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_ |
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 | |||
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 | |||
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 | |||
Settings_ |
double |
itgen_horeko_settings_grossprofitpercentage | |||
Settings_ |
double |
itgen_horeko_settings_multiplier | |||
Settings_ |
int32 |
itgen_horeko_settings_vatpercentage | |||
Settings_ |
double |
itgen_horeko_settings_wastepercentage |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: