Can be joined Disputes and Recovery Actions to get more details about the disputed transaction and what recovery methods were attempted
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 |