create trigger [dbo].[TR_REVENUETRIBUTETAXCLAIMAMOUNT_INSERTUPDATE_CURRENCY] on [dbo].[REVENUETRIBUTETAXCLAIMAMOUNT]
after insert, update
not for replication
as
begin
set nocount on;
declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();
-- If we try to save an amount without explicitly setting an organization amount
-- and an exchange rate, copy the amount to the organization amount field.
if update(TAXCLAIMAMOUNT)
begin
update
dbo.REVENUETRIBUTETAXCLAIMAMOUNT
set
REVENUETRIBUTETAXCLAIMAMOUNT.ORGANIZATIONTAXCLAIMAMOUNT = REVENUETRIBUTETAXCLAIMAMOUNT.TAXCLAIMAMOUNT,
REVENUETRIBUTETAXCLAIMAMOUNT.BASECURRENCYID = @ORGANIZATIONCURRENCYID,
REVENUETRIBUTETAXCLAIMAMOUNT.CHANGEDBYID = REVENUETRIBUTETAXCLAIMAMOUNT.CHANGEDBYID,
REVENUETRIBUTETAXCLAIMAMOUNT.DATECHANGED = REVENUETRIBUTETAXCLAIMAMOUNT.DATECHANGED
from
inserted
inner join
dbo.REVENUETRIBUTETAXCLAIMAMOUNT on inserted.ID = REVENUETRIBUTETAXCLAIMAMOUNT.ID
where
REVENUETRIBUTETAXCLAIMAMOUNT.ORGANIZATIONEXCHANGERATEID is null
and (REVENUETRIBUTETAXCLAIMAMOUNT.BASECURRENCYID is null or REVENUETRIBUTETAXCLAIMAMOUNT.BASECURRENCYID = @ORGANIZATIONCURRENCYID)
and
(
REVENUETRIBUTETAXCLAIMAMOUNT.ORGANIZATIONTAXCLAIMAMOUNT <> REVENUETRIBUTETAXCLAIMAMOUNT.TAXCLAIMAMOUNT
or REVENUETRIBUTETAXCLAIMAMOUNT.TAXCLAIMAMOUNT = 0
);
end
end
|
Trigger Definition
