Appendix 3
Daily Transaction Detail
Daily transaction details file is for reconciliation of daily transactions in Partner Business Account (MBA). The transactions include:
- MBA account top up.
- Successful or accepted DuitNow fund transfer transaction.
- DuitNow fund transfer Refund by receiving bank.
The files will be available for download after 7am (GMT+8) on each day.
File Name Convention
- Filename shall be in:
SenderID_Date_PFTRX_RunningNumber.txt, as per example below:
000000000000281_20201113_TRXDT_001.txt
| Field Name | Required | Type | Length | Description | Example |
|---|---|---|---|---|---|
| Sender ID | Yes | AN | 19 | Sender ID. | "000000000000281" |
| Separator | Yes | ANS | 1 | Separator. | "_" |
| Date | Yes | N | 8 | Request date. | "20201113" |
| Separator | Yes | ANS | 1 | Separator. | "_" |
| File type | Yes | AN | 5 | Transaction detail. | "TRXDT" |
| Separator | Yes | ANS | 1 | Separator. | "_" |
| Running Number | Yes | N | 3 | Running number. | "001" |
Header Record
| Field Name | Required | Type | Length | Description | Example |
|---|---|---|---|---|---|
| Record Type | Yes | AN | 1 | Header record. | "H" |
| Sender ID | Yes | AN | 19 | Sender ID. | "000000000005446" |
| Partner’s MBA number | Yes | N | 16 | Partner’s merchant business account. | "0031233180263344" |
| Transaction Date | Yes | N | 8 | Transaction date. | "20201112" |
| File Date | Yes | N | 8 | File generated date. | "20201113" |
| Running Number | Yes | N | 3 | Running number. | "001" |
Transaction Record
| Field Name | Required | Type | Length | Description | Example |
|---|---|---|---|---|---|
| Record Type | Yes | AN | 1 | Data record. | "D" |
| Reference Number | Optional | AN | 50 | Sender reference number in transaction request. | "22011121407123331" |
| Transaction Description | Optional | AN | 40 | Transaction description. | "DUITNOW - REFUND" |
| Original Transaction Currency Code | Yes | AN | 3 | Original transaction currency code. | "MYR" |
| Transaction Amount | Yes | ANS + N | 1 + 18 | Transaction amount. | "+000000000000150000", "-000000000000150000" |
| Local Transaction Currency Code | Yes | AN | 3 | Local transaction currency code. | "MYR" |
| Transaction Amount in Local Currency | Yes | ANS + N | 1 + 18 | Transaction amount in local currency. | "+000000000000150000", "-000000000000150000" |
| Transaction Date | Yes | N | 8 | Transaction date. | "20201112" |
| Transaction Time | Yes | N | 6 | Transaction time. | "005912" |
| Transaction Posting Date | Yes | N | 8 | Transaction posting date. | "20201112" |
| Beneficiary BIC | Optional | AN | 8 | Beneficiary Business Identified Code. | "FNXSMYNB" |
| Beneficiary Account No | Optional | AN | 34 | Masked beneficiary account number. | "123*22 |
| Beneficiary Name | Optional | AN | 140 | Masked beneficiary name. | "TR****ACC" |
Trailer Record
| Field Name | Required | Type | Length | Description | Example |
|---|---|---|---|---|---|
| Record Type | Yes | AN | 1 | Trailer record. | "T" |
| Total Detail Record | Yes | N | 8 | Total number of detail record. | "00000003" |
| Balances Currency Code | Yes | AN | 3 | Balances transaction currency code. | "MYR" |
| Opening Balance | Yes | ANS + N | 1 + 18 | Opening balance of the account. | "+000000000000150000", "-000000000000150000" |
| Total Credit Amount | Yes | N | 18 | Total amount of credit transaction record. | "000000000000150000" |
| Total Debit Amount | Yes | N | 18 | Total amount of debit transaction record. | "000000000000150000" |
| Closing Balance | Yes | ANS + N | 1 + 18 | Closing balance of the account. | "+000000000000150000", "-000000000000150000" |
Sample Data
H|000000000005446|0031233180263344|20201112|20201113|001
D|22011121407123331|DUITNOW - REFUND|MYR|+000000000001000000|MYR|+000000000001000000|20201112|005912|20201112|FNXSMYNB|123*****22|TR****ACC
D|22011121407123332|DUITNOW - 2222222|MYR|-000000000000050000|MYR|-000000000000050000|20201112|104953|20201112|SMBCMYKL|456*****21|JH****LIM
D|22011121407123333|DUITNOW - 2222222|MYR|-000000000000100000|MYR|-000000000000100000|20201112|232218|20201112|BSNAMYK1|445*****56|HO****LIN
T|00000003|MYR|+000000000002000000|+000000000001000000|+000000000000150000|+000000000002850000
info
- AN = Alphanumeric, ASCII format
- ANS = Alphanumeric and Special Characters, ASCII format
- N[n] = Numeric, ASCII format
