/*
*用途：库存分类情况表
*作者：龚德辉 2011-02-13
*/
CREATE proc UP_InvItemPriceChart as begin
Select a.MC001 品号,b.MB002 品名,b.MB003 规格,b.MB004 单位,c.MC002 仓库,a.MC007 库存数量,a.MC008 库存金额, case when left(b.MB003,2)='AZ' then '继电器' when left(b.MB003,2)='ZE' then '贸易品' when left(a.MC001,1)='1' then '成品' when left(b.MB001,1)<>'1' THEN '原材料'
END AS 种类, case when left(b.MB003,2)='AZ' then '继电器' when left(b.MB003,2)='ZE' then '贸易品' when left(a.MC001,1)='1' then '成品' when left(b.MB001,1)<>'1' and left(a.MC001,3)='301' then 'LCD' when left(b.MB001,1)<>'1' and left(a.M
