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

TrackHistory

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

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 String False

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

EventCompany String False

Company name if delivered to a company for a given TrackingNumber.

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.

Other String False

Other information about the tracking event.

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.

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