SHPARJURGP

Each row of this table indicates that a ShippingArrangement applies to all OrderItems whose shipping addresses match a ShippingJurisdictionGroup. Refer to SHPARRANGE.FLAGS.

Column Descriptions:

NameTypeDescription
SHPARRANGE_IDINTEGER NOT NULLThe ShippingArrangement.
JURSTGROUP_IDINTEGER NOT NULLThe ShippingJurisdictionGroup.
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>SHPARRANGE_ID+JURSTGROUP_IDPrimary Key
I0000764JURSTGROUP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_746JURSTGROUP_IDJURSTGROUPJURSTGROUP_IDCascade
F_747SHPARRANGE_IDSHPARRANGESHPARRANGE_IDCascade