-- rent settlement SELECT receiveruser AS landlord_userid, receiverphonenumber, transaction_id, totaltransactionamount as amt, receiverbankifsc, receiverbankid, receiverbankaccountsha, receiver_vpa, message, utr, receiver_name, updated_date FROM fraud.transaction_details_v3 WHERE year(updated_date) = 2022 -- AND receiveruser = '' AND sendertype = 'EXTERNAL_USER' AND receivertype = 'INTERNAL_USER' AND workflowtype = 'EXTERNAL_TO_CONSUMER' AND transfermode = 'PHONEPE_PAYOUT' AND backend_errorcode = 'SUCCESS' AND errorcode = 'SUCCESS' AND transaction_status = 'COMPLETED' AND sender_vpa = 'phonepe-payouts@yesbank'