Chargeback reject activity is useful for understanding the effectiveness of recovery rules . Whenever a chargeback is rejected by Visa or Mastercard, an event is created. Each event includes basic details about the disputed transaction and any reason code or description provided by the network rejecting the chargeback.
Data Category | Event Field/Column Name | Data Type | Description | Applicability | Sample Value | Notes |
|---|---|---|---|---|---|---|
Key | TenantId | VARCHAR(32) | Unique ID associated with each Quavo client. | ALWAYS | qvo-stg |
|
Key | ClientId | VARCHAR(64) | A unique ID representing a single client. | ALWAYS | Default |
|
Key | ClaimId | VARCHAR(32) |
Unique ID associated with a claim. Format: YYMMDD<Ordinal Number>"C" Example: 2405230003C
| ALWAYS | 2306060014C |
|
Key | DisputeId | VARCHAR(32) | Unique ID associated with a disputed transaction. Format: YYMMDD#####"D" | ALWAYS | 2306050001D |
|
Rejection Details | TransactionDate | DATE | The date of the transaction, as provided by the system of record. This generally represents the Posting Date. | ALWAYS | 2023-06-24 |
|
Rejection Details | PostingDate | DATE | The date the transaction posted to the customer/member account. | ALWAYS | 2023-06-25 |
|
Rejection Details | Description | VARCHAR(256) | A description of the transaction as provided by the system of record. Typically, this will match what the customer/member sees on their account statement. | ALWAYS | CASH APP*VISA MONEY TRANS |
|
Rejection Details | Amount | NUMBER(9,2) | The amount of the transaction. | ALWAYS | 11.00 |
|
Rejection Details | RecoveryAmount | NUMBER(9,2) | The amount in dispute for a submitted chargeback. | ALWAYS | 11.00 |
|
Rejection Details | Network | VARCHAR(32) | 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. | ALWAYS | VISA |
|
Rejection Details | REASONCODEKEY | VARCHAR(64) | A code provided by the network, representing a reason for the reject. | CONDITIONAL |
|
|
Rejection Details | REASONCODEVALUE | VARCHAR(128) | A message provided by the network, representing a reason for the reject. | CONDITIONAL |
| (where applicable) |
Rejection Details | PerformedById | VARCHAR(128) | User that recorded the reject. | ALWAYS |
| |
Rejection Details | RejectCode | VARCHAR(64) | A code provided by the network, representing a reason for the reject. | CONDITIONAL |
|
|
Rejection Details | RejectMessage | VARCHAR(256) | A message provided by the network, representing a reason for the reject. | CONDITIONAL |
|
|
Rejection Details | RejectType | VARCHAR(16) | The method used by the network to reject the dispute. | ALWAYS | "Service Failure", "Reject" | For Visa, rejects are handled via service failure message ("Service Failure"). For Mastercard, a queue item is generated ("Reject"). |
Metadata | EventDateTime | TIMESTAMP_NTZ(9) | The datetime that the event was recorded. | ALWAYS | 2023-09-09 21:00:00 |
|
Metadata | EventIdentifier | VARCHAR(64) | A unique ID associated with each business event. | ALWAYS | 70b1c86d-d06f-4c93-bab2-0e938a4ef768 |
|
Metadata | EventItemId | VARCHAR(64) | An ID included with each business event that identifies the tenant and Claim ID or Dispute ID associated with the event. | ALWAYS | qvo-stg|2302030002D |
|