UnsettledTransactionList
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
Columns
| Name | Type | Statistic | Description |
| 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. |