invantive documentation
Invantive SupportforenAnmelden / Eintragen

DishRecipeFinancialCalculationsByDishID: Horeko Dish Recipe Financial Calculations by Dish ID

read only REST

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

Returns dish financial state Returns financial calculations for one dish

Es können nur Daten abgerufen werden.

API-Quelle

  • Endpunkt: /v4/dishes/{id}/financialstate
  • Operation: get /v4/dishes/{id}/financialstate

Parameter

Name Datentyp Required Default Documentation
id ``

Tabellenspalten

Die Spalten der Tabelle DishRecipeFinancialCalculationsByDishID 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
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: