Settlement file

Last updated: 2019-9-9

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

Example

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.

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

2Transaction_id

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

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

3Amount

Transaction amount in foreign currency

39.30

4Rmb_amount

Transaction amount in CNY currency

201.38

5fee

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

0.01

6SettlementSettlement amount in foreign currency

39.30

7Rmb_settlementSettlement amount in CNY currency

201.38

8Currency

Settlement currency

EUR

9Rate

The exchange rate between Amount and Rmb_amount

7.84239700

10Payment_time

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

2018-08-20 20:26:30

11Settlement_time

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

2018-08-21 16:50:00

12Type

Transaction type. The value can be:

P: Payment transaction

R: Refund transaction

P

13Status

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

L

14Remarks

Remarks


15Secondary_merchant_industry

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

5812

16Secondary_merchant_name

Secondary merchant name

Apple store

17Operator_name

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

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)

externalCreateOrder

19Trans_currency

The pricing currency

EUR

20Trans_amount

The order amount in the pricing currency

39.3

21Trans_forex_rate

Exchange rate between the settlement currency and the pricing currency

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

Example

1

Payment Time

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

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

3

Gross Amount

Transaction amount in foreign currency and in CNY currencyS. $130.00 /¥643.07

4

Fee

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

S.$ 1.28

5

Net Amount

Settlement amount in foreign currency and in CNY currencyS. $126.72/ ¥626.85

6

CurrencySettlement currencySGD

7

RateThe exchange rate between Amount and Rmb_amount4.945000

8

Settlement TimeThe date and time when the transaction is liquidated. Format: YYYY.MM.DD HH:MM:SS2018.08.27 17:21:47

9

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

10

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

11

RemarksRemarks



Sample

在线结算3.png


If you have any question, please contact us