34,587
社区成员
发帖
与我相关
我的任务
分享
select 1 FSumSort,'1' as 序号,#temp2.产品长代码,物料名称,#temp2.规格型号,单位,数量,不含税金额/数量 as 不含税单价,不含税金额,不含税金额*0.17 as 税额,(不含税金额*0.17)+不含税金额 as 价税合计,领料部门
from #temp2 inner join t_ICItem on #temp2.产品长代码=t_ICItem.FNumber
union all
select 101 FSumSort,'' as 序号, @number1+'小计' as fnumber,'' as 物料名称,''as fmodel,'' as 单位,SUM(数量) as fqty,null as 不含税单价, SUM(#temp2.不含税金额) as 不含税金额,SUM(#temp2.不含税金额)*0.17 as 税额,SUM((不含税金额*0.17)+不含税金额) as 价税合计,'' as 领料部门
from #temp2