Production.WorkOrderRouting (table)

wikibot

Table

Production.WorkOrderRouting

Column	Data Type	Nullable	Default	PK	Index
WorkOrderID	int	not null		PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
ProductID	int	not null		PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence	IX_WorkOrderRouting_ProductID
OperationSequence	smallint	not null		PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
LocationID	smallint	not null
ScheduledStartDate	datetime	not null
ScheduledEndDate	datetime	not null
ActualStartDate	datetime	null
ActualEndDate	datetime	null
ActualResourceHrs	decimal(9, 4)	null
PlannedCost	money	not null
ActualCost	money	null
ModifiedDate	datetime	not null	(getdate())

Relation	Column	Referenced Column
Production.Location	LocationID	LocationID
Production.WorkOrder	WorkOrderID	WorkOrderID