Entity Definition

Logical Name : BusinessUnitGroupRecipe
Physical Name : CO_BSNGP_RCP

An associative entity denoting which Recipes for a particular PreparedItem are valid in a particular BusinessUnitGroup. Eg: A recipe variation for a hamburger may call for the use of a patty made from Lamb rather than Beef. RetailStores in areas with a high Hindu population may have this recipe variation.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
BusinessUnitGroupID (FK)(PK) A unique system assigned identifier for a group of BusinessUnits. ID_BSNGP Identity integer BusinessUnitGroup(CO_BSNGP)
RecipeID (FK)(PK) A system assigned unique identifier for the Recipe that the RetailStoreGroup uses. ID_RCPE Identity integer Recipe(ST_RCP)
EffectiveDate (PK) The date from which the RetailStoreGroup makes use of the Recipe DC_RCPE_EF EffectiveDate date
ExpirationDate The date at which the RetailStoreGroup (will) cease to use the Recipe DC_RCPE_EP ExpirationDate date


Parent Entity Verb Phrase Child Entity
BusinessUnitGroup uses BusinessUnitGroupRecipe
Recipe is used at BusinessUnitGroupRecipe

Logical Views containing BusinessUnitGroupRecipe

Logical View
Logical 01030 - Item Description - Recipe View
Logical 10110 - Enterprise - Location Retailer Organization View