COGNOS QUERY STRUCTURE,1,1 DATABASE,O21_op04 DATASOURCENAME,C:\GAPS\Portal\System\IQD\NW\NW_GW_VK_Pos_op04.imr TITLE,NW_GW_VK_Pos_op04.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, c277 as c269, c276 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."RECEPTION_DATE" as c277, T11."SALE_DATE" as c278, T11."PURCH_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" = '15') 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')) 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')) 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 (((((((((("deop04"."dbo"."VEH_ORDER_HEADER" T1 left outer join "deop04"."dbo"."vPP25" T2 on T1."STATUS" = T2."STAT_CODE") left outer join "deop04"."dbo"."DEPARTMENT_TYPE" T3 on T1."DEPARTMENT" = T3."DEPARTMENT_TYPE_ID") left outer join "deop04"."dbo"."vPP43" T4 on T1."SALESMAN" = T4."SELLER_CODE") left outer join "deop04"."dbo"."vPP4K" T5 on T1."FLEET_OWNER" = T5."FLEET_OWNER_CODE") left outer join "deop04"."dbo"."vPP48" T6 on T1."CUSTOMER_GROUP" = T6."CUSTOMER_GROUP") left outer join "deop04"."dbo"."vPP61" T7 on T1."STOCK" = T7."STOCK") left outer join "deop04"."dbo"."VEH_ORDER_LINE" T8 on T1."ORDER_NUMBER" = T8."ORDER_NUMBER") left outer join "deop04"."dbo"."vPP5M" T10 on T8."ACCOUNTING_CODE" = T10."BOOK_KEEPING_CODE") left outer join "deop04"."dbo"."UNIT_HISTORY" T16 on (T8."UNIT_NUMBER" = T16."UNIT_NUMBER") and (T8."ORDER_NUMBER" = T16."ORDER_NUMBER")) left outer join "deop04"."dbo"."vPP5A" T17 on T16."TRANSACTION_CODE" = T17."TRANSACTION_CODE"), (((((("deop04"."dbo"."UNIT_FILE" T11 left outer join "deop04"."dbo"."vPP5R" T9 on T11."VEHICLE_TYPE" = T9."VEHICLE_TYPE") left outer join "deop04"."dbo"."VEHICLE" T12 on T11."BASIS_NUMBER" = T12."BASIS_NUMBER") left outer join "deop04"."dbo"."vPP5Q" T13 on T12."MODEL_LINE" = T13."MODEL_LINE") left outer join "deop04"."dbo"."vPP74" T14 on (T12."WORKSHOP_MODEL" = T14."WORKSHOP_MODEL") and (T12."MAKE_CD" = T14."MAKE_CD")) left outer join "deop04"."dbo"."GLOBAL_MAKE" T15 on T12."MAKE_CD" = T15."GLOBAL_MAKE_CD") left outer join "deop04"."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')) 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,Purch Date COLUMN,267,Sale Date COLUMN,268,Reception Date COLUMN,269,verkaufte Standtage Basis COLUMN,270,Berechnungszahl COLUMN,271,verkaufte Standtage