SeanHoppe.com > CLEO Tips > Cleo EDI Integrator > Create Purchase Order (850) and Invoice (810) DB2 Tables

Create Purchase Order (850) and Invoice (810) DB2 Tables

15th May 2015

In an earlier post we showed EXTOL EDI Integrator users how to implement the EDI transactions Load Tender 204 and the Freight Invoice (210). To see the details, CLICK HERE >

Below, we show EEI users a starter set-up for

  • purchase orders: x12 850 /EDIFACT ORDER
  • invoices: x12 810 /EDIFACT INVOIC

In our table (QDDSSRC) examples we break out the address and notes sections into separate tables. This allows us to anticipate any number of name/address segments. In addition to supplying users with the DDS, we also show the mappings in XLS spreadsheets.

Purchase Order DDS SPECS:

Invoice DDS SPECS:

Spreadsheets:


To see more information on EXTOL EDI Integrator


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