Settlement file format

Settlement File Naming: MID_settle_YYYYMMDD_BatchID.csv;

The single settlement file contains a list of the following fields:

 No.

Field

Type(Byte)

Description

1

Partner_transaction_id

String(64)

A numbered transaction ID(unique in partner system), which is equal to merchantTransId when 

transaction type is in (payment, cancel). It is equal to merchantRefundId when transaction type is refund.

2

Transaction_id

String(64)

A numbered transaction ID (Unique inside the AlipayHK system).

3

Amount

Number(10,2)

Amount in list currency/refund amount in list currency

4

Fee

Number(10,2)

Commission fee

5

Settlement

Number(10,2)

Settlement amount in list currency

6

Currency

String(3)

The currency given in the transaction request.

7

Payment_time

String(64)

The time of transaction.

Format: MM/DD/YYYY HH:MM:SS

8

Settlement_time

String(64)

The time of settlement;

Format: MM/DD/YYYY HH:MM:SS

9

Issue

String(64)

Indicator of wallet version: The default value is null.

10

Product

String(64)

The identifier for different payment scene

11

Type

String(64)

Transaction typeREFUND, CANCEL, PAYMENT.

12

Status

String(64)

SETTLED. 

13

Remarks

String(256)

Remarks

14

original_partner_transaction_ID

String(64)

Original partner transaction ID. In the payment request, the value of this field is NULL. In the 

refund request, the value of this field is the same as that for the partner_transaction_ID of 

the original transaction in the corresponding payment request.

 

File Sample

copy
Partner_transaction_id,Transaction_id,Amount,Fee,Settlement,Currency,Payment_time,Settlement_time,Issue,Product,Type,Status,Remarks,Original_partner_transaction_ID
Merchant_Refund_Id_122112,20181225194010800100160610009243868,0.2,0,-0.2,HKD,12/26/2018 0:55,12/27/2018 9:40,,CASHIER_PAY,REFUND,SETTLED,,
20181220194010800100160650009000664,20181220194010800100160650009000664,0.3,0,-0.3,HKD,12/20/2018 3:30,12/27/2018 9:40,,CASHIER_PAY,CANCEL,SETTLED,,
Merchant_Refund_Id_122102,20181219194010800100160700009017566,10,0,-9.9,HKD,12/21/2018 6:47,12/27/2018 9:40,,CASHIER_PAY,REFUND,SETTLED,,
201812260756161102217,20181225194010800100160610009243871,0.4,0,0.4,HKD,12/25/2018 23:56,12/27/2018 9:40,,CASHIER_PAY,PAYMENT,SETTLED,,
gujiu_20181224_00003,20181226194010800100160610009243881,10,0.1,9.9,HKD,12/26/2018 0:40,12/27/2018 9:40,,AGREEMENT_PAY,PAYMENT,SETTLED,,
Merchant_Refund_Id_122111,20181225194010800100160610009243871,0.4,0,-0.4,HKD,12/26/2018 0:54,12/27/2018 9:40,,CASHIER_PAY,REFUND,SETTLED,,