---
title: "DishFinancialCalculations (Horeko)"
description: "Dish Financial Calculations"
language: nl
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/nl/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/nl/
---

# DishFinancialCalculations: Horeko Dish Financial Calculations

`read only`

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

Kan alleen gegevens ophalen.

## Tabelkolommen

De kolommen van de tabel `DishFinancialCalculations` worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

| Name | Datatype | 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` | Kostprijs | [ ] |  |  |
| `DishCreatedOn` | `datetime` | Aangemaakt op | [ ] |  |  |
| `DishDescription` | `varchar2` | Description | [ ] |  |  |
| `DishFolder_Id` | `int32` | Map ID | [ ] |  |  |
| `DishFolder_Name` | `varchar2` | Mapnaam | [ ] |  |  |
| `DishId` | `int32` | ID | [ ] |  |  |
| `DishLaborPreparationTime` | `varchar2` | Arbeid Voorbereidingstijd | [ ] |  |  |
| `DishLaborWashingTime` | `varchar2` | Arbeid Wastijd | [ ] |  |  |
| `DishLastModifiedOn` | `datetime` | Laatst Gewijzigd op | [ ] |  |  |
| `DishName` | `varchar2` | Name | [ ] |  |  |
| `DishNumberOfPersons` | `int32` | Aantal Personen | [ ] |  |  |
| `DishPluNumber` | `varchar2` | PLU-nummer | [ ] |  |  |
| `DishPreparationDescription` | `varchar2` | Voorbereiding Omschrijving | [ ] |  |  |
| `DishRecipeComments` | `varchar2` | Recept Opmerkingen | [ ] |  |  |
| `DishServingDescription` | `varchar2` | Serveeromschrijving | [ ] |  |  |
| `DishType_Id` | `int32` | Type ID | [ ] |  |  |
| `DishType_Name` | `varchar2` | Soortnaam | [ ] |  |  |
| `DishUnitType_Id` | `int32` | Eenheidsoort ID | [ ] |  |  |
| `DishUnitType_Name` | `varchar2` | Eenheidssoortnaam | [ ] |  |  |
| `DishUsableAmount` | `double` | Bruikbare Hoeveelheid | [ ] |  |  |
| `Fluctuation` | `int32` | Fluctuation | [ ] |  | 0 = Increased, 1 = Decreased, 2 = Unchanged |
| `Id` | `int32` | ID | [ ] |  |  |
| `LineNumber` | `int32` | Regelnummer | [ ] |  |  |
| `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` | Aantal Eenheid | [ ] |  | 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` | Prijs per Eenheid | [ ] |  |  |


## Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver:

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