GAPS/Portal/System/IQD/Serv_Teile/Aufträge_Gutschrift_deop04.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,O21_op04
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Serv_Teile\Aufträge_Gutschrift_deop04.imr
TITLE,Aufträge_Gutschrift_deop04.imr
BEGIN SQL
select c334 as c1,
	   c656 as c2,
	   c655 as c3,
	   c654 as c4,
	   c653 as c5,
	   c652 as c6,
	   c651 as c7,
	   c650 as c8,
	   c649 as c9,
	   c648 as c10,
	   c647 as c11,
	   c646 as c12,
	   c645 as c13,
	   c644 as c14,
	   c643 as c15,
	   c642 as c16,
	   c641 as c17,
	   c640 as c18,
	   c639 as c19,
	   c638 as c20,
	   c637 as c21,
	   c636 as c22,
	   c635 as c23,
	   c634 as c24,
	   c633 as c25,
	   c632 as c26,
	   c631 as c27,
	   c630 as c28,
	   c629 as c29,
	   c628 as c30,
	   c627 as c31,
	   c626 as c32,
	   c625 as c33,
	   c624 as c34,
	   c623 as c35,
	   c622 as c36,
	   c621 as c37,
	   c620 as c38,
	   c619 as c39,
	   c618 as c40,
	   c617 as c41,
	   c616 as c42,
	   c615 as c43,
	   c614 as c44,
	   c613 as c45,
	   c612 as c46,
	   c611 as c47,
	   c610 as c48,
	   c609 as c49,
	   c608 as c50,
	   c607 as c51,
	   c606 as c52,
	   c605 as c53,
	   c604 as c54,
	   c603 as c55,
	   c342 as c56,
	   c602 as c57,
	   c601 as c58,
	   c600 as c59,
	   c599 as c60,
	   c598 as c61,
	   c597 as c62,
	   c596 as c63,
	   c595 as c64,
	   c594 as c65,
	   c593 as c66,
	   c592 as c67,
	   c591 as c68,
	   c590 as c69,
	   c589 as c70,
	   c588 as c71,
	   c587 as c72,
	   c586 as c73,
	   c585 as c74,
	   c584 as c75,
	   c583 as c76,
	   c582 as c77,
	   c581 as c78,
	   c336 as c79,
	   c580 as c80,
	   c579 as c81,
	   c578 as c82,
	   c577 as c83,
	   c576 as c84,
	   c575 as c85,
	   c574 as c86,
	   c573 as c87,
	   c572 as c88,
	   c571 as c89,
	   c570 as c90,
	   c569 as c91,
	   c568 as c92,
	   c567 as c93,
	   c566 as c94,
	   c565 as c95,
	   c564 as c96,
	   c563 as c97,
	   c562 as c98,
	   c561 as c99,
	   c560 as c100,
	   c559 as c101,
	   c558 as c102,
	   c557 as c103,
	   c556 as c104,
	   c555 as c105,
	   c554 as c106,
	   c553 as c107,
	   c552 as c108,
	   c551 as c109,
	   c550 as c110,
	   c549 as c111,
	   c548 as c112,
	   c547 as c113,
	   c546 as c114,
	   c545 as c115,
	   c544 as c116,
	   c543 as c117,
	   c542 as c118,
	   c541 as c119,
	   c540 as c120,
	   c539 as c121,
	   c538 as c122,
	   c537 as c123,
	   c536 as c124,
	   c535 as c125,
	   c534 as c126,
	   c533 as c127,
	   c532 as c128,
	   c531 as c129,
	   c530 as c130,
	   c529 as c131,
	   c528 as c132,
	   c527 as c133,
	   c526 as c134,
	   c525 as c135,
	   c524 as c136,
	   c523 as c137,
	   c522 as c138,
	   c521 as c139,
	   c520 as c140,
	   c519 as c141,
	   c518 as c142,
	   c517 as c143,
	   c516 as c144,
	   c515 as c145,
	   c514 as c146,
	   c513 as c147,
	   c512 as c148,
	   c511 as c149,
	   c510 as c150,
	   c509 as c151,
	   c508 as c152,
	   c507 as c153,
	   c506 as c154,
	   c505 as c155,
	   c504 as c156,
	   c503 as c157,
	   c502 as c158,
	   c501 as c159,
	   c500 as c160,
	   c499 as c161,
	   c498 as c162,
	   c497 as c163,
	   c496 as c164,
	   c495 as c165,
	   c494 as c166,
	   c493 as c167,
	   c492 as c168,
	   c491 as c169,
	   c490 as c170,
	   c489 as c171,
	   c488 as c172,
	   c487 as c173,
	   c486 as c174,
	   c485 as c175,
	   c484 as c176,
	   c483 as c177,
	   c482 as c178,
	   c481 as c179,
	   c480 as c180,
	   c479 as c181,
	   c478 as c182,
	   c477 as c183,
	   c476 as c184,
	   c475 as c185,
	   c474 as c186,
	   c473 as c187,
	   c472 as c188,
	   c471 as c189,
	   c470 as c190,
	   c469 as c191,
	   c468 as c192,
	   c467 as c193,
	   c466 as c194,
	   c465 as c195,
	   c464 as c196,
	   c463 as c197,
	   c462 as c198,
	   c461 as c199,
	   c460 as c200,
	   c459 as c201,
	   c458 as c202,
	   c457 as c203,
	   c456 as c204,
	   c455 as c205,
	   c454 as c206,
	   c453 as c207,
	   c452 as c208,
	   c451 as c209,
	   c450 as c210,
	   c449 as c211,
	   c448 as c212,
	   c447 as c213,
	   c446 as c214,
	   c445 as c215,
	   c444 as c216,
	   c443 as c217,
	   c442 as c218,
	   c441 as c219,
	   c440 as c220,
	   c439 as c221,
	   c438 as c222,
	   c437 as c223,
	   c436 as c224,
	   c435 as c225,
	   c434 as c226,
	   c433 as c227,
	   c432 as c228,
	   c431 as c229,
	   c430 as c230,
	   c429 as c231,
	   c428 as c232,
	   c427 as c233,
	   c426 as c234,
	   c425 as c235,
	   c424 as c236,
	   c423 as c237,
	   c422 as c238,
	   c421 as c239,
	   c420 as c240,
	   c419 as c241,
	   c418 as c242,
	   c417 as c243,
	   c416 as c244,
	   c415 as c245,
	   c414 as c246,
	   c413 as c247,
	   c412 as c248,
	   c411 as c249,
	   c410 as c250,
	   c409 as c251,
	   c408 as c252,
	   c407 as c253,
	   c406 as c254,
	   c405 as c255,
	   c404 as c256,
	   c403 as c257,
	   c402 as c258,
	   c401 as c259,
	   c400 as c260,
	   c399 as c261,
	   c398 as c262,
	   c397 as c263,
	   c396 as c264,
	   c395 as c265,
	   c394 as c266,
	   c393 as c267,
	   c392 as c268,
	   c391 as c269,
	   c390 as c270,
	   c389 as c271,
	   c388 as c272,
	   c387 as c273,
	   c386 as c274,
	   c385 as c275,
	   c384 as c276,
	   c383 as c277,
	   c382 as c278,
	   c381 as c279,
	   c380 as c280,
	   c379 as c281,
	   c360 as c282,
	   c378 as c283,
	   c377 as c284,
	   c376 as c285,
	   c375 as c286,
	   c374 as c287,
	   c373 as c288,
	   c359 as c289,
	   c372 as c290,
	   c371 as c291,
	   c370 as c292,
	   c369 as c293,
	   c368 as c294,
	   c367 as c295,
	   1 as c296,
	   CASE WHEN (c336 IS NOT NULL) THEN (XCOUNT(c336 for c334)) ELSE (1) END as c297,
	   '1' as c298,
	   c366 as c299,
	   c365 as c300,
	   c364 as c301,
	   c363 as c302,
	   c362 as c303,
	   c361 as c304,
	   c360 as c305,
	   c359 as c306,
	   c358 as c307,
	   c357 as c308,
	   c356 as c309,
	   c355 as c310,
	   c354 as c311,
	   c353 as c312,
	   c352 as c313,
	   c351 as c314,
	   c350 as c315,
	   c349 as c316,
	   c348 as c317,
	   c347 as c318,
	   c346 as c319,
	   c345 as c320,
	   c344 as c321,
	   c343 as c322,
	   c343 as c323,
	   c342 as c324,
	   c341 as c325,
	   c340 as c326,
	   c339 as c327,
	   c338 as c328,
	   c337 as c329,
	   1 / (CASE WHEN (c336 IS NOT NULL) THEN (XCOUNT(c336 for c334)) ELSE (1) END) as c330,
	   c335 as c331
from 
(select T1."ORDER_NUMBER" as c334,
	   (database()) as c335,
	   T2."LINE_NUMBER" as c336,
	   (od_left((cast_numberToString(cast_integer(T1."ORDER_NUMBER"))),7)) || ' - ' || T2."HANDLER" || ' - ' || T1."DEBIT_ACCOUNT" || ' - ' || T1."NAME" || ' - ' || (asciiz(extract(YEAR FROM T1."INVOICE_DATE"),4) || '-' || asciiz(extract(MONTH FROM T1."INVOICE_DATE"),2) || '-' || asciiz(extract(DAY FROM T1."INVOICE_DATE"),2)) as c337,
	   CASE WHEN (T1."STATUS" IN ('35','37','47','50')) THEN ('Rechnung') WHEN (T1."STATUS" IN ('36','39','49','51')) THEN ('Gutschrift') ELSE null END as c338,
	   CASE WHEN ((T2."ORDER_LINETYPE" = '1') and (T1."STATUS" BETWEEN '30' AND '39')) THEN (T2."LINE_COSTS") ELSE null END as c339,
	   CASE WHEN ((T2."ORDER_LINETYPE" = '1') and (T1."STATUS" BETWEEN '40' AND '51')) THEN (T2."LINE_COSTS") ELSE null END as c340,
	   T1."BASIS_NUMBER" || ' - ' || T1."CHASSIS_NUMBER" as c341,
	   T1."MODEL_TEXT" as c342,
	   T9."DESCRIPTION" as c343,
	   T9."GLOBAL_MAKE_CD" as c344,
	   CASE WHEN (T2."MAKE_TIME_UNIT" = 'AW12') THEN (T2."USED_TIME") WHEN (T2."MAKE_TIME_UNIT" = 'S100') THEN (T2."USED_TIME" * 12) WHEN (T2."MAKE_TIME_UNIT" = 'A120') THEN (T2."USED_TIME" / 10) ELSE null END as c345,
	   CASE WHEN (T2."MAKE_TIME_UNIT" = 'AW12') THEN (T2."EST_TIME") WHEN (T2."MAKE_TIME_UNIT" IN ('A120','S100')) THEN (T2."EST_TIME" * 12) ELSE null END as c346,
	   T1."DEBIT_ACCOUNT" || ' - ' || T1."NAME" as c347,
	   CASE WHEN ((T2."MAKE_TIME_UNIT" = 'AW12') and (T2."LINE_GROUP_CODE" = '150')) THEN (T2."EST_TIME") WHEN ((T2."MAKE_TIME_UNIT" IN ('A120','S100')) and (T2."LINE_GROUP_CODE" = '150')) THEN (T2."INV_TIME_COST" * 12) WHEN ((T2."MAKE_TIME_UNIT" = 'AW12') and (T2."LINE_GROUP_CODE" <> '150')) THEN (T2."INV_TIME") WHEN ((T2."MAKE_TIME_UNIT" IN ('A120','S100')) and (T2."LINE_GROUP_CODE" <> '150')) THEN (T2."INV_TIME" * 12) ELSE null END as c348,
	   CASE WHEN ((T2."ORDER_LINETYPE" = '3') and (T2."PROD_CODE" <> 'TU')) THEN (T2."LINES_NET_VALUE") ELSE null END as c349,
	   CASE WHEN (T2."MAKE_TIME_UNIT" = 'AW12') THEN (T2."USED_TIME" / 12) WHEN (T2."MAKE_TIME_UNIT" = 'S100') THEN (T2."USED_TIME") WHEN (T2."MAKE_TIME_UNIT" = 'A120') THEN (T2."USED_TIME" / 120) ELSE null END as c350,
	   CASE WHEN (T2."MAKE_TIME_UNIT" = 'AW12') THEN (T2."EST_TIME" / 12) WHEN (T2."MAKE_TIME_UNIT" IN ('A120','S100')) THEN (T2."EST_TIME") ELSE null END as c351,
	   CASE WHEN (T2."MAKE_TIME_UNIT" = 'AW12') THEN (T2."INV_TIME" / 12) WHEN (T2."MAKE_TIME_UNIT" IN ('A120','S100')) THEN (T2."INV_TIME") ELSE null END as c352,
	   CASE WHEN (T1."STATUS" IN ('35','37','39','47','49')) THEN ('Rechnung/Gutschrift') WHEN (T1."STATUS" IN ('30','40','32','36')) THEN ('offen') WHEN (T1."STATUS" IN ('41')) THEN ('Kostenvoranschlag') ELSE null END as c353,
	   CASE WHEN ((T2."ORDER_LINETYPE" = '1') and (T1."STATUS" BETWEEN '30' AND '39')) THEN (T2."LINES_NET_VALUE") ELSE null END as c354,
	   CASE WHEN ((T2."INV_TIME" <> 0) and (T2."LINES_NET_VALUE" <> .00)) THEN (T2."LINES_NET_VALUE") WHEN ((T2."INV_TIME" <> 0) and (T2."LINES_NET_VALUE" = .00)) THEN (T2."REDUCTION_AMOUNT") ELSE null END as c355,
	   CASE WHEN ((T2."ORDER_LINETYPE" = '1') and (T1."STATUS" BETWEEN '40' AND '51')) THEN (T2."LINES_NET_VALUE") ELSE null END as c356,
	   T1."STATUS" || ' - ' || T3."STAT_SPECIFY" as c357,
	   CASE WHEN (T1."STATUS" BETWEEN '30' AND '39') THEN ('Teile') WHEN (T1."STATUS" BETWEEN '40' AND '51') THEN ('Service') WHEN (T1."STATUS" = '70') THEN ('sonst. Auftrag') WHEN (T1."STATUS" = '91') THEN ('Anfrage') ELSE null END as c358,
	   T7."SEL_NAME" as c359,
	   T5."SEL_NAME" as c360,
	   T1."PMT_TERM" || ' - ' || T1."PAYMENT_TEXT" as c361,
	   CASE WHEN ((T6."CUSTOMER_GROUP" BETWEEN '10' AND '59') or (T1."CUSTOMER_GROUP" LIKE '7%')) THEN ('extern') WHEN (T6."CUSTOMER_GROUP" LIKE '6%') THEN ('GWL') WHEN (((T6."CUSTOMER_GROUP" LIKE '9%') or (T1."PMT_TERM" = 'IN')) or ((od_left(T1."CUSTOMER_GROUP",1)) BETWEEN 'A' AND 'Z')) THEN ('intern') ELSE null END as c362,
	   T6."CUSTOMER_GROUP" || ' - ' || T6."CUST_GROUP_SPECIFY" as c363,
	   CASE WHEN (T7."SEL_DEPARTMENT" = '0316      ') THEN ((substring(T7."SEL_DEPARTMENT" from 4 for 1))) ELSE ((substring(T4."DEPARTMENT_TYPE_ID" from 4 for 1))) END as c364,
	   (substring(T4."DEPARTMENT_TYPE_ID" from 3 for 1)) as c365,
	   CASE WHEN (T7."SEL_DEPARTMENT" = '0316      ') THEN ((od_left(T7."SEL_DEPARTMENT",2))) ELSE ((od_left(T4."DEPARTMENT_TYPE_ID",2))) END as c366,
	   T8."REPAIR_GRP_SPECIFY" as c367,
	   T8."MAKE_CD" as c368,
	   T8."REPAIR_GROUP" as c369,
	   T7."SEL_FAMILY_NAME" as c370,
	   T7."SEL_FIRST_NAME" as c371,
	   T7."SEL_DEPARTMENT" as c372,
	   T7."SELLER_CODE" as c373,
	   T6."CUST_GROUP_SPECIFY" as c374,
	   T6."CUSTOMER_GROUP" as c375,
	   T5."SEL_FAMILY_NAME" as c376,
	   T5."SEL_FIRST_NAME" as c377,
	   T5."SEL_DEPARTMENT" as c378,
	   T5."SELLER_CODE" as c379,
	   T4."DESCRIPTION" as c380,
	   T4."DEPARTMENT_TYPE_ID" as c381,
	   T3."STAT_SPECIFY" as c382,
	   T3."STAT_CODE" as c383,
	   T2."UNIQUE_IDENT" as c384,
	   T2."REQUESTED_QUANTITY" as c385,
	   T2."ORIG_COST_PRICE" as c386,
	   T2."QTY_SOLD_NEGATIVE" as c387,
	   T2."DEDUCTIBLE_VAT" as c388,
	   T2."OIL" as c389,
	   T2."ORDER_QUANTITY_ALT_UNIT" as c390,
	   T2."SALES_UNIT_ALT" as c391,
	   T2."SALES_UNIT_STD" as c392,
	   T2."LINE_STATUS" as c393,
	   T2."DEPOSIT_TYPE" as c394,
	   T2."MAKE_TIME_UNIT" as c395,
	   T2."INV_TIME_INT" as c396,
	   T2."EST_TIME_INT" as c397,
	   T2."USED_TIME_INT" as c398,
	   T2."REQUISITION_NUMBER" as c399,
	   T2."SUPPLIER_CODE" as c400,
	   T2."SPECIAL_LOCK_NO" as c401,
	   T2."CREATE_MSC" as c402,
	   T2."TEXT_200" as c403,
	   T2."JOB_CODE_DESCR" as c404,
	   T2."CUSTOMER_COMPLAINT" as c405,
	   T2."WORK_TYPE_CODE" as c406,
	   T2."LINE_REFERENCE" as c407,
	   T2."STOCK_SHOP_LIST" as c408,
	   T2."EXTERNAL_ORIGIN" as c409,
	   T2."CCC" as c410,
	   T2."CCC_CATEGORY" as c411,
	   T2."BUYERS_REFERENCE" as c412,
	   T2."ORIG_PROD_GROUP" as c413,
	   T2."ORIG_MAKE_CD" as c414,
	   T2."ORIG_PROD_CODE" as c415,
	   T2."ORDER_LINE_TRANSM" as c416,
	   T2."MISC_6" as c417,
	   T2."MISC_5" as c418,
	   T2."MISC_4" as c419,
	   T2."MISC_3" as c420,
	   T2."MISC_2" as c421,
	   T2."MISC_1" as c422,
	   T2."PART_GROUP" as c423,
	   T2."CONSIGNMENT_CODE" as c424,
	   T2."ORDER_LINETYPE_4" as c425,
	   T2."INCOMPLETE_LINE_2" as c426,
	   T2."INCOMPLETE_LINE" as c427,
	   T2."AUTOMATIC_CREATED" as c428,
	   T2."REPAIR_GROUP_TYPE" as c429,
	   T2."EXTERNAL_STOCK" as c430,
	   T2."RESULTING_LINE_1" as c431,
	   T2."REDUCTION_FACTOR_1" as c432,
	   T2."FACTOR_CODE" as c433,
	   T2."TIME_CODE" as c434,
	   T2."INV_TIME_COST" as c435,
	   T2."REPEAT_REPAIR" as c436,
	   T2."CREATE_AFTER_RC" as c437,
	   T2."DISCOUNT_ALLOWANCE" as c438,
	   T2."COST_PRICE_TYPE_2" as c439,
	   T2."USED_TIME_TYPE_2" as c440,
	   T2."TIME_CODE_2" as c441,
	   T2."COST_PRICE_TYPE_1" as c442,
	   T2."USED_TIME_TYPE_1" as c443,
	   T2."TIME_CODE_1" as c444,
	   T2."COST_PRICE_WORK" as c445,
	   T2."RECOMMENDED_PRICE" as c446,
	   T2."REPAIR_CODE_ACCU" as c447,
	   T2."CASH_ACCOUNT" as c448,
	   T2."AMOUNT_OL" as c449,
	   T2."TXT_OL" as c450,
	   T2."TRANSACTION_CODE_2" as c451,
	   T2."TYPE_OL" as c452,
	   T2."KIT_PRINT_SPLIT" as c453,
	   T2."KIT_PRICE_DIFF" as c454,
	   T2."KIT_DELETE" as c455,
	   T2."KIT_MISC_DISC_PER" as c456,
	   T2."KIT_WORK_DISC_PER" as c457,
	   T2."KIT_PARTS_DISC_PER" as c458,
	   T2."KIT_CATALOG_CODE" as c459,
	   T2."KIT_ONE_LINEPRICE" as c460,
	   T2."KIT_ONE_LINE" as c461,
	   T2."CLASS_RULE" as c462,
	   T2."KIT_FIXED_PRICE" as c463,
	   T2."KIT_TEXT" as c464,
	   T2."WORKSHOP_MODEL" as c465,
	   T2."KIT_CODE" as c466,
	   T2."KIT_GROUP" as c467,
	   T2."W_MAIN_REPAIR_NO" as c468,
	   T2."WORKSHOP_AREA" as c469,
	   T2."END_TIME" as c470,
	   T2."END_DATE" as c471,
	   T2."START_TIME" as c472,
	   T2."WORK_DATE" as c473,
	   T2."INSPECTION_2" as c474,
	   T2."INSPECTION_1" as c475,
	   T2."LINE_COMMENT" as c476,
	   T2."REPAIR_POS" as c477,
	   T2."REPAIR_CODE_2" as c478,
	   T2."INV_TIME" as c479,
	   T2."EST_TIME" as c480,
	   T2."USED_TIME" as c481,
	   T2."TIME_RATE" as c482,
	   T2."RATE_PRICE_CODE" as c483,
	   T2."REPAIR_NAME" as c484,
	   T2."REPAIR_GROUP" as c485,
	   T2."REPAIR_CODE" as c486,
	   T2."REQUISITION_NUM" as c487,
	   T2."BACK_REG_CODE" as c488,
	   T2."LINE_WORKSHOP" as c489,
	   T2."LINE_CODE" as c490,
	   T2."LINE_TEXT_CODE" as c491,
	   T2."LINE_TEXTLINE_3" as c492,
	   T2."LINE_TEXTLINE_2" as c493,
	   T2."LINE_TEXTLINE_1" as c494,
	   T2."N_MAIN_PART_NO" as c495,
	   T2."REPLACE_CODE" as c496,
	   T2."CAMPAIGN_CODE" as c497,
	   T2."QUANTITY_DISC_CODE" as c498,
	   T2."STDPRICE_2" as c499,
	   T2."INTERNAL_TRANSFER" as c500,
	   T2."BACK_ORDER" as c501,
	   T2."BACK_ORDER_CD" as c502,
	   T2."ORIG_CREATION_CODE" as c503,
	   T2."ORIG_LINE_NO" as c504,
	   T2."ORIG_ORDER_NO" as c505,
	   T2."SALES_PRICE_INCL" as c506,
	   T2."SALES_PRICE" as c507,
	   T2."SPECIAL_PRICE" as c508,
	   T2."INV_TOTAL_NUMBER" as c509,
	   T2."CLAIM_RETURN_CODE" as c510,
	   T2."COSTPRICE_TAX" as c511,
	   T2."LINE_COSTS" as c512,
	   T2."RE_PURCHASE_PRICE" as c513,
	   T2."SPEC_PURCH_PRICE" as c514,
	   T2."DELIVERY_QUANTITY" as c515,
	   T2."ORDER_QUANTITY" as c516,
	   T2."DEDUCTABLE" as c517,
	   T2."LOCATION_3" as c518,
	   T2."LOCATION_2" as c519,
	   T2."LOCATION" as c520,
	   T2."PROD_NAME" as c521,
	   T2."PRODUCT_GROUP" as c522,
	   T2."MAKE_CD" as c523,
	   T2."PROD_CODE" as c524,
	   T2."SPLIT_AM_SUB2" as c525,
	   T2."SPLIT_AM_SUB1" as c526,
	   T2."SPLIT_AM_MAIN" as c527,
	   T2."SPLIT_TYPE" as c528,
	   T2."CLAIM_TROUBLE_CD" as c529,
	   T2."LINE_MISC_ADDS_PER" as c530,
	   T2."LINE_MISC_ADDS" as c531,
	   T2."TAX_DRAWN" as c532,
	   T2."TAX_C_U" as c533,
	   T2."VAT_RATE_CODE" as c534,
	   T2."TAX_CODE_1" as c535,
	   T2."LINES_NET_VALUE" as c536,
	   T2."STDPRICE" as c537,
	   T2."DISCOUNT" as c538,
	   T2."DISCOUNT_PERC_2" as c539,
	   T2."DISCOUNT_PERC" as c540,
	   T2."ADD_COST_CODE" as c541,
	   T2."DECIMAL_INDICATOR" as c542,
	   T2."STATISTIC_CODE" as c543,
	   T2."GROSS_DISCOUNT" as c544,
	   T2."STOCK" as c545,
	   T2."STATUS" as c546,
	   T2."WUST_CODE" as c547,
	   T2."R_DELIVERY_DATE" as c548,
	   T2."KIT_FIXED_PRICE_CD" as c549,
	   T2."CLAIM_NUMBER" as c550,
	   T2."CLAIM_CODE_IND" as c551,
	   T2."DISCOUNT_CODE" as c552,
	   T2."DISCOUNT_TABLE" as c553,
	   T2."SALESMAN" as c554,
	   T2."MECHANIC_CODE" as c555,
	   T2."PICKED" as c556,
	   T2."SMALL_ACCESSORIES" as c557,
	   T2."SPLIT_CODE_2" as c558,
	   T2."SPLIT_CODE" as c559,
	   T2."REDUCTION_POS" as c560,
	   T2."REDUCTION_CODE_2" as c561,
	   T2."REDUCTION_AMOUNT" as c562,
	   T2."REDUCTION_CODE" as c563,
	   T2."PRINT_INVOICE" as c564,
	   T2."JOB_CODE" as c565,
	   T2."RESULTING_LINE_2" as c566,
	   T2."RESULTING_LINE" as c567,
	   T2."ORDER_LINETYPE_3" as c568,
	   T2."ORDER_LINETYPE_2" as c569,
	   T2."ORDER_LINETYPE" as c570,
	   T2."FUNCTION_CODE" as c571,
	   T2."PROGRAM" as c572,
	   T2."PERSON_CODE" as c573,
	   T2."STATE_CODE" as c574,
	   T2."HANDLER" as c575,
	   T2."TRANSACT_DATE" as c576,
	   T2."LINE_GROUP_CODE" as c577,
	   T2."DELIVERY_DATE" as c578,
	   T2."KEY_MAKE_CD" as c579,
	   T2."KEY_PROD_CODE" as c580,
	   T2."ORDER_NUMBER" as c581,
	   T1."UNIQUE_IDENT" as c582,
	   T1."CONV_FLAG" as c583,
	   T1."ACTUAL_INV_DATE_TIME" as c584,
	   T1."FHG_REPORT" as c585,
	   T1."LDC_ORDER" as c586,
	   T1."USE_PARTS_PRE_PICKING" as c587,
	   T1."REF_IDENT_SALES_CLASS" as c588,
	   T1."REF_IDENT_INV_TOTAL" as c589,
	   T1."COMMISSION_SALESMAN" as c590,
	   T1."WORKSHOP_TEAM" as c591,
	   T1."CHASSIS_NUMBER" as c592,
	   T1."TRANSFER_MAKE_CD" as c593,
	   T1."YEAR_MODEL" as c594,
	   T1."MAKE_CD" as c595,
	   T1."FAC_MODEL_CODE_S" as c596,
	   T1."END_TIME" as c597,
	   T1."END_DATE" as c598,
	   T1."ARRIVAL_DATE" as c599,
	   T1."ARRIVAL_TIME" as c600,
	   T1."SPLIT_COUNTER" as c601,
	   T1."WORKSHOP_PRICECODE" as c602,
	   T1."BOL_TAX_SHARE" as c603,
	   T1."EXPECTED_ORDER_TIM" as c604,
	   T1."REFERENCE_NUMBER" as c605,
	   T1."DISCOUNT_LIMIT" as c606,
	   T1."MAIL_ADDR" as c607,
	   T1."ZIPCODE" as c608,
	   T1."ADDR_2" as c609,
	   T1."STREET_ADDR" as c610,
	   T1."NAME" as c611,
	   T1."TITLE" as c612,
	   T1."SALES_TAX_FREE" as c613,
	   T1."INVOICE_CHARGE" as c614,
	   T1."INVOICE_ROUNDED" as c615,
	   T1."INVOICE_DISC_PERC" as c616,
	   T1."SALES_CLASS_NUMBER" as c617,
	   T1."PREV_STATUS" as c618,
	   T1."MILEAGE" as c619,
	   T1."BASIS_NUMBER" as c620,
	   T1."INVOICE_COPY_CODE" as c621,
	   T1."SMALL_ACCESSORIES" as c622,
	   T1."CUSTOMER_GROUP" as c623,
	   T1."INTERNAL_CODE" as c624,
	   T1."PLACE_CODE" as c625,
	   T1."STOCK" as c626,
	   T1."MISC_ADDS" as c627,
	   T1."PRICE_CODE" as c628,
	   T1."DISCOUNT_AMOUNT" as c629,
	   T1."TAX_SHARE" as c630,
	   T1."ORDERS_GROSSVALUE" as c631,
	   T1."PURCH_TAX" as c632,
	   T1."COSTS" as c633,
	   T1."PAYMENT_TEXT" as c634,
	   T1."DUEDATE_1" as c635,
	   T1."NEXT_LINE_NUMBER" as c636,
	   T1."PMT_TERM" as c637,
	   T1."TAX_PERC" as c638,
	   T1."TAX_CODE" as c639,
	   T1."INVOICE_DATE" as c640,
	   T1."DELIVERY_DATE" as c641,
	   T1."ORDER_DATE" as c642,
	   T1."DEBIT_PERM" as c643,
	   T1."SALESMAN" as c644,
	   T1."DEBET_DEPARTMENT" as c645,
	   T1."DEPARTMENT" as c646,
	   T1."DELIVERY_ACCOUNT" as c647,
	   T1."HANDLER" as c648,
	   T1."TRANSACT_DATE" as c649,
	   T1."STATE_CODE" as c650,
	   T1."WORKSHOP_MODEL" as c651,
	   T1."INVOICE_NUMBER" as c652,
	   T1."DEBIT_ACCOUNT" as c653,
	   T1."STATE_KEY_DATE" as c654,
	   T1."STATUS" as c655,
	   T1."REGISTER_NUMBER" as c656
from (((((((("deop04"."dbo"."ORDER_HEADER" T1 left outer join "deop04"."dbo"."ORDER_LINE" T2 on T1."ORDER_NUMBER" = T2."ORDER_NUMBER") left outer join "deop04"."dbo"."vPP25" T3 on T1."STATUS" = T3."STAT_CODE") left outer join "deop04"."dbo"."DEPARTMENT_TYPE" T4 on T1."DEPARTMENT" = T4."DEPARTMENT_TYPE_ID") left outer join "deop04"."dbo"."vPP43" T5 on T1."SALESMAN" = T5."SELLER_CODE") left outer join "deop04"."dbo"."vPP48" T6 on T1."CUSTOMER_GROUP" = T6."CUSTOMER_GROUP") left outer join "deop04"."dbo"."vPP43" T7 on T2."MECHANIC_CODE" = T7."SELLER_CODE") left outer join "deop04"."dbo"."vPP73" T8 on (T2."REPAIR_GROUP" = T8."REPAIR_GROUP") and (T2."MAKE_CD" = T8."MAKE_CD")) left outer join "deop04"."dbo"."GLOBAL_MAKE" T9 on T1."MAKE_CD" = T9."GLOBAL_MAKE_CD")
where (((T1."STATUS" IN ('35','37','39','47','49','50','51','36')) and ((CASE WHEN (T1."STATUS" IN ('35','37','47','50')) THEN ('Rechnung') WHEN (T1."STATUS" IN ('36','39','49','51')) THEN ('Gutschrift') ELSE null END) LIKE '%Gutschrift%')) and ((extract(DAY FROM (now()) - T1."INVOICE_DATE")) <= 1460))
order by c334 asc
) D1

END SQL
COLUMN,0,Order Number
COLUMN,1,Register Number
COLUMN,2,Status
COLUMN,3,State Key Date
COLUMN,4,Debit Account
COLUMN,5,Invoice Number
COLUMN,6,Workshop Model
COLUMN,7,State Code
COLUMN,8,Transact Date
COLUMN,9,Handler_ori
COLUMN,10,Delivery Account
COLUMN,11,Department
COLUMN,12,Debet Department
COLUMN,13,Salesman
COLUMN,14,Debit Perm
COLUMN,15,Order Date
COLUMN,16,Delivery Date
COLUMN,17,Invoice Date
COLUMN,18,Tax Code
COLUMN,19,Tax Perc
COLUMN,20,Pmt Term
COLUMN,21,Next Line Number
COLUMN,22,Duedate 1
COLUMN,23,Payment Text
COLUMN,24,Costs
COLUMN,25,Purch Tax
COLUMN,26,Orders Grossvalue
COLUMN,27,Tax Share
COLUMN,28,Discount Amount
COLUMN,29,Price Code
COLUMN,30,Misc Adds
COLUMN,31,Stock
COLUMN,32,Place Code
COLUMN,33,Internal Code
COLUMN,34,Customer Group
COLUMN,35,Small Accessories
COLUMN,36,Invoice Copy Code
COLUMN,37,Basis Number
COLUMN,38,Mileage
COLUMN,39,Prev Status
COLUMN,40,Sales Class Number
COLUMN,41,Invoice Disc Perc
COLUMN,42,Invoice Rounded
COLUMN,43,Invoice Charge
COLUMN,44,Sales Tax Free
COLUMN,45,Title
COLUMN,46,Name
COLUMN,47,Street Addr
COLUMN,48,Addr 2
COLUMN,49,Zipcode
COLUMN,50,Mail Addr
COLUMN,51,Discount Limit
COLUMN,52,Reference Number
COLUMN,53,Expected Order Tim
COLUMN,54,Bol Tax Share
COLUMN,55,Model Text
COLUMN,56,Workshop Pricecode
COLUMN,57,Split Counter
COLUMN,58,Arrival Time
COLUMN,59,Arrival Date
COLUMN,60,End Date
COLUMN,61,End Time
COLUMN,62,Fac Model Code S
COLUMN,63,Make Cd
COLUMN,64,Year Model
COLUMN,65,Transfer Make Cd
COLUMN,66,Chassis Number
COLUMN,67,Workshop Team
COLUMN,68,Commission Salesman
COLUMN,69,Ref Ident Inv Total
COLUMN,70,Ref Ident Sales Class
COLUMN,71,Use Parts Pre Picking
COLUMN,72,Ldc Order
COLUMN,73,Fhg Report
COLUMN,74,Actual Inv Date Time
COLUMN,75,Conv Flag
COLUMN,76,Unique Ident
COLUMN,77,Order Number
COLUMN,78,Line Number
COLUMN,79,Key Prod Code
COLUMN,80,Key Make Cd
COLUMN,81,Delivery Date
COLUMN,82,Line Group Code
COLUMN,83,Transact Date
COLUMN,84,Handler
COLUMN,85,State Code
COLUMN,86,Person Code
COLUMN,87,Program
COLUMN,88,Function Code
COLUMN,89,Order Linetype
COLUMN,90,Order Linetype 2
COLUMN,91,Order Linetype 3
COLUMN,92,Resulting Line
COLUMN,93,Resulting Line 2
COLUMN,94,Job Code
COLUMN,95,Print Invoice
COLUMN,96,Reduction Code
COLUMN,97,Reduction Amount
COLUMN,98,Reduction Code 2
COLUMN,99,Reduction Pos
COLUMN,100,Split Code
COLUMN,101,Split Code 2
COLUMN,102,Small Accessories
COLUMN,103,Picked
COLUMN,104,Mechanic Code
COLUMN,105,Salesman
COLUMN,106,Discount Table
COLUMN,107,Discount Code
COLUMN,108,Claim Code Ind
COLUMN,109,Claim Number
COLUMN,110,Kit Fixed Price Cd
COLUMN,111,R Delivery Date
COLUMN,112,Wust Code
COLUMN,113,Status
COLUMN,114,Stock
COLUMN,115,Gross Discount
COLUMN,116,Statistic Code
COLUMN,117,Decimal Indicator
COLUMN,118,Add Cost Code
COLUMN,119,Discount Perc
COLUMN,120,Discount Perc 2
COLUMN,121,Discount
COLUMN,122,Stdprice
COLUMN,123,Lines Net Value
COLUMN,124,Tax Code 1
COLUMN,125,Vat Rate Code
COLUMN,126,Tax C U
COLUMN,127,Tax Drawn
COLUMN,128,Line Misc Adds
COLUMN,129,Line Misc Adds Per
COLUMN,130,Claim Trouble Cd
COLUMN,131,Split Type
COLUMN,132,Split Am Main
COLUMN,133,Split Am Sub1
COLUMN,134,Split Am Sub2
COLUMN,135,Prod Code
COLUMN,136,Make Cd
COLUMN,137,Product Group
COLUMN,138,Prod Name
COLUMN,139,Location
COLUMN,140,Location 2
COLUMN,141,Location 3
COLUMN,142,Deductable
COLUMN,143,Order Quantity
COLUMN,144,Delivery Quantity
COLUMN,145,Spec Purch Price
COLUMN,146,Re Purchase Price
COLUMN,147,Line Costs
COLUMN,148,Costprice Tax
COLUMN,149,Claim Return Code
COLUMN,150,Inv Total Number
COLUMN,151,Special Price
COLUMN,152,Sales Price
COLUMN,153,Sales Price Incl
COLUMN,154,Orig Order No
COLUMN,155,Orig Line No
COLUMN,156,Orig Creation Code
COLUMN,157,Back Order Cd
COLUMN,158,Back Order
COLUMN,159,Internal Transfer
COLUMN,160,Stdprice 2
COLUMN,161,Quantity Disc Code
COLUMN,162,Campaign Code
COLUMN,163,Replace Code
COLUMN,164,N Main Part No
COLUMN,165,Line Textline 1
COLUMN,166,Line Textline 2
COLUMN,167,Line Textline 3
COLUMN,168,Line Text Code
COLUMN,169,Line Code
COLUMN,170,Line Workshop
COLUMN,171,Back Reg Code
COLUMN,172,Requisition Num
COLUMN,173,Repair Code
COLUMN,174,Repair Group
COLUMN,175,Repair Name
COLUMN,176,Rate Price Code
COLUMN,177,Time Rate
COLUMN,178,Used Time
COLUMN,179,Est Time
COLUMN,180,Inv Time
COLUMN,181,Repair Code 2
COLUMN,182,Repair Pos
COLUMN,183,Line Comment
COLUMN,184,Inspection 1
COLUMN,185,Inspection 2
COLUMN,186,Work Date
COLUMN,187,Start Time
COLUMN,188,End Date
COLUMN,189,End Time
COLUMN,190,Workshop Area
COLUMN,191,W Main Repair No
COLUMN,192,Kit Group
COLUMN,193,Kit Code
COLUMN,194,Workshop Model
COLUMN,195,Kit Text
COLUMN,196,Kit Fixed Price
COLUMN,197,Class Rule
COLUMN,198,Kit One Line
COLUMN,199,Kit One Lineprice
COLUMN,200,Kit Catalog Code
COLUMN,201,Kit Parts Disc Per
COLUMN,202,Kit Work Disc Per
COLUMN,203,Kit Misc Disc Per
COLUMN,204,Kit Delete
COLUMN,205,Kit Price Diff
COLUMN,206,Kit Print Split
COLUMN,207,Type Ol
COLUMN,208,Transaction Code 2
COLUMN,209,Txt Ol
COLUMN,210,Amount Ol
COLUMN,211,Cash Account
COLUMN,212,Repair Code Accu
COLUMN,213,Recommended Price
COLUMN,214,Cost Price Work
COLUMN,215,Time Code 1
COLUMN,216,Used Time Type 1
COLUMN,217,Cost Price Type 1
COLUMN,218,Time Code 2
COLUMN,219,Used Time Type 2
COLUMN,220,Cost Price Type 2
COLUMN,221,Discount Allowance
COLUMN,222,Create After Rc
COLUMN,223,Repeat Repair
COLUMN,224,Inv Time Cost
COLUMN,225,Time Code
COLUMN,226,Factor Code
COLUMN,227,Reduction Factor 1
COLUMN,228,Resulting Line 1
COLUMN,229,External Stock
COLUMN,230,Repair Group Type
COLUMN,231,Automatic Created
COLUMN,232,Incomplete Line
COLUMN,233,Incomplete Line 2
COLUMN,234,Order Linetype 4
COLUMN,235,Consignment Code
COLUMN,236,Part Group
COLUMN,237,Misc 1
COLUMN,238,Misc 2
COLUMN,239,Misc 3
COLUMN,240,Misc 4
COLUMN,241,Misc 5
COLUMN,242,Misc 6
COLUMN,243,Order Line Transm
COLUMN,244,Orig Prod Code
COLUMN,245,Orig Make Cd
COLUMN,246,Orig Prod Group
COLUMN,247,Buyers Reference
COLUMN,248,Ccc Category
COLUMN,249,Ccc
COLUMN,250,External Origin
COLUMN,251,Stock Shop List
COLUMN,252,Line Reference
COLUMN,253,Work Type Code
COLUMN,254,Customer Complaint
COLUMN,255,Job Code Descr
COLUMN,256,Text 200
COLUMN,257,Create Msc
COLUMN,258,Special Lock No
COLUMN,259,Supplier Code
COLUMN,260,Requisition Number
COLUMN,261,Used Time Int
COLUMN,262,Est Time Int
COLUMN,263,Inv Time Int
COLUMN,264,Make Time Unit
COLUMN,265,Deposit Type
COLUMN,266,Line Status
COLUMN,267,Sales Unit Std
COLUMN,268,Sales Unit Alt
COLUMN,269,Order Quantity Alt Unit
COLUMN,270,Oil
COLUMN,271,Deductible Vat
COLUMN,272,Qty Sold Negative
COLUMN,273,Orig Cost Price
COLUMN,274,Requested Quantity
COLUMN,275,Unique Ident
COLUMN,276,Stat Code
COLUMN,277,Stat Specify
COLUMN,278,Department Type Id
COLUMN,279,Description
COLUMN,280,Seller Code
COLUMN,281,Sel Name
COLUMN,282,Sel Department
COLUMN,283,Sel First Name
COLUMN,284,Sel Family Name
COLUMN,285,Customer Group
COLUMN,286,Cust Group Specify
COLUMN,287,Seller Code
COLUMN,288,Sel Name_Monteur
COLUMN,289,Sel Department
COLUMN,290,Sel First Name_Monteur
COLUMN,291,Sel Family Name_Monteur
COLUMN,292,Repair Group
COLUMN,293,Make Cd
COLUMN,294,Repair Grp Specify
COLUMN,295,DG_1
COLUMN,296,DG_2
COLUMN,297,Hauptbetrieb
COLUMN,298,Standort
COLUMN,299,Marke
COLUMN,300,Kostenstelle
COLUMN,301,Kundenart
COLUMN,302,Umsatzart
COLUMN,303,Geschäftsart
COLUMN,304,Serviceberater
COLUMN,305,Monteur
COLUMN,306,Auftragsart
COLUMN,307,Auftragsstatus
COLUMN,308,Umsatz Teile Service
COLUMN,309,Umsatz Lohn
COLUMN,310,Umsatz Teile (nur Teile)
COLUMN,311,Status_1
COLUMN,312,verk. Stunden
COLUMN,313,Soll-Stunden (Auftrag)
COLUMN,314,benutzte Zeit (Auftrag)
COLUMN,315,Umsatz Sonstiges
COLUMN,316,verk. AW
COLUMN,317,Kunde
COLUMN,318,Soll AW
COLUMN,319,benutzte AW
COLUMN,320,Global Make Cd
COLUMN,321,Description
COLUMN,322,Fabrikat
COLUMN,323,Model
COLUMN,324,Fahrzeug
COLUMN,325,Einsatz Teile Service
COLUMN,326,Einsatz Teile (nur Teile)
COLUMN,327,Rechnung/Gutschrift
COLUMN,328,Kunde_fuer_Gutschriften
COLUMN,329,Durchgänge (Aufträge)
COLUMN,330,Mandant