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)