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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000135 | ADJUSTCODE+STOREENT_ID | Unique Index |
SQL050212031233590 | INVADJCODE_ID | Primary Key |
I0000591 | STOREENT_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_388 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_390 | INVADJCODE_ID | INVADJDESC | INVADJCODE_ID | Cascade |
F_391 | INVADJCODE_ID | INVADJUST | INVADJCODE_ID | Cascade |