Optimization Protection

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.

Note

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,<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>",
    "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.