TR NO.,TR PUNCH DATE,LI Receipt No/UNO Receipt No,Policy No/Certificate No,SFS TR Status,SFS TR Status Remarks,Certificate Status,Pending Requirements,Policy Issue Date,Maturity Date,Invested Interest Rate,Maturity Amount,TR PRODUCT,COMPANY NAME,TR Company.Ref Code,TR PLAN NAME,Tax Free Bond,Transaction Nature,Policy Term,Bank Name,Cheque Date,Cheque No.,Cheque Amount,Customer Name,House No. & Street Name,Building / Society Name,Area,City,state,Pincode,Phone Number,Mobile Number,E-Mail ID,Gender,Receipt Amount,Date Of Birth,PAN Number,Aadhaar Number,MIS MAIN TYPE,MIS SUB TYPE,MIS POLICY AMT.,MIS APE AMT.,MIS COMM. %,MIS COMM. AMT.,Gross Comm Amt,Comm ST Amt,COMM PAYMENT REMARKS,Comm Payment Ref No,Comm Pay Mode,Comm Pay Date,REASON FOR NON-PAYMENT,Chq/NEFT NO,PAYMENT REF. NO.,Comm Cycle Name,Paid Bank Name,Paid Account No,TR BA/CP CODE,TR BA/CP NAME,TR CHANNEL,TR Location Type,Reporting Code,Reporting Name,Type,INSTALMENT_NUMBER,Tenure
1509301443,30-Sep-2015,1509300010,50503944,Confirmed,,Live,,24-Jul-2015,24-Jul-2018,,63433.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,3,IDEPSTFC4830705,30-Sep-2015,0,48315.00,TANAZ K PATRAWALA,LBS MARG VIKROLI W,F-39 GODREJ HILL SIDE COLONY,VIKROLI W,MUMBAI,MAHARASHTRA,400079,,0000000000,,F,48315.00,01-07-82,ANFPK3759E,,,SPECIAL DEPOSIT RECEIPT,48315.00,48315.00,,725.00,,,UnPaid - No Commission Data,,,30-Sep-2015,,,,,,,195906,TULIP  INVESTMENTS,BUSINESS PARTNER,ASSISTANT MANAGER-CUSTOMER SERVICE,5670,MAYUR MOHAN JAGTAP,,,36
1507160448,16-Jul-2015,1507160003,50469108,Cancelled,,CLOSED,,15-Jul-2015,15-Jul-2018,,100000.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,3,BANK OF INDIA,15-Jul-2015,000016,100000.00,GLADIS  PICARDO,"J P ROAD, VERSOVA","A/706 EVEREST BLDG, OPP GANGA BHAVAN",ANDHERI (W),MUMBAI,MAHARASHTRA,400061,02226311449,,,F,100000.00,25-03-46,AFYPP1421P,,,FIXED DEPOSIT RECEIPT,100000.00,100000.00,,-1500.00,,,UnPaid - No Commission Data,,,15-Jul-2015,,,,,,,195906,TULIP  INVESTMENTS,BUSINESS PARTNER,ASSISTANT MANAGER-CUSTOMER SERVICE,5670,MAYUR MOHAN JAGTAP,,,36
1507090645,9-Jul-2015,,IDEP,Cancelled,,,,,,,,INVESTMENT,SHRIRAM CITY UNION FINANCE COMPANY LTD,SCUF,DEPOSIT,NO,,,,,,,BHAGWANT PANDHARINATH BHARGAWE,PLOT NO-10 BRAHMAN SEVA SANGH,203 CHINTAMAN DIWAKAR CHS,NAUPADA,THANE (W),MAHARASHTRA,400602,,9769540878,,M,40000.00,25-06-55,AAGPB5389K,,SCUF DEPOSITS FIXED,FIXED DEPOSIT RECEIPT,40000.00,40000.00,0,0,0,,,,,,,,,,,,195906,TULIP  INVESTMENTS,BUSINESS PARTNER,ASSISTANT MANAGER-CUSTOMER SERVICE,,,,,36
1509010186,1-Sep-2015,,IDEP,Cancelled,,,,,,,,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,,,,,,LEENA AVINASH  VARDE,JUHU ROAD,E-16 JUHU APARTMENTS,SANTACRUZ WEST,MUMBAI,MAHARASHTRA,400049,,0000000000,,F,34519.00,22-11-37,ABZPV8488M,,STFC DEPOSITS SPECIAL,SPECIAL DEPOSIT RECEIPT,34519.00,34519.00,0,0,0,,,,,,,,,,,,195906,TULIP  INVESTMENTS,BUSINESS PARTNER,ASSISTANT MANAGER-CUSTOMER SERVICE,5670,MAYUR MOHAN JAGTAP,,,36
1509010188,1-Sep-2015,,IDEP,Cancelled,,,,,,,,INVESTMENT,SHRIRAM CITY UNION FINANCE COMPANY LTD,SCUF,DEPOSIT,NO,,,,,,,JOHN F X RODRIGUES,FLAT NO 11 2ND FLOOR,SHANTIVANAM 23-B PALI RD,BANDRA WEST,MUMBAI,MAHARASHTRA,400050,26553396,,,M,35000.00,03-12-48,AANPR5663D,,SCUF DEPOSITS FIXED,FIXED DEPOSIT RECEIPT,35000.00,35000.00,0,0,0,,,,,,,,,,,,195906,TULIP  INVESTMENTS,BUSINESS PARTNER,ASSISTANT MANAGER-CUSTOMER SERVICE,5670,MAYUR MOHAN JAGTAP,,,36
1510130605,13-Oct-2015,,IDEP,Cancelled,,,,,,,,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,,,,,,KATY PESY GHODAWALA,LALBAUG,"NOWROZE BAUG, G BLOCK NO. 3,",DR.S S RAO ROAD,MUMBAI,MAHARASHTRA,400012,022-24713231,0000000000,,F,50000.00,22-01-32,AJVPG4591L,,SENIOR CITIZEN FIXED,FIXED DEPOSIT RECEIPT,50000.00,50000.00,0,0,0,,,,,,,,,,,,195906,TULIP  INVESTMENTS,BUSINESS PARTNER,ASSISTANT MANAGER-CUSTOMER SERVICE,5670,MAYUR MOHAN JAGTAP,,,36
