TR_MKTSEGMENTATIONSEGMENTLIST_IU_ORGANIZATIONAMOUNTS

                    create trigger [dbo].[TR_MKTSEGMENTATIONSEGMENTLIST_IU_ORGANIZATIONAMOUNTS] on [dbo].[MKTSEGMENTATIONSEGMENTLIST] 
                    after insert, update 
                    not for replication
                    as
                    begin
                        set nocount on;

            if update(BASERENTALCOST) or update(BASEEXCHANGECOST) or update(RENTALCOSTADJUSTMENT) or update(EXCHANGECOSTADJUSTMENT)
            begin
              declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.[UFN_CURRENCY_GETORGANIZATIONCURRENCY](); 

                          update
                              dbo.[MKTSEGMENTATIONSEGMENTLIST]
                          set
                              [MKTSEGMENTATIONSEGMENTLIST].[ORGANIZATIONBASERENTALCOST] = [MKTSEGMENTATIONSEGMENTLIST].[BASERENTALCOST],
                [MKTSEGMENTATIONSEGMENTLIST].[ORGANIZATIONBASEEXCHANGECOST] = [MKTSEGMENTATIONSEGMENTLIST].[BASEEXCHANGECOST],
                [MKTSEGMENTATIONSEGMENTLIST].[ORGANIZATIONRENTALCOSTADJUSTMENT] = [MKTSEGMENTATIONSEGMENTLIST].[RENTALCOSTADJUSTMENT],
                [MKTSEGMENTATIONSEGMENTLIST].[ORGANIZATIONEXCHANGECOSTADJUSTMENT] = [MKTSEGMENTATIONSEGMENTLIST].[EXCHANGECOSTADJUSTMENT],
                [MKTSEGMENTATIONSEGMENTLIST].[BASECURRENCYID] = @ORGANIZATIONCURRENCYID,
                              [MKTSEGMENTATIONSEGMENTLIST].[CHANGEDBYID] = [MKTSEGMENTATIONSEGMENTLIST].[CHANGEDBYID],
                              [MKTSEGMENTATIONSEGMENTLIST].[DATECHANGED] = [MKTSEGMENTATIONSEGMENTLIST].[DATECHANGED]
                          from
                              inserted
                              inner join dbo.[MKTSEGMENTATIONSEGMENTLIST] on inserted.ID = [MKTSEGMENTATIONSEGMENTLIST].[ID]
                          where
                              [MKTSEGMENTATIONSEGMENTLIST].[ORGANIZATIONCURRENCYEXCHANGERATEID] is null
                              and ([MKTSEGMENTATIONSEGMENTLIST].[BASECURRENCYID] is null or [MKTSEGMENTATIONSEGMENTLIST].[BASECURRENCYID] = @ORGANIZATIONCURRENCYID)
                and
                  (
                                  [MKTSEGMENTATIONSEGMENTLIST].[ORGANIZATIONBASERENTALCOST] <> [MKTSEGMENTATIONSEGMENTLIST].[BASERENTALCOST]
                    or [MKTSEGMENTATIONSEGMENTLIST].[ORGANIZATIONBASEEXCHANGECOST] <> [MKTSEGMENTATIONSEGMENTLIST].[BASEEXCHANGECOST]
                    or [MKTSEGMENTATIONSEGMENTLIST].[ORGANIZATIONRENTALCOSTADJUSTMENT] <> [MKTSEGMENTATIONSEGMENTLIST].[RENTALCOSTADJUSTMENT]
                    or [MKTSEGMENTATIONSEGMENTLIST].[ORGANIZATIONEXCHANGECOSTADJUSTMENT] <> [MKTSEGMENTATIONSEGMENTLIST].[EXCHANGECOSTADJUSTMENT]
                    or ([MKTSEGMENTATIONSEGMENTLIST].[BASERENTALCOST] = 0 and [MKTSEGMENTATIONSEGMENTLIST].[BASEEXCHANGECOST] = 0 and [MKTSEGMENTATIONSEGMENTLIST].[RENTALCOSTADJUSTMENT] = 0 and [MKTSEGMENTATIONSEGMENTLIST].[EXCHANGECOSTADJUSTMENT] = 0)
                  );
            end
                    end