格搜:采购申请报表-目标价格等于该供应商最后一次报价价格
小于 1 分钟
- 示例代码
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