TR_BATCHAUCTIONITEM_INSERTUPDATE_CURRENCY (Trigger)

                
                    create trigger [dbo].[TR_BATCHAUCTIONITEM_INSERTUPDATE_CURRENCY] on [dbo].[BATCHAUCTIONITEM] 
                    after insert
                    not for replication
                    as begin
                        set nocount on;

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