Report data
The table below provides an explanation of all the columns of the Transaction and funding report.
| Column/Field Name | Description | Supported Options (If applicable) | Format / Example Value | Applicability |
|---|---|---|---|---|
| NP Transaction ID | Transaction’s unique identifier assigned by the uP Platform. | NP-69b73a945f16750372454403492 | Transaction report Standard funding report IC++ funding report | |
| Transaction Date | Transaction date and time. NOTE: the time zone will be set based on the merchant’s location | YYYY-MM-DD hh:mm:ss | Transaction report Standard funding report IC++ funding report | |
| Transaction Type | Transaction type. Can be as follows: • Authorization of purchase • Single instruction purchase transaction • Single instruction credit transaction • Authorization reversal • Refund of previous purchase • Cardholder initiated dispute of previous purchase • Representment of a chargeback • Technical reprocessing of purchase • Technical reprocessing of refund • Technical reprocessing of transaction • Temporary authorization of purchase • Adjustment of non-captured purchase transaction • Capture of previous authorisation | • Authorization • Sale • Credit • Reversal • Refund • Chargeback • Representment • Adjust_Purchase • Adjust_Refund • Adjust_Internal • PreAuth • authorised_reversal • Completion | Transaction report Standard funding report IC++ funding report | |
| Transaction Status | Transaction status. Can be as follows: • Successful authorization / purchase • Approved authorization / purchase • Declined authorization / purchase • Reversed authorization / purchase • Aborted authorization / purchase | • Authorized • Approved • Declined • Reversed • Aborted | Text, as defined in Supported Options column | Transaction report Standard funding report IC++ funding report |
| Transaction Amount | Transaction amount. Two decimal digits. Amounts are formatted using a dot (".") Amount is preceded with (-) if your balance is to be debited. | 2327.24 or -2327.24 (for a debit) | Transaction report Standard funding report IC++ funding report | |
| Transaction Currency | Transaction currency. Currency three letter code ISO 4217-Alpha 3 | HKD | Transaction report Standard funding report IC++ funding report | |
| MDR Amount | Merchant Discount Rate amount. Two decimal digits. Amounts are formatted using a dot (".") Amount is preceded with a (-) sign in instances where the MDR has been deducted. | 13.67 or -13.67 (for a deduction) | Transaction report Standard funding report IC++ funding report | |
| MDR Currency | Merchant Discount Rate currency. Currency three letter code ISO 4217-Alpha 3 | HKD | Transaction report Standard funding report IC++ funding report | |
| GRT Amount | Gross Receipt Tax amount. Two decimal digits. Amounts are formatted using a dot ("."). Amount is preceded with a (-) sign in instances where the GRT has been deducted. Only applicable for specific countries. When not applicable this field will be left empty. | 27.24 or -27.24 (for a deduction) | Transaction report Standard funding report IC++ funding report | |
| GRT Currency | Gross Receipt Tax currency. Currency three letter code ISO 4217-Alpha 3 Only applicable for specific countries. When not applicable this field will be left empty. | PHP | Transaction report Standard funding report IC++ funding report | |
| WHT Amount | Withholding Tax amount. Two decimal digits. Amounts are formatted using a dot ("."). Amount is preceded with a (-) sign in instances where the WHT has been deducted. Only applicable for specific countries. When not applicable this field will be left empty. | 57.22 or -57.22 (for a deduction) | Transaction report Standard funding report IC++ funding report | |
| WHT Currency | Withholding Tax currency Currency three letter code ISO 4217-Alpha 3 Only applicable for specific countries. When not applicable this field will be left empty. | EUR | Transaction report Standard funding report IC++ funding report | |
| VAT Amount | Value-Added Tax amount. Two decimal digits. Amounts are formatted using a dot ("."). Amount is preceded with a (-) sign in instances where the VAT has been deducted. Only applicable for specific countries. When not applicable this field will be left empty. | 7.89 or -7.89 (for a deduction) | Transaction report Standard funding report IC++ funding report | |
| VAT Currency | Value-Added Tax currency. Currency three letter code ISO 4217-Alpha 3 Only applicable for specific countries. When not applicable this field will be left empty. | THB | Transaction report Standard funding report IC++ funding report | |
| SST Amount | Sales and Service Tax amount. Two decimal digits. Amounts are formatted using a dot ("."). Amount is preceded with a (-) sign in instances where the SST has been deducted. Only applicable for specific countries. When not applicable this field will be left empty. | 146.45 or -146.45 (for a deduction) | Transaction report Standard funding report IC++ funding report | |
| SST Currency | Sales and Service Tax currency. Currency three letter code ISO 4217-Alpha 3 Only applicable for specific countries. When not applicable this field will be left empty. | MYR | Transaction report Standard funding report IC++ funding report | |
| Funding Amount | Amount due to be sent to the merchant’s Unified Balance after deducting any applicable fees and taxes (and/or foreign exchange if a currency conversion is required). These funds are sent to the merchant’s specified bank account on the same day. Two decimal digits. Amounts are formatted using a dot ("."). Amount is preceded with (-) if your balance is to be debited | 27.24 or -27.24 (for a debit) | Transaction report Standard funding report IC++ funding report | |
| Funding Currency | Funding currency. Currency three letter code ISO 4217-Alpha 3 | HKD | Transaction report Standard funding report IC++ funding report | |
| Funding Date | Date that NomuPay funds the merchant’s Unified Balance on the uP Platform. These funds are sent to the merchant’s specified bank account on the same day. | YYYY-MM-DD | MDR funding report IC++ funding report | |
| Funding ID | Unique ID to be found on the merchant’s bank statement, allowing to match the transactions in the funding report and funding amount. | 45r139b5df24fc65283502899 | Standard funding report IC++ funding report | |
| Payment method | Payment method type. Can be as follows: • Visa • Mastercard • Troy • China UnionPay • 7-Eleven over-the-counter • Bayad Center • Boost e-wallet • Cebuana over-the-counter • Direct Carrier Billing • DuitNow Online • DuitNow QRC • ECPay e-wallet • FPX Online Banking • GCash e-wallet • GrabPay e-wallet • MAE QRC • Maya e-wallet • ShopeePay e-wallet • Touch ‘N Go e-wallet | • VISA • MC • troy • UPI • seven_eleven • bayad_center • boost • cebuana • direct_carrier_billing • duitnow • duitnow_qr • ecpay • fpx • gcash • grabpay • mae • paymaya • shopeepay • touch_n_go | Transaction report Standard funding report IC++ funding report | |
| Card Type | Card type. Only applicable when a card is in the payment method field (Visa, Mastercard, China UnionPay, America Express, Diners Club International) When not applicable this field will be left empty. Can be as follows: • Credit Card • Debit Card • Prepaid Card • Charge Card | • CC • DC • PC • RC | Text, as defined in Supported Options column | Transaction report Standard funding report IC++ funding report |
| Acceptance Channel | Channel that the transaction was accepted on. Can be as follows: • e-commerce • Point of sale • Mail order/telephone order | • eCom • POS • MOTO | Text, as defined in Supported Options column | Transaction report Standard funding report IC++ funding report |
| RRN | Transaction Retrieval Reference Number (RRN). When not applicable this field will be left empty. | 123456789012 | Transaction report Standard funding report IC++ funding report | |
| ARN | Transaction Acquirer Reference Number (ARN). When not applicable this field will be left empty. | 234567890123 | Transaction report Standard funding report IC++ funding report | |
| Billing date | Date fees are calculated for billing by NomuPay | YYYY-MM-DD | Transaction report Standard funding report IC++ funding report | |
| Authorization code | Authorization code returned by the scheme. When not applicable this field will be left empty. | 123456 | Transaction report Standard funding report IC++ funding report | |
| Response code | Response code returned by the issuer. When not applicable this field will be left empty. | 0 | Transaction report Standard funding report IC++ funding report | |
| Issuer locality | Issuer locality When not applicable this field will be left empty. Can be as follows: • Local transaction • Foreign transaction • Regional transaction | • Local • Foreign • Regional | Text, as defined in Supported Options column | Transaction report Standard funding report IC++ funding report |
| Issuer country | Payment method issuer country. Country two letter code ISO 3166-1 Alpha 2 | HK | Transaction report Standard funding report IC++ funding report | |
| MCC | Merchant category code. Identifier that classifies a business by the type of goods or services it provides. | 1234 | Transaction report Standard funding report IC++ funding report | |
| Terminal ID | Unique ID assigned by NomuPay to terminals. | 87654321 | Transaction report Standard funding report IC++ funding report | |
| Terminal Batch | End of day ID assigned to in-store processing. | 12345678 | Transaction report Standard funding report IC++ funding report | |
| MID | Unique merchant ID assigned by the processor. | 987654321987 | Transaction report Standard funding report IC++ funding report | |
| Store ID | Unique Location ID assigned by NomuPay preceded by the LID identifier. | LID-123456789 | Transaction report Standard funding report IC++ funding report | |
| Store Name | Unique name assigned to each store. | HAPPY STORE | Transaction report Standard funding report IC++ funding report | |
| Store country | Store’s country location. Applicable to digital e-commerce stores and physical stores. Country two letter code ISO 3166-1 Alpha 2 | HK | Transaction report Standard funding report IC++ funding report | |
| Store City | Store’s city location. Applicable to digital e-commerce stores and physical stores. | KOWLOON | Transaction report Standard funding report IC++ funding report | |
| Account ID | Unique merchant identifier assigned by uP POM during onboarding preceded by the EID identifier. | EID-123456789 | Transaction report Standard funding report IC++ funding report | |
| Account name | Merchant’s legal entity name. | HAPPY STORE SUPPLIES LTD. | Transaction report Standard funding report IC++ funding report | |
| Card Number | Masked account number. This field is used for all payment method account types (not just cards) if/when applicable. | 553312XXXXXX1234 | Transaction report Standard funding report IC++ funding report | |
| Merchant Reference | Arbitrary text provided by the merchant | Free-text | Transaction report Standard funding report IC++ funding report | |
| Gateway Reference | Unique ID shared by partner processor | Free-text | Transaction report Standard funding report IC++ funding report | |
| Remarks | Additional info on transaction (Optional) | Free-text | Transaction report Standard funding report IC++ funding report | |
| Interchange Amount | Fee due to the issuer of the card. Two decimal digits. Amounts are formatted using a dot (".") Amount is preceded with a (-) sign in instances where the amount has been deducted. | 200.50 or -200.50 (for a deduction) | IC++ funding report | |
| Interchange Currency | Interchange CurrencyClearing Fee Currency. Currency three letter code ISO 4217-Alpha 3. | HKD | IC++ funding report | |
| Pre-Authorization Fee Amount | Fee due to the scheme for the usage of the pre-authorization transaction (each pre-authorization is billed). Two decimal digits. Amounts are formatted using a dot (".") Amount is preceded with a (-) sign in instances where the amount has been deducted. | 100.50 or -100.50 (for a deduction) | IC++ funding report | |
| Pre-Authorization Fee Currency | Pre-Authorization Fee CurrencyClearing Fee Currency. Currency three letter code ISO 4217-Alpha 3. | HKD | IC++ funding report | |
| Authorization Fee Amount | Authorization fee Amount. Two decimal digits. Amounts are formatted using a dot (".") Amount is preceded with a (-) sign in instances where the amount has been deducted. | 200.50 or -200.50 (for a deduction) | IC++ funding report | |
| Authorization Fee Currency | Authorization fee CurrencyClearing Fee Currency. Currency three letter code ISO 4217-Alpha 3. | HKD | IC++ funding report | |
| 3DS Fee Amount | Fee due to the scheme for the usage of 3D Secure authentication. Two decimal digits. Amounts are formatted using a dot (".") Amount is preceded with a (-) sign in instances where the amount has been deducted. | 342.50 or -342.50 (for a deduction) | IC++ funding report | |
| 3DS Fee Currency | 3DS Fee CurrencyClearing Fee Currency. Currency three letter code ISO 4217-Alpha 3. | HKD | IC++ funding report | |
| Non-3DS Fee Amount | Fee is due to the scheme for insecure transaction, without usage of 3D Secure authentication. Two decimal digits. Amounts are formatted using a dot (".") Amount is preceded with a (-) sign in instances where the amount has been deducted. | 1100.50 or -1100.50 (for a deduction) | IC++ funding report | |
| Non-3DS Fee Currency | Non-3DS Fee CurrencyClearing Fee Currency. Currency three letter code ISO 4217-Alpha 3. | HKD | IC++ funding report | |
| Cross Border Fee Amount | Fee is due to the scheme for a transaction where the country of the merchant differs from the country of the issuer. Two decimal digits. Amounts are formatted using a dot (".") Amount is preceded with a (-) sign in instances where the amount has been deducted. | 900.50 or -900.50 (for a deduction) | IC++ funding report | |
| Cross Border Fee Currency | Cross Border Fee CurrencyClearing Fee Currency. Currency three letter code ISO 4217-Alpha 3. | HKD | IC++ funding report | |
| Cross Currency Fee Amount | Fee due to the scheme for a transaction where the merchant country currency differs from the transaction currency. Two decimal digits. Amounts are formatted using a dot (".") Amount is preceded with a (-) sign in instances where the amount has been deducted. | 1243.50 or -1243.50 (for a deduction) | IC++ funding report | |
| Cross Currency Fee Currency | Cross Currency Fee CurrencyClearing Fee Currency. Currency three letter code ISO 4217-Alpha 3. | HKD | IC++ funding report | |
| Clearing Fee Amount | Fee due to the scheme for each financial transaction initiated by the merchant (purchase and refund). Two decimal digits. Amounts are formatted using a dot (".") Amount is preceded with a (-) sign in instances where the amount has been deducted. | 300.50 or -300.50 (for a deduction) | IC++ funding report | |
| Clearing Fee Currency | Clearing Fee Currency. Currency three letter code ISO 4217-Alpha 3. | HKD | IC++ funding report | |
| Gateway Fee Amount | Gateway Fee amount. Two decimal digits. Amounts are formatted using a dot (".") Amount is preceded with a (-) sign in instances where the Gateway Fee has been deducted. | 13.67 or -13.67 (for a deduction) | Transaction report Standard funding report IC++ funding report | |
| Gateway Fee Currency | Gateway Fee currency ISO 4217-Alpha 3. | HKD | Transaction report Standard funding report IC++ funding report |