WorkOrder Table (AdventureWorks)
Contains the manufacturing work orders. Work orders control which products are manufactured in the appropriate quantity and in time to meet sales or inventory demands.
WorkOrder Table Definition
The WorkOrder table is contained in the Production schema.
Column |
Data type |
Nullability |
Description |
|---|---|---|---|
WorkOrderID |
int |
Not null |
Primary key. |
ProductID |
int |
Not null |
Product identification number. Foreign key to Product.ProductID. |
OrderQty |
int |
Not null |
Product quantity to build. |
StockedQty |
int |
Not null |
Quantity built and put in inventory. |
ScrappedQty |
smallint |
Not null |
Quantity that failed inspection. |
StartDate |
datetime |
Not null |
Work order start date. |
EndDate |
datetime |
Null |
Work order end date. |
DueDate |
datetime |
Not null |
Work order due date. |
ScrapReasonID |
smalllint |
Null |
Reason the product failed inspection. Foreign key to Production.ScrapReason. |
ModifiedDate |
datetime |
Not null |
Date and time the row was last updated. |