This table contains the data entry import options to configure the Quickbooks Online Import feature. |
client_KEY | int (4) | NOT NULL | Primary/foreign key. There is a 1-0..1 relationship between Client and this table. |
import_transactions | bit (1) | NOT NULL | If true then import available transactions from Quickbooks Online. These will map to Bank_Transaction. |
import_gl_accounts | bit (1) | NOT NULL | If true then import available gl accounts from Quickbooks Online. These will map to GL_Account. |
import_inactive_gl_accounts | bit (1) | NOT NULL | If true then import available inactive gl accounts from Quickbooks Online. These will map to GL_Account. |
import_vendors | bit (1) | NOT NULL | If true then import available vendors from Quickbooks Online. These will map to Vendor. |
import_inactive_vendors | bit (1) | NOT NULL | If true then import available inactive vendors from Quickbooks Online. These will map to Vendor. |
import_bank_accounts | bit (1) | NOT NULL | If true then import available bank accounts from Quickbooks Online. These will map to Checkbook. |
import_inactive_bank_accounts | bit (1) | NOT NULL | If true then import available inactive bank accounts from Quickbooks Online. These will map to Checkbook. |
start_date_of_last_import | smalldatetime (4) | NOT NULL | This date will be used for automated/cron imports from Quickbooks Online. Log beginning of when the last import happened. |
end_date_of_last_import | smalldatetime (4) | NOT NULL | This date will be used for automated/cron imports from Quickbooks Online. Log ending of when the last import happened. |
import_classes | bit (1) | NOT NULL | If true then import available classes from Quickbooks Online. Classes from quickbooks can be mapped to accounting cs segment codes. |
import_inactive_classes | bit (1) | NOT NULL | If true then import available inactive classes from Quickbooks Online. Classes from quickbooks can be mapped to accounting cs segment codes. |
import_balances | bit (1) | NOT NULL | Specifies if we will import balances from QuickBooks Online. |