Reference > Database > WebSphere Commerce database tables > J
WebSphere Commerce database table: JURST
Each row of this table defines an instance of a particular subclass of jurisdiction. A jurisdiction contains information that can be matched with an address.
Column Name Column Type Description JURST_ID INTEGER NOT NULL Generated unique key. COUNTRY VARCHAR(128) The country or region. Its definition should always match the one in the ADDRESS table. STOREENT_ID INTEGER NOT NULL The StoreEntity associated with this jurisdiction definition. CODE CHAR(30) NOT NULL A code which, together with its StoreEntity and SubClass, uniquely identifies this jurisdiction. DESCRIPTION VARCHAR(254) A brief description of the jurisdiction, suitable for display by a user interface that manages jurisdiction definitions. SUBCLASS INTEGER NOT NULL Indicates the jurisdiction subclass...
1 = ShippingJurisdiction.
2 = TaxJurisdiction.CITY VARCHAR(128) The city or an equivalent. Its definition should always match the one in the ADDRESS table. STATE VARCHAR(128) The state, province, or an equivalent. Its definition should always match the one in the ADDRESS table. STATEABBR VARCHAR(10) An optional abbreviation code for the state or province (as specified in the STATE column). It supports the use of normal form or short form in the ADDRESS table. COUNTRYABBR VARCHAR(10) An optional abbreviation code for the country or region (as specified in the COUNTRY column). It supports the use of normal form or short form in the ADDRESS table. DISTRICT VARCHAR(30) The district or an equivalent. COUNTY VARCHAR(30) The county or an equivalent. ZIPCODESTART VARCHAR(40) The starting ZIP or postal code of a range of codes. Its definition should always match the one in the ADDRESS table. ZIPCODEEND VARCHAR(40) The ending ZIP or postal code of a range of codes. Its definition should always match the one in the ADDRESS table. GEOCODE VARCHAR(254) A tax code based on geographical region. This column is used to support Taxware integration. Its definition should always match the one in the ADDRESS table. MARKFORDELETE INTEGER NOT NULL DEFAULT 0 Reserved for IBM internal use. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000142 CODE+STOREENT_ID+SUBCLASS Unique Index SQL100520030348790 JURST_ID Primary Key I0000600 STOREENT_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_409 STOREENT_ID STOREENT STOREENT_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_410 JURST_ID JURSTGPREL JURST_ID Cascade
Related reference
_vcc_freeselect_bottom_