Exception details report
This report provides a summary of successful and unsuccessful transactions and details of unsuccessful transactions (Declined/Rejected/Cancelled/On-Hold).
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.
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.
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:
|
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). |
Sample report configuration
The following request code block shows how to configure an exception report for entityType
= CO/BU/TD.
{
"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.<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"
}
}
The following request code block shows how to configure an exception report for entityType
= PE.
{
"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.<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"
}
}