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