WebSphere Commerce database table: INVADJDESC

INVADJDESC

Each row of this table contains language-dependent information about an InventoryAdjustmentCode.

Column Descriptions:

Name Type Description
INVADJCODE_ID BIGINT NOT NULL The InventoryAdjustmentCode.
DESCRIPTION VARCHAR (254) A description of the InventoryAdjustmentCode, suitable for display in a user interface that manages InventoryAdjustments or InventoryAdjustmentCodes.
LANGUAGE_ID INTEGER NOT NULL The language for this information. For a list of language components, see the LANGUAGE table.
LASTUPDATE TIMESTAMP The time this information was most recently updated.
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> INVADJCODE_ID+LANGUAGE_ID Primary Key

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_389 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_390 INVADJCODE_ID INVADJCODE INVADJCODE_ID Cascade

Related reference
ATP inventory adjustment data model

Name	Type	Description
INVADJCODE_ID	BIGINT NOT NULL	The InventoryAdjustmentCode.
DESCRIPTION	VARCHAR (254)	A description of the InventoryAdjustmentCode, suitable for display in a user interface that manages InventoryAdjustments or InventoryAdjustmentCodes.
LANGUAGE_ID	INTEGER NOT NULL	The language for this information. For a list of language components, see the LANGUAGE table.
LASTUPDATE	TIMESTAMP	The time this information was most recently updated.
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_389	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade
F_390	INVADJCODE_ID	INVADJCODE	INVADJCODE_ID	Cascade