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_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.00","-0.01","0.01","0.00","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.00","-0.01","0.01","0.00","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.00","-0.03","0.05","0.00","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.00","-0.06","0.12","0.00","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.00","-0.06","0.12","0.00","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 (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 | Not applicable for RPP transactions | 0.00 |
| 19 | cashout_fee | - | - | Decimal | Payable cash out fee | 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 |
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","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 (TAR02) | 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; 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 | 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 |