...
| View file |
|---|
| name | Tracking Statuses.xlsx |
|---|
|
API query
exec sp_executesql N'-- TrackingInfoDetailed
SELECT TOP 1
@trackingNumber as [TrackingNumber],
ShipmentDate as [ShipmentDate],
ServiceLevel as [ServiceLevel],
ShipmentStatus as [ShipmentStatus],
DueDate as [DueDate],
| Code Block |
|---|
NULLIF(ShipReference, '''') as [ShipperReference],
ShipCity as [ShipperCity],
ShipState as [ShipperStateCode],
ShipPostal as [ShipperPostalCode],
ShipCountryCode as [ShipperCountryCode],
NULLIF(ConsReference, '''') as [ConsigneeReference],
ConsCity as [ConsigneeCity],
ConsState as [ConsigneeStateCode],
ConsPostal as [ConsigneePostalCode],
ConsCountryCode as [ConsigneeCountryCode],
PODDate as [PodDate],
NULLIF(PODReceivedBy, '''') as [PodReceivedBy],
Pieces as [PieceCount],
[Weight] as [TotalWeight],
UnitOfWeight as [UnitOfWeight]
FROM vwOrderDetail_GetOdysseyShipmentHeader
WHERE ShipmentID = @ordOrderID
-- MilestonEvent
exec [dbo].[spOrderDetail_IntlShipmentRemarks] @HawbID=@ordOrderID',N'@ordOrderID uniqueidentifier,@trackingNumber nvarchar(13)',@ordOrderID='39CB3F55-97B8-429A-B075-058EBD61475A',@trackingNumber=N'WWT1590094600' |