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
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