CASE 

        WHEN E.electronicdeal = 1 AND E.godkand = 0 THEN 'Nya'

        WHEN E.electronicdeal = 1 AND E.godkand = 1 THEN 'Nekat'

        WHEN E.electronicdeal = 1 AND E.godkand = 2 THEN 'Ångrat'

        WHEN E.electronicdeal = 1 AND E.godkand = 3 THEN 'Till XLN'

        WHEN E.electronicdeal = 1 AND E.godkand = 4 THEN 'Inkvitterat i XLN'

        WHEN E.electronicdeal = 1 AND E.godkand = 5 THEN 'Manuellt hanterad'

        WHEN E.electronicdeal = 1 AND E.godkand = 6 THEN 'Under utredning'

        WHEN E.electronicdeal = 1 AND E.godkand = 7 THEN 'Tidigare inkvitterad i XLN'

        WHEN E.electronicdeal = 1 AND E.godkand = 8 THEN 'Kontrolleras'

        WHEN E.electronicdeal = 1 AND E.godkand = 9 THEN 'Vänta på export'

        WHEN E.electronicdeal = 1 AND E.godkand = 10 THEN 'Flytt väntar på export'

        WHEN E.electronicdeal = 1 AND E.godkand = 20 THEN 'På väg till e-signering'

        WHEN E.electronicdeal = 1 AND E.godkand = 21 THEN 'Vänta på e-signering'

        WHEN E.electronicdeal = 1 AND E.godkand = 22 THEN 'Offert skickad'

        WHEN E.electronicdeal = 1 AND E.godkand = 99 THEN 'Ignoreras'

        ELSE '-'

    END AS Avtalsstatus,

    CASE 

        WHEN E.electronicdeal = 0 AND E.iFullmaktsStatus = 0 THEN 'Nya'

        WHEN E.electronicdeal = 0 AND E.iFullmaktsStatus = 1 THEN 'Under utredning'

        WHEN E.electronicdeal = 0 AND E.iFullmaktsStatus = 2 THEN 'Till Zavann'

        WHEN E.electronicdeal = 0 AND E.iFullmaktsStatus = 3 THEN 'Hos Zavann (aut)'

        WHEN E.electronicdeal = 0 AND E.iFullmaktsStatus = 4 THEN 'Manuell kontroll'

        WHEN E.electronicdeal = 0 AND E.iFullmaktsStatus = 5 THEN 'Till webbavtal'

        WHEN E.electronicdeal = 0 AND E.iFullmaktsStatus = 7 THEN 'Nekad manuellt'

        WHEN E.electronicdeal = 0 AND E.iFullmaktsStatus = 8 THEN 'Nekad'

        WHEN E.electronicdeal = 0 AND E.iFullmaktsStatus = 9 THEN 'Ångrad'

        WHEN E.electronicdeal = 0 AND E.iFullmaktsStatus = 10 THEN 'Påväg till Zavann (aut)'

        WHEN E.electronicdeal = 0 AND E.iFullmaktsStatus = 20 THEN 'Påväg till e-signering'

        WHEN E.electronicdeal = 0 AND E.iFullmaktsStatus = 21 THEN 'Vänta på e-signering'

        WHEN E.electronicdeal = 0 AND E.iFullmaktsStatus = 22 THEN 'Offert skickad'

        WHEN E.electronicdeal = 0 AND E.iFullmaktsStatus = 99 THEN 'Ignoreras'

        ELSE '-'

    END AS Fullmaktsavtalsstatus,