TransactionDetailItems

Query TransactionDetails to retrieve Items for an Authorize.net merchant account.

テーブル固有の情報

TransId は、WHERE 句でサポートされている唯一使用可能なカラムで、TransactionDetailItems から結果を取得する必要があります。TransId は、(=)演算子またはIN 演算子と一緒に使用できます。

SELECT * FROM TransactionDetailItems WHERE TransId = '23478353'

SELECT * FROM TransactionDetailItems WHERE TransId IN ('23478353', '23479147')


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). 使用できる値は次のとおりです。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.