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

GenerateReturnLabels

CData 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. Unlike GenerateLabels, this procedure will reverse the Sender and Recipient when creating the label.

Procedure Specific Information

The stored procedure will examine the following tables for input:

  • Shipments
  • Senders
  • Recipients
  • Packages
  • Payors
  • 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:

  • LabelHistory

Execute

In order to execute this procedure, one must specify ServiceType, and ShipmentId. See the example below:

EXECUTE GenerateReturnLabels ServiceType = 'FedEx_Ground', ShipmentId = 3

Input

Name Type Description
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

Name Type Description
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.

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