格搜：采购申请报表-目标价格等于该供应商最后一次报价价格

SELECT top 1 T1.[Price] FROM OPQT T0  INNER JOIN PQT1 T1 ON T0.[DocEntry] = T1.[DocEntry] 
where t0.cardcode=$[$1470000006.1470000007.0]   and t1.itemcode=$[$1470000006.1470000003] AND T0.[CANCELED]='N' AND T0.[DocStatus]='O'
ORDER BY T0.[DocNum] DESC

五六零

海报 链接