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

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'