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 |