Unsettled/Refunded Transaction Report (Exclusion from settlement)

Any unsettled transaction that has been canceled within a given settlement batch will be retrievable using this API

Formula of token

token = md5( merchantID + verify_key + date )

Value	Type Format / Max Length	Description / Example
H	1 character	Header
Settlement currency	3 chars ISO-4217 currency code	Default is MYR
total settlement amount	numeric without decimal and comma	5331674 is equal to 53,316.74 in that currency
total settlement fees	numeric without decimal and comma	Sum of the transfer fees and 3rd party costs
total refund transaction number	numeric	Total number of refund transactions
batch reference number	alphanumeric	Reference number of this settlement
date	YYYYMMDD	The settlement date
bank account	alphanumeric	Bank swift code and bank account number
Start date	YYYY-MM-DD	The settlement period start date
End date	YYYY-MM-DD	The settlement period end date

Variable / Parameter	Type Format / Max Length	Description / Example
R	1 character	Refund Data
merchant ID	alphanumeric	Merchant ID in PG system
Order ID	alphanumeric	Order references for merchant system
Channel / transaction ID	alpha-numeric / numeric	Payment channel / PG transaction ID
Transaction net amount	Numeric without decimal and comma	This should equal the original transaction amount minus the fee or commission
Transaction commission amount	Numeric without decimal and comma	The MDR or transaction fee or commission
Forex Rate	0	0
Settlement amount	0	0
Settlement currency	0	0
Transaction date	YYMMDD	The date of settlement
Transaction gross amount	Numeric without decimal and comma	Original transaction amount
Transaction currency	3 chars ISO-4217 currency code	Default is MYR
Status	alpha-numeric	The transaction status. Usually REFUND

Variable / Parameter	Description / Example
success	false
token	invalid token
date	invalid date format, eg. yyyy-mm-dd