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 |