Generated using SQL Data Dictionary demo version.

Table Production.WorkOrder (72,591 rows)

Manufacturing work orders.

  Column Data Type Identity Nullable Default
PK WorkOrderID int X
Primary key for WorkOrder records.
FK ProductID int
Product identification number. Foreign key to Product.ProductID.
OrderQty int
Product quantity to build.
StockedQty int
Quantity built and put in inventory.
ScrappedQty smallint
Quantity that failed inspection.
StartDate datetime
Work order start date.
EndDate datetime X
Work order end date.
DueDate datetime
Work order due date.
FK ScrapReasonID smallint X
Reason for inspection failure.
ModifiedDate datetime getdate()
Date and time the record was last updated.



Referenced by: