Table: dbo.GL_Account_Parent
The parent child relationships of the GL Account table.
Columns
NameTypeConstraintsDescription
gl_account_KEYint (4)NOT NULLPrimary key for this table. Each GL_account can have up to one parent.
parent__gl_account_KEYint (4)NOT NULLThe foreign key to the parent GL Account.
gl_account_hierarchy_type_KEYint (4)NOT NULLForeign 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_KEYint (4)NOT NULLPrimary Key
Primary key
NameColumnsDescription
PK_GL_Account_Parentgl_account_parent_KEY
Unique constraints
NameColumnsDescription
UK_GL_Account_Parent$gl_account_KEY$gl_account_hierarchy_type_KEYgl_account_KEY, gl_account_hierarchy_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Account_Parent__GL_Account__gl_account_KEYgl_account_KEYGL_Account (gl_account_KEY)
FK_GL_Account_Parent__GL_Account__parent__gl_account_KEYparent__gl_account_KEYGL_Account (gl_account_KEY)
FK_GL_Account_Parent__GL_Account_Hierarchy_Type__gl_account_hierarchy_type_KEYgl_account_hierarchy_type_KEYGL_Account_Hierarchy_Type (gl_account_hierarchy_type_KEY)

Schema diagram