Horeko Data Model
Set up this platform in Invantive Cloud: https://cloud.invantive.com/horeko
Text comparisons on this platform are case sensitive.
Platform
- Used from: Invantive Cloud and the Invantive products on your own computer or server.
- Kind: an application reached over its API.
- The data is partitioned, such as per company or administration.
- Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
Figures
| Figure | Count |
|---|---|
| Tables | 206 |
| Columns | 3,425 |
Data Model Poster
This data model declares no keys yet; the dotted relations are derived from column names.
On a table of the poster: plus and minus zoom, the arrow keys move, 0 fits.
The poster as text: tables per topic and their relations
Other
MyClockingStateBreaks, Departments, Meals, TodaysShifts
Account (without relations)
AccountCheckOeiUserPopupOptions, AccountGetOeiUserInfo
Analytic (without relations)
Bought (without relations)
Company (without relations)
Contract (without relations)
Custom (without relations)
Department (without relations)
Dish (without relations)
DishAllergans, DishFinancialCalculations, DishFinancialStates, DishNutrientMarkQualityMarks
Employee (without relations)
EmployeeDepartments, EmployeeOptions
Health (without relations)
Ingredient (without relations)
IngredientAllergans, IngredientNutrients, IngredientQualityMarkMutrients
Manager (without relations)
ManagerDishTypes, ManagerIngredientMutations, ManagerSuppliers
Menubuffet (without relations)
MenubuffetTemplateComponents, MenubuffetTemplates
Mobile (without relations)
Mobilesetting (without relations)
MobilesettingsGetMobileAppVersions
My (without relations)
MyActiveContractToday, MyClockingState, MyPlusMinuses, MyShifts, MyUndeterminedShiftRequests, MyVacations
NATIVEPLATFORMSCALARREQUESTS (without relations)
Permission (without relations)
Personal (without relations)
Predefined (without relations)
Recipe (without relations)
Request (without relations)
Roster (without relations)
RosterDepartments, RosterFeeds, Roster_DataSelectionFeeds
Shift (without relations)
Shifttrade (without relations)
ShifttradesManagerOverview, ShifttradesManager_AcceptedEmployeesAcceptedEmployeesImagesOverview
Userlocation (without relations)
Relations
- MyClockingStateBreaks → Meals (candidate): Derived from the column Meal_Id.
- TodaysShifts → Departments (candidate): Derived from the column DepartmentId.
Tables
Horeko.Account
- AccountCheckOeiUserPopupOptions: itgen_horeko_accountcheckoeiuserpopupoptions_plural
- AccountCheckOeiUserStatus: itgen_horeko_accountcheckoeiuserstatus_plural
- AccountGetOeiUserInfo: itgen_horeko_accountgetoeiuserinfo_plural
Horeko.Analytics
- Analytics: Analytics
Horeko.Availability
- AvailabilitiesBlockavailability: itgen_horeko_availabilitiesblockavailability_plural
- AvailabilitiesMyavailabilities_RecurrenceDetailsWeeklyRecurrenceDaysOfWeekById: itgen_horeko_availabilitiesmyavailabilities_recurrencedetailsweeklyrecurrencedaysofweekbyid_plural
- MyAvailabilitiesByID: My Availabilities by ID
- MyAvalabilities: My Avalabilities
Horeko.Clocking
- ClockingStateByHourID: Clocking State by Hour ID
- MyClockingState: My Clocking State
- MyClockingStateBreaks: My Clocking State Breaks
- MyClockingStateBreaksByHourID: My Clocking State Breaks by Hour ID
- MyHours: My Hours
- MyShifts: My Shifts
- TodaysShiftsByStatus: Todays Shifts by Status
Horeko.Contracts
- ContractRates: Contract Rates
- ContractRatesBasic: Contract Rates (basic)
- ContractTypes: Contract Types
- ContractWeekDays: Contract Weekdays
- Contracts: Contracts
- MyActiveContractToday: My Active Contract Today
Horeko.Department
- DepartmentByID: Department by ID
- Departments: Departments
- DepartmentsBasic: Departments (basic)
Horeko.Dish
- DishAllergensByDishID: Dish Allergens by Dish ID
- DishByID: itgen_horeko_dishbyid_plural
- DishFinancialStateByID: Dish Financial State by ID
- DishNutrientQualityMarksByDishID: Dish Nutrient Quality Marks by Dish ID
- DishNutrientsByDishID: Dish Nutrients by Dish ID
- DishRecipeFinancialCalculationsByDishID: Dish Recipe Financial Calculations by Dish ID
- DishRecipeIngredients: Dish Recipe Ingredients
- DishRecipeIngredientsByDishID: Dish Recipe Ingredients by Dish ID
- Dishes: Dishes
- DishesBasics: Dishes (basics)
- Dishes_MediaImagesById: itgen_horeko_dishes_mediaimagesbyid_plural
- Dishes_MediaVideosById: itgen_horeko_dishes_mediavideosbyid_plural
- _RecordsMediaImagesDishes: itgen_horeko__recordsmediaimagesdishes_plural
- _RecordsMediaVideosDishes: itgen_horeko__recordsmediavideosdishes_plural
Horeko.DocumentManagement
- CompanyEntriesByEntryTypeID: Company Entries by Entry Type ID
- CompanyEntryTypes: Company Entry Types
- EntryAttachmentDetailsByEntryID: Entry Attachment Details by Entry ID
- EntryDetailsByEntryID: Entry Details by Entry ID
- EntryHistoryByEntryID: Entry History by Entry ID
- PersonalEntriesByEntryTypeID: Personal Entries by Entry Type ID
- PersonalEntryTypes: Personal Entry Types
Horeko.Documents
- DownloadByUrl: Download by URL
Horeko.Employee
- EmployeeByID: Employee by ID
- EmployeeDepartmentsByEmployeeID: Employee Departments by Employee ID
- EmployeeDetailsByID: Employee Details by ID
- EmployeeOptions: Employee Options
- EmployeeSkills: Employee Skills
- EmployeeSkillsByEmployeeID: Employee Skills by Employee ID
- EmployeeSkillsByEmployeeID2: Employee Skills by Employee ID
- EmployeeTeams: Employee Teams
- EmployeeTeamsByEmployeeID: Employee Teams by Employee ID
- EmployeeTeamsByEmployeeID2: Employee Teams by Employee ID
- Employees: Employees
Horeko.Export
- ArticleAllergensByPluNumber: Article Allergens by PLU Number
- ArticleIngredientsByPluNumber: Article Ingredients by PLU Number
- ArticleMediaByPluNumber: Article Media by PLU Number
- ArticleProductsByPluNumber: Article Products by PLU Number
- ArticlesByPluNumber: Articles by PLU Number
- DishAllergensByDishID: Dish Allergens by Dish ID
- DishByID: itgen_horeko_dishbyid_plural
- DishIngredientsByDishID: Dish Ingredients by Dish ID
- DishMediaByDishID: Dish Media by Dish ID
- DishProductsByDishID: Dish Products by Dish ID
Horeko.File
- FileById: File by ID
Horeko.HealthController
- Health: itgen_horeko_health_plural
Horeko.Hours
- BreakHours: Breakhours
- Hours: Hours
Horeko.Ingredient
- IngredientAllergensByIngredientID: Ingredient Allergens by Ingredient ID
- IngredientByID: Ingredient by ID
- IngredientByIDAlt: Ingredient by ID (alt.)
- IngredientHistoryByIngredientID: Ingredient History by Ingredient ID
- IngredientHistorySummaryByIngredient: Ingredient History Summary by Ingredient
- IngredientNutrientsByIngredientID: Ingredient Nutrients by Ingredient ID
- IngredientOptions: Ingredient Options
- IngredientQualityMarkNutrientsByIngredientID: Ingredient Quality Mark Nutrients by Ingredient ID
- IngredientSynonyms: Ingredient Synonyms
- IngredientSynonymsByIngredientID: Ingredient Synonyms by Ingredient ID
- IngredientSynonymsByIngredientIDAlt: Ingredient Synonyms by Ingredient ID (alt.)
- Ingredients: Ingredients
Horeko.Location
- Locations: Locations
- Userlocations: User Locations
Horeko.Meal
- Meals: Meals
Horeko.Menubuffet
- MenubuffetTemplateComponents: Menubuffet Template Components
- MenubuffetTemplates: Menubuffet Templates
Horeko.MobileSettings
- MobileSettings: Mobile Settings
- MobilesettingsGetMobileAppVersions: itgen_horeko_mobilesettingsgetmobileappversions_plural
Horeko.Native
- NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar Requests
Horeko.Newsletter
- NewsletterAttachmentsByNewsletterID: Newsletter Attachments by Newsletter ID
- NewsletterByID: itgen_horeko_newsletterbyid_plural
- NewsletterCommentsByNewsletterID: itgen_horeko_newslettercommentsbynewsletterid_plural
- NewslettersByDate: Newsletters by Date
Horeko.Permissions
- BoughtProductPermissions: Bought Product Permissions
- Permissions: Permissions
Horeko.Recipefolders
- RecipeFoldersByFolderType: Recipe Folders by Folder Type
Horeko.Request
- RequestsByDate: Requests by Date
- RequestsManagerOverview: itgen_horeko_requestsmanageroverview_plural
- RequestsOverview: Requests Overview
- UndecidedAndFutureRequestTeamsByRosterType: Undecided and Future Request Teams by Roster Type
- UndecidedAndFutureRequestsByRosterType: Undecided and Future Requests by Roster Type
Horeko.Roster
- AvailabilityEvents: Availability Events
- CalendarEvents: Calendar Events
- RosterDepartmentByDepartmentIdTeamTeamIdEmployees: itgen_horeko_rosterdepartmentbydepartmentidteamteamidemployees_plural
- RosterDepartmentByDepartmentIdTeams: itgen_horeko_rosterdepartmentbydepartmentidteams_plural
- RosterDepartments: itgen_horeko_rosterdepartments_plural
- RosterEventswithshiftrecipients: itgen_horeko_rostereventswithshiftrecipients_plural
- RosterFeeds: itgen_horeko_rosterfeeds_plural
- RosterOverview: Roster Overview
- RosterTeamByTeamIdSkills: itgen_horeko_rosterteambyteamidskills_plural
- Roster_AvailabilitiesEventswithshiftrecipients: itgen_horeko_roster_availabilitieseventswithshiftrecipients_plural
- Roster_CalendarEventsEventswithshiftrecipients: itgen_horeko_roster_calendareventseventswithshiftrecipients_plural
- Roster_DataSelectionFeeds: itgen_horeko_roster_dataselectionfeeds_plural
- Roster_ShiftsEventswithshiftrecipients: itgen_horeko_roster_shiftseventswithshiftrecipients_plural
- Roster_ShiftsUndeterminedShiftEmployeesStatusAcceptedEmployeesImagesEventswithshiftrecipients: itgen_horeko_roster_shiftsundeterminedshiftemployeesstatusacceptedemployeesimageseventswithshiftrecipients_plural
- Roster_ShiftsUndeterminedShiftEmployeesStatusRejectedEmployeesImagesEventswithshiftrecipients: itgen_horeko_roster_shiftsundeterminedshiftemployeesstatusrejectedemployeesimageseventswithshiftrecipients_plural
- Roster_UnavailabilitiesEventswithshiftrecipients: itgen_horeko_roster_unavailabilitieseventswithshiftrecipients_plural
- ShiftEvents: Shift Events
- UnavailabilityEvents: Unavailability Events
Horeko.Sale
- Sales: Sales
- SalesBrancheStores: Sales Branche Stores
- SalesBranches: Sales Branches
- SalesStores: Sales Stores
Horeko.ShiftLocation
- ShiftLocationByID: Shift Location by ID
- ShiftLocations: Shift Locations
Horeko.ShiftTrade
- ShiftTradeRecipientsByShiftID: Shift Trade Recipients by Shift ID
- ShiftTradesByDepartmentID: Shift Trades by Department ID
- ShiftTradesByShiftID: Shift Trades by Shift ID
- ShiftTradesByShiftTradeRecipientID: Shift Trades by Shift Trade Recipient ID
- ShifttradesManagerDetailsByShiftId: itgen_horeko_shifttradesmanagerdetailsbyshiftid_plural
- ShifttradesManagerDetailsByShiftTradeIdRecipients: itgen_horeko_shifttradesmanagerdetailsbyshifttradeidrecipients_plural
- ShifttradesManagerOverview: itgen_horeko_shifttradesmanageroverview_plural
- ShifttradesManager_AcceptedEmployeesAcceptedEmployeesImagesOverview: itgen_horeko_shifttradesmanager_acceptedemployeesacceptedemployeesimagesoverview_plural
Horeko.Shifts
- DailyShiftByID: Daily Shift by ID
- MyShifts: My Shifts
- ShiftsByShiftId: itgen_horeko_shiftsbyshiftid_plural
- ShiftsTemplates: itgen_horeko_shiftstemplates_plural
- Shifts_k__BackingFieldByShiftId: {res:itgen_horeko_shifts_k__backingfieldbyshiftid_plural}
Horeko.Statistics
- ManagerDishTypes: Dish Types (Manager)
- ManagerIngredientMutationsBySupplierID: Ingredient Mutations by Supplier ID (Manager)
- ManagerMarginProblemsByDishTypeID: Margin Problems by Dish Type ID (Manager)
- ManagerProfitableDishes: Profitable Dishes (Manager)
- ManagerSuppliers: Suppliers (Manager)
- ManagerTodaysOverdueTasksByDateRange: Todays Overdue Tasks by Date Range (Manager)
- ManagerTurnoverAndLaborStatisticsByDate: itgen_horeko_managerturnoverandlaborstatisticsbydate_plural
- ManagerTurnoverAndLaborStatisticsByDayAlt: itgen_horeko_managerturnoverandlaborstatisticsbydayalt_plural
- ManagerWasteByLocationID: itgen_horeko_managerwastebylocationid_plural
- MyPlusMinuses: My Plus/Minuses
- MyVacations: My Vacations
Horeko.Stock
- StockByID: Stock by ID
- StockLevel1ItemsByStockID: Stock Level 1 Items by Stock ID
- StockLevel2ItemsByStockID: Stock Level 2 Items by Stock ID
- StockLevel3ItemsByStockID: Stock Level 3 Items by Stock ID
- StockLevel4ItemsByStockID: Stock Level 4 Items by Stock ID
- StockLevel5ItemsByStockID: Stock Level 5 Items by Stock ID
- Stocks: Stocks
Horeko.Subrecipe
- SubrecipeAllergensBySubrecipeID: Subrecipe Allergens by Subrecipe ID
- SubrecipeByID: Subrecipe by ID
- SubrecipeFinancialStateByID: Subrecipe Financial State by ID
- SubrecipeIngredientCostFinancialStateBySubrecipeID: Subrecipe Ingredient Cost Financial State by Subrecipe ID
- SubrecipeIngredientQualityMarkNutrientsBySubrecipeID: Subrecipe Ingredient Quality Mark Nutrients by Subrecipe ID
- SubrecipeIngredients: Subrecipe Ingredients
- SubrecipeIngredientsBySubrecipeID: Subrecipe Ingredients by Subrecipe ID
- SubrecipeNutrientsBySubrecipeID: Subrecipe Nutrients by Subrecipe ID
- SubrecipeOptions: Subrecipe Options
- SubrecipeOptionsAlt: Subrecipe Options (alt.)
- SubrecipeSynonyms: Subrecipe Synonyms
- SubrecipeSynonymsBySubrecipeID: Subrecipe Synonyms by Subrecipe ID
- Subrecipes_MediaImagesById: itgen_horeko_subrecipes_mediaimagesbyid_plural
- Subrecipes_MediaVideosById: itgen_horeko_subrecipes_mediavideosbyid_plural
- _RecordsMediaImagesSubrecipes: itgen_horeko__recordsmediaimagessubrecipes_plural
- _RecordsMediaVideosSubrecipes: itgen_horeko__recordsmediavideossubrecipes_plural
Horeko.Team
Horeko.Unavailability
- CustomUnavailabilities: Custom Unavailabilities
- MyUnavailabilities: My Unavailabilities
- MyUnavailabilitiesAlt: My Unavailabilities (alt.)
- PredefinedUnavailabilities: Predefined Unavailabilities
- UnavailabilitiesByID: itgen_horeko_unavailabilitiesbyid_plural
- UnavailabilitiesById_RecurrenceDetailsWeeklyRecurrenceDaysOfWeekDetails: itgen_horeko_unavailabilitiesbyid_recurrencedetailsweeklyrecurrencedaysofweekdetails_plural
- UnavailabilitiesDaily: Unavailabilities Daily
- UnavailabilitiesManagerOverview: itgen_horeko_unavailabilitiesmanageroverview_plural
- UnavailabilitiesManager_TeamsIdsOverview: itgen_horeko_unavailabilitiesmanager_teamsidsoverview_plural
Horeko.UndeterminedShift
- MyUndeterminedShiftRequestByID: My Undetermined Shift Request by ID
- MyUndeterminedShiftRequests: My Undetermined Shift Requests
- UndeterminedshiftrequestsDetailsByShiftId: itgen_horeko_undeterminedshiftrequestsdetailsbyshiftid_plural
- UndeterminedshiftrequestsDetailsByShiftIdRecipients: itgen_horeko_undeterminedshiftrequestsdetailsbyshiftidrecipients_plural
- UndeterminedshiftrequestsDetailsByShiftId_ShiftRecipientsRecipients: itgen_horeko_undeterminedshiftrequestsdetailsbyshiftid_shiftrecipientsrecipients_plural
- UndeterminedshiftrequestsManagerOverview: itgen_horeko_undeterminedshiftrequestsmanageroverview_plural
- UndeterminedshiftrequestsManager_EmployeesStatusAcceptedEmployeesImagesOverview: itgen_horeko_undeterminedshiftrequestsmanager_employeesstatusacceptedemployeesimagesoverview_plural
- UndeterminedshiftrequestsManager_EmployeesStatusRejectedEmployeesImagesOverview: itgen_horeko_undeterminedshiftrequestsmanager_employeesstatusrejectedemployeesimagesoverview_plural
Horeko.Views
- DishAllergans: Dish Allergens
- DishFinancialCalculations: Dish Financial Calculations
- DishFinancialStates: Dish Financial States
- DishNutrientMarkQualityMarks: Dish Nutrient Quality Marks
- EmployeeDepartments: Employee Departments
- IngredientAllergans: Ingredient Allergans
- IngredientNutrients: Ingredient Nutrients
- IngredientQualityMarkMutrients: Ingredient Quality Mark Nutrients
- ManagerIngredientMutations: Manager Ingredient Mutations
- RecipeFolders: Recipe Folders
- TodaysShifts: Todays Shifts
Horeko.Waste
- WasteItems: Waste Items
- WasteStatisticsByDateRange: Waste Statistics by Date Range
Attributes
The attributes of this platform are on the page Attributes.
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: