SHPMODEDSC

Each row of this table contains language-dependent information about a ShippingMode.

Column Descriptions:

NameTypeDescription
SHIPMODE_IDINTEGER NOT NULLThe ShippingMode.
LANGUAGE_IDINTEGER NOT NULLThe Language. For a list of language components, see the LANGUAGE table.
DESCRIPTIONVARCHAR (254)A brief description of the ShippingMode, suitable for display to a customer for selection.
FIELD1VARCHAR (254)Customizable.
FIELD2VARCHAR (254)Customizable.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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_ID+LANGUAGE_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_755SHIPMODE_IDSHIPMODESHIPMODE_IDCascade
F_756LANGUAGE_IDLANGUAGELANGUAGE_IDCascade