Reference > Database > WebSphere Commerce database tables > I


WebSphere Commerce database table: INVADJDESC

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

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

Indexes
Index Name Indexed Column Names Index Type
SQL100520030345330 INVADJCODE_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_390 INVADJCODE_ID INVADJCODE INVADJCODE_ID Cascade
F_389 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search