Table: dbo.Quick_Books_Online_Import_Option
This table contains the data entry import options to configure the Quickbooks Online Import feature.
Columns
Name | Type | Constraints | Description
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.

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

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