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

Updated On: 05.03.31