Table Prd_Operations
Entity
Entity: Production.Resources.Operations
The different steps performed to create products. Entity: Prd_Operations
Owner Tables Hierarchy
Summary
Name
Type
Description
Active
bit
Indicates whether the current operation is active.
Description
nvarchar(max)
Id
uniqueidentifier
PK
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
The time required for the product to move to the next operation. During this time no resource is allocated.
Operation_Group_Id
uniqueidentifier
Operation_Instructions_Id
uniqueidentifier
Full instructions for the operation.
Operation_Name
nvarchar(50)
Row_Version
timestamp
Run_Time_Minutes
int
The time required to process one product lot. The run time is calculated for each produced lot.
Scrap_Rate
decimal(7, 6)
The percentage (0..1) of scrap usually occurring during the production operation. NULL means that the scrap rate cannot be generally calculated.
Setup_Time_Minutes
int
The time required to setup the operation. The setup is incurred only once, regardless of the produced quntity.
Standard_Price_Per_Hour
decimal(18, 6)
Standard price for 1 hour work for this operation.
Tooling
nvarchar(254)
Short description of the needed instruments for the operation.
Use_Quantity_Base
decimal(9, 3)
Quantity of the resource that need to be allocated for the operation, in base measurement units for the resource
Wait_Time_Minutes
int
The time required to wait after completing the operation. During this time, the resource is still allocated to the operation.
Workgroup_Resource_Id
uniqueidentifier
When not NULL, specifies the Workgroup Resource, which is required by the operation.
Columns
Active
Indicates whether the current operation is active.
Property
Value
Auto Complete
no
Data Filter
no
Default Value
True
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
16
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
no
Type
bit
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Active - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
True
no
no
Description
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
2147483647
Order
11
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
Medium
User Login
no
Visible
yes
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
0
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
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
5
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
The time required for the product to move to the next operation. During this time no resource is allocated.
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
9
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
Operation_Group_Id
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
yes
Pasword
no
Picture
no
Primary Key
no
Readonly
no
Referenced Table
Prd_Operation_Groups
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
yes
Type
uniqueidentifier
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Operation_Group_Id - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
Operation_Instructions_Id
Full instructions 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
13
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
Referenced Table
Prd_Operation_Instructions
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
yes
Type
uniqueidentifier (Allows NULL)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
no
Operation_Instructions_Id - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
yes
no
Operation_Name
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
50
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(50)
UI Memo Editor
no
UI Width
Long
User Login
no
Visible
yes
Operation_Name - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Like
None
no
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
15
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
The time required to process one product lot. The run time is calculated for each produced lot.
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
7
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
Scrap_Rate
The percentage (0..1) of scrap usually occurring during the production operation. NULL means that the scrap rate cannot be generally calculated.
Property
Value
Attributes
IsPercent
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
no
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
10
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) (Allows NULL)
UI Memo Editor
no
UI Width
Short
User Login
no
Visible
yes
Setup_Time_Minutes
The time required to setup the operation. The setup is incurred only once, regardless of the produced quntity.
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
6
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
Standard_Price_Per_Hour
Standard price for 1 hour work for this 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
14
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(18, 6)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
no
Short description of the needed instruments for 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
254
Order
12
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
Medium
User Login
no
Visible
yes
Use_Quantity_Base
Quantity of the resource that need to be allocated for the operation, in base measurement units for the resource
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
Short
User Login
no
Visible
yes
Wait_Time_Minutes
The time required to wait after completing the operation. During this time, the resource is still allocated to 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
8
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
Workgroup_Resource_Id
When not NULL, specifies the Workgroup Resource, which is required by 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 (Allows NULL)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Workgroup_Resource_Id - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
yes
no