-- 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'
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter