This table contains export options used when exporting data to QuickBooks. |
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. |