Table: dbo.OnBalance_Import_Option
This table contains the data entry import options to configure the OnBalance Import feature.
Columns
Name | Type | Constraints | Description
client_KEY | int (4) | NOT NULL | Primary/foreign key to which the OnBalance import should happen.
include_inactive_bank_accounts | bit (1) | NOT NULL | If true then import available inactive bank accounts from OnBalance into Accounting CS. These will map to Checkbook.
start_date_of_last_import | date (3) | NOT NULL | This date will be used to log beginning date of last import.
end_date_of_last_import | date (3) | NOT NULL | This date will be used to log ending date of last import.

Primary key
Name | Columns | Description
PK_OnBalance_Import_Option$client_KEY | client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_OnBalance_Import_Option__Client__client_KEY | client_KEY | Client (client_KEY) |