CustomerProfileTransactionList
Query Transactions in a batch for an Authorize.net merchant account.
テーブル固有の情報
CustomerProfileId は、WHERE 句でサポートされている唯一使用可能なカラムで、CustomerProfileTransactionList から結果を取得する必要があります。CustomerProfileId は、(=)演算子またはIN 演算子と一緒に使用できます。
SELECT * FROM TransactionList WHERE CustomerProfileId = '1915622429'
SELECT * FROM TransactionList WHERE CustomerProfileId IN ('1915622429', '3543535')
Columns
| Name | Type | Statistic | Description |
| TransId [KEY] | String | The unique transaction 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. | |
| CustomerProfileId | String | The ID number associated with the customer profile. | |
| CustomerPaymentProfileId | String | The ID of the customer payment profile used to charge this transaction. |