WebSphere Commerce 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 Description(s):
Column NameColumn TypeDescription
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 Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000245 CALRULE_ID+FFMCENTER_ID+JURSTGROUP_ID Unique Index
SQL050212031318140 TAXJCRULE_ID Primary Key
I0000805 JURSTGROUP_ID Non-Unique Index
I0000806 FFMCENTER_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)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

Feedback