ODBC Driver for eBay

Build 24.0.8963

Transactions

Query all transactions in which the authenticated user is either the buyer or seller. By default, only transactions of orders made in the last 90 days are returned. Transactions of orders older than 90 days can be retrieved by specifying OrderId.

ビュー固有の情報

Select

Transactions ビューのクエリ例:

SELECT * FROM Transactions WHERE OrderRole = 'Seller'

SELECT * FROM Transactions WHERE OrderId = '110276240386-28854859001'

SELECT * FROM Transactions WHERE CreateTimeFrom = '2/10/2018' AND CreateTimeTo = '3/16/2018'

Columns

Name Type Description
TransactionId [KEY] String Unique identifier for an eBay order line item. An order line item is created once there is a commitment from a buyer to purchase an item.
OrderId String The Id that uniquely identifies the item listing. The Id is generated by eBay after an item is listed. You cannot choose or revise this value.
ItemId String The unique identifier of the eBay listing. This identifier is generated by eBay and returned in the response of an Add call if an item is successfully listed.
ItemSite String The name of the site on which the item is listed.
ItemTitle String This field is used to specify the title of the listing.
ActualHandlingCost Decimal The handling cost that the seller has charged for the order line item.
ActualShippingCost Decimal The shipping cost paid by the buyer for the order line item. This field is only returned after checkout is complete.
BuyerEmail String Email address for the user.
BuyerFirstName String The first name of the buyer who purchased the order.
BuyerLastName String The last name of the buyer who purchased the order.
CreatedDate Datetime Indicates the creation time of the order line item.
Price Decimal The price of the order line item.
SiteId String The site upon which the order line item (transaction) was created.
PaidTime Datetime Indicates the time when the order was marked paid.
DigitalRecipientEmail String This field displays the email address of the sender/purchaser of the digital gift card.
DigitalRecipientName String This field displays the actual name (not the eBay user ID) of the sender/purchaser of the digital gift card.
DigitalSenderEmail String This field displays the email address of the sender/purchaser of the digital gift card.
DigitalSenderName String This field displays the actual name (not the eBay user ID) of the sender/purchaser of the digital gift card
DigitalDeliveryMethod String This value indicates the method in which the digital gift card will be delivered to the buyer.
EBayPlusTransaction Boolean If true, this transaction is for an item that was purchased under the eBay Plus program.
FinalValueFee Decimal A Final Value Fee is calculated and charged to a seller's account immediately upon creation of an order line item.
GuaranteedDelivery Boolean This field is returned as true if the order line item is qualified for eBay Guaranteed Delivery, or false if it is not eligible.
GuaranteedShipping Boolean This field is returned as true if the seller chose to use eBay's Guaranteed Shipping feature at listing time.
InvoiceSentTime Datetime This field indicates the date/time that an order invoice was sent from the seller to the buyer.
DigitalStatus String This enumeration value indicates the current state of a purchased digital gift card.
InquiryStatus String This field gives the status of a buyer's Item Not Received (INR) Inquiry.
ReturnStatus String This field gives the status of a buyer's return request.
TotalTaxAmount Decimal This value indicates the total tax amount for the order line item, including the sales tax on the item, the sales tax on shipping and handling, and any electronic waste recycling fee.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
CreateTimeFrom Datetime Specifies the start of the date range for which to retrieve transactions of orders created within this date range.
CreateTimeTo Datetime Specifies the end of the date range for which to retrieve transactions of orders created within this date range.
ModTimeFrom Datetime Specifies the start of the date range for which to retrieve transactions of orders modified within this date range. The maximum time range that may be specified is 30 days.
ModTimeTo Datetime Specifies the end of the date range for which to retrieve transactions of orders modified within this date range. The maximum time range that may be specified is 30 days.
NumberOfDays Integer All eBay transactions that were either created or modified within this period are returned in the output. Min: 1. Max: 30.
OrderRole String Filters the returned transactions based on the role of the user. The user's role is either buyer or seller.
OrderStatus String Filters the returned transactions based on the status of the order. Applicable Values: Active, All, Completed, Inactive.

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