SHPMODCLCD

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

Column Descriptions:

NameTypeDescription
SHPMODCLCD_IDINTEGER NOT NULLThe primary key.
STORE_IDINTEGER NOT NULLThis is the store ID in STORE table.
SHIPMODE_IDINTEGERThe ship mode ID in SHIPMODE table.
CALCODE_IDINTEGER NOT NULLThe CALCODE ID in CALCODE table.
TRADING_IDBIGINTThe TradingAgreement. NULL implies all TradingAgreements.
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>SHPMODCLCD_IDPrimary Key
I0000303STORE_ID+CALCODE_ID+SHIPMODE_ID+TRADING_IDUnique Index
I0000268TRADING_IDNon-Unique Index
I0000269CALCODE_IDNon-Unique Index
I0000270SHIPMODE_IDNon-Unique Index
I0000271STORE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_927CALCODE_IDCALCODECALCODE_IDCascade
F_928SHIPMODE_IDSHIPMODESHIPMODE_IDCascade
F_929TRADING_IDTRADINGTRADING_IDCascade
F_930STORE_IDSTORESTORE_IDCascade