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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000230 | FFMCENTER_ID, SHIPMODE_ID, JURSTGROUP_ID, CALRULE_ID | Unique Index |
SQL030416035105650 | SHPJCRULE_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|