Exporting Transaction Data from Micros 3700

[Doubleohalex]

thread693-1164015

Hey All,

I just obtained a new client running a Micros 3700 system. They are currently working with an outside company to analyze their sales data to determine trends and patterns. They are requesting data pertaining to transaction details (e.g. date, time, price, item(s) on the check, etc.), product descriptions and/or taxonomies, and anything that explains coupons or promotions. They also said they prefer this data to be exported into tab delimited text files however, any readable format will suffice.

So far, I have looked through the previous thread from '05 linked here and was able to successfully run one of the queries provided from that thread. However, there are 3 connected restaurants being run from the 1 Micros server. I am not sure which tables I will need to be targeting for the requested data or how the data for multiple restaurants will be handled. Can we export data per restaurant or will it all come out mixed together?

Any insight is much appreciated. Thanks in advanced!

 

[pmegan]

You have a couple of options.
I you know the sequence number(s)for each of the restaurants you can add "where tdtl.rvc_seq in (x,y,z)", with x, y and z being the rvc_seqs.

You can also join in the rvc_def table on trans_dtl.rvc_seq = rvc_def.rvc_seq and make the first Sort parameter rvc_def.rvc_seq, rvc_def.obj_num or rvc_def.name.

 

[Doubleohalex]

Do you have an exampled script to show this? I am a beginner at Micros and that went a bit over my head.