item_storage_exec_link
- Last UpdatedNov 20, 2024
- 1 minute read
The item_storage_exec_link table defines reorder points and amounts for individual storage locations, and not just for the item wherever it may be. Whether or not an order is generated automatically is controlled by the auto_reorder flag in the item table. This is most useful in Kanban environments.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
ent_id |
int32 |
Y |
N |
Storage entity |
|
item_id |
string40 |
Y |
N |
Item whose inventory level is to be monitored |
|
min_inv_level |
tfloat |
N |
N |
The amount of this item stored here below which a replenishment order should be generated |
|
min_reorder_amt |
tfloat |
N |
N |
The minimum quantity of the replenishment order |
|
last_edit_comment |
string254 |
N |
Y |
Reserved for internal use to indicate why this record was changed |
|
last_edit_by |
string40 |
N |
N |
Who last changed this record |
|
last_edit_at |
tdatetime |
N |
N |
When this record was last changed, use as mod_id |
|
row_id |
ID 1 |
N |
N |
Unique row identifier, for audit trail |
FK from item_id to item. (Cascade delete)
FK from ent_id to storage_exec. (Cascade delete)