SeanHoppe.com > CLEO Tips > CLEO JDE Tips > 4 E1 Inbound Purchase Order User Reserved Fields

E1 Inbound Purchase Order User Reserved Fields

9th April 2015

JDEdwards E1 offers the following user defined fields for the EDI 850 Inbound PO Header (F47011) table but they do not map to an equivalent field in the Sales Order Header (F4201) that will be created.


User Reserved Fields

EXVAR0 - through EXVAR13
Reserved - User Defined - These are Text Strings reserved for the user. Oracle does not currently use this field and will not utilize this field in the future.

EXNM0 through EXNMP2
Reserved - User Defined - These are Numeric Values that is reserved for the user. Oracle does not currently use this field and will not utilize this field in the future.

EXDT0 through EXDT2
Reserved - User Defined - These are Dates that is reserved for the user. Oracle does not currently use this field and will not utilize this field in the future.


EXTOL Solution

In EXTOL Business Integrator, users can create a SQL Action to chain-out to F47011 to retrieve these user reserved fields. F47011.DOCO will be populated and offer users a common key between F47011 and other tables such as F47046 (invoice header) and F47026 (PO Ack Header).

In EXTOL EDI Integrator, users can use External File Look-up. In order to use EFL a logical file will have to be created over F47011.


By: on
load('http://www.seanhoppe.com/EXTOL-Blog-Feed2/'); $feed2 = array(); foreach ($rss2->getElementsByTagName('item') as $node2) { $item2 = array ( 'title' => $node2->getElementsByTagName('title')->item(0)->nodeValue, 'desc' => $node2->getElementsByTagName('description')->item(0)->nodeValue, 'link' => $node2->getElementsByTagName('link')->item(0)->nodeValue, 'date' => $node2->getElementsByTagName('pubDate')->item(0)->nodeValue, ); array_push($feed2, $item2); } $limit2 = 5; $rss3 = new DOMDocument(); $rss3->load('http://www.ebithree.com/EBIThree-RSS/'); $feed3 = array(); foreach ($rss3->getElementsByTagName('item') as $node3) { $item3 = array ( 'title' => $node3->getElementsByTagName('title')->item(0)->nodeValue, 'link' => $node3->getElementsByTagName('link')->item(0)->nodeValue, ); array_push($feed3, $item3); } $limit3 = 5; $rss4 = new DOMDocument(); //$rss4->load('http://www.ebithree.com/EBIThree-RSS/'); $rss4->load('http://www.ebiworld.com/EBI-Feed/'); $feed4 = array(); foreach ($rss4->getElementsByTagName('item') as $node4) { $item4 = array ( 'title' => $node4->getElementsByTagName('title')->item(0)->nodeValue, 'link' => $node4->getElementsByTagName('link')->item(0)->nodeValue, ); array_push($feed4, $item4); } $limit4 = 5; echo ' '; ?>