[易飞]品号属性的定期监控

T-SQL

--1.所有材料设置超交管理 UPDATE INVMB SET MB087='Y' FROM INVMB --2.设置类别管理仓管(原材料) --310-320 设置仓管码310 --其他取前三位 UPDATE INVMB SET MB006='310' FROM INVMB WHERE LEFT(MB001,1)='3' and (LEFT(MB001,3)>'309' and LEFT(MB001,3)<'321') UPDATE INVMB SET MB006=LEFT(MB001,3) FROM INVMB WHERE LEFT(MB001,1)='3' and (LEFT(MB001,3)<'310' or LEFT(MB001,3)>'320') --3.库存单位为PCS或者SET 领用倍量改成1 UPDATE INVMB SET MB041=1 FROM INVMB WHERE MB004 IN('PCS','pcs','set','SET') --4.所有材料超领率0.01，超入率0.01，缺领率0.05 UPDATE INVMB SET MB401=0.01,MB402=0.01,MB403=0.05 FROM INVMB --5.成品品检验码 UPDATE INVMB set MB043='2' FROM INVMB WHERE LEFT(MB001,1)in ('1','2') --6.前置天数 1开头10，2开头5 UPDATE INVMB set MB036=10 FROM INVMB WHERE LEFT(MB001,1)='1' UPDATE INVMB set MB036=5 FROM INVMB WHERE LEFT(MB001,1)='2'