Skip to main content

Itemised Report

MyDebit Daily Itemised Report

This is a daily file generated that contains all the MyDebit transactions by Participants. This can be used by Participants to reconcile transactions against the settlement, fee & tax amount.

File Format

File Extension.csv
Delimiter, (Comma character)
Text Qualifier" (Double quotes)
EncodingUTF-8
Line Break\n (Unix)

Sample Layout

settlement_cycle,product,transaction_type,initiation_time,completion_time,payer_fiid,payer_id,payer_name,receiver_fiid,receiver_id,receiver_name,mcc,trace_id,reference_id,transaction_status,response_code,transaction_amount,cashout_amount,cashout_fee,network_fee,interchange_fee,locaf_fee,foreign_currency,fx_rate,fx_reference_number,foreign_amount,iso_specific_1.approval_code,iso_specific_1.mti,iso_specific_1.eci,iso_specific_1.pcde,iso_specific_1.tpan,iso_specific_1.rv_code,iso_specific_1.oem_id,iso_specific_1.entry_mode,iso_specific_1.term_city,iso_specific_1.term_state,iso_specific_2.tran_datetime,additional_fields_1.original_reference_id
001,MYD,PUR,2025-07-30T22:30:18,2025-07-30T22:30:18,ALB,,,PYN,00005766,UIN Partners,8099,785037,221599336522,Declined,05,45.00,0.00,0.00,0.00,0.00,0.00,458,1.000000,,0.00,551643,0210,null,null,null,00,null,271,JHRBAHRU,01,2025-07-30T22:30:18,null
001,MYD,PUR,2025-07-30T22:30:24,2025-07-30T22:30:25,ALB,,,PYN,21506001,WRG International,5499,143922,447716054615,Approved,00,3.30,0.00,0.00,0.01,0.00,0.00,458,1.000000,,0.00,509946,0210,null,null,null,00,null,271,KLUMPUR,14,2025-07-30T22:30:24,null
001,MYD,RPRER,2025-07-30T22:30:26,2025-07-30T22:30:26,ALB,,,PYN,84167014,WPZ International,5542,141607,714653279928,Approved,00,50.00,0.00,0.00,0.03,0.05,0.00,458,1.000000,,0.00,499327,0420,null,null,null,01,null,271,SARAWAK,SAR,2025-07-30T22:30:26,null
001,MYD,PUR,2025-07-30T22:30:39,2025-07-30T22:30:39,ALB,,,PYN,16140229,DEF Company,5814,570800,428718439415,Approved,00,12.40,0.00,0.00,0.01,0.01,0.00,458,1.000000,,0.00,607015,0210,null,null,null,00,null,271,KOTA KINABALU,MY,2025-07-30T22:30:39,null

MyDebit Daily Itemised Report

Click to download sample CSV file.



Report Fields

Field NameOriginal Field (STAT09)Original Field (RECON)Field TypeDefinitionSample Data
1settlement_cycle--StringIdentifier of which cycle transaction was settled001
2product--StringProduct indicatorMYD
3transaction_typeTRAN DESCtxn-typeStringIdentifier for the type of service or transactionPUR
4initiation_timeDAT-TIM-Timestamp <yyyy-MM-ddThh:mm:ss>Timestamp for when transaction was initiated2024-12-05T14:22:33
5completion_timePOS-DAT-Timestamp <yyyy-MM-ddThh:mm:ss>Timestamp for when transaction was completed2024-12-05T14:23:01
6payer_fiidFI NAMEfiidStringIssuing Bank CodeA1234
7payer_idCARDHOLDER NUMBERcard-numStringCard Number4333123456789000
8payer_name--StringPayer Name<null>
9receiver_fiidFI NAMEfiidStringAcquiring Bank CodeA5678
10receiver_idTRM IDterm-idStringTerminal ID12345678
11receiver_nameATM TRM OWNER/POS RETLRretailer-idStringTerminal OwnerSUPER MARKET 789
12mccMCC-StringMerchant Category Code1234
13trace_idTRACE#acq-trace-num/iss-trace-numStringTrace ID set by issuer or acquirer123456
14reference_idSEQUENCE#rrnStringRetrieval Reference Number417413001047
15transaction_status--StringStatus of the transaction; Approved, Declined, Purcan, ReversalApproved
16response_codeSWI RESP-StringResponse code detailing the transaction status00
17transaction_amountTRAN/BAL/ORIG AMOUNTamt-1DecimalTransaction amount or reversed amount in MYR200.00
18cashout_amountCASH-AMTamt-2DecimalCash out amount0.00
19cashout_fee--DecimalCash out fee payable or receivable to/from FI counterpart0.00
20network_feeFEE-PAY (SWITCH FEE)-DecimalFee payable to PayNet0.50
21interchange_feeFEE-PAY/RCV (INTERCHANGE FEE)-DecimalFee payable or receivable to/from FI counterpart0.85
22locaf_fee--DecimalLOCAF fee payable or receivable to/from FI counterpart0.00
23foreign_currencyCRNCY-StringCurrency of foreign counterpart458
24fx_rateFOREX-DecimalForeign exchange rate set by settlement bank1.000000
25fx_reference_number--StringForeign exchange reference numberNUMBER007730
26foreign_amountFOREIGN-AMT-DecimalTransaction amount in foreign currency0.00
27iso_specific_1.approval_codeATM TO ACCT#/POS ACCT#/APPR CDE-StringApproval code set by Issuer123456
28iso_specific_1.mtiSWI TYP-StringMessage Type Indicator for transaction type0110
29iso_specific_1.eciECIeci-indicatorStringE-commerce indicator15
30iso_specific_1.pcdePCDE-StringE-commerce entry59
31iso_specific_1.tpanTOKEN PAN-StringTokenised PAN Number5078080011112222333
32iso_specific_1.rv_codeRV CDE-StringReversal Code by switchU7
33iso_specific_1.oem_id--StringIdentifier for wallet type used during transactionAPAY
34iso_specific_1.entry_modePOS-ENT-MOD-StringTransaction Entry Mode270
35iso_specific_1.term_cityTRM CITY-StringTerminal CityKLANG
36iso_specific_1.term_stateTRM ST-StringTerminal StateSEL
37iso_specific_2.tran_datetimeTRAN_DAT, TRAN_TIMEtran_dat, tran_timeTimestamp <yyyy-MM-ddThh:mm:ss>Transaction date & time. P12, P132024-12-05T14:23:54
38additional_fields_1.original_reference_idPREAUTH SEQ#-StringPreauth sequence417413001088

Transaction Types

Transaction TypeValue
1Purchase from Default AccountPUR
2Purchase Cancellation from Default AccountRTRN
3Purchase with Cash Out from Default AccountPCO
4Purchase with Cash Out Cancellation from Default AccountRTPCO
5Adjustment Debit from Account Default AccountADJDDA
6Adjustment Credit to Account Default AccountADJCDA
7Pre-Auth Request from Default AccountPRER
8Sales Completion from Default AccountPREC
9Reversal for Purchase from Default AccountRDB
10Reversal for Purchase Cancellation from Default AccountRCR
11Reversal for Purchase with Cash Out from Default AccountRPCO
12Reversal for Purchase with Cash Out Cancellation from Default AccountRCPCO
13Reversal of Adjustment Debit from Account Default AccountRADJDDA
14Reversal of Adjustment Credit to Account Default AccountRADJCDA
15Reversal for Pre-Auth Request from Default AccountRPER

Fields from STAT09 dropped from new report

Original NameDefinition
B24 DAT-TIMPayNet Internal Messaging
B24 RESPPayNet Internal Messaging
B24 TYPPayNet Internal Messaging
ATM to ACCT#/POS ACCT#Field not used for MyDebit
TRM LNStatic Value, PRO2
CRD LNStatic Value, PRO2
SETL AMTField not used for MyDebit
PRDStatic Value, POS
PURC-AMTPurchase amount for purchase with cashout
COMP-AMTCompleted amount for transaction

Fields from RECON dropped from new report

Original NameDefinitionRequired Derivation
PROCESS-TYPECode to determine FI Role. 01 is acquirer, 02 is issuerpayer_fiid = issuer
acquirer_fiid = acquirer
NEG-INDICATORnegative for specific txn_typeif txn-type in (RDB, RDB SA, RDB CA, RPCO, RPCOSA, RPCOCA, RCPO, RCPCOSA, RCPCPCA, RPRER, RPRERSA, RPRERCA, RCR, RCR SA, RCR CA)


RPP Daily Itemised Report

This is a daily file generated that contains all the RPP transactions by Participants. This can be used by Participants to reconcile transactions against the settlement, fee & tax amount.

File Format

File Extension.csv
Delimiter, (Comma character)
Text Qualifier" (Double quotes)
EncodingUTF-8
Line Break\n (Unix)

Sample Layout

"settlement_cycle","product","transaction_type","initiation_time","completion_time","payer_fiid","payer_id","payer_name","receiver_fiid","receiver_id","receiver_name","mcc","trace_id","reference_id","transaction_status","response_code","transaction_amount","cashout_amount","cashout_fee","network_fee","interchange_fee","locaf_fee","foreign_currency","fx_rate","fx_reference_number","foreign_amount","iso_specific_1.payer_acct_type","iso_specific_1.receiver_acct_type","additional_fields_1.original_reference_id","additional_fields_1.msme_eligible"
"001","RPP","010","2023-12-01T00:00:36","2023-12-01T00:00:36","ABCDMYKL","513595932109","DEF Business Account","ASDFMYKL","692744223194","Emily Wilson","","20231201EFGHMYNB01011712149","20231201EFGHMYNB010ORM71121419","RJCT","29","17.00","0.00","0.00","0.00","0.00","0.00","MYR","1.000000","","0.00","DFLT","SVGS","",""
"001","RPP","010","2023-12-01T00:00:36","2023-12-01T00:00:36","ABCDMYKL","1410501175","ABC Corporate Account","ASDFMYKL","551291450649","Robert Davis","","20231201IJKLMYKL01037468035","20231201IJKLMYKL010OCB80457336","RJCT","29","493.07","0.00","0.00","0.00","0.00","0.00","MYR","1.000000","","0.00","CACC","DFLT","",""
"001","RPP","010","2023-12-01T00:00:56","2023-12-01T00:00:56","ABCDMYKL","8680951485","James Green","ASDFMYKL","375490127101","Robert Davis","","20231201ABCDMYKL01072723221","20231201ABCDMYKL010OCB21322727","RJCT","29","200.54","0.00","0.00","0.00","0.00","0.00","MYR","1.000000","","0.00","CACC","DFLT","",""
"001","RPP","010","2023-12-01T00:01:13","2023-12-01T00:01:13","DEFGMYKL","112376505147","Alice Brown","ASDFMYKL","230532102016","Emily Wilson","","20231201MNOPMYKX01085773882","20231201MNOPMYKX010OCB32588778","RJCT","29","1145.07","0.00","0.00","0.00","0.00","0.00","MYR","1.000000","","0.00","CACC","DFLT","",""
"001","RPP","010","2023-12-01T00:01:28","2023-12-01T00:01:28","HIJKMYKL","0787810047","ABC Corporate Account","ASDFMYKL","927366243610","Emily Wilson","","20231201ABCDMYKL01013732236","20231201ABCDMYKL010OCB63172323","RJCT","29","328.28","0.00","0.00","0.00","0.00","0.00","MYR","1.000000","","0.00","CACC","DFLT","",""

RPP Daily Itemised Report

Click to download sample CSV file.



Report Fields

Field NameOriginal Field (TAR02)Field TypeDefinitionSample Data
1settlement_cycleSettlement CycleStringIdentifier of which window transaction was settled001
2productScheme IDStringProduct indicatorRPP
3transaction_typeService TypeStringIdentifier for the type of service or transaction010
4initiation_timeInitiation TimeTimestamp <yyyy-MM-ddThh:mm:ss>Timestamp for when transaction was initiated2024-12-05T09:15:00
5completion_timeCompletion TimeTimestamp <yyyy-MM-ddThh:mm:ss>Timestamp for when transaction was completed2024-12-05T09:15:22
6payer_fiidDebiting PartyStringBIC Code servicing an account for the debtorBANKMYKL
7payer_idPayer AcctStringDebtor's account number12345675676577
8payer_nameAcct NameStringDebtor's NameVENDOR 12346
9receiver_fiidCrediting PartyStringBIC Code servicing an account for the creditorBANCMYKL
10receiver_idRecipient AcctStringCreditor's account number/QR ID12345675676577 or MBBQR12345
11receiver_nameAcct NameStringCreditor's nameVendor Supply Sdn Bhd
12mcc-StringMerchant Category Code (ISO18245)1234
13trace_idMessage IDStringTransaction reference set by Originator (OFI)20231201BKRMMYKL01074386530
14reference_idBusiness Message IDStringMain transaction reference set by Originator (OFI)20231201BKRMMYKL010OCB86375304
15transaction_statusTrans StatusStringStatus of the transaction; ACSP, ACTC, RJCTACTC
16response_codeTrans Sub CodeStringResponse code detailing the transaction statusU000
17transaction_amountTrans AmountDecimalTransaction amount or reversed amount in MYR5000.00
18cashout_amount-DecimalCash out amount0.00
19cashout_fee-DecimalCash out fee payable or receivable to/from FI counterpart0.00
20network_fee-DecimalFee payable to PayNet0.20
21interchange_fee-DecimalFee payable or receivable to/from FI counterpart0.20
22locaf_fee-DecimalLOCAF fee payable or receivable to/from FI counterpart0.00
23foreign_currencyCurrencyStringCurrency of foreign counterpartMYR
24fx_rateFX RateDecimalForeign exchange rate set by settlement bank1.000000
25fx_reference_numberFX Ref. No.StringReference number for FX rate set by settlement bankNUMBER007730
26foreign_amountForeign Amt.DecimalTransaction amount in foreign currency0.00
27iso_specific_1.payer_acct_typeOFI Acc TypeStringDebtor's account typeCACC
28iso_specific_1.receiver_acct_typeRFI Acc TypeStringCreditor's account typeDFLT
29additional_fields_1.original_reference_id-StringOriginal Business Message ID for reversals, RTD etc20231201BKRMMYKL010OCB86375111
30additional_fields_1.msme_eligible-StringFee waiver identifier for QR POS transactionsfalse