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

      Settlement file

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


      #Settlement file obtained from SFTP

      The settlement file obtained from SFTP contains the record details of the settlement cycle.

      #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 is cancelled, the value is same as that of transaction_id.
      • 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 partner_refund_id.
      • When the transaction is reversed, the value is same as that of partner_trans_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

      3Amount

      Transaction amount in foreign currency

      Example: 39.3

      4Rmb_amount

      Transaction amount in CNY currency

      Example: 201.38

      5fee

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

      Example: 0.01

      6Settlement

      Settlement amount in foreign currency

      Example: 39.30

      7Rmb_settlement

      Settlement amount in CNY currency

      Example: 201.38

      8Currency

      Settlement currency

      Example: EUR

      9Rate

      The exchange rate between Amount and Rmb_amount

      Example: 7.84239700

      10Payment_time

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

      Example: 2018-08-20 20:26:30

      11Settlement_time

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

      Example: 2018-08-21 16:50:00

      12Type

      Transaction type. The value can be:

      P: Payment transaction

      R: Refund transaction

      Example: P

      13Status

      Transaction status. For both payment and refund transactions, the value is L, which means Transaction Liquidated.

      Example: L

      14Remarks

      Remarks

      15Secondary_merchant_industry

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

      Example: 5812

      16Secondary_merchant_name

      Secondary merchant name

      Example: Apple store

      17Operator_name

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

      Example: Apple store

      18Order_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

      19Trans_currency

      The pricing currency

      Example: EUR

      20Trans_amount

      The order amount in the pricing currency

      Example: 39.3

      21Trans_forex_rate

      Exchange rate between the settlement currency and the pricing currency

      Example: 1


      #Sample

      Partner_transaction_id|Transaction_id|Amount|Rmb_amount|Fee|Settlement|Rmb_settlement|Currency|Rate|Payment_time|Settlement_time|Type|Status|Remarks|Secondary_merchant_industry|Secondary_merchant_name|Operator_name|Order_scene|Trans_currency|Trans_amount|Trans_forex_rate
      EASA-20170801233604653-5GP0GVWNY|2017080221001004060213245489|369.30|2001.38|2.22|367.08|1989.37|AUD|5.41940000|2017-08-02 07:36:46|2017-08-03 15:46:00|P|L||5311|xxx|xxx|shopQrCode|AUD|369.30|1

      #Settlement file obtained from Alipay global open platform

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


      No.

      FieldDescription

      1

      Payment 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

      Partner_transaction_id

      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 partner_refund_id.
      • When the transaction is cancelled or reversed without the partner_refund_id, the value is same as that of partner_trans_id.

      Example: 123456789012345

      3

      Gross Amount

      Transaction amount in foreign currency and in CNY currency

      Example: S. $130.00 /¥643.07

      4

      Fee

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

      Example: S.$ 1.28

      5

      Net Amount

      Settlement amount in foreign currency and in CNY currency

      Example: S. $126.72/ ¥626.85

      6

      Currency

      Settlement currency

      Example: SGD

      7

      Rate

      The exchange rate between Amount and Rmb_amount

      Example: 4.945000

      8

      Settlement Time

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

      Example: 2018.08.27 17:21:47

      9

      Type

      Transaction type. The value can be:
      P: Payment transaction
      R: Refund transaction

      Example: P

      10

      Status

      Transaction status. For both payment and refund transactions, the value is L, which means Transaction Liquidated.

      Example: L

      11

      RemarksRemarks


      #Sample

      在线结算3.png