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 Descriptions:

NameTypeDescription
JURSTGROUP_IDINTEGER NOT NULLGenerated unique key.
DESCRIPTIONVARCHAR (254)A brief description of the JurisdictionGroup, suitable for display in a user interface that manages JurisdictionGroups.
SUBCLASSINTEGER NOT NULLIndicates the JurisdictionGroup subclass as follows: 1 = ShippingJurisdictionGroup. 2 = TaxJurisdictionGroup.
STOREENT_IDINTEGER NOT NULLThe StoreEntity associated with this JurisdictionGroup.
CODECHAR (30) NOT NULLA code which, together with its StoreEntity and SubClass, uniquely identifies this JurisdictionGroup.
MARKFORDELETEINTEGER NOT NULL DEFAULT 0Reserved for IBM internal use.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>JURSTGROUP_IDPrimary Key
I0000143CODE+STOREENT_ID+SUBCLASSUnique Index
I0000602STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_412STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_411JURSTGROUP_IDJURSTGPRELJURSTGROUP_IDCascade
F_746JURSTGROUP_IDSHPARJURGPJURSTGROUP_IDCascade
F_752JURSTGROUP_IDSHPJCRULEJURSTGROUP_IDCascade
F_822JURSTGROUP_IDTAXJCRULEJURSTGROUP_IDCascade