TR_FINANCIALTRANSACTION_LINEITEM_NONEWLINEITEMSONDELETEDTRANSACTION (Trigger)

                
                    CREATE trigger TR_FINANCIALTRANSACTION_LINEITEM_NONEWLINEITEMSONDELETEDTRANSACTION 
                        on dbo.FINANCIALTRANSACTIONLINEITEM 
                        for insert, update
                        not for replication as
                    begin
                        set nocount on;
                        begin try
                            if exists(
                                select inserted.ID
                                from inserted
                                    inner join dbo.FINANCIALTRANSACTION
                                        on inserted.FINANCIALTRANSACTIONID = FINANCIALTRANSACTION.ID
                                where (not FINANCIALTRANSACTION.DELETEDON is null)
                                )
                                    raiserror('ERR_FINANCIALTRANSACTION_LINEITEM_NONEWLINEITEMSONDELETEDTRANSACTION', 13,1);
                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR;
                        end catch
                    end