Table of Contents

Table Prd_Recipe_Ingredients

Entity

Entity: Production.Technologies.RecipeIngredients

Contains the materials of a recipe that make up the product. Entity: Prd_Recipe_Ingredients

Owner Tables Hierarchy

Summary

Name Type Description
Cost decimal(18, 4) The cost of the specified quantity of the ingredient
Fixed_Scrap_Quantity decimal(18, 3) Fixed scrap quantity of the material, needed for setup.
Id uniqueidentifier PK
Line_Ord int The order of this line in the recipe.
Material_Id uniqueidentifier The Id of the consumed material (Gen_Products_Table)
Notes nvarchar(254)
Operation_Id uniqueidentifier Specifies for which operation this ingredient will be used
Price decimal(18, 4) Total price of the ingredient
Principal_Recipe_Ingredient_Id uniqueidentifier The principal recipe ingredient which was used to create this recipe ingredient. NULL means that this ingredient is standalone, not created with principal recipe ingredient
Recipe_Id uniqueidentifier
Row_Version timestamp
Scrap_Rate decimal(7, 6) The usual percentage (0..1) of scrap of the raw material; inflates the requirements of this material for this recipe
Store_Id uniqueidentifier The store from which to retrieve the material.
Unit_Cost decimal(18, 6) Cost of 1 of Usage_Unit_Id
Unit_Price decimal(18, 6) Price for 1 of Usage_Unit_Id
Usage_Quantity decimal(18, 6) Quantity of the material, consumed in the operation. The measurement unit is the primary unit of Material_Item_Id.
Usage_Unit_Id uniqueidentifier The measurement unit of Usage_Quantity. The selected item must support the specified unit

Columns

Cost

The cost of the specified quantity of the ingredient

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 8
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, 4)
UI Memo Editor no
UI Width Short
User Login no
Visible yes

Cost - Supported Filters

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

Fixed_Scrap_Quantity

Fixed scrap quantity of the material, needed 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

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 this line in the recipe.

Property Value
Auto Complete no
Autoincrement 1
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
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

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

Material_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no 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 254
Order 11
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 will 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 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

Price

Total price of the ingredient

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

Price - Supported Filters

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

Principal_Recipe_Ingredient_Id

The principal recipe ingredient which was used to create this recipe ingredient. NULL means that this ingredient is standalone, not created with principal recipe 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 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 no

Principal_Recipe_Ingredient_Id - Supported Filters

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

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

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

Scrap_Rate

The usual percentage (0..1) of scrap of the raw material; inflates the requirements of this material for this recipe

Property Value
Attributes IsPercent
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 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(7, 6)
UI Memo Editor no
UI Width Short
User Login no
Visible yes

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

Store_Id - Supported Filters

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

Unit_Cost

Cost of 1 of Usage_Unit_Id

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 7
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, 6)
UI Memo Editor no
UI Width Short
User Login no
Visible yes

Unit_Cost - Supported Filters

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

Unit_Price

Price for 1 of Usage_Unit_Id

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

Unit_Price - Supported Filters

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

Usage_Quantity

Quantity of the material, consumed in the operation. The measurement unit is the primary unit of Material_Item_Id.

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, 6) (Allows NULL)
UI Memo Editor no
UI Width Short
User Login no
Visible yes

Usage_Quantity - Supported Filters

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

Usage_Unit_Id

The measurement unit of Usage_Quantity. The selected item must support the specified unit

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

Usage_Unit_Id - Supported Filters

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