S_Offene_Auftraege_queries.sql 6.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182
  1. CREATE
  2. OR
  3. ALTER VIEW [load].[current_date_Prognose~1]
  4. AS
  5. SELECT --[Bundeslaender Id] AS [Bundeslaender Id],
  6. [Datum] AS [Invoice Date],
  7. --[Wochentage Id] AS [Wochentage Id],
  8. [Arbeitstag Mofr] AS [Arbeitstag Mofr],
  9. --[Zaehler Mofr] AS [Zaehler Mofr],
  10. --[Summe Mofr] AS [Summe Mofr],
  11. --[Arbeitstag Mosa] AS [Arbeitstag Mosa],
  12. --[Zaehler Mosa] AS [Zaehler Mosa],
  13. --[Summe Mosa] AS [Summe Mosa],
  14. --[Feiertage Id] AS [Feiertage Id],
  15. --[Jahr] AS [Jahr],
  16. --[Arbeitstag Nr Jahr] AS [Arbeitstag Nr Jahr],
  17. --[Gesamt Arbeitstage] AS [Gesamt Arbeitstage]
  18. FROM [export_csv].[current_date_Prognose~1]
  19. GO
  20. CREATE
  21. OR
  22. ALTER VIEW [load].[Service_offene_Auftraege_neu_mitMont_Anzeige]
  23. AS
  24. SELECT --[Document Type] AS [Document Type],
  25. --[No] AS [No],
  26. --[Sell-to Customer No] AS [Sell-to Customer No],
  27. --[Bill-to Customer No] AS [Bill-to Customer No],
  28. --[Bill-to Name] AS [Bill-to Name],
  29. --[Order Date] AS [Order Date],
  30. --[Posting Date] AS [Posting Date],
  31. --[Posting Description] AS [Posting Description],
  32. --[Due Date] AS [Due Date],
  33. --[Location Code] AS [Location Code],
  34. --[Department Code] AS [Department Code],
  35. [Make Code] AS [Make Code],
  36. --[Salesperson Code] AS [Salesperson Code],
  37. --[On Hold] AS [On Hold],
  38. --[Transaction Type] AS [Transaction Type],
  39. --[Transport Method] AS [Transport Method],
  40. --[Correction] AS [Correction],
  41. --[Document Date] AS [Document Date],
  42. --[Area] AS [Area],
  43. --[Reserve] AS [Reserve],
  44. --[Option Code] AS [Option Code],
  45. --[Service Posting Group] AS [Service Posting Group],
  46. --[Vin] AS [Vin],
  47. --[Model Code] AS [Model Code],
  48. --[Model No] AS [Model No],
  49. [Model] AS [Model],
  50. --[Type] AS [Type],
  51. --[Initial Registration] AS [Initial Registration],
  52. --[Order Limit] AS [Order Limit],
  53. --[Time Of Order] AS [Time Of Order],
  54. --[Pickup Date] AS [Pickup Date],
  55. --[Pickup Time] AS [Pickup Time],
  56. --[Completion Date] AS [Completion Date],
  57. --[Completion Time] AS [Completion Time],
  58. --[Labor Type] AS [Labor Type],
  59. --[Labor Charging Code] AS [Labor Charging Code],
  60. --[Book No] AS [Book No],
  61. --[Branch Book No] AS [Branch Book No],
  62. --[Sales Department Code] AS [Sales Department Code],
  63. --[Fixed Date] AS [Fixed Date],
  64. --[Fixed Instruction] AS [Fixed Instruction],
  65. --[Current Instruction Type] AS [Current Instruction Type],
  66. --[Work Completed] AS [Work Completed],
  67. --[Status Code] AS [Status Code],
  68. --[Service Advisor No] AS [Service Advisor No],
  69. [Hauptbetrieb] AS [Hauptbetrieb],
  70. --[Standort_Department] AS [Standort_Department],
  71. [Standort] AS [Standort],
  72. --[No_Employee] AS [No_Employee],
  73. --[First Name_Employee] AS [First Name_Employee],
  74. --[Last Name_Employee] AS [Last Name_Employee],
  75. [Serviceberater] AS [Serviceberater],
  76. --[Umsatzart] AS [Umsatzart],
  77. [Kunde] AS [Kunde],
  78. --[Order Number_mit Monteur] AS [Order Number_mit Monteur],
  79. --[Entry No] AS [Entry No],
  80. --[Order No] AS [Order No],
  81. --[Document No] AS [Document No],
  82. --[Description] AS [Description],
  83. --[Quantity] AS [Quantity],
  84. --[Direct Unit Cost] AS [Direct Unit Cost],
  85. --[Unit Cost] AS [Unit Cost],
  86. --[Total Cost] AS [Total Cost],
  87. --[Unit Price] AS [Unit Price],
  88. --[Total Price] AS [Total Price],
  89. --[Work Type Code] AS [Work Type Code],
  90. --[User Id] AS [User Id],
  91. --[Amt To Post To G L] AS [Amt To Post To G L],
  92. --[Amt Posted To G L] AS [Amt Posted To G L],
  93. --[Amt To Recognize] AS [Amt To Recognize],
  94. --[Amt Recognized] AS [Amt Recognized],
  95. --[Entry Type] AS [Entry Type],
  96. --[Positive] AS [Positive],
  97. --[Qty Evaluated] AS [Qty Evaluated],
  98. --[Corrected] AS [Corrected],
  99. --[Variant Code] AS [Variant Code],
  100. --[Qty Per Unit Of Measure] AS [Qty Per Unit Of Measure],
  101. --[Quantity (base)] AS [Quantity (base)],
  102. --[Time Type] AS [Time Type],
  103. --[Service Job No] AS [Service Job No],
  104. --[Assoc Entry] AS [Assoc Entry],
  105. --[Closed] AS [Closed],
  106. --[Qty Per Hour] AS [Qty Per Hour],
  107. --[Qty (hour)] AS [Qty (hour)],
  108. --[Item Group Code] AS [Item Group Code],
  109. --[Customer Group Code] AS [Customer Group Code],
  110. --[Charging Group No] AS [Charging Group No],
  111. --[Standard Time] AS [Standard Time],
  112. --[Standard Time Type] AS [Standard Time Type],
  113. --[Source Type] AS [Source Type],
  114. --[Main Customer] AS [Main Customer],
  115. --[Order Line No] AS [Order Line No],
  116. --[Time From] AS [Time From],
  117. --[Time Until] AS [Time Until],
  118. --[Internal Charged] AS [Internal Charged],
  119. --[Order Completed] AS [Order Completed],
  120. --[Open] AS [Open],
  121. --[Closed By Entry No] AS [Closed By Entry No],
  122. --[Closed At Date] AS [Closed At Date],
  123. --[Closed By Quantity] AS [Closed By Quantity],
  124. --[Open Quantity] AS [Open Quantity],
  125. --[Labor Standard Time Type] AS [Labor Standard Time Type],
  126. --[Menge] AS [Menge],
  127. --[Einstandsbetrag] AS [Einstandsbetrag],
  128. --[Verkaufsbetrag] AS [Verkaufsbetrag],
  129. --[Umsatz Lohn] AS [Umsatz Lohn],
  130. --[Umsatz Teile Service] AS [Umsatz Teile Service],
  131. --[Umsatz Sonstiges] AS [Umsatz Sonstiges],
  132. --[Einsatz Teile Service] AS [Einsatz Teile Service],
  133. --[Einsatz Sonstiges] AS [Einsatz Sonstiges],
  134. --[Menge pro Stunde] AS [Menge pro Stunde],
  135. --[verk.Stunden] AS [verk.Stunden],
  136. --[verk. AW] AS [verk. AW],
  137. --[benutzte Zeit] AS [benutzte Zeit],
  138. [benutzte AW] AS [benutzte AW],
  139. --[Name_Employee] AS [Name_Employee],
  140. --[Function Code] AS [Function Code],
  141. --[Monteur] AS [Monteur],
  142. --[Funktion Monteur] AS [Funktion Monteur],
  143. --[ben. AW ohne AZUBI] AS [ben. AW ohne AZUBI],
  144. --[Auftragsdatum] AS [Auftragsdatum],
  145. --[DG_1] AS [DG_1],
  146. --[DG_2] AS [DG_2],
  147. [Durchgänge] AS [Durchgänge],
  148. --[Anzahl_Tage] AS [Anzahl_Tage],
  149. [Tage offen] AS [Tage offen],
  150. [gebuchte Teile] AS [gebuchte Teile],
  151. --[Monteur_Anzeige] AS [Monteur_Anzeige],
  152. --[Serviceberater_Monteur] AS [Serviceberater_Monteur],
  153. [Order Number] AS [Order Number],
  154. [Invoice Date] AS [Invoice Date],
  155. --[Minimum Letzte Stempelung] AS [Minimum Letzte Stempelung],
  156. --[Tage letzte Stemp. bereinigt] AS [Tage letzte Stemp. bereinigt],
  157. [Anz. Tage letzte Stemp.] AS [Anz. Tage letzte Stemp.],
  158. --[Order Number_intern] AS [Order Number_intern],
  159. --[Anzahl Tage über Abholtermin] AS [Anzahl Tage über Abholtermin],
  160. [Intern/Extern] AS [Intern/Extern],
  161. [Tage über Abholtermin] AS [Tage über Abholtermin],
  162. --[Kundenname_verkauft_an] AS [Kundenname_verkauft_an],
  163. --[Bill-to Contact] AS [Bill-to Contact],
  164. --[Sell-to Customer Name] AS [Sell-to Customer Name],
  165. [Order Number_intern_neu] AS [Order Number_intern_neu],
  166. --[Anzahl Tage_ori] AS [Anzahl Tage_ori],
  167. --[Durchgänge (Auftrag)] AS [Durchgänge (Auftrag)],
  168. --[Anzahl Tage] AS [Anzahl Tage],
  169. [Kostenstelle] AS [Kostenstelle],
  170. [Fahrzeug] AS [Fahrzeug],
  171. [Teile] AS [Teile],
  172. --[Arbeitswerte] AS [Arbeitswerte],
  173. --[Gen Prod Posting Group] AS [Gen Prod Posting Group],
  174. [Fremdl.] AS [Fremdl.],
  175. --[Summe Amount_Order_Line_VK] AS [Summe Amount_Order_Line_VK],
  176. [Umsatz Auftrag] AS [Umsatz Auftrag]
  177. FROM [export_csv].[Service_offene_Auftraege_neu_mitMont_Anzeige]
  178. GO