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

An example of file content:

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