Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 IMMEDIATEDESTINATIONNUMBER nvarchar(9)   Default = ''
 IMMEDIATEDESTINATIONNAME nvarchar(23)   Default = ''
 IMMEDIATEORIGINNUMBEROPTIONCODE tinyint   Default = 0
 IMMEDIATEORIGINNUMBEROPTION nvarchar(27) (Computed) CASE [IMMEDIATEORIGINNUMBEROPTIONCODE] WHEN 0 THEN N'Bank account routing number' WHEN 1 THEN N'Organization EIN' WHEN 2 THEN N'Other number' END
 IMMEDIATEORIGINNUMBER nvarchar(9)   Default = ''
 IMMEDIATEORIGINNAMEOPTIONCODE tinyint   Default = 0
 IMMEDIATEORIGINNAMEOPTION nvarchar(17) (Computed) CASE [IMMEDIATEORIGINNAMEOPTIONCODE] WHEN 0 THEN N'Organization name' WHEN 1 THEN N'Other name' END
 IMMEDIATEORIGINNAME nvarchar(23)   Default = ''
 REFERENCECODE nvarchar(8)   Default = ''
 COMPANYNAMEOPTIONCODE tinyint   Default = 0
 COMPANYNAMEOPTION nvarchar(17) (Computed) CASE [COMPANYNAMEOPTIONCODE] WHEN 0 THEN N'Organization name' WHEN 1 THEN N'Other name' END
 COMPANYNAME nvarchar(16)   Default = ''
 COMPANYIDPREFIX tinyint   Default = 0
 COMPANYID nvarchar(9)   Default = ''
 CREATEOFFSETTINGTRANSACTIONS bit   Default = 0
 INCLUDECARRIAGERETURN bit   Default = 1
 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   BANKACCOUNT.ID
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID

Index Name Field(s) Unique Primary Clustered
 IX_BANKACCOUNTEFTINFO_DATEADDED DATEADDED    
 IX_BANKACCOUNTEFTINFO_DATECHANGED DATECHANGED      
 PK_BANKACCOUNTEFTINFO ID  

Trigger Name Description
 TR_BANKACCOUNTEFTINFO_AUDIT_UPDATE
 TR_BANKACCOUNTEFTINFO_AUDIT_DELETE

Entity-Relationship diagram of this table