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:
INSERT statements are not supported for this table.
UPDATE statements are not supported for this table.
Identifier of the calculated rate.
Date of rate calculation.
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
Net charge amount applied to a service. Specific to the AccountNumber.
Transportation charges before surcharges and discounts applied to a service. Applied only when RequestAccountRate was set to false during rate calculation.
Net charge amount applied to a service. Applied only when RequestAccountRate was set to false during rate calculation.
Total surcharge amount for all additional services applied to a service. Applied only when RequestAccountRate was set to false during rate calculation.
Textual description of the time of transit as enumerated.