TR_INSTALLMENTSPLIT_INSERTUPDATE_CURRENCY

Trigger Definition

				
					CREATE trigger [dbo].[TR_INSTALLMENTSPLIT_INSERTUPDATE_CURRENCY] on [dbo].[INSTALLMENTSPLIT] 
					after insert, update 
					not for replication
					as
					begin
						set nocount on;
						
						if update(AMOUNT)
						begin
							declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY(); 

							update
								dbo.INSTALLMENTSPLIT
							set
								INSTALLMENTSPLIT.ORGANIZATIONAMOUNT = INSTALLMENTSPLIT.AMOUNT,
								INSTALLMENTSPLIT.TRANSACTIONAMOUNT = INSTALLMENTSPLIT.AMOUNT,
								INSTALLMENTSPLIT.BASECURRENCYID = @ORGANIZATIONCURRENCYID,
								INSTALLMENTSPLIT.TRANSACTIONCURRENCYID = @ORGANIZATIONCURRENCYID,
								INSTALLMENTSPLIT.CHANGEDBYID = INSTALLMENTSPLIT.CHANGEDBYID,
								INSTALLMENTSPLIT.DATECHANGED = INSTALLMENTSPLIT.DATECHANGED
							from
								inserted
							inner join
								dbo.INSTALLMENTSPLIT on inserted.ID = INSTALLMENTSPLIT.ID
							where
								INSTALLMENTSPLIT.ORGANIZATIONEXCHANGERATEID is null
								and (INSTALLMENTSPLIT.BASECURRENCYID is null or INSTALLMENTSPLIT.BASECURRENCYID = @ORGANIZATIONCURRENCYID)
								and INSTALLMENTSPLIT.BASEEXCHANGERATEID is null
								and (INSTALLMENTSPLIT.TRANSACTIONCURRENCYID is null or INSTALLMENTSPLIT.TRANSACTIONCURRENCYID = @ORGANIZATIONCURRENCYID)
								and (
									INSTALLMENTSPLIT.ORGANIZATIONAMOUNT <> INSTALLMENTSPLIT.AMOUNT
									or INSTALLMENTSPLIT.TRANSACTIONAMOUNT <> INSTALLMENTSPLIT.AMOUNT
									or INSTALLMENTSPLIT.AMOUNT = 0
								);
						end
					end