m_loan

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
m_account_transfer_details.from_loan_account_id FK_m_account_transfer_details_from_loan_accountR
m_account_transfer_details.to_loan_account_id FK_m_account_transfer_details_to_loan_accountR
m_guarantor.loan_id FK_m_guarantor_m_loanR
m_loan_arrears_aging.loan_id m_loan_arrears_aging_ibfk_1R
m_loan_charge.loan_id m_loan_charge_ibfk_2R
m_loan_collateral.loan_id FK_collateral_m_loanR
m_loan_collateral_management.loan_id fkLoanC
m_loan_disbursement_detail.loan_id FK_loan_disbursement_detail_loan_idR
m_loan_officer_assignment_history.loan_id fk_m_loan_officer_assignment_history_0001R
m_loan_paid_in_advance.loan_id m_loan_paid_in_advance_ibfk_1R
m_loan_rate.loan_id FK_M_LOAN_RATE_LOANR
m_loan_recalculation_details.loan_id FK_m_loan_m_loan_recalculation_detailsR
m_loan_repayment_schedule.loan_id FK488B92AA40BE0710R
m_loan_repayment_schedule_history.loan_id m_loan_repayment_schedule_history_ibfk_1R
m_loan_reschedule_request.loan_id m_loan_reschedule_request_ibfk_1R
m_loan_term_variations.loan_id FK_loan_id_m_loan_idR
m_loan_topup.closure_loan_id m_loan_topup_FK_closure_loan_idR
m_loan_topup.loan_id m_loan_topup_FK_loan_idR
m_loan_tranche_charges.loan_id FK_m_loan_tranche_charges_m_loanR
m_loan_transaction.loan_id FKCFCEA42640BE0710R
m_note.loan_id FK7C9708940BE0710R
m_portfolio_account_associations.linked_loan_account_id linked_loan_fkR
m_portfolio_account_associations.loan_account_id account_association_loan_fkR
m_repayment_with_post_dated_checks.loan_id fkloanrepaymentC
account_no VARCHAR 20 null
external_id VARCHAR 100 √ NULL
client_id BIGINT 19 √ NULL
m_client.id FKB6F935D87179A0CBR
group_id BIGINT 19 √ NULL
m_group.id m_loan_ibfk_1R
glim_id BIGINT 19 √ NULL
glim_accounts.id FK_glim_idR
product_id BIGINT 19 √ NULL
m_product_loan.id FKB6F935D8C8D4B434R
fund_id BIGINT 19 √ NULL
m_fund.id FK7C885877240145R
loan_officer_id BIGINT 19 √ NULL
m_staff.id FK_m_loan_m_staffR
loanpurpose_cv_id INT 10 √ NULL
m_code_value.id FK_m_loanpurpose_codevalueR
loan_status_id SMALLINT 5 null
loan_type_enum SMALLINT 5 null
currency_code VARCHAR 3 null
currency_digits SMALLINT 5 null
currency_multiplesof SMALLINT 5 √ NULL
principal_amount_proposed DECIMAL 19,6 null
principal_amount DECIMAL 19,6 null
approved_principal DECIMAL 19,6 null
net_disbursal_amount DECIMAL 19,6 null
arrearstolerance_amount DECIMAL 19,6 √ NULL
is_floating_interest_rate BIT 1 √ b'0'
interest_rate_differential DECIMAL 19,6 √ 0.000000
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'
term_frequency SMALLINT 5 0
term_period_frequency_enum SMALLINT 5 2
repay_every SMALLINT 5 null
repayment_period_frequency_enum SMALLINT 5 null
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
submittedon_date DATE 10 √ NULL
submittedon_userid BIGINT 19 √ NULL
m_appuser.id FK_submittedon_useridR
approvedon_date DATE 10 √ NULL
approvedon_userid BIGINT 19 √ NULL
m_appuser.id FK_approvedon_useridR
expected_disbursedon_date DATE 10 √ NULL
expected_firstrepaymenton_date DATE 10 √ NULL
interest_calculated_from_date DATE 10 √ NULL
disbursedon_date DATE 10 √ NULL
disbursedon_userid BIGINT 19 √ NULL
m_appuser.id FK_disbursedon_useridR
expected_maturedon_date DATE 10 √ NULL
maturedon_date DATE 10 √ NULL
closedon_date DATE 10 √ NULL
closedon_userid BIGINT 19 √ NULL
m_appuser.id FK_closedon_useridR
total_charges_due_at_disbursement_derived DECIMAL 19,6 √ NULL
principal_disbursed_derived DECIMAL 19,6 0.000000
principal_repaid_derived DECIMAL 19,6 0.000000
principal_writtenoff_derived DECIMAL 19,6 0.000000
principal_outstanding_derived DECIMAL 19,6 0.000000
interest_charged_derived DECIMAL 19,6 0.000000
interest_repaid_derived DECIMAL 19,6 0.000000
interest_waived_derived DECIMAL 19,6 0.000000
interest_writtenoff_derived DECIMAL 19,6 0.000000
interest_outstanding_derived DECIMAL 19,6 0.000000
fee_charges_charged_derived DECIMAL 19,6 0.000000
fee_charges_repaid_derived DECIMAL 19,6 0.000000
fee_charges_waived_derived DECIMAL 19,6 0.000000
fee_charges_writtenoff_derived DECIMAL 19,6 0.000000
fee_charges_outstanding_derived DECIMAL 19,6 0.000000
penalty_charges_charged_derived DECIMAL 19,6 0.000000
penalty_charges_repaid_derived DECIMAL 19,6 0.000000
penalty_charges_waived_derived DECIMAL 19,6 0.000000
penalty_charges_writtenoff_derived DECIMAL 19,6 0.000000
penalty_charges_outstanding_derived DECIMAL 19,6 0.000000
total_expected_repayment_derived DECIMAL 19,6 0.000000
total_repayment_derived DECIMAL 19,6 0.000000
total_expected_costofloan_derived DECIMAL 19,6 0.000000
total_costofloan_derived DECIMAL 19,6 0.000000
total_waived_derived DECIMAL 19,6 0.000000
total_writtenoff_derived DECIMAL 19,6 0.000000
total_outstanding_derived DECIMAL 19,6 0.000000
total_overpaid_derived DECIMAL 19,6 √ NULL
rejectedon_date DATE 10 √ NULL
rejectedon_userid BIGINT 19 √ NULL
m_appuser.id FK_rejectedon_useridR
rescheduledon_date DATE 10 √ NULL
rescheduledon_userid BIGINT 19 √ NULL
withdrawnon_date DATE 10 √ NULL
withdrawnon_userid BIGINT 19 √ NULL
m_appuser.id FK_withdrawnon_useridR
writtenoffon_date DATE 10 √ NULL
loan_transaction_strategy_id BIGINT 19 √ NULL
ref_loan_transaction_processing_strategy.id FK_loan_ltp_strategyR
sync_disbursement_with_meeting BIT 1 √ NULL
loan_counter SMALLINT 5 √ NULL
loan_product_counter SMALLINT 5 √ NULL
fixed_emi_amount DECIMAL 19,6 √ NULL
max_outstanding_loan_balance DECIMAL 19,6 √ NULL
grace_on_arrears_ageing SMALLINT 5 √ NULL
is_npa BIT 1 b'0'
total_recovered_derived DECIMAL 19,6 √ NULL
accrued_till DATE 10 √ NULL
interest_recalcualated_on DATE 10 √ NULL
days_in_month_enum SMALLINT 5 1
days_in_year_enum SMALLINT 5 1
interest_recalculation_enabled BIT 1 b'0'
guarantee_amount_derived DECIMAL 19,6 √ NULL
create_standing_instruction_at_disbursement BIT 1 √ NULL
version INT 10 1
writeoff_reason_cv_id INT 10 √ NULL
m_code_value.id FK_writeoffreason_m_loan_m_code_valueR
loan_sub_status_id SMALLINT 5 √ NULL
is_topup BIT 1 b'0'
is_equal_amortization BIT 1 b'0'
fixed_principal_percentage_per_installment DECIMAL 5,2 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
account_no Must be unique Asc account_no
external_id Must be unique Asc external_id
FK7C885877240145 Performance Asc fund_id
FK_approvedon_userid Performance Asc approvedon_userid
FK_closedon_userid Performance Asc closedon_userid
FK_disbursedon_userid Performance Asc disbursedon_userid
FK_glim_id Performance Asc glim_id
FK_loan_ltp_strategy Performance Asc loan_transaction_strategy_id
fk_m_group_client_001_idx Performance Asc/Asc group_id + client_id
FK_m_loan_m_staff Performance Asc loan_officer_id
FK_m_loanpurpose_codevalue Performance Asc loanpurpose_cv_id
FK_rejectedon_userid Performance Asc rejectedon_userid
FK_submittedon_userid Performance Asc submittedon_userid
FK_withdrawnon_userid Performance Asc withdrawnon_userid
FK_writeoffreason_m_loan_m_code_value Performance Asc writeoff_reason_cv_id
FKB6F935D87179A0CB Performance Asc client_id
FKB6F935D8C8D4B434 Performance Asc product_id
group_id Performance Asc group_id

Relationships

Close relationships within degrees of separation