Network Management

Power and Cabling

Interfaces

Data Security

eAlerts

IT Services

Home

Aloha GNDSALE.DBF Grind File Contents

This file contains sales information.

Field Description Version
EMPLOYEE Employee ID who closed the check, but not necessarily the employee who sold the items.  -
CHECK Check number -
PERIOD Period ID -
TYPE Sales type (see the GNDSALE.DBF Type Constants table) -
TYPEID ID associated with TYPE, if any -
AMOUNT Amount -
OPENHOUR Hour the check was opened -
OPENMIN Minute the check was opened -
ORDERHOUR Hour when the first item on this check was ordered -
ORDERMIN Minute when the first item on this check was ordered -
CLOSEHOUR Hour the check was closed -
CLOSEMIN Minute the check was closed -
SHIFT Employee shift number for the day (0 if not applicable).  For example, the first time the clock-in for the day is shift one, the second time they clock-in for the same day is shift two, and so on. -
COUNT Depends on record TYPE (see the GNDSALE.DBF Type Constants table).  For TYPE 25, 51 and 54, the COUNT field is also the Tax ID. -
REVENUE Revenue Center ID in TS; Cash Drawer ID in QS -
TIPEMP The tippable employee (employee who opened the check) -
UNIT Unit ID (from the ALOHA.INI) -
DOB Date Of Business -
TYPEID2 Item category for a sold BackOffice gift certificate if the TYPE is 23 (See the GNDSALE.DBF type constants table).  The Tax ID for TYPE 25, 51 and 54. -
OCCASION Event ID (SuperSite) -
REVID2 Used to store the Job Code Id for type 15 – cash in / out 5.2

GNDSALE.DBF Type Constants

Used with GNDSALE.DBF.

Type Description Version
1 Total (including inclusive taxes) of all items sold by sales category.  Does not include exclusive taxes or voids. TYPEID=CAT.DBF -
2 Exclusive taxes, by Tax ID. TYPEID=TAX.DBF -
3 Tax-exempt exclusive taxes, by Tax ID. TYPEID=TAX.DBF -
4 Payments, by tender ID.  In QS, TYPEID2 is checkout number.  This includes tips and gratuities. TYPEID=TDR.DBF -
5 Comps, by comp ID. TYPEID=CMP.DBF -
6 Promotions, by promotion ID. TYPEID=PRO.DBF -
7 Comp tax not collected, by tax ID. TYPEID=TAX.DBF -
8 Promotion tax not collected, by tax ID. TYPEID=TAX.DBF -
9 Taxable sales for inclusive and vendor taxes, by tax ID. TYPEID=TAX.DBF -
10 Total guests -
11 Total checks -
12 Amount of tip share paid -
13 Total voided sales, by employee ID. TYPEID=EMP.DBF -
14 Tip reduction, by employee ID. TYPEID=EMP.DBF -
15 Petty cash, by manager employee ID and account ID.  TYPEID2 is a running count of the number of cash in/out records that is used to identify each record.  In QS, CLOSEHOUR is the checkout number within the shift. TYPEID=EMP.DBF -
16 Non-collected surcharges -
17 Collected surcharges -
18 Order mode charges -
19 Comps, by sales category ID. TYPEID=CAT.DBF -
20 Promotions, by sales category ID. TYPEID=CAT.DBF -
21 Server performance measure, by performance measure ID. TYPEID=PRF.DBF -
22 Declared cash from checkout.  In QS, TYPEID2 is the checkout number.  ORDERHOUR is the checkout hour, ORDERMINUTE is the checkout minute and CLOSEHOUR is the terminal ID where the employee checked-out. -
23 Gift certificates sold, by gift certificate ID. TYPEID=GIF.DBF -
24 Tax, by sales category ID.  COUNT is the tax ID. TYPEID=CAT.DBF -
25 Taxable sales for inclusive taxes, by sales category ID.

The inclusive tax formula is TAX= (AMOUNT * RATE) / (1 + RATE) .  COUNT is the tax ID. TYPEID=CAT.DBF

 -
26 Non-redeemed payments (over-payment without return change).  In QS, TYPEID2 is the checkout number. -
31 Net sales, by order mode ID. TYPEID=ODR.DBF -
32 Total calculated inclusive taxes -
33 Calculated inclusive taxes, by check number. -
34 Auto gratuity, by check number -
35 Refunds, by tender ID. TYPEID=TDR.DBF -
36 Total tax refunded -
37 Taxable refunds (currently unused) -
38 Tax exempt refunds (currently unused) -
39 Tax refunds, by sales category ID (currently unused). TYPEID=CAT.DBF -
40 Taxable refunds, by sales category ID (currently unused). TYPEID=CAT.DBF -
41 Tax-exempt taxable sales -
42 Over/short, by employee ID (if available).  In QS, TYPEID2 is the checkout number. TYPEID=EMP.DBF -
43 Number of checks, by order mode ID. TYPEID=ODR.DBF -
44 Perpetual check counter information.  TYPEID2 is the terminal ID. -
45 Rounding adjustment total -
46 Order attributes -
47 Number of 'no sale' transactions -
48 Foreign currency payments, by tender ID.  In QS, TYPEID2 is the checkout number. TYPEID=TDR.DBF -
49 Guests, by order mode ID. TYPEID=ODR.DBF -
50 Credit card refunds (currently unused) -
51 Exclusive-tax taxable sales, by sales category ID, TYPEID2 is the Tax ID number. TYPEID=CAT.DBF -
52 Straight sales – inclusive tax – comps (if NETHASCOMPS=TRUE) – promotions (if NETHASCOMPS=TRUE), by sales category ID. TYPEID=CAT.DBF -
53 Straight sales + Exclusive tax, by sales category. TYPEID=CAT.DBF -
54 Inclusive tax, by sales category ID. TYPEID=CAT.DBF -
55 Cash cards sold -
56 Voided gift certificates, by gift certificate ID. TYPEID=GIF.DBF -
57 Declared tenders from Payment Reconciliation.  In QS, TYPEID2 is the checkout number.  ORDERHOUR is the checkout hour, ORDERMINUTE is the checkout minute and CLOSEHOUR is the terminal ID where the employee checked-out.  TYPEID is the tender ID. -
58 Uncollected surcharges, by sales category ID. TYPEID=CAT.DBF -
59 Collected surcharges, by sales category ID. TYPEID=CAT.DBF -
60 Order mode charges, by sales category ID and revenue center. TYPEID=CAT.DBF -
61 Revenue item sales -
62 Additional charges (Aloha Manager\Maintenance\Store Settings\Financials\Add Charges) -
63 Goods and services tax (GST) -
64 $0.00 check count (only populated if Aloha Manager/Maintenance/Store Settings/Financials/Reports/'Exclude Comped Checks and Guests' is enabled) 5.2
65 Total comps applied to gift certificates, by comp ID. TYPEID=CMP.DBF 5.2
66 Total promos applied to gift certificates, by promo ID. TYPEID=PRO.DBF 5.2
67 Total comps applied to gift certificates, by sales category ID. TYPEID=CAT.DBF 5.2
68 Total promos applied to gift certificates, by sales category ID. TYPEID=CAT.DBF 5.2
69 Unused 5.2
70 Unused 5.2
71 Voids by category ID. TYPEID=CAT.DBF 5.2
72 Voided revenue items 5.2
73 VizorVestSM contributions by employee ID. TYPEID=EMP.DBF 5.2
74 Portion of the VizorVest contributions that adds to Cash Owed 5.2
75 Cleared (unordered) items by amount 5.2
76 Cleared (unordered) items by category ID. TYPEID=CAT.DBF 5.2
77 Cleared revenue items 5.2
78 Charge tip added to the check.  This type only appears if the LANDRYS flag is enabled.  Refer to document AKBID3038 for more information on the LANDRYS flag. 5.2
79 Number of tokens dispensed.  Used with the Chuck E. Cheese's T.O.D.D. System Controller (token dispenser). 5.2
80 Carryover Sales (obsolete) 5.2
81 Tippable sale of this check 5.3e
82 Tippable charge sale of this check 5.3e
83 Coupon Count Audit 5.4
84 Delivery 5.3e
85 Delivery Customer Id 5.3e
86 Straight sales by Non-Sales category ID. TYPEID=CAT.DBF 6.1
87 Number of QCs sold as well as the price at which they were sold at.  TYPEID=QCID, TYPEID2=QCLEVEL 6.2

 

Abacus. You can count on us.

 

          » Abacus Business Solutions  »  15301 Roosevelt Blvd.  »  Suite 303  »  Clearwater, FL 33760  »  Tel: (727) 524-0177  »  Fax: (727) 524-0188