orit_ID

Order specifications ID

orit_ordr_ID

Order

Order to which the specification belongs. Link to tp_Orders (Orders)

orit_master_ID

Parent

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

orit_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 orit_mitm_ID field. Link to tp_MenuItems (Menu items)

orit_mvtp_ID

Unit (menu)

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

orit_mmgr_ID

Menu modifier group

Modifier group from which the item was selected. Command box. On the POS terminal, it is necessary for adjustment of modifiers. Link to tp_MenuModifierGroups (Menu modifier group)

orit_slgr_ID

Sales department

Sales department. Link to tp_SaleGroups (Sales departments)

orit_sprv_ID

Promotion category

Promotion category. Link to tp_SalePrivileges (Promotion categories)

orit_orpi_ID

tp_OrderPurseItems

orit_pcit_ID

Bill item

Bill item using which the order item was paid for. If it IS NULL, the order item has not been paid for. If it is NOT NULL, the item has been paid for and cannot be edited. Link to tp_PreCheckItems (Bill specification)

orit_Volume

Quantity

Menu item portion volume. Full volume = orit_Count*orit_Volume

orit_Count

Number of portions

Number of portions with the orit_Volume volume

orit_Price

Price

Price with discount Item's total = orit_Count*orit_Price Menu price without discounts or markups = orit_Price+orit_PriceDiscount-orit_PriceMargin

orit_PriceDiscount

Discount

Discount on portion price

orit_PriceMargin

Markup

Markup on portion price

orit_VAT

VAT, %

orit_PriceVAT

VAT price

orit_Course

Courses

Reference numeric value that designates in which order dishes will be served.

orit_SeatNumber

Guest number

Seat number

orit_Comment

Comment

Comment

orit_Order

Index

Ordinal number whenn adding to order.