C11/System/CARLO/IQD/Belege/auftraege_eds_fibu.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,GC_CARLO
DATASOURCENAME,C:\GlobalCube\System\CARLO\IQD\belege\auftraege_eds_fibu.imr
TITLE,auftraege_eds_fibu.imr
BEGIN SQL
select c314 as c1,
	   c313 as c2,
	   c312 as c3,
	   c311 as c4,
	   c310 as c5,
	   c309 as c6,
	   c308 as c7,
	   c307 as c8,
	   c306 as c9,
	   c305 as c10,
	   c304 as c11,
	   c303 as c12,
	   c302 as c13,
	   c301 as c14,
	   c300 as c15,
	   c299 as c16,
	   c298 as c17,
	   c297 as c18,
	   c296 as c19,
	   c295 as c20,
	   c294 as c21,
	   c180 as c22,
	   c293 as c23,
	   c292 as c24,
	   c291 as c25,
	   c290 as c26,
	   c289 as c27,
	   c232 as c28,
	   c288 as c29,
	   c287 as c30,
	   c231 as c31,
	   c286 as c32,
	   c285 as c33,
	   c284 as c34,
	   c283 as c35,
	   c282 as c36,
	   c224 as c37,
	   c281 as c38,
	   c280 as c39,
	   c279 as c40,
	   c278 as c41,
	   c277 as c42,
	   c276 as c43,
	   c219 as c44,
	   c275 as c45,
	   c274 as c46,
	   c273 as c47,
	   c272 as c48,
	   c271 as c49,
	   c270 as c50,
	   c269 as c51,
	   c268 as c52,
	   c267 as c53,
	   c193 as c54,
	   c266 as c55,
	   c265 as c56,
	   c264 as c57,
	   c211 as c58,
	   c206 as c59,
	   c263 as c60,
	   c262 as c61,
	   c261 as c62,
	   c260 as c63,
	   c259 as c64,
	   c258 as c65,
	   c257 as c66,
	   c256 as c67,
	   c197 as c68,
	   c255 as c69,
	   c210 as c70,
	   c209 as c71,
	   c254 as c72,
	   c253 as c73,
	   c252 as c74,
	   c251 as c75,
	   c250 as c76,
	   c249 as c77,
	   c248 as c78,
	   c247 as c79,
	   c246 as c80,
	   c245 as c81,
	   c244 as c82,
	   c243 as c83,
	   c242 as c84,
	   c241 as c85,
	   c240 as c86,
	   c239 as c87,
	   c208 as c88,
	   c238 as c89,
	   c207 as c90,
	   '1' as c91,
	   c237 as c92,
	   c237 as c93,
	   c236 as c94,
	   c236 as c95,
	   c235 as c96,
	   c234 as c97,
	   c233 as c98,
	   c232 as c99,
	   c231 as c100,
	   c218 as c101,
	   c230 as c102,
	   c229 as c103,
	   c228 as c104,
	   c227 as c105,
	   c226 as c106,
	   c180 as c107,
	   c225 as c108,
	   c224 as c109,
	   c223 as c110,
	   c223 as c111,
	   c222 as c112,
	   c221 as c113,
	   c220 as c114,
	   c219 as c115,
	   c218 as c116,
	   c217 as c117,
	   c216 as c118,
	   c215 as c119,
	   c214 as c120,
	   c213 as c121,
	   c212 as c122,
	   c211 as c123,
	   c206 as c124,
	   c210 as c125,
	   c209 as c126,
	   c208 as c127,
	   c207 as c128,
	   c206 as c129,
	   c205 as c130,
	   c204 as c131,
	   c175 as c132,
	   c203 as c133,
	   c202 as c134,
	   c201 as c135,
	   c200 as c136,
	   c199 as c137,
	   c177 as c138,
	   c198 as c139,
	   c197 as c140,
	   1 as c141,
	   c196 as c142,
	   c195 as c143,
	   c194 as c144,
	   c193 as c145,
	   c192 as c146,
	   c191 as c147,
	   c190 as c148,
	   c189 as c149,
	   c188 as c150,
	   c187 as c151,
	   c186 as c152,
	   c188 as c153,
	   c187 as c154,
	   c186 as c155,
	   c185 as c156,
	   c184 as c157,
	   c183 as c158,
	   c182 as c159,
	   c181 as c160,
	   1 as c161,
	   XCOUNT(c296 for c175) as c162,
	   1 / (XCOUNT(c296 for c175)) as c163,
	   c180 as c164,
	   '1' as c165,
	   c179 as c166,
	   'verkaufte Stückzahlen' as c167,
	   'Service' as c168,
	   c178 as c169,
	   c177 as c170,
	   c176 as c171
from 
(select T3."Auftragsnr_" as c175,
	   CASE WHEN (not (CASE WHEN (T3."Kostenstellencode" IN ('110','210','50','60','80','310','410')) THEN ('1') WHEN (T3."Kostenstellencode" IN ('120','220','20','52','62','85','10','320','420')) THEN ('2') WHEN (T3."Kostenstellencode" IN ('140','240','40','54','64','84','340','440')) THEN ('3') WHEN (T3."Kostenstellencode" IN ('141','241','41','55','65','81','341','441')) THEN ('4') WHEN (T3."Kostenstellencode" IN ('142','242','42','56','66','82','342')) THEN ('5') WHEN (T3."Kostenstellencode" IN ('150','230','231','30','31','53','63','83','330','331','430','431')) THEN ('6') WHEN (T3."Kostenstellencode" IN ('170','180','270','271','272','290','57','67','70','71','72','87','370')) THEN ('7') ELSE null END) IN ('3','4','5')) THEN ('3') ELSE ((CASE WHEN (T3."Kostenstellencode" IN ('110','210','50','60','80','310','410')) THEN ('1') WHEN (T3."Kostenstellencode" IN ('120','220','20','52','62','85','10','320','420')) THEN ('2') WHEN (T3."Kostenstellencode" IN ('140','240','40','54','64','84','340','440')) THEN ('3') WHEN (T3."Kostenstellencode" IN ('141','241','41','55','65','81','341','441')) THEN ('4') WHEN (T3."Kostenstellencode" IN ('142','242','42','56','66','82','342')) THEN ('5') WHEN (T3."Kostenstellencode" IN ('150','230','231','30','31','53','63','83','330','331','430','431')) THEN ('6') WHEN (T3."Kostenstellencode" IN ('170','180','270','271','272','290','57','67','70','71','72','87','370')) THEN ('7') ELSE null END)) END as c176,
	   (CASE WHEN ((T3."Geschäftsbuchungsgruppe" LIKE '%GWL%') or (T3."Geschäftsbuchungsgruppe" LIKE '%GEWL%')) THEN ('GWL') WHEN (T3."Geschäftsbuchungsgruppe" LIKE '%INTERN%') THEN ('Intern') ELSE ('Extern') END) as c177,
	   CASE WHEN ((CASE WHEN (T3."Kostenstellencode" IN ('110','210','50','60','80','310','410')) THEN ('1') WHEN (T3."Kostenstellencode" IN ('120','220','20','52','62','85','10','320','420')) THEN ('2') WHEN (T3."Kostenstellencode" IN ('140','240','40','54','64','84','340','440')) THEN ('3') WHEN (T3."Kostenstellencode" IN ('141','241','41','55','65','81','341','441')) THEN ('4') WHEN (T3."Kostenstellencode" IN ('142','242','42','56','66','82','342')) THEN ('5') WHEN (T3."Kostenstellencode" IN ('150','230','231','30','31','53','63','83','330','331','430','431')) THEN ('6') WHEN (T3."Kostenstellencode" IN ('170','180','270','271','272','290','57','67','70','71','72','87','370')) THEN ('7') ELSE null END) = '3') THEN ('Mechanik') WHEN ((CASE WHEN (T3."Kostenstellencode" IN ('110','210','50','60','80','310','410')) THEN ('1') WHEN (T3."Kostenstellencode" IN ('120','220','20','52','62','85','10','320','420')) THEN ('2') WHEN (T3."Kostenstellencode" IN ('140','240','40','54','64','84','340','440')) THEN ('3') WHEN (T3."Kostenstellencode" IN ('141','241','41','55','65','81','341','441')) THEN ('4') WHEN (T3."Kostenstellencode" IN ('142','242','42','56','66','82','342')) THEN ('5') WHEN (T3."Kostenstellencode" IN ('150','230','231','30','31','53','63','83','330','331','430','431')) THEN ('6') WHEN (T3."Kostenstellencode" IN ('170','180','270','271','272','290','57','67','70','71','72','87','370')) THEN ('7') ELSE null END) = '4') THEN ('Karosserie') WHEN ((CASE WHEN (T3."Kostenstellencode" IN ('110','210','50','60','80','310','410')) THEN ('1') WHEN (T3."Kostenstellencode" IN ('120','220','20','52','62','85','10','320','420')) THEN ('2') WHEN (T3."Kostenstellencode" IN ('140','240','40','54','64','84','340','440')) THEN ('3') WHEN (T3."Kostenstellencode" IN ('141','241','41','55','65','81','341','441')) THEN ('4') WHEN (T3."Kostenstellencode" IN ('142','242','42','56','66','82','342')) THEN ('5') WHEN (T3."Kostenstellencode" IN ('150','230','231','30','31','53','63','83','330','331','430','431')) THEN ('6') WHEN (T3."Kostenstellencode" IN ('170','180','270','271','272','290','57','67','70','71','72','87','370')) THEN ('7') ELSE null END) = '5') THEN ('Lack') ELSE ('Mechanik') END as c178,
	   CASE WHEN (T4."Code" IN ('00','05','09')) THEN ('Königsberger Str.') WHEN (T4."Code" IN ('10','15','19')) THEN ('Kevelaer') WHEN (T4."Code" IN ('20','25','29')) THEN ('Brunnenstr.') WHEN (T4."Code" IN ('30','35','39')) THEN ('Weilerswist') WHEN (T4."Code" IN ('50','55','59')) THEN ('Benrath') WHEN (T4."Code" IN ('40','45','49')) THEN ('Ratingen') WHEN (T4."Code" IN ('69','60','65')) THEN ('Automeile HW') WHEN (T4."Code" IN ('79','70','75')) THEN ('Ratingen II') ELSE null END as c179,
	   ((CASE WHEN (T1."Buchungsdatum" IS NULL) THEN (T2."Buchungsdatum") ELSE (T1."Buchungsdatum") END)) as c180,
	   ((CASE WHEN (T1."Nr_" IS NULL) THEN (T2."Nr_") ELSE (T1."Nr_") END) || ' - ' || T6."Name") || ' - ' || (T3."Serviceberaternr_" || ' - ' || T5."Vorname" || ' ' || T5."Nachname") || ' - ' || (asciiz(extract(YEAR FROM (CASE WHEN (T1."Buchungsdatum" IS NULL) THEN (T2."Buchungsdatum") ELSE (T1."Buchungsdatum") END)),4) || '-' || asciiz(extract(MONTH FROM (CASE WHEN (T1."Buchungsdatum" IS NULL) THEN (T2."Buchungsdatum") ELSE (T1."Buchungsdatum") END)),2) || '-' || asciiz(extract(DAY FROM (CASE WHEN (T1."Buchungsdatum" IS NULL) THEN (T2."Buchungsdatum") ELSE (T1."Buchungsdatum") END)),2)) as c181,
	   CASE WHEN ((((datepart({weekday},((getdate()))))) = 1) and ((extract(DAY FROM ((getdate())) - (CASE WHEN (T1."Buchungsdatum" IS NULL) THEN (T2."Buchungsdatum") ELSE (T1."Buchungsdatum") END))) IN (2,3,4))) THEN ((((CASE WHEN (T1."Nr_" IS NULL) THEN (T2."Nr_") ELSE (T1."Nr_") END) || ' - ' || T6."Name") || ' - ' || (T3."Serviceberaternr_" || ' - ' || T5."Vorname" || ' ' || T5."Nachname") || ' - ' || (asciiz(extract(YEAR FROM (CASE WHEN (T1."Buchungsdatum" IS NULL) THEN (T2."Buchungsdatum") ELSE (T1."Buchungsdatum") END)),4) || '-' || asciiz(extract(MONTH FROM (CASE WHEN (T1."Buchungsdatum" IS NULL) THEN (T2."Buchungsdatum") ELSE (T1."Buchungsdatum") END)),2) || '-' || asciiz(extract(DAY FROM (CASE WHEN (T1."Buchungsdatum" IS NULL) THEN (T2."Buchungsdatum") ELSE (T1."Buchungsdatum") END)),2)))) WHEN ((((datepart({weekday},((getdate()))))) IN (2,3,4,5,6)) and ((extract(DAY FROM ((getdate())) - (CASE WHEN (T1."Buchungsdatum" IS NULL) THEN (T2."Buchungsdatum") ELSE (T1."Buchungsdatum") END))) IN (1,2))) THEN ((((CASE WHEN (T1."Nr_" IS NULL) THEN (T2."Nr_") ELSE (T1."Nr_") END) || ' - ' || T6."Name") || ' - ' || (T3."Serviceberaternr_" || ' - ' || T5."Vorname" || ' ' || T5."Nachname") || ' - ' || (asciiz(extract(YEAR FROM (CASE WHEN (T1."Buchungsdatum" IS NULL) THEN (T2."Buchungsdatum") ELSE (T1."Buchungsdatum") END)),4) || '-' || asciiz(extract(MONTH FROM (CASE WHEN (T1."Buchungsdatum" IS NULL) THEN (T2."Buchungsdatum") ELSE (T1."Buchungsdatum") END)),2) || '-' || asciiz(extract(DAY FROM (CASE WHEN (T1."Buchungsdatum" IS NULL) THEN (T2."Buchungsdatum") ELSE (T1."Buchungsdatum") END)),2)))) ELSE null END as c182,
	   (cdate((CASE WHEN (T1."Buchungsdatum" IS NULL) THEN (T2."Buchungsdatum") ELSE (T1."Buchungsdatum") END))) as c183,
	   (datepart({weekday},((getdate())))) as c184,
	   (getdate()) as c185,
	   (T8."Einstandspreis (durchschn_)") as c186,
	   (T8."EK-Preis (neuester)") as c187,
	   (T8."Einstandspreis") as c188,
	   T8."VK-Preis" as c189,
	   T8."Basiseinheitencode" as c190,
	   T8."Beschreibung" as c191,
	   T8."Nr_" as c192,
	   (T3."Verrechnungsbetrag") as c193,
	   (CASE WHEN (T3."Art" = 1) THEN ((CASE WHEN (T3."Offen" = 0) THEN ((T3."Verkaufsbetrag" * -1)) ELSE ((T3."Verkaufsbetrag")) END)) ELSE (0) END) - (CASE WHEN (T3."Art" = 1) THEN (((T3."Einstandsbetrag"))) ELSE (0) END) as c194,
	   T3."Hauptdebitor" as c195,
	   T3."Herkunftsnr_(Zahlung)" as c196,
	   T3."Kundengruppencode" as c197,
	   CASE WHEN (T3."Kostenstellencode" BETWEEN '110' AND '190') THEN ('Citroen') WHEN (T3."Kostenstellencode" BETWEEN '210' AND '290') THEN ('GM') WHEN (T3."Kostenstellencode" IN ('31','20','70','41','30','40','10','72','71','42')) THEN ('Opel') WHEN (T3."Kostenstellencode" BETWEEN '50' AND '57') THEN ('Chevrolet') WHEN (T3."Kostenstellencode" BETWEEN '60' AND '67') THEN ('Chrysler') WHEN (T3."Kostenstellencode" BETWEEN '80' AND '87') THEN ('Lotus') WHEN (T3."Kostenstellencode" BETWEEN '410' AND '470') THEN ('Peugeot') ELSE ('Allgemein') END as c198,
	   T1."Archivierungsgrund" as c199,
	   T1."Arch_ durch Benutzer ID" as c200,
	   T1."Archivierungsdatum" as c201,
	   T9."Zeilennr_" as c202,
	   T9."Belegnr_" as c203,
	   CASE WHEN (((T3."Menge pro Stunde")) <> 0) THEN ((((T3."AW Mont_ 1")) + ((T3."AW Mont_ 2"))) / ((T3."Menge pro Stunde"))) ELSE (((T3."AW Mont_ 1")) + ((T3."AW Mont_ 2"))) END as c204,
	   CASE WHEN ((((T3."Menge pro Stunde")) <> 0) and ((((T3."Menge (Stunde)"))) >= 0)) THEN (((T3."Vorgabezeit")) / ((T3."Menge pro Stunde"))) WHEN ((((T3."Menge pro Stunde")) <> 0) and ((((T3."Menge (Stunde)"))) < 0)) THEN (((T3."Vorgabezeit")) / ((T3."Menge pro Stunde")) * -1) ELSE (((T3."Vorgabezeit"))) END as c205,
	   ((T3."Menge (Stunde)")) as c206,
	   (T3."AW Mont_ 2") as c207,
	   (T3."AW Mont_ 1") as c208,
	   T3."Vorgabezeitart" as c209,
	   (T3."Vorgabezeit") as c210,
	   (T3."Menge pro Stunde") as c211,
	   CASE WHEN (T3."Art" IN (0,3)) THEN (((T3."Einstandsbetrag"))) ELSE (0) END as c212,
	   CASE WHEN (((CASE WHEN (T3."Art" = 1) THEN (((T3."Einstandsbetrag"))) ELSE (0) END) = 0) and ((CASE WHEN (T3."Art" = 4) THEN ((CASE WHEN (T3."Offen" = 0) THEN ((T3."Verkaufsbetrag" * -1)) ELSE ((T3."Verkaufsbetrag")) END)) ELSE (0) END) = 0)) THEN (((T3."Menge")) * T8."Einstandspreis") ELSE ((CASE WHEN (T3."Art" = 1) THEN (((T3."Einstandsbetrag"))) ELSE (0) END)) END as c213,
	   CASE WHEN (T3."Art" = 1) THEN (((T3."Einstandsbetrag"))) ELSE (0) END as c214,
	   CASE WHEN (T3."Art" IN (0,3)) THEN ((CASE WHEN (T3."Offen" = 0) THEN ((T3."Verkaufsbetrag" * -1)) ELSE ((T3."Verkaufsbetrag")) END)) ELSE (0) END as c215,
	   CASE WHEN (T3."Art" = 1) THEN ((CASE WHEN (T3."Offen" = 0) THEN ((T3."Verkaufsbetrag" * -1)) ELSE ((T3."Verkaufsbetrag")) END)) ELSE (0) END as c216,
	   CASE WHEN (T3."Art" = 4) THEN ((CASE WHEN (T3."Offen" = 0) THEN ((T3."Verkaufsbetrag" * -1)) ELSE ((T3."Verkaufsbetrag")) END)) ELSE (0) END as c217,
	   (CASE WHEN (T3."Offen" = 0) THEN ((T3."Verkaufsbetrag" * -1)) ELSE ((T3."Verkaufsbetrag")) END) as c218,
	   T3."Produktbuchungsgruppe" as c219,
	   CASE WHEN (T3."Kostenstellencode" IN ('110','210','50','60','80','310','410')) THEN ('1') WHEN (T3."Kostenstellencode" IN ('120','220','20','52','62','85','10','320','420')) THEN ('2') WHEN (T3."Kostenstellencode" IN ('140','240','40','54','64','84','340','440')) THEN ('3') WHEN (T3."Kostenstellencode" IN ('141','241','41','55','65','81','341','441')) THEN ('4') WHEN (T3."Kostenstellencode" IN ('142','242','42','56','66','82','342')) THEN ('5') WHEN (T3."Kostenstellencode" IN ('150','230','231','30','31','53','63','83','330','331','430','431')) THEN ('6') WHEN (T3."Kostenstellencode" IN ('170','180','270','271','272','290','57','67','70','71','72','87','370')) THEN ('7') ELSE null END as c220,
	   CASE WHEN (T3."Kostenstellencode" = '') THEN ('99') ELSE ((substring(T3."Kostenstellencode" from 3 for 2))) END as c221,
	   T3."Fahrgestellnummer" || ' - ' || T7."Modell" as c222,
	   T7."Modell" as c223,
	   T3."Markencode" as c224,
	   (CASE WHEN (T1."Nr_" IS NULL) THEN (T2."Nr_") ELSE (T1."Nr_") END) || ' - ' || T6."Name" as c225,
	   T6."Nr_" || ' - ' || T6."Name" as c226,
	   T6."Name" as c227,
	   T6."Nr_" as c228,
	   CASE WHEN (((T3."Herkunftsnr_" LIKE '%INT%') or ((CASE WHEN (T1."Verk_ an Deb_-Nr_" IS NULL) THEN (T2."Verk_ an Deb_-Nr_") ELSE (T1."Verk_ an Deb_-Nr_") END) LIKE '%INT%')) or ((CASE WHEN (T1."Rech_ an Deb_-Nr_" IS NULL) THEN (T2."Rech_ an Deb_-Nr_") ELSE (T1."Rech_ an Deb_-Nr_") END) LIKE '%INT%')) THEN ('Intern') WHEN ((T3."Belegtyp" = 2) and (((not T3."Herkunftsnr_" LIKE '%INT%') or (not (CASE WHEN (T1."Verk_ an Deb_-Nr_" IS NULL) THEN (T2."Verk_ an Deb_-Nr_") ELSE (T1."Verk_ an Deb_-Nr_") END) LIKE '%INT%')) or (not (CASE WHEN (T1."Rech_ an Deb_-Nr_" IS NULL) THEN (T2."Rech_ an Deb_-Nr_") ELSE (T1."Rech_ an Deb_-Nr_") END) LIKE '%INT%'))) THEN ('Extern') WHEN ((T3."Belegtyp" = 3) and (((not T3."Herkunftsnr_" LIKE '%INT%') or (not (CASE WHEN (T1."Verk_ an Deb_-Nr_" IS NULL) THEN (T2."Verk_ an Deb_-Nr_") ELSE (T1."Verk_ an Deb_-Nr_") END) LIKE '%INT%')) or (not (CASE WHEN (T1."Rech_ an Deb_-Nr_" IS NULL) THEN (T2."Rech_ an Deb_-Nr_") ELSE (T1."Rech_ an Deb_-Nr_") END) LIKE '%INT%'))) THEN ('GWL') ELSE null END as c229,
	   CASE WHEN (T1."Rech_ an Deb_-Nr_" IS NULL) THEN (T2."Rech_ an Deb_-Nr_") ELSE (T1."Rech_ an Deb_-Nr_") END as c230,
	   (T3."Einstandsbetrag") as c231,
	   (T3."Menge") as c232,
	   T3."Serviceberaternr_" || ' - ' || T5."Vorname" || ' ' || T5."Nachname" as c233,
	   T5."Nachname" as c234,
	   T5."Vorname" as c235,
	   T4."Bezeichnung" as c236,
	   T4."Code" as c237,
	   T3."Monteur Nr_ 2" as c238,
	   T3."Monteur Nr_ 1" as c239,
	   T3."Tätigkeitsartcode" as c240,
	   T3."Mitarbeiternr_" as c241,
	   T3."Serviceberaternr_" as c242,
	   T3."Betrag int_ verrechnet (BW)" as c243,
	   T3."Betrag int_ verrechnet" as c244,
	   T3."Betrag int_ zu verrechnen (BW)" as c245,
	   T3."Betrag int_ zu verrechnen" as c246,
	   T3."Offen" as c247,
	   T3."Buchungsdatum (letzte Rechn_)" as c248,
	   T3."Auftrag erledigt" as c249,
	   T3."Verrechnungspreis fix" as c250,
	   T3."Interne Verrechnung erfolgt" as c251,
	   T3."Auftragszeilennr_" as c252,
	   T3."Herkunftsnr_" as c253,
	   T3."Herkunftsart" as c254,
	   T3."Ist-Menge (Stunde)" as c255,
	   T3."Positionsgruppencode" as c256,
	   T3."Untergruppencode" as c257,
	   T3."Hauptgruppencode" as c258,
	   T3."Marktsegmentcode" as c259,
	   T3."Fahrzeugstatus" as c260,
	   T3."Fahrzeugartencode" as c261,
	   T3."Belegtyp" as c262,
	   T3."Artikelgruppencode" as c263,
	   T3."Fahrgestellnummer" as c264,
	   T3."Abgeschlossen" as c265,
	   T3."Verrechnungsbetrag (BW)" as c266,
	   T3."Verrechnungspreis" as c267,
	   T3."Kostenstellencode Verkauf" as c268,
	   T3."Paketnr_" as c269,
	   T3."Fahrzeugtyp" as c270,
	   T3."Zeitart" as c271,
	   T3."Buchnr_" as c272,
	   T3."Storniert" as c273,
	   T3."Nummernserie" as c274,
	   T3."Belegdatum" as c275,
	   T3."Geschäftsbuchungsgruppe" as c276,
	   T3."Positiv" as c277,
	   T3."Postenart" as c278,
	   T3."Herkunftscode" as c279,
	   T3."Benutzer ID" as c280,
	   T3."Arbeitstypencode" as c281,
	   T3."Kostenstellencode" as c282,
	   T3."Werkstattbuchungsgruppe" as c283,
	   T3."Fakturierbar" as c284,
	   T3."Verkaufsbetrag" as c285,
	   T3."VK-Preis" as c286,
	   T3."Einstandspreis" as c287,
	   T3."EK-Preis" as c288,
	   T3."Beschreibung" as c289,
	   T3."Nr_" as c290,
	   T3."Art" as c291,
	   T3."Belegnr_" as c292,
	   CASE WHEN (T1."Filialcode" IS NULL) THEN (T2."Filialcode") ELSE (T1."Filialcode") END as c293,
	   CASE WHEN (T1."Auftragsdatum" IS NULL) THEN (T2."Auftragsdatum") ELSE (T1."Auftragsdatum") END as c294,
	   CASE WHEN (T1."Verk_ an Deb_-Nr_" IS NULL) THEN (T2."Verk_ an Deb_-Nr_") ELSE (T1."Verk_ an Deb_-Nr_") END as c295,
	   CASE WHEN (T1."Nr_" IS NULL) THEN (T2."Nr_") ELSE (T1."Nr_") END as c296,
	   CASE WHEN (T1."Belegart" IS NULL) THEN (T2."Belegart") ELSE (T1."Belegart") END as c297,
	   T2."Filialcode" as c298,
	   T1."Interne Belegnr_" as c299,
	   T1."Interner Auftrag" as c300,
	   T2."Interne Belegnr_" as c301,
	   T2."Buchungsdatum" as c302,
	   T2."Auftragsdatum" as c303,
	   T2."Rech_ an Deb_-Nr_" as c304,
	   T2."Verk_ an Deb_-Nr_" as c305,
	   T2."Nr_" as c306,
	   T2."Belegart" as c307,
	   T1."Filialcode" as c308,
	   T1."Buchungsdatum" as c309,
	   T1."Auftragsdatum" as c310,
	   T1."Rech_ an Deb_-Nr_" as c311,
	   T1."Verk_ an Deb_-Nr_" as c312,
	   T1."Nr_" as c313,
	   T1."Belegart" as c314
from (((((((("CARLO"."import"."Werkstattposten" T3 full outer join "CARLO"."import"."Archiv_Werkstattkopf" T1 on (T3."Auftragsnr_" = T1."Nr_") and (T3."Client_DB" = T1."Client_DB")) full outer join "CARLO"."import"."Werkstattkopf" T2 on (T2."Nr_" = T3."Auftragsnr_") and (T2."Client_DB" = T3."Client_DB")) left outer join "CARLO"."import"."Filialbezeichnung" T4 on (T4."Code" = T3."Filialcode") and (T4."Client_DB" = T3."Client_DB")) left outer join "CARLO"."import"."Employee" T5 on (T5."Nr_" = T3."Serviceberaternr_") and (T5."Client_DB" = T3."Client_DB")) left outer join "CARLO"."import"."Debitor" T6 on (T3."Herkunftsnr_" = T6."Nr_") and (T3."Client_DB" = T6."Client_DB")) left outer join "CARLO"."import"."Fahrzeug" T7 on (T3."Fahrgestellnummer" = T7."Fahrgestellnummer") and (T3."Client_DB" = T7."Client_DB")) left outer join "CARLO"."import"."Artikel" T8 on (T3."Nr_" = T8."Nr_") and (T3."Client_DB" = T8."Client_DB")) left outer join "CARLO"."import"."Archiv_Werkstattzeile" T9 on ((T3."Auftragsnr_" = T9."Belegnr_") and (T3."Auftragszeilennr_" = T9."Zeilennr_")) and (T3."Client_DB" = T9."Client_DB"))
where (((((((((((T3."Art" <> 2) and (not T3."Belegnr_" LIKE 'G%')) and (T3."Abgeschlossen" = 1)) and (T3."Nummernserie" <> '')) and (T3."Offen" = 0)) and ((T3."Belegnr_" LIKE 'WVRG%') or (T3."Belegnr_" LIKE 'WSGG%'))) and (T3."Nummernserie" <> 'WSLIEFG')) or ((((((T3."Art" <> 2) and (not T3."Belegnr_" LIKE 'G%')) and (T3."Abgeschlossen" = 1)) and (T3."Nummernserie" <> '')) and (T3."Offen" = 1)) and ((T3."Belegnr_" LIKE 'WVLG%') or (T3."Belegnr_" LIKE 'WVGL%')))) or (((((T3."Art" <> 2) and (not T3."Belegnr_" LIKE 'G%')) and (T3."Abgeschlossen" = 1)) and (T3."Offen" = 1)) and (T3."Belegnr_" LIKE 'WVAN%'))) and (((CASE WHEN (T1."Buchungsdatum" IS NULL) THEN (T2."Buchungsdatum") ELSE (T1."Buchungsdatum") END)) >= TIMESTAMP '2018-01-01 00:00:00.000')) and ((((T3."Menge (Stunde)"))) <> 0))
) D1
order by c19 asc

END SQL
COLUMN,0,A_Belegart
COLUMN,1,A_Nr
COLUMN,2,A_Verk An Deb -nr
COLUMN,3,A_Rech An Deb -nr
COLUMN,4,A_Auftragsdatum
COLUMN,5,A_Buchungsdatum
COLUMN,6,A_Filialcode
COLUMN,7,B_Belegart
COLUMN,8,B_Nr
COLUMN,9,B_Verk An Deb -nr
COLUMN,10,B_Rech An Deb -nr
COLUMN,11,B_Auftragsdatum
COLUMN,12,B_Buchungsdatum
COLUMN,13,B_Interne Belegnr
COLUMN,14,A_Interner Auftrag
COLUMN,15,A_Interne Belegnr
COLUMN,16,B_Filialcode
COLUMN,17,Belegart
COLUMN,18,Nr
COLUMN,19,Verk An Deb -nr
COLUMN,20,Auftragsdatum
COLUMN,21,Buchungsdatum
COLUMN,22,Filialcode
COLUMN,23,Belegnr
COLUMN,24,Art
COLUMN,25,APO_TEILE_Nr
COLUMN,26,Beschreibung
COLUMN,27,Menge_ori
COLUMN,28,Ek-preis
COLUMN,29,Einstandspreis
COLUMN,30,Einstandsbetrag_ori
COLUMN,31,Vk-preis
COLUMN,32,Verkaufsbetrag_ori
COLUMN,33,Fakturierbar
COLUMN,34,Werkstattbuchungsgruppe
COLUMN,35,Kostenstellencode
COLUMN,36,Markencode
COLUMN,37,Arbeitstypencode
COLUMN,38,Benutzer Id
COLUMN,39,Herkunftscode
COLUMN,40,Postenart
COLUMN,41,Positiv
COLUMN,42,Geschäftsbuchungsgruppe
COLUMN,43,Produktbuchungsgruppe
COLUMN,44,Belegdatum
COLUMN,45,Nummernserie
COLUMN,46,Storniert
COLUMN,47,Buchnr
COLUMN,48,Zeitart
COLUMN,49,Fahrzeugtyp
COLUMN,50,Paketnr
COLUMN,51,Kostenstellencode Verkauf
COLUMN,52,Verrechnungspreis
COLUMN,53,Verrechnungsbetrag_ori
COLUMN,54,Verrechnungsbetrag (bw)
COLUMN,55,Abgeschlossen
COLUMN,56,Fahrgestellnummer
COLUMN,57,Menge Pro Stunde
COLUMN,58,Menge (stunde)
COLUMN,59,Artikelgruppencode
COLUMN,60,Belegtyp
COLUMN,61,Fahrzeugartencode
COLUMN,62,Fahrzeugstatus
COLUMN,63,Marktsegmentcode
COLUMN,64,Hauptgruppencode
COLUMN,65,Untergruppencode
COLUMN,66,Positionsgruppencode
COLUMN,67,Kundengruppencode
COLUMN,68,Ist-menge (stunde)
COLUMN,69,Vorgabezeit
COLUMN,70,Vorgabezeitart
COLUMN,71,Herkunftsart
COLUMN,72,Herkunftsnr
COLUMN,73,Auftragszeilennr
COLUMN,74,Interne Verrechnung Erfolgt
COLUMN,75,Verrechnungspreis Fix
COLUMN,76,Auftrag Erledigt
COLUMN,77,Buchungsdatum (letzte Rechn )
COLUMN,78,Offen
COLUMN,79,Betrag Int Zu Verrechnen
COLUMN,80,Betrag Int Zu Verrechnen (bw)
COLUMN,81,Betrag Int Verrechnet
COLUMN,82,Betrag Int Verrechnet (bw)
COLUMN,83,Serviceberaternr
COLUMN,84,Mitarbeiternr
COLUMN,85,Tätigkeitsartcode
COLUMN,86,Monteur Nr 1
COLUMN,87,Aw Mont 1
COLUMN,88,Monteur Nr 2
COLUMN,89,Aw Mont 2
COLUMN,90,Hauptbetrieb
COLUMN,91,Standort
COLUMN,92,FIL-Code
COLUMN,93,FIL-Bezeichnung
COLUMN,94,Standort_1
COLUMN,95,Vorname
COLUMN,96,Nachname
COLUMN,97,Serviceberater
COLUMN,98,Menge
COLUMN,99,Einstandsbetrag
COLUMN,100,Verkaufsbetrag
COLUMN,101,Rech An Deb -nr
COLUMN,102,Umsatzart_ori
COLUMN,103,KD_Nr
COLUMN,104,KD_Name
COLUMN,105,Kunde
COLUMN,106,Invoice Date
COLUMN,107,Order Number
COLUMN,108,Fabrikat
COLUMN,109,Modell
COLUMN,110,Model
COLUMN,111,Fahrzeug
COLUMN,112,KST_aus_Code
COLUMN,113,Kostenstelle_alt
COLUMN,114,Auftragsart
COLUMN,115,Lines Net Value
COLUMN,116,Umsatz Lohn
COLUMN,117,Umsatz Teile Service
COLUMN,118,Umsatz Sonstiges
COLUMN,119,Einsatz Teile Service_ori
COLUMN,120,Einsatz Teile Service
COLUMN,121,Einsatz Sonstiges
COLUMN,122,Menge_pro_Stunde
COLUMN,123,Menge_stunde
COLUMN,124,Sollzeit
COLUMN,125,Sollzeit_Art
COLUMN,126,AW_Mont_1
COLUMN,127,AW_Mont_2
COLUMN,128,verk. Stunden
COLUMN,129,Soll-Stunden
COLUMN,130,benutzte Zeit_ori
COLUMN,131,Auftragsnr
COLUMN,132,A_Belegnr
COLUMN,133,A_Zeilennr
COLUMN,134,Archivierungsdatum
COLUMN,135,Arch Durch Benutzer Id
COLUMN,136,Archivierungsgrund
COLUMN,137,Umsatzart
COLUMN,138,Marke
COLUMN,139,Kundenart
COLUMN,140,DG_1
COLUMN,141,Herkunftsnr (zahlung)
COLUMN,142,Hauptdebitor
COLUMN,143,DB Teile
COLUMN,144,Verr_Betrag
COLUMN,145,Nr
COLUMN,146,Beschreibung
COLUMN,147,Basiseinheitencode
COLUMN,148,Vk-preis
COLUMN,149,Einstandspreis_ART
COLUMN,150,Ek-preis (neuester)_ART
COLUMN,151,Einstandspreis (durchschn )_ART
COLUMN,152,Einstandspreis_Art
COLUMN,153,EK_preis_neu_Art
COLUMN,154,Einstandspreis_Durch_Art
COLUMN,155,Heute
COLUMN,156,Tag
COLUMN,157,Buchungsdatum_Datum
COLUMN,158,Rechnungsausgang
COLUMN,159,Order_Number_RG_Ausg
COLUMN,160,DG_1
COLUMN,161,DG_2
COLUMN,162,Durchgänge
COLUMN,163,Bookkeep Date
COLUMN,164,Rechtseinheit
COLUMN,165,Betrieb
COLUMN,166,Ebene1
COLUMN,167,Ebene2
COLUMN,168,Ebene3
COLUMN,169,Ebene4
COLUMN,170,Kostenstelle