Table: dbo.GL_Account_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_n_gl_account_grouping_code_KEYint (4)NOT NULLPrimary key for this table.
gl_account_grouping_subcode_KEYint (4)NOT NULLGL_Account_Grouping_Code key.
Primary key
NameColumnsDescription
PK_GL_Account_N_GL_Account_Grouping_Code_Subcode$gl_account_n_gl_account_grouping_code_KEYgl_account_n_gl_account_grouping_code_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Account_N_GL_Account_Grouping_Code_Subcode__GL_Account_Grouping_Subcode__gl_account_grouping_subcode_KEYgl_account_grouping_subcode_KEYGL_Account_Grouping_Subcode (gl_account_grouping_subcode_KEY)
FK_GL_Account_N_GL_Account_Grouping_Code_Subcode__GL_Account_N_GL_Account_Grouping_Code__gl_account_n_gl_account_grouping_code_Kgl_account_n_gl_account_grouping_code_KEYGL_Account_N_GL_Account_Grouping_Code (gl_account_n_gl_account_grouping_code_KEY)

Schema diagram