Table: dbo.Csa_Account_Group_Map_To_Classification_Code
This table stores the classification code/subcode mappings for CSA account groups.
Columns
Name | Type | Constraints | Description
csa_account_group_map_to_classification_code_KEY | int (4) | NOT NULL | Primary Key for this table.
client_KEY | int (4) | NOT NULL | Client Key.
description | nvarchar (256) | NOT NULL | Csa Account Group description.
gl_account_grouping_code_KEY | int (4) | NOT NULL | Classification Code Key.
gl_account_grouping_subcode_KEY | int (4) |  | Classification Subcode Key. Not Required

Primary key
Name | Columns | Description
PK_Csa_Account_Group_Map_To_Classification_Code | csa_account_group_map_to_classification_code_KEY |
Unique constraints
Name | Columns | Description
UK_Csa_Account_Group_Map_To_Classification_Code$client_KEY$description$gl_account_grouping_code_KEY | client_KEY, description, gl_account_grouping_code_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Csa_Account_Group_Map_To_Classification_Code__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Csa_Account_Group_Map_To_Classification_Code__GL_Account_Grouping_Code__gl_account_grouping_code_KEY | gl_account_grouping_code_KEY | GL_Account_Grouping_Code (gl_account_grouping_code_KEY) |
FK_Csa_Account_Group_Map_To_Classification_Code__GL_Account_Grouping_Subcode__gl_account_grouping_subcode_KEY | gl_account_grouping_subcode_KEY | GL_Account_Grouping_Subcode (gl_account_grouping_subcode_KEY) |