if @object_type = '22' --服务采购订单限制必须填写科目
begin
if @transaction_type='A' OR @transaction_type = 'U'
begin
if exists(
SELECT T1.[AcctCode] FROM OPOR T0 INNER JOIN POR1 T1 ON T0.[DocEntry] = T1.[DocEntry]
WHERE T0.[DocType] ='S' AND T1.[AcctCode] IS NULL AND T1.DocEntry = @list_of_cols_val_tab_del
)
begin
select @error=1
select @error_message='服务采购订单限制必须填写科目!'
end
end
end声明：欢迎来到五六零学院。
