Table: dbo.GL_Account_Grouping
Complete set of Account Groupings for a client and global
Columns
Name | Type | Constraints | Description
gl_account_grouping_KEY | int (4) | NOT NULL | Primary key for this table.
client_KEY | int (4) |  | Key of client that owns the Account Grouping.
description | nvarchar (100) | NOT NULL | account grouping Description
is_standard_classification_code | bit (1) | NOT NULL | This columns serves as a flag for marking this Account grouping the default group.
gl_account_grouping_guid | uniqueidentifier (16) | NOT NULL | A unique GUID key for this row.

Primary key
Name | Columns | Description
PK_GL_Account_Grouping | gl_account_grouping_KEY |
Unique constraints
Name | Columns | Description
UK_GL_Account_Grouping$client_KEY$description | client_KEY, description |
UK_GL_Account_Grouping$gl_account_grouping_guid | gl_account_grouping_guid |

Foreign keys
Name | Columns | Referenced table | Description
FK_GL_Account_Grouping__Client__client_KEY | client_KEY | Client (client_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_GL_Account_Grouping_Code__GL_Account_Grouping__gl_account_grouping_KEY | gl_account_grouping_KEY | GL_Account_Grouping_Code |
FK_GL_Account_Grouping_Csa_Description__GL_Account_Grouping__gl_account_grouping_KEY | gl_account_grouping_KEY | GL_Account_Grouping_Csa_Description |
FK_Custom_Office_Account_Grouping__GL_Account_Grouping__gl_account_grouping_KEY | gl_account_grouping_KEY | Custom_Office_Account_Grouping |
FK_Trial_Balance_Grid_Column_Account_Grouping_Option__GL_Account_Grouping__gl_account_grouping_KEY | gl_account_grouping_KEY | Trial_Balance_Grid_Column_Account_Grouping_Option |
FK_Import_Template_Column_GL_Account_Data__GL_Account_Grouping__gl_account_grouping_KEY | gl_account_grouping_KEY | Import_Template_Column_GL_Account_Data |