Reference > Database > WebSphere Commerce database tables > I
WebSphere Commerce database table: INVADJCODE
Each row of this table defines an InventoryAdjustmentCode for a Store, or the Stores in a StoreGroup. Each code represents a reason for an InventoryAdjustment, such as broken, lost, or found.
Column Name Column Type Description INVADJCODE_ID BIGINT NOT NULL Generated primary key. ADJUSTCODE CHAR(4) NOT NULL A code that uniquely identifies this InventoryAdjustmentCode for a particular StoreEntity, suitable for display in a user interface that manages InventoryAdjustments and InventoryAdjustmentCodes. LASTUPDATE TIMESTAMP The time this InventoryAdjustmentCode was most recently updated. STOREENT_ID INTEGER NOT NULL The Store or StoreGroup for the InventoryAdjustmentCode. The InventoryAdjustmentCode can be used by the specified Store, or all the Stores in the specified StoreGroup. MARKFORDELETE INTEGER DEFAULT 0 Indicates whether the InventoryAdjustmentCode should be deleted:
0 = Do not delete. It can be used to adjust inventory.
1 = Marked for delete. It may not be used to adjust inventory.
Refer to the Database Cleanup utility.OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000135 ADJUSTCODE+STOREENT_ID Unique Index SQL100520030345180 INVADJCODE_ID Primary Key I0000591 STOREENT_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_388 STOREENT_ID STOREENT STOREENT_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_390 INVADJCODE_ID INVADJDESC INVADJCODE_ID Cascade F_391 INVADJCODE_ID INVADJUST INVADJCODE_ID Cascade
Related reference
_vcc_freeselect_bottom_