Database Table: TAXJCRULE

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

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 TaxJurisdictionGroup. If this is NULL, then this row applies to all TaxJurisdictionGroups.
PRECEDENCE DOUBLE
NOT NULL, DEFAULT 0
When 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.
TAXJCRULE_ID INTEGER
NOT NULL
Generated unique key.
Indexes:
Index Name Indexed Column Names Index Type
I0000245 CALRULE_ID, FFMCENTER_ID, JURSTGROUP_ID Unique Index
SQL030416035125630 TAXJCRULE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_820 CALRULE_ID CALRULE CALRULE_ID Cascade
F_821 FFMCENTER_ID FFMCENTER FFMCENTER_ID Cascade
F_822 JURSTGROUP_ID JURSTGROUP JURSTGROUP_ID Cascade

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