Schedules a courier pickup from a specified sender's location. Input information will, at a minimum, be gathered from the Senders table. While the ConfirmationNumber is displayed immediately, this value will be inserted alongside other pertinent values in the Pickups table automatically.
Procedure Specific Information
The stored procedure will examine the following tables for input:
The stored procedure will add its output as records to the following table:
In order to execute this procedure, one must specify SenderId, and PackageId. See the example below:
EXECUTE SchedulePickup SenderId = 3, PackageId = '9,13,17'
|IsInternational||Boolean|| Whether the pickup will use the Intl service.
The default value is false.
|ShipDate||Date||Date when package will be tendered. This value should be in the format (yyyy-MM-dd).|
|EarliestPickupTime||Time||Earliest time a shipment can be picked up. This value should be in the format (HH:mm:ss).|
|LatestPickupTime||Time||Latest time a shipment can be picked up. This value should be in the format (HH:mm:ss).|
|FloorNumber||Integer||Pickup location's floor number.|
|RoomNumber||Integer||Pickup location's room number.|
|SenderId||Integer||Identifier for the Sender requesting pickup.|
Result Set Columns
|PickupId||Integer||Identifier for the pickup request.|
|ConfirmationNumber||String||Confirmation number for the pickup request.|
|EarliestPickupTime||String||Earliest time a shipment can be picked up.|
|LatestPickupTime||String||Latest time a shipment can be picked up.|
|PickupType||String||Pickup type as enumerated.|
|SenderId||String||Identifier of the sender requesting the pickup.|
|ShipDate||Date||Date when package will be tendered.|