TR_BATCHREVENUE_INSERTUPDATE_CURRENCY

        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