Production.WorkOrder (table) - Revision history

Bot at 08:55, 27 August 2011

2011-08-27T08:55:53Z

Bot at 22:17, 23 June 2010

2010-06-23T22:17:07Z

Bot at 22:06, 2 February 2010

2010-02-02T22:06:13Z

Show changes

Bot at 21:55, 28 December 2009

2009-12-28T21:55:52Z

Bot at 06:00, 30 November 2009

2009-11-30T06:00:35Z

Bot at 05:38, 30 November 2009

2009-11-30T05:38:47Z

Bot at 05:24, 30 November 2009

2009-11-30T05:24:22Z

Bot at 23:11, 26 November 2009

2009-11-26T23:11:27Z

Bot at 22:58, 26 November 2009

2009-11-26T22:58:39Z

Bot at 22:27, 26 November 2009

2009-11-26T22:27:51Z

@@ Line 98: / Line 98: @@
 | '''Columns
 |- valign="top"
 | IX_WorkOrder_ScrapReasonID
+|
 | ScrapReasonID
 |}
@@ Line 315: / Line 315: @@
 | Trigger
-| uWorkOrder
+| iWorkOrder
 |- valign="top"
 | Execute
@@ Line 322: / Line 322: @@
 | Trigger
-| iWorkOrder
+| uWorkOrder
 |}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Production.WorkOrder
@@ Line 8: / Line 8: @@
 | '''Description
 | Manufacturing work orders.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | WorkOrderID
@@ Line 88: / Line 86: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_WorkOrder_WorkOrderID
 | WorkOrderID
@@ Line 99: / Line 97: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | IX_WorkOrder_ScrapReasonID
+|
 | ScrapReasonID
-|-
+|- valign="top"
 | IX_WorkOrder_ProductID
+|
@@ Line 116: / Line 114: @@
 | '''Expression
 | '''Description
-−
-|-
+|- valign="top"
 | CK_WorkOrder_EndDate
 | ([EndDate]>=[StartDate] OR [EndDate] IS NULL)
 | Check constraint [EndDate] >= [StartDate] OR [EndDate] IS NULL
-|-
+|- valign="top"
 | CK_WorkOrder_OrderQty
 | ([OrderQty]>(0))
 | Check constraint [OrderQty] > (0)
-|-
+|- valign="top"
 | CK_WorkOrder_ScrappedQty
 | ([ScrappedQty]>=(0))
@@ Line 137: / Line 135: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[Production.Product_(table)|Production.Product]]
 | ProductID
 | ProductID
-|-
+|- valign="top"
 | [[Production.ScrapReason_(table)|Production.ScrapReason]]
 | ScrapReasonID
@@ Line 154: / Line 152: @@
 | '''Column
 | '''Referencing Column
-−
-|-
+|- valign="top"
 | [[Production.WorkOrderRouting_(table)|Production.WorkOrderRouting]]
 | WorkOrderID
@@ Line 164: / Line 162: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
-| '''Triggers
+| '''Trigger
 | '''Type
-−
-|-
+|- valign="top"
 | iWorkOrder
 | ON INSERT
-|-
+|- valign="top"
 | uWorkOrder
 | ON UPDATE
 |}
-	Trigger iWorkOrder
+==== Trigger iWorkOrder ====
 <pre>
 CREATE TRIGGER [Production].[iWorkOrder] ON [Production].[WorkOrder]
@@ Line 219: / Line 217: @@
 END;
 </pre>
-		Trigger uWorkOrder
 <pre>
 CREATE TRIGGER [Production].[uWorkOrder] ON [Production].[WorkOrder]
@@ Line 264: / Line 263: @@
 END;
 </pre>
-−
 === References ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
@@ Line 275: / Line 274: @@
 | '''Child Object
-|-
+|- valign="top"
 | Schema
 | Schema
@@ Line 282: / Line 281: @@
+|
+|
-|-
+|- valign="top"
 | Insert
 | Table
@@ Line 289: / Line 288: @@
 | Trigger
 | iWorkOrder
-|-
+|- valign="top"
 | Insert
 | Table
@@ Line 296: / Line 295: @@
 | Trigger
 | uWorkOrder
-|-
+|- valign="top"
 | Execute
 | Procedure
@@ Line 303: / Line 302: @@
 | Trigger
 | iWorkOrder
-|-
+|- valign="top"
 | Execute
 | Procedure
@@ Line 310: / Line 309: @@
 | Trigger
 | uWorkOrder
-|-
+|- valign="top"
 | Execute
 | Procedure
@@ Line 317: / Line 316: @@
 | Trigger
 | uWorkOrder
-|-
+|- valign="top"
 | Execute
 | Procedure

@@ Line 5: / Line 5: @@
 | '''Table
 | Production.WorkOrder
 |-
 |}
@@ Line 15: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description / PK / Index
-|-
+|- valign="top"
 | WorkOrderID
 | int
 | not null
+|
-| PK_WorkOrder_WorkOrderID
+| Primary key for WorkOrder records.<br />PK_WorkOrder_WorkOrderID
+|- valign="top"
 | ProductID
 | int
 | not null
+|
+| Product identification number. Foreign key to Product.ProductID.<br />IX_WorkOrder_ProductID
-| IX_WorkOrder_ProductID
+|- valign="top"
 | OrderQty
 | int
 | not null
+|
+| Product quantity to build.<br />
+|- valign="top"
 | StockedQty
+|
+|
+|
+| Quantity built and put in inventory.<br />
+|- valign="top"
 | ScrappedQty
 | smallint
 | not null
+|
+| Quantity that failed inspection.<br />
+|- valign="top"
 | StartDate
 | datetime
 | not null
+|
+| Work order start date.<br />
+|- valign="top"
 | EndDate
 | datetime
 | null
+|
+| Work order end date.<br />
+|- valign="top"
 | DueDate
 | datetime
 | not null
+|
+| Work order due date.<br />
+|- valign="top"
 | ScrapReasonID
 | smallint
 | null
+|
+| Reason for inspection failure.<br />IX_WorkOrder_ScrapReasonID
-| IX_WorkOrder_ScrapReasonID
+|- valign="top"
 | ModifiedDate
 | datetime
 | not null
 | (getdate())
+| Date and time the record was last updated.<br />
 |}
@@ Line 134: / Line 126: @@
 | ON UPDATE
 |}
 == automatically generated ==

@@ Line 141: / Line 141: @@
 | Production.WorkOrder
 |- valign="top"
 | '''Description
 | Manufacturing work orders.
 |-
 |}

@@ Line 267: / Line 267: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
-| '''Object Type
-| '''Dependency Type
+| '''Child Type
 |-
 | Schema
 | Schema
 |-
 | [[Production.TransactionHistory_(table)|Production.TransactionHistory]]
-| Table
 | Trigger
 | iWorkOrder
 |-
 | [[Production.TransactionHistory_(table)|Production.TransactionHistory]]
-| Table
 | Trigger
 | uWorkOrder
 |-
 | [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
-| Procedure
 | Trigger
 | iWorkOrder
 |-
 | [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
-| Procedure
 | Trigger
 | uWorkOrder
 |-
 | [[dbo.uspPrintError_(procedure)|dbo.uspPrintError]]
-| Procedure
 | Trigger
 | uWorkOrder
 |-
 | [[dbo.uspPrintError_(procedure)|dbo.uspPrintError]]
-| Procedure
 | Trigger
 | iWorkOrder
 |}