SHPJCRULE

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

Column Descriptions:

NameTypeDescription
CALRULE_IDINTEGER NOT NULLThe CalculationRule.
SHPJCRULE_IDINTEGER NOT NULLGenerated unique key.
FFMCENTER_IDINTEGERThe FulfillmentCenter. If this is NULL then this row applies to all FulfillmentCenters.
JURSTGROUP_IDINTEGERThe ShippingJurisdictionGroup. If this is NULL, then this row applies to all ShippingJurisdictionGroups.
PRECEDENCEDOUBLE NOT NULL DEFAULT 0When 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_IDINTEGERThe ShippingMode.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>SHPJCRULE_IDPrimary Key
I0000230 FFMCENTER_ID+SHIPMODE_ID+JURSTGROUP_ID+CALRULE_IDUnique Index
I0000767SHIPMODE_IDNon-Unique Index
I0000768JURSTGROUP_IDNon-Unique Index
I0000769CALRULE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_751CALRULE_IDCALRULECALRULE_IDCascade
F_752JURSTGROUP_IDJURSTGROUPJURSTGROUP_IDCascade
F_753SHIPMODE_IDSHIPMODESHIPMODE_IDCascade
F_754FFMCENTER_IDFFMCENTERFFMCENTER_IDCascade