{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Main","SUM.Channel","SUMMARY","InSum","InCo","AGCOM","TRCOM"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":1,"pivot_tables":2},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Main","index":0,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,7,2,9],[1,0,1,3]]}
["IPAddress:","http://192.168.82.6:8099/RiskkSvc"]
["COMMISSION FUNDING SUMMARY"]
[null,null,null,null,"Batch Export",null,null,"Position"]
[null,"Start Date:",{"$f":"EOMONTH(EndDate,-1)+1","v":"2021-02-01"},null,"No","Company","Company Name","Export","File Name Format","File Date Format"]
[null,"End of Month Date:","2021-02-28",null,1,"NAMM",{"$f":"VLOOKUP(F5,InCo!A:C,3,0)","v":"Nomura Asset Management Malaysia Sdn. Bhd."},"Yes",{"$f":"F5&\"-Commission_Funding_Summary\"","v":"NAMM-Commission_Funding_Summary"},"dd-MMM-yyyy"]
[null,"Days:",{"$f":"EndDate-StartDate+1","v":28},null,2,"NIAM",{"$f":"VLOOKUP(F6,InCo!A:C,3,0)","v":"Nomura Islamic Asset Management Sdn. Bhd."},"Yes",{"$f":"F6&\"-Commission_Funding_Summary\"","v":"NIAM-Commission_Funding_Summary"},"dd-MMM-yyyy"]
[null,"Company ID:","NIAM",null,3]
[null,"Company Name:",{"$f":"VLOOKUP(CompanyID,InCo!A:C,3,0)","v":"Nomura Islamic Asset Management Sdn. Bhd."}]
[null,"Output Path:","ThisWorkbook.Path"]

{"sheet":"SUM.Channel","index":1,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,4],[2,0,2,4],[4,0,4,2]]}
["Nomura Islamic Asset Management Sdn. Bhd."]
[]
["COMMISSION PAYMENT FOR ALL AGENTS FROM 01-Feb-2021 TO 28-Feb-2021 (Feb 2021)"]
[]
["CHANNEL NAME"]
[" ","Currency","ChannelName"]
[null,"MYR"]
["PAYMENT DATE","IUTA","DIRECT AGENTS"]
["1900-01-02",6708.12,4505.1500000000005]
["Grand Total",6708.12,4505.1500000000005]

{"sheet":"SUMMARY","index":2,"n_rows":12,"n_cols":24,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Nomura Islamic Asset Management Sdn. Bhd."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Values"]
["Currency","SL NO","AGENT CODE","AGENT NAME","AGENCY GROUP","ACC NO","NEW NRIC","OLD NRIC","BANK NAME","BANK BRANCH NAME","GST STATUS","Remarks","PAYMENT REF NO","PAYMENT DATE","CHANNEL NAME","PAY MODE","AG COM","OAG COM","OTR COM","TR COM","COMM ADJ"," TOTAL","GST AMOUNT","TOTAL + GST "]
["COMMISSION PAYMENT FOR ALL AGENTS FROM 01-Feb-2021 TO 28-Feb-2021 (Feb 2021) MYR"]
["MYR",1,"NIMIFAST01","IFAST CAPITAL SDN BHD","IFAST01"," ","782978-H"," "," "," ","Not Registered"," "," ","1900-01-02","IUTA","DIRECT CREDIT",0,0,0,6202.52,0,0,0,6202.52]
["MYR",3,"NIMMR01","NOMURA ISLAMIC ASSET MANAGEMENT SDN BHD","NIMMR01"," "," "," "," "," ","Not Registered"," "," ","1900-01-02","DIRECT AGENTS","DIRECT CREDIT",0,0,0,1195.6400000000001,0,0,0,1195.6400000000001]
["MYR",4,"NIMMR02","NOMURA ISLAMIC ASSET MANAGEMENT SDN BHD-MR02","NIMMR02"," ","838564-7"," "," "," ","Not Registered"," "," ","1900-01-02","DIRECT AGENTS","DIRECT CREDIT",0,0,0,3309.51,0,0,0,3309.51]
["MYR",5,"NIMPHMB001","PHILLIP MUTUAL BERHAD","PHMB001"," ","570409-K"," "," "," ","Not Registered"," "," ","1900-01-02","IUTA","DIRECT CREDIT",0,0,0,30.67,0,0,0,30.67]
["MYR",6,"NIMUOBKH01","UOB KAY HIAN SECURITES (M) SDN BHD","UOBKH01"," ","194990-K"," "," "," ","Not Registered"," "," ","1900-01-02","IUTA","DIRECT CREDIT",0,0,0,231.74,0,0,0,231.74]
["MYR",2,"NIMKIB0001","KENANGA INVESTORS BERHAD","KIB0001"," "," "," "," "," ","Not Registered"," "," ","1900-01-02","IUTA","DIRECT CREDIT",0,0,0,243.19,0,0,0,243.19]
["MYR Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,11213.270000000002,0,0,0,11213.270000000002]

{"sheet":"InSum","index":3,"n_rows":8,"n_cols":25,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[]
["SLNo","qAgentCode","AgentName","qAgencyCode","qBankAccount","FMUTM","NRIC_OLD","BankName","BankBranch","AGCom","OAGCom","OTRCom","TRCom","ComAdj","Total","GST_Status","GSTAmt","TotalComPlusGST","Remarks","VoucherNo","PaymentDate","ChannelName","PayMode","Currency","CurGroup"]
[1,"NIMIFAST01","IFAST CAPITAL SDN BHD","IFAST01"," ","782978-H"," "," "," ",0,0,0,6202.52,0,null,"Not Registered",0,6202.52," "," ","1900-01-02","IUTA","DIRECT CREDIT","MYR","COMMISSION PAYMENT FOR ALL AGENTS FROM 01-Feb-2021 TO 28-Feb-2021 (Feb 2021) MYR"]
[2,"NIMKIB0001","KENANGA INVESTORS BERHAD","KIB0001"," "," "," "," "," ",0,0,0,243.19,0,null,"Not Registered",0,243.19," "," ","1900-01-02","IUTA","DIRECT CREDIT","MYR","COMMISSION PAYMENT FOR ALL AGENTS FROM 01-Feb-2021 TO 28-Feb-2021 (Feb 2021) MYR"]
[3,"NIMMR01","NOMURA ISLAMIC ASSET MANAGEMENT SDN BHD","NIMMR01"," "," "," "," "," ",0,0,0,1195.6400000000001,0,null,"Not Registered",0,1195.6400000000001," "," ","1900-01-02","DIRECT AGENTS","DIRECT CREDIT","MYR","COMMISSION PAYMENT FOR ALL AGENTS FROM 01-Feb-2021 TO 28-Feb-2021 (Feb 2021) MYR"]
[4,"NIMMR02","NOMURA ISLAMIC ASSET MANAGEMENT SDN BHD-MR02","NIMMR02"," ","838564-7"," "," "," ",0,0,0,3309.51,0,null,"Not Registered",0,3309.51," "," ","1900-01-02","DIRECT AGENTS","DIRECT CREDIT","MYR","COMMISSION PAYMENT FOR ALL AGENTS FROM 01-Feb-2021 TO 28-Feb-2021 (Feb 2021) MYR"]
[5,"NIMPHMB001","PHILLIP MUTUAL BERHAD","PHMB001"," ","570409-K"," "," "," ",0,0,0,30.67,0,null,"Not Registered",0,30.67," "," ","1900-01-02","IUTA","DIRECT CREDIT","MYR","COMMISSION PAYMENT FOR ALL AGENTS FROM 01-Feb-2021 TO 28-Feb-2021 (Feb 2021) MYR"]
[6,"NIMUOBKH01","UOB KAY HIAN SECURITES (M) SDN BHD","UOBKH01"," ","194990-K"," "," "," ",0,0,0,231.74,0,null,"Not Registered",0,231.74," "," ","1900-01-02","IUTA","DIRECT CREDIT","MYR","COMMISSION PAYMENT FOR ALL AGENTS FROM 01-Feb-2021 TO 28-Feb-2021 (Feb 2021) MYR"]

{"sheet":"InCo","index":4,"n_rows":4,"n_cols":13,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
["qCompanyID","CompanyCode","CompanyName","RegisterRef","Address","qCityID","PostCode","qStateID","qCountryID","Tel","Fax","Email","Website"]
["NAMM","NAMM","Nomura Asset Management Malaysia Sdn. Bhd.","200601028939 (748695-A)","Menara IMC, Level 12, Suite 12.2, No. 8 Jalan Sultan Ismail","Kuala Lumpur",50250,"Wilayah Persekutuan","MY","+603 2027 6688           ","+603 2027 6624           "," "," "]
["NIAM","NIAM","Nomura Islamic Asset Management Sdn. Bhd.","200801037222 (838564-T)","Menara IMC, Level 12, Suite 12.2, No. 8 Jalan Sultan Ismail","Kuala Lumpur",50250,"Wilayah Persekutuan","MY","+603 2027 6688           ","+603 2027 6624           "," "," "]

{"sheet":"AGCOM","index":5,"n_rows":2,"n_cols":26,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["",null,"","","","","","","","","","","","","","","","","","","","","","","",""]
["SL NO","MASTER_AC_NO","AC_NO","INVESTOR_NAME","FUND_CODE","EPF_FLAG","REF_NO","EFF_DT","ALLOCATION_DT","TXN_TYP","TXN_DESC","AGENT_CD","AGENT_NAME","INVEST_AMT","UNITS","RATE","COMM_AMT","AGENT_RANK","DOWNLINE","GROSS_SALES_CHARGE","DISCOUNT","COMMISSION _TYPE","PMNT_REF_NO","PMNT_DT","CHANNEL_NAME","CURRENCY"]

{"sheet":"TRCOM","index":6,"n_rows":30,"n_cols":19,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,18],[1,0,1,1]]}
["Nomura Islamic Asset Management Sdn. Bhd."]
["",null,"","","","","","","","","","","","","","","","",""]
["SL NO","BROKER_CD","AGENT_RANK","DOWNLINE","AC_NO","FUND_CODE","EPF_FLAG","START_DT","UPTO_DT","NO_DAYS","BAL_UNITS","AVG_NAV","BROKERAGE_RATE","COMM_AMT","COMM_TYPE","PMNT_REF_NO","PMNT_DT","CHANNEL_NAME","CURRENCY"]
[1,"NIMIFAST01",1,"NIMIFAST01",5061243756,"I-CASH","CASH","2021-02-01","2021-02-28",28,9275160.9900000002,1.0265071428571424,0.10000000000000005,755.59,"TRCOM",null,null,"IUTA","MYR"]
[2,"NIMIFAST01",1,"NIMIFAST01",5061243756,"I-INCOME","CASH","2021-02-01","2021-02-28",28,52713169.840000004,1.1238642857142858,0.11499999999999998,5446.92,"TRCOM",null,null,"IUTA","MYR"]
[3,"NIMKIB0001",1,"NIMKIB0001",5062665883,"I-CASH","CASH","2021-02-01","2021-02-28",28,216171.13,1.0265071428571424,0.10000000000000005,23,"TRCOM",null,null,"IUTA","MYR"]
[4,"NIMKIB0001",1,"NIMKIB0001",5062665883,"I-INCOME","CASH","2021-02-01","2021-02-28",28,2210596.86,1.1238642857142858,0.11499999999999998,220.19,"TRCOM",null,null,"IUTA","MYR"]
[5,"NIMMR01",1,"NIMMR01",5062598554,"I-CASH","CASH","2021-02-01","2021-02-28",28,21704292.18,1.0265071428571424,6.9999999999999965E-2,379.12,"TRCOM",null,null,"DIRECT AGENTS","MYR"]
[6,"NIMMR01",1,"NIMMR01",5062598505,"I-CASH","CASH","2021-02-01","2021-02-28",28,21704292.18,1.0265071428571424,6.9999999999999965E-2,107.67,"TRCOM",null,null,"DIRECT AGENTS","MYR"]
[7,"NIMMR01",1,"NIMMR01",5062565193,"I-CASH","CASH","2021-02-01","2021-02-28",28,21704292.18,1.0265071428571424,6.9999999999999965E-2,316.99,"TRCOM",null,null,"DIRECT AGENTS","MYR"]
[8,"NIMMR01",1,"NIMMR01",5062565155,"I-CASH","CASH","2021-02-01","2021-02-28",28,21704292.18,1.0265071428571424,6.9999999999999965E-2,391.86,"TRCOM",null,null,"DIRECT AGENTS","MYR"]
[9,"NIMMR02",1,"NIMMR02",5062586465,"I-CASH","CASH","2021-02-01","2021-02-28",28,21670181.039999999,1.0265071428571424,6.9999999999999965E-2,27.22,"TRCOM",null,null,"DIRECT AGENTS","MYR"]
[10,"NIMMR02",1,"NIMMR02",5062582856,"I-CASH","CASH","2021-02-01","2021-02-28",28,21670181.039999999,1.0265071428571424,6.9999999999999965E-2,42.11,"TRCOM",null,null,"DIRECT AGENTS","MYR"]
[11,"NIMMR02",1,"NIMMR02",5062661481,"I-CASH","CASH","2021-02-01","2021-02-28",28,21670181.039999999,1.0265071428571424,6.9999999999999965E-2,167.04,"TRCOM",null,null,"DIRECT AGENTS","MYR"]
[12,"NIMMR02",1,"NIMMR02",5062570461,"I-CASH","CASH","2021-02-01","2021-02-28",28,21670181.039999999,1.0265071428571424,6.9999999999999965E-2,108.17,"TRCOM",null,null,"DIRECT AGENTS","MYR"]
[13,"NIMMR02",1,"NIMMR02",5062570494,"I-CASH","CASH","2021-02-01","2021-02-28",28,21670181.039999999,1.0265071428571424,6.9999999999999965E-2,118.49,"TRCOM",null,null,"DIRECT AGENTS","MYR"]
[14,"NIMMR02",1,"NIMMR02",5062628271,"I-CASH","CASH","2021-02-01","2021-02-28",28,21670181.039999999,1.0265071428571424,6.9999999999999965E-2,54.46,"TRCOM",null,null,"DIRECT AGENTS","MYR"]
[15,"NIMMR02",1,"NIMMR02",5062756683,"I-CASH","CASH","2021-02-01","2021-02-28",28,21670181.039999999,1.0265071428571424,6.9999999999999965E-2,290.27,"TRCOM",null,null,"DIRECT AGENTS","MYR"]
[16,"NIMMR02",1,"NIMMR02",5062775751,"I-CASH","CASH","2021-02-01","2021-02-28",28,21670181.039999999,1.0265071428571424,6.9999999999999993E-2,76.73,"TRCOM",null,null,"DIRECT AGENTS","MYR"]
[17,"NIMMR02",1,"NIMMR02",5062775682,"I-CASH","CASH","2021-02-01","2021-02-28",28,21670181.039999999,1.0265071428571424,6.9999999999999993E-2,57.55,"TRCOM",null,null,"DIRECT AGENTS","MYR"]
[18,"NIMMR02",1,"NIMMR02",5062530334,"I-INCOME","CASH","2021-02-01","2021-02-28",28,35264446.299999997,1.1238642857142858,8.0500000000000002E-2,1395.06,"TRCOM",null,null,"DIRECT AGENTS","MYR"]
[19,"NIMMR02",1,"NIMMR02",5062573544,"I-INCOME","CASH","2021-02-01","2021-02-28",28,35264446.299999997,1.1238642857142858,8.0500000000000002E-2,368.87,"TRCOM",null,null,"DIRECT AGENTS","MYR"]
[20,"NIMMR02",1,"NIMMR02",5062582845,"I-INCOME","CASH","2021-02-01","2021-02-28",28,35264446.299999997,1.1238642857142858,8.0500000000000002E-2,430.35,"TRCOM",null,null,"DIRECT AGENTS","MYR"]
[21,"NIMMR02",1,"NIMMR02",5062586465,"I-INCOME","CASH","2021-02-01","2021-02-28",28,35264446.299999997,1.1238642857142858,8.0500000000000002E-2,6.15,"TRCOM",null,null,"DIRECT AGENTS","MYR"]
[22,"NIMMR02",1,"NIMMR02",5062628271,"I-INCOME","CASH","2021-02-01","2021-02-28",28,35264446.299999997,1.1238642857142858,8.0500000000000002E-2,123.01,"TRCOM",null,null,"DIRECT AGENTS","MYR"]
[23,"NIMMR02",1,"NIMMR02",5062775751,"I-INCOME","CASH","2021-02-01","2021-02-28",28,35264446.299999997,1.1238642857142858,8.0500000000000002E-2,22.03,"TRCOM",null,null,"DIRECT AGENTS","MYR"]
[24,"NIMMR02",1,"NIMMR02",5062775682,"I-INCOME","CASH","2021-02-01","2021-02-28",28,35264446.299999997,1.1238642857142858,8.0500000000000002E-2,22.03,"TRCOM",null,null,"DIRECT AGENTS","MYR"]
[25,"NIMPHMB001",1,"NIMPHMB001",5062354081,"I-INCOME","CASH","2021-02-01","2021-02-28",28,352844.11,1.1238642857142858,9.200000000000004E-2,30.67,"TRCOM",null,null,"IUTA","MYR"]
[26,"NIMUOBKH01",1,"NIMUOBKH01",5062527424,"I-CASH","CASH","2021-02-01","2021-02-28",28,null,1.0265071428571424,0.10000000000000005,6.85,"TRCOM",null,null,"IUTA","MYR"]
[27,"NIMUOBKH01",1,"NIMUOBKH01",5062527424,"I-INCOME","CASH","2021-02-01","2021-02-28",28,2019052.47,1.1238642857142858,0.11499999999999998,224.89,"TRCOM",null,null,"IUTA","MYR"]