WorkOrderRouting Table (AdventureWorks)
Contains manufacturing work order details. Work order details control the order in which the products travel through the work centers during the manufacturing process. WorkOrderRouting also contains the planned and actual manufacturing start and end dates and costs for each work center that is used to build the specified product.
The WorkOrderRouting table is contained in the Production schema.
Column | Data type | Nullability | Description |
---|---|---|---|
WorkOrderID |
int |
Not null |
Primary key. Foreign key to WorkOrder.WorkOrderID. |
ProductID |
int |
Not null |
Primary key. Product identification number. Foreign key to Product.ProductID. |
OperationSequence |
smallint |
Not null |
Primary key. Indicates the manufacturing process sequence. |
LocationID |
smallint |
Not null |
Manufacturing location where the part is processed. Foreign key to Location.LocationID. |
ScheduledStartDate |
datetime |
Not null |
Planned manufacturing start date. |
ScheduledEndDate |
datetime |
Not null |
Planned manufacturing end date. |
ActualStartDate |
datetime |
Null |
Actual manufacturing start date. |
ActualEndDate |
datetime |
Null |
Actual manufacturing end date. |
ActualResourcesHrs |
decimal (9,4) |
Null |
Number of manufacturing hours used by the work center to produce the product. |
PlannedCost |
money |
Not null |
Estimated manufacturing cost per work center to produce the product. |
ActualCost |
money |
Null |
Actual manufacturing cost per work center to produce the product. |
ModifiedDate |
datetime |
Not null |
Date and time the row was last updated. |
WorkOrder Table (AdventureWorks)
Product Table (AdventureWorks)
Location Table (AdventureWorks)