Table: dbo.GL_Account_Grouping_Code_Type
Extension of the GL_Account_Grouping_Code table to hold the Type for the standard classification codes and the default codes for each Type
Columns
NameTypeConstraintsDescription
gl_account_grouping_code_KEYint (4)NOT NULLPrimary key for this table.
gl_account_type_KEYint (4)NOT NULLGL_Account_Type key.
default__gl_account_type_KEYint (4)GL_Account_Type key If this code is the default code for this type, NULL otherwise.
Primary key
NameColumnsDescription
PK_GL_Account_Grouping_Code_Type$gl_account_grouping_code_KEYgl_account_grouping_code_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Account_Grouping_Code_Type__GL_Account_Grouping_Code__gl_account_grouping_code_KEYgl_account_grouping_code_KEYGL_Account_Grouping_Code (gl_account_grouping_code_KEY)
FK_GL_Account_Grouping_Code_Type__GL_Account_Type__default__gl_account_type_KEYdefault__gl_account_type_KEYGL_Account_Type (gl_account_type_KEY)
FK_GL_Account_Grouping_Code_Type__GL_Account_Type__gl_account_type_KEYgl_account_type_KEYGL_Account_Type (gl_account_type_KEY)

Schema diagram