FENXTINTEGRATION

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
ENVIRONMENTID	nvarchar(50)		Default = ''
FEDESIGNATIONSOURCE	bit		Default = 0
LASTUPDATETIME	datetime	yes
SYNCFISCALYEAR	bit		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_FENXTINTEGRATION_DATEADDED	DATEADDED
IX_FENXTINTEGRATION_DATECHANGED	DATECHANGED
PK_FENXTINTEGRATION	ID	yes	yes
UC_FENXTINTEGRATION_PDACCOUNTSYSTEMID	PDACCOUNTSYSTEMID	yes
UIX_FENXTINTEGRATION_PDACCOUNTSYSTEMID	PDACCOUNTSYSTEMID	yes		yes

Triggers

Trigger Name	Description
TR_FENXTINTEGRATION_IU
TR_FENXTINTEGRATION_AUDIT_UPDATE
TR_FENXTINTEGRATION_AUDIT_DELETE

Referenced by

Referenced by	Field
FENXTSYNCPROCESS	FENXTINTEGRATIONID