Shipping Rates

Internal Table Name: ShippingRates

Use the Shipping Rates table to calculate LTL and Parcel rates that you can then use to populate the Variable Transportation Cost column in Transportation Policies and the Direct Shipping Cost in Shipments.

• RateWare XL – You can use RateWare® XL from SMC3 to obtain LTL tariff rates when using Supply Chain Guru X.
• Parcel Rates – Supply Chain Guru X includes a set of FedEx® and UPS® rate tables that you can use to calculate parcel rates.

The records in your Transportation Policies and Shipments tables can be used to populate the origin, destination and product information in Shipping Rates. Based on these values, you use the Calculate Rates function to perform lookups and populate the rate values.

Once the Shipping Rates have been calculated, the Rate Source can be used to populate a number of cost columns:

• Shipments > Direct Shipping Cost

• Transportation Policies > Variable Transportation Cost

• Transportation Policies > Fixed Shipment Cost

• LTL Rate > Base Cost

Rate Source

Technology: NO TO S

Table: ShippingRates

Internal Name: RateSource

Type: Text (255)

This is the Rate Provider used to calculate the rates. This column is populated when you use Calculate Rates to perform the rate lookup.

Source Country

Technology: NO TO S

Table: ShippingRates

Internal Name: OriginCountry

Type: Short Text (255)

This is the country for the source of the shipment. It is populated based on the Transportation Policies or Shipments records you use with the Generate Data function, or you can manually enter this value.

Source Postal Code

Technology: NO TO S

Table: ShippingRates

Internal Name: OriginZipCode

Type: Short Text (100)

This is the postal code for the source of the shipment. It is populated based on the Transportation Policies or Shipments records you use with the Generate Data function, or you can manually enter this value.

Destination Country

Technology: NO TO S

Table: ShippingRates

Internal Name: DestinationCountry

Type: Short Text (255)

This is the country for the destination of the shipment. It is populated based on the Transportation Policies or Shipments records you use with the Generate Data function, or you can manually enter this value.

Destination Postal Code

Technology: NO TO S

Table: ShippingRates

Internal Name: DestinationZipCode

Type: Short Text (100)

This is the postal code for the origin of the shipment. It is populated based on the Transportation Policies or Shipments records you use with the Generate Data function, or you can manually enter this value.

Shipment Weight

Technology: NO TO S

Table: ShippingRates

Internal Name: ShipmentWeight

Type: Short Text (100)

This is the weight to be used to calculate the cost of the shipment. If you are entering records manually, enter the weight value. When you use Generate Data, the weight is returned or calculated, based on what is populated in the source tables:

When using Transportation Policies to generate Shipping Rate data, Shipment Size is used to determine the weight of the shipment. If the Shipment Size unit of measure is not weight-based, the value is converted based on the Weight as defined in the Products table.

When using Shipments to generate Shipping Rate data, the weight is determined based on whether Weight, Volume or Quantity is populated as shown below:

You can manually edit the Shipment Weight as required. Enter a value, then optionally select a weight unit of measure. If you do not select a unit of measure, the default Weight Unit Of Measure from Model Settings is used.

Freight Class

Technology: NO TO S

Table: ShippingRates

Internal Name: FreightClass

Type: Short Text (25)

This field specifies the freight class. This is the category of freight defined by the National Motor Freight Traffic Association according to four characteristics: Weight, Storability, Handling, and Liability. There are 18 freight classes ranging from class 50 (the least expensive) to class 500 (most expensive).

When using Transportation Policies to populate Shipping Rates, you must have either the Class column in Products or Product Class column in Transportation Policies populated. Product Class overrides Class when both are populated.

When using Shipments to populate Shipping Rates, you must have either the Class column in Products or Freight Class column in Shipments populated. Freight Class overrides Class when both are populated.

Cost

Technology: NO TO S

Table: ShippingRates

Internal Name: Cost

Type: Short Text (100)

This is the cost to transport the shipment based on the origin, destination, freight class and weight. This value is returned when you run Calculate Rates. You can edit the Cost as required.

Lookup Date

Technology: NO TO S

Table: ShippingRates

Internal Name: LookupDate

Type: Date/Time

This field displays the date on which the lookup for the calculated rate was performed.