gest_ID

Guest tabs ID

gest_dvsn_ID

Division

Division in which the guest tab was created. Link to tp_Divisions (Divisions)

gest_sprv_ID

Promotion category

Promotion category. A guest tab can have one or more promotion categories. This is the primary promotion category, it determines the status of the client. see gest_dev_ID_SalePrivilege tp_GuestSalePrivileges Link to tp_SalePrivileges (Promotion categories)

gest_clnt_ID

Regular customer

Regular customer if the regular customer is authorised through the Tillypad athorisation. The field = NULL either if the regular customer is a client of an external system (in this case the gest_ClientName is populated) or if the guest is not a regular customer (in this case the gest_ClientName field = NULL) Link to tp_Clients (Regular customers)

gest_idnt_ID

ID

ID. Link to tp_Identifiers (IDs)

gest_usr_ID

Employee

Employee responsible for the guest tab. Link to tp_Users (Employees)

gest_dev_ID

POS terminal

POS terminal in which the guest tab was opened. Link to tp_Devices (Devices)

gest_plac_ID

Table

Table. If specified, the gest_PlaceNumber field is ignored. Link to tp_Places (Tables)

gest_lggr_ID

Language pack

Language pack. Link to tp_LanguageGroups (Language packs)

gest_gsst_ID

Guest tab status

Guest tab status. Link to tp_GuestStates (Guest tab statuses)

gest_dev_ID_SalePrivilege

External client authorisation device

Device that authorised the regular customer. see gest_clnt_ID gest_ClientName

gest_DateOpen

Open date

Open date

gest_DateClose

Close date

Close date

gest_Name

Number

Number Generated by the document number format.

gest_ClientName

Regular customer name

Regular customer name. If the regular customer is a Tillypad client, the name matches the client's ID (gest_clnt_ID) during authorisation. If the regular customer is an external client, the gest_clnt_ID field = NULL see gest_dev_ID_SalePrivilege gest_clnt_ID

gest_ClientPhone

Regular customer phone number

gest_ClientEMail

Regular customer e-mail address

gest_ClientAddress

Regular customer address

gest_PlaceNumber

Table number

Table number Number of a virtual table that does not exist in the Tables directory Can be used to group or mark guest tabs.

gest_Count

Number of customers

Number of persons in the guest tab

gest_SalePrivilegeData

gest_InformationTransactionID

Notification

ID for: Guest tab notification transaction. If the guest tab is authorised as a regular customer, and gest_dev_ID_Authorization IS NOT NULL, the authorisation device will receive information about this guest tab in the corresponding notification format when this tab will be closed. In order to ensure the delivery of the information to the external system even despite interruptions in the operation of the authorisation device or its restart, the guest tab stores the notification transaction ID.

gest_Comment

Comment

Comment