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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000245 | CALRULE_ID, FFMCENTER_ID, JURSTGROUP_ID | Unique Index |
SQL030416035125630 | TAXJCRULE_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|