{"id":20852,"date":"2021-05-27T10:37:37","date_gmt":"2021-05-27T10:37:37","guid":{"rendered":"https:\/\/intranet-old.colart.com\/en\/?page_id=20852"},"modified":"2021-05-27T10:37:37","modified_gmt":"2021-05-27T10:37:37","slug":"test-reports-siop","status":"publish","type":"page","link":"https:\/\/intranet-old.colart.com\/en\/business-analytics-home\/mrc\/test-reports-siop\/","title":{"rendered":"Test Reports &#8211; SIOP"},"content":{"rendered":"<div id=\"pl-20852\"  class=\"panel-layout\" ><div id=\"pg-20852-0\"  class=\"panel-grid panel-no-style\" ><div id=\"pgc-20852-0-0\"  class=\"panel-grid-cell\" ><div id=\"panel-20852-0-0-0\" class=\"so-panel widget widget_colart-hero-widget colart-hero-widget panel-first-child panel-last-child\" data-index=\"0\" ><section class=\"colart-hero-widget colart-hero-widget-default\">\n    <div class=\"hero\" style=\"background-image: url('https:\/\/intranet-old.colart.com\/en\/wp-content\/uploads\/sites\/2\/2019\/06\/businessman-analyzes-graph-data-and-use-the-P48X8YL-1920x576-1561734297.jpg')\">\n        <div class=\"content hero-widget-headings\">\n\t\t\t                <h1><span>Business Analytics<\/span><\/h1>\n\t\t\t\t\t\t                <h2><span>SIOP<\/span><\/h2>\n\t\t\t\t\t\t        <\/div>\n    <\/div>\n<\/section>\n<\/div><\/div><\/div><div id=\"pg-20852-1\"  class=\"panel-grid panel-no-style\" ><div id=\"pgc-20852-1-0\"  class=\"panel-grid-cell\" ><div id=\"panel-20852-1-0-0\" class=\"so-panel widget widget_sow-editor panel-first-child panel-last-child\" data-index=\"1\" ><div\n\t\t\t\n\t\t\tclass=\"so-widget-sow-editor so-widget-sow-editor-base\"\n\t\t\t\n\t\t>\n<div class=\"siteorigin-widget-tinymce textwidget\">\n\t<table style=\"height: 336px;padding: 15px;border-style: solid;border-color: #080707\" border=\"1\">\n<tbody>\n<tr style=\"height: 24px\">\n<th style=\"width: 15%;height: 24px;color: #ffffff;background-color: #000000;text-align: center\">Name<\/th>\n<th style=\"height: 24px;color: #ffffff;text-align: center;background-color: #000000\">Description<\/th>\n<th style=\"height: 24px;color: #ffffff;text-align: center;background-color: #000000\">Type<\/th>\n<th style=\"height: 24px;color: #ffffff;text-align: center;background-color: #000000\">Owner<\/th>\n<\/tr>\n<tr style=\"height: 24px;border: 1px solid black;border-collapse: collapse\">\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\"><a href=\"http:\/\/172.16.1.111:18011\/mrcjava\/servlet\/MRCCOLART.R62020s\" target=\"_blank\" rel=\"noopener\">Firms Dos<\/a><\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"670\">To extract all Firm Distribution Order's, filtered on Order Type 501<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Report<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Jessi Kuo<\/td>\n<\/tr>\n<tr style=\"height: 24px;border: 1px solid black;border-collapse: collapse\">\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\"><a href=\"http:\/\/172.16.1.111:18011\/mrcjava\/servlet\/MRCCOLART.R63393s\" target=\"_blank\" rel=\"noopener\">FIRM DO\/PO REPORT<\/a><\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"670\">To extract all Firm Distribution Order's and Purchase Orders for US<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Report<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Jessi Kuo<\/td>\n<\/tr>\n<tr style=\"height: 24px;border: 1px solid black;border-collapse: collapse\">\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\"><a href=\"http:\/\/172.16.1.111:18011\/mrcjava\/servlet\/MRCCOLART.R12866s\" target=\"_blank\" rel=\"noopener\">MCPSUM LEM<\/a><\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"670\">To extract firmed MO + Future MOP (PMS170)<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Report<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Kevin Besard<\/td>\n<\/tr>\n<tr style=\"height: 24px;border: 1px solid black;border-collapse: collapse\">\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\"><a href=\"http:\/\/172.16.1.111:18011\/mrcjava\/servlet\/MRCCOLART.R00460s\" target=\"_blank\" rel=\"noopener\">MITBAL<\/a><\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"670\">This reports has all information related to our warehouses, from the MITBAL table - MMS002<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Report<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Bruno Lebourdais<\/td>\n<\/tr>\n<tr style=\"height: 24px;border: 1px solid black;border-collapse: collapse\">\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\"><a href=\"http:\/\/172.16.1.111:18011\/mrcjava\/servlet\/MRCCOLART.I01200s\" target=\"_blank\" rel=\"noopener\">MITPLO<\/a><\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"670\">This report shows information about the material plan including order information, planning date and item data.<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Retrieval<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Bruno Lebourdais<\/td>\n<\/tr>\n<tr style=\"height: 24px;border: 1px solid black;border-collapse: collapse\">\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\"><a href=\"http:\/\/172.16.1.111:18011\/mrcjava\/servlet\/MRCCOLART.R61950s\" target=\"_blank\" rel=\"noopener\">Performa Recap Report<\/a><\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"670\">This gives shipment information such as Shipment number and delivery index, grouped together by Harmcode.<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Report<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Jessie Kuo<\/td>\n<\/tr>\n<tr style=\"height: 24px;border: 1px solid black;border-collapse: collapse\">\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\"><a href=\"http:\/\/172.16.1.111:18011\/mrcjava\/servlet\/MRCCOLART.R62130s\" target=\"_blank\" rel=\"noopener\">Performa Recap Report V3<\/a><\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"670\">This gives shipment information such as Shipment number and delivery index, grouped together by Harmcode.<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Report<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Jessie Kuo<\/td>\n<\/tr>\n<tr style=\"height: 24px;border: 1px solid black;border-collapse: collapse\">\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\"><a href=\"http:\/\/172.16.1.111:18011\/mrcjava\/servlet\/MRCCOLART.R62803s\" target=\"_blank\" rel=\"noopener\">Performa Recap V5<\/a><\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"670\">This gives shipment information such as Shipment number and delivery index, grouped together by Harmcode. Newest version<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Report<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Jessie Kuo<\/td>\n<\/tr>\n<tr style=\"height: 24px;border: 1px solid black;border-collapse: collapse\">\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\"><a href=\"http:\/\/172.16.1.111:18011\/mrcjava\/servlet\/MRCCOLART.R63403s\" target=\"_blank\" rel=\"noopener\">Performa Recap V7<\/a><\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"670\">This gives shipment information such as Shipment number and delivery index, grouped together by Harmcode (Updated Version)<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Report<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Jessie Kuo<\/td>\n<\/tr>\n<tr style=\"height: 24px;border: 1px solid black;border-collapse: collapse\">\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\"><a href=\"http:\/\/172.16.1.111:18011\/mrcjava\/servlet\/MRCCOLART.R02000s\" target=\"_blank\" rel=\"noopener\">PLAN: Supply chain<\/a><\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"670\">To extract all open Do Lines of warehouse from status 22 to 66<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Report<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Cindy Levacher<\/td>\n<\/tr>\n<tr style=\"height: 24px;border: 1px solid black;border-collapse: collapse\">\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\"><a href=\"http:\/\/172.16.1.111:18011\/mrcjava\/servlet\/MRCCOLART.R62733s\" target=\"_blank\" rel=\"noopener\">Planning Groups (Workcenters)<\/a><\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"670\">Extraction of the settings of each work center (PDS010)<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Report<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Kevin Besard<\/td>\n<\/tr>\n<tr style=\"height: 24px;border: 1px solid black;border-collapse: collapse\">\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\"><a href=\"http:\/\/172.16.1.111:18011\/mrcjava\/servlet\/MRCCOLART.R12626s\" target=\"_blank\" rel=\"noopener\">PO MDI<\/a><\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"670\">To extract of firm PO's in status 15 to 35 for one supplier<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Report<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Cindy Levacher<\/td>\n<\/tr>\n<tr style=\"height: 24px;border: 1px solid black;border-collapse: collapse\">\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\"><a href=\"http:\/\/172.16.1.111:18011\/mrcjava\/servlet\/MRCCOLART.R60844s\" target=\"_blank\" rel=\"noopener\">PO Proposal Planning<\/a><\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"670\">Extraction of existing POs with information around the Planned quantity, planned delivery date and item information.<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Report<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Cindy Levacher<\/td>\n<\/tr>\n<tr style=\"height: 24px;border: 1px solid black;border-collapse: collapse\">\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\"><a href=\"http:\/\/172.16.1.111:18011\/mrcjava\/servlet\/MRCCOLART.I51135s\" target=\"_blank\" rel=\"noopener\">Product Standard Costs<\/a><\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"670\">This reports shows the Standard cost per item, per facility<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Retrieval<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Bruno Lebourdais<\/td>\n<\/tr>\n<tr style=\"height: 24px;border: 1px solid black;border-collapse: collapse\">\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\"><a href=\"http:\/\/172.16.1.111:18011\/mrcjava\/servlet\/MRCCOLART.R61620s\" target=\"_blank\" rel=\"noopener\">Stock Purchase Order Report - V2<\/a><\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"670\">To extract all the Released purchase orders of a given selections<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Report<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Bruno Lebourdais<\/td>\n<\/tr>\n<tr style=\"height: 24px;border: 1px solid black;border-collapse: collapse\">\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\"><a href=\"http:\/\/172.16.1.111:18011\/mrcjava\/servlet\/MRCCOLART.R00280s\" target=\"_blank\" rel=\"noopener\">Supplier Info<\/a><\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"670\">To extract Item data related to the Supplier and purchase information<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Report<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Bruno Lebourdais<\/td>\n<\/tr>\n<tr style=\"height: 24px;border: 1px solid black;border-collapse: collapse\">\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\"><a href=\"http:\/\/172.16.1.111:18011\/mrcjava\/servlet\/MRCCOLART.R61930s\" target=\"_blank\" rel=\"noopener\">UPS Export<\/a><\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"670\">This report provides COO,harmcode,value and quantity on each line for an export order<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Report<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Jessie Kuo<\/td>\n<\/tr>\n<tr style=\"height: 24px;border: 1px solid black;border-collapse: collapse\">\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\"><a href=\"http:\/\/172.16.1.111:18011\/mrcjava\/servlet\/MRCCOLART.I61950s\" target=\"_blank\" rel=\"noopener\">US Export Summary<\/a><\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"670\">This reports shows all export orders for the US<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Retrieval<\/td>\n<td style=\"padding: 15px;border: 1px solid black;border-collapse: collapse\" width=\"254\">Jessie Kuo<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Name Description Type Owner Firms Dos To extract all Firm Distribution Order&#8217;s, filtered on Order Type 501 Report Jessi Kuo FIRM DO\/PO REPORT To extract all Firm Distribution Order&#8217;s and Purchase Orders for US Report Jessi Kuo MCPSUM LEM To extract firmed MO + Future MOP (PMS170) Report Kevin Besard MITBAL This reports has all [&hellip;]<\/p>\n","protected":false},"author":1852,"featured_media":0,"parent":9663,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_relevanssi_hide_post":"","_relevanssi_hide_content":"","_relevanssi_pin_for_all":"","_relevanssi_pin_keywords":"","_relevanssi_unpin_keywords":"","_relevanssi_related_keywords":"","_relevanssi_related_include_ids":"","_relevanssi_related_exclude_ids":"","_relevanssi_related_no_append":"","_relevanssi_related_not_related":"","_relevanssi_related_posts":"","_relevanssi_noindex_reason":"","footnotes":""},"colart_campaign":[],"class_list":["post-20852","page","type-page","status-publish","hentry","post"],"acf":[],"_links":{"self":[{"href":"https:\/\/intranet-old.colart.com\/en\/wp-json\/wp\/v2\/pages\/20852","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/intranet-old.colart.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/intranet-old.colart.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/intranet-old.colart.com\/en\/wp-json\/wp\/v2\/users\/1852"}],"replies":[{"embeddable":true,"href":"https:\/\/intranet-old.colart.com\/en\/wp-json\/wp\/v2\/comments?post=20852"}],"version-history":[{"count":1,"href":"https:\/\/intranet-old.colart.com\/en\/wp-json\/wp\/v2\/pages\/20852\/revisions"}],"predecessor-version":[{"id":20853,"href":"https:\/\/intranet-old.colart.com\/en\/wp-json\/wp\/v2\/pages\/20852\/revisions\/20853"}],"up":[{"embeddable":true,"href":"https:\/\/intranet-old.colart.com\/en\/wp-json\/wp\/v2\/pages\/9663"}],"wp:attachment":[{"href":"https:\/\/intranet-old.colart.com\/en\/wp-json\/wp\/v2\/media?parent=20852"}],"wp:term":[{"taxonomy":"colart_campaign","embeddable":true,"href":"https:\/\/intranet-old.colart.com\/en\/wp-json\/wp\/v2\/colart_campaign?post=20852"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}