{"id":472,"date":"2010-02-08T07:38:56","date_gmt":"2010-02-08T06:38:56","guid":{"rendered":"http:\/\/websha.de\/xstepcafe\/?p=472"},"modified":"2018-06-01T06:45:22","modified_gmt":"2018-06-01T04:45:22","slug":"pi-pcs-mapping-the-structure-against-erp-tables-and-fields","status":"publish","type":"post","link":"https:\/\/websha.de\/xstepcafe\/2010\/02\/08\/pi-pcs-mapping-the-structure-against-erp-tables-and-fields\/","title":{"rendered":"PI-PCS: Mapping the Structure against ERP Tables and Fields"},"content":{"rendered":"<p>When connecting external systems from ERP via the PI-PCS interface you might want to check the content in ERP first. Here are some hints where to look and what to look out for.<\/p>\n<p><!--more--><\/p>\n<p>The tables involved are:<\/p>\n<ul>\n<li>COCH &#8211; Control recipe header information<\/li>\n<li>COFT &#8211; Instruction header<\/li>\n<li>COFV &#8211; Instruction content<\/li>\n<\/ul>\n<p>When looking at the structure (see <a href=\"http:\/\/websha.de\/xstepcafe\/wp-content\/uploads\/PI-PCS-Structure.pdf\">PI-PCS &#8211; Structure<\/a>) you get from the PI-PCS interface you will notice some differences. I have made a little mapping table to show this: <a href=\"http:\/\/websha.de\/xstepcafe\/wp-content\/uploads\/PI-PCS-ERP-Table-Mapping.pdf\">PI-PCS &#8211; ERP Table Mapping<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>When connecting external systems from ERP via the PI-PCS interface you might want to check the content in ERP first. Here are some hints where to look and what to look out for.<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_links_to":"","_links_to_target":""},"categories":[52],"tags":[49,50],"_links":{"self":[{"href":"https:\/\/websha.de\/xstepcafe\/wp-json\/wp\/v2\/posts\/472"}],"collection":[{"href":"https:\/\/websha.de\/xstepcafe\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/websha.de\/xstepcafe\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/websha.de\/xstepcafe\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/websha.de\/xstepcafe\/wp-json\/wp\/v2\/comments?post=472"}],"version-history":[{"count":5,"href":"https:\/\/websha.de\/xstepcafe\/wp-json\/wp\/v2\/posts\/472\/revisions"}],"predecessor-version":[{"id":612,"href":"https:\/\/websha.de\/xstepcafe\/wp-json\/wp\/v2\/posts\/472\/revisions\/612"}],"wp:attachment":[{"href":"https:\/\/websha.de\/xstepcafe\/wp-json\/wp\/v2\/media?parent=472"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/websha.de\/xstepcafe\/wp-json\/wp\/v2\/categories?post=472"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/websha.de\/xstepcafe\/wp-json\/wp\/v2\/tags?post=472"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}