材料出库单列表-汇总

材料出库单列表-汇总

 

SELECT cwhcode as '仓库编码', cwhname as '仓库',  cinvcode as '材料编码',  cinvname as '材料名称',  cdepcode as '部门编码', 

       cdepname as '部门', cinvm_unit as '主计量单位', Sum(iquantity)  as '数量' 

FROM recordoutlist 

where @start_bill_datetime> ddate and @end_bill_datetime 

GROUP BY cwhcode, cwhname, cinvcode, acinvname, cdepcode, cdepname, cinvm_unit

 

 

--recordoutlist View 材料出库单列表视图   

--recordoutq View   材料出库单主表视图

--recordoutsq View  材料出库单子表视图