TR_RECEIVABLECREDIT_DELETE (Trigger)

        
        CREATE trigger TR_RECEIVABLECREDIT_DELETE on dbo.RECEIVABLECREDIT for delete not for replication
        as begin
            set nocount on;
            begin try
                if exists(
                    select D.ID
                    from Deleted D
                    inner join dbo.FINANCIALTRANSACTION F on F.ID = D.ID
                    inner join dbo.FINANCIALTRANSACTIONLINEITEM FTLI on F.ID = FTLI.FINANCIALTRANSACTIONID
                    where FTLI.POSTSTATUSCODE = 2)
                begin
                    raiserror('The credit cannot be deleted because it has been posted.', 13,1)
                end
            end try
            begin catch
                exec dbo.USP_RAISE_ERROR;
            end catch
        end