Table: dbo.GL_Account_Segment_Code_N_Quick_Books_Class
This table shows the export mapping of gl account segment codes to quick books classes. A gl account segment code key is used only once in the mapping per client, so this can be the primary key. The quick books class key can be used one or more times in the mapping.
Columns
NameTypeConstraintsDescription
gl_account_segment_code_KEYint (4)NOT NULLPrimary key from the GL_Account_Segment_Code table.
quick_books_class_KEYint (4)NOT NULLPrimary key from the Quick_Books_Class table.
Primary key
NameColumnsDescription
PK_GL_Account_Segment_Code_N_Quick_Books_Class$gl_account_segment_code_KEYgl_account_segment_code_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Account_Segment_Code_N_Quick_Books_Class__GL_Account_Segment_Code__gl_account_segment_code_KEYgl_account_segment_code_KEYGL_Account_Segment_Code (gl_account_segment_code_KEY)
FK_GL_Account_Segment_Code_N_Quick_Books_Class__Quick_Books_Class__quick_books_class_KEYquick_books_class_KEYQuick_Books_Class (quick_books_class_KEY)

Schema diagram