Fields
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 TransactionDate DATE The date of the transaction, as provided by the system of record. This generally represents the Posting Date. CONDITIONAL 2023-08-16 Only applicable when provided by the System of Record. Potential Credit Details 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 Only applicable when provided by the System of Record. Potential Credit Details TransactionId VARCHAR(256) A unique ID associated with a transaction. This value is provided by the transaction system of record. CONDITIONAL 000002174116543800 Only applicable when provided by the System of Record. Potential Credit Details ARN VARCHAR(32) A unique number assigned to a credit card transaction as it moves through the payment flow. CONDITIONAL 13199982166549566629334 Only applicable when provided by the System of Record. Potential Credit Details PostingDate DATE The date the transaction posted to the customer/member account. CONDITIONAL 2023-08-17 Only applicable when provided by the System of Record. Potential Credit 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. CONDITIONAL http://APPLE.COM/BILL , 866-712-7753, CAUS Only applicable when provided by the System of Record. Potential Credit Details 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 Only applicable when provided by the System of Record. Potential Credit Details Amount NUMBER(92) The amount of the potential credit transaction. ALWAYS 11.99 Potential Credit Details 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 AppliedAmount NUMBER(92) The amount of the credit that was applied to the dispute. CONDITIONAL 11.99 Only applicable when some amount is applied. Potential Credit Details 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. CONDITIONAL 5 Only applicable for potential matches. Potential Credit Details 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 TRUE Only applicable for merchant collaboration cases. Potential Credit Details 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 Only applicable for subsequent credit checks. Potential Credit Details 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" Only applicable for potential matches. 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