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 type：REFUND, 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 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
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,,