Service_offene_Auftraege_neu_mitMont_Anzeige.iqd 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459
  1. COGNOS QUERY
  2. STRUCTURE,1,1
  3. DATABASE,ARIntelligence
  4. DATASOURCENAME,C:\GlobalCube\SYSTEM\ARIntelligence\IQD\service\Service_offene_Auftraege_neu_mitMont_Anzeige.imr
  5. TITLE,Service_offene_Auftraege_neu_mitMont_Anzeige.imr
  6. BEGIN SQL
  7. select c292 as c1,
  8. c291 as c2,
  9. c290 as c3,
  10. c289 as c4,
  11. c288 as c5,
  12. c164 as c6,
  13. c287 as c7,
  14. c286 as c8,
  15. c285 as c9,
  16. c284 as c10,
  17. c283 as c11,
  18. c282 as c12,
  19. c281 as c13,
  20. c280 as c14,
  21. c279 as c15,
  22. c278 as c16,
  23. c277 as c17,
  24. c276 as c18,
  25. c275 as c19,
  26. c274 as c20,
  27. c273 as c21,
  28. c272 as c22,
  29. c163 as c23,
  30. c271 as c24,
  31. c270 as c25,
  32. c269 as c26,
  33. c268 as c27,
  34. c267 as c28,
  35. c266 as c29,
  36. c265 as c30,
  37. c264 as c31,
  38. c263 as c32,
  39. c262 as c33,
  40. c261 as c34,
  41. c260 as c35,
  42. c259 as c36,
  43. c258 as c37,
  44. c257 as c38,
  45. c256 as c39,
  46. c255 as c40,
  47. c254 as c41,
  48. c253 as c42,
  49. c252 as c43,
  50. c251 as c44,
  51. c250 as c45,
  52. '1' as c46,
  53. c249 as c47,
  54. c248 as c48,
  55. c247 as c49,
  56. c246 as c50,
  57. c245 as c51,
  58. c176 as c52,
  59. '' as c53,
  60. c244 as c54,
  61. c160 as c55,
  62. c243 as c56,
  63. c166 as c57,
  64. c242 as c58,
  65. c241 as c59,
  66. c240 as c60,
  67. c239 as c61,
  68. c238 as c62,
  69. c237 as c63,
  70. c236 as c64,
  71. c235 as c65,
  72. c234 as c66,
  73. c233 as c67,
  74. c232 as c68,
  75. c231 as c69,
  76. c230 as c70,
  77. c229 as c71,
  78. c228 as c72,
  79. c227 as c73,
  80. c226 as c74,
  81. c225 as c75,
  82. c224 as c76,
  83. c223 as c77,
  84. c222 as c78,
  85. c221 as c79,
  86. c220 as c80,
  87. c219 as c81,
  88. c218 as c82,
  89. c217 as c83,
  90. c216 as c84,
  91. c215 as c85,
  92. c214 as c86,
  93. c213 as c87,
  94. c212 as c88,
  95. c211 as c89,
  96. c210 as c90,
  97. c209 as c91,
  98. c208 as c92,
  99. c207 as c93,
  100. c206 as c94,
  101. c205 as c95,
  102. c204 as c96,
  103. c203 as c97,
  104. c202 as c98,
  105. c201 as c99,
  106. c200 as c100,
  107. c199 as c101,
  108. c198 as c102,
  109. c197 as c103,
  110. c196 as c104,
  111. c195 as c105,
  112. c194 as c106,
  113. c193 as c107,
  114. c192 as c108,
  115. c191 as c109,
  116. c190 as c110,
  117. c189 as c111,
  118. c162 as c112,
  119. c188 as c113,
  120. c187 as c114,
  121. c186 as c115,
  122. c185 as c116,
  123. c184 as c117,
  124. c161 as c118,
  125. c183 as c119,
  126. c182 as c120,
  127. c181 as c121,
  128. c180 as c122,
  129. c181 as c123,
  130. c180 as c124,
  131. c179 as c125,
  132. c164 as c126,
  133. 1 as c127,
  134. XCOUNT(c291 for c160) as c128,
  135. 1 / (XCOUNT(c291 for c160)) as c129,
  136. c165 as c130,
  137. (c165) / (XCOUNT(c291 for c160)) as c131,
  138. c178 as c132,
  139. c177 as c133,
  140. c176 as c134,
  141. c175 as c135,
  142. c164 as c136,
  143. 0 as c137,
  144. c174 as c138,
  145. (c174) / (XCOUNT(c291 for c160)) as c139,
  146. c173 as c140,
  147. c171 as c141,
  148. c172 as c142,
  149. (c171) / (XCOUNT(c291 for c160)) as c143,
  150. c170 as c144,
  151. c169 as c145,
  152. c168 as c146,
  153. c167 as c147,
  154. c166 as c148,
  155. c165 as c149,
  156. (1 / (XCOUNT(c291 for c160))) as c150,
  157. c165 as c151,
  158. c164 as c152,
  159. '' as c153,
  160. c163 as c154,
  161. c162 as c155,
  162. c161 as c156
  163. from
  164. (select (CASE WHEN ((((T2."First Name" || ' ' || T2."Last Name"))) IS NOT NULL) THEN (T1."No_" || ' - ' || (T1."Bill-to Customer No_" || ' - ' || T1."Bill-to Name") || ' - ' || (((T2."First Name" || ' ' || T2."Last Name"))) || ' - ' || (asciiz(extract(YEAR FROM T1."Order Date"),4) || '-' || asciiz(extract(MONTH FROM T1."Order Date"),2) || '-' || asciiz(extract(DAY FROM T1."Order Date"),2))) WHEN ((((T2."First Name" || ' ' || T2."Last Name"))) IS NULL) THEN (T1."No_" || ' - ' || (T1."Bill-to Customer No_" || ' - ' || T1."Bill-to Name") || ' - ' || (asciiz(extract(YEAR FROM T1."Order Date"),4) || '-' || asciiz(extract(MONTH FROM T1."Order Date"),2) || '-' || asciiz(extract(DAY FROM T1."Order Date"),2))) ELSE null END) as c160,
  165. ((CASE WHEN (T3."Type" = 4) THEN ((cast_float(T3."Qty_ (Hour)"))) ELSE (0) END) * ((cast_float(T3."Qty_ per Hour")))) as c161,
  166. (CASE WHEN (T3."Type" = 1) THEN (((cast_float(T3."Total Price")))) ELSE (0) END) as c162,
  167. T1."VIN" as c163,
  168. T1."Order Date" as c164,
  169. ((extract(DAY FROM (now()) - T1."Order Date"))) as c165,
  170. T3."Order No_" as c166,
  171. CASE WHEN ((T2."First Name" || ' ' || T2."Last Name") IS NOT NULL) THEN (T1."No_" || ' - ' || T1."VIN" || ' / ' || T1."Model" || ' - ' || T1."Sell-to Customer Name" || ' / ' || T1."Bill-to Customer No_" || ' - ' || (T2."First Name" || ' ' || T2."Last Name") || ' - ' || (asciiz(extract(YEAR FROM T1."Order Date"),4) || '-' || asciiz(extract(MONTH FROM T1."Order Date"),2) || '-' || asciiz(extract(DAY FROM T1."Order Date"),2)) || ' / ' || 'Abh. Termin:' || ' ' || (asciiz(extract(YEAR FROM T1."Pickup Date"),4) || '-' || asciiz(extract(MONTH FROM T1."Pickup Date"),2) || '-' || asciiz(extract(DAY FROM T1."Pickup Date"),2))) WHEN ((T2."First Name" || ' ' || T2."Last Name") IS NULL) THEN (T1."No_" || ' - ' || T1."VIN" || ' / ' || T1."Model" || ' - ' || T1."Sell-to Customer Name" || ' / ' || T1."Bill-to Customer No_" || ' - ' || (asciiz(extract(YEAR FROM T1."Order Date"),4) || '-' || asciiz(extract(MONTH FROM T1."Order Date"),2) || '-' || asciiz(extract(DAY FROM T1."Order Date"),2)) || ' / ' || 'Abh. Termin:' || ' ' || (asciiz(extract(YEAR FROM T1."Pickup Date"),4) || '-' || asciiz(extract(MONTH FROM T1."Pickup Date"),2) || '-' || asciiz(extract(DAY FROM T1."Pickup Date"),2))) ELSE null END as c167,
  172. T1."Sell-to Customer Name" as c168,
  173. T1."Bill-to Contact" as c169,
  174. T6."Name" as c170,
  175. (extract(DAY FROM (now()) - T1."Pickup Date")) as c171,
  176. CASE WHEN (T1."Sell-to Customer No_" IN ('INTERN1','INTERN2')) THEN ('Intern') ELSE ('Extern') END as c172,
  177. CASE WHEN (T1."Sell-to Customer No_" IN ('INTERN1','INTERN2')) THEN ((CASE WHEN ((T2."First Name" || ' ' || T2."Last Name") IS NOT NULL) THEN (T1."No_" || ' - ' || (T1."Bill-to Customer No_" || ' - ' || T1."Bill-to Name") || ' - ' || (T2."First Name" || ' ' || T2."Last Name") || ' - ' || (asciiz(extract(YEAR FROM T1."Order Date"),4) || '-' || asciiz(extract(MONTH FROM T1."Order Date"),2) || '-' || asciiz(extract(DAY FROM T1."Order Date"),2))) WHEN ((T2."First Name" || ' ' || T2."Last Name") IS NULL) THEN (T1."No_" || ' - ' || (T1."Bill-to Customer No_" || ' - ' || T1."Bill-to Name") || ' - ' || (asciiz(extract(YEAR FROM T1."Order Date"),4) || '-' || asciiz(extract(MONTH FROM T1."Order Date"),2) || '-' || asciiz(extract(DAY FROM T1."Order Date"),2))) ELSE null END) || ' / ' || T1."VIN" || ' / ' || T1."Model" || ' - ' || 'Abh.Termin:' || ' ' || (asciiz(extract(YEAR FROM T1."Pickup Date"),4) || '-' || asciiz(extract(MONTH FROM T1."Pickup Date"),2) || '-' || asciiz(extract(DAY FROM T1."Pickup Date"),2)) || ' - ' || T1."Sell-to Customer Name") ELSE null END as c173,
  178. CASE WHEN (0 IS NULL) THEN (((extract(DAY FROM (now()) - T1."Order Date")))) ELSE (0) END as c174,
  179. CASE WHEN ((T2."First Name" || ' ' || T2."Last Name") IS NOT NULL) THEN (T1."No_" || ' - ' || (T1."Bill-to Customer No_" || ' - ' || T1."Bill-to Name") || ' - ' || (T2."First Name" || ' ' || T2."Last Name") || ' - ' || (asciiz(extract(YEAR FROM T1."Order Date"),4) || '-' || asciiz(extract(MONTH FROM T1."Order Date"),2) || '-' || asciiz(extract(DAY FROM T1."Order Date"),2))) WHEN ((T2."First Name" || ' ' || T2."Last Name") IS NULL) THEN (T1."No_" || ' - ' || (T1."Bill-to Customer No_" || ' - ' || T1."Bill-to Name") || ' - ' || (asciiz(extract(YEAR FROM T1."Order Date"),4) || '-' || asciiz(extract(MONTH FROM T1."Order Date"),2) || '-' || asciiz(extract(DAY FROM T1."Order Date"),2))) ELSE null END as c175,
  180. ((T2."First Name" || ' ' || T2."Last Name")) as c176,
  181. T5."Last Name" as c177,
  182. CASE WHEN ((T3."Type" = 1) and (T3."Document No_" IS NOT NULL)) THEN (((cast_float(T3."Total Price")))) ELSE (0) END as c178,
  183. CASE WHEN (not T4."Function Code" IN ('AZUBI','AZUBIG')) THEN (((CASE WHEN (T3."Type" = 2) THEN ((cast_float(T3."Qty_ Evaluated"))) ELSE (0) END) * 12)) ELSE (0) END as c179,
  184. T4."Function Code" as c180,
  185. T4."Name" as c181,
  186. (CASE WHEN (T3."Type" = 2) THEN ((cast_float(T3."Qty_ Evaluated"))) ELSE (0) END) * 12 as c182,
  187. CASE WHEN (T3."Type" = 2) THEN ((cast_float(T3."Qty_ Evaluated"))) ELSE (0) END as c183,
  188. CASE WHEN (T3."Type" = 4) THEN ((cast_float(T3."Qty_ (Hour)"))) ELSE (0) END as c184,
  189. (cast_float(T3."Qty_ per Hour")) as c185,
  190. CASE WHEN (T3."Type" IN (0,3)) THEN (((cast_float(T3."Total Cost")))) ELSE (0) END as c186,
  191. CASE WHEN (T3."Type" = 1) THEN (((cast_float(T3."Total Cost")))) ELSE (0) END as c187,
  192. CASE WHEN (T3."Type" IN (0,3)) THEN (((cast_float(T3."Total Price")))) ELSE (0) END as c188,
  193. CASE WHEN (T3."Type" = 4) THEN (((cast_float(T3."Total Price")))) ELSE (0) END as c189,
  194. (cast_float(T3."Total Price")) as c190,
  195. (cast_float(T3."Total Cost")) as c191,
  196. (cast_float(T3."Quantity")) as c192,
  197. T3."Labor Standard Time Type" as c193,
  198. T3."Open Quantity" as c194,
  199. T3."Closed by Quantity" as c195,
  200. T3."Closed at Date" as c196,
  201. T3."Closed by Entry No_" as c197,
  202. T3."Open" as c198,
  203. T3."Order Completed" as c199,
  204. T3."Internal Charged" as c200,
  205. T3."Time Until" as c201,
  206. T3."Time From" as c202,
  207. T3."Order Line No_" as c203,
  208. T3."Main Customer" as c204,
  209. T3."Source Type" as c205,
  210. T3."Standard Time Type" as c206,
  211. T3."Standard Time" as c207,
  212. T3."Charging Group No_" as c208,
  213. T3."Customer Group Code" as c209,
  214. T3."Document Type" as c210,
  215. T3."Item Group Code" as c211,
  216. T3."Qty_ (Hour)" as c212,
  217. T3."Qty_ per Hour" as c213,
  218. T3."Closed" as c214,
  219. T3."Assoc_ Entry" as c215,
  220. T3."Service Job No_" as c216,
  221. T3."Time Type" as c217,
  222. T3."Quantity (Base)" as c218,
  223. T3."Qty_ per Unit of Measure" as c219,
  224. T3."Variant Code" as c220,
  225. T3."Corrected" as c221,
  226. T3."Qty_ Evaluated" as c222,
  227. T3."Positive" as c223,
  228. T3."Entry Type" as c224,
  229. T3."Amt_ Recognized" as c225,
  230. T3."Amt_ to Recognize" as c226,
  231. T3."Amt_ Posted to G_L" as c227,
  232. T3."Amt_ to Post to G_L" as c228,
  233. T3."User ID" as c229,
  234. T3."Work Type Code" as c230,
  235. T3."Department Code" as c231,
  236. T3."Total Price" as c232,
  237. T3."Unit Price" as c233,
  238. T3."Total Cost" as c234,
  239. T3."Unit Cost" as c235,
  240. T3."Direct Unit Cost" as c236,
  241. T3."Quantity" as c237,
  242. T3."Description" as c238,
  243. T3."No_" as c239,
  244. T3."Type" as c240,
  245. T3."Document No_" as c241,
  246. T3."Posting Date" as c242,
  247. T3."Entry No_" as c243,
  248. T1."Bill-to Customer No_" || ' - ' || T1."Bill-to Name" as c244,
  249. T2."Last Name" as c245,
  250. T2."First Name" as c246,
  251. T2."No_" as c247,
  252. CASE WHEN ((T1."Location Code" = 'HB') or (T1."Location Code" = '')) THEN ('10') WHEN (T1."Location Code" = 'NB') THEN ('20') ELSE ((od_left(T1."Department Code",2))) END as c248,
  253. (od_left(T1."Department Code",2)) as c249,
  254. T1."Service Advisor No_" as c250,
  255. T1."Status Code" as c251,
  256. T1."Work Completed" as c252,
  257. T1."Current Instruction Type" as c253,
  258. T1."Fixed Instruction" as c254,
  259. T1."Fixed Date" as c255,
  260. T1."Sales Department Code" as c256,
  261. T1."Branch Book No_" as c257,
  262. T1."Book No_" as c258,
  263. T1."Labor Charging Code" as c259,
  264. T1."Labor Type" as c260,
  265. T1."Completion Time" as c261,
  266. T1."Completion Date" as c262,
  267. T1."Pickup Time" as c263,
  268. T1."Pickup Date" as c264,
  269. T1."Time of Order" as c265,
  270. T1."Order Limit" as c266,
  271. T1."Initial Registration" as c267,
  272. T1."Type" as c268,
  273. T1."Model" as c269,
  274. T1."Model No_" as c270,
  275. T1."Model Code" as c271,
  276. T1."Service Posting Group" as c272,
  277. T1."Option Code" as c273,
  278. T1."Reserve" as c274,
  279. T1."Area" as c275,
  280. T1."Document Date" as c276,
  281. T1."Correction" as c277,
  282. T1."Transport Method" as c278,
  283. T1."Transaction Type" as c279,
  284. T1."On Hold" as c280,
  285. T1."Salesperson Code" as c281,
  286. T1."Make Code" as c282,
  287. T1."Department Code" as c283,
  288. T1."Location Code" as c284,
  289. T1."Due Date" as c285,
  290. T1."Posting Description" as c286,
  291. T1."Posting Date" as c287,
  292. T1."Bill-to Name" as c288,
  293. T1."Bill-to Customer No_" as c289,
  294. T1."Sell-to Customer No_" as c290,
  295. T1."No_" as c291,
  296. T1."Document Type" as c292
  297. from ((((("Automag7x"."dbo"."Automag GmbH$Service Header" T1 left outer join "Automag7x"."dbo"."Automag GmbH$Employee" T2 on T2."No_" = T1."Service Advisor No_") left outer join "Automag7x"."dbo"."Automag GmbH$Service Ledger Entry" T3 on T1."No_" = T3."Order No_") left outer join "Automag7x"."dbo"."Automag GmbH$Employee" T4 on T4."No_" = T3."No_") left outer join QSS."C:\GlobalCube\System\ARIntelligence\IQD\Service\Monteure_fuer_Anzeige_offene_Auftraege.ims" T5 on T5."Order No_" = T1."No_") left outer join "Automag7x"."dbo"."Automag GmbH$Customer" T6 on T1."Sell-to Customer No_" = T6."No_")
  298. where ((T1."No_" LIKE 'WA%') and (T1."Document Type" = 1))
  299. ) D1
  300. order by c2 asc
  301. END SQL
  302. COLUMN,0,Document Type
  303. COLUMN,1,No
  304. COLUMN,2,Sell-to Customer No
  305. COLUMN,3,Bill-to Customer No
  306. COLUMN,4,Bill-to Name
  307. COLUMN,5,Order Date
  308. COLUMN,6,Posting Date
  309. COLUMN,7,Posting Description
  310. COLUMN,8,Due Date
  311. COLUMN,9,Location Code
  312. COLUMN,10,Department Code
  313. COLUMN,11,Make Code
  314. COLUMN,12,Salesperson Code
  315. COLUMN,13,On Hold
  316. COLUMN,14,Transaction Type
  317. COLUMN,15,Transport Method
  318. COLUMN,16,Correction
  319. COLUMN,17,Document Date
  320. COLUMN,18,Area
  321. COLUMN,19,Reserve
  322. COLUMN,20,Option Code
  323. COLUMN,21,Service Posting Group
  324. COLUMN,22,Vin
  325. COLUMN,23,Model Code
  326. COLUMN,24,Model No
  327. COLUMN,25,Model
  328. COLUMN,26,Type
  329. COLUMN,27,Initial Registration
  330. COLUMN,28,Order Limit
  331. COLUMN,29,Time Of Order
  332. COLUMN,30,Pickup Date
  333. COLUMN,31,Pickup Time
  334. COLUMN,32,Completion Date
  335. COLUMN,33,Completion Time
  336. COLUMN,34,Labor Type
  337. COLUMN,35,Labor Charging Code
  338. COLUMN,36,Book No
  339. COLUMN,37,Branch Book No
  340. COLUMN,38,Sales Department Code
  341. COLUMN,39,Fixed Date
  342. COLUMN,40,Fixed Instruction
  343. COLUMN,41,Current Instruction Type
  344. COLUMN,42,Work Completed
  345. COLUMN,43,Status Code
  346. COLUMN,44,Service Advisor No
  347. COLUMN,45,Hauptbetrieb
  348. COLUMN,46,Standort_Department
  349. COLUMN,47,Standort
  350. COLUMN,48,No_Employee
  351. COLUMN,49,First Name_Employee
  352. COLUMN,50,Last Name_Employee
  353. COLUMN,51,Serviceberater
  354. COLUMN,52,Umsatzart
  355. COLUMN,53,Kunde
  356. COLUMN,54,Order Number_mit Monteur
  357. COLUMN,55,Entry No
  358. COLUMN,56,Order No
  359. COLUMN,57,Posting Date
  360. COLUMN,58,Document No
  361. COLUMN,59,Type
  362. COLUMN,60,No
  363. COLUMN,61,Description
  364. COLUMN,62,Quantity
  365. COLUMN,63,Direct Unit Cost
  366. COLUMN,64,Unit Cost
  367. COLUMN,65,Total Cost
  368. COLUMN,66,Unit Price
  369. COLUMN,67,Total Price
  370. COLUMN,68,Department Code
  371. COLUMN,69,Work Type Code
  372. COLUMN,70,User Id
  373. COLUMN,71,Amt To Post To G L
  374. COLUMN,72,Amt Posted To G L
  375. COLUMN,73,Amt To Recognize
  376. COLUMN,74,Amt Recognized
  377. COLUMN,75,Entry Type
  378. COLUMN,76,Positive
  379. COLUMN,77,Qty Evaluated
  380. COLUMN,78,Corrected
  381. COLUMN,79,Variant Code
  382. COLUMN,80,Qty Per Unit Of Measure
  383. COLUMN,81,Quantity (base)
  384. COLUMN,82,Time Type
  385. COLUMN,83,Service Job No
  386. COLUMN,84,Assoc Entry
  387. COLUMN,85,Closed
  388. COLUMN,86,Qty Per Hour
  389. COLUMN,87,Qty (hour)
  390. COLUMN,88,Item Group Code
  391. COLUMN,89,Document Type
  392. COLUMN,90,Customer Group Code
  393. COLUMN,91,Charging Group No
  394. COLUMN,92,Standard Time
  395. COLUMN,93,Standard Time Type
  396. COLUMN,94,Source Type
  397. COLUMN,95,Main Customer
  398. COLUMN,96,Order Line No
  399. COLUMN,97,Time From
  400. COLUMN,98,Time Until
  401. COLUMN,99,Internal Charged
  402. COLUMN,100,Order Completed
  403. COLUMN,101,Open
  404. COLUMN,102,Closed By Entry No
  405. COLUMN,103,Closed At Date
  406. COLUMN,104,Closed By Quantity
  407. COLUMN,105,Open Quantity
  408. COLUMN,106,Labor Standard Time Type
  409. COLUMN,107,Menge
  410. COLUMN,108,Einstandsbetrag
  411. COLUMN,109,Verkaufsbetrag
  412. COLUMN,110,Umsatz Lohn
  413. COLUMN,111,Umsatz Teile Service
  414. COLUMN,112,Umsatz Sonstiges
  415. COLUMN,113,Einsatz Teile Service
  416. COLUMN,114,Einsatz Sonstiges
  417. COLUMN,115,Menge pro Stunde
  418. COLUMN,116,verk.Stunden
  419. COLUMN,117,verk. AW
  420. COLUMN,118,benutzte Zeit
  421. COLUMN,119,benutzte AW
  422. COLUMN,120,Name_Employee
  423. COLUMN,121,Function Code
  424. COLUMN,122,Monteur
  425. COLUMN,123,Funktion Monteur
  426. COLUMN,124,ben. AW ohne AZUBI
  427. COLUMN,125,Auftragsdatum
  428. COLUMN,126,DG_1
  429. COLUMN,127,DG_2
  430. COLUMN,128,Durchgänge
  431. COLUMN,129,Anzahl_Tage
  432. COLUMN,130,Tage offen
  433. COLUMN,131,gebuchte Teile
  434. COLUMN,132,Monteur_Anzeige
  435. COLUMN,133,Serviceberater_Monteur
  436. COLUMN,134,Order Number
  437. COLUMN,135,Invoice Date
  438. COLUMN,136,Minimum Letzte Stempelung
  439. COLUMN,137,Tage letzte Stemp. bereinigt
  440. COLUMN,138,Anz. Tage letzte Stemp.
  441. COLUMN,139,Order Number_intern
  442. COLUMN,140,Anzahl Tage über Abholtermin
  443. COLUMN,141,Intern/Extern
  444. COLUMN,142,Tage über Abholtermin
  445. COLUMN,143,Kundenname_verkauft_an
  446. COLUMN,144,Bill-to Contact
  447. COLUMN,145,Sell-to Customer Name
  448. COLUMN,146,Order Number_intern_neu
  449. COLUMN,147,Order Number
  450. COLUMN,148,Anzahl Tage_ori
  451. COLUMN,149,Durchgänge (Auftrag)
  452. COLUMN,150,Anzahl Tage
  453. COLUMN,151,Order Date
  454. COLUMN,152,Kostenstelle
  455. COLUMN,153,Fahrzeug
  456. COLUMN,154,Teile
  457. COLUMN,155,Arbeitswerte