Power BI Connector for UPS

Build 20.0.7587

Commodities

Details about a commodity item. This table is initially empty and must be populated by user action. Stored Procedures may then retrieve this information as input via Id references. Specification of at least one commodity item is required only for freight and international shipments.

Table Specific Information

The following stored procedures will rely on input from this table:

  • GenerateLabels (Freight/Intl only)
  • GenerateReturnLabels (Freight/Intl only)
  • SchedulePickup (Freight/Intl only)

Insert

In order to add a Commodity, one must specify Description, Manufacturer, Weight, Quantity, QuantityUnit, and UnitPrice. See the example below:

INSERT INTO Commodities (Description, Manufacturer, Weight, Quantity, QuantityUnit, UnitPrice) VALUES ('Petroleum', 'US', 49.00, 12, 'GAL', 2.50)
One may specify a CommodityId on creation. However, if one is not provided, then a CommodityId be auto-generated.

Columns

Name Type ReadOnly References Description
CommodityId [KEY] Integer False

Identifier for the commodity (required, one will be generated if unspecified).

CommodityType String False

Packaging type of commodity item as enumerated.

使用できる値は次のとおりです。BAG, BARREL, BASKT, BOX, BUCKET, BUNDLE, CARTON, CASE, CONTAINER, CRATE, CYLINDER, DRUM, ENVELOPE, HAMPER, OTHER, PAIL, PALLET, PIECES, REEL, ROLL, SKID, TANK, TUBE

Description String False

Textual description of commodity item.

Manufacturer String False

Country code of where final product was produced.

NumberOfPieces Integer False

Total number of containers of this item.

FreightNMFC String False

Textual description of commodity item.

FreightNMFCSub String False

Textual description of commodity item.

FreightIsHazardous Boolean False

Textual description of commodity item.

Weight Double False

Weight of the commodity item.

Quantity Integer False

Number of specified units of the commodity item.

QuantityUnit String False

Specified unit of commodity item as enumerated.

使用できる値は次のとおりです。AR, CG, CM, CM3, CFT, M3, DOZ, DPR, EA, GAL, G, GR, KGM, KG, LFT, LNM, LYD, L, LTR, MG, ML, NO, OZ, PR, PRS, PCS, LB, CM2, SFT, SQI, M2, SYD, YD

WeightUnit String False

Specified unit of the commodity's weight. SizeUnit is adjusted automatically based on WeightUnit (IN for LBS and CM for KGS).

使用できる値は次のとおりです。LBS, KGS

UnitPrice Decimal False

Value of each specified unit of the item.

ExportType String False

Indicates the export type.

使用できる値は次のとおりです。Domestic, Foreign, ForeignMilitary

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587