MuleSoft Connector for UPS

Build 20.0.7587

CalculateRates

Returns rate information for a specified service or all services. This table will, at a minimum, take pertinent input information from the Shipments, Senders, Recipients, and Packages tables. The information it fetches from these tables will depend on the provided ShipmentId. The output will be a result set of individual services that will all be automatically inserted into the RateHistory table.

Procedure Specific Information

The stored procedure will examine the following tables for input:

  • Shipments
  • Senders
  • Recipients
  • Packages

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

  • RateHistory

Execute

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

EXECUTE CalculateRates ServiceType = 'Ground', ShipmentId = 3

Input

Name Type Description
ServiceType String Type of service for which the rate is applied as enumerated.

The allowed values are 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.

PickupType String Pickup type used for the shipment as enumerated.

The allowed values are DailyPickup, CustomerCounter, OneTimePickup, OnCallAir, LetterCenter, AirServiceCenter, None.

CustomerType String Customer classification code as enumerated.

The allowed values are None, ShipperNumber, Daily, Retail, Standard.

CurrencyCode String Three letter currency code for monetary values.
ShipmentId Integer Identifier for the shipment details to calculate rates for.

Result Set Columns

Name Type Description
RateId Integer Identifier for calculated service rate.
ServiceType String Type of service for which the rate is applied. Valid values are the following: 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
QuoteDate Datetime Date of rate calculation.
NetCharge Decimal Net charge amount applied to a service. Specific to the AccountNumber.
ListBaseCharge Decimal Transportation charges before surcharges and discounts applied to a service. Applied only when RequestAccountRate was set to false during rate calculation.
ListNetCharge Decimal Net charge amount applied to a service. Applied only when RequestAccountRate was set to false during rate calculation.
ListTotalSurcharge Decimal Total surcharge amount for all additional services applied to a service. Applied only when RequestAccountRate was set to false during rate calculation.
TransitTime String Textual description of the time of transit as enumerated.

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