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 Column Description
CITY VARCHAR (128)
NULL
The city or an equivalent. Its definition should always match the one in the ADDRESS table.
CODE CHARACTER (30)
NOT NULL
A code which, together with its StoreEntity and SubClass, uniquely identifies this jurisdiction.
COUNTRY VARCHAR (128)
NULL
The country or region. Its definition should always match the one in the ADDRESS table.
COUNTRYABBR VARCHAR (10)
NULL
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.
COUNTY VARCHAR (30)
NULL
The county or an equivalent.
DESCRIPTION VARCHAR (254)
NULL
A brief description of the jurisdiction, suitable for display by a user interface that manages jurisdiction definitions.
DISTRICT VARCHAR (30)
NULL
The district or an equivalent.
GEOCODE VARCHAR (254)
NULL
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.
JURST_ID INTEGER
NOT NULL
Generated unique key.
MARKFORDELETE INTEGER
NOT NULL, DEFAULT 0
Reserved for IBM internal use.
STATE VARCHAR (128)
NULL
The state, province, or an equivalent. Its definition should always match the one in the ADDRESS table.
STATEABBR VARCHAR (10)
NULL
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.
STOREENT_ID INTEGER
NOT NULL
The StoreEntity associated with this jurisdiction definition.
SUBCLASS INTEGER
NOT NULL
Indicates the jurisdiction subclass as follows:
1 = ShippingJurisdiction.
2 = TaxJurisdiction.
ZIPCODEEND VARCHAR (40)
NULL
The ending ZIP or postal code of a range of codes. Its definition should always match the one in the ADDRESS table.
ZIPCODESTART VARCHAR (40)
NULL
The starting ZIP or postal code of a range of codes. Its definition should always match the one in the ADDRESS table.
Indexes:
Index Name Indexed Column Names Index Type
I0000142 CODE, STOREENT_ID, SUBCLASS Unique Index
SQL030416034950600 JURST_ID Primary Key
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