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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000135 ADJUSTCODE+STOREENT_ID Unique Index
SQL050212031233590 INVADJCODE_ID Primary Key
I0000591 STOREENT_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_388 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_390 INVADJCODE_ID INVADJDESC INVADJCODE_ID Cascade
F_391 INVADJCODE_ID INVADJUST INVADJCODE_ID Cascade

Feedback