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

      Transaction file

      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
      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.

      Example: 124************************025

      2Transaction_id

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

      Example: 2018*********************911

      3Transaction_amount

      The transaction amount in foreign currency

      Example: 7.50

      4Charge_amount

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

      Example: 0.01

      5Currency

      Settlement currency

      Example: EUR

      6Payment_time

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

      Example: 2019-08-07 17:11:00

      7Transaction_type

      The transaction type. The value can be:

      • PAYMENT
      • REVERSAL
      • REFUND
      • CANCEL

      Example: PAYMENT

      8RemarkRemarks
      9Secondary_merchant_industry

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

      Example: 5812

      10Secondary_merchant_name

      Secondary merchant name

      Example: Apple store

      11Operator_name

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

      Example: 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)

      Example: externalCreateOrder

      13Trans_currency

      The pricing currency

      Example: EUR

      14Trans_amount

      The order amount in the pricing currency

      Example: 7.50

      15Trans_forex_rate

      Exchange rate between the settlement currency and the pricing currency

      Example: 1

      #Sample

      copy
      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.

      		FieldDescription

      1

      		Time

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

      Example: 2018.08.26 17:21:47

      2

      		Transaction ID/Partner transaction ID

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

      Example: 2018*********************911/FOREXREFUND_2018*********043

      3

      		Gross Amount

      The transaction amount in foreign currency and in CNY currency. When the transaction is a refund, the amount is a minus number.

      Example: $-0.01/￥-0.06

      4

      		Settlement

      The settlement amount in foreign currency and in CNY currency.

      Example: $ 2.00/￥12.00

      5

      		Fee

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

      Example: $ 0.00/￥0.00

      6

      		Discount Amount

      Amount of the discount voucher in foreign currency and in CNY currency.

      Example: $ 2.00/￥12.00

      7

      		Currency

      Settlement currency

      Example: USD 6.352371

      8

      		Product

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

      Example: SPOT

      9

      		TypeThe transaction type. The value can be:

      P: Payment transaction

      R: Refund transaction

      Example: R

      10

      		Status

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

      P: Payment succeeds

      When Type is R, the value can be:

      S: Refund succeeds

      F: Refund failed

      W: Refund process has not completed

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

      Example: P

      11

      		RemarksRemarks

      12

      Operation

      Action to process a transaction

      Example: Refund

      #Sample

      在线交易3.png