# UD Column Mapping **URL:** \ **Category:** Epicor ERP 10\ **Tags:** customization\ **Created:** [September 16, 2019, 8:36pm UTC](https://www.epiusers.help/t/ud-column-mapping/59809 "2019-09-16T20:36:47Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Paul\_Millsaps](https://www.epiusers.help/user_avatar/www.epiusers.help/paul_millsaps/32/2562_2.png) [@Paul\_Millsaps](https://www.epiusers.help/u/Paul_Millsaps)\ **Post date:** [September 16, 2019, 8:36pm UTC](https://www.epiusers.help/t/ud-column-mapping/59809/1 "2019-09-16T20:36:47Z")
I am trying to use the UD Column maps to bring a field form the Part table to the JobMtl table. I have the UD fields created, synced, and mapped in the UD Column Map Maintenance, but it does not seem to automatically link the data. Am I mis-understanding the purpose of that mapping, or is there some step I have missed? I have restarted the appservers completely, but nothing seems to trigger the mapping. ![image](https://epiusers.help/uploads/default/original/3X/7/3/733579221680e54f4b2224e24385c9dc91fcb771.png) ---
**Author:** ![Jason\_Woods](https://www.epiusers.help/user_avatar/www.epiusers.help/jason_woods/32/80101_2.png) [@Jason\_Woods](https://www.epiusers.help/u/Jason_Woods)\ **Post date:** [September 16, 2019, 9:55pm UTC](https://www.epiusers.help/t/ud-column-mapping/59809/2 "2019-09-16T21:55:24Z")
I suppose I have never tried linking those two tables. Typically it would be: ECOMtl \> PartMtl PartMtl \> JobMtl It would not be too hard to write a BPM to populate this depending on your hosting restrictions. ---
**Author:** ![Ashley](https://www.epiusers.help/letter_avatar_proxy/v4/letter/a/45deac/32.png) [@Ashley](https://www.epiusers.help/u/Ashley)\ **Post date:** [September 17, 2019, 12:23pm UTC](https://www.epiusers.help/t/ud-column-mapping/59809/3 "2019-09-17T12:23:15Z")
Did you Get Details for the job after setting the mapping? I’d guess it doesn’t load for pre-existing records. ---
**Author:** ![Paul\_Millsaps](https://www.epiusers.help/user_avatar/www.epiusers.help/paul_millsaps/32/2562_2.png) [@Paul\_Millsaps](https://www.epiusers.help/u/Paul_Millsaps)\ **Post date:** [September 17, 2019, 12:52pm UTC](https://www.epiusers.help/t/ud-column-mapping/59809/4 "2019-09-17T12:52:30Z")
I recreated the job from scratch a couple of times after doing the mapping using the Order Job Wizard. I will try a manual get details process to see if that works. ---
**Author:** ![Ashley](https://www.epiusers.help/letter_avatar_proxy/v4/letter/a/45deac/32.png) [@Ashley](https://www.epiusers.help/u/Ashley)\ **Post date:** [September 17, 2019, 12:58pm UTC](https://www.epiusers.help/t/ud-column-mapping/59809/5 "2019-09-17T12:58:36Z")
For what it’s worth, my reading of the application help matches your expectation for behavior. But the last time I pointed out that the Help said Epicor would do something a certain way, they responded with a change request to change the Help file. ---
**Author:** ![Paul\_Millsaps](https://www.epiusers.help/user_avatar/www.epiusers.help/paul_millsaps/32/2562_2.png) [@Paul\_Millsaps](https://www.epiusers.help/u/Paul_Millsaps)\ **Post date:** [September 17, 2019, 1:09pm UTC](https://www.epiusers.help/t/ud-column-mapping/59809/6 "2019-09-17T13:09:03Z")
I just verified if I add a material manually, it does bring across the data correctly, so I think it has to do with the Order Job Wizard, or the mass get details method not pulling them across. Even doing the Get Details manually did not bring them in. ---
**Author:** ![Ashley](https://www.epiusers.help/letter_avatar_proxy/v4/letter/a/45deac/32.png) [@Ashley](https://www.epiusers.help/u/Ashley)\ **Post date:** [September 17, 2019, 1:12pm UTC](https://www.epiusers.help/t/ud-column-mapping/59809/7 "2019-09-17T13:12:55Z")
Well, that’s not much use. Try starting a case with EpicCare. ---
**Author:** ![Paul\_Millsaps](https://www.epiusers.help/user_avatar/www.epiusers.help/paul_millsaps/32/2562_2.png) [@Paul\_Millsaps](https://www.epiusers.help/u/Paul_Millsaps)\ **Post date:** [September 17, 2019, 9:45pm UTC](https://www.epiusers.help/t/ud-column-mapping/59809/8 "2019-09-17T21:45:41Z")
Finally got some documentation from support, and the Part to JobMtl link only works when you add Material manually. To get them to come in during the GetDetails call requires them to be in the PartMtl ud field, which means I would have to add the UD field all throughout the chain, Part to ECOMtl to PartMtl to JobMtl. It actually turned out to be easier during the MassIssueToMfg to add the lookup into the Part table during the grid build. Very fast response, and works like a champ! Thanks for your responses and thoughts.