JDBC Driver for Authorize.Net

Build 22.0.8462

CustomerProfileTransactionList

Query Transactions in a batch for an Authorize.Net merchant account.

Table Specific Information

The CustomerProfileId is the only available supported column in the WHERE clause and it is required to retrieve results from CustomerProfileTransactionList. CustomerProfileId can be used with the (=) or IN operator.

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.

The allowed values are 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.

The allowed values are 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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462