acc_gl_account

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
acc_accounting_rule.credit_account_id FK_acc_accounting_rule_acc_gl_account_creditR
acc_accounting_rule.debit_account_id FK_acc_accounting_rule_acc_gl_account_debitR
acc_gl_account.parent_id FK_ACC_0000000001R
acc_gl_financial_activity_account.gl_account_id FK_office_mapping_acc_gl_accountR
acc_gl_journal_entry.account_id FK_acc_gl_journal_entry_acc_gl_accountR
m_charge.income_or_liability_account_id FK_m_charge_acc_gl_accountR
m_loanproduct_provisioning_entry.expense_account m_loanproduct_provisioning_entry_ibfk_7R
m_loanproduct_provisioning_entry.liability_account m_loanproduct_provisioning_entry_ibfk_6R
m_provisioning_criteria_definition.expense_account m_provisioning_criteria_definition_ibfk_4R
m_provisioning_criteria_definition.liability_account m_provisioning_criteria_definition_ibfk_3R
m_tax_component.credit_account_id FK_tax_component_credit_gl_accountR
m_tax_component.debit_account_id FK_tax_component_debit_gl_accountR
m_tellers.credit_account_id FK_m_tellers_gl_account_credit_account_idR
m_tellers.debit_account_id FK_m_tellers_gl_account_debit_account_idR
name VARCHAR 200 null
parent_id BIGINT 19 √ NULL
acc_gl_account.id FK_ACC_0000000001R
hierarchy VARCHAR 50 √ NULL
gl_code VARCHAR 45 null
disabled BIT 1 b'0'
manual_journal_entries_allowed BIT 1 b'1'
account_usage TINYINT 3 2
classification_enum SMALLINT 5 null
tag_id INT 10 √ NULL
m_code_value.id FKGLACC000000002R
description VARCHAR 500 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_ACC_0000000001 Performance Asc parent_id
FKGLACC000000002 Performance Asc tag_id
gl_code Must be unique Asc gl_code

Relationships

Close relationships within degrees of separation