industry-department-solutions
latest
false
Supply Chain & Retail Solutions user guide
- Overview
- Platform setup and administration
- Platform setup and administration
- Platform architecture
- Data Bridge onboarding overview
- Connecting a Peak-managed data lake
- Connecting a customer-managed data lake
- Creating an AWS IAM role for Data Bridge
- Connecting a Snowflake data warehouse
- Connecting a Redshift data warehouse (public connectivity)
- Connecting a Redshift data warehouse (private connectivity)
- Reauthorizing a Snowflake OAuth connection
- Using Snowflake with Peak
- SQL Explorer overview
- Roles and permissions
- User management
- Inventory management solution
- Commercial pricing solution
- Merchandising solution
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 inventory management 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
| Field | Description | Type | Use | Notes |
|---|---|---|---|---|
product_id | Unique identifier for the manufactured product. | string | Application | N/A |
location_id | Unique identifier for the factory location. | string | Application | N/A |
order_number | Unique identifier for the manufacturing order. | string | Application | N/A |
source_id | Identifier of the source or supplier associated with the order. | string | Application | N/A |
ordered_at | Date and time the manufacturing order was placed. | datetime | Application | N/A |
ordered_units | Number of units ordered for manufacture. | integer | Application | N/A |
expected_start_date | Planned start date and time for production. | datetime | Application | N/A |
actual_start_date | Actual start date and time for production. | datetime | Application | Optional. |
expected_end_date | Planned completion date and time. | datetime | Application | N/A |
actual_end_date | Actual completion date and time. | datetime | Application | Optional. |
produced_units | Number of units actually produced. | integer | Application | Optional. |
status | Current status of the manufacturing order. | string | Application | Optional. |
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.