WebSphere Commerce database table: ORDADJDSC

WebSphere Commerce database table: ORDADJDSC

Each row of this table contains language-dependent information for an OrderAdjustment.
Column Descriptions
Column Name Column 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 Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235218050 ORDADJUST_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_487 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_486 ORDADJUST_ID ORDADJUST ORDADJUST_ID Cascade
Related reference

Order adjustment data model

Column Name	Column 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	Reserved for IBM internal use.

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_487	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade
F_486	ORDADJUST_ID	ORDADJUST	ORDADJUST_ID	Cascade