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 Claim Details ClaimReason VARCHAR(64) Identifies the specific reason associated with the claim. ALWAYS MerchantNotProvided Account Details IsChipOnCard BOOLEAN A boolean value chip presence, based on client profile settings. CONDITIONAL FALSE ChipCardDefault client info Only applicable when provided by the System of Record. Account Details IsPinPreferredChipCard BOOLEAN A Boolean value PIN-preferring chip presence, based on client profile settings. CONDITIONAL FALSE PinPreferringChipCardCreditDefault/PinPreferringChipCardDebitDefault client info Only applicable when provided by the System of Record. Dispute Details CBRightsExpirationDate DATE A date value the represents the last day that a chargeback can be submitted, based on network rules. CONDITIONAL 2024-01-09 DateCBRightsExpire Only applicable when provided by the System of Record. Claim Details FraudType VARCHAR(48) An alphanumeric value set based on network rules. For more details, see Fraud Reporting. CONDITIONAL Issuer reported counterfeit Only applicable when provided by the System of Record. Transaction Details Amount NUMBER(92) Amount of the transaction. CONDITIONAL 19.99 Only applicable when provided by the System of Record. Transaction Details CardNumber VARCHAR(32) The card number associated with the disputed transaction(s). CONDITIONAL 424002******2079 Only applicable when provided by the System of Record. Dispute Details DisputedAmount NUMBER(92) The current amount in dispute, accounting for any recoveries or adjustments. CONDITIONAL 19.99 Only applicable when provided by the System of Record. Transaction Details MerchantCategoryCode (MCC) VARCHAR(6) Also referred to as "MCC", this 4-digit code represents the type of goods or services a business offers. CONDITIONAL 5816 Only applicable when provided by the System of Record. Transaction Details AcquirerRegion VARCHAR(3) CONDITIONAL 1 Only applicable when provided by the System of Record. Transaction Details AuthorizationCode VARCHAR(64) 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 853118 Only applicable when provided by the System of Record. Transaction Details AuthorizationResponseCode VARCHAR(3) CONDITIONAL A - 000 Only applicable when provided by the System of Record. Transaction Details BusinessAppId VARCHAR(4) This value is provided in card authorization data and provides additional information regarding the usage an application of the transaction. CONDITIONAL TU Only applicable when provided by the System of Record. Transaction Details CardAuthenticationResults VARCHAR(4) CONDITIONAL 2 Only applicable when provided by the System of Record. Transaction Details CardholderIdMethodCode VARCHAR(3) CONDITIONAL 4 Only applicable when provided by the System of Record. Transaction Details ChipDataServiceCode VARCHAR(4) CONDITIONAL 201 Only applicable when provided by the System of Record. Transaction Details CvvResult VARCHAR(3) The CVV2 Result Code contains verification result for card-not-present transactions and for card present CVV2 verification-only requests. CONDITIONAL 2 Only applicable when provided by the System of Record. Transaction Details DCCInd VARCHAR(3) Dynamic currency conversion, or DCC, is a point-of-sale payment option that allows cardholders from abroad the option of paying in the local currency or their own currency. CONDITIONAL 1 Only applicable when provided by the System of Record. Transaction Details ECMOTO VARCHAR(3) CONDITIONAL 7 Only applicable when provided by the System of Record. Transaction Details FallbackInd VARCHAR(8) This field indicates the reason why a chip-capable terminal processed the transaction using the magnetic strip of a chip-capable card for Visa, MasterCard, or Discover. The field will be blank when a fallback does not occur. CONDITIONAL 0 Only applicable when provided by the System of Record. Transaction Details IssuerRegion VARCHAR(3) CONDITIONAL 1 Only applicable when provided by the System of Record. Transaction Details LocalCashBackAmount NUMBER(92) CONDITIONAL 10.00 Only applicable when provided by the System of Record. Transaction Details MarketSpecificDataInd VARCHAR(2) CONDITIONAL B Only applicable when provided by the System of Record. Transaction Details AuthMotoeCommerce VARCHAR(2) CONDITIONAL Only applicable when provided by the System of Record. Transaction Details PosConditionCode VARCHAR(2) A code identifying transaction conditions at the point-of-sale or point-of-service. CONDITIONAL 59 Only applicable when provided by the System of Record. Transaction Details PosEntryMode VARCHAR(2) Code representing how the merchant entered the transaction at the point of sale (POS). CONDITIONAL 10 Only applicable when provided by the System of Record. Transaction Details AuthPosEnvironment VARCHAR(2) CONDITIONAL R Only applicable when provided by the System of Record. Transaction Details PosPinEntryCapabilityCode VARCHAR(3) CONDITIONAL 1 Only applicable when provided by the System of Record. Transaction Details PosTerminalCapabilityCode VARCHAR(3) CONDITIONAL 5 Only applicable when provided by the System of Record. Transaction Details ProductId VARCHAR(4) CONDITIONAL F Only applicable when provided by the System of Record. Transaction Details Token VARCHAR(32) CONDITIONAL 447930782026**** Only applicable when provided by the System of Record. Transaction Details AuthTransactionType VARCHAR(8) CONDITIONAL 0100 Only applicable when provided by the System of Record. Transaction Details AcquirerNetworkId VARCHAR(4) A 4-digit numeric code representing the acquirer network that processed the transaction. CONDITIONAL BII Only applicable when provided by the System of Record. Transaction Details ClearingMotoeCommerce VARCHAR(3) CONDITIONAL Only applicable when provided by the System of Record. Transaction Details ClearingPosEnvironment VARCHAR(2) CONDITIONAL C Only applicable when provided by the System of Record. Transaction Details ClearingTransactionType VARCHAR(8) CONDITIONAL 1240 Only applicable when provided by the System of Record. Transaction Details FraudReportDateTime TIMESTAMP_NTZ(9) Datetime that fraud reporting was completed. CONDITIONAL 2023-09-09 21:00:00 Only applicable when provided by the System of Record. Transaction Details WasResolveAttempted BOOLEAN CONDITIONAL FALSE Only applicable when provided by the System of Record. Dispute Details HasChargebackRights BOOLEAN A boolean value representing whether chargeback rights exist for a specified dispute. CONDITIONAL FALSE Only applicable when provided by the System of Record. 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