I just started the E10 migration process and found out that all the UD fields on the system tables with data in them will be migrated over to table_UD tables during the conversion. We have utilized 500+ of these fields on customizations and they follow through to BAQs, Dashboards, Reports and data pulls outside of Epicor for custom reporting. I want to prep my E9 database and create _UD fields and move all of this data now and not wait for the E10 conversion to do it. Having been on Epicor since Vantage 8.03, I know how migrations go. I can created the new _UD fields but I cannot figure out how to move the data from say Project.Character01 to Project_UD.MyNewField. I have code written to use the Project adapter to move data from one field on the table to the another field on that table but I cannot find an adapter for Project_UD any of the _UD tables that I have created. How do I programmatically access the _UD tables?
Thanks
Jason