Looking for some guidance. Is there an easy way to see what database tables are used by Epicor screens?
For example, the “User Account Maintenance” screen. How can I find out what tables are used to store data for this screen? Obviously erp.UserComp is used, but how can I find what other tables are used?
Any input is greatly appreciated!
You can go up to Help > Field help.
Click into a field, then click the Technical Details tab at the bottom of the new slideout.
Thanks for the response Hannah. Do you think the Filed Name and DB Field are stored somewhere in the DB? I was thinking it would be nice to query the screen name and have it return a result of all of the field name and corresponding DB field, used across the whole screen. Let me know what you think.
Thanks!
In the web, you can probably query the bo that provides the json for the screens, then check what business objects it uses, and then check those.
On the thick client, I believe you’d need to parse the dll assemblies for which business objects are used, and then check those.
It get’s tricky too because the fields that are on the screens aren’t always what’s in the database. There are calculated fields, and there are fields that the server code touches that isn’t touched by the client code. It’s all an interconnected web, so while the idea sounds simple, it’s really not.
Adding to the other comments, it’s better to learn what’s in the Business Objects. Some fields are stored across tables and you’ll not get into the poor habit of directly updating the database tables.
You can see the data models used on screens with both the classic screens and Application Studio.
I was actually working on something similar and figured I would dive in and see how far I could take it. As everyone said above, it is not mapped to a screen, but instead a BO. I created this BAQ.
DataDictionary.baq (28.1 KB)
