Entity Definition

Logical Name : RecipeLineItem
Physical Name : ST_LTM_RCP

A single ingredient in a Recipe

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RecipeID (FK)(PK) A system assigned unique identifier for the recipe ID_RCPE Identity integer Recipe(ST_RCP)
ComponentID (FK)(PK) A unique system assigned identifier for the RawMaterialComponent that goes into the Recipe ID_COM Identity integer RawMaterialComponent(CO_COM_RAW_MTR)
ServingsCount The number of servings of a component that make up the Ingredient. QU_CNT_SRV QuantityShortCount decimal(3,0)
CostInclusiveFlag A flag denoting if the cost of the ingredient is (or is not) included in the cost of the completed PreparedItem FL_CST_INC Flag integer
WasteFlag A flag denoting if the recipe ingredient is wasted when the PreparedItem is discarded. e.g. When a piece of cake is discarded the whipped cream & spoon that are included with the cake when it is sold, are not discarded FL_WST Flag integer
KeyIngredientFlag A flag denoting that the ingredient is required to make up the PreparedItem. e.g. Patties are key ingredients in a burger, but pickles are not. FL_IGDT_KY Flag integer


Parent Entity Verb Phrase Child Entity
RawMaterialComponent is used in RecipeLineItem
Recipe assembles RecipeLineItem

Logical Views containing RecipeLineItem

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