It is important that you always include tenantID in your WHERE clause. Not doing so will result in poor performance. WHERE tenantid = 'YOURTENANTIDHERE'
SQL
select
client.commonname as "Client",
c.claimtype as "Claim Type",
c.reasontype as "Claim Category",
c.reason as "Claim Reason",
d.claimid as "Claim ID",
d.disputeid as "Dispute ID",
c.customercontactdate as "Contact Date",
d.acquirernetwork as "Network",
d.status as "Dispute Status",
d.disputeamount as "Dispute Amount",
to_date(cb.performedondatetime) as "Chargeback Date",
cb.amount as "Chargeback Amount",
to_date(rp.performedondatetime) as "Representment Date",
rp.amountas "Representment Amount"
from
dispute as d
join claim as c
on d.tenantid = c.tenantid and d.claimid = c.claimid
join client as client
on d.tenantid = client.tenantid and d.clientid = client.clientid
join recoveryaction as cb
on d.tenantid = cb.tenantid and d.disputeid = cb.disputeid and cb.actionname in ('Dispute Submitted', 'Rapid Dispute Resolution') and cb.cycle = '1'
join recoveryaction as rp
on d.tenantid = rp.tenantid and d.disputeid = rp.disputeid and rp.actionname in ('Inbound Pre-Compliance Received', 'Dispute Declined', 'Pre-Arbitration Received', 'Dispute Accepted - Partial')
where
cb.performedondatetime is not null -- only disputes with chargebacks
where
d.tenantid = 'YOURTENANTIDHERE'
AND chargebackdate=:daterange
Field Glossary
| Field | Definition |
|---|---|
| Client | The common name of the issuer, as identified by it's employees and customers/members. This value is used in various places throughout the application. See also, Legal Name. |
| Claim Type | See Transaction Type. |
| Claim Category | General categorization of the claim. For a more precise description, see Claim Reason. |
| Claim Reason | Identifies the specific reason associated with the claim. |
| Network | A network is a company that provides the communication system between a merchant and a card issuer in order to process transactions. For more details, see Acquirer Networks. |
| Claim ID | Unique ID associated with a claim. Format: YYMMDD<Ordinal Number>"C" Example: 2405230003C |
| Dispute ID | Unique ID associated with a disputed transaction. Format: YYMMDD#####"D" |
| Contact Date | Represents the date that the claim was received from the accountholder. |
| Dispute Status | Current status of an individual transaction on a claim. See Work Status for a comprehensive list of values. |
| Dispute Amount | The current amount in dispute, accounting for any recoveries or adjustments. |
| Chargeback Date | Date the chargeback was performed. |
| Chargeback Amount | Amount of the chargeback. |
| Representment Date | Date the representment was received. |
| Representment Amount | Amount of the representment. |
Change Log
| Date | Description |
|---|---|
| 11/1/2024 | New |