Manufacturing orders dataset

Manufacturing orders dataset containing historical and planned manufacturing orders per product and factory location, used by Inventory Management to project future inventory availability.

The manufacturing orders dataset contains historical and planned manufacturing orders for each product at each factory location. It is used by the inventory management solution to project future inventory availability.

Purpose

The solution uses manufacturing order data to understand incoming supply from production. By combining placed and planned orders with expected and actual production dates and quantities, the solution can project future inventory availability and support replenishment and stock optimization recommendations.

Required fields

About the Constraint column: every field listed must be provided in your data. Non-null means its value cannot be null; Nullable means the value may be sent as null (or left blank in your source). Primary key, Unique, and Foreign key describe the field's role in the data model; a Primary key is always non-null.

Field	Description	Type	Constraint
product_id	Unique identifier for the manufactured product.	string	Primary key
location_id	Unique identifier for the factory location.	string	Primary key
order_number	Unique identifier for the manufacturing order.	string	Primary key
source_id	Identifier of the source or supplier associated with the order.	string	Non-null
ordered_at	Date and time the manufacturing order was placed.	datetime	Non-null
ordered_units	Number of units ordered for manufacture.	integer	Non-null
expected_start_date	Planned start date and time for production.	datetime	Non-null
actual_start_date	Actual start date and time for production.	datetime	Nullable
expected_end_date	Planned completion date and time.	datetime	Non-null
actual_end_date	Actual completion date and time.	datetime	Nullable
produced_units	Number of units actually produced.	integer	Nullable
status	Current status of the manufacturing order.	string	Nullable

Usage notes

• This dataset is optional and relevant when inventory is replenished through in-house manufacturing.
• Product and location identifiers must align with the corresponding Products and Locations datasets.
• Both planned and actual dates should be provided where available to support accurate availability projections.
• Quantities should use the same unit of measure as related datasets.