Reference > Database > WebSphere Commerce database tables > S
WebSphere Commerce database table: SHPJCRULE
This table can be used by the shipping CalculationRuleQualifyMethod to choose a CalculationRule based on ShippingMode and FulfillmentCenter. It is used the shipping address matches one of the ShippingJurisdictions in a particular ShippingJurisdictionGroup.
Column Name Column Type Description 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.
Indexes Index Name Indexed Column Names Index Type I0000230 FFMCENTER_ID+SHIPMODE_ID+JURSTGROUP_ID+CALRULE_ID Unique Index SQL100520030429280 SHPJCRULE_ID Primary Key I0000767 SHIPMODE_ID Non-Unique Index I0000768 JURSTGROUP_ID Non-Unique Index I0000769 CALRULE_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names 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
Related reference
_vcc_freeselect_bottom_