orti_ID

ID for: Timed services in orders

orti_ordr_ID

Order

Order. Link to tp_Orders (Orders)

orti_master_ID

Master record. If = NULL, the item has no master record, i.e. it is not a modifier. If it is NOT NULL, the item is a modifier. The master record can be in both the tp_OrderItems and tp_OrderTimeItems tables

orti_plac_ID

Table

Table. Link to tp_Places (Tables)

orti_mitm_ID

Menu item

Menu item. If the menu item was added to the order using a shortcut, here you will find a menu item, to which the shortcut is linked. The shortcut itself is stored in the orti_mitm_ID field. Link to tp_MenuItems (Menu items)

orti_mvtp_ID

Unit (menu)

Unit of measurement for menu quantity. Link to tp_MenuVolumeTypes (Menu units of measurement)

orti_mmgr_ID

Menu modifier group

Modifier group if the item was sold as a modifier. Link to tp_MenuModifierGroups (Menu modifier group)

orti_slgr_ID

Sales department

Sales department. Link to tp_SaleGroups (Sales departments)

orti_sprv_ID

Promotion category

Primary promotion category for this service. May be on or more. For more information on other promotion categories, refer to tp_OrderTimeItemSalePrivileges Link to tp_SalePrivileges (Promotion categories)

orti_orpi_ID

tp_OrderPurseItems

orti_pcit_ID

Bill item. NULL if the service has not been paid for. Link to tp_PreCheckItems (Bill specification)

orti_DateBegin

Start date

Service start

orti_Volume

Quantity

Timed service quantity.

orti_SeatNumber

Seat number

???

orti_Comment

Comment

Comment

orti_Order

Index

Ordinal number of the service