Transaction file

Last updated: 2019-10-10

The transaction files obtained from SFTP and Alipay global open platform are slightly different in contents.

Transaction file obtained from SFTP

The transaction file obtained from SFTP consists of two parts, which are the file header and the record details.

File header

The following table lists the fields in the file header:

No.Field

Type

(length)

Description
1PartnerString(16)

The unique ID that is assigned by Alipay to identify a partner. The ID is composed of 16 digits beginning with 2088.

2Payment_timeString(10)

The date when the transaction is completed. Format: YYYY-MM-DD

3Total_countNumber(9)

The total number of records in the file


Record details

The record details contain the following fields:

 No.FieldDescription

Example

1Partner_transaction_id

The unique ID that is assigned by the partner to identify a transaction in the partner system.

  • When the Transaction_type is PAYMENT, REVERSAL or CANCEL, the value is same as that of partner_trans_id.
  • When the Transaction_type is REFUND, the value is same as that of partner_refund_id.

124************************025

2Transaction_id

The unique ID that is composed of digits and assigned by Alipay to identify a transaction

2018*********************911

3Transaction_amount

The transaction amount in foreign currency

7.50

4Charge_amount

The commission fee that is charged for the transaction in foreign currency

0.01

5Currency

Settlement currency

EUR

6Payment_time

The date and time when the transaction is completed. Format: YYYY-MM-DD HH:MM:SS

2019-08-07 17:11:00

7Transaction_type

The transaction type. The value can be:

  • PAYMENT
  • REVERSAL
  • REFUND
  • CANCEL

PAYMENT

8RemarkRemarks


9Secondary_merchant_industry

The merchant category code that is assigned by Alipay to identify an industry. See MCC list for details.

5812

10Secondary_merchant_name

Secondary merchant name

Apple store

11Operator_name

Operator name, such as a store name or a taxi driver name

Apple store

12Order_scene

The business scenario where the transaction is completed. The value can be:

  • shopQrCode: Merchant QR mode
  • paymentQrCode: Barcode payment mode
  • transactionQrCode: Transaction QR mode
  • externalCreateOrder: Third-party Merchant QR Code (Standard mode)
  • transactionQrCode: Third-party Merchant QR Code (Simple mode)

externalCreateOrder

13Trans_currency

The pricing currency

EUR

14Trans_amount

The order amount in the pricing currency

7.50

15Trans_forex_rate

Exchange rate between the settlement currency and the pricing currency

1

Sample

Partner:208800000000|Payment_time: 2013-12-02|Total_count:4
Partner_transaction_id|Transaction_id|Transaction_amount|Charge_amount|Currency|Payment_time|Transaction_type|Remark|Secondary_merchant_industry|Secondary_merchant_name|Operator_name|Order_scene|Trans_currency|Trans_amount|Trans_forex_rate 
0001|201312020445|100|3|HKD|2013-12-02 10:45:42|PAYMENT||5812|xxx|xxx|shopQrCode|TWD|100|0.031 
0002|201312020446|100|3|HKD|2013-12-02 10:45:13|REVERSAL||5812|xxx|xxx|shopQrCode|TWD|100|0.031 
0003|201312020448|100|3|HKD|2013-12-02 10:45:09|REFUND|Refund|5812|xxx|xxx|shopQrCode|TWD|100|0.031 

Transaction file obtained from Alipay global open platform

When you view transaction information on Alipay global open platform, you can see the following fields:


No.

FieldDescriptionExample

1

TimeThe date and time when the transaction is completed. Format: YYYY.MM.DD HH:MM:SS2018.08.26 17:21:47

2

Transaction ID/Partner transaction IDThe unique ID that is composed of digits and assigned by Alipay to identify a transaction / The unique ID that is assigned by the partner to identify a transaction in the partner system. When Type is P, the value is same as that of partner_trans_id. When Type is R, the value is same as that of transaction_id.2018*********************911/FOREXREFUND_2018*********043

3

Gross AmountThe transaction amount in foreign currency and in CNY currency. When the transaction is a refund, the amount is a minus number.$-0.01/¥-0.06

4

SettlementThe settlement amount in foreign currency and in CNY currency.$ 2.00/¥12.00

5

FeeThe commission fee that is charged for the transaction in foreign currency and in CNY currency.$ 0.00/¥0.00

6

Discount AmountAmount of the discount voucher in foreign currency and in CNY currency.$ 2.00/¥12.00

7

CurrencySettlement currency

USD 6.352371

8

ProductIn-store payment product. The value is fixed as SPOT.SPOT

9

TypeThe transaction type. The value can be:

P: Payment transaction

R: Refund transaction

R

10

StatusTransaction status.
When Type is P, the value can be:

P: Payment succeeds

When Type is R, the value can be:

P: Refund succeeds

F: Refund failed

W: Refund process has not completed

Note: The value W is only available in the async refund process.
P

11

RemarksRemarks 

12

Operation

Action to process a transaction

Refund

Sample

在线交易3.png

If you have any question, please contact us