acc_gl_account

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
acc_accounting_rule.credit_account_id FK_acc_accounting_rule_acc_gl_account_credit R
acc_accounting_rule.debit_account_id FK_acc_accounting_rule_acc_gl_account_debit R
acc_gl_account.parent_id fk_acc_0000000001 R
acc_gl_financial_activity_account.gl_account_id FK_office_mapping_acc_gl_account R
acc_gl_journal_entry.account_id FK_acc_gl_journal_entry_acc_gl_account R
acc_product_mapping.gl_account_id FK_acc_product_mapping_gl_account_id R
m_charge.income_or_liability_account_id FK_m_charge_acc_gl_account R
m_journal_entry_aggregation_summary.gl_account_id fk_gl_journal_entry_aggregation_summary_on_gl_account_id R
m_loanproduct_provisioning_entry.expense_account m_loanproduct_provisioning_entry_ibfk_7 R
m_loanproduct_provisioning_entry.liability_account m_loanproduct_provisioning_entry_ibfk_6 R
m_provisioning_criteria_definition.expense_account m_provisioning_criteria_definition_ibfk_4 R
m_provisioning_criteria_definition.liability_account m_provisioning_criteria_definition_ibfk_3 R
m_tax_component.credit_account_id FK_tax_component_credit_gl_account R
m_tax_component.debit_account_id FK_tax_component_debit_gl_account R
m_tellers.credit_account_id FK_m_tellers_gl_account_credit_account_id R
m_tellers.debit_account_id FK_m_tellers_gl_account_debit_account_id R
name varchar 200 null
parent_id int8 19 √ null
acc_gl_account.id fk_acc_0000000001 R
hierarchy varchar 50 √ null
gl_code varchar 45 null
disabled bool 1 false
manual_journal_entries_allowed bool 1 true
account_usage int2 5 2
classification_enum int2 5 null
tag_id int4 10 √ null
m_code_value.id fkglacc000000002 R
description varchar 500 √ null

Indexes

Constraint Name Type Sort Column(s)
acc_gl_account_pkey Primary key Asc id
acc_gl_account_gl_code_key Must be unique Asc gl_code
fk_acc_0000000001 Performance Asc parent_id
fkglacc000000002 Performance Asc tag_id

Relationships

Close relationships within degrees of separation