Description:	List of all disputes where a representment has been received, including the date and the amount of the chargeback and the representment.
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",
To_date(rp.performedondatetime) AS "Representment Date",
rp.amount AS "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 d.tenantid = 'YOURTENANTIDHERE'
AND rp.performedondatetime = :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

Representments

SQL

Field Glossary

Change Log