SELECT b.client_account_name,a.* FROM benificiary_payment a left join api_data b on a.switch_id=b.id where a.paid_on between '2023-12-01 09:28:02' and '2023-12-08 09:28:02' ORDER BY a.id DESC

PAYMENT REQUESTS

From: To:  

Id Order Id Submitted Age Paid On Submitted Account Name Verified Account Name Account Number Bank Name Beneficiary Amount (NGN) Verification Status Approval Status Payment Status
Id Order Id Submitted Age Paid On Submitted Account Name Verified Account Name Account Number Bank Name Beneficiary Amount (NGN) Status Action
Id Order Id Submitted Age Paid On Submitted Account Name Verified Account Name Account Number Bank Name Beneficiary Amount (NGN) Status Action
Id Order Id Submitted Age Paid On Submitted Account Name Verified Account Name Account Number Bank Name Beneficiary Amount (NGN) Status Action
Id Order Id Submitted Age Paid On Submitted Account Name Verified Account Name Account Number Bank Name Beneficiary Amount (NGN) Status Channel Action
Id Order Id Submitted Voided Submitted Account Name Verified Account Name Account Number Bank Name Beneficiary Amount (NGN) Status Action