Table: dbo.OnBalance_Bank_Account
Table to store the mapping data information of bank accounts for OnBalance
Columns
NameTypeConstraintsDescription
onbalance_bank_account_KEYint (4)NOT NULLKey which uniquely identifies each row of the table.
client_KEYint (4)NOT NULLClient key for which we are importing the OnBalance data.
descriptionnvarchar (318)NOT NULLDescription for the bank account from OnBalance.
checkbook_KEYint (4)NOT NULLBank account key for which the bank account of OnBalance is mapped.
Primary key
NameColumnsDescription
PK_OnBalance_Bank_Accountonbalance_bank_account_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_OnBalance_Bank_Account__Client__client_KEYclient_KEYClient (client_KEY)
FK_OnBalance_Bank_Account__Checkbook__checkbook_KEYcheckbook_KEYCheckbook (checkbook_KEY)

Schema diagram