# 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 details report
The following request code block shows how to configure an authorization report for `entityType` = CO/BU/TD/PE. Download the sample [Authorization details report](/system/downloads/commerce/reporting/Authorization_Details_Preset_Report.csv?type=stream).
```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": "Entity Type Code"
},
{
"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": "2026-03-24 02:00:00",
"reportingPeriodEndTimestamp": "2026-03-25 01: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](/system/downloads/commerce/reporting/Account_Updater_Preset_Report.csv?type=stream).
```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"
}
}
```
#### Billing schedule activity report
The following request code block shows how to configure a billing schedule activity report for `entityType` = CO/BU/TD/PE. Download the sample [Billing Schedule Activity report](/system/downloads/commerce/reporting/Billing_Schedule_Activity.csv?type=stream)..
```json
{
"entityType": "CO",
"entityIds": [
"1234567"
],
"reportSections": [
{
"sectionReportTypeName": "Managed Billing",
"sectionTitle": "Billing Schedule Activity Summary",
"sectionReportTypeId": "3020",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "MBR0020"
},
{
"alias": "Plan Name",
"reportAttributeName": "Merchant Recurring Plan Name"
},
{
"alias": "Plan ID",
"reportAttributeName": "Recurring Plan Identifier"
},
{
"alias": "Billing Cycle Status",
"reportAttributeName": "Billing Schedule Status Name"
},
{
"alias": "Number of Unique Profiles",
"reportAttributeName": "Consumer Profile Identifier",
"aggregateOperationText": "distinctCount"
},
{
"alias": "Number of Unique Recurring Programs",
"reportAttributeName": "Recurring Program Identifier",
"aggregateOperationText": "distinctCount"
},
{
"alias": "Currency",
"reportAttributeName": "Representment Currency Code"
},
{
"alias": "Total Billing Amount",
"reportAttributeName": "Total Billing Amount",
"aggregateOperationText": "sum"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Report Type Name",
"filterAttributeCode": "IN (\"ACTIVITY\")"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Merchant Recurring Plan Name",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Billing Schedule Status Name",
"sortOrderCode": "asc"
}
]
},
{
"sectionReportTypeName": "Managed Billing",
"sectionTitle": "Billing Schedule Activity Details",
"sectionReportTypeId": "3020",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "MBR0020"
},
{
"reportAttributeName": "Transaction Processing Entity Identifier"
},
{
"alias": "Consumer Profile ID",
"reportAttributeName": "Consumer Profile Identifier"
},
{
"alias": "Processor Profile ID",
"reportAttributeName": "Internal Consumer Profile Identifier"
},
{
"alias": "Payment Method ID",
"reportAttributeName": "Payment Method Identifier"
},
{
"reportAttributeName": "Payment Method Code"
},
{
"alias": "Payment Account Number",
"reportAttributeName": "Masked Account Number"
},
{
"alias": "Recurring Program ID",
"reportAttributeName": "Recurring Program Identifier"
},
{
"alias": "Recurring Program Description",
"reportAttributeName": "Recurring Program Description Text"
},
{
"reportAttributeName": "Merchant Order Number"
},
{
"alias": "Plan Name",
"reportAttributeName": "Merchant Recurring Plan Name"
},
{
"alias": "Plan ID",
"reportAttributeName": "Recurring Plan Identifier"
},
{
"alias": "Recurring Program Status",
"reportAttributeName": "Recurring Program Status Code"
},
{
"reportAttributeName": "Billing Cycle Sequence"
},
{
"alias": "Billing Date",
"reportAttributeName": "Current Billing Date"
},
{
"alias": "Billing Cycle Start Date",
"reportAttributeName": "Billing Period Start Date"
},
{
"alias": "Billing Cycle End Date",
"reportAttributeName": "Billing Period End Date"
},
{
"alias": "Billing Cycle Status",
"reportAttributeName": "Billing Schedule Status Name"
},
{
"alias": "Currency Code",
"reportAttributeName": "Representment Currency Code"
},
{
"alias": "Total Billing Amount",
"reportAttributeName": "Total Billing Amount"
},
{
"alias": "First Payment Attempt Date",
"reportAttributeName": "First Payment Adjustment Date"
},
{
"reportAttributeName": "Number of Retries Attempted"
},
{
"reportAttributeName": "Number of Retries Remaining"
},
{
"alias": "Latest Payment Attempt Date",
"reportAttributeName": "Last Payment Timestamp"
},
{
"alias": "Next Billing Date",
"reportAttributeName": "Billing Schedule Date"
},
{
"reportAttributeName": "Firm Authorization Response Category Code"
},
{
"reportAttributeName": "Firm Authorization Response Code"
},
{
"alias": "Firm Authorization Response Description",
"reportAttributeName": "Firm Authorization Response Code Description Text"
},
{
"alias": "Payment Brand Auth Response",
"reportAttributeName": "Authorization Response Name"
},
{
"alias": "Payment Brand Response Code Category",
"reportAttributeName": "Payment Brand Authorization Response Category Code"
},
{
"reportAttributeName": "Authorization Code"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Report Type Name",
"filterAttributeCode": "IN (\"ACTIVITY\")"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Merchant Recurring Plan Name",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Billing Schedule Status Name",
"sortOrderCode": "asc"
}
]
}
],
"fileDelimiter": ",",
"reportConfigurationName": "Billing Schedule Activity Report",
"reportFileName": "Billing Schedule Activity Report.....",
"reportHeader": ",,,,,,GenerationTime=",
"fileHeader": "BEGIN,EntityId=,Frequency=",
"fileTrailer": "END,EntityId=,Frequency=",
"csvColumnNameDisplayIndicator": true,
"reportConfigStatus": "active",
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2025-03-15 00:00:00",
"reportingPeriodEndTimestamp": "2025-04-04 00:00:00"
}
}
```
#### Charge summary report
The following request code block shows how to configure a charge summary report for `entityType` = CO/BU/TD/PE. Download the sample [Charge summary report](/system/downloads/commerce/reporting/Charge_Summary_Preset_Report.csv?type=stream).
```json
{
"entityType": "CO",
"entityIds": [
"1234567"
],
"reportSections": [
{
"sectionTitle": "Charge Summary",
"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\")",
},
{
"reportAttributeName": "Fee Text",
"filterAttributeCode": "NOT IN(\"Provincial Tax\",\"Federal Tax\",\"Sales Tax\")"
}
]
},
{
"sectionTitle": "Tax Information",
"sectionReportTypeName": "Submission Details",
"sectionReportTypeId": "3003",
"distinctSelectIndicator": true,
"sectionSelectedFields": [
{
"constantValueText": "Tax Information",
"alias": "Record Type"
},
{
"reportAttributeName": "Entity Identifier"
},
{
"reportAttributeName": "Entity Type Code",
},
{
"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\")"
},
{
"reportAttributeName": "Transaction Division External Identifier",
"filterAttributeCode": "IS NOT NULL"
}
]
}
],
"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": "2026-03-24 02:00:00",
"reportingPeriodEndTimestamp": "2026-03-25 01:59:59"
}
}
```
#### Closed batch summary report
The following request code block shows how to configure a closed batch summary report for `entityType` = CO/BU/TD/PE. Download the sample [Closed Batch Summary report](/system/downloads/commerce/reporting/Closed_Batch.xlsx?type=stream).
```json
{
"entityType": "CO",
"entityIds": [
"1234567"
],
"reportSections": [
{
"sectionTitle": "Closed Batch Summary",
"sectionReportTypeName": "Submission Details",
"sectionReportTypeId": "3003",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "CBR0010"
},
{
"alias": "Merchant ID",
"reportAttributeName": "Transaction Division External Identifier"
},
{
"alias": "Merchant Name",
"reportAttributeName": "Transaction Division Name"
},
{
"alias": "Batch ID",
"reportAttributeName": "Submission Identifier"
},
{
"alias": "Card Type",
"reportAttributeName": "Payment Method Code"
},
{
"alias": "Transaction Type",
"reportAttributeName": "Action Type Code Text"
},
{
"alias": "Transaction Description",
"reportAttributeName": "Fee Text"
},
{
"alias": "Transaction Count",
"reportAttributeName": "Action Type Code Text",
"aggregateOperationText": "count"
},
{
"alias": "Currency",
"reportAttributeName": "Presentment Currency Code"
},
{
"alias": "Net Amount",
"reportAttributeName": "Presentment Amount",
"aggregateOperationText": "sum"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Fee Text",
"filterAttributeCode": "IN (\"Settled Sales\",\"Settled Refunds\",\"Conveyed Sales\",\"Conveyed Refunds\",\"Rejected Transact\")",
"alias": "fee_text"
},
{
"reportAttributeName": "Charge Category Text",
"filterAttributeCode": "IN (\"Settled Sales\",\"Settled Refunds\",\"Conveyed Sales\",\"Conveyed Refunds\")",
"alias": "charge_cat_text"
}
],
"filterExpression": "(fee_text OR charge_cat_text)",
"sectionSortOrderList": [
{
"reportAttributeName": "Submission Identifier",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Payment Method Code",
"sortOrderCode": "asc"
}
]
},
{
"sectionTitle": "Closed Batch Details",
"sectionReportTypeName": "Submission Details",
"sectionReportTypeId": "3003",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "CBR0010"
},
{
"alias": "Merchant ID",
"reportAttributeName": "Transaction Division External Identifier"
},
{
"alias": "Merchant Name",
"reportAttributeName": "Transaction Division Name"
},
{
"alias": "Batch ID",
"reportAttributeName": "Submission Identifier"
},
{
"alias": "Card Type",
"reportAttributeName": "Payment Method Code"
},
{
"alias": "Transaction Type",
"reportAttributeName": "Action Type Code Text"
},
{
"alias": "Card Number",
"reportAttributeName": "Account Number"
},
{
"alias": "Order #",
"reportAttributeName": "Merchant Order Number"
},
{
"alias": "Resp Code",
"reportAttributeName": "Merchant Service Authorization Response Code"
},
{
"alias": "Resp Code Description",
"reportAttributeName": "PTI Authorization Response Code Description"
},
{
"alias": "Rejection Code",
"reportAttributeName": "Reject Code"
},
{
"alias": "Transaction Description",
"reportAttributeName": "Fee Text"
},
{
"alias": "Transaction DateTime",
"reportAttributeName": "Authorization Timestamp"
},
{
"alias": "Settlement DateTime",
"reportAttributeName": "Submission Timestamp"
},
{
"alias": "Customer Profile",
"reportAttributeName": "Consumer Profile ID"
},
{
"alias": "Currency",
"reportAttributeName": "Presentment Currency Code"
},
{
"alias": "Amount",
"reportAttributeName": "Presentment Amount"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Fee Text",
"filterAttributeCode": "IN (\"Settled Sales\",\"Settled Refunds\",\"Conveyed Sales\",\"Conveyed Refunds\",\"Rejected Transact\")",
"alias": "fee_text"
},
{
"reportAttributeName": "Charge Category Text",
"filterAttributeCode": "IN (\"Settled Sales\",\"Settled Refunds\",\"Conveyed Sales\",\"Conveyed Refunds\")",
"alias": "charge_cat_text"
}
],
"filterExpression": "(fee_text OR charge_cat_text)",
"sectionSortOrderList": [
{
"reportAttributeName": "Submission Identifier",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Payment Method Code",
"sortOrderCode": "asc"
}
]
}
],
"fileDelimiter": ",",
"reportConfigurationName": "Closed Batch Report",
"reportFileName": "Closed Batch Report.....",
"reportHeader": ",,,,,,GenerationTime=",
"fileHeader": "BEGIN,EntityId=,Frequency=",
"fileTrailer": "END,EntityId=,Frequency=",
"csvColumnNameDisplayIndicator": true,
"reportConfigStatus": "active",
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2025-04-03 23:59:59",
"reportingPeriodEndTimestamp": "2025-04-04 23:59:59"
}
}
```
#### 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](/system/downloads/commerce/reporting/Consumer_Profile_Overview_Preset_Report.csv?type=stream).
```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/PE. Download the sample [Deposit details report](/system/downloads/commerce/reporting/Deposit_Details_Preset_Report.csv?type=stream).
```json
{
"entityType": "CO",
"entityIds": [
"1234567"
],
"reportSections": [
{
"sectionTitle": "Deposit Details",
"sectionReportTypeName": "Submission Details",
"sectionReportTypeId": "3003",
"sectionSelectedFields": [
{
"reportAttributeName": "Entity Identifier"
},
{
"reportAttributeName": "Entity Type Code"
},
{
"reportAttributeName": "Submission Date"
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"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": "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=",
"reportName": "Deposit Detail Report",
"csvColumnNameDisplayIndicator": true,
"reportConfigStatus": "active",
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2026-03-24 02:00:00",
"reportingPeriodEndTimestamp": "2026-03-25 01:59:59"
}
}
```
#### Deposit activity summary report
The following request code block shows how to configure a deposit activity summary report for `entityType` = CO/BU/TD/PE. Download the sample [Deposit activity summary report](/system/downloads/commerce/reporting/Deposit_Activity_Summary_Preset_Report.csv?type=stream).
```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": "2026-03-24 02:00:00",
"reportingPeriodEndTimestamp": "2026-03-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/PE. Download the sample [Dispute details report](/system/downloads/commerce/reporting/Dispute_Details_Preset_Report.csv?type=stream).
```json
{
"entityType": "CO",
"entityIds": [
"1234567"
],
"reportSections": [
{
"sectionTitle": "Dispute Summary",
"sectionReportTypeName": "Dispute Details v2",
"sectionReportTypeId": "3017",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "DisputeSummary"
},
{
"reportAttributeName": "Entity Identifier"
},
{
"reportAttributeName": "Entity Type Code",
},
{
"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": "Entity Identifier",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Dispute Category Code",
"sortOrderCode": "asc"
}
]
},
{
"sectionTitle": "Dispute Details",
"sectionReportTypeName": "Dispute Details v2",
"sectionReportTypeId": "3017",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "DisputeDetails"
},
{
"reportAttributeName": "Entity Identifier"
},
{
"reportAttributeName": "Entity Type Code",
},
{
"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": "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": "2026-03-24 02:00:00",
"reportingPeriodEndTimestamp": "2026-03-25 01:59:59"
}
}
```
#### Exception report
The following request code block shows how to configure an exception report for `entityType` = CO/BU/TD/PE. Download the sample [Exception report](/system/downloads/commerce/reporting/Exception_Details_Preset_Report.csv?type=stream).
```json
{
"entityType": "CO",
"entityIds": [
"1234567"
],
"reportSections": [
{
"sectionTitle": "Transaction Summary",
"sectionReportTypeName": "Transaction Details",
"sectionReportTypeId": "3001",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "Transaction Summary"
},
{
"reportAttributeName": "Entity Identifier",
},
{
"reportAttributeName": "Entity Type Code",
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "Merchant Presenter Identifier"
},
{
"reportAttributeName": "Merchant Presenter Short Name"
},
{
"reportAttributeName": "Submission Identifier"
},
{
"reportAttributeName": "Submission Status"
},
{
"reportAttributeName": "Submission Date"
},
{
"alias": "Transaction Count",
"reportAttributeName": "Merchant Order Number",
"aggregateOperationText": "count"
},
{
"reportAttributeName": "Merchant Order Number",
"alias": "Authorization Count",
"aggregateOperationText": "count",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Merchant Action Code Text",
"aggregateConditionText": "= 'AUTHORIZATIONS'"
},
{
"aggregateConditionAttributeName": "Submission File Status",
"aggregateConditionText": "= 'RD'"
}
]
},
{
"reportAttributeName": "Merchant Order Number",
"alias": "Declined Deposit Count",
"aggregateOperationText": "count",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Exception Description",
"aggregateConditionText": "= 'Declined Deposit'"
}
]
},
{
"reportAttributeName": "Presentment Amount",
"alias": "Declined Deposit Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Exception Description",
"aggregateConditionText": "= 'Declined Deposit'"
}
]
},
{
"reportAttributeName": "Merchant Order Number",
"alias": "Rejected Transaction Count",
"aggregateOperationText": "count",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Exception Description",
"aggregateConditionText": "= 'Rejected Transaction'"
}
]
},
{
"reportAttributeName": "Presentment Amount",
"alias": "Rejected Transaction Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Exception Description",
"aggregateConditionText": "= 'Rejected Transaction'"
}
]
},
{
"reportAttributeName": "Merchant Order Number",
"alias": "Cancelled/On-Hold Deposit Count",
"aggregateOperationText": "count",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Exception Description",
"aggregateConditionText": "= 'Cancels/OnHold'"
}
]
},
{
"reportAttributeName": "Presentment Amount",
"alias": "Cancelled/On-Hold Net Deposit Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Exception Description",
"aggregateConditionText": "= 'Cancels/OnHold'"
}
]
},
{
"reportAttributeName": "Merchant Order Number",
"alias": "Successful Deposit Count",
"aggregateOperationText": "count",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Transaction Deposit Indicator",
"aggregateConditionText": "= 'Y'"
},
{
"aggregateConditionAttributeName": "Submission File Status",
"aggregateConditionText": "= 'RD'"
}
]
},
{
"reportAttributeName": "Presentment Amount",
"alias": "Successful Net Deposit Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Transaction Deposit Indicator",
"aggregateConditionText": "= 'Y'"
},
{
"aggregateConditionAttributeName": "Submission File Status",
"aggregateConditionText": "= 'RD'"
}
]
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Presentment Currency Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Settlement Currency Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Merchant Presenter Identifier",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Submission Identifier",
"sortOrderCode": "asc"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Merchant Action Code Text",
"filterAttributeCode": "NOT IN (\"EXCLUDE FROM REPORTING\")"
},
{
"reportAttributeName": "Online Submission Indicator",
"filterAttributeCode": "IN (\"N\")"
},
{
"reportAttributeName": "Latest Authorization Indicator",
"filterAttributeCode": "=\"TRUE\""
}
]
},
{
"sectionTitle": "Exception Details",
"sectionReportTypeName": "Transaction Details",
"sectionReportTypeId": "3001",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "Exception Details"
},
{
"reportAttributeName": "Entity Identifier"
},
{
"reportAttributeName": "Entity Type Code"
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "Submission Identifier"
},
{
"reportAttributeName": "Record Number"
},
{
"reportAttributeName": "Merchant Order Number"
},
{
"reportAttributeName": "Exception Description"
},
{
"alias": "Amount",
"reportAttributeName": "Presentment Amount"
},
{
"reportAttributeName": "Payment Method Code"
},
{
"reportAttributeName": "Account Number"
},
{
"reportAttributeName": "Credit Card Expiration Year Month Number"
},
{
"reportAttributeName": "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": "Entity Identifier",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Presentment Currency Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Settlement Currency Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Submission Identifier",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Merchant Order Number",
"sortOrderCode": "asc"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Exception Description",
"filterAttributeCode": "IN(\"rejected transaction\",\"declined deposit\",\"cancels/onhold\")"
}
]
}
],
"fileDelimiter": ",",
"reportConfigurationName": "Exception Details Report",
"reportFileName": "Exception Details Report....",
"reportHeader": "EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=",
"fileHeader": "BEGIN,EntityId=,Frequency=",
"fileTrailer": "END,EntityId=,Frequency=",
"csvColumnNameDisplayIndicator": true,
"reportConfigStatus": "active",
"reportName": "Transaction Summary & Exception Report",
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2026-03-24 02:00:00",
"reportingPeriodEndTimestamp": "2026-03-25 01:59:59"
}
}
```
#### Financial activity summary report
The following request code block shows how to configure a financial activity summary report for `entityType` = CO/BU/TD/PE. Download the sample [Financial activity summary report](/system/downloads/commerce/reporting/Financial_Activity_Summary_Preset_Report.csv?type=stream).
```json
{
"entityType": "CO",
"entityIds": [
"1234567"
],
"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"
},
{
"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=,GenerationDate=,GenerationTime=",
"fileHeader": "BEGIN,EntityId=,Frequency=",
"fileTrailer": "END,EntityId=,Frequency=",
"reportName": "Financial Activity Summary Report",
"csvColumnNameDisplayIndicator": true,
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2026-03-24 02:00:00",
"reportingPeriodEndTimestamp": "2026-03-25 01:59:59"
}
}
```
#### Funded transaction fee details report
The following request code block shows how to configure a funded transaction fee details report for `entityType` = CO/BU/TD/PE. Download the sample [Funded transaction fee details report](/system/downloads/commerce/reporting/Funded_Transaction_Fee_Details_Preset_Report.csv?type=stream).
```json
{
"entityType": "CO",
"entityIds": [
"1234567"
],
"reportSections": [
{
"sectionReportTypeName": "Fee Details",
"sectionReportTypeId": "3006",
"sectionTitle": "Funded Transaction Fee Detail",
"sectionSelectedFields": [
{
"reportAttributeName": "Activity Date"
},
{
"reportAttributeName": "Entity Identifier"
},
{
"reportAttributeName": "Entity Type Code"
},
{
"reportAttributeName": "Payment Method Code"
},
{
"reportAttributeName": "Merchant Order Number"
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "Foreign Exchange Rate"
},
{
"reportAttributeName": "Funds Transfer Category Text"
},
{
"reportAttributeName": "Fund Transfer Identifier"
},
{
"reportAttributeName": "Fund Transfer Instruction Number"
},
{
"reportAttributeName": "Fund Transfer Effective Date"
},
{
"reportAttributeName": "Acquirer Reference Number"
},
{
"reportAttributeName": "Account Number"
},
{
"reportAttributeName": "Sale/Refund Code"
},
{
"reportAttributeName": "Action Type Code"
},
{
"reportAttributeName": "Secure Bank Account Number"
},
{
"reportAttributeName": "Presentment Amount"
},
{
"alias": "Presentment Amount in Settlement Currency",
"reportAttributeName": "Transaction Amount"
},
{
"reportAttributeName": "Settled Total Fee Amount",
"alias": "Net Settled Sales Amount",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "IN (\"Settled Sales\",\"Settled Refunds\")"
}
]
},
{
"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": "Back Up Withholding Adjustments",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "IN (\"Back Up Withholding Adjustments\")"
}
]
},
{
"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": "Discount Fees",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "IN (\"Discount Fees\")"
}
]
},
{
"reportAttributeName": "Settled Total Fee Amount",
"alias": "ECP Return Adjustments",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "IN (\"ECP Return Adjustments\")"
}
]
},
{
"reportAttributeName": "Settled Total Fee Amount",
"alias": "Other Adjustments",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "IN (\"Other Adjustments\")"
}
]
},
{
"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": "Reserve Adjustments",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "IN (\"Reserve Adjustments\")"
}
]
},
{
"reportAttributeName": "Settled Total Fee Amount",
"alias": "Other Fees",
"aggregateOperationText": "sum",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Charge Category Text",
"aggregateConditionText": "NOT IN (\"Reserve Adjustments\",\"Interchange & Assessment Fees\",\"Back Up Withholding Adjustments\",\"Chargeback Adjustments\",\"Discount Fees\",\"ECP Return Adjustments\",\"Settled Sales\",\"Conveyed Sales\",\"Conveyed Refunds\",\"Settled Refunds\", \"Other 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\")"
}
]
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Entity Identifier",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Payment Method Code",
"sortOrderCode": "desc"
},
{
"reportAttributeName": "Presentment Currency Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Settlement Currency Code",
"sortOrderCode": "asc"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Settled Total Fee Amount",
"filterAttributeCode": "!=0.0"
},
{
"reportAttributeName": "Conveyed Settled Code",
"filterAttributeCode": "='S'"
}
]
}
],
"fileDelimiter": ",",
"reportConfigurationName": "Funded Transaction Fee Detail Report",
"reportFileName": "Funded Transaction Fee Detail Report,...",
"reportHeader": "EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=",
"fileHeader": "BEGIN,EntityId=,Frequency=",
"fileTrailer": "END,EntityId=,Frequency=",
"csvColumnNameDisplayIndicator": true,
"reportConfigStatus": "active",
"reportName": "Funded Transaction Fee Detail Report",
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2026-03-24 02:00:00",
"reportingPeriodEndTimestamp": "2026-03-25 01:59:59"
}
}
```
#### Interchange qualification report
The following request code block shows how to configure an interchange report for `entityType` = CO/BU/TD/PE. Download the sample [Interchange qualification report](/system/downloads/commerce/reporting/Interchange_Qualification_Preset_Report.csv?type=stream).
```json
{
"entityType": "CO",
"entityIds": [
"1234567"
],
"reportSections": [
{
"sectionTitle": "Interchange Qualification Summary",
"sectionReportTypeName": "Submission Details",
"sectionReportTypeId": "3003",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "Interchange Qualification Summary"
},
{
"reportAttributeName": "Entity Identifier",
},
{
"reportAttributeName": "Entity Type Code",
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "Payment Method Code"
},
{
"reportAttributeName": "Interchange Qualification Code"
},
{
"reportAttributeName": "Interchange Qualification Text"
},
{
"reportAttributeName": "Fee Rate"
},
{
"reportAttributeName": "Unit Fee Amount"
},
{
"alias": "Sales Count",
"reportAttributeName": "Merchant Order Number",
"aggregateOperationText": "count"
},
{
"alias": "Count %",
"customCalculationText": "% of",
"customCalculationOn": "Sales Count",
"groupBy": [
"Payment Method Code",
"Settlement Currency Code"
]
},
{
"alias": "Sales Amount",
"reportAttributeName": "Settlement Amount",
"aggregateOperationText": "sum"
},
{
"alias": "Amount %",
"customCalculationText": "% of",
"customCalculationOn": "Sales Amount",
"groupBy": [
"Payment Method Code",
"Settlement Currency Code"
]
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Conveyed Settled Code",
"filterAttributeCode": "=\"S\""
},
{
"reportAttributeName": "Deposit Category Code",
"filterAttributeCode": "=\"S\""
},
{
"reportAttributeName": "Fee Text",
"filterAttributeCode": "=\"Interchange\""
},
{
"reportAttributeName": "Payment Method Code",
"filterAttributeCode": "IN(\"MC\",\"VI\",\"DI\",\"MD\",\"SW\",\"IM\",\"DD\",\"VR\",\"MR\",\"AX\",\"JC\")"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Payment Method Code",
"sortOrderCode": "desc"
},
{
"reportAttributeName": "Interchange Qualification Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Presentment Currency Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Settlement Currency Code",
"sortOrderCode": "asc"
}
]
},
{
"sectionTitle": "Interchange Qualification Details",
"sectionReportTypeName": "Submission Details",
"sectionReportTypeId": "3003",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "Interchange Qualification Details"
},
{
"reportAttributeName": "Entity Identifier"
},
{
"reportAttributeName": "Entity Type Code"
},
{
"reportAttributeName": "Presentment Currency Code"
},
{
"reportAttributeName": "Settlement Currency Code"
},
{
"reportAttributeName": "Payment Method Code"
},
{
"reportAttributeName": "Merchant Order Number"
},
{
"reportAttributeName": "Interchange Qualification Code"
},
{
"reportAttributeName": "Downgrade Reason Code"
},
{
"reportAttributeName": "Downgrade Reason Text"
},
{
"reportAttributeName": "Account Number"
},
{
"reportAttributeName": "Deposit Date"
},
{
"alias": "Amount",
"reportAttributeName": "Settlement Amount",
"aggregateOperationText": "max"
},
{
"reportAttributeName": "Acquirer Reference Number"
},
{
"reportAttributeName": "Card Usage Type"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Conveyed Settled Code",
"filterAttributeCode": "=\"S\""
},
{
"reportAttributeName": "Deposit Category Code",
"filterAttributeCode": "=\"S\""
},
{
"reportAttributeName": "Fee Text",
"filterAttributeCode": "=\"Interchange\""
},
{
"reportAttributeName": "Payment Method Code",
"filterAttributeCode": "IN(\"MC\",\"VI\",\"DI\",\"MD\",\"SW\",\"IM\",\"DD\",\"VR\",\"MR\",\"AX\",\"JC\")"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Entity Identifier",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Payment Method Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Interchange Qualification Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Presentment Currency Code",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Settlement Currency Code",
"sortOrderCode": "asc"
}
]
}
],
"fileDelimiter": ",",
"reportConfigurationName": "Interchange Qualification Report",
"reportFileName": "Interchange Report....",
"reportHeader": "EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=",
"fileHeader": "BEGIN,EntityId=,Frequency=",
"fileTrailer": "END,EntityId=,Frequency=",
"csvColumnNameDisplayIndicator": true,
"reportConfigStatus": "active",
"reportName": "Interchange Qualification Report",
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2026-03-24 02:00:00",
"reportingPeriodEndTimestamp": "2026-03-25 01:59:59"
}
}
```
#### Recurring program next billing report
The following request code block shows how to configure an recurring program next billing report for `entityType` = CO/BU/TD/PE. Download the sample [Recurring Program Next Billing report](/system/downloads/commerce/reporting/Recurring_Program_Next_Billing.xlsx?type=stream).
```json
{
"entityType": "CO",
"entityIds": [
"1234567"
],
"reportSections": [
{
"sectionReportTypeName": "Managed Billing",
"sectionReportTypeId": "3020",
"sectionTitle": "Recurring Program Next Billing Summary",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "MBR0010"
},
{
"alias": "Plan Name",
"reportAttributeName": "Merchant Recurring Plan Name"
},
{
"alias": "Plan ID",
"reportAttributeName": "Recurring Plan Identifier"
},
{
"alias": "Recurring Program Status",
"reportAttributeName": "Recurring Program Status Code"
},
{
"alias": "Number of Unique Profiles",
"reportAttributeName": "Consumer Profile Identifier",
"aggregateOperationText": "distinctCount"
},
{
"alias": "Number of Unique Recurring Programs",
"reportAttributeName": "Recurring Program Identifier",
"aggregateOperationText": "distinctCount"
},
{
"alias": "Currency",
"reportAttributeName": "Representment Currency Code"
},
{
"alias": "Total Billing Amount",
"reportAttributeName": "Billing Period Type Scheduled Payment Amount",
"aggregateOperationText": "sum"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Report Type Name",
"filterAttributeCode": "IN (\"RECURRING\")"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Merchant Recurring Plan Name",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Recurring Program Status Code",
"sortOrderCode": "asc"
}
]
},
{
"sectionReportTypeName": "Managed Billing",
"sectionReportTypeId": "3020",
"sectionTitle": "Recurring Program Next Billing Details",
"sectionSelectedFields": [
{
"alias": "Record Type",
"constantValueText": "MBR0010"
},
{
"reportAttributeName": "Transaction Processing Entity Identifier"
},
{
"alias": "Consumer Profile ID",
"reportAttributeName": "Consumer Profile Identifier"
},
{
"alias": "Processor Profile ID",
"reportAttributeName": "Internal Consumer Profile Identifier"
},
{
"alias": "Consumer Profile Status",
"reportAttributeName": "Consumer Profile Status Code"
},
{
"alias": "Customer Name",
"reportAttributeName": "Consumer Name"
},
{
"alias": "Customer Email",
"reportAttributeName": "Consumer Profile Email Address Text"
},
{
"alias": "Customer Address",
"reportAttributeName": "Consumer Address"
},
{
"alias": "Payment Method ID",
"reportAttributeName": "Payment Method Identifier"
},
{
"reportAttributeName": "Payment Method Code"
},
{
"alias": "Payment Account Number",
"reportAttributeName": "Masked Account Number"
},
{
"alias": "Payment Method Status",
"reportAttributeName": "Payment Method Account Status Code"
},
{
"alias": "Card Expiration Date",
"reportAttributeName": "Card Expiration Month Year Number"
},
{
"alias": "Recurring Program ID",
"reportAttributeName": "Recurring Program Identifier"
},
{
"alias": "Merchant Recurring Program ID",
"reportAttributeName": "Merchant Recurring Program Identifier"
},
{
"reportAttributeName": "Recurring Program Status Code"
},
{
"alias": "Plan Name",
"reportAttributeName": "Merchant Recurring Plan Name"
},
{
"alias": "Plan ID",
"reportAttributeName": "Recurring Plan Identifier"
},
{
"alias": "Next Billing Date",
"reportAttributeName": "Billing Schedule Date"
},
{
"alias": "Currency",
"reportAttributeName": "Representment Currency Code"
},
{
"alias": "Next Billing Amount",
"reportAttributeName": "Billing Period Type Scheduled Payment Amount"
},
{
"reportAttributeName": "Card Expire Indicator"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Report Type Name",
"filterAttributeCode": "IN (\"RECURRING\")"
}
],
"sectionSortOrderList": [
{
"reportAttributeName": "Merchant Recurring Plan Name",
"sortOrderCode": "asc"
},
{
"reportAttributeName": "Recurring Program Status Code",
"sortOrderCode": "asc"
}
]
}
],
"fileDelimiter": ",",
"reportConfigurationName": "Recurring Program Next Billing Report",
"reportFileName": "Recurring Program Next Billing Report.....",
"reportHeader": ",,,,,,GenerationTime=",
"fileHeader": "BEGIN,EntityId=,Frequency=",
"fileTrailer": "END,EntityId=,Frequency=",
"csvColumnNameDisplayIndicator": true,
"reportConfigStatus": "active",
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2025-06-03 00:00:00",
"reportingPeriodEndTimestamp": "2025-06-04 00:00:00"
}
}
```
#### Token provisioning and lifecycle report
The following request code block shows how to configure a token provisioning and lifecycle report for `entityType` = CO/BU/TD. Download the sample [Token provisioning and lifecycle report](/system/downloads/commerce/reporting/Token_Lifecycle_Preset_Report.csv?type=stream).
```json
{
"entityType": "CO",
"entityIds": [
"9999999"
],
"reportSections": [
{
"sectionTitle": "Token Provisioning & Cryptogram Details",
"sectionReportTypeName": "Token Provisioning and Lifecycle",
"sectionReportTypeId": "3022",
"sectionSelectedFields": [
{
"reportAttributeName": "Payment Method Code",
"alias": "Method of Payment"
},
{
"alias": "Tokens Provisioned",
"reportAttributeName": "Unified Payment Gateway Token Management Response Log Identifier",
"aggregateOperationText": "distinctCount",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Unified Payment Gateway Token Management Operation Name",
"aggregateConditionText": "IN(\"TokenProvision\",\"InternalTokenProvision\")"
},
{
"aggregateConditionAttributeName": "Unified Payment Gateway Token Management Response Code",
"aggregateConditionText": "IN(\"SUCCESS\")"
}
]
},
{
"alias": "Total Tokens Requested",
"reportAttributeName": "Unified Payment Gateway Token Management Response Log Identifier",
"aggregateOperationText": "distinctCount",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Unified Payment Gateway Token Management Operation Name",
"aggregateConditionText": "IN(\"TokenProvision\",\"InternalTokenProvision\")"
}
]
},
{
"alias": "Token Provision Success Ratio",
"customCalculationText": "Div",
"customCalculationOn": "Tokens Provisioned,Total Tokens Requested"
},
{
"alias": "Cryptograms Provisioned",
"reportAttributeName": "Unified Payment Gateway Token Management Response Log Identifier",
"aggregateOperationText": "distinctCount",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Unified Payment Gateway Token Management Operation Name",
"aggregateConditionText": "IN(\"TokenCryptogram\",\"TokenCryptoProcessing\")"
},
{
"aggregateConditionAttributeName": "Unified Payment Gateway Token Management Response Code",
"aggregateConditionText": "IN(\"SUCCESS\")"
}
]
},
{
"alias": "Total Cryptograms Requested",
"reportAttributeName": "Unified Payment Gateway Token Management Response Log Identifier",
"aggregateOperationText": "distinctCount",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Unified Payment Gateway Token Management Operation Name",
"aggregateConditionText": "IN(\"TokenCryptogram\",\"TokenCryptoProcessing\")"
}
]
},
{
"alias": "Token Cryptogram Request Success Ratio",
"customCalculationText": "Div",
"customCalculationOn": "Cryptograms Provisioned,Total Cryptograms Requested"
}
],
"sectionFilterAttributeList": [
{
"reportAttributeName": "Payment Method Code",
"filterAttributeCode": "!=\"NULL\""
}
]
},
{
"sectionTitle": "Token Lifecycle Details",
"sectionReportTypeName": "Token Provisioning and Lifecycle Report",
"sectionReportTypeId": "3022",
"sectionSelectedFields": [
{
"reportAttributeName": "Unified Payment Gateway Token Status Text",
"alias": "State Change Update",
"aggregateOperationText": "count"
},
{
"reportAttributeName": "Unified Payment Gateway Token Status Text",
"alias": "Active Tokens",
"aggregateOperationText": "count",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Unified Payment Gateway Token Status Text",
"aggregateConditionText": "IN(\"ACTIVE\")"
}
]
},
{
"reportAttributeName": "Unified Payment Gateway Token Status Text",
"alias": "Inactive or Suspended Tokens",
"aggregateOperationText": "count",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Unified Payment Gateway Token Status Text",
"aggregateConditionText": "IN(\"INACTIVE\",\"SUSPENDED\")"
}
]
},
{
"reportAttributeName": "Unified Payment Gateway Token Status Text",
"alias": "Deleted Tokens",
"aggregateOperationText": "count",
"conditionalAggregateIndicator": true,
"conditionalAggregateFilterList": [
{
"aggregateConditionAttributeName": "Unified Payment Gateway Token Status Text",
"aggregateConditionText": "IN(\"DELETED\")"
}
]
}
]
}
],
"fileDelimiter": ",",
"reportConfigurationName": "Token Provisioning and Lifecycle Report",
"reportFileName": "Unified Token Provisioning and Lifecycle Report.....",
"reportHeader": "ProcessingEntityID=,ReportType=