Table of Contents

Table Prd_Principal_Recipes

Entity

Entity: Production.Technologies.PrincipalRecipes

List of base recipe models. Recipe models are used by the Product Configurator to create specific recipes. Entity: Prd_Principal_Recipes

Owner Tables Hierarchy

Summary

Name Type Description
Duration_Hour decimal(10, 0) The approximate duration of the operation (for the specified quantities) in seconds. This is pure operation time and excludes setup time.
Expiry_Date datetime The last date, when the recipe should be used. NULL means that there is no expiry date yet and the recipe model is still active.
Id uniqueidentifier PK The principal recipe unique id
Notes nvarchar(254) User comments for the principal recipe.
Principal_Recipe_Name nvarchar(64) Name of the principal recipe
Produce_Quantity decimal(18, 3) Suggested quantity to produce. Usually it is equal to 1
Produce_Unit_Id uniqueidentifier The measurement unit of Produce_Quantity. The selected item must support the specified unit
Product_Group_Id uniqueidentifier The production group, whose production is defined by the principal recipe
Release_Date datetime The date, when the recipe model is released for use
Routing_Id uniqueidentifier The routing to be used for the recipes. NULL means that the workorders will not use routing
Row_Version timestamp
Scrap_Rate decimal(7, 6) The percentage (0..1) of scrap usually occurring during the production operations. Specifying this leads to inflated requirements of all raw materials for the recipe.

Columns

Duration_Hour

The approximate duration of the operation (for the specified quantities) in seconds. This is pure operation time and excludes setup time.

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 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(10, 0)
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Expiry_Date

The last date, when the recipe should be used. NULL means that there is no expiry date yet and the recipe model is still active.

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

Expiry_Date - Supported Filters

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

Id

The principal recipe unique 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

Notes

User comments for the principal recipe.

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

Principal_Recipe_Name

Name of the principal 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 64
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(64)
UI Memo Editor no
UI Width Long
User Login no
Visible yes

Principal_Recipe_Name - Supported Filters

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

Produce_Quantity

Suggested quantity to produce. Usually it is equal to 1

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

Produce_Quantity - Supported Filters

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

Produce_Unit_Id

The measurement unit of Produce_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

Produce_Unit_Id - Supported Filters

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

Product_Group_Id

The production group, whose production is defined by the principal 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 2147483647
Ownership Reference yes
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 Long
User Login no
Visible yes

Product_Group_Id - Supported Filters

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

Release_Date

The date, when the recipe model is released for use

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

Release_Date - Supported Filters

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

Routing_Id

The routing to be used for the recipes. NULL means that the workorders will not use routing

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

Routing_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

Scrap_Rate

The percentage (0..1) of scrap usually occurring during the production operations. Specifying this leads to inflated requirements of all raw materials for the recipe.

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