m_product_loan

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
m_creditbureau_loanproduct_mapping.loan_product_id fk_cb_lp2 R
m_external_asset_owner_loan_product_configurable_attributes.loan_product_id FK_ext_asset_owner_lp_conf_attr_loan_product_id R
m_loan.product_id fkb6f935d8c8d4b434 R
m_loan_product_credit_allocation_rule.loan_product_id m_loan_product_credit_allocation_rule_fk R
m_loan_product_payment_allocation_rule.loan_product_id m_loan_product_payment_allocation_rule_fk R
m_loanproduct_provisioning_entry.product_id m_loanproduct_provisioning_entry_ibfk_4 R
m_loanproduct_provisioning_mapping.product_id m_loanproduct_provisioning_mapping_ibfk_1 R
m_product_loan_charge.product_loan_id m_product_loan_charge_ibfk_2 R
m_product_loan_configurable_attributes.loan_product_id fk_m_product_loan_configurable_attributes_0001 R
m_product_loan_floating_rates.loan_product_id FK_mappings_m_product_loan_id R
m_product_loan_guarantee_details.loan_product_id FK_guarantee_details_loan_product R
m_product_loan_rate.product_loan_id fk_m_product_loan_rate_loan R
m_product_loan_recalculation_details.product_id FK_m_product_loan_m_product_loan_recalculation_details R
m_product_loan_variable_installment_config.loan_product_id FK_mappings_m_variable_product_loan_id R
m_product_loan_variations_borrower_cycle.loan_product_id borrower_cycle_loan_product_FK R
m_product_mix.product_id FK_m_product_mix_product_id_to_m_product_loan R
m_product_mix.restricted_product_id FK_m_product_mix_restricted_product_id_to_m_product_loan R
short_name varchar 4 null
currency_code varchar 3 null
currency_digits int2 5 null
currency_multiplesof int2 5 √ null
principal_amount numeric 19,6 √ NULL::numeric
min_principal_amount numeric 19,6 √ NULL::numeric
max_principal_amount numeric 19,6 √ NULL::numeric
arrearstolerance_amount numeric 19,6 √ NULL::numeric
name varchar 100 null
description varchar 500 √ null
fund_id int8 19 √ null
m_fund.id fka6a8a7d77240145 R
is_linked_to_floating_interest_rates bool 1 false
allow_variabe_installments bool 1 false
nominal_interest_rate_per_period numeric 19,6 √ NULL::numeric
min_nominal_interest_rate_per_period numeric 19,6 √ NULL::numeric
max_nominal_interest_rate_per_period numeric 19,6 √ NULL::numeric
interest_period_frequency_enum int2 5 √ null
annual_nominal_interest_rate numeric 19,6 √ NULL::numeric
interest_method_enum int2 5 null
interest_calculated_in_period_enum int2 5 1
allow_partial_period_interest_calcualtion bool 1 false
repay_every int2 5 null
repayment_period_frequency_enum int2 5 null
number_of_repayments int2 5 null
min_number_of_repayments int2 5 √ null
max_number_of_repayments int2 5 √ null
grace_on_principal_periods int2 5 √ null
recurring_moratorium_principal_periods int2 5 √ null
grace_on_interest_periods int2 5 √ null
grace_interest_free_periods int2 5 √ null
amortization_method_enum int2 5 null
accounting_type int2 5 null
loan_transaction_strategy_id int8 19 √ null
external_id varchar 100 √ null
include_in_borrower_cycle bool 1 false
use_borrower_cycle bool 1 false
start_date date 13 √ null
close_date date 13 √ null
allow_multiple_disbursals bool 1 false
max_disbursals int4 10 √ null
max_outstanding_loan_balance numeric 19,6 √ NULL::numeric
grace_on_arrears_ageing int2 5 √ null
overdue_days_for_npa int2 5 √ null
days_in_month_enum int2 5 1
days_in_year_enum int2 5 1
interest_recalculation_enabled bool 1 false
min_days_between_disbursal_and_first_repayment int4 10 √ null
hold_guarantee_funds bool 1 false
principal_threshold_for_last_installment numeric 5,2 50
account_moves_out_of_npa_only_on_arrears_completion bool 1 false
can_define_fixed_emi_amount bool 1 false
installment_amount_in_multiples_of numeric 19,6 √ NULL::numeric
can_use_for_topup bool 1 false
sync_expected_with_disbursement_date bool 1 √ false
is_equal_amortization bool 1 false
fixed_principal_percentage_per_installment numeric 5,2 √ NULL::numeric
disallow_expected_disbursements bool 1 false
allow_approved_disbursed_amounts_over_applied bool 1 false
over_applied_calculation_type varchar 10 √ null
over_applied_number int4 10 √ null
delinquency_bucket_id int8 19 √ null
m_delinquency_bucket.id FK_m_product_loan_m_delinquency_bucket R
loan_transaction_strategy_code varchar 100 '-'::character varying
loan_transaction_strategy_name varchar 100 '-'::character varying
due_days_for_repayment_event int4 10 √ null
overdue_days_for_repayment_event int4 10 √ null
enable_down_payment bool 1 false
disbursed_amount_percentage_for_down_payment numeric 9,6 √ NULL::numeric
enable_installment_level_delinquency bool 1 false
enable_accrual_activity_posting bool 1 false
days_in_year_custom_strategy varchar 100 √ null
enable_income_capitalization bool 1 false
capitalized_income_calculation_type varchar 100 √ null
m_external_event_configuration.type Implied Constraint R
capitalized_income_strategy varchar 100 √ null
capitalized_income_type varchar 10 √ null
enable_buy_down_fee bool 1 false
buy_down_fee_calculation_type varchar 100 √ null
m_external_event_configuration.type Implied Constraint R
buy_down_fee_strategy varchar 100 √ null
buy_down_fee_income_type varchar 100 √ null
m_external_event_configuration.type Implied Constraint R
allow_full_term_for_tranche bool 1 false
month_end_due_date_strategy varchar 100 √ null
enable_auto_repayment_for_down_payment bool 1 false
repayment_start_date_type_enum int2 5 1
loan_schedule_type varchar 20 'CUMULATIVE'::character varying
loan_schedule_processing_type varchar 20 'HORIZONTAL'::character varying
fixed_length int2 5 √ null
supported_interest_refund_types text 2147483647 √ null
charge_off_behaviour varchar 20 √ 'REGULAR'::character varying
interest_recognition_on_disbursement_date bool 1 false
is_merchant_buy_down_fee bool 1 true

Indexes

Constraint Name Type Sort Column(s)
m_product_loan_pkey Primary key Asc id
FK_ltp_strategy Performance Asc loan_transaction_strategy_id
fka6a8a7d77240145 Performance Asc fund_id
m_product_loan_external_id_key Must be unique Asc external_id
m_product_loan_name_key Must be unique Asc name
m_product_loan_short_name_key Must be unique Asc short_name

Relationships

Close relationships within degrees of separation