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 | Tenant | VARCHAR(64) | A tenant is a Quavo customer that uses QFD. Each tenant is assigned a unique Tenant ID. | ALWAYS | Default | |
Key | ClientId | VARCHAR(64) | A unique ID representing a single client. | ALWAYS | Default | |
Key | Client | VARCHAR(64) | A client is a Quavo customer that uses QFD through a relationship with a Quavo tenant. Each client is assigned a unique Client ID. | ALWAYS | Default | |
Claim Details | ClaimType | VARCHAR(64) | See Transaction Type. | CONDITIONAL | Card-Pinless | |
Claim Details | ClaimCategory | VARCHAR(64) | General categorization of the claim. For a more precise description, see Claim Reason. | CONDITIONAL | Fraud | |
Claim Details | ClaimReason | VARCHAR(64) | Identifies the specific reason associated with the claim. | CONDITIONAL | Stolen | |
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 | 2306060014D | |
Approval Details | DisputeAmount | NUMBER(9,2) | The current amount in dispute, accounting for any recoveries or adjustments. | CONDITIONAL | 99.95 | |
Approval Details | ApprovalType | VARCHAR(64) | The type of action that resulted in an approval assignment. Possible values include "Deny Dispute", "Provisional Credit", "Send Letter", and "Write Off". | ALWAYS | Write Off, Provisional Credit, Deny | |
Approval Details | CreatedByUserID | VARCHAR(64) | ID of the user that performed the action that led to the approval requirement. | ALWAYS | devan.robertson@quavo.com | |
Approval Details | CreatedBy | VARCHAR | First initial and last name of user that performed the action requiring approval. | ALWAYS | D. Robertson, System | |
Approval Details | PerformedByUserID | VARCHAR(64) | ID of the user, typically a manager, that completed the approval task. | ALWAYS | devan.robertson@quavo.com | |
Accounting Details | PerformedBy | VARCHAR | First initial and last name of user that completed the approval task. | ALWAYS | D. Robertson | |
Approval Details | Outcome | VARCHAR(32) | Outcome of the review: "Approve" or "Deny" | ALWAYS | Approve | |
Approval Details | ApprovalInfo | VARCHAR(64) | Additional details of the approval, such as the name of the letter being sent. | CONDITIONAL | Additional Information |
General
Content
Integrations