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