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:
| Name | Type | Description |
| CALRULE_ID | INTEGER NOT NULL | The CalculationRule. |
| TAXJCRULE_ID | INTEGER NOT NULL | Generated unique key. |
| FFMCENTER_ID | INTEGER | The FulfillmentCenter. If this is NULL then this
row applies to all FulfillmentCenters. |
| JURSTGROUP_ID | INTEGER | 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. |
| OPTCOUNTER | SMALLINT | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | TAXJCRULE_ID | Primary Key |
| I0000245 | CALRULE_ID+FFMCENTER_ID+JURSTGROUP_ID | Unique Index |
| I0000805 | JURSTGROUP_ID | Non-Unique Index |
| I0000806 | FFMCENTER_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | 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 |