Home > Manuals > Tutorials > > Tutorials
select id from charge_transaction
sub_batch_fk = 1234
and response_code in ('A01', 'A05')
and remaining_amount > 0
original_reference_number original transactionId,
account_number_masked account number,
account_accessory_masked account accessory,
request_date between '2018-11-01' and '2018-11-01'
and transaction_memo = 'batch refund issued'