...
order by
transaction_time_begin
QUERY TO CHECK FOR TRANSACTION STATUS AND CORRECT MASKED PAN FROM BANK_TRANSFER_TRANSACTION
SELECT
a.[request_time],
a.[response_time],
b.[masked_pan],
a.[stan],
a.[message_name],
a.[response_code],
a.cast([request_amount] as money)/100 as request_amount,
a.[retrieval_reference_number],
a.[card_acceptor_id],
a.[terminal_id],
a.[card_acceptor_location],
a.[mti],
a.[transaction_search_key]
FROM
[aptent_db].[dbo].[transaction_record] a
INNER JOIN
[aptent_db].[dbo].[bank_transfer_transaction] b
ON
a.[transaction_search_key] = b.[transaction_search_key]
WHERE
concat(a.[terminal_id],a.[retrieval_reference_number]) IN ('2TFD0UU6000172503150')