Which grind dbf contains the transaction type. 3

[Tekwebmonkey]

The tdr.dbf has the list of possible transaction types, but which gnd*.dbf contains the transaction id?

Better yet, any have a quick reference of what is contained in the gnd*.dbf files?

 

[AdamDR]

ADJTIME.DBF – Contains payroll information about employee shifts and the jobs worked.
ADJTIMEX.DBF – Contains payroll edits for employee shifts and the jobs worked.
GCHKINFO.DBF – Contains check information.
GCLOG.DBF – Contains gift certificate sold / redeemed information.
GNDAUDIT.DBF – Contains sales audit information.
GNDBREAK.DBF – Contains employee break information.
GNDDEPST.DBF – Contains deposit information.
GNDDRWR.DBF (or GNDOPD.DBF)– Contains drawer activity such as time drawer was opened / closed.
GNDEDC.DBF – Contains audit information for EDC.
GNDITEM.DBF – Contains information about all items sold.
GNDLBSUM.DBF – Contains labor summary information.
GNDLINE.DBF – Contains line item detail records for comps and promos applied.
GNDOWAGE.DBF – Contains information about other wages.
GNDPERF.DBF – Contains performance measures tracked for employees.
GNDQKCNT.DBF – Contains quick count accumulated total information.
GNDREVN.DBF – Contains information separated by revenue center
GNDSALE.DBF – Contains a variety of sales information about each check closed in the system.
GNDSLSSUM.DBF – Contains sales summary information.
GNDTIME.DBF – Contains time and attendance information.
GNDTNDR.DBF – Contains information about all payments including tender, comp, and promotion information.
GNDTURN.DBF – Contains table turn information used to track progress of check state.
GNDVOID.DBF – Contains a record for every item voided.
WAGEEDIT.DBF – Contains information about otherwages’ audit information.



Hope this helps!!

Adam

 

[Tekwebmonkey]

The list helps a lot!

I've been starring at the gnditem.dbf data, which I think is the most comprehensive, but where do I find if an order was cash, debit, etc.?

-Airhead with a headache

 

[AdamDR]

Reprint guest check would be my first place to look. Do you have Aloha Manager? Go to Reports>Reprint>Guest Check

 

[Tekwebmonkey]

Yes, we have Aloha Manager 4.2. I'll check to see if that version has it. Thanks Adam, you've been a great help!

 

[jimmy777]

Hi Adam, that is great info!! is there a resource where I can get definitions of all the Aloha dbf files?

 

[AdamDR]

How much money do you have??


Just kidding!

It's a long list, so email me and I'll send it to you.

adrothenbuhl<at>gmail<dot>com