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 Descriptions:
Name | 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 | 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> | JURSTGROUP_ID | Primary Key |
I0000143 | CODE+STOREENT_ID+SUBCLASS | Unique Index |
I0000602 | STOREENT_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_412 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Referenced By Child Tables:
Constraint | Columns | Child Table | Child Columns | 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 |