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) |