SELECT
count(*) as "Count",
sum(d.disputeamount) as "Total Dispute Amount",
sum(d.losstotal * -1) as "Total Loss Amount",
sum(d.merchanttotal * -1) as "Total Recovered Amount"
FROM
dispute AS d
JOIN
claim AS c ON c.tenantid = d.tenantid AND c.claimid = d.claimid
WHERE
d.resolveddatetime =:daterange
AND d.status in ('Resolved-Paid', 'Resolved-Denied') -- exclude open disputes and temporary authorizations that posted as these will have a new dispute record
General
Content
Integrations