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