Reference > Database > WebSphere Commerce database tables > S
WebSphere Commerce database table: 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 Name Column Type Description SHPARRANGE_ID INTEGER NOT NULL The ShippingArrangement. JURSTGROUP_ID INTEGER NOT NULL The ShippingJurisdictionGroup. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030428950 SHPARRANGE_ID+JURSTGROUP_ID Primary Key I0000764 JURSTGROUP_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_746 JURSTGROUP_ID JURSTGROUP JURSTGROUP_ID Cascade F_747 SHPARRANGE_ID SHPARRANGE SHPARRANGE_ID Cascade
Related reference
_vcc_freeselect_bottom_