richchipper
Well Known Member
In our process of system cleanup, we've found that in the past, SQL copies were done that did not do much validation. As an example, we have records in our F3002 table for branches that have never been set up for JDE use. So, obviously, we can't go into the programs to delete these records.
I'm working to try to clean this up, but was wondering if there is any kind of process to research the tables to see any table containing a value for an alias without having to go through every table. In my example, I'd like to research any table with MCU=360001. Any suggestions would be helpful.
I'm working to try to clean this up, but was wondering if there is any kind of process to research the tables to see any table containing a value for an alias without having to go through every table. In my example, I'd like to research any table with MCU=360001. Any suggestions would be helpful.