create trigger TR_FINANCIALTRANSACTIONLINEITEMID_FINANCIALTRANSACTIONVALID
on dbo.CHARGELINEITEMRESPONSIBILITY
for insert, update, delete
not for replication as
begin
set nocount on;
begin try
if exists(
select FINANCIALTRANSACTION.ID
from inserted
inner join dbo.FINANCIALTRANSACTIONLINEITEM
on inserted.FINANCIALTRANSACTIONLINEITEMID = FINANCIALTRANSACTIONLINEITEM.ID
inner join dbo.FINANCIALTRANSACTION
on FINANCIALTRANSACTION.ID = FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID
where (FINANCIALTRANSACTIONLINEITEM.TYPECODE != 0) -- Is NOT a standard line item
or (FINANCIALTRANSACTION.TYPECODE != 104) -- The transaction is NOT a charge
)
raiserror('ERR_FINANCIALTRANSACTIONLINEITEMID_FINANCIALTRANSACTIONVALID', 13,1);
end try
begin catch
exec dbo.USP_RAISE_ERROR;
end catch
end
|
Trigger Definition
