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 |