Tillypad XL Data Base Description
© Tillypad 2008-2014
Table of Contents
- 21. Data Base Main Scheme
- 22. Tillypad XL objects
- Simple tables
- Business day
- Menu picture group
- Regular customer
- Store group
- Regular customer accounts operation
- Stock item
- Keyboard layout
- Bill
- Order ready confirmation
- Personal profile
- Delete
- Setting option of number generators
- Table join
- Partner
- Print template
- Authorisation device
- Company group
- Draft
- Production record
- Promotion formula
- Partner group
- Planned cost record
- Authorisation device type
- Computer
- Stock-in record
- Reason for restricted POS terminal operation
- Stock-out record
- Sales copying mode
- Stock item category
- Link guest tab to stores
- Sales setting
- Development record
- Software module print format
- Menu picture
- Guest tab
- Additional device parameter
- Employee paging device
- Keyboard shortcut action
- Menu unit of measurement
- VAT Rate
- Stock adjustment record
- User role
- Stocktaking record
- Stock item unit of measurement
- Report
- Payment method group
- Auto-order
- On-screen button format
- Number generator
- Sales parameter
- Screen form print layout
- Menu group
- Timesheet
- Return delivery note
- Authorisation operation
- Device loader
- Promotion category
- Associate deletions from orders (with stock deduction)
- Menu type
- Point type
- Location
- Price schedule group
- Day type
- Sales record
- Payment method
- Payment authorisation device parameter
- Employee information
- Stock item concurrence
- Butchering record
- Fiscal register type
- Company type
- Employee privilege set
- Task type
- Fiscal register
- Current on hand stock item
- Sales rule
- Stock movement between different companies
- Stock item type
- Security level
- Fiscal registration
- Device
- Personal profile group
- Stock item unit of measurement group
- Keyboard shortcut action type
- Stock adjustment record type
- Price schedule
- Cost price item
- Stock item group
- Table type
- Table group
- Software module
- Employee
- Business day processing job
- ID group
- Regular customer points operation
- Store period closure
- Update package
- Division
- Day types by date setting element
- Segment
- Table
- Note type
- Payment setting
- Day types by weekday setting element
- Menu item
- Global system settings
- Store
- Language pack
- Concurrence
- ID type
- Menu modifier
- Restricted POS terminal operation
- Seating and device layout
- Module macro
- ID
- Sales department
- Regular customer group
- POS terminal operating mode
- Promotion type
- Exclude menu items from sale
- Report group
- Stock limit
- Screen form
- Company
- Promotion category authorisation devices parameter
- Deletion from orders (with stock deduction)
- Stock movement record
- Regular customer account type
- 23. Tables of Tillypad XL Database
- Business day statuses
- Store period closure errors
- Authorisation operation types
- Receipt statuses
- Regular customer point states
- Regular customer account balances
- Production document statuses
- Recipe modes
- Butchering document statuses
- Software module functionality
- Software module functionality types
- Operation statuses by device
- Jobs in device queue
- Job statuses in device queue
- Counters of number generators
- Number format types
- Fiscal registration types
- Point deposit type
- Guest tab statuses
- Stock-in record statuses
- Languages
- Draft statuses
- String values for queries
- Software module types
- Stock movement record statuses
- Notes
- Access to objects
- Order statuses
- Stock-out record statuses
- Table type statuses
- Port types
- POS terminal operating mode types
- Bill statuses
- Print layouts
- Return delivery notes statuses
- Sales record statuses
- Privilege groups
- Privileges
- Order form building mode
- Gender
- Errors processing store documents
- Store document processing statuses
- Development record statuses
- Stocktaking record statuses
- Tasks
- Task schedule
- Days of the week
- Stock adjustment record statuses
- Application settings
- Programs
- Application error messages
- Replication objects
- Application table fields
- Application tables
- Business days
- Picture group
- Regular customer IDs
- Regular customer accounts
- Regular customers
- Purchase cost by store groups
- Store groups
- Regular customer account operations
- Recipe specifications
- Recipes
- Butchering specifications
- Butchering
- Cold preparation wastages
- Cooking wastages
- Stock item IDs
- Stock items
- Stock item substitute specifications
- Stock item replacements
- Weight specifications (scales)
- Stock item weights
- Keyboard layouts
- Receipt sales specifications
- Receipt payment specifications
- Receipts
- Bills specification
- Bills
- Order ready confirmations
- Order ready confirmation specification
- Personal profile
- Recycle bin
- Setting options of number generators
- Table joins
- Partners
- Print templates
- Authorisation devices
- Company groups
- Drafts
- Draft menu groups
- Draft menu items
- Draft menu item IDs
- Draft menu item stock items
- Draft menu prepaid credits
- Draft menu items price schedule
- Draft menu item timed service
- Draft modifiers
- Draft menu modifier groups
- Draft modifiers specification
- Production record specifications
- Production records
- Promotion formulas
- Partner groups
- Planned cost record specifications
- Planned cost records
- Authorisation device types
- Computer input devices
- Computers
- Stock-in record specifications
- Stock-in records
- Reasons for restricted POS terminal operations
- Stock-out records specification
- Stock-out records
- POS terminal relationships
- Fiscal registration device filters for sales copying modes
- Sales copying modes
- Stock item categories
- Sales settings
- Sales setting elements
- Sales setting element printers
- Development record specifications
- Development record results
- Development records
- Development record experiments
- Software module print formats
- Menu pictures
- Guest tab points operations
- Reservation
- Guest tabs
- Promotion categories of the guest tab
- Promotions on order specification item
- Order items
- Order item promotion categories
- Prepaid credits
- Orders
- Order promotion categories
- Promotions on timed services in order
- Timed services price schedule in orders
- Timed services in orders
- Order timed services promotion categories
- Additional device parameters
- Employee paging device
- Keyboard shortcut actions
- Supplementary units
- Menu units of measurement
- VAT rates
- Stock adjustment record specifications
- Stock adjustment records
- Access settings
- User roles
- Stocktaking records
- Stocktaking record collation reports
- Stocktaking record specifications
- Stock item units of measurement
- Associate reports with software modules
- Reports
- Payment method groups
- Auto-orders specification
- Auto-orders
- On-screen button formats
- Number generators
- Sales parameters
- Screen form print layouts
- Menu groups
- Timesheet entry
- Return delivery note specification items
- Return delivery notes
- Authorisation operations
- Device loaders
- Promotion categories
- Menu types
- Point types
- Employee notification devices
- Locations
- Price schedule groups
- Day types
- Sales rules by day type
- Day type price schedules
- Sales record specifications (stock items)
- Orders included in sales record
- Sales records
- Deletions (with stock deduction) entered into sales records
- Payment method denominations
- Payment methods
- Guest tab type settings
- Payment authorisation device parameters
- Employee information
- Stock item concurrences
- Butchering record specifications
- Butchering records
- Fiscal register types
- Company types
- Employee privilege sets
- Task types
- Fiscal registers
- Stock on hand
- Interval and sales rule settings
- Sales rules intervals
- Sales rules
- Stock item types
- Security levels
- Fiscal registration specifications
- Fiscal registration payments
- Fiscal registrations
- Additional parameters for devices
- Device screen forms
- Device print formats
- Device queries
- Device redirection settings
- Devices monitored via devices
- Tables monitored via devices
- Connected device print formats
- Connected devices
- Devices
- Device sales settings
- Variable device parameter values
- Personal profile groups
- Stock item unit of measurement groups
- Keyboard shortcut action types
- Stock adjustment record types
- Price schedule timetable element
- Price schedules
- Cost price item
- Stock item groups
- Table pictures
- Table types
- Table groups
- Software module connections
- Software module supported functionality
- Software module screen form elements
- Screen form types
- Software module keyboard model
- Software module print format types
- Software module queries
- Software module dependencies
- Required functionality of software module connected device
- Software module connected device print format types
- Software module connected device roles
- Software modules
- Software module states
- Software module variable parameters
- Employee IDs
- Employees
- Business day processing jobs
- ID groups
- Regular customer points operations
- Store period closures
- Update package specification
- Update packages
- Divisions
- Promotion category authorisation
- Day types on date
- Subscription
- Ports
- Segments
- Tables
- Note object types
- Note types
- Payment settings
- Payment methods in payment settings
- Payment setting elements
- Sales departments in payment settings
- Settings for days of the week
- Menu item IDs
- Menu item stock items
- Menu prepaid credits
- Menu items
- Menu items price schedule
- Menu item timed service
- System settings
- Stock item concurrences
- Stores
- Language packs
- Language pack specifications
- Concurrences
- ID types
- Menu modifier groups
- Menu modifiers specification
- Menu modifiers
- Restricted change of number of customers in guest tab
- Restricted change of table
- Restricted changes of guest tab promotion category
- Restricted guest tab handover
- Restricted guest tab voids
- Restricted order item voids
- Restricted payment order item voids
- Restricted order voids
- Restricted voids of timed service charge rates in orders
- Restricted timed service voids from orders
- Guest tabs of restricted voids of sending guest tabs to payment
- Restricted bill item voids
- Restricted voids of sending guest tabs to payment
- Restricted POS terminal operations
- Restricted bill reprint
- Restricted guest tab split
- Restricted prepaid credits voids from orders
- Restricted timed service split
- Seating and device layouts
- Module macros
- IDs
- Sales departments
- Regular customer groups
- POS terminal operating modes
- Promotion settings by menu group
- Promotion settings by menu item
- Promotion settings by point type
- Promotion types
- Menu item sales exclusions
- Report groups
- Stock limits
- Screen forms
- Companies
- Imported point types
- Promotion category authorisation device parameters
- Imported promotion categories
- Deletions from orders (with stock deduction)
- Stock movement records specification
- Stock movement records
- Regular customer account types