The relationship between the calculation code and
the shipmode for shipping promotion use.
Column Descriptions:
| Name | 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 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | SHPMODCLCD_ID | Primary Key |
| I0000303 | STORE_ID+CALCODE_ID+SHIPMODE_ID+TRADING_ID | Unique Index |
| I0000268 | TRADING_ID | Non-Unique Index |
| I0000269 | CALCODE_ID | Non-Unique Index |
| I0000270 | SHIPMODE_ID | Non-Unique Index |
| I0000271 | STORE_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_927 | CALCODE_ID | CALCODE | CALCODE_ID | Cascade |
| F_928 | SHIPMODE_ID | SHIPMODE | SHIPMODE_ID | Cascade |
| F_929 | TRADING_ID | TRADING | TRADING_ID | Cascade |
| F_930 | STORE_ID | STORE | STORE_ID | Cascade |