Table: dbo.Csa_Account_Group_Map_To_Classification_Code
This table stores the classification code/subcode mappings for CSA account groups.
Columns
NameTypeConstraintsDescription
csa_account_group_map_to_classification_code_KEYint (4)NOT NULLPrimary Key for this table.
client_KEYint (4)NOT NULLClient Key.
descriptionnvarchar (256)NOT NULLCsa Account Group description.
gl_account_grouping_code_KEYint (4)NOT NULLClassification Code Key.
gl_account_grouping_subcode_KEYint (4)Classification Subcode Key. Not Required
Primary key
NameColumnsDescription
PK_Csa_Account_Group_Map_To_Classification_Codecsa_account_group_map_to_classification_code_KEY
Unique constraints
NameColumnsDescription
UK_Csa_Account_Group_Map_To_Classification_Code$client_KEY$description$gl_account_grouping_code_KEYclient_KEY, description, gl_account_grouping_code_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Csa_Account_Group_Map_To_Classification_Code__Client__client_KEYclient_KEYClient (client_KEY)
FK_Csa_Account_Group_Map_To_Classification_Code__GL_Account_Grouping_Code__gl_account_grouping_code_KEYgl_account_grouping_code_KEYGL_Account_Grouping_Code (gl_account_grouping_code_KEY)
FK_Csa_Account_Group_Map_To_Classification_Code__GL_Account_Grouping_Subcode__gl_account_grouping_subcode_KEYgl_account_grouping_subcode_KEYGL_Account_Grouping_Subcode (gl_account_grouping_subcode_KEY)

Schema diagram