Table: dbo.Quick_Books_Export_Option
This table contains export options used when exporting data to QuickBooks.
Columns
Name | Type | Constraints | Description
client_KEY | int (4) | NOT NULL | The client to whom the options pertain. This is also the primary key for this table and a foreign key to the client table.
exclude_inactive_bank_accounts | bit (1) | NOT NULL | Option to not export inactive bank accounts to quickbooks.
exclude_inactive_general_ledger_accounts | bit (1) | NOT NULL | Option to not export inactive general ledger accounts to quickbooks.
exclude_inactive_employees | bit (1) | NOT NULL | Option to not export inactive employees to quickbooks.
exclude_inactive_vendors | bit (1) | NOT NULL | Option to not export inactive vendors to quickbooks.
last_export_start_date | smalldatetime (4) |  | This is the start date of the date range of the transactions that were included in the last export to quickbooks, if any export to quickbooks has been done previously. This field will be null until an export has been done. This field is used to display a note to the user as a reminder of what they did the last time they exported to quickbooks. We show them a field with the date range of the last export.
last_export_end_date | smalldatetime (4) |  | This is the end date of the date range of the transactions that were included in the last export to quickbooks, if any export to quickbooks has been done previously. This field will be null until an export has been done. This field is used to display a note to the user as a reminder of what they did the last time they exported to quickbooks. We show them a field with the date range of the last export.
exclude_inactive_segment_codes | bit (1) | NOT NULL | Option to not export inactive segment codes to quickbooks.

Primary key
Name | Columns | Description
PK_Quick_Books_Export_Option$client_KEY | client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Quick_Books_Export_Option__Client__client_KEY | client_KEY | Client (client_KEY) |