Table: dbo.GL_Account_N_GL_Account_Grouping_Code
Dictionary table for connecting GL account to GL account grouping code for codes that are not Account Classification codes.
Columns
NameTypeConstraintsDescription
gl_account_n_gl_account_grouping_code_KEYint (4)NOT NULLPrimary key for this table.
gl_account_KEYint (4)NOT NULLGL_Account key.
gl_account_grouping_code_KEYint (4)NOT NULLGL_Account_Grouping_Code key.
Primary key
NameColumnsDescription
PK_GL_Account_N_GL_Account_Grouping_Codegl_account_n_gl_account_grouping_code_KEY
Unique constraints
NameColumnsDescription
UK_GL_Account_N_GL_Account_Grouping_Code$gl_account_KEY$gl_account_grouping_code_KEYgl_account_KEY, gl_account_grouping_code_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Account_N_GL_Account_Grouping_Code__GL_Account__gl_account_KEYgl_account_KEYGL_Account (gl_account_KEY)
FK_GL_Account_N_GL_Account_Grouping_Code__GL_Account_Grouping_Code__gl_account_grouping_code_KEYgl_account_grouping_code_KEYGL_Account_Grouping_Code (gl_account_grouping_code_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
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_Subcode

Schema diagram