Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 TRANSACTIONNUMBER int   Default = 1
 TRANSACTIONTYPECODE tinyint   Default = 1
 TRANSACTIONTYPE nvarchar(23) (Computed) CASE [TRANSACTIONTYPECODE] WHEN 1 THEN N'Computer Check' WHEN 8 THEN N'Deposit' WHEN 16 THEN N'Adjustment deposit' WHEN 17 THEN N'Adjustment payment' WHEN 32 THEN N'Adjustment transfer out' WHEN 33 THEN N'Adjustment transfer in' END
 TRANSACTIONFLAGCODE tinyint   Default = 1
 TRANSACTIONFLAG nvarchar(18) (Computed) CASE [TRANSACTIONFLAGCODE] WHEN 1 THEN N'Deposit' WHEN 2 THEN N'Check/Payment' WHEN 3 THEN N'Adjustment' WHEN 4 THEN N'Special Adjustment' END
 ORIGINATINGID uniqueidentifier
 STATUSCODE tinyint   Default = 1
 STATUS nvarchar(11) (Computed) CASE [STATUSCODE] WHEN 1 THEN N'Outstanding' WHEN 2 THEN N'Cleared' WHEN 3 THEN N'Reconciled' WHEN 4 THEN N'Voided' END
 CLEAREDDATE datetime
 VOIDDATE datetime
 PROCESSING bit   Default = 0
 ADDRESSBLOCK nvarchar(150)   Default = ''
 CITY nvarchar(50)   Default = ''
 POSTCODE nvarchar(12)   Default = ''
 VOIDDATETYPECODE tinyint   Default = 0
 VOIDDATETYPE nvarchar(17) (Computed) CASE [VOIDDATETYPECODE] WHEN 0 THEN N'Today' WHEN 1 THEN N'Payment post date' WHEN 2 THEN N'Specific date' END
 REVERSALPOSTDATE datetime
 REVERSALPOSTDATETYPECODE tinyint   Default = 1
 REVERSALPOSTDATETYPE nvarchar(17) (Computed) CASE [REVERSALPOSTDATETYPECODE] WHEN 0 THEN N'Today' WHEN 1 THEN N'Payment post date' WHEN 2 THEN N'Specific date' END
 REVERSALPOSTSTATUSCODE tinyint   Default = 1
 REVERSALPOSTSTATUS nvarchar(10) (Computed) CASE [REVERSALPOSTSTATUSCODE] WHEN 1 THEN N'Not posted' WHEN 2 THEN N'Posted' END
 DATEADDED datetime   Default = getdate()
 DATECHANGED datetime   Default = getdate()
 TS timestamp  
 TSLONG bigint (Computed) CONVERT(bigint, TS)

Foreign Key Field Type Null Notes Description
 ID uniqueidentifier   FINANCIALTRANSACTION.ID
 BANKACCOUNTID uniqueidentifier   BANKACCOUNT.ID
 TRANSFERBANKACCOUNTID uniqueidentifier BANKACCOUNT.ID
 DISBURSEMENTPROCESSID uniqueidentifier DISBURSEMENTPROCESS.ID
 COUNTRYID uniqueidentifier COUNTRY.LOCALID
 STATEID uniqueidentifier STATE.LOCALID
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID

Index Name Field(s) Unique Primary Clustered
 IX_BANKACCOUNTTRANSACTION_EXT_DATEADDED DATEADDED    
 IX_BANKACCOUNTTRANSACTION_EXT_DATECHANGED DATECHANGED      
 IX_BANKACCOUNTTRANSACTION_EXT_DISBURSEMENTPROCESSID DISBURSEMENTPROCESSID      
 PK_BANKACCOUNTTRANSACTION_EXT ID  

Trigger Name Description
 TR_BANKACCOUNTTRANSACTION_EXT_VALIDATION_I
 TR_BANKACCOUNTTRANSACTION_EXT_VALIDATION_IU
 TR_BANKACCOUNTTRANSACTION_EXT_AUDIT_UPDATE
 TR_BANKACCOUNTTRANSACTION_EXT_AUDIT_DELETE

Entity-Relationship diagram of this table