Table: dbo.Quick_Books_Account
This table stores a quick book account
Columns
Name | Type | Constraints | Description
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.

Primary key
Name | Columns | Description
PK_Quick_Books_Account | quick_books_account_KEY |
Unique constraints
Name | Columns | Description
UK_Quick_Books_Account$full_name$list_id$client_KEY$quick_books_class_KEY | full_name, list_id, client_KEY, quick_books_class_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Quick_Books_Account__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Quick_Books_Account__Quick_Books_Class__quick_books_class_KEY | quick_books_class_KEY | Quick_Books_Class (quick_books_class_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_GL_Account__Quick_Books_Account__export__quick_books_account_KEY | export__quick_books_account_KEY | GL_Account |
FK_Checkbook__Quick_Books_Account__export__quick_books_account_KEY | export__quick_books_account_KEY | Checkbook |
FK_Quick_Books_Account_GL_Account__Quick_Books_Account__quick_books_account_KEY | quick_books_account_KEY | Quick_Books_Account_GL_Account |
FK_Quick_Books_Account_N_Checkbook__Quick_Books_Account__quick_books_account_KEY | quick_books_account_KEY | Quick_Books_Account_N_Checkbook |