Daily Client Card Transaction Authorization

This once-a-day static report contains all card authorization details for customers of the client.

It may be setup on request. A client administrator can login to the NIUM back-office and view or download the same. It can also be delivered over SFTP on request.

File naming convention: Client_Card_Transaction_Authorization_Report_{ClientHashId}_YYYYMMDD.csv

Field	Description
Date/Time of Transaction	Date/Time of transaction, formatted as 24-hour `DD/MM/YYYY HH:mm:ss`.
Transaction Type	This report contains all transactions done on a card, including fees and adjustments.
Status	Transaction status. Values included: `APPROVED`, `PENDING`, `DECLINED`, `REVERSAL`, and `BLOCKED`.
Settlement Status	Settlement status of the transaction. Values included: `UNSETTLED`, `SETTLED`, `RELEASED`, `WAIVED`, `DISPUTED`, and `DISPUTE CLOSED`.
Transaction Currency Code	3-letter ISO currency code for the transaction amount.
Transaction Amount	Transaction amount.
Billing Currency Code	3-letter ISO currency code for the billing amount.
Billing Amount	Billing amount.
Auth Currency Code	3-letter ISO currency code for the authorization amount.
Auth Amount	Authorization amount.
Effective Auth Amount	Authorization amount after accounting for fees, etc.
Previous Balance	Previous balance prior to the transaction.
Settlement Date of Transaction	Date/Time of settlement, and used only for transactions with `SETTLED` status (this field is empty for all other status types).
Settlement Currency Code	3-letter ISO currency code for the settlement amount.
Settlement Transaction Amount	Transaction amount at time of settlement. This field will have `0.0000` for unsettled transactions.
Settlement Billing Amount	Billing amount at time of settlement. This field will have `0.0000` for unsettled transactions.
Settlement Auth Amount	Settlement amount at time of settlement. This field will have `0.0000` for unsettled transactions.
Customer Hash Id	Unique customer identifier [36 character UUID].
Wallet Hash Id	Unique wallet identifier [36 character UUID].
Card Hash Id	Unique card identifier [36 character UUID].
Mask Card Number	Masked card number, formatted as `1234-56xx-xxxx-9876`.
Pocket Name	Name of the pocket. If no pocket is assigned, value is `DEFAULT`.
Merchant Category	Merchant category as grouped by Nium, based on MCC.
Merchant Category Code	4-digit Merchant Category Code.
Merchant Id	Merchant Identifier assigned by the network.
Merchant Name	Name of the merchant.
Merchant City	Merchant city or location.
Merchant Country	Country where merchant is situated.
Merchant Latitude	Merchant latitude.
Merchant Longitude	Merchant longitude.
Merchant Tagged Name	Merchant tagged name.
Merchant Zoom Index	Merchant zoom index on map.
Business Transaction	Boolean flag to signify a business transaction.
Authorization Code	6-digit authorization code for the transaction.
System Trace Audit Number	Unique 6-digit transaction identifier generated by Nium.
Retrieval Reference Number	12 digit number used with other data elements as a key to identify and track a transaction.
Processing Code	6-digit processing code for the transaction.
Pos Entry Mode	2-digit mode of entry for the transaction being done at POS.
Pos Entry Capability Code	1-digit code that describes the capability of the POS terminal at which the transaction takes place.
Pos Condition Code	2-digit code that describes the condition under which the transaction takes place at the point of service.
Original Authorization Code	Used for reversals. Authorization code of the transaction being reversed.
Original Date of Transaction	Used for reversals. Original date and time of transactions.
Original System Trace Audit Number	Used for reversals. System trace audit number (STAN) of the original transaction.
Acquiring Institution Code	Acquiring institution code.
Original Acquiring Institution Code	Used for reversals. Original Acquiring institution code.
Acquiring Institution Country Code	Acquirer country code.
Comments	System generated comments.
Labels	Labels capturing miscellaneous information such as fee name, exchange rate, etc.