Transaction Report
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
Transaction Report Header
| Item | Description |
|---|---|
| Community | The name of the community to which a client belongs, as set up in Nium. |
| Client | The name of the client, as set up in Nium. |
| transactionInitiationDate | Represents the transaction initiation date (in GMT). The date format follows ISO 8601 (yyyy-MM-dd'T'HH:mm:ssZ). |
| transactionCompletionDate | Represents the transaction’s completion date (in GMT). The date format follows ISO 8601 (yyyy-MM-dd'T'HH:mm:ssZ). |
| transactionReference | Represents a unique transaction identifier. |
| balanceReference | The unique identifier of the Balance to which the card will be associated. |
| balanceCurrency | Represents Balance’s currency in ISO 4217 format. |
| transactionType | Describes the transaction types as defined in the document Balanceless_Cards_Transaction_Types_and_States. |
| transactionState | Represents the state of the transaction entry. The following reported transaction statuses are available Balanceless_Cards_Transaction_Types_and_States. |
| transactionAuthor | Represents the author type of the transaction entry. When a transaction is updated, the author is updated as well. (Ennums: user, API, operator). |
| sourceType | The source participant in the transaction. |
| sourceName | The unique identifier of the source participant. |
| destinationType | The destination participant in the transaction. |
| destinationName | The unique identifier of the destination participant. |
| originalCurrency | Represents the original currency of the transaction in ISO 4217 format. This is independent of the billing currency.. |
| originalAmount | Represents the original amount of the transaction. This is independent of the participant's currency. |
| billingCurrency | Represents the billing currency of the transaction in ISO 4217 format. It reflects the card currency in which the client will be billed. |
| billingAmount | Represents the billing amount of the transaction, including fees. |
| transactionCurrency | Represents the transaction currency of the transaction in ISO 4217 format. It reflects the Balance currency. |
| transactionAmount | Represents the transaction amount of the Balance adjustment. |
| transactionFee | Contains fees for the reported transaction, where applicable. |
| transactionFeeCurrency | The currency of the transaction fee. |
| interchangeCurrency | The currency of the interchange. |
| interchangeAmount | The amount of the interchange. |
| forexRate | The exchange rate used between the source currency and destination currency (if they are different). |
| forexFee | Contains forex fees for the reported transaction, where applicable. |
| forexFeeCurrency | The currency of the forex fee. |
| ecbRate | The latest European Central Bank (ECB) rate applicable for the day identified by the field Central Processing Date. |
| availableBalanceAdjustment | The adjustment amount on the available balance of the Balance. |
| availableBalanceAfter | The available balance on the Balance after the transaction is processed. |
| actualBalanceAdjustment | The adjustment amount on the actual balance of the Balance. |
| actualBalanceAfter | The actual balance on the Balance after the transaction is processed. |
| direction | Contains a Boolean flag indicating whether a transaction is an advance or a reversal. |
| remainingCardSpendLimitAdjustment | Represents the adjustment of the Spend Limit of the Linked Card with the transaction. |
| remainingCardSpendLimitAfter | Represents the Spend Limit of the Linked Card after the transaction. |
| cardSpendLimitBefore | Represents the Spend Limit before the update. |
| cardSpendLimit | After Represents the Spend Limit after the update with a predefined value |
| externalReference | A unique Nium reference of the card. |
| cardNumber | The first six and last four digits of a virtual card. |
| cardBrand | The card brand of the issued card. |
| cardType | Indicates the card factory (card type) with which a card is created. |
| merchantName | The name of the merchant. |
| merchantCountry | The merchant's base country registered with the acquirer. |
| merchantCategoryCode | An identifier for the merchant category that a merchant belongs to. |
| authCode | The authorization code used in authorizations and settlements. |
| authTransactionDate | The date of the respective authorization for a purchase. |
| acquirerReferenceNumber | A unique reference number that identifies the acquirer for each merchant. |
| Tags 1-20 | Additional fields defined by the client. |