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 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.
Indexes:
Index Name Indexed Column Names Index Type
I0000135 ADJUSTCODE, STOREENT_ID Unique Index
SQL030416034946220 INVADJCODE_ID Primary Key
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