m_loanproduct_provisioning_entry

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
history_id int8 19 null
m_provisioning_history.id m_loanproduct_provisioning_entry_ibfk_1 R
criteria_id int8 19 null
m_provisioning_criteria.id m_loanproduct_provisioning_entry_ibfk_2 R
currency_code varchar 3 null
office_id int8 19 null
m_office.id m_loanproduct_provisioning_entry_ibfk_3 R
product_id int8 19 null
m_product_loan.id m_loanproduct_provisioning_entry_ibfk_4 R
category_id int8 19 null
m_provision_category.id m_loanproduct_provisioning_entry_ibfk_5 R
overdue_in_days int8 19 √ 0
reseve_amount numeric 20,6 √ 0
liability_account int8 19 √ null
acc_gl_account.id m_loanproduct_provisioning_entry_ibfk_6 R
expense_account int8 19 √ null
acc_gl_account.id m_loanproduct_provisioning_entry_ibfk_7 R

Indexes

Constraint Name Type Sort Column(s)
m_loanproduct_provisioning_entry_pkey Primary key Asc id
category_id Performance Asc category_id
expense_account Performance Asc expense_account
fk_loanproduct_provisioning_entry_criteria Performance Asc criteria_id
history_id Performance Asc history_id
loanproduct_provisioning_entry_liability_account Performance Asc liability_account
loanproduct_provisioning_entry_office_id Performance Asc office_id
loanproduct_provisioning_entry_product_id Performance Asc product_id

Relationships

Close relationships within degrees of separation