BANKACCOUNT (4.0)

no changes

dbo-4.0

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers
Referenced by

This table contains information about a bank account.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
BANKID	uniqueidentifier	false	BANK.ID	Bank
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
GLACCOUNTID	uniqueidentifier	true	GLACCOUNT.ID	The default cash account to use for the bank account
PDACCOUNTSEGMENTVALUEID	uniqueidentifier	true	PDACCOUNTSEGMENTVALUE.ID	The account code to be used for the account masking
PDACCOUNTSYSTEMID	uniqueidentifier	true	PDACCOUNTSYSTEM.ID	The account system in use for this bank account
TRANSACTIONCURRENCYID	uniqueidentifier	true	CURRENCY.ID	The transaction currency associated with this bank account.
BANKINGSYSTEMID	uniqueidentifier	true	BANKINGSYSTEM.ID

Fields
Field	Field Type	Null	Notes	Description
ACCOUNTNUMBER	nvarchar(4000)	false	''	User-defined bank account number
ROUTINGNUMBER	nvarchar(4000)	false	''	User-defined bank account number
ACCOUNTTYPECODE	tinyint	false	1	Bank account type
STATUSCODE	tinyint	false	1	Bank account status
MINIMUMBALANCE	decimal(19, 4)	false	0	Minimum balance required to avoid service charge
DEFAULTPRINTER	nvarchar(255)	false	''	Default printer for the bank
RECONCILED	bit	false	0	Indicates whether or not the bank is reconciled
DATELASTRECONCILED	datetime	true		Date that the bank was last reconciled
RECONCILEDBALANCE	decimal(19, 4)	false	0	Bank account balance as of the last time it was reconciled
PRINTCONTACTPOSITION	bit	false	0	Indicates whether or not to print the contact
LASTDEPOSITNUM	int	false	0
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.
ACCOUNTNAME	nvarchar(100)	false	''	Account name
ACCOUNTTYPE	nvarchar(8) (Computed)	true		Provides a translation for the 'ACCOUNTTYPECODE' field.
STATUS	nvarchar(6) (Computed)	true		Provides a translation for the 'STATUSCODE' field.
DEFAULTCASHACCOUNTTYPECODE	tinyint	false	0	Either use an account number or an account code (masking) for the default cash account
DEFAULTCASHACCOUNTTYPE	nvarchar(21) (Computed)	true		Provides a translation for the 'DEFAULTCASHACCOUNTTYPECODE' field.
CLIENTNAME	nvarchar(100)	false	''	An alternate name for the bank account
USERNUMBER	nvarchar(24)	false	''	The processing identifier for EFT processes
SORTCODE	nvarchar(8)	false	''	User-defined sort code for the UK
BIC	nvarchar(11)	false	''
BANKCODE	nvarchar(25)	false	''

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_BANKACCOUNT_DATEADDED	DATEADDED	False	False	True
IX_BANKACCOUNT_DATECHANGED	DATECHANGED	False	False	False
PK_BANKACCOUNT	ID	True	True	False
UC_BANKACCOUNT_ACCOUNTNAME	ACCOUNTNAME	True	False	False
UIX_BANKACCOUNT_BANKID_ACCOUNTNUMBER	BANKID ACCOUNTNUMBER	True	False	False

Triggers
Trigger Name	Description
TR_BANKACCOUNT_VALIDCURRENCY
TR_BANKACCOUNT_PDACCOUNTSYSTEMID_DEFAULT
TR_BANKACCOUNT_AUDIT_UPDATE
TR_BANKACCOUNT_AUDIT_DELETE
TR_BANKACCOUNT_GLACCOUNTIDPDACCOUNTSEGMENTID_VALIDREQUIRED
TR_BANKACCOUNT_PDACCOUNTSEGMENTVALUEID_ISACCOUNTCODE
TR_BANKACCOUNT_ACCOUNTCODE_ISUNIQUE

Referenced by
Referenced by	Field
BANKACCOUNTADJUSTMENTCATEGORY	TRANSFERBANKACCOUNTID
BANKACCOUNTADJUSTMENTCATEGORY	BANKACCOUNTID
BANKACCOUNTAUTHORIZEDSIGNATURE	BANKACCOUNTID
BANKACCOUNTEFTINFO	ID
BANKACCOUNTSEPAINFO	ID
BANKACCOUNTSITE	BANKACCOUNTID
BANKACCOUNTTRANSACTION_EXT	BANKACCOUNTID
BANKACCOUNTTRANSACTION_EXT	TRANSFERBANKACCOUNTID
CONTROLACCOUNTTREASURY	BANKACCOUNTID
CREDITMEMO	BANKACCOUNTID
DISBURSEMENTPROCESS	BANKACCOUNTID
DISBURSEMENTPROCESSTEMPLATE	BANKACCOUNTID
GENERATEBACSFILEPROCESS	BANKACCOUNTID
GENERATEEFTFILEPROCESS	BANKACCOUNTID
INVOICE	BANKACCOUNTID
PAPERLESSMANDATESINSTRUCTIONPROCESS	BANKACCOUNTID
POSTTOGLPROCESSBANKACCOUNTFILTER	BANKACCOUNTID
PRENOTIFICATIONPROCESS	BANKACCOUNTID
SALESDEPOSITTEMPLATE	BANKACCOUNTID
VENDOR	PAYMENTBANKACCOUNTID