Power BI 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.

使用できる値は次のとおりです。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).

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

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