JDBC Driver for Authorize.Net

Build 22.0.8462

TransactionList

Query Transactions in a batch for an Authorize.Net merchant account.

Table Specific Information

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

SELECT * FROM TransactionList WHERE BatchId='35353'

SELECT * FROM TransactionList WHERE BatchId IN ('35353', '34219')

Columns

Name Type Statistic Description
TransId [KEY] String The unique transaction Id.
BatchId String The unique batch Id.
SubmitTime Datetime Date and time the transaction was submitted.
SettlementTimeLocal Datetime Date and time the transaction was submitted in local format: YYYY-MM-DDTHH:MM:SS.mmm
TransactionStatus String The status of the transaction.
InvoiceNumber String The invoice number for the transaction.
FirstName String The first name of the customer for the transaction.
LastName String The last name of the customer for the transaction.
AccountType String The card type for this transaction (including eCheck). Valid values are: Visa, MasterCard, AmericanExpress, Discover, JCB, DinersClub, eCheck.

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

AccountNumber String The account number for the transaction.
SettleAmount Decimal The amount that was submitted for settlement.
HasReturnedItems Boolean Indicates that this transaction contains returned items.
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.
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.

MobileDeviceId String The unique identifier of the mobile device.

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