LOS029 Disbursement MIS
The objective of this report is to provide the disbursement details of each application.
| Field | Description | Remarks | Table | Column/Logic |
|
loan_account_no
|
Loan application no | common_los.applications | direct - loan_application_no | |
|
application_no
|
Application No | common_los.applications | direct - application_no | |
|
customer_name
|
Name of customer | common_los.customers | logic - combination of first_name, middle_name, last_name | |
| CIF Id | Customer No | common_los.customers | direct - customer_no | |
|
mobile_no
|
Mobile no of customer | common_los.customers | direct - mobile_no | |
|
branch_code
|
Branch Code | master.branch | direct - branch_code | |
|
branch_name
|
Branch Name | master.branch | direct - branch_name | |
|
state_for_business
|
State Name | master.branch | direct - state | |
|
business_year
|
Current Business Year | logic | ||
|
current_month
|
Current month | logic | ||
|
current_quarter
|
current quarter | logic | ||
|
product_name
|
Name of the product | master.product |
direct - product_name |
|
|
sub_product
|
Name of the scheme |
master.scheme |
direct - scheme_name |
|
|
sanctioned_amount
|
Sanctioned Amount |
common_los.applications |
direct - sanctioned_amount |
|
|
disbursed_amount
|
Disbursed Amount |
common_los.applications |
direct - disbursed_amount |
|
|
lan_creation_date
|
LAN Generation Date |
common_los.applications |
direct - sanctioned_date |
|
|
sanctioned_date
|
Sanctioned Date |
common_los.applications |
direct - sanctioned_date |
|
|
disbursed_date
|
Date at which amount is disbursed |
common_los.applications |
direct - disbursed_date |
|
|
first_disbursement_date
|
Date at which amount is first disbursed |
common_los.disbursal_schedule |
direct - due_date |
|
|
rate_in_current
|
||||
| rate_type | ||||
|
first_interest_reset_date
|
||||
|
next_interest_reset_date
|
||||
|
reset_frequency
|
||||
|
disbursement_type
|
||||
|
repayment_mode
|
||||
|
tranche_no
|
||||
|
benchmark_type
|
||||
|
benchmark_rate
|
||||
| spread | ||||
|
emi_amount
|
||||
| frequency | ||||
|
emi_cycle_date
|
||||
| tenure | ||||
|
stamping_charges
|
||||
|
processing_fees
|
||||
|
legal_charges
|
||||
|
valuation_charges
|
||||
|
rcu_charges
|
||||
|
cattle_insurance_charges
|
||||
|
general_insurance_charges
|
||||
|
life_insurance_charges
|
||||
|
health_insurance_charges
|
||||
|
collateral_name
|
||||
|
scheme_name_and_code
|
||||
|
Soucing Reporting Manager Name
|
||||
|
Soucing Reporting Manager Code
|
||||
|
Sourcing Code
|
||||
|
Sourcing Name
|
||||
|
Sourcing Number
|
||||
|
Sourcing Designation
|
||||
|
credit_decision_final_approval_id
|
||||
|
credit_decision_final_approval_name
|
||||
|
DIC Name
|
||||
| DIC Id | ||||
| DIC Date | ||||
|
DIM Name
|
||||
| DIM Id | ||||
| DIM Date | ||||
|
nature_of_loan
|
||||
|
parent_first_loan_number
|
||||
|
loan_tagging
|
||||
| BC Name | ||||
|
Payment Reference/UTR Number
|
||||
|
payment_status
|
||||
|
cumulative_monthly_disbursement
|
||||
|
cumulative_ytd_disbursement
|
||||
|
disbursement_dates_for_all_tranches
|