Table Prd_Work_Order_Items

Entity

Entity: Production.ShopFloor.WorkOrderItems

The different items that are produced with a work order. Entity: Prd_Work_Order_Items

Owner Tables Hierarchy

Summary

Name	Type	Description
Completion_Date	`datetime`	The date, when the item should be completed. NULL means that there is no constraint for completion date
Id	`uniqueidentifier` `PK`
Line_Ord	`int`	The order of the line within the work order.
Lot_Id	`uniqueidentifier`	The lot of the produced product.
Lot_Size	`decimal(18, 3)`	Quantity produced in one production run
Notes	`nvarchar(max)`
Output_Store_Id	`uniqueidentifier`	Output store for the production
Parent_Document_Id	`uniqueidentifier`	The document, which the current line executes. NULL when the current line does not execute another line.
Parent_Line_Id	`uniqueidentifier`	If not NULL contains the Id of the line of the parent document, that created the current row
Parent_Line_No	`int`	The number of the line within the parent document, which the current line executes. NULL when the current line does not execute another line.
Priority	`smallint` Allowed: `1`, `2`, `3`, `4`, `5`	Priority of the production of the item. Initially inherits the priority of the work order. 1=Lowest ... 5=Highest
Produced_Quantity	`decimal(18, 3)`	The quantity produced in the operation
Produced_Quantity_Base	`decimal(18, 3)` Readonly	The equivalence of Produced Quantity in the base measurement category of the product.
Produced_Quantity_Unit_Id	`uniqueidentifier`	The measurement unit of the quantity produced in the operation
Produced_Standard_Quantity_Base	`decimal(18, 3)` Readonly	The theoretical quantity in base measurement unit according to the current measurement dimensions of the product. Used to measure the execution. NULL means to take the value from Produced Quantity Base.
Product_Code_Id	`uniqueidentifier`	Selects the product thru some of the product codes.
Product_Id	`uniqueidentifier`	The Id of the produced product.
Recipe_Id	`uniqueidentifier`	The base recipe. NULL means that the item is produced without recipe.
Release_Date	`datetime`	The date, when the item is released to production. NULL means that still there is no plan when the item will be released to production
Row_Version	`timestamp`
Scheduled_End_Date_Time	`datetime`	Date and time when the production of this item is scheduled to end
Scheduled_Start_Date_Time	`datetime`	Date and time when the production of this item is scheduled to begin
Serial_Number_Id	`uniqueidentifier`	If not NULL, specifies that the product was (has to be) produced with specific serial number
Store_Bin_Id	`uniqueidentifier`	The store bin in which to store the products
Work_Order_Id	`uniqueidentifier`	The Id of the work order, containing the item

Columns

Completion_Date

The date, when the item should be completed. NULL means that there is no constraint for completion date

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	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	datetime (Allows NULL)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	no

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

The order of the line within the work order.

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

Lot_Id

The lot of the produced product.

Property	Value
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	16
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Inv_Lots
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

Lot_Id - Supported Filters

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

Lot_Size

Quantity produced in one production run

Property	Value
Auto Complete	no
Data Filter	no
Default Value	1
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(18, 3)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Notes

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	2147483647
Order	21
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	no

Output_Store_Id

Output store for the production

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

Output_Store_Id - Supported Filters

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

Parent_Document_Id

The document, which the current line executes. NULL when the current line does not execute another 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	19
Ownership Reference	no
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 (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Parent_Document_Id - Supported Filters

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

Parent_Line_Id

If not NULL contains the Id of the line of the parent document, that created the current row

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

Parent_Line_Id - Supported Filters

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

Parent_Line_No

The number of the line within the parent document, which the current line executes. NULL when the current line does not execute another 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	20
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	Medium
User Login	no
Visible	no

Parent_Line_No - Supported Filters

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

Priority

Priority of the production of the item. Initially inherits the priority of the work order. 1=Lowest ... 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	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	smallint
UI Memo Editor	no
UI Width	100
User Login	no
Visible	no

Produced_Quantity

The quantity produced in 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	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	decimal(18, 3)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Produced_Quantity_Base

The equivalence of Produced Quantity in the base measurement category of the product.

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

Produced_Quantity_Unit_Id

The measurement unit of the quantity produced in the operation

Property	Value
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	3
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Measurement_Units
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Short
User Login	no
Visible	yes

Produced_Quantity_Unit_Id - Supported Filters

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

Produced_Standard_Quantity_Base

The theoretical quantity in base measurement unit according to the current measurement dimensions of the product. Used to measure the execution. NULL means to take the value from Produced Quantity Base.

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	24
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	yes
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	no

Product_Code_Id

Selects the product thru some of the product codes.

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	18
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Product_Codes
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

Product_Code_Id - Supported Filters

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

Product_Id

The Id of the produced product.

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

Product_Id - Supported Filters

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

Recipe_Id

The base recipe. NULL means that the item is produced without recipe.

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	4
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Prd_Recipes
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

Recipe_Id - Supported Filters

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

Release_Date

The date, when the item is released to production. NULL means that still there is no plan when the item will be released to production

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	datetime (Allows NULL)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	no

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

Scheduled_End_Date_Time

Date and time when the production of this item is scheduled to end

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	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	datetime (Allows NULL)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	no

Scheduled_End_Date_Time - Supported Filters

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

Scheduled_Start_Date_Time

Date and time when the production of this item is scheduled to begin

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

Scheduled_Start_Date_Time - Supported Filters

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

Serial_Number_Id

If not NULL, specifies that the product was (has to be) produced with specific serial number

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	17
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Inv_Serial_Numbers
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

Serial_Number_Id - Supported Filters

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

Store_Bin_Id

The store bin in which to store the 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	23
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Inv_Store_Bins
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

Store_Bin_Id - Supported Filters

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

Work_Order_Id

The Id of the work order, containing the item

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	8
Ownership Reference	yes
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Prd_Work_Orders
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_Id - Supported Filters

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

Table of Contents