selectSELECT 
client.commonname asAS "Client",
c.claimtype asAS "Claim Type",
c.reasontype asAS "Claim Category",
c.reason asAS "Claim Reason",
d.claimid asAS "Claim ID",
d.disputeid asAS "Dispute ID",
c.customercontactdate asAS "Contact Date",
d.acquirernetwork asAS "Network",
d.status asAS "Dispute Status",
d.disputeamount asAS "Dispute Amount",
toTo_date(cb.performedondatetime) asAS "Chargeback Date",
cb.amount asAS "Chargeback Amount",
toTo_date(rp.performedondatetime) asAS "Representment Date",
rp.amountasamount AS "Representment Amount"
fromFROM dispute asAS d
joinJOIN claim asAS c onON d.tenantid = c.tenantid andAND d.claimid = c.claimid
joinJOIN client asAS client onON d.tenantid = client.tenantid andAND d.clientid = client.clientid
joinJOIN recoveryaction asAS cb onON d.tenantid = cb.tenantid andAND d.disputeid = cb.disputeid andAND cb.actionname inIN ( 'Dispute Submitted', 'Rapid Dispute Resolution' ) andAND cb.cycle = '1'
joinJOIN recoveryaction asAS rp onON d.tenantid = rp.tenantid andAND d.disputeid = rp.disputeid andAND rp.actionname inIN ( 'Inbound Pre-Compliance Received', 'Dispute Declined', 'Pre-Arbitration Received', 'Dispute Accepted - Partial' )
 
where 
cb.performedondatetime is not null -- only disputes with chargebacks 
where 
    WHERE d.tenantid = 'YOURTENANTIDHERE' AND    AND chargebackdate=rp.performedondatetime = :daterange