Micros Time Files ? 1

[azrobert]

Hello all,

I am looking to pull time shifts and tips from the Micros database to send to our corp office. I am able to connect to the database fine, i have determined that I need to join the (micros_emp_def) and (micros_time_card_dtl) to get the shifts and employees, I also see the link to the job table there but haven't gone that far yet.

I have found that declared tips are in the table: (micros_tip_declared_dtl) but have not discovered any way to link those to a particular shift ????

I am also looking to collect employee sales by shift


does anyone have experience in this area ?

any help will be greatly appreciated......

p.s. micros res 3000

Robert

 

[POSWizard]

Look in the views. Micros uses shifts so that you can track by time period. Tips are linked to business dates most likely.

You are going yo want to look at micros.shift_emp...tables. There are a few here and should do the trick. If not look in the views. Using Sybase will help you discover what tables you need.

 

[azrobert]

Thanks....

I have a demo version installed and have been looking at those tables. so far there is no data in them, is it only added after the end of day is run ?

the tips_declared table seems to have the tipp data but there is only 3 fields and can't seem to link the tran seq to anything...

 

[POSWizard]

You will need the software licensed to see data for the current business date. If the system is not licensed all data will post to the demo date 9/8/2015. You also need to make sure that you are posting data via autoseq every 15 minutes or so. The views receive there data when the system posts. With timecard and tips posting information, you must post the information in a specific order. First step is to increment shifts, and this should only be done with end of night or clock out. Remember, Tip data is linked to shifts, so until you advance the shift the tips will not post.

Hope this helps