Table of Contents

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

Tooling

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