Data Category
Event Field/Column Name
Data Type
Description
Applicability
Sample Value
Notes
Key
TenantId
VARCHAR(32)
glossary_description
ALWAYS
qvo-stg
Key
ClientId
VARCHAR(64)
glossary_description
ALWAYS
Default
Key
ClaimId
VARCHAR(32)
glossary_description
ALWAYS
2306060014C
Key
DisputeId
VARCHAR(32)
glossary_description
ALWAYS
2306050001D
Dispute Details
Status
VARCHAR(32)
glossary_description
ALWAYS
Open-ProcessLiability
Dispute Details
StatusChangeDateTime
TIMESTAMP_NTZ(9)
glossary_description
ALWAYS
2023-09-09 21:00:00
Dispute Details
DisputeAmount
NUMBER(9,2)
glossary_description
ALWAYS
185.00
Transaction Details
TransactionId
VARCHAR(128)
glossary_description
ALWAYS
ABC123456789
Transaction Details
Amount
NUMBER(9,2)
Amount of the transaction.
ALWAYS
185.00
Transaction Details
AmountPosted
NUMBER(9,2)
glossary_description
CONDITIONAL
185.00
Only applicable for posted transactions.
Transaction Details
AuthCode
VARCHAR(32)
de23ee9f-1394-4295-aa2b-12a094417afaeJyLjgUAARUAuQ==glossary_descriptionfalse
CONDITIONAL
855410
Only applicable for dual message card transactions where provided by the System of Record. Available in 24.01.03.
Transaction Details
IsManualTransaction
BOOLEAN
Indicates whether the transaction information was entered manually by the intake user.
CONDITIONAL
TRUE
Only applicable when true. Available in 24.01.03.
Transaction Details
TransactionDate
DATE
glossary_description
ALWAYS
2023-11-11
Transaction Details
PostingDate
DATE
glossary_description
ALWAYS
2023-11-12
Transaction Details
AcquirerNetwork
VARCHAR(64)
glossary_description
CONDITIONAL
Mastercard, Visa
Only applicable when provided by the System of Record.
Transaction Details
AcquirerReferenceNumber
VARCHAR(32)
60d14521-eef9-4246-bb64-37f53c6b84c8glossary_descriptioneJyLjgUAARUAuQ==
CONDITIONAL
24055233349083742325779
Only applicable when provided by the System of Record.
Transaction Details
TransactionType
VARCHAR(64)
glossary_description
ALWAYS
Card - Pinless
Transaction Details
AuthorizationStatus
VARCHAR(32)
glossary_description
ALWAYS
Pending, Posted
Transaction Details
Description
VARCHAR(256)
glossary_description
ALWAYS
GOOGLE *YouTube g.co/helppay#CAUS
Transaction Details
MerchantCategoryCode
VARCHAR(6)
glossary_description
CONDITIONAL
4829
Only applicable when provided by the System of Record.
Transaction Details
MerchantName
VARCHAR(256)
glossary_description
CONDITIONAL
GOOGLE *YouTube
Only applicable when provided by the System of Record.
Transaction Details
POSEntryMode
VARCHAR(32)
glossary_description
CONDITIONAL
05
Only applicable when provided by the System of Record.
Dispute Details
HasChargebackRights
BOOLEAN
glossary_description
CONDITIONAL
FALSE
Only applicable for transactions where chargeback rights can be evaluated.
Dispute Details
IsChargebackSubmitted
BOOLEAN
glossary_description
CONDITIONAL
TRUE
Only applicable for card disputes where a chargeback has been submitted.
Dispute Details
OriginalDisputeAmount
NUMBER(9,2)
3f845230-765d-4312-9e52-3e4b70cc0e1fglossary_description
ALWAYS
185.00
Available in 24.01.03.
Dispute Details
NextRecoveryDateTime
TIMESTAMP_NTZ(9)
glossary_description
CONDITIONAL
2023-09-09 21:00:00
Only applicable where a recovery deadline is present.
Accounting Details
AccountHolderTotal
NUMBER(9,2)
glossary_description
CONDITIONAL
185.00
Only applicable when accounting has occurred for the specified bucket.
Accounting Details
MerchantTotal
NUMBER(9,2)
glossary_description
CONDITIONAL
185.00
Only applicable when accounting has occurred for the specified bucket.
Accounting Details
LossTotal
NUMBER(9,2)
glossary_description
CONDITIONAL
185.00
Only applicable when accounting has occurred for the specified bucket.
Accounting Details
AppliedCreditsTotal
NUMBER(9,2)
c0661816-783b-447e-a8a6-34e54c5949c7glossary_descriptioneJyLjgUAARUAuQ==
CONDITIONAL
185.00
Value only exists when 1, or more, merchant credits applied to dispute.
Dispute Details
Decision
VARCHAR(64)
glossary_description
CONDITIONAL
Deny
Only applicable when a decision has been rendered.
Dispute Details
DenyReason
VARCHAR(64)
glossary_description
CONDITIONAL
No Error
Only applicable when a deny decision has been rendered.
Dispute Details
DenySubReason
VARCHAR(64)
glossary_description
CONDITIONAL
Out of Timeframe
Deprecated
Dispute Details
DenyDebitDate
DATE
glossary_description
CONDITIONAL
2023-12-06
Only applicable when a credit reversal is processed.
Dispute Details
InvestigationCompleteDateTime
TIMESTAMP_NTZ(9)
glossary_description
CONDITIONAL
2023-11-28 17:32:46.625
Only applicable when an investigation has been completed.
Dispute Details
CustomerFinalProcessingDateTime
TIMESTAMP_NTZ(9)
glossary_description
CONDITIONAL
2023-11-28 17:32:46.625
Only applicable when the dispute has been paid.
Dispute Details
ResolvedDateTime
TIMESTAMP_NTZ(9)
glossary_description
CONDITIONAL
2023-11-28 17:32:46.625
Only applicable when the dispute has been resolved.
Dispute Details
LastReopenDateTime
TIMESTAMP_NTZ(9)
glossary_description
CONDITIONAL
2023-11-28 17:32:46.625
Only applicable when the dispute has been denied and then reopened.
Dispute Details
DisputeStatusDateTime
TIMESTAMP_NTZ(9)
CONDITIONAL
2023-11-28 17:32:46.625
Only applicable when dispute status maintenance has been performed.
Dispute Details
IsAutoDenyLetterSuppressed
BOOLEAN
CONDITIONAL
TRUE
Only applicable when a user has suppressed a denial letter.
Dispute Details
IsAutoPaidLetterSuppressed
BOOLEAN
CONDITIONAL
TRUE
Only applicable when a user has suppressed a paid letter.
Dispute Details
IsAutoPCLetterSuppressed
BOOLEAN
CONDITIONAL
TRUE
Only applicable when a user has suppressed a provisional credit letter.
Dispute Details
IsReopened
BOOLEAN
CONDITIONAL
TRUE
Only applicable when the dispute has been denied and then reopened.
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)
glossary_description
ALWAYS
2023-09-09 21:00:00
Metadata
SaveDateTime
TIMESTAMP_NTZ(9)
ALWAYS
2023-09-09 21:00:00
Metadata
EventDateTime
TIMESTAMP_NTZ(9)
glossary_description
ALWAYS
2023-09-09 21:00:00
Metadata
EventIdentifier
VARCHAR(64)
glossary_description
ALWAYS
70b1c86d-d06f-4c93-bab2-0e938a4ef768
Metadata
EventItemId
VARCHAR(64)
glossary_description
ALWAYS
qvo-stg|2302030002D
