Each row of this table indicates that a jurisdiction of a particular subclass is in a jurisdiction group of that same subclass.
Column Name | Column Type | Description |
---|---|---|
JURST_ID | INTEGER NOT NULL | The Jurisdiction. |
JURSTGROUP_ID | INTEGER NOT NULL | The JurisdictionGroup. |
SUBCLASS | INTEGER NOT NULL | The subclass of the jurisdiction and of the jurisdiction group should match as follows: 1 = ShippingJurisdiction[Group]. 2 = TaxJurisdiction[Group]. |
OPTCOUNTER | SMALLINT | Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031235760 | JURST_ID+JURSTGROUP_ID | Primary Key |
I0000601 | JURSTGROUP_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_410 | JURST_ID | JURST | JURST_ID | Cascade |
F_411 | JURSTGROUP_ID | JURSTGROUP | JURSTGROUP_ID | Cascade |