RENT SETTLEMENT

-- 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'