# JPMC-PDP Documentation from https://developer.payments.jpmorgan.com # Authorization Details report This report provides you a summary of the successful and unsuccessful authorizations, and associated details for each authorization. **Authorization report details** | Report type | Supported entity types | Supported file formats | | --- | --- | --- | | Transaction details | - PE - Processing Entity - TD - Transaction Division - BU - Business Unit - FTI - Fund Transfer Instruction - CO - Company - RG - Reporting Group - PI - Platform Identifier | - Comma Separated Values (CSV) - Gzip or GNU Zip (GZ) - Portable Document Format (PDF) - MS Excel Workbook (.xlsx) | ## Use cases - Track all the payment transactions that have been authorized during a specific period. - Verify that transactions have been properly authorized by the card issuer or payment network. - Reconcile by comparing this report with sales records to ensure that all authorized transactions are accounted for. ## Granularity - Summary section: Combination of Presentment Currency Code, Settlement Currency Code, Method of Payment (MOP) Type, and Response Code. - Details section: Combination of Merchant Order Number, Merchant Action Code Text, Authorization Amount, Authorization Code, and Payment Brand Auth Response. ## Fields ### Summary The following table shows the summary section field details. Fields labeled **(O) **are optional and can be added to the preset report as needed. **Summary section field details** | Field name | Description | | --- | --- | | Record Type | The section of the report. For the summary section, record type value is Authorization Summary. | | Presentment Currency Code | The three-character abbreviation for the currency in which the cardholder transaction occurred. | | Settlement Currency Code | The three-character abbreviation for the currency in which the merchant is being funded. | | MOP Type | The method of payment (Visa, Mastercard, International Maestro, etc.). | | Response Code | The authorization response code indicating Approval, Decline or Rejection. | | Response Description | The text description of the authorization response code. Authorization response indicating Approval, Decline, or Rejection. | | Firm Authorization Approval Code | A high-level summarization of the firm's representation of the authorization response code being sent back to the merchant during credit card authorization. Valid values are: - Approved - Not Approved | | Total Transaction Count | The count of transactions for the summarized record. | | Amount | The authorization amount. | | Count of Declined Transactions | The number of declined transactions for the summarized record. | | Authorization Total Count % | The percentage of authorization count for the specific payment method compared to the total count. | | Authorization Status % | The percentage of authorization count for the specific reason code compared to the total count. | | Transaction Decline % | The percentage of decline count for the specific decline reason code compared to the total decline count. | | Entity Name (O) | The name associated with the Commerce platform assigned entity identifier. | | Transaction Division External Identifier (O) | The identifier of the external transaction division. | | Transaction Processing Entity Identifier (O) | The identifier of the transaction processing entity. | | Business Unit Identifier (O) | The identifier of the business unit associated with the record. | | Business Unit Name (O) | The name associated with the Commerce platform assigned business unit number. | | Company External Identifier (O) | The identifier of the external company. | | Company Name (O) | The name associated with the Merchant Services assigned CO number. | | Platform Identifier (O) | The identifier of the platform used to facilitate the transaction request. | | Platform Name (O) | The name of the platform used to facilitate the transaction request. | ### Details The following table shows the detailed section field details. Fields labeled **(O) **are optional and can be added to the preset report as needed. **Detail section field details** | Field name | Description | | --- | --- | | Record Type | The section of the report. For the detail section, record type value is Authorization Details. | | Presentment Currency Code | The three-character abbreviation for the currency in which the cardholder transaction occurred. | | Settlement Currency Code | The three-character abbreviation for the currency in which the merchant is being funded. | | Payment Method Code | The code that identifies the method of payment (MOP) for the transaction. | | Merchant Order Number | The order number submitted by the merchant with the original sale. | | Merchant Action Code Text | The type of transaction action conducted. Valid values: - AUTHORIZATIONS - DEPOSITS | | Authorization Amount | The authorization amount. | | Account Number | The 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 Type Text | The textual description of type of the transaction. | | Authorization Timestamp | The date and time in UTC time zone on which the authorization was performed for the transaction. | | Authorization Code | The six-character code related to a positive response from the endpoint. | | Payment Brand Auth Response | The actual auth response received from the network. | | Payment Brand Response Code Category | The payment brand response code category is derived based on the authorization response codes received from payment brand systems. Valid values are: - 1 - Issuer will never approve - 2 - Issuer cannot approve at this time - 3 - Issuer cannot approve with these details - 4 - Generic response codes - N - Not available - A - Approved - X - Not supported MOP | | PTI Authorization Response Code | The response code describing the result of an authorization attempted that was either received from an endpoint or merchant supplied. | | Authorization Initiator | The person or entity who initiated the authorization, ECP Verification/Validation, and pre-notes attempt. | | Authorization Source Code | The provider of the response (for example, merchant or endpoint). | | POS Authentication Source | The point of sale authentication source. | | Merchant Category Code | The indicator used to classify a merchant's product or service. | | Country of Issuance | The standard alpha ISO country code that identifies the card's issuing country. May be space-filled for transactions on unsupported methods of payment. | | Digital Token Method Text | The text description which indicates whether the transaction is related to a Digital Payment Token. | | Prepaid Card Type Code | The card Type Indicator (CTI), Indicates whether the card is a prepaid card. | | Commercial Card Code | The card Type Indicator (CTI) indicates whether the card is a commercial card and is capable of processing Level 2 or Level 3 transactions. | | Card Usage Type | Identifies whether the transaction is a signature debit transaction (1), PIN debit transaction (2), or credit card transaction (3). | | Payment Transaction Identifier | The unique identifier of a payment processing request for a sale that is associated with a purchase of goods and/or services. A payment request can consist of authorizations, captures and refunds. This identifier connects all of the requests related to the original sale. | | Terminal Identifier | The number identifying the POS terminal or similar device through which the transaction was processed. | | Entity Identifier | The associated CO, BU, TD, or PE identification number. | | Entity Type Code | The level at which the reported event occurred. Valid values are: - BU - Business Unit - CO - Company - TD - Transaction Division - PE - Processing Entity | | Platform Identifier (O) | The identifier of the platform used to facilitate the transaction request. | | Platform Name (O) | The name of the platform used to facilitate the transaction request. | | Transaction Division External Identifier (O) | The identifier for the external transaction division. | | Transaction Processing Entity Identifier (O) | The identifier for the transaction processing entity. | | Entity Name (O) | The name associated with the Commerce platform assigned entity identifier. | | Business Unit Identifier (O) | The business unit associated with the record. | | Business Unit Name (O) | The name associated with the Commerce platform assigned business unit number. | | Company External Identifier (O) | The identifier of the external company. | | Company Name (O) | The name associated with the Commerce platform assigned company number. | | Affluent Category Card Type Code (O) | The card Type Indicator (CTI) that indicates whether the card supports account holders with higher credit limits. | | Bank Identification Code (O) | The bank identification code. | | PTI Card Security Value Response (O) | The value returned by the endpoint in response to CVV2, CVC2 or CID validation request from the merchant. | | Consumer Bank County Code (O) | The code that indicates the country that the consumers bank in located in. | | Creditor Identifier (O) | The creditor identifier associated with the transaction. | | Durbin Regulated (O) | Indicates whether the issuing bank’s card range is regulated or not as defined by the Durbin Amendment. | | Encrypt (O) | The PAN encryption account status. | | Enhance Address Verification Service Response Code (O) | The responses are for Postal Code, Street, Name, Phone, and Email. | | Fraud Score Request (O) | The fraud score request from the merchant. | | Fraud Score Response (O) | The fraud score response from Safetech to the merchant. | | Healthcare Card Type Code (O) | The Card Type Indicator (CTI) that indicates whether the card is a Healthcare card. | | International Bank Account Number (O) | The international bank account number that is comprised of the bank's Country Code, a checksum and the Base Bank Account Number (BBAN). Base Bank Account Number consists of up to thirty alphanumeric characters and contains the domestic bank account details specific for each country. | | Level3 Card Type Code (O) | The Card Type Indicator (CTI) that indicates whether a commercial card is Level III interchange qualification capable. | | Mandate Identifier (O) | The code that identifies the agreement between the consumer and merchant to allow the consumer's direct debit account to be debited in an automated manner over a period of time. | | Mandate Code (O) | The sequence type of the mandate. Valid values are: - 1 - First - 2 - Recurrence - 3 - Last - 4 - One-off - 5 - New - 6 - Cancel - 7 - Change from manual to electronic. Space-filled if Mandate ID and Signature Date fields are space-filled. | | Payroll Card Type Code (O) | The Card Type Indicator (CTI) that indicates whether the card is a payroll card. | | Merchant Presenter Identifier (O) | The merchant's presenter ID number. | | Merchant Presenter Short Name (O) | The merchant's presenter ID abbreviated name. | | Pinless Debit Card Type Code (O) | The Card Type Indicator (CTI) that indicates whether the card is PINless debit capable. | | PTI Address Verification Response (O) | The code describing the address verification response for the authorization. | | Receiving Depository Financial Institution Number (O) | The receiving depository financial institution number. | | Record Number (O) | The sequential number of a transaction within a submission file. | | Reversal Reason Code (O) | The character indicator for the reason an authorization reversal occured. | | Signature Date (O) | The date on which the consumer signed the mandate. | | Signature Debit Card Type Code (O) | The Card Type Indicator (CTI) that indicates whether the card is a signature debit card. | | Bank Sort Code (O) | The code that identifies both the bank and the branch where the account is held. | | Submission Identifier (O) | The unique identification number for the submission that is assigned by Commerce platform. | | Submission EDT Date (O) | The date on which the submission was fully received at Commerce platform in EDT time zone. | | Debit Trace Number (O) | The sequential identifier assigned by Commerce platform ranging from 1-99999999 that is applied to debit transactions. | | Vendor Address Verification Response (O) | The endpoint code describing the Address Verification Response. | | Vendor Line (O) | Indicates which communication line Commerce platform used when performing the authorization, ECP verification/validation ,and pre-notes. | | Voice Authentication Required Indicator (O) | Indicates if voice authorization was used. | > There can be multiple records for a single merchant order number in the Authorization Details section in scenarios such as: > > > - Successful authorizations will have an additional record for the corresponding deposit. > > - For split shipment, the detail section can have multiple authorization records. > ## Sample report configurations The following samples help you get an idea of how to configure authorization reports. ### CO/BU/TD/PE The following request code block shows how to configure an authorization report for `entityType` = CO/BU/TD/PE. ```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" } } ``` ### PI The following request code block shows how to configure an authorization report for `entityType` = PI. ```json { "entityType": "PI", "entityIds": [ "6019581085" ], "reportSections": [ { "sectionTitle": "Authorization Summary", "sectionReportTypeName": "Transaction Details", "sectionReportTypeId": "3001", "sectionSelectedFields": [ { "alias": "Record Type", "constantValueText": "Authorization Summary" }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "MOP Type" }, { "reportAttributeName": "PTI Authorization Response Code", "alias": "Response Code" }, { "reportAttributeName": "PTI Authorization Response Code Description", "alias": "Response Description" }, { "reportAttributeName": "Firm Authorization Approval Code" }, { "reportAttributeName": "Merchant Order Number", "alias": "Total Transaction Count", "aggregateOperationText": "count", "conditionalAggregateIndicator": false }, { "reportAttributeName": "Authorization Amount", "alias": "Amount", "aggregateOperationText": "sum", "conditionalAggregateIndicator": false }, { "reportAttributeName": "Transaction Decline Count", "alias": "Count of Declined Transactions", "aggregateOperationText": "sum", "conditionalAggregateIndicator": false }, { "alias": "Authorization Total Count %", "customCalculationText": "% of", "customCalculationOn": "Total Transaction Count", "groupBy": [ "MOP Type" ] }, { "alias": "Authorization Status %", "customCalculationText": "% of", "customCalculationOn": "Total Transaction Count", "groupBy": [ "MOP Type", "PTI Authorization Response Code" ] }, { "alias": "Transaction Decline %", "customCalculationText": "% of", "customCalculationOn": "Count of Declined Transactions", "groupBy": [ "MOP Type", "PTI Authorization Response Code" ] } ], "sectionFilterAttributeList": [ { "reportAttributeName": "Transaction Type Text", "filterAttributeCode": "NOT IN (\"REJECTS\")" }, { "reportAttributeName": "Merchant Action Code Text", "filterAttributeCode": "IN (\"DEPOSITS\",\"AUTHORIZATIONS\")" }, { "reportAttributeName": "Authorization Amount", "filterAttributeCode": "IS NOT NULL" } ], "sectionSortOrderList": [ { "reportAttributeName": "MOP Type", "sortOrderCode": "asc" }, { "reportAttributeName": "PTI Authorization Response Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Presentment Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Settlement Currency Code", "sortOrderCode": "asc" } ] }, { "sectionTitle": "Authorization Details", "sectionReportTypeName": "Transaction Details", "sectionReportTypeId": "3001", "sectionSelectedFields": [ { "alias": "Record Type", "constantValueText": "Authorization Details" }, { "reportAttributeName": "Transaction Processing Entity Identifier" }, { "reportAttributeName": "Presentment Currency Code" }, { "reportAttributeName": "Settlement Currency Code" }, { "reportAttributeName": "Payment Method Code" }, { "reportAttributeName": "Merchant Order Number" }, { "reportAttributeName": "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": "Platform Identifier" }, { "reportAttributeName": "Platform Name" }, { "reportAttributeName": "Terminal Identifier" } ], "sectionFilterAttributeList": [ { "reportAttributeName": "Merchant Action Code Text", "filterAttributeCode": "IN (\"DEPOSITS\",\"AUTHORIZATIONS\")" }, { "reportAttributeName": "Authorization Amount", "filterAttributeCode": "IS NOT NULL" } ], "sectionSortOrderList": [ { "reportAttributeName": "Presentment Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Settlement Currency Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Transaction Processing Entity Identifier", "sortOrderCode": "asc" }, { "reportAttributeName": "Payment Method Code", "sortOrderCode": "asc" }, { "reportAttributeName": "Merchant Order Number", "sortOrderCode": "asc" } ] } ], "fileDelimiter": ",", "reportConfigurationName": "Authorization Report", "reportFileName": "Authorization Report,....", "reportHeader": "EntityId=,ReportTypeName=,Frequency=,FromDate=,ToDate=,GenerationDate=,GenerationTime=", "fileHeader": "BEGIN,EntityId=,Frequency=", "fileTrailer": "END,EntityId=,Frequency=", "csvColumnNameDisplayIndicator": true, "reportConfigStatus": "active", "reportName": "Authorization Report", "frequencyConfig": { "scheduleFrequency": "adhoc", "reportingPeriodStartTimestamp": "2025-09-17 04:00:00", "reportingPeriodEndTimestamp": "2025-09-23 03:59:59" } } ``` ## Download sample report - [English sample report](/system/downloads/commerce/reporting/Authorization_Details_Preset_Report.csv?type=stream) - [French sample report](/system/downloads/commerce/reporting/Details_de_lautorisation.csv?type=stream) ## Related [Scheduled and ad hoc report configurations](/docs/commerce/optimization-protection/capabilities/reporting/report-configurations/scheduled-adhoc)