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