Each row of this table represents a ShippingMode for a StoreEntity. A Store can use its own ShippingModes, and the ShippingModes of its StoreGroup.
Column Name | Column Type | Column Description |
---|---|---|
CARRIER | CHARACTER (30) NULL |
Shipping carrier identifier. |
CODE | CHARACTER (30) NULL |
A merchant assigned code, unique for the StoreEntity. |
FIELD1 | VARCHAR (254) NULL |
Customizable. |
FIELD2 | INTEGER NULL |
Customizable. |
MARKFORDELETE | INTEGER NOT NULL, DEFAULT 0 |
Reserved for IBM internal use. |
SHIPMODE_ID | INTEGER NOT NULL |
Generated unique key. |
STOREENT_ID | INTEGER NOT NULL |
The StoreEntity. |
TRACKINGHOST | VARCHAR (64) NULL |
Reserved for IBM internal use. |
TRACKINGICON | VARCHAR (64) NULL |
Reserved for IBM internal use. |
TRACKINGNAME | VARCHAR (64) NULL |
Reserved for IBM internal use. |
TRACKINGPORT | INTEGER NULL |
Reserved for IBM internal use. |
TRACKINGTYPE | CHARACTER (8) NULL |
Reserved for IBM internal use. |
TRACKINGURL | VARCHAR (254) NULL |
Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000228 | STOREENT_ID, CODE, CARRIER | Unique Index |
SQL030416035104610 | SHIPMODE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_745 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_427 | SHIPMODE_ID | MANIFEST | SHIPMODE_ID | Cascade |
F_509 | SHIPMODE_ID | ORDERITEMS | SHIPMODE_ID | Cascade |
F_749 | SHIPMODE_ID | SHPARRANGE | SHIPMODE_ID | Cascade |
F_753 | SHIPMODE_ID | SHPJCRULE | SHIPMODE_ID | Cascade |
F_755 | SHIPMODE_ID | SHPMODEDSC | SHIPMODE_ID | Cascade |
F_787 | SHIPMODE_ID | STOREDEF | SHIPMODE_ID | Cascade |
F_928 | SHIPMODE_ID | SHPMODCLCD | SHIPMODE_ID | Cascade |