Untitled

select PAYMENT_POSTED_DATE as hbpd_txn_date ,PYMT_RCPT_SEQ_NBR AS hbpd_txn_id , BANK_NAME as hbpd_bank_name , CANCELLATION_MESSAGE as hbpd_cancelled , CHANNEL_ID as hbpd_channel , CIRCLE_ID as hbpd_circle , CURRENCY_CODE as hbpd_currency , PYMT_RCPT_SEQ_NBR as hbpd_external_receipt_num , PARTY_ID as hbpd_party_id , PAYMENT_MODE as hbpd_payment_mode , PAYMENT_POSTED_DATE as hbpd_posting_date , PAYMENT_RECEIVED_DATE as hbpd_receive_date ,CREATED_BY as hbpd_user_id , PAYMENT_POSTED as hbpd_payment_amount , BANK_SORT_CODE AS hbpd_branch_code ,PAYMENT_MESSAGE as hbpd_payment_message , PARENT_RECEIPT_NUM AS hbpd_receipt_no, FINANCIAL_DOC_TYPE AS hbpd_document_type , CURRENCY_CODE as hbpd_country  , STATUS as hbpd_txn_status FROM  tib_payments.pm_payment_transaction_det where PAYMENT_POSTED_DATE >= '2022-01-01' and delete status = 'cancelled';