TransactionList
Query Transactions in a batch for an Authorize.net merchant account.
テーブル固有の情報
BatchId は、WHERE 句でサポートされている唯一使用可能なカラムで、TransactionList から結果を取得する必要があります。BatchId は、(=)演算子またはIN 演算子と一緒に使用できます。
SELECT * FROM TransactionList WHERE BatchId = '35353'
SELECT * FROM TransactionList WHERE BatchId IN ('35353', '34219')
Columns
| Name | Type | Statistic | Description |
| TransId [KEY] | String | The unique transaction Id. | |
| BatchId | String | The unique batch 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.
使用できる値は次のとおりです。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.
使用できる値は次のとおりです。Card Not Present, Card Present | |
| MobileDeviceId | String | The unique identifier of the mobile device. |