JURSTGPREL

Each row of this table indicates that a jurisdiction of a particular subclass is in a jurisdiction group of that same subclass.

Column Descriptions:

NameTypeDescription
JURST_IDINTEGER NOT NULLThe Jurisdiction.
JURSTGROUP_IDINTEGER NOT NULLThe JurisdictionGroup.
SUBCLASSINTEGER NOT NULLThe subclass of the jurisdiction and of the jurisdiction group should match as follows: 1 = ShippingJurisdiction[Group]. 2 = TaxJurisdiction[Group].
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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>JURST_ID+JURSTGROUP_IDPrimary Key
I0000601JURSTGROUP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_410JURST_IDJURSTJURST_IDCascade
F_411JURSTGROUP_IDJURSTGROUPJURSTGROUP_IDCascade