Hi Rob,

There is no single ERD in IFS. We have a number of separate ones but they are neither complete nor published in an easy manner (you need IFS Developer Studio, our main developer tool, to see them).

The information is right there under your fingertips though, in the database :)

How to find all columns/attributes in an entity:

SELECT column_name

FROM Dictionary_Sys_View_Column

WHERE lu_name = 'DocTitle'

How to find references from an entity to other entities:

SELECT column_reference

FROM Dictionary_Sys_View_Column

WHERE lu_name = 'DocTitle'

Armed with this, you should be able to query the database for the information you need. If you are using Cloud Deployment you can create one or a few quick reports to extract the same information.

Good luck!
 

Ok, but is there somehow a way to see dependencies? 
Eg. in order to add a customer, what tables does it depend on? 

Does something like that exists? That would be of great help for  data migration and other topics.

Check my last query above for the LU CustomerInfo, and combine with this condition:

AND required_flag = 'M'

Then you will find what entities a customer references and which are mandatory.