Skip to end of banner
Go to start of banner

Merchant Collaboration View

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Name

Merchant_Collaboration

Type

View

Description

A normalized view of all merchant collaboration attempts and outcomes, based on the Recovery Action table, with additional claim and dispute attributes for filtering/analysis.

Data Category

Event Field/Column Name

Data Type

Description

Applicability

Sample Value

Notes

Key

TenantId

VARCHAR

Unique ID associated with each Quavo client.

ALWAYS

qvo-stg

Key

Tenant

VARCHAR

A tenant is a Quavo customer that uses QFD.  Each tenant is assigned a unique Tenant ID.

ALWAYS

Default

Key

ClientId

VARCHAR

A unique ID representing a single client.

ALWAYS

Default

Key

Client

VARCHAR

A client is a Quavo customer that uses QFD through a relationship with a Quavo tenant.  Each client is assigned a unique Client ID.

ALWAYS

Default

Claim Details

ClaimType

VARCHAR

See Transaction Type.

CONDITIONAL

Card-Pinless

Claim Details

ClaimCategory

VARCHAR

General categorization of the claim.

For a more precise description, see Claim Reason.

CONDITIONAL

Fraud

Claim Details

ClaimReason

VARCHAR

Identifies the specific reason associated with the claim.

CONDITIONAL

Stolen

Transaction Details

Network

VARCHAR

A network is a company that provides the communication system between a merchant and a card issuer in order to process transactions.  For more details, see Acquirer Networks.

CONDITIONAL

Mastercard, Visa

Key

ClaimId

VARCHAR

Unique ID associated with a claim.  Format: YYMMDD<Ordinal Number>"C"

Example: 2405230003C

ALWAYS

2306060014C

Key

DisputeId

VARCHAR

Unique ID associated with a disputed transaction.  Format: YYMMDD#####"D"

ALWAYS

2306060014D

Collaboration Details

CollaborationNetwork

VARCHAR

The name of the network where merchant collaboration is attempted (i.e. "Ethoca", "Verifi")

ALWAYS

Ethoca

Transaction Details

MCC

VARCHAR

Also referred to as "MCC", this 4-digit code represents the type of goods or services a business offers.

CONDITIONAL

3000

Transaction Details

Merchant

VARCHAR

The seller or provider associated with a specific transaction.  Data in this field may simply reflect Transaction Description if there is not sufficient data available to QFD.

CONDITIONAL

American Airlines

Dispute Details

ResolvedDate

Date

Datetime that a claim or dispute is set to a "Resolved" status..  Also referred to as RESOLVEDDATETIME.

CONDITIONAL

2024-07-16 18:34:03.696

Collaboration Details

Eligibility

VARCHAR

The outcome of an eligibility check with a dispute collaboration network, such as Ethoca.

ALWAYS

Eligible, Not Eligible

Collaboration Details

AttemptDate

Date

Datetime that a recovery attempt, such as a chargeback, was submitted.

CONDITIONAL

2024-07-16 18:34:03.696

Collaboration Details

ResponseStatus

VARCHAR

CONDITIONAL

Response Received

Collaboration Details

Response

VARCHAR

An acquirer/merchant response to a recovery action by the issuer.

CONDITIONAL

Collaboration Request Accepted - Full: Other - Refunded

Collaboration Details

ResponseReceivedOn

Date

Datetime that a response to a recovery attempt, such as a chargeback, is received.

CONDITIONAL

2024-07-16 18:34:03.696

Collaboration Details

ResponseTime

Number

Specifies if the time elapsed, usually in days or hours, between a recovery or collaboration attempt and the response.

CONDITIONAL

1

Hours

Collaboration Details

Outcome

VARCHAR

When a decision is made to pursue recovery, the response to that action from the acquirer/merchant is evaluated to set an outcome of "Won", "Lost", or "N/A".

CONDITIONAL

Collaboration Details

RecoveryStatus

VARCHAR

A summarized status, usually for a specific recovery cycle.  Possible values include: Not Attempted, Recovered, and Not Recovered.

CONDITIONAL

Recovered

Collaboration Details

CreditReceived

Number

The dollar amount of a posted credit.

CONDITIONAL

123.45

Collaboration Details

CreditReceivedOn

Date

A datetime value representing when a posted credit was associated with a disputed transaction.

CONDITIONAL

2024-07-16 18:34:03.696

Collaboration Details

CreditTime

Number

Specifies if the time, usually in days or hours, that it took to receive a credit, following a positive recovery/collaboration attempt response.

CONDITIONAL

1

Hours

  • No labels