WebSphere Commerce database table: SHPMODCLCD

The relationship between the calculation code and the shipmode for shipping promotion use.


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000303 STORE_ID+CALCODE_ID+SHIPMODE_ID+TRADING_ID Unique Index
SQL050212031311880 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
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)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

Feedback