Optimization Protection

Authorization 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 Seperated 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

The following table shows the summary section field details.

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	The name associated with the Commerce platform assigned entity identifier.
Transaction Division External Identifier	The identifier of the external transaction division.
Transaction Processing Entity Identifier	The identifier of the transaction processing entity.
Business Unit Identifier	The identifier of the business unit associated with the record.
Business Unit Name	The name associated with the Commerce platform assigned business unit number.
Company External Identifier	The identifier of the external company.
Company Name	The name associated with the Merchant Services assigned CO number.
Platform Identifier	The identifier of the platform used to facilitate the transaction request.
Platform Name	The name of the platform used to facilitate the transaction request.

The following table shows the data section field details.

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 entitiy 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	The identifier of the platform used to facilitate the transaction request.
Platform Name	The name of the platform used to facilitate the transaction request.
Transaction Division External Identifier	The identifier for the external transaction division.
Transaction Processing Entity Identifier	The identifier for the transaction processing entity.
Entity Name	The name associated with the Commerce platform assigned entity identifier.
Business Unit Identifier	The business unit associated with the record.
Business Unit Name	The name associated with the Commerce platform assigned business unit number.
Company External Identifier	The identifier of the external company.
Company Name	The name associated with the Commerce platform assigned company number.

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.

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,<Processing Entity ID>.<Report Type>.<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": "Authorization Report",
  "frequencyConfig": {
    "scheduleFrequency": "adhoc",
    "reportingPeriodStartTimestamp": "2025-09-17 04:00:00",
    "reportingPeriodEndTimestamp": "2025-09-23 03:59:59"
  }
}

Download sample report

Download the sample Authorization report.

Scheduled and adhoc report configurations