# Transaction details report > The transaction details report provides a detailed record of successful transactions on T day. The transaction details report provides a detailed record of successful transactions on T day. You can obtain this report through [APO Dashboard](https://global.alipay.com/docs/ac/apo/reconcile#pIfZG). # Report details The transaction details report consists of three parts: header information, transaction details, and the end-of-file 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 valid values are: - Kakao Pay: `KAKAOPAY` - NAVERPAY: `NAVERPAY` - Toss Pay: `TOSSPAY` - Alipay: `ALIPAY_CN` - WeChat Pay: `WECHATPAY` 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](https://www.iso.org/iso-8601-date-and-time-format.html). | | _productCode_ | **MANDATORY** String The type of payment product that is contracted between APO and the merchant. Valid values are: - `AGREEMENT_PAYMENT`: indicates Tokenized Payment. - `CASHIER_PAYMENT`: indicates One-time Payments. 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](https://www.iso.org/iso-4217-currency-codes.html). | | _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](https://www.iso.org/obp/ui/#search) 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. | | _orderMetadata_ | **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: ```plaintext 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](https://idocs-assets.marmot-cloud.com/storage/idocs87c36dc8dac653c1/yuque/idocs/2025/csv/eca91d90-3088-4748-906f-ecb71ceeaa9d.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 _capture__Amount.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.