TR_REVENUESPLITGIFTFEE_INSERTUPDATE_CURRENCY (Trigger)

                
                CREATE trigger [dbo].[TR_REVENUESPLITGIFTFEE_INSERTUPDATE_CURRENCY] on [dbo].[REVENUESPLITGIFTFEE] 
                after insert, update 
                not for replication
                as
                begin
                    set nocount on;
                    
                    if update(FEE)
                    begin
                        declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY(); 

                        update
                            dbo.REVENUESPLITGIFTFEE
                        set
                            REVENUESPLITGIFTFEE.ORGANIZATIONAMOUNT = REVENUESPLITGIFTFEE.FEE,
                            REVENUESPLITGIFTFEE.TRANSACTIONAMOUNT = REVENUESPLITGIFTFEE.FEE,
                            REVENUESPLITGIFTFEE.BASECURRENCYID = @ORGANIZATIONCURRENCYID,
                            REVENUESPLITGIFTFEE.TRANSACTIONCURRENCYID = @ORGANIZATIONCURRENCYID,
                            REVENUESPLITGIFTFEE.CHANGEDBYID = REVENUESPLITGIFTFEE.CHANGEDBYID,
                            REVENUESPLITGIFTFEE.DATECHANGED = REVENUESPLITGIFTFEE.DATECHANGED
                        from
                            inserted
                        inner join
                            dbo.REVENUESPLITGIFTFEE on inserted.ID = REVENUESPLITGIFTFEE.ID
                        where
                            REVENUESPLITGIFTFEE.ORGANIZATIONEXCHANGERATEID is null
                            and (REVENUESPLITGIFTFEE.BASECURRENCYID is null or REVENUESPLITGIFTFEE.BASECURRENCYID = @ORGANIZATIONCURRENCYID)
                            and REVENUESPLITGIFTFEE.BASEEXCHANGERATEID is null
                            and (REVENUESPLITGIFTFEE.TRANSACTIONCURRENCYID is null or REVENUESPLITGIFTFEE.TRANSACTIONCURRENCYID = @ORGANIZATIONCURRENCYID)
                            and (
                                REVENUESPLITGIFTFEE.ORGANIZATIONAMOUNT <> REVENUESPLITGIFTFEE.FEE
                                or REVENUESPLITGIFTFEE.TRANSACTIONAMOUNT <> REVENUESPLITGIFTFEE.FEE
                                or REVENUESPLITGIFTFEE.FEE = 0
                            );
                    end
                end