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
program_nameProgram Name associated with the card. Generated by CLOWD9 represented as a GUID CLOWD9 Travel
program_idProgram Name associated with the card. Generated by CLOWD9 represented as a GUID b33bf1dc-30f4-498f-b7ad-3e23b7f0180e
product_idProgram Name associated with the card. Generated by CLOWD9 represented as a GUID7ab1e3e2-32cc-4e8f-96af-50fc158a4bd5
card_idThe ID of the card associated to the transaction9fc53743-247b-185f-8720-13be7ac028b6
card_endingThe last four digits of the PAN1234Under Development
bin8 digit value for the BIN the card_id is associated with.
Subject to the network, this could be 6 digits
12345678
bin_typeReserved for future use
network_nameThe network associated with the BIN and card_idvisa
Mastercard
mti Numeric network specific identifier of the financial operation0100
message_typeType of message received from the NetworkAuthorization Request
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
system_trace_audit_numberThe System Trace Audit Number for the network message if present/applicable123456
retrieval_reference_numberThe Retrieval Reference Number for the network message if present/applicable12345678910
network_transaction_idThe unique identifier of the transaction assigned by the network, such as Visa TID.
Reserved for future use for Mastercard
204145677823994
resultIndicates based on the response code the authorization outcomeApproved
Declined
directionTo identify if the amount is a Debit or CreditDebit
Credit
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
response_sourceIndicates the source of the response_code value.

For Off Ledger products, your source name will be provided
scheme
CLOWD9
your source name
network
response_reasonA description of the reason for the assigned response_code.
See Appendix ii for reasons
Approved
Do Not Honour
transaction_typeThe numerical value for the transaction service and used to identify the service type.
See Appendix iii for types
00
transaction_serviceThe alpha value associated with the transaction_typeGoods and Services
authorization_codeThe code generated by CLOWD9 or the network following a successful authorization038247
transaction_life_cycle_idUnique identifier generated by the Network during the AuthorizationMDT0023J3
transaction_local_dateThe local date at the point of transaction origination, YYYYMMDD20230108
transaction_local_timeThe local time at the point of transaction origination, HHMMSS210608
transaction_amountThe amount to be authorized with the transaction in units. Can be “0” for non-financial messages225
transaction_currency_codeThe Numeric currency code in which transaction_amount is represented978
transaction_currencyThe Alpha (2-3) currency code in which transaction_amount is representedEUR
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
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
cardholder_billing_currency_codeThe Numeric currency code in which cardholder_billing_amount is represented. Note that this may have implications for the decimal place826
cardholder_billing_currencyThe Alpha (2-3) currency code in which cardholder_billing_amount is representedGBP
additional_amountAdditional amount for example cashback100
additional_amount_currency_codeThe currency code of the additional amount. Should match the authorization currency code826
additional_amount_typeIdentifies the type of additional amountCashback
card_acceptor_country_nameThe country of the card acceptor entity in Alpha 2-3GB
GBR
card_acceptor_post_codeThe post code of the card acceptor entityAB1 2CD
merchant_category_codeThe Merchant Category Code5542
card_acceptor_nameThe name of the card acceptor entity7 CLOWD9 Street
card_acceptor_terminal_idThe identifier of the terminal where the transaction took place35043598
card_acceptor_cityThe city of the card acceptor entityLondon
card_acceptor_country_codeThe Alpha (2-3) country code of the card_acceptorGBR
acquiring_institution_id_codeThe identification code of the Acquiring Institution015909
forwarding_institution_id_codeThe identification code of the Forwarding Institution023748
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
pin_indicatorIndicates whether PIN for the transaction was checked, its nature and the result.
See Appendix v for values and meaning
y
n
dcc_indicatorIndicates whether Dynamic Currency Conversion took placey
n
3ds_indicatorIndicates whether 3D-Secure Authentication took place for this transactiony
n
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
cardholder_conditionCardholder condition indicator provided during the authorization. Possible values are:

“00” cardholder present, normal transaction
“01” cardholder not present
“02” cardholder present
“03” card present, suspicious activity
“05” cardholder present
“08” cardholder not present, mail or telephone order
“59” cardholder not present, electronic order (ecommerce)
“71” cardholder present (Used in US only)
string
trace_idA unique value used to assist with locating the transactiond27aa3ad557092196b87e8e24d5b12f
transaction_linkidThe Identifier of the transaction assigned by the Network. The Identifier will be provided in all future Financial messagesmxtw204145677823994