invantive documentation
Invantive Support ForumsLog In / Sign Up

DishFinancialStates: Horeko Dish Financial States

read only

  • Catalog: Horeko
  • Schema: Views
  • Label: Dish Financial States

Can only retrieve data.

Table Columns

The columns of the table DishFinancialStates 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
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
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
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
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

Release Notes

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