Representments View
Name | Representments |
---|---|
Type | View |
Description | A normalized view of all representments received, 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 |
---|---|---|---|---|---|---|
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 | Â | |
Chargeback Details | ChargebackDate | DATE | ALWAYS | 2023-09-09 | Â | |
Chargeback Details | ChargebackAmount | NUMBER | Amount of the chargeback. | ALWAYS | 123.45 | Â |
Representment Details | RepresentmentDate | DATE | Date that the representment was received. | ALWAYS | 2023-09-09 | Â |
Representment Details | RepresentmentAmount | NUMBER | Amount of the representment. | ALWAYS | 123.45 | Â |