How find where a data type is used in Sage X3
Sometimes, before making a change, or during a debugger, or for reverse engineering,
it may be necessary to know where a particular data type is used.
For example, you want to look for a data type “AAA”
The fastest way requires direct access to the database.
You execute this query :
Select * from FOLDER.AMSKZON Where CODTYP_0='AAA'
Brutal but very efficient method.
Alternatively, directly from the folder (test folder!) you can try to delete the data type
to see if the system signals a link to be deleted.
A method not recommended also because it wastes a lot of time.
I hope it helps you,
and if you have found another method I look forward to your reports.
See you next time!