Transaction file format

Transaction File Naming : MID_fptrade_YYYYMMDD.csv;

The single transaction file contains a list of the following fields:

 No.

Field

Type

Description

1

customerId

String(64)

Unique ID for AMS merchants

2

transactionId

String(64)

When transactionType is payment/authorization, transactionId is AMS paymentId.

When transactionType is capture, transactionId is AMS capture ID. 

3

originalTransactionId

String(64)

Original TransactionID.

4

transactionRequestId

String(64)

The unique request identifier of merchant transaction.

ie. paymentRequestId, refundRequestId

5

orderDescription

String(256)

Order Description

6

paymentMethodType

String(32)

Payment Method Type

AlipayHK

7

pspName

String(64)

The name of payment service proivder

8

transactionType

String(32)

Possible transaction type:

payment

refund

cancel

9

paymentTime

String(64)

Payment time, in ISO 8601 format YYYY-MM-DDTHH:MM:SS+hh:mm

10

productCode

String(32)

Product name:

In-store Payment

11

transactionAmountValue

String(16)

The gross amount of fund in order request

12

transactionCurrency

String(3)

The order currency

HKD

13

originalTransactionRequestId

String(64)

The original payment request id of the transaction when the transaction type is refund, cancel or capture when applicable.  Otherwise, it will be null

14

voucherAmount

String(16)

Cashless voucher amount