Table: dbo.GL_Account_Parent
The parent child relationships of the GL Account table.
Columns
Name | Type | Constraints | Description
gl_account_KEY | int (4) | NOT NULL | Primary key for this table. Each GL_account can have up to one parent.
parent__gl_account_KEY | int (4) | NOT NULL | The foreign key to the parent GL Account.
gl_account_hierarchy_type_KEY | int (4) | NOT NULL | Foreign key to the GL account hierarchy type. This column now allows this table to track two completely different account hierarchies for each client.
gl_account_parent_KEY | int (4) | NOT NULL | Primary Key

Primary key
Name | Columns | Description
PK_GL_Account_Parent | gl_account_parent_KEY |
Unique constraints
Name | Columns | Description
UK_GL_Account_Parent$gl_account_KEY$gl_account_hierarchy_type_KEY | gl_account_KEY, gl_account_hierarchy_type_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_GL_Account_Parent__GL_Account__gl_account_KEY | gl_account_KEY | GL_Account (gl_account_KEY) |
FK_GL_Account_Parent__GL_Account__parent__gl_account_KEY | parent__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_GL_Account_Parent__GL_Account_Hierarchy_Type__gl_account_hierarchy_type_KEY | gl_account_hierarchy_type_KEY | GL_Account_Hierarchy_Type (gl_account_hierarchy_type_KEY) |