Skip to main content
A summary of authorizations (counts, amounts) for the given transaction activity date. Use this report to calculate and analyze your authorization rates, and look for trends in declined transactions.
FieldDescription
ACCEPTOR_IDA unique, 36 character identifier created by Tesouro and assigned to the entity providing the goods or services to the customer, such as a Merchant, a Submerchant of a Payment Facilitator, a Seller within a Marketplace, or a Biller of a Consumer Bill Payment Service Provider (CBPS). Historically, processors have called this identifier the Merchant ID (or MID), Outlet ID, or Customer number.
ACCEPTOR_NAMEA human readable description used to uniquely label the Acceptor. It is assigned during onboarding of the Acceptor and mapped to the Acceptor ID. Maximum of 255 characters. Other processors may refer to this as a Billing descriptor.
ACCEPTOR_REFERENCEA unique identifier created and managed by the entity holding the direct relationship with the Acceptor, and assigned to the Acceptor with a one-to-one mapping to Tesouro’s Acceptor ID. Other processors may refer to this as Location ID, Store ID, Club ID, etc.
APPROVAL_STATUSSpecifies if the authorization was fully approved, partially approved, or declined.
AVS_RESPONSEThe Address Verification Service (AVS) result provided by the payment brand that verifies the entered address information matches the address information on file with the issuing bank.
ISSUING_BANK_COUNTRYThe ISO 3166-1 three-letter country code associated with the issuing bank.
ISSUING_BANK_NAMEThe name of the bank that issued the card.
MERCHANT_CATEGORYUnique ISO four digit values used to classify merchants and their transactions into specific categories based on the type of business, trade or services supplied.
ORGANIZATION_IDA unique 36 character identifier created and used by Tesouro, and assigned to the organization holding the relationship with Tesouro.
PAYMENT_BRANDThe payment brand used, e.g., Visa, Mastercard, Discover, American Express, etc.
PAYMENT_CHANNELThe card-present or card-not-present channel from which the customer makes a payment, e.g., In-store using a physical card terminal, online, or over the phone or through mail order.
PAYMENT_FUNDING_SOURCEThe source of the customer’s funds , e.g., credit, debit, pre-paid, cash. NOTE: This field will present a null, not applicable, or empty value if the fee is not tied to a specific transaction.
PAYMENT_PRODUCTThe product name according to the payment brand (e.g. World Elite Mastercard card), if applicable.
PROCESSING_NETWORKThe payment network that the transaction was processed on, which may be unaffiliated with the card brand.
PROCESSOR_RESPONSE_CODEA response code provided Tesouro indicating whether the transaction was approved or declined.
PROCESSOR_RESPONSE_MESSAGEA human readable description of the authorization response code. e.g., Insufficient funds.
SECURITY_CODE_NETWORK_RESPONSEThe response code sent from the network detailing the card security code verification results.
TRANSACTION_ACTIVITY_DATEThe date Tesouro recognized the payment request based upon the acceptor cutoff. Formatted as YYY-MM-DD
TRANSACTION_AMOUNT_APPROVEDThe total amount approved for authorization, which may be different than the total amount requested.
TRANSACTION_AMOUNT_REQUESTEDThe total amount requested for authorization
TRANSACTION_COUNTThe total quantity of transactions.
TRANSACTION_CURRENCYThe currency specified on the transaction request, in ISO 4217 alpha currency code format.
TRANSACTION_TYPEThe type of transaction, e.g., Authorization, Refund authorization, or Incremental authorization.

Report availability

The report is generated daily by 10:00 AM ET, encrypted, and placed in the outbound directory of an SFTP location dedicated for your use. (This schedule can be configured to later cadences to suit your needs, e.g., a later time in the day, every other day, weekly, monthly, etc.) Reports expire and removed from the SFTP location after 14 calendar days.

Report format

  • CSV file, following the RFC 4180 standard
  • File name: authorization-summaries_{startdate:YYYYMMDD}-{endDate:YYYYMMDD}_{generationDate:YYYYMMDDThhmmss}.csv
  • Values are separated using commas.
  • Values containing commas are enclosed within double quotes.
  • Values containing double-quotes are escaped by two double quote preceding it.