Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Production WorkOrder (table)

Compare Page Revisions



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


Page Revision: 2010/01/09 18:05


wikibot

TableProduction.WorkOrder
DescriptionManufacturing work orders.

ColumnData TypeNullableDefaultDescription / PK / Index
WorkOrderIDintnot null Primary key for WorkOrder records.
PK_WorkOrder_WorkOrderID
ProductIDintnot null Product identification number. Foreign key to Product.ProductID.
IX_WorkOrder_ProductID
OrderQtyintnot null Product quantity to build.
StockedQty   Quantity built and put in inventory.
ScrappedQtysmallintnot null Quantity that failed inspection.
StartDatedatetimenot null Work order start date.
EndDatedatetimenull Work order end date.
DueDatedatetimenot null Work order due date.
ScrapReasonIDsmallintnull Reason for inspection failure.
IX_WorkOrder_ScrapReasonID
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.



RelationColumnReferenced Column
Production.ProductProductIDProductID
Production.ScrapReasonScrapReasonIDScrapReasonID

Detail TableColumnReferencing Column
Production.WorkOrderRoutingWorkOrderIDWorkOrderID

TriggersType
iWorkOrderON INSERT
uWorkOrderON UPDATE

Dependency TypeObject TypeReferenced ObjectChild TypeChild Object
InsertTableProduction.TransactionHistoryTriggeriWorkOrder
InsertTableProduction.TransactionHistoryTriggeruWorkOrder
ExecuteProceduredbo.uspLogErrorTriggeriWorkOrder
ExecuteProceduredbo.uspLogErrorTriggeruWorkOrder
ExecuteProceduredbo.uspPrintErrorTriggeruWorkOrder
ExecuteProceduredbo.uspPrintErrorTriggeriWorkOrder

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