WebSphere Commerce database table: SHPMODCLCD
The relationship between the calculation code and the shipmode for shipping promotion use.
Column Descriptions Column Name Column Type Description SHPMODCLCD_ID INTEGER NOT NULL The primary key. STORE_ID INTEGER NOT NULL This is the store ID in STORE table. SHIPMODE_ID INTEGER The shipmode ID in SHIPMODE table. CALCODE_ID INTEGER NOT NULL The calcode ID in CALCODE table. TRADING_ID BIGINT The TradingAgreement. NULL implies all TradingAgreements. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000303 STORE_ID+CALCODE_ID+SHIPMODE_ID+TRADING_ID Unique Index SQL060903235250810 SHPMODCLCD_ID Primary Key I0000268 TRADING_ID Non-Unique Index I0000269 CALCODE_ID Non-Unique Index I0000270 SHIPMODE_ID Non-Unique Index I0000271 STORE_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_927 CALCODE_ID CALCODE CALCODE_ID Cascade F_928 SHIPMODE_ID SHIPMODE SHIPMODE_ID Cascade F_930 STORE_ID STORE STORE_ID Cascade F_929 TRADING_ID TRADING TRADING_ID Cascade