Table: dbo.Quick_Books_Payee
Quick Books Payee
Columns
NameTypeConstraintsDescription
quick_books_payee_KEYint (4)NOT NULLPrimary key.
client_KEYint (4)NOT NULLThe client_KEY for this payee.
namenvarchar (160)NOT NULLname.
full_namenvarchar (510)NOT NULLfull name.
first_namenvarchar (100)NOT NULLfirst name.
middle_namenvarchar (40)NOT NULLmiddle name.
last_namenvarchar (100)NOT NULLlast name.
is_activebit (1)NOT NULLflag for indicating the active status of the payee.
list_idnvarchar (120)NOT NULLThe Quick Books list id for the payee.
quick_books_payee_type_KEYint (4)NOT NULLKey for the payee type of this payee.
do_not_importbit (1)NOT NULLwhen set true, this tells us that the user does not want to import a particular vendor or employee from QuickBooks into Accounting CS. The vendor or employee will not be added and will not be mapped to an existing Accounting CS vendor or employee. This setting needs to be saved so that the data mapping user interface can display a user choice from a previous import.
Primary key
NameColumnsDescription
PK_Quick_Books_Payeequick_books_payee_KEY
Unique constraints
NameColumnsDescription
UK_Quick_Books_Payee$full_name$list_id$client_KEYfull_name, list_id, client_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Quick_Books_Payee__Client__client_KEYclient_KEYClient (client_KEY)
FK_Quick_Books_Payee__Quick_Books_Payee_Type__quick_books_payee_type_KEYquick_books_payee_type_KEYQuick_Books_Payee_Type (quick_books_payee_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Vendor__Quick_Books_Payee__export__quick_books_payee_KEYexport__quick_books_payee_KEYVendor
FK_Quick_Books_Payee_N_Vendor__Quick_Books_Payee__quick_books_payee_KEYquick_books_payee_KEYQuick_Books_Payee_N_Vendor
FK_Employee__Quick_Books_Payee__export__quick_books_payee_KEYexport__quick_books_payee_KEYEmployee
FK_Quick_Books_Payee_N_Employee__Quick_Books_Payee__quick_books_payee_KEYquick_books_payee_KEYQuick_Books_Payee_N_Employee

Schema diagram