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
Transaction Details
AuthCode
VARCHAR(32)
de23ee9f-1394-4295-aa2b-12a094417afaeJyLjgUAARUAuQ==glossary_descriptionfalse
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
glossary_description
ALWAYS
2023-11-11
Transaction Details
PostingDate
DATE
glossary_description
ALWAYS
2023-11-12
Transaction Details
AcquirerNetwork
VARCHAR(64)
glossary_description
CONDITIONAL
VISA
Transaction Details
AcquirerReferenceNumber
VARCHAR(32)
60d14521-eef9-4246-bb64-37f53c6b84c8glossary_descriptioneJyLjgUAARUAuQ==
CONDITIONAL
24055233349083742325779
Transaction Details
TransactionType
VARCHAR(64)
glossary_description
ALWAYS
Card - Pinless
Transaction Details
AuthorizationStatus
VARCHAR(32)
glossary_description
ALWAYS
Posted
Transaction Details
Description
VARCHAR(256)
glossary_description
ALWAYS
GOOGLE *YouTube g.co/helppay#CAUS
Transaction Details
MerchantCategoryCode
VARCHAR(6)
glossary_description
CONDITIONAL
4829
Transaction Details
MerchantName
VARCHAR(256)
glossary_description
CONDITIONAL
GOOGLE *YouTube
Transaction Details
POSEntryMode
VARCHAR(32)
glossary_description
CONDITIONAL
05
Dispute Details
HasChargebackRights
BOOLEAN
glossary_description
CONDITIONAL
FALSE
Dispute Details
IsChargebackSubmitted
BOOLEAN
glossary_description
CONDITIONAL
FALSE
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
Accounting Details
AccountHolderTotal
NUMBER(9,2)
glossary_description
CONDITIONAL
185.00
Accounting Details
MerchantTotal
NUMBER(9,2)
glossary_description
CONDITIONAL
185.00
Accounting Details
LossTotal
NUMBER(9,2)
glossary_description
CONDITIONAL
185.00
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
Dispute Details
DenyReason
VARCHAR(64)
glossary_description
CONDITIONAL
No Error
Dispute Details
DenySubReason
VARCHAR(64)
glossary_description
CONDITIONAL
Out of Timeframe
Dispute Details
DenyDebitDate
DATE
glossary_description
CONDITIONAL
2023-12-06
Dispute Details
InvestigationCompleteDateTime
TIMESTAMP_NTZ(9)
glossary_description
CONDITIONAL
2023-11-28 17:32:46.625
Dispute Details
CustomerFinalProcessingDateTime
TIMESTAMP_NTZ(9)
glossary_description
CONDITIONAL
2023-11-28 17:32:46.625
Dispute Details
ResolvedDateTime
TIMESTAMP_NTZ(9)
glossary_description
CONDITIONAL
2023-11-28 17:32:46.625
Dispute Details
LastReopenDateTime
TIMESTAMP_NTZ(9)
glossary_description
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)
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
