ODBC Driver for eBay

Build 24.0.8963

TransactionShipping

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

ビュー固有の情報

Select

TransactionShipping ビューのクエリ例:

SELECT * FROM TransactionShipping WHERE ModTimeFrom = '2/22/2018' AND ModTimeTo = '3/4/2018'

SELECT * FROM TransactionShipping WHERE OrderId = '110277719772-28859911001'

SELECT * FROM TransactionShipping WHERE OrderId IN ('110277719772-28859911001', '110276240386-28854859001')

Columns

Name Type Description
TransactionId [KEY] String Unique identifier for the transaction.
OrderId String Unique identifier for the order.
InternationalPackagingHandlingCosts Decimal Fees a seller might assess for the shipping of the item (in addition to whatever the shipping service might charge).
PostalCode String Postal code for the location from which the package will be shipped.
PackagingHandlingCosts Decimal Fees a seller might assess for the shipping of the item (in addition to whatever the shipping service might charge).
ShippingIrregular Boolean This boolean field indicates that the shipping package is considered an irregular shape and/or size by the shipping carrier, and thus requires special handling.
ExpeditedService Boolean Indicates whether the service is an expedited shipping service.
ShippingImportCharge Decimal The total cost of customs and taxes for the international leg of an order shipped using the Global Shipping Program.
ShippingInsuranceCost Decimal The insurance cost associated with shipping a single item with this shipping service.
ShippingServiceAdditionalCost Decimal The cost of shipping each additional item if the same buyer purchases multiple quantity of the same line item.
ShippingServiceCost Decimal The base cost of shipping the item using the shipping service specified in the ShippingService field.
ShippingPackageInfo String This aggregate contains all shipping package info.
ShipmentTrackingNumbers String The tracking numbers assigned by the shipping carriers.
ShippingCarriers String The name of the shipping carriers used to ship the items.

Pseudo-Columns

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

Name Type Description
CreateTimeFrom Datetime Specifies the start of the date range for which to retrieve shipping details of the transactions in orders created within this date range. By default the date range is 90 days.
CreateTimeTo Datetime Specifies the end of the date range for which to retrieve shipping details of the transactions in orders created within this date range. By default the date range is 90 days.
ModTimeFrom Datetime Specifies the start of the date range for which to retrieve shipping details of the transactions in 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 shipping details of the transactions in orders modified within this date range. The maximum time range that may be specified is 30 days.
NumberOfDays Integer All eBay shipping details of the transactions in orders that were either created or modified within this period are returned in the output. Min: 1. Max: 30.
OrderRole String Filters the returned shipping details of the transactions based on the role of the user. The user's role is either buyer or seller.
OrderStatus String Filters the returned shipping details of the 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