| Table: dbo.GL_Account_Grouping_Code | |||
| Complete set of Account Groupings Codes/Classes for a client and global | |||
| Columns | |||
| Name | Type | Constraints | Description |
| gl_account_grouping_code_KEY | int (4) | NOT NULL | Primary key for this table. |
| gl_account_grouping_KEY | int (4) | NOT NULL | Key for the type of this group. |
| code | nvarchar (30) | NOT NULL | account grouping code. |
| description | nvarchar (100) | NOT NULL | account grouping Description of the code. |
| is_standard_classification_code | bit (1) | NOT NULL | This columns serves as a flag for marking this code the default class of the associated group. |
| sequence_number | int (4) | NOT NULL | sequence_number that determines the display order within the Account grouping codes. |
| gl_account_grouping_code_guid | uniqueidentifier (16) | NOT NULL | A unique GUID key for this row. |
| gl_account_grouping_category_KEY | int (4) | Key of Accounting grouping category to be assigned to account grouping codes. | |
| Primary key | |||
| Name | Columns | Description | |
| PK_GL_Account_Grouping_Code | gl_account_grouping_code_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_GL_Account_Grouping_Code$gl_account_grouping_code_guid | gl_account_grouping_code_guid | ||
| UK_GL_Account_Grouping_Code$gl_account_grouping_KEY$code | gl_account_grouping_KEY, code | ||