[易飞]库存分类情况表

/*
 *用途：库存分类情况表
 *作者：龚德辉 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