Power BI Connector for UPS

Build 20.0.7587

GenerateLabels

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, 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:

  • Shipments
  • Senders
  • Recipients
  • Packages
  • Payors
  • CommercialInvoices (Intl only)
  • Commodities (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 GenerateLabels ServiceType = '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.

使用できる値は次のとおりです。Unspecified, First_Class, Priority_Mail, Expedited_Mail_Innovations, Priority_Mail_Innovations, Economy_Mail_Innovations, Next_Day_Air, Express, 2nd_Day_Air, Ground, Worldwide_Express, Worldwide_Expedited, Expedited, Standard, 3Day_Select, Next_Day_Air_Saver, Saver, Next_Day_Air_Early_AM, Express_Early_AM, Worldwide_Express_Plus, Express_Plus, 2nd_Day_Air_AM, Today_Standard, Today_Courrier, Today_Inter_City, Today_Express, Today_Express_Saver, Worldwide_Express_Freight, Sure_Post_Less_Than_1LB, Sure_Post_1LB_OR_Greater, Sure_Post_BPM, Sure_Post_Media

LabelImageType String File format of of the generated label as enumerated.

使用できる値は次のとおりです。GIF, EPL, SPL, ZPL, STAR

SpecialServices String Additional services to apply to the shipment as enumerated.

使用できる値は次のとおりです。HoldForPickup, LiftgateDropoff, LiftgatePickup, ReturnShipment, SaturdayPickup, SaturdayDelivery, ReturnOfDocument, ImportControl, CommercialInvoiceRemoval, ExchangeForward, CarbonNeutral, DropoffAtUPSFacility, DeliverToAddresseeOnly, DirectDeliveryOnly

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.
Surcharges Decimal Total surcharges for this package.
TotalBaseCharge Decimal Base charge of the entire shipment.
TotalNetCharge Decimal Net charge of the entire shipment.
TotalSurcharges Decimal Total surcharges for 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 20.0.7587