Table: dbo.Quick_Books_Export_Option
This table contains export options used when exporting data to QuickBooks.
Columns
NameTypeConstraintsDescription
client_KEYint (4)NOT NULLThe 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_accountsbit (1)NOT NULLOption to not export inactive bank accounts to quickbooks.
exclude_inactive_general_ledger_accountsbit (1)NOT NULLOption to not export inactive general ledger accounts to quickbooks.
exclude_inactive_employeesbit (1)NOT NULLOption to not export inactive employees to quickbooks.
exclude_inactive_vendorsbit (1)NOT NULLOption to not export inactive vendors to quickbooks.
last_export_start_datesmalldatetime (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_datesmalldatetime (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_codesbit (1)NOT NULLOption to not export inactive segment codes to quickbooks.
Primary key
NameColumnsDescription
PK_Quick_Books_Export_Option$client_KEYclient_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Quick_Books_Export_Option__Client__client_KEYclient_KEYClient (client_KEY)

Schema diagram