Each row in this table represents an instance of a particular subclass of JurisdictionGroup. A JurisdictionGroup of a particular subclass is a grouping of Jurisdiction definitions of that subclass.
Column Description(s):
Column Name | Column Type | Description |
JURSTGROUP_ID |
INTEGER NOT NULL |
Generated unique key. |
DESCRIPTION |
VARCHAR(254) |
A brief description of the JurisdictionGroup, suitable for display in a user interface that manages JurisdictionGroups. |
SUBCLASS |
INTEGER NOT NULL |
Indicates the JurisdictionGroup subclass as follows:
1 = ShippingJurisdictionGroup.
2 = TaxJurisdictionGroup. |
STOREENT_ID |
INTEGER NOT NULL |
The StoreEntity associated with this JurisdictionGroup. |
CODE |
CHAR(30) NOT NULL |
A code which, together with its StoreEntity and SubClass, uniquely identifies this JurisdictionGroup. |
MARKFORDELETE |
INTEGER NOT NULL DEFAULT 0 |
Reserved for IBM internal use. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000143 |
CODE+STOREENT_ID+SUBCLASS |
Unique Index |
SQL050212031235890 |
JURSTGROUP_ID |
Primary Key |
I0000602 |
STOREENT_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_412 |
STOREENT_ID |
STOREENT |
STOREENT_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_411 |
JURSTGROUP_ID |
JURSTGPREL |
JURSTGROUP_ID |
Cascade |
F_746 |
JURSTGROUP_ID |
SHPARJURGP |
JURSTGROUP_ID |
Cascade |
F_752 |
JURSTGROUP_ID |
SHPJCRULE |
JURSTGROUP_ID |
Cascade |
F_822 |
JURSTGROUP_ID |
TAXJCRULE |
JURSTGROUP_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.