Tables of Tillypad XL Database

Chapter 31. Tables of Tillypad XL Database

Table of Contents

Addresses
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
Other alcoholic beverage suppliers
Stock item substitute specifications
Stock item replacements
Weight specifications (scale)
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
Alcoholic beverage licences
Partners
Separate divisions
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
Alcohol declaration types
Alcohol declarations
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
Account type settings
Payment authorisation device parameters
Employee information
Stock item concurrences
Butchering record specifications
Butchering records
Fiscal register types
Company types
Alcoholic beverage sorts
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

Table

Name

Description

tp_Addresses

Addresses

tp_AlcoDeclarationStates

tp_AlcoDeclarationTypes

Alcohol declaration types

Alcohol declaration types

tp_AlcoDeclarations

Alcohol declarations

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_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_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_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_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

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 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.

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_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_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

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_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

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 between stock item and 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_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_OrderPurseItems

Prepaid credits

tp_OrderPurseModes

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_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

Restricted guest tab split

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_PartnerAlcoLicenses

Alcoholic beverage licences

tp_PartnerGroups

Partner groups

Partner groups

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_ProductAlcoTypes

Alcoholic beverage sorts

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_ProductPartnerAlcoTypes

Other alcoholic beverage suppliers

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

Associate reports with software modules

Associate reports with 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 (stock items)

Sales record specifications (stock items)

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_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_StoreEngine

Cost price item

Cost price element

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_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

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_ErrorMessages

Application error messages

Application error messages

tpsys_Log

tpsys_ObjectFilterClasses

tpsys_ObjectFilterObjects

tpsys_ObjectFilterReasons

tpsys_ObjectFilterStates

tpsys_ObjectFilterTasks

tpsys_ObjectFilterTypeObjects

tpsys_ObjectFilterTypes

tpsys_ObjectGroups

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.