Table: dbo.Quick_Books_Account
This table stores a quick book account
Columns
NameTypeConstraintsDescription
quick_books_account_KEYint (4)NOT NULLPrimary key.
client_KEYint (4)NOT NULLThe client key for this quick books account.
account_numbernvarchar (40)NOT NULLThe Quick Books account number.
full_namenvarchar (318)NOT NULLThe Quick Books full_name.
account_sortint (4)NOT NULLThe sort value for the account number
list_idnvarchar (120)NOT NULLThe Quick Books List ID for the account
account_typenvarchar (300)NOT NULLa description of the Quick Books account type
original_account_numbernvarchar (40)NOT NULLThe original Quick Books account number.
original_full_namenvarchar (318)NOT NULLThe original Quick Books full_name.
quick_books_class_KEYint (4)The Quick Books class for this account.
do_not_importbit (1)NOT NULLwhen 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_balancedecimal (9, 2)QuickBooks current balance for the account.
Primary key
NameColumnsDescription
PK_Quick_Books_Accountquick_books_account_KEY
Unique constraints
NameColumnsDescription
UK_Quick_Books_Account$full_name$list_id$client_KEY$quick_books_class_KEYfull_name, list_id, client_KEY, quick_books_class_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Quick_Books_Account__Client__client_KEYclient_KEYClient (client_KEY)
FK_Quick_Books_Account__Quick_Books_Class__quick_books_class_KEYquick_books_class_KEYQuick_Books_Class (quick_books_class_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_GL_Account__Quick_Books_Account__export__quick_books_account_KEYexport__quick_books_account_KEYGL_Account
FK_Checkbook__Quick_Books_Account__export__quick_books_account_KEYexport__quick_books_account_KEYCheckbook
FK_Quick_Books_Account_GL_Account__Quick_Books_Account__quick_books_account_KEYquick_books_account_KEYQuick_Books_Account_GL_Account
FK_Quick_Books_Account_N_Checkbook__Quick_Books_Account__quick_books_account_KEYquick_books_account_KEYQuick_Books_Account_N_Checkbook

Schema diagram