Transaction File (Merchant Interest Subsidy) Format
The transaction file (merchant interest subsidy) 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. |
16 | Interest_free_tag | String(1) | Indicates that the transaction have enable merchant subsidy |
17 | Activity_id | String(64) | The merchant subsidy activity id |
18 | Card_brand | String(64) | The installment bank name |
19 | Installments_num | String(2) | Number of the interest installments periods |
Record Detail
Partner_transaction_id,Transaction_id,Amount,Fee,Distribute_amount,Settlement,Currency,Payment_time,Settlement_time,Issue,Product,Type,Status,Remarks,Original_partner_transaction_ID,Interest_free_tag,Activity_id,Card_brand,Installments_num
6276895309058723,2017050221001003140213828085,0.10,0.00,,0.10,HKD,2017-05-02 14:41:14,,ALIPAYCN,Cross_wap,P,P,test1,6276895309058723,Y,PLYCFG2608271373670,ANTBANKBNPL,3
4133645818053569,2017050221001003360298122050,1.00,0.01,,0.99,HKD,2017-05-02 15:31:38,,ALIPAYHK,Cross_wap,P,P,test2,4133645818053569,Y,PLYCFG2608271373670,BOCI,3
3408856710504544,2017050221001003360298148619,0.99,0.01,,0.98,HKD,2017-05-02 15:46:35,,ALIPAYHK,Cross_wap,P,P,test3,3408856710504544,,,,
7520065377778011,2017050221001003360298148081,1.99,0.02,,1.97,HKD,2017-05-02 15:55:08,,ALIPAYHK,Cross_wap,P,P,test4,7520065377778011,Y,PLYCFG2608271373670,SCB,6
4688343898644090,2017050221001003360298193131,1.00,0.01,,0.99,HKD,2017-05-02 16:16:15,,ALIPAYHK,Cross_wap,P,P,test5,4688343898644090,Y,PLYCFG2608271373670,ANTBANKBNPL,12
5433317664128301,2017050221001003360298193495,1.00,0.01,,0.99,HKD,2017-05-02 16:21:18,,ALIPAYHK,Cross_wap,P,P,test6,5433317664128301,,,,
3179751587946773,2017050221001003140213828085,-0.10,0.00,,-0.10,HKD,2017-05-02 16:54:07,,ALIPAYCN,Cross_wap,R,P,test_refund1,6276895309058723,Y,PLYCFG2608271373670,ANTBANKBNPL,3