Difference between revisions of "Production.WorkOrderRouting (table)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Production.WorkOrderRouting |- |} {| border="1" cellpadding="5" cellspacing=...)
 
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
== wikibot ==
 
== 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"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
Line 5: Line 183:
 
| '''Table
 
| '''Table
 
| Production.WorkOrderRouting
 
| Production.WorkOrderRouting
 +
|- valign="top"
 +
| '''Description
 +
| Work order details.
 
|-
 
|-
 
|}
 
|}
Line 15: Line 196:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description / PK / Index
−
| '''Index
 
 
 
−
|-
+
|- valign="top"
 
| WorkOrderID
 
| WorkOrderID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
+
| Primary key. Foreign key to WorkOrder.WorkOrderID.<br />PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
−
|
+
|- valign="top"
−
|-
 
 
| ProductID
 
| ProductID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
+
| Primary key. Foreign key to Product.ProductID.<br />PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequenceIX_WorkOrderRouting_ProductID
−
| IX_WorkOrderRouting_ProductID
+
|- valign="top"
−
|-
 
 
| OperationSequence
 
| OperationSequence
 
| smallint
 
| smallint
 
| not null
 
| not null
 
|  
 
|  
−
| PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
+
| Primary key. Indicates the manufacturing process sequence.<br />PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
−
|
+
|- valign="top"
−
|-
 
 
| LocationID
 
| LocationID
 
| smallint
 
| smallint
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Manufacturing location where the part is processed. Foreign key to Location.LocationID.<br />
−
|
+
|- valign="top"
−
|-
 
 
| ScheduledStartDate
 
| ScheduledStartDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Planned manufacturing start date.<br />
−
|
+
|- valign="top"
−
|-
 
 
| ScheduledEndDate
 
| ScheduledEndDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Planned manufacturing end date.<br />
−
|
+
|- valign="top"
−
|-
 
 
| ActualStartDate
 
| ActualStartDate
 
| datetime
 
| datetime
 
| null
 
| null
 
|  
 
|  
−
|  
+
| Actual start date.<br />
−
|
+
|- valign="top"
−
|-
 
 
| ActualEndDate
 
| ActualEndDate
 
| datetime
 
| datetime
 
| null
 
| null
 
|  
 
|  
−
|  
+
| Actual end date.<br />
−
|
+
|- valign="top"
−
|-
 
 
| ActualResourceHrs
 
| ActualResourceHrs
 
| decimal(9, 4)
 
| decimal(9, 4)
 
| null
 
| null
 
|  
 
|  
−
|  
+
| Number of manufacturing hours used.<br />
−
|
+
|- valign="top"
−
|-
 
 
| PlannedCost
 
| PlannedCost
 
| money
 
| money
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Estimated manufacturing cost.<br />
−
|
+
|- valign="top"
−
|-
 
 
| ActualCost
 
| ActualCost
 
| money
 
| money
 
| null
 
| null
 
|  
 
|  
−
|  
+
| Actual manufacturing cost.<br />
−
|
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
−
| (getdate())
+
| (GETDATE())
−
|  
+
| Date and time the record was last updated.<br />
−
|
 
 
|}
 
|}
  
Line 120: Line 288:
 
| WorkOrderID
 
| WorkOrderID
 
| 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]]
 +
 
|}
 
|}

Latest revision as of 23:17, 23 June 2010

wikibot[edit]

Table Production.WorkOrderRouting
Description Work order details.

Columns[edit]

Column Data Type Nullable Default Description
WorkOrderID int not null Primary key. Foreign key to WorkOrder.WorkOrderID.
ProductID int not null Primary key. Foreign key to Product.ProductID.
OperationSequence smallint not null Primary key. Indicates the manufacturing process sequence.
LocationID smallint not null Manufacturing location where the part is processed. Foreign key to Location.LocationID.
ScheduledStartDate datetime not null Planned manufacturing start date.
ScheduledEndDate datetime not null Planned manufacturing end date.
ActualStartDate datetime null Actual start date.
ActualEndDate datetime null Actual end date.
ActualResourceHrs decimal(9, 4) null Number of manufacturing hours used.
PlannedCost money not null Estimated manufacturing cost.
ActualCost money null Actual manufacturing cost.
ModifiedDate datetime not null (getdate()) Date and time the record was last updated.

Primary Key[edit]

Primary Key Columns
PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence WorkOrderID, ProductID, OperationSequence

Indexes[edit]

Index Type Columns
IX_WorkOrderRouting_ProductID ProductID

Check Constraints[edit]

Check Constraint Expression Description
CK_WorkOrderRouting_ActualCost ([ActualCost]>(0.00)) Check constraint [ActualCost] > (0.00)
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
CK_WorkOrderRouting_ActualResourceHrs ([ActualResourceHrs]>=(0.0000)) Check constraint [ActualResourceHrs] >= (0.0000)
CK_WorkOrderRouting_PlannedCost ([PlannedCost]>(0.00)) Check constraint [PlannedCost] > (0.00)
CK_WorkOrderRouting_ScheduledEndDate ([ScheduledEndDate]>=[ScheduledStartDate]) Check constraint [ScheduledEndDate] >= [ScheduledStartDate]

Foreign Keys[edit]

Relation Column Referenced Column
Production.Location LocationID LocationID
Production.WorkOrder WorkOrderID WorkOrderID

References[edit]

Dependency Type Object Type Referenced Object
Schema Schema Production


automatically generated[edit]

Table Production.WorkOrderRouting
Description Work order details.


Column Data Type Nullable Default Description / PK / Index
WorkOrderID int not null Primary key. Foreign key to WorkOrder.WorkOrderID.
PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
ProductID int not null Primary key. Foreign key to Product.ProductID.
PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequenceIX_WorkOrderRouting_ProductID
OperationSequence smallint not null Primary key. Indicates the manufacturing process sequence.
PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
LocationID smallint not null Manufacturing location where the part is processed. Foreign key to Location.LocationID.
ScheduledStartDate datetime not null Planned manufacturing start date.
ScheduledEndDate datetime not null Planned manufacturing end date.
ActualStartDate datetime null Actual start date.
ActualEndDate datetime null Actual end date.
ActualResourceHrs decimal(9, 4) null Number of manufacturing hours used.
PlannedCost money not null Estimated manufacturing cost.
ActualCost money null Actual manufacturing cost.
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Relation Column Referenced Column
Production.Location LocationID LocationID
Production.WorkOrder WorkOrderID WorkOrderID


Dependency Type Object Type Referenced Object
Schema Schema Production
Retrieved from "http://dbshelp.devio.at/index.php?title=Production.WorkOrderRouting_(table)&oldid=2650"