Table: dbo.OnBalance_Bank_Account
Table to store the mapping data information of bank accounts for OnBalance
Columns
Name | Type | Constraints | Description
onbalance_bank_account_KEY | int (4) | NOT NULL | Key which uniquely identifies each row of the table.
client_KEY | int (4) | NOT NULL | Client key for which we are importing the OnBalance data.
description | nvarchar (318) | NOT NULL | Description for the bank account from OnBalance.
checkbook_KEY | int (4) | NOT NULL | Bank account key for which the bank account of OnBalance is mapped.

Primary key
Name | Columns | Description
PK_OnBalance_Bank_Account | onbalance_bank_account_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_OnBalance_Bank_Account__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_OnBalance_Bank_Account__Checkbook__checkbook_KEY | checkbook_KEY | Checkbook (checkbook_KEY) |