Table of Contents

Table Prd_Work_Orders

Entity

Entity: Production.ShopFloor.WorkOrders

Scheduled and released production orders. Each order can contain the production of many items. Entity: Prd_Work_Orders

Owner Tables Hierarchy

Summary

Name Type Description
Completion_Date datetime Scheduled date of completion. Specifies the date when the workorder was completed. NULL means that the order is not yet completed.
Default_Materials_Store_Id uniqueidentifier Default materials store for the ingredients
Default_Output_Store_Id uniqueidentifier Default output store for the finished products
Document_Id uniqueidentifier Document Id for the released production orders. NULL for orders that are not yet released
Due_Date datetime The final due date, when the production should be ready.
Duration_Hour decimal(10, 0) The duration of all operations in the protocol either planned (for planned orders) or actual (for completed orders)
Id uniqueidentifier PK
Is_Released bit Readonly True if the document is not void and its state is released or greater. Deprecated
Is_Single_Execution bit Readonly Specifies whether the document is a single execution of its order document.
Notes nvarchar(max) User notes for the production order
Priority smallint Allowed: 1, 2, 3, 4, 5 Priority of the work order. Higher priority orders might seize resources from lower priority orders. 1=Lowest priority ... 5=Highest
Release_Date datetime Scheduled release date. Specifies the date when the order is planned/released to production. NULL means that still there is no plan for releasing the order.
Row_Version timestamp
Workgroup_Id uniqueidentifier The workgroup which performs the operations

Columns

Completion_Date

Scheduled date of completion. Specifies the date when the workorder was completed. NULL means that the order is not yet 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

Completion_Date - Supported Filters

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

Default_Materials_Store_Id

Default materials store for the ingredients

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 Inv_Stores
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

Default_Materials_Store_Id - Supported Filters

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

Default_Output_Store_Id

Default output store for the finished products

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 Inv_Stores
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

Default_Output_Store_Id - Supported Filters

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

Document_Id

Document Id for the released production orders. NULL for orders that are not yet released

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 Gen_Documents
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

Document_Id - Supported Filters

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

Due_Date

The final due date, when the production should be ready.

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

Due_Date - Supported Filters

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

Duration_Hour

The duration of all operations in the protocol either planned (for planned orders) or actual (for completed orders)

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(10, 0)
UI Memo Editor no
UI Width 100
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 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

Is_Released

True if the document is not void and its state is released or greater. Deprecated

Property Value
Auto Complete no
Data Filter no
Default Value False
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 yes
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type bit
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Is_Released - Supported Filters

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

Is_Single_Execution

Specifies whether the document is a single execution of its order document.

Property Value
Auto Complete no
Data Filter no
Default Value False
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 yes
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type bit
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Is_Single_Execution - Supported Filters

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

Notes

User notes for the production order

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 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 no

Priority

Priority of the work order. Higher priority orders might seize resources from lower priority orders. 1=Lowest priority ... 5=Highest

Property Value
Allowed Values 1, 2, 3, 4, 5
Auto Complete no
Data Filter no
Default Value 3
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 smallint
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Priority - Supported Filters

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

Release_Date

Scheduled release date. Specifies the date when the order is planned/released to production. NULL means that still there is no plan for releasing the order.

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

Release_Date - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan 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 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

Workgroup_Id

The workgroup which performs the operations

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_Workgroups
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

Workgroup_Id - Supported Filters

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