Alipay, China's leading third-party online payment solutionAlipay, China's leading third-party online payment solution

      Settlement File - Detail

      #File information

      No.ParameterValueExample
      1File Typealipay.intl.acquiring.settlement.detail
      2File Version2.0.4
      3Provideralipay
      4File formatTXT
      5Directory/download/_//download/IPAY/12345678/20181201
      6FilenameALIPAY_SETTLEMENT_DETAIL__.csvALIPAY_SETTLEMENT_DETAIL_CNY_20160730.csv
      7Scheduledaily
      8RemarksThe format of date is YYYYMMDD.


      #File content

      No.ParameterTypeLengthRequiredDescription

      Example

      1merchantIdmerchantId64YThe merchant ID12345678
      2sellerIDString64NThe seller ID2188xxxxxxxx7080
      3storeIdString64NThe store ID1234
      4transTypeString1YThe transaction type. The value can be PAYMENT, REFUND, or CANCEL.PAYMENT
      5productCodeString64YThe product code. The value can be AUTO_DEBIT, GlobalOfflineAcquire, or AUTH_CAPTURE.AUTO_DEBIT
      6remarkString256NThe remarkPurchases on 08.04
      7acquirementIdString64NThe unique Alipay transaction ID2016xxxxx004680219786774
      8originalAcquirementIdString64YThe original Alipay transaction ID. When the value of transType is payment, the value of originalAcquirementId is empty. When the value of transType is refund, the value of originalAcquirementId is the Alipay payment transaction ID.2016xxxxx004680219786774
      9paymentTimeString64YThe payment time in ISO 8601 format: YYYY-MM-DDTHH:MM:SS+hh:mm2001-07-04T00:00:00+08:00
      10userSiteString64YThe payment user site. The value can be:

      ALIPAY_CN: Alipay site for Chinese mainland

      ALIPAY_HK: Alipay site for Hong Kong, China

      KAKAOPAY: KakaoPay

      ALIPAY_CN
      11referenceIdString64YThe settlement reference ID.1357924680
      12settlementTimeString64YThe settlement time in ISO 8601 format: YYYY-MM-DDTHH:MM:SS+hh:mm2001-07-04T00:00:00+08:00
      13merchantTransIdString64YThe unique ID assigned by the merchant to identify a transactionMQSWD65N79a1
      14orderAmountNumber(10,2)YThe transaction amount in the currency defined in orderCurrency73
      15orderCurrencyString3YThe transaction currencyCNY
      16commissionNumber(10,2)YThe commission fee in settlement currency-0.73
      17commissionCurrencyString3YThe commission currency codeUSD
      18settlementAmountNumber(10,2)YThe net settlement amount in settlement currency72.27
      19settlementCurrencyString3YThe settlement currencyCNY
      20conversionRateNumber(8,4)

      N

      The currency conversion rate6.7037
      21conversionRateRelationString64

      N

      The currency pairUSD/CNY


      #Sample

      #File name        

      copy
      ALIPAY_SETTLEMENT_DETAIL_CNY_20160730.csv


      #File content

      copy
      merchantId,sellerId,storeId,transType,productCode,remark,acquirementId,originalAcquirementId,paymentTime,userSite,referenceId,settlementTime,merchantTransId,orderAmount,orderCurrency,commission,commissionCurrency,settlementAmount,settlementCurrency,conversionRate,conversionRateRelation
      2188xxxxxxxx7080,123,1234,PAYMENT,AUTO_DEBIT,Purchases on 08.04,2016xxxxx004680219786774,2016xxxxx004680219786774,2016-08-05T16:35:25+08:00,ALIPAY_CN,2016080521001004100285676126,2016-08-05T16:35:25+08:00,MQSWD65N79a1,73.00,CNY,0.73,USD,72.27,CNY,6.7037,USD/CNY