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 Descriptions:

NameTypeDescription
INVADJCODE_IDBIGINT NOT NULLGenerated primary key.
ADJUSTCODECHAR (4) NOT NULLA code that uniquely identifies this InventoryAdjustmentCode for a particular StoreEntity, suitable for display in a user interface that manages InventoryAdjustments and InventoryAdjustmentCodes.
LASTUPDATETIMESTAMPThe time this InventoryAdjustmentCode was most recently updated.
STOREENT_IDINTEGER NOT NULLThe Store or StoreGroup for the InventoryAdjustmentCode. The InventoryAdjustmentCode can be used by the specified Store, or all the Stores in the specified StoreGroup.
MARKFORDELETEINTEGER DEFAULT 0Indicates 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.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>INVADJCODE_IDPrimary Key
I0000135ADJUSTCODE+STOREENT_IDUnique Index
I0000591STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_388STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_390INVADJCODE_IDINVADJDESCINVADJCODE_IDCascade
F_391INVADJCODE_IDINVADJUSTINVADJCODE_IDCascade