The Recipe Cost Analysis Report shows the ingredient cost of each recipe by location. It contains one row for each recipe and ingredient line, with the quantity and cost details.
Column reference
| Column | Type | Description |
|---|---|---|
| tenant_id | NUMBER(38,0) | R365 internal tenant identifier |
| location_id | VARCHAR | Location identifier the ingredient cost is calculated for |
| location_name | VARCHAR | Name of the location |
| recipe_item_id | VARCHAR | Identifier of the recipe item this ingredient line belongs to |
| recipe_name | VARCHAR | Name of the recipe item |
| ingredient_id | VARCHAR | Identifier of the ingredient line (one row per recipe ingredient) |
| ingredient_name | VARCHAR | Name of the ingredient item |
| ingredient_quantity | NUMBER(38,10) | Quantity of the ingredient used in the recipe |
| ingredient_uofm_name | VARCHAR | Unit of measure name for the ingredient quantity |
| ingredient_yield_percent | NUMBER(38,10) | Yield percent applied to the ingredient quantity |
| yield_qty | NUMBER(38,10) | Quantity yielded by the recipe batch |
| yield_uofm_name | VARCHAR | Unit of measure name for the recipe yield |
| portion_size | NUMBER(38,10) | Portion size of the recipe |
| portion_uofm_name | VARCHAR | Unit of measure name for the portion size |
| number_of_portions | NUMBER(38,10) | Number of portions the recipe batch yields |
| prep_in_mins | NUMBER(38,10) | Prep time in minutes |
| cook_in_mins | NUMBER(38,10) | Cook time in minutes |
| finish_in_mins | NUMBER(38,10) | Finish time in minutes |
| shelf_life_days | NUMBER(38,10) | Shelf life in days. This is the days-only value. The newer shelf life format is not available. |
| tools | VARCHAR | Tools needed for the recipe |
| serving_plate | VARCHAR | Serving plate for the recipe |
| storage_container | VARCHAR | Storage container for the recipe |
| recipe_steps | VARCHAR | Recipe preparation steps |
| is_included_in_count | BOOLEAN | Shows whether the recipe item is included in the inventory count: true if it is, false if it is not |
| eq_weight_qty | NUMBER(38,10) | Equivalence weight quantity |
| eq_weight_uofm_name | VARCHAR | Equivalence weight unit of measure name, or 'Inactive' if not active |
| eq_volume_qty | NUMBER(38,10) | Equivalence volume quantity |
| eq_volume_uofm_name | VARCHAR | Equivalence volume unit of measure name, or 'Inactive' if not active |
| eq_each_qty | NUMBER(38,10) | Equivalence each quantity |
| eq_each_uofm_name | VARCHAR | Equivalence each unit of measure name, or 'Inactive' if not active |
| cost_account_name | VARCHAR | Name of the GL cost account assigned to the recipe item |
| inventory_account_name | VARCHAR | Name of the GL inventory account assigned to the recipe item |
| cost | NUMBER(31,4) | Cost of this ingredient line for the recipe batch, at this location |
| cost_per_portion | NUMBER(38,4) | Cost of this ingredient line divided by the recipe's number of portions |