Exception Details report
This report provides a summary of successful and unsuccessful transactions and details of unsuccessful transactions (Declined/Rejected/Cancelled/On-Hold).
| Report type | Supported entity types | Supported file formats |
|---|---|---|
| Transaction Details |
|
|
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 reasons 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
Summary
The following table shows the summary section field details.
|
Field name |
Definition |
|---|---|
|
Record Type |
The section of the report. For the summary section, record type value is |
|
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 |
The merchant presenter identifier. |
|
Merchant Presenter Short Name |
The merchant presenter's short name. |
|
Submission Identifier |
The 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 |
The count of transactions for the summarized record. |
|
Authorization Count |
The count of authorizations for the summarized record. |
|
Declined Deposit Count |
The count of deposits declined for the summarized record. |
|
Declined Deposit Amount |
The total Deposit Amount declined for the summarized record. |
|
Rejected Transaction Count |
The count of rejected transactions for the summarized record. |
|
Rejected Transaction Amount |
The total transaction amount rejected for the summarized record. |
|
Cancelled/On-Hold Deposit Count |
The count of deposits cancelled or on-hold for the summarized record. |
|
Cancelled/On-Hold Net Deposit Amount |
The total deposit amount cancelled/on-hold for the summarized record. |
|
Successful Deposit Count |
The count of successful transactions for the summarized record. |
|
Successful Net Deposit Amount |
The total successful transaction amount for the summarized record. |
|
Biometric Description (O) |
The description of the method used to automatically recognize a consumer by means of unique physical characteristics, such as facial recognition, fingerprint, or palm. |
|
Biometric Indicator (O) |
The code for the method used to automatically recognize a consumer by means of unique physical characteristics, such as facial recognition, fingerprint, or palm. |
|
Business Unit Identifier (O) |
The identifier of the business unit associated with the record. |
|
Business Unit Name (O) |
The name associated with the Commerce platform assigned business unit number. |
|
Company External Identifier (O) |
The identifier of the external company. |
|
Company Name (O) |
The name associated with the Commerce platform assigned CO number. |
|
Entity Name (O) |
The name associated with the Commerce platform assigned entity identifier. |
|
Merchant Action Code (O) |
The merchant-supplied code that indicates the type of transaction conducted. |
|
Payment Method Code Description (O) |
The description of the code that identifies the (MOP) method of payment for the transaction. |
|
Platform Identifier (O) |
The identifier of the platform used to facilitate the transaction request. |
|
Platform Name (O) |
The name of the platform used to facilitate the transaction request. |
|
Sales Channel Name (O) |
Indicates whether the transaction was initiated online or in-store. |
|
Transaction Division External Identifier (O) |
The identifier of the external transaction division. |
|
Transaction Processing Entity Identifier (O) |
The identifier of the transaction processing entity. |
Details
The following table shows the details section field details.
|
Field name |
Definition |
|---|---|
|
Record Type |
The section of the report. For the details section, record type value is |
|
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 |
The unique identification number for the submission. |
|
Record Number |
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 |
The transaction amount. |
|
Payment Method Code |
The code that identifies the method of payment (MOP) for the transaction. |
|
Account Number |
The cardholder's 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 |
The type of transaction action conducted. Valid values are:
|
|
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 |
The authorization response code indicating Approval, Decline or Rejection. |
|
Country Of Issuance |
The 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 |
The code that is used to classify a merchant's product or service. |
|
Reject Code |
The code that is used to classify the reason for rejecting a transaction. |
|
Card Usage Type |
Identifies whether the transaction is a Signature Debit transaction (1), PIN Debit transaction (2), or a Credit Card transaction (3). |
|
Entity Identifier |
The associated CO, BU, TD, or PE identification number. |
|
Entity Type Code |
The level at which the reported event occurred. Valid values are:
|
|
Bank Identification Code (O) |
The bank identification code. |
|
Bank Sort Code (O) |
The code that identifies both the bank and the branch where the account is held. |
|
Biometric Description (O) |
The description of the method used to automatically recognize a consumer by means of unique physical characteristics, such as facial recognition, fingerprint, or palm. |
|
Biometric Indicator (O) |
The code for the method used to automatically recognize a consumer by means of unique physical characteristics, such as facial recognition, fingerprint, or palm. |
|
Business Unit Identifier (O) |
The identifier of the business unit associated with the record. |
|
Business Unit Name (O) |
The name associated with the Commerce platform assigned business unit number. |
|
Company External Identifier (O) |
The identifier of the external company. |
|
Company Name (O) |
The name associated with the Commerce platform assigned CO number. |
|
Creditor Identifier (O) |
The creditor identifier associated with the transaction. |
|
Debit Trace Number (O) |
For US debit transactions only, a sequential eight-digit identifier (1-99999999) assigned by J.P. Morgan. The number rolls over, so the same number may appear more than once. Space-filled for transactions other than US debit. |
|
Entity Name (O) |
The name associated with the Commerce platform assigned entity identifier. |
|
International Bank Account Number (O) |
The International Bank Account Number (IBAN), comprised of the bank's country code, a checksum, and the Basic Bank Account Number (BBAN) of up to thirty alphanumeric characters containing the domestic bank account details. |
|
Mandate Code (O) |
The sequence type of the mandate. Valid values are:
Space-filled if Mandate Identifier and Signature Date are space-filled. |
|
Mandate Identifier (O) |
The code that identifies the agreement between the consumer and merchant that allows the consumer's direct debit account to be debited in an automated manner over a period of time. |
|
Receiving Depository Financial Institution Number (O) |
The Receiving Depository Financial Institution (RDFI) number / routing number. |
|
Sales Channel (O) |
Indicates whether the transaction was initiated online or in-store. |
|
Signature Date (O) |
The date the customer signed the mandate. |
|
Transaction Division External Identifier (O) |
The identifier of the external transaction division. |
|
Transaction Processing Entity Identifier (O) |
The identifier of the transaction processing entity. |
Sample report configurations
The following samples help you get an idea of how to configure exception reports.
CO/BU/TD/PE
The following request code block shows how to configure an exception report for entityType = CO/BU/TD/PE.
{
"entityType": "CO",
"entityIds": [
"1234567"
],
"preBuiltConfigurationId": "preset_Unified_Transaction_Summary_Exception_Report",
"reportSections": [
{
"sectionReportTypeId": "3001",
"sectionReportTypeName": "Transaction Details",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "Transaction Summary"
},
{
"reportAttributeName": "Entity Identifier"
},
{
"reportAttributeName": "Entity Type Code"
},
{
"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"
},
{
"alias": "Authorization Count",
"reportAttributeName": "Merchant Order Number",
"aggregateOperationText": "count",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Merchant Action Code Text",
"aggregateConditionText": "= 'AUTHORIZATIONS'"
},
{
"aggregateConditionAttributeName": "Submission File Status",
"aggregateConditionText": "= 'RD'"
}
]
},
{
"alias": "Declined Deposit Count",
"reportAttributeName": "Merchant Order Number",
"aggregateOperationText": "count",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Exception Description",
"aggregateConditionText": "= 'Declined Deposit'"
}
]
},
{
"alias": "Declined Deposit Amount",
"reportAttributeName": "Presentment Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Exception Description",
"aggregateConditionText": "= 'Declined Deposit'"
}
]
},
{
"alias": "Rejected Transaction Count",
"reportAttributeName": "Merchant Order Number",
"aggregateOperationText": "count",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Exception Description",
"aggregateConditionText": "= 'Rejected Transaction'"
}
]
},
{
"alias": "Rejected Transaction Amount",
"reportAttributeName": "Presentment Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Exception Description",
"aggregateConditionText": "= 'Rejected Transaction'"
}
]
},
{
"alias": "Cancelled/On-Hold Deposit Count",
"reportAttributeName": "Merchant Order Number",
"aggregateOperationText": "count",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Exception Description",
"aggregateConditionText": "= 'Cancels/OnHold'"
}
]
},
{
"alias": "Cancelled/On-Hold Net Deposit Amount",
"reportAttributeName": "Presentment Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Exception Description",
"aggregateConditionText": "= 'Cancels/OnHold'"
}
]
},
{
"alias": "Successful Deposit Count",
"reportAttributeName": "Merchant Order Number",
"aggregateOperationText": "count",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Transaction Deposit Indicator",
"aggregateConditionText": "= 'Y'"
},
{
"aggregateConditionAttributeName": "Submission File Status",
"aggregateConditionText": "= 'RD'"
}
]
},
{
"alias": "Successful Net Deposit Amount",
"reportAttributeName": "Presentment Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Transaction Deposit Indicator",
"aggregateConditionText": "= 'Y'"
},
{
"aggregateConditionAttributeName": "Submission File Status",
"aggregateConditionText": "= 'RD'"
}
]
}
],
"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\""
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Presentment Currency Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Settlement Currency Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Merchant Presenter Identifier",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Submission Identifier",
"sortOrderCode": "asc"
}
]
},
{
"sectionReportTypeId": "3001",
"sectionReportTypeName": "Transaction Details",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "Exception Details"
},
{
"reportAttributeName": "Entity Identifier"
},
{
"reportAttributeName": "Entity Type Code"
},
{
"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"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Exception Description",
"filterAttributeCode": "IN(\"rejected transaction\",\"declined deposit\",\"cancels/onhold\")"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "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"
}
]
}
],
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2026-07-08 00:00:00",
"reportingPeriodEndTimestamp": "2026-07-09 23:59:59"
},
"reportConfigurationName": "Exception Details",
"reportName": "Exception Details",
"reportConfigType": "PreBuilt",
"fileDelimiter": ",",
"csvColumnNameDisplayIndicator": true,
"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>",
"languageCode": "en-us"
}PI
The following request code block shows how to configure an exception report for entityType = PI.
{
"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.<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,
"reportConfigStatus": "active",
"reportName": "Transaction Summary & Exception Report",
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2024-05-06 11:30:00",
"reportingPeriodEndTimestamp": "2024-05-07 02:00:00"
}
}