© Tillypad 2008-2014
Table of Contents
Table |
Name |
Description |
---|---|---|
Addresses | ||
Alcohol declaration types |
Alcohol declaration types | |
Alcohol declarations | ||
Business day statuses |
Business day statuses (read-only) | |
Store period closure errors |
Store period closure errors operational report | |
Business day processing jobs |
Business day processing jobs | |
Business days |
Business days list | |
Authorisation device types |
Authorisation device types | |
Authorisation devices |
Authorisation devices | |
Authorisation operation types |
Authorisation | |
Authorisation operations |
Authorisation operations | |
Account type settings |
Account type settings | |
Payment authorisation device parameters |
Payment authorisation device parameters | |
Imported point types |
Imported point types | |
Imported promotion categories |
Imported promotion categories | |
Promotion category authorisation device parameters |
Promotion category authorisation device parameters | |
Auto-orders specification |
Auto-order specification - list of menu items | |
Auto-orders |
Auto-order header | |
Receipt sales specifications |
Receipt items. | |
Receipt payment specifications |
Receipt payment specification. Contains payment amount and payment methods | |
Receipt statuses |
Receipt statuses | |
Receipts |
Receipt. Document confirming payment of goods and services. | |
Regular customer points operations |
Regular customer points operations | |
Regular customer point states |
Regular customer point balances | |
Regular customer groups |
Regular customer groups | |
Regular customer IDs |
Regular customer IDs | |
Regular customer account operations |
Regular customer account operations | |
Regular customer account balances |
Regular customer account balances | |
Regular customer account types |
Regular customer account types | |
Regular customer accounts |
Regular customer accounts | |
Regular customers |
Regular customers | |
Production record specifications |
The specification contains the compound stock items themselves and their ingredients: other stock items and semi-finished products. | |
Production document statuses |
Production document statuses | |
Production records |
Production record header | |
Recipe specifications |
Recipe specifications | |
Recipe modes |
Recipe mode for store documents 1. If the 'By stock item concurrence' mode is selected for a stock item of the 'With recipe' class, then the stock item concurrence specified for the store determines whether its recipe items should be included in the specification. 2. If 'Always with recipe' is selected, the stock item ingredients are included, regardless of the stock item concurrence. 3. If 'Manual' is selected, the stock item ingredients are not included, regardless of the stock item concurrence. | |
Recipes |
Recipes | |
Computer input devices |
Computer input devices | |
Computers |
Computers | |
Day types on date |
Calendar day types | |
Sales rules by day type |
Sales rules by day types | |
Day type price schedules |
Day type price schedules | |
Day types |
Day types | |
Butchering record specifications |
Butchering record specifications | |
Butchering document statuses |
Butchering document statuses | |
Butchering records |
Sales record header | |
Butchering specifications |
Butchering specifications | |
Butchering |
Butcherings | |
Recycle bin |
Recycle bin | |
Software module functionality |
Software module functionality Expandable list | |
Software module functionality types |
Software module functionality types | |
Additional parameters for devices |
Additional device parameters | |
Device screen forms |
Device screen forms | |
Operation statuses by device |
Device operation statuses (read-only) | |
Device print formats |
Device print formats | |
Device queries |
Queries for devices | |
Jobs in device queue |
Device job queue | |
Execution log in device queue | ||
Job statuses in device queue |
Job statuses in device queue | |
Device redirection settings |
Device redirection settings | |
Devices monitored via devices |
Devices under surveillance by device | |
Tables monitored via devices |
Device locations under surveillance | |
Connected device print formats |
Connected device print formats | |
Connected devices |
Connected devices | |
Device sales settings |
Device sales settings | |
Variable device parameter values |
Variable device parameter values | |
Devices |
Devices | |
Promotion formulas |
Promotion formulas | |
Promotion settings by menu group |
Menu groups to which promotion is applied or to which promotion is not applicable (if dmgr_IsExcluded = 1) The promotion is applied to the menu group and to all the menu groups contained in it (if dmgr_IsExcluded = 0) | |
Promotion settings by menu item |
Menu items to which promotion is applied or to which promotion is not applicable (if dmit_IsExcluded = 1) | |
Point types |
Point types | |
Promotion settings by point type |
Promotion settings by point type | |
Promotion types |
Promotion types directory | |
POS terminal relationships |
Device relationship for sales copying | |
Fiscal registration device filters for sales copying modes |
Fiscal registration device filters for sales copying modes | |
Sales copying modes |
Sales copying modes | |
? | ||
Promotion category authorisation |
Promotion category authorisation. Used to determine customer's promotion categories. | |
Divisions |
Divisions | |
Counters of number generators |
Counter ID Counter must be associated with several IDs (ID1-ID4). For example, stock-in record. If separate numbering settings are required for each partner and each store, both the ID of the partner and the ID of the store must be preserved. If numbering is required only for store, the partner ID does not need to be preserved. | |
Number generators |
Document number generators | |
Setting options of number generators |
Document number settings | |
Number format types |
Document number format types | |
Reserved | ||
Additional device parameters |
Additional device parameters | |
Company groups |
Company groups | |
Company types |
Company types | |
Companies |
Companies | |
Fiscal register types |
Fiscal register types | |
Fiscal registers |
Fiscal registers | |
Fiscal registration specifications |
Fiscal registration specifications | |
Fiscal registration payments |
Fiscal registration payments | |
Fiscal registration types |
Fiscal registration types | |
Fiscal registrations |
Fiscal registrations | |
Screen form print layouts |
Screen form print formats | |
Point deposit type |
Point award type | |
Guest tab points operations |
Contains point deposit operations for the guest tab. Takes into account points awarded to the regular customer on previous visits and points awarded during the current visit. | |
Reservation | ||
Promotion categories of the guest tab |
Contains additional promotion categories added to the guest tab, e.g. promotion categories assigned to the table where it was opened. | |
Guest tab statuses |
Guest tab statuses | |
| ||
Guest tabs |
Guest tab header | |
ID groups |
ID groups | |
ID types |
ID types | |
IDs |
IDs | |
Stock-in record specifications |
Stock-in record specifications | |
Stock-in record statuses |
Stock-in record statuses (read-only) | |
Stock-in records |
Stock-in records | |
Keyboard shortcut action types |
Keyboard shortcut action types | |
Keyboard shortcut actions |
Keyboard shortcut actions | |
Keyboard layouts |
Keyboard layouts | |
Language packs |
Language pack. Contains a list of languages in order of preference for use in the interface | |
Language pack specifications |
Language pack specifications | |
Languages |
Available languages directory | |
Device loaders |
Device loaders | |
Employee notification devices |
Employee notification devices | |
Employee paging device |
Employee paging device | |
Locations |
Locations | |
Stock item unit of measurement groups |
Stock item unit of measurement groups | |
Stock item units of measurement |
Stock item units of measurement | |
Draft statuses |
Draft statuses | |
Drafts |
Drafts | |
Draft menu groups |
Draft menu groups | |
Menu groups |
Menu groups | |
Draft menu items |
Draft menu items | |
Draft menu item IDs |
Draft menu item IDs | |
Menu item IDs |
Menu item IDs | |
Draft menu item stock items |
Draft menu item stock items | |
Menu item stock items |
Link between stock item and menu item | |
Draft menu prepaid credits |
Draft menu prepaid credits | |
Menu prepaid credits | ||
Menu item sales exclusions |
Menu item sales exclusions | |
Draft menu items price schedule |
Draft menu items price schedule | |
Menu items price schedule |
Menu items price schedule | |
Menu item timed service |
Menu item timed service | |
Draft menu item timed service |
Draft menu item timed service | |
Menu items |
Menu items | |
Draft modifiers |
Draft modifiers | |
Draft menu modifier groups |
Draft menu modifier groups | |
Menu modifier groups |
Menu modifier groups | |
Draft modifiers specification |
Draft modifiers specification | |
Menu modifiers specification |
Menu modifiers specification | |
Menu modifiers |
Menu modifiers | |
Picture group |
Picture groups | |
Menu pictures |
Menu pictures | |
Sales parameters |
Sales parameters | |
Concurrences |
Concurrences | |
Menu types |
Menu types | |
Supplementary units |
Quantity recalculations | |
Menu units of measurement |
Menu units of measurement | |
String values for queries | ||
Software module connections |
Software module interconnections | |
Software module supported functionality |
Software module supported functionality | |
Software module screen form elements |
Software module screen form items | |
Screen forms |
Module screen form settings | |
Screen form types |
Software module screen forms | |
Software module keyboard model |
Software module keyboard model | |
Module macros |
Module macros | |
Software module print format types |
Software module print format types | |
Software module print formats |
Software module print formats | |
Software module queries |
Software module queries | |
Software module dependencies |
Software module dependencies | |
Required functionality of software module connected device |
Required functionality of software module connected device | |
Software module connected device print format types |
Software module connected device print format types | |
Software module connected device roles |
Software module connected device roles | |
Software module states |
Software module states | |
Software module types |
Software module types | |
Software module variable parameters |
Software module variable parameters | |
Software modules |
Software modules | |
Stock movement records specification |
Stock movement records specification | |
Stock movement record statuses |
Stock movement record statuses (read-only) | |
Stock movement records |
Stock movement records | |
Note object types |
Note type objects | |
Note types |
Note types | |
Notes |
A Note is additional information about an object. | |
Access to objects | ||
Promotions on order specification item |
Contains a list of the promotions applied | |
Order item promotion categories |
Order item promotion categories | |
Order items |
Orders specification. Contains menu items and services included in orders for the guest tab. | |
Prepaid credits | ||
Order promotion categories |
Contains a list of the promotion categories used to calculate promotion on this order. This list can be populated from promotion categories associated with the table that the guest tab was registered at when this order was made. | |
? | ||
Order ready confirmations |
Order ready confirmation | |
Order ready confirmation specification |
Order ready confirmation specification | |
Order statuses |
Order statuses | |
? | ||
Promotions on timed services in order |
Detailed information on promotions for the timed service item | |
Timed services price schedule in orders |
Contains billing details of timed services. | |
Order timed services promotion categories |
Order timed services promotion categories | |
Timed services in orders |
Contains timed services in the order. | |
Orders |
Contains order headers for the guest tab. | |
Stock-out records specification |
Stock-out records specification | |
Stock-out record statuses |
Stock-out record statuses (read-only) | |
Stock-out records |
Stock-out records | |
On-screen button formats |
On-screen button formats | |
POS terminal operating mode types |
POS terminal operating mode types | |
POS terminal operating modes |
POS terminal operating modes | |
Restricted operation types (read-only table) | ||
Reasons for restricted POS terminal operations |
Reasons for restricted POS terminal operations | |
Restricted change of number of customers in guest tab |
Restricted change of number of customers in guest tab | |
Restricted change of table |
Restricted change of table | |
Restricted changes of guest tab promotion category |
Restricted changes of guest tab promotion category | |
Restricted guest tab handover |
Restricted guest tab handover | |
Restricted guest tab voids |
Restricted guest tab voids | |
Restricted order item voids |
Restricted order item voids | |
Restricted payment order item voids |
Restricted prepayment credits voids | |
Restricted voids of timed service charge rates in orders |
Restricted voids of timed service charge rates in orders | |
Restricted timed service voids from orders |
Restricted timed service voids from orders | |
Restricted order voids |
Restricted order voids | |
Guest tabs of restricted voids of sending guest tabs to payment |
Guest tabs of restricted voids of sending guest tabs to payment | |
Restricted bill item voids |
Restricted bill item voids | |
Restricted voids of sending guest tabs to payment |
Restricted voids of sending guest tabs to payment | |
Restricted POS terminal operations |
Restricted POS terminal operations | |
Restricted bill reprint |
Restricted bill reprint | |
Restricted guest tab split |
Restricted guest tab split | |
Restricted prepaid credits voids from orders | ||
Restricted timed service split |
Restricted timed service split | |
Update package specification |
Update package specification | |
Update packages |
Update packages | |
Alcoholic beverage licences | ||
Partner groups |
Partner groups | |
Separate divisions | ||
Partners |
Partners | |
Payment settings |
Payment settings | |
Payment methods in payment settings |
Payment methods in payment settings | |
Sales departments in payment settings |
Sales departments in payment settings | |
Payment setting elements |
Payment setting elements | |
Payment method groups |
Payment method groups | |
Payment method denominations | ||
Payment methods |
Payment methods | |
Personal profile |
Personal profiles | |
Personal profile groups |
Personal profile groups | |
Table groups |
Table groups | |
Table joins |
Table joins | |
Seating and device layouts |
Seating and device layouts | |
Table pictures |
Table pictures | |
Table type statuses |
Table type statuses (read-only) | |
Table types |
Table types | |
Tables |
Tables | |
Port types |
Port types (read-only table) | |
Bills specification |
Bill specifications | |
Bill statuses |
Bill statuses (read-only) | |
Bills |
Bill header | |
Print layouts |
Print layouts | |
Print templates |
Print templates | |
Alcoholic beverage sorts | ||
Stock item categories |
Stock item categories | |
Cold preparation wastages |
Cold preparation wastages | |
Stock item groups |
Stock item groups | |
Cooking wastages |
Cooking wastages | |
Stock item IDs |
Stock item IDs | |
Stock items |
Stock items | |
Other alcoholic beverage suppliers | ||
Stock item substitute specifications |
Stock item substitute specifications | |
Stock item replacements |
Stock item replacements | |
Stock item concurrences |
Stock item concurrences | |
Stock item types |
Stock item types | |
Weight specifications (scale) |
Weight specifications | |
Stock item weights |
Stock item weight | |
Read-only elements list (switch System parameter) | ||
Report groups |
Report groups | |
Associate reports with software modules |
Associate reports with software modules | |
Reports |
Reports | |
Return delivery note specification items |
Return delivery note specification items | |
Return delivery notes statuses |
Return delivery notes statuses | |
Return delivery notes |
Return delivery notes | |
Sales record specifications (stock items) |
Sales record specifications (stock items) | |
Orders included in sales record |
Orders included in sales record | |
Sales record statuses |
Sales record statuses (read-only) | |
Deletions (with stock deduction) entered into sales records |
Deletions (with stock deduction) included in the sales record | |
Sales records |
Sales records | |
Sales departments |
Sales departments | |
Interval and sales rule settings |
Interval and sales rules settings | |
Promotion categories |
Promotion categories | |
Sales settings |
Sales settings | |
Sales setting element printers |
Sales setting element printers | |
Sales setting elements |
Sales setting elements | |
Sales rules intervals |
Sales rules intervals | |
Sales rules |
Sales rules | |
Privilege groups |
Privilege groups | |
? | ||
Privileges |
Privileges | |
Security levels |
Security levels. | |
Employee privilege sets |
Employee privilege sets | |
Subscription |
Subscription | |
Ports |
Ports | |
Segments |
Segments | |
Order form building mode |
? | |
Gender |
Gender | |
Store period closures |
Store period closures | |
Cost price item |
Cost price element | |
? | ||
Store document types | ||
? | ||
? | ||
? | ||
Errors processing store documents |
Storekeeping system document processing errors directory | |
Store document processing statuses |
Document processing status (read-only) | |
Development record results |
Stock item consumptions in development record | |
Development record specifications |
Specification of stock items used in developing the recipe. | |
Development record statuses |
Development record statuses (read-only) | |
Development record experiments |
Development record experiments | |
Development records |
Development record header | |
? | ||
Purchase cost by store groups |
Store group purchase prices | |
Planned cost record specifications |
Planned cost record specifications | |
Planned cost records |
Planned cost records | |
Store groups |
Store groups | |
Stocktaking records |
Stocktaking record header | |
Stocktaking record collation reports |
Stocktaking record collation report. Lists the actual count of stock-on hand | |
Stocktaking record statuses |
Stocktaking record statuses (read-only) | |
Stocktaking record specifications |
Stocktaking record specifications | |
Stock limits |
Stock limits | |
Stock item concurrences |
Stock item concurrences | |
Stock on hand |
Stock on hand | |
Stores |
Stores | |
System settings |
System settings | |
Price schedule groups |
Price schedule groups | |
Price schedule timetable element |
Price schedule timetable element | |
Price schedules |
Price schedules | |
Task schedule |
Task schedule | |
Task types |
Task types | |
Tasks |
Custom tasks There also exist system tasks which you can check by running the procedure tpsrv_SelectTasks | |
Employee IDs |
Employee IDs | |
Timesheet entry |
Timesheet entry | |
Employee information |
Employee's personal settings | |
Access settings |
Access settings | |
| ||
User roles |
User roles | |
Employees |
Employees | |
VAT rates | ||
| ||
Deletions from orders (with stock deduction) |
Deletions from orders (with stock deduction) | |
Settings for days of the week |
Settings for days of the week | |
Days of the week |
Days of the week | |
Stock adjustment record specifications |
Stock adjustment record specifications | |
Stock adjustment record statuses |
Stock adjustment record statuses | |
Stock adjustment record types |
Stock adjustment record types | |
Stock adjustment records |
Stock adjustment records | |
Application settings |
Segment settings | |
Programs |
Programmes | |
Application error messages |
Application error messages | |
Replication objects |
Replication objects | |
Application table fields |
Application table fields | |
Application tables |
List of all database tables. |