TR_BATCHMEMBERSHIPDUES_INSERTUPDATE_CURRENCY (Trigger)

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

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