Table of Contents

Table Prd_Work_Order_Item_Operation_Resources

Owner Tables Hierarchy

Summary

Name Type Description
Function_Id uniqueidentifier Specifies the function, that the resource must be able to perform. This helps the selection of specific resource for the operation. This column is used as search/selection criteria. NULL means that the user must select the resource through all resources
Id uniqueidentifier PK
Line_Ord int The order of the line within the item.
Locked_Quantity decimal(18, 3) The quantity locked from the resource. The measurement unit is specified in Prd_Resources.
Resource_Id uniqueidentifier A resource that will be utilized for this routing step
Row_Version timestamp
Work_Order_Item_Operation_Id uniqueidentifier The work order item operation, containing the line.
Workgroup_Resource_Id uniqueidentifier The workgroup resource that is used for the operation

Columns

Function_Id

Specifies the function, that the resource must be able to perform. This helps the selection of specific resource for the operation. This column is used as search/selection criteria. NULL means that the user must select the resource through all resources

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
Referenced Table Prd_Functions
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

Function_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes 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 yes

Id - Supported Filters

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

Line_Ord

The order of the line within the item.

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 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 Medium
User Login no
Visible yes

Locked_Quantity

The quantity locked from the resource. The measurement unit is specified in Prd_Resources.

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 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(18, 3)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Resource_Id

A resource that will be utilized for this routing step

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
Referenced Table Prd_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

Resource_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

Work_Order_Item_Operation_Id

The work order item operation, 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_Item_Operations
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

Work_Order_Item_Operation_Id - Supported Filters

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

Workgroup_Resource_Id

The workgroup resource that is used 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 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
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
Suggest improvement to this page