If you are like me sometimes it can be hard to translate from technical name to the actual data entity name. As a Microsoft Dynamics 365 for Finance and Operations developer it is sometimes useful to use the cross reference to identify the proper entity to use, however some tables are used so often it can be a task to scroll through to find the right reference. An example is EcoResCategory table.
Each data entity is actually a SQL view as well. So we can back into a list of tables used on each data entity using a SQL query!
Let’s find out which entities use the EcoResCategory table.
Surprise! There are 70 data entities using that table (I chose this on purpose). This is because it is much easier to give the category name instead of a RefRecId. So there is still some brainpower needed here, but it normally is a very short list to review. I suggest that you export this list once, and refer to it whenever required. Here is the list for 10.0.0.