WebSphere Commerce 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 Descriptions
| 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.
|
Indexes
| Index Name
| Indexed Column Names
| Index Type |
| I0000135
| ADJUSTCODE+STOREENT_ID
| Unique Index
|
| SQL060903235207680
| INVADJCODE_ID
| Primary Key
|
| I0000591
| STOREENT_ID
| Non-Unique Index
|
Constraints
| 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
|
Related reference