SSIS Components for UPS

Build 20.0.7587

TrackHistory

Contains tracked events for a shipment's progress. This table is populated by the TrackShipment stored procedure. Consequently, it is not possible to INSERT or UPDATE this table directly, but DELETE is still enabled.

Table Specific Information

The following stored procedures will add records to this table:

  • TrackShipment

Insert

INSERT statements are not supported for this table.

Update

UPDATE statements are not supported for this table.

Columns

Name Type ReadOnly References Description
EventId [KEY] Integer False

Identifier for the tracked event. This varies between a shipment's events.

EventDate Datetime False

Date of the tracked event. This varies between a shipment's events.

EventStatus String False

Status of the package or shipment at the time of the event. This varies between a shipment's events.

EventLocation String False

Location description where a tracking event occurred. This varies between a shipment's events.

EventAddress String False

Street Address where event occurred. This varies between a shipment's events.

EventCity String False

City where event occurred. This varies between a shipment's events.

EventState String False

State where event occurred. This varies between a shipment's events.

EventZipCode String False

Zip code where event occurred. This varies between a shipment's events.

EventCountryCode String False

Country code where event occurred. This varies between a shipment's events.

TrackingNumber String False

Tracking number of package or shipment provided by user. This is consistent between all of a shipment's events.

TrackDate Datetime False

The date on which the tracking was requested. This is consistent between all of a shipment's events.

ServiceType String False

Textual description of the service type used to ship the package or shipment. This is consistent between all of a shipment's events.

ScheduledDeliveryDate String False

Scheduled delivery date for the package or shipment, if any. This is consistent between all of a shipment's events.

ShipmentReference String False

Reference number pertaining to shipment, if any. This is consistent between all of a shipment's events.

RecipientAddress String False

Identifies the recipient's street address. This is consistent between all of a shipment's events.

RecipientCity String False

Identifies the recipient's city. This is consistent between all of a shipment's events.

RecipientState String False

Identifies the recipient's state. This is consistent between all of a shipment's events.

RecipientZipCode String False

Identifies the recipient's zip code. This is consistent between all of a shipment's events.

RecipientCountryCode String False

Identifies the recipient's country code. This is consistent between all of a shipment's events.

SenderAddress String False

Identifies the sender's street address. This is consistent between all of a shipment's events.

SenderCity String False

Identifies the sender's city. This is consistent between all of a shipment's events.

SenderState String False

Identifies the sender's state. This is consistent between all of a shipment's events.

SenderZipCode String False

Identifies the sender's zip code. This is consistent between all of a shipment's events.

SenderCountryCode String False

Identifies the sender's country code. This is consistent between all of a shipment's events.

Weight Double False

Total shipment weight. This is consistent between all of a shipment's events.

WeightUnit String False

Unit of measure for total shipment weight. This is consistent between all of a shipment's events.

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