FENXTACCOUNT

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
ACCOUNTID	int		Default = 0
ACCOUNTNUMBER	nvarchar(100)		Default = ''
DESCRIPTION	nvarchar(200)		Default = ''
ACCOUNTCLASS	nvarchar(50)		Default = ''
DATEMODIFIED	datetime	yes
CATEGORY	nvarchar(50)		Default = ''
PREVENTDATAENTRY	bit		Default = 0
PREVENTPOSTINGDATE	datetime	yes
PROJECTREQUIRED	tinyint		Default = 0
DATEADDED	datetime		Default = getdate()
DATECHANGED	datetime		Default = getdate()
TS	timestamp
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
PDACCOUNTSYSTEMID	uniqueidentifier		PDACCOUNTSYSTEM.ID
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_FENXTACCOUNT_DATEADDED	DATEADDED
IX_FENXTACCOUNT_DATECHANGED	DATECHANGED
PK_FENXTACCOUNT	ID	yes	yes
UIX_FENXTACCOUNT_PDACCOUNTSYSTEMID_ACCOUNTID	PDACCOUNTSYSTEMID, ACCOUNTID	yes		yes

Triggers

Trigger Name	Description
TR_FENXTACCOUNT_AUDIT_UPDATE
TR_FENXTACCOUNT_AUDIT_DELETE