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

automatically generated

Table	Production.WorkOrder
Description	Manufacturing work orders.

Column	Data Type	Nullable	Default	Description / PK / Index
WorkOrderID	int	not null		Primary key for WorkOrder records. PK_WorkOrder_WorkOrderID
ProductID	int	not null		Product identification number. Foreign key to Product.ProductID. IX_WorkOrder_ProductID
OrderQty	int	not null		Product quantity to build.
StockedQty				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	smallint	null		Reason for inspection failure. IX_WorkOrder_ScrapReasonID
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

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

Referenced Object	Object Type	Dependency Type
.Production	Schema	Schema
Production.TransactionHistory	Table	Insert	Trigger	iWorkOrder
Production.TransactionHistory	Table	Insert	Trigger	uWorkOrder
dbo.uspLogError	Procedure	Execute	Trigger	iWorkOrder
dbo.uspLogError	Procedure	Execute	Trigger	uWorkOrder
dbo.uspPrintError	Procedure	Execute	Trigger	uWorkOrder
dbo.uspPrintError	Procedure	Execute	Trigger	iWorkOrder