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!

Leave a Reply