Specifications

JSON PATHDescriptionExample
file_date_and_time UTC Date transmitted by processor
Format: YYYY-MM-DD hhmmss
2024-01-15 011023
total_number_of_recordsDetails how many records are included in the report1
authorizations
authorizations.program_nameProgram Name associated with the card. Generated by CLOWD9 represented as a GUIDCLOWD9 Travel
authorizations.program_idProgram Name associated with the card. Generated by CLOWD9 represented as a GUID b33bf1dc-30f4-498f-b7ad-3e23b7f0180e
authorizations.product_idProgram Name associated with the card. Generated by CLOWD9 represented as a GUID7ab1e3e2-32cc-4e8f-96af-50fc158a4bd5
authorizations.card_idThe ID of the card associated to the transaction9fc53743-247b-185f-8720-13be7ac028b6
authorizations.bin8 digit value for the BIN the card_id is associated with.
Subject to the network, this could be 6 digits
12345678
authorizations.bin_typeReserved for future use
authorizations.network_nameThe network associated with the BIN and card_idVisa
Mastercard
authorizations.mtiNumeric network specific identifier of the financial operation0100
authorizations.message_typeType of message received from the NetworkAuthorization
authorizations.transaction_idThe unique identifier (UUID) of the transaction log entry in the CLOWD9 database.
Generated by CLOWD9 represented as a GUID
71a78503-5b49-42d1-ae89-4280a12b9af2
authorizations.system_trace_audit_numberThe System Trace Audit Number for the network message if present/applicable123456
authorizations.retrieval_reference_numberThe Retrieval Reference Number for the network message if present/applicable12345678910
authorizations.network_transaction_idThe unique identifier of the transaction assigned by the network, such as Visa TID.
Reserved for future use for Mastercard
204145677823994
authorizations.resultIndicates based on the response code the authorization outcomeApproved
Declined
authorizations.directionTo identify if the amount is a Debit or CreditDebit
Credit
authorizations.response_codeResponse code of the transaction. In notification messages, it is the final outcome of the authorization process. In request messages, it may contain a value indicating the outcome of previous checks000
100
authorizations.response_sourceIndicates the source of the response_code valuescheme
CLOWD9
client
authorizations.response_reasonA description of the reason for the assigned response_code.
See Appendix ii for reasons
Approved
Do Not Honour
authorizations.transaction_typeThe numerical value for the transaction service and used to identify the service type.
See Appendix iii for types
00
authorizations.transaction_serviceThe alpha value associated with the transaction_typeGoods and Services
authorizations.authorization_codeThe code generated by CLOWD9 or the network following a successful authorization038247
authorizations.transaction_life_cycle_idUnique identifier generated by the Network during the AuthorizationMDT0023J3
authorizations.transaction_local_dateThe local date at the point of transaction origination, YYYYMMDD20230108
authorizations.transaction_local_timeThe local time at the point of transaction origination, HHMMSS210608
authorizations.transaction_amountThe amount to be authorized with the transaction in units. Can be “0” for non-financial messages225
authorizations.transaction_currency_codeThe Numeric currency code in which transaction_amount is represented. Note that this may have implications for the decimal place978
authorizations.transaction_currencyThe Alpha (2-3) currency code in which transaction_amount is representedEUR
authorizations.cardholder_billing_amountThe cardholder currency amount to be authorized in units.
This amount may differ to the transaction_amount where the transaction currency is different to card settlement currency
190
authorizations.cardholder_billing_conversion_rateRate provided by the Network represented as a string in decimal format
Domestic values will use the rate 1.0000000 or 1
1
authorizations.cardholder_billing_currency_codeThe Numeric currency code in which cardholder_billing_amount is represented. Note that this may have implications for the decimal place826
authorizations.cardholder_billing_currencyThe Alpha (2-3) currency code in which cardholder_billing_amount is representedGBP
authorizations.additional_amountAdditional amount for example cashback100
authorizations.additional_amount_currency_codeThe currency code of the additional amount. Should match the authorization currency code826
authorizations.additional_amount_typeIdentifies the type of additional amountCashback
authorizations.card_acceptor_country_nameThe country of the card acceptor entity in Alpha 2-3GBR
authorizations.card_acceptor_post_codeThe post code of the card acceptor entityAB1 2CD
authorizations.merchant_category_codeThe Merchant Category Code5542
authorizations.card_acceptor_nameThe name of the card acceptor entity7 CLOWD9 Street
authorizations.card_acceptor_terminal_idThe identifier of the terminal where the transaction took place35043598
authorizations.card_acceptor_cityThe city of the card acceptor entityLondon
authorizations.card_acceptor_country_codeThe Alpha (2-3) country code of the card_acceptorGBR
authorizations.acquiring_institution_id_codeThe identification code of the Acquiring Institution015909
authorizations.forwarding_institution_id_codeThe identification code of the Forwarding Institution023748
authorizations.chip_indicatorIndicates if the transaction was made using the Integrated Circuit Card (ICC Chip) i.e. Contact / Contactless.
See Appendix iv for values and meaning
contact
authorizations.pin_indicatorIndicates whether PIN for the transaction was checked, its nature and the result.
See Appendix v for values and meaning
y
n
authorizations.dcc_indicatorIndicates whether Dynamic Currency Conversion took placey
n
authorizations.3ds_indicatorIndicates whether 3D-Secure Authentication took place for this transactiony
n
authorizations.eciE-Commerce authentication indicator. For an e-commerce transaction, when available, identifies the various security measures applied before transaction submission.
See Appendix vi for values and meaning
0
authorizations.trace_idA unique value used to assist with locating the transactiond27aa3ad557092196b87e8e24d5b12f