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:
| Name | 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 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | JURST_ID | Primary Key |
| I0000142 | CODE+STOREENT_ID+SUBCLASS | Unique Index |
| I0000600 | STOREENT_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_409 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_410 | JURST_ID | JURSTGPREL | JURST_ID | Cascade |