Shipping Charges Implementation Using Calculation Framework

1.             Define the jurisdiction groups and jurisdictions.
2.             Define the shipping modes.
3.             Define the calculation codes.
4.             Define the calculation rules.
5.             Define the calculation scales.
6.             Define the calculation ranges.
7.             Define the look-up results for the calculation ranges.
8.             Associate the calculation scales with the calculation rules.
9.             Attach the calculation code with the all catalog entries.
10.             Associate the calculation rules with the fulfillment center.
11.             (optional) Set the default shipping mode for the store.
12.             (optional) Set the default shipping calculation code for the store. You would only complete this step if your store does not already have a default calculation code defined for shipping charges.

 Tables Used -

JURSTGROUP - This table defines jurisdiction groups.
JURST - This table defines jurisdictions.
JURSTGPREL - This table defines which jurisdictions belong to which jurisdiction groups.

CALUSAGE - This table contains a unique identifier for each calculation usage and a description of the calculation usage. Values in this table are defined in the language-dependent bootstrap file.

STENCALUSG - This table defines the high-level behavior of a calculation usage for a store or group of stores. If the implementation for a store is not defined, the implementation for the store group is used. If different implementations are defined for the store and the store group, the implementation for the store is used. This database table is initially populated from the language-independent bootstrap file.

CALRULE - Defines calculation rules.

CALSCALE -Defines calculation scales.

CALRANGE - Defines the calculation ranges that make up a calculation scale.

CALRLOOKUP - Contains the look-up results for calculation ranges. The currencies of the look-up results, optional attributes, are also specified in this database table.

CALSCALEDS - Contains national language descriptions of a calculation scale. This allows one calculation scale to have descriptions in multiple languages.

CRULESCALE -Relates a calculation scale to a calculation rule. A calculation rule can have multiple calculation scales and a calculation scale can be used by multiple calculation rules.

CALRLOOKUP -Contains the following information about calculation range look–up results