Chargebacks
- Devan Robertson
Owned by Devan Robertson
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 d.tenantid = 'YOURTENANTIDHERE' AND cb.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. |
Change Log
| Date | Description |
|---|---|
| 11/1/2024 | New |