Entity Definition

Logical Name : RawMaterialComponent
Physical Name : CO_COM_RAW_MTR

An abstract standardized Recipe ingredient that is re-used in many recipes. Used to define a common quantity & UnitOfMeasure for the Ingredient. Eg: "5oz Tomato Ketchup" which may be used once in a small hamburger and twice or three times in a large hamburger, and BBQ sauce is an acceptable substitute.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ComponentID (PK) A unique system assigned identifier for the RawMaterialComponent ID_COM Identity integer
ItemID (FK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) Item(AS_ITM)
UnitOfMeasureCode (FK) The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. CD_UOM Code varchar(20) UnitOfMeasure(CO_UOM)
UnitQuantity The quantity of the RawItem that make up a single serving of the RawMaterialComponent QU_UN_AMT QuantityShortCount decimal(3,0)
Description A short description denoting what the ingredient is. Eg: 5oz Ketchup/BBQ DE_COM DescriptionShort varchar(255)


Parent Entity Verb Phrase Child Entity
Item is primarily RawMaterialComponent
UnitOfMeasure defines RawMaterialComponent
RawMaterialComponent is used in RecipeLineItem
RawMaterialComponent may be substituted with RawMaterialComponentItem

Logical Views containing RawMaterialComponent

Logical View
Logical 01030 - Item Description - Recipe View
Logical 21000 - Fresh Item Management Macro View