SSIS Components for USPS

Build 20.0.7587

CalculateRates

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. It should be noted that if the PostageProvider is set to Stamps, only the first package in the shipment will be processed.

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

Input

Name Type Description
ServiceType String Type of service for which the rate is applied as enumerated.

使用できる値は次のとおりです。Unspecified, Express, First_Class, Priority, Parcel_Post, Media, Library, Parcel_Select, Critical_Mail, Standard_Mail

ShipDate Datetime The date the user requests USPS to pickup the package from the origin, up to 7 days from the future. Required for Stamps if ShipDate is not defined in the specified Shipment.
TotalValue Decimal Total value of the items inside the package. Used to calculate InsuranceCost and IndemnityCoverage.
ShipmentId Integer Identifier for the shipment details to calculate rates for.

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, Express, First_Class, Priority, Parcel_Post, Media, Library, Parcel_Select, Critical_Mail, Standard_Mail
QuoteDate Datetime Date of rate calculation.
PackagingType String The mail service type when shipping to a given country. (intl only)
Commitments String Service commitments for the PackagingType when shipping to a given country.
MaxDimensions String The maximum allowable dimensions of a package sent to the specified country via the indicated ServiceType.
MaxWeight Double The maximum allowable weight (in pounds) of a package sent to the specified country via the indicated ServiceType.
IndemnityCoverage String It contains the lesser of maximum parcel indemnity coverage per given weight and TotalValue, if applicable.
InsuranceComment String Explains why no InsuranceCost was returned in the response despite ToalValue being specified, if applicable.
InsuranceCost String The cost of purchasing insurance for this package.
ListNetCharge Decimal Net charge amount applied to a service.
TransitTime String Textual description of the time of transit as enumerated.
SignatureType String Textual description of delivery signature option as enumerated.
Restrictions String Restrictions on items being shipped.
Prohibitions String List of items prohibited from mailing to the destination country.
Observations String Additional mailing information based on country of destination.
PostalZone String Indicates the number of postal rate zones between the origin and destination zip codes.
CustomsForms String Customs forms required to mail to a country.
AreasServed String Areas where the PackagingType service is available when shipped to a country.
ExpressMailInfo String Express Mail information when shipping to a country.

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