Entity Definition

Logical Name : Recipe
Physical Name : ST_RCP

The Recipe or Bill of Materials that is used to assemble a PreparedItem from other (usually Bulk) Items. A recursive relationship "variations produce" allows recipe variations to be recorded.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RecipeID (PK) A system assigned unique identifier for the recipe ID_RCPE Identity integer
ItemID (FK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) PreparedItem(AS_ITM_PPR)
RecipeVariationOf (FK) A system assigned unique identifier for the recipe which this recipe is a variation of CD_VRT Identity integer Recipe(ST_RCP)
LastChangeDate The date the recipe was last changed. DC_CHN_LS DateCalendar date
CreateDate The date the recipe was created DC_CRT DateCalendar date
StatusCode The status of the recipe, possible values include Active, Inactive, Testing SC_RCPE Code2 char(2)
Description A short narrative description describing the recipe. When the recipe is a variant of another recipe, the description includes a description of the variation. DE_RCPE DescriptionNarrative varchar(4000)


Parent Entity Verb Phrase Child Entity
PreparedItem is assembled via Recipe
Recipe variations produce Recipe
Recipe variations produce Recipe
Recipe is used at BusinessUnitGroupRecipe
Recipe assembles RecipeLineItem

Logical Views containing Recipe

Logical View
Logical 01010 - Item Description - Subtype View
Logical 01030 - Item Description - Recipe View