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 Description(s):
Column Name | Column Type | Description |
SHIPMODE_ID |
INTEGER NOT NULL |
Generated unique key. |
FIELD1 |
VARCHAR(254) |
Customizable. |
STOREENT_ID |
INTEGER NOT NULL |
The StoreEntity. |
FIELD2 |
INTEGER |
Customizable. |
CODE |
CHAR(30) |
A merchant assigned code, unique for the StoreEntity. |
CARRIER |
CHAR(30) |
Shipping carrier identifier. |
TRACKINGNAME |
VARCHAR(64) |
Reserved for IBM internal use. |
TRACKINGURL |
VARCHAR(254) |
Reserved for IBM internal use. |
TRACKINGHOST |
VARCHAR(64) |
Reserved for IBM internal use. |
TRACKINGPORT |
INTEGER |
Reserved for IBM internal use. |
TRACKINGICON |
VARCHAR(64) |
Reserved for IBM internal use. |
TRACKINGTYPE |
CHAR(8) |
Reserved for IBM internal use. |
MARKFORDELETE |
INTEGER NOT NULL DEFAULT 0 |
Reserved for IBM internal use. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000228 |
STOREENT_ID+CODE+CARRIER |
Unique Index |
SQL050212031311340 |
SHIPMODE_ID |
Primary Key |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_745 |
STOREENT_ID |
STOREENT |
STOREENT_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_1226 |
SHIPMODE_ID |
CALADJUST |
SHIPMODE_ID |
Cascade |
F_427 |
SHIPMODE_ID |
MANIFEST |
SHIPMODE_ID |
Cascade |
F_509 |
SHIPMODE_ID |
ORDERITEMS |
SHIPMODE_ID |
Cascade |
F_1091 |
SHIPMODE_ID |
ORDRELEASE |
SHIPMODE_ID |
Cascade |
F_1148 |
SHIPMODE_ID |
SHIPINFO |
SHIPMODE_ID |
Cascade |
F_749 |
SHIPMODE_ID |
SHPARRANGE |
SHIPMODE_ID |
Cascade |
F_753 |
SHIPMODE_ID |
SHPJCRULE |
SHIPMODE_ID |
Cascade |
F_928 |
SHIPMODE_ID |
SHPMODCLCD |
SHIPMODE_ID |
Cascade |
F_755 |
SHIPMODE_ID |
SHPMODEDSC |
SHIPMODE_ID |
Cascade |
F_787 |
SHIPMODE_ID |
STOREDEF |
SHIPMODE_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.