SeanHoppe.com > CLEO Tips > CLEO JDE Tips > 4 Outbound 856 - Retrieve Carrier Information from F4211

Outbound 856 - Retrieve Carrier Information from F4211

13th May 2015

When it comes to extracting data from F4211/F42119 to return shipping quantites and tracking numbers, we have multiple options to query the data.

One such option would be to use SQL Access to return the shipping quantites and carrier tracking numbers. 

Another option would to incorporate F4211 (F42119) into the outbound ASN schema.

SCHEMA SET-UP:

F470371: Below is the initial set-up with F47036 and F470371. We we list the F470371 keys: EDLN, STPC, ANTY and LINS.

EXTOL Business Integrator 2 JDE 856 Schema with F470371 table and key structure


F4201: We set-up F4201 as a child record, off of F470371. Instead of using the customary key of EDOC, we will use DOCO, DCTO and KCOO.

EXTOL Business Integrator 2 JDE 856 Schema with f4201 record as a child record of F470371 table


F4211: Just as we assigned a key structure to F4201, we will set-up the keys for F4211. In the example below, we use DOCO, DCTO, KCOO, and LINS.

EXTOL Business Integrator 2 JDE 856 Schema with f4211 record as a child record of F4201 table


RULESET SET-UP:

After the outbound 856 (ASN) Schema has been set-up and the keys have been assigned, we will be able to retrieve carrier tracking information from tables such as F4211.


EXTOL Business Integrator 2 JDE 856 ruleset with f4201 and F42119 tables


For more information on JDE Hacks and Tips:


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 ' '; ?>