Table: dbo.GL_Account_Grouping_Csa_Description
This table stores the csa description for a gl account grouping.
Columns
NameTypeConstraintsDescription
gl_account_grouping_KEYint (4)NOT NULLGL Account Grouping key.
descriptionnvarchar (256)NOT NULLOrginal description.
grouping_numberint (4)NOT NULLCSA 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
NameColumnsDescription
PK_GL_Account_Grouping_Csa_Description$gl_account_grouping_KEYgl_account_grouping_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Account_Grouping_Csa_Description__GL_Account_Grouping__gl_account_grouping_KEYgl_account_grouping_KEYGL_Account_Grouping (gl_account_grouping_KEY)

Schema diagram