Loan
Download as DOCX, PDF
0 likes202 views
This document outlines the loan application process, including collecting customer information, verifying documents, and generating customer details. It lists required identity documents like a passport, voter ID, and pan card. Address proof documents like a ration card, electricity bill, or property tax receipts are also needed. Other documents include a mortgage document. The loan amount is based on the customer's required amount and selected period to repay in installments.
Loan
- 1. 4.Loan application to collect all customer information. document verification. o Reports generates customer detail to the applying for loan. customer master Id Int (primary key) cust_name Varchar(25) cust_add Varchar(40) cust_dob Date Sex Varchar(1) Occuption Varchar(10) Contact_no Varchar(10) created by:-Ashish lakhani Page 1
- 2. 4.Loan document required given documents by identity:- - passport - recent passport size photo - voters id card - driving license - pan card by address proof:- - ration card - electricity bill - lease agreement - trade license - sales tax certificate - proof of agriculture land/ - property-tax receipts. others:- - mortgage document this all document are required to the mortgage purpose and financial condition of customer . created by:-Ashish lakhani Page 2
- 3. 4.Loan loan amount used to required amount of the customer. period of amount s are used to how long time to take. loan_amount_master Id Int (primary key) cust_name Varchar(25) Date Date Loan_amount Int Installments Int created by:-Ashish lakhani Page 3