Query Unsettled Transactions for an Authorize.Net merchant account.
Table Specific Information
This table does not support any columns in the WHERE clause.
SELECT * FROM UnsettledTransactionList
|TransId [KEY]||String||The unique transaction Id.|
|SubmitTime||Datetime||Date and time the transaction was submitted.|
|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.|
|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||String||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.