Mastercard Example

{
    "file_date_and_time": "2025-07-18 144400",
    "total_number_of_records": "2",
    "clearing_records": [
        {
            "program_name": "CLOWD9 Travel",
            "program_id": "f1cc05a5-50d3-4a96-81df-cef0b8c3168a",
            "product_id": "4fac231b-2a2c-4212-a4db-d809a661d902",
            "card_id": "9347b6be-6b9e-48c1-9a21-36d641889e9a",
            "card_ending": "1234",
            "network_name": "Mastercard",
            "clearing_outcome": "0",
            "clearing_cycle": "01",
            "authorizations": [
                {
                    "transaction_id": "65374d5f-9612-4638-a39d-3c887cba8276",
                    "system_trace_audit_number": "505864",
                    "retrieval_reference_number": "519812927922"
                }
            ],
            "record_id_clearing": "2f9d664d-f4dc-43ae-9819-3dba830c73ab",
            "clearing_category": "sales_debit",
            "presentment_type": "0",
            "transaction_type": "00",
            "transaction_service": "Goods and Service",
            "from_account": "00",
            "to_account": "00",
            "direction": "Debit",
            "transaction_amount": "3000",
            "transaction_currency_code": "985",
            "reconciliation_amount": "588",
            "reconciliation_currency_code": "826",
            "cardholder_billing_amount": "588",
            "cardholder_billing_currency_code": "826",
            "cardholder_billing_conversion_rate": "5.1",
            "transaction_to_base_currency_rate": "5.1",
            "base_to_billing_currency_rate": "5.1",
            "date": "2025-07-17",
            "reason_code": "",
            "merchant_category_code": "5734",
            "reference_number": "15555555198000005058641",
            "acquiring_institution_id_code": "100000",
            "forwarding_institution_id_code": "555555",
            "authorization_code": "573407",
            "card_acceptor_terminal_id": "MAILORD1",
            "card_acceptor_id": "MERCHANT 000002",
            "card_acceptor_name": "CLOWD9 TRAVEL           ",
            "card_acceptor_city": "LONDON       ",
            "card_acceptor_post_code": "840SW1 3AN",
            "card_acceptor_country_code": "GBR",
            "licensed_product_identifier": "MRG",
            "network_card_program_identifier": "",
            "bin_type": "",
            "product_type": "",
            "central_site_business_date": "2019-02-22",
            "special_condition_indicator": "N",
            "settlement_service_level_code": "1",
            "settlement_date": "2025-07-17",
            "additional_amount_type": "",
            "additional_amount": "0",
            "additional_amount_currency_code": "",
            "interchange_fee": "D000000000001234567",
            "transaction_link_id": ""
        },
        {
            "program_name": "CLOWD9 Travel",
            "program_id": "f1cc05a5-50d3-4a96-81df-cef0b8c3168a",
            "product_id": "4fac231b-2a2c-4212-a4db-d809a661d902",
            "card_id": "9347b6be-6b9e-48c1-9a21-36d641889e9a",
            "network_name": "Mastercard",
            "clearing_outcome": "0",
            "clearing_cycle": "04",
            "authorizations": [
                {
                    "transaction_id": "6268765e-ba76-4375-be7c-0da9e28e7e33",
                    "system_trace_audit_number": "750567",
                    "retrieval_reference_number": "519875694245"
                }
            ],
            "record_id_clearing": "333bf71c-cd6e-46ec-8955-cb03e87da84a",
            "clearing_category": "credit",
            "presentment_type": "0",
            "transaction_type": "20",
            "transaction_service": "Returns/Refunds",
            "from_account": "00",
            "to_account": "00",
            "direction": "Credit",
            "transaction_amount": "2000",
            "transaction_currency_code": "978",
            "reconciliation_amount": "1709",
            "reconciliation_currency_code": "826",
            "cardholder_billing_amount": "1709",
            "cardholder_billing_currency_code": "826",
            "cardholder_billing_conversion_rate": "1.17",
            "transaction_to_base_currency_rate": "1.17",
            "base_to_billing_currency_rate": "1.17",
            "date": "2025-07-17",
            "reason_code": "",
            "merchant_category_code": "5411",
            "reference_number": "15555555198000007505672",
            "acquiring_institution_id_code": "100000",
            "forwarding_institution_id_code": "555555",
            "authorization_code": "912158",
            "card_acceptor_terminal_id": "RFCHIPE1",
            "card_acceptor_id": "MERCHANT 000005",
            "card_acceptor_name": "CLOWD9 TRAVEL        ",
            "card_acceptor_city": "LONDON       ",
            "card_acceptor_post_code": "826SW1 3AN",
            "card_acceptor_country_code": "GBR",
            "licensed_product_identifier": "MRG",
            "network_card_program_identifier": "",
            "bin_type": "",
            "product_type": "",
            "central_site_business_date": "2019-02-22",
            "special_condition_indicator": "N",
            "settlement_service_level_code": "1",
            "settlement_date": "2025-07-17",
            "additional_amount_type": "",
            "additional_amount": "0",
            "additional_amount_currency_code": "",
            "interchange_fee": "D000000000001234567",
            "transaction_link_id": ""
        }
    ]
}