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 Descriptions
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 as follows:
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
SQL060903235209580 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

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_410 JURST_ID JURSTGPREL JURST_ID Cascade
Related reference