CData BizTalk Adapter for FedEx 2019 - Online Help
Questions / Feedback?

TrackShipment

CData BizTalk Adapter for FedEx 2019 - Build 19.0.7354

Returns tracking data for requested idValue of IdentifierType type. This procedure does not need to fetch input from your tables. Its output is a result set containing track event records. Each record will automatically be inserted into the TrackHistory table.

Procedure Specific Information

The stored procedure will add its output as records to the following table:

  • TrackHistory

Execute

In order to execute this procedure, one must specify TrackingId (using a valid Tracking Number). See the example below:

EXECUTE TrackShipment TrackingId = '920241085725456'

Input

Name Type Description
TrackingId String Tracking number or other identifier to track a shipment.
TrackingIdType String Type of identifier used to track shipment as enumerated.

The allowed values are TrackingNumberOrDoorTag, BillOfLading, CODReturnTrackingNumber, CustomReference, Department, FreeFormReference, GroundShipmentId, GroundMPS, InvoiceNumber, PartnerCarrierNumber, PartNumber, PONumber, RMANumber, TrackingControlNumber, ShipperReference, StandardMPS.

StartDate Date Start of ship date range used to narrow search. This value should be in the format (yyyy-MM-dd).
EndDate Date End of ship date range used to narrow search. This value should be in the format (yyyy-MM-dd).
ShipperAccountNumber Integer Account number associated with shipment.
CountryCode String Identifies the recipient's country code to which the shipment is destined.
ZipCode String Identifies the recipient's zip code to which the shipment is destined.

Result Set Columns

Name Type Description
TrackingNumber String Tracking number of package or shipment provided by user. This is consistent between all of a shipment's events.
TrackDate String The date on which the tracking was requested. This is consistent between all of a shipment's events.
ServiceType String Textual description of the service type used to ship the package or shipment. This is consistent between all of a shipment's events.
EstimatedDeliveryDate String Projected delivery date for the package or shipment. This is consistent between all of a shipment's events.
DeliveredDate String Actual date when the package or shipment (if applicable). This is consistent between all of a shipment's events.
DeliveredLocation String Relative location at which package or shipment was left (if package delivered). This is consistent between all of a shipment's events.
SignedBy String Signature of person who signed for package or shipment. This is consistent between all of a shipment's events.
RecipientAddress String Identifies the recipient's street address. This is consistent between all of a shipment's events.
RecipientCity String Identifies the recipient's city. This is consistent between all of a shipment's events.
RecipientState String Identifies the recipient's state. This is consistent between all of a shipment's events.
RecipientZipCode String Identifies the recipient's zip code. This is consistent between all of a shipment's events.
RecipientCountryCode String Identifies the recipient's country code. This is consistent between all of a shipment's events.
SenderAddress String Identifies the sender's street address. This is consistent between all of a shipment's events.
SenderCity String Identifies the sender's city. This is consistent between all of a shipment's events.
SenderState String Identifies the sender's state. This is consistent between all of a shipment's events.
SenderZipCode String Identifies the sender's zip code. This is consistent between all of a shipment's events.
SenderCountryCode String Identifies the sender's country code. This is consistent between all of a shipment's events.
Weight Double Total shipment weight. This is consistent between all of a shipment's events.
EventId Integer Identifier the tracked event. This varies between a shipment's events.
EventDate String Date of the tracked event. This varies between a shipment's events.
EventStatus String Status of the package or shipment at the time of the event. This varies between a shipment's events.
EventAddress String Street Address where event occurred. This varies between a shipment's events.
EventCity String City where event occurred. This varies between a shipment's events.
EventState String State where event occurred. This varies between a shipment's events.
EventZipCode String Zip code where event occurred. This varies between a shipment's events.
EventCountryCode String Country code where event occurred. This varies between a shipment's events.

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