LEDGERACCOUNT

Contains account information for general ledger accounts.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

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)	yes	CONVERT(bigint, TS)	Numeric representation of the timestamp.
ACCOUNTCODEID	uniqueidentifier (Computed)	yes	dbo.UFN_LEDGERACCOUNT_GETACCOUNTCODEID(ID)

Foreign Keys

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

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_LEDGERACCOUNT_ACCOUNTSTRING	ACCOUNTSTRING
IX_LEDGERACCOUNT_DATEADDED	DATEADDED			yes
IX_LEDGERACCOUNT_DATECHANGED	DATECHANGED
PK_LEDGERACCOUNT	ID	yes	yes
UIC_LEDGERACCOUNT_DESCRIPTION	DESCRIPTION	yes

Triggers

Trigger Name	Description
TR_LEDGERACCOUNT_INSUPD
TR_LEDGERACCOUNT_AUDIT_UPDATE
TR_LEDGERACCOUNT_AUDIT_DELETE