Please note I’m new to DMT and database maintenance.
I’m looking for some guidance on the DMT tool in terms of locating data. I’m trying to do some database cleanup with the DMT tool in a multi site environment. One of our sites was copied from another and has a lot of irrelevant data in it. My plan was to query the database server and build out the templates the DMT tool provides and fill those in with the bad data to take out. My one hang up is that in DMT I’m not finding what table the templates are referencing. For example for Part Class the DMT tool says the required fields are Company, ClassId, & Description, but it’s not showing me what table to query to get this info. Some of the tables are easy to find just from the system knowledge, but others are not. Is there any way from the DMT tool to see what tables its referencing for the required fields?
@Dcarne , do you know about the Field Help? If you go to the main screen for the data you are looking for and turn on Field Help, you will be able to see what table the data is in.
I am familiar with the field help. I didn’t think of that for this though. I was just hoping there was something within DMT that might help so I don’t have to go tracking it all down. Im still learning all of the menus and where to find all the fields within the system as I came from Epicor CMS which is much different. Based off my looking through the forums I wasn’t able to find a nice way so I think I will follow your advice unless someone has something easier! I appreciate the help!
