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 | Column Description |
---|---|---|
ADJUSTCODE | CHARACTER (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. |
INVADJCODE_ID | BIGINT NOT NULL |
Generated primary key. |
LASTUPDATE | TIMESTAMP NULL |
The time this InventoryAdjustmentCode was most recently updated. |
MARKFORDELETE | INTEGER NULL, 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. |
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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000135 | ADJUSTCODE, STOREENT_ID | Unique Index |
SQL030416034946220 | INVADJCODE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_388 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
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 |