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) |
Encoding | UTF-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 Name | Original Field (STAT09) | Original Field (RECON) | Field Type | Definition | Sample Data | |
---|---|---|---|---|---|---|
1 | settlement_cycle | - | - | String | Identifier of which cycle transaction was settled | 001 |
2 | product | - | - | String | Product indicator | MYD |
3 | transaction_type | TRAN DESC | txn-type | String | Identifier for the type of service or transaction | PUR |
4 | initiation_time | DAT-TIM | - | Timestamp <yyyy-MM-ddThh:mm:ss> | Timestamp for when transaction was initiated | 2024-12-05T14:22:33 |
5 | completion_time | POS-DAT | - | Timestamp <yyyy-MM-ddThh:mm:ss> | Timestamp for when transaction was completed | 2024-12-05T14:23:01 |
6 | payer_fiid | FI NAME | fiid | String | Issuing Bank Code | A1234 |
7 | payer_id | CARDHOLDER NUMBER | card-num | String | Card Number | 4333123456789000 |
8 | payer_name | - | - | String | Payer Name | <null> |
9 | receiver_fiid | FI NAME | fiid | String | Acquiring Bank Code | A5678 |
10 | receiver_id | TRM ID | term-id | String | Terminal ID | 12345678 |
11 | receiver_name | ATM TRM OWNER/POS RETLR | retailer-id | String | Terminal Owner | SUPER MARKET 789 |
12 | mcc | MCC | - | String | Merchant Category Code | 1234 |
13 | trace_id | TRACE# | acq-trace-num/iss-trace-num | String | Trace ID set by issuer or acquirer | 123456 |
14 | reference_id | SEQUENCE# | rrn | String | Retrieval Reference Number | 417413001047 |
15 | transaction_status | - | - | String | Status of the transaction; Approved, Declined, Purcan, Reversal | Approved |
16 | response_code | SWI RESP | - | String | Response code detailing the transaction status | 00 |
17 | transaction_amount | TRAN/BAL/ORIG AMOUNT | amt-1 | Decimal | Transaction amount or reversed amount in MYR | 200.00 |
18 | cashout_amount | CASH-AMT | amt-2 | Decimal | Cash out amount | 0.00 |
19 | cashout_fee | - | - | Decimal | Cash out fee payable or receivable to/from FI counterpart | 0.00 |
20 | network_fee | FEE-PAY (SWITCH FEE) | - | Decimal | Fee payable to PayNet | 0.50 |
21 | interchange_fee | FEE-PAY/RCV (INTERCHANGE FEE) | - | Decimal | Fee payable or receivable to/from FI counterpart | 0.85 |
22 | locaf_fee | - | - | Decimal | LOCAF fee payable or receivable to/from FI counterpart | 0.00 |
23 | foreign_currency | CRNCY | - | String | Currency of foreign counterpart | 458 |
24 | fx_rate | FOREX | - | Decimal | Foreign exchange rate set by settlement bank | 1.000000 |
25 | fx_reference_number | - | - | String | Foreign exchange reference number | NUMBER007730 |
26 | foreign_amount | FOREIGN-AMT | - | Decimal | Transaction amount in foreign currency | 0.00 |
27 | iso_specific_1.approval_code | ATM TO ACCT#/POS ACCT#/APPR CDE | - | String | Approval code set by Issuer | 123456 |
28 | iso_specific_1.mti | SWI TYP | - | String | Message Type Indicator for transaction type | 0110 |
29 | iso_specific_1.eci | ECI | eci-indicator | String | E-commerce indicator | 15 |
30 | iso_specific_1.pcde | PCDE | - | String | E-commerce entry | 59 |
31 | iso_specific_1.tpan | TOKEN PAN | - | String | Tokenised PAN Number | 5078080011112222333 |
32 | iso_specific_1.rv_code | RV CDE | - | String | Reversal Code by switch | U7 |
33 | iso_specific_1.oem_id | - | - | String | Identifier for wallet type used during transaction | APAY |
34 | iso_specific_1.entry_mode | POS-ENT-MOD | - | String | Transaction Entry Mode | 270 |
35 | iso_specific_1.term_city | TRM CITY | - | String | Terminal City | KLANG |
36 | iso_specific_1.term_state | TRM ST | - | String | Terminal State | SEL |
37 | iso_specific_2.tran_datetime | TRAN_DAT, TRAN_TIME | tran_dat, tran_time | Timestamp <yyyy-MM-ddThh:mm:ss> | Transaction date & time. P12, P13 | 2024-12-05T14:23:54 |
38 | additional_fields_1.original_reference_id | PREAUTH SEQ# | - | String | Preauth sequence | 417413001088 |
Transaction Types
Transaction Type | Value | |
---|---|---|
1 | Purchase from Default Account | PUR |
2 | Purchase Cancellation from Default Account | RTRN |
3 | Purchase with Cash Out from Default Account | PCO |
4 | Purchase with Cash Out Cancellation from Default Account | RTPCO |
5 | Adjustment Debit from Account Default Account | ADJDDA |
6 | Adjustment Credit to Account Default Account | ADJCDA |
7 | Pre-Auth Request from Default Account | PRER |
8 | Sales Completion from Default Account | PREC |
9 | Reversal for Purchase from Default Account | RDB |
10 | Reversal for Purchase Cancellation from Default Account | RCR |
11 | Reversal for Purchase with Cash Out from Default Account | RPCO |
12 | Reversal for Purchase with Cash Out Cancellation from Default Account | RCPCO |
13 | Reversal of Adjustment Debit from Account Default Account | RADJDDA |
14 | Reversal of Adjustment Credit to Account Default Account | RADJCDA |
15 | Reversal for Pre-Auth Request from Default Account | RPER |
Fields from STAT09 dropped from new report
Original Name | Definition |
---|---|
B24 DAT-TIM | PayNet Internal Messaging |
B24 RESP | PayNet Internal Messaging |
B24 TYP | PayNet Internal Messaging |
ATM to ACCT#/POS ACCT# | Field not used for MyDebit |
TRM LN | Static Value, PRO2 |
CRD LN | Static Value, PRO2 |
SETL AMT | Field not used for MyDebit |
PRD | Static Value, POS |
PURC-AMT | Purchase amount for purchase with cashout |
COMP-AMT | Completed amount for transaction |
Fields from RECON dropped from new report
Original Name | Definition | Required Derivation |
---|---|---|
PROCESS-TYPE | Code to determine FI Role. 01 is acquirer, 02 is issuer | payer_fiid = issuer acquirer_fiid = acquirer |
NEG-INDICATOR | negative for specific txn_type | if 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) |
Encoding | UTF-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 Name | Original Field (TAR02) | Field Type | Definition | Sample Data | |
---|---|---|---|---|---|
1 | settlement_cycle | Settlement Cycle | String | Identifier of which window transaction was settled | 001 |
2 | product | Scheme ID | String | Product indicator | RPP |
3 | transaction_type | Service Type | String | Identifier for the type of service or transaction | 010 |
4 | initiation_time | Initiation Time | Timestamp <yyyy-MM-ddThh:mm:ss> | Timestamp for when transaction was initiated | 2024-12-05T09:15:00 |
5 | completion_time | Completion Time | Timestamp <yyyy-MM-ddThh:mm:ss> | Timestamp for when transaction was completed | 2024-12-05T09:15:22 |
6 | payer_fiid | Debiting Party | String | BIC Code servicing an account for the debtor | BANKMYKL |
7 | payer_id | Payer Acct | String | Debtor's account number | 12345675676577 |
8 | payer_name | Acct Name | String | Debtor's Name | VENDOR 12346 |
9 | receiver_fiid | Crediting Party | String | BIC Code servicing an account for the creditor | BANCMYKL |
10 | receiver_id | Recipient Acct | String | Creditor's account number/QR ID | 12345675676577 or MBBQR12345 |
11 | receiver_name | Acct Name | String | Creditor's name | Vendor Supply Sdn Bhd |
12 | mcc | - | String | Merchant Category Code (ISO18245) | 1234 |
13 | trace_id | Message ID | String | Transaction reference set by Originator (OFI) | 20231201BKRMMYKL01074386530 |
14 | reference_id | Business Message ID | String | Main transaction reference set by Originator (OFI) | 20231201BKRMMYKL010OCB86375304 |
15 | transaction_status | Trans Status | String | Status of the transaction; ACSP, ACTC, RJCT | ACTC |
16 | response_code | Trans Sub Code | String | Response code detailing the transaction status | U000 |
17 | transaction_amount | Trans Amount | Decimal | Transaction amount or reversed amount in MYR | 5000.00 |
18 | cashout_amount | - | Decimal | Cash out amount | 0.00 |
19 | cashout_fee | - | Decimal | Cash out fee payable or receivable to/from FI counterpart | 0.00 |
20 | network_fee | - | Decimal | Fee payable to PayNet | 0.20 |
21 | interchange_fee | - | Decimal | Fee payable or receivable to/from FI counterpart | 0.20 |
22 | locaf_fee | - | Decimal | LOCAF fee payable or receivable to/from FI counterpart | 0.00 |
23 | foreign_currency | Currency | String | Currency of foreign counterpart | MYR |
24 | fx_rate | FX Rate | Decimal | Foreign exchange rate set by settlement bank | 1.000000 |
25 | fx_reference_number | FX Ref. No. | String | Reference number for FX rate set by settlement bank | NUMBER007730 |
26 | foreign_amount | Foreign Amt. | Decimal | Transaction amount in foreign currency | 0.00 |
27 | iso_specific_1.payer_acct_type | OFI Acc Type | String | Debtor's account type | CACC |
28 | iso_specific_1.receiver_acct_type | RFI Acc Type | String | Creditor's account type | DFLT |
29 | additional_fields_1.original_reference_id | - | String | Original Business Message ID for reversals, RTD etc | 20231201BKRMMYKL010OCB86375111 |
30 | additional_fields_1.msme_eligible | - | String | Fee waiver identifier for QR POS transactions | false |