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-06 DateCBRightsExpire Only applicable when provided by the System of Record. Transaction Details Amount NUMBER(92) Amount of the transaction. CONDITIONAL 14.99 Only applicable when provided by the System of Record. Dispute Details DisputeAmount NUMBER(92) The current amount in dispute, accounting for any recoveries or adjustments. CONDITIONAL 14.99 Only applicable when provided by the System of Record. Transaction Details MerchantCategoryCode VARCHAR(6) Also referred to as "MCC", this 4-digit code represents the type of goods or services a business offers. CONDITIONAL 5968 Only applicable when provided by the System of Record. Transaction Details CardDataInputMode VARCHAR(2) A code indicating the method used for PAN entry to initiate a transaction. CONDITIONAL S Only applicable when provided by the System of Record. Transaction Details CardHolderPresent VARCHAR(2) CONDITIONAL 5 Only applicable when provided by the System of Record. Transaction Details Category VARCHAR(64) Refers to the chargeback/recovery category as defined by the association. CONDITIONAL Fraud Only applicable when provided by the System of Record. Transaction Details IssuerCountry VARCHAR(3) CONDITIONAL USA Only applicable when provided by the System of Record. Transaction Details AcquirerNetwork VARCHAR(64) The network that processed the transaction on behalf of the merchant. For more details, see Acquirer Networks. CONDITIONAL Debit Mastercard Only applicable when provided by the System of Record. Transaction Details AuthIssuerBilledAmount NUMBER(92) CONDITIONAL 14.99 Only applicable when provided by the System of Record. Transaction Details CardDataInputCapability VARCHAR(2) A code indicating the set of methods supported by the terminal for the input of account number, card, or mobile device data. CONDITIONAL D Only applicable when provided by the System of Record. Transaction Details CardholderActivatedTerminalLevel VARCHAR(2) CONDITIONAL 2 Only applicable when provided by the System of Record. Transaction Details CardholderAuthenticationEntity VARCHAR(2) A code indicating the entity through which the cardholder’s identity was verified at the point of service. CONDITIONAL 9 Only applicable when provided by the System of Record. Transaction Details CardholderAuthenticationMethod VARCHAR(2) A code indicating the method by which the cardholder’s identity was verified at the point of service. CONDITIONAL 9 Only applicable when provided by the System of Record. Transaction Details CardPresent VARCHAR(2) CONDITIONAL 1 Only applicable when provided by the System of Record. Transaction Details GCMSProductIdentifier VARCHAR(4) CONDITIONAL MDJ Only applicable when provided by the System of Record. Transaction Details ECommSecurityLevelAndUcafCollectionInd VARCHAR(3) CONDITIONAL 210 Only applicable when provided by the System of Record. Transaction Details IntegratedCircuitCardRelatedData VARCHAR(64) CONDITIONAL 100 Only applicable when provided by the System of Record. Transaction Details POSCardPresence VARCHAR(2) CONDITIONAL 0 Only applicable when provided by the System of Record. Transaction Details CardAcceptorCountry VARCHAR(3) CONDITIONAL USA Only applicable when provided by the System of Record. Transaction Details CardPresentData VARCHAR(2) A code indicating if the card is present at the point of service. CONDITIONAL 1 Only applicable when provided by the System of Record. Transaction Details POSCardholderPresence VARCHAR(2) CONDITIONAL 0 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 05 Only applicable when provided by the System of Record. Transaction Details POSTerminalAttendance VARCHAR(2) CONDITIONAL 1 Only applicable when provided by the System of Record. Transaction Details ProcessingCode VARCHAR(2) CONDITIONAL 00 Only applicable when provided by the System of Record. Transaction Details ServiceCode VARCHAR(3) CONDITIONAL 201 Only applicable when provided by the System of Record. Transaction Details TerminalCapability VARCHAR(2) CONDITIONAL 1 Only applicable when provided by the System of Record. Transaction Details TerminalOperatingEnvironment VARCHAR(2) A code indicating whether the card acceptor is attending the terminal and the location of the terminal. CONDITIONAL 5 Only applicable when provided by the System of Record. Transaction Details Track1 VARCHAR(8) CONDITIONAL N Only applicable when provided by the System of Record. Transaction Details Track2 VARCHAR(8) CONDITIONAL Y201 Only applicable when provided by the System of Record. Dispute Details IsWithinHighNumberOfFraudDisputeRange BOOLEAN CONDITIONAL FALSE Only applicable when provided by the System of Record. Dispute Details IsDecree587Declared BOOLEAN CONDITIONAL FALSE Only applicable when provided by the System of Record. Dispute 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. 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 Only applicable when provided by the System of Record. Metadata EventIdentifier VARCHAR(64) A unique ID associated with each business event. ALWAYS 70b1c86d-d06f-4c93-bab2-0e938a4ef768 Only applicable when provided by the System of Record. 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 Only applicable when provided by the System of Record.