Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Excerpt
nameEach time a change is saved to a claim-level property in QFD, an event is created.  This event includes all important claim details and will be useful for referencing from most other events to understand the full picture of the claim.

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.

...

Multiexcerpt macro
hiddenfalse
nameFields
fallbackfalse

Data Category

Event Field/Column Name

Data Type

Description

Applicability

Sample Value

Notes

Key

TenantId

VARCHAR(32)

...

glossary_description

...

false

ALWAYS

qvo-stg

Key

ClientId

VARCHAR(64)

...

glossary_description

...

...

false

ALWAYS

Default

Key

ClaimId

VARCHAR(32)

...

glossary_description

...

...

false

ALWAYS

2306060014C

Key

DisputeId

VARCHAR(32)

...

glossary_description

...

...

false

ALWAYS

2306050001D

Dispute Details

Status

VARCHAR(32)

...

glossary_description

...

...

false

ALWAYS

Open-ProcessLiability

Dispute Details

StatusChangeDateTime

TIMESTAMP_NTZ(9)

...

glossary_description

...

false

ALWAYS

2023-09-09 21:00:00

Dispute Details

DisputeAmount

NUMBER(9,2)

...

glossary_description

...

...

false

ALWAYS

185.00

Transaction Details

TransactionId

VARCHAR(128)

...

glossary_description

...

...

false

ALWAYS

ABC123456789

Transaction Details

Amount

NUMBER(9,2)

Amount of the transaction.

ALWAYS

185.00

Transaction Details

AmountPosted

NUMBER(9,2)

...

glossary_description

...

false

CONDITIONAL

185.00

Transaction Details

AuthCode

VARCHAR(32)

...

de23ee9f-1394-4295-aa2b-12a094417afa

...

eJyLjgUAARUAuQ==

...

glossary_description

...

false

...

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

...

false

ALWAYS

2023-11-11

Transaction Details

PostingDate

DATE

...

glossary_description

...

...

false

ALWAYS

2023-11-12

Transaction Details

AcquirerNetwork

VARCHAR(64)

...

glossary_description

...

false

CONDITIONAL

VISA

Transaction Details

AcquirerReferenceNumber

VARCHAR(32)

CONDITIONAL

Transaction Details

TransactionType

VARCHAR(64)

...

...

glossary_description

...

...

false

ALWAYS

Card - Pinless

Transaction Details

AuthorizationStatus

VARCHAR(32)

...

glossary_description

...

...

false

ALWAYS

Posted

Transaction Details

Description

VARCHAR(256)

...

glossary_description

...

...

false

ALWAYS

GOOGLE *YouTube        g.co/helppay#CAUS

Transaction Details

MerchantCategoryCode

VARCHAR(6)

...

glossary_description

...

...

false

CONDITIONAL

4829

Transaction Details

MerchantName

VARCHAR(256)

...

glossary_description

...

false

CONDITIONAL

GOOGLE *YouTube

Transaction Details

POSEntryMode

VARCHAR(32)

...

...

glossary_description

...

...

false

CONDITIONAL

05

Dispute Details

HasChargebackRights

BOOLEAN

...

glossary_description

...

...

false

CONDITIONAL

FALSE

Dispute Details

IsChargebackSubmitted

BOOLEAN

...

glossary_description

...

false

CONDITIONAL

FALSE

Dispute Details

OriginalDisputeAmount

NUMBER(9,2)

...

3f845230-765d-4312-9e52-3e4b70cc0e1f

...

glossary_description

...

...

false

ALWAYS

185.00

Available in 24.01.03.

Dispute Details

NextRecoveryDateTime

TIMESTAMP_NTZ(9)

...

glossary_description

...

...

false

CONDITIONAL

2023-09-09 21:00:00

Accounting Details

AccountHolderTotal

NUMBER(9,2)

...

glossary_description

...

...

false

CONDITIONAL

185.00

Accounting Details

MerchantTotal

NUMBER(9,2)

...

glossary_description

...

...

false

CONDITIONAL

185.00

Accounting Details

LossTotal

NUMBER(9,2)

...

glossary_description

...

...

false

CONDITIONAL

185.00

Dispute Details

Decision

VARCHAR(64)

...

glossary_description

...

...

false

CONDITIONAL

Deny

Dispute Details

DenyReason

VARCHAR(64)

...

glossary_description

...

false

CONDITIONAL

No Error

Dispute Details

DenySubReason

VARCHAR(64)

...

...

glossary_description

...

...

false

CONDITIONAL

Out of Timeframe

Dispute Details

DenyDebitDate

DATE

...

glossary_description

...

false

CONDITIONAL

2023-12-06

Dispute Details

InvestigationCompleteDateTime

TIMESTAMP_NTZ(9)

...

glossary_description

...

...

false

CONDITIONAL

2023-11-28 17:32:46.625

Dispute Details

CustomerFinalProcessingDateTime

TIMESTAMP_NTZ(9)

...

glossary_description

...

...

false

CONDITIONAL

2023-11-28 17:32:46.625

Dispute Details

ResolvedDateTime

TIMESTAMP_NTZ(9)

...

glossary_description

...

false

CONDITIONAL

2023-11-28 17:32:46.625

Dispute Details

LastReopenDateTime

TIMESTAMP_NTZ(9)

...

glossary_description

...

...

false

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)

...

glossary_description

...

false

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

...

...

false

ALWAYS

2023-09-09 21:00:00

Metadata

EventIdentifier

VARCHAR(64)

...

glossary_description

...

...

false

ALWAYS

70b1c86d-d06f-4c93-bab2-0e938a4ef768

Metadata

EventItemId

VARCHAR(64)

...

glossary_description

...

false

ALWAYS

qvo-stg|2302030002D