Tableau Connector for Authorize.net

Build 24.0.9062

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062