Skip to main content
Optimization Protection

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 Separated 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 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.

Summary section field details

Field name

Definition

Record Type

The section of the report. For the 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

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.

Detail section field details

Field name

Definition

Record Type

The section of the report. For the details section, record type value is Exception Details.

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:

  • 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

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:

  • BU - Business Unit
  • CO - Company
  • TD - Transaction Division
  • PE - Processing Entity

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:

  • 1 - First
  • 2 - Recurrence
  • 3 - Last
  • 4 - One-off
  • 5 - New
  • 6 - Cancel
  • 7 - Change from manual to electronic

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"
  }
}
Is this page helpful?