# JPMC-PDP Documentation from https://developer.payments.jpmorgan.com # Exception details report This report provides a summary of successful and unsuccessful transactions and details of unsuccessful transactions (Declined/Rejected/Cancelled/On-Hold). **Exception details report information** | Report type | Supported entity types | Supported file formats | | --- | --- | --- | | Transaction details | - PE - Processing Entity - TD - Transaction Division - BU - Business Unit - FTI - Fund Transfer Instruction - CO - Company - RG - Reporting Group - PI - Platform Identifier | - Comma Seperated Values (CSV) - Gzip or GNU Zip (GZ) - Portable Document Format (PDF) - MS Excel Workbook (.xlsx) | ## Use cases - View transactions summary for a submission date, with classification of number of transactions declined, rejected, cancelled, on-hold or successful, and total transaction amount in each category. - View exception details and rejection reason for unsuccessful transactions. ## Granularity - Summary section: Combination of Presentment Currency Code, Settlement Currency Code, Merchant Presenter Identifier, Submission Identifier, and Submission Date. - Details section: Merchant Order Number ## Fields The following table shows the summary section field details. **Summary section field details** | Field name | Definition | | --- | --- | | Record Type | Defines the section of the report. For summary section, record type value is Transaction Summary. | | Presentment Currency Code | The three-character abbreviation for the currency in which the cardholder transaction occurred. | | Settlement Currency Code | The three-character abbreviation for the currency in which the merchant is being funded. | | Merchant Presenter Identifier | Merchant Presenter Identifier. | | Merchant Presenter Short Name | Merchant Presenter Short Name. | | Submission Identifier | Unique identification number for the submission. | | Submission Status | The status of the submission in which this transaction was included. | | Submission Date | The date on which the submission was fully received at J.P. Morgan. | | Transaction Count | Count of transactions for the summarized record. | | Authorization Count | Count of authorizations for the summarized record. | | Declined Deposit Count | Count of deposits declined for the summarized record. | | Declined Deposit Amount | Total Deposit Amount declined for the summarized record. | | Rejected Transaction Count | Count of rejected transactions for the summarized record. | | Rejected Transaction Amount | Total transaction amount rejected for the summarized record. | | Cancelled/On-Hold Deposit Count | Count of deposits cancelled on-hold for the summarized record. | | Cancelled/On-Hold Net Deposit Amount | Total deposit amount cancelled/on-hold for the summarized record. | | Successful Deposit Count | Count of successful transactions for the summarized record. | | Successful Net Deposit Amount | Total successful transaction amount for the summarized record. | The following table shows the detail section field details. **Detail section field details** | Field name | Definition | | --- | --- | | Record Type | Defines the section of the report. For Details section, record type value is Exception Details. | | Transaction Division External Identifier | Transaction division external identifier. | | Presentment Currency Code | The three-character abbreviation for the currency in which the cardholder transaction occurred. | | Settlement Currency Code | The three-character abbreviation for the currency in which the merchant is being funded. | | Submission Identifier | Unique identification number for the submission. | | Record Number | Record number is the sequential number of a transaction within a submission file. | | Merchant Order Number | The order number submitted by the merchant with the original sale. | | Exception Description | The type of exception being reported in this data record. | | Amount | Transaction amount. | | Payment Method Code | Code that identifies the (MOP) method of payment for the transaction. | | Account Number | Cardholders account number. | | Credit Card Expiration Year Month Number | The credit card account expiration date (month and year) as submitted by the merchant with this transaction. | | Merchant Action Code Text | Type of transaction action conducted. Valid values are: - AUTHORIZATIONS - DEPOSITS | | Authorization Date | The date and time in UTC time zone on which the authorization was performed for the transaction. | | Authorization Code | the six-character code related to a positive response from the endpoint. | | Auth Response Code | Authorization response code indicating Approval, Decline or Rejection. | | Country Of Issuance | Standard alpha ISO country code that identifies the card's issuing country. May be blank for transactions on unsupported methods of payment. | | Merchant Category Code | Indicator used to classify a merchant's product or service. | | Reject Code | Indicator that classifies the reason for rejecting a transaction. | | Card Usage Type | Codifies whether the transaction is a Signature Debit transaction (1), PIN Debit transaction (2), or a Credit Card transaction (3). | | Entity Identifier | Associated CO, BU, or TD identification number. | | Entity Type Code | Level at which the reported event occurred. - BU: Business Unit - CO: Company - TD: Transaction Division | | Platform Identifier | Identifies the platform used to facilitate the transaction request. | | Platform Name | The name of the platform used to facilitate the transaction request. | ## Sample report configurations The following samples help you get an idea of how to configure exception reports. ### CO/BU/TD The following request code block shows how to configure an exception report for `entityType` = CO/BU/TD. ```json { "entityType": "CO", "entityIds": [ "1234567" ], "reportSections": [ { "sectionReportTypeName": "Transaction Details", "sectionReportTypeId": "3001", "sectionSelectedFields": [ { "alias": "Record Type", "constantValueText": "Transaction Summary" }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "Merchant Presenter Identifier" }, { "reportAttributeName": "Merchant Presenter Short Name" }, { "reportAttributeName": "Submission Identifier" }, { "reportAttributeName": "Submission Status" }, { "reportAttributeName": "Submission Date" }, { "alias": "Transaction Count", "reportAttributeName": "Merchant Order Number", "aggregateOperationText": "count" }, { "reportAttributeName": "Merchant Order Number", "alias": "Authorization Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Merchant Action Code Text", "aggregateConditionText": "= 'AUTHORIZATIONS'" }, { "aggregateConditionAttributeName": "Submission File Status", "aggregateConditionText": "= 'RD'" } ] }, { "reportAttributeName": "Merchant Order Number", "alias": "Declined Deposit Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Declined Deposit'" } ] }, { "reportAttributeName": "Presentment Amount", "alias": "Declined Deposit Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Declined Deposit'" } ] }, { "reportAttributeName": "Merchant Order Number", "alias": "Rejected Transaction Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Rejected Transaction'" } ] }, { "reportAttributeName": "Presentment Amount", "alias": "Rejected Transaction Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Rejected Transaction'" } ] }, { "reportAttributeName": "Merchant Order Number", "alias": "Cancelled/On-Hold Deposit Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Cancels/OnHold'" } ] }, { "reportAttributeName": "Presentment Amount", "alias": "Cancelled/On-Hold Net Deposit Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Cancels/OnHold'" } ] }, { "reportAttributeName": "Merchant Order Number", "alias": "Successful Deposit Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Transaction Deposit Indicator", "aggregateConditionText": "= 'Y'" }, { "aggregateConditionAttributeName": "Submission File Status", "aggregateConditionText": "= 'RD'" } ] }, { "reportAttributeName": "Presentment Amount", "alias": "Successful Net Deposit Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Transaction Deposit Indicator", "aggregateConditionText": "= 'Y'" }, { "aggregateConditionAttributeName": "Submission File Status", "aggregateConditionText": "= 'RD'" } ] } ], "sectionSortOrderList": [ { "reportAttributeName": "Presentment Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Settlement Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Merchant Presenter Identifier", "sortOrderCode": "asc" }, { "reportAttributeName": "Submission Identifier", "sortOrderCode": "asc" } ], "sectionFilterAttributeList": [ { "reportAttributeName": "Merchant Action Code Text", "filterAttributeCode": "NOT IN (\"EXCLUDE FROM REPORTING\")" }, { "reportAttributeName": "Online Submission Indicator", "filterAttributeCode": "IN (\"N\")" }, { "reportAttributeName": "Latest Authorization Indicator", "filterAttributeCode": "=\"TRUE\"" } ] }, { "sectionReportTypeName": "Transaction Details", "sectionReportTypeId": "3001", "sectionSelectedFields": [ { "alias": "Record Type", "constantValueText": "Exception Details" }, { "reportAttributeName": "Transaction Division External Identifier" }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "Submission Identifier" }, { "reportAttributeName": "Record Number" }, { "reportAttributeName": "Merchant Order Number" }, { "reportAttributeName": "Exception Description" }, { "alias": "Amount", "reportAttributeName": "Presentment Amount" }, { "reportAttributeName": "Payment Method Code" }, { "reportAttributeName": "Account Number" }, { "reportAttributeName": "Credit Card Expiration Year Month Number" }, { "reportAttributeName": "Merchant Action Code Text" }, { "reportAttributeName": "Authorization Date" }, { "reportAttributeName": "Authorization Code" }, { "alias": "Auth Response Code", "reportAttributeName": "PTI Authorization Response Code" }, { "reportAttributeName": "Country Of Issuance" }, { "reportAttributeName": "Merchant Category Code" }, { "reportAttributeName": "Reject Code" }, { "reportAttributeName": "Card Usage Type" } ], "sectionSortOrderList": [ { "reportAttributeName": "Transaction Division External Identifier", "sortOrderCode": "asc" }, { "reportAttributeName": "Presentment Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Settlement Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Submission Identifier", "sortOrderCode": "asc" }, { "reportAttributeName": "Merchant Order Number", "sortOrderCode": "asc" } ], "sectionFilterAttributeList": [ { "reportAttributeName": "Exception Description", "filterAttributeCode": "IN(\"rejected transaction\",\"declined deposit\",\"cancels/onhold\")" } ] } ], "fileDelimiter": ",", "reportConfigurationName": "Transaction Summary & Exception Report", "reportFileName": "Transaction Summary & Exception Report....", "reportHeader": "EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=", "fileHeader": "BEGIN,EntityId=,Frequency=", "fileTrailer": "END,EntityId=,Frequency=", "csvColumnNameDisplayIndicator": true, "reportConfigStatus": "active", "reportName": "Transaction Summary & Exception Report", "frequencyConfig": { "scheduleFrequency": "adhoc", "reportingPeriodStartTimestamp": "2024-05-06 11:30:00", "reportingPeriodEndTimestamp": "2024-05-07 02:00:00" } } ``` ### PE The following request code block shows how to configure an exception report for `entityType` = PE. ```json { "entityType": "PE", "entityIds": [ "1234567" ], "reportSections": [ { "sectionReportTypeName": "Transaction Details", "sectionReportTypeId": "3001", "sectionSelectedFields": [ { "alias": "Record Type", "constantValueText": "Transaction Summary" }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "Merchant Presenter Identifier" }, { "reportAttributeName": "Merchant Presenter Short Name" }, { "reportAttributeName": "Submission Identifier" }, { "reportAttributeName": "Submission Status" }, { "reportAttributeName": "Submission Date" }, { "alias": "Transaction Count", "reportAttributeName": "Merchant Order Number", "aggregateOperationText": "count" }, { "reportAttributeName": "Merchant Order Number", "alias": "Authorization Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Merchant Action Code Text", "aggregateConditionText": "= 'AUTHORIZATIONS'" }, { "aggregateConditionAttributeName": "Submission File Status", "aggregateConditionText": "= 'RD'" } ] }, { "reportAttributeName": "Merchant Order Number", "alias": "Declined Deposit Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Declined Deposit'" } ] }, { "reportAttributeName": "Presentment Amount", "alias": "Declined Deposit Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Declined Deposit'" } ] }, { "reportAttributeName": "Merchant Order Number", "alias": "Rejected Transaction Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Rejected Transaction'" } ] }, { "reportAttributeName": "Presentment Amount", "alias": "Rejected Transaction Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Rejected Transaction'" } ] }, { "reportAttributeName": "Merchant Order Number", "alias": "Cancelled/On-Hold Deposit Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Cancels/OnHold'" } ] }, { "reportAttributeName": "Presentment Amount", "alias": "Cancelled/On-Hold Net Deposit Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Cancels/OnHold'" } ] }, { "reportAttributeName": "Merchant Order Number", "alias": "Successful Deposit Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Transaction Deposit Indicator", "aggregateConditionText": "= 'Y'" }, { "aggregateConditionAttributeName": "Submission File Status", "aggregateConditionText": "= 'RD'" } ] }, { "reportAttributeName": "Presentment Amount", "alias": "Successful Net Deposit Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Transaction Deposit Indicator", "aggregateConditionText": "= 'Y'" }, { "aggregateConditionAttributeName": "Submission File Status", "aggregateConditionText": "= 'RD'" } ] } ], "sectionSortOrderList": [ { "reportAttributeName": "Presentment Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Settlement Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Merchant Presenter Identifier", "sortOrderCode": "asc" }, { "reportAttributeName": "Submission Identifier", "sortOrderCode": "asc" } ], "sectionFilterAttributeList": [ { "reportAttributeName": "Merchant Action Code Text", "filterAttributeCode": "NOT IN (\"EXCLUDE FROM REPORTING\")" }, { "reportAttributeName": "Online Submission Indicator", "filterAttributeCode": "IN (\"N\")" }, { "reportAttributeName": "Latest Authorization Indicator", "filterAttributeCode": "=\"TRUE\"" } ] }, { "sectionReportTypeName": "Transaction Details", "sectionReportTypeId": "3001", "sectionSelectedFields": [ { "alias": "Record Type", "constantValueText": "Exception Details" }, { "reportAttributeName": "Transaction Processing Entity Identifier" }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "Submission Identifier" }, { "reportAttributeName": "Record Number" }, { "reportAttributeName": "Merchant Order Number" }, { "reportAttributeName": "Exception Description" }, { "alias": "Amount", "reportAttributeName": "Presentment Amount" }, { "reportAttributeName": "Payment Method Code" }, { "reportAttributeName": "Account Number" }, { "reportAttributeName": "Credit Card Expiration Year Month Number" }, { "reportAttributeName": "Merchant Action Code Text" }, { "reportAttributeName": "Authorization Date" }, { "reportAttributeName": "Authorization Code" }, { "alias": "Auth Response Code", "reportAttributeName": "PTI Authorization Response Code" }, { "reportAttributeName": "Country Of Issuance" }, { "reportAttributeName": "Merchant Category Code" }, { "reportAttributeName": "Reject Code" }, { "reportAttributeName": "Card Usage Type" } ], "sectionSortOrderList": [ { "reportAttributeName": "Transaction Processing Entity Identifier", "sortOrderCode": "asc" }, { "reportAttributeName": "Presentment Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Settlement Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Submission Identifier", "sortOrderCode": "asc" }, { "reportAttributeName": "Merchant Order Number", "sortOrderCode": "asc" } ], "sectionFilterAttributeList": [ { "reportAttributeName": "Exception Description", "filterAttributeCode": "IN(\"rejected transaction\",\"declined deposit\",\"cancels/onhold\")" } ] } ], "fileDelimiter": ",", "reportConfigurationName": "Transaction Summary & Exception Report", "reportFileName": "Transaction Summary & Exception Report....", "reportHeader": "EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=", "fileHeader": "BEGIN,EntityId=,Frequency=", "fileTrailer": "END,EntityId=,Frequency=", "csvColumnNameDisplayIndicator": true, "reportConfigStatus": "active", "reportName": "Transaction Summary & Exception Report", "frequencyConfig": { "scheduleFrequency": "adhoc", "reportingPeriodStartTimestamp": "2024-05-06 11:30:00", "reportingPeriodEndTimestamp": "2024-05-07 02:00:00" } } ``` ### PI The following request code block shows how to configure an exception report for `entityType` = PI. ```json { "entityType": "PI", "entityIds": [ "6019581085" ], "reportSections": [ { "sectionTitle": "Transaction Summary", "sectionReportTypeName": "Transaction Details", "sectionReportTypeId": "3001", "sectionSelectedFields": [ { "alias": "Record Type", "constantValueText": "Transaction Summary" }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Platform Identifier" }, { "reportAttributeName": "Platform Name" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "Merchant Presenter Identifier" }, { "reportAttributeName": "Merchant Presenter Short Name" }, { "reportAttributeName": "Submission Identifier" }, { "reportAttributeName": "Submission Status" }, { "reportAttributeName": "Submission Date" }, { "alias": "Transaction Count", "reportAttributeName": "Merchant Order Number", "aggregateOperationText": "count" }, { "reportAttributeName": "Merchant Order Number", "alias": "Authorization Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Merchant Action Code Text", "aggregateConditionText": "= 'AUTHORIZATIONS'" }, { "aggregateConditionAttributeName": "Submission File Status", "aggregateConditionText": "= 'RD'" } ] }, { "reportAttributeName": "Merchant Order Number", "alias": "Declined Deposit Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Declined Deposit'" } ] }, { "reportAttributeName": "Presentment Amount", "alias": "Declined Deposit Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Declined Deposit'" } ] }, { "reportAttributeName": "Merchant Order Number", "alias": "Rejected Transaction Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Rejected Transaction'" } ] }, { "reportAttributeName": "Presentment Amount", "alias": "Rejected Transaction Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Rejected Transaction'" } ] }, { "reportAttributeName": "Merchant Order Number", "alias": "Cancelled/On-Hold Deposit Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Cancels/OnHold'" } ] }, { "reportAttributeName": "Presentment Amount", "alias": "Cancelled/On-Hold Net Deposit Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Exception Description", "aggregateConditionText": "= 'Cancels/OnHold'" } ] }, { "reportAttributeName": "Merchant Order Number", "alias": "Successful Deposit Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Transaction Deposit Indicator", "aggregateConditionText": "= 'Y'" }, { "aggregateConditionAttributeName": "Submission File Status", "aggregateConditionText": "= 'RD'" } ] }, { "reportAttributeName": "Presentment Amount", "alias": "Successful Net Deposit Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": true, "conditionalAggregateFilterList": [ { "aggregateConditionAttributeName": "Transaction Deposit Indicator", "aggregateConditionText": "= 'Y'" }, { "aggregateConditionAttributeName": "Submission File Status", "aggregateConditionText": "= 'RD'" } ] } ], "sectionSortOrderList": [ { "reportAttributeName": "Presentment Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Settlement Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Merchant Presenter Identifier", "sortOrderCode": "asc" }, { "reportAttributeName": "Submission Identifier", "sortOrderCode": "asc" } ], "sectionFilterAttributeList": [ { "reportAttributeName": "Merchant Action Code Text", "filterAttributeCode": "NOT IN (\"EXCLUDE FROM REPORTING\")" }, { "reportAttributeName": "Online Submission Indicator", "filterAttributeCode": "IN (\"N\")" }, { "reportAttributeName": "Latest Authorization Indicator", "filterAttributeCode": "=\"TRUE\"" } ] }, { "sectionTitle": "Exception Details", "sectionReportTypeName": "Transaction Details", "sectionReportTypeId": "3001", "sectionSelectedFields": [ { "alias": "Record Type", "constantValueText": "Exception Details" }, { "reportAttributeName": "Transaction Processing Entity Identifier" }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "Submission Identifier" }, { "reportAttributeName": "Record Number" }, { "reportAttributeName": "Merchant Order Number" }, { "reportAttributeName": "Exception Description" }, { "alias": "Amount", "reportAttributeName": "Presentment Amount" }, { "reportAttributeName": "Payment Method Code" }, { "reportAttributeName": "Account Number" }, { "reportAttributeName": "Credit Card Expiration Year Month Number" }, { "reportAttributeName": "Action Code Text" }, { "reportAttributeName": "Authorization Date" }, { "reportAttributeName": "Authorization Code" }, { "alias": "Auth Response Code", "reportAttributeName": "PTI Authorization Response Code" }, { "reportAttributeName": "Country Of Issuance" }, { "reportAttributeName": "Merchant Category Code" }, { "reportAttributeName": "Reject Code" }, { "reportAttributeName": "Card Usage Type" } ], "sectionSortOrderList": [ { "reportAttributeName": "Transaction Processing Entity Identifier", "sortOrderCode": "asc" }, { "reportAttributeName": "Presentment Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Settlement Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Submission Identifier", "sortOrderCode": "asc" }, { "reportAttributeName": "Merchant Order Number", "sortOrderCode": "asc" } ], "sectionFilterAttributeList": [ { "reportAttributeName": "Exception Description", "filterAttributeCode": "IN(\"rejected transaction\",\"declined deposit\",\"cancels/onhold\")" } ] } ], "fileDelimiter": ",", "reportConfigurationName": "Exception Details Report", "reportFileName": "Exception Details Report....", "reportHeader": "EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=", "fileHeader": "BEGIN,EntityId=,Frequency=", "fileTrailer": "END,EntityId=,Frequency=", "csvColumnNameDisplayIndicator": true, "reportConfigStatus": "active", "reportName": "Transaction Summary & Exception Report", "frequencyConfig": { "scheduleFrequency": "adhoc", "reportingPeriodStartTimestamp": "2024-05-06 11:30:00", "reportingPeriodEndTimestamp": "2024-05-07 02:00:00" } } ``` ## Download sample report Download the sample [Exception details report](https://raw.githubusercontent.com/jpmorgan-payments/online-payments/refs/heads/main/docs/reporting/Exception%20Details%20Preset%20Report.csv). ## Related [Scheduled and adhoc report configurations](/docs/commerce/optimization-protection/capabilities/reporting/report-configurations/scheduled-adhoc)