GAPS/Portal/System/IQD/Belege/FB_NW_GW.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,O21
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Belege\FB_NW_GW.imr
TITLE,FB_NW_GW.imr
BEGIN SQL
select T1."ORDER_NUMBER" as c1,
	   T1."DEBIT_ACCOUNT" as c2,
	   T1."STATUS" as c3,
	   T1."STATE_KEY_DATE" as c4,
	   T1."INVOICE_NUMBER" as c5,
	   T1."DEPARTMENT" as c6,
	   T1."STATE_DELIV_DATE" as c7,
	   T1."STATE_CODE_VO" as c8,
	   T1."TRANSACT_DATE" as c9,
	   T1."HANDLER" as c10,
	   T1."DELIVERY_ACCOUNT" as c11,
	   T1."USER_UPDATE_VO" as c12,
	   T1."SALESMAN" as c13,
	   T1."DEBIT_PERM" as c14,
	   T1."ORDER_DATE" as c15,
	   T1."DELIVERY_DATE" as c16,
	   T1."DELIVERY_PLACE" as c17,
	   T1."INVOICE_DATE" as c18,
	   T1."PMT_TERM" as c19,
	   T1."NEXT_LINE_NUMBER" as c20,
	   T1."PAYMENT_TEXT" as c21,
	   T1."INVOICE_COPY_CODE" as c22,
	   T1."TEXT_CODE_1" as c23,
	   T1."TEXT_CODE_2" as c24,
	   T1."TEXT_CODE_3" as c25,
	   T1."TEXT1_1_VO" as c26,
	   T1."TEXT1_2_VO" as c27,
	   T1."TEXT_FL1_VO" as c28,
	   T1."TEXT2_1_VO" as c29,
	   T1."TEXT2_2_VO" as c30,
	   T1."TEXT_FL2_VO" as c31,
	   T1."TEXT3_1_VO" as c32,
	   T1."TEXT3_2_VO" as c33,
	   T1."TEXT_FL3_VO" as c34,
	   T1."TEXT4_1_VO" as c35,
	   T1."TEXT4_2_VO" as c36,
	   T1."TEXT_FL4_VO" as c37,
	   T1."FLEET_OWNER" as c38,
	   T1."OPTION_SPECIFIC" as c39,
	   T1."VEHICLE_LINES_VO" as c40,
	   T1."ORDER_SUM_VO" as c41,
	   T1."REQ_NO" as c42,
	   T1."REFERENCE_NUMBER" as c43,
	   T1."DUEDATE_1" as c44,
	   T1."TITLE" as c45,
	   T1."NAME" as c46,
	   T1."STREET_ADDR" as c47,
	   T1."ADDR_2" as c48,
	   T1."ZIPCODE" as c49,
	   T1."MAIL_ADDR" as c50,
	   T1."ADDR_3" as c51,
	   T1."COUNTY" as c52,
	   T1."VEHICLE_SOLD" as c53,
	   T1."VEHICLE_SOLD_SUM" as c54,
	   T1."VEHICLE_PURCH" as c55,
	   T1."VEHICLE_PURCH_SUM" as c56,
	   T1."CHAIN_NUMBER" as c57,
	   T1."SYSTEM_INV_PERM" as c58,
	   T1."INTERNAL_CODE" as c59,
	   T1."PREV_STATUS" as c60,
	   T1."CREDIT_ORDER_VEH" as c61,
	   T1."TAX_HANDLING" as c62,
	   T1."TAX_PERC" as c63,
	   T1."DELIVERY_WAY_CODE" as c64,
	   T1."DELIVERY_TERM" as c65,
	   T1."CUSTOMER_GROUP" as c66,
	   T1."PRICE_CODE" as c67,
	   T1."STOCK" as c68,
	   T1."PLACE_CODE_2" as c69,
	   T1."INVOICE_DISC_PERC" as c70,
	   T1."ORDER_ARR_DATE_VO" as c71,
	   T1."OFFER" as c72,
	   T1."VEH_ORDER_TYPE" as c73,
	   T1."MAIN_ORDER_NO" as c74,
	   T1."SUB_ORDER_NO_1" as c75,
	   T1."SUB_ORDER_NO_2" as c76,
	   T1."SUB_ORDER_NO_3" as c77,
	   T1."SUB_ORDER_NO_4" as c78,
	   T1."SUB_ORDER_NO_5" as c79,
	   T1."SUB_ORDER_NO_6" as c80,
	   T1."SUB_ORDER_NO_7" as c81,
	   T1."SUB_ORDER_NO_8" as c82,
	   T1."SUB_ORDER_NO_9" as c83,
	   T1."SUB_ORDER_NO_10" as c84,
	   T1."TO_MICROFICHE" as c85,
	   T1."LANGUAGE_CODE" as c86,
	   T1."TAX_CODE_VO" as c87,
	   T1."INV_ROUNDING_VO" as c88,
	   T1."DEBT_NEW" as c89,
	   T1."CASH_AMOUNT" as c90,
	   T1."CNTRACT_DUE_DATE" as c91,
	   T1."CONTRACT_DATE" as c92,
	   T1."FAC_MODEL_CODE_L" as c93,
	   T1."CUSTOMER_SOLD" as c94,
	   T1."EXP_ARRIVAL_TIME" as c95,
	   T1."BOOK_NO" as c96,
	   T1."BOOK_NO_FLAG" as c97,
	   T1."REFERENCE_DATE" as c98,
	   T1."DEBET_DEPARTMENT" as c99,
	   T1."CUSTOMER_EAN_NUMBER" as c100,
	   T1."EAN_DEPARTMENT" as c101,
	   T1."EAN_REFERENCE" as c102,
	   T1."EAN_INTERNAL_ACCT" as c103,
	   T1."NWFAKT_MARKING" as c104,
	   T1."EXT_ORDER_NUMBER" as c105,
	   T1."DEAL_ID" as c106,
	   T1."PREORDER_ID" as c107,
	   T1."CONV_FLAG" as c108,
	   T1."UNIQUE_IDENT" as c109,
	   T2."STAT_CODE" as c110,
	   T2."STAT_SPECIFY" as c111,
	   T3."DEPARTMENT_TYPE_ID" as c112,
	   T3."DESCRIPTION" as c113,
	   T4."SELLER_CODE" as c114,
	   T4."SEL_NAME" as c115,
	   T4."SEL_DEPARTMENT" as c116,
	   T4."SEL_FIRST_NAME" as c117,
	   T4."SEL_FAMILY_NAME" as c118,
	   T5."FLEET_OWNER_CODE" as c119,
	   T5."SPECIFY" as c120,
	   T6."CUSTOMER_GROUP" as c121,
	   T6."CUST_GROUP_SPECIFY" as c122,
	   T7."STOCK" as c123,
	   T7."STOCK_NAME" as c124,
	   T8."ORDER_NUMBER" as c125,
	   T8."LINE_NUMBER" as c126,
	   T8."UNIT_NUMBER" as c127,
	   T8."VEHICLE_TYPE_VO" as c128,
	   T8."REGISTER_NUMBER" as c129,
	   T8."CHASSIS_NUMBER" as c130,
	   T8."VEHICLE_SUM_OLD" as c131,
	   T8."VEHICLE_SUM_NEW" as c132,
	   T8."OPTION_LINES" as c133,
	   T8."LINE_TYPE_VEH" as c134,
	   T8."MILEAGE" as c135,
	   T8."ACCOUNTING_CODE" as c136,
	   T9."VEHICLE_TYPE" as c137,
	   T9."VEHICLE_TYPE_TEXT" as c138,
	   T10."BOOK_KEEPING_CODE" as c139,
	   T10."SPECIFY" as c140,
	   T11."UNIT_NUMBER" as c141,
	   T11."BASIS_NUMBER" as c142,
	   T11."ECC_STATUS" as c143,
	   T11."VEHICLE_TYPE" as c144,
	   T11."CATEGORY" as c145,
	   T11."PMT_TERM" as c146,
	   T12."BASIS_NUMBER" as c147,
	   T12."CHASSIS_NUMBER" as c148,
	   T12."CAR_GROUP" as c149,
	   T12."CAR_STATUS" as c150,
	   T12."FAC_MODEL_CODE_L" as c151,
	   T12."MODEL_TEXT" as c152,
	   T12."ORIG_MODEL_CODE1" as c153,
	   T12."ORIG_MODEL_CODE2" as c154,
	   T12."COLOUR_CF" as c155,
	   T12."TRIM_TXT" as c156,
	   T12."MODEL_LINE" as c157,
	   T12."WORKSHOP_MODEL" as c158,
	   T12."FAC_MODEL_CODE_S" as c159,
	   T12."CLASSIFICATION" as c160,
	   T12."MOTOR_NUMBER" as c161,
	   T12."KEY_CODE" as c162,
	   T12."YEAR_MODEL_CF" as c163,
	   T12."CYLINDER_VOLUME" as c164,
	   T12."SEATS" as c165,
	   T12."MISC_1_CF" as c166,
	   T12."MISC_2_CF" as c167,
	   T12."MISC_3_CF" as c168,
	   T12."MISC_4_CF" as c169,
	   T12."MISC_5_CF" as c170,
	   T12."MISC_6_CF" as c171,
	   T12."MISC_7_CF" as c172,
	   T12."MISC_8_CF" as c173,
	   T12."MISC_9_CF" as c174,
	   T12."MISC_10_CF" as c175,
	   T12."MOTOR_CODE" as c176,
	   T12."GEAR_CODE" as c177,
	   T12."DRIVE_CODE" as c178,
	   T12."COLOUR_CODE" as c179,
	   T12."TRIM_CODE" as c180,
	   T12."TYPE_YEAR" as c181,
	   CASE WHEN (T11."ECC_STATUS" = '21') THEN ('21 - Vorlauf') WHEN (T11."ECC_STATUS" = '25') THEN ('25 - für Kd best. FZG') WHEN (T11."ECC_STATUS" = '41') THEN ('41 - Bestand') WHEN (T11."ECC_STATUS" = '44') THEN ('44 - am Hof nicht fakt.') WHEN (T11."ECC_STATUS" = '64') THEN ('64 - verkauft') ELSE null END as c182,
	   T13."MODEL_LINE" as c183,
	   T13."MOD_LIN_SPECIFY" as c184,
	   T13."MAKE_CD" as c185,
	   T14."WORKSHOP_MODEL" as c186,
	   T14."MAKE_CD" as c187,
	   T14."MODEL_TEXT" as c188,
	   T14."ORIG_MODEL_CODE" as c189,
	   T14."MAKE_CODE" as c190,
	   T11."PRICE_CODE" as c191,
	   T11."DISCOUNT_LIMIT" as c192,
	   T11."DEPRECIATION" as c193,
	   T11."BUD_SALE_DET" as c194,
	   T11."BUD_PURCH_PRICE" as c195,
	   T11."BUD_REG_FEE" as c196,
	   T11."BUD_DEDUCT_FEE" as c197,
	   T11."BUD_COST" as c198,
	   T11."PURCH_PRICE_UNIT" as c199,
	   T11."COST_UNIT" as c200,
	   T11."SALES_PRICE_UNIT" as c201,
	   T11."REG_FEE" as c202,
	   T11."PURCH_TAX" as c203,
	   T11."COST_TAX" as c204,
	   T11."STOCK_DAYS" as c205,
	   T11."BUDG_PRICE_VAT" as c206,
	   T11."FREIGHT_BALANCE" as c207,
	   T11."VALUATION_DATE" as c208,
	   T11."NOVA_CALC_FLAG" as c209,
	   T11."NOVA_CALC_BASE" as c210,
	   T11."NOVA_PERCENT" as c211,
	   T11."NOVA_AMOUNT" as c212,
	   T11."NOVA_EXCEPT_CODE" as c213,
	   T11."NOVA_EXCEPT_TEXT" as c214,
	   T11."ARGUS_PURCH_PRICE" as c215,
	   T11."ARGUS_SALES_PRICE" as c216,
	   T11."IQ_USED_VEHICLE" as c217,
	   T11."STOCK_VALUE_BPM" as c218,
	   T11."BUD_OPT_PRICE" as c219,
	   T11."NOVA_AMOUNT_NEW" as c220,
	   T11."SALE_PRICE_DATE" as c221,
	   T11."VARIATION_PCT" as c222,
	   T11."PRICE_LIST_VERSION" as c223,
	   T11."PRICE_LIST_DATE" as c224,
	   CASE WHEN (T9."VEHICLE_TYPE" IN ('N','T','V','B','M')) THEN ('Neuwagen') WHEN (T9."VEHICLE_TYPE" IN ('D','R')) THEN ('Gebrauchtwagen') ELSE null END as c225,
	   '1' as c226,
	   (od_left(T3."DEPARTMENT_TYPE_ID",2)) as c227,
	   T4."SEL_NAME" as c228,
	   T15."DESCRIPTION" as c229,
	   T13."MOD_LIN_SPECIFY" as c230,
	   T12."MODEL_TEXT" as c231,
	   T12."CHASSIS_NUMBER" as c232,
	   T1."DELIVERY_ACCOUNT" || ' - ' || T1."NAME" as c233,
	   CASE WHEN (T10."BOOK_KEEPING_CODE" = 'AGENT') THEN ('Behörden FZG') ELSE (T1."FLEET_OWNER" || ' - ' || T5."SPECIFY") END as c234,
	   T1."PMT_TERM" || ' - ' || T1."PAYMENT_TEXT" as c235,
	   T16."UNIT_NUMBER" as c236,
	   T16."ORDER_NUMBER" as c237,
	   T16."TRANSACTION_CODE" as c238,
	   T16."ORDERS_GROSSVALUE" as c239,
	   T16."DISCOUNT" as c240,
	   T17."TRANSACTION_CODE" as c241,
	   T17."SPECIFY" as c242,
	   CASE WHEN ((T16."TRANSACTION_CODE" = '10') and (T8."LINE_TYPE_VEH" <> 'Z')) THEN ((T1."PMT_TERM" || ' - ' || T1."PAYMENT_TEXT")) ELSE null END as c243,
	   CASE WHEN ((T16."TRANSACTION_CODE" = '10') and (T8."LINE_TYPE_VEH" <> 'Z')) THEN ((CASE WHEN (T10."BOOK_KEEPING_CODE" = 'AGENT') THEN ('Behörden FZG') ELSE (T1."FLEET_OWNER" || ' - ' || T5."SPECIFY") END)) ELSE null END as c244,
	   CASE WHEN (((((T16."TRANSACTION_CODE" = '10') and (T1."STATUS" = 'FR')) and (T8."LINE_TYPE_VEH" <> 'Z')) and ((CASE WHEN (T9."VEHICLE_TYPE" IN ('N','T','V','B','M')) THEN ('Neuwagen') WHEN (T9."VEHICLE_TYPE" IN ('D','R')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen')) and ((CASE WHEN (T16."TRANSACTION_CODE" = '10') THEN (T16."ORDERS_GROSSVALUE" * -1) ELSE null END) > 5000)) THEN (1) WHEN (((((T16."TRANSACTION_CODE" = '10') and (T1."STATUS" IN ('FG','FS'))) and (T8."LINE_TYPE_VEH" <> 'Z')) and ((CASE WHEN (T9."VEHICLE_TYPE" IN ('N','T','V','B','M')) THEN ('Neuwagen') WHEN (T9."VEHICLE_TYPE" IN ('D','R')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen')) and ((CASE WHEN (T16."TRANSACTION_CODE" = '10') THEN (T16."ORDERS_GROSSVALUE" * -1) ELSE null END) < - 5000)) THEN (-1) WHEN ((((T16."TRANSACTION_CODE" = '10') and (T1."STATUS" = 'FR')) and (T8."LINE_TYPE_VEH" <> 'Z')) and ((CASE WHEN (T9."VEHICLE_TYPE" IN ('N','T','V','B','M')) THEN ('Neuwagen') WHEN (T9."VEHICLE_TYPE" IN ('D','R')) THEN ('Gebrauchtwagen') ELSE null END) = 'Gebrauchtwagen')) THEN (1) WHEN ((((T16."TRANSACTION_CODE" = '10') and (T1."STATUS" IN ('FG','FS'))) and (T8."LINE_TYPE_VEH" <> 'Z')) and ((CASE WHEN (T9."VEHICLE_TYPE" IN ('N','T','V','B','M')) THEN ('Neuwagen') WHEN (T9."VEHICLE_TYPE" IN ('D','R')) THEN ('Gebrauchtwagen') ELSE null END) = 'Gebrauchtwagen')) THEN (-1) ELSE null END as c245,
	   CASE WHEN (T16."TRANSACTION_CODE" = '10') THEN (T16."ORDERS_GROSSVALUE" * -1) ELSE null END as c246,
	   CASE WHEN (T16."TRANSACTION_CODE" IN ('14','21')) THEN (T16."ORDERS_GROSSVALUE" * -1) ELSE null END as c247,
	   CASE WHEN (T16."TRANSACTION_CODE" = '11') THEN (T16."ORDERS_GROSSVALUE") ELSE null END as c248,
	   CASE WHEN (((T16."TRANSACTION_CODE" = '10') and ((CASE WHEN (T16."TRANSACTION_CODE" = '10') THEN (T16."ORDERS_GROSSVALUE" * -1) ELSE null END) >= 0)) and (T8."LINE_TYPE_VEH" <> 'Z')) THEN (T11."PURCH_PRICE_UNIT") WHEN (((T16."TRANSACTION_CODE" = '10') and ((CASE WHEN (T16."TRANSACTION_CODE" = '10') THEN (T16."ORDERS_GROSSVALUE" * -1) ELSE null END) < 0)) and (T8."LINE_TYPE_VEH" <> 'Z')) THEN (T11."PURCH_PRICE_UNIT" * -1) ELSE null END as c249,
	   T12."COLOUR_CODE" || ' - ' || T12."COLOUR_CF" as c250,
	   T9."VEHICLE_TYPE" || ' - ' || T9."VEHICLE_TYPE_TEXT" as c251,
	   T8."UNIT_NUMBER" || ' - ' || T12."CHASSIS_NUMBER" as c252,
	   T15."GLOBAL_MAKE_CD" as c253,
	   T15."DESCRIPTION" as c254,
	   'verkaufte Stückzahlen' as c255,
	   (CASE WHEN (T9."VEHICLE_TYPE" IN ('N','T','V','B','M')) THEN ('Neuwagen') WHEN (T9."VEHICLE_TYPE" IN ('D','R')) THEN ('Gebrauchtwagen') ELSE null END) as c256,
	   T15."DESCRIPTION" as c257,
	   (CASE WHEN ((T16."TRANSACTION_CODE" = '10') and (T8."LINE_TYPE_VEH" <> 'Z')) THEN ((CASE WHEN (T10."BOOK_KEEPING_CODE" = 'AGENT') THEN ('Behörden FZG') ELSE (T1."FLEET_OWNER" || ' - ' || T5."SPECIFY") END)) ELSE null END) as c258,
	   T13."MOD_LIN_SPECIFY" as c259,
	   (T8."UNIT_NUMBER" || ' - ' || T12."CHASSIS_NUMBER") as c260,
	   CASE WHEN (T12."CHASSIS_NUMBER" <> ' ') THEN ((od_left((cast_numberToString(cast_integer(T1."INVOICE_NUMBER"))),7)) || '-' || (od_right(T8."CHASSIS_NUMBER",7)) || (database()) || T12."BASIS_NUMBER") ELSE ((od_left((cast_numberToString(cast_integer(T1."INVOICE_NUMBER"))),7)) || '-' || (database()) || T11."BASIS_NUMBER") END as c261,
	   (CASE WHEN (((((T16."TRANSACTION_CODE" = '10') and (T1."STATUS" = 'FR')) and (T8."LINE_TYPE_VEH" <> 'Z')) and ((CASE WHEN (T9."VEHICLE_TYPE" IN ('N','T','V','B','M')) THEN ('Neuwagen') WHEN (T9."VEHICLE_TYPE" IN ('D','R')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen')) and ((CASE WHEN (T16."TRANSACTION_CODE" = '10') THEN (T16."ORDERS_GROSSVALUE" * -1) ELSE null END) > 5000)) THEN (1) WHEN (((((T16."TRANSACTION_CODE" = '10') and (T1."STATUS" IN ('FG','FS'))) and (T8."LINE_TYPE_VEH" <> 'Z')) and ((CASE WHEN (T9."VEHICLE_TYPE" IN ('N','T','V','B','M')) THEN ('Neuwagen') WHEN (T9."VEHICLE_TYPE" IN ('D','R')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen')) and ((CASE WHEN (T16."TRANSACTION_CODE" = '10') THEN (T16."ORDERS_GROSSVALUE" * -1) ELSE null END) < - 5000)) THEN (-1) WHEN ((((T16."TRANSACTION_CODE" = '10') and (T1."STATUS" = 'FR')) and (T8."LINE_TYPE_VEH" <> 'Z')) and ((CASE WHEN (T9."VEHICLE_TYPE" IN ('N','T','V','B','M')) THEN ('Neuwagen') WHEN (T9."VEHICLE_TYPE" IN ('D','R')) THEN ('Gebrauchtwagen') ELSE null END) = 'Gebrauchtwagen')) THEN (1) WHEN ((((T16."TRANSACTION_CODE" = '10') and (T1."STATUS" IN ('FG','FS'))) and (T8."LINE_TYPE_VEH" <> 'Z')) and ((CASE WHEN (T9."VEHICLE_TYPE" IN ('N','T','V','B','M')) THEN ('Neuwagen') WHEN (T9."VEHICLE_TYPE" IN ('D','R')) THEN ('Gebrauchtwagen') ELSE null END) = 'Gebrauchtwagen')) THEN (-1) ELSE null END) as c262,
	   '1' as c263,
	   ((od_left(T3."DEPARTMENT_TYPE_ID",2))) as c264,
	   CASE WHEN ((CASE WHEN (T9."VEHICLE_TYPE" IN ('N','T','V','B','M')) THEN ('Neuwagen') WHEN (T9."VEHICLE_TYPE" IN ('D','R')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen') THEN ('1') WHEN ((CASE WHEN (T9."VEHICLE_TYPE" IN ('N','T','V','B','M')) THEN ('Neuwagen') WHEN (T9."VEHICLE_TYPE" IN ('D','R')) THEN ('Gebrauchtwagen') ELSE null END) = 'Gebrauchtwagen') THEN ('2') ELSE null END as c265,
	   (substring(T3."DEPARTMENT_TYPE_ID" from 3 for 1)) as c266,
	   (database()) as c267,
	   '' as c268,
	   '' as c269
from (((((((((("deop01"."dbo"."VEH_ORDER_HEADER" T1 left outer join "deop01"."dbo"."vPP25" T2 on T1."STATUS" = T2."STAT_CODE") left outer join "deop01"."dbo"."DEPARTMENT_TYPE" T3 on T1."DEPARTMENT" = T3."DEPARTMENT_TYPE_ID") left outer join "deop01"."dbo"."vPP43" T4 on T1."SALESMAN" = T4."SELLER_CODE") left outer join "deop01"."dbo"."vPP4K" T5 on T1."FLEET_OWNER" = T5."FLEET_OWNER_CODE") left outer join "deop01"."dbo"."vPP48" T6 on T1."CUSTOMER_GROUP" = T6."CUSTOMER_GROUP") left outer join "deop01"."dbo"."vPP61" T7 on T1."STOCK" = T7."STOCK") left outer join "deop01"."dbo"."VEH_ORDER_LINE" T8 on T1."ORDER_NUMBER" = T8."ORDER_NUMBER") left outer join "deop01"."dbo"."vPP5M" T10 on T8."ACCOUNTING_CODE" = T10."BOOK_KEEPING_CODE") left outer join "deop01"."dbo"."UNIT_HISTORY" T16 on (T8."UNIT_NUMBER" = T16."UNIT_NUMBER") and (T8."ORDER_NUMBER" = T16."ORDER_NUMBER")) left outer join "deop01"."dbo"."vPP5A" T17 on T16."TRANSACTION_CODE" = T17."TRANSACTION_CODE"),
	((((("deop01"."dbo"."UNIT_FILE" T11 left outer join "deop01"."dbo"."vPP5R" T9 on T11."VEHICLE_TYPE" = T9."VEHICLE_TYPE") left outer join "deop01"."dbo"."VEHICLE" T12 on T11."BASIS_NUMBER" = T12."BASIS_NUMBER") left outer join "deop01"."dbo"."vPP5Q" T13 on (T12."MODEL_LINE" = T13."MODEL_LINE") and (T12."MAKE_CD" = T13."MAKE_CD")) left outer join "deop01"."dbo"."vPP74" T14 on (T12."WORKSHOP_MODEL" = T14."WORKSHOP_MODEL") and (T12."MAKE_CD" = T14."MAKE_CD")) left outer join "deop01"."dbo"."GLOBAL_MAKE" T15 on T12."MAKE_CD" = T15."GLOBAL_MAKE_CD")
where (T8."UNIT_NUMBER" = T11."UNIT_NUMBER")
and (((((T1."STATUS" IN ('FG','FR','FS')) and (not T16."TRANSACTION_CODE" IN ('25','76','77'))) and (T11."ECC_STATUS" = '64')) and (((CASE WHEN (((((T16."TRANSACTION_CODE" = '10') and (T1."STATUS" = 'FR')) and (T8."LINE_TYPE_VEH" <> 'Z')) and ((CASE WHEN (T9."VEHICLE_TYPE" IN ('N','T','V','B','M')) THEN ('Neuwagen') WHEN (T9."VEHICLE_TYPE" IN ('D','R')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen')) and ((CASE WHEN (T16."TRANSACTION_CODE" = '10') THEN (T16."ORDERS_GROSSVALUE" * -1) ELSE null END) > 5000)) THEN (1) WHEN (((((T16."TRANSACTION_CODE" = '10') and (T1."STATUS" IN ('FG','FS'))) and (T8."LINE_TYPE_VEH" <> 'Z')) and ((CASE WHEN (T9."VEHICLE_TYPE" IN ('N','T','V','B','M')) THEN ('Neuwagen') WHEN (T9."VEHICLE_TYPE" IN ('D','R')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen')) and ((CASE WHEN (T16."TRANSACTION_CODE" = '10') THEN (T16."ORDERS_GROSSVALUE" * -1) ELSE null END) < - 5000)) THEN (-1) WHEN ((((T16."TRANSACTION_CODE" = '10') and (T1."STATUS" = 'FR')) and (T8."LINE_TYPE_VEH" <> 'Z')) and ((CASE WHEN (T9."VEHICLE_TYPE" IN ('N','T','V','B','M')) THEN ('Neuwagen') WHEN (T9."VEHICLE_TYPE" IN ('D','R')) THEN ('Gebrauchtwagen') ELSE null END) = 'Gebrauchtwagen')) THEN (1) WHEN ((((T16."TRANSACTION_CODE" = '10') and (T1."STATUS" IN ('FG','FS'))) and (T8."LINE_TYPE_VEH" <> 'Z')) and ((CASE WHEN (T9."VEHICLE_TYPE" IN ('N','T','V','B','M')) THEN ('Neuwagen') WHEN (T9."VEHICLE_TYPE" IN ('D','R')) THEN ('Gebrauchtwagen') ELSE null END) = 'Gebrauchtwagen')) THEN (-1) ELSE null END)) IS NOT NULL)) and (T1."INVOICE_DATE" >= TIMESTAMP '2018-01-01 00:00:00.000'))
order by c127 asc

END SQL
COLUMN,0,Order Number
COLUMN,1,Debit Account
COLUMN,2,Status
COLUMN,3,State Key Date
COLUMN,4,Invoice Number
COLUMN,5,Department
COLUMN,6,State Deliv Date
COLUMN,7,State Code Vo
COLUMN,8,Transact Date
COLUMN,9,Handler
COLUMN,10,Delivery Account
COLUMN,11,User Update Vo
COLUMN,12,Salesman
COLUMN,13,Debit Perm
COLUMN,14,Order Date
COLUMN,15,Delivery Date
COLUMN,16,Delivery Place
COLUMN,17,Bookkeep Date
COLUMN,18,Pmt Term
COLUMN,19,Next Line Number
COLUMN,20,Payment Text
COLUMN,21,Invoice Copy Code
COLUMN,22,Text Code 1
COLUMN,23,Text Code 2
COLUMN,24,Text Code 3
COLUMN,25,Text1 1 Vo
COLUMN,26,Text1 2 Vo
COLUMN,27,Text Fl1 Vo
COLUMN,28,Text2 1 Vo
COLUMN,29,Text2 2 Vo
COLUMN,30,Text Fl2 Vo
COLUMN,31,Text3 1 Vo
COLUMN,32,Text3 2 Vo
COLUMN,33,Text Fl3 Vo
COLUMN,34,Text4 1 Vo
COLUMN,35,Text4 2 Vo
COLUMN,36,Text Fl4 Vo
COLUMN,37,Fleet Owner
COLUMN,38,Option Specific
COLUMN,39,Vehicle Lines Vo
COLUMN,40,Order Sum Vo
COLUMN,41,Req No
COLUMN,42,Reference Number
COLUMN,43,Duedate 1
COLUMN,44,Title
COLUMN,45,Name
COLUMN,46,Street Addr
COLUMN,47,Addr 2
COLUMN,48,Zipcode
COLUMN,49,Mail Addr
COLUMN,50,Addr 3
COLUMN,51,County
COLUMN,52,Vehicle Sold
COLUMN,53,Vehicle Sold Sum
COLUMN,54,Vehicle Purch
COLUMN,55,Vehicle Purch Sum
COLUMN,56,Chain Number
COLUMN,57,System Inv Perm
COLUMN,58,Internal Code
COLUMN,59,Prev Status
COLUMN,60,Credit Order Veh
COLUMN,61,Tax Handling
COLUMN,62,Tax Perc
COLUMN,63,Delivery Way Code
COLUMN,64,Delivery Term
COLUMN,65,Customer Group
COLUMN,66,Price Code
COLUMN,67,Stock
COLUMN,68,Place Code 2
COLUMN,69,Invoice Disc Perc
COLUMN,70,Order Arr Date Vo
COLUMN,71,Offer
COLUMN,72,Veh Order Type
COLUMN,73,Main Order No
COLUMN,74,Sub Order No 1
COLUMN,75,Sub Order No 2
COLUMN,76,Sub Order No 3
COLUMN,77,Sub Order No 4
COLUMN,78,Sub Order No 5
COLUMN,79,Sub Order No 6
COLUMN,80,Sub Order No 7
COLUMN,81,Sub Order No 8
COLUMN,82,Sub Order No 9
COLUMN,83,Sub Order No 10
COLUMN,84,To Microfiche
COLUMN,85,Language Code
COLUMN,86,Tax Code Vo
COLUMN,87,Inv Rounding Vo
COLUMN,88,Debt New
COLUMN,89,Cash Amount
COLUMN,90,Cntract Due Date
COLUMN,91,Contract Date
COLUMN,92,Fac Model Code L
COLUMN,93,Customer Sold
COLUMN,94,Exp Arrival Time
COLUMN,95,Book No
COLUMN,96,Book No Flag
COLUMN,97,Reference Date
COLUMN,98,Debet Department
COLUMN,99,Customer Ean Number
COLUMN,100,Ean Department
COLUMN,101,Ean Reference
COLUMN,102,Ean Internal Acct
COLUMN,103,Nwfakt Marking
COLUMN,104,Ext Order Number
COLUMN,105,Deal Id
COLUMN,106,Preorder Id
COLUMN,107,Conv Flag
COLUMN,108,Unique Ident
COLUMN,109,Stat Code
COLUMN,110,Stat Specify
COLUMN,111,Department Type Id
COLUMN,112,Description
COLUMN,113,Seller Code
COLUMN,114,Sel Name
COLUMN,115,Sel Department
COLUMN,116,Sel First Name
COLUMN,117,Sel Family Name
COLUMN,118,Fleet Owner Code
COLUMN,119,Specify
COLUMN,120,Customer Group
COLUMN,121,Cust Group Specify
COLUMN,122,Stock
COLUMN,123,Stock Name
COLUMN,124,Order Number
COLUMN,125,Line Number
COLUMN,126,Unit Number
COLUMN,127,Vehicle Type Vo
COLUMN,128,Register Number
COLUMN,129,Chassis Number
COLUMN,130,Vehicle Sum Old
COLUMN,131,Vehicle Sum New
COLUMN,132,Option Lines
COLUMN,133,Line Type Veh
COLUMN,134,Mileage
COLUMN,135,Accounting Code
COLUMN,136,Vehicle Type
COLUMN,137,Vehicle Type Text
COLUMN,138,Book Keeping Code
COLUMN,139,Specify
COLUMN,140,Unit Number
COLUMN,141,Basis Number
COLUMN,142,Ecc Status
COLUMN,143,Vehicle Type
COLUMN,144,Category
COLUMN,145,Pmt Term
COLUMN,146,Basis Number
COLUMN,147,Chassis Number
COLUMN,148,Car Group
COLUMN,149,Car Status
COLUMN,150,Fac Model Code L
COLUMN,151,Model Text
COLUMN,152,Orig Model Code1
COLUMN,153,Orig Model Code2
COLUMN,154,Colour Cf
COLUMN,155,Trim Txt
COLUMN,156,Model Line
COLUMN,157,Workshop Model
COLUMN,158,Fac Model Code S
COLUMN,159,Classification
COLUMN,160,Motor Number
COLUMN,161,Key Code
COLUMN,162,Year Model Cf
COLUMN,163,Cylinder Volume
COLUMN,164,Seats
COLUMN,165,Misc 1 Cf
COLUMN,166,Misc 2 Cf
COLUMN,167,Misc 3 Cf
COLUMN,168,Misc 4 Cf
COLUMN,169,Misc 5 Cf
COLUMN,170,Misc 6 Cf
COLUMN,171,Misc 7 Cf
COLUMN,172,Misc 8 Cf
COLUMN,173,Misc 9 Cf
COLUMN,174,Misc 10 Cf
COLUMN,175,Motor Code
COLUMN,176,Gear Code
COLUMN,177,Drive Code
COLUMN,178,Colour Code
COLUMN,179,Trim Code
COLUMN,180,Type Year
COLUMN,181,Ecc_Status_Text
COLUMN,182,Model Line
COLUMN,183,Mod Lin Specify
COLUMN,184,Make Cd
COLUMN,185,Workshop Model
COLUMN,186,Make Cd
COLUMN,187,Model Text
COLUMN,188,Orig Model Code
COLUMN,189,Make Code
COLUMN,190,Price Code
COLUMN,191,Discount Limit
COLUMN,192,Depreciation
COLUMN,193,Bud Sale Det
COLUMN,194,Bud Purch Price
COLUMN,195,Bud Reg Fee
COLUMN,196,Bud Deduct Fee
COLUMN,197,Bud Cost
COLUMN,198,Purch Price Unit
COLUMN,199,Cost Unit
COLUMN,200,Sales Price Unit
COLUMN,201,Reg Fee
COLUMN,202,Purch Tax
COLUMN,203,Cost Tax
COLUMN,204,Stock Days
COLUMN,205,Budg Price Vat
COLUMN,206,Freight Balance
COLUMN,207,Valuation Date
COLUMN,208,Nova Calc Flag
COLUMN,209,Nova Calc Base
COLUMN,210,Nova Percent
COLUMN,211,Nova Amount
COLUMN,212,Nova Except Code
COLUMN,213,Nova Except Text
COLUMN,214,Argus Purch Price
COLUMN,215,Argus Sales Price
COLUMN,216,Iq Used Vehicle
COLUMN,217,Stock Value Bpm
COLUMN,218,Bud Opt Price
COLUMN,219,Nova Amount New
COLUMN,220,Sale Price Date
COLUMN,221,Variation Pct
COLUMN,222,Price List Version
COLUMN,223,Price List Date
COLUMN,224,Fahrzeugart
COLUMN,225,Hauptbetrieb
COLUMN,226,Standort
COLUMN,227,Verkäufer
COLUMN,228,Fabrikat
COLUMN,229,Model
COLUMN,230,Modellbez
COLUMN,231,Fahrgestellnr
COLUMN,232,Kunde
COLUMN,233,Kundenart
COLUMN,234,Geschäftsart
COLUMN,235,Unit Number
COLUMN,236,Order Number
COLUMN,237,Transaction Code
COLUMN,238,Orders Grossvalue
COLUMN,239,Discount
COLUMN,240,Transaction Code
COLUMN,241,Specify
COLUMN,242,Geschäftsart_neu
COLUMN,243,Kundenart_neu
COLUMN,244,Menge
COLUMN,245,Erlös
COLUMN,246,Ums. Fracht und Überf.
COLUMN,247,Nachlass
COLUMN,248,Einsatz
COLUMN,249,Farbe
COLUMN,250,Fahrzeugtyp
COLUMN,251,FZG
COLUMN,252,Global Make Cd
COLUMN,253,Description
COLUMN,254,Ebene1
COLUMN,255,Ebene2
COLUMN,256,Ebene3
COLUMN,257,Ebene4
COLUMN,258,Ebene5
COLUMN,259,Konto
COLUMN,260,Acct Nr
COLUMN,261,Betrag
COLUMN,262,Rechtseinheit
COLUMN,263,Betrieb
COLUMN,264,Kostenstelle
COLUMN,265,Marke
COLUMN,266,Mandant
COLUMN,267,Text
COLUMN,268,Ebene6