BANKACCOUNTADJUSTMENT

This stores bank account adjustment-specific fields.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
TRANSFERADJUSTMENTID	uniqueidentifier	yes		For transfers, points to the second adjustment
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.
ISORIGINALADJUSTMENT	bit		Default = 0	For transfer in/out adjustment, mark the originating adjustment true.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
ID	uniqueidentifier		FINANCIALTRANSACTION.ID	Primary Key.
BANKACCOUNTADJUSTMENTCATEGORYID	uniqueidentifier	yes	BANKACCOUNTADJUSTMENTCATEGORY.ID	Adjustment category
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
EXCHANGERATEID	uniqueidentifier	yes	CURRENCYEXCHANGERATE.ID	The exchange rate used to convert from one bank account amount to another bank account amount.

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_BANKACCOUNTADJUSTMENT_DATEADDED	DATEADDED			yes
IX_BANKACCOUNTADJUSTMENT_DATECHANGED	DATECHANGED
PK_BANKACCOUNTADJUSTMENT	ID	yes	yes

Triggers

Trigger Name	Description
TR_BANKACCOUNTADJUSTMENT_DELETE_POSTED
TR_BANKACCOUNTADJUSTMENT_AUDIT_UPDATE
TR_BANKACCOUNTADJUSTMENT_AUDIT_DELETE

Referenced by

Referenced by	Field
BANKACCOUNTADJUSTMENTATTACHMENT	ADJUSTMENTID
BANKACCOUNTADJUSTMENTMEDIALINK	ADJUSTMENTID
BANKACCOUNTADJUSTMENTNOTE	ADJUSTMENTID