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