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 |
|
Dispute Details | Status | VARCHAR(32) | Represents the current stage or step of a particular process or lifecycle, such as a claim or dispute. | ALWAYS | Open-ProcessLiability |
|
Dispute Details | StatusChangeDateTime | TIMESTAMP_NTZ(9) | Datetime the status of the object was last changed. | ALWAYS | 2023-09-09 21:00:00 |
|
Dispute Details | DisputeAmount | NUMBER(9,2) | The current amount in dispute, accounting for any recoveries or adjustments. | ALWAYS | 185.00 |
|
Transaction Details | TransactionId | VARCHAR(128) | A unique ID associated with a transaction. This value is provided by the transaction system of record. | ALWAYS | ABC123456789 |
|
Transaction Details | Amount | NUMBER(9,2) | Amount of the transaction. | ALWAYS | 185.00 |
|
Transaction Details | AmountPosted | NUMBER(9,2) | The settled amount of a transaction. | CONDITIONAL | 185.00 |
|
Transaction Details | AuthCode | VARCHAR(32) | 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 | 855410 | Available in 24.01.03. |
Transaction Details | IsManualTransaction | BOOLEAN | Indicates whether the transaction information was entered manually by the intake user. | CONDITIONAL | TRUE | Available in 24.01.03. |
Transaction Details | TransactionDate | DATE | The date of the transaction, as provided by the system of record. This generally represents the Posting Date. | ALWAYS | 2023-11-11 |
|
Transaction Details | PostingDate | DATE | The date the transaction posted to the customer/member account. | ALWAYS | 2023-11-12 |
|
Transaction Details | AcquirerNetwork | VARCHAR(64) | 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. | CONDITIONAL | VISA |
|
Transaction Details | AcquirerReferenceNumber | VARCHAR(32) | A unique number assigned to a credit card transaction as it moves through the payment flow. | CONDITIONAL | 24055233349083742325779 |
|
Transaction Details | TransactionType | VARCHAR(64) | The type of transaction, such as ACH, BillPay, Card, Check, RTP, Wire, Zelle, etc. | ALWAYS | Card - Pinless |
|
Transaction Details | AuthorizationStatus | VARCHAR(32) | Represents the posting state of a transaction. Values include "Authorization" and "Posted". | ALWAYS | Posted |
|
Transaction 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 | GOOGLE *YouTube g.co/helppay#CAUS |
|
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 | 4829 |
|
Transaction Details | MerchantName | VARCHAR(256) | Name of the business providing goods or services, as provided by the system of record. | CONDITIONAL | GOOGLE *YouTube |
|
Transaction Details | POSEntryMode | VARCHAR(32) | Code representing how the merchant entered the transaction at the point of sale (POS). | CONDITIONAL | 05 |
|
Dispute Details | HasChargebackRights | BOOLEAN | A boolean value representing whether chargeback rights exist for a specified dispute. | CONDITIONAL | FALSE |
|
Dispute Details | IsChargebackSubmitted | BOOLEAN | A boolean value representing whether a chargeback has been processed in QFD for a particular dispute. | CONDITIONAL | FALSE |
|
Dispute Details | OriginalDisputeAmount | NUMBER(9,2) | Represents the date that the next recovery action must be completed by an issuer or acquirer to continue in the recovery process. | ALWAYS | 185.00 | Available in 24.01.03. |
Dispute Details | NextRecoveryDateTime | TIMESTAMP_NTZ(9) | Represents the date that the next recovery action must be completed by an issuer or acquirer to continue in the recovery process. | CONDITIONAL | 2023-09-09 21:00:00 |
|
Accounting Details | AccountHolderTotal | NUMBER(9,2) | The balance of the Accountholder accounting collection. Also referred to as ACCOUNTHOLDERTOTAL. | CONDITIONAL | 185.00 |
|
Accounting Details | MerchantTotal | NUMBER(9,2) | The balance of the Merchant accounting collection. Also referred to as MERCHANTTOTAL. | CONDITIONAL | 185.00 |
|
Accounting Details | LossTotal | NUMBER(9,2) | The balance of the Loss accounting collection. Also referred to as LOSSTOTAL. | CONDITIONAL | 185.00 |
|
Accounting Details | AppliedCreditsTotal | NUMBER(9,2) | Amount of all applied merchant credits. | CONDITIONAL | 185.00 | Value only exists when 1, or more, merchant credits applied to dispute. |
Dispute Details | Decision | VARCHAR(64) | When related to a claim or dispute, this represents a pay/deny decision applied. When related to recovery actions, this represents a decision made by the system or user to pursue or not pursue recovery. Reflected as either "Deny," "Write Off," or "Pay" | CONDITIONAL | Deny |
|
Dispute Details | DenyReason | VARCHAR(64) | The reason associated with a denial action. See Denied for a list of supported reasons. | CONDITIONAL | No Error |
|
Dispute Details | DenySubReason | VARCHAR(64) | A more detailed Deny Reason. | CONDITIONAL | Out of Timeframe |
|
Dispute Details | DenyDebitDate | DATE | Date that a provisional credit reversal will occur when a dispute is denied and provisional credit was previously issued. | CONDITIONAL | 2023-12-06 |
|
Dispute Details | InvestigationCompleteDateTime | TIMESTAMP_NTZ(9) | Date and/or datetime that a Pay or Deny decision is rendered for all disputes on a claim. | CONDITIONAL | 2023-11-28 17:32:46.625 |
|
Dispute Details | CustomerFinalProcessingDateTime | TIMESTAMP_NTZ(9) | Datetime that final processing is completed. Also referred to as CUSTOMERFINALPROCESSINGDATETIME. | CONDITIONAL | 2023-11-28 17:32:46.625 |
|
Dispute Details | ResolvedDateTime | TIMESTAMP_NTZ(9) | Datetime that a claim or dispute is set to a "Resolved" status.. Also referred to as RESOLVEDDATETIME. | CONDITIONAL | 2023-11-28 17:32:46.625 |
|
Dispute Details | LastReopenDateTime | TIMESTAMP_NTZ(9) | Datetime that a dispute was last reopened. | CONDITIONAL | 2023-11-28 17:32:46.625 |
|
Dispute Details | DisputeStatusDateTime | TIMESTAMP_NTZ(9) |
| CONDITIONAL | 2023-11-28 17:32:46.625 |
|
Dispute Details | IsAutoDenyLetterSuppressed | BOOLEAN |
| CONDITIONAL | TRUE |
|
Dispute Details | IsAutoPaidLetterSuppressed | BOOLEAN |
| CONDITIONAL | TRUE |
|
Dispute Details | IsAutoPCLetterSuppressed | BOOLEAN |
| CONDITIONAL | TRUE |
|
Dispute Details | IsReopened | BOOLEAN |
| CONDITIONAL | FALSE |
|
Deflection Details | WasReviewedForMerchantCredit | BOOLEAN | TRUE when a merchant credit was presented during intake in an attempt to resolved the dispute. | CONDITIONAL | TRUE | Only available with the Deflection booster. |
Deflection Details | WasReviewedForPurchaseInquiry | BOOLEAN | TRUE when purchase inquiry details were presented during intake in an attempt to resolved the dispute. | CONDITIONAL | TRUE | Only available with the Deflection booster. |
Deflection Details | WasReviewedForUndisputedHistory | BOOLEAN | TRUE when undisputed history was presented during intake in an attempt to resolved the dispute. | CONDITIONAL | TRUE | Only available with the Deflection booster. |
Deflection Details | IsDeflectedFromMerchantCredit | BOOLEAN | TRUE when the dispute was resolved in intake via merchant credit. | CONDITIONAL | TRUE | Only available with the Deflection booster. |
Deflection Details | IsDeflectedFromPurchaseInquiry | BOOLEAN | TRUE when the dispute was resolved in intake via purchase inquiry details. | CONDITIONAL | TRUE | Only available with the Deflection booster. |
Deflection Details | IsDeflectedFromUndisputedHistory | BOOLEAN | TRUE when the dispute was resolved in intake via undisputed history details. | CONDITIONAL | TRUE | Only available with the Deflection booster. |
Deflection Details | IsDeflectedFromIntake | BOOLEAN | TRUE when the dispute was resolved in intake via any deflection method. | CONDITIONAL | TRUE | Only available with the Deflection booster. |
Metadata | CreateDateTime | TIMESTAMP_NTZ(9) | The datetime that a record was created. | ALWAYS | 2023-09-09 21:00:00 |
|
Metadata | SaveDateTime | TIMESTAMP_NTZ(9) |
| ALWAYS | 2023-09-09 21:00:00 |
|
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 |
|
Each time a change is saved to a dispute-level property in QFD, an event is created. This event includes all important dispute details and will be useful for referencing from most other events to understand the full picture of the dispute.
General
Content
Integrations