Dispute details report

This is a combined report providing a detailed listing of Chargebacks, ECP Returns and Debit Adjustments at each stage of Dispute lifecycle.

Use Cases

Identify new chargebacks received, returned to the merchant, received for recourse, or represented to the issuing bank and trigger Chargeback Management process.
Identify new ECP returns received, returned to the merchant, or represented to the depository financial institution and trigger ECP Return process.
Identify new Debit Adjustments received, returned to the merchant, or represented to the financial institution and trigger Debit Management process.

Granularity

Summary Section: For a given reporting Entity Identifier and Currency, Presentment and Settlement Currency Amounts are rolled up ( summed up ) and displayed at Dispute Type level broken down by Dispute Category.
Details Section: For a given reporting Entity Identifier and Currency, each Dispute Type is displayed, and it is broken down at the Dispute Category level.

Fields

The following table shows the summary section field details.

Summary section field details
Field name	Definition
Record Type	Dispute summary.
Transaction Division External Identifier	Transaction division identification number.
Dispute Type Code	A label given to categorize customer disputes. Valid values are: CB - Chargeback ECP - ECP Returns AJ - Debit Adjustments RR - Retrieval Requests PD - Pre-Disputes IPA - Incoming Pre-Arbitration
Category	Indicates the category of the activity represented in this record. Valid values: BEGINV - Beginning Inventory ENDIN - Ending Inventory RECD CB/Returns - Received REPR - Items Represented RTM - Returned to Merchant.
Financial Non-Financial Code	Code indicating whether the activity for this data record has financial impact to the merchant.
Count	Indicates total number of records. For the categories REPR and RTM, counts are expressed as a negative number, reflecting a reduction to the Ending Inventory numbers. For the category ADJPDE, count could be either positive or negative.
Presentment Currency Amount	The amount of this dispute at the time it was received from the issuer, expressed in the cardholder's Presentment Currency. The amount is always a debit to the merchant unless it is preceded by a dash (-) to indicate the value is a credit to the merchant.
Presentment Currency Code	The three-character abbreviation for the currency in which the cardholder transaction occurred.
Settlement Currency Amount	The amount of this chargeback at the time it was received from the issuer, expressed in the merchant's Settlement currency. The amount is always a debit to the merchant unless it is preceded by a dash (-) to indicate the value is a credit to the merchant.
Settlement Currency Code	The three-character abbreviation for the currency in which the merchant is being funded. This field is suppressed unless cross currency is selected.

The following table shows the detail section field details.

Detail section field details
Field name	Definition
Record Type	Dispute details
Transaction Division External Identifier	Transaction division identification number.
Dispute Transaction Sequence Number	Chargeback transaction identification number, assigned by J.P. Morgan.
Dispute Type Code	A label given to categorize customer disputes. Valid values: CB - Chargeback ECP - ECP Returns AJ - Debit Adjustments RR - Retrieval Requests PD - Pre-Disputes IPA - Incoming Pre-Arbitration
Category	Indicates the category of the activity represented in this record. Valid Values are: BEGINV - Beginning Inventory ENDIN - Ending Inventory RECD CB/Returns - Received REPR - Items Represented RTM - Returned to Merchant.
Issuer Dispute Presentment Currency Amount	The amount of this dispute at the time it was received from the issuer, expressed in the cardholder's Presentment Currency. The amount is always a debit to the merchant unless it is preceded by a dash (-) to indicate the value is a credit to the merchant.
Current Action Presentment Currency Amount	The monetary value of the items included in a data record expressed in the merchant presentment currency. Example: For an item with a category of REPR, this would be the amount that was represented, which may or may not agree with the Issuer Dispute amount. The amount is always a debit to the merchant unless it is preceded by a dash (-) to indicate the value is a credit to the merchant.
Presentment Currency Code	The three-character abbreviation for the currency in which the cardholder transaction occurred.
Merchant Order Number	The order number submitted by the merchant with the original sale.
Account Number	Customers credit card or depository financial institution account number in account masking format.
Consumer Name	The cardholder’s name associated with the account for this transaction.
Payment Method Code	Code that identifies the method of payment for the transaction. Sample values are VI, MC, DI etc. Also known with the Firm as method of payment or MOP.
Payment Brand Dispute Reason Code	Code used to identify the reason for the Dispute. Reason codes for all Dispute Types are populated in this field.
Payment Brand Dispute Reason Text	Description of the reason code used to identify reason for the Dispute.
ECP Reason Category Classification	ECP Return Category. Valid values are: 1 - Insufficient/uncollected funds 2 - Unauthorized entry 3 - Administrative 4 - Miscellaneous. Populated only for ECP Returns.
ECP Reason Category Classification Text	Textual description of ECP return category. Valid values are: 1 - Insufficient/uncollected funds 2 - Unauthorized entry 3 - Administrative 4 - Miscellaneous. Populated only for ECP Returns.
Transaction Date	Date when the transaction was performed in UTC time zone.
Dispute Initiate Date	Date that the chargeback was initiated by the issuing bank in UTC time zone.
Activity Date	Activity date of the transaction in UTC time zone.
Dispute Due Date	Due date for the charge back transaction in UTC time zone. Populated only for chargebacks and debit adjustments.
Dispute Usage Code	Single digit code 1, 2, 3, 5 or 9 identifying whether this is a first or second chargeback or a dispute that falls under the Visa Claims Resolution process.
Accountholder Authorization Method	Means by which the accountholder authorized the merchant to transact on the account. Populated only for ECP Returns.
Accountholder Authorization Method Text	Textual description of means by which the accountholder authorized the merchant to transact on the account. Populated only for ECP Returns.
Acquirer Reference Number	The acquirers reference number assigned to the transaction at the time of the sale/refund.
Issuer Dispute Settlement Currency Amount	The amount of this chargeback at the time it was received from the issuer, expressed in the merchant's Settlement currency. The amount is always a debit to the merchant unless it is preceded by a dash (-) to indicate the value is a credit to the merchant.
Current Action Settlement Currency Amount	The amount of this chargeback at the time it was received from the issuer, expressed in the merchant's Settlement currency. The amount is always a debit to the merchant unless it is preceded by a dash (-) to indicate the value is a credit to the merchant.
Settlement Currency Code	The three-character abbreviation for the currency in which the merchant is being funded. This field is suppressed unless cross currency is selected.
Authorization Date	Date of the original authorization in UTC time zone.
Action Code	Codifies the payment processing activity, the financial institution will do on behalf of the merchant for the requested transaction. For example: A= Authorize, B= Conditional Deposit, D= Deposit, R=Refund etc. Populated only for Debit Adjustments.
Cardholder Debit Credit Indicator	Represents the card type of the cardholder. Sample values are: D -Debit Cardholder C - Credit Cardholder. Populated only for Debit Adjustments.
Adjustment Number	Debit network assigned reference number for an adjustment.
Ticket Number	Identifies a unique paper or electronic receipt identifying travel entitlements for an individual associated to a travel purchase transaction. Tickets may contain a single travel segment (e.g., one-way trip), or separate segments (e.g., round trip, stopover)
Status Flag Code	Indicates if a dispute activity is related to a Reversed item. Sample values are R or blank. Populated for Chargebacks, ECP Returns, Debit Adjustments and Pre-Disputes.
Digital Token Method Code	Indicates whether the dispute is related to a Digital Payment Token.
Potential Bundled Chargebacks Indicator	Indicates multiple items may be included in this line item=Yes. May be space-filled. Populated only for Chargebacks.

Tip

For Dispute Details Report generated at any non-daily frequency (weekly, monthly, or ad hoc ) , BEGINV ( Begin Inventory ) records won’t be populated for Dispute Summary.

Count of BEGINV records can be calculated by deducting total number of Action Records from total number of ENDINV (End Inventory) at each TD and Currency Pair level. Dispute Details generated at daily frequency (scheduled or ad hoc) will have BEGINV records.

Sample report configuration

The following request code block shows how to configure an dispute details report for entityType = CO/BU/TD.

Json

{
    "entityType": "CO",
    "entityIds": [
        "1234567"
    ],
    "reportSections": [
        {
            "sectionReportTypeName": "Dispute Details v2",
            "sectionReportTypeId": "3017",
            "sectionSelectedFields": [
                {
                    "alias": "Record Type",
                    "constantValueText": "DisputeSummary"
                },
                {
                    "reportAttributeName": "Transaction Division External Identifier"
                }, 

               {
                    "alias": "Dispute Type Code",
                    "reportAttributeName": "Post Deposit Event Dispute Type Code"
                },
                
               {
                    "alias": "Category",
                    "reportAttributeName": "Dispute Category Code"
                },
                {
                    "reportAttributeName": "Financial Non-Financial Code"
                },
                {
                    "alias": "Count",
                    "reportAttributeName": "Record Count",
                    "aggregateOperationText": "sum"
                },
                
                {
                    "alias": "Presentment Currency Amount",
                    "reportAttributeName": "Post Deposit Event Action Presentment Currency Amount",
                    "aggregateOperationText": "sum"
                },
                {
                    "reportAttributeName": "Presentment Currency Code"
                },
                {
                    "alias": "Settlement Currency Amount",
                    "reportAttributeName": "Post Deposit Event Action Settlement Currency Amount",
                    "aggregateOperationText": "sum"
                },
                {
                    "reportAttributeName": "Settlement Currency Code"
                }
               
            ],
            "sectionFilterAttributeList": [
                {
                    "reportAttributeName": "Post Deposit Event Dispute Type Code",
                    "filterAttributeCode": "IN (\"CB\",\"ECP\",\"AJ\")"                },
                {
                    "reportAttributeName": "Dispute Category Code",
                    "filterAttributeCode": "IN (\"BEGINV\",\"RECD\",\"REPR\",\"PARREP\",\"OPAACCEPT\",\"RECRS\",\"RTM\",\"PARRTM\",\"OPAREQ\",\"OPADENY\",\"ADJPDE\",\"ADJPAR\",\"ENDINV\")"
                }
            ],
            "sectionSortOrderList": [
                {
                    "reportAttributeName": "Transaction Division External Identifier",
                    "sortOrderCode": "asc"
                },
                {
                    "reportAttributeName": "Dispute Category Code",
                    "sortOrderCode": "asc"
                }
            ]
        },
        {
            "sectionReportTypeName": "Dispute Details v2",
            "sectionReportTypeId": "3017",
            "sectionSelectedFields": [
                {
                    "alias": "Record Type",
                    "constantValueText": "DisputeDetails"
                },
                {
                    "reportAttributeName": "Transaction Division External Identifier"
                },
                { 
                    "reportAttributeName": "Dispute Transaction Sequence Number"
                },

        {
                    "alias": "Dispute Type Code",
                    "reportAttributeName": "Post Deposit Event Dispute Type Code"
        },

                {
                    "alias": "Category",
                    "reportAttributeName": "Dispute Category Code"
                },
                {
                    "reportAttributeName": "Issuer Dispute Presentment Currency Amount"
                },
                
                {
                    "alias": "Current Action Presentment Currency Amount",
                    "reportAttributeName": "Post Deposit Event Action Presentment Currency Amount"
                },
                {
                    "reportAttributeName": "Presentment Currency Code"
                },
               
                {
                    "reportAttributeName": "Merchant Order Number"
                },
                {
                    "reportAttributeName": "Account Number"
                },
                {
                    "reportAttributeName": "Consumer Name"
                },
                {
                    "reportAttributeName": "Payment Method Code"
                },
                {
                    "reportAttributeName": "Payment Brand Dispute Reason Code"
                },
                {
                    "reportAttributeName": "Payment Brand Dispute Reason Text"
                },
                {
                    "reportAttributeName": "ECP Reason Category Classification"
                },
                {
                    "reportAttributeName": "ECP Reason Category Classification Text"
                },
                {
                    "reportAttributeName": "Transaction Date"
                },
                {
                    "reportAttributeName": "Dispute Initiate Date"
                },
                {
                    "alias": "Activity Date",
                    "reportAttributeName": "Dispute Activity Date"
                },
                {
                    "reportAttributeName": "Dispute Due Date"
                },
             
                {
                    "reportAttributeName": "Dispute Usage Code"
                },
                {
                    "reportAttributeName": "Accountholder Authorization Method"
                },
                {
                    "reportAttributeName": "Accountholder Authorization Method Text"
                },



                {
                    "reportAttributeName": "Acquirer Reference Number"
                },
             
                {
                    "reportAttributeName": "Issuer Dispute Settlement Currency Amount"
                },
                {
                    "alias": "Current Action Settlement Currency Amount",
                    "reportAttributeName": "Post Deposit Event Action Settlement Currency Amount"
                },
                {
                    "reportAttributeName": "Settlement Currency Code"
                },
                {
                    "reportAttributeName": "Authorization Date"
                },
                {
                    "reportAttributeName": "Action Code"
                },
                {
                     "reportAttributeName": "Cardholder Debit Credit Indicator"
                },
                 {
                     "reportAttributeName": "Adjustment Number"
                },
                {
                    "reportAttributeName": "Ticket Number"
                },
                {
                    "reportAttributeName": "Status Flag Code"
                },
                {
                    "reportAttributeName": "Digital Token Method Code"
                },
                {
                    "reportAttributeName": "Potential Bundled Chargebacks Indicator"
                }
                 
            ],
            "sectionFilterAttributeList": [
                {
                    "reportAttributeName": "Post Deposit Event Dispute Type Code",
                    "filterAttributeCode": "IN (\"CB\",\"ECP\",\"AJ\")"

                },
                {
                    "reportAttributeName": "Dispute Category Code",
                    "filterAttributeCode": "IN (\"RECD\",\"REPR\",\"PARREP\",\"OPAACCEPT\",\"RECRS\",\"RTM\",\"PARRTM\",\"OPAREQ\",\"OPADENY\",\"ADJPDE\",\"ENDINV\")"
                }
            ],
            "sectionSortOrderList": [
                {
                    "reportAttributeName": "Transaction Division External Identifier",
                    "sortOrderCode": "asc"
                },
                {
                    "reportAttributeName": "Dispute Category Code",
                    "sortOrderCode": "asc"
                },
                {
                    "reportAttributeName": "Dispute Transaction Sequence Number",
                    "sortOrderCode": "asc"
                }
            ]
        }
    ],
    "fileDelimiter": ",",
    "reportConfigurationName": "Dispute Details Report",
    "reportFileName": "Dispute Details.<Processing Entity ID>.<frequency>.<From Date YYYY-MM-DD>.<To Date YYYY-MM-DD>",
    "reportHeader": "EntityId=<Processing Entity ID>,ReportTypeName=<Report Type>,Frequency=<frequency>,FromDate=<From Date YYYY-MM-DD>,ToDate=<To Date YYYY-MM-DD>,GenerationDate=<Generation Date YYYY-MM-DD>,GenerationTime=<Generation Time HH:MM:SS>",
    "fileHeader": "BEGIN,EntityId=<Processing Entity ID>,Frequency=<frequency>",
    "fileTrailer": "END,EntityId=<Processing Entity ID>,Frequency=<frequency>",
    "csvColumnNameDisplayIndicator": true,
    "frequencyConfig": {
        "scheduleFrequency": "adhoc",
        "reportingPeriodStartTimestamp": "2024-06-03 00:00:00",
        "reportingPeriodEndTimestamp": "2024-06-04 00:00:00"
    }
}

The following request code block shows how to configure an dispute details report for entityType = PE.

Json

{
    "entityType": "PE",
    "entityIds": [
        "1234567"
    ],
    "reportSections": [
        {
            "sectionReportTypeName": "Dispute Details v2",
            "sectionReportTypeId": "3017",
            "sectionSelectedFields": [
                {
                    "alias": "Record Type",
                    "constantValueText": "DisputeSummary"
                },
                {
                    "reportAttributeName": "Transaction Processing Entity Identifier"
                }, 

               {
                    "alias": "Dispute Type Code",
                    "reportAttributeName": "Post Deposit Event Dispute Type Code"
                },
               {
                    "alias": "Category",
                    "reportAttributeName": "Dispute Category Code"
                },
                {
                    "reportAttributeName": "Financial Non-Financial Code"
                },
                {
                    "alias": "Count",
                    "reportAttributeName": "Record Count",
                    "aggregateOperationText": "sum"
                },
                
                {
                    "alias": "Presentment Currency Amount",
                    "reportAttributeName": "Post Deposit Event Action Presentment Currency Amount",
                    "aggregateOperationText": "sum"
                },
                {
                    "reportAttributeName": "Presentment Currency Code"
                },
                {
                    "alias": "Settlement Currency Amount",
                    "reportAttributeName": "Post Deposit Event Action Settlement Currency Amount",
                    "aggregateOperationText": "sum"
                },
                {
                    "reportAttributeName": "Settlement Currency Code"
                }
               
                
            ],
            "sectionFilterAttributeList": [
                {
                    "reportAttributeName": "Post Deposit Event Dispute Type Code",
                    "filterAttributeCode": "IN (\"CB\",\"ECP\",\"AJ\")"                },
                {
                    "reportAttributeName": "Dispute Category Code",
                    "filterAttributeCode": "IN (\"BEGINV\",\"RECD\",\"REPR\",\"PARREP\",\"OPAACCEPT\",\"RECRS\",\"RTM\",\"PARRTM\",\"OPAREQ\",\"OPADENY\",\"ADJPDE\",\"ADJPAR\",\"ENDINV\")"
                }
            ],
            "sectionSortOrderList": [
                {
                    "reportAttributeName": "Transaction Processing Entity Identifier",
                    "sortOrderCode": "asc"
                },
                {
                    "reportAttributeName": "Dispute Category Code",
                    "sortOrderCode": "asc"
                }
            ]
        },
        {
            "sectionReportTypeName": "Dispute Details v2",
            "sectionReportTypeId": "3017",
            "sectionSelectedFields": [
                {
                    "alias": "Record Type",
                    "constantValueText": "DisputeDetails"
                },
                {
                    "reportAttributeName": "Transaction Processing Entity Identifier"
                },
                { 
                    "reportAttributeName": "Dispute Transaction Sequence Number"
                },

        {
                    "alias": "Dispute Type Code",
                    "reportAttributeName": "Post Deposit Event Dispute Type Code"
        },

                {
                    "alias": "Category",
                    "reportAttributeName": "Dispute Category Code"
                },
                {
                    "reportAttributeName": "Issuer Dispute Presentment Currency Amount"
                },
                
                {
                    "alias": "Current Action Presentment Currency Amount",
                    "reportAttributeName": "Post Deposit Event Action Presentment Currency Amount"
                },
                {
                    "reportAttributeName": "Presentment Currency Code"
                },
               
                {
                    "reportAttributeName": "Merchant Order Number"
                },
                {
                    "reportAttributeName": "Account Number"
                },
                {
                    "reportAttributeName": "Consumer Name"
                },
                {
                    "reportAttributeName": "Payment Method Code"
                },
                {
                    "reportAttributeName": "Payment Brand Dispute Reason Code"
                },
                {
                    "reportAttributeName": "Payment Brand Dispute Reason Text"
                },
                {
                    "reportAttributeName": "ECP Reason Category Classification"
                },
                {
                    "reportAttributeName": "ECP Reason Category Classification Text"
                },
                {
                    "reportAttributeName": "Transaction Date"
                },
                {
                    "reportAttributeName": "Dispute Initiate Date"
                },
                {
                    "alias": "Activity Date",
                    "reportAttributeName": "Dispute Activity Date"
                },
                {
                    "reportAttributeName": "Dispute Due Date"
                },
             
                {
                    "reportAttributeName": "Dispute Usage Code"
                },
                {
                    "reportAttributeName": "Accountholder Authorization Method"
                },
                {
                    "reportAttributeName": "Accountholder Authorization Method Text"
                },



                {
                    "reportAttributeName": "Acquirer Reference Number"
                },
             
                {
                    "reportAttributeName": "Issuer Dispute Settlement Currency Amount"
                },
                {
                    "alias": "Current Action Settlement Currency Amount",
                    "reportAttributeName": "Post Deposit Event Action Settlement Currency Amount"
                },
                {
                    "reportAttributeName": "Settlement Currency Code"
                },
                {
                    "reportAttributeName": "Authorization Date"
                },
                {
                    "reportAttributeName": "Action Code"
                },
                {
                     "reportAttributeName": "Cardholder Debit Credit Indicator"
                },
                 {
                     "reportAttributeName": "Adjustment Number"
                },
                {
                    "reportAttributeName": "Ticket Number"
                },
                {
                    "reportAttributeName": "Status Flag Code"
                },
                {
                    "reportAttributeName": "Digital Token Method Code"
                },
                {
                    "reportAttributeName": "Potential Bundled Chargebacks Indicator"
                }
               
               
            ],
            "sectionFilterAttributeList": [
                {
                    "reportAttributeName": "Post Deposit Event Dispute Type Code",
                    "filterAttributeCode": "IN (\"CB\",\"ECP\",\"AJ\")"

                },
                {
                    "reportAttributeName": "Dispute Category Code",
                    "filterAttributeCode": "IN (\"RECD\",\"REPR\",\"PARREP\",\"OPAACCEPT\",\"RECRS\",\"RTM\",\"PARRTM\",\"OPAREQ\",\"OPADENY\",\"ADJPDE\",\"ENDINV\")"
                }
            ],
            "sectionSortOrderList": [
                {
                    "reportAttributeName": "Transaction Processing Entity Identifier",
                    "sortOrderCode": "asc"
                },
                {
                    "reportAttributeName": "Dispute Category Code",
                    "sortOrderCode": "asc"
                },
                {
                    "reportAttributeName": "Dispute Transaction Sequence Number",
                    "sortOrderCode": "asc"
                }
            ]
        }
    ],
    "fileDelimiter": ",",
    "reportConfigurationName": "Dispute Details Report",
    "reportFileName": "Dispute Details.<Processing Entity ID>.<frequency>.<From Date YYYY-MM-DD>.<To Date YYYY-MM-DD>",
    "reportHeader": "EntityId=<Processing Entity ID>,ReportTypeName=<Report Type>,Frequency=<frequency>,FromDate=<From Date YYYY-MM-DD>,ToDate=<To Date YYYY-MM-DD>,GenerationDate=<Generation Date YYYY-MM-DD>,GenerationTime=<Generation Time HH:MM:SS>",
    "fileHeader": "BEGIN,EntityId=<Processing Entity ID>,Frequency=<frequency>",
    "fileTrailer": "END,EntityId=<Processing Entity ID>,Frequency=<frequency>",
    "csvColumnNameDisplayIndicator": true,
    "frequencyConfig": {
        "scheduleFrequency": "adhoc",
        "reportingPeriodStartTimestamp": "2024-06-03 00:00:00",
        "reportingPeriodEndTimestamp": "2024-06-04 00:00:00"
    }
}

Download sample report

Download the sample Dispute details report.

Preset reports