审批条件：营销单据-单价低于特殊价格则触发审批

--营销单据行价格低于特殊价格清单则触发审批

DECLARE @Price numeric(19, 6)
DECLARE @ItemCode VARCHAR(20) 

SELECT 
  @Price = $[$38.14.NUMBER] 
SELECT 
  @ItemCode = ISNULL($[$38.1.0], '') 

Select distinct 'true' 
  		        FROM OSPP T0
		WHERE  isnull(T0.Price,0)>0 and ISNULL(@Price, 0) < isnull(T0.Price,0) 
and t0.ItemCode=@ITEMcode

五六零

海报 链接