WorkOrderRouting Table (AdventureWorks)

Contains manufacturing work order details. Work order details control the order in which the products travel through the work centers during the manufacturing process. WorkOrderRouting also contains the planned and actual manufacturing start and end dates and costs for each work center that is used to build the specified product.

WorkOrderRouting Table Definition

The WorkOrderRouting table is contained in the Production schema.

Column Data type Nullability Description

WorkOrderID

int

Not null

Primary key. Foreign key to WorkOrder.WorkOrderID.

ProductID

int

Not null

Primary key. Product identification number. 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 manufacturing start date.

ActualEndDate

datetime

Null

Actual manufacturing end date.

ActualResourcesHrs

decimal (9,4)

Null

Number of manufacturing hours used by the work center to produce the product.

PlannedCost

money

Not null

Estimated manufacturing cost per work center to produce the product.

ActualCost

money

Null

Actual manufacturing cost per work center to produce the product.

ModifiedDate

datetime

Not null

Date and time the row was last updated.

See Also

Reference

WorkOrder Table (AdventureWorks)
Product Table (AdventureWorks)
Location Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary

Help and Information

Getting SQL Server 2005 Assistance