ShippingServices
Query Shipping Services supported by the specified eBay site.
テーブル固有の情報
Select
次のクエリは、すべての有効なShipping Services を取得します。このビューでは、サポートされているフィルタはありません。
SELECT * FROM ShippingServices
Columns
Name | Type | Description |
ShippingServiceId [KEY] | Integer | Numeric identifier. A value greater than 50000 represents an international shipping service. |
CODService | Boolean | This flag is returned as true if the corresponding ShippingService value is a COD (Cash-On-Delivery) service. |
CostGroupFlat | Boolean | If returned, this is the shipping service group to which the shipping service belongs. |
Description | String | A user-friendly description of shipping service options. |
DetailVersion | String | Returns the latest version number for this field. |
DimensionsRequired | Boolean | Whether the shipping service option requires that package dimensions are provided by the seller. |
ExpeditedService | Boolean | Indicates whether the shipping service is an expedited shipping service. Only returned for sites for which the Get It Fast feature is enabled and only if true. |
InternationalService | Boolean | Indicates whether the shipping service is an international shipping service. |
MappedToShippingServiceId | Integer | The Id of another shipping service that will be used when a shipping service is deprecated. |
ShippingCategory | String | Indicates the shipping category. Shipping categories include the following: ECONOMY, STANDARD, EXPEDITED, ONE_DAY, PICKUP, OTHER, and NONE. International shipping services are generally grouped into the NONE category. |
ShippingService | String | The name of the shipping service option. If the ValidForSellingFlow column is not true, this particular shipping service option is no longer valid and cannot be offered to buyers through a listing. |
ShippingTimeMax | Integer | The maximum guaranteed number of days the shipping carrier will take to ship an item (not including the time it takes the seller to deliver the item to the shipping carrier). Always returned when ExpeditedService is true or if defined for a particular service. |
ShippingTimeMin | Integer | The minimum guaranteed number of days the shipping carrier will take to ship an item (not including the time it takes the seller to deliver the item to the shipping carrier). Always returned when ExpeditedService is true or if defined for a particular service. |
SurchargeApplicable | Boolean | True if a surcharge applies for any region that this service ships to. |
UpdateTime | Datetime | Gives the time in GMT that the feature flags for the details were last updated. |
ValidForSellingFlow | Boolean | If this field is returned as true, the shipping service option can be used. If this field is returned as false, the shipping service option is not currently supported. |
WeightRequired | Boolean | If true, a seller who selects this package type for the listing and then offers this shipping service must specify WeightMajor and WeightMinor in the item definition. If not returned, WeightRequired is false. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
DetailName | String | A designation of what kind of information you wish returned for the specified eBay site.
使用できる値は次のとおりです。ShippingServiceDetails |