| 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) | |