Settlement file

Last updated: 2019-12-30

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


If you have any question, please contact us