Production WorkOrderRouting (table)

wikibot

TableProduction.WorkOrderRouting
DescriptionWork order details.

Columns

ColumnData TypeNullableDefaultDescription
WorkOrderIDintnot null Primary key. Foreign key to WorkOrder.WorkOrderID.
ProductIDintnot null Primary key. Foreign key to Product.ProductID.
OperationSequencesmallintnot null Primary key. Indicates the manufacturing process sequence.
LocationIDsmallintnot null Manufacturing location where the part is processed. Foreign key to Location.LocationID.
ScheduledStartDatedatetimenot null Planned manufacturing start date.
ScheduledEndDatedatetimenot null Planned manufacturing end date.
ActualStartDatedatetimenull Actual start date.
ActualEndDatedatetimenull Actual end date.
ActualResourceHrsdecimal(9, 4)null Number of manufacturing hours used.
PlannedCostmoneynot null Estimated manufacturing cost.
ActualCostmoneynull Actual manufacturing cost.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Primary Key

Primary KeyColumns
PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequenceWorkOrderID, ProductID, OperationSequence

Indexes

IndexTypeColumns
IX_WorkOrderRouting_ProductID ProductID

Check Constraints

Check ConstraintExpressionDescription
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

RelationColumnReferenced Column
Production.LocationLocationIDLocationID
Production.WorkOrderWorkOrderIDWorkOrderID

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaProduction