Part VIII. Tillypad XL database description
Prev		Next

Tillypad XL database description

>

© Tillypad, 2008-2016

Part VIII. Tillypad XL database description

This section contains descriptions of Tillypad XL objects and database tables.

Table of Contents

39. Tillypad XL objects

40. Tillypad XL database tables

Addresses
Table tp_AlcoDeclarationStates
Table tp_Aligns
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
Table tp_DeliveryMethods
Table tp_DeliveryStates
Software module functionality
Software module functionality types
Operation statuses by device
Jobs in device queue
Table tp_DeviceQueueLog
Job statuses in device queue
Table tp_DiscountRoundTypes
Table tp_DivisionSaleDocumentDates
Counters of number generators
Number format types
Table tp_ExtendedMoveDocumentStates
Fiscal registration types
Point deposit type
Guest tab statuses
Stock-in record statuses
Order item preparation statuses
Languages
Table tp_LicenseItems
Draft statuses
Table tp_MenuItemClasses
String values for queries
Software module types
Stock movement record statuses
Notes
Table tp_ObjectFilterTaskStates
Access to objects
Table tp_OrderPurseModes
Table tp_OrderServiceData
Table tp_OrderServiceDataStates
Table tp_OrderServiceItems
Table tp_OrderServiceQueue
Table tp_OrderServices
Order statuses
Table tp_OrderTimeItemDeviceQueue
Table tp_OrderTimeItemDeviceQueueLog
Table tp_OrderTimeItemDeviceQueueStates
Stock-out record statuses
Table tp_PayPropertyItemTypes
Table type statuses
Port types
POS terminal operating mode types
Table tp_POSOperationReasonTypes
Bill statuses
Print layouts
Table tp_ProductItemClasses
Table tp_ReadOnlyObjects
Table tp_ReportTypes
Return delivery notes statuses
Sales record statuses
Privilege groups
Table tp_SecretItemDependencies
Privileges
Table tp_SegmentCommittedObjectFilters
Table tp_SegmentObjectFilterTasks
Order form building mode
Gender
Table tp_StoreEngineDocumentQueue
Table tp_StoreEngineDocumentTypes
Table tp_StoreEngineItemQueue_1
Table tp_StoreEngineItemQueue_3
Table tp_StoreEngineItemQueue_4
Errors processing store documents
Store document processing statuses
Development record statuses
Table tp_StoreGroupInputPriceDates
Table tp_StoreGroupPlanPriceStates
Stocktaking record statuses
Table tp_StoreRequestItemStates
Table tp_StoreRequestStates
Table tp_StoreRequestTypes
Table tp_TaskLog
Tasks
Task schedule
Table tp_UserPropertyTypes
Table tp_UserRoleSecretLevels
Table tp_ValueDataTypes
Days of the week
Stock adjustment record statuses
Table tplog_Queries
Table tplog_QueryItems
Table tplog_QueryItemTypes
Application settings
Table tpsrv_ObjectDefinitions
Programs
Table tpsys_Captions
Table tpsys_DeferredLog
Application error messages
Table tpsys_Log
Table tpsys_ObjectFilterClasses
Table tpsys_ObjectFilterObjects
Table tpsys_ObjectFilterReasons
Table tpsys_ObjectFilterStates
Table tpsys_ObjectFilterTypeObjects
Table tpsys_ObjectFilterTypes
Table tpsys_ObjectGroups
Table tpsys_ObjectInstances
Replication objects
Table tpsys_SystemQueries
Application table fields
Application tables
Business days
Picture group
Domains
Regular customers
Store groups
Regular customer account operations
Stock items
Keyboard layouts
Bills
Order ready confirmations
KDS queries
Personal profile
Recycle bin
Setting options of number generators
Table joins
Partners
Print templates
Authorisation devices
Company groups
Drafts
Production records
Promotion formulas
Partner groups
Planned cost records
Authorisation device types
Computers
Stock-in records
Reasons for restricted POS terminal operations
Stock-out records
Sales copying modes
Stock item categories
Sales settings
Development records
Software module print formats
Menu pictures
Guest tabs
Additional device parameters
Employee paging device
Keyboard shortcut actions
Menu units of measurement
VAT rates
Stock adjustment records
User roles
Stocktaking records
Stock item units of measurement
Reports
Payment method groups
Auto-orders
On-screen button formats
Number generators
Sales parameters
Screen form print layouts
Payments via courier
Menu groups
Timesheet entry
Return delivery notes
Authorisation operations
Device loaders
Promotion categories
Menu types
Table tp_OrderItemsReady
Alcohol declaration types
Alcohol declarations
Point types
Locations
Price schedule groups
Day types
Sales records
Payment methods
Payment authorisation device parameters
Employee information
Stock item concurrences
Butchering records
Fiscal register types
Company types
Alcoholic beverage sorts
Employee privilege sets
Task types
Fiscal registers
Stock on hand
Sales rules
Table tp_ExtendedMoveDocuments
Stock item types
Security levels
Fiscal registrations
Devices
Personal profile groups
Stock item unit of measurement groups
Keyboard shortcut action types
Stock adjustment record types
Price schedules
Cost price item
Stock item groups
Table types
Table groups
Software modules
Employees
Business day processing jobs
ID groups
Regular customer points operations
Store period closures
Update packages
Divisions
Day types on date
Requests
Segments
Tables
Note types
Payment settings
Settings for days of the week
Menu items
System settings
Stores
Language packs
Concurrences
ID types
Menu modifiers
Restricted POS terminal operations
Seating and device layouts
KDS query types
Module macros
IDs
Sales departments
Regular customer groups
POS terminal operating modes
Promotion types
Menu item sales exclusions
Report groups
Stock limits
Screen forms
Companies
Promotion category authorisation device parameters
Deletions from orders (with stock deduction)
Stock movement records
Regular customer account types
Regular customer IDs
Regular customer phones
Regular customer accounts
Purchase cost by store groups
Stock item substition in recipe item
Recipe specifications
Recipes
Butchering specifications
Butchering
Cold preparation wastages
Cooking wastages
Stock item IDs
Other alcoholic beverage suppliers
Stock item substitute specifications
Stock item replacements
Weight specifications (scale)
Stock item weights
Receipt sales specifications
Receipt payment specifications
Receipts
Bills specification
Order ready confirmation specification
Alcoholic beverage licences
Purchase agreements
Goods nomenclature IDs
Goods nomenclature
Separate divisions
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
Planned cost record specifications
Computer input devices
Stock-in record specifications
Stock-out records specification
POS terminal relationships
Fiscal registration device filters for sales copying modes
Sales setting elements
Sales setting element printers
Development record specifications
Development record results
Development record experiments
Delivery
Delivery status change log
Guest tab points operations
Reservation
Promotion categories of the guest tab
Link guest tab to stores
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
Supplementary units
Stock adjustment record specifications
Access settings
Stocktaking record collation reports
Stocktaking record specifications
Link reports to software modules
Auto-orders specification
Return delivery note specification items
Table tp_OrderItemsReadyLog
Employee notification devices
Sales rules by day type
Day type price schedules
Sales record specifications
Orders included in sales record
Deletions (with stock deduction) entered into sales records
Payment method denominations
Account type settings
Butchering record specifications
Interval and sales rule settings
Sales rules intervals
Table tp_ExtendedMoveDocumentItems
Fiscal registration specifications
Fiscal registration payments
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
Device sales settings
Variable device parameter values
Price schedule timetable element
Table pictures
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 module states
Software module variable parameters
Employee IDs
Update package specification
Promotion category authorisation
Supplier requests included in the stock-in records
Original requests included in the supplier request
Request specification
Subscription
Ports
Note object types
Payment methods in payment settings
Payment setting elements
Sales departments in payment settings
Menu item IDs
Menu item stock items
Menu prepaid credits
Menu items price schedule
Menu item timed service
Document types for calculating standard daily consumption rates
Document filing time
Stock item concurrences
Language pack specifications
Menu modifier groups
Menu modifiers specification
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 delivery cancellations
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 bill reprint
Restricted guest tab split/merge
Restricted prepaid credits voids from orders
Restricted timed service split
Promotion settings by menu group
Promotion settings by menu item
Promotion settings by point type
Imported point types
Imported promotion categories
Link deletions from orders (with stock deduction) to stores
Stock movement records specification