level 3
li01453
楼主
(Isnull(po_podetails.ireceivedqty,0) + Isnull(arrtmp.rdsquantity,0)) AS rdquantity,
(CASE
WHEN Isnull(inventory.igrouptype,0) = 1 THEN (Isnull(po_podetails.ireceivedqty,0) + Isnull(arrtmp.rdsquantity,0)) / unit2.ichangrate
ELSE (Isnull(po_podetails.ireceivednum,0) + Isnull(arrtmp.rdsnum,0))
END) AS rdnum,
(Isnull(potmp.iprice,0) + Isnull(arrtmp.rdsprice,0)) AS rdprice,
2014年07月13日 02点07分
1
(CASE
WHEN Isnull(inventory.igrouptype,0) = 1 THEN (Isnull(po_podetails.ireceivedqty,0) + Isnull(arrtmp.rdsquantity,0)) / unit2.ichangrate
ELSE (Isnull(po_podetails.ireceivednum,0) + Isnull(arrtmp.rdsnum,0))
END) AS rdnum,
(Isnull(potmp.iprice,0) + Isnull(arrtmp.rdsprice,0)) AS rdprice,