Production.WorkOrderRouting (table) - Revision history

Bot at 22:17, 23 June 2010

2010-06-23T22:17:09Z

Bot at 22:05, 2 February 2010

2010-02-02T22:05:49Z

Bot at 21:55, 28 December 2009

2009-12-28T21:55:53Z

Bot at 06:00, 30 November 2009

2009-11-30T06:00:37Z

Bot at 05:38, 30 November 2009

2009-11-30T05:38:49Z

Bot at 05:25, 30 November 2009

2009-11-30T05:25:15Z

Bot at 23:11, 26 November 2009

2009-11-26T23:11:29Z

Bot at 22:58, 26 November 2009

2009-11-26T22:58:41Z

Bot at 22:27, 26 November 2009

2009-11-26T22:27:52Z

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Production.WorkOrderRouting |- |} {| border="1" cellpadding="5" cellspacing=...

2009-01-03T12:35:28Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Production.WorkOrderRouting |- |} {| border="1" cellpadding="5" cellspacing=...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table
| Production.WorkOrderRouting
|-
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column
| '''Data Type
| '''Nullable
| '''Default
| '''PK
| '''Index

|-
| WorkOrderID
| int
| not null
|
| PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
|
|-
| ProductID
| int
| not null
|
| PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
| IX_WorkOrderRouting_ProductID
|-
| OperationSequence
| smallint
| not null
|
| PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
|
|-
| LocationID
| smallint
| not null
|
|
|
|-
| ScheduledStartDate
| datetime
| not null
|
|
|
|-
| ScheduledEndDate
| datetime
| not null
|
|
|
|-
| ActualStartDate
| datetime
| null
|
|
|
|-
| ActualEndDate
| datetime
| null
|
|
|
|-
| ActualResourceHrs
| decimal(9, 4)
| null
|
|
|
|-
| PlannedCost
| money
| not null
|
|
|
|-
| ActualCost
| money
| null
|
|
|
|-
| ModifiedDate
| datetime
| not null
| (getdate())
|
|
|}

{| 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
|}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Production.WorkOrderRouting
@@ Line 8: / Line 8: @@
 | '''Description
 | Work order details.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | WorkOrderID
@@ Line 100: / Line 98: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
 | WorkOrderID, ProductID, OperationSequence
@@ Line 111: / Line 109: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | IX_WorkOrderRouting_ProductID
+|
@@ Line 124: / Line 122: @@
 | '''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])
@@ Line 153: / Line 151: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[Production.Location_(table)|Production.Location]]
 | LocationID
 | LocationID
-|-
+|- valign="top"
 | [[Production.WorkOrder_(table)|Production.WorkOrder]]
 | WorkOrderID
@@ Line 171: / Line 169: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Schema
 | Schema

@@ Line 12: / Line 12: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 18: / Line 19: @@
 | '''Nullable
 | '''Default
-| '''Description / PK / Index
+| '''Description
 |- valign="top"
@@ Line 25: / Line 26: @@
 | not null
+|
-| Primary key. Foreign key to WorkOrder.WorkOrderID.<br />PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
+| Primary key. Foreign key to WorkOrder.WorkOrderID.
 |- valign="top"
 | ProductID
@@ Line 31: / Line 32: @@
 | not null
+|
-| Primary key. Foreign key to Product.ProductID.<br />PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequenceIX_WorkOrderRouting_ProductID
+| Primary key. Foreign key to Product.ProductID.
 |- valign="top"
 | OperationSequence
@@ Line 37: / Line 38: @@
 | not null
+|
-| Primary key. Indicates the manufacturing process sequence.<br />PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
+| Primary key. Indicates the manufacturing process sequence.
 |- valign="top"
 | LocationID
@@ Line 43: / Line 44: @@
 | not null
+|
-| Manufacturing location where the part is processed. Foreign key to Location.LocationID.<br />
+| Manufacturing location where the part is processed. Foreign key to Location.LocationID.
 |- valign="top"
 | ScheduledStartDate
@@ Line 49: / Line 50: @@
 | not null
+|
-| Planned manufacturing start date.<br />
+| Planned manufacturing start date.
 |- valign="top"
 | ScheduledEndDate
@@ Line 55: / Line 56: @@
 | not null
+|
-| Planned manufacturing end date.<br />
+| Planned manufacturing end date.
 |- valign="top"
 | ActualStartDate
@@ Line 61: / Line 62: @@
 | null
+|
-| Actual start date.<br />
+| Actual start date.
 |- valign="top"
 | ActualEndDate
@@ Line 67: / Line 68: @@
 | null
+|
-| Actual end date.<br />
+| Actual end date.
 |- valign="top"
 | ActualResourceHrs
@@ Line 73: / Line 74: @@
 | null
+|
-| Number of manufacturing hours used.<br />
+| Number of manufacturing hours used.
 |- valign="top"
 | PlannedCost
@@ Line 79: / Line 80: @@
 | not null
+|
-| Estimated manufacturing cost.<br />
+| Estimated manufacturing cost.
 |- valign="top"
 | ActualCost
@@ Line 85: / Line 86: @@
 | null
+|
-| Actual manufacturing cost.<br />
+| Actual manufacturing cost.
 |- valign="top"
 | ModifiedDate
@@ Line 91: / Line 92: @@
 | not null
 | (getdate())
-| Date and time the record was last updated.<br />
+| Date and time the record was last updated.
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 112: / Line 164: @@
 |}

@@ Line 128: / Line 128: @@
 | Production.WorkOrderRouting
 |- valign="top"
 | '''Description
 | Work order details.
 |-
 |}

@@ Line 239: / Line 239: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
 |-
 | Schema
 | Schema
 |}

@@ Line 127: / Line 127: @@
 | '''Table
 | Production.WorkOrderRouting
-|-
+|- valign="top"
 | '''Description
@@ Line 149: / Line 149: @@
 | not null
+|
-| Primary key. Foreign key to WorkOrder.WorkOrderID.PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
+| Primary key. Foreign key to WorkOrder.WorkOrderID.<br />PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
 |- valign="top"
 | ProductID
@@ Line 155: / Line 155: @@
 | not null
+|
-| Primary key. Foreign key to Product.ProductID.PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequenceIX_WorkOrderRouting_ProductID
+| Primary key. Foreign key to Product.ProductID.<br />PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequenceIX_WorkOrderRouting_ProductID
 |- valign="top"
 | OperationSequence
@@ Line 161: / Line 161: @@
 | not null
+|
-| Primary key. Indicates the manufacturing process sequence.PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
+| Primary key. Indicates the manufacturing process sequence.<br />PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
 |- valign="top"
 | LocationID
@@ Line 167: / Line 167: @@
 | not null
+|
-| Manufacturing location where the part is processed. Foreign key to Location.LocationID.
+| Manufacturing location where the part is processed. Foreign key to Location.LocationID.<br />
 |- valign="top"
 | ScheduledStartDate
@@ Line 173: / Line 173: @@
 | not null
+|
-| Planned manufacturing start date.
+| Planned manufacturing start date.<br />
 |- valign="top"
 | ScheduledEndDate
@@ Line 179: / Line 179: @@
 | not null
+|
-| Planned manufacturing end date.
+| Planned manufacturing end date.<br />
 |- valign="top"
 | ActualStartDate
@@ Line 185: / Line 185: @@
 | null
+|
-| Actual start date.
+| Actual start date.<br />
 |- valign="top"
 | ActualEndDate
@@ Line 191: / Line 191: @@
 | null
+|
-| Actual end date.
+| Actual end date.<br />
 |- valign="top"
 | ActualResourceHrs
@@ Line 197: / Line 197: @@
 | null
+|
-| Number of manufacturing hours used.
+| Number of manufacturing hours used.<br />
 |- valign="top"
 | PlannedCost
@@ Line 203: / Line 203: @@
 | not null
+|
-| Estimated manufacturing cost.
+| Estimated manufacturing cost.<br />
 |- valign="top"
 | ActualCost
@@ Line 209: / Line 209: @@
 | null
+|
-| Actual manufacturing cost.
+| Actual manufacturing cost.<br />
 |- valign="top"
 | ModifiedDate
@@ Line 215: / Line 215: @@
 | not null
 | (GETDATE())
-| Date and time the record was last updated.
+| Date and time the record was last updated.<br />
 |}