TR_BATCHREVENUE_INSERTUPDATE_CURRENCY (Trigger)

            
                CREATE trigger [dbo].[TR_BATCHREVENUE_INSERTUPDATE_CURRENCY] on [dbo].[BATCHREVENUE] 
                after insert
                not for replication
                as begin
                    set nocount on;

                    update dbo.BATCHREVENUE
                        set BATCHREVENUE.BASECURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY(),
                            BATCHREVENUE.TRANSACTIONCURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY(),
                            BATCHREVENUE.CHANGEDBYID = BATCHREVENUE.CHANGEDBYID,
                            BATCHREVENUE.DATECHANGED = BATCHREVENUE.DATECHANGED
                    from inserted
                    inner join dbo.BATCHREVENUE on inserted.ID = BATCHREVENUE.ID
                    where BATCHREVENUE.BASECURRENCYID is null
                    and BATCHREVENUE.TRANSACTIONCURRENCYID is null;
                end