Table: dbo.GL_Account_Grouping_Csa_Description | |||
This table stores the csa description for a gl account grouping. | |||
Columns | |||
Name | Type | Constraints | Description |
gl_account_grouping_KEY | int (4) | NOT NULL | GL Account Grouping key. |
description | nvarchar (256) | NOT NULL | Orginal description. |
grouping_number | int (4) | NOT NULL | CSA allows up to five groups and labels them Grp1-5. We need to maintain a connection to this label in ACS in order to correctly convert financial statements. |
Primary key | |||
Name | Columns | Description | |
PK_GL_Account_Grouping_Csa_Description$gl_account_grouping_KEY | gl_account_grouping_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_GL_Account_Grouping_Csa_Description__GL_Account_Grouping__gl_account_grouping_KEY | gl_account_grouping_KEY | GL_Account_Grouping (gl_account_grouping_KEY) |