Card network transaction CSV file parameters

Below are the parameters included in the exported CSV file for card network transactions, along with their descriptions.

Parameter	Description
id	Transaction ID A unique identifier assigned to the network transaction by Tuum CMS.
messageType	Message Type Identifier (MTI) code A four-digit numeric code that identifies the type of message being exchanged in transaction processing.
transactionType	Processing code PROCESSING_CODE values and their translations can be found in BackOffice under Administration > Settings > Lookups > CARD > Service type, within the CARD.SERVICE_TYPE entity.
cardholder	The unique identifier of the cardholder.
accountOwner	The unique identifier of the person who owns the account.
cardNumber	Primary Account Number (PAN) The unique number identifying the cardholder’s account.
cardAcceptorNameLocation	Card acceptor name / location This is not filled for Visa clearing transactions. For those transactions, the equivalent information is provided in the merchantName and merchantCity fields.
cardAcceptorTerminalId	A unique code that identifies a specific terminal at the card acceptor’s location.
cardAcceptorId	The identification code assigned to the card acceptor by the acquirer.
purchaseCountry	Purchase country code Both ISO-2 (alpha-2) and ISO-3 (alpha-3) country codes are supported, depending on the format provided by the processor or scheme. Example: FR and FRA for France.
mcc	Merchant Category Code (MCC) MCC codes and their translations can be found in BackOffice under Administration > Settings > Lookups > CARD > Card transaction, in the CARD.CARD_TRANSACTION lookup.
merchantName	The merchant name is provided for Visa clearing transactions.
merchantCity	The merchant city is provided for Visa clearing transactions.
transactionAmount	The total amount of the transaction as received from the card payment network.
transactionCurrency	Transaction currency code The currency code for the transaction, provided in ISO-3 (alpha-3) format. Example: GBP for the Great British Pound.
cardAmount	The amount billed to the cardholder, received from the card payment network. It reflects the original transaction amount converted into the issuer’s designated cardholder currency.
cardCurrency	Cardholder billing currency code The cardholder’s billing currency code, provided in ISO-3 (alpha-3) format. Example: GBP for the Great British Pound.
authorisationTime	Authorisation time The time when the authorisation request was processed by the CMS.
posLocalTime	Local transaction date and time The local year, month, day, and time at which the transaction occurs at the card acceptor location.
posData	Point of service data code A code that indicates specific conditions present at the time the transaction occurred at the point of interaction.
retrievalReferenceNumber	Retrieval reference number A unique identifier assigned to the transaction for retrieval and tracking purposes.
authorisationResponse	Response action code RESPONSE_CODE values and their translations can be found in BackOffice under Administration > Settings > Lookups > CARD > Card transaction, within the CARD.CARD_TRANSACTION entity.
panReference	Card number (PAN) reference A reference to the Primary Account Number (PAN) of the card.
authorisation	Transaction cycle indicator TRUE indicates an authorisation transaction. FALSE indicates a clearing transaction.
clearingProcessedTime	Clearing processed time The time when the clearing transaction was processed by the CMS.
messageTypeName	Message Type Identifier (MTI) description A description of the Message Type Identifier (MTI) code.
cardId	A unique technical identifier assigned to the card.
productScheme	The card scheme, such as VISA or MASTERCARD.
transactionState	Clearing transaction status code This field is filled only for clearing transactions. STATUS codes and their translations can be found in BackOffice under the Administration > Settings > Lookups > CARD > Card transaction message type, within the CARD.FILE_TRANSACTION entity.
bin	Bank Identification Number (BIN) The numeric identifier that specifies the issuing bank of the card.
walletId	Wallet provider ID WALLET_PROVIDER codes and their translations can be found in BackOffice under Administration > Settings > Lookups > CARD > Token, within the CARD.TOKEN entity.
reversal	Indicates whether the transaction is a reversal.
transactionLabels	Labels assigned to the network transaction by Tuum CMS.
errorReason	The explanation provided for why the transaction was declined.