Inventory

Overview

The Inventory entity represents the storage of specific inventory lots at various locations. Each inventory record links an inventory lot to a storage location, allowing for tracking of material quantities across different locations in the facility. This structure enables effective inventory management by specifying where and how much of each inventory lot is stored.

Table Structure

The following table outlines the SQL columns for the inventory table, providing a brief description of each, along with sample data where applicable.

Column	Type	Description	Example
id	String (ULID)	Unique identifier for the entity.	01JAP8RJBN-8ZTPXSGY-J9GSDPE1
enabled	Boolean	If the entity is enabled or not.	true
created_date	DateTime	Date the entity was created.	2024-12-31T19:48:44Z
created_by	String	Person who created the entity.	TamakiMES
modified_date	DateTime	Date the entity was modified. Value is null upon creation, and gets initially populated upon the first edit.	2024-12-31T19:48:44Z
modified_by	String	Last person to modify the entity. Value is null upon creation, and gets initially populated upon the first edit.	TamakiMES
notes	String	Notes about the entity.	This entity has these extra notes
spare1	String	The first spare column that can be used for additional context on the entity.	some extra context 1
spare2	String	The second spare column that can be used for additional context on the entity.	some extra context 2
spare3	String	The third spare column that can be used for additional context on the entity.	some extra context 3
name	String	Name of the inventory at that location at that time.	165456432135659
quantity	Double	Current quantity of material in this inventory record.	250.0
location_id	String (ULID)	References the location where the inventory is stored. See locations.	01JAP8R5RT-3FPXQABY-7KQZT6VF
inventory_lot_id	String (ULID)	References the inventory lot stored in this location. See inventory_lots.	01JAP8RJBN-4VYZUKE1-LY2QHV8X
production_order_id	String (ULID)	References the associated production order. See production_orders.	01JAP8RJBN-7KQZT6VF-Q5VUZYPW

Field Details

name

The name field provides a descriptive identifier of the inventory at that location at that time, such as a License Plate Number for a pallet.

quantity

Represents the current quantity of material in this specific inventory record. This field allows for accurate management of material stock levels and tracking across multiple locations.

location_id

References the Location entity where this inventory is stored, allowing precise tracking of inventory storage within the facility. See locations for details.

inventory_lot_id

Links to the specific InventoryLot associated with this inventory record, enabling tracking of unique lots within each storage location. See inventory_lots for details.

production_order_id

Indicates the associated ProductionOrder, linking the inventory record to a specific production order. This enables tracking of inventory for a production order. See production_orders for details.