Field

Description

Version

TYPE

The type of record ('0' for a normal sale, '1' for a refund, ‘2’ for a revenue item, ‘3’ for a refunded revenue item)

-

EMPLOYEE

Employee ID who sold the item, but not necessarily the employee who closed the check.

-

CHECK

Check number

-

ITEM

Item ID

-

PARENT

Item ID number of the parent item if this item acted as a modifier

-

CATEGORY

Sales category ID

-

MODE

Order mode ID

-

PERIOD

Period ID

-

HOUR

Transaction hour

-

MINUTE

Transaction minute

-

TAXID

Tax ID

-

REVID

Revenue center ID assigned to the check

-

TERMID

Terminal ID

-

MENU

Menu ID

-

ORIGIN

Submenu ID or modifier menu ID

-

PRICE

Price

-

MODCODE

Modifier Code ID (Aloha Manager\Maintenance\Menu\Modifier Codes)

-

DOB

Date Of Business

-

SYSDATE

System date

5.3.21e

UNIT     

Unit ID (from the ALOHA.INI)

-

SEAT

If pivot seating is used, the seat number the item was ordered from

-

ENTRY ID

A unique entry ID generated by the Front-of-House (FOH)

-

OCCASION

Event ID (SuperSite)

-

QUANTITY

Item quantity, usually one.  Check with the QTYPRICE.DBF file to see if this item affects inventory.  If items do not have a QTYPRICE.DBF item associated with them, then inventory should assume that the item does affect inventory.

5.2

TAXID2

Secondary tax ID

5.2

DISCPRICE

Reduced price at which item was sold

5.2

REVID2

Revenue center from which item was ordered

5.2

CONCEPT

Concept from which item was ordered, if any

5.2

INCLTAX

Inclusive tax

5.2

COURSE

Course number. (QS will always be 0.)

6.1

BOHNAME

Control Name (Aloha Manager\Maintenance\Menu\Items\Control Name)

6.1

BOHNAMEPRN

Control Name of PARENT item

6.1

MODFUNC

Function that has been applied to MODCODE (see MODFUNC Types table)

6.2

QCID

QS Quick Combo ID

6.2

EXCLTAX

Exclusive Tax – To check for Tax Exempt before putting on the report

6.3

PARENTMOD

Item ID number of the immediate parent item if this item acted as a modifier.

6.4

ETIME_HOUR

The Hour an Item was added to the guest check

6.4

ETIME_MIN

The Minute an Item was added to the guest check

6.4

ETIME_SEC

The Second an Item was added to the guest check

6.4

TABLEID

A unique table ID generated by the FOH

6.4

Type

Description

0

Modifier code not used

1

WITH modifier code

5

MESSAGE modifier code (use internally)

6

SUBSTITUTE modifier code

7

FOR modifier code (use internally)

8

DELETED modifier code

11

INACTIVE modifier code (use internally)

12

PRINTED DELETED modifier code

13

CANCELED modifier code (use internally)