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 Name Column Type Column Description
CALRULE_ID INTEGER
NOT NULL
The CalculationRule.
FFMCENTER_ID INTEGER
NULL
The FulfillmentCenter. If this is NULL then this row applies to all FulfillmentCenters.
JURSTGROUP_ID INTEGER
NULL
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
NULL
The ShippingMode.
SHPJCRULE_ID INTEGER
NOT NULL
Generated unique key.
Indexes:
Index Name Indexed Column Names Index Type
I0000230 FFMCENTER_ID, SHIPMODE_ID, JURSTGROUP_ID, CALRULE_ID Unique Index
SQL030416035105650 SHPJCRULE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_751 CALRULE_ID CALRULE CALRULE_ID Cascade
F_752 JURSTGROUP_ID JURSTGROUP JURSTGROUP_ID Cascade
F_753 SHIPMODE_ID SHIPMODE SHIPMODE_ID Cascade
F_754 FFMCENTER_ID FFMCENTER FFMCENTER_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable