Reference > Database > WebSphere Commerce database tables > T
WebSphere Commerce database table: TAXJCRULE
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 Name Column 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 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000245 CALRULE_ID+FFMCENTER_ID+JURSTGROUP_ID Unique Index SQL100520030437490 TAXJCRULE_ID Primary Key I0000805 JURSTGROUP_ID Non-Unique Index I0000806 FFMCENTER_ID Non-Unique Index
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
Related reference
_vcc_freeselect_bottom_