Production.WorkOrder (table)

wikibot

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

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

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

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