Inventory Lot
Overview
The InventoryLot entity represents a specific batch or lot of a material. Each lot is associated with a parent
material, has a defined status, and includes details like total quantity, expiration date, and unit of measure. This
entity supports tracking and management of materials in discrete quantities for production, inventory, and compliance.
Uniqueness: A database unique constraint enforces that each (
material_id,name) pair may only appear once.
Table Structure
The following table outlines the SQL columns for the inventory_lots 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 | (Required) Name of the lot, unique within the context of its parent material. | Batch #1001 |
material_id | String (ULID) | (Required) References the material associated with this lot. See materials. | 01JAP8R5RT-3FPXQABY-7KQZT6VF |
status | String (Enum) | (Required) Current status of the inventory lot, as defined by the LotStatus enum (defaults to OPEN). | OPEN |
total_quantity | Double | (Required) Total cumulative quantity ever added to the lot (defaults to 0.0). | 1500.0 |
expiration_date | DateTime | (Optional) Expected expiration date of the lot. | 2024-12-31T23:59:59Z |
closed_date | DateTime | (Optional) Date the lot was closed. | 2024-01-15T12:00:00Z |
unit_of_measure_id | String (ULID) | (Required) References the unit of measure for the lot quantity. See unit_of_measure. | 01JAP8RJBN-4VYZUKE1-LY2QHV8X |
Field Details
material_id
References the Material entity associated with this lot, providing context about the material's characteristics and
properties.
See materials for details.
status
Indicates the current state of the lot, using the LotStatus enum (default OPEN), with possible values:
- OPEN: Lot is in the system but not available for use.
- AVAILABLE: Lot is available for use.
- QA_HOLD: Lot is put on hold by QA. It is quarantined or under inspection and is not available for use.
- EXPIRED: Lot is expired. It is not available for use.
- SHIPPED: Lot is shipped to a customer.
- CLOSED: Lot has been closed and is no longer active.
total_quantity
Specifies the cumulative quantity of material ever added to this lot. This value:
- Defaults to
0.0. - Must be greater than or equal to zero.
- Increases when inventory is added, but does not decrease when inventory is consumed or removed.
expiration_date
Optional field for the expected expiration date of the material in the lot, primarily used for perishable or time-sensitive materials.
closed_date
Optional field for the date on which the lot was closed, useful for tracking lifecycle events of the lot.
unit_of_measure_id
References the UnitOfMeasure entity associated with the inventory lot (required). Enables consistent measurement standards.
See unit_of_measure for details.
Uniqueness
The pair (material_id, name) must be unique. Attempts to create a duplicate combination will result in a constraint violation.