| 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) | |