Difference between revisions of "Production.WorkOrderRouting (table)"
| Line 2: | Line 2: | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| − | |- | + | |- valign="top" |
| '''Table | | '''Table | ||
| Production.WorkOrderRouting | | Production.WorkOrderRouting | ||
| Line 8: | Line 8: | ||
| '''Description | | '''Description | ||
| Work order details. | | Work order details. | ||
| − | |||
|} | |} | ||
| − | |||
=== Columns === | === Columns === | ||
| Line 20: | Line 18: | ||
| '''Default | | '''Default | ||
| '''Description | | '''Description | ||
| − | + | ||
|- valign="top" | |- valign="top" | ||
| WorkOrderID | | WorkOrderID | ||
| Line 100: | Line 98: | ||
| '''Primary Key | | '''Primary Key | ||
| '''Columns | | '''Columns | ||
| − | |- | + | |- valign="top" |
| PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence | | PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence | ||
| WorkOrderID, ProductID, OperationSequence | | WorkOrderID, ProductID, OperationSequence | ||
| Line 111: | Line 109: | ||
| '''Type | | '''Type | ||
| '''Columns | | '''Columns | ||
| − | + | ||
| − | |- | + | |- valign="top" |
| IX_WorkOrderRouting_ProductID | | IX_WorkOrderRouting_ProductID | ||
| | | | ||
| Line 124: | Line 122: | ||
| '''Expression | | '''Expression | ||
| '''Description | | '''Description | ||
| − | + | ||
| − | |- | + | |- valign="top" |
| CK_WorkOrderRouting_ActualCost | | CK_WorkOrderRouting_ActualCost | ||
| ([ActualCost]>(0.00)) | | ([ActualCost]>(0.00)) | ||
| Check constraint [ActualCost] > (0.00) | | Check constraint [ActualCost] > (0.00) | ||
| − | |- | + | |- valign="top" |
| CK_WorkOrderRouting_ActualEndDate | | CK_WorkOrderRouting_ActualEndDate | ||
| ([ActualEndDate]>=[ActualStartDate] OR [ActualEndDate] IS NULL OR [ActualStartDate] IS NULL) | | ([ActualEndDate]>=[ActualStartDate] OR [ActualEndDate] IS NULL OR [ActualStartDate] IS NULL) | ||
| Check constraint [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 | | CK_WorkOrderRouting_ActualResourceHrs | ||
| ([ActualResourceHrs]>=(0.0000)) | | ([ActualResourceHrs]>=(0.0000)) | ||
| Check constraint [ActualResourceHrs] >= (0.0000) | | Check constraint [ActualResourceHrs] >= (0.0000) | ||
| − | |- | + | |- valign="top" |
| CK_WorkOrderRouting_PlannedCost | | CK_WorkOrderRouting_PlannedCost | ||
| ([PlannedCost]>(0.00)) | | ([PlannedCost]>(0.00)) | ||
| Check constraint [PlannedCost] > (0.00) | | Check constraint [PlannedCost] > (0.00) | ||
| − | |- | + | |- valign="top" |
| CK_WorkOrderRouting_ScheduledEndDate | | CK_WorkOrderRouting_ScheduledEndDate | ||
| ([ScheduledEndDate]>=[ScheduledStartDate]) | | ([ScheduledEndDate]>=[ScheduledStartDate]) | ||
| Line 153: | Line 151: | ||
| '''Column | | '''Column | ||
| '''Referenced Column | | '''Referenced Column | ||
| − | + | ||
| − | |- | + | |- valign="top" |
| [[Production.Location_(table)|Production.Location]] | | [[Production.Location_(table)|Production.Location]] | ||
| LocationID | | LocationID | ||
| LocationID | | LocationID | ||
| − | |- | + | |- valign="top" |
| [[Production.WorkOrder_(table)|Production.WorkOrder]] | | [[Production.WorkOrder_(table)|Production.WorkOrder]] | ||
| WorkOrderID | | WorkOrderID | ||
| Line 171: | Line 169: | ||
| '''Referenced Object | | '''Referenced Object | ||
| − | |- | + | |- valign="top" |
| Schema | | Schema | ||
| Schema | | Schema | ||
Latest revision as of 00:17, 24 June 2010
Contents
[hide]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 |
