-- =============================================
-- 更改Bom物料的倒沖屬性!
-- wang jianli ad 2010-12-24
-- =============================================
select * from t_submessage
select * from sysobjects where name like '%message%' and xtype = 'U'
--FBackFlush = 1058 倒沖
--FBackFlush = 1059 非倒沖
--查看物料清單及相關(guān)屬性
select fbomnumber,a.fitemid ,b.fitemid, b.FBackFlush ,e.FErpClsID , f.fname
from icbom a , icbomchild b , t_icitem e ,t_submessage f
where a.finterid = b.finterid and
a.fitemid = e.fitemid and
e.FErpClsID = f.finterid and
f.fname like '%自制%' and (
e.fnumber like '3.%' or
e.fnumber like '1.%' )
--
-- update b set b.FBackFlush = 1058
-- from icbom a , icbomchild b , t_icitem e ,t_submessage f
-- where a.finterid = b.finterid and
-- a.fitemid = e.fitemid and
-- e.FErpClsID = f.finterid and
-- f.fname like '%自制%' and (
-- e.fnumber like '3.%' or
-- e.fnumber like '1.%' )
--
本站僅提供存儲服務(wù),所有內容均由用戶(hù)發(fā)布,如發(fā)現有害或侵權內容,請
點(diǎn)擊舉報。