Daily Settlement Report

Method : POST
URL :https://open.revenuemonster.my/v3/payment/reconciliation
Sandbox URL : https://sb-open.revenuemonster.my/v3/payment/reconciliation

note

To get Daily Payment report

Request Parameters#

ParameterTypeRequiredDescriptionExample
transactionTypeStringYes"PAYMENT" or "REFUND""PAYMENT"
dateStringYesDate of the report"2019-12-31"
methodStringYesRM currently supported method[]
regionStringYesRegion of wallet, "MALAYSIA" or "CHINA"[]
cursorStringYesOptional, if pagination exists""

Example Request

curl --location --request POST "https://sb-open.revenuemonster.my/v3/payment/reconciliation" \
--header "Content-Type: application/json"\
--header "Authorization: Bearer eyJhbGciOiJSUzI1NiIsImtpZCI6IjIwMTgtMDMtMTMiLCJ0eXAiOiJKV1QifQ.eyJhdWQiOlsiKiJdLCJleHAiOjE1MjE2MjkyNTYsImlhdCI6MTUyMTYyMjA1NywiaXNzIjoiaHR0cHM6Ly9zYi1vYXV0aC5yZXZlbnVlbW9uc3Rlci5teSIsImp0aSI6IkVod0tFRTlCZFhSb1FXTmpaWE56Vkc5clpXNFF5cmYza3EzTDY4QnoiLCJuYmYiOjE1MjE2MjIwNTcsInN1YiI6IkVoUUtDRTFsY21Ob1lXNTBFSlhWemQzd3JhcVRPUklRQ2dSVmMyVnlFSXlKcUl6dnlNUFZjUSJ9.dJknY9MZHLNrKx1p7gZxS0_oA3uXLWplDU1r1dpwxIbmdB6yw4tQBTXKlWArDfKLlBDn6v22_gT5Px7sdCMj7e5M9eRoJoMnoPnslgYpmJJ5kjqAbKU7dUxKb1OzFLrvmtSK9r-FRLVtMFHioWYpwgSvSPBgZ6lAYkUyDzH7aKadFYtQcBuJR0hlq2CXtP0mzbHOeu2q6giONf3E5-XqS8lLRtuHPAbJ7_YFwo0Oe2zc6h05IOocmx_NvBVPfDBnuygTU063h70Q987MYeGDV_Os4N6N_I4b-GoHprEPtmntB1RJPrFrY28hvvoUfDHXHZVXT1GlrsozrkWV4EjbTw" \
--header "X-Signature: sha256 OsjlEWZLKx0IXgC5PUk6sM+ZZdrS/ELBNdEGj+okOhVAwo/i+GK91CwEmIbLko+p0Vbs8Ph+iBQG/3DyS7kHug=="\
--header "X-Nonce-Str: VYNknZohxwicZMaWbNdBKUrnrxDtaRhN" \
--header "X-Timestamp: 1527407052" \
--data-raw "{
"transactionType": "PAYMENT",
"date": "2019-12-31",
"method": [],
"region": [],
"cursor": ""
}"

Response Parameters#

ParameterTypeDescriptionExample
itemsObjectTransaction object(Refer to explanation below)
codeStringSuccessfully call this endpoint. If fail, will return error code object (Refer Appendix 1: Error Codes)"SUCCESS"
metaObjectDatabase object{}

Transaction object (item):
ParameterTypeDescriptionExample
transactionAtDateTimeTransaction date time of transaction"2019-12-31T07:00:10Z"
merchantIdString(Can view From RM Portal)"4118165203679668885"
merchantNameString(Can view From RM Portal)"Revenue Monster Sdn Bhd"
storeIdStringStore ID"4949529109748431621"
storeNameStringStore Name"Kim's Food Corner"
regionStringRegion of wallet, "MALAYSIA" or "CHINA""MALAYSIA"
methodStringRM currently supported method"TNG"
transactionTypeString"PAYMENT" or "REFUND""PAYMENT"
typeString"QUICK_PAY" , "QR_PAY","Web_Payment" , "Mobile_Payment" , "Mobile_Web_Payment""QUICK_PAY"
transactionIdStringTransaction ID (from RM server)"191231070009010323431829"
orderIdStringOrder ID (from Merchant), max: 24"1577775608765190100M6010"
currencyTypeStringCurrency notation (currently only support MYR)"MYR"
grossAmountDoubleGross Amount QR pay"0.10"
mdrDoubleMDR (from RM server)"0.70"
serviceFeeDoubleService Fee (from RM server)"-0.00"
settlementAmountDoubleSettlement Amount"0.10"
storeObjectStore object(Refer to explanation below)
referenceIdStringTransaction ID (from WeChat server)""
transactionIdStringTransaction ID (from RM server)"152161448229438994"
orderObjectOrder object(Refer to explanation below)
payeeObjectObject of userID made payment (payment sender){"userId": "o74f0wjjzv9eKRu1fccrZswVFnOQ"}
platformStringCurrently only support "OPEN_API""OPEN_API"
methodStringCurrently only support "WECHATPAY" , "PRESTO" , "BOOST" , "TNG" , "MAYBANK" , "ALIPAY" , "GRABPAY"."ALL"
typeStringCurrently only support "QUICKPAY""QUICKPAY"
statusStringStatus returned from WeChat server, "SUCCESS" or "IN_PROCESS" or "FAILED". "IN_PROCESS" means user scanned and making payment."FAILED"
createdAtDateTimeCreation date time of transaction"2018-03-21T06:41:22Z"
updatedAtDateTimeLast update date time of transaction"2018-03-21T06:41:22Z"

Store object (store):
ParameterTypeDescriptionExample
idStringStore ID"6170506694335521334"
nameStringStore Name"REVENUE MONSTER"
addressLine1StringStore Address 1"B-5-30, 5th Floor, Block Bougainvillea,"
addressLine2StringStore Address 2"PJU 6A, Lebuhraya SPRINT, 10 Boulevard,"
postCodeStringPostcode of store"47400"
cityStringCity of store"Petaling Jaya"
stateStringState of store"Selangor"
countryStringCountry of store"Malaysia"
countryCodeStringCountry code of store contact number"60"
phoneNumberStringPhone number of store"377334080"
geoLocationObject of [String]Geo Location (latitude and longtitude) of store{"Lat": 3.1349857, "Lng": 101.6136659 }
statusStringCurrent status of store"ACTIVE"
createdAtDateTimeCreation date time of store"2018-02-12T08:53:13Z"
updatedAtDateTimeLast update date time of store"2018-02-12T08:53:13Z"

Order object (order):
ParameterTypeDescriptionExample
idStringOrder ID (from Merchant)"134850717797247290"
titleStringOrder title"Sales"
detailsStringOrder details"1 x iPhone X; 2 x SAMSUNG S8"
additionalDataStringFor merchant's remark""
currencyTypeStringCurrency notation (currently only support MYR)"MYR"
amountUintAmount of order100

Example Response

{
"items": [
{
"transactionAt": "2019-12-31T07:00:10Z",
"merchantId": "4118165203679668885",
"merchantName": "Revenue Monster Sdn Bhd",
"storeId": "4949529109748431621",
"storeName": "Kim's Food Corner",
"region": "MALAYSIA",
"method": "TNG",
"transactionType": "PAYMENT",
"type": "QUICK_PAY",
"transactionId": "191231070009010323431829",
"orderId": "1577775608765190100M6010",
"currencyType": "MYR",
"grossAmount": "0.10",
"mdr": "0.70",
"serviceFee": "-0.00",
"settlementAmount": "0.10"
},
{
"transactionAt": "2019-12-31T07:42:55Z",
"merchantId": "4118165203679668885",
"merchantName": "Revenue Monster Sdn Bhd",
"storeId": "4949529109748431621",
"storeName": "Kim's Food Corner",
"region": "MALAYSIA",
"method": "TNG",
"transactionType": "PAYMENT",
"type": "QUICK_PAY",
"transactionId": "191231074255010324053928",
"orderId": "1577778173933190100M6010",
"currencyType": "MYR",
"grossAmount": "1.00",
"mdr": "0.70",
"serviceFee": "-0.01",
"settlementAmount": "0.99"
}
],
"code": "SUCCESS",
"meta": {}
}