CData Excel Add-In for USPS 2019J - Online Help

Packages

CData Excel Add-In for USPS 2019J - Build 19.0.7354

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, Length, and Girth. It is also a good idea to specify PackagingType as well for certain stored procedures. See the example below:

INSERT INTO Packages (Weight, Length, Girth, PackagingType) VALUES ('42', '50', '20', '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).

Weight Double False

Integer weight of the package in OZ.

Length Integer False

Length of the package in IN.

Girth Integer False

Measurement around the widest part of the package in IN, perpendicular to the Length.

Width Integer False

Width of the package in IN. Used for non-rectangular packaging.

Height Integer False

Height of the Package in IN. Used for non-rectangular packaging.

PackagingType String False

Type of package as enumerated. The specified type will be applied to all Packages in the shipment.

使用できる値は次のとおりです。NONE, LETTER, PAK, BOX, 10KGBOX, 25KGBOX, SMALLEXPRESSBOX, MEDIUMEXPRESSBOX, LARGEEXPRESSBOX, TUBE, YOURPACKAGING, FLATS, PARCELS, BPM, FIRSTCLASS, PRIORITY, MACHINABLES, IRREGULARS, PARCELPOST, BPMPARCEL, MEDIAMAIL, BPMFLAT, STANDARDFLAT

PackageSize String False

Size of the package being mailed, as enumerated.

使用できる値は次のとおりです。Regular, Large, Oversize

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