Settlement file format

Settlement File Naming: MID_settle_YYYYMMDD_BatchID.csv;

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

 No.

Field

Type(Byte)

Description

1

settlementBatchId

String(64)

Settlement batch code, corresponding to the settlement batch number in Summary Files.

2

customerId

String(64)

The unique ID for AMS merchants

3

transactionId

String(64)

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

When transactionType is capture, transactionId is AMS captureId.

When transactionType is refund, transactionId is AMS refundId

4

originalTransactionId

String(64)

When transType is payment/cancel,orignalTransactionId is null.

When transType is refund,orignalTransactionId is Alipay paymentId of the original payment or authorization. 

5

transactionRequestId

String(64)

The unique request identifier of transaction.  ie.  paymentRequestId, refundRequestId

6

paymentMethodType

String(64)

Payment Method Type

AlipayHK

7

pspName

String(64)

The name of payment service proivder

8

transactionType

String(32)

Applicable Tansaction type:

payment

refund

cancel

9

paymentTime

String(64)

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

10

settlementTime

String(64)

Settlement batch generated time, in ISO 8601 format YYYY-MM-DDTHH:MM:SS+hh:mm

11

productCode

String(32)

Product name:

In-store Payment

12

transactionAmountValue

String(16)

The gross amount of fund in order request

13

transactionCurrency

String(3)

The order currency

HKD

14

settlementAmountValue

String(16)

Net settlement amount in settlement currency

16

settlementCurrency

String(3)

Settlement currency

HKD

17

feeAmountValue

String(16)

Commission fee, in settlement currency

18

feeCurrency

String(3)

The commission currency code

HKD

19

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.

20

voucherAmount

String(16)

Cashless voucher amount