WebSphere Commerce database table: ORDADJDSC

ORDADJDSC

Each row of this table contains language-dependent information for an OrderAdjustment.

Column Descriptions:

Name Type Description
ORDADJUST_ID BIGINT NOT NULL Generated unique key.
LANGUAGE_ID INTEGER NOT NULL The language of the description. For a list of language components, see the LANGUAGE table.
DESCRIPTION VARCHAR (254) A brief description of the OrderAdjustment, suitable for display to a customer. Normally, this is the CalculationCode description (CALCODEDSC.DESCRIPTION) of the CalculationCode used to create the OrderAdjustment.
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> ORDADJUST_ID+LANGUAGE_ID Primary Key

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_486 ORDADJUST_ID ORDADJUST ORDADJUST_ID Cascade
F_487 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

Related reference
Order adjustment data model

Name	Type	Description
ORDADJUST_ID	BIGINT NOT NULL	Generated unique key.
LANGUAGE_ID	INTEGER NOT NULL	The language of the description. For a list of language components, see the LANGUAGE table.
DESCRIPTION	VARCHAR (254)	A brief description of the OrderAdjustment, suitable for display to a customer. Normally, this is the CalculationCode description (CALCODEDSC.DESCRIPTION) of the CalculationCode used to create the OrderAdjustment.
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.

Constraint	Columns	Parent Table	Parent Columns	Type
F_486	ORDADJUST_ID	ORDADJUST	ORDADJUST_ID	Cascade
F_487	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade