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 |