Power BI Connector for Authorize.net

Build 26.0.9770

AuthorizeCreditCard

Use this procedure to authorize a credit card payment without capturing the funds. Use the CaptureTransaction procedure afterward to capture the authorized amount.

Stored Procedure-Specific Information

To execute this stored procedure, enter: 
    EXEC AuthorizeCreditCard Amount='25.00', CurrencyCode='USD', CardNumber='4111111111111111', ExpirationDate='2025-12', CardCode='123'

Input

Name Type Required Description
RefId String False Merchant-assigned reference ID for the request. If included, this value is returned in the response.
Amount Decimal True Amount of the transaction. This is the total amount and must include tax, shipping, and any other charges.
CurrencyCode String False The currency of the transaction.
PaymentTrack1 String False Track 1 data from the card's magnetic stripe. Provide PaymentTrack1 or PaymentTrack2 to bill card-present track data instead of CardNumber/ExpirationDate.
PaymentTrack2 String False Track 2 data from the card's magnetic stripe. Provide PaymentTrack1 or PaymentTrack2 to bill card-present track data instead of CardNumber/ExpirationDate.
CardNumber String False The customer's credit card number. Provide with ExpirationDate to bill a card-not-present credit card instead of PaymentTrack1/PaymentTrack2.
ExpirationDate String False The customer's credit card expiration date, in YYYY-MM format.
CardCode String False The customer's card code. The three- or four-digit number on the back of a credit card (on the front for American Express).
CreateProfile Boolean False When true, a customer profile is created from the transaction data.
SolutionId String False The solution ID generated by Authorize.Net for a partner solution.
SolutionName String False The solution name associated with the SolutionId.
CallId String False The call ID generated by a digital wallet provider.
TerminalNumber String False The terminal number used for the transaction.
AuthCode String False The authorization code of an original transaction not authorized on the payment gateway.
RefTransId String False The payment gateway assigned transaction ID of the original transaction.
SplitTenderId String False The identifier of a split tender group used to combine multiple transactions.
OrderInvoiceNumber String False Merchant-defined invoice number associated with the order.
OrderDescription String False Description of the item purchased.
SupplierOrderReference String False A supplier order reference number for the order.
LineItemId String False Item identification.
LineItemName String False Name of the item.
LineItemDescription String False Description of the item.
LineItemQuantity Decimal False Quantity purchased.
LineItemUnitPrice Decimal False Price of one item per unit, excluding tax, freight, and duty.
LineItemTaxable Boolean False Indicates whether the line item is taxable.
LineItemUnitOfMeasure String False The unit of measure for the line item.
LineItemTaxAmount Decimal False The tax amount for the line item.
LineItemTotalAmount Decimal False The total amount for the line item.
LineItemCommodityCode String False The commodity code for the line item.
LineItemProductCode String False The product code for the line item.
LineItemProductSKU String False The product SKU for the line item.
LineItemDiscountAmount Decimal False The discount amount for the line item.
TaxAmount Decimal False The tax amount for the order.
TaxName String False The name of the tax for the order.
TaxDescription String False The description of the tax for the order.
DutyAmount Decimal False The duty amount for the order.
DutyName String False The name of the duty for the order.
DutyDescription String False The description of the duty for the order.
ShippingAmount Decimal False The shipping charge amount for the order.
ShippingName String False The name of the shipping charge for the order.
ShippingDescription String False The description of the shipping charge for the order.
TaxExempt Boolean False Indicates whether the transaction is tax exempt.
PONumber String False The purchase order number.
CustomerType String False The type of customer. Possible values are individual and business.
CustomerId String False Merchant assigned customer ID. Unique identifier to represent the customer associated with the transaction.
CustomerEmail String False The customer's email address.
BillToFirstName String False First name associated with customer's billing address.
BillToLastName String False Last name associated with BillTo's billing address.
BillToCompany String False Company associated with customer's billing address.
BillToAddress String False Customer's billing address. Required if the merchant would like to use the Address Verification Service security feature.
BillToCity String False City of customer's billing address.
BillToState String False State of customer's billing address.
BillToZip String False ZIP code of customer's billing address. Required if the merchant would like to use the Address Verification Service security feature.
BillToCountry String False Country of customer's billing address.
BillToPhoneNumber String False Phone number associated with customer's billing address.
BillToFaxNumber String False Fax number associated with customer's billing address.
ShipToFirstName String False First name associated with customer's shipping address.
ShipToLastName String False Last name associated with customer's shipping address.
ShipToCompany String False Company associated with customer's shipping address.
ShipToAddress String False Customer's shipping address.
ShipToCity String False City of customer's shipping address.
ShipToState String False State of customer's shipping address.
ShipToZip String False ZIP code of customer's shipping address.
ShipToCountry String False Country of customer's shipping address.
CustomerIP String False The customer's IP address.
CardholderAuthenticationIndicator String False The cardholder authentication indicator (ECI) value.
CardholderAuthenticationValue String False The cardholder authentication verification value (CAVV).
RetailMarketType String False The market type for the retail transaction.
RetailDeviceType String False The device type for the retail transaction.
EmployeeId String False The identifier of the employee processing the transaction.
TransactionSettingName String False The name of a transaction setting. Allowed values include emailCustomer, merchantEmail, allowPartialAuth, headerEmailReceipt, footerEmailReceipt, recurringBilling, duplicateWindow, and testRequest.
TransactionSettingValue String False The value of the transaction setting identified by TransactionSettingName.
UserFieldName String False The name of a merchant-defined user field.
UserFieldValue String False The value of the merchant-defined user field identified by UserFieldName.
SurchargeAmount Decimal False The surcharge amount applied to the transaction.
SurchargeDescription String False The description of the surcharge.
MerchantDescriptor String False The merchant descriptor that appears on the customer's statement.
SubMerchantIdentifier String False The identifier of the sub-merchant. Required when subMerchant information is provided.
SubMerchantDoingBusinessAs String False The doing-business-as name of the sub-merchant.
SubMerchantPaymentServiceProviderName String False The payment service provider name of the sub-merchant.
SubMerchantPaymentServiceFacilitator String False The payment service facilitator of the sub-merchant.
SubMerchantStreetAddress String False The street address of the sub-merchant.
SubMerchantPhone String False The phone number of the sub-merchant.
SubMerchantEmail String False The email address of the sub-merchant.
SubMerchantPostalCode String False The postal code of the sub-merchant.
SubMerchantCity String False The city of the sub-merchant.
SubMerchantRegionCode String False The region code of the sub-merchant.
SubMerchantCountryCode String False The country code of the sub-merchant.
TipAmount Decimal False The tip amount included in the transaction.
ProcessingOptionsIsFirstRecurringPayment Boolean False Indicates whether this is the first payment in a series of recurring payments.
ProcessingOptionsIsFirstSubsequentAuth Boolean False Indicates whether this is the first in a series of merchant-initiated transactions.
ProcessingOptionsIsSubsequentAuth Boolean False Indicates whether this is a subsequent merchant-initiated transaction.
ProcessingOptionsIsStoredCredentials Boolean False Indicates whether stored credentials are used for the transaction.
SubsequentAuthInformationOriginalNetworkTransId String False The network transaction ID of the original transaction. Required when subsequentAuthInformation is provided.
SubsequentAuthInformationSubsequentAuthReason String False The reason for the subsequent authorization. Required when subsequentAuthInformation is provided.
SubsequentAuthInformationOriginalAuthAmount Decimal False The amount of the original authorization. Required when subsequentAuthInformation is provided.
OtherTaxNationalTaxAmount Decimal False The national tax amount.
OtherTaxLocalTaxAmount Decimal False The local tax amount.
OtherTaxAlternateTaxAmount Decimal False The alternate tax amount.
OtherTaxAlternateTaxId String False The alternate tax identifier.
OtherTaxVatTaxRate Decimal False The VAT tax rate.
OtherTaxVatTaxAmount Decimal False The VAT tax amount.
ShipFromFirstName String False First name associated with the ship-from address.
ShipFromLastName String False Last name associated with the ship-from address.
ShipFromCompany String False Company associated with the ship-from address.
ShipFromAddress String False Street address of the ship-from location.
ShipFromCity String False City of the ship-from location.
ShipFromState String False State of the ship-from location.
ShipFromZip String False ZIP code of the ship-from location.
ShipFromCountry String False Country of the ship-from location.
AuthorizationIndicator String False The authorization indicator. Possible values are pre and final.
TapToPhone Boolean False Indicates whether the transaction was made using a tap-to-phone device.
DebtRepaymentIndicator Boolean False Indicates whether the transaction is a debt repayment.
PurchaseLevel String False The purchase level of the transaction data.
AftInformationAftIndicator String False The Account Funding Transaction (AFT) indicator.
AftInformationAftBusinessApplicationId String False The business application identifier for the account funding transaction.
AftInformationRecipientFirstName String False First name of the recipient in an account funding transaction.
AftInformationRecipientLastName String False Last name of the recipient in an account funding transaction.
AftInformationRecipientMiddleName String False Middle name of the recipient in an account funding transaction.
AftInformationRecipientAddress String False Street address of the recipient in an account funding transaction.
AftInformationRecipientCity String False City of the recipient in an account funding transaction.
AftInformationRecipientState String False State of the recipient in an account funding transaction.
AftInformationRecipientZip String False ZIP code of the recipient in an account funding transaction.
AftInformationRecipientCountry String False Country of the recipient in an account funding transaction.
AftInformationRecipientAccountId String False The account identifier of the recipient in an account funding transaction.
AftInformationRecipientAccountType String False The account type of the recipient in an account funding transaction.
AftInformationSenderFirstName String False First name of the sender in an account funding transaction.
AftInformationSenderMiddleName String False Middle name of the sender in an account funding transaction.
AftInformationSenderLastName String False Last name of the sender in an account funding transaction.
AftInformationSenderName String False Sender business, government, non-government name, or Visa payer name. When name has a value, sender's other name fields should not be present in the transaction.
AftInformationSenderAddress String False Street address of the sender in an account funding transaction.
AftInformationSenderCity String False City of the sender in an account funding transaction.
AftInformationSenderState String False State of the sender in an account funding transaction.
AftInformationSenderZip String False ZIP code of the sender in an account funding transaction.
AftInformationSenderCountry String False Country of the sender in an account funding transaction.
AftInformationSenderType String False The type of sender in an account funding transaction.
AftInformationSenderAccount String False The account of the sender in an account funding transaction.
AftInformationSenderFundsSourceNumber String False The funds source number of the sender in an account funding transaction.
AftInformationSenderFundsSourceType String False The funds source type of the sender in an account funding transaction.
AftInformationSenderDateOfBirth String False The date of birth of the sender in an account funding transaction.
AftInformationSenderIdentificationNumber String False The identification number of the sender in an account funding transaction.
AftInformationSenderPersonalIdType String False The personal identification type of the sender in an account funding transaction.
AftInformationSenderReferenceNumber String False The reference number of the sender in an account funding transaction.
DiscountAmount Decimal False The discount amount for the order.
DiscountName String False The name of the discount for the order.
DiscountDescription String False The description of the discount for the order.

Result Set Columns

Name Type Description
RefId String Merchant-assigned reference ID for the request.
Code String Response code that represents the status.
Message String Text description of the status.
ResponseCode Integer Overall status of the transaction. Possible values are 1 = Approved, 2 = Declined, 3 = Error, 4 = Held for Review.
AuthCode String The authorization or approval code for the transaction.
AvsResultCode String Address Verification Service (AVS) response code. Indicates the result of the AVS filter.
CvvResultCode String Card code verification (CCV) response code.
CavvResultCode String Cardholder authentication verification value (CAVV) response code.
TransId String The payment gateway assigned identification number for the transaction. Use this value for any follow-on transactions such as a credit, prior authorization and capture, or void.
RefTransId String The transaction ID of a related, previously settled transaction.
TransHash String An MD5 hash used to authenticate the response.
AccountNumber String The masked account number used for the transaction.
AccountType String The account type used for the transaction.
ErrorCode String The error code returned when the transaction results in an error.
ErrorText String The text description of the error.
SplitTenderPaymentTransId String The transaction ID of a payment in a split tender group.
SplitTenderPaymentResponseCode String The response code of a payment in a split tender group.
SplitTenderPaymentResponseToCustomer String The response message presented to the customer for a payment in a split tender group.
SplitTenderPaymentAuthCode String The authorization code of a payment in a split tender group.
SplitTenderPaymentAccountNumber String The masked account number of a payment in a split tender group.
SplitTenderPaymentAccountType String The account type of a payment in a split tender group.
SplitTenderPaymentRequestedAmount String The requested amount for a payment in a split tender group.
SplitTenderPaymentApprovedAmount String The approved amount for a payment in a split tender group.
SplitTenderPaymentBalanceOnCard String The remaining balance on the card for a payment in a split tender group.
UserFieldName String The name of a merchant-defined user field returned in the response.
UserFieldValue String The value of the merchant-defined user field returned in the response.
TransHashSha2 String A SHA-256 hash used to authenticate the response.
NetworkTransId String The network transaction ID returned by the processor.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770