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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000142 | CODE, STOREENT_ID, SUBCLASS | Unique Index |
SQL030416034950600 | JURST_ID | Primary Key |
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 |