BANKACCOUNTTRANSACTIONAUDITORIGINAL

This table contains the audit trail for rows in the dbo.BANKACCOUNTTRANSACTION table.

Primary Key

Primary Key	Field Type
AUDITID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
AUDITRECORDID	uniqueidentifier			The AuditRecordID column is a foreign key to the dbo.BANKACCOUNTTRANSACTION.ID field.
AUDITKEY	uniqueidentifier			When an update occurs to the dbo.BANKACCOUNTTRANSACTION table, both the ''before'' and ''after'' changes are written to the dbo.BANKACCOUNTTRANSACTIONAUDIT table. The AuditKey is used to associate both rows together, so that they can be aggregated when reporting the audit trail for a given record. Note that for deletes to the dbo.BANKACCOUNTTRANSACTION table, only the ''deleted'' data is written to the dbo.BANKACCOUNTTRANSACTIONAUDIT table.
AUDITCHANGEAGENTID	uniqueidentifier			FK to CHANGEAGENT, indicating the agent that invoked the change being audited.
AUDITDATE	datetime		Default = getdate()	The AuditDate field indicates the date that a change (update or delete) occurred to the dbo.BANKACCOUNTTRANSACTION table.
AUDITTYPECODE	tinyint		Default = 0	The AuditType field describes context of each row in the dbo.BANKACCOUNTTRANSACTIONAUDIT table. A value of 0 implies the data before an update, 1 implies the data after an update, and 2 implies the data before a delete.
AUDITTYPE	nvarchar(13) (Computed)	yes		Computed column - translation for AUDITTYPECODE.
AMOUNT	money	yes
TRANSACTIONDATE	datetime	yes
TRANSACTIONNUMBER	int	yes
TRANSACTIONTYPECODE	tinyint	yes
REFERENCE	nvarchar(100)	yes
TRANSACTIONFLAGCODE	tinyint	yes
POSTSTATUSCODE	tinyint	yes
POSTDATE	datetime	yes
DELETED	bit	yes
DELETEDDATE	datetime	yes
ADDEDBYID	uniqueidentifier	yes
CHANGEDBYID	uniqueidentifier	yes
DATEADDED	datetime	yes
DATECHANGED	datetime	yes
BANKACCOUNTID	uniqueidentifier	yes
TRANSFERBANKACCOUNTID	uniqueidentifier	yes
ORIGINATINGID	uniqueidentifier	yes
PROCESSING	bit	yes
STATUSCODE	tinyint	yes
CLEAREDDATE	datetime	yes
VOIDDATETYPECODE	tinyint	yes
VOIDDATE	datetime	yes
REVERSALPOSTDATE	datetime	yes
REVERSALPOSTDATETYPECODE	tinyint	yes
REVERSALPOSTSTATUSCODE	tinyint	yes
BASECURRENCYID	uniqueidentifier	yes
ORGANIZATIONAMOUNT	money	yes
ORGANIZATIONEXCHANGERATEID	uniqueidentifier	yes
TRANSACTIONAMOUNT	money	yes
BASEEXCHANGERATEID	uniqueidentifier	yes

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_BANKACCOUNTTRANSACTIONAUDIT_AUDITDATE	AUDITDATE			yes
IX_BANKACCOUNTTRANSACTIONAUDIT_AUDITRECORDID	AUDITRECORDID
PK_BANKACCOUNTTRANSACTIONAUDIT	AUDITID	yes	yes