Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 DESCRIPTION nvarchar(400)   Default = '' Account description
 ACTIVE bit   Default = 1
 ACCOUNTSTRING nvarchar(130)   Default = '' An indexed version of the account string used for searching. Fixed separator of hyphen (-).
 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.
 ACCOUNTCODEID uniqueidentifier (Computed) dbo.UFN_LEDGERACCOUNT_GETACCOUNTCODEID(ID)

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

Index Name Field(s) Unique Primary Clustered
 IX_LEDGERACCOUNT_ACCOUNTSTRING ACCOUNTSTRING      
 IX_LEDGERACCOUNT_DATEADDED DATEADDED    
 IX_LEDGERACCOUNT_DATECHANGED DATECHANGED      
 PK_LEDGERACCOUNT ID  
 UIC_LEDGERACCOUNT_DESCRIPTION DESCRIPTION    

Trigger Name Description
 TR_LEDGERACCOUNT_INSUPD
 TR_LEDGERACCOUNT_AUDIT_UPDATE
 TR_LEDGERACCOUNT_AUDIT_DELETE

Entity-Relationship diagram of this table