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:
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.
Identifier for the package (required, one will be generated if unspecified).
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.
Decimal weight of the package in either LB or KG.
Length of the package in either IN or CM.
Width of the package in either IN or CM.
Height of the Package in either IN or CM.
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.