Skip to end of banner
Go to start of banner

Representments

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

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

<font face="Courier New" size="2">
<font color = "blue">SELECT</font> <font color = "maroon">client</font><font color = "silver">.</font><font color = "maroon">commonname</font>               <font color = "blue">AS</font> <font color = "maroon">"Client"</font><font color = "silver">,</font>
<br/>       <font color = "maroon">c</font><font color = "silver">.</font><font color = "maroon">claimtype</font>                     <font color = "blue">AS</font> <font color = "maroon">"Claim Type"</font><font color = "silver">,</font>
<br/>       <font color = "maroon">c</font><font color = "silver">.</font><font color = "maroon">reasontype</font>                    <font color = "blue">AS</font> <font color = "maroon">"Claim Category"</font><font color = "silver">,</font>
<br/>       <font color = "maroon">c</font><font color = "silver">.</font><font color = "maroon">reason</font>                        <font color = "blue">AS</font> <font color = "maroon">"Claim Reason"</font><font color = "silver">,</font>
<br/>       <font color = "maroon">d</font><font color = "silver">.</font><font color = "maroon">claimid</font>                       <font color = "blue">AS</font> <font color = "maroon">"Claim ID"</font><font color = "silver">,</font>
<br/>       <font color = "maroon">d</font><font color = "silver">.</font><font color = "maroon">disputeid</font>                     <font color = "blue">AS</font> <font color = "maroon">"Dispute ID"</font><font color = "silver">,</font>
<br/>       <font color = "maroon">c</font><font color = "silver">.</font><font color = "maroon">customercontactdate</font>           <font color = "blue">AS</font> <font color = "maroon">"Contact Date"</font><font color = "silver">,</font>
<br/>       <font color = "maroon">d</font><font color = "silver">.</font><font color = "maroon">acquirernetwork</font>               <font color = "blue">AS</font> <font color = "maroon">"Network"</font><font color = "silver">,</font>
<br/>       <font color = "maroon">d</font><font color = "silver">.</font><font color = "maroon">status</font>                        <font color = "blue">AS</font> <font color = "maroon">"Dispute Status"</font><font color = "silver">,</font>
<br/>       <font color = "maroon">d</font><font color = "silver">.</font><font color = "maroon">disputeamount</font>                 <font color = "blue">AS</font> <font color = "maroon">"Dispute Amount"</font><font color = "silver">,</font>
<br/>       <font color = "#FF0080"><b>To_date</b></font><font color = "maroon">(</font><font color = "maroon">cb</font><font color = "silver">.</font><font color = "maroon">performedondatetime</font><font color = "maroon">)</font> <font color = "blue">AS</font> <font color = "maroon">"Chargeback Date"</font><font color = "silver">,</font>
<br/>       <font color = "maroon">cb</font><font color = "silver">.</font><font color = "maroon">amount</font>                       <font color = "blue">AS</font> <font color = "maroon">"Chargeback Amount"</font><font color = "silver">,</font>
<br/>       <font color = "#FF0080"><b>To_date</b></font><font color = "maroon">(</font><font color = "maroon">rp</font><font color = "silver">.</font><font color = "maroon">performedondatetime</font><font color = "maroon">)</font> <font color = "blue">AS</font> <font color = "maroon">"Representment Date"</font><font color = "silver">,</font>
<br/>       <font color = "maroon">rp</font><font color = "silver">.</font><font color = "maroon">amount</font>                       <font color = "blue">AS</font> <font color = "maroon">"Representment Amount"</font>
<br/><font color = "blue">FROM</font>   <font color = "maroon">dispute</font> <font color = "blue">AS</font> <font color = "maroon">d</font>
<br/>       <font color = "blue">JOIN</font> <font color = "maroon">claim</font> <font color = "blue">AS</font> <font color = "maroon">c</font>
<br/>         <font color = "blue">ON</font> <font color = "maroon">d</font><font color = "silver">.</font><font color = "maroon">tenantid</font> <font color = "silver">=</font> <font color = "maroon">c</font><font color = "silver">.</font><font color = "maroon">tenantid</font>
<br/>            <font color = "blue">AND</font> <font color = "maroon">d</font><font color = "silver">.</font><font color = "maroon">claimid</font> <font color = "silver">=</font> <font color = "maroon">c</font><font color = "silver">.</font><font color = "maroon">claimid</font>
<br/>       <font color = "blue">JOIN</font> <font color = "maroon">client</font> <font color = "blue">AS</font> <font color = "maroon">client</font>
<br/>         <font color = "blue">ON</font> <font color = "maroon">d</font><font color = "silver">.</font><font color = "maroon">tenantid</font> <font color = "silver">=</font> <font color = "maroon">client</font><font color = "silver">.</font><font color = "maroon">tenantid</font>
<br/>            <font color = "blue">AND</font> <font color = "maroon">d</font><font color = "silver">.</font><font color = "maroon">clientid</font> <font color = "silver">=</font> <font color = "maroon">client</font><font color = "silver">.</font><font color = "maroon">clientid</font>
<br/>       <font color = "blue">JOIN</font> <font color = "maroon">recoveryaction</font> <font color = "blue">AS</font> <font color = "maroon">cb</font>
<br/>         <font color = "blue">ON</font> <font color = "maroon">d</font><font color = "silver">.</font><font color = "maroon">tenantid</font> <font color = "silver">=</font> <font color = "maroon">cb</font><font color = "silver">.</font><font color = "maroon">tenantid</font>
<br/>            <font color = "blue">AND</font> <font color = "maroon">d</font><font color = "silver">.</font><font color = "maroon">disputeid</font> <font color = "silver">=</font> <font color = "maroon">cb</font><font color = "silver">.</font><font color = "maroon">disputeid</font>
<br/>            <font color = "blue">AND</font> <font color = "maroon">cb</font><font color = "silver">.</font><font color = "maroon">actionname</font> <font color = "blue">IN</font> <font color = "maroon">(</font> <font color = "red">'Dispute Submitted'</font><font color = "silver">,</font>
<br/>                                   <font color = "red">'Rapid Dispute Resolution'</font> <font color = "maroon">)</font>
<br/>            <font color = "blue">AND</font> <font color = "maroon">cb</font><font color = "silver">.</font><font color = "maroon">cycle</font> <font color = "silver">=</font> <font color = "red">'1'</font>
<br/>       <font color = "blue">JOIN</font> <font color = "maroon">recoveryaction</font> <font color = "blue">AS</font> <font color = "maroon">rp</font>
<br/>         <font color = "blue">ON</font> <font color = "maroon">d</font><font color = "silver">.</font><font color = "maroon">tenantid</font> <font color = "silver">=</font> <font color = "maroon">rp</font><font color = "silver">.</font><font color = "maroon">tenantid</font>
<br/>            <font color = "blue">AND</font> <font color = "maroon">d</font><font color = "silver">.</font><font color = "maroon">disputeid</font> <font color = "silver">=</font> <font color = "maroon">rp</font><font color = "silver">.</font><font color = "maroon">disputeid</font>
<br/>            <font color = "blue">AND</font> <font color = "maroon">rp</font><font color = "silver">.</font><font color = "maroon">actionname</font> <font color = "blue">IN</font> <font color = "maroon">(</font> <font color = "red">'Inbound Pre-Compliance Received'</font><font color = "silver">,</font>
<br/>                                   <font color = "red">'Dispute Declined'</font><font color = "silver">,</font>
<br/>                                   <font color = "red">'Pre-Arbitration Received'</font><font color = "silver">,</font>
<br/>                                       <font color = "red">'Dispute Accepted - Partial'</font> <font color = "maroon">)</font>
<br/><font color = "blue">WHERE</font>  <font color = "maroon">d</font><font color = "silver">.</font><font color = "maroon">tenantid</font> <font color = "silver">=</font> <font color = "red">'YOURTENANTIDHERE'</font>
<br/>       <font color = "blue">AND</font> <font color = "maroon">rp</font><font color = "silver">.</font><font color = "maroon">performedondatetime</font> <font color = "silver">=</font> <font color = "maroon">:daterange</font> 
</font>

Field Glossary

FieldDefinition
ClientThe 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.
NetworkA 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 AmountThe current amount in dispute, accounting for any recoveries or adjustments.
Chargeback DateDate the chargeback was performed.
Chargeback AmountAmount of the chargeback.
Representment DateDate the representment was received.
Representment AmountAmount of the representment.

Change Log

DateDescription
11/1/2024New
  • No labels