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

RateHistory

CData BizTalk Adapter for FedEx 2019 - Build 19.0.7354

Collection of calculated service rates. This table is populated by the CalculateRates stored procedure. Consequently, it is not possible to INSERT or UPDATE this table directly, but DELETE is still enabled.

Table Specific Information

The following stored procedures will add records to this table:

  • CalculateRates

Insert

INSERT statements are not supported for this table.

Update

UPDATE statements are not supported for this table.

Columns

Name Type ReadOnly References Description
RateId [KEY] Integer False

Identifier of the calculated rate.

QuoteDate Datetime False

Date of rate calculation.

ServiceType String False

Type of Fedex service rendered as enumerated. 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

RateScale String False

Rate scale for the service type.

RateZone String False

Applicable rate zone for service type.

DeliveryDate Datetime False

Date of shipment delivery for the ServiceType.

DeliveryDay String False

Day of the week for the delivery date.

EffectiveNetDiscount Decimal False

Net discount applied to the service type.

BaseCharge Decimal False

Transportation charges before surcharges and discounts applied to a service. Specific to the AccountNumber.

NetCharge Decimal False

Net charge amount applied to a service. Specific to the AccountNumber.

TotalDiscount Decimal False

Total discount amount applied to a shipment. Specific to the AccountNumber.

TotalSurcharge Decimal False

Total surcharge amount for all additional services applied to a service. Specific to the AccountNumber.

ListBaseCharge Decimal False

Transportation charges before surcharges and discounts applied to a service. Applied only when RequestAccountRate was set to false during rate calculation.

ListNetCharge Decimal False

Net charge amount applied to a service. Applied only when RequestAccountRate was set to false during rate calculation.

ListTotalDiscount Decimal False

Total discount amount applied to a shipment. Applied only when RequestAccountRate was set to false during rate calculation.

ListTotalSurcharge Decimal False

Total surcharge amount for all additional services applied to a service. Applied only when RequestAccountRate was set to false during rate calculation.

TransitTime String False

Textual description of the time of transit as enumerated.

The allowed values are ONE_DAY, TWO_DAYS, THREE_DAYS, FOUR_DAYS, FIVE_DAYS, SIX_DAYS, SEVEN_DAYS, EIGHT_DAYS, NINE_DAYS, UNKNOWN.

SignatureType String False

Textual description of delivery signature option as enumerated.

The allowed values are ADULT, DIRECT, INDIRECT, NO_SIGNATURE_REQUIRED, SERVICE_DEFAULT.

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