Can be joined to Disputes to compare potential credit attributes with those of the disputed transaction
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 | |
Potential Credit Details | MerchantCreditList[].TransactionDate | DATE | The date of the transaction, as provided by the system of record. This generally represents the Posting Date. | CONDITIONAL | 2023-08-16 | |
Potential Credit Details | MerchantCreditList[].AuthorizationCode/AUTHCODE | VARCHAR(8) | A credit card authorization or approval code is an alphanumeric string generated at the POS. Normally consisting of five to six characters, this one-time approval code is unique to each transaction. | CONDITIONAL | 85541091 | |
Potential Credit Details | MerchantCreditList[].TransactionId | VARCHAR(256) | A unique ID associated with a transaction. This value is provided by the transaction system of record. | CONDITIONAL | 000002174116543800 | |
Potential Credit Details | MerchantCreditList[].AcquirerReferenceNumber/ARN | VARCHAR(32) | A unique number assigned to a credit card transaction as it moves through the payment flow. | CONDITIONAL | 13199982166549566629334 | |
Potential Credit Details | MerchantCreditList[].PostingDate | DATE | The date the transaction posted to the customer/member account. | CONDITIONAL | 2023-08-17 | |
Potential Credit Details | MerchantCreditList[].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. | CONDITIONAL | http://APPLE.COM/BILL , 866-712-7753, CAUS | |
Potential Credit Details | MerchantCreditList[].MerchantName | VARCHAR(256) | Name of the business providing goods or services, as provided by the system of record. | CONDITIONAL | http://APPLE.COM/BILL , 866-712-7753, CAUS | |
Potential Credit Details | MerchantCreditList[].Amount | NUMBER(92) | The amount of the potential credit transaction. | ALWAYS | 11.99 | |
Potential Credit Details | MerchantCreditCheckOutcome/OUTCOME | VARCHAR(16) | For merchant credit checking, this represents the result of the check or user review. | ALWAYS | "Auto", "Manual", "No Match", "Canceled" | |
Potential Credit Details | MerchantCreditList[].AppliedAmount | NUMBER(92) | The amount of the credit that was applied to the dispute. | CONDITIONAL | 11.99 | (where applicable) |
Potential Credit Details | MerchantCreditList[].Iteration | NUMBER(20) | For matching algorithms, such as merchant credit or authorization posting, this number represents the the highest probability rule that resulted in a match. | ALWAYS | 5 | |
Potential Credit Details | IsMerchantCreditExpected/ISCREDITEXPECTED | BOOLEAN | When a credit for a dispute is promised, such as in the case of merchant collaboration, this Boolean value is set to true. | CONDITIONAL | FALSE | |
Potential Credit Details | MerchantCreditSearchStartDate/SEARCHSTARTDATE | DATE | Represents the start of the search range when searching for merchant credits. With each subsequent check, the start date begins on the end date of the previous check. | CONDITIONAL | 2023-08-24 | |
Potential Credit Details | MerchantCreditList[].MatchResult | VARCHAR(16) | For matching algorithms, such as merchant credit or authorization posting, this represents whether a match was applied automatically or referred to a user. | CONDITIONAL | "Auto Match", "Review" | |
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 |