Production.WorkOrderRouting

Table: 'Production.WorkOrderRouting'

Field Name Data Type Size Original Type Default Nullable Description Check

WorkOrderID int Not null Primary key. Foreign key to WorkOrder.WorkOrderID.

ProductID int Not null Primary key. 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 start date.

ActualEndDate datetime Null Actual end date.

ActualResourceHrs decimal 9,4 Null Number of manufacturing hours used. ([ActualResourceHrs]>=(0.0000))

PlannedCost money 19,4 decimal(19,4) Not null Estimated manufacturing cost. ([PlannedCost]>(0.00))

ActualCost money 19,4 decimal(19,4) Null Actual manufacturing cost. ([ActualCost]>(0.00))

ModifiedDate datetime getdate() Not null Date and time the record was last updated.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
WorkOrderID	int				Not null	Primary key. Foreign key to WorkOrder.WorkOrderID.
ProductID	int				Not null	Primary key. 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 start date.
ActualEndDate	datetime				Null	Actual end date.
ActualResourceHrs	decimal	9,4			Null	Number of manufacturing hours used.	([ActualResourceHrs]>=(0.0000))
PlannedCost	money	19,4	decimal(19,4)		Not null	Estimated manufacturing cost.	([PlannedCost]>(0.00))
ActualCost	money	19,4	decimal(19,4)		Null	Actual manufacturing cost.	([ActualCost]>(0.00))
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Production.WorkOrderRouting'

Primary Key Name Field Names

PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence WorkOrderID, ProductID, OperationSequence

Primary Key Name	Field Names
PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence	WorkOrderID, ProductID, OperationSequence

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

Foreign Primary Key Name

WorkOrderRouting.LocationID Location.LocationID FK_WorkOrderRouting_Location_LocationID

WorkOrderRouting.WorkOrderID WorkOrder.WorkOrderID FK_WorkOrderRouting_WorkOrder_WorkOrderID

Foreign	Primary	Key Name
WorkOrderRouting.LocationID	Location.LocationID	FK_WorkOrderRouting_Location_LocationID
WorkOrderRouting.WorkOrderID	WorkOrder.WorkOrderID	FK_WorkOrderRouting_WorkOrder_WorkOrderID

Indexes for table 'Production.WorkOrderRouting', 2 items

Index Name Description Clustered Unique Fields

PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence Clustered index created by a primary key constraint. Yes Yes WorkOrderID, ProductID, OperationSequence

IX_WorkOrderRouting_ProductID Nonclustered index. No No ProductID

Index Name	Description	Clustered	Unique	Fields
PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence	Clustered index created by a primary key constraint.	Yes	Yes	WorkOrderID, ProductID, OperationSequence
IX_WorkOrderRouting_ProductID	Nonclustered index.	No	No	ProductID

Triggers for table 'Production.WorkOrderRouting', 1 item

Name Description Type Enabled

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

Name	Description	Type	Enabled
uWorkOrderRouting	AFTER 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 Name Type Field Name

Production.CK_WorkOrderRouting_ActualCost check cns N/A

Production.CK_WorkOrderRouting_ActualEndDate check cns N/A

Production.CK_WorkOrderRouting_ActualResourceHrs check cns N/A

Production.CK_WorkOrderRouting_PlannedCost check cns N/A

Production.CK_WorkOrderRouting_ScheduledEndDate check cns N/A

Production.uWorkOrderRouting trigger N/A