This table stores a quick books class and connects it to a gl account code |
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. |