DishFinancialCalculations: Horeko Dish Financial Calculations
read only
- Catalog:
Horeko - Schema:
Views - Label: Dish Financial Calculations
Can only retrieve data.
Table Columns
The columns of the table DishFinancialCalculations 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 |
|---|---|---|---|---|---|
Article |
varchar2 |
Article Code | |||
Calculations_ |
double |
itgen_horeko_calculations_grossprofit | |||
Calculations_ |
double |
itgen_horeko_calculations_marginexcluded | |||
Calculations_ |
double |
itgen_horeko_calculations_menuprice | |||
Calculations_ |
double |
itgen_horeko_calculations_purchasingcosts | |||
Calculations_ |
double |
itgen_horeko_calculations_realisedfactor | |||
Calculations_ |
double |
itgen_horeko_calculations_realisedmargin | |||
Calculations_ |
double |
itgen_horeko_calculations_salesexcludingvat | |||
Calculations_ |
double |
itgen_horeko_calculations_salesincludingvat | |||
Calculations_ |
double |
itgen_horeko_calculations_totalcosts | |||
Calculations_ |
double |
itgen_horeko_calculations_vat | |||
Calculations_ |
double |
itgen_horeko_calculations_waste | |||
Cost |
double |
Cost Price | |||
Dish |
datetime |
Created on | |||
Dish |
varchar2 |
Description | |||
Dish |
int32 |
Folder ID | |||
Dish |
varchar2 |
Folder Name | |||
DishId |
int32 |
ID | |||
Dish |
varchar2 |
Labor Preparation Time | |||
Dish |
varchar2 |
Labor Washing Time | |||
Dish |
datetime |
Last Modified on | |||
Dish |
varchar2 |
Name | |||
Dish |
int32 |
Number of Persons | |||
Dish |
varchar2 |
PLU Number | |||
Dish |
varchar2 |
Preparation Description | |||
Dish |
varchar2 |
Recipe Comments | |||
Dish |
varchar2 |
Serving Description | |||
Dish |
int32 |
Type ID | |||
Dish |
varchar2 |
Type Name | |||
Dish |
int32 |
Unit Type ID | |||
Dish |
varchar2 |
Unit Type Name | |||
Dish |
double |
Usable Amount | |||
Fluctuation |
int32 |
Fluctuation | 0 = Increased, 1 = Decreased, 2 = Unchanged | ||
Id |
int32 |
ID | |||
Line |
int32 |
Line Number | |||
Name |
varchar2 |
Name | |||
Personal |
double |
itgen_horeko_personalcosts_dishdishwashingcosts | |||
Personal |
double |
itgen_horeko_personalcosts_dishkitchenpreparationcosts | |||
Personal |
double |
itgen_horeko_personalcosts_halfproductsdishwashingcosts | |||
Personal |
double |
itgen_horeko_personalcosts_halfproductskitchenpreparationcosts | |||
Personal |
double |
itgen_horeko_personalcosts_totalcosts | |||
Quantity |
double |
Quantity | |||
Quantity |
int32 |
Quantity Unit | 0 = Kilo, 1 = Liter, 2 = Piece | ||
Settings_ |
double |
itgen_horeko_settings_grossprofitpercentage | |||
Settings_ |
double |
itgen_horeko_settings_multiplier | |||
Settings_ |
int32 |
itgen_horeko_settings_vatpercentage | |||
Settings_ |
double |
itgen_horeko_settings_wastepercentage | |||
Type |
int32 |
Type | 0 = Ingredient, 1 = IngredientSynonym, 2 = Subrecipe, 3 = SubrecipeSynonym, 4 = Unknown | ||
Unit |
double |
Unit Price |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: