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 |
|||
|
sub_product
|
||||
|
sanctioned_amount
|
||||
|
disbursed_amount
|
||||
|
lan_creation_date
|
||||
|
sanctioned_date
|
||||
|
disbursed_date
|
||||
|
first_disbursement_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
|