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
1602220237,22-Feb-2016,1602220001,40310972,ILU CASES-Closed,ILU,Live,,27-Oct-2013,27-Nov-2018,,30000.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,SUB DEBENTURE,NO,,5,ISUBSTFC40270850,22-Feb-2016,0,30000.00,ARMAITY KEKI NAMVER,,A-7 JER BAUG,BYCULLA (E),MUMBAI,MAHARASHTRA,400027,,9892085752,,F,30000.00,29-12-41,AAEPN0436F,,,FIXED DEPOSIT RECEIPT,30000.00,30000.00,,0.00,,,UnPaid - No Commission Data,,,22-Feb-2016,,,,,,,139288,ABN  SECURITIES,BUSINESS PARTNER,ASSISTANT MANAGER-CUSTOMER SERVICE,,,,,61
1510300496,30-Oct-2015,1510300001,50520494,ILU CASES-Closed,ILU,CLOSED,,1-Aug-2013,1-Aug-2016,,100000.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,3,IDEPSTFC50089122,30-Oct-2015,0,100000.00,RAJANI RAMESH GADKARI,CROSS ROAD NO.7,"A-401, ADITYA, GULMOHAR",JUHU SCHEME,MUMBAI,MAHARASHTRA,400049,,9819890732,,F,100000.00,23-09-38,AIKPG4190M,,,FIXED DEPOSIT RECEIPT,100000.00,100000.00,,0.00,,,UnPaid - No Commission Data,,,30-Oct-2015,,,,,,,139288,ABN  SECURITIES,BUSINESS PARTNER,ASSISTANT MANAGER-CUSTOMER SERVICE,5596,SHAH SANDEEP VIJAY,,,36
1506090781,9-Jun-2015,1506090001,50697680,ILU CASES-Closed,ILU,CLOSED,,9-Mar-2013,9-Mar-2016,,100000.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEBENTURE,NO,,3,IDBNSTFC50649060,9-Jun-2015,0,100000.00,SAROJ  R SHAH,MULJI LAKHAMSHI BLDG,"1/3 MINT ROAD, 3RD FLOOR",FORT OPP. GPO,MUMBAI,MAHARASHTRA,400001,,0000000000,,F,100000.00,23-12-41,BLYPS1891M,,,FIXED DEPOSIT RECEIPT,100000.00,100000.00,,0.00,,,UnPaid - No Commission Data,,,9-Jun-2015,,,,,,,139288,ABN  SECURITIES,BUSINESS PARTNER,ASSISTANT MANAGER-CUSTOMER SERVICE,5596,SHAH SANDEEP VIJAY,,,36
1603100498,10-Mar-2016,1603100014,50581156,ILU CASES-Confirmed,ILU,CLOSED,,24-Jul-2014,24-Jul-2017,,20000.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,3,IDEPSTFC50271781,10-Mar-2016,0,20000.00,LAURA F D'MELLO,FOUR BUNGLOWS,"B/104 SAI SADAN,RATAN NAGAR",ANDHERI (WEST),MUMBAI,MAHARASHTRA,400053,26356368,9833468522,,F,20000.00,12-10-52,ALPPD1788C,,,FIXED DEPOSIT RECEIPT,20000.00,20000.00,,0.00,,,UnPaid - No Commission Data,,,10-Mar-2016,,,,,,,139288,ABN  SECURITIES,BUSINESS PARTNER,ASSISTANT MANAGER-CUSTOMER SERVICE,7556,NARENDRA CHANDRAKANT SHINDE,,,36
1504180299,18-Apr-2015,,IDEP,Cancelled,,,,,,,,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,,,,,,CLIFFORD PICARDO ,VERSOVA,A/706 EVERST,"YARI ROAD, ANDHERI WEST",MUMBAI,MAHARASHTRA,400061,,,,M,25000.00,13-12-36,AOHPP4637B,,SENIOR CITIZEN FIXED,FIXED DEPOSIT RECEIPT,25000.00,25000.00,0,0,0,,,,,,,,,,,,139288,ABN  SECURITIES,BUSINESS PARTNER,ASSISTANT MANAGER-CUSTOMER SERVICE,5596,SHAH SANDEEP VIJAY,,,36
