COGNOS QUERY STRUCTURE,1,1 DATABASE,O21_SKR51 DATASOURCENAME,D:\Gaps\Portal\System\IQD\NW\NW_GW_VK_Stk_2.imr TITLE,NW_GW_VK_Stk_2.imr BEGIN SQL select T1."UNIT_NUMBER" as c1, T1."BASIS_NUMBER" as c2, T1."ECC_STATUS" as c3, T1."VEHICLE_TYPE" as c4, T2."VEHICLE_TYPE" as c5, T2."VEHICLE_TYPE_TEXT" as c6, T1."CAR_CREATION_DATE" as c7, T1."DEPRECIATION" as c8, T1."BOOK_KEEPING_CODE" as c9, T3."BOOK_KEEPING_CODE" as c10, T3."SPECIFY" as c11, T1."MILEAGE" as c12, T1."PURCH_DEPARTMENT" as c13, T1."PURCH_SALSMAN_CODE" as c14, T1."PURCH_DATE" as c15, T1."RECEPTION_DATE" as c16, T1."SALES_DEPARTMENT" as c17, T4."DEPARTMENT_TYPE_ID" as c18, T4."DESCRIPTION" as c19, T1."SALE_SALESMAN" as c20, T5."SELLER_CODE" as c21, T5."SEL_NAME" as c22, T5."SEL_FAMILY_NAME" as c23, T1."SALE_INV_NUMBER" as c24, T1."SALE_DATE" as c25, T1."BUD_SALE_DET" as c26, T1."BUD_PURCH_PRICE" as c27, T1."BUD_REG_FEE" as c28, T1."BUD_DEDUCT_FEE" as c29, T1."BUD_COST" as c30, T1."PURCH_PRICE_UNIT" as c31, T1."COST_UNIT" as c32, T1."SALES_PRICE_UNIT" as c33, T1."REG_FEE" as c34, T1."STOCK_DAYS" as c35, T1."BUYING_ORDER_NO" as c36, T1."BUYING_ORDER_DATE" as c37, T1."PA_NUMBER" as c38, T1."LOCATION_CODE" as c39, T1."OWNER" as c40, T1."PREV_OWNER" as c41, T1."ACCOUNT_PURCHASE" as c42, T1."ACCOUNT_SALES" as c43, T6."CUSTOMER_NUMBER" as c44, T6."NAME" as c45, T6."CUSTOMER_GROUP" as c46, T7."CUSTOMER_GROUP" as c47, T7."CUST_GROUP_SPECIFY" as c48, T1."ORDER_ARRIVAL_DATE" as c49, T1."ORDER_CONFIRM_DATE" as c50, T1."CONTRACT_DATE" as c51, T8."REGISTER_NUMBER" as c52, T8."CHASSIS_NUMBER" as c53, T8."OWNER_CODE" as c54, T8."FIRST_REG_DATE" as c55, T8."LATEST_REG_DATE" as c56, T8."ARRIVAL_DATE" as c57, T8."SALESMAN_BUY" as c58, T8."SALESMAN_SALE" as c59, T8."MODEL_TEXT" as c60, T8."COLOUR_CF" as c61, T8."MODEL_LINE" as c62, T9."MODEL_LINE" as c63, T9."MOD_LIN_SPECIFY" as c64, T8."WORKSHOP_MODEL" as c65, T8."MILEAGE" as c66, T8."MOTOR_CODE" as c67, T8."DRIVE_CODE" as c68, T8."COLOUR_CODE" as c69, T8."MAKE" as c70, T8."MAKE_CD" as c71, T10."GLOBAL_MAKE_CD" as c72, T10."DESCRIPTION" as c73, T8."ORIG_INV_DATE" as c74, T8."LATEST_INV_DATE" as c75, T1."SALE_DATE" as c76, '1' as c77, '01' as c78, CASE WHEN (T11."ACCOUNT_NO" <> ' ') THEN ((rtrim(T5."SEL_NAME")) || ' - ' || T11."ACCOUNT_NO") ELSE ((rtrim(T5."SEL_NAME")) || ' - ' || T5."SELLER_CODE") END as c79, T10."DESCRIPTION" as c80, T9."MOD_LIN_SPECIFY" as c81, T8."MODEL_TEXT" as c82, T8."CHASSIS_NUMBER" as c83, CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END as c84, T1."VEHICLE_TYPE" || ' - ' || T2."VEHICLE_TYPE_TEXT" as c85, T6."CUSTOMER_NUMBER" || '- ' || T6."NAME" as c86, T6."CUSTOMER_GROUP" || ' - ' || T7."CUST_GROUP_SPECIFY" as c87, '' as c88, T8."COLOUR_CODE" || ' - ' || T8."COLOUR_CF" as c89, CASE WHEN (T1."ECC_STATUS" = '21') THEN ('21 - Vorlauf') WHEN (T1."ECC_STATUS" = '25') THEN ('25 - für Kd best. FZG') WHEN (T1."ECC_STATUS" = '41') THEN ('41 - Bestand') WHEN (T1."ECC_STATUS" = '44') THEN ('44 - am Hof nicht fakt.') WHEN (T1."ECC_STATUS" = '64') THEN ('64 - verkauft') ELSE null END as c90, (od_left(T1."UNIT_NUMBER",7)) || ' / ' || (od_left(T1."BASIS_NUMBER",7)) || ' - ' || T8."CHASSIS_NUMBER" as c91, CASE WHEN (T8."ORIG_INV_DATE" IS NOT NULL) THEN ((od_left(T1."UNIT_NUMBER",7)) || ' / ' || (od_left(T1."BASIS_NUMBER",8)) || ' - ' || T1."OWNER" || ' - ' || (asciiz(extract(YEAR FROM T8."ORIG_INV_DATE"),4) || '-' || asciiz(extract(MONTH FROM T8."ORIG_INV_DATE"),2) || '-' || asciiz(extract(DAY FROM T8."ORIG_INV_DATE"),2))) ELSE ((od_left(T1."UNIT_NUMBER",7)) || ' / ' || (od_left(T1."BASIS_NUMBER",8)) || ' - ' || T1."OWNER") END as c92, ((od_left(T1."UNIT_NUMBER",7)) || ' / ' || (od_left(T1."BASIS_NUMBER",7)) || ' - ' || T8."CHASSIS_NUMBER") || ' - ' || T1."VEHICLE_TYPE" as c93, T12."SEL_NAME" as c94, T12."SEL_NAME" as c95, T1."PREV_OWNER" as c96, CASE WHEN (T12."SEL_NAME" IS NULL) THEN (' - ' || ' / ' || T1."PREV_OWNER") ELSE (T12."SEL_NAME" || ' / ' || T1."PREV_OWNER") END as c97, T8."MODEL_TEXT" as c98, (CASE WHEN (T11."ACCOUNT_NO" <> ' ') THEN ((rtrim(T5."SEL_NAME")) || ' - ' || T11."ACCOUNT_NO") ELSE ((rtrim(T5."SEL_NAME")) || ' - ' || T5."SELLER_CODE") END) || ' / ' || (T6."CUSTOMER_NUMBER" || '- ' || T6."NAME") as c99, 1 as c100, CASE WHEN (T1."RECEPTION_DATE" IS NULL) THEN ((extract(DAY FROM (now()) - T1."PURCH_DATE"))) ELSE ((extract(DAY FROM (now()) - T1."RECEPTION_DATE"))) END as c101, T11."BIRTH_PLACE" as c102, T11."BANK_NAME" as c103, (rtrim(T1."BOOK_KEEPING_CODE")) as c104, (length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1) as c105, CASE WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 5)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 4 for 2))) WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 4)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 3 for 2))) WHEN ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Gebrauchtwagen') THEN ('GW') ELSE null END as c106, CASE WHEN ((CASE WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 5)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 4 for 2))) WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 4)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 3 for 2))) WHEN ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Gebrauchtwagen') THEN ('GW') ELSE null END) = '10') THEN ('10 - Privatkunde') WHEN ((CASE WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 5)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 4 for 2))) WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 4)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 3 for 2))) WHEN ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Gebrauchtwagen') THEN ('GW') ELSE null END) IN ('20','30','32','33')) THEN ('30 - Großkunde') WHEN ((CASE WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 5)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 4 for 2))) WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 4)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 3 for 2))) WHEN ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Gebrauchtwagen') THEN ('GW') ELSE null END) = '12') THEN ('12 - Leasing') WHEN ((CASE WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 5)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 4 for 2))) WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 4)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 3 for 2))) WHEN ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Gebrauchtwagen') THEN ('GW') ELSE null END) = '80') THEN ('80 - Händlertausch') WHEN ((CASE WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 5)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 4 for 2))) WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 4)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 3 for 2))) WHEN ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Gebrauchtwagen') THEN ('GW') ELSE null END) = 'GW') THEN ('GW') ELSE ('nicht zuzuordnen') END as c107, CASE WHEN ((substring((CASE WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 5)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 4 for 2))) WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 4)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 3 for 2))) WHEN ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Gebrauchtwagen') THEN ('GW') ELSE null END) from 1 for 1)) = '1') THEN ('Privatkunde') WHEN ((substring((CASE WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 5)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 4 for 2))) WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 4)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 3 for 2))) WHEN ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Gebrauchtwagen') THEN ('GW') ELSE null END) from 1 for 1)) IN ('2','3')) THEN ('Großkunde') WHEN ((substring((CASE WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 5)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 4 for 2))) WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 4)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 3 for 2))) WHEN ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Gebrauchtwagen') THEN ('GW') ELSE null END) from 1 for 1)) = '8') THEN ('Händlertausch') ELSE ((CASE WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 5)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 4 for 2))) WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 4)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 3 for 2))) WHEN ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Gebrauchtwagen') THEN ('GW') ELSE null END)) END as c108, CASE WHEN ((((substring((CASE WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 5)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 4 for 2))) WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 4)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 3 for 2))) WHEN ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Gebrauchtwagen') THEN ('GW') ELSE null END) from 2 for 1)) = '0') or ((substring((CASE WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 5)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 4 for 2))) WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 4)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 3 for 2))) WHEN ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Gebrauchtwagen') THEN ('GW') ELSE null END) from 2 for 1)) = '3')) or (T1."BOOK_KEEPING_CODE" IN ('DZ100 ','RZ100 ','RZ120 ','RZ130 ','RG100 ','M0P10 ','EE100 ','EZ100 ','M0P13 ','RM100 ','DE100 ','RM113 ','M6P10 '))) THEN ('Bar') WHEN (((substring((CASE WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 5)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 4 for 2))) WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 4)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 3 for 2))) WHEN ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Gebrauchtwagen') THEN ('GW') ELSE null END) from 2 for 1)) = '1') or (T1."BOOK_KEEPING_CODE" IN ('DZ111 ','RZ111 ','RZ121 ','RZ131 ','M0P11 ','RG111 ','RM111 '))) THEN ('Finanzierung') WHEN (((substring((CASE WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 5)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 4 for 2))) WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and (((length(((rtrim(T1."BOOK_KEEPING_CODE"))) || 'Z') - 1)) = 4)) THEN ((substring(T1."BOOK_KEEPING_CODE" from 3 for 2))) WHEN ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Gebrauchtwagen') THEN ('GW') ELSE null END) from 2 for 1)) = '2') or (T1."BOOK_KEEPING_CODE" IN ('DZ112 ','RZ112 ','RZ122 ','RZ132 ','M0P12 ','RG112 ','RM112 '))) THEN ('Leasing') ELSE ('Zahlart fehlt') END as c109, T13."FLEET_CODE_GMD" as c110, T13."DRIVE_GMD" as c111, T1."LOCATION_CODE" as c112, CASE WHEN (T13."FLEET_CODE_GMD" = '0922 ') THEN ('Opel Rent-Einstellung') WHEN (T13."DRIVE_GMD" = 'L') THEN ('VFW-Einstellung') ELSE null END as c113, CASE WHEN (((T1."VEHICLE_TYPE" IN ('V','T')) and ((extract(DAY FROM T1."SALE_DATE" - T8."FIRST_REG_DATE")) >= 366)) and (T8."OPTIONAL_DATE_1" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ('Gebrauchtwagen') ELSE ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END)) END as c114, CASE WHEN ((((CASE WHEN (((T1."VEHICLE_TYPE" IN ('V','T')) and ((extract(DAY FROM T1."SALE_DATE" - T8."FIRST_REG_DATE")) >= 366)) and (T8."OPTIONAL_DATE_1" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ('Gebrauchtwagen') ELSE ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END)) END) <> 'Gebrauchtwagen') and ((CASE WHEN (T13."FLEET_CODE_GMD" = '0922 ') THEN ('Opel Rent-Einstellung') WHEN (T13."DRIVE_GMD" = 'L') THEN ('VFW-Einstellung') ELSE null END) = 'VFW-Einstellung')) and (T8."LATEST_REG_DATE" <> TIMESTAMP '1800-01-01 00:00:00.000')) THEN ('V - Vorführwagen') WHEN (T1."BOOK_KEEPING_CODE" LIKE 'RZ12%') THEN ('R - Jahreswagen') ELSE ((T1."VEHICLE_TYPE" || ' - ' || T2."VEHICLE_TYPE_TEXT")) END as c115, T1."DELIVERY_DATE_VEH" as c116, CASE WHEN ((((CASE WHEN (T13."FLEET_CODE_GMD" = '0922 ') THEN ('Opel Rent-Einstellung') WHEN (T13."DRIVE_GMD" = 'L') THEN ('VFW-Einstellung') ELSE null END) IN ('VFW-Einstellung','Opel Rent-Einstellung')) and ((T6."CUSTOMER_GROUP" || ' - ' || T7."CUST_GROUP_SPECIFY") = '20 - AOV ')) and ((CASE WHEN (((T1."VEHICLE_TYPE" IN ('V','T')) and ((extract(DAY FROM T1."SALE_DATE" - T8."FIRST_REG_DATE")) >= 366)) and (T8."OPTIONAL_DATE_1" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ('Gebrauchtwagen') ELSE ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END)) END) = 'Neuwagen')) THEN ('raus') WHEN (((((CASE WHEN (T13."FLEET_CODE_GMD" = '0922 ') THEN ('Opel Rent-Einstellung') WHEN (T13."DRIVE_GMD" = 'L') THEN ('VFW-Einstellung') ELSE null END) IN ('VFW-Einstellung','Opel Rent-Einstellung')) and (T6."CUSTOMER_NUMBER" = '100001')) and (T1."OWNER" IN ('Gebr. Barth GmbH','Autohaus Brock e.K.','Auto-Depping GmbH','Heinrich Freitag GmbH & Co.KG','Autohaus Graver','H.O. Automobile GmbH','Kauhs GmbH & Co. KG','Kauhs GmbH & Co.KG','Jens-Heinrich Kaulfers','Autoland Schilling GmbH','Auto-Thielmann GmbH','Autovermie Auto-Thielmann GmbH','Gebr. Vogel GmbH','Wehmeier GmbH & Co.KG','Ostermeier GmbH','Auto Kemper','Auto Kemper GbR','Auto Kemper oHG'))) and ((CASE WHEN (((T1."VEHICLE_TYPE" IN ('V','T')) and ((extract(DAY FROM T1."SALE_DATE" - T8."FIRST_REG_DATE")) >= 366)) and (T8."OPTIONAL_DATE_1" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ('Gebrauchtwagen') ELSE ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END)) END) = 'Neuwagen')) THEN ('raus') ELSE null END as c117, CASE WHEN (((CASE WHEN ((((CASE WHEN (T13."FLEET_CODE_GMD" = '0922 ') THEN ('Opel Rent-Einstellung') WHEN (T13."DRIVE_GMD" = 'L') THEN ('VFW-Einstellung') ELSE null END) IN ('VFW-Einstellung','Opel Rent-Einstellung')) and ((T6."CUSTOMER_GROUP" || ' - ' || T7."CUST_GROUP_SPECIFY") = '20 - AOV ')) and ((CASE WHEN (((T1."VEHICLE_TYPE" IN ('V','T')) and ((extract(DAY FROM T1."SALE_DATE" - T8."FIRST_REG_DATE")) >= 366)) and (T8."OPTIONAL_DATE_1" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ('Gebrauchtwagen') ELSE ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END)) END) = 'Neuwagen')) THEN ('raus') WHEN (((((CASE WHEN (T13."FLEET_CODE_GMD" = '0922 ') THEN ('Opel Rent-Einstellung') WHEN (T13."DRIVE_GMD" = 'L') THEN ('VFW-Einstellung') ELSE null END) IN ('VFW-Einstellung','Opel Rent-Einstellung')) and (T6."CUSTOMER_NUMBER" = '100001')) and (T1."OWNER" IN ('Gebr. Barth GmbH','Autohaus Brock e.K.','Auto-Depping GmbH','Heinrich Freitag GmbH & Co.KG','Autohaus Graver','H.O. Automobile GmbH','Kauhs GmbH & Co. KG','Kauhs GmbH & Co.KG','Jens-Heinrich Kaulfers','Autoland Schilling GmbH','Auto-Thielmann GmbH','Autovermie Auto-Thielmann GmbH','Gebr. Vogel GmbH','Wehmeier GmbH & Co.KG','Ostermeier GmbH','Auto Kemper','Auto Kemper GbR','Auto Kemper oHG'))) and ((CASE WHEN (((T1."VEHICLE_TYPE" IN ('V','T')) and ((extract(DAY FROM T1."SALE_DATE" - T8."FIRST_REG_DATE")) >= 366)) and (T8."OPTIONAL_DATE_1" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ('Gebrauchtwagen') ELSE ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END)) END) = 'Neuwagen')) THEN ('raus') ELSE null END) = 'raus') and (T1."DELIVERY_DATE_VEH" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ((CASE WHEN ((((CASE WHEN (T13."FLEET_CODE_GMD" = '0922 ') THEN ('Opel Rent-Einstellung') WHEN (T13."DRIVE_GMD" = 'L') THEN ('VFW-Einstellung') ELSE null END) IN ('VFW-Einstellung','Opel Rent-Einstellung')) and ((T6."CUSTOMER_GROUP" || ' - ' || T7."CUST_GROUP_SPECIFY") = '20 - AOV ')) and ((CASE WHEN (((T1."VEHICLE_TYPE" IN ('V','T')) and ((extract(DAY FROM T1."SALE_DATE" - T8."FIRST_REG_DATE")) >= 366)) and (T8."OPTIONAL_DATE_1" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ('Gebrauchtwagen') ELSE ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END)) END) = 'Neuwagen')) THEN ('raus') WHEN (((((CASE WHEN (T13."FLEET_CODE_GMD" = '0922 ') THEN ('Opel Rent-Einstellung') WHEN (T13."DRIVE_GMD" = 'L') THEN ('VFW-Einstellung') ELSE null END) IN ('VFW-Einstellung','Opel Rent-Einstellung')) and (T6."CUSTOMER_NUMBER" = '100001')) and (T1."OWNER" IN ('Gebr. Barth GmbH','Autohaus Brock e.K.','Auto-Depping GmbH','Heinrich Freitag GmbH & Co.KG','Autohaus Graver','H.O. Automobile GmbH','Kauhs GmbH & Co. KG','Kauhs GmbH & Co.KG','Jens-Heinrich Kaulfers','Autoland Schilling GmbH','Auto-Thielmann GmbH','Autovermie Auto-Thielmann GmbH','Gebr. Vogel GmbH','Wehmeier GmbH & Co.KG','Ostermeier GmbH','Auto Kemper','Auto Kemper GbR','Auto Kemper oHG'))) and ((CASE WHEN (((T1."VEHICLE_TYPE" IN ('V','T')) and ((extract(DAY FROM T1."SALE_DATE" - T8."FIRST_REG_DATE")) >= 366)) and (T8."OPTIONAL_DATE_1" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ('Gebrauchtwagen') ELSE ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END)) END) = 'Neuwagen')) THEN ('raus') ELSE null END)) ELSE null END as c118, CASE WHEN (((CASE WHEN ((((CASE WHEN (T13."FLEET_CODE_GMD" = '0922 ') THEN ('Opel Rent-Einstellung') WHEN (T13."DRIVE_GMD" = 'L') THEN ('VFW-Einstellung') ELSE null END) IN ('VFW-Einstellung','Opel Rent-Einstellung')) and ((T6."CUSTOMER_GROUP" || ' - ' || T7."CUST_GROUP_SPECIFY") = '20 - AOV ')) and ((CASE WHEN (((T1."VEHICLE_TYPE" IN ('V','T')) and ((extract(DAY FROM T1."SALE_DATE" - T8."FIRST_REG_DATE")) >= 366)) and (T8."OPTIONAL_DATE_1" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ('Gebrauchtwagen') ELSE ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END)) END) = 'Neuwagen')) THEN ('raus') WHEN (((((CASE WHEN (T13."FLEET_CODE_GMD" = '0922 ') THEN ('Opel Rent-Einstellung') WHEN (T13."DRIVE_GMD" = 'L') THEN ('VFW-Einstellung') ELSE null END) IN ('VFW-Einstellung','Opel Rent-Einstellung')) and (T6."CUSTOMER_NUMBER" = '100001')) and (T1."OWNER" IN ('Gebr. Barth GmbH','Autohaus Brock e.K.','Auto-Depping GmbH','Heinrich Freitag GmbH & Co.KG','Autohaus Graver','H.O. Automobile GmbH','Kauhs GmbH & Co. KG','Kauhs GmbH & Co.KG','Jens-Heinrich Kaulfers','Autoland Schilling GmbH','Auto-Thielmann GmbH','Autovermie Auto-Thielmann GmbH','Gebr. Vogel GmbH','Wehmeier GmbH & Co.KG','Ostermeier GmbH','Auto Kemper','Auto Kemper GbR','Auto Kemper oHG'))) and ((CASE WHEN (((T1."VEHICLE_TYPE" IN ('V','T')) and ((extract(DAY FROM T1."SALE_DATE" - T8."FIRST_REG_DATE")) >= 366)) and (T8."OPTIONAL_DATE_1" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ('Gebrauchtwagen') ELSE ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END)) END) = 'Neuwagen')) THEN ('raus') ELSE null END) = 'raus') and ((CASE WHEN (((CASE WHEN ((((CASE WHEN (T13."FLEET_CODE_GMD" = '0922 ') THEN ('Opel Rent-Einstellung') WHEN (T13."DRIVE_GMD" = 'L') THEN ('VFW-Einstellung') ELSE null END) IN ('VFW-Einstellung','Opel Rent-Einstellung')) and ((T6."CUSTOMER_GROUP" || ' - ' || T7."CUST_GROUP_SPECIFY") = '20 - AOV ')) and ((CASE WHEN (((T1."VEHICLE_TYPE" IN ('V','T')) and ((extract(DAY FROM T1."SALE_DATE" - T8."FIRST_REG_DATE")) >= 366)) and (T8."OPTIONAL_DATE_1" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ('Gebrauchtwagen') ELSE ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END)) END) = 'Neuwagen')) THEN ('raus') WHEN (((((CASE WHEN (T13."FLEET_CODE_GMD" = '0922 ') THEN ('Opel Rent-Einstellung') WHEN (T13."DRIVE_GMD" = 'L') THEN ('VFW-Einstellung') ELSE null END) IN ('VFW-Einstellung','Opel Rent-Einstellung')) and (T6."CUSTOMER_NUMBER" = '100001')) and (T1."OWNER" IN ('Gebr. Barth GmbH','Autohaus Brock e.K.','Auto-Depping GmbH','Heinrich Freitag GmbH & Co.KG','Autohaus Graver','H.O. Automobile GmbH','Kauhs GmbH & Co. KG','Kauhs GmbH & Co.KG','Jens-Heinrich Kaulfers','Autoland Schilling GmbH','Auto-Thielmann GmbH','Autovermie Auto-Thielmann GmbH','Gebr. Vogel GmbH','Wehmeier GmbH & Co.KG','Ostermeier GmbH','Auto Kemper','Auto Kemper GbR','Auto Kemper oHG'))) and ((CASE WHEN (((T1."VEHICLE_TYPE" IN ('V','T')) and ((extract(DAY FROM T1."SALE_DATE" - T8."FIRST_REG_DATE")) >= 366)) and (T8."OPTIONAL_DATE_1" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ('Gebrauchtwagen') ELSE ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END)) END) = 'Neuwagen')) THEN ('raus') ELSE null END) = 'raus') and (T1."DELIVERY_DATE_VEH" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ((CASE WHEN ((((CASE WHEN (T13."FLEET_CODE_GMD" = '0922 ') THEN ('Opel Rent-Einstellung') WHEN (T13."DRIVE_GMD" = 'L') THEN ('VFW-Einstellung') ELSE null END) IN ('VFW-Einstellung','Opel Rent-Einstellung')) and ((T6."CUSTOMER_GROUP" || ' - ' || T7."CUST_GROUP_SPECIFY") = '20 - AOV ')) and ((CASE WHEN (((T1."VEHICLE_TYPE" IN ('V','T')) and ((extract(DAY FROM T1."SALE_DATE" - T8."FIRST_REG_DATE")) >= 366)) and (T8."OPTIONAL_DATE_1" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ('Gebrauchtwagen') ELSE ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END)) END) = 'Neuwagen')) THEN ('raus') WHEN (((((CASE WHEN (T13."FLEET_CODE_GMD" = '0922 ') THEN ('Opel Rent-Einstellung') WHEN (T13."DRIVE_GMD" = 'L') THEN ('VFW-Einstellung') ELSE null END) IN ('VFW-Einstellung','Opel Rent-Einstellung')) and (T6."CUSTOMER_NUMBER" = '100001')) and (T1."OWNER" IN ('Gebr. Barth GmbH','Autohaus Brock e.K.','Auto-Depping GmbH','Heinrich Freitag GmbH & Co.KG','Autohaus Graver','H.O. Automobile GmbH','Kauhs GmbH & Co. KG','Kauhs GmbH & Co.KG','Jens-Heinrich Kaulfers','Autoland Schilling GmbH','Auto-Thielmann GmbH','Autovermie Auto-Thielmann GmbH','Gebr. Vogel GmbH','Wehmeier GmbH & Co.KG','Ostermeier GmbH','Auto Kemper','Auto Kemper GbR','Auto Kemper oHG'))) and ((CASE WHEN (((T1."VEHICLE_TYPE" IN ('V','T')) and ((extract(DAY FROM T1."SALE_DATE" - T8."FIRST_REG_DATE")) >= 366)) and (T8."OPTIONAL_DATE_1" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ('Gebrauchtwagen') ELSE ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END)) END) = 'Neuwagen')) THEN ('raus') ELSE null END)) ELSE null END) IS NULL)) THEN (T1."DELIVERY_DATE_VEH") ELSE (T1."SALE_DATE") END as c119, CASE WHEN ((((substring(T1."BOOK_KEEPING_CODE" from 4 for 2))) BETWEEN '10' AND '12') and (T13."FLEET_CODE_GMD" = ' ')) THEN ('Privat') WHEN ((((substring(T1."BOOK_KEEPING_CODE" from 4 for 2))) BETWEEN '10' AND '12') and (T13."FLEET_CODE_GMD" <> ' ')) THEN ('KFP') WHEN ((((substring(T1."BOOK_KEEPING_CODE" from 4 for 2))) BETWEEN '30' AND '33') and (T13."FLEET_CODE_GMD" <> ' ')) THEN ('Großkunden') ELSE ('keine Zuordnung') END as c120, (substring(T1."BOOK_KEEPING_CODE" from 4 for 2)) as c121, T8."OPTIONAL_DATE_1" as c122, CASE WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and ((substring(((rtrim(T1."BOOK_KEEPING_CODE"))) from 4 for 1)) = '1')) THEN ('Privat') WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and ((substring(((rtrim(T1."BOOK_KEEPING_CODE"))) from 4 for 1)) = '2')) THEN ('KFP') WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and ((substring(((rtrim(T1."BOOK_KEEPING_CODE"))) from 4 for 1)) = '3')) THEN ('GK') WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and ((substring(((rtrim(T1."BOOK_KEEPING_CODE"))) from 4 for 1)) = '4')) THEN ('Verband') WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and ((substring(((rtrim(T1."BOOK_KEEPING_CODE"))) from 4 for 1)) = '8')) THEN ('Händler') WHEN ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Gebrauchtwagen') THEN ('GW') ELSE null END as c123, CASE WHEN ((substring(((rtrim(T1."BOOK_KEEPING_CODE"))) from 5 for 1)) IN ('0','3')) THEN ('Bar') WHEN ((substring(((rtrim(T1."BOOK_KEEPING_CODE"))) from 5 for 1)) = '1') THEN ('Finanzierung') WHEN ((substring(((rtrim(T1."BOOK_KEEPING_CODE"))) from 5 for 1)) = '2') THEN ('Leasing') ELSE null END as c124, CASE WHEN (((CASE WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and ((substring(((rtrim(T1."BOOK_KEEPING_CODE"))) from 4 for 1)) = '1')) THEN ('Privat') WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and ((substring(((rtrim(T1."BOOK_KEEPING_CODE"))) from 4 for 1)) = '2')) THEN ('KFP') WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and ((substring(((rtrim(T1."BOOK_KEEPING_CODE"))) from 4 for 1)) = '3')) THEN ('GK') WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and ((substring(((rtrim(T1."BOOK_KEEPING_CODE"))) from 4 for 1)) = '4')) THEN ('Verband') WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and ((substring(((rtrim(T1."BOOK_KEEPING_CODE"))) from 4 for 1)) = '8')) THEN ('Händler') WHEN ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Gebrauchtwagen') THEN ('GW') ELSE null END) IS NOT NULL) and ((CASE WHEN ((substring(((rtrim(T1."BOOK_KEEPING_CODE"))) from 5 for 1)) IN ('0','3')) THEN ('Bar') WHEN ((substring(((rtrim(T1."BOOK_KEEPING_CODE"))) from 5 for 1)) = '1') THEN ('Finanzierung') WHEN ((substring(((rtrim(T1."BOOK_KEEPING_CODE"))) from 5 for 1)) = '2') THEN ('Leasing') ELSE null END) IS NOT NULL)) THEN ((CASE WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and ((substring(((rtrim(T1."BOOK_KEEPING_CODE"))) from 4 for 1)) = '1')) THEN ('Privat') WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and ((substring(((rtrim(T1."BOOK_KEEPING_CODE"))) from 4 for 1)) = '2')) THEN ('KFP') WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and ((substring(((rtrim(T1."BOOK_KEEPING_CODE"))) from 4 for 1)) = '3')) THEN ('GK') WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and ((substring(((rtrim(T1."BOOK_KEEPING_CODE"))) from 4 for 1)) = '4')) THEN ('Verband') WHEN (((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') and ((substring(((rtrim(T1."BOOK_KEEPING_CODE"))) from 4 for 1)) = '8')) THEN ('Händler') WHEN ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END) = 'Gebrauchtwagen') THEN ('GW') ELSE null END) || ' - ' || (CASE WHEN ((substring(((rtrim(T1."BOOK_KEEPING_CODE"))) from 5 for 1)) IN ('0','3')) THEN ('Bar') WHEN ((substring(((rtrim(T1."BOOK_KEEPING_CODE"))) from 5 for 1)) = '1') THEN ('Finanzierung') WHEN ((substring(((rtrim(T1."BOOK_KEEPING_CODE"))) from 5 for 1)) = '2') THEN ('Leasing') ELSE null END)) ELSE null END as c125, T8."USER_CODE" as c126, CASE WHEN (T14."FIRST_NAME" IS NULL) THEN (T14."LAST_NAME") ELSE (T14."LAST_NAME" || ', ' || T14."FIRST_NAME") END as c127, CASE WHEN (T14."ADDR_2" IS NULL) THEN ('-') ELSE (T14."ADDR_2") END as c128, CASE WHEN (T14."MAIL_ADDR" IS NULL) THEN ('-') ELSE (T14."MAIL_ADDR") END as c129, CASE WHEN (T14."PHONE_1" IS NULL) THEN ('(-)') ELSE ('(' || T14."PHONE_1" || ')') END as c130, (CASE WHEN (T14."FIRST_NAME" IS NULL) THEN (T14."LAST_NAME") ELSE (T14."LAST_NAME" || ', ' || T14."FIRST_NAME") END) || ' / ' || ((CASE WHEN (T14."ADDR_2" IS NULL) THEN ('-') ELSE (T14."ADDR_2") END) || ', ' || (truncate((CASE WHEN (T14."ZIPCODE" IS NULL) THEN ('-') ELSE (T14."ZIPCODE") END))) || ' ' || (CASE WHEN (T14."MAIL_ADDR" IS NULL) THEN ('-') ELSE (T14."MAIL_ADDR") END)) || ' / ' || ((CASE WHEN (T14."MOBILE_PHONE" IS NULL) THEN ('(-)') ELSE ('(' || T14."MOBILE_PHONE" || ')') END) || ' - ' || (CASE WHEN (T14."PHONE_1" IS NULL) THEN ('(-)') ELSE ('(' || T14."PHONE_1" || ')') END) || ' - ' || (CASE WHEN (T14."TELEFAX_NUMBER" IS NULL) THEN ('(-)') ELSE ('(' || T14."TELEFAX_NUMBER" || ')') END)) || ' / ' || (CASE WHEN (T14."DECLARATION_STATE" IS NULL) THEN (' - ') ELSE (T14."DECLARATION_STATE") END) as c131, T14."LAST_NAME" as c132, T14."FIRST_NAME" as c133, CASE WHEN (T14."ZIPCODE" IS NULL) THEN ('-') ELSE (T14."ZIPCODE") END as c134, (CASE WHEN (T14."ADDR_2" IS NULL) THEN ('-') ELSE (T14."ADDR_2") END) || ', ' || (truncate((CASE WHEN (T14."ZIPCODE" IS NULL) THEN ('-') ELSE (T14."ZIPCODE") END))) || ' ' || (CASE WHEN (T14."MAIL_ADDR" IS NULL) THEN ('-') ELSE (T14."MAIL_ADDR") END) as c135, CASE WHEN (T14."MOBILE_PHONE" IS NULL) THEN ('(-)') ELSE ('(' || T14."MOBILE_PHONE" || ')') END as c136, CASE WHEN (T14."TELEFAX_NUMBER" IS NULL) THEN ('(-)') ELSE ('(' || T14."TELEFAX_NUMBER" || ')') END as c137, CASE WHEN (T14."DECLARATION_STATE" IS NULL) THEN (' - ') ELSE (T14."DECLARATION_STATE") END as c138, (CASE WHEN (T14."MOBILE_PHONE" IS NULL) THEN ('(-)') ELSE ('(' || T14."MOBILE_PHONE" || ')') END) || ' - ' || (CASE WHEN (T14."PHONE_1" IS NULL) THEN ('(-)') ELSE ('(' || T14."PHONE_1" || ')') END) || ' - ' || (CASE WHEN (T14."TELEFAX_NUMBER" IS NULL) THEN ('(-)') ELSE ('(' || T14."TELEFAX_NUMBER" || ')') END) as c139, CASE WHEN (T11."ACCOUNT_NO" <> ' ') THEN (T15."LAST_NAME" || ', ' || T15."FIRST_NAME" || ' - ' || T11."ACCOUNT_NO") ELSE (T15."LAST_NAME" || ', ' || T15."FIRST_NAME" || ' - ' || T1."SALE_SALESMAN") END as c140, CASE WHEN ((CASE WHEN (T11."ACCOUNT_NO" <> ' ') THEN ((rtrim(T5."SEL_NAME")) || ' - ' || T11."ACCOUNT_NO") ELSE ((rtrim(T5."SEL_NAME")) || ' - ' || T5."SELLER_CODE") END) IS NULL) THEN ((CASE WHEN (T11."ACCOUNT_NO" <> ' ') THEN (T15."LAST_NAME" || ', ' || T15."FIRST_NAME" || ' - ' || T11."ACCOUNT_NO") ELSE (T15."LAST_NAME" || ', ' || T15."FIRST_NAME" || ' - ' || T1."SALE_SALESMAN") END)) ELSE ((CASE WHEN (T11."ACCOUNT_NO" <> ' ') THEN ((rtrim(T5."SEL_NAME")) || ' - ' || T11."ACCOUNT_NO") ELSE ((rtrim(T5."SEL_NAME")) || ' - ' || T5."SELLER_CODE") END)) END as c141, T15."BIRTH_PLACE" as c142, T15."BANK_NAME" as c143 from (((((((("deop01"."dbo"."UNIT_FILE" T1 left outer join "deop01"."dbo"."vPP5R" T2 on T1."VEHICLE_TYPE" = T2."VEHICLE_TYPE") left outer join "deop01"."dbo"."vPP5M" T3 on T1."BOOK_KEEPING_CODE" = T3."BOOK_KEEPING_CODE") left outer join "deop01"."dbo"."DEPARTMENT_TYPE" T4 on T1."SALES_DEPARTMENT" = T4."DEPARTMENT_TYPE_ID") left outer join "deop01"."dbo"."vPP43" T5 on T1."SALE_SALESMAN" = T5."SELLER_CODE") left outer join "deop01"."dbo"."PERSON" T11 on T5."SELLER_CODE" = T11."PERSON_CODE") left outer join "deop01"."dbo"."vPP43" T12 on T1."PURCH_SALSMAN_CODE" = T12."SELLER_CODE") left outer join "deop01"."dbo"."GM_DRIVE_ORDER" T13 on T1."BASIS_NUMBER" = T13."VEHICLE_NUMBER_GMD") left outer join "deop01"."dbo"."PERSON" T15 on ((od_left(T1."SALE_SALESMAN",4)) = (od_left(T15."PERSON_CODE",4))) and (T15."PERSON_CODE" <> ' ')), ("deop01"."dbo"."CUSTOMER" T6 left outer join "deop01"."dbo"."vPP48" T7 on T6."CUSTOMER_GROUP" = T7."CUSTOMER_GROUP"), ((("deop01"."dbo"."VEHICLE" T8 left outer join "deop01"."dbo"."vPP5Q" T9 on (T8."MODEL_LINE" = T9."MODEL_LINE") and (T8."MAKE_CD" = T9."MAKE_CD")) left outer join "deop01"."dbo"."GLOBAL_MAKE" T10 on T8."MAKE_CD" = T10."GLOBAL_MAKE_CD") left outer join "deop01"."dbo"."CUSTOMER" T14 on T14."CUSTOMER_NUMBER" = T8."USER_CODE") where (T1."ACCOUNT_SALES" = T6."CUSTOMER_NUMBER") and (T1."BASIS_NUMBER" = T8."BASIS_NUMBER") and (((T1."ECC_STATUS" = '64') and ((CASE WHEN (((CASE WHEN ((((CASE WHEN (T13."FLEET_CODE_GMD" = '0922 ') THEN ('Opel Rent-Einstellung') WHEN (T13."DRIVE_GMD" = 'L') THEN ('VFW-Einstellung') ELSE null END) IN ('VFW-Einstellung','Opel Rent-Einstellung')) and ((T6."CUSTOMER_GROUP" || ' - ' || T7."CUST_GROUP_SPECIFY") = '20 - AOV ')) and ((CASE WHEN (((T1."VEHICLE_TYPE" IN ('V','T')) and ((extract(DAY FROM T1."SALE_DATE" - T8."FIRST_REG_DATE")) >= 366)) and (T8."OPTIONAL_DATE_1" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ('Gebrauchtwagen') ELSE ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END)) END) = 'Neuwagen')) THEN ('raus') WHEN (((((CASE WHEN (T13."FLEET_CODE_GMD" = '0922 ') THEN ('Opel Rent-Einstellung') WHEN (T13."DRIVE_GMD" = 'L') THEN ('VFW-Einstellung') ELSE null END) IN ('VFW-Einstellung','Opel Rent-Einstellung')) and (T6."CUSTOMER_NUMBER" = '100001')) and (T1."OWNER" IN ('Gebr. Barth GmbH','Autohaus Brock e.K.','Auto-Depping GmbH','Heinrich Freitag GmbH & Co.KG','Autohaus Graver','H.O. Automobile GmbH','Kauhs GmbH & Co. KG','Kauhs GmbH & Co.KG','Jens-Heinrich Kaulfers','Autoland Schilling GmbH','Auto-Thielmann GmbH','Autovermie Auto-Thielmann GmbH','Gebr. Vogel GmbH','Wehmeier GmbH & Co.KG','Ostermeier GmbH','Auto Kemper','Auto Kemper GbR','Auto Kemper oHG'))) and ((CASE WHEN (((T1."VEHICLE_TYPE" IN ('V','T')) and ((extract(DAY FROM T1."SALE_DATE" - T8."FIRST_REG_DATE")) >= 366)) and (T8."OPTIONAL_DATE_1" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ('Gebrauchtwagen') ELSE ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END)) END) = 'Neuwagen')) THEN ('raus') ELSE null END) = 'raus') and ((CASE WHEN (((CASE WHEN ((((CASE WHEN (T13."FLEET_CODE_GMD" = '0922 ') THEN ('Opel Rent-Einstellung') WHEN (T13."DRIVE_GMD" = 'L') THEN ('VFW-Einstellung') ELSE null END) IN ('VFW-Einstellung','Opel Rent-Einstellung')) and ((T6."CUSTOMER_GROUP" || ' - ' || T7."CUST_GROUP_SPECIFY") = '20 - AOV ')) and ((CASE WHEN (((T1."VEHICLE_TYPE" IN ('V','T')) and ((extract(DAY FROM T1."SALE_DATE" - T8."FIRST_REG_DATE")) >= 366)) and (T8."OPTIONAL_DATE_1" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ('Gebrauchtwagen') ELSE ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END)) END) = 'Neuwagen')) THEN ('raus') WHEN (((((CASE WHEN (T13."FLEET_CODE_GMD" = '0922 ') THEN ('Opel Rent-Einstellung') WHEN (T13."DRIVE_GMD" = 'L') THEN ('VFW-Einstellung') ELSE null END) IN ('VFW-Einstellung','Opel Rent-Einstellung')) and (T6."CUSTOMER_NUMBER" = '100001')) and (T1."OWNER" IN ('Gebr. Barth GmbH','Autohaus Brock e.K.','Auto-Depping GmbH','Heinrich Freitag GmbH & Co.KG','Autohaus Graver','H.O. Automobile GmbH','Kauhs GmbH & Co. KG','Kauhs GmbH & Co.KG','Jens-Heinrich Kaulfers','Autoland Schilling GmbH','Auto-Thielmann GmbH','Autovermie Auto-Thielmann GmbH','Gebr. Vogel GmbH','Wehmeier GmbH & Co.KG','Ostermeier GmbH','Auto Kemper','Auto Kemper GbR','Auto Kemper oHG'))) and ((CASE WHEN (((T1."VEHICLE_TYPE" IN ('V','T')) and ((extract(DAY FROM T1."SALE_DATE" - T8."FIRST_REG_DATE")) >= 366)) and (T8."OPTIONAL_DATE_1" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ('Gebrauchtwagen') ELSE ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END)) END) = 'Neuwagen')) THEN ('raus') ELSE null END) = 'raus') and (T1."DELIVERY_DATE_VEH" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ((CASE WHEN ((((CASE WHEN (T13."FLEET_CODE_GMD" = '0922 ') THEN ('Opel Rent-Einstellung') WHEN (T13."DRIVE_GMD" = 'L') THEN ('VFW-Einstellung') ELSE null END) IN ('VFW-Einstellung','Opel Rent-Einstellung')) and ((T6."CUSTOMER_GROUP" || ' - ' || T7."CUST_GROUP_SPECIFY") = '20 - AOV ')) and ((CASE WHEN (((T1."VEHICLE_TYPE" IN ('V','T')) and ((extract(DAY FROM T1."SALE_DATE" - T8."FIRST_REG_DATE")) >= 366)) and (T8."OPTIONAL_DATE_1" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ('Gebrauchtwagen') ELSE ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END)) END) = 'Neuwagen')) THEN ('raus') WHEN (((((CASE WHEN (T13."FLEET_CODE_GMD" = '0922 ') THEN ('Opel Rent-Einstellung') WHEN (T13."DRIVE_GMD" = 'L') THEN ('VFW-Einstellung') ELSE null END) IN ('VFW-Einstellung','Opel Rent-Einstellung')) and (T6."CUSTOMER_NUMBER" = '100001')) and (T1."OWNER" IN ('Gebr. Barth GmbH','Autohaus Brock e.K.','Auto-Depping GmbH','Heinrich Freitag GmbH & Co.KG','Autohaus Graver','H.O. Automobile GmbH','Kauhs GmbH & Co. KG','Kauhs GmbH & Co.KG','Jens-Heinrich Kaulfers','Autoland Schilling GmbH','Auto-Thielmann GmbH','Autovermie Auto-Thielmann GmbH','Gebr. Vogel GmbH','Wehmeier GmbH & Co.KG','Ostermeier GmbH','Auto Kemper','Auto Kemper GbR','Auto Kemper oHG'))) and ((CASE WHEN (((T1."VEHICLE_TYPE" IN ('V','T')) and ((extract(DAY FROM T1."SALE_DATE" - T8."FIRST_REG_DATE")) >= 366)) and (T8."OPTIONAL_DATE_1" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ('Gebrauchtwagen') ELSE ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END)) END) = 'Neuwagen')) THEN ('raus') ELSE null END)) ELSE null END) IS NULL)) THEN (T1."DELIVERY_DATE_VEH") ELSE (T1."SALE_DATE") END) >= TIMESTAMP '2022-01-01 00:00:00.000')) and ((CASE WHEN (((CASE WHEN ((((CASE WHEN (T13."FLEET_CODE_GMD" = '0922 ') THEN ('Opel Rent-Einstellung') WHEN (T13."DRIVE_GMD" = 'L') THEN ('VFW-Einstellung') ELSE null END) IN ('VFW-Einstellung','Opel Rent-Einstellung')) and ((T6."CUSTOMER_GROUP" || ' - ' || T7."CUST_GROUP_SPECIFY") = '20 - AOV ')) and ((CASE WHEN (((T1."VEHICLE_TYPE" IN ('V','T')) and ((extract(DAY FROM T1."SALE_DATE" - T8."FIRST_REG_DATE")) >= 366)) and (T8."OPTIONAL_DATE_1" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ('Gebrauchtwagen') ELSE ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END)) END) = 'Neuwagen')) THEN ('raus') WHEN (((((CASE WHEN (T13."FLEET_CODE_GMD" = '0922 ') THEN ('Opel Rent-Einstellung') WHEN (T13."DRIVE_GMD" = 'L') THEN ('VFW-Einstellung') ELSE null END) IN ('VFW-Einstellung','Opel Rent-Einstellung')) and (T6."CUSTOMER_NUMBER" = '100001')) and (T1."OWNER" IN ('Gebr. Barth GmbH','Autohaus Brock e.K.','Auto-Depping GmbH','Heinrich Freitag GmbH & Co.KG','Autohaus Graver','H.O. Automobile GmbH','Kauhs GmbH & Co. KG','Kauhs GmbH & Co.KG','Jens-Heinrich Kaulfers','Autoland Schilling GmbH','Auto-Thielmann GmbH','Autovermie Auto-Thielmann GmbH','Gebr. Vogel GmbH','Wehmeier GmbH & Co.KG','Ostermeier GmbH','Auto Kemper','Auto Kemper GbR','Auto Kemper oHG'))) and ((CASE WHEN (((T1."VEHICLE_TYPE" IN ('V','T')) and ((extract(DAY FROM T1."SALE_DATE" - T8."FIRST_REG_DATE")) >= 366)) and (T8."OPTIONAL_DATE_1" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ('Gebrauchtwagen') ELSE ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END)) END) = 'Neuwagen')) THEN ('raus') ELSE null END) = 'raus') and (T1."DELIVERY_DATE_VEH" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ((CASE WHEN ((((CASE WHEN (T13."FLEET_CODE_GMD" = '0922 ') THEN ('Opel Rent-Einstellung') WHEN (T13."DRIVE_GMD" = 'L') THEN ('VFW-Einstellung') ELSE null END) IN ('VFW-Einstellung','Opel Rent-Einstellung')) and ((T6."CUSTOMER_GROUP" || ' - ' || T7."CUST_GROUP_SPECIFY") = '20 - AOV ')) and ((CASE WHEN (((T1."VEHICLE_TYPE" IN ('V','T')) and ((extract(DAY FROM T1."SALE_DATE" - T8."FIRST_REG_DATE")) >= 366)) and (T8."OPTIONAL_DATE_1" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ('Gebrauchtwagen') ELSE ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END)) END) = 'Neuwagen')) THEN ('raus') WHEN (((((CASE WHEN (T13."FLEET_CODE_GMD" = '0922 ') THEN ('Opel Rent-Einstellung') WHEN (T13."DRIVE_GMD" = 'L') THEN ('VFW-Einstellung') ELSE null END) IN ('VFW-Einstellung','Opel Rent-Einstellung')) and (T6."CUSTOMER_NUMBER" = '100001')) and (T1."OWNER" IN ('Gebr. Barth GmbH','Autohaus Brock e.K.','Auto-Depping GmbH','Heinrich Freitag GmbH & Co.KG','Autohaus Graver','H.O. Automobile GmbH','Kauhs GmbH & Co. KG','Kauhs GmbH & Co.KG','Jens-Heinrich Kaulfers','Autoland Schilling GmbH','Auto-Thielmann GmbH','Autovermie Auto-Thielmann GmbH','Gebr. Vogel GmbH','Wehmeier GmbH & Co.KG','Ostermeier GmbH','Auto Kemper','Auto Kemper GbR','Auto Kemper oHG'))) and ((CASE WHEN (((T1."VEHICLE_TYPE" IN ('V','T')) and ((extract(DAY FROM T1."SALE_DATE" - T8."FIRST_REG_DATE")) >= 366)) and (T8."OPTIONAL_DATE_1" = TIMESTAMP '1800-01-01 00:00:00.000')) THEN ('Gebrauchtwagen') ELSE ((CASE WHEN (T1."VEHICLE_TYPE" IN ('N','T','V','B','P','W','Y','Q','X')) THEN ('Neuwagen') WHEN (T1."VEHICLE_TYPE" IN ('D','R','G','M')) THEN ('Gebrauchtwagen') ELSE null END)) END) = 'Neuwagen')) THEN ('raus') ELSE null END)) ELSE null END) IS NULL)) order by c1 asc END SQL COLUMN,0,Unit Number COLUMN,1,Basis Number COLUMN,2,Ecc Status COLUMN,3,Vehicle Type COLUMN,4,Vehicle Type_vpp5r COLUMN,5,Vehicle Type Text_vpp5r COLUMN,6,Car Creation Date COLUMN,7,Depreciation COLUMN,8,Book Keeping Code COLUMN,9,Book Keeping Code_vpp5m COLUMN,10,Specify_vpp5m COLUMN,11,Mileage COLUMN,12,Purch Department COLUMN,13,Purch Salsman Code COLUMN,14,Purch Date COLUMN,15,Reception Date COLUMN,16,Sales Department COLUMN,17,Department Type Id_Dep COLUMN,18,Description_Dep COLUMN,19,Sale Salesman COLUMN,20,Seller Code_vpp43 COLUMN,21,Sel Name_vpp43 COLUMN,22,Sel Family Name_vpp43 COLUMN,23,Sale Inv Number COLUMN,24,Sale Date COLUMN,25,Bud Sale Det COLUMN,26,Bud Purch Price COLUMN,27,Bud Reg Fee COLUMN,28,Bud Deduct Fee COLUMN,29,Bud Cost COLUMN,30,Purch Price Unit COLUMN,31,Cost Unit COLUMN,32,Sales Price Unit COLUMN,33,Reg Fee COLUMN,34,Stock Days COLUMN,35,Buying Order No COLUMN,36,Buying Order Date COLUMN,37,Pa Number COLUMN,38,Location Code COLUMN,39,Owner COLUMN,40,Prev Owner COLUMN,41,Account Purchase COLUMN,42,Account Sales COLUMN,43,Customer Number_Cust COLUMN,44,Name_Cust COLUMN,45,Customer Group_Cust COLUMN,46,Customer Group_vpp48 COLUMN,47,Cust Group Specify_vpp48 COLUMN,48,Order Arrival Date COLUMN,49,Order Confirm Date COLUMN,50,Contract Date COLUMN,51,Register Number COLUMN,52,Chassis Number COLUMN,53,Owner Code COLUMN,54,First Reg Date COLUMN,55,Latest Reg Date COLUMN,56,Arrival Date COLUMN,57,Salesman Buy COLUMN,58,Salesman Sale COLUMN,59,Model Text COLUMN,60,Colour Cf COLUMN,61,Model Line COLUMN,62,Model Line_vpp5q COLUMN,63,Mod Lin Specify_vpp5q COLUMN,64,Workshop Model COLUMN,65,Mileage COLUMN,66,Motor Code COLUMN,67,Drive Code COLUMN,68,Colour Code COLUMN,69,Make COLUMN,70,Make Cd COLUMN,71,Global Make Cd COLUMN,72,Description_Global_Make COLUMN,73,Orig Inv Date COLUMN,74,Latest Inv Date COLUMN,75,Invoice Date_ori COLUMN,76,Hauptbetrieb COLUMN,77,Standort COLUMN,78,Verkäufer_ori COLUMN,79,Fabrikat COLUMN,80,Model COLUMN,81,Modellbez COLUMN,82,Fahrgestellnr COLUMN,83,Fahrzeugart_ori COLUMN,84,Fahrzeugtyp_ori COLUMN,85,Kunde COLUMN,86,Kundenart COLUMN,87,Geschäftsart COLUMN,88,Farbe COLUMN,89,ECC_Status_Text COLUMN,90,FZG COLUMN,91,FZG_1 COLUMN,92,FZG_Liste_1 COLUMN,93,Sel Name_EK_vpp43 COLUMN,94,Einkäufer COLUMN,95,Vorbesitzer COLUMN,96,FZG_Liste_2 COLUMN,97,FZG_Liste_3 COLUMN,98,FZG_Liste_4 COLUMN,99,Menge COLUMN,100,Standtage COLUMN,101,Birth Place_ori COLUMN,102,Bank Name_ori COLUMN,103,Buchungscode_Stellen COLUMN,104,Buchungscode_Stellen1 COLUMN,105,Buchungscode_ori COLUMN,106,Buchungscode_ori2 COLUMN,107,Abnehmergruppe COLUMN,108,Zahlart COLUMN,109,Fleet Code Gmd COLUMN,110,Drive Gmd COLUMN,111,AOS CODE COLUMN,112,Einstellungsart COLUMN,113,Fahrzeugart COLUMN,114,Fahrzeugtyp COLUMN,115,Delivery Date Veh COLUMN,116,Filterfeld COLUMN,117,Filterfeld_1 COLUMN,118,Invoice Date COLUMN,119,KD-Art_Siebrecht COLUMN,120,Book Keeping Code_4_5 COLUMN,121,Optional Date 1 COLUMN,122,Buchungscode_1 COLUMN,123,Buchungscode_2 COLUMN,124,Buchungscode COLUMN,125,User Code COLUMN,126,User_Name COLUMN,127,User_Addr 2 COLUMN,128,User_Mail Addr COLUMN,129,User_Phone 1 COLUMN,130,User_Info COLUMN,131,User_Last Name COLUMN,132,User_First Name COLUMN,133,User_Zipcode COLUMN,134,User_Anschrift COLUMN,135,Mobile Phone COLUMN,136,Telefax Number COLUMN,137,Declaration State COLUMN,138,User_Tel COLUMN,139,Verkäufer_aus_Person_Code COLUMN,140,Verkäufer COLUMN,141,Birth Place COLUMN,142,Bank Name