ORDJUSTDESC

This table holds the language specific descriptions of the order justifications.

Column Descriptions:

Name Type Description
ORDJUST_ID INTEGER NOT NULL The unique identifier of the justification.
LANGUAGE_ID INTEGER NOT NULL The identifier of the language. For a list of language identifiers, see the LANGUAGE table.
DESCRIPTION VARCHAR(254) The description of the justification.
OPTCOUNTER SMALLINT 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
P_ORDJUSTDESC ORDJUST_ID + LANGUAGE_ID Primary Key
I_ORDJUST_1 STOREENT_ID Non-Unique Index

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_ORDJUSTDESC_ORDJUST_ID ORDJUST_ID ORDJUST ORDJUST_ID Cascade
F_ORDJUSTDESC_LANGUAGE_ID LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade