ShipmentsCData Excel Add-In for USPS 2019J - Build 19.0.7354
Linked entity associations for a shipment. Every shipment will at least need a Sender, Recipient, and at least one Package. It will be from a specified ShipmentId that certain stored procedures (like GenerateLabels) will fetch needed input information from the other related tables, such as Senders, Recipients, and Packages.
Table Specific Information
The following stored procedures will rely on input from this table:
In order to add a Shipment, one must specify SenderId, RecipientId, and PackageId. See the example below:
INSERT INTO Shipments (SenderId, RecipientId, PackageId) VALUES ('3', '7', '9,13,17')One may specify a ShipmentId on creation. However, if one is not provided, then a ShipmentId be auto-generated.
Identifier of the shipment preset (required, one will be generated if unspecified).
Date when package will be shipped. This value should be in the format (yyyy-MM-dd).
Time when package will be shipped. This value should be in the format (hh:mm:ss).
Comma-separated list of packages in shipment. The specified packages must all use the same SizeUnit and WeightUnit. Otherwise, an error may be encountered during the execution of a stored procedure.
The shipment's sender.
The shipment's recipient.
Comma-separated list of commodities in the shipment. Specific to international shipments (intl only).
Description of items being shipped, as enumerated (intl only).
使用できる値は次のとおりです。Sample, Gift, Documents, Return, Other, Merchandise, HumanitarianDonation, DangerousGoods
Description of the contents. This should be provided only if Contents is set to
Certificate number, which some countries require for certain items to be imported (intl only).
Invoice number if known or included in the package (intl only).
Import License number, which many many countries require the sender to obtain in order to import certain items (intl only).