营销单据：价格低于价格清单需要审批

营销单据行价格低于价格清单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

效果图