Transaction Report
Introduction
The Transaction Report contains a detailed list of all Balances and Card activities per deployment on a specific day.
File repository path: Transactions/Daily
File name pattern: Transaction_daily_yyyy_mm_dd.csv
Report frequency: Daily & Monthly
Transaction Report Header
| Item | Description | Mandatory/Conditional |
|---|---|---|
| community | The name of the community to which the client belongs, as configured in Nium. | Mandatory |
| client | The name of the client, as configured in Nium. | Mandatory |
| transactionInitiationDate | The date and time the transaction was initiated in GMT, following the ISO 8601 format (yyyy-MM-dd'T'HH:mm:ssZ). | Mandatory |
| transactionCompletionDate | The date and time the transaction was completed in GMT, following the ISO 8601 format (yyyy-MM-dd'T'HH:mm:ssZ). | Conditional |
| transactionReference | A unique identifier for the transaction. | Mandatory |
| balanceReference | A unique identifier for the Balance instrument associated with the transaction. | Conditional |
| balanceCurrency | The currency of the Balance instrument in ISO 4217 format. | Conditional |
| transactionType | Describes the transaction type. See Balanceless Card Transaction Types. | Mandatory |
| transactionState | The current state of the transaction. See Balanceless Cards Transaction States. | Mandatory |
| transactionAuthor | Identifies who initiated or updated the transaction (e.g. user, API, operator). | Mandatory |
| sourceType | Type of the source participant in the transaction. | Conditional |
| sourceName | Unique identifier of the source participant. | Conditional |
| destinationType | Type of the destination participant in the transaction. | Conditional |
| destinationName | Unique identifier of the destination participant. | Conditional |
| originalCurrency | Original currency of the transaction (ISO 4217). This is independent of the billing currency | Conditional |
| originalAmount | Original transaction amount. This is independent of the billing currency. | Conditional |
| billingCurrency | Currency used for billing (ISO 4217), the same as the card currency. | Conditional |
| billingAmount | Billed amount of the transaction, including any fees. | Conditional |
| transactionCurrency | Transaction currency (ISO 4217), matching the Balance instrument currency. | Conditional |
| transactionAmount | Transaction amount of the Balance instrument adjustment. | Conditional |
| transactionFeeCurrency | Currency in which any applicable transaction fee is charged. | Conditional |
| transactionFeeAmount | Fee amount charged for the transaction, if applicable. | Conditional |
| interchangeCurrency | Currency used for the interchange. | Conditional |
| interchangeAmount | Amount of the interchange. | Conditional |
| forexRate | Foreign exchange rate applied between source and destination currencies (if different). | Conditional |
| forexFeeCurrency | Currency in which any forex fee is charged. | Conditional |
| forexFeeAmount | Amount of the forex fee applied, if any. | Conditional |
| ecbRate | Latest European Central Bank (ECB) rate applicable on the date specified in the Central Processing Date field. | Conditional |
| availableBalanceAdjustment | Amount adjusted on the available balance of the Balance instrument. | Conditional |
| availableBalanceAfter | Available balance on the Balance instrument after processing the transaction. | Conditional |
| actualBalanceAdjustment | Amount adjusted on the actual balance of the Balance instrument. | Conditional |
| actualBalanceAfter | Actual balance on the Balance instrument after processing the transaction. | Conditional |
| direction | Indicates instrument direction; possible values: SOURCE, DESTINATION. | Mandatory |
| remainingSpendAdjustment | Amount by which the virtual card’s Spend Limit is increased or decreased as a result of the transaction. | Conditional |
| remainingSpendAfter | Spend Limit of the virtual card after the transaction. | Conditional |
| cardSpendLimitAdjustment | Amount representing the change applied to the card’s spend limit by the transaction. Present only for CARD_SPEND_LIMIT_UPDATE transactions. | Conditional |
| cardSpendLimitAfter | Spend Limit after the update to a predefined value. | Conditional |
| cardReference | Unique Nium reference for the card. | Conditional |
| customReference | Custom field provided by the client to uniquely identify the virtual card. Present only for CARD_CREATE transactions. | Conditional |
| maskedCardNumber | First six and last four digits of a virtual card. | Conditional |
| cardBrand | Card brand of the issued card. | Conditional |
| cardProfile | Card factory (card type) used to create the card. | Conditional |
| merchantName | Name of the merchant. | Conditional |
| merchantCountry | Merchant’s base country as registered with the acquirer. | Conditional |
| merchantCategoryCode | Code representing the merchant category (MCC) assigned to the merchant. | Conditional |
| authCode | Authorisation code used in authorisations and settlements. | Conditional |
| relatedTransactionReference | Unique identifier linking a transaction to a related one, such as linking a settlement to its authorisation. | Conditional |
| relatedTransactionCompletionDate | Date and time (in GMT) when a related transaction is completed, marking the end of its processing period. Format follows ISO 8601 format (yyyy-MM-dd'T'HH:mm:ssZ). | Conditional |
| acquirerReferenceNumber | Unique reference number that identifies the acquirer for each merchant. | Conditional |
| tag 1-20 | Additional fields defined by the client. | Conditional |