新wms中用到的视图

1入库的视图
CREATE VIEW viewRece AS SELECT number,SUM(qty) AS qtyRece,SUM(pcs) AS pcsRece FROM receive GROUP BY number
2出库的视图
CREATE VIEW viewShip AS SELECT id,number,SUM(qty) AS qtyShip,SUM(pcs) AS pcsShip FROM ship GROUP BY number;
3入库-出库，在库存的视
CREATE VIEW view_Inv AS SELECT R.number,R.qtyRece-IFNULL(S.qtyShip,0) AS qtyInv,R.pcsRece-IFNULL(S.pcsShip,0) AS pcsInv FROM viewRece R LEFT JOIN viewShip S ON R.number=S.number