TR_STEWARDSHIPPLAN_INSERT_BASECURRENCYID (Trigger)

        
                    CREATE trigger [dbo].[TR_STEWARDSHIPPLAN_INSERT_BASECURRENCYID] on [dbo].[STEWARDSHIPPLAN] 
                    after insert
                    not for replication
                    as
                    begin
                        set nocount on;
                        
                        update dbo.STEWARDSHIPPLAN set
                            STEWARDSHIPPLAN.BASECURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY(),
                            STEWARDSHIPPLAN.CHANGEDBYID = STEWARDSHIPPLAN.CHANGEDBYID,
                            STEWARDSHIPPLAN.DATECHANGED = STEWARDSHIPPLAN.DATECHANGED
                        from 
                            inserted
                            inner join dbo.STEWARDSHIPPLAN on inserted.ID = STEWARDSHIPPLAN.ID
                        where
                            inserted.BASECURRENCYID is null;
                    end