GAPS/Portal/System/IQD/NW/NW_GW_VK_Stk_2.iqd

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