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