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