Table: dbo.Quick_Books_Online_Import_Option
This table contains the data entry import options to configure the Quickbooks Online Import feature.
Columns
NameTypeConstraintsDescription
client_KEYint (4)NOT NULLPrimary/foreign key. There is a 1-0..1 relationship between Client and this table.
import_transactionsbit (1)NOT NULLIf true then import available transactions from Quickbooks Online. These will map to Bank_Transaction.
import_gl_accountsbit (1)NOT NULLIf true then import available gl accounts from Quickbooks Online. These will map to GL_Account.
import_inactive_gl_accountsbit (1)NOT NULLIf true then import available inactive gl accounts from Quickbooks Online. These will map to GL_Account.
import_vendorsbit (1)NOT NULLIf true then import available vendors from Quickbooks Online. These will map to Vendor.
import_inactive_vendorsbit (1)NOT NULLIf true then import available inactive vendors from Quickbooks Online. These will map to Vendor.
import_bank_accountsbit (1)NOT NULLIf true then import available bank accounts from Quickbooks Online. These will map to Checkbook.
import_inactive_bank_accountsbit (1)NOT NULLIf true then import available inactive bank accounts from Quickbooks Online. These will map to Checkbook.
start_date_of_last_importsmalldatetime (4)NOT NULLThis date will be used for automated/cron imports from Quickbooks Online. Log beginning of when the last import happened.
end_date_of_last_importsmalldatetime (4)NOT NULLThis date will be used for automated/cron imports from Quickbooks Online. Log ending of when the last import happened.
import_classesbit (1)NOT NULLIf true then import available classes from Quickbooks Online. Classes from quickbooks can be mapped to accounting cs segment codes.
import_inactive_classesbit (1)NOT NULLIf true then import available inactive classes from Quickbooks Online. Classes from quickbooks can be mapped to accounting cs segment codes.
import_balancesbit (1)NOT NULLSpecifies if we will import balances from QuickBooks Online.
Primary key
NameColumnsDescription
PK_Quick_Books_Online_Import_Option$client_KEYclient_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Quick_Books_Online_Import_Option__Client__client_KEYclient_KEYClient (client_KEY)

Schema diagram