Statement Inquiry API

The Statement Inquiry API fetches the transactions on a wallet/card within the specified date range and the balance. This API includes the following financial and non-financial transactions:

Financial: network transactions and wallet (load, unload, fund transfer).
Non-financial: reset PIN, block, and unblock.

📘
Note:
The **Card Inquiry **API will not provide the transaction history of the card.


Sandbox	https://payusandbox-kong.pc.enstage-sas.com/uat/sbx/api/onboarding/v3/statementInquiry
Production	Contact your WIBMO KAM or support.

Sample request

curl --request POST \
     --url https://payusandbox-kong.pc.enstage-sas.com/uat/sbx/api/onboarding/v3/statementInquiry \
     --header 'X-Consumer-Custom-ID: F42BC4E7B801C834B630DE498473533F' \
     --header 'bankId: 6060' \
     --header 'clientId: 1060' \
     --header 'content-type: application/json' \
     --header 'entityId: 100' \
     --header 'secureCode: pu8gSMLNE7pNv36IlUmstU' \
     --header 'x-api-key: 4A02C4267C9A97A1488AB3259FD1A725' \
     --data '
{
  "token": "PvLNIjKAREzAVW6+GKpbcmtepBQ5LfPNuRoVWhf0oyBaFYFDSCY9LxfrGa39nj7Ff0wnoj4L31uFU2kXrc/WSeTuURE4CGm4Lgzl61DHQLQQ8n4Gcm25YE8UQaHBJsQwugGMWUmIw3yrtRpKS1b0z679bLT1wtaFjF2TvUbXfI0e/0AGd/4WvbvcDChXQ6LUIFC80mxjinbTp6V4CYgIxCP0O7zaZYJ8I1nput5ZiV9WbWHR9CroIWe7Cs108Y2jD+mbyUAXKP4C3IqySZCQqNVqrf9ev6GWNZvx5aN9Af5Rlh+wh7VFyvvNXZGd/SrdDUDCPNIjAvLYlwVkunKovsnnl+wVNBIcVkB06O/K9JfBoJIl3u2BhbRwCg7MD89s"
}
'

Response parameters (Decrypted)

This API will provide a token in the response that must be decrypted using the Decrypt API. The decrypted response is similar to the following:

Parameter	Type	Parameter Requirement	Description
messageCode	numeric(4)	Mandatory	Code to Identify "Transaction Statement Inquiry" API response
clientTxnId	string(100)	Mandatory	Echoed from the request
bankId	Numeric(4)	Mandatory	Value echoed from the request header.
clientId	String(15)	Mandatory	Value echoed from the request header.
responseDateTime	numeric(14)	Mandatory	Response date time in the format YYYYMMDDHHMMSS with time in 24-hour format
urn	Numeric(10)	Mandatory	Echoed from the request.
customerId	String(20)	Mandatory	Echoed from the request.
accosaTransactionId	numeric(10)	Mandatory	Unique ID for a particular transaction generated in the Prepaid system.
responseCode	string(4)	Mandatory	Represents the status of the transaction.
responseMessage	string(100)	Mandatory	Response message based on the response code.
description	String(100)	Optional	Reserved field to send information to client.
transactionDetails	Object array	Mandatory	This object array will contain the complete transaction information list.

Sample response (Decrypted)

{
    "urn": 70000000884,
    "customerId": "000000000021",
    "description": "Transaction Statement Details",
    "responseCode": "00",
    "messageCode": 3541,
    "clientTxnId": "BDO_TransactionStatement_Inquiry11",
    "clientId": "1040",
    "responseDateTime": "20231220122317",
    "accosaTransactionId": 10578,
    "responseMessage": "SUCCESS",
    "bankId": 6010,
    "transactionDetails": [
        {
            "txnId": 2089,
            "txnDateTime": "2023-09-24 12:46:02.0",
            "txnAmount": "2730.00",
            "txnType": "AUTHORIZATION_REQUEST",
            "txnMode": "DR",
            "txnStatus": "Open",
            "cardAcceptorName": "Merchant name",
            "mcc": "5999",
            "approvalCode": "060WN5",
            "txnCurrencyCode": "840",
            "eventId": "105010",
            "closingBal": "355.00",
            "rrn": "085001200001"
        },
        {
            "txnId": 2090,
            "txnDateTime": "2023-09-24 12:46:44.0",
            "txnAmount": "2730.00",
            "txnType": "AUTHORIZATION_REQUEST",
            "txnMode": "DR",
            "txnStatus": "Open",
            "cardAcceptorName": "Merchant name",
            "mcc": "5999",
            "approvalCode": "060WN6",
            "txnCurrencyCode": "840",
            "eventId": "105010",
            "closingBal": "355.00",
            "rrn": "085001200002"
        },
        {
            "txnId": 2074,
            "txnDateTime": "2023-09-24 11:59:49.0",
            "txnAmount": "234.26",
            "txnType": "ATM_CASH_WITHDRAWAL_REQUEST",
            "txnMode": "DR",
            "txnStatus": "Open",
            "cardAcceptorName": "MSR MERCHANT",
            "mcc": "6011",
            "approvalCode": "060H7L",
            "txnCurrencyCode": "978",
            "eventId": "130030",
            "closingBal": "0.00",
            "rrn": "085000400003"
        },
        {
            "txnId": 2092,
            "txnDateTime": "2023-09-24 12:47:21.0",
            "txnAmount": "2730.00",
            "txnType": "AUTHORIZATION_REQUEST",
            "txnMode": "DR",
            "txnStatus": "Open",
            "cardAcceptorName": "Merchant name",
            "mcc": "5999",
            "approvalCode": "060WN7",
            "txnCurrencyCode": "840",
            "eventId": "105010",
            "closingBal": "8350.00",
            "rrn": "085001200003"
        }
    ]
}

Error codes (Decrypted)

Error Code	Description
00	SUCCESS
1001	CARD_NOT_FOUND
1030	INVALID MESSAGE COD
1031	INVALID BANK ID
1032	INVALID_CLIENT_CHANNEL
1049	INVALID SECURE CODE
1052	SYSTEM_ERROR
1055	MALFORMED_REQUEST
1056	INVALID MESSAGE CODE
1081	OPERATION NOT ALLOWED
1083	URN AND LAST 4 DIGITS MISMATCH
1084	URN AND CUSTOMER ID MISMATCH
1085	REQUESTOR UNAUTHORIZED FOR URN OR PRODUCT
1088	INVALID DATE format
1093	INVALID CLIENT TXN ID
1116	CARD AML PROFILE MISSING
1262	CLIENT ID NOT PRESENT
1264	BANK ID NOT PRESENT
1310	XCONSUMERKEY NOT PRESENT
1311	SECURE CODE NOT PRESENT
1320	REQUEST_DATETIME_IS_MANDATORY
1346	URN_IS_MANDATORY
1500	SYSTEM ERROR
1501	SYSTEM ERROR(DB)
1501	SYSTEM ERROR
5003	CLIENT_NOT_CONFIGURED_UNDER_BANK_ID
9329	LAST 4 DIGITS IS MANDATORY
9343	CLIENT TXN ID IS MANDATORY
9344	FROM DATE CANNOT BE GREATER THAN TO DATE
9345	DIFFERENCE BETWEEN FROM DATE AND TO DATE GREATER THAN DEFINED IN DB
10108	CUSTOMER ID MISSING

Note:

Request parameters