TR_BANKACCOUNTADJUSTMENT_DELETE_POSTED

CREATE trigger dbo.TR_BANKACCOUNTADJUSTMENT_DELETE_POSTED ON dbo.BANKACCOUNTADJUSTMENT FOR DELETE NOT FOR REPLICATION AS
BEGIN
    SET NOCOUNT ON;

    if exists(select DELETED.ID    from DELETED
            inner join dbo.BANKACCOUNTTRANSACTION on DELETED.ID = BANKACCOUNTTRANSACTION.ID
            where BANKACCOUNTTRANSACTION.POSTSTATUSCODE = 0)
    begin
        RAISERROR ('ERR_DELETE_POSTED_TRANSACTION.',  16, 1)
        ROLLBACK TRANSACTION
    end
end