Transaction File Format

The transaction file contains a list of the following fields:

 No.FieldType(length)Description
1Partner_transaction_idString(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
2Transaction_idString(64)A numbered transaction ID (Unique inside the Alipay system)
3AmountNumber(9,2)Amount in list currency/refund amount in list currency
4FeeNumber(9,2)Commission fee
6SettlementNumber(9,2)Settlement amount in list currency
7CurrencyString(8)The currency given in the transaction request.
8Payment_timeString(19)

The time of transaction;

Format: YYYY-MM-DD HH:MM:SS

9Settlement_timeString(19)

The time of settlment;

Format: YYYY-MM-DD HH:MM:SS

10IssueString

Indicator of wallet version:

ALIPAYCN : Alipay

ALIPAYHK: AlipayHK

11ProductStringIdentifier for different Alipay products. Alipay and AlipayHK wap and sdk payment: Cross_wap
12TypeString(8)

Transaction type:

P: payment

R: refund

13StatusString(1)

Normal transaction: 

P: payment made

L: liquidated

Refundament transaction:

P: refund success 

L: liquidated

14RemarksString(256)Remarks
15original_partner_transaction_IDString(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

An example of file content:

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