invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

DishRecipeFinancialCalculationsByDishID: Horeko Dish Recipe Financial Calculations by Dish ID

read only REST

  • Catalogus: Horeko
  • Schema: Dish
  • Label: Dish Recipe Financial Calculations by Dish ID

Returns dish financial state Returns financial calculations for one dish

Kan alleen gegevens ophalen.

API-bron

  • Eindpunt: /v4/dishes/{id}/financialstate
  • Operatie: get /v4/dishes/{id}/financialstate

Parameters

Name Datatype Required Default Documentation
id ``

Tabelkolommen

De kolommen van de tabel DishRecipeFinancialCalculationsByDishID 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
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: