FireDAC Components 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.

The allowed values are 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.

The allowed values are 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).

The allowed values are LBS, KGS.

UnitPrice Decimal False

Value of each specified unit of the item.

ExportType String False

Indicates the export type.

The allowed values are Domestic, Foreign, ForeignMilitary.

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