BizTalk Adapter for USPS

Build 20.0.7587

Pickups

Details of scheduled Pickups from a sender's location. This table is populated by the SchedulePickups stored procedure. Consequently, it is not possible to INSERT or UPDATE this table directly, but DELETE is still enabled. It should also be noted that the CancelPickup stored procedure will remove records from this table.

Table Specific Information

The following stored procedures will add records to this table:

  • SchedulePickup

The following stored procedures will remove records from this table:

  • CancelPickup

Insert

INSERT statements are not supported for this table.

Update

UPDATE statements are not supported for this table.

Columns

Name Type ReadOnly References Description
PickupId [KEY] Integer False

Identifier for the pickup.

ConfirmationNumber String False

Confirmation number for the pickup.

ShipDate String False

Date that the package will be tendered.

CarrierRoute String False

The carrier route. This can be

SenderId String False

Identifier of the sender requesting the pickup.

TotalWeight Integer False

The estimated weight for the packages to be picked up.

ExpressCount Integer False

The number of Express Mail packages to be picked up.

PriorityCount Integer False

The number of Priority Mail packages to be picked up.

InternationalCount Integer False

The number of International Mail packages to be picked up.

OtherCount Integer False

The number of mail packages to be picked up, outside of Priority/Express/Intl.

PackageLocation String False

A description of the location of pickup.

SpecialInstructions String False

Special instructions for pickup location, if any.

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