Production WorkOrderRouting (table)

Modified on 2011/08/27 11:18 by wikibot Categorized as Uncategorized
== 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
| &nbsp;
| Primary key. Foreign key to WorkOrder.WorkOrderID.
|- valign="top"
| ProductID
| int
| not null
| &nbsp;
| Primary key. Foreign key to Product.ProductID.
|- valign="top"
| OperationSequence
| smallint
| not null
| &nbsp;
| Primary key. Indicates the manufacturing process sequence.
|- valign="top"
| LocationID
| smallint
| not null
| &nbsp;
| Manufacturing location where the part is processed. Foreign key to Location.LocationID.
|- valign="top"
| ScheduledStartDate
| datetime
| not null
| &nbsp;
| Planned manufacturing start date.
|- valign="top"
| ScheduledEndDate
| datetime
| not null
| &nbsp;
| Planned manufacturing end date.
|- valign="top"
| ActualStartDate
| datetime
| null
| &nbsp;
| Actual start date.
|- valign="top"
| ActualEndDate
| datetime
| null
| &nbsp;
| Actual end date.
|- valign="top"
| ActualResourceHrs
| decimal(9, 4)
| null
| &nbsp;
| Number of manufacturing hours used.
|- valign="top"
| PlannedCost
| money
| not null
| &nbsp;
| Estimated manufacturing cost.
|- valign="top"
| ActualCost
| money
| null
| &nbsp;
| 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
| &nbsp;
| 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]]

|}
devio dbscript ScrewTurn Wiki

Navigation¶

Production WorkOrderRouting (table)
