Table of Contents

Table Prd_Recipes

Entity

Entity: Production.Technologies.Recipes

Contains the characteristics of operations used to create products. Entity: Prd_Recipes

Summary

Name Type Description
Creation_Time datetime Readonly
Creation_User nvarchar(64) Readonly
Currency_Directory_Id uniqueidentifier Currency directory, which is used to convert the costs and prices of materials, operations and resources into the currency of the product.
Expiry_Date datetime The last date, when the recipe should be used. NULL means that the recipe might still be in use
Id uniqueidentifier PK Unique recipe Id
Is_Default bit Default for period: Release_Date - Expiry_Date
Notes nvarchar(254) User comments for the recipe
Price decimal(18, 4) The price for the specified Produce_Quantity
Price_Per_Lot decimal(18, 4) Price for one lot of the product (according to Lot_Size_Quantity_Base)
Principal_Recipe_Id uniqueidentifier The prinicipal recipe, used to create this recipe. NULL means that this recipe was created without the help of principal recipe
Produce_Quantity decimal(18, 3) Lot size. This is the produced quantity in one production run. The quantity is measured in the primary unit of Product_Id
Product_Id uniqueidentifier The Id of the produced product
Recipe_Name nvarchar(64) The name of the recipe. When there is only 1 recipe, it is often equal to the product name. However, when there are multiple recipes for one product, the name is used for diferentiation.
Release_Date datetime The date, when the recipe was released to production
Routing_Id uniqueidentifier The routing used to create the product. NULL means that workorders might not use routing.
Row_Version timestamp
Scrap_Rate decimal(7, 6) The percentage (0..1) of scrap usually occurring during the operation. Specifying this leads to inflated requirements of all raw materials for this recipe
Store_Id uniqueidentifier The store for which this technology is valid. The store is matched with the output store specified in the production order. When NULL, the technology is valid for all stores.
Update_Time datetime Readonly
Update_User nvarchar(64) Readonly

Columns

Creation_Time

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

Creation_Time - Supported Filters

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

Creation_User

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

Creation_User - Supported Filters

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

Currency_Directory_Id

Currency directory, which is used to convert the costs and prices of materials, operations and resources into the currency of the 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 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Gen_Currency_Directories
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

Currency_Directory_Id - Supported Filters

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

Expiry_Date

The last date, when the recipe should be used. NULL means that the recipe might still be in use

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

Expiry_Date - Supported Filters

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

Id

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

Is_Default

Default for period: Release_Date - Expiry_Date

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

Is_Default - Supported Filters

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

Notes

User comments for the recipe

Property Value
Attributes IsLongString
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

Price

The price for the specified Produce_Quantity

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

Price_Per_Lot

Price for one lot of the product (according to Lot_Size_Quantity_Base)

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

Principal_Recipe_Id

The prinicipal recipe, used to create this recipe. NULL means that this recipe was created without the help of 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 no
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 (Allows NULL)
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Principal_Recipe_Id - Supported Filters

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

Produce_Quantity

Lot size. This is the produced quantity in one production run. The quantity is measured in the primary unit of Product_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 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 100
User Login no
Visible yes

Product_Id

The Id of the 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 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 100
User Login no
Visible yes

Product_Id - Supported Filters

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

Recipe_Name

The name of the recipe. When there is only 1 recipe, it is often equal to the product name. However, when there are multiple recipes for one product, the name is used for diferentiation.

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 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 nvarchar(64)
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Recipe_Name - Supported Filters

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

Release_Date

The date, when the recipe was released to production

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

Release_Date - Supported Filters

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

Routing_Id

The routing used to create the product. NULL means that workorders might not use routing.

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

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 operation. Specifying this leads to inflated requirements of all raw materials 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 100
User Login no
Visible yes

Store_Id

The store for which this technology is valid. The store is matched with the output store specified in the production order. When NULL, the technology is valid for all stores.

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

Store_Id - Supported Filters

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

Update_Time

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

Update_Time - Supported Filters

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

Update_User

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

Update_User - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Like None no yes
Suggest improvement to this page