Description:	List of all resolved disputes where a chargeback has been submitted, including the data and the amount of the chargeback.
Sources:	Dispute, Claim, RecoveryAction

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"
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' 
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.

Change Log

Date	Description
11/1/2024	New

Chargebacks

SQL

Field Glossary

Change Log