Production.WorkOrderRouting (table)

wikibot

Table	Production.WorkOrderRouting
Description	Work order details.

Columns

Column	Data Type	Nullable	Default	Description
WorkOrderID	int	not null		Primary key. Foreign key to WorkOrder.WorkOrderID.
ProductID	int	not null		Primary key. Foreign key to Product.ProductID.
OperationSequence	smallint	not null		Primary key. Indicates the manufacturing process sequence.
LocationID	smallint	not null		Manufacturing location where the part is processed. Foreign key to Location.LocationID.
ScheduledStartDate	datetime	not null		Planned manufacturing start date.
ScheduledEndDate	datetime	not null		Planned manufacturing end date.
ActualStartDate	datetime	null		Actual start date.
ActualEndDate	datetime	null		Actual end date.
ActualResourceHrs	decimal(9, 4)	null		Number of manufacturing hours used.
PlannedCost	money	not null		Estimated manufacturing cost.
ActualCost	money	null		Actual manufacturing cost.
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Primary Key

Primary Key	Columns
PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence	WorkOrderID, ProductID, OperationSequence

Indexes

Index	Type	Columns
IX_WorkOrderRouting_ProductID		ProductID

Check Constraints

Check Constraint	Expression	Description
CK_WorkOrderRouting_ActualCost	([ActualCost]>(0.00))	Check constraint [ActualCost] > (0.00)
CK_WorkOrderRouting_ActualEndDate	([ActualEndDate]>=[ActualStartDate] OR [ActualEndDate] IS NULL OR [ActualStartDate] IS NULL)	Check constraint [ActualEndDate] >= [ActualStartDate] OR [ActualEndDate] IS NULL OR [ActualStartDate] IS NULL
CK_WorkOrderRouting_ActualResourceHrs	([ActualResourceHrs]>=(0.0000))	Check constraint [ActualResourceHrs] >= (0.0000)
CK_WorkOrderRouting_PlannedCost	([PlannedCost]>(0.00))	Check constraint [PlannedCost] > (0.00)
CK_WorkOrderRouting_ScheduledEndDate	([ScheduledEndDate]>=[ScheduledStartDate])	Check constraint [ScheduledEndDate] >= [ScheduledStartDate]

Foreign Keys

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

References

Dependency Type	Object Type	Referenced Object
Schema	Schema	Production

automatically generated

Table	Production.WorkOrderRouting
Description	Work order details.

Column	Data Type	Nullable	Default	Description / PK / Index
WorkOrderID	int	not null		Primary key. Foreign key to WorkOrder.WorkOrderID. PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
ProductID	int	not null		Primary key. Foreign key to Product.ProductID. PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequenceIX_WorkOrderRouting_ProductID
OperationSequence	smallint	not null		Primary key. Indicates the manufacturing process sequence. PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
LocationID	smallint	not null		Manufacturing location where the part is processed. Foreign key to Location.LocationID.
ScheduledStartDate	datetime	not null		Planned manufacturing start date.
ScheduledEndDate	datetime	not null		Planned manufacturing end date.
ActualStartDate	datetime	null		Actual start date.
ActualEndDate	datetime	null		Actual end date.
ActualResourceHrs	decimal(9, 4)	null		Number of manufacturing hours used.
PlannedCost	money	not null		Estimated manufacturing cost.
ActualCost	money	null		Actual manufacturing cost.
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

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

Dependency Type	Object Type	Referenced Object
Schema	Schema	Production