Transaction file format
Transaction File Naming: MID_fptrade_YYYYMMDD.csv;
The single transaction file contains a list of the following fields:
No. | Field | Type | 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. Default is null in the transaction file. Please refer to the same field in the settlement file. |
6 | Currency | String(3) | The currency given in the transaction request. |
7 | Payment_time | String(64) | The time of the transaction. Format: MM/DD/YYYY HH:MM:SS |
8 | Settlement_time | String(64) | The time of settlement. Default is null in the transaction file. Please refer to the same field in Settlement file. Format: MM/DD/YYYY HH:MM:SS |
9 | Issue | String(64) | Indicator of wallet version (Blank by default) |
10 | Product | String(64) | The identifier for different payment scene: CASHIER_PAY: represents the IN-APP payment transaction. AGREEMENT_PAY: represents the auto debit payment transaction. |
11 | Type | String(64) | Transaction type: REFUND, CANCEL, PAYMENT. |
12 | Status | String(64) | SUCCESS |
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 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
Partner_transaction_id,Transaction_id,Amount,Fee,Settlement,Currency,Payment_time,Settlement_time,Issue,Product,Type,Status,Remarks,Original_partner_transaction_ID
20183333333333333333333333,20181227194010800100160650009253449,3.33,,,HKD,12/27/2018 2:02,,,,PAYMENT,SUCCESS,,
20182222222222222222222222,20181227194010800100160650009253448,2.22,,,HKD,12/27/2018 1:59,,,,PAYMENT,SUCCESS,,