品号保存领料数量不可于工单需领数量

create trigger trigger_moctea
 
 --品号保存领料数量不可于工单需领数量
 on MOCTE
 FOR insert,update
 as
 begin
  declare @TE011 CHAR(4),@TE012 CHAR(12),@TE004 CHAR (30)--,@TE005 decimal(20)
  declare @TB004 decimal(20),@count decimal(20)
  select @TE011=TE011 FROM inserted
  select @TE012=TE012 FROM inserted
  SELECT @TE004=TE004 FROM inserted
  select @TB004=TB004 FROM MOCTB WHERE TB001=@TE011 AND TB002=@TE012 AND TB003=@TE004  
  SELECT @count=SUM(TE005) FROM MOCTE WHERE TE011=@TE011 AND TE012=@TE012 AND TE004=@TE004
 IF(@count>@TB004 AND @TE011!='516')
 begin
    raiserror('领料保存数量大于工单需领数量',16,0)
    rollback transaction
    end
    end