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. |
Updated 5 months ago