MuleSoft Connector for UPS

Build 20.0.7587

Packages

Type and measures of a given package. This table is initially empty and must be populated by user action. Stored Procedures may then retrieve this information as input via Id references. All shipments will need at least one package specified for them.

Table Specific Information

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

  • CalculateRates
  • GenerateLabels
  • GenerateReturnLabels
  • PickupAvailability
  • SchedulePickup

Insert

In order to add a Package, one must specify Weight. It is also a good idea to specify PackagingType as well for certain stored procedures. See the example below:

INSERT INTO Packages (Weight, PackagingType) VALUES (13.37, 'YOURPACKAGING')
One may specify a PackageId on creation. However, if one is not provided, then a PackageId be auto-generated.

Columns

Name Type ReadOnly References Description
PackageId [KEY] Integer False

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

PackagingType String False

Type of package as enumerated.

The allowed values are NONE, LETTER, PAK, BOX, 10KGBOX, 25KGBOX, SMALLEXPRESSBOX, MEDIUMEXPRESSBOX, LARGEEXPRESSBOX, TUBE, YOURPACKAGING, FLATS, PARCELS, BPM, FIRSTCLASS, PRIORITY, MACHINABLES, IRREGULARS, PARCELPOST, BPMPARCEL, MEDIAMAIL, BPMFLAT, STANDARDFLAT.

Weight Double False

Decimal weight of the package in either LB or KG.

Length Integer False

Length of the package in either IN or CM.

Width Integer False

Width of the package in either IN or CM.

Height Integer False

Height of the Package in either IN or CM.

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.

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