Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Excerptmultiexcerpt-macro
Each 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.
hiddenfalse
nameDescription
fallbackfalse

Merchant Credit events provide all the data necessary to evaluate the effectiveness of potential credit matching logic, as well as total recoveries via merchant credits.  When a possible merchant credit is automatically matched by the system, an event is created.  When a merchant credit is identified by a user, an event is created.  When a possible merchant credit is referred to a user by the system, and the user does not identify it as a match for the disputed transaction, an event is created. 

...

...

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

Potential Credit Details

...

TransactionDate

DATE

...

...

glossary_description

...

false

CONDITIONAL

2023-08-16

Potential Credit Details

...

AUTHCODE

VARCHAR(8)

...

glossary_description

...

false

CONDITIONAL

85541091

Potential Credit Details

...

TransactionId

VARCHAR(256)

...

...

glossary_description

...

false

CONDITIONAL

000002174116543800

Potential Credit Details

...

ARN

VARCHAR(32)

...

glossary_description

...

false

CONDITIONAL

13199982166549566629334

Potential Credit Details

...

PostingDate

DATE

...

glossary_description

...

false

CONDITIONAL

2023-08-17

Potential Credit Details

...

Description

VARCHAR(256)

...

glossary_description

...

false

CONDITIONAL

http://APPLE.COM/BILL , 866-712-7753, CAUS

Potential Credit Details

...

MerchantName

VARCHAR(256)

...

glossary_description

...

false

CONDITIONAL

http://APPLE.COM/BILL , 866-712-7753, CAUS

Potential Credit Details

...

Amount

NUMBER(92)

The amount of the potential credit transaction.

ALWAYS

11.99

Potential Credit Details

...

OUTCOME

VARCHAR(16)

...

glossary_description_merchantcredit

...

false

ALWAYS

"Auto", "Manual", "No Match", "Canceled"

Potential Credit Details

...

AppliedAmount

NUMBER(92)

The amount of the credit that was applied to the dispute.

CONDITIONAL

11.99

(where applicable)

Potential Credit Details

...

Iteration

NUMBER(20)

...

glossary_description

...

false

ALWAYS

5

Potential Credit Details

...

ISCREDITEXPECTED

BOOLEAN

...

...

glossary_description

...

false

CONDITIONAL

FALSE

Potential Credit Details

...

SEARCHSTARTDATE

DATE

...

glossary_description

...

false

CONDITIONAL

2023-08-24

Potential Credit Details

...

MatchResult

VARCHAR(16)

...

glossary_description

...

false

CONDITIONAL

"Auto Match", "Review"

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