It is important that you always include tenantID in your WHERE clause. Not doing so will result in poor performance. WHERE tenantid = 'YOURTENANTIDHERE'
SQL
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 |