-------------------------------------------------
--方案名称：价格低于基础价格清单则审批
--使用说明：营销单据行价格低于价格清单1则触发审批
-------------------------------------------------

DECLARE @Price numeric(19, 6)
DECLARE @ItemCode VARCHAR(20) 
SELECT 
  @Price = $[$38.14.NUMBER] 
SELECT 
  @ItemCode = ISNULL($[$38.1.0], '') 
SELECT 
  'TRUE' 
FROM 
  ITM1 T0 
WHERE 
  T0.[PriceList] = '1' 
  AND T0.[ItemCode] = ISNULL(@ItemCode, '') 
  AND ISNULL(T0.[Price], 0)> ISNULL(@Price, 0)

价格清单编号查询

SELECT T0.[ListNum], T0.[ListName] FROM OPLN T0

五六零

海报 链接