WebSphere Commerce database table: SHPJCRULE

This table can be used by the shipping CalculationRuleQualifyMethod to choose a CalculationRule based on ShippingMode and FulfillmentCenter when the shipping address matches one of the ShippingJurisdictions in a particular ShippingJurisdictionGroup.


Column Description(s):
Column NameColumn TypeDescription
CALRULE_ID INTEGER NOT NULL The CalculationRule.
SHPJCRULE_ID INTEGER NOT NULL Generated unique key.
FFMCENTER_ID INTEGER The FulfillmentCenter. If this is NULL then this row applies to all FulfillmentCenters.
JURSTGROUP_ID INTEGER The ShippingJurisdictionGroup. If this is NULL, then this row applies to all ShippingJurisdictionGroups.
PRECEDENCE DOUBLE NOT NULL DEFAULT 0 When a shipping address falls within more than one of the specified ShippingJurisdictionGroups, for the same FulfillmentCenter and ShippingMode, only the CalculationRule with the highest SHPJCRULE.PRECEDENCE value qualifies.
SHIPMODE_ID INTEGER The ShippingMode.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000230 FFMCENTER_ID+SHIPMODE_ID+JURSTGROUP_ID+CALRULE_ID Unique Index
SQL050212031311750 SHPJCRULE_ID Primary Key
I0000767 SHIPMODE_ID Non-Unique Index
I0000768 JURSTGROUP_ID Non-Unique Index
I0000769 CALRULE_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_751 CALRULE_ID CALRULE CALRULE_ID Cascade
F_754 FFMCENTER_ID FFMCENTER FFMCENTER_ID Cascade
F_752 JURSTGROUP_ID JURSTGROUP JURSTGROUP_ID Cascade
F_753 SHIPMODE_ID SHIPMODE SHIPMODE_ID Cascade

Feedback