Table [dbo].[L_GLAccountOrg]

CREATE TABLE [dbo].[L_GLAccountOrg] (
[ACCTCODE] [varchar] (15) NOT NULL ,
[LocationCode] [varchar] (3) NOT NULL ,
[OrgCode] [varchar] (15) NULL ,
[OrgName] [varchar] (50) NULL ,
[ADDRESS1] [varchar] (40) NULL ,
[ADDRESS2] [varchar] (40) NULL ,
[CITY] [varchar] (20) NULL ,
[STATE] [varchar] (20) NULL ,
[POSTCODE] [varchar] (8) NULL ,
[CNTYCODE] [varchar] (2) NULL ,
[TEL] [varchar] (15) NULL ,
[FAX] [varchar] (15) NULL ,
[TLX] [varchar] (15) NULL ,
[EMAIL] [varchar] (50) NULL ,
[WEBSITE] [varchar] (50) NULL ,
[CONTACT] [varchar] (40) NULL ,
[CRLIMIT] [float] NULL ,
[TERMDAY] [float] NULL ,
[OrgMemo] [text] NULL ,
[PrintStatement] [bit] NULL ,
[TaxCode] [varchar] (10) NULL ,
[PaymentModeID] [smallint] NULL ,
[PaymentTermID] [smallint] NULL ,
[rowguid] uniqueidentifier ROWGUIDCOL NOT NULL ,
[SMCode] [varchar] (10) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Updated On: 05.03.31