{"id":1474,"date":"2026-01-12T21:56:16","date_gmt":"2026-01-12T13:56:16","guid":{"rendered":"https:\/\/www.jumoon.top\/?p=1474"},"modified":"2026-01-12T21:56:16","modified_gmt":"2026-01-12T13:56:16","slug":"%e9%bc%8e%e6%8d%b7e10%e6%9f%a5%e8%af%a2%e5%8c%85%e5%90%ab%e6%8c%87%e5%ae%9a%e5%93%81%e5%8f%b7%e7%9a%84%e6%98%8e%e7%bb%86%e9%87%87%e8%b4%ad%e8%ae%a2%e5%8d%95","status":"publish","type":"post","link":"https:\/\/www.jumoon.top\/?p=1474","title":{"rendered":"\u9f0e\u6377E10\u67e5\u8be2\u5305\u542b\u6307\u5b9a\u54c1\u53f7\u7684\u660e\u7ec6\u91c7\u8d2d\u8ba2\u5355"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT\n\tA.DOC_NO AS \u5355\u53f7,\n\tA.DOC_DATE AS \u5355\u636e\u65e5\u671f,\n\te.USER_NAME AS \u5236\u5355\u4eba,\n\tc.ITEM_CODE AS \u54c1\u53f7,\n\tB.ITEM_DESCRIPTION AS \u54c1\u540d,\n\tB.ITEM_SPECIFICATION AS \u89c4\u683c,\n\t--c.ITEM_NAME as \u65b0\u54c1\u540d,\n\t--c.ITEM_SPECIFICATION as \u65b0\u89c4\u683c,\n\t--c.ITEM_DESC as \u54c1\u53f7\u63cf\u8ff0,\n\td.PROJECT_CODE AS \u9879\u76ee\u53f7,\n\tSUPPLIER_FULL_NAME AS \u91c7\u8d2d\u4f9b\u5e94\u5546,\n\nROUND(A.AMOUNT_UNINCLUDE_TAX_BC + A.TAX_BC,2) AS &#91;\u672c\u5e01\u5408\u8ba1],\nROUND(A.AMOUNT_UNINCLUDE_TAX_OC+A.TAX_OC,2) AS &#91;\u539f\u5e01\u5408\u8ba1],\nROUND(A.UNSETTLE_ARR_AMT_UN_TAX_OC + A.UNSETTLE_ARR_TAX_OC ,2) as \u672a\u7ed3\u7b97\u5df2\u5230\u8d27\u539f\u5e01,\nROUND(A.RECEIPTED_AMT_UN_TAX_OC+A.RECEIPTED_TAX_OC,2) as \u9700\u7ed3\u7b97\u5df2\u5165\u5e93\u539f\u5e01,\nROUND(A.SETTLEMENT_AMT_UN_TAX_OC+A.SETTLEMENT_TAX_OC,2) as \u5df2\u7ed3\u7b97\u539f\u5e01,\n\nCASE \nWHEN A.RECEIPTED_AMT_UN_TAX_OC+A.RECEIPTED_TAX_OC = 0   THEN '\u8fd8\u672a\u5165\u5e93'\nWHEN CAST( A.RECEIPTED_AMT_UN_TAX_OC+A.RECEIPTED_TAX_OC  AS INT) - CAST (A.SETTLEMENT_AMT_UN_TAX_OC+A.SETTLEMENT_TAX_OC AS INT) = 0 THEN '\u5df2\u7ed3\u7b97\u5b8c' ELSE '\u672a\u7ed3\u7b97\u5b8c' \nEND AS \u7ed3\u7b97\u72b6\u6001\n\nFROM\n\tPURCHASE_ORDER A\n\tLEFT JOIN PURCHASE_ORDER_D B ON A.PURCHASE_ORDER_ID= B.PURCHASE_ORDER_ID\n\tLEFT JOIN ITEM c ON B.ITEM_ID= c.ITEM_BUSINESS_ID\n\tLEFT JOIN PROJECT d ON B.PROJECT_ID = d.PROJECT_ID\n\tLEFT JOIN &#91;USER] e ON A.CreateBy  = e.USER_ID\n\tLEFT JOIN PURCHASE_ORDER_SD  F on B.PURCHASE_ORDER_D_ID= F.PURCHASE_ORDER_D_ID\nwhere c.ITEM_CODE in (select Code from ITEMUP1) \n--where A.DOC_NO = '3500-202403130008'---and c.ITEM_DESC &lt;> ''\norder by A.DOC_DATE desc<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","site-transparent-header":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[19],"tags":[],"class_list":["post-1474","post","type-post","status-publish","format-standard","hentry","category-19"],"_links":{"self":[{"href":"https:\/\/www.jumoon.top\/index.php?rest_route=\/wp\/v2\/posts\/1474","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jumoon.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jumoon.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jumoon.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jumoon.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1474"}],"version-history":[{"count":1,"href":"https:\/\/www.jumoon.top\/index.php?rest_route=\/wp\/v2\/posts\/1474\/revisions"}],"predecessor-version":[{"id":1475,"href":"https:\/\/www.jumoon.top\/index.php?rest_route=\/wp\/v2\/posts\/1474\/revisions\/1475"}],"wp:attachment":[{"href":"https:\/\/www.jumoon.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1474"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jumoon.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1474"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jumoon.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1474"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}