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:
Name | 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 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | INVADJCODE_ID | Primary Key |
I0000135 | ADJUSTCODE+STOREENT_ID | Unique Index |
I0000591 | STOREENT_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_388 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Referenced By Child Tables:
Constraint | Columns | Child Table | Child Columns | Type |
F_390 | INVADJCODE_ID | INVADJDESC | INVADJCODE_ID | Cascade |
F_391 | INVADJCODE_ID | INVADJUST | INVADJCODE_ID | Cascade |