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. |