Production.WorkOrderRouting

Table: 'Production.WorkOrderRouting'

12 fields. 145 bytes.

Work order details.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
WorkOrderIDint   Not nullPrimary key. Foreign key to WorkOrder.WorkOrderID. 
ProductIDint   Not nullPrimary key. Foreign key to Product.ProductID. 
OperationSequencesmallint   Not nullPrimary key. Indicates the manufacturing process sequence. 
LocationIDsmallint   Not nullManufacturing location where the part is processed. Foreign key to Location.LocationID. 
ScheduledStartDatedatetime   Not nullPlanned manufacturing start date. 
ScheduledEndDatedatetime   Not nullPlanned manufacturing end date. 
ActualStartDatedatetime   NullActual start date. 
ActualEndDatedatetime   NullActual end date. 
ActualResourceHrsdecimal9,4  NullNumber of manufacturing hours used.([ActualResourceHrs]>=(0.0000))
PlannedCostmoney19,4decimal(19,4) Not nullEstimated manufacturing cost.([PlannedCost]>(0.00))
ActualCostmoney19,4decimal(19,4) NullActual manufacturing cost.([ActualCost]>(0.00))
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Production.WorkOrderRouting'

Primary Key NameField Names
PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequenceWorkOrderID, ProductID, OperationSequence

Foreign keys for table 'Production.WorkOrderRouting', 2 items

ForeignPrimaryKey Name
WorkOrderRouting.LocationIDLocation.LocationIDFK_WorkOrderRouting_Location_LocationID
WorkOrderRouting.WorkOrderIDWorkOrder.WorkOrderIDFK_WorkOrderRouting_WorkOrder_WorkOrderID

Indexes for table 'Production.WorkOrderRouting', 2 items

Index NameDescriptionClusteredUniqueFields
PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequenceClustered index created by a primary key constraint.YesYesWorkOrderID, ProductID, OperationSequence
IX_WorkOrderRouting_ProductIDNonclustered index.NoNoProductID

Triggers for table 'Production.WorkOrderRouting', 1 item

NameDescriptionTypeEnabled
uWorkOrderRoutingAFTER UPDATE trigger setting the ModifiedDate column in the WorkOrderRouting table to the current date.after Update Yes

Dependencies for table 'Production.WorkOrderRouting', 6 items

Object NameTypeField Name
Production.CK_WorkOrderRouting_ActualCostcheck cnsN/A
Production.CK_WorkOrderRouting_ActualEndDatecheck cnsN/A
Production.CK_WorkOrderRouting_ActualResourceHrscheck cnsN/A
Production.CK_WorkOrderRouting_PlannedCostcheck cnsN/A
Production.CK_WorkOrderRouting_ScheduledEndDatecheck cnsN/A
Production.uWorkOrderRoutingtriggerN/A