TransactionDetailItems
Query TransactionDetails to retrieve Items for an Authorize.Net merchant account.
Table Specific Information
The TransId is the only available supported column in the WHERE clause and it is required to retrieve results from TransactionDetailItems. TransId can be used with the (=) or IN operator.
SELECT * FROM TransactionDetailItems WHERE TransId='23478353'
SELECT * FROM TransactionDetailItems WHERE TransId IN ('23478353', '23479147')
Columns
| Name | Type | Statistic | Description |
| TransId [KEY] | String | The unique transaction Id. | |
| ItemId [KEY] | String | The Id assigned to an item. | |
| BatchId | String | The Id of the batch the transaction is in. | |
| SettlementTime | Datetime | Date and time the transaction was settled. | |
| SettlementState | String | Status of the batch. Valid values: settledSuccessfully, settlementError, pendingSettlement. | |
| ResponseCode | Integer | The overall status of the transaction. Valid values: 1 (Approved), 2 (Declined), 3 (Error), 4 (Held for review).
The allowed values are 1, 2, 3, 4. | |
| InvoiceNumber | String | The invoice number for the transaction. | |
| PurchaseOrderNumber | String | The purchase order number for the transaction. | |
| AuthAmount | Decimal | The amount authorized or refunded. | |
| CustomerId | String | The merchant-assigned customer Id. | |
| CustomerEmail | String | The email address of the customer. | |
| ReturnedItemId | String | The transaction ID for returned item | |
| ReturnedItemDate | Datetime | Date the item was returned. | |
| ReturnedItemCode | String | The ACH return code. | |
| ReturnedItemDescription | String | A text description of the reason for the return. | |
| ItemName | String | The short description of the item. | |
| ItemDescription | String | The detailed description of the item. | |
| ItemQuantity | Double | The number of items sold. | |
| ItemUnitPrice | Decimal | The cost of the item per unit, excluding tax, freight, and duty. | |
| ItemTaxable | Boolean | Indicates whether the item is subject to tax. |