It is important that you always include tenantID in your WHERE clause. Not doing so will result in poor performance. WHERE tenantid = 'YOURTENANTIDHERE'
SQL
SELECTclient.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 dJOIN claim AS c ON d.tenantid = c.tenantid AND d.claimid = c.claimidJOIN client AS client ON d.tenantid = client.tenantid AND d.clientid = client.clientidJOIN 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 |