Table: dbo.GL_Account_Hierarchy_Type
The type table used to differentiate the different GL account hierarchies supported via the GL_Account_Parent table. Currently there are two types: Core account and User defined. The Core Account hierarchy will associate a core account number with its posting account numbers. This information will be system maintained based on the user's selected core account segment and the account numbers entered into the Chart. The User-defined hierarchy will be maintained by the user and will represent whatever concept they wish it too (thus the name user-defined!). Both hierarchies are limited to one generation. That is, a parent can't be a child and a child can't be a parent.
Columns
Name | Type | Constraints | Description
gl_account_hierarchy_type_KEY | int (4) | NOT NULL | Primary key.
description | nvarchar (40) | NOT NULL | Description of the GL account parent-child hierarchy type.

Primary key
Name | Columns | Description
PK_GL_Account_Hierarchy_Type | gl_account_hierarchy_type_KEY |
Unique constraints
Name | Columns | Description
UK_GL_Account_Hierarchy_Type$description | description |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_GL_Account_Parent__GL_Account_Hierarchy_Type__gl_account_hierarchy_type_KEY | gl_account_hierarchy_type_KEY | GL_Account_Parent |