Table: dbo.GL_Account_Classification_N_GL_Account_Grouping_Code
Dictionary table for connecting GL_Account_Grouping_Subcode to GL account grouping code for mapping.
Columns
NameTypeConstraintsDescription
gl_account_classification_n_gl_account_grouping_code_KEYint (4)NOT NULLPrimary key for this table.
classification__gl_account_grouping_subcode_KEYint (4)NOT NULLkey to the GL_Account_Grouping_Subcode table.
gl_account_grouping_code_KEYint (4)NOT NULLkey to the GL_Account_Grouping_Code table.
Primary key
NameColumnsDescription
PK_GL_Account_Classification_N_GL_Account_Grouping_Codegl_account_classification_n_gl_account_grouping_code_KEY
Unique constraints
NameColumnsDescription
UK_GL_Account_Classification_N_GL_Account_Grouping_Code$classification__gl_account_grouping_subcode_KEY$gl_account_grouping_codeclassification__gl_account_grouping_subcode_KEY, gl_account_grouping_code_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Account_Classification_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)
FK_GL_Account_Classification_N_GL_Account_Grouping_Code__GL_Account_Grouping_Subcode__classification__gl_account_grouping_subcodclassification__gl_account_grouping_subcode_KEYGL_Account_Grouping_Subcode (gl_account_grouping_subcode_KEY)
Incoming foreign keys
NameColumnsReferencing 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_Subcode

Schema diagram