Chapter 40. Tillypad XL database tables
Prev	Part VIII. Tillypad XL database description	Next

Tillypad XL database tables

> >

Chapter 40. Tillypad XL database tables

Table of Contents

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

Table	Name	Description
tp_Addresses	Addresses
tp_AlcoDeclarationStates
tp_Aligns
tp_ArchiveStates	Business day statuses	Business day statuses (read-only)
tp_ArchiveStoreTaskErrors	Store period closure errors	Store period closure errors operational report
tp_AuthorizationOperationTypes	Authorisation operation types	Authorisation
tp_CheckStates	Receipt statuses	Receipt statuses
tp_ClientDiscountPointRegister	Regular customer point states	Regular customer point balances
tp_ClientPurseRegister	Regular customer account balances	Regular customer account balances
tp_CompoundDocumentStates	Production document statuses	Production document statuses
tp_CompoundModes	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.
tp_DecomposeDocumentStates	Butchering document statuses	Butchering document statuses
tp_DeliveryMethods
tp_DeliveryStates
tp_DeviceAbilities	Software module functionality	Software module functionality Expandable list
tp_DeviceAbilityTypes	Software module functionality types	Software module functionality types
tp_DeviceOperationStates	Operation statuses by device	Device operation statuses (read-only)
tp_DeviceQueue	Jobs in device queue	Device job queue
tp_DeviceQueueLog		Execution log in device queue
tp_DeviceQueueStates	Job statuses in device queue	Job statuses in device queue
tp_DiscountRoundTypes
tp_DivisionSaleDocumentDates
tp_DocumentNameFormatCounters	Counters of number generators	Counter ID Counters can be associated with several IDs (ID1-ID4). Let's take stock-in record as an example. If separate numbering settings are required for each partner and each store, both the partner ID and the store ID must be saved. If numbering is required only for the store, the partner ID does not need to be saved.
tp_DocumentNamePlaces	Number format types	Document number format types
tp_ExtendedMoveDocumentStates		Reserved
tp_FiscalOperationTypes	Fiscal registration types	Fiscal registration types
tp_GuestDiscountPointOperationTypes	Point deposit type	Point award type
tp_GuestStates	Guest tab statuses	Guest tab statuses
tp_InputDocumentStates	Stock-in record statuses	Stock-in record statuses (read-only)
tp_KDSStates	Order item preparation statuses	Order item preparation statuses on KDS workstations - read-only.
tp_Languages	Languages	Available languages directory
tp_LicenseItems
tp_MenuDraftStates	Draft statuses	Draft statuses
tp_MenuItemClasses
tp_Messages	String values for queries
tp_ModuleTypes	Software module types	Software module types
tp_MoveDocumentStates	Stock movement record statuses	Stock movement record statuses (read-only)
tp_Notes	Notes	A Note is additional information about an object.
tp_ObjectFilterTaskStates
tp_ObjectSecretLevels	Access to objects
tp_OrderPurseModes
tp_OrderServiceData
tp_OrderServiceDataStates
tp_OrderServiceItems
tp_OrderServiceQueue
tp_OrderServices
tp_OrderStates	Order statuses	Order statuses
tp_OrderTimeItemDeviceQueue
tp_OrderTimeItemDeviceQueueLog
tp_OrderTimeItemDeviceQueueStates
tp_OutputDocumentStates	Stock-out record statuses	Stock-out record statuses (read-only)
tp_PayPropertyItemTypes
tp_PlaceTypeStates	Table type statuses	Table type statuses (read-only)
tp_PortTypes	Port types	Port types (read-only table)
tp_POSModeTypes	POS terminal operating mode types	POS terminal operating mode types
tp_POSOperationReasonTypes		Restricted operation types (read-only table)
tp_PreCheckStates	Bill statuses	Bill statuses (read-only)
tp_PrintFormats	Print layouts	Print layouts
tp_ProductItemClasses
tp_ReadOnlyObjects		Read-only elements list (switch System parameter)
tp_ReportTypes
tp_ReturnDocumentStates	Return delivery notes statuses	Return delivery notes statuses
tp_SaleDocumentStates	Sales record statuses	Sales record statuses (read-only)
tp_SecretGroups	Privilege groups	Privilege groups
tp_SecretItemDependencies
tp_SecretItems	Privileges	Privileges
tp_SegmentCommittedObjectFilters
tp_SegmentObjectFilterTasks
tp_ServicePrinterSaleFormatSplitModes	Order form building mode
tp_Sexes	Gender	Gender
tp_StoreEngineDocumentQueue
tp_StoreEngineDocumentTypes		Store document types
tp_StoreEngineItemQueue_1		?
tp_StoreEngineItemQueue_3
tp_StoreEngineItemQueue_4
tp_StoreEngineResultCodes	Errors processing store documents	Storekeeping system document processing errors directory
tp_StoreEngineStates	Store document processing statuses	Document processing status (read-only)
tp_StoreExperimentStates	Development record statuses	Development record statuses (read-only)
tp_StoreGroupInputPriceDates
tp_StoreGroupPlanPriceStates
tp_StoreInventoryStates	Stocktaking record statuses	Stocktaking record statuses (read-only)
tp_StoreRequestItemStates
tp_StoreRequestStates
tp_StoreRequestTypes
tp_TaskLog
tp_Tasks	Tasks	Custom tasks There also exist system tasks which you can check by running the procedure tpsrv_SelectTasks
tp_TaskSchedules	Task schedule	Task schedule
tp_UserPropertyTypes
tp_UserRoleSecretLevels
tp_ValueDataTypes
tp_WeekDays	Days of the week	Days of the week
tp_WriteOffDocumentStates	Stock adjustment record statuses	Stock adjustment record statuses
tplog_Queries
tplog_QueryItems
tplog_QueryItemTypes
tpsrv_Constants	Application settings	Segment settings
tpsrv_ObjectDefinitions
tpsrv_Programs	Programs	Programmes
tpsys_Captions
tpsys_DeferredLog
tpsys_ErrorMessages	Application error messages	Application error messages
tpsys_Log
tpsys_ObjectFilterClasses
tpsys_ObjectFilterObjects
tpsys_ObjectFilterReasons
tpsys_ObjectFilterStates
tpsys_ObjectFilterTypeObjects
tpsys_ObjectFilterTypes
tpsys_ObjectGroups
tpsys_ObjectInstances
tpsys_Objects	Replication objects	Replication objects
tpsys_SystemQueries
tpsys_TableFields	Application table fields	Application table fields
tpsys_Tables	Application tables	List of all database tables.
tp_Archives	Business days	Business days list
tp_MenuPictureGroups	Picture group	Picture groups
tp_Domains	Domains	Domains
tp_Clients	Regular customers	Regular customers
tp_StoreGroups	Store groups	Store groups
tp_ClientPurseOperations	Regular customer account operations	Regular customer account operations
tp_ProductItems	Stock items	Stock items
tp_KeyboardLayouts	Keyboard layouts	Keyboard layouts
tp_PreChecks	Bills	Bill header
tp_OrderServiceReady	Order ready confirmations	Order ready confirmation
tp_KDSQueries	KDS queries
tp_People	Personal profile	Personal profiles
tp_Deleted	Recycle bin	Recycle bin
tp_DocumentNamePlaceFormats	Setting options of number generators	Document number settings
tp_PlaceJoins	Table joins	Table joins
tp_Partners	Partners	Partners
tp_PrintTemplates	Print templates	Print templates
tp_AuthorizationDevices	Authorisation devices	Authorisation devices
tp_FirmGroups	Company groups	Company groups
tp_MenuDrafts	Drafts	Drafts
tp_CompoundDocuments	Production records	Production record header
tp_DiscountFunctions	Promotion formulas	Promotion formulas
tp_PartnerGroups	Partner groups	Partner groups
tp_StoreGroupPlanPrices	Planned cost records	Planned cost records
tp_AuthorizationDeviceTypes	Authorisation device types	Authorisation device types
tp_Computers	Computers	Computers
tp_InputDocuments	Stock-in records	Stock-in records
tp_POSOperationReasons	Reasons for restricted POS terminal operations	Reasons for restricted POS terminal operations
tp_OutputDocuments	Stock-out records	Stock-out records
tp_DivisionCopyOptions	Sales copying modes	Sales copying modes
tp_ProductCategories	Stock item categories	Stock item categories
tp_SaleProperties	Sales settings	Sales settings
tp_StoreExperiments	Development records	Development record header
tp_ModulePrintFormats	Software module print formats	Software module print formats
tp_MenuPictures	Menu pictures	Menu pictures
tp_Guests	Guest tabs	Guest tab header
tp_ExternalModuleParams	Additional device parameters	Additional device parameters
tp_LocationUserMessageDevices	Employee paging device	Employee paging device
tp_KeyboardLayoutActions	Keyboard shortcut actions	Keyboard shortcut actions
tp_MenuVolumeTypes	Menu units of measurement	Menu units of measurement
tp_VAT	VAT rates
tp_WriteOffDocuments	Stock adjustment records	Stock adjustment records
tp_UserRoles	User roles	User roles
tp_StoreInventories	Stocktaking records	Stocktaking record header
tp_MeasureItems	Stock item units of measurement	Stock item units of measurement
tp_Reports	Reports	Reports
tp_PayTypeGroups	Payment method groups	Payment method groups
tp_AutoOrders	Auto-orders	Auto-order header
tp_POSButtonFormats	On-screen button formats	On-screen button formats
tp_DocumentNameFormats	Number generators	Document number generators
tp_MenuSaleProperties	Sales parameters	Sales parameters
tp_FormPrintFormats	Screen form print layouts	Screen form print formats
tp_DeliveryMoneyReceived	Payments via courier
tp_MenuGroups	Menu groups	Menu groups
tp_UserLocationPresence	Timesheet entry	Timesheet entry
tp_ReturnDocuments	Return delivery notes	Return delivery notes
tp_AuthorizationOperations	Authorisation operations	Authorisation operations
tp_Loaders	Device loaders	Device loaders
tp_SalePrivileges	Promotion categories	Promotion categories
tp_MenuTypes	Menu types	Menu types
tp_OrderItemsReady
tp_AlcoDeclarationTypes	Alcohol declaration types	Alcohol declaration types
tp_AlcoDeclarations	Alcohol declarations
tp_DiscountPointTypes	Point types	Point types
tp_Locations	Locations	Locations
tp_TariffGroups	Price schedule groups	Price schedule groups
tp_DayTypes	Day types	Day types
tp_SaleDocuments	Sales records	Sales records
tp_PayTypes	Payment methods	Payment methods
tp_AuthorizationPayClientPurseTypes	Payment authorisation device parameters	Payment authorisation device parameters
tp_UserProperties	Employee information	Employee's personal settings
tp_ProductServices	Stock item concurrences	Stock item concurrences
tp_DecomposeDocuments	Butchering records	Sales record header
tp_FiscalDeviceTypes	Fiscal register types	Fiscal register types
tp_FirmTypes	Company types	Company types
tp_ProductAlcoTypes	Alcoholic beverage sorts
tp_SecretPatterns	Employee privilege sets	Employee privilege sets
tp_TaskTypes	Task types	Task types
tp_FiscalDevices	Fiscal registers	Fiscal registers
tp_StoreRegister	Stock on hand	Stock on hand
tp_SaleRules	Sales rules	Sales rules
tp_ExtendedMoveDocuments
tp_ProductTypes	Stock item types	Stock item types
tp_SecretLevels	Security levels	Security levels.
tp_FiscalOperations	Fiscal registrations	Fiscal registrations
tp_Devices	Devices	Devices
tp_PeopleGroups	Personal profile groups	Personal profile groups
tp_MeasureGroups	Stock item unit of measurement groups	Stock item unit of measurement groups
tp_KeyboardLayoutActionTypes	Keyboard shortcut action types	Keyboard shortcut action types
tp_WriteOffDocumentTypes	Stock adjustment record types	Stock adjustment record types
tp_Tariffs	Price schedules	Price schedules
tp_StoreEngine	Cost price item	Cost price element
tp_ProductGroups	Stock item groups	Stock item groups
tp_PlaceTypes	Table types	Table types
tp_PlaceGroups	Table groups	Table groups
tp_Modules	Software modules	Software modules
tp_Users	Employees	Employees
tp_ArchiveStoreTasks	Business day processing jobs	Business day processing jobs
tp_IdentifierGroups	ID groups	ID groups
tp_ClientDiscountPointOperations	Regular customer points operations	Regular customer points operations
tp_StoreArchives	Store period closures	Store period closures
tp_Packages	Update packages	Update packages
tp_Divisions	Divisions	Divisions
tp_DateDayTypes	Day types on date	Calendar day types
tp_StoreRequests	Requests
tp_Segments	Segments	Segments
tp_Places	Tables	Tables
tp_NoteTypes	Note types	Note types
tp_PayProperties	Payment settings	Payment settings
tp_WeekDayTypes	Settings for days of the week	Settings for days of the week
tp_MenuItems	Menu items	Menu items
tp_SystemConstants	System settings	System settings
tp_Stores	Stores	Stores
tp_LanguageGroups	Language packs	Language pack. Contains a list of languages in order of preference for use in the interface
tp_MenuServices	Concurrences	Concurrences
tp_IdentifierTypes	ID types	ID types
tp_MenuModifiers	Menu modifiers	Menu modifiers
tp_POSWatchOperations	Restricted POS terminal operations	Restricted POS terminal operations
tp_PlaceMaps	Seating and device layouts	Seating and device layouts
tp_KDSQueryTypes	KDS query types
tp_ModuleMacroses	Module macros	Module macros
tp_Identifiers	IDs	IDs
tp_SaleGroups	Sales departments	Sales departments
tp_ClientGroups	Regular customer groups	Regular customer groups
tp_POSModes	POS terminal operating modes	POS terminal operating modes
tp_DiscountTypes	Promotion types	Promotion types directory
tp_MenuItemStopList	Menu item sales exclusions	Menu item sales exclusions
tp_ReportGroups	Report groups	Report groups
tp_StoreLimits	Stock limits	Stock limits
tp_ModuleFormLayouts	Screen forms	Module screen form settings
tp_Firms	Companies	Companies
tp_AuthorizationSalePrivilegeModuleParams	Promotion category authorisation device parameters	Promotion category authorisation device parameters
tp_VoidOrderItems	Deletions from orders (with stock deduction)	Deletions from orders (with stock deduction)
tp_MoveDocuments	Stock movement records	Stock movement records
tp_ClientPurseTypes	Regular customer account types	Regular customer account types