JDBC Driver for Authorize.Net

Build 22.0.8462

TransactionDetails

Query TransactionDetails for an Authorize.Net merchant account.

Table Specific Information

The TransId is the only available supported column in the WHERE clause and it is required to retrieve results from TransactionDetails. TransId can be used with the (=) or IN operator.

SELECT * FROM TransactionDetails WHERE TransId='23478353'

SELECT * FROM TransactionDetails WHERE TransId IN ('23478353', '23479147')

Columns

Name Type Statistic Description
TransId [KEY] String The unique transaction Id.
RefTransId String The transaction Id of the original transaction. This only appears for linked credits (transaction type refundTransaction).
SplitTenderId String Identifies the split tender order, if applicable. This only appears for transactions that are part of a larger partial authorization order.
SubmitTime Datetime Date and time the transaction was submitted.
TransactionType String The type of transaction that was originally submitted. Valid values: authCaptureTransaction, authOnlyTransaction, captureOnlyTransaction, refundTransaction.

The allowed values are authCaptureTransaction, authOnlyTransaction, captureOnlyTransaction, refundTransaction.

TransactionStatus String The status of the transaction.
ResponseCode Integer The overall status of the transaction. Valid values: 1 (Approved), 2 (Declined), 3 (Error), 4 (Held for review).

The allowed values are 1, 2, 3, 4.

ResponseReasonCode Integer A code that represents more details about the result of the transaction.
ResponseReasonDescription String A brief description of the result, which corresponds with the response reason code.
AuthCode String The authorization or approval code.
AVSResponse String Response from the AVS security check. Indicates the result of the AVS filter.
CardCodeResponse String Response from the card code security check. Indicates the result of the CCV filter.
CAVVResponse String The cardholder authentication verification response code.
FDSFilterAction String The action taken for a transaction that triggered one or more of the Advanced Fraud Detection Suite filters. Valid values: reject, decline, hold, authAndHold, report.
FDSFiltersName String A comma-separated list of fraud filter names.
FDSFiltersAction String A comma-separated list of fraud filter settings.
BatchId String The Id of the batch the transaction is in.
SettlementTime Datetime Date and time the transaction was settled.
SettlementState String Status of the batch. Valid values: settledSuccessfully, settlementError, pendingSettlement.

The allowed values are settledSuccessfully, settlementError, pendingSettlement.

InvoiceNumber String The invoice number for the transaction.
Description String The description of the transaction.
PurchaseOrderNumber String The purchase order number for the transaction.
RequestedAmount Decimal The amount requested. This will only be present for partial authorization transactions. For other transactions it is not listed because it is always the same as AuthAmount.
AuthAmount Decimal The amount authorized or refunded.
SettleAmount Decimal The amount that was submitted for settlement.
TaxAmount Decimal The amount of the tax.
TaxName String The name of the tax.
TaxDescription String The description of the tax.
ShippingAmount Decimal The amount charged for shipping.
ShippingName String The name of the shipping charges.
ShippingDescription String The description of the shipping charges.
DutyAmount Decimal The amount of the duty.
DutyName String The name of the duty.
DutyDescription String The description of the duty.
PrepaidBalanceRemaining Decimal The amount remaining on the prepaid card at the time of the transaction.
TaxExempt Boolean Indicates whether the item is tax exempt.
CardNumber String The credit card number.
CardExpirationDate String The expiration date.
CardAccountType String The type of credit card. Valid values: Visa, MasterCard, AmericanExpress, Discover, JCB, DinersClub.

The allowed values are Visa, MasterCard, AmericanExpress, Discover, JCB, DinersClub.

BankRoutingNumber String The routing number of the bank.
BankAccountNumber String The masked bank account number.
BankNameOnAccount String The name on the bank account.
BankEcheckType String The echeck type used for the transaction. Valid values: PPD, WEB, CCD, TEL.

The allowed values are PPD, WEB.CCD.TEL.

CustomerType String The customer type. Valid values: individual, business.

The allowed values are individual, business.

CustomerId String The merchant-assigned customer Id.
CustomerEmail String The email address of the customer.
BillToFirstName String The first name associated with the billing address of the customer.
BillToLastName String The last name associated with the billing address of the customer.
BillToCompany String The company name associated with the billing address of the customer.
BillToAddress String The billing address of the customer.
BillToCity String The city of the billing address of the customer.
BillToState String The state of the billing address of the customer.
BillToZip String The ZIP of the billing address of the customer.
BillToCountry String The country of the billing address of the customer.
BillToPhoneNumber String The phone number for the billing address of the customer.
BillToFaxNumber String The fax number for the billing address of the customer.
ShipToFirstName String The first name associated with the shipping address of the customer.
ShipToLastName String The last name associated with the shipping address of the customer.
ShipToCompany String The company name associated with the shipping address of the customer.
ShipToAddress String The shipping address of the customer.
ShipToCity String The city of the shipping address of the customer.
ShipToState String The state of the shipping address of the customer.
ShipToZip String The ZIP of the shipping address of the customer.
ShipToCountry String The country of the shipping address of the customer.
SubscriptionId String The subscription Id.
SubscriptionPayNum Integer Identifies the number of this transaction, in terms of how many transactions have been submitted for this subscription.
SolutionId String The solution Id generated by Authorize.Net and provided to the solution provider.
SolutionName String The name generated by the solution provider and provided to Authorize.Net.
CustomerIP String The IP address for the customer.
MobileDeviceId String The unique identifier of the mobile device.
MarketType String The market type used to process the transaction. Valid values: 0 (eCommerce), 1 (MOTO), 2 (Retail).
Product String The product method used to process the transaction. Valid values: Card Not Present, Card Present.

The allowed values are Card Not Present, Card Present.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462