Recipes

Recipes

tp_Compounds - tp_Compounds

Object: Stock item

Field

Name

Description

cmpd_pitm_ID

Stock item

Stock item for which the recipe is created. Link to tp_ProductItems (Stock items)

cmpd_meit_ID

Unit of measurement for recipe

Unit of measurement for stock item quantity. Link to tp_MeasureItems (Stock item units of measurement)

cmpd_Volume

Quantity

Quantity Stored in baseline units of measurement for a given stock item taking into account the ratio in its unit of measurement group. For example, the document might display "Potato" - 200 g The unit of measurement (g) has the ratio 0.001. Therefore, in the base it would be stored as 0.2.

cmpd_Date

Recipe date

Recipe date

cmpd_Output

Dish weights

Dish weights

cmpd_Card

Preparation instructions

Preparation instructions

cmpd_ProteinRate

Protein

Protein

cmpd_FatRate

Fats

Fats

cmpd_CarbohydrateRate

Carbohydrates

Carbohydrates

cmpd_CaloryRate

Calorie content

Calorie content