Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Production WorkOrderRouting (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/01/09 18:05


wikibot

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

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