Table Prd_Principal_Recipe_Ingredients
Entity
Entity: Production.Technologies.PrincipalRecipeIngredients
Template for material usage of a principal recipe. Entity: Prd_Principal_Recipe_Ingredients
Owner Tables Hierarchy
Summary
| Name |
Type |
Description |
| Conditional_Property_Allowed_Value_Id |
uniqueidentifier |
When not NULL, specifies that, when creating recipe, the ingredient will be added only if the main product property, specified in Conditional_Property_Id equals the specified value |
| Conditional_Property_Description |
nvarchar(254) ML |
The desired description of Conditional Property in order for the template line to match. |
| Conditional_Property_Id |
uniqueidentifier |
When not NULL, specifies that, when creating recipe, the ingredient will be added only if this property is set for the main product |
| Conditional_Property_Value |
nvarchar(254) |
The desired value of Conditional Property in order for the template line to match. |
| Default_Material_Id |
uniqueidentifier |
If not NULL, points to default product for this ingredient |
| Default_Store_Id |
uniqueidentifier |
The default store from which to retrieve the material. |
| Fixed_Scrap_Quantity |
decimal(18, 3) |
Fixed scrap quantity for setup |
| Id |
uniqueidentifier PK |
The Id of the recipe ingredient. This changes for each different line of each different recipe in contrast to the ingredient id, which might be the same for many principal recipes |
| Ingredient_Id |
uniqueidentifier |
The Id of the ingredient. When copying principal recipes, this Id remains the same for the new principal recipe to provide upgrade path for old recipes. |
| Ingredient_Name |
nvarchar(254) |
The principal name of the ingredient. |
| Line_Ord |
int |
The position of the line in the recipe model |
| Material_From_Property_Id |
uniqueidentifier |
When not NULL, specifies that the material will be obtained from the value of the specified property. The property must have allowed values in the Products domain. |
| Material_Group_Id |
uniqueidentifier |
Filter for choosing specific material in the recipe (Gen_Product_Groups_Table) |
| Operation_Id |
uniqueidentifier |
Specifies for which operation this ingredient will be used |
| Principal_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. |
| Usage_Quantity |
decimal(18, 6) |
Quantity to be consumed from the material. NULL means that the quantity is specified with formula |
| Usage_Quantity_Formula |
nvarchar(max) |
Specifies formula for the usage quantity. The formula can reference properties in [<Prop_Name>] style, just like products name and description mask. The formula can contain *, /, + and - operators. The formula can also be simple number, directly specifying quantity |
| Usage_Unit_Id |
uniqueidentifier |
The measurement unit of Usage_Quantity. The selected item must support the specified unit |
Columns
Conditional_Property_Allowed_Value_Id
When not NULL, specifies that, when creating recipe, the ingredient will be added only if the main product property, specified in Conditional_Property_Id equals the specified value
| 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_Property_Allowed_Values |
| 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 |
Conditional_Property_Allowed_Value_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
no |
Conditional_Property_Description
The desired description of Conditional Property in order for the template line to match.
| 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 |
254 |
| 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(254) (MultiLanguage) (Allows NULL) |
| UI Memo Editor |
no |
| UI Width |
100 |
| User Login |
no |
| Visible |
yes |
Conditional_Property_Id
When not NULL, specifies that, when creating recipe, the ingredient will be added only if this property is set for the main 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 |
2147483647 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| Referenced Table |
Gen_Properties |
| 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 |
Conditional_Property_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
no |
Conditional_Property_Value
The desired value of Conditional Property in order for the template line to match.
| 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 |
254 |
| 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(254) (Allows NULL) |
| UI Memo Editor |
no |
| UI Width |
100 |
| User Login |
no |
| Visible |
yes |
Default_Material_Id
If not NULL, points to default product for this ingredient
| 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_Products |
| 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 |
Default_Material_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
no |
Default_Store_Id
The default 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 |
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 |
Medium |
| User Login |
no |
| Visible |
yes |
Default_Store_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
no |
Fixed_Scrap_Quantity
Fixed scrap quantity 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 recipe ingredient. This changes for each different line of each different recipe in contrast to the ingredient id, which might be the same for many principal recipes
| 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 |
Ingredient_Id
The Id of the ingredient. When copying principal recipes, this Id remains the same for the new principal recipe to provide upgrade path for old recipes.
| 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 |
no |
| 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 |
Ingredient_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
no |
Ingredient_Name
The principal name 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 |
254 |
| 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(254) |
| UI Memo Editor |
no |
| UI Width |
Long |
| User Login |
no |
| Visible |
yes |
Ingredient_Name - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Like |
None |
no |
no |
Line_Ord
The position of the line in the recipe model
| 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 |
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 |
int |
| UI Memo Editor |
no |
| UI Width |
100 |
| User Login |
no |
| Visible |
yes |
Material_From_Property_Id
When not NULL, specifies that the material will be obtained from the value of the specified property. The property must have allowed values in the Products domain.
| 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_Properties |
| 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 |
Material_From_Property_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
no |
Material_Group_Id
Filter for choosing specific material in the recipe (Gen_Product_Groups_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 |
2147483647 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| Referenced Table |
Gen_Product_Groups |
| 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 |
Material_Group_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
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 |
Principal_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_Principal_Recipes |
| 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 |
Principal_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 |
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(7, 6) |
| UI Memo Editor |
no |
| UI Width |
Short |
| User Login |
no |
| Visible |
yes |
Scrap_Rate - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| GreaterThanOrLessThan |
None |
yes |
no |
Usage_Quantity
Quantity to be consumed from the material. NULL means that the quantity is specified with formula
| 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 |
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, 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 |
Specifies formula for the usage quantity. The formula can reference properties in [<Prop_Name>] style, just like products name and description mask. The formula can contain *, /, + and - operators. The formula can also be simple number, directly specifying 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 |
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 |
yes |
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 |
2147483647 |
| 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 |