Settlement File Format

Record detail

The record details contain the following fields: 

No.FieldTypeDescription
1Partner_transaction_ idString(64)

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 partner_refund_id is empty, the value is same as that of partner_trans_id.
2Transaction_idString(64)

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

3AmountNumber(9,2)

Transaction amount in settlement currency

4

FeeNumber(9,2)

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

5

SettlementNumber(9,2)Settlement amount in settlement currency

6

CurrencyString(10)

Settlement currency

7

Payment_timeString(19)

The date and time when the transaction is completed. Format: yyyy-MM-dd HH:mm:ss

8

Settlement_timeString(19)

The date and time when the transaction is liquidated. Format: yyyy-MM-dd HH:mm:ss

9

TypeString(1)

Transaction type. The value can be:

P: Payment transaction

R: Refund transaction

10

StatusString(1)

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

11

RemarksString(256)

Remarks

12

Secondary_merchant_industryString(4)

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

13

Secondary_merchant_nameStringSecondary merchant name

14

Secondary_merchant_id

String

The unique ID assigned by the partner to identify a secondary merchant

15

Operator_nameString

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

16

Order_sceneString

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)

17

Trans_currencyString(10)

The pricing currency

18

Trans_amountNumber(9,2)

The order amount in the pricing currency

19

Trans_forex_rateString

Exchange rate between the settlement currency and the pricing currency

20

Issue

String

Payment method type. The value can be:

  • ALIPAYHK
  • ALIPAYCN

Sample

Partner_transaction_id|Transaction_id|Amount|Fee|Settlement|Currency|Payment_time|Settlement_time|Type|Status|Remarks|Secondary_merchant_industry|Secondary_merchant_name|Secondary_merchant_id|Operator_name|Order_scene|Trans_currency|Trans_amount|Trans_forex_rate

|Issue

EASA-20170801233604653-5GP0GVWNY|2017080221001004060213245489|369.30|2.22|367.08|AUD|2017-08-02 07:36:46|2017-08-03 15:46:00|P|L||5311|xxx|1234|xxx|shopQrCode|AUD|369.30|1|ALIPAYCN