GenerateLabelsCData BizTalk Adapter for FedEx 2019 - Build 19.0.7354
Generates a shipping label for each package in a given shipment. This table will, at a minimum, take pertinent input information from the Shipments, Senders, Recipients, and Packages tables. Depending on the ShipmentId provided, the Payors, Brokers, CommercialInvoices, and Commodities tables may be examined as well. The output will be a result set of pertinent label information across multiple records. Each record will be automatically inserted into the LabelHistory table.
Procedure Specific Information
The stored procedure will examine the following tables for input:
- Brokers (Freight/Intl only)
- CommercialInvoices (Freight/Intl only)
- Commodities (Freight/Intl only)
The stored procedure will add its output as records to the following table:
In order to execute this procedure, one must specify ServiceType, and ShipmentId. See the example below:
EXECUTE GenerateLabels ServiceType = 'FedEx_Ground', ShipmentId = 3
|ShipmentId||Integer||Identifier for the shipment details to generate the label for.|
|ServiceType||String|| Type of service for the shipment as enumerated.
The allowed values are Unspecified, Priority_Overnight, Standard_Overnight, First_Overnight, FedEx_2_Day, Express_Saver, FedEx_Ground, FedEx_Ground_Home_Delivery, FedEx_1_Day_Freight, FedEx_2_Day_Freight, FedEx_3_Day_Freight, International_Priority, FedEx_2_Day_AM, International_Economy, First_Freight, International_First, International_Priority_Freight, International_Economy_Freight, Smart_Post, Europe_First_International_Priority, International_Ground, Freight_Economy, Freight_Priority.
|DropOffType||String|| Method by which the package will be tendered as enumerated.
The allowed values are RegularPickup, RequestCourier, DropBox, BusinessServiceCenter, Station.
|LabelImageType||String|| File format of of the generated label as enumerated.
The allowed values are PDF, PNG.
|InsuredValue||Double||Insured value of the shipment.|
|SpecialServices||String|| Additional services to apply to the shipment as enumerated.
The allowed values are SaturdayPickup, SaturdayDelivery, DryIce, COD, FutureDay, EmailNotification, BrokerSelect, HoldAtLocation, LiftgateDelivery, LiftgatePickup, InsideDelivery, InsidePickup, Poison, TopLoad, DangerousGoods, DoNotBreakDownPallets, DoNotStackPallets, ElectronicTradeDocuments, ExtremeLength, FreightGuarantee, InternationalControlledExportService, ProtectFromFreezing, InternationalTrafficInArmsRegulation.
Result Set Columns
|LabelId||Integer||Identifier for generated label.|
|ShipmentId||Integer||Identifier for applicable shipment.|
|PackageId||Integer||Identifier for the specific package for this label.|
|SenderId||Integer||Identifier for the shipment's sender.|
|RecipientId||Integer||Identifier for the shipment's recipient.|
|LabelDate||Datetime||Date the label was generated.|
|MasterTrackingNumber||String||Tracking Number for the entire shipment.|
|TrackingNumber||String||Tracking Number for this package.|
|NetCharge||Decimal||Net charge for this package.|
|BaseCharge||Decimal||Base charge for this package.|
|TotalDiscount||Decimal||Total discount for this package.|
|TotalSurcharges||Decimal||Total surcharges for this package.|
|DeliveryDate||Datetime||Date of delivery for the shipment.|
|TotalNetCharge||Decimal||Net charge of the entire shipment.|
|ShippingLabelFile||String||File location for the generated label for this package.|
|ShipmentType||String||Type of service used to generate label.|
|IsReturnShipment||Boolean||Whether or not this label was for a return shipment.|