Table of Contents

Table Prd_Work_Order_Item_Ingredients

Entity

Entity: Production.ShopFloor.WorkOrderItemIngredients

The materials consumed in the production order operations. Entity: Prd_Work_Order_Item_Ingredients

Owner Tables Hierarchy

Summary

Name Type Description
Distribute_By nvarchar(2) Allowed: SP, MC, SC Distribution method in case the materials from the line are distributed amongst all work order items. Should be NOT NULL iif Work_Order_Item_Id is NULL. MC=Measurement, SP=Standard_Price
Distribute_By_Measurement_Category_Id uniqueidentifier Measurement category by which the materials from the line are distributed amongst all work order items in case Distribute_By = MC. Should be NOT NULL iif Distribute_By = MC.
Fixed_Scrap_Quantity decimal(18, 3) The quantity of the material, which will be used for setup.
Id uniqueidentifier PK The Id of the production order operation
Line_Ord int The order of the line within the item.
Lot_Id uniqueidentifier Lot from which to get the material. When NULL, any lot can be used.
Material_Id uniqueidentifier The Id of the consumed material (Gen_Products_Table)
Notes nvarchar(254)
Operation_Id uniqueidentifier Specifies for which operation this ingredient is used
Principal_Recipe_Ingredient_Id uniqueidentifier The principal recipe ingredient on which this record is based.
Product_Code_Id uniqueidentifier Selects the product thru some of the product codes.
Row_Version timestamp
Serial_Number_Id uniqueidentifier If not NULL, specifies the serial number of the ingredient
Store_Bin_Id uniqueidentifier The store bin from which to take the ingredients
Store_Id uniqueidentifier The store from which to retrieve the material.
Used_Quantity decimal(18, 3) The quantity of the material consumed in the operation
Used_Quantity_Base decimal(18, 3) Readonly The equivalence of Used Quantity in the base measurement category of the material.
Used_Quantity_Unit_Id uniqueidentifier The measurement unit of the quantity of the material consumed in the operation
Used_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 Used Quantity Base.
Work_Order_Id uniqueidentifier
Work_Order_Item_Id uniqueidentifier The work order item for which the materials in this line are used. If NULL means that the materials are distributed amongst all work order items in the document.

Columns

Distribute_By

Distribution method in case the materials from the line are distributed amongst all work order items. Should be NOT NULL iif Work_Order_Item_Id is NULL. MC=Measurement, SP=Standard_Price

Property Value
Allowed Values SP, MC, SC
Auto Complete no
Data Filter no
Default Value None
Enter Stop no
Ignore for Insert Order no
Is Entity Name no
Max Length 2
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(2) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Distribute_By_Measurement_Category_Id

Measurement category by which the materials from the line are distributed amongst all work order items in case Distribute_By = MC. Should be NOT NULL iif Distribute_By = MC.

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

Distribute_By_Measurement_Category_Id - Supported Filters

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

Fixed_Scrap_Quantity

The quantity of the material, which will be used for setup.

Property Value
Auto Complete no
Data Filter no
Default Value 0
Enter Stop no
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

Id

The Id of the production order operation

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

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

Lot from which to get the material. When NULL, any lot can be used.

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

Material_Id

The Id of the consumed material (Gen_Products_Table)

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

Material_Id - Supported Filters

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

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

Operation_Id

Specifies for which operation this ingredient is used

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

Operation_Id - Supported Filters

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

Principal_Recipe_Ingredient_Id

The principal recipe ingredient on which this record is based.

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

Principal_Recipe_Ingredient_Id - Supported Filters

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

Product_Code_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

Serial_Number_Id

If not NULL, specifies the serial number of the ingredient

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

Serial_Number_Id - Supported Filters

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

Store_Bin_Id

The store bin from which to take 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_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 yes

Store_Bin_Id - Supported Filters

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

Store_Id

The store from which to retrieve the material.

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

Store_Id - Supported Filters

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

Used_Quantity

The quantity of the material consumed 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 3
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

Used_Quantity_Base

The equivalence of Used Quantity in the base measurement category of the material.

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

Used_Quantity_Unit_Id

The measurement unit of the quantity of the material consumed 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 4
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 Medium
User Login no
Visible yes

Used_Quantity_Unit_Id - Supported Filters

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

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

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

Work_Order_Id - Supported Filters

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

Work_Order_Item_Id

The work order item for which the materials in this line are used. If NULL means that the materials are distributed amongst all work order items in the document.

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

Work_Order_Item_Id - Supported Filters

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