Table: dbo.Quick_Books_Import_Option
This table contains import options used when importing data from QuickBooks.
Columns
NameTypeConstraintsDescription
quick_books_import_option_KEYint (4)NOT NULLPrimary key.
client_KEYint (4)NOT NULLThe client to whom the options pertain.
file_locationnvarchar (510)NOT NULLThe path to the import source file.
import_method_KEYint (4)NOT NULLThe import method to be used.
exclude_1099_itemsbit (1)NOT NULLOption to not import 1099 items from quickbooks.
exclude_classesbit (1)NOT NULLOption to not import classes from quickbooks.
exclude_employees_and_payroll_checksbit (1)NOT NULLOption to not import employees or payroll checks from quickbooks.
exclude_inactive_itemsbit (1)NOT NULLOption to not import inactive items from quickbooks.
exclude_inactive_employeesbit (1)NOT NULLOption to not import inactive employees from quickbooks.
exclude_inactive_vendorsbit (1)NOT NULLOption to not import inactive vendors from quickbooks.
exclude_inactive_customersbit (1)NOT NULLOption to not import inactive customers from quickbooks.
exclude_inactive_accountsbit (1)NOT NULLOption to not import inactive accounts from quickbooks.
import_only_employees_and_payroll_checksbit (1)NOT NULLOption to import only employees and payroll checks from quickbooks.
skip_data_mappingbit (1)NOT NULLOption to skip the data mapping phase of the quickbooks import.
Primary key
NameColumnsDescription
PK_Quick_Books_Import_Optionquick_books_import_option_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Quick_Books_Import_Option__Client__client_KEYclient_KEYClient (client_KEY)
FK_Quick_Books_Import_Option__Import_Method__import_method_KEYimport_method_KEYImport_Method (import_method_KEY)

Schema diagram