Table of Contents

Table Prd_Work_Order_Item_Operations

Entity

Entity: Production.ShopFloor.WorkOrderItemOperations

The operations that are performed to produce the product. Entity: Prd_Work_Order_Item_Operations

Owner Tables Hierarchy

Summary

Name Type Description
Actual_End_Date_Time datetime The date/time when the operation has completed. NULL means that the operation is not completed.
Actual_Start_Date_Time datetime The date/time when the operation has started. NULL means that the has not started yet
Id uniqueidentifier PK
Line_Ord int Order of the line within the work order routing
Minimum_Concurrent_Start_Time_Minutes int How many minutes after the start of this operation can the next operation start. NULL means that the next operation should wait this operation to finish before starting
Move_Time_Minutes int Time to move the lot to the next operation in minutes
Notes nvarchar(254)
Operation_Description nvarchar(max) The short description of the operation.
Operation_Id uniqueidentifier The performed operation.
Row_Version timestamp
Run_Time_Minutes int Time for production of one lot of the produced item in minutes
Scheduled_End_Date_Time datetime The date/time when the operation is scheduled to complete. NULL means that there is still no plan when the operation will finish (for new orders only)
Scheduled_Start_Date_Time datetime The date/time when the operation is planned to start. NULL means that there is still no plan when to start the operaion (only for new work orders)
Scrap_Rate decimal(7, 6) Projected scrap rate of the operation
Setup_Time_Minutes int Time needed to setup the equipment in minutes
Tooling nvarchar(max) The tools needed for the routing step
Use_Quantity decimal(9, 3) Quantity of the resource, that should be allocated for the operation
Wait_Time_Minutes int Wait time (drying, cooling, etc.) after the operation in minutes
Work_Order_Item_Id uniqueidentifier The work order item, containing the line.
Workgroup_Resource_Id uniqueidentifier The resource that will be used for the operation. NULL means that no resource will be locked for the operation

Columns

Actual_End_Date_Time

The date/time when the operation has completed. NULL means that the operation is not completed.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type datetime (Allows NULL)
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Actual_End_Date_Time - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan None no no

Actual_Start_Date_Time

The date/time when the operation has started. NULL means that the has not started yet

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type datetime (Allows NULL)
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Actual_Start_Date_Time - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan None no no

Id

Property Value
Auto Complete no
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key yes (order: 1)
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Line_Ord

Order of the line within the work order routing

Property Value
Auto Complete no
Autoincrement 10
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 0
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type int
UI Memo Editor no
UI Width Short
User Login no
Visible yes

Line_Ord - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no yes
Like None no yes

Minimum_Concurrent_Start_Time_Minutes

How many minutes after the start of this operation can the next operation start. NULL means that the next operation should wait this operation to finish before starting

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type int (Allows NULL)
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Move_Time_Minutes

Time to move the lot to the next operation in minutes

Property Value
Auto Complete no
Data Filter no
Default Value 0
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type int
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Notes

Property Value
Attributes IsLongString
Auto Complete no
Data Filter no
Default Value None
Enter Stop no
Ignore for Insert Order no
Is Entity Name no
Max Length 254
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(254) (Allows NULL)
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Operation_Description

The short description of the operation.

Property Value
Attributes IsLongString
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 2147483647
Order 2
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(max) (Allows NULL)
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Operation_Id

The performed operation.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 1
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Prd_Operations
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier (Allows NULL)
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Operation_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no

Row_Version

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type timestamp
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Run_Time_Minutes

Time for production of one lot of the produced item in minutes

Property Value
Auto Complete no
Data Filter no
Default Value 0
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type int
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Scheduled_End_Date_Time

The date/time when the operation is scheduled to complete. NULL means that there is still no plan when the operation will finish (for new orders only)

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type datetime (Allows NULL)
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Scheduled_End_Date_Time - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan None no no

Scheduled_Start_Date_Time

The date/time when the operation is planned to start. NULL means that there is still no plan when to start the operaion (only for new work orders)

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type datetime (Allows NULL)
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Scheduled_Start_Date_Time - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan None no no

Scrap_Rate

Projected scrap rate of the operation

Property Value
Auto Complete no
Data Filter no
Default Value 0
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(7, 6)
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Setup_Time_Minutes

Time needed to setup the equipment in minutes

Property Value
Auto Complete no
Data Filter no
Default Value 0
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type int
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Tooling

The tools needed for the routing step

Property Value
Attributes IsLongString
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 2147483647
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(max) (Allows NULL)
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Use_Quantity

Quantity of the resource, that should be allocated for the operation

Property Value
Auto Complete no
Data Filter no
Default Value 1
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 4
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(9, 3)
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Wait_Time_Minutes

Wait time (drying, cooling, etc.) after the operation in minutes

Property Value
Auto Complete no
Data Filter no
Default Value 0
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type int
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Work_Order_Item_Id

The work order item, containing the line.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference yes
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Prd_Work_Order_Items
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Work_Order_Item_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Workgroup_Resource_Id

The resource that will be used for the operation. NULL means that no resource will be locked for the operation

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 3
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Prd_Workgroup_Resources
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Workgroup_Resource_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no
Suggest improvement to this page