交易明细报告

交易明细报告包含 T 日所有成功交易的明细,您可以通过 APO Dashboard 来获取该报告。

报告详情

交易明细报告包含三部分内容:表头信息、交易详情和文件结束符。文件结束符 <END> 出现在报告的最后一行,表头信息由如下字段名表示,交易详情由字段对应的值表示。

下表展示了交易明细报告正文中的字段及字段说明:

字段

说明

customerId

必选 String (64)

收单机构为商家分配的唯一身份标识号。

acquirer

必选 String (64)

负责交易处理的收单机构的名字。

该收单机构主要是指为您提供收单和资金结算服务的机构。

referenceMerchantId

可选 String (64)

直接向买家提供服务或商品的商家唯一标识,由商户分配给其二级商户。

该字段的值与原支付或授权请求中的 referenceMerchantId 字段的值相同。

referenceStoreId

可选 String (64)

商家店铺的唯一标识,由商户分配给其二级商户。

transactionId

必选 String (64)

APO 分配的交易唯一标识。该字段的值遵循以下规则:

  • transactionType PAYMENTCANCELAUTHORIZATION 时,该字段的值与 paymentId 的值相同。
  • transactionTypeCAPTURE 时,该字段的值与 captureId 的值相同。
  • transactionTypeREFUND 时,该字段的值与 refundId 的值相同。
  • transactionTypeDISPUTE 时,该字段的值与 disputeId 的值相同。
  • 当 transactionType 为 VOID 时,该字段的值为 APO 的内部 ID

originalTransactionId

可选 String (64)

原始交易的标识符。

  • transactionType PAYMENTCANCEL 或 AUTHORIZATION 时,该字段的值为空。
  • transactionType VOID 时,该字段的值与原授权请求的 paymentId 相同。
  • transactionType REFUND 时,该字段的值与原支付或授权请求的 paymentId 相同。
  • transactionType CAPTURE 时,该字段的值与原授权请求的 paymentId 相同。
  • transactionType DISPUTE 时,该字段的值与原授权请求的 paymentId 相同。

transactionRequestId

必选 String (64)

商家分配的交易请求唯一标识。该字段的值与付款的 paymentRequestId 的值相同,或与退款的 refundRequestId 的值相同。

transactionTypeDISPUTE 时,该字段为空。

referenceTransactionId

可选 String (64)

直接向买家提供服务或商品的商家分配的用于识别交易的唯一标识。该字段的值与付款的 referenceOrderId 的值相同。

transactionTypeCANCEL, CAPTUREDISPUTE 时,该字段为空。

orderDescription

可选 String (256)

订单的说明。

该字段的值与原支付或授权请求中的 orderDescription 字段的值相同。

paymentMethodType

必选 String (32)

支付方式。

该字段的值与原先支付或授权请求中paymentMethodType 字段的值相同

pspName

可选 String (64)

电子钱包名称,例如 Gcash。

该字段的值原先支付或授权请求中的 pspName 字段的值相同

transactionType

必选 String

交易类型,包含的值如下:

  • PAYMENT:表示交易类型为支付。
  • REFUND:表示交易类型为退款。
  • CANCEL:表示交易类型为取消。
  • AUTHORIZATION:表示交易类型为卡支付预授权。
  • CAPTURE:表示交易类型为卡支付授权后请款。
  • VOID:表示交易类型为卡支付预授权解除。
  • DISPUTE: 表示交易类型为争议。

orderCreateTime

必选 String

订单创建时间。

orderModifyTime

必选 String

订单更新时间。

若没有更新,那订单更新时间与 orderCreateTime 相同。

paymentTime

必选 String (64)

交易达到成功或失败终态的日期和时间,格式为 YYYY-MM-DDTHH:MM:SS+hh:mm,遵循 ISO 8601 标准。

productCode

必选 String

APO 和商家合同中约定的支付产品类型。值包含如下:

  • AGREEMENT_PAYMENT:表示代扣。
  • CASHIER_PAYMENT:表示收银台。

该字段的值与原支付或授权请求中的 productCode 字段的值相同。

transactionAmountValue

必选 String (16)

交易金额,以主要币种单位展示(例如美元用 USD 表示,日元用 JPY 表示)。

transactionCurrency

必选 String (3)

transactionAmountValue 对应的币种,为 ISO 4217 中定义的三位字母币种代码 。

originalTransactionRequestId

可选 String (64)

交易类型为 REFUNDCANCELCAPTURE 时交易的原先支付请求 ID。该字段在其它情况下为空。

installmentsNum

可选 String (8)

表示分期付款的期数。

issuingCountry

可选 String (2)

发卡国家或地区。该字段值是遵循 ISO 3166 Country Codes 标准的二位国家码。

paymentMethodTypeCARD 时该字段有值。

该字段的值与原支付或授权请求中的 issuingCountry 字段的值相同。

cardBrand

可选 String (256)

卡品牌。

paymentMethodTypeCARD 时该字段有值。

该字段的值与原支付或授权请求中的 cardBrand 字段的值相同。

funding

可选 String (20)

支付方式的资金类型。当 paymentMethodTypeCARDGRABPAY_MY,或 GRABPAY_SG 时该字段有值。

paymentMethodTypeCARD 时,包含值如下:

  • CREDIT: 表示为信用卡。
  • DEBIT: 表示为借记卡。

paymentMethodTypeGRABPAY_MY,或 GRABPAY_SG 时,包含值如下:

  • WALLETS: 表示为钱包余额支付。
  • BNPL_POSTPAID: 表示先买后付,且一次性付清。
  • BNPL_INSTALLMENT: 表示先买后付,且分期付款。

该字段的值与原支付或授权请求中的 funding 字段的值相同。

status

可选 String

订单状态。

outAcquirementId

可选 String

收单机构分配的唯一原始 ID,用于在其系统中识别特定交易。

orderMetadata

可选 String

可选的业务信息,由商户在交易层级定义并提供。

表 1. 交易明细报告字段及说明

注意:请利用表头字段信息进行账单解析。您从 APO Dashboard 所下载的账单中的字段顺序不一定与上方报告中显示的字段顺序一致。

报告样例

在 2025 年 2 月 13 日(交易日), 商家产生了多笔交易,分别为授权、请款、退款、争议、付款、取消。在 2025 年 2 月 14 日,APO 生成了一个 CSV 交易明细报告文件,详情如下:

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   "," "

📎交易明细报告样例.csv

在本样例中,授权、请款和退款的重要信息如下:

  • 授权信息
    • transactionId:交易流水号 202502131940108001001888402779xxxxx,与原授权支付中的 paymentId 的值相同。
    • transactionAmountValue:交易金额 1100 (KRW),与原授权支付中的 paymentAmount.value 的相同。
  • 请款信息
    • transactionId:交易流水号 202502131940108070001888402794xxxxx,与原请款中的 captureId 的值相同。
    • transactionAmountValue:交易金额 1100 (KRW),为原请款中的 captureAmount.value 的基础单位的值。
    • originalTransactionId:原始交易流水号 202502131940108001001888402779xxxxx,与原授权支付请求中的 paymentId 相同
    • originalTransactionRequestId:原先支付请求 ID amsdmpay_${userConfig_user}_20250212_180356_421,与原授权支付请求中的 TransactionRequestId 相同。
  • 退款信息
    • transactionId:交易流水号 202502131940108013001888402555xxxxx,与原退款中的 refundId 的值相同。
    • transactionAmountValue:交易金额 -1100 (KRW) ,为原退款中的 refundAmount.value 的基础单位的值。
    • originalTransactionId:原始交易流水号 202502131940108001001888402779xxxxx,与原授权支付请求中的 paymentId 相同
    • originalTransactionRequestId:原先支付请求 ID amsdmpay_${userConfig_user}_20250212_180356_421,与原授权支付请求中的 TransactionRequestId 相同。

付款和取消的重要信息如下:

  • 付款信息
    • transactionId:交易流水号 202502181940108901001118202510xxxxx,为原支付中的 paymentId 的值相同。
    • transactionRequestId:商家分配的交易请求唯一标识为 amsdmpay_huizhen2025021xxxxx,与原支付的 paymentRequestId 的值相同。
    • transactionAmountValue:交易金额 1.20 (MYR),为原支付中的 paymentAmount.value 的基础单位的值。
  • 取消信息
    • transactionId:交易流水号 202502181940108901001118202510xxxxx,为原支付中的 paymentId 的值相同。
    • transactionAmountValue:交易金额 -1.20 (MYR),为原支付中的 paymentAmount.value 的基础单位的值。
    • originalTransactionId:原始交易流水号 202502181940108901001118202510xxxxx,与原支付请求中的 paymentId 相同
    • originalTransactionRequestId:原先支付请求 ID amsdmpay_huizhen2025021xxxxx,与原支付请求中的 TransactionRequestId 相同。