Disputes
A dispute is a financial transaction reversal that occurs when a customer disputes a charge made to their credit or debit card.
Disputes are typically initiated by the cardholder, and they serve as a consumer protection mechanism to resolve issues with unauthorised or fraudulent transactions, billing errors, or cases of dissatisfaction with a product or service.
This enables us to apply a credit to an account for a transaction which has been disputed, including applying credits for any posted interest and fees.
Dispute Fields
| Column | Comment | DDL |
|---|---|---|
| id | Unique identifier for the dispute | int(11) NOT NULL AUTO_INCREMENT |
| disputed_transaction_id | ID of the disputed transaction | int(11) NOT NULL |
| disputed_transaction_reference | External reference for the disputed transaction | char(36) DEFAULT NULL |
| account_id | ID of the account | int(11) NOT NULL |
| statement_id | ID of the statement | int(11) NOT NULL |
| product_id | ID of the product | int(11) NOT NULL |
| product_apr_id | ID of the product APR | int(11) NOT NULL |
| rate | APR to apply | decimal(8,4) NOT NULL |
| customer_id | ID of the customer | int(11) NOT NULL |
| institution_id | ID of the client | smallint(6) NOT NULL |
| date_raised | date the dispute was raised | date NOT NULL |
| date_processed | date the dispute was processed or expired | date |
| date_resolved | date the dispute was resolved | date |
| status | status of the dispute | char(1) NOT NULL |
| original_transaction_amount | original transaction amount | decimal(15,2) NOT NULL DEFAULT 0.00 |
| aggregated_amount_chargedback | total amount charged back | decimal(15,2) DEFAULT 0.00 |
| calculated_interest_forgiven | interest forgiven | decimal(15,2) DEFAULT 0.00 |
| posted_interest_reversed | interest reversed | decimal(15,2) DEFAULT 0.00 |
| description | narrative by VE | varchar(1000) NOT NULL |
Updated over 1 year ago