Query Transactions in a batch for an Authorize.Net merchant account.
Table Specific Information
The CustomerProfileId is the only available supported column in the WHERE clause and it is required to retrieve results from CustomerProfileTransactionList. CustomerProfileId can be used with the (=) or IN operator.
SELECT * FROM TransactionList WHERE CustomerProfileId='1915622429' SELECT * FROM TransactionList WHERE CustomerProfileId IN ('1915622429', '3543535')
|TransId [KEY]||String||The unique transaction 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.|
|CustomerProfileId||String||The ID number associated with the customer profile.|
|CustomerPaymentProfileId||String||The ID of the customer payment profile used to charge this transaction.|