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
|
Trigger Definition
