Database Table: JURSTGROUP

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000143 CODE, STOREENT_ID, SUBCLASS Unique Index
SQL030416034951230 JURSTGROUP_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_412 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
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