TR_FINANCIALTRANSACTIONLINEITEM_DELETE (Trigger)

                
                CREATE trigger TR_FINANCIALTRANSACTIONLINEITEM_DELETE on dbo.FINANCIALTRANSACTIONLINEITEM for delete not for replication
                as begin
                    set nocount on;
                        if exists(
                            select D.ID
                            from Deleted D
                            where D.POSTSTATUSCODE = 2)
                        begin
                            raiserror('The financial transaction line item cannot be deleted because it has been posted', 13,1)
                        end
                end