Settlement File Format

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.

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

Transaction amount in settlement currency

4

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

5

6

Settlement currency

7

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

8

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

9

Transaction type. The value can be:

P: Payment transaction

R: Refund transaction

10

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

11

Remarks

12

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

13

14

Secondary_merchant_id

String

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

15

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

16

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

The pricing currency

18

The order amount in the pricing currency

19

Exchange rate between the settlement currency and the pricing currency

20

Issue

String

Payment method type. The value can be:

• ALIPAYHK
• ALIPAYCN