---
title: "DishFinancialCalculations (Horeko)"
description: "Dish Financial Calculations"
language: de
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/de/datamodels/horeko/Horeko.Views.DishFinancialCalculations
original: https://documentation.invantive.eu/en/datamodels/horeko/Horeko.Views.DishFinancialCalculations
updated: 2026-11-16T21:09:56Z
license: https://documentation.invantive.eu/de/
---

# DishFinancialCalculations: Horeko Dish Financial Calculations

`read only`

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

Es können nur Daten abgerufen werden.

## Tabellenspalten

Die Spalten der Tabelle `DishFinancialCalculations` sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ArticleCode` | `varchar2` | Artikelcode | [ ] |  |  |
| `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` | Kostenpreis | [ ] |  |  |
| `DishCreatedOn` | `datetime` | Erstellt am | [ ] |  |  |
| `DishDescription` | `varchar2` | Description | [ ] |  |  |
| `DishFolder_Id` | `int32` | Verzeichnis-ID | [ ] |  |  |
| `DishFolder_Name` | `varchar2` | Ordnernamen | [ ] |  |  |
| `DishId` | `int32` | ID | [ ] |  |  |
| `DishLaborPreparationTime` | `varchar2` | Vorbereitungszeit für die Arbeit | [ ] |  |  |
| `DishLaborWashingTime` | `varchar2` | Arbeitszeit für die Wäsche | [ ] |  |  |
| `DishLastModifiedOn` | `datetime` | Zuletzt geändert am | [ ] |  |  |
| `DishName` | `varchar2` | Name | [ ] |  |  |
| `DishNumberOfPersons` | `int32` | Anzahl der Personen | [ ] |  |  |
| `DishPluNumber` | `varchar2` | PLU-Nummer | [ ] |  |  |
| `DishPreparationDescription` | `varchar2` | Beschreibung der Zubereitung | [ ] |  |  |
| `DishRecipeComments` | `varchar2` | Kommentare zum Rezept | [ ] |  |  |
| `DishServingDescription` | `varchar2` | Beschreibung der Portion | [ ] |  |  |
| `DishType_Id` | `int32` | Typ-ID | [ ] |  |  |
| `DishType_Name` | `varchar2` | Modellname | [ ] |  |  |
| `DishUnitType_Id` | `int32` | Typ-ID der Einheit | [ ] |  |  |
| `DishUnitType_Name` | `varchar2` | Bezeichnung des Einheitstyps | [ ] |  |  |
| `DishUsableAmount` | `double` | Verfügbarer Betrag | [ ] |  |  |
| `Fluctuation` | `int32` | Fluctuation | [ ] |  | 0 = Increased, 1 = Decreased, 2 = Unchanged |
| `Id` | `int32` | ID | [ ] |  |  |
| `LineNumber` | `int32` | Zeilen Nummer | [ ] |  |  |
| `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` | Menge Einheit | [ ] |  | 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` | Einheit Preis | [ ] |  |  |


## Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:

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