Transaction File - Detail

File information

No.

Parameter

Value

Example

1File Typealipay.intl.acquiring.transaction.detail
2File Version2.0.4
3Provideralipay
4File formatTXT
5Directory/download/<merchantId>/<date>/download/IPAY/12345678/20181201
6FilenameALIPAY_TRANSACTION_DETAIL_<currency>_<date>.csvALIPAY_TRANSACTION_DETAIL_HKD_20160730.csv
7Scheduledaily

8

Remarks

The format of date is YYYYMMDD.

File content

No.

Parameter

Type

Length

Required

Description

Sample

1

merchantId

String

64

Y

The merchant ID

218xxxxx6240

2

sellerID

String

64

N

The seller ID

123

3

storeId

String

64

N

The store ID

1234

4

productCode

String

64

Y

The product code. The value can be AUTO_DEBITGlobalOfflineAcquire, or AUTH_CAPTURE.

AUTO_DEBIT

5

paymentTime

String

64

Y

The payment time, in ISO 8601 format:   YYYY-MM-DDTHH:MM:SS+hh:mm

2001-07-04T00:00:00+08:00

6

orderTitle

String

256

N

The transaction title

Pencil

7

transType

String

64

Y

The transaction type. The value can be PAYMENTREFUND, or CANCEL.

PAYMENT

8

transStatus

String

64

Y

Transaction status

Success

9

merchantTransId

String

64

Y

The unique ID assigned by the merchant to identify a transaction

MQAWD65N79a1

10

acquirementId

String

64

Y

The unique Alipay transaction ID

2018xxxxxxxx10800100188320004337018

11

originalAcquirementId

String

64

N

The 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 transaction ID.

2018xxxxxxxx10800100188320004337018

12

orderAmount

Number

(10,2)

Y

The transaction amount in the transaction currency

73.00

13

orderCurrency

String

3

Y

The transaction currency

CNY

14

remark

String

256

N

The remark

Purchases on 08.04

15

userSite

String

64

Y

The payment user site

ALIPAY_CN

16

siteUserId

String

64

N

The site user ID

2088xxxxxxxx6240

Sample

File name

copy
ALIPAY_TRANSACTION_DETAIL_CNY_20160730.csv

File Content

copy
merchantId,sellerId,storeId,productCode,paymentTime,orderTitle,transType,transSTatus,merchantTransId,acquirementId,originalAcquirementId,orderAmount,orderCurrency,remark,userSite,siteUserId
218xxxxx6240,123,1234,AUTO_DEBIT,2016-08-05T16:35:25+08:00,Pencil,PAYMENT,Success,MQSWD65N79a1,2018xxxxxxxx10800100188320004337018,2018xxxxxxxx10800100188320004337018,73.00,CNY,Purchases on 08.04,Alipay_CN,2088xxxxxxxx6240