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