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
1904030095,3-Apr-2019,T190049393,51114072,Confirmed,,Live,,14-Jan-2019,14-Jan-2024,,100000.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,5,ISUBSTFC40285520,3-Apr-2019,0,100000.00,VIRENDRA GUPTA ,JUHU CHURCH ROAD,C 201 KAILASH APARTMENTS,JUHU,MUMBAI,MAHARASHTRA,400049,,9821184897,,M,100000.00,20-10-56,ABOPG8002F,,,FIXED DEPOSIT RECEIPT,100000.00,100000.00,,0.00,,,UnPaid - Valid,,,3-Apr-2019,TAX MASTER IS NOT DEFINED AS ON 07 Dec 2020,,,,,,211973,CLASSIQUE  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,,,,,60
1904040031,4-Apr-2019,1904040001,51113602,ILU CASES-Confirmed,ILU,Live,,12-Apr-2018,12-Apr-2021,,190230.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,3,IDEPSTFC50900415,4-Apr-2019,0,150000.00,RITESH V SHAH,"NEW SAMADHAN APT,SENAPATI BAPAT MARG,","B/403,",DADAR (W),MUMBAI,MAHARASHTRA,400028,,9821638670,4ALL.RITESH@GMAIL.COM,M,150000.00,05-02-83,AWGPS3417D,,,SPECIAL DEPOSIT RECEIPT,150000.00,150000.00,,0.00,,,UnPaid - No Commission Data,,,4-Apr-2019,,,,,,,211973,CLASSIQUE  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,,,,,36
1907260240,26-Jul-2019,1907260004,51185876,ILU CASES-Confirmed,ILU,Live,,20-Dec-2018,20-Dec-2021,,50000.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,3,IDEPSTFC51038823,26-Jul-2019,0,50000.00,VIJAY MEHRA ,N S RD NO 2 JVPD SCHEME VILE PARLE W,402 SHUBHANGAN PLOT NO 14,TEL 9322544468,MUMBAI,MAHARASHTRA,400056,,,,M,50000.00,10-10-44,AHFPM8937Q,,,FIXED DEPOSIT RECEIPT,50000.00,50000.00,,0.00,,,UnPaid - No Commission Data,,,26-Jul-2019,,,,,,,211973,CLASSIQUE  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,85520,SHEETAL BHIMSANDESH KAMBLE,,,36
1907260239,26-Jul-2019,1907260003,51185875,ILU CASES-Confirmed,ILU,Live,,19-Sep-2018,19-Sep-2021,,25000.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,3,IDEPSTFC50977512,26-Jul-2019,0,25000.00,VIJAY MEHRA ,N S RD NO 2 JVPD SCHEME VILE PARLE W,402 SHUBHANGAN PLOT NO 14,TEL 9322544468,MUMBAI,MAHARASHTRA,400056,,,,M,25000.00,10-10-44,AHFPM8937Q,,,FIXED DEPOSIT RECEIPT,25000.00,25000.00,,0.00,,,UnPaid - No Commission Data,,,26-Jul-2019,,,,,,,211973,CLASSIQUE  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,85520,SHEETAL BHIMSANDESH KAMBLE,,,36
1907310639,31-Jul-2019,1907310001,51189225,ILU CASES-Confirmed,ILU,Live,,2-Nov-2018,2-Nov-2021,,100000.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,3,IDEPSTFC51011401,31-Jul-2019,0,100000.00,LOURDINA FERNANDES ,2ND FLOOR,52 3RD MARINE STREET,MARINE LINES,MUMBAI,MAHARASHTRA,400002,,9769837113,,F,100000.00,23-05-50,AATPF7040A,,,FIXED DEPOSIT RECEIPT,100000.00,100000.00,,0.00,,,UnPaid - No Commission Data,,,31-Jul-2019,,,,,,,211973,CLASSIQUE  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,85520,SHEETAL BHIMSANDESH KAMBLE,,,36
1907260236,26-Jul-2019,1907260001,51185873,ILU CASES-Confirmed,ILU,Live,,20-Jun-2018,20-Jun-2021,,30000.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,3,IDEPSTFC50922070,26-Jul-2019,0,30000.00,VIJAY MEHRA ,N S RD NO 2 JVPD SCHEME VILE PARLE W,402 SHUBHANGAN PLOT NO 14,TEL 9322544468,MUMBAI,MAHARASHTRA,400056,,,,M,30000.00,10-10-44,AHFPM8937Q,,,FIXED DEPOSIT RECEIPT,30000.00,30000.00,,0.00,,,UnPaid - No Commission Data,,,26-Jul-2019,,,,,,,211973,CLASSIQUE  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,85520,SHEETAL BHIMSANDESH KAMBLE,,,36
1907260238,26-Jul-2019,1907260002,51185874,ILU CASES-Confirmed,ILU,Live,,27-Jul-2018,27-Jul-2021,,20000.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,3,IDEPSTFC50939028,26-Jul-2019,0,20000.00,VIJAY MEHRA ,N S RD NO 2 JVPD SCHEME VILE PARLE W,402 SHUBHANGAN PLOT NO 14,TEL 9322544468,MUMBAI,MAHARASHTRA,400056,,,,M,20000.00,10-10-44,AHFPM8937Q,,,FIXED DEPOSIT RECEIPT,20000.00,20000.00,,0.00,,,UnPaid - No Commission Data,,,26-Jul-2019,,,,,,,211973,CLASSIQUE  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,85520,SHEETAL BHIMSANDESH KAMBLE,,,36
1911190501,19-Nov-2019,1911190002,51245314,ILU CASES-Confirmed,ILU,CLOSED,,16-Oct-2017,16-Oct-2020,,63410.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,3,IDEPSTFC50829201,19-Nov-2019,0,50000.00,DEEPA RAMESH PUNJABI,"BELFER, 147 WATER FIELD ROAD","FLAT NO. 6, 1ST FLOOR",OPP  ICICI BANK,BANDRA WEST,MAHARASHTRA,400050,,9870411717,SUNJAY_29@YAHOO.IN,F,50000.00,05-09-49,AABPP5490N,,,SPECIAL DEPOSIT RECEIPT,50000.00,50000.00,,0.00,,,UnPaid - No Commission Data,,,19-Nov-2019,,,,,,,211973,CLASSIQUE  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,,,,,36
