Network Management

Power and Cabling

Interfaces

Data Security

eAlerts

IT Services

Home

Aloha Application Software Database Files

The following lists the .dbf files used by Aloha application software, their description, whether they are used with QuickService or TableService, and the numerical reference found in some errors.

The Cat.dbf, Cit.dbf, and Pro.dbf files have multiple versions for Store, Regional, and Corporate levels.  This is disabled in versions 5.0x and higher.

Some database files might exist in both QuickService and TableService, even though only one of the two products actually uses the files.  Files in this document are attributed to the product only if they are actually used by the product.

The following table lists the file name, description, whether the file applies to QuickService or TableService, if the database file is owned by Aloha Centralized Data Management (if you are using CDM), and the error number that is referenced in debugging files:

Name
Description
QS
TS
CDM
Error
Reference
Number

Acc.dbf

Access Levels

X

X

Y

1100

AdjTime.dbf

Employee shifts and jobs worked payroll information

-

-

-

-

AdjTimex.dbf

Edited employee shifts and jobs worked payroll information

-

-

-

-

Aloha.ini

Configuration

X

X

-

1128

Amnu.dbf

Auto Menu

-

X

Y

1159

Amnud.dbf

Auto Menu Details

-

X

Y

1160

Avail.dbf

ALS Employee Availability

X

X

-

N/A

Bhrs.dbf

ALS Business Hours

X

X

-

N/A

Brkrdt.dbf

Break Rule Detail

X

X

 

N/A

Brkremmg.dbf

Break Reminder Messages

X

X

 

N/A

Brkrloc.dbf

Break Location

X

X

 

N/A

Brkrqua.dbf

Breal Quailify

X

X

 

N/A

Brkrule.dbf

Break Rules

X

X

 

N/A

Brkwaimg.dbf

Waive Break Messages

X

X

 

N/A

Btn.dbf

Panel Buttons

X

X

Y

1147

CashCard.dbf

Cash Cards

X

X

-

1180

Cat.dbf

Categories

X

X

Y

1101

Cat1.dbf

Store-Level Categories

-

-

-

1101

Cat2.dbf

Regional-Level Categories

-

-

-

1101

Cat3.dbf

Corporate-Level Categories

-

-

-

1101

Cevnt.dbf

CDM Event Groups

-

X

-

N/A

Cevntsub.dbf

CDM Event Group Subscriptions

X

X

-

N/A

Cit.dbf

Category Items

X

X

Y

1102

Cit1.dbf

Store-Level Category Items

-

-

-

1102

Cit2.dbf

Regional-Level Category Items

-

-

-

1102

Cit3.dbf

Corporate-Level Category Items

-

-

-

1102

Cmg.dbf

Clock-In Messages

X

X

-

1103

Cmp.dbf

Comps

X

X

Y

1104

Cncpt.dbf

Concepts

X

X

-

1196

 Coin.dbf

Coins

X

X

Y

N/A

Ctk.dbf

Quick Count Composite Tracking Items

X

-

Y

1162

Dnk.dbf

Drink Dispensers

X

X

-

1165

Dsplybrd.dbf

Display Boards

X

X

-

1182

Dwr.dbf

Cash Drawers

X

X

-

1105

Emp.dbf

Employees

X

X

-

1106

Empi9.dbf

Employee I9 Information

X

X

-

N/A

Emppol.dbf

ALS Employee Policies

X

X

-

N/A

EmpType.dbf

ALS Employee Types

X

X

-

N/A

Exc.dbf

Exception Modifier Groups

X

X

Y

1107

FixPrice.dbf

Fixed Item Pricing

-

X

Y

1176

FlexTax.dbf

Flex Taxes

X

X

Y

1185

Gci.dbf

Guest Check Information

X

X

-

1108

GcLog.dbf

Gift certificate sold and gift certificate redeemed information.

-

-

-

1142

Gchkinfo.dbf

Additional guest check information.

-

-

-

-

Gif.dbf

Basic Gift Certificates

X

X

-

1109

Gndaudit.dbf

Contains audit information and appears if the LANDRYS flag is enabled OR the option “Enable Grind Audit” is enabled

-

-

-

-

Gndbreak.dbf

Contains all breaks for a business day

-

-

-

-

Gndbreakinfo.dbf

Contains information about earned breaks and their status

-

-

-

-

Gnddepst.dbf

Contains the daily deposit information previously contained in DEPOSIT.TXT

-

-

-

-

Gnddrwr.dbf

Open cash drawer tracking

-

-

-

-

Gndopd.dbf

Open cash drawer tracking

-

-

-

-

Gndedc.dbf

Contains EDC transaction information and only appears if the LANDRYS flag is enabled

-

-

-

-

Gnditem.dbf

Contains one record for every item sold

-

-

-

-

Gndlbsum.dbf

Contains a daily labor summary

-

-

-

-

Gndline.dbf

Contains line item detail records for applied Comps and Promos

-

-

-

-

Gndowage.dbf

Contains Other Wages paid for a business day: paid time off, vacation, sick time, and other types of wages

-

-

-

-

Gndperf.dbf

Records Performance Measure information

-

-

-

-

Gndqkcnt.dbf

Records Quick Count accumulated totals

-

-

-

-

Gndrevn.dbf

Contains miscellaneous information formatted to expedite Revenue Center reporting

-

-

-

-

Gndsale.dbf

Contains sales information

-

-

-

-

Gndslsum.dbf

Contains a daily sales summary

-

-

-

-

Gndtime.dbf

Contains daily labor information

-

-

-

-

Gndtipshare.dbf

Contains Tipshare information for Tipshare Recipients and Contributors

-

-

-

-

Gndtndr.dbf

Contains a record for all applied payments

-

-

-

-

Gndturn.dbf

Contains detailed information for each opened and closed table, enabling reports to track the lifetime of the table

-

-

-

-

Gndvoid.dbf

Contains a record for every item voided

-

-

-

-

Gpredem.dbf

TGI Friday's Gold Points Redeemed

-

X

-

N/A

Hpb.dbf

N/A

X

X

-

N/A

Hse.dbf

House Accounts

X

X

-

1110

Intmsg.dbf

Interactive Messages

X

X

 

 N/A

 Intmsgdt.dbf

Interactive Messages Detail 

X

X

 

 N/A

Itm.dbf

Items

X

X

Y

1111

Itmgrp.dbf

Item Size Groups

X

-

Y

1185

Itmgrpl.dbf

Item Size Group List

X

-

Y

1186

Job.dbf

Job Codes

X

X

Y

1112

Jrv.dbf

Job by Revenue Center

X

X

Y

N/A

Lab.dbf

Labor Groups

X

X

Y

1113

Label.dbf

Labels

X

X

-

1181

LabLimit.dbf

ALS Labor Period Limits

X

X

-

N/A

Laborprj.dbf

ALS Labor Projections

X

X

-

N/A

Labpdtm.dbf

ALS Labor Period Times

X

X

-

N/A

Labprd.dbf

ALS Labor Periods

X

X

-

N/A

Memb.dbf

Memberships

-

X

-

N/A

MembHold.dbf

Membership Hold Reasons

X

X

-

N/A

Mnu.dbf

Menus

-

X

Y

1114

Mod.dbf

Modifier Groups

X

X

Y

1115

Modcode.dbf

Modifier Codes

X

X

-

N/A

Movie.dbf

Clock-in Movies

X

X

-

N/A

Movieemp.dbf

Clock-in Movie employee assignments

X

X

-

N/A

Moviehst.dbf

Clock-in Movie play history

X

X

-

N/A

Moviejob.dbf

Clock-in Movie job code assignments

X

X

-

N/A

Msg.dbf

Main Screen Messages

X

X

-

1134

Multcurr.dbf

Foreign Currencies

X

X

Y

1177

NoSaler.dbf

No Sale Reasons

X

X

Y

1184

Occ.dbf

Occasions

X

X

-

1171

Oct.dbf

Occasion Categories

X

X

-

1172

Odr.dbf

Order Modes

X

X

Y

1116

OthWage.dbf

Other Wages

X

X

-

1197

Pc.dbf

Price Changes

X

X

Y

1167

Pcid.dbf

Price Change Item Detail

X

X

Y

1168

Pcpd.dbf

Price Change Promotion Detail

X

X

Y

1190

Pcpld.dbf

Price Change Price Level Detail

X

X

Y

1169

Pet.dbf

Petty Cash Accounts

X

X

-

1135

Pkgpro.dbf

Chuck E. Cheese's Package Promos

X

-

Y

N/A

Pkgprocp.dbf

Chuck E. Cheese's Package Promo Components

X

-

Y

N/A

Pkgprogc.dbf

Chuck E. Cheese's Package Promo Group Components

X

-

Y

N/A               

 

 Pkgprogp.dbf

Chuck E. Cheese's Package Promo Group Pricing

X

Y

N/A

 

Pnchrsn.dbf

Edit Punch Reasons

X

X

-

N/A

Pnl.dbf

Panels

X

X

Y

1148

Poll.dbf

Customer Polls

X

X

-

N/A

PollEvent.dbf

Customer Poll Events

X

X

-

N/A

Pollsubs.dbf

Customer Poll Subscribers

X

X

-

N/A

Prd.dbf

Day Parts

X

X

Y

1117

Prf.dbf

Performance Measures

X

X

Y

1118

Prg.dbf

Printer Groups

X

X

-

1119

Prjc.dbf

Preparation Projections

X

X

-

1179

Prjt.dbf

Preparation Projection Tracking

X

X

-

1178

Prl.dbf

Price Levels

X

X

Y

1157

Prntd.dbf

Thumb (Finger) Print Data

X

X

-

N/A

Pro.dbf

Promotions

X

X

Y

1120

Pro1.dbf

Store-Level Promotions

-

-

-

1120

Pro2.dbf

Regional-Level Promotions

-

-

-

1120

Pro3.dbf

Corporate-Level Promotions

-

-

-

1120

Pron.dbf

N/A

-

-

-

N/A

Prt.dbf

Printers

X

X

-

1121

Qccp.dbf

QuickCombo promotion components

X

X

Y

N/A

Qcitem.dbf

QuickCombo promotion items

X

X

Y

N/A

Qcpro.dbf

QuickCombo promotion type specifics

X

X

Y

N/A

Qcupsell.dbf

QuickCombo promotion upsell items

X

X

Y

N/A

QtyPrice.dbf

Quantity Pricing

X

X

Y

1175

Que.dbf

Order Queues

X

X

-

1149

Rcp.dbf

Quick Count Composite Item Recipes

X

X

Y

1163

Reg.dbf

Regions

X

X

Y

1170

ReGrind.dbf

Regrind Dated Folders Information

X

X

-

N/A

ReqRule.dbf

ALS Requirement Rules

X

X

-

N/A

Required.ini

Required fields configuration

X

X

-

N/A

Rev.dbf

Revenue Centers

X

X

Y

1122

Rsn.dbf

Void Reasons

X

X

Y

1123

Rtl.dbf

Routing Levels

X

-

-

1154

Salesproj.dbf

ALS Sales Projections

X

X

-

N/A

Salesum.dbf

ALS Sales Summary

X

X

-

N/A

Scale.dbf

Scales

X

X

-

1173

Sch.dbf

Schedule

X

X

-

1124

Schdshft.dbf

ALS Schedule Shift Data

X

X

-

N/A

Scr.dbf

Screens

X

X

Y

1153

Seclvl.dbf

Security Levels

X

X

Y

N/A

Seclvldt.dbf

Security Level Details

X

X

Y

N/A

Shift.dbf

ALS Shifts

X

X

-

N/A

ShiftTag.dbf

ALS Shift Tags

X

X

-

N/A

Smcrd.dbf

Smart Cards

X

X

-

1164

Smg.dbf

Server Information Messages

X

X

-

1126

Specreq.dbf

ALS Special Requests

X

X

-

N/A

Sqlrpt.dbf

SQL Reports

X

X

-

N/A

Sqlrptpm.dbf

SQL Report Parameters

X

X

-

N/A

Sto.dbf

Stores

X

X

-

1166

StrEdit.dbf

CDM Store Edits

X

X

-

N/A

Strgrp.dbf

CDM Store Groups

X

X

-

N/A

Strgrpm.dbf

CDM Store Group Members

X

X

-

N/A

Sub.dbf

Submenus

-

X

Y

1127

Sur.dbf

Surcharges

X

X

Y

1136

Survey.dbf

Surveys

X

X

Y

1191

Tab.dbf

Tables

-

X

-

1129

Tabdef.dbf

CDM Table Definitions

X

X

-

N/A

Tare.dbf

Tare Weights

X

X

Y

1174

Task.dbf

ALS Tasks

X

X

-

N/A

TaskType.dbf

ALS Task Types

X

X

-

N/A

Tax.dbf

Taxes

X

X

Y

1130

Tdr.dbf

Payment Tenders

X

X

Y

1131

Tdrgrp.dbf

Tender Groups

X

X

-

-

Tdrgptdr.dbf

Tender Group Contents

X

X

-

-

Teamserv.dbf

Team Service Tip Distribution

-

X

-

N/A

Tippldtl.dbf

Tipshare Pool Detail

-

X

 

N/A

Tippools.dbf

Tipshare Pools

-

X

 

N/A

Trdtx.dbf

Tiered Taxes

X

X

-

N/A

Trk.dbf

Quick Count Tracking Items

X

-

Y

1161

Trm.dbf

Terminals

X

X

-

1132

Val.dbf

Valid Tender Identifiers

X

X

-

1133

Vdv.dbf

Remote Display Devices

X

X

-

1192

Ver.dbf

Database Version Number

X

X

-

N/A

Vgp.dbf

Remote Display Groups

X

X

-

1143

Vid.dbf

Remote Displays

X

X

-

1138

Vkp.dbf

Remote Display Keypads

X

X

 -

1193

Vol.dbf

Volume Levels

X

-

Y

1156

Vqu.dbf

Remote Display Queues

X

X

 -

1194

Wageedit.dbf

Contains records used to record edits to other wages.  Other wages includes paid time off, vacation, sick time, and any other wage information

-

-

-

-

Workpol.dbf

Work Policies

X

X

-

1301

Zap.dbf

Termination Reasons

X

X

Y

1137

 

Abacus. You can count on us.

 

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