ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
Production.WorkOrderRouting_(table)
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Table''' | Production.WorkOrderRouting |- valign="top" | '''Description''' | Work order details. |} === Columns === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description''' |- valign="top" | WorkOrderID | int | not null | | Primary key. Foreign key to WorkOrder.WorkOrderID. |- valign="top" | ProductID | int | not null | | Primary key. Foreign key to Product.ProductID. |- valign="top" | OperationSequence | smallint | not null | | Primary key. Indicates the manufacturing process sequence. |- valign="top" | LocationID | smallint | not null | | Manufacturing location where the part is processed. Foreign key to Location.LocationID. |- valign="top" | ScheduledStartDate | datetime | not null | | Planned manufacturing start date. |- valign="top" | ScheduledEndDate | datetime | not null | | Planned manufacturing end date. |- valign="top" | ActualStartDate | datetime | null | | Actual start date. |- valign="top" | ActualEndDate | datetime | null | | Actual end date. |- valign="top" | ActualResourceHrs | decimal(9, 4) | null | | Number of manufacturing hours used. |- valign="top" | PlannedCost | money | not null | | Estimated manufacturing cost. |- valign="top" | ActualCost | money | null | | Actual manufacturing cost. |- valign="top" | ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |} === Primary Key === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Primary Key''' | '''Columns''' |- valign="top" | PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence | WorkOrderID, ProductID, OperationSequence |} === Indexes === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Index''' | '''Type''' | '''Columns''' |- valign="top" | IX_WorkOrderRouting_ProductID | | ProductID |} === Check Constraints === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Check Constraint''' | '''Expression''' | '''Description''' |- valign="top" | CK_WorkOrderRouting_ActualCost | ([ActualCost]>(0.00)) | Check constraint [ActualCost] > (0.00) |- valign="top" | CK_WorkOrderRouting_ActualEndDate | ([ActualEndDate]>=[ActualStartDate] OR [ActualEndDate] IS NULL OR [ActualStartDate] IS NULL) | Check constraint [ActualEndDate] >= [ActualStartDate] OR [ActualEndDate] IS NULL OR [ActualStartDate] IS NULL |- valign="top" | CK_WorkOrderRouting_ActualResourceHrs | ([ActualResourceHrs]>=(0.0000)) | Check constraint [ActualResourceHrs] >= (0.0000) |- valign="top" | CK_WorkOrderRouting_PlannedCost | ([PlannedCost]>(0.00)) | Check constraint [PlannedCost] > (0.00) |- valign="top" | CK_WorkOrderRouting_ScheduledEndDate | ([ScheduledEndDate]>=[ScheduledStartDate]) | Check constraint [ScheduledEndDate] >= [ScheduledStartDate] |} === Foreign Keys === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Relation''' | '''Column''' | '''Referenced Column''' |- valign="top" | [[Production.Location_(table)|Production.Location]] | LocationID | LocationID |- valign="top" | [[Production.WorkOrder_(table)|Production.WorkOrder]] | WorkOrderID | WorkOrderID |} === References === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Dependency Type''' | '''Object Type''' | '''Referenced Object''' |- valign="top" | Schema | Schema | [[Production_(schema)|Production]] |} == automatically generated == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table''' | Production.WorkOrderRouting |- valign="top" | '''Description''' | Work order details. |- |- |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description / PK / Index''' |- | WorkOrderID | int | not null | | Primary key. Foreign key to WorkOrder.WorkOrderID.<br />PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence |- | ProductID | int | not null | | Primary key. Foreign key to Product.ProductID.<br />PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequenceIX_WorkOrderRouting_ProductID |- | OperationSequence | smallint | not null | | Primary key. Indicates the manufacturing process sequence.<br />PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence |- | LocationID | smallint | not null | | Manufacturing location where the part is processed. Foreign key to Location.LocationID.<br /> |- | ScheduledStartDate | datetime | not null | | Planned manufacturing start date.<br /> |- | ScheduledEndDate | datetime | not null | | Planned manufacturing end date.<br /> |- | ActualStartDate | datetime | null | | Actual start date.<br /> |- | ActualEndDate | datetime | null | | Actual end date.<br /> |- | ActualResourceHrs | decimal(9, 4) | null | | Number of manufacturing hours used.<br /> |- | PlannedCost | money | not null | | Estimated manufacturing cost.<br /> |- | ActualCost | money | null | | Actual manufacturing cost.<br /> |- | ModifiedDate | datetime | not null | (GETDATE()) | Date and time the record was last updated.<br /> |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Relation''' | '''Column''' | '''Referenced Column''' |- | [[Production.Location_(table)|Production.Location]] | LocationID | LocationID |- | [[Production.WorkOrder_(table)|Production.WorkOrder]] | WorkOrderID | WorkOrderID |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Dependency Type''' | '''Object Type''' | '''Referenced Object''' |- | Schema | Schema | [[Production_(schema)|Production]] |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.