Transaction File Format
The transaction file contains a list of the following fields:
| No. | Field | Type(length) | Description |
| 1 | Partner_transaction_id | String(64) | A numbered transaction ID(unique in partner system)it is equal to “partner_trans_id” when transaction type is in (payment,reversal,reverse); it is equal to “partner_refund_id” when transaction type is refund |
| 2 | Transaction_id | String(64) | A numbered transaction ID （Unique inside the Alipay system） |
| 3 | Amount | Number(9,2) | Amount in list currency/refund amount in list currency |
| 4 | Fee | Number(9,2) | Commission fee |
| 6 | Settlement | Number(9,2) | Settlement amount in list currency |
| 7 | Currency | String(8) | The currency given in the transaction request. |
| 8 | Payment_time | String(19) | The time of transaction; Format: YYYY-MM-DD HH:MM:SS |
| 9 | Settlement_time | String(19) | The time of settlment; Format: YYYY-MM-DD HH:MM:SS |
| 10 | Issue | String | Indicator of wallet version: ALIPAYCN : Alipay ALIPAYHK: AlipayHK |
| 11 | Product | String | Identifier for different Alipay products. Alipay and AlipayHK wap and sdk payment: Cross_wap |
| 12 | Type | String(8) | Transaction type： P: payment R: refund |
| 13 | Status | String(1) | Normal transaction: P: payment made L: liquidated Refundament transaction: P: refund success L: liquidated |
| 14 | Remarks | String(256) | Remarks |
| 15 | original_partner_transaction_ID | String(64) | The original partner transaction ID. When the transaction is a payment, the value is same with that of out_trade_no. When the transaction is a refund, the value is same with that of out_return_no. |
Record Detail
Partner_transaction_id,Transaction_id,Amount,Fee,Settlement,Currency,Payment_time,Settlement_time,Issue,Product,Type,Status,Remarks,Original_partner_transaction_ID
6276895309058723 ,2017050221001003140213828085 ,0.10,0.00,,0.10,HKD,2017-05-02 14:41:14,2017-05-23 15:36:00,ALIPAYCN,Cross_wap,P,P,test1,
4133645818053569 ,2017050221001003360298122050 ,1.00,0.01,,0.99,HKD,2017-05-02 15:31:38,2017-05-23 15:36:00,ALIPAYHK,Cross_wap,P,P,test2,
3408856710504544 ,2017050221001003360298148619 ,0.99,0.01,,0.98,HKD,2017-05-02 15:46:35,2017-05-23 15:36:00,ALIPAYHK,Cross_wap,P,P,test3,
7520065377778011 ,2017050221001003360298148081 ,1.99,0.02,,1.97,HKD,2017-05-02 15:55:08,2017-05-23 15:36:00,ALIPAYHK,Cross_wap,P,P,test4,
4688343898644090 ,2017050221001003360298193131 ,1.00,0.01,,0.99,HKD,2017-05-02 16:16:15,2017-05-23 15:36:00,ALIPAYHK,Cross_wap,P,P,test5,
5433317664128301 ,2017050221001003360298193495 ,1.00,0.01,,0.99,HKD,2017-05-02 16:21:18,2017-05-23 15:36:00,ALIPAYHK,Cross_wap,P,P,test6,
3179751587946773 ,2017050221001003140213828085 ,-0.10,0.00,,-0.10,HKD,2017-05-02 16:54:07,2017-05-23 15:36:00,ALIPAYCN,Cross_wap,R,P,test_refund1,6276895309058723