inv_lot_attr
- Last UpdatedNov 12, 2024
- 1 minute read
The inv_lot_attr table displays as columns all the lot attributes to be visible in an inventory grid, for each lot in inventory. This table initially has two columns, the item_id and the lot_no, with an additional pair of columns being added whenever visible_in_inv is set to Yes for a lot attribute or whenever a lot attribute is created with this set to Yes. A pair of columns is removed whenever visible_in_inv is set to No for a lot attribute or whenever a lot attribute with this set to Yes is deleted. A row is added whenever a record with a new combination of item_id and lot_no is added to the item_inv table. A row is deleted whenever the last record having a particular combination of item_id and lot_no is deleted from the item_inv table.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
inv_lot_item_id_h |
string40 |
Y |
N |
Identify item of the lot whose attributes are to be displayed in inventory |
|
inv_lot_lot_no_h |
string40 |
Y |
N |
Identify lot whose attributes are to be displayed in inventory |
|
attr<attr_id> |
string1700 |
N |
Y |
Value of the lot attribute whose ID is the numeric part of the field name following "attr" |
|
attr<attr_id>d_h |
string80 |
N |
N |
Description of the attribute whose ID is the numeric part of the field name following "attr" and preceding "d_h". This will be the same for every row. |
|
... |
string80 |
N |
Y |
(additional pairs of rows per above, one for every lot attribute where "visible_in_queue" is Yes) |
|
... |
string80 |
N |
N |
FK from inv_lot_item_id_h, inv_lot_lot_no_h to lot. (Cascade delete)