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)it 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) | 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 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. |
CASHIER_PAY : represent IN-APP payment transaction |
AGREEMENT_PAY : represent auto debit payment transaction |
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,, |