Specifications

JSON PATHDescriptionExample
file_date_and_timeUTC Date transmitted by processor Format: YYYY-MM-DD hmmss2023-01-15 011525
total_number_of_recordsDetails how many records are included in the report1
clearing_records
program_nameProgram Name associated with the cardCLOWD9 Travel
program_idProgram ID associated with the card. Generated by CLOWD9 represented as a GUID1028c3d4-06fc-401d-bbb2-9df36a06e06b
product_idProduct ID associated with card. Generated by CLOWD9 represented as a GUID0828c3d4-06fc-401d-bbb2-9df36a06e06b
card_idThe identifier associated to the card used represented as a GUIDf6ea4c96-db0b-4bd9-9d59-c745ea24b183
card_endingThe last four digits of the PANstring
network_nameThe network associated with the BIN and card_idvisa
Mastercard
clearing_outcomeIdentifies the outcome of matching the clearing to the original authorization0
clearing_cycleIdentifies the cycle file containing the clearing record.
Note: This field is only applicable to Mastercard programs
1
authorizations
transaction_idThe ID of the authorization identified to be matching the clearing record represented as a GUID1ae4af71-720d-4657-a742-24c7bc809985
system_trace_audit_numberSystem Trace Audit Number of authorization105308
retrieval_reference_numberRetrieval Reference Numbers of authorization74541834244288088530027
12345678910
record_id_clearingThe unique identifier of the clearing record in the CLOWD9 database represented as a GUID8de0972-bd31-46ac-bb3c-014b2b438c55
clearing_categoryIdentifies the category of a clearing transactionsales_debit
presentment_typeThe type of presentment (First, Chargeback, Second or Arbitration)0
transaction_type In Development
Numerical value associated with the transaction_type
00
transaction_service In Development
The alpha value associated with the transaction_type
Goods and Services
from_accountReserved for future use and defaults to 00
to_accountReserved for future use and defaults to 0000
directionTo identify if the amount is a Debit or CreditDebit
Credit
partial_indicatorThe indicator of F (Full) or P (Partial) will only be populated for Dispute Financials.P
original_transaction_amountThe original amount of the transaction relating to the Disputed Financial in units represented in original_transaction_currency_code.1000
original_transaction_currency_codeThe currency code for the original transaction amount for Disputed Financials978
transaction_amountThe transaction amount in units represented in transaction_currency_code.
For example 1000 = 10.00
225
transaction_currency_codeThe Numeric currency code in which transaction_amount is represented978
reconciliation_amountThe reconciliation (settlement) in units represented in reconciliation_currency_code
For example 1000 = 10.00
150
reconciliation_currency_codeThe currency code for the reconciliation amount826
cardholder_billing_amountThe cardholder billing transaction amount in units, represented in billing_currency_code.
For example 857 = 8.57
150
cardholder_billing_currency_codeBilling_currency_code826
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
0.8444444
transaction_to_base_currency_rateRate if provided by the Network represented as a string in decimal format. This is used with the base_to_billing_currnecy_rate to calculate the cardholder_billing_converstion_rate.
Note: If not provided, this will default to cardholder_billing_conversion_rate
Domestic values will use the rate 1.0000000 or 1
0.8444444
base_to_billing_currency_rateRate if provided by the Network represented as a string in decimal format. This is used with the transaction_to_base_currency_rate to calculate the cardholder_billing_converstion_rate.
Domestic values will use the rate 1.0000000 or 1
Note: If not provided, this will default to cardholder_billing_conversion_rate
0.8444444
dateDate of transaction as per clearing record.
Visa: MMDD
Mastercard: YYYY-MM-DD
Visa: 1204
Mastercard: 2024-12-04
sequence_numberThe sequence number of the clearing record. Used to identify multiple clearing transactions associated to the same authorization (Visa only) 1
reason_codeTypically used in dispute transactions to identify the reason of dispute00
merchant_category_codeThe Merchant Category Code (MCC)5542
reference_numberReference number of the clearing record, such as Acquirer Reference Number (ARN)080000100059
acquiring_institution_id_codeThe identification code of the Acquiring Institution00000999901
forwarding_institution_id_codeThe identification code of the Forwarding Institution999901
authorization_codeFollowing successful matching, the value will be that of the original authorization.
If the clearing record cannot be matched, the field will not be populated
239845
card_acceptor_terminal_idThe identifier of the terminal where the transaction took place12345678
card_acceptor_idThe identifier of the card acceptor entityR-5411-GBR
card_acceptor_nameThe name of the card acceptor entity7 CLOWD9 Street
card_acceptor_cityThe city of the card acceptor entityLondon
card_acceptor_post_codeThe post code of the card acceptor entityCL0 4DN
card_acceptor_country_codeThe country of the card acceptor entity in Alpha 2-3GB
GBR
licensed_product_identifierNetwork Product IdentifierMDT
MDS
network_file_referenceReserved for future use001
network_card_program_identifierIdentifies the Program TypeMDS
bin_typeReserved for future use and will identify the BIN typedebit
credit
prepaid
product_typeReserved for future use and will identify the Product typeconsumer
corporate
central_site_business_dateCentral Processing Date from the clearing file. YYYY-MM-DD2023-01-14
special_condition_indicatorProvides additional information regarding dispute financials and adjustments1, 2, 3
N, F, H, L
settlement_service_level_codeNumeric value (1) identifying type of settlement, Domestic or International1
settlement_dateDate of settlement from the network YYYY-MM-DD2023-01-14
additional_amount_typeIdentifies the additional amount typeCashback
additional_amountThe value of the additional amount in units. For example 500 = 5.00500
additional_amount_currency_codeThe transaction currency code of the amount826
interchange_feeRepresents the interchange fee amount, beginning with “C” for Credit and “D” for Debit. This is represented in the issuer’s base currency, with 6 decimal placesC000000000000123000
transaction_link_idThe Identifier of the transaction assigned by the Network to match to the Authorization315204374419372
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)
00