ordr_ID

Orders ID

ordr_gest_ID

Guest tab

Guest tab associated with the order. Link to tp_Guests (Guest tabs)

ordr_usr_ID

Employee

Employee who created the order. Link to tp_Users (Employees)

ordr_usr_ID_Operator

Operator

Employee who entered the order into the system (operator)

ordr_dev_ID

POS terminal

POS terminal on which the order was entered. Link to tp_Devices (Devices)

ordr_dvsn_ID

Division

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

ordr_arch_ID

Business day

Business day in which the order was entered. Link to tp_Archives (Business days)

ordr_sprv_ID

Promotion category

Promotion category of the order. Link to tp_SalePrivileges (Promotion categories)

ordr_orst_ID

Status

Status. Link to tp_OrderStates (Order statuses)

ordr_Date

Date

Document generation date.

ordr_Name

Number

Number Generated by the document number format.

ordr_ExternalTransactionID

External

External transaction. If = NULL, this is a normal order, which was made within the Tillypad system. If it is NOT NULL, this is an order, which was made in an external system and them imported to Tillypad