ScrewTurn Wiki

Edit

wikibot

TableProduction.WorkOrderRouting
DescriptionWork order details.

Edit

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.

Edit

Primary Key

Primary KeyColumns
PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequenceWorkOrderID, ProductID, OperationSequence

Edit

Indexes

IndexTypeColumns
IX_WorkOrderRouting_ProductID ProductID

Edit

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

Edit

Foreign Keys

RelationColumnReferenced Column
Production.LocationLocationIDLocationID
Production.WorkOrderWorkOrderIDWorkOrderID

Edit

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaProduction

Edit

automatically generated

TableProduction.WorkOrderRouting
DescriptionWork order details.

ColumnData TypeNullableDefaultDescription / PK / Index
WorkOrderIDintnot null Primary key. Foreign key to WorkOrder.WorkOrderID.
PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
ProductIDintnot null Primary key. Foreign key to Product.ProductID.
PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequenceIX_WorkOrderRouting_ProductID
OperationSequencesmallintnot null Primary key. Indicates the manufacturing process sequence.
PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
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.



RelationColumnReferenced Column
Production.LocationLocationIDLocationID
Production.WorkOrderWorkOrderIDWorkOrderID

Dependency TypeObject TypeReferenced Object
SchemaSchemaProduction

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.