Table: dbo.Quick_Books_Import_Option
This table contains import options used when importing data from QuickBooks.
Columns
Name | Type | Constraints | Description
quick_books_import_option_KEY | int (4) | NOT NULL | Primary key.
client_KEY | int (4) | NOT NULL | The client to whom the options pertain.
file_location | nvarchar (510) | NOT NULL | The path to the import source file.
import_method_KEY | int (4) | NOT NULL | The import method to be used.
exclude_1099_items | bit (1) | NOT NULL | Option to not import 1099 items from quickbooks.
exclude_classes | bit (1) | NOT NULL | Option to not import classes from quickbooks.
exclude_employees_and_payroll_checks | bit (1) | NOT NULL | Option to not import employees or payroll checks from quickbooks.
exclude_inactive_items | bit (1) | NOT NULL | Option to not import inactive items from quickbooks.
exclude_inactive_employees | bit (1) | NOT NULL | Option to not import inactive employees from quickbooks.
exclude_inactive_vendors | bit (1) | NOT NULL | Option to not import inactive vendors from quickbooks.
exclude_inactive_customers | bit (1) | NOT NULL | Option to not import inactive customers from quickbooks.
exclude_inactive_accounts | bit (1) | NOT NULL | Option to not import inactive accounts from quickbooks.
import_only_employees_and_payroll_checks | bit (1) | NOT NULL | Option to import only employees and payroll checks from quickbooks.
skip_data_mapping | bit (1) | NOT NULL | Option to skip the data mapping phase of the quickbooks import.

Primary key
Name | Columns | Description
PK_Quick_Books_Import_Option | quick_books_import_option_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Quick_Books_Import_Option__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Quick_Books_Import_Option__Import_Method__import_method_KEY | import_method_KEY | Import_Method (import_method_KEY) |