Entity Definition

Logical Name : PreparedItem
Physical Name : AS_ITM_PPR

A sub-type of Item that is manufactured (or prepared) for sale from a set of BulkItem via a Recipe. The distinction from StockItem being that PreparedItem is not booked into inventory when the item is manufactured; nor is it removed from inventory when it is sold; rather the inventory for the BulkItem constituent parts as defined by the recipe is reduced when the PreparedItem is sold.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32)
FoodItemHoldingTime The number of minutes that a prepared food item may be held ready for sale. At the end of this time, the item must not be sold to a customer. TM_HLDR_FD_ITM QuantityShortCountMinutes decimal(4,0)


Parent Entity Verb Phrase Child Entity
PreparedItem is assembled via Recipe
Item can be a PreparedItem

Logical Views containing PreparedItem

Logical View
Logical 01000 - Item Description - Macro View
Logical 01004 - Item Description - Branding
Logical 01010 - Item Description - Subtype View
Logical 01020 - Item Description - Enterprise View
Logical 01030 - Item Description - Recipe View