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
NameTypeConstraintsDescription
gl_account_hierarchy_type_KEYint (4)NOT NULLPrimary key.
descriptionnvarchar (40)NOT NULLDescription of the GL account parent-child hierarchy type.
Primary key
NameColumnsDescription
PK_GL_Account_Hierarchy_Typegl_account_hierarchy_type_KEY
Unique constraints
NameColumnsDescription
UK_GL_Account_Hierarchy_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_GL_Account_Parent__GL_Account_Hierarchy_Type__gl_account_hierarchy_type_KEYgl_account_hierarchy_type_KEYGL_Account_Parent

Schema diagram