© Tillypad, 2008-2015
Table of Contents
|
Object |
Description |
Tables |
|---|---|---|
|
Auto-order. Used to automatically add specified menu items to a guest tab when it is created. | ||
|
Bill is a document generated from the guest tab order and given to the custumer to pay. Receipt is generated after the bill has been paid. | ||
|
Business day is a period of an enterprise working time within which the enterprise performance data are calculated. To show the enterprise performance data, at least one division must be created, in which business days are opened and closed. If there are multiple divisions in the enterprise, a business day is opened and closed for each division individually and can have different length, opening and closing dates. For example, a restaurant may work from 12 p. m. till 2 a. m., while a bistro is open from 9 a. m. till 9 p. m. Business days feature helps organise reporting on Sales and Store, as well as the general monitoring of the enterprise activity. Within business days the following actions are performed: - Generating bills and receipts - Payment and fiscal registering - Cost price calculation and recalculetion | ||
|
Butchering record. Used to turn one stock item into many stock items (e.g. a carcase into cuts). | ||
|
Day types Directory is used for configuring promotions | ||
|
Recycle bin Directory contents are not deleted permanently; instead they are marked as deleted with a link in the xxx_del_ID field. | ||
|
| ||
|
Development record Used to deduct stock items consumed in the process of experimenting with dish preparation or preparation wastages. | ||
|
Employee privilege sets. Each access check is a separarte table column | ||
|
A guest tab contains information about a customer's visit. |
| |
|
ID groups Used for quick and easy search of IDs and assigning them | ||
|
Language pack Defines the language in which information is displayed in the interface Employee language pack can be specified (in descending order of priority): 1.In the Employees directory directly in the employee's record 2.In the Personal profiles directory 3.In system settings for the segment The language pack of a regular customer can be specified (in descending order of priority): 1.In the Regular customers directory directly in the client's record 2.In the Personal profiles directory 3.In system settings for the segment Device language pack can be specified (in descending order of priority): 1.In the Devices directory directly in the device's record 2.In system settings for the segment | ||
|
| ||
|
Production record. Used to prepare stock items using recipes with other stock items as ingredients. | ||
|
Promotion types tp_DiscountTypes stores the link to the promotion formula and query parameters for the promotion Aside from the parameters defined in the formula itself, there are also required parameters that are stored in these tables: - tp_DiscountMenuGroups - tp_DiscountMenuItems - tp_DiscountMenuItemShortCuts - tp_DiscountTypePointTypes | ||
|
Regular customer account operations are credits and debits on regular customer accounts. | ||
|
| ||
|
Sales record. Used to determine cost price of stock items sold as menu items. Generated automatically according to sales results. | ||
|
Security levels. Access system component. Along with 'User role' and 'Employee privilege sets' security levels define user access rights. | ||
|
Stock item groups Used for organising stock items and assigning access to them | ||
|
Stock item unit of measurement groups Used for generating a coefficient for recalculating the dish weights value | ||
|
| ||
|
Stocktaking record. Contains information about theoretical and actual stock on hand. | ||
|
Store | ||