| This table contains the data entry import options to configure the Quickbooks Online Import feature. |
| client_KEY | int (4) | NOT NULL | Primary/foreign key. There is a 1-0..1 relationship between Client and this table. |
| import_transactions | bit (1) | NOT NULL | If true then import available transactions from Quickbooks Online. These will map to Bank_Transaction. |
| import_gl_accounts | bit (1) | NOT NULL | If true then import available gl accounts from Quickbooks Online. These will map to GL_Account. |
| import_inactive_gl_accounts | bit (1) | NOT NULL | If true then import available inactive gl accounts from Quickbooks Online. These will map to GL_Account. |
| import_vendors | bit (1) | NOT NULL | If true then import available vendors from Quickbooks Online. These will map to Vendor. |
| import_inactive_vendors | bit (1) | NOT NULL | If true then import available inactive vendors from Quickbooks Online. These will map to Vendor. |
| import_bank_accounts | bit (1) | NOT NULL | If true then import available bank accounts from Quickbooks Online. These will map to Checkbook. |
| import_inactive_bank_accounts | bit (1) | NOT NULL | If true then import available inactive bank accounts from Quickbooks Online. These will map to Checkbook. |
| start_date_of_last_import | smalldatetime (4) | NOT NULL | This date will be used for automated/cron imports from Quickbooks Online. Log beginning of when the last import happened. |
| end_date_of_last_import | smalldatetime (4) | NOT NULL | This date will be used for automated/cron imports from Quickbooks Online. Log ending of when the last import happened. |
| import_classes | bit (1) | NOT NULL | If true then import available classes from Quickbooks Online. Classes from quickbooks can be mapped to accounting cs segment codes. |
| import_inactive_classes | bit (1) | NOT NULL | If true then import available inactive classes from Quickbooks Online. Classes from quickbooks can be mapped to accounting cs segment codes. |
| import_balances | bit (1) | NOT NULL | Specifies if we will import balances from QuickBooks Online. |