TR_REVENUE_EXT_VALIDATE (Trigger)

        
CREATE trigger TR_REVENUE_EXT_VALIDATE on dbo.REVENUE_EXT for insert, update not for replication
as 
begin
  set nocount on

  begin try
    declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY(); 

    if exists(select *
              from inserted R 
              inner join dbo.FINANCIALTRANSACTION FT on FT.ID = R.ID 
              left outer join  dbo.V_BASECURRENCYFORFINANCIALTRANSACTION_I V with (noexpand) on FT.ID = V.FINANCIALTRANSACTIONID
              where not (dbo.UFN_REVENUE_RECEIPTAMOUNTVALID(R.RECEIPTAMOUNT, FT.TRANSACTIONAMOUNT, FT.TRANSACTIONCURRENCYID, FT.BASEAMOUNT, V.BASECURRENCYID, FT.BASEEXCHANGERATEID, FT.ORGAMOUNT, FT.ORGEXCHANGERATEID) = 1))
      raiserror('CK_REVENUE_RECEIPTAMOUNTLESSTHANGIFTAMOUNT', 13, 1);
  end try
  begin catch
    exec dbo.USP_RAISE_ERROR;
  end catch
end