TR_BANKACCOUNTADJUSTMENT_DELETE_POSTED (Trigger)

                
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