Table: dbo.OnBalance_Import_Option
This table contains the data entry import options to configure the OnBalance Import feature.
Columns
NameTypeConstraintsDescription
client_KEYint (4)NOT NULLPrimary/foreign key to which the OnBalance import should happen.
include_inactive_bank_accountsbit (1)NOT NULLIf true then import available inactive bank accounts from OnBalance into Accounting CS. These will map to Checkbook.
start_date_of_last_importdate (3)NOT NULLThis date will be used to log beginning date of last import.
end_date_of_last_importdate (3)NOT NULLThis date will be used to log ending date of last import.
Primary key
NameColumnsDescription
PK_OnBalance_Import_Option$client_KEYclient_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_OnBalance_Import_Option__Client__client_KEYclient_KEYClient (client_KEY)

Schema diagram