I would like to create a report which lists all the current products which are either present in any active promotion or listed in any particular special price list. Any clues onto which tables I need to be looking at?
You can download the database help file from CKP document store. The help file contains all database objects and a brief explanation of all fields available. This file has become my "bible" when it comes to creating reports. There is a version of teh help file available for both 6.4 and 6.5 versions of iVend
however I feel that the help file for 6.5.5 does need some good beefing up. Unfortunately, sometimes with field descriptions with a mere repetition of the field title, the help file isn't much of help.
Thanks anyways though.