mysql> select * from pos_transactions; +----+----------------+-------------------+--------------+----------+----------+---------------+--------------------+----------+---------+---------------------+----------------+--------------+-----------------+--------------+--------------------+------------------+-----------------+---------------------+---------------------+ | id | transaction_id | merchant_id | terminal_id | amount | currency | card_type | card_number_masked | mcc_code | status | transaction_time | location | country_code | settlement_date | batch_number | authorization_code | reference_number | additional_data | inserted_at | updated_at | +----+----------------+-------------------+--------------+----------+----------+---------------+--------------------+----------+---------+---------------------+----------------+--------------+-----------------+--------------+--------------------+------------------+-----------------+---------------------+---------------------+ | 4 | TEST_POS_001 | TEST_MERCHANT_001 | POS_TERM_001 | 89.99 | AED | domestic | 485498******6740 | NULL | success | 2026-03-05 11:37:04 | POS Terminal 1 | NULL | NULL | NULL | NULL | NULL | NULL | 2026-03-05 11:37:04 | 2026-03-05 11:37:04 | | 5 | TEST_POS_002 | TEST_MERCHANT_001 | POS_TERM_001 | 12500.00 | AED | domestic | 485498******6740 | NULL | success | 2026-03-05 11:47:04 | POS Terminal 1 | NULL | NULL | NULL | NULL | NULL | NULL | 2026-03-05 11:47:04 | 2026-03-05 11:47:04 | | 6 | TEST_POS_003 | TEST_MERCHANT_001 | POS_TERM_002 | 5000.00 | AED | international | 3747*******2009 | NULL | success | 2026-03-05 12:02:04 | POS Terminal 2 | NULL | NULL | NULL | NULL | NULL | NULL | 2026-03-05 12:02:04 | 2026-03-05 12:02:04 | | 7 | TEST_POS_004 | TEST_MERCHANT_001 | POS_TERM_003 | 125.00 | AED | domestic | 485498******6740 | NULL | success | 2026-03-05 12:28:04 | POS Terminal 3 | NULL | NULL | NULL | NULL | NULL | NULL | 2026-03-05 12:28:04 | 2026-03-05 12:28:04 | | 8 | TEST_POS_005 | TEST_MERCHANT_001 | POS_TERM_003 | 235.50 | AED | domestic | 485498******6740 | NULL | success | 2026-03-05 12:29:34 | POS Terminal 3 | NULL | NULL | NULL | NULL | NULL | NULL | 2026-03-05 12:29:34 | 2026-03-05 12:29:34 | | 9 | TEST_POS_006 | TEST_MERCHANT_001 | POS_TERM_003 | 99.99 | AED | domestic | 485498******6740 | NULL | success | 2026-03-05 12:30:34 | POS Terminal 3 | NULL | NULL | NULL | NULL | NULL | NULL | 2026-03-05 12:30:34 | 2026-03-05 12:30:34 | | 10 | TEST_POS_007 | TEST_MERCHANT_001 | POS_TERM_003 | 445.00 | AED | domestic | 485498******6740 | NULL | success | 2026-03-05 12:31:34 | POS Terminal 3 | NULL | NULL | NULL | NULL | NULL | NULL | 2026-03-05 12:31:34 | 2026-03-05 12:31:34 | +----+----------------+-------------------+--------------+----------+----------+---------------+--------------------+----------+---------+---------------------+----------------+--------------+-----------------+--------------+--------------------+------------------+-----------------+---------------------+---------------------+ mysql> select * from transactions limit 5; +----+--------------+------+-------------+------------------------------+-----------+---------------+------------------------+-------+---------+----------+-------------+----------------------+------------------+-----------------+---------+------------+--------------+---------+----------------+--------------------+------------------------+------------------+------+-------------+-------------+-------------+----------------------------------------------------------------------------------------------------------------------------+---------------------+---------------------+----------------------+---------+----------------------+---------------------+---------------+--------------+-----------------+---------------+-------------------+--------------+---------+ | id | patient_name | uhid | charge_rate | email | mobile_no | processing_id | provider_processing_id | uname | user_id | pay_mode | location_id | transaction_location | credentials_user | credentials_key | version | return_url | response_url | status | transaction_id | transaction_amount | transaction_ref_number | m_ref_num | name | provider_id | device_id | merchant_id | additional_data | inserted_at | updated_at | payment_reference_id | payload | settlement_date_time | refund_reference_id | provider_name | batch_number | bank_user_id | settlement_id | settlement_status | merchant_tag | ysp_tid | +----+--------------+------+-------------+------------------------------+-----------+---------------+------------------------+-------+---------+----------+-------------+----------------------+------------------+-----------------+---------+------------+--------------+---------+----------------+--------------------+------------------------+------------------+------+-------------+-------------+-------------+----------------------------------------------------------------------------------------------------------------------------+---------------------+---------------------+----------------------+---------+----------------------+---------------------+---------------+--------------+-----------------+---------------+-------------------+--------------+---------+ | 1 | NULL | NULL | NULL | ch_cc78241903f6@momentpay.in | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | pending | NULL | 11200.00 | testing111 | 6D5F0549B298089A | test | 1 | 90080001-qr | test123 | {"externalRefNumber2": "ref2", "externalRefNumber4": "ref4", "externalRefNumbers": [], "customerMobileNumber": 6201561171} | 2025-04-30 09:58:57 | 2025-04-30 09:58:57 | NULL | NULL | NULL | NULL | NULL | NULL | Mercury_6FBBED6 | NULL | unmatched | US421AX | NULL | | 2 | NULL | NULL | NULL | ch_8ac17c24eaa8@momentpay.in | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | pending | NULL | 11200.00 | testing111 | 6D5F711A39810375 | test | 1 | 90080001-qr | test123 | {"externalRefNumber2": "ref2", "externalRefNumber4": "ref4", "externalRefNumbers": [], "customerMobileNumber": 6201561171} | 2025-04-30 10:03:31 | 2025-04-30 10:03:31 | NULL | NULL | NULL | NULL | NULL | NULL | Mercury_6FBBED6 | NULL | unmatched | US421AX | NULL | | 3 | NULL | NULL | NULL | ch_091287a35580@momentpay.in | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | pending | NULL | 11200.00 | testing111 | 6D5FEFB7F49153A7 | test | 1 | 90080001-qr | test123 | {"externalRefNumber2": "ref2", "externalRefNumber4": "ref4", "externalRefNumbers": [], "customerMobileNumber": 6201561171} | 2025-04-30 10:05:29 | 2025-04-30 10:05:29 | NULL | NULL | NULL | NULL | NULL | NULL | Mercury_6FBBED6 | NULL | unmatched | US421AX | NULL | | 4 | NULL | NULL | NULL | ch_74f7186ffd4e@momentpay.in | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | pending | NULL | 11200.00 | testing111 | 6D5FC0B0687073CE | test | 1 | 90080001-qr | test123 | {"externalRefNumber2": "ref2", "externalRefNumber4": "ref4", "externalRefNumbers": [], "customerMobileNumber": 6201561171} | 2025-04-30 10:31:53 | 2025-04-30 10:31:53 | NULL | NULL | NULL | NULL | NULL | NULL | Mercury_6FBBED6 | NULL | unmatched | US421AX | NULL | | 5 | NULL | NULL | NULL | ch_13e1a387ca9d@momentpay.in | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | pending | NULL | 11200.00 | testing111 | 6D5FF25AEEEBA62F | test | 1 | 90080001-qr | test123 | {"externalRefNumber2": "ref2", "externalRefNumber4": "ref4", "externalRefNumbers": [], "customerMobileNumber": 6201561171} | 2025-04-30 10:42:30 | 2025-04-30 10:42:30 | NULL | NULL | NULL | NULL | NULL | NULL | Mercury_6FBBED6 | NULL | unmatched | US421AX | NULL | +----+--------------+------+-------------+------------------------------+-----------+---------------+------------------------+-------+---------+----------+-------------+----------------------+------------------+-----------------+---------+------------+--------------+---------+----------------+--------------------+------------------------+------------------+------+-------------+-------------+-------------+----------------------------------------------------------------------------------------------------------------------------+---------------------+---------------------+----------------------+---------+----------------------+---------------------+---------------+--------------+-----------------+---------------+-------------------+--------------+---------+ 5 rows in set (0.00 sec)