---
title: "DishFinancialCalculations (Horeko)"
description: "Dish Financial Calculations"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/horeko/Horeko.Views.DishFinancialCalculations
original: https://documentation.invantive.eu/en/datamodels/horeko/Horeko.Views.DishFinancialCalculations
updated: 2025-06-11T11:15:01Z
license: https://documentation.invantive.eu/en/
---

# DishFinancialCalculations: Horeko Dish Financial Calculations

`read only`

- Catalog: `Horeko`
- Schema: `Views`
- Label: Dish Financial Calculations

Can only retrieve data.

## Table Columns

The columns of the table `DishFinancialCalculations` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ArticleCode` | `varchar2` | Article Code | [ ] |  |  |
| `Calculations_GrossProfit` | `double` | itgen_horeko_calculations_grossprofit | [ ] |  |  |
| `Calculations_MarginExcluded` | `double` | itgen_horeko_calculations_marginexcluded | [ ] |  |  |
| `Calculations_MenuPrice` | `double` | itgen_horeko_calculations_menuprice | [ ] |  |  |
| `Calculations_PurchasingCosts` | `double` | itgen_horeko_calculations_purchasingcosts | [ ] |  |  |
| `Calculations_RealisedFactor` | `double` | itgen_horeko_calculations_realisedfactor | [ ] |  |  |
| `Calculations_RealisedMargin` | `double` | itgen_horeko_calculations_realisedmargin | [ ] |  |  |
| `Calculations_SalesExcludingVat` | `double` | itgen_horeko_calculations_salesexcludingvat | [ ] |  |  |
| `Calculations_SalesIncludingVat` | `double` | itgen_horeko_calculations_salesincludingvat | [ ] |  |  |
| `Calculations_TotalCosts` | `double` | itgen_horeko_calculations_totalcosts | [ ] |  |  |
| `Calculations_VAT` | `double` | itgen_horeko_calculations_vat | [ ] |  |  |
| `Calculations_Waste` | `double` | itgen_horeko_calculations_waste | [ ] |  |  |
| `CostPrice` | `double` | Cost Price | [ ] |  |  |
| `DishCreatedOn` | `datetime` | Created on | [ ] |  |  |
| `DishDescription` | `varchar2` | Description | [ ] |  |  |
| `DishFolder_Id` | `int32` | Folder ID | [ ] |  |  |
| `DishFolder_Name` | `varchar2` | Folder Name | [ ] |  |  |
| `DishId` | `int32` | ID | [ ] |  |  |
| `DishLaborPreparationTime` | `varchar2` | Labor Preparation Time | [ ] |  |  |
| `DishLaborWashingTime` | `varchar2` | Labor Washing Time | [ ] |  |  |
| `DishLastModifiedOn` | `datetime` | Last Modified on | [ ] |  |  |
| `DishName` | `varchar2` | Name | [ ] |  |  |
| `DishNumberOfPersons` | `int32` | Number of Persons | [ ] |  |  |
| `DishPluNumber` | `varchar2` | PLU Number | [ ] |  |  |
| `DishPreparationDescription` | `varchar2` | Preparation Description | [ ] |  |  |
| `DishRecipeComments` | `varchar2` | Recipe Comments | [ ] |  |  |
| `DishServingDescription` | `varchar2` | Serving Description | [ ] |  |  |
| `DishType_Id` | `int32` | Type ID | [ ] |  |  |
| `DishType_Name` | `varchar2` | Type Name | [ ] |  |  |
| `DishUnitType_Id` | `int32` | Unit Type ID | [ ] |  |  |
| `DishUnitType_Name` | `varchar2` | Unit Type Name | [ ] |  |  |
| `DishUsableAmount` | `double` | Usable Amount | [ ] |  |  |
| `Fluctuation` | `int32` | Fluctuation | [ ] |  | 0 = Increased, 1 = Decreased, 2 = Unchanged |
| `Id` | `int32` | ID | [ ] |  |  |
| `LineNumber` | `int32` | Line Number | [ ] |  |  |
| `Name` | `varchar2` | Name | [ ] |  |  |
| `PersonalCosts_DishDishwashingCosts` | `double` | itgen_horeko_personalcosts_dishdishwashingcosts | [ ] |  |  |
| `PersonalCosts_DishKitchenPreparationCosts` | `double` | itgen_horeko_personalcosts_dishkitchenpreparationcosts | [ ] |  |  |
| `PersonalCosts_HalfproductsDishwashingCosts` | `double` | itgen_horeko_personalcosts_halfproductsdishwashingcosts | [ ] |  |  |
| `PersonalCosts_HalfproductsKitchenPreparationCosts` | `double` | itgen_horeko_personalcosts_halfproductskitchenpreparationcosts | [ ] |  |  |
| `PersonalCosts_TotalCosts` | `double` | itgen_horeko_personalcosts_totalcosts | [ ] |  |  |
| `Quantity` | `double` | Quantity | [ ] |  |  |
| `QuantityUnit` | `int32` | Quantity Unit | [ ] |  | 0 = Kilo, 1 = Liter, 2 = Piece |
| `Settings_GrossProfitPercentage` | `double` | itgen_horeko_settings_grossprofitpercentage | [ ] |  |  |
| `Settings_Multiplier` | `double` | itgen_horeko_settings_multiplier | [ ] |  |  |
| `Settings_VatPercentage` | `int32` | itgen_horeko_settings_vatpercentage | [ ] |  |  |
| `Settings_WastePercentage` | `double` | itgen_horeko_settings_wastepercentage | [ ] |  |  |
| `Type` | `int32` | Type | [ ] |  | 0 = Ingredient, 1 = IngredientSynonym, 2 = Subrecipe, 3 = SubrecipeSynonym, 4 = Unknown |
| `UnitPrice` | `double` | Unit Price | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Horeko](/en/release-notes/drivers?driver=horeko)

