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 Name | Column Type | Column Description |
---|---|---|
CODE | CHARACTER (30) NOT NULL |
A code which, together with its StoreEntity and SubClass, uniquely identifies this JurisdictionGroup. |
DESCRIPTION | VARCHAR (254) NULL |
A brief description of the JurisdictionGroup, suitable for display in a user interface that manages JurisdictionGroups. |
JURSTGROUP_ID | INTEGER NOT NULL |
Generated unique key. |
MARKFORDELETE | INTEGER NOT NULL, DEFAULT 0 |
Reserved for IBM internal use. |
STOREENT_ID | INTEGER NOT NULL |
The StoreEntity associated with this JurisdictionGroup. |
SUBCLASS | INTEGER NOT NULL |
Indicates the JurisdictionGroup subclass as follows: 1 = ShippingJurisdictionGroup. 2 = TaxJurisdictionGroup. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000143 | CODE, STOREENT_ID, SUBCLASS | Unique Index |
SQL030416034951230 | JURSTGROUP_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_412 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | 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 |