Production.WorkOrder (table)

wikibot

Table

Production.WorkOrder

Column	Data Type	Nullable	Default	PK	Index
WorkOrderID	int	not null		PK_WorkOrder_WorkOrderID
ProductID	int	not null			IX_WorkOrder_ProductID
OrderQty	int	not null
StockedQty
ScrappedQty	smallint	not null
StartDate	datetime	not null
EndDate	datetime	null
DueDate	datetime	not null
ScrapReasonID	smallint	null			IX_WorkOrder_ScrapReasonID
ModifiedDate	datetime	not null	(getdate())

Relation	Column	Referenced Column
Production.Product	ProductID	ProductID
Production.ScrapReason	ScrapReasonID	ScrapReasonID

Detail Table	Column	Referencing Column
Production.WorkOrderRouting	WorkOrderID	WorkOrderID

Triggers	Type
iWorkOrder	ON INSERT
uWorkOrder	ON UPDATE