Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 ACCOUNTNUMBER nvarchar(100)   Default = '' Account Number
 ACCOUNTDESCRIPTION nvarchar(400)   Default = '' Account Description
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 ACTIVE bit   Default = 1
 ACCOUNTSTRING nvarchar(100)   Default = '' An indexed version of the account string used for searching.
 ACCOUNTCODEID uniqueidentifier (Computed) dbo.UFN_LEDGERACCOUNT_GETACCOUNTCODEID(ID)
 ACCOUNTALIAS nvarchar(100)   Default = '' Account Alias
 SEG1VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(1),[PDACCOUNTSYSTEMID])) 1st Segment Value
 SEG2VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(2),[PDACCOUNTSYSTEMID])) 2nd Segment Value
 SEG3VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(3),[PDACCOUNTSYSTEMID])) 3rd Segment Value
 SEG4VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(4),[PDACCOUNTSYSTEMID])) 4th Segment Value
 SEG5VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(5),[PDACCOUNTSYSTEMID])) 5th Segment Value
 SEG6VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(6),[PDACCOUNTSYSTEMID])) 6th Segment Value
 SEG7VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(7),[PDACCOUNTSYSTEMID])) 7th Segment Value
 SEG8VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(8),[PDACCOUNTSYSTEMID])) 8th Segment Value
 SEG9VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(9),[PDACCOUNTSYSTEMID])) 9th Segment Value
 SEG10VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(10),[PDACCOUNTSYSTEMID])) 10th Segment Value
 SEG11VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(11),[PDACCOUNTSYSTEMID])) 11th Segment Value
 SEG12VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(12),[PDACCOUNTSYSTEMID])) 12th Segment Value
 SEG13VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(13),[PDACCOUNTSYSTEMID])) 13th Segment Value
 SEG14VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(14),[PDACCOUNTSYSTEMID])) 14th Segment Value
 SEG15VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(15),[PDACCOUNTSYSTEMID])) 15th Segment Value
 SEG16VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(16),[PDACCOUNTSYSTEMID])) 16th Segment Value
 SEG17VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(17),[PDACCOUNTSYSTEMID])) 17th Segment Value
 SEG18VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(18),[PDACCOUNTSYSTEMID])) 18th Segment Value
 SEG19VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(19),[PDACCOUNTSYSTEMID])) 19th Segment Value
 SEG20VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(20),[PDACCOUNTSYSTEMID])) 20th Segment Value
 SEG21VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(21),[PDACCOUNTSYSTEMID])) 21th Segment Value
 SEG22VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(22),[PDACCOUNTSYSTEMID])) 22th Segment Value
 SEG23VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(23),[PDACCOUNTSYSTEMID])) 23th Segment Value
 SEG24VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(24),[PDACCOUNTSYSTEMID])) 24th Segment Value
 SEG25VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(25),[PDACCOUNTSYSTEMID])) 25th Segment Value
 SEG26VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(26),[PDACCOUNTSYSTEMID])) 26th Segment Value
 SEG27VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(27),[PDACCOUNTSYSTEMID])) 27th Segment Value
 SEG28VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(28),[PDACCOUNTSYSTEMID])) 28th Segment Value
 SEG29VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(29),[PDACCOUNTSYSTEMID])) 29th Segment Value
 SEG30VALUE varchar(100) (Computed) ([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(30),[PDACCOUNTSYSTEMID])) 30th Segment Value
 HASHVALUE int   Default = 0
 MD5HASHVALUE uniqueidentifier

Foreign Key Field Type Null Notes Description
 PDCATEGORYDEFINITIONID uniqueidentifier PDCATEGORYDEFINITION.ID FK to category definition
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 PDACCOUNTSYSTEMID uniqueidentifier   PDACCOUNTSYSTEM.ID Accounting system id
 LEDGERACCOUNTWORKFLOWSTAGECODEID uniqueidentifier LEDGERACCOUNTWORKFLOWSTAGECODE.ID FK to LEDGERACCOUNTWORKFLOWSTAGECODE
 DATAELEMENT1ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 1st column
 DATAELEMENT2ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 2nd column
 DATAELEMENT3ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 3rd column
 DATAELEMENT4ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 4th column
 DATAELEMENT5ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 5th column
 DATAELEMENT6ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 6th column
 DATAELEMENT7ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 7th column
 DATAELEMENT8ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 8th column
 DATAELEMENT9ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 9th column
 DATAELEMENT10ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 10th column
 DATAELEMENT11ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 11th column
 DATAELEMENT12ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 12th column
 DATAELEMENT13ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 13th column
 DATAELEMENT14ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 14th column
 DATAELEMENT15ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 15th column
 DATAELEMENT16ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 16th column
 DATAELEMENT17ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 17th column
 DATAELEMENT18ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 18th column
 DATAELEMENT19ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 19th column
 DATAELEMENT20ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 20th column
 DATAELEMENT21ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 21st column
 DATAELEMENT22ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 22nd column
 DATAELEMENT23ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 23rd column
 DATAELEMENT24ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 24th column
 DATAELEMENT25ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 25th column
 DATAELEMENT26ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 26th column
 DATAELEMENT27ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 27th column
 DATAELEMENT28ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 28th column
 DATAELEMENT29ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 29th column
 DATAELEMENT30ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID DataelementID for the 20th column

Index Name Field(s) Unique Primary Clustered
 IX_GLACCOUNT_ACCOUNTNUMBER ACCOUNTNUMBER      
 IX_GLACCOUNT_ACCOUNTSTRING ACCOUNTSTRING      
 IX_GLACCOUNT_DATAELEMENT1ID_DYN DATAELEMENT1ID      
 IX_GLACCOUNT_DATAELEMENTS_DYN DATAELEMENT1ID      
 IX_GLACCOUNT_DATEADDED DATEADDED    
 IX_GLACCOUNT_DATECHANGED DATECHANGED      
 IX_GLACCOUNT_ID ID      
 IX_GLACCOUNT_MD5HASHVALUE MD5HASHVALUE      
 PK_GLACCOUNT ID  

Trigger Name Description
 TR_GLACCOUNT_DEL
 TR_GLACCOUNT_INS
 TR_GLACCOUNT_UPD
 TR_GLACCOUNT_PDACCOUNTSYSTEMID_ACCOUNTNUMBER_ISUNIQUE
 TR_GLACCOUNT_AUDIT_UPDATE
 TR_GLACCOUNT_AUDIT_DELETE

Referenced by Field
 ACCOUNTINGELEMENTRELATIONSHIPDETAIL ACCOUNTID
 ACCOUNTINGELEMENTRELATIONSHIPELEMENTPARAMETER ACCOUNTID
 BANKACCOUNT GLACCOUNTID
 CLOSINGREQUIREMENT LEDGERACCOUNTID
 GLACCOUNTALIAS ID
 JOURNALENTRY GLACCOUNTID
 LEDGERACCOUNTATTACHMENT LEDGERACCOUNTID
 LEDGERACCOUNTMEDIALINK LEDGERACCOUNTID
 LEDGERACCOUNTNOTE LEDGERACCOUNTID
 PDACCOUNTCODEMAPPING DEBITGLACCOUNTID
 PDACCOUNTCODEMAPPING CREDITGLACCOUNTID
 PDACCOUNTSEGMENT GLACCOUNTID
 PDACCOUNTSYSTEM DEFAULTGLACCOUNTID

Entity-Relationship diagram of this table