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 |