Database Table: SHIPMODE

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000228 STOREENT_ID, CODE, CARRIER Unique Index
SQL030416035104610 SHIPMODE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_745 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
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