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:

NameTypeDescription
SHIPMODE_IDINTEGER NOT NULLGenerated unique key.
FIELD1VARCHAR (254)Customizable.
STOREENT_IDINTEGER NOT NULLThe StoreEntity.
FIELD2INTEGERCustomizable.
CODECHAR (30)A merchant assigned code, unique for the StoreEntity.
CARRIERCHAR (30)Shipping carrier identifier.
TRACKINGNAMEVARCHAR (64)Reserved for IBM internal use.
TRACKINGURLVARCHAR (254)Reserved for IBM internal use.
TRACKINGHOSTVARCHAR (64)Reserved for IBM internal use.
TRACKINGPORTINTEGERReserved for IBM internal use.
TRACKINGICONVARCHAR (64)Reserved for IBM internal use.
TRACKINGTYPECHAR (8)Reserved for IBM internal use.
MARKFORDELETEINTEGER NOT NULL DEFAULT 0Reserved for IBM internal use.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>SHIPMODE_IDPrimary Key
I0000228STOREENT_ID+CODE+CARRIERUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_745STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1091SHIPMODE_IDORDRELEASESHIPMODE_IDCascade
F_1148SHIPMODE_IDSHIPINFOSHIPMODE_IDCascade
F_1226SHIPMODE_IDCALADJUSTSHIPMODE_IDCascade
F_427SHIPMODE_IDMANIFESTSHIPMODE_IDCascade
F_509SHIPMODE_IDORDERITEMSSHIPMODE_IDCascade
F_749SHIPMODE_IDSHPARRANGESHIPMODE_IDCascade
F_753SHIPMODE_IDSHPJCRULESHIPMODE_IDCascade
F_755SHIPMODE_IDSHPMODEDSCSHIPMODE_IDCascade
F_787SHIPMODE_IDSTOREDEFSHIPMODE_IDCascade
F_928SHIPMODE_IDSHPMODCLCDSHIPMODE_IDCascade