Antom, leading provider of tailored payment solutionsAntom, leading provider of tailored payment solutions

Transaction details report

The transaction details report provides a detailed record of successful transactions on T day. You can obtain this report through APO Dashboard.

Report details

The transaction details report consists of three parts: header information, transaction details, and the end-of-file <END> that appears in the last line of the report. The header information is represented by parameter names, and the transaction details are represented by the corresponding values of the parameters.

The following table shows the parameters in the transaction details report and parameter descriptions:

Parameter

Description

customerId

MANDATORY String (64)

The unique ID that is assigned by the acquirer to identify a merchant.

acquirer

MANDATORY String (64)

The name of the acquirer that processes the transactions.

The acquirer here specifically means the acquirer that provides acquiring and funds settlement services for the merchant.

referenceMerchantId

OPTIONAL String (64)

The unique ID of the merchant that directly provides services or goods to users, assigned by the merchant to its sub-merchant.

The value of this parameter needs to be the same as that of the referenceMerchantId parameter in the original payment or authorization request.

referenceStoreId

OPTIONAL String (64)

The unique ID of the store that belongs to the merchant, assigned by the merchant to its second merchant.

transactionId

MANDATORY String (64)

The unique ID that is assigned by APO to identify a transaction. The value of this parameter follows these rules:

  • When transactionType is PAYMENT, CANCEL, or AUTHORIZATION, the value of this parameter is identical to that of paymentId.
  • When transactionType is CAPTURE, the value of this parameter is identical to that of captureId.
  • When transactionType is REFUND, the value of this parameter is identical to that of refundId.
  • When transactionType is DISPUTE, the value of this parameter is identical to that of disputeId.
  • When transactionType is VOID, the value of this parameter is APO's internal ID.

originalTransactionId

OPTIONAL String (64)

An identifier for the original transaction.

  • When transactionType is PAYMENT, CANCEL, or AUTHORIZATION, the value of this parameter is empty.
  • When transactionType is VOID, the value of this parameter is identical to paymentId of the original authorization.
  • When transactionType is REFUND, the value of this parameter is identical to paymentId of the original payment or authorization.
  • When transactionType is CAPTURE, the value of this parameter is identical to paymentId of the original authorization.
  • When transactionType is DISPUTE, the value of this parameter is identical to that of paymentId of the original authorization.

transactionRequestId

MANDATORY String (64)

The unique ID that is assigned by the merchant to identify a transaction request. The value of this parameter is identical to the value of paymentRequestId for a payment, or the value of refundRequestId for a refund.

When transactionType is DISPUTE, the value of this parameter is empty.

referenceTransactionId

OPTIONAL String (64)

The unique ID assigned by the merchant that directly provides services or goods to users, to identify a transaction. The value of this parameter is identical to that of referenceOrderId for a payment.

When transactionType is CANCEL, CAPTURE, or DISPUTE, the value of this parameter is empty.

orderDescription

OPTIONAL String (256)

The description of the order.

The value of this parameter is identical to that of orderDescription of the original payment or authorization.

paymentMethodType

MANDATORY String (64)

The payment method for processing the payment.

The value of this parameter is identical to that of paymentMethodType in the original payment or authorization request.

pspName

OPTIONAL String (64)

The name of the digital wallets, such as GCash.

The value of this parameter is identical to that of pspName in the original payment or authorization request.

transactionType

MANDATORY String

Transaction type. Possible values are:

  • PAYMENT: indicates a payment process.
  • REFUND: indicates a refund process.
  • CANCEL: indicates a cancellation process.
  • AUTHORIZATION: indicates an authorization process.
  • CAPTURE: indicates a capture process.
  • VOID: indicates a void authorization.
  • DISPUTE: indicates a dispute process.

orderCreateTime

MANDATORY String

The time when the order is created.

orderModifyTime

MANDATORY String

The time when the order is modified. When there is no modification, the order motify time will be the same as orderCreateTime.

paymentTime

MANDATORY String (64)

The date and time when the corresponding transaction reaches a final status of success, in the format of YYYY-MM-DDTHH:MM:SS+hh:mm as defined in ISO 8601.

productCode

MANDATORY String

The type of payment product that is contracted between APO and the merchant. Valid values are:

  • AGREEMENT_PAYMENT: indicates the auto debit payment.
  • CASHIER_PAYMENT: indicates the cashier payment.

The value of this parameter is identical to that of productCode in the original payment or authorization request.

transactionAmountValue

MANDATORY String (16)

The transaction amount in major units of the corresponding currency (For example, USD for dollars, and JPY for yen).

transactionCurrency

MANDATORY String (3)

The currency of transactionAmountValue, specified by a 3-letter currency code as defined in ISO 4217.

originalTransactionRequestId

OPTIONAL String (64)

The original payment request ID of the transaction when transactionType is REFUND, CANCEL, or CAPTURE. Otherwise, the value of this parameter is empty.

installmentsNum

OPTIONAL String (8)

Indicates the number of installment payments.

issuingCountry

OPTIONAL String (2)

The issuing country or region of the card. The parameter is a 2-letter country or region code that follows the ISO 3166 Country Codes standard.

This parameter is specified when paymentMethodType is CARD.

The value of this parameter is identical to that of issuingCountry in the original payment or authorization request.

cardBrand

OPTIONAL String (256)

The brand of the card.

This parameter is specified when paymentMethodType is CARD.

The value of this parameter is identical to that of cardBrand in the original payment or authorization request.

funding

OPTIONAL String (20)

The funding type of the payment method. This parameter is returned when the value of paymentMethodType is CARD, GRABPAY_MY, or GRABPAY_SG.

When the value of paymentMethodType is CARD, valid values are:

  • CREDIT: indicates a credit card payment.
  • DEBIT: indicates a debit card payment.

When the value of paymentMethodType is GRABPAY_MY or GRABPAY_SG, valid values are:

  • WALLETS: indicates a regular wallet payment using the wallet balance.
  • BNPL_POSTPAID: indicates a buy-now-pay-later payment, and the buyer pays the full amount.
  • BNPL_INSTALLMENT: indicates a buy-now-pay-later payment, and the buyer pays in installments.

The value of this parameter is identical to that of funding in the original payment or authorization request.

status

OPTIONAL String

The order status.

outAcquirementId

OPTIONAL String

This original unique ID is assigned by the acquirer to identify a specific transaction on their system.

outAcquirementId

OPTIONAL String

This field contains optional business information that merchants define and provide at the transaction level.

Table 1. Parameters and descriptions in the transaction details report

Note: Use the header parameters to parse the transaction details report. The parameter order in the report downloaded from APO Dashboard may not match the parameter order displayed in Table 1.

Report samples

The following samples show transaction details reports in different scenarios.

Sample (Standard report)

On the transaction day of February 13, 2025, the merchant had many transactions, including authorization, capture, refund, dispute, payment, and cancellation. On February 14, 2025, APO generated a transaction details report in CSV. The details of the report are as follows:

copy
customerId,acquirer,referenceMerchantId,referenceStoreId,transactionId,originalTransactionId,transactionRequestId,referenceTransactionId,orderDescription,paymentMethodType,pspName,transactionType,orderCreateTime,orderModifyTime,paymentTime,productCode,transactionAmountValue,transactionCurrency,originalTransactionRequestId,installmentsNum,issuingCountry,cardBrand,funding,status,outAcquirementId,orderMetaData
"2111120000344090   ","ALIPAY   "," ","2188120120587153 ","20250213194010801300188840255593298  ","20250213194010800100188840277901343  ","amsdmrefund_${userConfig_user}_20250212_194743_646   "," ","AMSDM_GIFT   ","CARD "," ","REFUND   ","2025-02-13 11:47:46  ","2025-02-14 17:06:19  ","2025-02-13 11:47:49  ","GLOBAL_ONLINE_DIRECT_PAY ","-1100    ","KRW  ","amsdmpay_${userConfig_user}_20250212_180356_421  "," "," "," "," ","SUCCESS  "," "," "
"2111120000344090   ","ALIPAY   "," ","2188120120587153 ","20250213194010807000188840279461343  ","20250213194010800100188840277901343  ","amsdmpay_${userConfig_user}_20250212_180356_421  ","amsdmorder_${userConfig_user}_20250212_180356_421    ","AMSDM_GIFT   ","CARD "," ","CAPTURE  ","2025-02-13 10:03:59  ","2025-02-14 17:06:04  ","2025-02-13 10:17:35  ","GLOBAL_ONLINE_DIRECT_PAY ","1100 ","KRW  ","amsdmpay_${userConfig_user}_20250212_180356_421  "," "," "," "," ","SUCCESS  "," "," "
"2111120000344090   ","ALIPAY   "," ","2188120120587153 ","20250213194010800100188840277901343  "," ","amsdmpay_${userConfig_user}_20250212_180356_421  ","amsdmorder_${userConfig_user}_20250212_180356_421    ","AMSDM_GIFT   ","CARD "," ","AUTHORIZATION    ","2025-02-13 10:03:59  ","2025-02-13 10:17:35  ","2025-02-13 10:17:34  ","GLOBAL_ONLINE_DIRECT_PAY ","1100 ","KRW  "," "," "," "," "," ","SUCCESS  "," "," "
"2111120000344090   ","ALIPAY   "," ","2188120040699147 ","20250312194010800100188920281976193  "," ","amsdmpay_caosheng_csy_20250311_205057_390    ","amsdmorder_caosheng_csy_20250311_205057_390  ","AMSDM_GIFT   ","Alipay_CN    ","AlipayCN ","AUTHORIZATION    ","2025-03-12 11:50:58  ","2025-03-12 11:51:29  ","2025-03-12 11:51:29  ","GLOBAL_ONLINE_DIRECT_PAY ","0.01 ","USD  "," "," "," "," "," ","SUCCESS  "," "," "
"2111120000344090   ","ALIPAY   "," ","2188120040699147 ","20250312194010806300188920243018039  ","20250312194010800100188920281976193  ","amsdmpay_caosheng_csy_20250311_205057_390    ","amsdmorder_caosheng_csy_20250311_205057_390  ","AMSDM_GIFT   ","Alipay_CN    ","Alipay   ","VOID ","2025-03-12 11:50:58  ","2025-03-12 15:03:48  ","2025-03-12 15:03:47  ","GLOBAL_ONLINE_DIRECT_PAY ","-0.01    ","USD  ","amsdmpay_caosheng_csy_20250311_205057_390    "," "," "," "," ","SUCCESS  "," "," "
"2111120000344090   ","MOLPAY   "," "," ","20250218194010890100111820251042771  ","20250218194010890100111820251042771  ","amsdmpay_huizhen202502180019 ","amsdm_good_yuqian_fyf_20240410_143002_405    ","AMSDM_GIFT   ","CARD "," ","PAYMENT  ","2025-02-18 14:45:48  ","2025-02-18 14:46:05  ","2025-02-18 14:46:04  ","CASHIER_PAYMENT  ","1.20 ","MYR  ","amsdmpay_huizhen202502180019 "," ","CN   ","VISA ","CREDIT   ","SUCCESS  ","2709593310   "," "
"2111120000344090   ","MOLPAY   "," "," ","20250218194010890100111820251050326  ","20250218194010890100111820251042771  ","cff2bc130ca445609cac7a4e9ba82786 ","amsdm_good_yuqian_fyf_20240410_143002_405    ","AMSDM_GIFT   ","CARD "," ","CANCEL   ","2025-02-18 14:48:21  ","2025-02-18 14:48:24  ","2025-02-18 14:48:24  ","CASHIER_PAYMENT  ","-1.20    ","MYR  ","amsdmpay_huizhen202502180019 "," ","CN   ","VISA ","CREDIT   ","SUCCESS  ","2709593310   "," "

📎Transaction details report-Sample.csv

In this sample, the key information about the authorization, capture and refund is as follows:

  • Authorization information:
    • transactionId: The transaction ID is 202502131940108001001888402779xxxxx, which is the same value as paymentId in the original payment.
    • transactionAmountValue: The transaction amount is 1100 (KRW), which is the same value as paymentAmount.value in the original payment.
  • Capture information:
    • transactionId: The transaction ID is 202502131940108070001888402794xxxxx, which is the same value as captureId in the original capture.
    • transactionAmountValue: The transaction amount is 1100 (KRW), which is the same value as captureAmount.value in the original capture.
    • originalTransactionId: The original transaction ID is 202502131940108001001888402779xxxxx, which is the same as paymentId in the original payment request.
    • originalTransactionRequestId: The original payment request ID is amsdmpay_${userConfig_user}_20250212_180356_421, which is the same as TransactionRequestId in the original payment request.
  • Refund information:
    • transactionId: The transaction ID is 202502131940108013001888402555xxxxx, which is the same value as refundId in the original refund.
    • transactionAmountValue: The transaction amount is -1100 (KRW), which is the basic unit of refundAmount.value in the original refund.
    • originalTransactionId: The original transaction ID is 202502131940108001001888402779xxxxx, which is the same as paymentId in the original payment request.
    • originalTransactionRequestId: The original payment request ID is amsdmpay_${userConfig_user}_20250212_180356_421, which is the same as TransactionRequestId in the original payment request.

The key information about the payment and cancellation is as follows:

  • Payment information:
    • transactionId: The transaction ID is 202502181940108901001118202510xxxxx, which is the same value as paymentId in the original payment.
    • transactionRequestId: The unique ID assigned by a merchant to identify a transaction request is amsdmpay_huizhen2025021xxxxx, which is the same value as paymentRequestId in the original payment.
    • transactionAmountValue: The transaction amount is 1.20 (MYR), which is the basic unit of paymentAmount.value in the original payment.
  • Cancellation information:
    • transactionId: The transaction ID is 202502181940108901001118202510xxxxx, which is the same value as paymentId in the original payment.
    • transactionAmountValue: The transaction amount is -1.20 (MYR), which is the basic unit of paymentAmount.value in the original payment.
    • originalTransactionId: The original transaction ID is 202502181940108901001118202510xxxxx, which is the same value as paymentId in the original payment.
    • originalTransactionRequestId: The original transaction ID is amsdmpay_huizhen2025021xxxxx, which is the same value as TransactionRequestId in the original payment.