Table: dbo.GL_Account_Grouping_Subcode
Complete set of Account Groupings Subcodes/subclasses for a client and global
Columns
NameTypeConstraintsDescription
gl_account_grouping_subcode_KEYint (4)NOT NULLPrimary key for this table.
subcodenvarchar (30)NOT NULLAccount Grouping subcode.
descriptionnvarchar (100)NOT NULLDescription of the account grouping subcode.
is_standard_classification_codebit (1)NOT NULLThis column serves as a flag to indicate this subcode is provided to the user by CS and it can not be changed or deleted by the user.
sequence_numberint (4)NOT NULLsequence_number that determines the display order within the Account grouping codes.
gl_account_grouping_code_KEYint (4)NOT NULLForeign key to the gl_account_grouping_code table.
gl_account_grouping_subcode_guiduniqueidentifier (16)NOT NULLA unique GUID key for this row.
Primary key
NameColumnsDescription
PK_GL_Account_Grouping_Subcodegl_account_grouping_subcode_KEY
Unique constraints
NameColumnsDescription
UK_GL_Account_Grouping_Subcode$gl_account_grouping_code_KEY$subcodegl_account_grouping_code_KEY, subcode
UK_GL_Account_Grouping_Subcode$gl_account_grouping_subcode_guidgl_account_grouping_subcode_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Account_Grouping_Subcode__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_Csa_Account_Group_Map_To_Classification_Code__GL_Account_Grouping_Subcode__gl_account_grouping_subcode_KEYgl_account_grouping_subcode_KEYCsa_Account_Group_Map_To_Classification_Code
FK_GL_Account_Classification_N_GL_Account_Grouping_Code__GL_Account_Grouping_Subcode__classification__gl_account_grouping_subcodclassification__gl_account_grouping_subcode_KEYGL_Account_Classification_N_GL_Account_Grouping_Code
FK_GL_Account_Classification_N_Tax_Code__GL_Account_Grouping_Subcode__classification__gl_account_grouping_subcode_KEYclassification__gl_account_grouping_subcode_KEYGL_Account_Classification_N_Tax_Code
FK_GL_Account_Classification_N_Tax_Code_M3__GL_Account_Grouping_Subcode__classification__gl_account_grouping_subcode_KEYclassification__gl_account_grouping_subcode_KEYGL_Account_Classification_N_Tax_Code_M3
FK_GL_Account_Classification_N_GL_Account_Grouping_Code_Subcode__GL_Account_Grouping_Subcode__classification__gl_account_groupinclassification__gl_account_grouping_subcode_KEYGL_Account_Classification_N_GL_Account_Grouping_Code_Subcode
FK_GL_Account_N_GL_Account_Grouping_Code_Subcode__GL_Account_Grouping_Subcode__gl_account_grouping_subcode_KEYgl_account_grouping_subcode_KEYGL_Account_N_GL_Account_Grouping_Code_Subcode

Schema diagram