TR_CHARGELINEITEM_LINEITEMANDCHARGEAREVALID (Trigger)

                
                    create trigger TR_CHARGELINEITEM_LINEITEMANDCHARGEAREVALID
                        on dbo.CHARGELINEITEM
                        for insert, update
                        not for replication as
                    begin
                        set nocount on;
                        begin try
                        
                            if exists (
                                select FINANCIALTRANSACTIONLINEITEM.ID
                                from inserted
                                    inner join dbo.FINANCIALTRANSACTIONLINEITEM
                                        on inserted.ID = FINANCIALTRANSACTIONLINEITEM.ID
                                where (FINANCIALTRANSACTIONLINEITEM.TYPECODE != 0)
                                )
                                    raiserror('ERR_CHARGELINEITEM_LINEITEMNOTVALID', 13,1);

                            if exists (
                                select FINANCIALTRANSACTION.ID
                                from inserted
                                    inner join dbo.FINANCIALTRANSACTIONLINEITEM
                                        on inserted.ID = FINANCIALTRANSACTIONLINEITEM.ID
                                    inner join dbo.FINANCIALTRANSACTION
                                        on FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = FINANCIALTRANSACTION.ID
                                where (FINANCIALTRANSACTION.TYPECODE != 104)
                                )
                                    raiserror('ERR_CHARGELINEITEM_CHARGENOTVALID', 13,1);

                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR;
                        end catch
                    end