TransactionDetails
Query TransactionDetails for an Authorize.net merchant account.
テーブル固有の情報
TransId は、WHERE 句でサポートされている唯一使用可能なカラムで、TransactionDetails から結果を取得する必要があります。TransId は、(=)演算子またはIN 演算子と一緒に使用できます。
SELECT * FROM TransactionDetails WHERE TransId = '23478353' SELECT * FROM TransactionDetails WHERE TransId IN ('23478353', '23479147')
Columns
Name | Type | Statistic | Description |
TransId [KEY] | String | The unique transaction Id. | |
RefTransId | String | The transaction Id of the original transaction. This only appears for linked credits (transaction type refundTransaction). | |
SplitTenderId | String | Identifies the split tender order, if applicable. This only appears for transactions that are part of a larger partial authorization order. | |
SubmitTime | Datetime | Date and time the transaction was submitted. | |
TransactionType | String | The type of transaction that was originally submitted. Valid values: authCaptureTransaction, authOnlyTransaction, captureOnlyTransaction, refundTransaction.
使用できる値は次のとおりです。authCaptureTransaction, authOnlyTransaction, captureOnlyTransaction, refundTransaction | |
TransactionStatus | String | The status of the transaction. | |
ResponseCode | Integer | The overall status of the transaction. Valid values: 1 (Approved), 2 (Declined), 3 (Error), 4 (Held for review).
使用できる値は次のとおりです。1, 2, 3, 4 | |
ResponseReasonCode | Integer | A code that represents more details about the result of the transaction. | |
ResponseReasonDescription | String | A brief description of the result, which corresponds with the response reason code. | |
AuthCode | String | The authorization or approval code. | |
AVSResponse | String | Response from the AVS security check. Indicates the result of the AVS filter. | |
CardCodeResponse | String | Response from the card code security check. Indicates the result of the CCV filter. | |
CAVVResponse | String | The cardholder authentication verification response code. | |
FDSFilterAction | String | The action taken for a transaction that triggered one or more of the Advanced Fraud Detection Suite filters. Valid values: reject, decline, hold, authAndHold, report. | |
FDSFiltersName | String | A comma-separated list of fraud filter names. | |
FDSFiltersAction | String | A comma-separated list of fraud filter settings. | |
BatchId | String | The Id of the batch the transaction is in. | |
SettlementTime | Datetime | Date and time the transaction was settled. | |
SettlementState | String | Status of the batch. Valid values: settledSuccessfully, settlementError, pendingSettlement.
使用できる値は次のとおりです。settledSuccessfully, settlementError, pendingSettlement | |
InvoiceNumber | String | The invoice number for the transaction. | |
Description | String | The description of the transaction. | |
PurchaseOrderNumber | String | The purchase order number for the transaction. | |
RequestedAmount | Decimal | The amount requested. This will only be present for partial authorization transactions. For other transactions it is not listed because it is always the same as AuthAmount. | |
AuthAmount | Decimal | The amount authorized or refunded. | |
SettleAmount | Decimal | The amount that was submitted for settlement. | |
TaxAmount | Decimal | The amount of the tax. | |
TaxName | String | The name of the tax. | |
TaxDescription | String | The description of the tax. | |
ShippingAmount | Decimal | The amount charged for shipping. | |
ShippingName | String | The name of the shipping charges. | |
ShippingDescription | String | The description of the shipping charges. | |
DutyAmount | Decimal | The amount of the duty. | |
DutyName | String | The name of the duty. | |
DutyDescription | String | The description of the duty. | |
PrepaidBalanceRemaining | Decimal | The amount remaining on the prepaid card at the time of the transaction. | |
TaxExempt | Boolean | Indicates whether the item is tax exempt. | |
CardNumber | String | The credit card number. | |
CardExpirationDate | String | The expiration date. | |
CardAccountType | String | The type of credit card. Valid values: Visa, MasterCard, AmericanExpress, Discover, JCB, DinersClub.
使用できる値は次のとおりです。Visa, MasterCard, AmericanExpress, Discover, JCB, DinersClub | |
BankRoutingNumber | String | The routing number of the bank. | |
BankAccountNumber | String | The masked bank account number. | |
BankNameOnAccount | String | The name on the bank account. | |
BankEcheckType | String | The echeck type used for the transaction. Valid values: PPD, WEB, CCD, TEL.
使用できる値は次のとおりです。PPD, WEB.CCD.TEL | |
CustomerType | String | The customer type. Valid values: individual, business.
使用できる値は次のとおりです。individual, business | |
CustomerId | String | The merchant-assigned customer Id. | |
CustomerEmail | String | The email address of the customer. | |
BillToFirstName | String | The first name associated with the billing address of the customer. | |
BillToLastName | String | The last name associated with the billing address of the customer. | |
BillToCompany | String | The company name associated with the billing address of the customer. | |
BillToAddress | String | The billing address of the customer. | |
BillToCity | String | The city of the billing address of the customer. | |
BillToState | String | The state of the billing address of the customer. | |
BillToZip | String | The ZIP of the billing address of the customer. | |
BillToCountry | String | The country of the billing address of the customer. | |
BillToPhoneNumber | String | The phone number for the billing address of the customer. | |
BillToFaxNumber | String | The fax number for the billing address of the customer. | |
ShipToFirstName | String | The first name associated with the shipping address of the customer. | |
ShipToLastName | String | The last name associated with the shipping address of the customer. | |
ShipToCompany | String | The company name associated with the shipping address of the customer. | |
ShipToAddress | String | The shipping address of the customer. | |
ShipToCity | String | The city of the shipping address of the customer. | |
ShipToState | String | The state of the shipping address of the customer. | |
ShipToZip | String | The ZIP of the shipping address of the customer. | |
ShipToCountry | String | The country of the shipping address of the customer. | |
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. | |
SolutionId | String | The solution Id generated by Authorize.net and provided to the solution provider. | |
SolutionName | String | The name generated by the solution provider and provided to Authorize.net. | |
CustomerIP | String | The IP address for the customer. | |
MobileDeviceId | String | The unique identifier of the mobile device. | |
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 |