Deposit details report
This report provides details of sale and refund transactions for each merchant order number along with the Interchange and Assessment fees of each transaction for the selected reporting period.
Use cases
- Verify what was sent and processed against their own internal transactions report.
- Reconciliation or research of deposit/submission activity.
Granularity
Combination of Submission Date, Presentment Currency Code, Settlement Currency Code, Transaction Division External Identifier, Payment Method Code, Merchant Order Number, Account Number, Credit Card Expiration Year Month Number, Merchant Action Code, Action Type Code Text, Authorization Date, Country of Issuance, Transaction Type Code, Transaction Type Text, Merchant Category Code, Digital Token Method Code, Digital Wallet Brand, Merchant Information Description, Surcharge Amount, Bank Sort Code, Card Usage Type
Fields
The following table shows the field details.
Field name |
Definition |
|---|---|
Submission Date |
The date on which the submission was fully received at J.P. Morgan in UTC time zone. |
Presentment Currency Code |
The three-character abbreviation for the currency in which the cardholder transaction occurred |
Settlement Currency Code |
The three-character abbreviation for the currency in which the merchant is being funded. |
Transaction Division External Identifier |
Transaction division external identifier. |
Transaction Processing Entity Identifier |
Transaction processing entity identifier. |
Payment Method Code |
Code that identifies the (MOP) method of payment for the transaction. |
Merchant Order Number |
The order number submitted by the merchant with the original sale. |
Account Number |
Cardholders account number. |
Credit Card Expiration Year Month Number |
The credit card account expiration date (month and year) as submitted by the merchant with this transaction. *Note: If the values in this column, do not render correctly, open the report file in Notepad to get the correct values for this field. |
Transaction Amount in Presentment Currency |
Total of sale or refund amount in presentment currency. |
Merchant Action Code |
Merchant supplied code that indicates the type of transaction conducted |
Action Type Code Text |
Action type code description. |
Authorization Date |
The date in UTC time zone on which the authorization was performed for the transaction. |
Country of Issuance |
Standard alpha ISO country code that identifies the card's issuing country. May be space-filled for transactions on unsupported methods of payment. |
Transaction Type Code |
Identifies attributes of the transaction. |
Transaction Type Text |
Textual description of the transaction type. |
Merchant Category Code |
Indicator used to classify a merchant's product or service. |
Digital Token Method Code |
Indicates whether the pre-dispute is related to a Digital Payment Token. |
Digital Wallet Brand |
The name of the token requestor within the card network. |
Interchange Qualification Code |
A code that identifies the rate at which J.P. Morgan qualified the transaction. |
Interchange Unit Fee |
Fee per item as assessed by the card associations. For this field, a positive amount indicates a debit unit fee to the merchant. A negative amount indicates a credit unit fee. |
Fee Rate |
The percentage rate fee applied to the face value of this transaction. For this field, a positive amount indicates a debit % rate to the merchant. A negative amount indicates a credit % rate. |
Total Interchange Amount |
The total Interchange fee assessed for this data record in settlement currency. |
Total Assessment Amount |
The total assessment fee assessed for this data record in settlement currency. |
Other Debit Passthrough Fees |
The total debit pass through fee assessed for this data record in settlement currency. |
Merchant Information Description |
A customized free form block of merchant specific data (up to 99 bytes) sent in with this submission. The submission must be sent directly to Stratus for this field to populate. |
Surcharge Amount |
Total surcharge amount submitted by the merchant for this transaction. |
Bank Sort Code |
Identifies both the bank and the branch where the account is held. |
Card Usage Type |
Codifies whether the transaction is a Signature Debit transaction (1), PINDebit transaction (2), or a Credit Card transaction (3). |
Sample report configuration
The following request code block shows how to configure a deposit details report for entityType = CO/BU/TD.
{
"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.<Processing Entity ID>.<frequency>.<From Date YYYY-MM-DD>.<To Date YYYY-MM-DD>",
"reportHeader": EntityId=<Processing Entity ID>,ReportTypeName=<Report Type>,Frequency=<frequency>,FromDate=<From Date YYYY-MM-DD>,ToDate=<To Date YYYY-MM-DD>,GenerationDate=<Generation Date YYYY-MM-DD>,GenerationTime=<Generation Time HH:MM:SS>",
"fileHeader": "BEGIN,EntityId=<Processing Entity ID>,Frequency=<frequency>",
"fileTrailer": "END,EntityId=<Processing Entity ID>,Frequency=<frequency>",
"csvColumnNameDisplayIndicator": true,
"reportConfigStatus": "active",
"reportName": "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.
{
"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.<Processing Entity ID>.<frequency>.<From Date YYYY-MM-DD>.<To Date YYYY-MM-DD>",
"reportHeader": EntityId=<Processing Entity ID>,ReportTypeName=<Report Type>,Frequency=<frequency>,FromDate=<From Date YYYY-MM-DD>,ToDate=<To Date YYYY-MM-DD>,GenerationDate=<Generation Date YYYY-MM-DD>,GenerationTime=<Generation Time HH:MM:SS>",
"fileHeader": "BEGIN,EntityId=<Processing Entity ID>,Frequency=<frequency>",
"fileTrailer": "END,EntityId=<Processing Entity ID>,Frequency=<frequency>",
"csvColumnNameDisplayIndicator": true,
"reportConfigStatus": "active",
"reportName": "Deposit Detail Report",
"frequencyConfig": {
"scheduleFrequency": "adhoc",
"reportingPeriodStartTimestamp": "2024-05-06 11:30:00",
"reportingPeriodEndTimestamp": "2024-05-07 02:00:00"
}
}