CREATE trigger [dbo].[TR_PLANNEDGIFTADDITIONDESIGNATION_INSERTUPDATE_CURRENCY] on [dbo].[PLANNEDGIFTADDITIONDESIGNATION]
after insert, update
not for replication
as
begin
set nocount on;
if update(AMOUNT)
begin
declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();
update
dbo.PLANNEDGIFTADDITIONDESIGNATION
set
PLANNEDGIFTADDITIONDESIGNATION.ORGANIZATIONAMOUNT = PLANNEDGIFTADDITIONDESIGNATION.AMOUNT,
PLANNEDGIFTADDITIONDESIGNATION.TRANSACTIONAMOUNT = PLANNEDGIFTADDITIONDESIGNATION.AMOUNT,
PLANNEDGIFTADDITIONDESIGNATION.BASECURRENCYID = @ORGANIZATIONCURRENCYID,
PLANNEDGIFTADDITIONDESIGNATION.TRANSACTIONCURRENCYID = @ORGANIZATIONCURRENCYID,
PLANNEDGIFTADDITIONDESIGNATION.CHANGEDBYID = PLANNEDGIFTADDITIONDESIGNATION.CHANGEDBYID,
PLANNEDGIFTADDITIONDESIGNATION.DATECHANGED = PLANNEDGIFTADDITIONDESIGNATION.DATECHANGED
from
inserted
inner join
dbo.PLANNEDGIFTADDITIONDESIGNATION on inserted.ID = PLANNEDGIFTADDITIONDESIGNATION.ID
where
PLANNEDGIFTADDITIONDESIGNATION.ORGANIZATIONEXCHANGERATEID is null
and (PLANNEDGIFTADDITIONDESIGNATION.BASECURRENCYID is null or PLANNEDGIFTADDITIONDESIGNATION.BASECURRENCYID = @ORGANIZATIONCURRENCYID)
and PLANNEDGIFTADDITIONDESIGNATION.BASEEXCHANGERATEID is null
and (PLANNEDGIFTADDITIONDESIGNATION.TRANSACTIONCURRENCYID is null or PLANNEDGIFTADDITIONDESIGNATION.TRANSACTIONCURRENCYID = @ORGANIZATIONCURRENCYID)
and (
PLANNEDGIFTADDITIONDESIGNATION.ORGANIZATIONAMOUNT <> PLANNEDGIFTADDITIONDESIGNATION.AMOUNT
or PLANNEDGIFTADDITIONDESIGNATION.TRANSACTIONAMOUNT <> PLANNEDGIFTADDITIONDESIGNATION.AMOUNT
or PLANNEDGIFTADDITIONDESIGNATION.AMOUNT = 0
);
end
end
|
Trigger Definition
