Table: dbo.GL_Account_Grouping
Complete set of Account Groupings for a client and global
Columns
NameTypeConstraintsDescription
gl_account_grouping_KEYint (4)NOT NULLPrimary key for this table.
client_KEYint (4) Key of client that owns the Account Grouping.
descriptionnvarchar (100)NOT NULLaccount grouping Description
is_standard_classification_codebit (1)NOT NULLThis columns serves as a flag for marking this Account grouping the default group.
gl_account_grouping_guiduniqueidentifier (16)NOT NULLA unique GUID key for this row.
Primary key
NameColumnsDescription
PK_GL_Account_Groupinggl_account_grouping_KEY
Unique constraints
NameColumnsDescription
UK_GL_Account_Grouping$client_KEY$descriptionclient_KEY, description
UK_GL_Account_Grouping$gl_account_grouping_guidgl_account_grouping_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Account_Grouping__Client__client_KEYclient_KEYClient (client_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_GL_Account_Grouping_Code__GL_Account_Grouping__gl_account_grouping_KEYgl_account_grouping_KEYGL_Account_Grouping_Code
FK_GL_Account_Grouping_Csa_Description__GL_Account_Grouping__gl_account_grouping_KEYgl_account_grouping_KEYGL_Account_Grouping_Csa_Description
FK_Custom_Office_Account_Grouping__GL_Account_Grouping__gl_account_grouping_KEYgl_account_grouping_KEYCustom_Office_Account_Grouping
FK_Trial_Balance_Grid_Column_Account_Grouping_Option__GL_Account_Grouping__gl_account_grouping_KEYgl_account_grouping_KEYTrial_Balance_Grid_Column_Account_Grouping_Option
FK_Import_Template_Column_GL_Account_Data__GL_Account_Grouping__gl_account_grouping_KEYgl_account_grouping_KEYImport_Template_Column_GL_Account_Data

Schema diagram