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 Descriptions:

Name	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 NOT NULL DEFAULT 0	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>	SHIPMODE_ID	Primary Key
I0000228	STOREENT_ID+CODE+CARRIER	Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_745	STOREENT_ID	STOREENT	STOREENT_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_1091	SHIPMODE_ID	ORDRELEASE	SHIPMODE_ID	Cascade
F_1148	SHIPMODE_ID	SHIPINFO	SHIPMODE_ID	Cascade
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_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

Related reference
Calculation rule - shipping data model
Order item data model
Order release data model
Shipping data model
Store data model