Client Settlement

This report contains the end-of-day settlement data as received between NIUM and scheme. A client administrator can login to the NIUM back-office and view or download the settlement report based on the selected date range.

A once-a-day static report may also be setup on request for the same which can be downloadable or delivered over SFTP.

File naming convention: Client_Settlement_Report_{clientHashId}_YYYYMMDD.csv

FieldDescription
Batch DateDate of settlement batch, formatted YYYYMMDD.
Posting DateDate of settlement batch posted to NIUM, formatted YYYYMMDD.
File NameName of scheme settlement file, formatted FV_MONTX_YYYYMMDDHHmmss.TXT.pgp.txt and is a PGP-encrypted file.
StatusSettlement status. Valid values are SUCCESS, PENDING, or FAILED.
Client Hash IDUnique client identifier [36 character UUID].
Customer Hash IDUnique customer identifier [36 character UUID].
Card Hash IDUnique card identifier [36 character UUID].
Mask Card NumberMasked card number in the format 1234-56xx-xxxx-9876.
Authorization CodeAuthorization code [6 digit] of the transaction.
Transaction Type1 letter code: C for Credit or D for Debit.
Account Number19-digit card account number.
Transaction Currency3-letter ISO currency code for transaction currency.
Transaction AmountTransaction amount.
Billing Currency3-letter ISO currency code for billing currency.
Billing AmountBilling amount of the transaction.
Region2-letter ISO country code depicting region.
Interchange Fee SignThis field can be positive + or negative -.
Interchange FeeInterchange Fee on the transaction.
Issuer MarkupIssuer markup.
Exchange Rate SignEmpty.
Exchange RateThis field contains 0.000000000.
Transaction Code SignEmpty.
Transaction Code5-digit code to reference debit and credit transactions.
Merchant ID15-digit Merchant identifier.
Merchant Category Code4-digit Merchant category code.
Merchant Name LocationMerchant name and location.
Merchant Country Code2-letter ISO country code of the merchant.
Ref Number23-character reference number.
Visa Transaction ID15-digit Visa transaction ID.
Interchange Reference23-digit interchange reference number.
Original Payment Amount SignEmpty.
Original Payment AmountThis field is usually 0.
Original Transaction CodeThis field is usually 0.
Rolled Amount SignEmpty.
Rolled AmountEmpty.
POS Entry Mode2-digit code that identifies the actual method used at the point of service to enter the cardholder account number and card expiry date.
Point of ServiceEmpty.
ECOM TransactionECOM transaction code.
Matched Authorization1 letter (Y or N) if the settlement was matched with an original transaction
Multi Clearing1 letter (F or blank) if a transaction is settled completely.
Recurring TransactionRecurring transaction identification, and is usually 0.
Recurring MCCRecurring MCC Code, and is usually 0.
Card Block CodeEmpty.
Record Type1-letter record type, and is usually M.
Payment IndicatorEmpty.
Fraud Matched FlagEmpty.
Digital Card Indicator1-digit (0 or 1) if a digital card is being used.
Sms Dms IndicatorEmpty.
Wsp IDWallet service provider ID.
WspWallet service provider.
Token Requester IDToken requestor ID.
Token NumberToken number.
CommentsSystem generated comments.
Created ByThis field is always SYSTEM.
Created DateCreation timestamp, formatted DD/MM/YYYY HH:mm:ss AM/PM.
Modified ByThis field is always SYSTEM.
Modified DateModification timestamp, formatted DD/MM/YYYY HH:mm:ss AM/PM.