TR_RECEIVABLECREDITLINEITEM_LINEITEMANDCREDITAREVALID (Trigger)

        
                    create trigger TR_RECEIVABLECREDITLINEITEM_LINEITEMANDCREDITAREVALID
                        on dbo.RECEIVABLECREDITLINEITEM
                        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_RECEIVABLECREDITLINEITEM_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 != 106)
                                )
                                    raiserror('ERR_RECEIVABLECREDITLINEITEM_CREDITNOTVALID', 13,1);

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