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","network_fee","interchange_fee","currency","fx_rate","fx_reference_number","foreign_amount","iso_specific_1.approval_code","iso_specific_1.mti","iso_specific_1.eci","iso_pecific_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"
"002","MYD","PUR","2024-12-10T09:55:14","2024-12-10T09:55:14","A1234","3777998305927078","","A5678","86639011","TestMerc3","5499","109007","880345628652","approved","00","22.30","0.00","-0.01","0.01","458","1.000000","","0.00","045560","","","","1493496802527308699","","","271","Batu Pahat","JOH","2024-12-10T09:55:44",""
"001","MYD","PUR","2024-12-10T17:21:15","2024-12-10T17:21:15","A1234","1604534282693450","","A5678","31616908","TestMerc2","5499","155033","780904573221","approved","00","7.06","0.00","-0.01","0.01","458","1.000000","","0.00","768255","","","","4438930316654181273","","","271","Batu Pahat","JOH","2024-12-10T17:21:55",""
"001","MYD","PUR","2024-12-10T17:26:27","2024-12-10T17:26:27","A1234","5282528047723081","","A5678","11368690","TestMerc2","5499","601098","575460350901","approved","00","93.06","0.00","-0.03","0.05","458","1.000000","","0.00","753172","","","","3944023720785019366","","","271","Petaling Jaya","SEL","2024-12-10T17:26:47",""
"001","MYD","PUR","2024-12-10T21:09:38","2024-12-10T21:09:38","A1234","4536861669617546","","A5678","19681630","TestMerc1","5499","066109","393570353843","approved","00","167.58","0.00","-0.06","0.12","458","1.000000","","0.00","859900","","","","8550631500191368917","","","271","Aloh Gajah","MEL","2024-12-10T21:09:54",""
"002","MYD","PUR","2024-12-10T13:31:27","2024-12-10T13:31:27","A1234","1502323181837275","","A5678","18096663","TestMerc3","5621","062652","555581111783","approved","00","216.13","0.00","-0.06","0.12","458","1.000000","","0.00","555257","","","","9189337370408833438","","","271","Aloh Gajah","MEL","2024-12-10T13:31:57",""
MyDebit Daily Itemised Report
Click to download sample CSV file.
Report Fields
Field Name | Original Field | 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 | String | Identifier for the type of service or transaction | PUR |
4 | initiation_time | - | Timestamp <yyyy-MM-ddThh:mm:ss> | Timestamp for when transaction was initiated | 2024-12-05T14:22:33 |
5 | completion_time | SWI DAT-TIM | Timestamp <yyyy-MM-ddThh:mm:ss> | Timestamp for when transaction was completed | 2024-12-05T14:23:01 |
6 | payer_fiid | FI NAME | String | Issuing Bank Code | A1234 |
7 | payer_id | CARDHOLDER NUMBER | String | Card Number | 4333123456789000 |
8 | payer_name | - | String | Payer Name | <null> |
9 | receiver_fiid | FI NAME | String | Acquiring Bank Code | A5678 |
10 | receiver_id | TRM ID | String | Terminal ID | 12345678 |
11 | receiver_name | ATM TRM OWNER/POS RETLR | String | Terminal Owner | SUPER MARKET 789 |
12 | mcc | MCC | String | Merchant Category Code | 1234 |
13 | trace_id | TRACE# | String | Trace ID set by issuer or acquirer | 123456 |
14 | reference_id | SEQUENCE# | String | Retrieval Reference Number | 417413001047 |
15 | transaction_status | - | String | Status of the transaction; Approved, Rejected, etc. | APPROVED |
16 | response_code | SWI RESP | String | Response code detailing the transaction status | 00 |
17 | transaction_amount | TRAN/BAL/ORIG AMOUNT | Decimal | Transaction amount or reversed amount in MYR | 200.00 |
18 | cashout_amount | CASH-AMT | Decimal | Cashout Amount | 0.00 |
19 | network_fee | FEE-PAY (SWITCH FEE) | Decimal | Fee payable to PayNet | 0.50 |
20 | interchange_fee | FEE-PAY/RCV (INTERCHANGE FEE) | Decimal | Fee payable or receivable to/from FI counterpart | 0.85 |
21 | currency | CRNCY | String | Currency of foreign counterpart | 458 |
22 | fx_rate | FOREX | Decimal | Foreign exchange rate set by settlement bank | 1.000000 |
23 | fx_reference_number | - | String | Foreign exchange reference number | NUMBER007730 |
24 | foreign_amount | FOREIGN-AMT | Decimal | Transaction amount in foreign currency | 0.00 |
25 | iso_specific_1.approval_code | ATM TO ACCT#/POS ACCT#/APPR CDE | String | Approval code set by Issuer | 123456 |
26 | iso_specific_1.mti | SWI TYP | String | Message Type Indicator for transaction type | 0110 |
27 | iso_specific_1.eci | ECI | String | E-commerce indicator | 15 |
28 | iso_specific_1.pcde | PCDE | String | E-commerce entry | 59 |
29 | iso_specific_1.tpan | TOKEN PAN | String | Tokenised PAN Number | 5078080011112222333 |
30 | iso_specific_1.rv_code | RV CDE | String | Reversal Code by switch | U7 |
31 | iso_specific_1.oem_id | - | String | Identifier for wallet type used during transaction | APAY |
32 | iso_specific_1.entry_mode | POS-ENT-MOD | String | Transaction Entry Mode | 270 |
33 | iso_specific_1.term_city | TRM CITY | String | Terminal City | KLANG |
34 | iso_specific_1.term_state | TRM ST | String | Terminal State | SEL |
35 | iso_specific_2.tran_datetime | TRAN_DAT, TRAN_TIME | Timestamp <yyyy-MM-ddThh:mm:ss> | Transaction date & time. P12, P13 | 2024-12-05T14:23:54 |
36 | additional_fields_1.original_reference_id | PREAUTH SEQ# | String | Preauth sequence | 417413001088 |
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 |
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","network_fee","interchange_fee","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","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","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","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","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","MYR","1.000000","","0.00","CACC","DFLT","",""
RPP Daily Itemised Report
Click to download sample CSV file.
Report Fields
Field Name | Original Field | Field Type | Definition | Sample Data | |
---|---|---|---|---|---|
1 | settlement_cycle | Settlement Cycle | String | Settlement of transaction (Cycle 1 or Cycle 2) | 001 |
2 | product | Scheme ID | String | Product indicator | RPP |
3 | transaction_type | Service | String | Identifier for the type of service or transaction | 010 |
4 | initiation_time | Initiation Date | Timestamp <yyyy-MM-ddThh:mm:ss> | Timestamp for when transaction was initiated | 2024-12-05T09:15:00 |
5 | completion_time | Completed Date | Timestamp <yyyy-MM-ddThh:mm:ss> | Timestamp for when transaction was completed | 2024-12-05T09:15:22 |
6 | payer_fiid | OFI Code | String | BIC Code servicing an account for the debtor | BANKMYKL |
7 | payer_id | OFI Acc No | String | Debtor’s account number | 12345675676577 |
8 | payer_name | OFI Acc Name | String | Debtor’s Name | VENDOR 12346 |
9 | receiver_fiid | RFI Code | String | BIC Code servicing an account for the creditor | BANCMYKL |
10 | receiver_id | RFI Acc No | String | Creditor’s account number/QR ID | 12345675676577 or MBBQR12345 |
11 | receiver_name | RFI Acc Name | String | Creditor’s name | Vendor Supply Sdn Bhd |
12 | mcc | - | String | Merchant Category Code (ISO18245) | 1234 |
13 | trace_id | MSG ID | String | Transaction reference set by Originator (OFI) | 20231201BKRMMYKL01074386530 |
14 | reference_id | Business MSG ID | String | Main transaction reference set by Originator (OFI) | 20231201BKRMMYKL010OCB86375304 |
15 | transaction_status | Trans Status | String | Status of the transaction; Successful, Accepted, etc. | 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 | Cashout Amount | 0.00 |
19 | network_fee | - | Decimal | Fee payable to PayNet | 0.20 |
20 | interchange_fee | - | Decimal | Fee payable or receivable to/from FI counterpart | 0.20 |
21 | currency | Currency | String | Currency of foreign counterpart | MYR |
22 | fx_rate | FX Rate | Decimal | Foreign exchange rate set by settlement bank | 1.000000 |
23 | fx_reference_number | FX Ref. No. | String | Reference number for FX rate set by settlement bank | NUMBER007730 |
24 | foreign_amount | Foreign Amt. | Decimal | Transaction amount in foreign currency | 0.00 |
25 | iso_specific_1.payer_acct_type | OFI Acc Type | String | Debtor’s account type | CACC |
26 | iso_specific_1.receiver_acct_type | RFI Acc Type | String | Creditor’s account type | DFLT |
27 | additional_fields_1.original_reference_id | - | String | Original Business Message ID for reversals, RTD etc | 20231201BKRMMYKL010OCB86375111 |
28 | additional_fields_1.msme_eligible | - | String | Fee waiver identifier for QR POS transactions | True |