Chargebacks View

Name	Chargebacks
Type	View
Description	A normalized view of all attempted chargebacks, based on the Recovery Action table, including various claim and dispute attributes for filtering/analysis.

Data Category	Event Field/Column Name	Data Type	Description	Applicability	Sample Value	Notes

Data Category	Event Field/Column Name	Data Type	Description	Applicability	Sample Value
Key	TenantId	VARCHAR		ALWAYS	qvo-stg
Key	Tenant	VARCHAR		ALWAYS	Default
Key	ClientId	VARCHAR		ALWAYS	Default
Key	Client	VARCHAR		ALWAYS	Default
Claim Details	ClaimType	VARCHAR		CONDITIONAL	Card-Pinless
Claim Details	ClaimCategory	VARCHAR		CONDITIONAL	Fraud
Claim Details	ClaimReason	VARCHAR		CONDITIONAL	Stolen
Transaction Details	Network	VARCHAR		CONDITIONAL	Mastercard, Visa
Key	ClaimId	VARCHAR		ALWAYS	2306060014C
Key	DisputeId	VARCHAR		ALWAYS	2306060014D
Claim Details	CustomerContactDate	DATE		CONDITIONAL	2023-09-09
Dispute Details	DisputeStatus	VARCHAR		ALWAYS	Pending-Response
Dispute Details	DisputeAmount	NUMBER		ALWAYS	123.45
Recovery Details	ChargebackDate	DATE		ALWAYS	2023-09-09
Recovery Details	ChargebackAmount	NUMBER	Amount of the chargeback.	ALWAYS	123.45
Recovery Details	ResponseDate	DATE		CONDITIONAL	2023-09-09
Recovery Details	Response	VARCHAR		CONDITIONAL	Ruled in Issuer Favor
Recovery Details	ResponseAmount	NUMBER	Amount of the acquirer action or association ruling.	CONDITIONAL	123.45
Recovery Details	Outcome	VARCHAR		ALWAYS	Recovered, No Recovery, Not Attempted
Recovery Details	Status	VARCHAR		ALWAYS	Not Attempted, Pending, Completed

Change Log

Date	Change Summary

Date	Change Summary
12/10/2024	New