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

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