-- ============================================= -- 更改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 非倒冲 --查看物料清单及相关属性
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.%' ) -- |
|