Card Authorizations
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. |