TAXJCRULE

When shipping from a FulfillmentCenter to a shipping address that matches one of the TaxJurisdictions in a particular TaxJurisdictionGroup. This table can be used by a tax CalculationRuleQualifyMethod to choose a CalculationRule

Column Descriptions:

NameTypeDescription
CALRULE_IDINTEGER NOT NULLThe CalculationRule.
TAXJCRULE_IDINTEGER NOT NULLGenerated unique key.
FFMCENTER_IDINTEGERThe FulfillmentCenter. If this is NULL then this row applies to all FulfillmentCenters.
JURSTGROUP_IDINTEGERThe TaxJurisdictionGroup. If this is NULL, then this row applies to all TaxJurisdictionGroups.
PRECEDENCEDOUBLE NOT NULL DEFAULT 0When a shipping address falls within more than one of the specified TaxJurisdictionGroups, for the same FulfillmentCenter, only the CalculationRule with the highest TAXJCRULE.PRECEDENCE value qualifies.
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>TAXJCRULE_IDPrimary Key
I0000245CALRULE_ID+FFMCENTER_ID+JURSTGROUP_IDUnique Index
I0000805JURSTGROUP_IDNon-Unique Index
I0000806FFMCENTER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_820CALRULE_IDCALRULECALRULE_IDCascade
F_821FFMCENTER_IDFFMCENTERFFMCENTER_IDCascade
F_822JURSTGROUP_IDJURSTGROUPJURSTGROUP_IDCascade