This table stores a quick book account |
quick_books_account_KEY | int (4) | NOT NULL | Primary key. |
client_KEY | int (4) | NOT NULL | The client key for this quick books account. |
account_number | nvarchar (40) | NOT NULL | The Quick Books account number. |
full_name | nvarchar (318) | NOT NULL | The Quick Books full_name. |
account_sort | int (4) | NOT NULL | The sort value for the account number |
list_id | nvarchar (120) | NOT NULL | The Quick Books List ID for the account |
account_type | nvarchar (300) | NOT NULL | a description of the Quick Books account type |
original_account_number | nvarchar (40) | NOT NULL | The original Quick Books account number. |
original_full_name | nvarchar (318) | NOT NULL | The original Quick Books full_name. |
quick_books_class_KEY | int (4) | | The Quick Books class for this account. |
do_not_import | bit (1) | NOT NULL | when set true, this tells us that the user does not want to import a particular general ledger account from QuickBooks into Accounting CS. The account will not be added and will not be mapped to an existing Accounting CS general ledger account. This setting needs to be saved so that the data mapping user interface can display a user choice from a previous import. |
current_balance | decimal (9, 2) | | QuickBooks current balance for the account. |