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

COGNOS QUERY
STRUCTURE,1,1
DATABASE,O21
DATASOURCENAME,C:\GAPS\Portal\System\IQD\NW\NW_GW_VK_Pos.imr
TITLE,NW_GW_VK_Pos.imr
BEGIN SQL
select c538 as c1,
	   c537 as c2,
	   c536 as c3,
	   c535 as c4,
	   c534 as c5,
	   c533 as c6,
	   c532 as c7,
	   c531 as c8,
	   c530 as c9,
	   c529 as c10,
	   c528 as c11,
	   c527 as c12,
	   c526 as c13,
	   c525 as c14,
	   c524 as c15,
	   c523 as c16,
	   c522 as c17,
	   c521 as c18,
	   c520 as c19,
	   c519 as c20,
	   c518 as c21,
	   c517 as c22,
	   c516 as c23,
	   c515 as c24,
	   c514 as c25,
	   c513 as c26,
	   c512 as c27,
	   c511 as c28,
	   c510 as c29,
	   c509 as c30,
	   c508 as c31,
	   c507 as c32,
	   c506 as c33,
	   c505 as c34,
	   c504 as c35,
	   c503 as c36,
	   c502 as c37,
	   c501 as c38,
	   c500 as c39,
	   c499 as c40,
	   c498 as c41,
	   c497 as c42,
	   c496 as c43,
	   c495 as c44,
	   c494 as c45,
	   c493 as c46,
	   c492 as c47,
	   c491 as c48,
	   c490 as c49,
	   c489 as c50,
	   c488 as c51,
	   c487 as c52,
	   c486 as c53,
	   c485 as c54,
	   c484 as c55,
	   c483 as c56,
	   c482 as c57,
	   c481 as c58,
	   c480 as c59,
	   c479 as c60,
	   c478 as c61,
	   c477 as c62,
	   c476 as c63,
	   c475 as c64,
	   c474 as c65,
	   c473 as c66,
	   c472 as c67,
	   c471 as c68,
	   c470 as c69,
	   c469 as c70,
	   c468 as c71,
	   c467 as c72,
	   c466 as c73,
	   c465 as c74,
	   c464 as c75,
	   c463 as c76,
	   c462 as c77,
	   c461 as c78,
	   c460 as c79,
	   c459 as c80,
	   c458 as c81,
	   c457 as c82,
	   c456 as c83,
	   c455 as c84,
	   c454 as c85,
	   c453 as c86,
	   c452 as c87,
	   c451 as c88,
	   c450 as c89,
	   c449 as c90,
	   c448 as c91,
	   c447 as c92,
	   c446 as c93,
	   c445 as c94,
	   c444 as c95,
	   c443 as c96,
	   c442 as c97,
	   c441 as c98,
	   c440 as c99,
	   c439 as c100,
	   c438 as c101,
	   c437 as c102,
	   c436 as c103,
	   c435 as c104,
	   c434 as c105,
	   c433 as c106,
	   c432 as c107,
	   c431 as c108,
	   c430 as c109,
	   c429 as c110,
	   c428 as c111,
	   c427 as c112,
	   c426 as c113,
	   c425 as c114,
	   c317 as c115,
	   c424 as c116,
	   c423 as c117,
	   c422 as c118,
	   c421 as c119,
	   c420 as c120,
	   c419 as c121,
	   c418 as c122,
	   c417 as c123,
	   c416 as c124,
	   c415 as c125,
	   c414 as c126,
	   c275 as c127,
	   c413 as c128,
	   c412 as c129,
	   c411 as c130,
	   c410 as c131,
	   c409 as c132,
	   c408 as c133,
	   c407 as c134,
	   c406 as c135,
	   c405 as c136,
	   c404 as c137,
	   c403 as c138,
	   c402 as c139,
	   c401 as c140,
	   c400 as c141,
	   c399 as c142,
	   c398 as c143,
	   c397 as c144,
	   c396 as c145,
	   c395 as c146,
	   c394 as c147,
	   c314 as c148,
	   c393 as c149,
	   c392 as c150,
	   c391 as c151,
	   c315 as c152,
	   c390 as c153,
	   c389 as c154,
	   c388 as c155,
	   c387 as c156,
	   c386 as c157,
	   c385 as c158,
	   c384 as c159,
	   c383 as c160,
	   c382 as c161,
	   c381 as c162,
	   c380 as c163,
	   c379 as c164,
	   c378 as c165,
	   c377 as c166,
	   c376 as c167,
	   c375 as c168,
	   c374 as c169,
	   c373 as c170,
	   c372 as c171,
	   c371 as c172,
	   c370 as c173,
	   c369 as c174,
	   c368 as c175,
	   c367 as c176,
	   c366 as c177,
	   c365 as c178,
	   c364 as c179,
	   c363 as c180,
	   c362 as c181,
	   c361 as c182,
	   c360 as c183,
	   c316 as c184,
	   c359 as c185,
	   c358 as c186,
	   c357 as c187,
	   c356 as c188,
	   c355 as c189,
	   c354 as c190,
	   c353 as c191,
	   c352 as c192,
	   c351 as c193,
	   c350 as c194,
	   c349 as c195,
	   c348 as c196,
	   c347 as c197,
	   c346 as c198,
	   c345 as c199,
	   c344 as c200,
	   c343 as c201,
	   c342 as c202,
	   c341 as c203,
	   c340 as c204,
	   c339 as c205,
	   c338 as c206,
	   c337 as c207,
	   c336 as c208,
	   c335 as c209,
	   c334 as c210,
	   c333 as c211,
	   c332 as c212,
	   c331 as c213,
	   c330 as c214,
	   c329 as c215,
	   c328 as c216,
	   c327 as c217,
	   c326 as c218,
	   c325 as c219,
	   c324 as c220,
	   c323 as c221,
	   c322 as c222,
	   c321 as c223,
	   c320 as c224,
	   c319 as c225,
	   '1' as c226,
	   c318 as c227,
	   c317 as c228,
	   c292 as c229,
	   c316 as c230,
	   c315 as c231,
	   c314 as c232,
	   c313 as c233,
	   c312 as c234,
	   c311 as c235,
	   c310 as c236,
	   c309 as c237,
	   c308 as c238,
	   c307 as c239,
	   c306 as c240,
	   c305 as c241,
	   c304 as c242,
	   c303 as c243,
	   c302 as c244,
	   c301 as c245,
	   c300 as c246,
	   c299 as c247,
	   c298 as c248,
	   c297 as c249,
	   c296 as c250,
	   c295 as c251,
	   c294 as c252,
	   c293 as c253,
	   c292 as c254,
	   c291 as c255,
	   c290 as c256,
	   c289 as c257,
	   c288 as c258,
	   c287 as c259,
	   c286 as c260,
	   c285 as c261,
	   c284 as c262,
	   c283 as c263,
	   c282 as c264,
	   c281 as c265,
	   c280 as c266,
	   c279 as c267,
	   c278 as c268,
	   c276 as c269,
	   c277 as c270,
	   XCOUNT(c284 for c275) as c271,
	   (c276) / (XCOUNT(c284 for c275)) as c272
from 
(select (T8."UNIT_NUMBER") as c275,
	   CASE WHEN (T11."RECEPTION_DATE" IS NULL) THEN ((extract(DAY FROM T11."SALE_DATE" - T11."PURCH_DATE"))) ELSE ((extract(DAY FROM T11."SALE_DATE" - T11."RECEPTION_DATE"))) END as c276,
	   T11."SALE_DATE" as c277,
	   T11."PURCH_DATE" as c278,
	   T11."RECEPTION_DATE" as c279,
	   T12."LATEST_INV_DATE" as c280,
	   T18."SEL_NAME" as c281,
	   T18."SELLER_CODE" as c282,
	   T11."PURCH_SALSMAN_CODE" as c283,
	   (database()) as c284,
	   T12."ORIG_INV_DATE" as c285,
	   T11."OWNER" as c286,
	   T8."UNIT_NUMBER" || ' - ' || T11."OWNER" || ' - ' || (asciiz(extract(YEAR FROM T12."LATEST_INV_DATE"),4) || '-' || asciiz(extract(MONTH FROM T12."LATEST_INV_DATE"),2) || '-' || asciiz(extract(DAY FROM T12."LATEST_INV_DATE"),2)) as c287,
	   CASE WHEN (T16."TRANSACTION_CODE" IN ('13 ','15 ','16 ')) THEN (T16."ORDERS_GROSSVALUE") ELSE null END as c288,
	   CASE WHEN (T16."TRANSACTION_CODE" = '91') THEN (T16."ORDERS_GROSSVALUE" * -1) ELSE null END as c289,
	   CASE WHEN (T16."TRANSACTION_CODE" = '93') THEN (T16."ORDERS_GROSSVALUE" * -1) ELSE null END as c290,
	   CASE WHEN (T16."TRANSACTION_CODE" IN ('92')) THEN (T16."ORDERS_GROSSVALUE" * -1) ELSE null END as c291,
	   T15."DESCRIPTION" as c292,
	   T15."GLOBAL_MAKE_CD" as c293,
	   T8."UNIT_NUMBER" || ' - ' || T12."CHASSIS_NUMBER" as c294,
	   T9."VEHICLE_TYPE" || ' - ' || T9."VEHICLE_TYPE_TEXT" as c295,
	   T12."COLOUR_CODE" || ' - ' || T12."COLOUR_CF" as c296,
	   CASE WHEN ((((T16."TRANSACTION_CODE" = '10') and ((CASE WHEN (T16."TRANSACTION_CODE" IN ('10','12','24')) THEN (T16."ORDERS_GROSSVALUE" * -1) ELSE null END) >= 0)) and (T8."LINE_TYPE_VEH" <> 'Z')) and (not T8."UNIT_NUMBER" IN ('DAFH9','218463','LAAF31','LAAG31','MAKU3','MADF3'))) THEN (T11."PURCH_PRICE_UNIT" + T11."COST_UNIT") WHEN ((((T16."TRANSACTION_CODE" = '10') and ((CASE WHEN (T16."TRANSACTION_CODE" IN ('10','12','24')) THEN (T16."ORDERS_GROSSVALUE" * -1) ELSE null END) > 0)) and (T8."LINE_TYPE_VEH" <> 'Z')) and (T8."UNIT_NUMBER" IN ('DAFH9','218463','LAAF31','LAAG31','MAKU3','MADF3'))) THEN (T11."PURCH_PRICE_UNIT" + T11."COST_UNIT") WHEN ((((T16."TRANSACTION_CODE" = '10') and ((CASE WHEN (T16."TRANSACTION_CODE" IN ('10','12','24')) THEN (T16."ORDERS_GROSSVALUE" * -1) ELSE null END) < 0)) and (T8."LINE_TYPE_VEH" <> 'Z')) and (not T8."UNIT_NUMBER" IN ('DAFH9','218463','LAAF31','LAAG31','MAKU3','MADF3'))) THEN ((T11."PURCH_PRICE_UNIT" + T11."COST_UNIT") * -1) ELSE null END as c297,
	   CASE WHEN (T16."TRANSACTION_CODE" = '11') THEN (T16."ORDERS_GROSSVALUE") ELSE null END as c298,
	   CASE WHEN (T16."TRANSACTION_CODE" IN ('14')) THEN (T16."ORDERS_GROSSVALUE" * -1) ELSE null END as c299,
	   CASE WHEN (T16."TRANSACTION_CODE" IN ('10','12','24')) THEN (T16."ORDERS_GROSSVALUE" * -1) ELSE null END as c300,
	   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','E')) THEN ('Neuwagen') WHEN (T9."VEHICLE_TYPE" IN ('D','R','G')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen')) and ((CASE WHEN (T16."TRANSACTION_CODE" IN ('10','12','24')) THEN (T16."ORDERS_GROSSVALUE" * -1) ELSE null END) > 5000)) THEN (1) WHEN (((((T16."TRANSACTION_CODE" = '10') and (T1."STATUS" = 'FG')) and (T8."LINE_TYPE_VEH" <> 'Z')) and ((CASE WHEN (T9."VEHICLE_TYPE" IN ('N','T','V','B','M','E')) THEN ('Neuwagen') WHEN (T9."VEHICLE_TYPE" IN ('D','R','G')) THEN ('Gebrauchtwagen') ELSE null END) = 'Neuwagen')) and ((CASE WHEN (T16."TRANSACTION_CODE" IN ('10','12','24')) 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','E')) THEN ('Neuwagen') WHEN (T9."VEHICLE_TYPE" IN ('D','R','G')) THEN ('Gebrauchtwagen') ELSE null END) = 'Gebrauchtwagen')) THEN (1) WHEN ((((T16."TRANSACTION_CODE" = '10') and (T1."STATUS" = 'FG')) and (T8."LINE_TYPE_VEH" <> 'Z')) and ((CASE WHEN (T9."VEHICLE_TYPE" IN ('N','T','V','B','M','E')) THEN ('Neuwagen') WHEN (T9."VEHICLE_TYPE" IN ('D','R','G')) THEN ('Gebrauchtwagen') ELSE null END) = 'Gebrauchtwagen')) THEN (-1) ELSE null END as c301,
	   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 c302,
	   CASE WHEN ((T16."TRANSACTION_CODE" = '10') and (T8."LINE_TYPE_VEH" <> 'Z')) THEN ((T1."PMT_TERM" || ' - ' || T1."PAYMENT_TEXT")) ELSE null END as c303,
	   T17."SPECIFY" as c304,
	   T17."TRANSACTION_CODE" as c305,
	   T16."DISCOUNT" as c306,
	   T16."ORDERS_GROSSVALUE" as c307,
	   T16."TRANSACTION_CODE" as c308,
	   T16."ORDER_NUMBER" as c309,
	   T16."UNIT_NUMBER" as c310,
	   T1."PMT_TERM" || ' - ' || T1."PAYMENT_TEXT" as c311,
	   CASE WHEN (T10."BOOK_KEEPING_CODE" = 'AGENT') THEN ('Behörden FZG') ELSE (T1."FLEET_OWNER" || ' - ' || T5."SPECIFY") END as c312,
	   T1."DELIVERY_ACCOUNT" || ' - ' || T1."NAME" as c313,
	   T12."CHASSIS_NUMBER" as c314,
	   T12."MODEL_TEXT" as c315,
	   T13."MOD_LIN_SPECIFY" as c316,
	   T4."SEL_NAME" as c317,
	   (od_left(T3."DEPARTMENT_TYPE_ID",2)) as c318,
	   CASE WHEN (T9."VEHICLE_TYPE" IN ('N','T','V','B','M','E')) THEN ('Neuwagen') WHEN (T9."VEHICLE_TYPE" IN ('D','R','G')) THEN ('Gebrauchtwagen') ELSE null END as c319,
	   T11."PRICE_LIST_DATE" as c320,
	   T11."PRICE_LIST_VERSION" as c321,
	   T11."VARIATION_PCT" as c322,
	   T11."SALE_PRICE_DATE" as c323,
	   T11."NOVA_AMOUNT_NEW" as c324,
	   T11."BUD_OPT_PRICE" as c325,
	   T11."STOCK_VALUE_BPM" as c326,
	   T11."IQ_USED_VEHICLE" as c327,
	   T11."ARGUS_SALES_PRICE" as c328,
	   T11."ARGUS_PURCH_PRICE" as c329,
	   T11."NOVA_EXCEPT_TEXT" as c330,
	   T11."NOVA_EXCEPT_CODE" as c331,
	   T11."NOVA_AMOUNT" as c332,
	   T11."NOVA_PERCENT" as c333,
	   T11."NOVA_CALC_BASE" as c334,
	   T11."NOVA_CALC_FLAG" as c335,
	   T11."VALUATION_DATE" as c336,
	   T11."FREIGHT_BALANCE" as c337,
	   T11."BUDG_PRICE_VAT" as c338,
	   T11."STOCK_DAYS" as c339,
	   T11."COST_TAX" as c340,
	   T11."PURCH_TAX" as c341,
	   T11."REG_FEE" as c342,
	   T11."SALES_PRICE_UNIT" as c343,
	   T11."COST_UNIT" as c344,
	   T11."PURCH_PRICE_UNIT" as c345,
	   T11."BUD_COST" as c346,
	   T11."BUD_DEDUCT_FEE" as c347,
	   T11."BUD_REG_FEE" as c348,
	   T11."BUD_PURCH_PRICE" as c349,
	   T11."BUD_SALE_DET" as c350,
	   T11."DEPRECIATION" as c351,
	   T11."DISCOUNT_LIMIT" as c352,
	   T11."PRICE_CODE" as c353,
	   T14."MAKE_CODE" as c354,
	   T14."ORIG_MODEL_CODE" as c355,
	   T14."MODEL_TEXT" as c356,
	   T14."MAKE_CD" as c357,
	   T14."WORKSHOP_MODEL" as c358,
	   T13."MAKE_CD" as c359,
	   T13."MODEL_LINE" as c360,
	   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 c361,
	   T12."TYPE_YEAR" as c362,
	   T12."TRIM_CODE" as c363,
	   T12."COLOUR_CODE" as c364,
	   T12."DRIVE_CODE" as c365,
	   T12."GEAR_CODE" as c366,
	   T12."MOTOR_CODE" as c367,
	   T12."MISC_10_CF" as c368,
	   T12."MISC_9_CF" as c369,
	   T12."MISC_8_CF" as c370,
	   T12."MISC_7_CF" as c371,
	   T12."MISC_6_CF" as c372,
	   T12."MISC_5_CF" as c373,
	   T12."MISC_4_CF" as c374,
	   T12."MISC_3_CF" as c375,
	   T12."MISC_2_CF" as c376,
	   T12."MISC_1_CF" as c377,
	   T12."SEATS" as c378,
	   T12."CYLINDER_VOLUME" as c379,
	   T12."YEAR_MODEL_CF" as c380,
	   T12."KEY_CODE" as c381,
	   T12."MOTOR_NUMBER" as c382,
	   T12."CLASSIFICATION" as c383,
	   T12."FAC_MODEL_CODE_S" as c384,
	   T12."WORKSHOP_MODEL" as c385,
	   T12."MODEL_LINE" as c386,
	   T12."TRIM_TXT" as c387,
	   T12."COLOUR_CF" as c388,
	   T12."ORIG_MODEL_CODE2" as c389,
	   T12."ORIG_MODEL_CODE1" as c390,
	   T12."FAC_MODEL_CODE_L" as c391,
	   T12."CAR_STATUS" as c392,
	   T12."CAR_GROUP" as c393,
	   T12."BASIS_NUMBER" as c394,
	   T11."PMT_TERM" as c395,
	   T11."CATEGORY" as c396,
	   T11."VEHICLE_TYPE" as c397,
	   T11."ECC_STATUS" as c398,
	   T11."BASIS_NUMBER" as c399,
	   T11."UNIT_NUMBER" as c400,
	   T10."SPECIFY" as c401,
	   T10."BOOK_KEEPING_CODE" as c402,
	   T9."VEHICLE_TYPE_TEXT" as c403,
	   T9."VEHICLE_TYPE" as c404,
	   T8."ACCOUNTING_CODE" as c405,
	   T8."MILEAGE" as c406,
	   T8."LINE_TYPE_VEH" as c407,
	   T8."OPTION_LINES" as c408,
	   T8."VEHICLE_SUM_NEW" as c409,
	   T8."VEHICLE_SUM_OLD" as c410,
	   T8."CHASSIS_NUMBER" as c411,
	   T8."REGISTER_NUMBER" as c412,
	   T8."VEHICLE_TYPE_VO" as c413,
	   T8."LINE_NUMBER" as c414,
	   T8."ORDER_NUMBER" as c415,
	   T7."STOCK_NAME" as c416,
	   T7."STOCK" as c417,
	   T6."CUST_GROUP_SPECIFY" as c418,
	   T6."CUSTOMER_GROUP" as c419,
	   T5."SPECIFY" as c420,
	   T5."FLEET_OWNER_CODE" as c421,
	   T4."SEL_FAMILY_NAME" as c422,
	   T4."SEL_FIRST_NAME" as c423,
	   T4."SEL_DEPARTMENT" as c424,
	   T4."SELLER_CODE" as c425,
	   T3."DESCRIPTION" as c426,
	   T3."DEPARTMENT_TYPE_ID" as c427,
	   T2."STAT_SPECIFY" as c428,
	   T2."STAT_CODE" as c429,
	   T1."UNIQUE_IDENT" as c430,
	   T1."CONV_FLAG" as c431,
	   T1."PREORDER_ID" as c432,
	   T1."DEAL_ID" as c433,
	   T1."EXT_ORDER_NUMBER" as c434,
	   T1."NWFAKT_MARKING" as c435,
	   T1."EAN_INTERNAL_ACCT" as c436,
	   T1."EAN_REFERENCE" as c437,
	   T1."EAN_DEPARTMENT" as c438,
	   T1."CUSTOMER_EAN_NUMBER" as c439,
	   T1."DEBET_DEPARTMENT" as c440,
	   T1."REFERENCE_DATE" as c441,
	   T1."BOOK_NO_FLAG" as c442,
	   T1."BOOK_NO" as c443,
	   T1."EXP_ARRIVAL_TIME" as c444,
	   T1."CUSTOMER_SOLD" as c445,
	   T1."FAC_MODEL_CODE_L" as c446,
	   T1."CONTRACT_DATE" as c447,
	   T1."CNTRACT_DUE_DATE" as c448,
	   T1."CASH_AMOUNT" as c449,
	   T1."DEBT_NEW" as c450,
	   T1."INV_ROUNDING_VO" as c451,
	   T1."TAX_CODE_VO" as c452,
	   T1."LANGUAGE_CODE" as c453,
	   T1."TO_MICROFICHE" as c454,
	   T1."SUB_ORDER_NO_10" as c455,
	   T1."SUB_ORDER_NO_9" as c456,
	   T1."SUB_ORDER_NO_8" as c457,
	   T1."SUB_ORDER_NO_7" as c458,
	   T1."SUB_ORDER_NO_6" as c459,
	   T1."SUB_ORDER_NO_5" as c460,
	   T1."SUB_ORDER_NO_4" as c461,
	   T1."SUB_ORDER_NO_3" as c462,
	   T1."SUB_ORDER_NO_2" as c463,
	   T1."SUB_ORDER_NO_1" as c464,
	   T1."MAIN_ORDER_NO" as c465,
	   T1."VEH_ORDER_TYPE" as c466,
	   T1."OFFER" as c467,
	   T1."ORDER_ARR_DATE_VO" as c468,
	   T1."INVOICE_DISC_PERC" as c469,
	   T1."PLACE_CODE_2" as c470,
	   T1."STOCK" as c471,
	   T1."PRICE_CODE" as c472,
	   T1."CUSTOMER_GROUP" as c473,
	   T1."DELIVERY_TERM" as c474,
	   T1."DELIVERY_WAY_CODE" as c475,
	   T1."TAX_PERC" as c476,
	   T1."TAX_HANDLING" as c477,
	   T1."CREDIT_ORDER_VEH" as c478,
	   T1."PREV_STATUS" as c479,
	   T1."INTERNAL_CODE" as c480,
	   T1."SYSTEM_INV_PERM" as c481,
	   T1."CHAIN_NUMBER" as c482,
	   T1."VEHICLE_PURCH_SUM" as c483,
	   T1."VEHICLE_PURCH" as c484,
	   T1."VEHICLE_SOLD_SUM" as c485,
	   T1."VEHICLE_SOLD" as c486,
	   T1."COUNTY" as c487,
	   T1."ADDR_3" as c488,
	   T1."MAIL_ADDR" as c489,
	   T1."ZIPCODE" as c490,
	   T1."ADDR_2" as c491,
	   T1."STREET_ADDR" as c492,
	   T1."NAME" as c493,
	   T1."TITLE" as c494,
	   T1."DUEDATE_1" as c495,
	   T1."REFERENCE_NUMBER" as c496,
	   T1."REQ_NO" as c497,
	   T1."ORDER_SUM_VO" as c498,
	   T1."VEHICLE_LINES_VO" as c499,
	   T1."OPTION_SPECIFIC" as c500,
	   T1."FLEET_OWNER" as c501,
	   T1."TEXT_FL4_VO" as c502,
	   T1."TEXT4_2_VO" as c503,
	   T1."TEXT4_1_VO" as c504,
	   T1."TEXT_FL3_VO" as c505,
	   T1."TEXT3_2_VO" as c506,
	   T1."TEXT3_1_VO" as c507,
	   T1."TEXT_FL2_VO" as c508,
	   T1."TEXT2_2_VO" as c509,
	   T1."TEXT2_1_VO" as c510,
	   T1."TEXT_FL1_VO" as c511,
	   T1."TEXT1_2_VO" as c512,
	   T1."TEXT1_1_VO" as c513,
	   T1."TEXT_CODE_3" as c514,
	   T1."TEXT_CODE_2" as c515,
	   T1."TEXT_CODE_1" as c516,
	   T1."INVOICE_COPY_CODE" as c517,
	   T1."PAYMENT_TEXT" as c518,
	   T1."NEXT_LINE_NUMBER" as c519,
	   T1."PMT_TERM" as c520,
	   T1."INVOICE_DATE" as c521,
	   T1."DELIVERY_PLACE" as c522,
	   T1."DELIVERY_DATE" as c523,
	   T1."ORDER_DATE" as c524,
	   T1."DEBIT_PERM" as c525,
	   T1."SALESMAN" as c526,
	   T1."USER_UPDATE_VO" as c527,
	   T1."DELIVERY_ACCOUNT" as c528,
	   T1."TRANSACT_DATE" as c529,
	   T1."HANDLER" as c530,
	   T1."STATE_CODE_VO" as c531,
	   T1."STATE_DELIV_DATE" as c532,
	   T1."DEPARTMENT" as c533,
	   T1."INVOICE_NUMBER" as c534,
	   T1."STATE_KEY_DATE" as c535,
	   T1."STATUS" as c536,
	   T1."DEBIT_ACCOUNT" as c537,
	   T1."ORDER_NUMBER" as c538
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") 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") left outer join "deop01"."dbo"."vPP43" T18 on T11."PURCH_SALSMAN_CODE" = T18."SELLER_CODE")
where (T8."UNIT_NUMBER" = T11."UNIT_NUMBER")
and (((((T1."STATUS" IN ('FG','FR')) and (not T16."TRANSACTION_CODE" IN ('76','77','25'))) and (T11."ECC_STATUS" = '64')) and (T1."INVOICE_DATE" >= TIMESTAMP '2012-01-01 00:00:00.000')) and (not T16."ORDER_NUMBER" IN (4105053,4105054,4104679,4104680,4104691,4104692,4104693,4104694,4104695,4104696,4104323,4104667,4104685,4104686,4104687,4104688,4104689,4104690)))
order by c275 asc
) D1

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,Handler
COLUMN,9,Transact Date
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,Invoice 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,Sonst. Erl. MwSt.pfl
COLUMN,255,Sonst. Erl. steuerfrei
COLUMN,256,Car Garantie
COLUMN,257,OSP Provisionen
COLUMN,258,FZG_1
COLUMN,259,Owner
COLUMN,260,Orig Inv Date
COLUMN,261,Mandant
COLUMN,262,Purch Salsman Code
COLUMN,263,EK_Seller Code
COLUMN,264,EK_Sel Name
COLUMN,265,Latest Inv Date
COLUMN,266,Reception Date
COLUMN,267,Purch Date
COLUMN,268,verkaufte Standtage_Basis
COLUMN,269,Sale Date
COLUMN,270,Berechnungszahl
COLUMN,271,verkaufte Standtage