Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.