Dispute Event
- Devan Robertson
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.
Â
Data Category | Event Field/Column Name | Data Type | Description | Applicability | Sample Value | Notes |
|---|---|---|---|---|---|---|
Key | TenantId | VARCHAR(32) | ALWAYS | qvo-stg | Â | |
Key | ClientId | VARCHAR(64) | ALWAYS | Default | Â | |
Key | ClaimId | VARCHAR(32) | ALWAYS | 2306060014C | Â | |
Key | DisputeId | VARCHAR(32) | ALWAYS | 2306050001D | Â | |
Dispute Details | Status | VARCHAR(32) | ALWAYS | Open-ProcessLiability | Â | |
Dispute Details | StatusChangeDateTime | TIMESTAMP_NTZ(9) | ALWAYS | 2023-09-09 21:00:00 | Â | |
Dispute Details | DisputeAmount | NUMBER(9,2) | ALWAYS | 185.00 | Â | |
Transaction Details | TransactionId | VARCHAR(128) | ALWAYS | ABC123456789 | Â | |
Transaction Details | Amount | NUMBER(9,2) | Amount of the transaction. | ALWAYS | 185.00 | Â |
Transaction Details | AmountPosted | NUMBER(9,2) | CONDITIONAL | 185.00 | Â | |
Transaction Details | AuthCode | VARCHAR(32) |
| 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 | ALWAYS | 2023-11-11 | Â | |
Transaction Details | PostingDate | DATE | ALWAYS | 2023-11-12 | Â | |
Transaction Details | AcquirerNetwork | VARCHAR(64) | CONDITIONAL | VISA | Â | |
Transaction Details | AcquirerReferenceNumber | VARCHAR(32) | Â | CONDITIONAL | Â | Â |
Transaction Details | TransactionType | VARCHAR(64) | ALWAYS | Card - Pinless | Â | |
Transaction Details | AuthorizationStatus | VARCHAR(32) | ALWAYS | Posted | Â | |
Transaction Details | Description | VARCHAR(256) | ALWAYS | GOOGLE *YouTube     g.co/helppay#CAUS |  | |
Transaction Details | MerchantCategoryCode | VARCHAR(6) | CONDITIONAL | 4829 | Â | |
Transaction Details | MerchantName | VARCHAR(256) | CONDITIONAL | GOOGLE *YouTube | Â | |
Transaction Details | POSEntryMode | VARCHAR(32) | CONDITIONAL | 05 | Â | |
Dispute Details | HasChargebackRights | BOOLEAN | CONDITIONAL | FALSE | Â | |
Dispute Details | IsChargebackSubmitted | BOOLEAN | CONDITIONAL | FALSE | Â | |
Dispute Details | OriginalDisputeAmount | NUMBER(9,2) |
| ALWAYS | 185.00 | Available in 24.01.03. |
Dispute Details | NextRecoveryDateTime | TIMESTAMP_NTZ(9) | CONDITIONAL | 2023-09-09 21:00:00 | Â | |
Accounting Details | AccountHolderTotal | NUMBER(9,2) | CONDITIONAL | 185.00 | Â | |
Accounting Details | MerchantTotal | NUMBER(9,2) | CONDITIONAL | 185.00 | Â | |
Accounting Details | LossTotal | NUMBER(9,2) | CONDITIONAL | 185.00 | Â | |
Dispute Details | Decision | VARCHAR(64) | CONDITIONAL | Deny | Â | |
Dispute Details | DenyReason | VARCHAR(64) | CONDITIONAL | No Error | Â | |
Dispute Details | DenySubReason | VARCHAR(64) | CONDITIONAL | Out of Timeframe | Â | |
Dispute Details | DenyDebitDate | DATE | CONDITIONAL | 2023-12-06 | Â | |
Dispute Details | InvestigationCompleteDateTime | TIMESTAMP_NTZ(9) | CONDITIONAL | 2023-11-28 17:32:46.625 | Â | |
Dispute Details | CustomerFinalProcessingDateTime | TIMESTAMP_NTZ(9) | CONDITIONAL | 2023-11-28 17:32:46.625 | Â | |
Dispute Details | ResolvedDateTime | TIMESTAMP_NTZ(9) | CONDITIONAL | 2023-11-28 17:32:46.625 | Â | |
Dispute Details | LastReopenDateTime | TIMESTAMP_NTZ(9) | 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 | Â |
Metadata | CreateDateTime | TIMESTAMP_NTZ(9) | ALWAYS | 2023-09-09 21:00:00 | Â | |
Metadata | SaveDateTime | TIMESTAMP_NTZ(9) | Â | ALWAYS | 2023-09-09 21:00:00 | Â |
Metadata | EventDateTime | TIMESTAMP_NTZ(9) | ALWAYS | 2023-09-09 21:00:00 | Â | |
Metadata | EventIdentifier | VARCHAR(64) | ALWAYS | 70b1c86d-d06f-4c93-bab2-0e938a4ef768 | Â | |
Metadata | EventItemId | VARCHAR(64) | ALWAYS | qvo-stg|2302030002D | Â |