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

Chapter 71. Tillypad XL database tables

Table of Contents

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

Table	Name	Description
tp_AccountOperationStates	Cash flow operation statuses
tp_AccountOperationTypeGroups	Cash flow item groups
tp_AccountOperationTypes	Cash flow items
tp_AccountOperations	Cash flow
tp_Accounts	Organisation accounts
tp_Addresses	Addresses
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_ArchiveStoreTasks	Business day processing jobs	Business day processing jobs
tp_Archives	Business days	Business days list
tp_AuthorizationDeviceTypes	Authorisation device types	Authorisation device types
tp_AuthorizationDevices	Authorisation devices	Authorisation devices
tp_AuthorizationOperationTypes	Authorisation operation types	Authorisation
tp_AuthorizationOperations	Authorisation operations	Authorisation operations
tp_AuthorizationPayClientPurseTypeItems	Account type settings	Account type settings
tp_AuthorizationPayClientPurseTypes	Payment authorisation device parameters	Payment authorisation device parameters
tp_AuthorizationSalePrivilegeModuleParamDiscountPointTypes	Imported point types	Imported point types
tp_AuthorizationSalePrivilegeModuleParamSalePrivileges	Imported promotion categories	Imported promotion categories
tp_AuthorizationSalePrivilegeModuleParams	Promotion category authorisation device parameters	Promotion category authorisation device parameters
tp_AutoOrderItems	Auto-orders specification	Auto-order specification - list of menu items
tp_AutoOrders	Auto-orders	Auto-order header
tp_CheckItems	Receipt sales specifications	Receipt items.
tp_CheckPayments	Receipt payment specifications	Receipt payment specification. Contains payment amount and payment methods
tp_CheckStates	Receipt statuses	Receipt statuses
tp_Checks	Receipts	Receipt. Document confirming payment of goods and services.
tp_ClientDiscountPointOperations	Regular customer points operations	Regular customer points operations
tp_ClientDiscountPointRegister	Regular customer point states	Regular customer point balances
tp_ClientGroups	Regular customer groups	Regular customer groups
tp_ClientIdentifiers	Regular customer IDs	Regular customer IDs
tp_ClientPhones	Regular customer phones	Regular customer phones (for delivery)
tp_ClientPurseOperations	Regular customer account operations	Regular customer account operations
tp_ClientPurseRegister	Regular customer account balances	Regular customer account balances
tp_ClientPurseTypes	Regular customer account types	Regular customer account types
tp_ClientPurses	Regular customer accounts	Regular customer accounts
tp_Clients	Regular customers	Regular customers
tp_CompoundDocumentItems	Production record specifications	The specification contains the compound stock items themselves and their ingredients: other stock items and semi-finished products.
tp_CompoundDocumentStates	Production document statuses	Production document statuses
tp_CompoundDocuments	Production records	Production record header
tp_CompoundItemReplacements	Stock item substition in recipe item	Stock item substition in recipe item
tp_CompoundItems	Recipe specifications	Recipe specifications
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_Compounds	Recipes	Recipes
tp_ComputerInputDevices	Computer input devices	Computer input devices
tp_Computers	Computers	Computers
tp_ConceptionItems	Conception divisions
tp_Conceptions	Conceptions	Style direction in sales
tp_DateDayTypes	Day types on date	Calendar day types
tp_DayTypeSaleRules	Sales rules by day type	Sales rules by day types
tp_DayTypeTariffs	Day type price schedules	Day type price schedules
tp_DayTypes	Day types	Day types
tp_DecomposeDocumentItems	Butchering record specifications	Butchering record specifications
tp_DecomposeDocumentStates	Butchering document statuses	Butchering document statuses
tp_DecomposeDocuments	Butchering records	Sales record header
tp_DecomposeItems	Butchering specifications	Butchering specifications
tp_Decomposes	Butchering	Butcherings
tp_Deleted	Recycle bin	Recycle bin
tp_DeliveryControlledPayTypes	Regulated payment methods
tp_DeliveryMethods	Delivery type
tp_DeliveryMoneyReceived	Payments via courier
tp_DeliveryStates	Delivery statuses
tp_DeviceAbilities	Software module functionality	Software module functionality Expandable list
tp_DeviceAbilityTypes	Software module functionality types	Software module functionality types
tp_DeviceExternalModuleParams	Additional parameters for devices	Additional device parameters
tp_DeviceFormLayouts	Device screen forms	Device screen forms
tp_DeviceOperationStates	Operation statuses by device	Device operation statuses (read-only)
tp_DevicePrintFormats	Device print formats	Device print formats
tp_DeviceQueries	Device queries	Queries for devices
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_DeviceRedirections	Device redirection settings	Device redirection settings
tp_DeviceRemoteMonitorDevices	Devices monitored via devices	Devices under surveillance by device
tp_DeviceRemoteMonitorPlaces	Tables monitored via devices	Device locations under surveillance
tp_DeviceRoleDevicePrintFormats	Connected device print formats	Connected device print formats
tp_DeviceRoleDevices	Connected devices	Connected devices
tp_DeviceSaleProperties	Device sales settings	Device sales settings
tp_DeviceValues	Variable device parameter values	Variable device parameter values
tp_Devices	Devices	Devices
tp_DiscountFunctions	Promotion formulas	Promotion formulas
tp_DiscountMenuGroups	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)
tp_DiscountMenuItems	Promotion settings by menu item	Menu items to which promotion is applied or to which promotion is not applicable (if dmit_IsExcluded = 1)
tp_DiscountPointTypes	Point types	Point types
tp_DiscountRoundTypes	Discount rounding modes
tp_DiscountTypePointTypes	Promotion settings by point type	Promotion settings by point type
tp_DiscountTypes	Promotion types	Promotion types directory
tp_DivisionCopyOptionDevices	POS terminal relationships	Device relationship for sales copying
tp_DivisionCopyOptionFiscalOperationDevices	Fiscal registration device filters for sales copying modes	Fiscal registration device filters for sales copying modes
tp_DivisionCopyOptions	Sales copying modes	Sales copying modes
tp_DivisionSaleDocumentDates
tp_DivisionSalePrivilegeDevices	Promotion category authorisation	Promotion category authorisation. Used to determine customer's promotion categories.
tp_Divisions	Divisions	Divisions
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_DocumentNameFormats	Number generators	Document number generators
tp_DocumentNamePlaceFormats	Setting options of number generators	Document number settings
tp_DocumentNamePlaces	Number format types	Document number format types
tp_Domains	Domains	Domains
tp_ExtendedMoveDocumentItems
tp_ExtendedMoveDocumentStates		Reserved
tp_ExtendedMoveDocuments
tp_ExternalModuleParams	Additional device parameters	Additional device parameters
tp_FirmGroups	Company groups	Company groups
tp_FirmTypes	Company types	Company types
tp_Firms	Companies	Companies
tp_FiscalDeviceTypes	Fiscal register types	Fiscal register types
tp_FiscalDevices	Fiscal registers	Fiscal registers
tp_FiscalOperationItems	Fiscal registration specifications	Fiscal registration specifications
tp_FiscalOperationPayments	Fiscal registration payments	Fiscal registration payments
tp_FiscalOperationTypes	Fiscal registration types	Fiscal registration types
tp_FiscalOperations	Fiscal registrations	Fiscal registrations
tp_FormPrintFormats	Screen form print layouts	Screen form print formats
tp_GuestDeliveries	Delivery
tp_GuestDeliveryStateLog	Delivery status change log
tp_GuestDiscountPointOperationTypes	Point deposit type	Point award type
tp_GuestDiscountPointOperations	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.
tp_GuestPreparations	Reservation
tp_GuestSalePrivileges	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.
tp_GuestStates	Guest tab statuses	Guest tab statuses
tp_GuestStores	Link guest tab to stores
tp_Guests	Guest tabs	Guest tab header
tp_IdentifierGroups	ID groups	ID groups
tp_IdentifierTypes	ID types	ID types
tp_Identifiers	IDs	IDs
tp_InputDocumentItems	Stock-in record specifications	Stock-in record specifications
tp_InputDocumentStates	Stock-in record statuses	Stock-in record statuses (read-only)
tp_InputDocuments	Stock-in records	Stock-in records
tp_KDSQueries	KDS queries
tp_KDSQueryTypes	KDS query types
tp_KDSStates	Order item preparation statuses	Order item preparation statuses on KDS workstations - read-only.
tp_KeyboardLayoutActionTypes	Keyboard shortcut action types	Keyboard shortcut action types
tp_KeyboardLayoutActions	Keyboard shortcut actions	Keyboard shortcut actions
tp_KeyboardLayouts	Keyboard layouts	Keyboard layouts
tp_LanguageGroups	Language packs	Language pack. Contains a list of languages in order of preference for use in the interface
tp_LanguageItems	Language pack specifications	Language pack specifications
tp_Languages	Languages	Available languages directory
tp_LicenseItems
tp_Loaders	Device loaders	Device loaders
tp_LocationMessageDevices	Employee notification devices	Employee notification devices
tp_LocationUserMessageDevices	Employee paging device	Employee paging device
tp_Locations	Locations	Locations
tp_MeasureGroups	Stock item unit of measurement groups	Stock item unit of measurement groups
tp_MeasureItems	Stock item units of measurement	Stock item units of measurement
tp_MenuDraftStates	Draft statuses	Draft statuses
tp_MenuDrafts	Drafts	Drafts
tp_MenuGroupDrafts	Draft menu groups	Draft menu groups
tp_MenuGroups	Menu groups	Menu groups
tp_MenuItemClasses	Menu item classes	Menu item classes
tp_MenuItemDrafts	Draft menu items	Draft menu items
tp_MenuItemIdentifierDrafts	Draft menu item IDs	Draft menu item IDs
tp_MenuItemIdentifiers	Menu item IDs	Menu item IDs
tp_MenuItemProductItemDrafts	Draft menu item stock items	Draft menu item stock items
tp_MenuItemProductItems	Menu item stock items	Link stock item to menu item
tp_MenuItemPurseDrafts	Draft menu prepaid credits	Draft menu prepaid credits
tp_MenuItemPurses	Menu prepaid credits
tp_MenuItemStopList	Menu item sales exclusions	Menu item sales exclusions
tp_MenuItemTariffItemDrafts	Draft menu items price schedule	Draft menu items price schedule
tp_MenuItemTariffItems	Menu items price schedule	Menu items price schedule
tp_MenuItemTime	Menu item timed service	Menu item timed service
tp_MenuItemTimeDrafts	Draft menu item timed service	Draft menu item timed service
tp_MenuItems	Menu items	Menu items
tp_MenuModifierDrafts	Draft modifiers	Draft modifiers
tp_MenuModifierGroupDrafts	Draft menu modifier groups	Draft menu modifier groups
tp_MenuModifierGroups	Menu modifier groups	Menu modifier groups
tp_MenuModifierItemDrafts	Draft modifiers specification	Draft modifiers specification
tp_MenuModifierItems	Menu modifiers specification	Menu modifiers specification
tp_MenuModifiers	Menu modifiers	Menu modifiers
tp_MenuPictureGroups	Picture group	Picture groups
tp_MenuPictures	Menu pictures	Menu pictures
tp_MenuSaleProperties	Sales parameters	Sales parameters
tp_MenuServices	Concurrences	Concurrences
tp_MenuTypes	Menu types	Menu types
tp_MenuVolumeTypeItems	Supplementary units	Quantity recalculations
tp_MenuVolumeTypes	Menu units of measurement	Menu units of measurement
tp_Messages	String values for queries
tp_ModuleDependencies	Software module connections	Software module interconnections
tp_ModuleDeviceAbilities	Software module supported functionality	Software module supported functionality
tp_ModuleFormControls	Software module screen form elements	Software module screen form items
tp_ModuleFormLayouts	Screen forms	Module screen form settings
tp_ModuleForms	Screen form types	Software module screen forms
tp_ModuleKeyboards	Software module keyboard model	Software module keyboard model
tp_ModuleMacroses	Module macros	Module macros
tp_ModulePrintFormatReasons	Software module print format types	Software module print format types
tp_ModulePrintFormats	Software module print formats	Software module print formats
tp_ModuleQueries	Software module queries	Software module queries
tp_ModuleRelations	Software module dependencies	Software module dependencies
tp_ModuleRoleDeviceAbilities	Required functionality of software module connected device	Required functionality of software module connected device
tp_ModuleRolePrintFormatReasons	Software module connected device print format types	Software module connected device print format types
tp_ModuleRoles	Software module connected device roles	Software module connected device roles
tp_ModuleStates	Software module states	Software module states
tp_ModuleTypes	Software module types	Software module types
tp_ModuleValues	Software module variable parameters	Software module variable parameters
tp_Modules	Software modules	Software modules
tp_MoveDocumentItems	Stock movement records specification	Stock movement records specification
tp_MoveDocumentStates	Stock movement record statuses	Stock movement record statuses (read-only)
tp_MoveDocuments	Stock movement records	Stock movement records
tp_NoteTypeObjects	Note object types	Note type objects
tp_NoteTypes	Note types	Note types
tp_Notes	Notes	A Note is additional information about an object.
tp_ObjectFilterTaskStates
tp_ObjectSecretLevels	Access to objects
tp_OrderItemDiscounts	Promotions on order specification item	Contains a list of the promotions applied
tp_OrderItemSalePrivileges	Order item promotion categories	Order item promotion categories
tp_OrderItems	Order items	Orders specification. Contains menu items and services included in orders for the guest tab.
tp_OrderItemsReady
tp_OrderItemsReadyLog
tp_OrderPurseItems	Prepaid credits
tp_OrderPurseModes	Bill building modes
tp_OrderSalePrivileges	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.
tp_OrderServiceData
tp_OrderServiceDataStates
tp_OrderServiceItems
tp_OrderServiceQueue
tp_OrderServiceReady	Order ready confirmations	Order ready confirmation
tp_OrderServiceReadyItems	Order ready confirmation specification	Order ready confirmation specification
tp_OrderServices
tp_OrderStates	Order statuses	Order statuses
tp_OrderTimeItemDeviceQueue
tp_OrderTimeItemDeviceQueueLog
tp_OrderTimeItemDeviceQueueStates
tp_OrderTimeItemPriceDiscounts	Promotions on timed services in order	Detailed information on promotions for the timed service item
tp_OrderTimeItemPrices	Timed services price schedule in orders	Contains billing details of timed services.
tp_OrderTimeItemSalePrivileges	Order timed services promotion categories	Order timed services promotion categories
tp_OrderTimeItems	Timed services in orders	Contains timed services in the order.
tp_Orders	Orders	Contains order headers for the guest tab.
tp_OutputDocumentItems	Stock-out records specification	Stock-out records specification
tp_OutputDocumentStates	Stock-out record statuses	Stock-out record statuses (read-only)
tp_OutputDocuments	Stock-out records	Stock-out records
tp_POSButtonFormats	On-screen button formats	On-screen button formats
tp_POSModeTypes	POS terminal operating mode types	POS terminal operating mode types
tp_POSModes	POS terminal operating modes	POS terminal operating modes
tp_POSOperationReasonTypes		Restricted operation types (read-only table)
tp_POSOperationReasons	Reasons for restricted POS terminal operations	Reasons for restricted POS terminal operations
tp_POSWatchChangeCountGuests	Restricted change of number of customers in guest tab	Restricted change of number of customers in guest tab
tp_POSWatchChangePlaceGuests	Restricted change of table	Restricted change of table
tp_POSWatchChangeSalePrivilegeGuests	Restricted changes of guest tab promotion category	Restricted changes of guest tab promotion category
tp_POSWatchChangeUserGuests	Restricted guest tab handover	Restricted guest tab handover
tp_POSWatchDeleteGuestDeliveries	Restricted delivery cancellations
tp_POSWatchDeleteGuests	Restricted guest tab voids	Restricted guest tab voids
tp_POSWatchDeleteOrderItems	Restricted order item voids	Restricted order item voids
tp_POSWatchDeleteOrderPurseItems	Restricted payment order item voids	Restricted prepayment credits voids
tp_POSWatchDeleteOrderTimeItemPrices	Restricted voids of timed service charge rates in orders	Restricted voids of timed service charge rates in orders
tp_POSWatchDeleteOrderTimeItems	Restricted timed service voids from orders	Restricted timed service voids from orders
tp_POSWatchDeleteOrders	Restricted order voids	Restricted order voids
tp_POSWatchDeletePreCheckGuests	Guest tabs of restricted voids of sending guest tabs to payment	Guest tabs of restricted voids of sending guest tabs to payment
tp_POSWatchDeletePreCheckItems	Restricted bill item voids	Restricted bill item voids
tp_POSWatchDeletePreChecks	Restricted voids of sending guest tabs to payment	Restricted voids of sending guest tabs to payment
tp_POSWatchOperations	Restricted POS terminal operations	Restricted POS terminal operations
tp_POSWatchRetryPrintPreChecks	Restricted bill reprint	Restricted bill reprint
tp_POSWatchSplitOrderItems	Restricted guest tab split/merge	Restricted guest tab split/merge
tp_POSWatchSplitOrderPurseItems	Restricted prepaid credits voids from orders
tp_POSWatchSplitOrderTimeItems	Restricted timed service split	Restricted timed service split
tp_PackageObjects	Update package specification	Update package specification
tp_Packages	Update packages	Update packages
tp_PartnerContracts	Purchase agreements
tp_PartnerGroups	Partner groups	Partner groups
tp_PartnerProductItemIdentifiers	Goods nomenclature IDs
tp_PartnerProductItems	Goods nomenclature
tp_PartnerSubsidiaries	Separate divisions
tp_Partners	Partners	Partners
tp_PayProperties	Payment settings	Payment settings
tp_PayPropertyItemPaymentTypes	Payment methods in payment settings	Payment methods in payment settings
tp_PayPropertyItemSaleGroups	Sales departments in payment settings	Sales departments in payment settings
tp_PayPropertyItemTypes
tp_PayPropertyItems	Payment setting elements	Payment setting elements
tp_PayTypeGroups	Payment method groups	Payment method groups
tp_PayTypeItems	Payment method denominations
tp_PayTypes	Payment methods	Payment methods
tp_People	Personal profile	Personal profiles
tp_PeopleGroups	Personal profile groups	Personal profile groups
tp_PlaceGroups	Table groups	Table groups
tp_PlaceJoins	Table joins	Table joins
tp_PlaceMaps	Seating and device layouts	Seating and device layouts
tp_PlaceTypePictures	Table pictures	Table pictures
tp_PlaceTypeStates	Table type statuses	Table type statuses (read-only)
tp_PlaceTypes	Table types	Table types
tp_Places	Tables	Tables
tp_PortTypes	Port types	Port types (read-only table)
tp_PreCheckItems	Bills specification	Bill specifications
tp_PreCheckStates	Bill statuses	Bill statuses (read-only)
tp_PreChecks	Bills	Bill header
tp_PrintFormats	Print layouts	Print layouts
tp_PrintTemplates	Print templates	Print templates
tp_ProductCategories	Stock item categories	Stock item categories
tp_ProductColdWastes	Cold preparation wastages	Cold preparation wastages
tp_ProductGroups	Stock item groups	Stock item groups
tp_ProductHotWastes	Cooking wastages	Cooking wastages
tp_ProductItemClasses
tp_ProductItemIdentifiers	Stock item IDs	Stock item IDs
tp_ProductItems	Stock items	Stock items
tp_ProductReplacementItems	Stock item substitute specifications	Stock item substitute specifications
tp_ProductReplacements	Stock item replacements	Stock item replacements
tp_ProductServices	Stock item concurrences	Stock item concurrences
tp_ProductTypes	Stock item types	Stock item types
tp_ProductWeightItems	Weight specifications (scale)	Weight specifications
tp_ProductWeights	Stock item weights	Stock item weight
tp_ReadOnlyObjects		Read-only elements list (switch System parameter)
tp_ReportGroups	Report groups	Report groups
tp_ReportModules	Link reports to software modules	Link reports to software modules
tp_ReportTypes
tp_Reports	Reports	Reports
tp_ReturnDocumentItems	Return delivery note specification items	Return delivery note specification items
tp_ReturnDocumentStates	Return delivery notes statuses	Return delivery notes statuses
tp_ReturnDocuments	Return delivery notes	Return delivery notes
tp_SaleDocumentItems	Sales record specifications	Sales record specifications
tp_SaleDocumentOrderItems	Orders included in sales record	Orders included in sales record
tp_SaleDocumentStates	Sales record statuses	Sales record statuses (read-only)
tp_SaleDocumentVoidOrderItems	Deletions (with stock deduction) entered into sales records	Deletions (with stock deduction) included in the sales record
tp_SaleDocuments	Sales records	Sales records
tp_SaleGroups	Sales departments	Sales departments
tp_SalePrivilegeRuleIntervals	Interval and sales rule settings	Interval and sales rules settings
tp_SalePrivileges	Promotion categories	Promotion categories
tp_SaleProperties	Sales settings	Sales settings
tp_SalePropertyItemServicePrinters	Sales setting element printers	Sales setting element printers
tp_SalePropertyItems	Sales setting elements	Sales setting elements
tp_SaleRuleIntervals	Sales rules intervals	Sales rules intervals
tp_SaleRules	Sales rules	Sales rules
tp_SecretGroups	Privilege groups	Privilege groups
tp_SecretItemDependencies
tp_SecretItems	Privileges	Privileges
tp_SecretLevels	Security levels	Security levels.
tp_SecretPatterns	Employee privilege sets	Employee privilege sets
tp_SegmentCommittedObjectFilters
tp_SegmentObjectFilterTasks
tp_SegmentObjectFilters	Subscription	Subscription
tp_SegmentPorts	Ports	Ports
tp_Segments	Segments	Segments
tp_ServicePrinterSaleFormatSplitModes	Order form building mode
tp_Sexes	Gender	Gender
tp_StoreArchives	Store period closures	Store period closures
tp_StoreConsumptionDocumentTypes	Document types for calculating standard daily consumption rates
tp_StoreDocumentTimeSettings	Document filing time
tp_StoreEngine	Cost price item	Cost price item
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_StoreExperimentItemSteps	Development record results	Stock item consumptions in development record
tp_StoreExperimentItems	Development record specifications	Specification of stock items used in developing the recipe.
tp_StoreExperimentStates	Development record statuses	Development record statuses (read-only)
tp_StoreExperimentSteps	Development record experiments	Development record experiments
tp_StoreExperiments	Development records	Development record header
tp_StoreGroupInputPriceDates
tp_StoreGroupInputPrices	Purchase cost by store groups	Store group purchase prices
tp_StoreGroupPlanPriceItems	Planned cost record specifications	Planned cost record specifications
tp_StoreGroupPlanPriceStates
tp_StoreGroupPlanPrices	Planned cost records	Planned cost records
tp_StoreGroups	Store groups	Store groups
tp_StoreInventories	Stocktaking records	Stocktaking record header
tp_StoreInventoryItems	Stocktaking record collation reports	Stocktaking record collation report. Lists the actual count of stock-on hand
tp_StoreInventoryStates	Stocktaking record statuses	Stocktaking record statuses (read-only)
tp_StoreInventoryWriteOffItems	Stocktaking record specifications	Stocktaking record specifications
tp_StoreLimits	Stock limits	Stock limits
tp_StoreProductServices	Stock item concurrences	Stock item concurrences
tp_StoreRegister	Stock on hand	Stock on hand
tp_StoreRequestItemInputDocumentItems	Supplier requests included in the stock-in records
tp_StoreRequestItemLinks	Original requests included in the supplier request
tp_StoreRequestItemStates
tp_StoreRequestItems	Request specification
tp_StoreRequestStates	Purchase request statuses	Purchase request statuses - read-only
tp_StoreRequestTypes	Purchase request types	Purchase request types - read-only
tp_StoreRequests	Requests
tp_Stores	Stores	Stores
tp_SystemConstants	System settings	System settings
tp_TariffGroups	Price schedule groups	Price schedule groups
tp_TariffItems	Price schedule timetable element	Price schedule timetable element
tp_Tariffs	Price schedules	Price schedules
tp_TaskLog
tp_TaskSchedules	Task schedule	Task schedule
tp_TaskTypes	Task types	Task types
tp_Tasks	Tasks	Custom tasks There also exist system tasks which you can check by running the procedure tpsrv_SelectTasks
tp_UserIdentifiers	Employee IDs	Employee IDs
tp_UserLocationPresence	Timesheet entry	Timesheet entry
tp_UserProperties	Employee information	Employee's personal settings
tp_UserPropertyTypes
tp_UserRolePermissions	Access settings	Access settings
tp_UserRoleSecretLevels
tp_UserRoles	User roles	User roles
tp_Users	Employees	Employees
tp_VAT	VAT rates
tp_ValueDataTypes
tp_VoidOrderItemStores	Link deletions from orders (with stock deduction) to stores
tp_VoidOrderItems	Deletions from orders (with stock deduction)	Deletions from orders (with stock deduction)
tp_WeekDayTypes	Settings for days of the week	Settings for days of the week
tp_WeekDays	Days of the week	Days of the week
tp_WriteOffDocumentItems	Stock adjustment record specifications	Stock adjustment record specifications
tp_WriteOffDocumentStates	Stock adjustment record statuses	Stock adjustment record statuses
tp_WriteOffDocumentTypes	Stock adjustment record types	Stock adjustment record types
tp_WriteOffDocuments	Stock adjustment records	Stock adjustment records
tplog_Queries
tplog_QueryItemTypes
tplog_QueryItems
tpsrv_Constants	Application settings	Segment settings
tpsrv_ObjectDefinitions
tpsrv_Programs	Programs	Programmes
tpsys_Captions
tpsys_DeferredLog
tpsys_DomainDeferredLog
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_ObjectInstanceReferences
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.