Tables in Service Manager

[kyariexcel]

One of our departments is looking for a way to manage job tickets more efficiently. They would like a four-column table with Job #, Location, Job Status, and Job Notes (underneath "Phases" on the report). They use Service Manager - specifically, Document Entry - to manage them currently, but AFAIK there is no simple way to consolidate only these fields into a view. The only thing is, I'm kinda lost on where to start poking in the DB, although I've had to in the past for requests of a different nature so I'm not unfamiliar with the process.

I reference the Sage Application Object Model 6.0 for such requests, querying SQL with PHP to create an HTML result table. But I don't see anything relating to Service Manager in the AOM documentation. Do I need separate documentation specific to Service Manager to find the necessary tables? Or is the information locked away in the existing tables found within the AOM?

 

[Jay Converse]

http://www.technisoft.com.au/support/downloads/documentation.aspx

 

[Jay Converse]

http://www.technisoft.com.au/download/documentation/VM62ADataDictionary.pdf

 

[kyariexcel]

Thank you for your assistance, tuba2007. But I'm having some trouble with these links. The first link is showing nothing on screen, looks like I need account credentials of some sort. I'll try to get that sorted out with upper management, but as for the second link, the PDF references tables that I cannot find when I query our DB. Specifically any table that begins with VM????.

Could this be an permissions / access issue?

 

[Jay Converse]

If you don't see VM tables, then you're not running Service Manager.

 

[kyariexcel]

I apologize for the confusion. I was in the wrong database Thank you for your help again!