FireDAC Components for UPS

Build 20.0.7587

RateHistory

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 UPS service rendered as enumerated. 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

NetCharge Decimal False

Net charge amount 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.

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.

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