{"id":398,"date":"2014-09-19T17:24:17","date_gmt":"2014-09-19T14:24:17","guid":{"rendered":"http:\/\/www.ozgurguler.net\/?p=398"},"modified":"2015-10-16T17:42:02","modified_gmt":"2015-10-16T14:42:02","slug":"birim-cevrimli-rapor","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/birim-cevrimli-rapor\/","title":{"rendered":"Birim \u00c7evrimli Rapor"},"content":{"rendered":"<p>SELECT CODE,NAME,UNITSETREF,<\/p>\n<p>(SELECT CODE FROM LG_058_UNITSETF WHERE LOGICALREF=ITM.UNITSETREF) AS BIRIMSETKODU,<br \/>\n(SELECT NAME FROM LG_058_UNITSETF WHERE LOGICALREF=ITM.UNITSETREF) AS BIRIMSETADI,<br \/>\n(SELECT CODE FROM LG_058_UNITSETL WHERE UNITSETREF=ITM.UNITSETREF AND LINENR=1) ANABIRIM,<br \/>\n(SELECT CODE FROM LG_058_UNITSETL WHERE UNITSETREF=ITM.UNITSETREF AND LINENR=2) [2.BIRIM],<br \/>\n(SELECT CONVFACT1 FROM LG_058_ITMUNITA WHERE ITEMREF=ITM.LOGICALREF AND UNITLINEREF=(SELECT LOGICALREF FROM LG_058_UNITSETL WHERE UNITSETREF=ITM.UNITSETREF AND LINENR=2)) [2.BIRIM KATSAYI],<br \/>\n(SELECT CODE FROM LG_058_UNITSETL WHERE UNITSETREF=ITM.UNITSETREF AND LINENR=3) [3.BIRIM],<br \/>\n(SELECT CONVFACT1 FROM LG_058_ITMUNITA WHERE ITEMREF=ITM.LOGICALREF AND UNITLINEREF=(SELECT LOGICALREF FROM LG_058_UNITSETL WHERE UNITSETREF=ITM.UNITSETREF AND LINENR=3)) [3.BIRIM KATSAYI]<br \/>\nFROM LG_058_ITEMS ITM WHERE ITM.LOGICALREF IN<br \/>\n(select STOCKREF FROM LG_058_01_ORFLINE WHERE ORDFICHEREF=3)<\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<br \/>\nSELECT T.CONVFACT1,F.AMOUNT FROM LG_058_ITMUNITA T,LG_058_01_ORFLINE F<br \/>\nWHERE T.ITEMREF=F.STOCKREF AND T.LINENR=2 AND F.ORDFICHEREF=3<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SELECT CODE,NAME,UNITSETREF, (SELECT CODE FROM LG_058_UNITSETF WHERE LOGICALREF=ITM.UNITSETREF) AS BIRIMSETKODU, (SELECT NAME FROM LG_058_UNITSETF WHERE LOGICALREF=ITM.UNITSETREF) AS BIRIMSETADI, (SELECT CODE FROM LG_058_UNITSETL WHERE UNITSETREF=ITM.UNITSETREF AND LINENR=1) ANABIRIM, (SELECT CODE FROM LG_058_UNITSETL WHERE UNITSETREF=ITM.UNITSETREF AND LINENR=2) [2.BIRIM], (SELECT CONVFACT1 FROM LG_058_ITMUNITA WHERE ITEMREF=ITM.LOGICALREF AND UNITLINEREF=(SELECT LOGICALREF FROM LG_058_UNITSETL WHERE UNITSETREF=ITM.UNITSETREF AND LINENR=2)) [2.BIRIM KATSAYI], (SELECT CODE [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[],"class_list":["post-398","post","type-post","status-publish","format-standard","hentry","category-ozel-dokuman"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/398","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=398"}],"version-history":[{"count":2,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/398\/revisions"}],"predecessor-version":[{"id":400,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/398\/revisions\/400"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=398"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=398"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=398"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}