摘要：
--半成品生产领料select a.月,a.年,a.一类编码,a.存货一类,a.大类编码 as 父项大类编码,a.存货大类 as 父项存货大类,a.分类编码 as 父项分类编码,a.存货分类 as 父项存货分类,a.存货编码 as 父项存货编码,a.存货名称 as 父项存货名称,a.规格型号 as 阅读全文
摘要：
--收入重量汇总 select sz.月 as 月,sz.年 as 年,sz.产品系列 as 产品系列,sum(isnull(sz.销售收入,'0')+isnull(s.销售收入,'0'))as 销售收入,sum(sz.全部重量) as 全部重量from(select a.月 as 月,a.年 as 阅读全文
摘要：
--收发存汇总表 select ia.iYear as 年,ia.iMonth as 月,ia.cWhCode as 仓库编码,war.cWhName as 仓库,ia.cInvCode as 存货编码,invc.cInvCName as 存货分类,inv.cInvName as 存货名称,inv. 阅读全文
2
