Table: dbo.GL_Account_Classification_N_GL_Account_Grouping_Code_Subcode
Dictionary table for connecting GL account to GL account grouping subcode through the code dictionary table for subcodes that are not Account Classification subcodes.
Columns
NameTypeConstraintsDescription
gl_account_classification_n_gl_account_grouping_code_KEYint (4)NOT NULLkey to the GL_Account_Classification_N_GL_Account_Grouping_Code table.
classification__gl_account_grouping_subcode_KEYint (4)NOT NULLkey to the GL_Account_Grouping_SubCode table.
Primary key
NameColumnsDescription
PK_GL_Account_Classification_N_GL_Account_Grouping_Code_Subcode$gl_account_classification_n_gl_account_grouping_code_KEYgl_account_classification_n_gl_account_grouping_code_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Account_Classification_N_GL_Account_Grouping_Code_Subcode__GL_Account_Classification_N_GL_Account_Grouping_Code__gl_accoungl_account_classification_n_gl_account_grouping_code_KEYGL_Account_Classification_N_GL_Account_Grouping_Code (gl_account_classification_n_gl_account_grouping_code_KEY)
FK_GL_Account_Classification_N_GL_Account_Grouping_Code_Subcode__GL_Account_Grouping_Subcode__classification__gl_account_groupinclassification__gl_account_grouping_subcode_KEYGL_Account_Grouping_Subcode (gl_account_grouping_subcode_KEY)

Schema diagram