Table: dbo.Quick_Books_Class
This table stores a quick books class and connects it to a gl account code
Columns
Name | Type | Constraints | Description
quick_books_class_KEY | int (4) | NOT NULL | Primary key.
description | nvarchar (318) | NOT NULL | The description of the class.
gl_account_segment_code_KEY | int (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_KEY | int (4) | NOT NULL | A foreign key to the client table.
do_not_import | bit (1) | NOT NULL | Allows 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_id | nvarchar (120) | NOT NULL | the id of the quickbooks class. this is supposed to be a unique value, at least for the classes of one quickbooks company.

Primary key
Name | Columns | Description
PK_Quick_Books_Class | quick_books_class_KEY |
Unique constraints
Name | Columns | Description
UK_Quick_Books_Class$description$client_KEY | description, client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Quick_Books_Class__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Quick_Books_Class__GL_Account_Segment_Code__gl_account_segment_code_KEY | gl_account_segment_code_KEY | GL_Account_Segment_Code (gl_account_segment_code_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_GL_Account_Segment_Code_N_Quick_Books_Class__Quick_Books_Class__quick_books_class_KEY | quick_books_class_KEY | GL_Account_Segment_Code_N_Quick_Books_Class |
FK_Quick_Books_Account__Quick_Books_Class__quick_books_class_KEY | quick_books_class_KEY | Quick_Books_Account |