Table: dbo.Quick_Books_Class
This table stores a quick books class and connects it to a gl account code
Columns
NameTypeConstraintsDescription
quick_books_class_KEYint (4)NOT NULLPrimary key.
descriptionnvarchar (318)NOT NULLThe description of the class.
gl_account_segment_code_KEYint (4)The gl_account_segment_code_KEY shows the mapping of the quick books class to an acs gl account segment code. If an import choice has not yet been made, for example if the do not import option has been chosen, then let the gl account segment code key field be null.
client_KEYint (4)NOT NULLA foreign key to the client table.
do_not_importbit (1)NOT NULLAllows us to track whether or not the user wants to import a given class. This also allows us to show in the user interface that the user has previously made this choice for a class.
list_idnvarchar (120)NOT NULLthe id of the quickbooks class. this is supposed to be a unique value, at least for the classes of one quickbooks company.
Primary key
NameColumnsDescription
PK_Quick_Books_Classquick_books_class_KEY
Unique constraints
NameColumnsDescription
UK_Quick_Books_Class$description$client_KEYdescription, client_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Quick_Books_Class__Client__client_KEYclient_KEYClient (client_KEY)
FK_Quick_Books_Class__GL_Account_Segment_Code__gl_account_segment_code_KEYgl_account_segment_code_KEYGL_Account_Segment_Code (gl_account_segment_code_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_GL_Account_Segment_Code_N_Quick_Books_Class__Quick_Books_Class__quick_books_class_KEYquick_books_class_KEYGL_Account_Segment_Code_N_Quick_Books_Class
FK_Quick_Books_Account__Quick_Books_Class__quick_books_class_KEYquick_books_class_KEYQuick_Books_Account

Schema diagram