Table Prd_Output_Order_Lines

Entity

Entity: Production.ShopFloor.OutputOrderLines

Detail records of output orders. Entity: Prd_Output_Order_Lines

Owner Tables Hierarchy

Summary

Name	Type	Description
Begin_Date_Time	`datetime`	Not used.
End_Time	`datetime`	Date and time when the operation has ended
Finished	`bit`	1 if this output entry completes the operation. 0 if there might be more entries
Id	`uniqueidentifier` `PK`
Line_Ord	`int`	Line number within the order
Line_Work_Order_Id	`uniqueidentifier`	The work order for which work is being accounted
Lot_Id	`uniqueidentifier`	The lot of the produced product.
Notes	`nvarchar(max)`
Output_Order_Id	`uniqueidentifier`
Produced_Quantity	`decimal(18, 3)`	The processed quantity of the end product.
Produced_Quantity_Base	`decimal(18, 3)` Readonly	The equivalence of Produced Quantity in the base measurement unit of the product.
Produced_Quantity_Unit_Id	`uniqueidentifier`	The measurement unit of Produced Quantity.
Produced_Standard_Quantity_Base	`decimal(18, 3)` Readonly	The theoretical quantity in base measurement unit according to the current measurement dimensions for the product. Used to measure the execution. NULL means to convert the value from Quantity using the measurement ratios.
Product_Code_Id	`uniqueidentifier`	Selects the product thru some of the product codes.
Product_Id	`uniqueidentifier`	The actually produced product
Row_Version	`timestamp`
Serial_Number_Id	`uniqueidentifier`	If not NULL, specifies that the product was (has to be) stored with specific serial number
Start_Time	`datetime`	Date and time when the operation has began
Store_Bin_Id	`uniqueidentifier`	If not NULL, specifies that the product was (has to be) stored to specific store bin
Store_Id	`uniqueidentifier`	Where to output the produced quantity. Can be NULL only if Produced_Quantity = 0
Transaction_Timestamp	`datetime` Readonly	Sets the timestamp of the receipt store operations for this output order line. Used in completing output orders.
Work_Done_By_Party_Id	`uniqueidentifier`	The party (usually employee worker) who has accomplished the work. NULL if unknown or N/A
Work_Order_Item_Id	`uniqueidentifier`	The work order item for which this output is recorded.
Work_Order_Item_Operation_Id	`uniqueidentifier`	The operation for which this output is recorded.
Workgroup_Resource_Id	`uniqueidentifier`	The resource, which was used to perform the operation.

Columns

Begin_Date_Time

Not used.

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

Begin_Date_Time - Supported Filters

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

End_Time

Date and time when the operation has ended

Property	Value
Auto Complete	no
Data Filter	no
Default Value	CurrentDateTime
Enter Stop	yes
Format	g
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	datetime
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

End_Time - Supported Filters

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

Finished

1 if this output entry completes the operation. 0 if there might be more entries

Property	Value
Auto Complete	no
Data Filter	no
Default Value	False
Enter Stop	no
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	bit
UI Memo Editor	no
UI Width	Short
User Login	no
Visible	no

Finished - Supported Filters

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

Line number within the order

Property	Value
Auto Complete	no
Autoincrement	10
Data Filter	no
Default Value	None
Enter Stop	no
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_Work_Order_Id

The work order for which work is being accounted

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	7
Ownership Reference	no
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	Short
User Login	no
Visible	no

Line_Work_Order_Id - Supported Filters

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

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

Notes

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

Output_Order_Id

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	6
Ownership Reference	yes
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Prd_Output_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

Output_Order_Id - Supported Filters

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

Produced_Quantity

The processed quantity of the end product.

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

Produced_Quantity - Supported Filters

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

Produced_Quantity_Base

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

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	4
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	Short
User Login	no
Visible	no

Produced_Quantity_Unit_Id

The measurement unit of Produced Quantity.

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	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 for the product. Used to measure the execution. NULL means to convert the value from Quantity using the measurement ratios.

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

Product_Id - Supported Filters

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

Serial_Number_Id

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

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

Start_Time

Date and time when the operation has began

Property	Value
Auto Complete	no
Data Filter	no
Default Value	CurrentDateTime
Enter Stop	yes
Format	g
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	datetime
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Start_Time - Supported Filters

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

Store_Bin_Id

If not NULL, specifies that the product was (has to be) stored to specific store bin

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

Store_Id

Where to output the produced quantity. Can be NULL only if Produced_Quantity = 0

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

Store_Id - Supported Filters

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

Transaction_Timestamp

Sets the timestamp of the receipt store operations for this output order line. Used in completing output orders.

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	yes
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	datetime (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Transaction_Timestamp - Supported Filters

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

Work_Done_By_Party_Id

The party (usually employee worker) who has accomplished the work. NULL if unknown or N/A

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

Work_Done_By_Party_Id - Supported Filters

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

Work_Order_Item_Id

The work order item for which this output is recorded.

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

Work_Order_Item_Id - Supported Filters

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

Work_Order_Item_Operation_Id

The operation for which this output is recorded.

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
Referenced Table	Prd_Work_Order_Item_Operations
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier (Allows NULL)
UI Memo Editor	no
UI Width	Short
User Login	no
Visible	no

Work_Order_Item_Operation_Id - Supported Filters

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

Workgroup_Resource_Id

The resource, which was used to perform 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	19
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	no

Workgroup_Resource_Id - Supported Filters

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

Table of Contents