{"id":1573,"date":"2026-01-16T19:19:23","date_gmt":"2026-01-16T11:19:23","guid":{"rendered":"https:\/\/www.jumoon.top\/?p=1573"},"modified":"2026-01-16T19:19:23","modified_gmt":"2026-01-16T11:19:23","slug":"%e9%bc%8e%e6%8d%b7e10%e6%9f%a5%e8%af%a2bom%e6%98%8e%e7%bb%86%e4%b8%ad%e4%b8%8d%e5%8f%91%e6%96%99%e7%9a%84%e7%89%a9%e6%96%99","status":"publish","type":"post","link":"https:\/\/www.jumoon.top\/?p=1573","title":{"rendered":"\u9f0e\u6377E10\u67e5\u8be2BOM\u660e\u7ec6\u4e2d\u4e0d\u53d1\u6599\u7684\u7269\u6599"},"content":{"rendered":"\n<p class=\"has-text-align-center\">\u542b\u4e3b\u4ef6\u4fe1\u606f\u7248\u672c<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>select x.PLANT_NAME as \u5de5\u5382\u540d\u79f0,\nc.ITEM_CODE as \u4e3b\u4ef6\u7f16\u53f7,c.ITEM_NAME as \u4e3b\u4ef6\u540d\u79f0,c.ITEM_SPECIFICATION as \u4e3b\u4ef6\u89c4\u683c,\nd.ITEM_CODE as \u5b50\u4ef6\u7f16\u53f7,d.ITEM_NAME as \u5b50\u4ef6\u540d\u79f0,d.ITEM_SPECIFICATION as \u5b50\u4ef6\u89c4\u683c,\ncase b.ITEM_TYPE when '4' then '\u4e0d\u53d1\u6599' else '' end as \u53d1\u6599\u65b9\u5f0f,\nb.QTY_PER as \u7ec4\u6210\u7528\u91cf,b.DENOMINATOR as \u5e95\u6570,b.FIXED_LOSS_RATE as \u56fa\u5b9a\u635f\u8017\u91cf,b.DYNAMIC_LOSS_RATE as \u53d8\u52a8\u635f\u8017,\nCONVERT(char(10),b.EFFECTIVE_DATE, 120) as \u751f\u6548\u65e5\u671f,CONVERT(char(10),b.EXPRITY_DATE, 120) as \u5931\u6548\u65e5\u671f,\nb.STANDARD_COST_ITEM as \u6210\u672c\u8ba1\u7b97,b.REMARK as \u5907\u6ce8,\nCONVERT(char(10),a.ApproveDate, 120) as \u5ba1\u6838\u65e5\u671f,y.USER_NAME as \u5ba1\u6838\u4eba\n\n---a.REFERENCE_PLANT_ID,a.ITEM_ID,b.PARENT_ITEM_ID,b.SOURCE_ID_ROid\nFROM BOM a \nleft  join BOM_D b on b.BOM_ID=a.BOM_ID\nleft join ITEM c on a.ITEM_ID=c.ITEM_BUSINESS_ID\nleft join ITEM d on d.ITEM_BUSINESS_ID=b.SOURCE_ID_ROid\nleft join PLANT x on x.PLANT_ID=a.REFERENCE_PLANT_ID\nleft join &#91;USER] y on a.ApproveBy=y.USER_ID\nwhere b.ITEM_TYPE ='4' and a.ApproveStatus ='Y'\nORDER BY c.ITEM_CODE,x.PLANT_NAME<\/code><\/pre>\n\n\n\n<p class=\"has-text-align-center\">\u4e0d\u542b\u4e3b\u4ef6\u4fe1\u606f\u7248\u672c<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>select DISTINCT x.PLANT_NAME as \u5de5\u5382\u540d\u79f0,\nd.ITEM_CODE as \u5b50\u4ef6\u7f16\u53f7,d.ITEM_NAME as \u5b50\u4ef6\u540d\u79f0,d.ITEM_SPECIFICATION as \u5b50\u4ef6\u89c4\u683c,\ncase b.ITEM_TYPE when '4' then '\u4e0d\u53d1\u6599' else '' end as \u53d1\u6599\u65b9\u5f0f\n\n\n---a.REFERENCE_PLANT_ID,a.ITEM_ID,b.PARENT_ITEM_ID,b.SOURCE_ID_ROid\nFROM BOM a \nleft  join BOM_D b on b.BOM_ID=a.BOM_ID\nleft join ITEM c on a.ITEM_ID=c.ITEM_BUSINESS_ID\nleft join ITEM d on d.ITEM_BUSINESS_ID=b.SOURCE_ID_ROid\nleft join PLANT x on x.PLANT_ID=a.REFERENCE_PLANT_ID\nleft join &#91;USER] y on a.ApproveBy=y.USER_ID\nwhere b.ITEM_TYPE ='4' and a.ApproveStatus ='Y'\nORDER BY x.PLANT_NAME,d.ITEM_CODE\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u542b\u4e3b\u4ef6\u4fe1\u606f\u7248\u672c \u4e0d\u542b\u4e3b\u4ef6\u4fe1\u606f\u7248\u672c<\/p>\n","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-1573","post","type-post","status-publish","format-standard","hentry","category-19"],"_links":{"self":[{"href":"https:\/\/www.jumoon.top\/index.php?rest_route=\/wp\/v2\/posts\/1573","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=1573"}],"version-history":[{"count":1,"href":"https:\/\/www.jumoon.top\/index.php?rest_route=\/wp\/v2\/posts\/1573\/revisions"}],"predecessor-version":[{"id":1574,"href":"https:\/\/www.jumoon.top\/index.php?rest_route=\/wp\/v2\/posts\/1573\/revisions\/1574"}],"wp:attachment":[{"href":"https:\/\/www.jumoon.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1573"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jumoon.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1573"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jumoon.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1573"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}