|
Table [dbo].[D_GLJournalItem]
CREATE TABLE [dbo].[D_GLJournalItem] ( [DocItemUID] [int] NOT NULL , [DocSite] [smallint] NULL , [DocUID] [int] NULL , [AcctCode] [varchar] (15) NULL , [DeptCode] [varchar] (10) NULL , [JobCode] [varchar] (10) NULL , [CurrencyCode] [varchar] (3) NULL , [AllocPeriod] [varchar] (7) NULL , [DocNo] [varchar] (15) NULL , [DocDate] [datetime] NULL , [Debit] [money] NULL , [Credit] [money] NULL , [Description] [varchar] (60) NULL , [Reason] [varchar] (40) NULL , [CurrencyRate] [float] NULL , [CurrencyDebit] [money] NULL , [CurrencyCredit] [money] NULL , [AllocTemp1] [bit] NULL , [AllocTemp2] [bit] NULL , [AllocFlag] [bit] NULL , [AllocOn] [datetime] NULL , [AllocBy] [varchar] (10) NULL , [AutoItemUID] [int] IDENTITY (1, 1) NOT NULL , [rowguid] uniqueidentifier ROWGUIDCOL NOT NULL ) ON [PRIMARY] GO
|