The transaction files obtained from SFTP and Alipay global open platform are slightly different in contents.
Transaction file obtained from SFTP
The transaction file obtained from SFTP consists of two parts, which are the file header and the record details.
The following table lists the fields in the file header:
The unique ID that is assigned by Alipay to identify a partner. The ID is composed of 16 digits beginning with 2088.
The date when the transaction is completed. Format: YYYY-MM-DD
The total number of records in the file
The record details contain the following fields:
The unique ID that is assigned by the partner to identify a transaction in the partner system.
The unique ID that is composed of digits and assigned by Alipay to identify a transaction
The transaction amount in foreign currency
The commission fee that is charged for the transaction in foreign currency
The date and time when the transaction is completed. Format: YYYY-MM-DD HH:MM:SS
The transaction type. The value can be:
The merchant category code that is assigned by Alipay to identify an industry. See MCC list for details.
Secondary merchant name
Operator name, such as a store name or a taxi driver name
The business scenario where the transaction is completed. The value can be:
The pricing currency
The order amount in the pricing currency
Exchange rate between the settlement currency and the pricing currency
Transaction file obtained from Alipay global open platform
When you view transaction information on Alipay global open platform, you can see the following fields:
|Time||The date and time when the transaction is completed. Format: YYYY.MM.DD HH:MM:SS||2018.08.26 17:21:47|
|Transaction ID/Partner transaction ID||The unique ID that is composed of digits and assigned by Alipay to identify a transaction / The unique ID that is assigned by the partner to identify a transaction in the partner system. When Type is P, the value is same as that of partner_trans_id. When Type is R, the value is same as that of transaction_id.||2018*********************911/FOREXREFUND_2018*********043|
|Gross Amount||The transaction amount in foreign currency and in CNY currency. When the transaction is a refund, the amount is a minus number.||$-0.01/￥-0.06|
|Settlement||The settlement amount in foreign currency and in CNY currency.||$ 2.00/￥12.00|
|Fee||The commission fee that is charged for the transaction in foreign currency and in CNY currency.||$ 0.00/￥0.00|
|Discount Amount||Amount of the discount voucher in foreign currency and in CNY currency.||$ 2.00/￥12.00|
|Product||In-store payment product. The value is fixed as SPOT.||SPOT|
transaction type. The value can be:|
P: Payment transaction
R: Refund transaction
When Type is P, the value can be:
P: Payment succeedsWhen Type is R, the value can be:
P: Refund succeeds
F: Refund failed
W: Refund process has not completedNote: The value W is only available in the async refund process.
Action to process a transaction