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
d.clientid,
client.commonname,
c.claimtype,
c.reasontype,
c.reason,
d.claimid,
d.disputeid,
c.customercontactdate,
d.acquirernetwork,
d.status,
d.disputeamount,
to_date(cb.performedondatetime),
cb.amount
from
dispute as d
join claim as c
on d.tenantid = c.tenantid and d.claimid = c.claimid
join tenant as tenant
on d.tenantid = tenant.tenantid
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'
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" |
| Dispute Status | Current status of an individual transaction on a claim. See Work Status for a comprehensive list of values. |
| Contact Date | Represents the date that the claim was received from the accountholder. |
| 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. |
Change Log
| Date | Description |
|---|---|
| 11/1/2024 | New |