I am trying to get an DB export in Simphony 1 for daily sales by menu item we need the obj_num from the master menu item along with RVC, amount, name1&2 for the day. it seems like there is a good view in the DB [LOCATION_ACTIVITY_DB].[dbo].[VMM_MENU_ITEMS] but it is missing the obj_num from the master and looking at the databases I have no clue where it would be in location activity or even a record that I could use to join tables/databases and grab the obj_num. Can anyone point me in the right direction?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Simphony Location activity DB to MCRSPOS menu items
- Thread starter Darren_H
- Start date
Similar threads
- Locked
- Question
