m_product_loan

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
m_creditbureau_loanproduct_mapping.loan_product_id fk_cb_lp2R
m_loan.product_id FKB6F935D8C8D4B434R
m_loanproduct_provisioning_entry.product_id m_loanproduct_provisioning_entry_ibfk_4R
m_loanproduct_provisioning_mapping.product_id m_loanproduct_provisioning_mapping_ibfk_1R
m_product_loan_charge.product_loan_id m_product_loan_charge_ibfk_2R
m_product_loan_configurable_attributes.loan_product_id fk_m_product_loan_configurable_attributes_0001R
m_product_loan_floating_rates.loan_product_id FK_mappings_m_product_loan_idR
m_product_loan_guarantee_details.loan_product_id FK_guarantee_details_loan_productR
m_product_loan_rate.product_loan_id FK_M_PRODUCT_LOAN_RATE_LOANR
m_product_loan_recalculation_details.product_id FK_m_product_loan_m_product_loan_recalculation_detailsR
m_product_loan_variable_installment_config.loan_product_id FK_mappings_m_variable_product_loan_idR
m_product_loan_variations_borrower_cycle.loan_product_id borrower_cycle_loan_product_FKR
m_product_mix.product_id FK_m_product_mix_product_id_to_m_product_loanR
m_product_mix.restricted_product_id FK_m_product_mix_restricted_product_id_to_m_product_loanR
short_name VARCHAR 4 null
currency_code VARCHAR 3 null
currency_digits SMALLINT 5 null
currency_multiplesof SMALLINT 5 √ NULL
principal_amount DECIMAL 19,6 √ NULL
min_principal_amount DECIMAL 19,6 √ NULL
max_principal_amount DECIMAL 19,6 √ NULL
arrearstolerance_amount DECIMAL 19,6 √ NULL
name VARCHAR 100 null
description VARCHAR 500 √ NULL
fund_id BIGINT 19 √ NULL
m_fund.id FKA6A8A7D77240145R
is_linked_to_floating_interest_rates BIT 1 b'0'
allow_variabe_installments BIT 1 b'0'
nominal_interest_rate_per_period DECIMAL 19,6 √ NULL
min_nominal_interest_rate_per_period DECIMAL 19,6 √ NULL
max_nominal_interest_rate_per_period DECIMAL 19,6 √ NULL
interest_period_frequency_enum SMALLINT 5 √ NULL
annual_nominal_interest_rate DECIMAL 19,6 √ NULL
interest_method_enum SMALLINT 5 null
interest_calculated_in_period_enum SMALLINT 5 1
allow_partial_period_interest_calcualtion BIT 1 b'0'
repay_every SMALLINT 5 null
repayment_period_frequency_enum SMALLINT 5 null
number_of_repayments SMALLINT 5 null
min_number_of_repayments SMALLINT 5 √ NULL
max_number_of_repayments SMALLINT 5 √ NULL
grace_on_principal_periods SMALLINT 5 √ NULL
recurring_moratorium_principal_periods SMALLINT 5 √ NULL
grace_on_interest_periods SMALLINT 5 √ NULL
grace_interest_free_periods SMALLINT 5 √ NULL
amortization_method_enum SMALLINT 5 null
accounting_type SMALLINT 5 null
loan_transaction_strategy_id BIGINT 19 √ NULL
ref_loan_transaction_processing_strategy.id FK_ltp_strategyR
external_id VARCHAR 100 √ NULL
include_in_borrower_cycle BIT 1 b'0'
use_borrower_cycle BIT 1 b'0'
start_date DATE 10 √ NULL
close_date DATE 10 √ NULL
allow_multiple_disbursals BIT 1 b'0'
max_disbursals INT 10 √ NULL
max_outstanding_loan_balance DECIMAL 19,6 √ NULL
grace_on_arrears_ageing SMALLINT 5 √ NULL
overdue_days_for_npa SMALLINT 5 √ NULL
days_in_month_enum SMALLINT 5 1
days_in_year_enum SMALLINT 5 1
interest_recalculation_enabled BIT 1 b'0'
min_days_between_disbursal_and_first_repayment INT 10 √ NULL
hold_guarantee_funds BIT 1 b'0'
principal_threshold_for_last_installment DECIMAL 5,2 50.00
account_moves_out_of_npa_only_on_arrears_completion BIT 1 b'0'
can_define_fixed_emi_amount BIT 1 b'0'
instalment_amount_in_multiples_of DECIMAL 19,6 √ NULL
can_use_for_topup BIT 1 b'0'
sync_expected_with_disbursement_date BIT 1 √ b'0'
is_equal_amortization BIT 1 b'0'
fixed_principal_percentage_per_installment DECIMAL 5,2 √ NULL
disallow_expected_disbursements BIT 1 b'0'
allow_approved_disbursed_amounts_over_applied BIT 1 b'0'
over_applied_calculation_type VARCHAR 10 √ NULL
over_applied_number INT 10 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
external_id Must be unique Asc external_id
FK_ltp_strategy Performance Asc loan_transaction_strategy_id
FKA6A8A7D77240145 Performance Asc fund_id
name Must be unique Asc name
short_name Must be unique Asc short_name

Relationships

Close relationships within degrees of separation