TR_FINANCIALTRANSACTIONLINEITEMID_FINANCIALTRANSACTIONVALID

                    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