# JPMC-PDP Documentation from https://developer.payments.jpmorgan.com
# Testing
The test environment generates results based on the details supplied in the request. In this guide, you will learn how to:
- Create new report configurations
- Use samples to create your test scenarios
## Before you begin
You must test the client credentials you received from the implementations team to conduct a test transaction. For more about getting your test client credentials, refer to [Getting started](/docs/commerce/optimization-protection/getting-started).
## Set up how and when you want to receive reports
Create a new report configuration by performing a `POST /reports` using the report configurations of the report type you want.
### Preset report configurations
You can use the following example report configurations for each preset report type.
#### Authorization report
The following request code block shows how to configure an authorization report for `entityType` = CO/BU/TD. Download the sample [Authorization report](https://raw.githubusercontent.com/jpmorgan-payments/online-payments/refs/heads/main/docs/reporting/Authorization%20Details%20Preset%20Report.csv).
```json
{
"entityType": "CO",
"entityIds": [
"1234567"
],
"reportSections": [
{
"sectionTitle": "Authorization Summary",
"sectionReportTypeName": "Transaction Details",
"sectionReportTypeId": "3001",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "Authorization Summary"
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "MOP Type"
},
{
"reportAttributeName": "PTI Authorization Response Code",
"alias": "Response Code"
},
{
"reportAttributeName": "PTI Authorization Response Code Description",
"alias": "Response Description"
},
{
"reportAttributeName": "Firm Authorization Approval Code"
},
{
"reportAttributeName": "Merchant Order Number",
"alias": "Total Transaction Count",
"aggregateOperationText": "count",
"conditionalAggregateIndicator": false
},
{
"reportAttributeName": "Authorization Amount",
"alias": "Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": false
},
{
"reportAttributeName": "Transaction Decline Count",
"alias": "Count of Declined Transactions",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": false
},
{
"alias": "Authorization Total Count %",
"customCalculationText": "% of",
"customCalculationOn": "Total Transaction Count",
"groupBy": [
"MOP Type"
]
},
{
"alias": "Authorization Status %",
"customCalculationText": "% of",
"customCalculationOn": "Total Transaction Count",
"groupBy": [
"MOP Type",
"PTI Authorization Response Code"
]
},
{
"alias": "Transaction Decline %",
"customCalculationText": "% of",
"customCalculationOn": "Count of Declined Transactions",
"groupBy": [
"MOP Type",
"PTI Authorization Response Code"
]
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Transaction Type Text",
"filterAttributeCode": "NOT IN (\"REJECTS\")"
},
{
"reportAttributeName": "Merchant Action Code Text",
"filterAttributeCode": "IN (\"DEPOSITS\",\"AUTHORIZATIONS\")"
},
{
"reportAttributeName": "Authorization Amount",
"filterAttributeCode": "IS NOT NULL"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "MOP Type",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "PTI Authorization Response Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Presentment Currency Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Settlement Currency Code",
"sortOrderCode": "asc"
}
]
},
{
"sectionTitle": "Authorization Details",
"sectionReportTypeName": "Transaction Details",
"sectionReportTypeId": "3001",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "Authorization Details"
},
{
"reportAttributeName": "Entity Identifier"
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "Payment Method Code"
},
{
"reportAttributeName": "Merchant Order Number"
},
{
"reportAttributeName": "Merchant Action Code Text"
},
{
"reportAttributeName": "Authorization Amount"
},
{
"reportAttributeName": "Account Number"
},
{
"reportAttributeName": "Credit Card Expiration Year Month Number"
},
{
"reportAttributeName": "Transaction Type Text"
},
{
"reportAttributeName": "Authorization Timestamp"
},
{
"reportAttributeName": "Authorization Code"
},
{
"reportAttributeName": "Payment Brand Auth Response"
},
{
"reportAttributeName": "Payment Brand Response Code Category"
},
{
"reportAttributeName": "PTI Authorization Response Code"
},
{
"reportAttributeName": "Authorization Initiator"
},
{
"reportAttributeName": "Authorization Source Code"
},
{
"reportAttributeName": "POS Authentication Source"
},
{
"reportAttributeName": "Merchant Category Code"
},
{
"reportAttributeName": "Country Of Issuance"
},
{
"reportAttributeName": "Digital Token Method Text"
},
{
"reportAttributeName": "Prepaid Card Type Code"
},
{
"reportAttributeName": "Commercial Card Code"
},
{
"reportAttributeName": "Card Usage Type"
},
{
"reportAttributeName": "Payment Transaction Identifier"
},
{
"reportAttributeName": "Terminal Identifier"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Merchant Action Code Text",
"filterAttributeCode": "IN (\"DEPOSITS\",\"AUTHORIZATIONS\")"
},
{
"reportAttributeName": "Authorization Amount",
"filterAttributeCode": "IS NOT NULL"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Presentment Currency Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Settlement Currency Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Entity Identifier",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Payment Method Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Merchant Order Number",
"sortOrderCode": "asc"
}
]
}
],
"fileDelimiter": ",",
"reportConfigurationName": "Authorization Report",
"reportFileName": "Authorization Report,...",
"reportHeader": "EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=",
"fileHeader": "BEGIN,EntityId=,Frequency=",
"fileTrailer": "END,EntityId=,Frequency=",
"reportConfigStatus": "active",
"reportName": "Authorization Report",
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2023-02-21 04:00:00",
"reportingPeriodEndTimestamp": "2023-02-22 03:59:59"
}
}
```
The following request code block shows how to configure an authorization report for `entityType` = PE.
```json
{
"entityType": "PE",
"entityIds": [
"1234567"
],
"reportSections": [
{
"sectionTitle": "Authorization Summary",
"sectionReportTypeName": "Transaction Details",
"sectionReportTypeId": "3001",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "Authorization Summary"
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "MOP Type"
},
{
"reportAttributeName": "PTI Authorization Response Code",
"alias": "Response Code"
},
{
"reportAttributeName": "PTI Authorization Response Code Description",
"alias": "Response Description"
},
{
"reportAttributeName": "Firm Authorization Approval Code"
},
{
"reportAttributeName": "Merchant Order Number",
"alias": "Total Transaction Count",
"aggregateOperationText": "count",
"conditionalAggregateIndicator": false
},
{
"reportAttributeName": "Authorization Amount",
"alias": "Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": false
},
{
"reportAttributeName": "Transaction Decline Count",
"alias": "Count of Declined Transactions",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": false
},
{
"alias": "Authorization Total Count %",
"customCalculationText": "% of",
"customCalculationOn": "Total Transaction Count",
"groupBy": [
"MOP Type"
]
},
{
"alias": "Authorization Status %",
"customCalculationText": "% of",
"customCalculationOn": "Total Transaction Count",
"groupBy": [
"MOP Type",
"PTI Authorization Response Code"
]
},
{
"alias": "Transaction Decline %",
"customCalculationText": "% of",
"customCalculationOn": "Count of Declined Transactions",
"groupBy": [
"MOP Type",
"PTI Authorization Response Code"
]
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Transaction Type Text",
"filterAttributeCode": "NOT IN (\"REJECTS\")"
},
{
"reportAttributeName": "Merchant Action Code Text",
"filterAttributeCode": "IN (\"DEPOSITS\",\"AUTHORIZATIONS\")"
},
{
"reportAttributeName": "Authorization Amount",
"filterAttributeCode": "IS NOT NULL"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "MOP Type",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "PTI Authorization Response Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Presentment Currency Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Settlement Currency Code",
"sortOrderCode": "asc"
}
]
},
{
"sectionTitle": "Authorization Details",
"sectionReportTypeName": "Transaction Details",
"sectionReportTypeId": "3001",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "Authorization Details"
},
{
"reportAttributeName": "Transaction Processing Entity Identifier"
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "Payment Method Code"
},
{
"reportAttributeName": "Merchant Order Number"
},
{
"reportAttributeName": "Merchant Action Code Text"
},
{
"reportAttributeName": "Authorization Amount"
},
{
"reportAttributeName": "Account Number"
},
{
"reportAttributeName": "Credit Card Expiration Year Month Number"
},
{
"reportAttributeName": "Transaction Type Text"
},
{
"reportAttributeName": "Authorization Timestamp"
},
{
"reportAttributeName": "Authorization Code"
},
{
"reportAttributeName": "Payment Brand Auth Response"
},
{
"reportAttributeName": "Payment Brand Response Code Category"
},
{
"reportAttributeName": "PTI Authorization Response Code"
},
{
"reportAttributeName": "Authorization Initiator"
},
{
"reportAttributeName": "Authorization Source Code"
},
{
"reportAttributeName": "POS Authentication Source"
},
{
"reportAttributeName": "Merchant Category Code"
},
{
"reportAttributeName": "Country Of Issuance"
},
{
"reportAttributeName": "Digital Token Method Text"
},
{
"reportAttributeName": "Prepaid Card Type Code"
},
{
"reportAttributeName": "Commercial Card Code"
},
{
"reportAttributeName": "Card Usage Type"
},
{
"reportAttributeName": "Payment Transaction Identifier"
},
{
"reportAttributeName": "Terminal Identifier"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Merchant Action Code Text",
"filterAttributeCode": "IN (\"DEPOSITS\",\"AUTHORIZATIONS\")"
},
{
"reportAttributeName": "Authorization Amount",
"filterAttributeCode": "IS NOT NULL"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Presentment Currency Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Settlement Currency Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Transaction Processing Entity Identifier",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Payment Method Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Merchant Order Number",
"sortOrderCode": "asc"
}
]
}
],
"fileDelimiter": ",",
"reportConfigurationName": "Authorization Report",
"reportFileName": "Authorization Report,....",
"reportHeader": "EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=",
"fileHeader": "BEGIN,EntityId=,Frequency=",
"fileTrailer": "END,EntityId=,Frequency=",
"csvColumnNameDisplayIndicator": true,
"reportConfigStatus": "active",
"reportName": "Authorization Report",
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2023-02-21 04:00:00",
"reportingPeriodEndTimestamp": "2023-02-22 03:59:59"
}
}
```
#### Account updated report
The following request code block shows how to configure an account updated report for `entityType` = CO/BU/TD. Download the sample [Account updated report](https://raw.githubusercontent.com/jpmorgan-payments/online-payments/refs/heads/main/docs/reporting/Account%20Updated%20Preset%20Report.csv).
```json
{
"entityType": "CO",
"entityIds": [
"393931"
],
"reportSections": [
{
"sectionTitle": "Account Updated Summary",
"sectionReportTypeName": "Account Updater",
"sectionReportTypeId": "3018",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "ACP-01 "
},
{
"alias": "Reason Message",
"reportAttributeName": "Firm Account Updater Response Type Name"
},
{
"alias": "Response Message",
"reportAttributeName": "Account Updater Status Message Text"
},
{
"alias": "Method",
"reportAttributeName": "Account Updater Inquiry Source Code"
},
{
"alias": "Method of Payment",
"reportAttributeName": "Payment Method Code"
},
{
"alias": "Total",
"reportAttributeName": "Firm Account Updater Response Type Name",
"aggregateOperationText": "count"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Firm Account Updater Response Type Name",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Account Updater Status Message Text",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Account Updater Inquiry Source Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Payment Method Code",
"sortOrderCode": "asc"
}
]
},
{
"sectionReportTypeName": "Account Update",
"sectionTitle": "Account Updated Details",
"sectionReportTypeId": "3018",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "ACP-02 "
},
{
"reportAttributeName": "ProfileID"
},
{
"alias": "Processor Profile ID ",
"reportAttributeName": "JPMC Consumer Profile ID"
},
{
"reportAttributeName": "Payment Method Id"
},
{
"alias": "Submitted Date ",
"reportAttributeName": "Transaction Timestamp"
},
{
"alias": "Method",
"reportAttributeName": "Account Updater Inquiry Source Code"
},
{
"alias": "Card Account Action",
"reportAttributeName": "Account Updater Inquiry Type Code"
},
{
"alias": "Sub Merchant ID",
"reportAttributeName": "Soft Merchant Identifier"
},
{
"alias": "Response ID",
"reportAttributeName": "Transaction Identifier"
},
{
"alias": "Payment Brand",
"reportAttributeName": "Payment Method Code"
},
{
"alias": "Payment Brand Change",
"reportAttributeName": "Card Brand Changed Indicator"
},
{
"alias": "Merchant Record Identifier ",
"reportAttributeName": "Merchant Provided Account Update Identifier"
},
{
"alias": "Submitted Account Number",
"reportAttributeName": "Old Account Number"
},
{
"alias": "Submitted Expiry",
"reportAttributeName": "Old Card Expiration Month Year Number"
},
{
"alias": "New Masked Account",
"reportAttributeName": "Account Number"
},
{
"alias": "New Expiry",
"reportAttributeName": "Card Expiration Month Year Number"
},
{
"alias": "Reason Message",
"reportAttributeName": "Firm Account Updater Response Type Name"
},
{
"alias": "Network Response",
"reportAttributeName": "Network Account Update Response Code"
},
{
"alias": "Request Status",
"reportAttributeName": "Card Account Action Code"
}
]
}
],
"fileDelimiter": ",",
"reportConfigurationName": "Account Updated Report",
"reportFileName": "ACP-01....",
"reportHeader": "ProcessingEntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=",
"fileHeader": "BEGIN,ProcessingEntityId=,Frequency=",
"fileTrailer": "END,ProcessingEntityId=,Frequency=",
"csvColumnNameDisplayIndicator": true,
"totalRowCountDisplayIndicator": false,
"sectionRowCountDisplayIndicator": false,
"reportConfigStatus": "active",
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2025-03-17 10:23:29",
"reportingPeriodEndTimestamp": "2025-03-31 10:23:29"
}
}
```
The following request code block shows how to configure an account updated report for `entityType` = PE.
```json
{
"entityType": "PE",
"entityIds": [
"997946715419"
],
"reportSections": [
{
"sectionTitle": "Account Updated Summary",
"sectionReportTypeName": "Account Updater",
"sectionReportTypeId": "3018",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "ACP-01 "
},
{
"alias": "Reason Message",
"reportAttributeName": "Firm Account Updater Response Type Name"
},
{
"alias": "Response Message",
"reportAttributeName": "Account Updater Status Message Text"
},
{
"alias": "Method",
"reportAttributeName": "Account Updater Inquiry Source Code"
},
{
"alias": "Method of Payment",
"reportAttributeName": "Payment Method Code"
},
{
"alias": "Total",
"reportAttributeName": "Firm Account Updater Response Type Name",
"aggregateOperationText": "count"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Firm Account Updater Response Type Name",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Account Updater Status Message Text",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Account Updater Inquiry Source Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Payment Method Code",
"sortOrderCode": "asc"
}
]
},
{
"sectionReportTypeName": "Account Updater",
"sectionTitle": "Account Updated Details",
"sectionReportTypeId": "3018",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "ACP-02 "
},
{
"reportAttributeName": "ProfileID"
},
{
"alias": "Processor Profile ID ",
"reportAttributeName": "JPMC Consumer Profile ID"
},
{
"reportAttributeName": "Payment Method Id"
},
{
"alias": "Submitted Date ",
"reportAttributeName": "Transaction Timestamp"
},
{
"alias": "Method",
"reportAttributeName": "Account Updater Inquiry Source Code"
},
{
"alias": "Card Account Action",
"reportAttributeName": "Account Updater Inquiry Type Code"
},
{
"alias": "Sub Merchant ID",
"reportAttributeName": "Soft Merchant Identifier"
},
{
"alias": "Response ID",
"reportAttributeName": "Transaction Identifier"
},
{
"alias": "Payment Brand",
"reportAttributeName": "Payment Method Code"
},
{
"alias": "Payment Brand Change",
"reportAttributeName": "Card Brand Changed Indicator"
},
{
"alias": "Merchant Record Identifier ",
"reportAttributeName": "Merchant Provided Account Update Identifier"
},
{
"alias": "Submitted Account Number",
"reportAttributeName": "Old Account Number"
},
{
"alias": "Submitted Expiry",
"reportAttributeName": "Old Card Expiration Month Year Number"
},
{
"alias": "New Masked Account",
"reportAttributeName": "Account Number"
},
{
"alias": "New Expiry",
"reportAttributeName": "Card Expiration Month Year Number"
},
{
"alias": "Reason Message",
"reportAttributeName": "Firm Account Updater Response Type Name"
},
{
"alias": "Network Response",
"reportAttributeName": "Network Account Update Response Code"
},
{
"alias": "Request Status",
"reportAttributeName": "Card Account Action Code"
}
]
}
],
"fileDelimiter": ",",
"reportConfigurationName": "Account Updated Report",
"reportFileName": "ACP-01....",
"reportHeader": "ProcessingEntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=",
"fileHeader": "BEGIN,ProcessingEntityId=,Frequency=",
"fileTrailer": "END,ProcessingEntityId=,Frequency=",
"csvColumnNameDisplayIndicator": true,
"totalRowCountDisplayIndicator": false,
"sectionRowCountDisplayIndicator": false,
"reportConfigStatus": "active",
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2025-03-17 10:23:29",
"reportingPeriodEndTimestamp": "2025-03-31 10:23:29"
}
}
```
#### Charge summary report
The following request code block shows how to configure a charge summary report for `entityType` = CO/BU/TD. Download the sample [Charge summary report](https://raw.githubusercontent.com/jpmorgan-payments/online-payments/refs/heads/main/docs/reporting/Charge%20Summary%20Preset%20Report.csv).
```json
{
"entityType": "CO",
"entityIds": [
"1234567"
],
"reportSections": [
{
"sectionReportTypeName": "Submission Details",
"sectionReportTypeId": "3003",
"sectionSelectedFields": [
{
"constantValueText": "Charge Summary",
"alias": "Record Type"
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "Payment Method Code"
},
{
"reportAttributeName": "Charge Category Text"
},
{
"reportAttributeName": "Charge Subcategory Text"
},
{
"reportAttributeName": "Action Type Code Text"
},
{
"reportAttributeName": "Merchant Service Fee Schedule Identifier"
},
{
"reportAttributeName": "Fee Text"
},
{
"reportAttributeName": "Interchange Qualification Code"
},
{
"reportAttributeName": "Unit Quantity Number",
"aggregateOperationText": "sum",
"alias": "Unit Quantity"
},
{
"reportAttributeName": "Unit Fee Amount"
},
{
"reportAttributeName": "Settlement Amount",
"aggregateOperationText": "sum",
"alias": "Transaction Amount"
},
{
"reportAttributeName": "Fee Rate"
},
{
"reportAttributeName": "Settled Total Fee Amount",
"aggregateOperationText": "sum",
"alias": "Total Charge"
},
{
"reportAttributeName": "Sales Tax",
"aggregateOperationText": "sum",
"alias": "Sales Tax"
},
{
"reportAttributeName": "Federal Tax",
"aggregateOperationText": "sum",
"alias": "Federal Tax"
},
{
"reportAttributeName": "Provincial Tax",
"aggregateOperationText": "sum",
"alias": "Provincial Tax"
},
{
"reportAttributeName": "Total Charge after Tax",
"aggregateOperationText": "sum",
"alias": "Total Charge after Tax"
}
]
},
],
"sectionSortOrderList": [
{
"reportAttributeName": "Settlement Currency Code",
"sortOrderCode": "asc"
}, {
"reportAttributeName": "Payment Method Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Charge Category Text",
"sortOrderCode": "desc"
},
{
"reportAttributeName": "Charge Subcategory Text",
"sortOrderCode": "asc"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Charge Subcategory Text",
"filterAttributeCode": "IN (\"Authorization Fees\",\"Interchange & Assessment Fees\",\"PDE Fees\",\"Deposit Fees\",\"Equipment Fees\",\"Monthly Fees\",\"Paymentech Non-Transaction Fees\",\"Funds Transfer Fees\",\"Other Fees\",\"Paymentech Fees\",\"Project Expenses\",\"Promotion Fees\", \"Interchange Fees\", \"Assessment Fees\",\"Monthly Non-Transaction Fees\")"
}
]
},
{
"sectionReportTypeName": "Submission Details",
"sectionReportTypeId": "3003",
"distinctSelectIndicator": true,
"sectionSelectedFields": [
{
"constantValueText": "Tax Information",
"alias": "Record Type"
},
{
"reportAttributeName": "Transaction Division External Identifier"
},
{
"reportAttributeName": "Acquirer Codice Fiscale"
},
{
"reportAttributeName": "Acquirer Legal Entity"
},
{
"reportAttributeName": "CPSI GST Registration Number"
},
{
"reportAttributeName": "CPSI QST Registration Number"
},
{
"reportAttributeName": "Merchant Codice Fiscale"
},
{
"reportAttributeName": "Recipient Address"
},
{
"reportAttributeName": "Recipient Legal Entity"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Charge Subcategory Text",
"filterAttributeCode": "IN (\"Authorization Fees\",\"Interchange & Assessment Fees\",\"PDE Fees\",\"Deposit Fees\",\"Equipment Fees\",\"Monthly Fees\",\"Paymentech Non-Transaction Fees\",\"Funds Transfer Fees\",\"Other Fees\",\"Paymentech Fees\",\"Project Expenses\",\"Promotion Fees\", \"Interchange Fees\", \"Assessment Fees\",\"Monthly Non-Transaction Fees\")"
}
]
}
],
"fileDelimiter": ",",
"reportConfigurationName": "Charge Summary Report",
"reportFileName": "Charge Summary Report....",
"reportHeader": EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=",
"fileHeader": "BEGIN,EntityId=,Frequency=",
"fileTrailer": "END,EntityId=,Frequency=",
"csvColumnNameDisplayIndicator": true,
"totalRowCountDisplayIndicator": false,
"reportName": "Charge Summary Report",
"sectionRowCountDisplayIndicator": false,
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2023-08-27 11:30:00",
"reportingPeriodEndTimestamp": "2023-08-28 02:00:00"
}
}
```
The following request code block shows how to configure a charge summary report for `entityType` = PE.
```json
{
"entityType": "PE",
"entityIds": [
"1234567"
],
"reportSections": [
{
"sectionReportTypeName": "Submission Details",
"sectionReportTypeId": "3003",
"sectionSelectedFields": [
{
"constantValueText": "Charge Summary",
"alias": "Record Type"
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "Payment Method Code"
},
{
"reportAttributeName": "Charge Category Text"
},
{
"reportAttributeName": "Charge Subcategory Text"
},
{
"reportAttributeName": "Action Type Code Text"
},
{
"reportAttributeName": "Merchant Service Fee Schedule Identifier"
},
{
"reportAttributeName": "Fee Text"
},
{
"reportAttributeName": "Interchange Qualification Code"
},
{
"reportAttributeName": "Unit Quantity Number",
"aggregateOperationText": "sum",
"alias": "Unit Quantity"
},
{
"reportAttributeName": "Unit Fee Amount"
},
{
"reportAttributeName": "Settlement Amount",
"aggregateOperationText": "sum",
"alias": "Transaction Amount"
},
{
"reportAttributeName": "Fee Rate"
},
{
"reportAttributeName": "Settled Total Fee Amount",
"aggregateOperationText": "sum",
"alias": "Total Charge"
},
{
"reportAttributeName": "Sales Tax",
"aggregateOperationText": "sum",
"alias": "Sales Tax"
},
{
"reportAttributeName": "Federal Tax",
"aggregateOperationText": "sum",
"alias": "Federal Tax"
},
{
"reportAttributeName": "Provincial Tax",
"aggregateOperationText": "sum",
"alias": "Provincial Tax"
},
{
"reportAttributeName": "Total Charge after Tax",
"aggregateOperationText": "sum",
"alias": "Total Charge after Tax"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Settlement Currency Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Payment Method Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Charge Category Text",
"sortOrderCode": "desc"
},
{
"reportAttributeName": "Charge Subcategory Text",
"sortOrderCode": "asc"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Charge Subcategory Text",
"filterAttributeCode": "IN (\"Authorization Fees\",\"Interchange & Assessment Fees\",\"PDE Fees\",\"Deposit Fees\",\"Equipment Fees\",\"Monthly Fees\",\"Paymentech Non-Transaction Fees\",\"Funds Transfer Fees\",\"Other Fees\",\"Paymentech Fees\",\"Project Expenses\",\"Promotion Fees\", \"Interchange Fees\", \"Assessment Fees\",\"Monthly Non-Transaction Fees\")"
}
]
}
],
"fileDelimiter": ",",
"reportConfigurationName": "Charge Summary Report",
"reportFileName": "Charge Summary Report....",
"reportHeader": EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=",
"fileHeader": "BEGIN,EntityId=,Frequency=",
"fileTrailer": "END,EntityId=,Frequency=",
"csvColumnNameDisplayIndicator": true,
"totalRowCountDisplayIndicator": false,
"reportName": "Charge Summary Report",
"sectionRowCountDisplayIndicator": false,
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2023-08-27 11:30:00",
"reportingPeriodEndTimestamp": "2023-08-28 02:00:00"
}
}
```
#### Consumer profile overview report
The following request code block shows how to configure a charge summary report for `entityType` = CO/BU/TD. Download the sample [Consumer profile overview report](https://raw.githubusercontent.com/jpmorgan-payments/online-payments/refs/heads/main/docs/reporting/Consumer%20Profile%20Overview%20Preset%20Report.csv).
```json
{
"entityType": "CO",
"entityIds": [
"242017"
],
"reportSections": [
{
"sectionReportTypeName": "Consumer Profile Overview",
"sectionTitle": "Consumer Profile Details",
"sectionReportTypeId": "3019",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "CPM-001"
},
{
"alias": "Profile ID",
"reportAttributeName": "Profile ID",
"aggregateOperationText": "max"
},
{
"alias": "Processor Profile ID ",
"reportAttributeName": "JPMC Consumer Profile ID"
},
{
"alias": "First Name ",
"reportAttributeName": "First Name by Payment Method"
},
{
"alias": "Last Name",
"reportAttributeName": "Last Name by Payment Method"
},
{
"alias": "Email Address",
"reportAttributeName": "Profile Email Address"
},
{
"reportAttributeName": "Phone Number"
},
{
"reportAttributeName": "Address Line 1"
},
{
"reportAttributeName": "Address Line 2"
},
{
"alias": "Address Postal Code",
"reportAttributeName": "Postal code"
},
{
"alias": "Address Country Code",
"reportAttributeName": "Country Code"
},
{
"reportAttributeName": "Profile Status"
},
{
"alias": "Payment Method ID",
"reportAttributeName": "Default Payment Method ID "
},
{
"alias": "Payment Method Status",
"reportAttributeName": "Account Status Code"
},
{
"alias": "Payment Method Type",
"reportAttributeName": "Default Payment Method Type"
},
{
"alias": "Payment Method Name",
"reportAttributeName": "Default Payment Method Name"
},
{
"alias": "Payment Method Code",
"reportAttributeName": "Default Payment Method Code"
},
{
"alias": "Payment Method (Last 4 Digit Card)",
"reportAttributeName": "Deault AccountNumber(Last 4 Digits)"
},
{
"alias": "Card Expiration Date",
"reportAttributeName": "Default Card Expiration Date"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Account Status Code",
"filterAttributeCode": "is not null"
}
]
}
],
"fileDelimiter": ",",
"reportConfigurationName": "Consumer Profile Report",
"reportFileName": "CPM-001....",
"reportHeader": "ProcessingEntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=",
"fileHeader": "BEGIN,ProcessingEntityId=,Frequency=",
"fileTrailer": "END,ProcessingEntityId=,Frequency=",
"csvColumnNameDisplayIndicator": true,
"totalRowCountDisplayIndicator": false,
"sectionRowCountDisplayIndicator": false,
"reportConfigStatus": "active",
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2025-04-01 00:23:29",
"reportingPeriodEndTimestamp": "2025-04-04 00:23:29"
}
}
```
The following request code block shows how to configure a charge summary report for `entityType` = PE.
```json
{
"entityType": "PE",
"entityIds": [
"997946715419"
],
"reportSections": [
{
"sectionReportTypeName": "Consumer Profile Overview",
"sectionTitle": "Consumer Profile Details",
"sectionReportTypeId": "3019",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "CPM-001"
},
{
"alias": "Profile ID",
"reportAttributeName": "Profile ID",
"aggregateOperationText": "max"
},
{
"alias": "Processor Profile ID ",
"reportAttributeName": "JPMC Consumer Profile ID"
},
{
"alias": "First Name ",
"reportAttributeName": "First Name by Payment Method"
},
{
"alias": "Last Name",
"reportAttributeName": "Last Name by Payment Method"
},
{
"alias": "Email Address",
"reportAttributeName": "Profile Email Address"
},
{
"reportAttributeName": "Phone Number"
},
{
"reportAttributeName": "Address Line 1"
},
{
"reportAttributeName": "Address Line 2"
},
{
"alias": "Address Postal Code",
"reportAttributeName": "Postal code"
},
{
"alias": "Address Country Code",
"reportAttributeName": "Country Code"
},
{
"reportAttributeName": "Profile Status"
},
{
"alias": "Payment Method ID",
"reportAttributeName": "Default Payment Method ID "
},
{
"alias": "Payment Method Status",
"reportAttributeName": "Account Status Code"
},
{
"alias": "Payment Method Type",
"reportAttributeName": "Default Payment Method Type"
},
{
"alias": "Payment Method Name",
"reportAttributeName": "Default Payment Method Name"
},
{
"alias": "Payment Method Code",
"reportAttributeName": "Default Payment Method Code"
},
{
"alias": "Payment Method (Last 4 Digit Card)",
"reportAttributeName": "Deault AccountNumber(Last 4 Digits)"
},
{
"alias": "Card Expiration Date",
"reportAttributeName": "Default Card Expiration Date"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Account Status Code",
"filterAttributeCode": "is not null"
}
]
}
],
"fileDelimiter": ",",
"reportConfigurationName": "Consumer Profile Report",
"reportFileName": "CPM-001....",
"reportHeader": "ProcessingEntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=",
"fileHeader": "BEGIN,ProcessingEntityId=,Frequency=",
"fileTrailer": "END,ProcessingEntityId=,Frequency=",
"csvColumnNameDisplayIndicator": true,
"totalRowCountDisplayIndicator": false,
"sectionRowCountDisplayIndicator": false,
"reportConfigStatus": "active",
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2025-04-01 00:23:29",
"reportingPeriodEndTimestamp": "2025-04-04 00:23:29"
}
}
```
#### Deposit details report configuration
The following request code block shows how to configure a deposit details report for `entityType` = CO/BU/TD. Download the sample [Deposit details report](https://raw.githubusercontent.com/jpmorgan-payments/online-payments/refs/heads/main/docs/reporting/Deposit%20Details%20Preset%20Report.csv).
```json
{
"entityType": "CO",
"entityIds": [
"1234567"
],
"reportSections": [
{
"sectionReportTypeName": "Submission Details",
"sectionReportTypeId": "3003",
"sectionSelectedFields": [
{
"reportAttributeName": "Submission Date"
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "Transaction Division External Identifier"
},
{
"reportAttributeName": "Payment Method Code"
},
{
"reportAttributeName": "Merchant Order Number"
},
{
"reportAttributeName": "Account Number"
},
{
"reportAttributeName": "Credit Card Expiration Year Month Number"
},
{
"alias": "Transaction Amount in Presentment Currency",
"reportAttributeName": "Presentment Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Code",
"aggregateConditionText": "IN(\"SALE\",\"REF\")"
}
]
},
{
"reportAttributeName": "Merchant Action Code"
},
{
"reportAttributeName": "Action Type Code Text"
},
{
"reportAttributeName": "Authorization Date"
},
{
"reportAttributeName": "Country of Issuance"
},
{
"reportAttributeName": "Transaction Type Code"
},
{
"reportAttributeName": "Transaction Type Text"
},
{
"reportAttributeName": "Merchant Category Code"
},
{
"reportAttributeName": "Digital Token Method Code"
},
{
"reportAttributeName": "Digital Wallet Brand"
},
{
"alias": "Interchange Qualification Code",
"reportAttributeName": "Interchange Qualification Code",
"aggregateOperationText": "max",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Fee Text",
"aggregateConditionText": "IN(\"Interchange\")"
}
]
},
{
"alias": "Interchange Unit Fee",
"reportAttributeName": "Unit Fee Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Fee Text",
"aggregateConditionText": "IN(\"Interchange\")"
}
]
},
{
"alias": "Fee Rate",
"reportAttributeName": "Fee Rate",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Fee Text",
"aggregateConditionText": "IN(\"Interchange\")"
}
]
},
{
"alias": "Total Interchange Amount",
"reportAttributeName": "Raw Settled Total Fee Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Code",
"aggregateConditionText": "IN(\"IA\")"
},
{
"aggregateConditionAttributeName": "Charge Subcategory Text",
"aggregateConditionText": "IN(\"Interchange Fees\")"
}
]
},
{
"alias": "Total Assessment Amount",
"reportAttributeName": "Raw Settled Total Fee Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Code",
"aggregateConditionText": "IN(\"IA\")"
},
{
"aggregateConditionAttributeName": "Charge Subcategory Text",
"aggregateConditionText": "IN (\"Assessment Fees\")"
}
]
},
{
"alias": "Other Debit Passthrough Fees",
"reportAttributeName": "Raw Settled Total Fee Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Code",
"aggregateConditionText": "IN(\"PFEE\")"
},
{
"aggregateConditionAttributeName": "Charge Subcategory Text",
"aggregateConditionText": "IN(\"Debit Pass Thru Fees\")"
}
]
},
{
"reportAttributeName": "Merchant Information Description"
},
{
"reportAttributeName": "Surcharge Amount"
},
{
"reportAttributeName": "Bank Sort Code"
},
{
"reportAttributeName": "Card Usage Type"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Submission Date",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Transaction Division External Identifier",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Payment Method Code",
"sortOrderCode": "desc"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Online Submission Indicator",
"filterAttributeCode": "=\"N\""
},
{
"reportAttributeName": "Merchant Action Text",
"filterAttributeCode": "=\"DEPOSITS\""
},
{
"reportAttributeName": "Transaction Type Text",
"filterAttributeCode": "!=\"Rejects\""
},
{
"reportAttributeName": "Transaction Deposit Indicator",
"filterAttributeCode": "=\"Y\""
},
{
"reportAttributeName": "Merchant Order Number",
"filterAttributeCode": "!=\"NULL\""
}
]
}
],
"fileDelimiter": ",",
"reportConfigurationName": "Deposit Detail Report",
"reportFileName": "Deposit Detail Report....",
"reportHeader": EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=",
"fileHeader": "BEGIN,EntityId=,Frequency=",
"fileTrailer": "END,EntityId=,Frequency=",
"csvColumnNameDisplayIndicator": true,
"reportConfigStatus": "active",
"reportName": "Deposit Detail 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 a deposit details report for `entityType` = PE.
```json
{
"entityType": "PE",
"entityIds": [
"1234567"
],
"reportSections": [
{
"sectionReportTypeName": "Submission Details",
"sectionReportTypeId": "3003",
"sectionSelectedFields": [
{
"reportAttributeName": "Submission Date"
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "Transaction Processing Entity Identifier"
},
{
"reportAttributeName": "Payment Method Code"
},
{
"reportAttributeName": "Merchant Order Number"
},
{
"reportAttributeName": "Account Number"
},
{
"reportAttributeName": "Credit Card Expiration Year Month Number"
},
{
"alias": "Transaction Amount in Presentment Currency",
"reportAttributeName": "Presentment Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Code",
"aggregateConditionText": "IN(\"SALE\",\"REF\")"
}
]
},
{
"reportAttributeName": "Merchant Action Code"
},
{
"reportAttributeName": "Action Type Code Text"
},
{
"reportAttributeName": "Authorization Date"
},
{
"reportAttributeName": "Country of Issuance"
},
{
"reportAttributeName": "Transaction Type Code"
},
{
"reportAttributeName": "Transaction Type Text"
},
{
"reportAttributeName": "Merchant Category Code"
},
{
"reportAttributeName": "Digital Token Method Code"
},
{
"reportAttributeName": "Digital Wallet Brand"
},
{
"alias": "Interchange Qualification Code",
"reportAttributeName": "Interchange Qualification Code",
"aggregateOperationText": "max",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Fee Text",
"aggregateConditionText": "IN(\"Interchange\")"
}
]
},
{
"alias": "Interchange Unit Fee",
"reportAttributeName": "Unit Fee Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Fee Text",
"aggregateConditionText": "IN(\"Interchange\")"
}
]
},
{
"alias": "Interchange Face Value % Fee",
"reportAttributeName": "Fee Rate",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Fee Text",
"aggregateConditionText": "IN(\"Interchange\")"
}
]
},
{
"alias": "Total Interchange Amount",
"reportAttributeName": "Raw Settled Total Fee Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Code",
"aggregateConditionText": "IN(\"IA\")"
},
{
"aggregateConditionAttributeName": "Charge Subcategory Text",
"aggregateConditionText": "IN(\"Interchange Fees\")"
}
]
},
{
"alias": "Total Assessment Amount",
"reportAttributeName": "Raw Settled Total Fee Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Code",
"aggregateConditionText": "IN(\"IA\")"
},
{
"aggregateConditionAttributeName": "Charge Subcategory Text",
"aggregateConditionText": "IN (\"Assessment Fees\")"
}
]
},
{
"alias": "Other Debit Passthrough Fees",
"reportAttributeName": "Raw Settled Total Fee Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Code",
"aggregateConditionText": "IN(\"PFEE\")"
},
{
"aggregateConditionAttributeName": "Charge Subcategory Text",
"aggregateConditionText": "IN(\"Debit Pass Thru Fees\")"
}
]
},
{
"reportAttributeName": "Merchant Information Description"
},
{
"reportAttributeName": "Surcharge Amount"
},
{
"reportAttributeName": "Bank Sort Code"
},
{
"reportAttributeName": "Card Usage Type"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Submission Date",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Transaction Processing Entity Identifier",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Payment Method Code",
"sortOrderCode": "desc"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Online Submission Indicator",
"filterAttributeCode": "=\"N\""
},
{
"reportAttributeName": "Merchant Action Text",
"filterAttributeCode": "=\"DEPOSITS\""
},
{
"reportAttributeName": "Transaction Type Text",
"filterAttributeCode": "!=\"Rejects\""
},
{
"reportAttributeName": "Transaction Deposit Indicator",
"filterAttributeCode": "=\"Y\""
},
{
"reportAttributeName": "Merchant Order Number",
"filterAttributeCode": "!=\"NULL\""
}
]
}
],
"fileDelimiter": ",",
"reportConfigurationName": "Deposit Detail Report",
"reportFileName": "Deposit Detail Report....",
"reportHeader": EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=",
"fileHeader": "BEGIN,EntityId=,Frequency=",
"fileTrailer": "END,EntityId=,Frequency=",
"csvColumnNameDisplayIndicator": true,
"reportConfigStatus": "active",
"reportName": "Deposit Detail Report",
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2024-05-06 11:30:00",
"reportingPeriodEndTimestamp": "2024-05-07 02:00:00"
}
}
```
#### Deposit activity summary report
The following request code block shows how to configure a deposit activity summary report for `entityType` = CO/BU/TD. Download the sample [Deposit activity summary report](https://raw.githubusercontent.com/jpmorgan-payments/online-payments/refs/heads/main/docs/reporting/Deposit%20Activity%20Summary%20Preset%20Report.csv).
```json
{
"entityType": "CO",
"entityIds": [
"1234567"
],
"reportSections": [
{
"sectionTitle": "Conveyed Deposit Summary",
"sectionReportTypeName": "Submission Details",
"sectionReportTypeId": "3003",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "Conveyed Deposit Summary"
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "Payment Method Code"
},
{
"alias": "Conveyed Sales Count",
"reportAttributeName": "Transaction Count",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "IN(\"Conveyed Sales\")"
}
]
},
{
"alias": "Conveyed Sales Amount",
"reportAttributeName": "Presentment Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "IN(\"Conveyed Sales\")"
}
]
},
{
"alias": "Conveyed Refund Count",
"reportAttributeName": "Transaction Count",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "IN(\"Conveyed Refunds\")"
}
]
},
{
"alias": "Conveyed Refund Amount",
"reportAttributeName": "Presentment Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "IN(\"Conveyed Refunds\")"
}
]
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Charge Category Text",
"filterAttributeCode": "IN (\"Conveyed Sales\",\"Conveyed Refunds\")"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Payment Method Code",
"sortOrderCode": "desc"
},
{
"reportAttributeName": "Presentment Currency Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Settlement Currency Code",
"sortOrderCode": "asc"
}
]
},
{
"sectionTitle": "Settled Deposit Summary",
"sectionReportTypeName": "Submission Details",
"sectionReportTypeId": "3003",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "Settled Deposit Summary"
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "Payment Method Code"
},
{
"alias": "Settled Sales Count",
"reportAttributeName": "Transaction Count",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "IN(\"Settled Sales\")"
}
]
},
{
"alias": "Settled Sales Amount in Presentment Currency",
"reportAttributeName": "Presentment Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Settled Conveyed Code",
"aggregateConditionText": "IN(\"S\")"
},
{
"aggregateConditionAttributeName": "Charge Category Code",
"aggregateConditionText": "IN(\"SALE\")"
}
]
},
{
"alias": "Settled Sales Amount in Settlement Currency",
"reportAttributeName": "Settlement Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Settled Conveyed Code",
"aggregateConditionText": "IN(\"S\")"
},
{
"aggregateConditionAttributeName": "Charge Category Code",
"aggregateConditionText": "IN(\"SALE\")"
}
]
},
{
"alias": "Settled Refund Count",
"reportAttributeName": "Transaction Count",
"aggregateOperationText": "count",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Settled Conveyed Code",
"aggregateConditionText": "IN(\"S\")"
},
{
"aggregateConditionAttributeName": "Charge Category Code",
"aggregateConditionText": "IN(\"REF\")"
}
]
},
{
"alias": "Settled Refund Amount in Presentment Currency",
"reportAttributeName": "Presentment Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Settled Conveyed Code",
"aggregateConditionText": "IN(\"S\")"
},
{
"aggregateConditionAttributeName": "Charge Category Code",
"aggregateConditionText": "IN(\"REF\")"
}
]
},
{
"alias": "Settled Refund Amount in Settlement Currency",
"reportAttributeName": "Settlement Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Settled Conveyed Code",
"aggregateConditionText": "IN(\"S\")"
},
{
"aggregateConditionAttributeName": "Charge Category Code",
"aggregateConditionText": "IN(\"REF\")"
}
]
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Charge Category Text",
"filterAttributeCode": "IN (\"Settled Sales\",\"Settled Refunds\")"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Payment Method Code",
"sortOrderCode": "desc"
},
{
"reportAttributeName": "Presentment Currency Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Settlement Currency Code",
"sortOrderCode": "asc"
}
]
},
{
"sectionTitle": "Fees & Adjustments Summary",
"sectionReportTypeName": "Submission Details",
"sectionReportTypeId": "3003",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "Fees & Adjustments Summary"
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "Settlement Amount",
"alias": "Net Settled Deposits Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Code",
"aggregateConditionText": "IN (\"SALE\",\"REF\")"
},
{
"aggregateConditionAttributeName": "Settled Conveyed Code",
"aggregateConditionText": "IN (\"S\")"
}
]
},
{
"reportAttributeName": "Settled Total Fee Amount",
"alias": "Interchange & Assessment Fees",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "IN (\"Interchange & Assessment Fees\")"
}
]
},
{
"reportAttributeName": "Settled Total Fee Amount",
"alias": "Processing Fees",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "IN (\"Processing Fees\")"
}
]
},
{
"reportAttributeName": "Settled Total Fee Amount",
"alias": "Chargeback Adjustments",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "IN (\"Chargeback Adjustments\")"
}
]
},
{
"reportAttributeName": "Settled Total Fee Amount",
"alias": "Other Fees & Adjustments",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "NOT IN (\"Settled Sales\",\"Settled Refunds\",\"Conveyed Sales\",\"Conveyed Refunds\",\"Interchange & Assessment Fees\",\"Chargeback Adjustments\",\"Processing Fees\")"
}
]
},
{
"reportAttributeName": "Settled Total Fee Amount",
"alias": "Net Financial Activity",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "NOT IN (\"Conveyed Sales\",\"Conveyed Refunds\")"
}
]
},
{
"reportAttributeName": "Foreign Exchange Rate"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Charge Category Text",
"filterAttributeCode": "Not IN (\"Conveyed Sales\",\"Conveyed Refunds\")"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Presentment Currency Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Settlement Currency Code",
"sortOrderCode": "asc"
}
]
},
{
"sectionTitle": "Deposit Transfer Summary",
"sectionReportTypeName": "Settlement Summary",
"sectionReportTypeId": "3005",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "Deposit Transfer Summary"
},
{
"reportAttributeName": "Activity Date"
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "Funds Transfer Category Description"
},
{
"reportAttributeName": "Fund Transfer Instruction Number"
},
{
"reportAttributeName": "Fund Transfer Identifier"
},
{
"reportAttributeName": "Merchant Activity Date Range"
},
{
"reportAttributeName": "Fund Transfer Effective Date"
},
{
"alias": "Funds Transfer Amount",
"reportAttributeName": "Funds Transfer Category Amount",
"aggregateOperationText": "sum"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Activity Date",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Funds Transfer Category Description",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Fund Transfer Effective Date",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Fund Transfer Identifier",
"sortOrderCode": "asc"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Category Code",
"filterAttributeCode": "NOT IN (\"OTHER\")"
},
{
"reportAttributeName": "Funds Transfer Category Amount",
"filterAttributeCode": "!=0.0"
},
{
"reportAttributeName": "Settled Conveyed Code",
"filterAttributeCode": "IN (\"S\")"
}
]
}
],
"fileDelimiter": ",",
"reportConfigurationName": "Deposit Activity Summary Report",
"reportFileName": "Deposit ACtivity Summary Report....",
"reportHeader": "EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=",
"fileHeader": "BEGIN,EntityId=,Frequency=",
"fileTrailer": "END,EntityId=,Frequency=",
"reportName": "Deposit Activity Summary Report",
"csvColumnNameDisplayIndicator": true,
"reportConfigStatus": "active",
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2024-07-24 02:00:00",
"reportingPeriodEndTimestamp": "2024-07-25 01:59:59"
}
}
```
The following request code block shows how to configure a deposit activity summary report for `entityType` = PE.
```json
{
"entityType": "PE",
"entityIds": [
"1234567"
],
"reportSections": [
{
"sectionTitle": "Conveyed Deposit Summary",
"sectionReportTypeName": "Submission Details",
"sectionReportTypeId": "3003",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "Conveyed Deposit Summary"
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "Payment Method Code"
},
{
"alias": "Conveyed Sales Count",
"reportAttributeName": "Transaction Count",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "IN(\"Conveyed Sales\")"
}
]
},
{
"alias": "Conveyed Sales Amount",
"reportAttributeName": "Presentment Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "IN(\"Conveyed Sales\")"
}
]
},
{
"alias": "Conveyed Refund Count",
"reportAttributeName": "Transaction Count",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "IN(\"Conveyed Refunds\")"
}
]
},
{
"alias": "Conveyed Refund Amount",
"reportAttributeName": "Presentment Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "IN(\"Conveyed Refunds\")"
}
]
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Charge Category Text",
"filterAttributeCode": "IN (\"Conveyed Sales\",\"Conveyed Refunds\")"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Payment Method Code",
"sortOrderCode": "desc"
},
{
"reportAttributeName": "Presentment Currency Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Settlement Currency Code",
"sortOrderCode": "asc"
}
]
},
{
"sectionTitle": "Settled Deposit Summary",
"sectionReportTypeName": "Submission Details",
"sectionReportTypeId": "3003",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "Settled Deposit Summary"
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "Payment Method Code"
},
{
"alias": "Settled Sales Count",
"reportAttributeName": "Transaction Count",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "IN(\"Settled Sales\")"
}
]
},
{
"alias": "Settled Sales Amount in Presentment Currency",
"reportAttributeName": "Presentment Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Settled Conveyed Code",
"aggregateConditionText": "IN(\"S\")"
},
{
"aggregateConditionAttributeName": "Charge Category Code",
"aggregateConditionText": "IN(\"SALE\")"
}
]
},
{
"alias": "Settled Sales Amount in Settlement Currency",
"reportAttributeName": "Settlement Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Settled Conveyed Code",
"aggregateConditionText": "IN(\"S\")"
},
{
"aggregateConditionAttributeName": "Charge Category Code",
"aggregateConditionText": "IN(\"SALE\")"
}
]
},
{
"alias": "Settled Refund Count",
"reportAttributeName": "Transaction Count",
"aggregateOperationText": "count",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Settled Conveyed Code",
"aggregateConditionText": "IN(\"S\")"
},
{
"aggregateConditionAttributeName": "Charge Category Code",
"aggregateConditionText": "IN(\"REF\")"
}
]
},
{
"alias": "Settled Refund Amount in Presentment Currency",
"reportAttributeName": "Presentment Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Settled Conveyed Code",
"aggregateConditionText": "IN(\"S\")"
},
{
"aggregateConditionAttributeName": "Charge Category Code",
"aggregateConditionText": "IN(\"REF\")"
}
]
},
{
"alias": "Settled Refund Amount in Settlement Currency",
"reportAttributeName": "Settlement Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Settled Conveyed Code",
"aggregateConditionText": "IN(\"S\")"
},
{
"aggregateConditionAttributeName": "Charge Category Code",
"aggregateConditionText": "IN(\"REF\")"
}
]
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Charge Category Text",
"filterAttributeCode": "IN (\"Settled Sales\",\"Settled Refunds\")"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Payment Method Code",
"sortOrderCode": "desc"
},
{
"reportAttributeName": "Presentment Currency Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Settlement Currency Code",
"sortOrderCode": "asc"
}
]
},
{
"sectionTitle": "Fees & Adjustments Summary",
"sectionReportTypeName": "Submission Details",
"sectionReportTypeId": "3003",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "Fees & Adjustments Summary"
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "Settlement Amount",
"alias": "Net Settled Deposits Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Code",
"aggregateConditionText": "IN (\"SALE\",\"REF\")"
},
{
"aggregateConditionAttributeName": "Settled Conveyed Code",
"aggregateConditionText": "IN (\"S\")"
}
]
},
{
"reportAttributeName": "Settled Total Fee Amount",
"alias": "Interchange & Assessment Fees",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "IN (\"Interchange & Assessment Fees\")"
}
]
},
{
"reportAttributeName": "Settled Total Fee Amount",
"alias": "Processing Fees",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "IN (\"Processing Fees\")"
}
]
},
{
"reportAttributeName": "Settled Total Fee Amount",
"alias": "Chargeback Adjustments",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "IN (\"Chargeback Adjustments\")"
}
]
},
{
"reportAttributeName": "Settled Total Fee Amount",
"alias": "Other Fees & Adjustments",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "NOT IN (\"Settled Sales\",\"Settled Refunds\",\"Conveyed Sales\",\"Conveyed Refunds\",\"Interchange & Assessment Fees\",\"Chargeback Adjustments\",\"Processing Fees\")"
}
]
},
{
"reportAttributeName": "Settled Total Fee Amount",
"alias": "Net Financial Activity",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "NOT IN (\"Conveyed Sales\",\"Conveyed Refunds\")"
}
]
},
{
"reportAttributeName": "Foreign Exchange Rate"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Charge Category Text",
"filterAttributeCode": "Not IN (\"Conveyed Sales\",\"Conveyed Refunds\")"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Presentment Currency Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Settlement Currency Code",
"sortOrderCode": "asc"
}
]
},
{
"sectionTitle": "Deposit Transfer Summary",
"sectionReportTypeName": "Settlement Summary",
"sectionReportTypeId": "3005",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "Deposit Transfer Summary"
},
{
"reportAttributeName": "Activity Date"
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "Funds Transfer Category Description"
},
{
"reportAttributeName": "Fund Transfer Instruction Number"
},
{
"reportAttributeName": "Fund Transfer Identifier"
},
{
"reportAttributeName": "Merchant Activity Date Range"
},
{
"reportAttributeName": "Fund Transfer Effective Date"
},
{
"alias": "Fund Transfer Amount",
"reportAttributeName": "Funds Transfer Category Amount",
"aggregateOperationText": "sum"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Activity Date",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Funds Transfer Category Description",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Fund Transfer Effective Date",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Fund Transfer Identifier",
"sortOrderCode": "asc"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Category Code",
"filterAttributeCode": "NOT IN (\"OTHER\")"
},
{
"reportAttributeName": "Funds Transfer Category Amount",
"filterAttributeCode": "!=0.0"
},
{
"reportAttributeName": "Settled Conveyed Code",
"filterAttributeCode": "IN (\"S\")"
}
]
}
],
"fileDelimiter": ",",
"reportConfigurationName": "Deposit Activity Summary Report",
"reportFileName": "Deposit ACtivity Summary Report....",
"reportHeader": EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=",
"fileHeader": "BEGIN,EntityId=,Frequency=",
"fileTrailer": "END,EntityId=,Frequency=",
"reportName": "Deposit Activity Summary Report",
"csvColumnNameDisplayIndicator": true,
"reportConfigStatus": "active",
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2024-07-24 02:00:00",
"reportingPeriodEndTimestamp": "2024-07-25 01:59:59"
}
}
```
#### Dispute details report
The following request code block shows how to configure a dispute details report for `entityType` = CO/BU/TD. Download the sample [Dispute details report](https://raw.githubusercontent.com/jpmorgan-payments/online-payments/refs/heads/main/docs/reporting/Dispute%20Details%20Preset%20Report.csv).
```json
{
"entityType": "CO",
"entityIds": [
"1234567"
],
"reportSections": [
{
"sectionReportTypeName": "Dispute Details v2",
"sectionReportTypeId": "3017",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "DisputeSummary"
},
{
"reportAttributeName": "Transaction Division External Identifier"
},
{
"alias": "Dispute Type Code",
"reportAttributeName": "Post Deposit Event Dispute Type Code"
},
{
"alias": "Category",
"reportAttributeName": "Dispute Category Code"
},
{
"reportAttributeName": "Financial Non-Financial Code"
},
{
"alias": "Count",
"reportAttributeName": "Record Count",
"aggregateOperationText": "sum"
},
{
"alias": "Presentment Currency Amount",
"reportAttributeName": "Post Deposit Event Action Presentment Currency Amount",
"aggregateOperationText": "sum"
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"alias": "Settlement Currency Amount",
"reportAttributeName": "Post Deposit Event Action Settlement Currency Amount",
"aggregateOperationText": "sum"
},
{
"reportAttributeName": "Settlement Currency Code"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Post Deposit Event Dispute Type Code",
"filterAttributeCode": "IN (\"CB\",\"ECP\",\"AJ\")" },
{
"reportAttributeName": "Dispute Category Code",
"filterAttributeCode": "IN (\"BEGINV\",\"RECD\",\"REPR\",\"PARREP\",\"OPAACCEPT\",\"RECRS\",\"RTM\",\"PARRTM\",\"OPAREQ\",\"OPADENY\",\"ADJPDE\",\"ADJPAR\",\"ENDINV\")"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Transaction Division External Identifier",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Dispute Category Code",
"sortOrderCode": "asc"
}
]
},
{
"sectionReportTypeName": "Dispute Details v2",
"sectionReportTypeId": "3017",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "DisputeDetails"
},
{
"reportAttributeName": "Transaction Division External Identifier"
},
{
"reportAttributeName": "Dispute Transaction Sequence Number"
},
{
"alias": "Dispute Type Code",
"reportAttributeName": "Post Deposit Event Dispute Type Code"
},
{
"alias": "Category",
"reportAttributeName": "Dispute Category Code"
},
{
"reportAttributeName": "Issuer Dispute Presentment Currency Amount"
},
{
"alias": "Current Action Presentment Currency Amount",
"reportAttributeName": "Post Deposit Event Action Presentment Currency Amount"
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Merchant Order Number"
},
{
"reportAttributeName": "Account Number"
},
{
"reportAttributeName": "Consumer Name"
},
{
"reportAttributeName": "Payment Method Code"
},
{
"reportAttributeName": "Payment Brand Dispute Reason Code"
},
{
"reportAttributeName": "Payment Brand Dispute Reason Text"
},
{
"reportAttributeName": "ECP Reason Category Classification"
},
{
"reportAttributeName": "ECP Reason Category Classification Text"
},
{
"reportAttributeName": "Transaction Date"
},
{
"reportAttributeName": "Dispute Initiate Date"
},
{
"alias": "Activity Date",
"reportAttributeName": "Dispute Activity Date"
},
{
"reportAttributeName": "Dispute Due Date"
},
{
"reportAttributeName": "Dispute Usage Code"
},
{
"reportAttributeName": "Accountholder Authorization Method"
},
{
"reportAttributeName": "Accountholder Authorization Method Text"
},
{
"reportAttributeName": "Acquirer Reference Number"
},
{
"reportAttributeName": "Issuer Dispute Settlement Currency Amount"
},
{
"alias": "Current Action Settlement Currency Amount",
"reportAttributeName": "Post Deposit Event Action Settlement Currency Amount"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "Authorization Date"
},
{
"reportAttributeName": "Action Code"
},
{
"reportAttributeName": "Cardholder Debit Credit Indicator"
},
{
"reportAttributeName": "Adjustment Number"
},
{
"reportAttributeName": "Ticket Number"
},
{
"reportAttributeName": "Status Flag Code"
},
{
"reportAttributeName": "Digital Token Method Code"
},
{
"reportAttributeName": "Potential Bundled Chargebacks Indicator"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Post Deposit Event Dispute Type Code",
"filterAttributeCode": "IN (\"CB\",\"ECP\",\"AJ\")"
},
{
"reportAttributeName": "Dispute Category Code",
"filterAttributeCode": "IN (\"RECD\",\"REPR\",\"PARREP\",\"OPAACCEPT\",\"RECRS\",\"RTM\",\"PARRTM\",\"OPAREQ\",\"OPADENY\",\"ADJPDE\",\"ENDINV\")"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Transaction Division External Identifier",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Dispute Category Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Dispute Transaction Sequence Number",
"sortOrderCode": "asc"
}
]
}
],
"fileDelimiter": ",",
"reportConfigurationName": "Dispute Details Report",
"reportFileName": "Dispute Details....",
"reportHeader": "EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=",
"fileHeader": "BEGIN,EntityId=,Frequency=",
"fileTrailer": "END,EntityId=,Frequency=",
"csvColumnNameDisplayIndicator": true,
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2024-06-03 00:00:00",
"reportingPeriodEndTimestamp": "2024-06-04 00:00:00"
}
}
```
The following request code block shows how to configure a dispute details report for `entityType` = PE.
```json
{
"entityType": "PE",
"entityIds": [
"1234567"
],
"reportSections": [
{
"sectionReportTypeName": "Dispute Details v2",
"sectionReportTypeId": "3017",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "DisputeSummary"
},
{
"reportAttributeName": "Transaction Processing Entity Identifier"
},
{
"alias": "Dispute Type Code",
"reportAttributeName": "Post Deposit Event Dispute Type Code"
},
{
"alias": "Category",
"reportAttributeName": "Dispute Category Code"
},
{
"reportAttributeName": "Financial Non-Financial Code"
},
{
"alias": "Count",
"reportAttributeName": "Record Count",
"aggregateOperationText": "sum"
},
{
"alias": "Presentment Currency Amount",
"reportAttributeName": "Post Deposit Event Action Presentment Currency Amount",
"aggregateOperationText": "sum"
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"alias": "Settlement Currency Amount",
"reportAttributeName": "Post Deposit Event Action Settlement Currency Amount",
"aggregateOperationText": "sum"
},
{
"reportAttributeName": "Settlement Currency Code"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Post Deposit Event Dispute Type Code",
"filterAttributeCode": "IN (\"CB\",\"ECP\",\"AJ\")" },
{
"reportAttributeName": "Dispute Category Code",
"filterAttributeCode": "IN (\"BEGINV\",\"RECD\",\"REPR\",\"PARREP\",\"OPAACCEPT\",\"RECRS\",\"RTM\",\"PARRTM\",\"OPAREQ\",\"OPADENY\",\"ADJPDE\",\"ADJPAR\",\"ENDINV\")"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Transaction Processing Entity Identifier",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Dispute Category Code",
"sortOrderCode": "asc"
}
]
},
{
"sectionReportTypeName": "Dispute Details v2",
"sectionReportTypeId": "3017",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "DisputeDetails"
},
{
"reportAttributeName": "Transaction Processing Entity Identifier"
},
{
"reportAttributeName": "Dispute Transaction Sequence Number"
},
{
"alias": "Dispute Type Code",
"reportAttributeName": "Post Deposit Event Dispute Type Code"
},
{
"alias": "Category",
"reportAttributeName": "Dispute Category Code"
},
{
"reportAttributeName": "Issuer Dispute Presentment Currency Amount"
},
{
"alias": "Current Action Presentment Currency Amount",
"reportAttributeName": "Post Deposit Event Action Presentment Currency Amount"
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Merchant Order Number"
},
{
"reportAttributeName": "Account Number"
},
{
"reportAttributeName": "Consumer Name"
},
{
"reportAttributeName": "Payment Method Code"
},
{
"reportAttributeName": "Payment Brand Dispute Reason Code"
},
{
"reportAttributeName": "Payment Brand Dispute Reason Text"
},
{
"reportAttributeName": "ECP Reason Category Classification"
},
{
"reportAttributeName": "ECP Reason Category Classification Text"
},
{
"reportAttributeName": "Transaction Date"
},
{
"reportAttributeName": "Dispute Initiate Date"
},
{
"alias": "Activity Date",
"reportAttributeName": "Dispute Activity Date"
},
{
"reportAttributeName": "Dispute Due Date"
},
{
"reportAttributeName": "Dispute Usage Code"
},
{
"reportAttributeName": "Accountholder Authorization Method"
},
{
"reportAttributeName": "Accountholder Authorization Method Text"
},
{
"reportAttributeName": "Acquirer Reference Number"
},
{
"reportAttributeName": "Issuer Dispute Settlement Currency Amount"
},
{
"alias": "Current Action Settlement Currency Amount",
"reportAttributeName": "Post Deposit Event Action Settlement Currency Amount"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "Authorization Date"
},
{
"reportAttributeName": "Action Code"
},
{
"reportAttributeName": "Cardholder Debit Credit Indicator"
},
{
"reportAttributeName": "Adjustment Number"
},
{
"reportAttributeName": "Ticket Number"
},
{
"reportAttributeName": "Status Flag Code"
},
{
"reportAttributeName": "Digital Token Method Code"
},
{
"reportAttributeName": "Potential Bundled Chargebacks Indicator"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Post Deposit Event Dispute Type Code",
"filterAttributeCode": "IN (\"CB\",\"ECP\",\"AJ\")"
},
{
"reportAttributeName": "Dispute Category Code",
"filterAttributeCode": "IN (\"RECD\",\"REPR\",\"PARREP\",\"OPAACCEPT\",\"RECRS\",\"RTM\",\"PARRTM\",\"OPAREQ\",\"OPADENY\",\"ADJPDE\",\"ENDINV\")"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Transaction Processing Entity Identifier",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Dispute Category Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Dispute Transaction Sequence Number",
"sortOrderCode": "asc"
}
]
}
],
"fileDelimiter": ",",
"reportConfigurationName": "Dispute Details Report",
"reportFileName": "Dispute Details....",
"reportHeader": "EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=",
"fileHeader": "BEGIN,EntityId=,Frequency=",
"fileTrailer": "END,EntityId=,Frequency=",
"csvColumnNameDisplayIndicator": true,
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2024-06-03 00:00:00",
"reportingPeriodEndTimestamp": "2024-06-04 00:00:00"
}
}
```
#### Exception report
The following request code block shows how to configure an exception report for `entityType` = CO/BU/TD. Download the sample [Exception report](https://raw.githubusercontent.com/jpmorgan-payments/online-payments/refs/heads/main/docs/reporting/Exception%20Details%20Preset%20Report.csv).
```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"
}
}
```
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"
}
}
```
#### Financial activity summary report
The following request code block shows how to configure a financial activity summary report for `entityType` = CO/BU/TD. Download the sample [Financial activity summary report](https://raw.githubusercontent.com/jpmorgan-payments/online-payments/refs/heads/main/docs/reporting/Financial%20Activity%20Summary%20Preset%20Report.csv).
```json
{
"entityType": "CO",
"entityIds": [
"557165"
],
"reportSections": [
{
"sectionTitle": "Financial Activity Summary",
"sectionReportTypeName": "Financial Activity Summary",
"sectionReportTypeId": "3021",
"sectionSelectedFields": [
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "Activity EDT Date",
"alias": "Reporting Date"
},
{
"reportAttributeName": "Net Conveyed Deposits",
"alias": "Net Conveyed Deposits",
"aggregateOperationText": "sum"
},
{
"reportAttributeName": "Net Settled Deposits",
"alias": "Net Settled Deposits",
"aggregateOperationText": "sum"
},
{
"alias": "Foreign Exchange Rate",
"reportAttributeName": "Foreign Exchange Rate"
},
{
"reportAttributeName": "Net Settled Deposit in Settlement Currency",
"alias": "Net Settled Deposits in Settlement Currency",
"aggregateOperationText": "sum"
},
{
"reportAttributeName": "Chargeback/ECP Returns/Debit Adjustments",
"alias": "Chargeback/ECPReturns/Debit Adjustments",
"aggregateOperationText": "sum"
},
{
"reportAttributeName": "Interchange & Assessment Fees",
"alias": "Interchange & Assessment Fees",
"aggregateOperationText": "sum"
},
{
"reportAttributeName": "Processing Fees",
"alias": "Processing Fees",
"aggregateOperationText": "sum"
},
{
"reportAttributeName": "Other Adjustments",
"alias": "Other Adjustments",
"aggregateOperationText": "sum"
},
{
"reportAttributeName": "Back Up Withholding Adjustments",
"alias": "Backup With Holding Adjustments",
"aggregateOperationText": "sum"
},
{
"reportAttributeName": "Reserve Adjustments",
"alias": "Reserve Adjustments",
"aggregateOperationText": "sum"
},
{
"reportAttributeName": "Net Financial Activity",
"alias": "Net Financial Activity",
"aggregateOperationText": "sum"
},
{
"reportAttributeName": "Rejected Transfers",
"alias": "Rejected Transfers",
"aggregateOperationText": "sum"
},
{
"reportAttributeName": "Pending Transfers",
"alias": "Pending Transfers",
"aggregateOperationText": "sum"
},
{
"reportAttributeName": "Effective Transfers",
"alias": "Effective Transfers",
"aggregateOperationText": "sum"
},
{
"reportAttributeName": "Daily Ending Balance"
},
{
"reportAttributeName": "Reserve Balance"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Activity EDT Date",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Presentment Currency Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Settlement Currency Code",
"sortOrderCode": "asc"
}
]
}
],
"fileDelimiter": ",",
"reportConfigurationName": "Financial Activity Summary Report",
"reportFileName": "Financial Activity Summary Report....",
"reportHeader": "EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=