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

CalculateRates

CData BizTalk Adapter for FedEx 2019 - Build 19.0.7354

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 = 'FedEx_Ground', ShipmentId = 3

Input

Name Type Description
IsFreight Boolean Whether the service used is freight or standard.
RequestAccountRate Boolean Whether to request a discount rate rather than list rate.
ServiceType String Type of service for which the rate is applied 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.

ShipmentId Integer Identifier for the shipment details to calculate rates for.
InsuredValue Double Insured value of the shipment.
SpecialServices String Additional services to apply to the shipment as enumerated. Valid values are the following (invalid values will be ignored for this input): 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
RateId Integer Identifier for calculated service rate.
ServiceType String Type of service for which the rate is applied. Valid values are the following: 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
QuoteDate Datetime Date of rate calculation.
RateScale String Rate scale for the service type.
RateZone String Applicable rate zone for service type.
DeliveryDate Datetime Date of shipment delivery for the ServiceType.
DeliveryDay String Day of the week for the delivery date.
EffectiveNetDiscount Decimal Net discount applied to the service type.
BaseCharge Decimal Transportation charges before surcharges and discounts applied to a service. Specific to the AccountNumber.
NetCharge Decimal Net charge amount applied to a service. Specific to the AccountNumber.
TotalDiscount Decimal Total discount amount applied to a shipment. Specific to the AccountNumber.
TotalSurcharge Decimal Total surcharge amount for all additional services 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.
ListTotalDiscount Decimal Total discount amount applied to a shipment. 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.
SignatureType String Textual description of delivery signature option as enumerated.

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