RateHistoryCData Excel Add-In for USPS 2019J - 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:
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 USPS 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
The mail service type when shipping to a given country. (intl only)
Service commitments for the PackagingType when shipping to a given country.
The maximum allowable dimensions of a package sent to the specified country via the indicated ServiceType.
The maximum allowable weight (in pounds) of a package sent to the specified country via the indicated ServiceType.
It contains the lesser of maximum parcel indemnity coverage per given weight and TotalValue, if applicable.
Explains why no InsuranceCost was returned in the response despite ToalValue being specified, if applicable.
The cost of purchasing insurance for this package.
Net charge amount applied to a service. Applied only when RequestAccountRate was set to false during rate calculation.
Textual description of the time of transit as enumerated.
使用できる値は次のとおりです。ONE_DAY, TWO_DAYS, THREE_DAYS, FOUR_DAYS, FIVE_DAYS, SIX_DAYS, SEVEN_DAYS, EIGHT_DAYS, NINE_DAYS, UNKNOWN
Textual description of delivery signature option as enumerated.
使用できる値は次のとおりです。ADULT, DIRECT, INDIRECT, NO_SIGNATURE_REQUIRED, SERVICE_DEFAULT
Restrictions on items being shipped.
List of items prohibited from mailing to the destination country.
Additional mailing information based on country of destination.
Indicates the number of postal rate zones between the origin and destination zip codes.
Customs forms required to mail to a country.
Areas where the PackagingType service is available when shipped to a country.
Express Mail information when shipping to a country.