C11/Tasks/sql_load/exec/CARLO_imr_csv.sql

USE [CARLO]
GO
/****** Object:  Table [imr_csv].[Auftraege_EDS]    Script Date: 24.04.2019 11:47:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[Auftraege_EDS](
	[A_Belegart] [varchar](100) NULL,
	[A_Nr] [varchar](100) NULL,
	[A_Verk An Deb -nr] [varchar](100) NULL,
	[A_Rech An Deb -nr] [varchar](100) NULL,
	[A_Auftragsdatum] [datetime] NULL,
	[A_Buchungsdatum] [datetime] NULL,
	[A_Filialcode] [varchar](100) NULL,
	[B_Belegart] [varchar](100) NULL,
	[B_Nr] [varchar](100) NULL,
	[B_Verk An Deb -nr] [varchar](100) NULL,
	[B_Rech An Deb -nr] [varchar](100) NULL,
	[B_Auftragsdatum] [datetime] NULL,
	[B_Buchungsdatum] [datetime] NULL,
	[B_Interne Belegnr] [varchar](100) NULL,
	[A_Interner Auftrag] [varchar](100) NULL,
	[A_Interne Belegnr] [varchar](100) NULL,
	[B_Filialcode] [varchar](100) NULL,
	[Belegart] [varchar](100) NULL,
	[Nr] [varchar](100) NULL,
	[Verk An Deb -nr] [varchar](100) NULL,
	[Auftragsdatum] [datetime] NULL,
	[Buchungsdatum] [datetime] NULL,
	[Filialcode] [varchar](100) NULL,
	[Belegnr] [varchar](100) NULL,
	[Art] [varchar](100) NULL,
	[APO_TEILE_Nr] [varchar](100) NULL,
	[Beschreibung] [varchar](100) NULL,
	[Menge_ori] [decimal](28, 8) NULL,
	[Ek-preis] [decimal](28, 8) NULL,
	[Einstandspreis] [decimal](28, 8) NULL,
	[Einstandsbetrag_ori] [decimal](28, 8) NULL,
	[Vk-preis] [decimal](28, 8) NULL,
	[Verkaufsbetrag_ori] [decimal](28, 8) NULL,
	[Fakturierbar] [varchar](100) NULL,
	[Werkstattbuchungsgruppe] [varchar](100) NULL,
	[Kostenstellencode] [varchar](100) NULL,
	[Markencode] [varchar](100) NULL,
	[Arbeitstypencode] [varchar](100) NULL,
	[Benutzer Id] [varchar](100) NULL,
	[Herkunftscode] [varchar](100) NULL,
	[Postenart] [varchar](100) NULL,
	[Positiv] [varchar](100) NULL,
	[Geschäftsbuchungsgruppe] [varchar](100) NULL,
	[Produktbuchungsgruppe] [varchar](100) NULL,
	[Belegdatum] [datetime] NULL,
	[Nummernserie] [varchar](100) NULL,
	[Storniert] [varchar](100) NULL,
	[Buchnr] [varchar](100) NULL,
	[Zeitart] [varchar](100) NULL,
	[Fahrzeugtyp] [varchar](100) NULL,
	[Paketnr] [varchar](100) NULL,
	[Kostenstellencode Verkauf] [varchar](100) NULL,
	[Verrechnungspreis] [decimal](28, 8) NULL,
	[Verrechnungsbetrag_ori] [decimal](28, 8) NULL,
	[Verrechnungsbetrag (bw)] [varchar](100) NULL,
	[Abgeschlossen] [varchar](100) NULL,
	[Fahrgestellnummer] [varchar](100) NULL,
	[Menge Pro Stunde] [varchar](100) NULL,
	[Menge (stunde)] [decimal](28, 8) NULL,
	[Artikelgruppencode] [varchar](100) NULL,
	[Belegtyp] [varchar](100) NULL,
	[Fahrzeugartencode] [varchar](100) NULL,
	[Fahrzeugstatus] [varchar](100) NULL,
	[Marktsegmentcode] [varchar](100) NULL,
	[Hauptgruppencode] [varchar](100) NULL,
	[Untergruppencode] [varchar](100) NULL,
	[Positionsgruppencode] [varchar](100) NULL,
	[Kundengruppencode] [varchar](100) NULL,
	[Ist-menge (stunde)] [varchar](100) NULL,
	[Vorgabezeit] [decimal](28, 8) NULL,
	[Vorgabezeitart] [varchar](100) NULL,
	[Herkunftsart] [varchar](100) NULL,
	[Herkunftsnr] [varchar](100) NULL,
	[Auftragszeilennr] [varchar](100) NULL,
	[Interne Verrechnung Erfolgt] [varchar](100) NULL,
	[Verrechnungspreis Fix] [varchar](100) NULL,
	[Auftrag Erledigt] [varchar](100) NULL,
	[Buchungsdatum (letzte Rechn )] [datetime] NULL,
	[Offen] [varchar](100) NULL,
	[Betrag Int Zu Verrechnen] [decimal](28, 8) NULL,
	[Betrag Int Zu Verrechnen (bw)] [decimal](28, 8) NULL,
	[Betrag Int Verrechnet] [decimal](28, 8) NULL,
	[Betrag Int Verrechnet (bw)] [decimal](28, 8) NULL,
	[Serviceberaternr] [varchar](100) NULL,
	[Mitarbeiternr] [varchar](100) NULL,
	[Tätigkeitsartcode] [varchar](100) NULL,
	[Monteur Nr 1] [varchar](100) NULL,
	[Aw Mont 1] [decimal](28, 8) NULL,
	[Monteur Nr 2] [varchar](100) NULL,
	[Aw Mont 2] [varchar](100) NULL,
	[Hauptbetrieb] [varchar](100) NULL,
	[Standort] [varchar](100) NULL,
	[FIL-Code] [varchar](100) NULL,
	[FIL-Bezeichnung] [varchar](100) NULL,
	[Standort_1_ori] [varchar](100) NULL,
	[Vorname] [varchar](100) NULL,
	[Nachname] [varchar](100) NULL,
	[Serviceberater] [varchar](100) NULL,
	[Menge] [decimal](28, 8) NULL,
	[Einstandsbetrag] [decimal](28, 8) NULL,
	[Verkaufsbetrag] [decimal](28, 8) NULL,
	[Rech An Deb -nr] [varchar](100) NULL,
	[Umsatzart_ori] [varchar](100) NULL,
	[KD_Nr] [varchar](100) NULL,
	[KD_Name] [varchar](100) NULL,
	[Kunde] [varchar](100) NULL,
	[Invoice Date] [datetime] NULL,
	[Order Number] [varchar](100) NULL,
	[Fabrikat] [varchar](100) NULL,
	[Modell] [varchar](100) NULL,
	[Model] [varchar](100) NULL,
	[Fahrzeug] [varchar](100) NULL,
	[KST_aus_Code] [varchar](100) NULL,
	[Kostenstelle] [varchar](100) NULL,
	[Auftragsart] [varchar](100) NULL,
	[Lines Net Value] [decimal](28, 8) NULL,
	[Umsatz Lohn] [decimal](28, 8) NULL,
	[Umsatz Teile Service] [decimal](28, 8) NULL,
	[Umsatz Sonstiges] [decimal](28, 8) NULL,
	[Einsatz Teile Service_ori] [decimal](28, 8) NULL,
	[Einsatz Teile Service] [decimal](28, 8) NULL,
	[Einsatz Sonstiges] [decimal](28, 8) NULL,
	[Menge_pro_Stunde] [decimal](28, 8) NULL,
	[Menge_stunde] [decimal](28, 8) NULL,
	[Sollzeit] [decimal](28, 8) NULL,
	[Sollzeit_Art] [decimal](28, 8) NULL,
	[AW_Mont_1] [decimal](28, 8) NULL,
	[AW_Mont_2] [decimal](28, 8) NULL,
	[verk  Stunden] [decimal](28, 8) NULL,
	[Soll-Stunden] [decimal](28, 8) NULL,
	[benutzte Zeit_ori] [decimal](28, 8) NULL,
	[Auftragsnr] [varchar](100) NULL,
	[A_Belegnr] [varchar](100) NULL,
	[A_Zeilennr] [varchar](100) NULL,
	[Archivierungsdatum] [datetime] NULL,
	[Arch Durch Benutzer Id] [varchar](100) NULL,
	[Archivierungsgrund] [varchar](100) NULL,
	[Umsatzart] [varchar](100) NULL,
	[Marke] [varchar](100) NULL,
	[Kundenart] [varchar](100) NULL,
	[DG_1] [varchar](100) NULL,
	[Herkunftsnr (zahlung)] [varchar](100) NULL,
	[Hauptdebitor] [varchar](100) NULL,
	[DB Teile] [decimal](28, 8) NULL,
	[Verr_Betrag] [decimal](28, 8) NULL,
	[Nr2] [varchar](100) NULL,
	[Beschreibung2] [varchar](100) NULL,
	[Basiseinheitencode] [varchar](100) NULL,
	[Vk-preis2] [decimal](28, 8) NULL,
	[Einstandspreis_ART] [decimal](28, 8) NULL,
	[Ek-preis (neuester)_ART] [decimal](28, 8) NULL,
	[Einstandspreis (durchschn )_ART] [decimal](28, 8) NULL,
	[EK_preis_neu_Art] [decimal](28, 8) NULL,
	[Einstandspreis_Durch_Art] [decimal](28, 8) NULL,
	[Heute] [datetime] NULL,
	[Tag] [varchar](100) NULL,
	[Buchungsdatum_Datum] [datetime] NULL,
	[Rechnungsausgang] [varchar](100) NULL,
	[Order_Number_RG_Ausg] [varchar](100) NULL,
	[DG_1_2] [varchar](100) NULL,
	[DG_2] [varchar](100) NULL,
	[Durchgänge] [decimal](28, 8) NULL,
	[Standort_1] [varchar](100) NULL,
	[Tage bis Rechnung_ori] [varchar](100) NULL,
	[Tage bis Rechnung] [decimal](28, 8) NULL,
	[Rech An Deb -nr2] [varchar](100) NULL,
	[Rech An Name] [varchar](100) NULL,
	[Rechnunsgkunde] [varchar](100) NULL,
	[Erstzulassung] [datetime] NULL,
	[Fahrzeugalter_Tage] [varchar](100) NULL,
	[Fahrzeugalter_Jahr] [decimal](28, 8) NULL,
	[FZG-Altersstaffel] [varchar](100) NULL,
	[Serviceberater_KZ_Employee] [varchar](100) NULL,
	[TÜV] [decimal](28, 8) NULL,
	[Fremdl ] [decimal](28, 8) NULL,
	[Mietw ] [decimal](28, 8) NULL,
	[Rädereinl ] [decimal](28, 8) NULL,
	[Einstandspreis_Art2] [decimal](28, 8) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[Auftraege_EDS_benutzte_Zeit]    Script Date: 24.04.2019 11:47:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[Auftraege_EDS_benutzte_Zeit](
	[A_Belegart] [varchar](100) NULL,
	[A_Nr] [varchar](100) NULL,
	[A_Verk An Deb -nr] [varchar](100) NULL,
	[A_Rech An Deb -nr] [varchar](100) NULL,
	[A_Auftragsdatum] [datetime] NULL,
	[A_Buchungsdatum] [datetime] NULL,
	[A_Filialcode] [varchar](100) NULL,
	[B_Belegart] [varchar](100) NULL,
	[B_Nr] [varchar](100) NULL,
	[B_Verk An Deb -nr] [varchar](100) NULL,
	[B_Rech An Deb -nr] [varchar](100) NULL,
	[B_Auftragsdatum] [datetime] NULL,
	[B_Buchungsdatum] [datetime] NULL,
	[B_Interne Belegnr] [varchar](100) NULL,
	[A_Interner Auftrag] [varchar](100) NULL,
	[A_Interne Belegnr] [varchar](100) NULL,
	[B_Filialcode] [varchar](100) NULL,
	[Belegart] [varchar](100) NULL,
	[Nr] [varchar](100) NULL,
	[Verk An Deb -nr] [varchar](100) NULL,
	[Auftragsdatum] [datetime] NULL,
	[Buchungsdatum] [datetime] NULL,
	[Filialcode] [varchar](100) NULL,
	[Hauptbetrieb] [varchar](100) NULL,
	[Standort] [varchar](100) NULL,
	[FIL-Code] [varchar](100) NULL,
	[FIL-Bezeichnung] [varchar](100) NULL,
	[Standort_1_ori] [varchar](100) NULL,
	[Serviceberaternr] [varchar](100) NULL,
	[Vorname] [varchar](100) NULL,
	[Nachname] [varchar](100) NULL,
	[Serviceberater] [varchar](100) NULL,
	[Kunde] [varchar](100) NULL,
	[Invoice Date] [datetime] NULL,
	[Order Number] [varchar](100) NULL,
	[Fabrikat] [varchar](100) NULL,
	[Modell] [varchar](100) NULL,
	[Model] [varchar](100) NULL,
	[Fahrzeug] [varchar](100) NULL,
	[KST_aus_Code] [varchar](100) NULL,
	[Kostenstelle] [varchar](100) NULL,
	[Auftragsart] [varchar](100) NULL,
	[benutzte Zeit] [decimal](28, 8) NULL,
	[Auftragsnr] [varchar](100) NULL,
	[A_Belegnr] [varchar](100) NULL,
	[Umsatzart] [varchar](100) NULL,
	[Marke] [varchar](100) NULL,
	[Kundenart] [varchar](100) NULL,
	[DG_1] [varchar](100) NULL,
	[Buchungsdatum_Datum] [datetime] NULL,
	[Rechnungsausgang] [varchar](100) NULL,
	[Order_Number_RG_Ausg] [varchar](100) NULL,
	[DG_1_2] [varchar](100) NULL,
	[DG_2] [varchar](100) NULL,
	[Employee No] [varchar](100) NULL,
	[Current Date] [datetime] NULL,
	[Order No] [varchar](100) NULL,
	[Time Account No] [varchar](100) NULL,
	[Time Account Value] [decimal](28, 8) NULL,
	[Standort_1] [varchar](100) NULL,
	[Markencode] [varchar](100) NULL,
	[Funktion] [varchar](100) NULL,
	[Servicberater   sonst  MA] [varchar](100) NULL,
	[Geschäftsbuchungsgruppe] [varchar](100) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[Auftraege_EDS_FIBU]    Script Date: 24.04.2019 11:47:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[Auftraege_EDS_FIBU](
	[A_Belegart] [varchar](100) NULL,
	[A_Nr] [varchar](100) NULL,
	[A_Verk An Deb -nr] [varchar](100) NULL,
	[A_Rech An Deb -nr] [varchar](100) NULL,
	[A_Auftragsdatum] [datetime] NULL,
	[A_Buchungsdatum] [datetime] NULL,
	[A_Filialcode] [varchar](100) NULL,
	[B_Belegart] [varchar](100) NULL,
	[B_Nr] [varchar](100) NULL,
	[B_Verk An Deb -nr] [varchar](100) NULL,
	[B_Rech An Deb -nr] [varchar](100) NULL,
	[B_Auftragsdatum] [datetime] NULL,
	[B_Buchungsdatum] [datetime] NULL,
	[B_Interne Belegnr] [varchar](100) NULL,
	[A_Interner Auftrag] [varchar](100) NULL,
	[A_Interne Belegnr] [varchar](100) NULL,
	[B_Filialcode] [varchar](100) NULL,
	[Belegart] [varchar](100) NULL,
	[Nr] [varchar](100) NULL,
	[Verk An Deb -nr] [varchar](100) NULL,
	[Auftragsdatum] [datetime] NULL,
	[Buchungsdatum] [datetime] NULL,
	[Filialcode] [varchar](100) NULL,
	[Belegnr] [varchar](100) NULL,
	[Art] [varchar](100) NULL,
	[APO_TEILE_Nr] [varchar](100) NULL,
	[Beschreibung] [varchar](100) NULL,
	[Menge_ori] [decimal](28, 8) NULL,
	[Ek-preis] [decimal](28, 8) NULL,
	[Einstandspreis] [decimal](28, 8) NULL,
	[Einstandsbetrag_ori] [decimal](28, 8) NULL,
	[Vk-preis] [decimal](28, 8) NULL,
	[Verkaufsbetrag_ori] [decimal](28, 8) NULL,
	[Fakturierbar] [varchar](100) NULL,
	[Werkstattbuchungsgruppe] [varchar](100) NULL,
	[Kostenstellencode] [varchar](100) NULL,
	[Markencode] [varchar](100) NULL,
	[Arbeitstypencode] [varchar](100) NULL,
	[Benutzer Id] [varchar](100) NULL,
	[Herkunftscode] [varchar](100) NULL,
	[Postenart] [varchar](100) NULL,
	[Positiv] [varchar](100) NULL,
	[Geschäftsbuchungsgruppe] [varchar](100) NULL,
	[Produktbuchungsgruppe] [varchar](100) NULL,
	[Belegdatum] [datetime] NULL,
	[Nummernserie] [varchar](100) NULL,
	[Storniert] [varchar](100) NULL,
	[Buchnr] [varchar](100) NULL,
	[Zeitart] [varchar](100) NULL,
	[Fahrzeugtyp] [varchar](100) NULL,
	[Paketnr] [varchar](100) NULL,
	[Kostenstellencode Verkauf] [varchar](100) NULL,
	[Verrechnungspreis] [decimal](28, 8) NULL,
	[Verrechnungsbetrag_ori] [decimal](28, 8) NULL,
	[Verrechnungsbetrag (bw)] [decimal](28, 8) NULL,
	[Abgeschlossen] [varchar](100) NULL,
	[Fahrgestellnummer] [varchar](100) NULL,
	[Menge Pro Stunde] [varchar](100) NULL,
	[Menge (stunde)] [decimal](28, 8) NULL,
	[Artikelgruppencode] [varchar](100) NULL,
	[Belegtyp] [varchar](100) NULL,
	[Fahrzeugartencode] [varchar](100) NULL,
	[Fahrzeugstatus] [varchar](100) NULL,
	[Marktsegmentcode] [varchar](100) NULL,
	[Hauptgruppencode] [varchar](100) NULL,
	[Untergruppencode] [varchar](100) NULL,
	[Positionsgruppencode] [varchar](100) NULL,
	[Kundengruppencode] [varchar](100) NULL,
	[Ist-menge (stunde)] [varchar](100) NULL,
	[Vorgabezeit] [decimal](28, 8) NULL,
	[Vorgabezeitart] [varchar](100) NULL,
	[Herkunftsart] [varchar](100) NULL,
	[Herkunftsnr] [varchar](100) NULL,
	[Auftragszeilennr] [varchar](100) NULL,
	[Interne Verrechnung Erfolgt] [varchar](100) NULL,
	[Verrechnungspreis Fix] [varchar](100) NULL,
	[Auftrag Erledigt] [varchar](100) NULL,
	[Buchungsdatum (letzte Rechn )] [datetime] NULL,
	[Offen] [varchar](100) NULL,
	[Betrag Int Zu Verrechnen] [decimal](28, 8) NULL,
	[Betrag Int Zu Verrechnen (bw)] [decimal](28, 8) NULL,
	[Betrag Int Verrechnet] [decimal](28, 8) NULL,
	[Betrag Int Verrechnet (bw)] [decimal](28, 8) NULL,
	[Serviceberaternr] [varchar](100) NULL,
	[Mitarbeiternr] [varchar](100) NULL,
	[Tätigkeitsartcode] [varchar](100) NULL,
	[Monteur Nr 1] [varchar](100) NULL,
	[Aw Mont 1] [decimal](28, 8) NULL,
	[Monteur Nr 2] [varchar](100) NULL,
	[Aw Mont 2] [varchar](100) NULL,
	[Hauptbetrieb] [varchar](100) NULL,
	[Standort] [varchar](100) NULL,
	[FIL-Code] [varchar](100) NULL,
	[FIL-Bezeichnung] [varchar](100) NULL,
	[Standort_1] [varchar](100) NULL,
	[Vorname] [varchar](100) NULL,
	[Nachname] [varchar](100) NULL,
	[Serviceberater] [varchar](100) NULL,
	[Menge] [decimal](28, 8) NULL,
	[Einstandsbetrag] [decimal](28, 8) NULL,
	[Verkaufsbetrag] [decimal](28, 8) NULL,
	[Rech An Deb -nr] [varchar](100) NULL,
	[Umsatzart_ori] [varchar](100) NULL,
	[KD_Nr] [varchar](100) NULL,
	[KD_Name] [varchar](100) NULL,
	[Kunde] [varchar](100) NULL,
	[Invoice Date] [datetime] NULL,
	[Order Number] [varchar](100) NULL,
	[Fabrikat] [varchar](100) NULL,
	[Modell] [varchar](100) NULL,
	[Model] [varchar](100) NULL,
	[Fahrzeug] [varchar](100) NULL,
	[KST_aus_Code] [varchar](100) NULL,
	[Kostenstelle_alt] [varchar](100) NULL,
	[Auftragsart] [varchar](100) NULL,
	[Lines Net Value] [decimal](28, 8) NULL,
	[Umsatz Lohn] [decimal](28, 8) NULL,
	[Umsatz Teile Service] [decimal](28, 8) NULL,
	[Umsatz Sonstiges] [decimal](28, 8) NULL,
	[Einsatz Teile Service_ori] [decimal](28, 8) NULL,
	[Einsatz Teile Service] [decimal](28, 8) NULL,
	[Einsatz Sonstiges] [decimal](28, 8) NULL,
	[Menge_pro_Stunde] [varchar](100) NULL,
	[Menge_stunde] [decimal](28, 8) NULL,
	[Sollzeit] [decimal](28, 8) NULL,
	[Sollzeit_Art] [varchar](100) NULL,
	[AW_Mont_1] [decimal](28, 8) NULL,
	[AW_Mont_2] [decimal](28, 8) NULL,
	[verk  Stunden] [decimal](28, 8) NULL,
	[Soll-Stunden] [decimal](28, 8) NULL,
	[benutzte Zeit_ori] [decimal](28, 8) NULL,
	[Auftragsnr] [varchar](100) NULL,
	[A_Belegnr] [varchar](100) NULL,
	[A_Zeilennr] [varchar](100) NULL,
	[Archivierungsdatum] [datetime] NULL,
	[Arch Durch Benutzer Id] [varchar](100) NULL,
	[Archivierungsgrund] [varchar](100) NULL,
	[Umsatzart] [varchar](100) NULL,
	[Marke] [varchar](100) NULL,
	[Kundenart] [varchar](100) NULL,
	[DG_1] [varchar](100) NULL,
	[Herkunftsnr (zahlung)] [varchar](100) NULL,
	[Hauptdebitor] [varchar](100) NULL,
	[DB Teile] [varchar](100) NULL,
	[Verr_Betrag] [decimal](28, 8) NULL,
	[Nr2] [varchar](100) NULL,
	[Beschreibung2] [varchar](100) NULL,
	[Basiseinheitencode] [varchar](100) NULL,
	[Vk-preis2] [varchar](100) NULL,
	[Einstandspreis_ART] [varchar](100) NULL,
	[Ek-preis (neuester)_ART] [varchar](100) NULL,
	[Einstandspreis (durchschn )_ART] [varchar](100) NULL,
	[Einstandspreis_Art_2] [varchar](100) NULL,
	[EK_preis_neu_Art] [varchar](100) NULL,
	[Einstandspreis_Durch_Art] [varchar](100) NULL,
	[Heute] [datetime] NULL,
	[Tag] [varchar](100) NULL,
	[Buchungsdatum_Datum] [datetime] NULL,
	[Rechnungsausgang] [varchar](100) NULL,
	[Order_Number_RG_Ausg] [varchar](100) NULL,
	[DG_1_2] [varchar](100) NULL,
	[DG_2] [varchar](100) NULL,
	[Durchgänge] [decimal](28, 8) NULL,
	[Bookkeep Date] [datetime] NULL,
	[Rechtseinheit] [varchar](100) NULL,
	[Betrieb] [varchar](100) NULL,
	[Ebene1] [varchar](100) NULL,
	[Ebene2] [varchar](100) NULL,
	[Ebene3] [varchar](100) NULL,
	[Ebene4] [varchar](100) NULL,
	[Kostenstelle] [varchar](100) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[Auftraege_EDS_intern_C11]    Script Date: 24.04.2019 11:47:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[Auftraege_EDS_intern_C11](
	[A_Belegart] [varchar](100) NULL,
	[A_Nr] [varchar](100) NULL,
	[A_Verk An Deb -nr] [varchar](100) NULL,
	[A_Rech An Deb -nr] [varchar](100) NULL,
	[A_Auftragsdatum] [datetime] NULL,
	[A_Buchungsdatum] [datetime] NULL,
	[A_Filialcode] [varchar](100) NULL,
	[A_Interner Auftrag] [varchar](100) NULL,
	[A_Interne Belegnr] [varchar](100) NULL,
	[Belegart] [varchar](100) NULL,
	[Nr] [varchar](100) NULL,
	[Verk An Deb -nr] [varchar](100) NULL,
	[Auftragsdatum] [datetime] NULL,
	[Buchungsdatum] [datetime] NULL,
	[Filialcode] [varchar](100) NULL,
	[Belegnr] [varchar](100) NULL,
	[Art] [varchar](100) NULL,
	[APO_TEILE_Nr] [varchar](100) NULL,
	[Beschreibung] [varchar](100) NULL,
	[Menge_ori] [decimal](28, 8) NULL,
	[Ek-preis] [decimal](28, 8) NULL,
	[Einstandspreis] [decimal](28, 8) NULL,
	[Einstandsbetrag_ori] [decimal](28, 8) NULL,
	[Vk-preis] [decimal](28, 8) NULL,
	[Verkaufsbetrag_ori] [decimal](28, 8) NULL,
	[Werkstattbuchungsgruppe] [varchar](100) NULL,
	[Kostenstellencode] [varchar](100) NULL,
	[Markencode] [varchar](100) NULL,
	[Benutzer Id] [varchar](100) NULL,
	[Herkunftscode] [varchar](100) NULL,
	[Geschäftsbuchungsgruppe] [varchar](100) NULL,
	[Produktbuchungsgruppe] [varchar](100) NULL,
	[Belegdatum] [datetime] NULL,
	[Nummernserie] [varchar](100) NULL,
	[Fahrgestellnummer] [varchar](100) NULL,
	[Menge Pro Stunde] [varchar](100) NULL,
	[Menge (stunde)] [decimal](28, 8) NULL,
	[Artikelgruppencode] [varchar](100) NULL,
	[Fahrzeugartencode] [varchar](100) NULL,
	[Vorgabezeit] [decimal](28, 8) NULL,
	[Herkunftsnr] [varchar](100) NULL,
	[Auftragszeilennr] [varchar](100) NULL,
	[Serviceberaternr] [varchar](100) NULL,
	[Monteur Nr 1] [varchar](100) NULL,
	[Aw Mont 1] [decimal](28, 8) NULL,
	[Monteur Nr 2] [varchar](100) NULL,
	[Aw Mont 2] [varchar](100) NULL,
	[Hauptbetrieb] [varchar](100) NULL,
	[Standort] [varchar](100) NULL,
	[FIL-Code] [varchar](100) NULL,
	[FIL-Bezeichnung] [varchar](100) NULL,
	[Standort_1_ori] [varchar](100) NULL,
	[Vorname] [varchar](100) NULL,
	[Nachname] [varchar](100) NULL,
	[Serviceberater] [varchar](100) NULL,
	[Menge] [decimal](28, 8) NULL,
	[Einstandsbetrag] [decimal](28, 8) NULL,
	[Verkaufsbetrag] [decimal](28, 8) NULL,
	[Rech An Deb -nr] [varchar](100) NULL,
	[Umsatzart_ori] [varchar](100) NULL,
	[KD_Nr] [varchar](100) NULL,
	[KD_Name] [varchar](100) NULL,
	[Kunde] [varchar](100) NULL,
	[Invoice Date] [datetime] NULL,
	[Order Number] [varchar](100) NULL,
	[Fabrikat] [varchar](100) NULL,
	[Modell] [varchar](100) NULL,
	[Model] [varchar](100) NULL,
	[Fahrzeug] [varchar](100) NULL,
	[Kostenstelle] [varchar](100) NULL,
	[Auftragsart] [varchar](100) NULL,
	[Lines Net Value] [decimal](28, 8) NULL,
	[Umsatz Lohn] [decimal](28, 8) NULL,
	[Umsatz Teile Service] [decimal](28, 8) NULL,
	[Umsatz Sonstiges] [decimal](28, 8) NULL,
	[Einsatz Teile Service_ori] [decimal](28, 8) NULL,
	[Einsatz Teile Service] [decimal](28, 8) NULL,
	[Einsatz Sonstiges] [decimal](28, 8) NULL,
	[Menge_pro_Stunde] [decimal](28, 8) NULL,
	[Menge_stunde] [decimal](28, 8) NULL,
	[Sollzeit] [decimal](28, 8) NULL,
	[Sollzeit_Art] [decimal](28, 8) NULL,
	[AW_Mont_1] [decimal](28, 8) NULL,
	[AW_Mont_2] [varchar](100) NULL,
	[verk  Stunden] [decimal](28, 8) NULL,
	[Soll-Stunden] [decimal](28, 8) NULL,
	[benutzte Zeit_ori] [decimal](28, 8) NULL,
	[Auftragsnr] [varchar](100) NULL,
	[Archivierungsdatum] [datetime] NULL,
	[Umsatzart] [varchar](100) NULL,
	[Marke] [varchar](100) NULL,
	[Kundenart] [varchar](100) NULL,
	[DG_1] [varchar](100) NULL,
	[DB Teile] [decimal](28, 8) NULL,
	[Verr_Betrag] [decimal](28, 8) NULL,
	[Nr2] [varchar](100) NULL,
	[Beschreibung2] [varchar](100) NULL,
	[Basiseinheitencode] [varchar](100) NULL,
	[Vk-preis2] [decimal](28, 8) NULL,
	[Einstandspreis_ART] [decimal](28, 8) NULL,
	[Ek-preis (neuester)_ART] [decimal](28, 8) NULL,
	[Einstandspreis (durchschn )_ART] [decimal](28, 8) NULL,
	[EK_preis_neu_Art] [decimal](28, 8) NULL,
	[Einstandspreis_Durch_Art] [decimal](28, 8) NULL,
	[Heute] [datetime] NULL,
	[Tag] [varchar](100) NULL,
	[Buchungsdatum_Datum] [datetime] NULL,
	[Rechnungsausgang] [varchar](100) NULL,
	[Order_Number_RG_Ausg] [varchar](100) NULL,
	[DG_1_2] [varchar](100) NULL,
	[DG_2] [varchar](100) NULL,
	[Durchgänge] [decimal](28, 8) NULL,
	[Standort_1] [varchar](100) NULL,
	[Tage bis Rechnung_ori] [varchar](100) NULL,
	[Tage bis Rechnung] [decimal](28, 8) NULL,
	[Rech An Deb -nr2] [varchar](100) NULL,
	[Rech An Name] [varchar](100) NULL,
	[Rechnunsgkunde] [varchar](100) NULL,
	[Funktion] [varchar](100) NULL,
	[Servicberater   sonst  MA] [varchar](100) NULL,
	[Date] [datetime] NULL,
	[Company_ID] [varchar](100) NULL,
	[Department_ID] [varchar](100) NULL,
	[Employee_Function] [varchar](100) NULL,
	[Service_Advisor_Name] [varchar](100) NULL,
	[Turnover_Type_Desc] [varchar](100) NULL,
	[Order_Desc_100] [varchar](100) NULL,
	[Invoice_Desc_100] [varchar](100) NULL,
	[Order_Desc_30] [varchar](100) NULL,
	[Invoice_Desc_30] [varchar](100) NULL,
	[Cost_Centre_ID] [varchar](100) NULL,
	[Make_Desc] [varchar](100) NULL,
	[Make_Group] [varchar](100) NULL,
	[Model_Desc] [varchar](100) NULL,
	[Customer_Group_Owner] [varchar](100) NULL,
	[Customer_Name_Owner] [varchar](100) NULL,
	[Ländercode] [varchar](100) NULL,
	[Land] [varchar](100) NULL,
	[Cust_Zipcode_Country] [varchar](100) NULL,
	[Plz Code] [varchar](100) NULL,
	[Cust_Zipcode_First] [varchar](100) NULL,
	[Cust_Zipcode_Second] [varchar](100) NULL,
	[Cust_Zipcode_Third] [varchar](100) NULL,
	[Cust_Zipcode_Fourth] [varchar](100) NULL,
	[Cust_Zipcode] [varchar](100) NULL,
	[Erstzulassung] [varchar](100) NULL,
	[Fahrzeugalter_Tage] [varchar](100) NULL,
	[Fahrzeugalter] [decimal](28, 8) NULL,
	[FZG_Altersstaffel] [varchar](100) NULL,
	[Car_Age] [varchar](100) NULL,
	[Nr_Artikel] [varchar](100) NULL,
	[Gmpd Code_Artikel] [varchar](100) NULL,
	[Gmpd Subcode_Artikel] [varchar](100) NULL,
	[GMPD_Group] [varchar](100) NULL,
	[Parts_Number] [varchar](100) NULL,
	[Repair_Group_Desc] [varchar](100) NULL,
	[Invoice_Credit_Note] [varchar](100) NULL,
	[Sign_DB1] [varchar](100) NULL,
	[Order_Status] [varchar](100) NULL,
	[Order_Type_Desc] [varchar](100) NULL,
	[Job_Amount] [decimal](28, 8) NULL,
	[Parts_Amount] [decimal](28, 8) NULL,
	[Parts_Purch_Amount] [decimal](28, 8) NULL,
	[Misc_Amount] [decimal](28, 8) NULL,
	[Invoiced_Time] [decimal](28, 8) NULL,
	[Quantity] [decimal](28, 8) NULL,
	[Order_Count] [decimal](28, 8) NULL,
	[Einstandspreis_Art2] [decimal](28, 8) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[Auftraege_EDS_intern_C11_ben_Zeit]    Script Date: 24.04.2019 11:47:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[Auftraege_EDS_intern_C11_ben_Zeit](
	[A_Belegart] [varchar](100) NULL,
	[A_Nr] [varchar](100) NULL,
	[A_Verk An Deb -nr] [varchar](100) NULL,
	[A_Rech An Deb -nr] [varchar](100) NULL,
	[A_Auftragsdatum] [datetime] NULL,
	[A_Buchungsdatum] [datetime] NULL,
	[A_Filialcode] [varchar](100) NULL,
	[A_Interner Auftrag] [varchar](100) NULL,
	[A_Interne Belegnr] [varchar](100) NULL,
	[Belegart] [varchar](100) NULL,
	[Nr] [varchar](100) NULL,
	[Verk An Deb -nr] [varchar](100) NULL,
	[Auftragsdatum] [datetime] NULL,
	[Buchungsdatum] [datetime] NULL,
	[Filialcode] [varchar](100) NULL,
	[Markencode] [varchar](100) NULL,
	[Hauptbetrieb] [varchar](100) NULL,
	[Standort] [varchar](100) NULL,
	[FIL-Code] [varchar](100) NULL,
	[FIL-Bezeichnung] [varchar](100) NULL,
	[Standort_1_ori] [varchar](100) NULL,
	[Serviceberaternr] [varchar](100) NULL,
	[Vorname] [varchar](100) NULL,
	[Nachname] [varchar](100) NULL,
	[Serviceberater] [varchar](100) NULL,
	[Rech An Deb -nr] [varchar](100) NULL,
	[KD_Nr] [varchar](100) NULL,
	[KD_Name] [varchar](100) NULL,
	[Kunde] [varchar](100) NULL,
	[Invoice Date] [datetime] NULL,
	[Order Number] [varchar](100) NULL,
	[Fabrikat] [varchar](100) NULL,
	[Modell] [varchar](100) NULL,
	[Model] [varchar](100) NULL,
	[Fahrzeug] [varchar](100) NULL,
	[Auftragsart] [varchar](100) NULL,
	[Auftragsnr] [varchar](100) NULL,
	[Archivierungsdatum] [datetime] NULL,
	[Umsatzart] [varchar](100) NULL,
	[Marke] [varchar](100) NULL,
	[Heute] [datetime] NULL,
	[Tag] [varchar](100) NULL,
	[Buchungsdatum_Datum] [datetime] NULL,
	[Rechnungsausgang] [varchar](100) NULL,
	[Order_Number_RG_Ausg] [varchar](100) NULL,
	[Standort_1] [varchar](100) NULL,
	[Tage bis Rechnung_ori] [varchar](100) NULL,
	[Tage bis Rechnung] [varchar](100) NULL,
	[Rech An Deb -nr2] [varchar](100) NULL,
	[Rech An Name] [varchar](100) NULL,
	[Rechnunsgkunde] [varchar](100) NULL,
	[Funktion] [varchar](100) NULL,
	[Servicberater   sonst  MA] [varchar](100) NULL,
	[Date] [varchar](100) NULL,
	[Company_ID] [varchar](100) NULL,
	[Department_ID] [varchar](100) NULL,
	[Employee_Function] [varchar](100) NULL,
	[Service_Advisor_Name] [varchar](100) NULL,
	[Turnover_Type_Desc] [varchar](100) NULL,
	[Order_Desc_100] [varchar](100) NULL,
	[Invoice_Desc_100] [varchar](100) NULL,
	[Order_Desc_30] [varchar](100) NULL,
	[Invoice_Desc_30] [varchar](100) NULL,
	[Make_Desc] [varchar](100) NULL,
	[Make_Group] [varchar](100) NULL,
	[Model_Desc] [varchar](100) NULL,
	[Customer_Group_Owner] [varchar](100) NULL,
	[Customer_Name_Owner] [varchar](100) NULL,
	[Ländercode] [varchar](100) NULL,
	[Land] [varchar](100) NULL,
	[Cust_Zipcode_Country] [varchar](100) NULL,
	[Plz Code] [varchar](100) NULL,
	[Cust_Zipcode_First] [varchar](100) NULL,
	[Cust_Zipcode_Second] [varchar](100) NULL,
	[Cust_Zipcode_Third] [varchar](100) NULL,
	[Cust_Zipcode_Fourth] [varchar](100) NULL,
	[Cust_Zipcode] [varchar](100) NULL,
	[Erstzulassung] [varchar](100) NULL,
	[Fahrzeugalter_Tage] [varchar](100) NULL,
	[Fahrzeugalter] [varchar](100) NULL,
	[FZG_Altersstaffel] [varchar](100) NULL,
	[Car_Age] [varchar](100) NULL,
	[Invoice_Credit_Note] [varchar](100) NULL,
	[Order_Status] [varchar](100) NULL,
	[Order_Type_Desc] [varchar](100) NULL,
	[Time Account No_Time_Entry_T] [varchar](100) NULL,
	[Time Account Value_Time_Entry_T] [varchar](100) NULL,
	[Used_Time] [varchar](100) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[Auftraege_EDS_mit_OP]    Script Date: 24.04.2019 11:47:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[Auftraege_EDS_mit_OP](
	[A_Belegart] [varchar](100) NULL,
	[A_Nr] [varchar](100) NULL,
	[A_Verk An Deb -nr] [varchar](100) NULL,
	[A_Rech An Deb -nr] [varchar](100) NULL,
	[A_Auftragsdatum] [datetime] NULL,
	[A_Buchungsdatum] [datetime] NULL,
	[A_Filialcode] [varchar](100) NULL,
	[B_Belegart] [varchar](100) NULL,
	[B_Nr] [varchar](100) NULL,
	[B_Verk An Deb -nr] [varchar](100) NULL,
	[B_Rech An Deb -nr] [varchar](100) NULL,
	[B_Auftragsdatum] [datetime] NULL,
	[B_Buchungsdatum] [datetime] NULL,
	[B_Interne Belegnr] [varchar](100) NULL,
	[A_Interner Auftrag] [varchar](100) NULL,
	[A_Interne Belegnr] [varchar](100) NULL,
	[B_Filialcode] [varchar](100) NULL,
	[Belegart] [varchar](100) NULL,
	[Nr] [varchar](100) NULL,
	[Verk An Deb -nr] [varchar](100) NULL,
	[Auftragsdatum] [datetime] NULL,
	[Buchungsdatum] [datetime] NULL,
	[Filialcode] [varchar](100) NULL,
	[Belegnr] [varchar](100) NULL,
	[Art] [varchar](100) NULL,
	[APO_TEILE_Nr] [varchar](100) NULL,
	[Beschreibung] [varchar](100) NULL,
	[Menge_ori] [decimal](28, 8) NULL,
	[Ek-preis] [decimal](28, 8) NULL,
	[Einstandspreis] [decimal](28, 8) NULL,
	[Einstandsbetrag_ori] [decimal](28, 8) NULL,
	[Vk-preis] [decimal](28, 8) NULL,
	[Verkaufsbetrag_ori] [decimal](28, 8) NULL,
	[Fakturierbar] [varchar](100) NULL,
	[Werkstattbuchungsgruppe] [varchar](100) NULL,
	[Kostenstellencode] [varchar](100) NULL,
	[Markencode] [varchar](100) NULL,
	[Arbeitstypencode] [varchar](100) NULL,
	[Benutzer Id] [varchar](100) NULL,
	[Herkunftscode] [varchar](100) NULL,
	[Postenart] [varchar](100) NULL,
	[Positiv] [varchar](100) NULL,
	[Geschäftsbuchungsgruppe] [varchar](100) NULL,
	[Produktbuchungsgruppe] [varchar](100) NULL,
	[Belegdatum] [datetime] NULL,
	[Nummernserie] [varchar](100) NULL,
	[Storniert] [varchar](100) NULL,
	[Buchnr] [varchar](100) NULL,
	[Zeitart] [varchar](100) NULL,
	[Fahrzeugtyp] [varchar](100) NULL,
	[Paketnr] [varchar](100) NULL,
	[Kostenstellencode Verkauf] [varchar](100) NULL,
	[Verrechnungspreis] [decimal](28, 8) NULL,
	[Verrechnungsbetrag_ori] [decimal](28, 8) NULL,
	[Verrechnungsbetrag (bw)] [varchar](100) NULL,
	[Abgeschlossen] [varchar](100) NULL,
	[Fahrgestellnummer] [varchar](100) NULL,
	[Menge Pro Stunde] [varchar](100) NULL,
	[Menge (stunde)] [decimal](28, 8) NULL,
	[Artikelgruppencode] [varchar](100) NULL,
	[Belegtyp] [varchar](100) NULL,
	[Fahrzeugartencode] [varchar](100) NULL,
	[Fahrzeugstatus] [varchar](100) NULL,
	[Marktsegmentcode] [varchar](100) NULL,
	[Hauptgruppencode] [varchar](100) NULL,
	[Untergruppencode] [varchar](100) NULL,
	[Positionsgruppencode] [varchar](100) NULL,
	[Kundengruppencode] [varchar](100) NULL,
	[Ist-menge (stunde)] [varchar](100) NULL,
	[Vorgabezeit] [decimal](28, 8) NULL,
	[Vorgabezeitart] [varchar](100) NULL,
	[Herkunftsart] [varchar](100) NULL,
	[Herkunftsnr] [varchar](100) NULL,
	[Auftragszeilennr] [varchar](100) NULL,
	[Interne Verrechnung Erfolgt] [varchar](100) NULL,
	[Verrechnungspreis Fix] [varchar](100) NULL,
	[Auftrag Erledigt] [varchar](100) NULL,
	[Buchungsdatum (letzte Rechn )] [datetime] NULL,
	[Offen] [varchar](100) NULL,
	[Betrag Int Zu Verrechnen] [decimal](28, 8) NULL,
	[Betrag Int Zu Verrechnen (bw)] [decimal](28, 8) NULL,
	[Betrag Int Verrechnet] [decimal](28, 8) NULL,
	[Betrag Int Verrechnet (bw)] [decimal](28, 8) NULL,
	[Serviceberaternr] [varchar](100) NULL,
	[Mitarbeiternr] [varchar](100) NULL,
	[Tätigkeitsartcode] [varchar](100) NULL,
	[Monteur Nr 1] [varchar](100) NULL,
	[Aw Mont 1] [decimal](28, 8) NULL,
	[Monteur Nr 2] [varchar](100) NULL,
	[Aw Mont 2] [varchar](100) NULL,
	[Hauptbetrieb] [varchar](100) NULL,
	[Standort] [varchar](100) NULL,
	[FIL-Code] [varchar](100) NULL,
	[FIL-Bezeichnung] [varchar](100) NULL,
	[Standort_1_ori] [varchar](100) NULL,
	[Vorname] [varchar](100) NULL,
	[Nachname] [varchar](100) NULL,
	[Serviceberater] [varchar](100) NULL,
	[Menge] [decimal](28, 8) NULL,
	[Einstandsbetrag] [decimal](28, 8) NULL,
	[Verkaufsbetrag] [decimal](28, 8) NULL,
	[Rech An Deb -nr] [varchar](100) NULL,
	[Umsatzart_ori] [varchar](100) NULL,
	[KD_Nr] [varchar](100) NULL,
	[KD_Name] [varchar](100) NULL,
	[Kunde] [varchar](100) NULL,
	[Invoice Date] [datetime] NULL,
	[Order Number] [varchar](100) NULL,
	[Fabrikat] [varchar](100) NULL,
	[Modell] [varchar](100) NULL,
	[Model] [varchar](100) NULL,
	[Fahrzeug] [varchar](100) NULL,
	[KST_aus_Code] [varchar](100) NULL,
	[Kostenstelle] [varchar](100) NULL,
	[Auftragsart] [varchar](100) NULL,
	[Lines Net Value] [decimal](28, 8) NULL,
	[Umsatz Lohn] [decimal](28, 8) NULL,
	[Umsatz Teile Service] [decimal](28, 8) NULL,
	[Umsatz Sonstiges] [decimal](28, 8) NULL,
	[Einsatz Teile Service_ori] [decimal](28, 8) NULL,
	[Einsatz Teile Service] [decimal](28, 8) NULL,
	[Einsatz Sonstiges] [decimal](28, 8) NULL,
	[Menge_pro_Stunde] [decimal](28, 8) NULL,
	[Menge_stunde] [decimal](28, 8) NULL,
	[Sollzeit] [decimal](28, 8) NULL,
	[Sollzeit_Art] [decimal](28, 8) NULL,
	[AW_Mont_1] [decimal](28, 8) NULL,
	[AW_Mont_2] [decimal](28, 8) NULL,
	[verk  Stunden] [decimal](28, 8) NULL,
	[Soll-Stunden] [decimal](28, 8) NULL,
	[benutzte Zeit_ori] [decimal](28, 8) NULL,
	[Auftragsnr] [varchar](100) NULL,
	[A_Belegnr] [varchar](100) NULL,
	[A_Zeilennr] [varchar](100) NULL,
	[Archivierungsdatum] [datetime] NULL,
	[Arch Durch Benutzer Id] [varchar](100) NULL,
	[Archivierungsgrund] [varchar](100) NULL,
	[Umsatzart] [varchar](100) NULL,
	[Marke] [varchar](100) NULL,
	[Kundenart] [varchar](100) NULL,
	[DG_1] [varchar](100) NULL,
	[Herkunftsnr (zahlung)] [varchar](100) NULL,
	[Hauptdebitor] [varchar](100) NULL,
	[DB Teile] [decimal](28, 8) NULL,
	[Verr_Betrag] [decimal](28, 8) NULL,
	[Nr2] [varchar](100) NULL,
	[Beschreibung2] [varchar](100) NULL,
	[Basiseinheitencode] [varchar](100) NULL,
	[Vk-preis2] [decimal](28, 8) NULL,
	[Einstandspreis_ART] [decimal](28, 8) NULL,
	[Ek-preis (neuester)_ART] [decimal](28, 8) NULL,
	[Einstandspreis (durchschn )_ART] [decimal](28, 8) NULL,
	[Einstandspreis_Art2] [decimal](28, 8) NULL,
	[EK_preis_neu_Art] [decimal](28, 8) NULL,
	[Einstandspreis_Durch_Art] [decimal](28, 8) NULL,
	[Heute] [datetime] NULL,
	[Tag] [varchar](100) NULL,
	[Buchungsdatum_Datum] [datetime] NULL,
	[Rechnungsausgang] [varchar](100) NULL,
	[Order_Number_RG_Ausg] [varchar](100) NULL,
	[DG_1_2] [varchar](100) NULL,
	[DG_2] [varchar](100) NULL,
	[Durchgänge] [decimal](28, 8) NULL,
	[Standort_1] [varchar](100) NULL,
	[Tage bis Rechnung_ori] [varchar](100) NULL,
	[Tage bis Rechnung] [decimal](28, 8) NULL,
	[Buchungsdatum2] [datetime] NULL,
	[Belegnr2] [varchar](100) NULL,
	[Betrag] [decimal](28, 8) NULL,
	[Restbetrag] [decimal](28, 8) NULL,
	[Offen2] [varchar](100) NULL,
	[Fälligkeitsdatum] [datetime] NULL,
	[Geschlossen Am] [datetime] NULL,
	[Geschlossen Mit Betrag] [decimal](28, 8) NULL,
	[Belegart2] [varchar](100) NULL,
	[Verk An Deb -nr2] [varchar](100) NULL,
	[Herkunftscode2] [varchar](100) NULL,
	[Betrag offen_ori] [decimal](28, 8) NULL,
	[Betrag offen] [decimal](28, 8) NULL,
	[MW Tage] [decimal](28, 8) NULL,
	[MW Preis] [decimal](28, 8) NULL,
	[TÜV] [decimal](28, 8) NULL,
	[Fremdl ] [decimal](28, 8) NULL,
	[Mietw ] [decimal](28, 8) NULL,
	[Rädereinl ] [decimal](28, 8) NULL,
	[Geschäftsbuchungsgruppe_Archiv_Kopf] [varchar](100) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[Belege_EDS]    Script Date: 24.04.2019 11:47:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[Belege_EDS](
	[Nr] [varchar](100) NULL,
	[Name] [varchar](100) NULL,
	[Kontoart] [varchar](100) NULL,
	[Guv Bilanz] [varchar](100) NULL,
	[Soll Haben] [varchar](100) NULL,
	[Kostenstellen Buchung] [varchar](100) NULL,
	[Lfd Nr] [varchar](100) NULL,
	[Sachkontonr] [varchar](100) NULL,
	[Buchungsdatum] [datetime] NULL,
	[Belegart] [varchar](100) NULL,
	[Belegnr] [varchar](100) NULL,
	[Beschreibung] [varchar](100) NULL,
	[Gegenkontonr] [varchar](100) NULL,
	[Betrag_ori] [decimal](28, 8) NULL,
	[Kostenstellencode] [varchar](100) NULL,
	[Markencode] [varchar](100) NULL,
	[Benutzer Id] [varchar](100) NULL,
	[Herkunftscode] [varchar](100) NULL,
	[Nachbuchung] [varchar](100) NULL,
	[Menge_ori] [decimal](28, 8) NULL,
	[Mwst Betrag] [decimal](28, 8) NULL,
	[Buchungsart] [varchar](100) NULL,
	[Geschäftsbuchungsgruppe] [varchar](100) NULL,
	[Produktbuchungsgruppe] [varchar](100) NULL,
	[Gegenkontoart] [varchar](100) NULL,
	[Transaktionsnr] [varchar](100) NULL,
	[Sollbetrag] [decimal](28, 8) NULL,
	[Habenbetrag] [decimal](28, 8) NULL,
	[Belegdatum] [datetime] NULL,
	[Externe Belegnummer] [varchar](100) NULL,
	[Herkunftsart] [varchar](100) NULL,
	[Herkunftsnr] [varchar](100) NULL,
	[Filialcode] [varchar](100) NULL,
	[Hauptbereich] [varchar](100) NULL,
	[Fahrgestellnummer] [varchar](100) NULL,
	[Buchnummer] [varchar](100) NULL,
	[Fahrzeug-kz] [varchar](100) NULL,
	[Umgebucht] [varchar](100) NULL,
	[Storniert] [varchar](100) NULL,
	[Fahrzeugklassecode] [varchar](100) NULL,
	[Code] [varchar](100) NULL,
	[Name2] [varchar](100) NULL,
	[Code2] [varchar](100) NULL,
	[Bezeichnung] [varchar](100) NULL,
	[Betrag_1] [decimal](28, 8) NULL,
	[Rechtseinheit] [varchar](100) NULL,
	[Betrieb_Nr] [varchar](100) NULL,
	[Betrieb_1] [varchar](100) NULL,
	[Marke_ori] [varchar](100) NULL,
	[Mandant] [varchar](100) NULL,
	[Menge_1] [decimal](28, 8) NULL,
	[Bookkeep Date] [datetime] NULL,
	[Text] [varchar](100) NULL,
	[KST_aus_Code] [varchar](100) NULL,
	[Kostenstelle_ori] [varchar](100) NULL,
	[KST_1] [varchar](100) NULL,
	[KST_2] [varchar](100) NULL,
	[Acct Nr] [varchar](100) NULL,
	[Betrag] [decimal](28, 8) NULL,
	[Menge_mit_ETÜ] [decimal](28, 8) NULL,
	[Betrieb_ori] [varchar](100) NULL,
	[Benutzer] [varchar](100) NULL,
	[Fahrgestellnummer2] [varchar](100) NULL,
	[Modell_neu] [varchar](100) NULL,
	[Markencode2] [varchar](100) NULL,
	[Verkäufer Nr Verkauf] [varchar](100) NULL,
	[Konto KZ] [varchar](100) NULL,
	[Plausibilität] [varchar](100) NULL,
	[Marke aus KST] [varchar](100) NULL,
	[Marke] [varchar](100) NULL,
	[Susa] [varchar](100) NULL,
	[GuV_Bilanz] [varchar](100) NULL,
	[Betrieb] [varchar](100) NULL,
	[Menge] [decimal](28, 8) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[Belege_EDS_SKR_KST_90]    Script Date: 24.04.2019 11:47:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[Belege_EDS_SKR_KST_90](
	[Nr] [varchar](100) NULL,
	[Name] [varchar](100) NULL,
	[Kontoart] [varchar](100) NULL,
	[Guv Bilanz] [varchar](100) NULL,
	[Soll Haben] [varchar](100) NULL,
	[Kostenstellen Buchung] [varchar](100) NULL,
	[Lfd Nr] [varchar](100) NULL,
	[Sachkontonr] [varchar](100) NULL,
	[Buchungsdatum] [datetime] NULL,
	[Belegart] [varchar](100) NULL,
	[Belegnr] [varchar](100) NULL,
	[Beschreibung] [varchar](100) NULL,
	[Gegenkontonr] [varchar](100) NULL,
	[Betrag_ori] [decimal](28, 8) NULL,
	[Kostenstellencode] [varchar](100) NULL,
	[Markencode] [varchar](100) NULL,
	[Benutzer Id] [varchar](100) NULL,
	[Herkunftscode] [varchar](100) NULL,
	[Nachbuchung] [varchar](100) NULL,
	[Menge_ori] [varchar](100) NULL,
	[Mwst Betrag] [decimal](28, 8) NULL,
	[Buchungsart] [varchar](100) NULL,
	[Geschäftsbuchungsgruppe] [varchar](100) NULL,
	[Geschäftsbuchungsgruppe_Beschreibung] [varchar](100) NULL,
	[Produktbuchungsgruppe] [varchar](100) NULL,
	[Produktbuchungsgruppe_Beschreibung] [varchar](100) NULL,
	[Gegenkontoart] [varchar](100) NULL,
	[Transaktionsnr] [varchar](100) NULL,
	[Sollbetrag] [decimal](28, 8) NULL,
	[Habenbetrag] [decimal](28, 8) NULL,
	[Belegdatum] [datetime] NULL,
	[Externe Belegnummer] [varchar](100) NULL,
	[Herkunftsart] [varchar](100) NULL,
	[Herkunftsnr] [varchar](100) NULL,
	[Filialcode] [varchar](100) NULL,
	[Hauptbereich] [varchar](100) NULL,
	[Fahrgestellnummer] [varchar](100) NULL,
	[Buchnummer] [varchar](100) NULL,
	[Fahrzeug-kz] [varchar](100) NULL,
	[Umgebucht] [varchar](100) NULL,
	[Storniert] [varchar](100) NULL,
	[Fahrzeugklassecode] [varchar](100) NULL,
	[Code] [varchar](100) NULL,
	[Name2] [varchar](100) NULL,
	[Code2] [varchar](100) NULL,
	[Bezeichnung] [varchar](100) NULL,
	[Betrag_1] [decimal](28, 8) NULL,
	[Rechtseinheit] [varchar](100) NULL,
	[Betrieb_Nr] [varchar](100) NULL,
	[Betrieb_1] [varchar](100) NULL,
	[Marke_ori] [varchar](100) NULL,
	[Mandant] [varchar](100) NULL,
	[Menge_1] [varchar](100) NULL,
	[Bookkeep Date] [datetime] NULL,
	[Text] [varchar](100) NULL,
	[KST_aus_Code] [varchar](100) NULL,
	[Kostenstelle_ori] [varchar](100) NULL,
	[KST_1] [varchar](100) NULL,
	[KST_2] [varchar](100) NULL,
	[Acct Nr_ori] [varchar](100) NULL,
	[Betrag] [decimal](28, 8) NULL,
	[Menge] [varchar](100) NULL,
	[Betrieb] [varchar](100) NULL,
	[Benutzer] [varchar](100) NULL,
	[Fahrgestellnummer2] [varchar](100) NULL,
	[Modell_neu] [varchar](100) NULL,
	[Markencode2] [varchar](100) NULL,
	[Verkäufer Nr Verkauf] [varchar](100) NULL,
	[Konto KZ] [varchar](100) NULL,
	[Plausibilität] [varchar](100) NULL,
	[Marke aus KST] [varchar](100) NULL,
	[Marke] [varchar](100) NULL,
	[Susa] [varchar](100) NULL,
	[GuV_Bilanz] [varchar](100) NULL,
	[Absatzkanal_Code] [varchar](100) NULL,
	[KST_ori] [varchar](100) NULL,
	[KST] [varchar](100) NULL,
	[Mb Makecode] [varchar](100) NULL,
	[Mb Locationcode] [varchar](100) NULL,
	[Mb Costcentercode] [varchar](100) NULL,
	[Mb Distributionchannelcode] [varchar](100) NULL,
	[Mb Costunitcode] [varchar](100) NULL,
	[Mb Taxationcode] [varchar](100) NULL,
	[Kostenträger] [varchar](100) NULL,
	[Acct Nr] [varchar](100) NULL,
	[Mb Makecode2] [varchar](100) NULL,
	[Code_MB_Cost_Unit] [varchar](100) NULL,
	[Description_MB_Cost_Unit] [varchar](100) NULL,
	[Kostenträger_FIBU] [varchar](100) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[Belege_EDS_SKR_ohne_KST_90]    Script Date: 24.04.2019 11:47:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[Belege_EDS_SKR_ohne_KST_90](
	[Nr] [varchar](100) NULL,
	[Name] [varchar](100) NULL,
	[Kontoart] [varchar](100) NULL,
	[Guv Bilanz] [varchar](100) NULL,
	[Soll Haben] [varchar](100) NULL,
	[Kostenstellen Buchung] [varchar](100) NULL,
	[Lfd Nr] [varchar](100) NULL,
	[Sachkontonr] [varchar](100) NULL,
	[Buchungsdatum] [datetime] NULL,
	[Belegart] [varchar](100) NULL,
	[Belegnr] [varchar](100) NULL,
	[Beschreibung] [varchar](100) NULL,
	[Gegenkontonr] [varchar](100) NULL,
	[Betrag_ori] [decimal](28, 8) NULL,
	[Kostenstellencode] [varchar](100) NULL,
	[Markencode] [varchar](100) NULL,
	[Benutzer Id] [varchar](100) NULL,
	[Herkunftscode] [varchar](100) NULL,
	[Nachbuchung] [varchar](100) NULL,
	[Menge_ori] [decimal](28, 8) NULL,
	[Mwst Betrag] [decimal](28, 8) NULL,
	[Buchungsart] [varchar](100) NULL,
	[Geschäftsbuchungsgruppe] [varchar](100) NULL,
	[Geschäftsbuchungsgruppe_Beschreibung] [varchar](100) NULL,
	[Produktbuchungsgruppe] [varchar](100) NULL,
	[Produktbuchungsgruppe_Beschreibung] [varchar](100) NULL,
	[Gegenkontoart] [varchar](100) NULL,
	[Transaktionsnr] [varchar](100) NULL,
	[Sollbetrag] [decimal](28, 8) NULL,
	[Habenbetrag] [decimal](28, 8) NULL,
	[Belegdatum] [datetime] NULL,
	[Externe Belegnummer] [varchar](100) NULL,
	[Herkunftsart] [varchar](100) NULL,
	[Herkunftsnr] [varchar](100) NULL,
	[Filialcode] [varchar](100) NULL,
	[Hauptbereich] [varchar](100) NULL,
	[Fahrgestellnummer] [varchar](100) NULL,
	[Buchnummer] [varchar](100) NULL,
	[Fahrzeug-kz] [varchar](100) NULL,
	[Umgebucht] [varchar](100) NULL,
	[Storniert] [varchar](100) NULL,
	[Fahrzeugklassecode] [varchar](100) NULL,
	[Code] [varchar](100) NULL,
	[Name2] [varchar](100) NULL,
	[Code2] [varchar](100) NULL,
	[Bezeichnung] [varchar](100) NULL,
	[Betrag_1] [decimal](28, 8) NULL,
	[Rechtseinheit] [varchar](100) NULL,
	[Betrieb_Nr] [varchar](100) NULL,
	[Betrieb_1] [varchar](100) NULL,
	[Marke_ori] [varchar](100) NULL,
	[Mandant] [varchar](100) NULL,
	[Menge_1] [varchar](100) NULL,
	[Bookkeep Date] [datetime] NULL,
	[Text] [varchar](100) NULL,
	[KST_aus_Code] [varchar](100) NULL,
	[Kostenstelle_ori] [varchar](100) NULL,
	[KST_1] [varchar](100) NULL,
	[KST_2] [varchar](100) NULL,
	[Acct Nr] [varchar](100) NULL,
	[Betrag] [decimal](28, 8) NULL,
	[Menge] [decimal](28, 8) NULL,
	[Betrieb] [varchar](100) NULL,
	[Benutzer] [varchar](100) NULL,
	[Fahrgestellnummer2] [varchar](100) NULL,
	[Modell_neu] [varchar](100) NULL,
	[Markencode2] [varchar](100) NULL,
	[Verkäufer Nr Verkauf] [varchar](100) NULL,
	[Konto KZ] [varchar](100) NULL,
	[Plausibilität] [varchar](100) NULL,
	[Marke aus KST] [varchar](100) NULL,
	[Marke] [varchar](100) NULL,
	[Susa] [varchar](100) NULL,
	[GuV_Bilanz] [varchar](100) NULL,
	[Absatzkanal_Code] [varchar](100) NULL,
	[KST_ori] [varchar](100) NULL,
	[KST] [varchar](100) NULL,
	[Mb Makecode] [varchar](100) NULL,
	[Mb Locationcode] [varchar](100) NULL,
	[Mb Costcentercode] [varchar](100) NULL,
	[Mb Distributionchannelcode] [varchar](100) NULL,
	[Mb Costunitcode] [varchar](100) NULL,
	[Mb Taxationcode] [varchar](100) NULL,
	[Kostenträger] [varchar](100) NULL,
	[rein_raus] [varchar](100) NULL,
	[Mb Makecode2] [varchar](100) NULL,
	[Code_MB_Cost_Unit] [varchar](100) NULL,
	[Description_MB_Cost_Unit] [varchar](100) NULL,
	[Kostenträger_FIBU] [varchar](100) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[Belege_EDS_SKR_Stk]    Script Date: 24.04.2019 11:47:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[Belege_EDS_SKR_Stk](
	[Nr] [varchar](100) NULL,
	[Name] [varchar](100) NULL,
	[Kontoart] [varchar](100) NULL,
	[Guv Bilanz] [varchar](100) NULL,
	[Soll Haben] [varchar](100) NULL,
	[Kostenstellen Buchung] [varchar](100) NULL,
	[Lfd Nr] [varchar](100) NULL,
	[Sachkontonr] [varchar](100) NULL,
	[Buchungsdatum] [datetime] NULL,
	[Belegart] [varchar](100) NULL,
	[Belegnr] [varchar](100) NULL,
	[Beschreibung] [varchar](100) NULL,
	[Gegenkontonr] [varchar](100) NULL,
	[Betrag_ori] [decimal](28, 8) NULL,
	[Kostenstellencode] [varchar](100) NULL,
	[Markencode] [varchar](100) NULL,
	[Benutzer Id] [varchar](100) NULL,
	[Herkunftscode] [varchar](100) NULL,
	[Nachbuchung] [varchar](100) NULL,
	[Menge_ori] [varchar](100) NULL,
	[Mwst Betrag] [decimal](28, 8) NULL,
	[Buchungsart] [varchar](100) NULL,
	[Geschäftsbuchungsgruppe] [varchar](100) NULL,
	[Geschäftsbuchungsgruppe_Beschreibung] [varchar](100) NULL,
	[Produktbuchungsgruppe] [varchar](100) NULL,
	[Produktbuchungsgruppe_Beschreibung] [varchar](100) NULL,
	[Gegenkontoart] [varchar](100) NULL,
	[Transaktionsnr] [varchar](100) NULL,
	[Sollbetrag] [decimal](28, 8) NULL,
	[Habenbetrag] [decimal](28, 8) NULL,
	[Belegdatum] [datetime] NULL,
	[Externe Belegnummer] [varchar](100) NULL,
	[Herkunftsart] [varchar](100) NULL,
	[Herkunftsnr] [varchar](100) NULL,
	[Filialcode] [varchar](100) NULL,
	[Hauptbereich] [varchar](100) NULL,
	[Fahrgestellnummer] [varchar](100) NULL,
	[Buchnummer] [varchar](100) NULL,
	[Fahrzeug-kz] [varchar](100) NULL,
	[Umgebucht] [varchar](100) NULL,
	[Storniert] [varchar](100) NULL,
	[Fahrzeugklassecode] [varchar](100) NULL,
	[Code] [varchar](100) NULL,
	[Name2] [varchar](100) NULL,
	[Code2] [varchar](100) NULL,
	[Bezeichnung] [varchar](100) NULL,
	[Betrag_1] [decimal](28, 8) NULL,
	[Rechtseinheit] [varchar](100) NULL,
	[Betrieb_Nr] [varchar](100) NULL,
	[Betrieb_1] [varchar](100) NULL,
	[Marke_ori] [varchar](100) NULL,
	[Mandant] [varchar](100) NULL,
	[Menge_1] [varchar](100) NULL,
	[Bookkeep Date] [datetime] NULL,
	[Text] [varchar](100) NULL,
	[KST_aus_Code] [varchar](100) NULL,
	[Kostenstelle_ori] [varchar](100) NULL,
	[KST_1] [varchar](100) NULL,
	[KST_2] [varchar](100) NULL,
	[Acct Nr_ori] [varchar](100) NULL,
	[Betrag] [varchar](100) NULL,
	[Menge] [varchar](100) NULL,
	[Betrieb] [varchar](100) NULL,
	[Benutzer] [varchar](100) NULL,
	[Fahrgestellnummer2] [varchar](100) NULL,
	[Modell_neu] [varchar](100) NULL,
	[Markencode2] [varchar](100) NULL,
	[Verkäufer Nr Verkauf] [varchar](100) NULL,
	[Konto KZ] [varchar](100) NULL,
	[Plausibilität] [varchar](100) NULL,
	[Marke aus KST] [varchar](100) NULL,
	[Marke] [varchar](100) NULL,
	[Susa] [varchar](100) NULL,
	[GuV_Bilanz] [varchar](100) NULL,
	[Absatzkanal_Code] [varchar](100) NULL,
	[KST_ori] [varchar](100) NULL,
	[KST] [varchar](100) NULL,
	[Mb Makecode] [varchar](100) NULL,
	[Mb Locationcode] [varchar](100) NULL,
	[Mb Costcentercode] [varchar](100) NULL,
	[Mb Distributionchannelcode] [varchar](100) NULL,
	[Mb Costunitcode] [varchar](100) NULL,
	[Mb Taxationcode] [varchar](100) NULL,
	[Kostenträger] [varchar](100) NULL,
	[Acct Nr] [varchar](100) NULL,
	[Mb Makecode2] [varchar](100) NULL,
	[Code_MB_Cost_Unit] [varchar](100) NULL,
	[Description_MB_Cost_Unit] [varchar](100) NULL,
	[Kostenträger_FIBU] [varchar](100) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[Belege_EDS_STK_ohne_Service_AW]    Script Date: 24.04.2019 11:47:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[Belege_EDS_STK_ohne_Service_AW](
	[Nr] [varchar](100) NULL,
	[Name] [varchar](100) NULL,
	[Kontoart] [varchar](100) NULL,
	[Guv Bilanz] [varchar](100) NULL,
	[Soll Haben] [varchar](100) NULL,
	[Kostenstellen Buchung] [varchar](100) NULL,
	[Lfd Nr] [varchar](100) NULL,
	[Sachkontonr] [varchar](100) NULL,
	[Buchungsdatum] [datetime] NULL,
	[Belegart] [varchar](100) NULL,
	[Belegnr] [varchar](100) NULL,
	[Beschreibung] [varchar](100) NULL,
	[Gegenkontonr] [varchar](100) NULL,
	[Betrag_ori] [decimal](28, 8) NULL,
	[Kostenstellencode] [varchar](100) NULL,
	[Markencode] [varchar](100) NULL,
	[Benutzer Id] [varchar](100) NULL,
	[Herkunftscode] [varchar](100) NULL,
	[Nachbuchung] [varchar](100) NULL,
	[Menge_ori] [varchar](100) NULL,
	[Mwst Betrag] [decimal](28, 8) NULL,
	[Buchungsart] [varchar](100) NULL,
	[Geschäftsbuchungsgruppe] [varchar](100) NULL,
	[Produktbuchungsgruppe] [varchar](100) NULL,
	[Gegenkontoart] [varchar](100) NULL,
	[Transaktionsnr] [varchar](100) NULL,
	[Sollbetrag] [decimal](28, 8) NULL,
	[Habenbetrag] [decimal](28, 8) NULL,
	[Belegdatum] [datetime] NULL,
	[Externe Belegnummer] [varchar](100) NULL,
	[Herkunftsart] [varchar](100) NULL,
	[Herkunftsnr] [varchar](100) NULL,
	[Filialcode] [varchar](100) NULL,
	[Hauptbereich] [varchar](100) NULL,
	[Fahrgestellnummer] [varchar](100) NULL,
	[Buchnummer] [varchar](100) NULL,
	[Fahrzeug-kz] [varchar](100) NULL,
	[Umgebucht] [varchar](100) NULL,
	[Storniert] [varchar](100) NULL,
	[Fahrzeugklassecode] [varchar](100) NULL,
	[Code] [varchar](100) NULL,
	[Name2] [varchar](100) NULL,
	[Code2] [varchar](100) NULL,
	[Bezeichnung] [varchar](100) NULL,
	[Betrag_1] [decimal](28, 8) NULL,
	[Rechtseinheit] [varchar](100) NULL,
	[Betrieb_Nr] [varchar](100) NULL,
	[Betrieb_1] [varchar](100) NULL,
	[Marke] [varchar](100) NULL,
	[Mandant] [varchar](100) NULL,
	[Menge_1] [varchar](100) NULL,
	[Bookkeep Date] [datetime] NULL,
	[Text] [varchar](100) NULL,
	[KST_aus_Code] [varchar](100) NULL,
	[Kostenstelle_ori] [varchar](100) NULL,
	[KST_1] [varchar](100) NULL,
	[KST_2] [varchar](100) NULL,
	[Acct Nr] [varchar](100) NULL,
	[Betrag_alt] [varchar](100) NULL,
	[Menge_3] [varchar](100) NULL,
	[Betrieb] [varchar](100) NULL,
	[Benutzer] [varchar](100) NULL,
	[Fahrgestellnummer2] [varchar](100) NULL,
	[Modell_neu] [varchar](100) NULL,
	[Markencode2] [varchar](100) NULL,
	[Konto KZ] [varchar](100) NULL,
	[Plausibilität] [varchar](100) NULL,
	[Marke aus KST] [varchar](100) NULL,
	[Marke_ori] [varchar](100) NULL,
	[Susa] [varchar](100) NULL,
	[GuV_Bilanz] [varchar](100) NULL,
	[Betrag] [varchar](100) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[Kontenrahmen]    Script Date: 24.04.2019 11:47:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[Kontenrahmen](
	[Konto_Nr] [varchar](50) NULL,
	[Konto_Bezeichnung] [varchar](50) NULL,
	[Konto_Art] [varchar](50) NULL,
	[Kostenstelle] [varchar](50) NULL,
	[STK] [varchar](50) NULL,
	[Konto_1] [varchar](50) NULL,
	[Konto_2] [varchar](50) NULL,
	[Konto_3] [varchar](50) NULL,
	[Konto_4] [varchar](50) NULL,
	[Konto_5] [varchar](50) NULL,
	[Ebene1] [varchar](50) NULL,
	[Ebene2] [varchar](50) NULL,
	[Ebene3] [varchar](50) NULL,
	[Ebene4] [varchar](50) NULL,
	[Ebene5] [varchar](50) NULL,
	[Ebene6] [varchar](50) NULL,
	[Ebene7] [varchar](50) NULL,
	[Ebene8] [varchar](50) NULL,
	[Ebene9] [varchar](50) NULL,
	[Ebene10] [varchar](50) NULL,
	[Ebene11] [varchar](50) NULL,
	[Ebene12] [varchar](50) NULL,
	[Ebene13] [varchar](50) NULL,
	[Ebene14] [varchar](50) NULL,
	[Ebene15] [varchar](50) NULL,
	[Ebene16] [varchar](50) NULL,
	[Ebene17] [varchar](50) NULL,
	[Ebene18] [varchar](50) NULL,
	[Ebene19] [varchar](50) NULL,
	[Ebene20] [varchar](50) NULL,
	[Ebene21] [varchar](50) NULL,
	[Ebene22] [varchar](50) NULL,
	[Ebene23] [varchar](50) NULL,
	[Ebene24] [varchar](50) NULL,
	[Ebene25] [varchar](50) NULL,
	[Ebene26] [varchar](50) NULL,
	[Ebene27] [varchar](50) NULL,
	[Ebene28] [varchar](50) NULL,
	[Ebene29] [varchar](50) NULL,
	[Ebene30] [varchar](50) NULL,
	[Ebene31] [varchar](50) NULL,
	[Ebene32] [varchar](50) NULL,
	[Ebene33] [varchar](50) NULL,
	[Ebene34] [varchar](50) NULL,
	[Ebene35] [varchar](50) NULL,
	[Ebene36] [varchar](50) NULL,
	[Ebene37] [varchar](50) NULL,
	[Ebene38] [varchar](50) NULL,
	[Ebene39] [varchar](50) NULL,
	[Ebene40] [varchar](50) NULL,
	[Ebene41] [varchar](50) NULL,
	[Ebene42] [varchar](50) NULL,
	[Ebene43] [varchar](50) NULL,
	[Ebene44] [varchar](50) NULL,
	[Ebene45] [varchar](50) NULL,
	[Ebene46] [varchar](50) NULL,
	[Ebene47] [varchar](50) NULL,
	[Ebene48] [varchar](50) NULL,
	[Ebene49] [varchar](50) NULL,
	[Ebene50] [varchar](50) NULL,
	[Ebene51] [varchar](50) NULL,
	[Ebene52] [varchar](50) NULL,
	[Ebene53] [varchar](50) NULL,
	[Ebene54] [varchar](50) NULL,
	[Ebene55] [varchar](50) NULL,
	[Ebene56] [varchar](50) NULL,
	[Ebene57] [varchar](50) NULL,
	[Ebene58] [varchar](50) NULL,
	[Ebene59] [varchar](50) NULL,
	[Ebene60] [varchar](50) NULL,
	[Ebene61] [varchar](50) NULL,
	[Ebene62] [varchar](50) NULL,
	[Ebene63] [varchar](50) NULL,
	[Ebene64] [varchar](50) NULL,
	[Ebene65] [varchar](50) NULL,
	[Ebene66] [varchar](50) NULL,
	[Ebene67] [varchar](50) NULL,
	[Ebene68] [varchar](50) NULL,
	[Ebene69] [varchar](50) NULL,
	[Ebene70] [varchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[Kontenrahmen_alt]    Script Date: 24.04.2019 11:47:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[Kontenrahmen_alt](
	[Konto_Nr] [varchar](100) NULL,
	[Konto_Bezeichnung] [varchar](100) NULL,
	[Konto_Art] [varchar](100) NULL,
	[Kostenstelle] [varchar](100) NULL,
	[STK] [varchar](100) NULL,
	[Konto_1] [varchar](100) NULL,
	[Konto_2] [varchar](100) NULL,
	[Konto_3] [varchar](100) NULL,
	[Konto_4] [varchar](100) NULL,
	[Konto_5] [varchar](100) NULL,
	[Ebene1] [varchar](100) NULL,
	[Ebene2] [varchar](100) NULL,
	[Ebene3] [varchar](100) NULL,
	[Ebene4] [varchar](100) NULL,
	[Ebene5] [varchar](100) NULL,
	[Ebene6] [varchar](100) NULL,
	[Ebene7] [varchar](100) NULL,
	[Ebene8] [varchar](100) NULL,
	[Ebene9] [varchar](100) NULL,
	[Ebene10] [varchar](100) NULL,
	[Ebene11] [varchar](100) NULL,
	[Ebene12] [varchar](100) NULL,
	[Ebene13] [varchar](100) NULL,
	[Ebene14] [varchar](100) NULL,
	[Ebene15] [varchar](100) NULL,
	[Ebene16] [varchar](100) NULL,
	[Ebene17] [varchar](100) NULL,
	[Ebene18] [varchar](100) NULL,
	[Ebene19] [varchar](100) NULL,
	[Ebene20] [varchar](100) NULL,
	[Ebene21] [varchar](100) NULL,
	[Ebene22] [varchar](100) NULL,
	[Ebene23] [varchar](100) NULL,
	[Ebene24] [varchar](100) NULL,
	[Ebene25] [varchar](100) NULL,
	[Ebene26] [varchar](100) NULL,
	[Ebene27] [varchar](100) NULL,
	[Ebene28] [varchar](100) NULL,
	[Ebene29] [varchar](100) NULL,
	[Ebene30] [varchar](100) NULL,
	[Ebene31] [varchar](100) NULL,
	[Ebene32] [varchar](100) NULL,
	[Ebene33] [varchar](100) NULL,
	[Ebene34] [varchar](200) NULL,
	[Ebene35] [varchar](100) NULL,
	[Ebene36] [varchar](100) NULL,
	[Ebene37] [varchar](100) NULL,
	[Ebene38] [varchar](100) NULL,
	[Ebene39] [varchar](100) NULL,
	[Ebene40] [varchar](100) NULL,
	[Ebene41] [varchar](100) NULL,
	[Ebene42] [varchar](100) NULL,
	[Ebene43] [varchar](100) NULL,
	[Ebene44] [varchar](100) NULL,
	[Ebene45] [varchar](100) NULL,
	[Ebene46] [varchar](100) NULL,
	[Ebene47] [varchar](100) NULL,
	[Ebene48] [varchar](100) NULL,
	[Ebene49] [varchar](100) NULL,
	[Ebene50] [varchar](100) NULL,
	[Ebene51] [varchar](100) NULL,
	[Ebene52] [varchar](100) NULL,
	[Ebene53] [varchar](100) NULL,
	[Ebene54] [varchar](100) NULL,
	[Ebene55] [varchar](100) NULL,
	[Ebene56] [varchar](100) NULL,
	[Ebene57] [varchar](100) NULL,
	[Ebene58] [varchar](100) NULL,
	[Ebene59] [varchar](100) NULL,
	[Ebene60] [varchar](100) NULL,
	[Ebene61] [varchar](100) NULL,
	[Ebene62] [varchar](100) NULL,
	[Ebene63] [varchar](100) NULL,
	[Ebene64] [varchar](100) NULL,
	[Ebene65] [varchar](100) NULL,
	[Ebene66] [varchar](100) NULL,
	[Ebene67] [varchar](100) NULL,
	[Ebene68] [varchar](100) NULL,
	[Ebene69] [varchar](100) NULL,
	[Ebene70] [varchar](100) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[Kontenrahmen_GC_Struct_SKR]    Script Date: 24.04.2019 11:47:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[Kontenrahmen_GC_Struct_SKR](
	[Konto Nr] [varchar](200) NULL,
	[Konto Bezeichnung] [varchar](200) NULL,
	[Konto Art_ori] [varchar](200) NULL,
	[Kostenstelle] [varchar](200) NULL,
	[Stk] [varchar](200) NULL,
	[Konto 1] [varchar](200) NULL,
	[Konto 2] [varchar](200) NULL,
	[Konto 3] [varchar](200) NULL,
	[Konto 4] [varchar](200) NULL,
	[Konto 5] [varchar](200) NULL,
	[Ebene1] [varchar](200) NULL,
	[Ebene2] [varchar](200) NULL,
	[Ebene3] [varchar](200) NULL,
	[Ebene4] [varchar](200) NULL,
	[Ebene5] [varchar](200) NULL,
	[Ebene6] [varchar](200) NULL,
	[Ebene7] [varchar](200) NULL,
	[Ebene8] [varchar](200) NULL,
	[Ebene9] [varchar](200) NULL,
	[Ebene10] [varchar](200) NULL,
	[Ebene11] [varchar](200) NULL,
	[Ebene12] [varchar](200) NULL,
	[Ebene13] [varchar](200) NULL,
	[Ebene14] [varchar](200) NULL,
	[Ebene15] [varchar](200) NULL,
	[Ebene16] [varchar](200) NULL,
	[Ebene17] [varchar](200) NULL,
	[Ebene18] [varchar](200) NULL,
	[Ebene19] [varchar](200) NULL,
	[Ebene20] [varchar](200) NULL,
	[Ebene21] [varchar](200) NULL,
	[Ebene22] [varchar](200) NULL,
	[Ebene23] [varchar](200) NULL,
	[Ebene24] [varchar](200) NULL,
	[Ebene25] [varchar](200) NULL,
	[Ebene26] [varchar](200) NULL,
	[Ebene27] [varchar](200) NULL,
	[Ebene28] [varchar](200) NULL,
	[Ebene29] [varchar](200) NULL,
	[Ebene30] [varchar](200) NULL,
	[Ebene31] [varchar](200) NULL,
	[Ebene32] [varchar](200) NULL,
	[Ebene33] [varchar](200) NULL,
	[Ebene34] [varchar](200) NULL,
	[Ebene35] [varchar](200) NULL,
	[Ebene36] [varchar](200) NULL,
	[Ebene37] [varchar](200) NULL,
	[Ebene38] [varchar](200) NULL,
	[Ebene39] [varchar](200) NULL,
	[Ebene40] [varchar](200) NULL,
	[Ebene41] [varchar](200) NULL,
	[Ebene42] [varchar](200) NULL,
	[Ebene43] [varchar](200) NULL,
	[Ebene44] [varchar](200) NULL,
	[Ebene45] [varchar](200) NULL,
	[Ebene46] [varchar](200) NULL,
	[Ebene47] [varchar](200) NULL,
	[Ebene48] [varchar](200) NULL,
	[Ebene49] [varchar](200) NULL,
	[Ebene50] [varchar](200) NULL,
	[Ebene51] [varchar](200) NULL,
	[Ebene52] [varchar](200) NULL,
	[Ebene53] [varchar](200) NULL,
	[Ebene54] [varchar](200) NULL,
	[Ebene55] [varchar](200) NULL,
	[Ebene56] [varchar](200) NULL,
	[Ebene57] [varchar](200) NULL,
	[Ebene58] [varchar](200) NULL,
	[Ebene59] [varchar](200) NULL,
	[Ebene60] [varchar](200) NULL,
	[Ebene61] [varchar](200) NULL,
	[Ebene62] [varchar](200) NULL,
	[Ebene63] [varchar](200) NULL,
	[Ebene64] [varchar](200) NULL,
	[Ebene65] [varchar](200) NULL,
	[Ebene66] [varchar](200) NULL,
	[Ebene67] [varchar](200) NULL,
	[Ebene68] [varchar](200) NULL,
	[Ebene69] [varchar](200) NULL,
	[Ebene70] [varchar](200) NULL,
	[Ebene71] [varchar](200) NULL,
	[Ebene72] [varchar](200) NULL,
	[Ebene73] [varchar](200) NULL,
	[Ebene74] [varchar](200) NULL,
	[Ebene75] [varchar](200) NULL,
	[Ebene76] [varchar](200) NULL,
	[Ebene77] [varchar](200) NULL,
	[Ebene78] [varchar](200) NULL,
	[Ebene79] [varchar](200) NULL,
	[Ebene80] [varchar](200) NULL,
	[Anzahl Stellen_Konto_Nr] [varchar](200) NULL,
	[Konto Art] [varchar](200) NULL,
	[GuV_Bilanz] [varchar](200) NULL,
	[Acct Nr] [varchar](200) NULL,
	[Konto] [varchar](200) NULL,
	[Susa] [varchar](200) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[Kontenrahmen_KST_90]    Script Date: 24.04.2019 11:47:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[Kontenrahmen_KST_90](
	[Konto_Nr] [varchar](200) NULL,
	[_90] [varchar](200) NULL,
	[Acct Nr] [varchar](200) NULL,
	[Konto_Bezeichnung] [varchar](200) NULL,
	[Konto_Art] [varchar](200) NULL,
	[Kostenstelle] [varchar](200) NULL,
	[STK] [varchar](200) NULL,
	[Konto_1] [varchar](200) NULL,
	[Konto_2] [varchar](200) NULL,
	[Konto_3] [varchar](200) NULL,
	[Konto_4] [varchar](200) NULL,
	[Konto_5] [varchar](200) NULL,
	[Ebene1] [varchar](200) NULL,
	[Ebene2] [varchar](200) NULL,
	[Ebene3] [varchar](200) NULL,
	[Ebene4] [varchar](200) NULL,
	[Ebene5] [varchar](200) NULL,
	[Ebene6] [varchar](200) NULL,
	[Ebene7] [varchar](200) NULL,
	[Ebene8] [varchar](200) NULL,
	[Ebene9] [varchar](200) NULL,
	[Ebene10] [varchar](200) NULL,
	[Ebene11] [varchar](200) NULL,
	[Ebene12] [varchar](200) NULL,
	[Ebene13] [varchar](200) NULL,
	[Ebene14] [varchar](200) NULL,
	[Ebene15] [varchar](200) NULL,
	[Ebene16] [varchar](200) NULL,
	[Ebene17] [varchar](200) NULL,
	[Ebene18] [varchar](200) NULL,
	[Ebene19] [varchar](200) NULL,
	[Ebene20] [varchar](200) NULL,
	[Ebene21] [varchar](200) NULL,
	[Ebene22] [varchar](200) NULL,
	[Ebene23] [varchar](200) NULL,
	[Ebene24] [varchar](200) NULL,
	[Ebene25] [varchar](200) NULL,
	[Ebene26] [varchar](200) NULL,
	[Ebene27] [varchar](200) NULL,
	[Ebene28] [varchar](200) NULL,
	[Ebene29] [varchar](200) NULL,
	[Ebene30] [varchar](200) NULL,
	[Ebene31] [varchar](200) NULL,
	[Ebene32] [varchar](200) NULL,
	[Ebene33] [varchar](200) NULL,
	[Ebene34] [varchar](200) NULL,
	[Ebene35] [varchar](200) NULL,
	[Ebene36] [varchar](200) NULL,
	[Ebene37] [varchar](200) NULL,
	[Ebene38] [varchar](200) NULL,
	[Ebene39] [varchar](200) NULL,
	[Ebene40] [varchar](200) NULL,
	[Ebene41] [varchar](200) NULL,
	[Ebene42] [varchar](200) NULL,
	[Ebene43] [varchar](200) NULL,
	[Ebene44] [varchar](200) NULL,
	[Ebene45] [varchar](200) NULL,
	[Ebene46] [varchar](200) NULL,
	[Ebene47] [varchar](200) NULL,
	[Ebene48] [varchar](200) NULL,
	[Ebene49] [varchar](200) NULL,
	[Ebene50] [varchar](200) NULL,
	[Ebene51] [varchar](200) NULL,
	[Ebene52] [varchar](200) NULL,
	[Ebene53] [varchar](200) NULL,
	[Ebene54] [varchar](200) NULL,
	[Ebene55] [varchar](200) NULL,
	[Ebene56] [varchar](200) NULL,
	[Ebene57] [varchar](200) NULL,
	[Ebene58] [varchar](200) NULL,
	[Ebene59] [varchar](200) NULL,
	[Ebene60] [varchar](200) NULL,
	[Ebene61] [varchar](200) NULL,
	[Ebene62] [varchar](200) NULL,
	[Ebene63] [varchar](200) NULL,
	[Ebene64] [varchar](200) NULL,
	[Ebene65] [varchar](200) NULL,
	[Ebene66] [varchar](200) NULL,
	[Ebene67] [varchar](200) NULL,
	[Ebene68] [varchar](200) NULL,
	[Ebene69] [varchar](200) NULL,
	[Ebene70] [varchar](200) NULL,
	[Ebene71] [varchar](200) NULL,
	[Ebene72] [varchar](200) NULL,
	[Ebene73] [varchar](200) NULL,
	[Ebene74] [varchar](200) NULL,
	[Ebene75] [varchar](200) NULL,
	[Ebene76] [varchar](200) NULL,
	[Ebene77] [varchar](200) NULL,
	[Ebene78] [varchar](200) NULL,
	[Ebene79] [varchar](200) NULL,
	[Ebene80] [varchar](200) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[Kontenrahmen_STK]    Script Date: 24.04.2019 11:47:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[Kontenrahmen_STK](
	[Konto_Nr] [varchar](100) NULL,
	[Konto_Bezeichnung] [varchar](100) NULL,
	[Konto_Art] [varchar](100) NULL,
	[Kostenstelle] [varchar](100) NULL,
	[STK] [varchar](100) NULL,
	[Konto_1] [varchar](100) NULL,
	[Konto_2] [varchar](100) NULL,
	[Konto_3] [varchar](100) NULL,
	[Konto_4] [varchar](100) NULL,
	[Konto_5] [varchar](100) NULL,
	[Ebene1] [varchar](100) NULL,
	[Ebene2] [varchar](100) NULL,
	[Ebene3] [varchar](100) NULL,
	[Ebene4] [varchar](100) NULL,
	[Ebene5] [varchar](100) NULL,
	[Ebene6] [varchar](100) NULL,
	[Ebene7] [varchar](100) NULL,
	[Ebene8] [varchar](100) NULL,
	[Ebene9] [varchar](100) NULL,
	[Ebene10] [varchar](100) NULL,
	[Ebene11] [varchar](100) NULL,
	[Ebene12] [varchar](100) NULL,
	[Ebene13] [varchar](100) NULL,
	[Ebene14] [varchar](100) NULL,
	[Ebene15] [varchar](100) NULL,
	[Ebene16] [varchar](100) NULL,
	[Ebene17] [varchar](100) NULL,
	[Ebene18] [varchar](100) NULL,
	[Ebene19] [varchar](100) NULL,
	[Ebene20] [varchar](100) NULL,
	[Ebene21] [varchar](100) NULL,
	[Ebene22] [varchar](100) NULL,
	[Ebene23] [varchar](100) NULL,
	[Ebene24] [varchar](100) NULL,
	[Ebene25] [varchar](100) NULL,
	[Ebene26] [varchar](100) NULL,
	[Ebene27] [varchar](100) NULL,
	[Ebene28] [varchar](100) NULL,
	[Ebene29] [varchar](100) NULL,
	[Ebene30] [varchar](100) NULL,
	[Ebene31] [varchar](100) NULL,
	[Ebene32] [varchar](100) NULL,
	[Ebene33] [varchar](100) NULL,
	[Ebene34] [varchar](100) NULL,
	[Ebene35] [varchar](100) NULL,
	[Ebene36] [varchar](100) NULL,
	[Ebene37] [varchar](100) NULL,
	[Ebene38] [varchar](100) NULL,
	[Ebene39] [varchar](100) NULL,
	[Ebene40] [varchar](100) NULL,
	[Ebene41] [varchar](100) NULL,
	[Ebene42] [varchar](100) NULL,
	[Ebene43] [varchar](100) NULL,
	[Ebene44] [varchar](100) NULL,
	[Ebene45] [varchar](100) NULL,
	[Ebene46] [varchar](100) NULL,
	[Ebene47] [varchar](100) NULL,
	[Ebene48] [varchar](100) NULL,
	[Ebene49] [varchar](100) NULL,
	[Ebene50] [varchar](100) NULL,
	[Ebene51] [varchar](100) NULL,
	[Ebene52] [varchar](100) NULL,
	[Ebene53] [varchar](100) NULL,
	[Ebene54] [varchar](100) NULL,
	[Ebene55] [varchar](100) NULL,
	[Ebene56] [varchar](100) NULL,
	[Ebene57] [varchar](100) NULL,
	[Ebene58] [varchar](100) NULL,
	[Ebene59] [varchar](100) NULL,
	[Ebene60] [varchar](100) NULL,
	[Ebene61] [varchar](100) NULL,
	[Ebene62] [varchar](100) NULL,
	[Ebene63] [varchar](100) NULL,
	[Ebene64] [varchar](100) NULL,
	[Ebene65] [varchar](100) NULL,
	[Ebene66] [varchar](100) NULL,
	[Ebene67] [varchar](100) NULL,
	[Ebene68] [varchar](100) NULL,
	[Ebene69] [varchar](100) NULL,
	[Ebene70] [varchar](100) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[Kontenrahmen_Stk_GC_Struct_SKR]    Script Date: 24.04.2019 11:47:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[Kontenrahmen_Stk_GC_Struct_SKR](
	[Konto Nr] [varchar](200) NULL,
	[Konto Bezeichnung] [varchar](200) NULL,
	[Konto Art_ori] [varchar](200) NULL,
	[Kostenstelle] [varchar](200) NULL,
	[Stk] [varchar](200) NULL,
	[Konto 1] [varchar](200) NULL,
	[Konto 2] [varchar](200) NULL,
	[Konto 3] [varchar](200) NULL,
	[Konto 4] [varchar](200) NULL,
	[Konto 5] [varchar](200) NULL,
	[Ebene1_ori] [varchar](200) NULL,
	[Ebene2_ori] [varchar](200) NULL,
	[Ebene3] [varchar](200) NULL,
	[Ebene4] [varchar](200) NULL,
	[Ebene5] [varchar](200) NULL,
	[Ebene6] [varchar](200) NULL,
	[Ebene7] [varchar](200) NULL,
	[Ebene8] [varchar](200) NULL,
	[Ebene9] [varchar](200) NULL,
	[Ebene10] [varchar](200) NULL,
	[Ebene11] [varchar](200) NULL,
	[Ebene12] [varchar](200) NULL,
	[Ebene13] [varchar](200) NULL,
	[Ebene14] [varchar](200) NULL,
	[Ebene15] [varchar](200) NULL,
	[Ebene16] [varchar](200) NULL,
	[Ebene17] [varchar](200) NULL,
	[Ebene18] [varchar](200) NULL,
	[Ebene19] [varchar](200) NULL,
	[Ebene20] [varchar](200) NULL,
	[Ebene21] [varchar](200) NULL,
	[Ebene22] [varchar](200) NULL,
	[Ebene23] [varchar](200) NULL,
	[Ebene24] [varchar](200) NULL,
	[Ebene25] [varchar](200) NULL,
	[Ebene26] [varchar](200) NULL,
	[Ebene27] [varchar](200) NULL,
	[Ebene28] [varchar](200) NULL,
	[Ebene29] [varchar](200) NULL,
	[Ebene30] [varchar](200) NULL,
	[Ebene31] [varchar](200) NULL,
	[Ebene32] [varchar](200) NULL,
	[Ebene33] [varchar](200) NULL,
	[Ebene34] [varchar](200) NULL,
	[Ebene35] [varchar](200) NULL,
	[Ebene36] [varchar](200) NULL,
	[Ebene37] [varchar](200) NULL,
	[Ebene38] [varchar](200) NULL,
	[Ebene39] [varchar](200) NULL,
	[Ebene40] [varchar](200) NULL,
	[Ebene41] [varchar](200) NULL,
	[Ebene42] [varchar](200) NULL,
	[Ebene43] [varchar](200) NULL,
	[Ebene44] [varchar](200) NULL,
	[Ebene45] [varchar](200) NULL,
	[Ebene46] [varchar](200) NULL,
	[Ebene47] [varchar](200) NULL,
	[Ebene48] [varchar](200) NULL,
	[Ebene49] [varchar](200) NULL,
	[Ebene50] [varchar](200) NULL,
	[Ebene51] [varchar](200) NULL,
	[Ebene52] [varchar](200) NULL,
	[Ebene53] [varchar](200) NULL,
	[Ebene54] [varchar](200) NULL,
	[Ebene55] [varchar](200) NULL,
	[Ebene56] [varchar](200) NULL,
	[Ebene57] [varchar](200) NULL,
	[Ebene58] [varchar](200) NULL,
	[Ebene59] [varchar](200) NULL,
	[Ebene60] [varchar](200) NULL,
	[Ebene61] [varchar](200) NULL,
	[Ebene62] [varchar](200) NULL,
	[Ebene63] [varchar](200) NULL,
	[Ebene64] [varchar](200) NULL,
	[Ebene65] [varchar](200) NULL,
	[Ebene66] [varchar](200) NULL,
	[Ebene67] [varchar](200) NULL,
	[Ebene68] [varchar](200) NULL,
	[Ebene69] [varchar](200) NULL,
	[Ebene70] [varchar](200) NULL,
	[Ebene71] [varchar](200) NULL,
	[Ebene72] [varchar](200) NULL,
	[Ebene73] [varchar](200) NULL,
	[Ebene74] [varchar](200) NULL,
	[Ebene75] [varchar](200) NULL,
	[Ebene76] [varchar](200) NULL,
	[Ebene77] [varchar](200) NULL,
	[Ebene78] [varchar](200) NULL,
	[Ebene79] [varchar](200) NULL,
	[Ebene80] [varchar](200) NULL,
	[Anzahl Stellen_Konto_Nr] [varchar](200) NULL,
	[Konto Art] [varchar](200) NULL,
	[GuV_Bilanz] [varchar](200) NULL,
	[Acct Nr] [varchar](200) NULL,
	[Konto] [varchar](200) NULL,
	[Susa] [varchar](200) NULL,
	[Ebene1] [varchar](200) NULL,
	[Ebene2] [varchar](200) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[Kontenrahmen_STKalt]    Script Date: 24.04.2019 11:47:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[Kontenrahmen_STKalt](
	[Konto_Nr] [varchar](100) NULL,
	[Konto_Bezeichnung] [varchar](100) NULL,
	[Konto_Art] [varchar](100) NULL,
	[Kostenstelle] [varchar](100) NULL,
	[STK] [varchar](100) NULL,
	[Konto_1] [varchar](100) NULL,
	[Konto_2] [varchar](100) NULL,
	[Konto_3] [varchar](100) NULL,
	[Konto_4] [varchar](100) NULL,
	[Konto_5] [varchar](100) NULL,
	[Ebene1] [varchar](100) NULL,
	[Ebene2] [varchar](100) NULL,
	[Ebene3] [varchar](100) NULL,
	[Ebene4] [varchar](100) NULL,
	[Ebene5] [varchar](100) NULL,
	[Ebene6] [varchar](100) NULL,
	[Ebene7] [varchar](100) NULL,
	[Ebene8] [varchar](100) NULL,
	[Ebene9] [varchar](100) NULL,
	[Ebene10] [varchar](100) NULL,
	[Ebene11] [varchar](100) NULL,
	[Ebene12] [varchar](100) NULL,
	[Ebene13] [varchar](100) NULL,
	[Ebene14] [varchar](100) NULL,
	[Ebene15] [varchar](100) NULL,
	[Ebene16] [varchar](100) NULL,
	[Ebene17] [varchar](100) NULL,
	[Ebene18] [varchar](100) NULL,
	[Ebene19] [varchar](100) NULL,
	[Ebene20] [varchar](100) NULL,
	[Ebene21] [varchar](100) NULL,
	[Ebene22] [varchar](100) NULL,
	[Ebene23] [varchar](100) NULL,
	[Ebene24] [varchar](100) NULL,
	[Ebene25] [varchar](100) NULL,
	[Ebene26] [varchar](100) NULL,
	[Ebene27] [varchar](100) NULL,
	[Ebene28] [varchar](100) NULL,
	[Ebene29] [varchar](100) NULL,
	[Ebene30] [varchar](100) NULL,
	[Ebene31] [varchar](100) NULL,
	[Ebene32] [varchar](100) NULL,
	[Ebene33] [varchar](100) NULL,
	[Ebene34] [varchar](100) NULL,
	[Ebene35] [varchar](100) NULL,
	[Ebene36] [varchar](100) NULL,
	[Ebene37] [varchar](100) NULL,
	[Ebene38] [varchar](100) NULL,
	[Ebene39] [varchar](100) NULL,
	[Ebene40] [varchar](100) NULL,
	[Ebene41] [varchar](100) NULL,
	[Ebene42] [varchar](100) NULL,
	[Ebene43] [varchar](100) NULL,
	[Ebene44] [varchar](100) NULL,
	[Ebene45] [varchar](100) NULL,
	[Ebene46] [varchar](100) NULL,
	[Ebene47] [varchar](100) NULL,
	[Ebene48] [varchar](100) NULL,
	[Ebene49] [varchar](100) NULL,
	[Ebene50] [varchar](100) NULL,
	[Ebene51] [varchar](100) NULL,
	[Ebene52] [varchar](100) NULL,
	[Ebene53] [varchar](100) NULL,
	[Ebene54] [varchar](100) NULL,
	[Ebene55] [varchar](100) NULL,
	[Ebene56] [varchar](100) NULL,
	[Ebene57] [varchar](100) NULL,
	[Ebene58] [varchar](100) NULL,
	[Ebene59] [varchar](100) NULL,
	[Ebene60] [varchar](100) NULL,
	[Ebene61] [varchar](100) NULL,
	[Ebene62] [varchar](100) NULL,
	[Ebene63] [varchar](100) NULL,
	[Ebene64] [varchar](100) NULL,
	[Ebene65] [varchar](100) NULL,
	[Ebene66] [varchar](100) NULL,
	[Ebene67] [varchar](100) NULL,
	[Ebene68] [varchar](100) NULL,
	[Ebene69] [varchar](100) NULL,
	[Ebene70] [varchar](100) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[NW_AE]    Script Date: 24.04.2019 11:47:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[NW_AE](
	[Hauptbetrieb] [varchar](100) NULL,
	[Standort] [varchar](100) NULL,
	[Code_verkäufer_einkäufer] [varchar](100) NULL,
	[Name_verkäufer_einkäufer] [varchar](100) NULL,
	[Verkäufer] [varchar](100) NULL,
	[Markencode_FZG] [varchar](100) NULL,
	[Fabrikat] [varchar](100) NULL,
	[Kunde] [varchar](100) NULL,
	[FZG] [varchar](100) NULL,
	[Fahrzeugstatus] [varchar](100) NULL,
	[Statistikgruppe] [varchar](100) NULL,
	[Erstzulassung] [datetime] NULL,
	[Anzahl Vorbesitzer] [varchar](100) NULL,
	[Lagerbuchungsgruppe] [varchar](100) NULL,
	[Fahrzeugtyp] [varchar](100) NULL,
	[Produktbuchungsgruppe] [varchar](100) NULL,
	[Fahrzeugart] [varchar](100) NULL,
	[Kundenart] [varchar](100) NULL,
	[Fahrzeugtyp_1] [varchar](100) NULL,
	[FZG_Detail_1] [varchar](300) NULL,
	[Menge] [varchar](100) NULL,
	[Belegart] [varchar](100) NULL,
	[Nr] [varchar](100) NULL,
	[Verk An Deb -nr] [varchar](100) NULL,
	[Rech An Deb -nr] [varchar](100) NULL,
	[Rech An Name] [varchar](100) NULL,
	[Rech An Name 2] [varchar](100) NULL,
	[Auftragsdatum] [datetime] NULL,
	[Buchungsdatum] [datetime] NULL,
	[Lieferdatum] [datetime] NULL,
	[Lagerortcode] [varchar](100) NULL,
	[Kostenstellencode] [varchar](100) NULL,
	[Markencode] [varchar](100) NULL,
	[Debitorenbuchungsgruppe] [varchar](100) NULL,
	[Vk-preise Inkl Mwst] [decimal](28, 8) NULL,
	[Mengenrabatt Zulassen] [varchar](100) NULL,
	[Verkäufercode] [varchar](100) NULL,
	[Auftragsgruppe] [varchar](100) NULL,
	[Rechnung] [varchar](100) NULL,
	[Buchungsnr] [varchar](100) NULL,
	[Letzte Buchungsnr] [varchar](100) NULL,
	[Sammelrechnung] [varchar](100) NULL,
	[Geschäftsbuchungsgruppe] [varchar](100) NULL,
	[Verk An Name] [varchar](100) NULL,
	[Verk An Name 2] [varchar](100) NULL,
	[Belegdatum] [datetime] NULL,
	[Reservieren] [varchar](100) NULL,
	[Fahrgestellnummer] [varchar](100) NULL,
	[Amtliches Kennzeichen] [varchar](100) NULL,
	[Modell] [varchar](100) NULL,
	[Auftragsart] [varchar](100) NULL,
	[Kundenbestätigungdatum] [datetime] NULL,
	[Bestellart] [varchar](100) NULL,
	[Erstes Lieferdatum] [datetime] NULL,
	[Letztes Lieferdatum] [datetime] NULL,
	[Hauptlieferdatum] [datetime] NULL,
	[Fahrzeug Vk-preisdatum] [datetime] NULL,
	[Finanzierung Leasing] [varchar](100) NULL,
	[Model_ori] [varchar](100) NULL,
	[Modell_FZG] [varchar](100) NULL,
	[FZG_Detail] [varchar](300) NULL,
	[Beschreibung] [varchar](100) NULL,
	[Zeilennr] [varchar](100) NULL,
	[Model] [varchar](100) NULL,
	[Markencode_Zeile] [varchar](100) NULL,
	[Auftragsbestand] [varchar](100) NULL,
	[Fahrzeugtyp_1_neu] [varchar](100) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[NW_AE_Archiv]    Script Date: 24.04.2019 11:47:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[NW_AE_Archiv](
	[Belegart] [varchar](100) NULL,
	[Nr] [varchar](100) NULL,
	[Verk An Deb -nr] [varchar](100) NULL,
	[Rech An Deb -nr] [varchar](100) NULL,
	[Rech An Name] [varchar](100) NULL,
	[Rech An Name 2] [varchar](100) NULL,
	[Auftragsdatum] [datetime] NULL,
	[Buchungsdatum] [datetime] NULL,
	[Lieferdatum] [datetime] NULL,
	[Lagerortcode] [varchar](100) NULL,
	[Kostenstellencode] [varchar](100) NULL,
	[Markencode] [varchar](100) NULL,
	[Debitorenbuchungsgruppe] [varchar](100) NULL,
	[Vk-preise Inkl Mwst] [varchar](100) NULL,
	[Mengenrabatt Zulassen] [varchar](100) NULL,
	[Verkäufercode] [varchar](100) NULL,
	[Auftragsgruppe] [varchar](100) NULL,
	[Rechnung] [varchar](100) NULL,
	[Buchungsnr] [varchar](100) NULL,
	[Letzte Buchungsnr] [varchar](100) NULL,
	[Sammelrechnung] [varchar](100) NULL,
	[Geschäftsbuchungsgruppe] [varchar](100) NULL,
	[Verk An Name] [varchar](100) NULL,
	[Verk An Name 2] [varchar](100) NULL,
	[Belegdatum] [datetime] NULL,
	[Archivierungsdatum] [datetime] NULL,
	[Arch Durch Benutzer] [varchar](100) NULL,
	[Archivierungsgrund] [varchar](100) NULL,
	[Fahrgestellnummer] [varchar](100) NULL,
	[Amtliches Kennzeichen] [varchar](100) NULL,
	[Modell] [varchar](100) NULL,
	[Auftragsart] [varchar](100) NULL,
	[Kundenbestätigungdatum] [datetime] NULL,
	[Bestellart] [varchar](100) NULL,
	[Erstes Lieferdatum] [datetime] NULL,
	[Letztes Lieferdatum] [datetime] NULL,
	[Haupt Lieferdatum] [datetime] NULL,
	[Fahrzeug Vk-preisdatum] [datetime] NULL,
	[Finanzierung Leasing] [varchar](100) NULL,
	[Vermittlung] [varchar](100) NULL,
	[Hauptbetrieb] [varchar](100) NULL,
	[Standort] [varchar](100) NULL,
	[Code_verkäufer_einkäufer] [varchar](100) NULL,
	[Name_verkäufer_einkäufer] [varchar](100) NULL,
	[Verkäufer] [varchar](100) NULL,
	[Markencode_FZG] [varchar](100) NULL,
	[Fabrikat] [varchar](100) NULL,
	[Model] [varchar](100) NULL,
	[Kunde] [varchar](100) NULL,
	[FZG] [varchar](100) NULL,
	[Fahrzeugstatus] [varchar](100) NULL,
	[Statistikgruppe] [varchar](100) NULL,
	[Erstzulassung] [datetime] NULL,
	[Anzahl Vorbesitzer] [varchar](100) NULL,
	[Lagerbuchungsgruppe] [varchar](100) NULL,
	[Fahrzeugtyp] [varchar](100) NULL,
	[Produktbuchungsgruppe] [varchar](100) NULL,
	[Fahrzeugart] [varchar](100) NULL,
	[Kundenart] [varchar](100) NULL,
	[Fahrzeugtyp_1] [varchar](100) NULL,
	[FZG_Detail] [varchar](300) NULL,
	[Menge] [varchar](100) NULL,
	[Fahrzeugtyp_1_neu] [varchar](100) NULL,
	[Maximum_Auftragsdatum] [datetime] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[NW_GW_EDS_Bilanz_Bestand_mit_15100_15200]    Script Date: 24.04.2019 11:47:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[NW_GW_EDS_Bilanz_Bestand_mit_15100_15200](
	[Nr] [varchar](100) NULL,
	[Name] [varchar](100) NULL,
	[Kontoart] [varchar](100) NULL,
	[Guv Bilanz] [varchar](100) NULL,
	[Soll Haben] [varchar](100) NULL,
	[Kostenstellen Buchung] [varchar](100) NULL,
	[Lfd Nr] [varchar](100) NULL,
	[Sachkontonr] [varchar](100) NULL,
	[Buchungsdatum] [datetime] NULL,
	[Belegart] [varchar](100) NULL,
	[Belegnr] [varchar](100) NULL,
	[Beschreibung] [varchar](100) NULL,
	[Gegenkontonr] [varchar](100) NULL,
	[Betrag_ori] [decimal](28, 8) NULL,
	[Kostenstellencode] [varchar](100) NULL,
	[Markencode] [varchar](100) NULL,
	[Benutzer Id] [varchar](100) NULL,
	[Herkunftscode] [varchar](100) NULL,
	[Nachbuchung] [varchar](100) NULL,
	[Menge_ori] [varchar](100) NULL,
	[Mwst Betrag] [decimal](28, 8) NULL,
	[Buchungsart] [varchar](100) NULL,
	[Geschäftsbuchungsgruppe] [varchar](100) NULL,
	[Produktbuchungsgruppe_FIBU] [varchar](100) NULL,
	[Gegenkontoart] [varchar](100) NULL,
	[Transaktionsnr] [varchar](100) NULL,
	[Sollbetrag] [decimal](28, 8) NULL,
	[Habenbetrag] [decimal](28, 8) NULL,
	[Belegdatum] [datetime] NULL,
	[Externe Belegnummer] [varchar](100) NULL,
	[Herkunftsart] [varchar](100) NULL,
	[Herkunftsnr] [varchar](100) NULL,
	[Filialcode] [varchar](100) NULL,
	[Hauptbereich] [varchar](100) NULL,
	[Fahrgestellnummer] [varchar](100) NULL,
	[Buchnummer] [varchar](100) NULL,
	[Fahrzeug-kz] [varchar](100) NULL,
	[Umgebucht] [varchar](100) NULL,
	[Storniert] [varchar](100) NULL,
	[Fahrzeugklassecode] [varchar](100) NULL,
	[Code] [varchar](100) NULL,
	[Name2] [varchar](100) NULL,
	[Code2] [varchar](100) NULL,
	[Bezeichnung] [varchar](100) NULL,
	[Betrag_1] [decimal](28, 8) NULL,
	[Hauptbetrieb] [varchar](100) NULL,
	[Standort] [varchar](100) NULL,
	[Betrieb_1] [varchar](100) NULL,
	[Marke_ori] [varchar](100) NULL,
	[Mandant] [varchar](100) NULL,
	[Menge_1] [varchar](100) NULL,
	[Bookkeep Date] [datetime] NULL,
	[Text] [varchar](100) NULL,
	[KST_aus_Code] [varchar](100) NULL,
	[Kostenstelle_ori] [varchar](100) NULL,
	[KST_1] [varchar](100) NULL,
	[KST_2] [varchar](100) NULL,
	[Acct Nr] [varchar](100) NULL,
	[Betrag] [decimal](28, 8) NULL,
	[Menge_ori2] [varchar](100) NULL,
	[Betrieb] [varchar](100) NULL,
	[Benutzer] [varchar](100) NULL,
	[Fabrikat] [varchar](100) NULL,
	[Fahrzeugstatus] [varchar](100) NULL,
	[Model] [varchar](100) NULL,
	[Fahrzeugart] [varchar](100) NULL,
	[Konto] [varchar](100) NULL,
	[Verkaufsdatum] [varchar](100) NULL,
	[Produktbuchungsgruppe] [varchar](100) NULL,
	[Fahrzeugtyp] [varchar](100) NULL,
	[FZG] [varchar](100) NULL,
	[Fahrgestellnummer_FZG] [varchar](100) NULL,
	[Fahrzeugtyp_1] [varchar](100) NULL,
	[Einkaufslieferdatum_FZG] [datetime] NULL,
	[Heute] [datetime] NULL,
	[Standtage] [varchar](100) NULL,
	[Standtagestaffel] [varchar](100) NULL,
	[Ausstattungscode] [varchar](100) NULL,
	[Ausstattungskennzeichen] [varchar](100) NULL,
	[Beschreibung_Ausstattung] [varchar](100) NULL,
	[Farbe] [varchar](100) NULL,
	[Standort_1] [varchar](100) NULL,
	[Lagerortcode] [varchar](100) NULL,
	[Markencode_FZG] [varchar](100) NULL,
	[Betrag_gesamt] [decimal](28, 8) NULL,
	[Nr_Lieferant] [varchar](100) NULL,
	[Name_Lieferant_ori] [varchar](100) NULL,
	[Text 1] [varchar](100) NULL,
	[Text 2] [varchar](100) NULL,
	[Text 3] [varchar](100) NULL,
	[Text 4] [varchar](100) NULL,
	[Verkäufernr Einkauf] [varchar](100) NULL,
	[Name_Einkäufer] [varchar](100) NULL,
	[Text_2_ohne_€] [varchar](100) NULL,
	[Text_2_ohne_ ] [varchar](100) NULL,
	[Text_2_ohne_,00] [varchar](100) NULL,
	[Plan VK Netz brutto] [varchar](100) NULL,
	[Plan VK Netz netto] [varchar](100) NULL,
	[Text_3_ohne_€] [varchar](100) NULL,
	[Text_3_ohne_ ] [varchar](100) NULL,
	[Text_3_ohne_,00] [varchar](100) NULL,
	[Plan Vk Platz brutto] [varchar](100) NULL,
	[Plan VK Platz netto] [varchar](100) NULL,
	[Modell_Beschreibung] [varchar](100) NULL,
	[Lieferant Einkäufer] [varchar](100) NULL,
	[Berechnungszahl_FZG] [varchar](100) NULL,
	[UST Netz] [varchar](100) NULL,
	[Km-stand] [varchar](100) NULL,
	[Hubraum (ccm)] [varchar](100) NULL,
	[Motorartcode] [varchar](100) NULL,
	[Leistung (kw)] [varchar](100) NULL,
	[Leistung (ps)] [varchar](100) NULL,
	[Einsatz ber ] [decimal](28, 8) NULL,
	[Erstzulassung] [datetime] NULL,
	[Jahr EZ] [varchar](100) NULL,
	[Monat EZ] [varchar](100) NULL,
	[Name_Lieferant] [varchar](100) NULL,
	[Aktuelle Filialbuchnummer] [varchar](100) NULL,
	[Aktuelle Buchnummer] [varchar](100) NULL,
	[Eüp_ori] [varchar](100) NULL,
	[Zbv-text 1] [varchar](100) NULL,
	[Zbv-text 2] [varchar](100) NULL,
	[EÜP_zwischen] [varchar](100) NULL,
	[EÜP] [varchar](100) NULL,
	[Kostenstellencode_FZG] [varchar](100) NULL,
	[FZG_Herkunft] [varchar](100) NULL,
	[EZ] [varchar](100) NULL,
	[FZG_Einkäufer] [varchar](100) NULL,
	[Datum letzte Preisänderung] [datetime] NULL,
	[int  Aufwendungen] [decimal](28, 8) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[NW_GW_EDS_FIBU_Verkauf]    Script Date: 24.04.2019 11:47:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[NW_GW_EDS_FIBU_Verkauf](
	[Nr] [varchar](100) NULL,
	[Name] [varchar](100) NULL,
	[Kontoart] [varchar](100) NULL,
	[Guv Bilanz] [varchar](100) NULL,
	[Soll Haben] [varchar](100) NULL,
	[Kostenstellen Buchung] [varchar](100) NULL,
	[Lfd Nr] [varchar](100) NULL,
	[Sachkontonr] [varchar](100) NULL,
	[Buchungsdatum] [datetime] NULL,
	[Belegart] [varchar](100) NULL,
	[Belegnr] [varchar](100) NULL,
	[Beschreibung] [varchar](100) NULL,
	[Gegenkontonr] [varchar](100) NULL,
	[Betrag_ori] [decimal](28, 8) NULL,
	[Kostenstellencode] [varchar](100) NULL,
	[Markencode] [varchar](100) NULL,
	[Benutzer Id] [varchar](100) NULL,
	[Herkunftscode] [varchar](100) NULL,
	[Nachbuchung] [varchar](100) NULL,
	[Menge_ori] [varchar](100) NULL,
	[Mwst Betrag] [decimal](28, 8) NULL,
	[Buchungsart] [varchar](100) NULL,
	[Geschäftsbuchungsgruppe] [varchar](100) NULL,
	[Produktbuchungsgruppe_FIBU] [varchar](100) NULL,
	[Gegenkontoart] [varchar](100) NULL,
	[Transaktionsnr] [varchar](100) NULL,
	[Sollbetrag] [decimal](28, 8) NULL,
	[Habenbetrag] [decimal](28, 8) NULL,
	[Belegdatum] [datetime] NULL,
	[Externe Belegnummer] [varchar](100) NULL,
	[Herkunftsart] [varchar](100) NULL,
	[Herkunftsnr] [varchar](100) NULL,
	[Filialcode] [varchar](100) NULL,
	[Hauptbereich] [varchar](100) NULL,
	[Fahrgestellnummer] [varchar](100) NULL,
	[Buchnummer] [varchar](100) NULL,
	[Fahrzeug-kz] [varchar](100) NULL,
	[Umgebucht] [varchar](100) NULL,
	[Storniert] [varchar](100) NULL,
	[Fahrzeugklassecode] [varchar](100) NULL,
	[Code] [varchar](100) NULL,
	[Name2] [varchar](100) NULL,
	[Code2] [varchar](100) NULL,
	[Bezeichnung] [varchar](100) NULL,
	[Betrag_1] [decimal](28, 8) NULL,
	[Hauptbetrieb] [varchar](100) NULL,
	[Standort] [varchar](100) NULL,
	[Betrieb_1] [varchar](100) NULL,
	[Marke_ori] [varchar](100) NULL,
	[Mandant] [varchar](100) NULL,
	[Menge_1] [varchar](100) NULL,
	[Bookkeep Date] [datetime] NULL,
	[Text] [varchar](100) NULL,
	[KST_aus_Code] [varchar](100) NULL,
	[Kostenstelle_ori] [varchar](100) NULL,
	[KST_1] [varchar](100) NULL,
	[KST_2] [varchar](100) NULL,
	[Acct Nr] [varchar](100) NULL,
	[Betrag] [decimal](28, 8) NULL,
	[Menge] [varchar](100) NULL,
	[Betrieb] [varchar](100) NULL,
	[Benutzer] [varchar](100) NULL,
	[Fabrikat] [varchar](100) NULL,
	[Fahrzeugstatus] [varchar](100) NULL,
	[Model] [varchar](100) NULL,
	[Fahrzeugart] [varchar](100) NULL,
	[Konto] [varchar](100) NULL,
	[Verkaufsdatum] [datetime] NULL,
	[Produktbuchungsgruppe] [varchar](100) NULL,
	[Fahrzeugtyp] [varchar](100) NULL,
	[FZG] [varchar](100) NULL,
	[Fahrgestellnummer_FZG] [varchar](100) NULL,
	[Fahrzeugtyp_1] [varchar](100) NULL,
	[Einkaufslieferdatum_FZG] [datetime] NULL,
	[Heute] [datetime] NULL,
	[Standtage] [varchar](100) NULL,
	[Standtagestaffel] [varchar](100) NULL,
	[Ausstattungscode] [varchar](100) NULL,
	[Ausstattungskennzeichen] [varchar](100) NULL,
	[Beschreibung_Ausstattung] [varchar](100) NULL,
	[Farbe] [varchar](100) NULL,
	[Standort_1] [varchar](100) NULL,
	[Lagerortcode] [varchar](100) NULL,
	[Markencode_FZG] [varchar](100) NULL,
	[FZG_KZ_Summe] [varchar](100) NULL,
	[Verkäufer Nr Verkauf] [varchar](100) NULL,
	[Code_Verkäufer] [varchar](100) NULL,
	[Name_Verkäufer] [varchar](100) NULL,
	[Verkäufer] [varchar](100) NULL,
	[Debitorennr_FZG] [varchar](100) NULL,
	[Nr_Deb] [varchar](100) NULL,
	[Name_Deb] [varchar](100) NULL,
	[Kunde] [varchar](100) NULL,
	[Kundenart] [varchar](100) NULL,
	[Anzahl Vorbesitzer] [varchar](100) NULL,
	[Edv Nummer] [varchar](100) NULL,
	[Aktuelle Filialbuchnummer] [varchar](100) NULL,
	[Alter Fahrzeugstatus] [varchar](100) NULL,
	[Alte Debitorennr] [varchar](100) NULL,
	[Altes Verkaufsdatum] [datetime] NULL,
	[Alter Eigenverkauf] [varchar](100) NULL,
	[Alte Buchnummer] [varchar](100) NULL,
	[Alte Filialbuchnummer] [varchar](100) NULL,
	[Aktuelle Buchnummer] [varchar](100) NULL,
	[Einkaufscode] [varchar](100) NULL,
	[Tage Buchungs_Verkaufsdatum] [varchar](100) NULL,
	[Fahrzeugart_Konto] [varchar](100) NULL,
	[zwei_mal_verkauft] [varchar](100) NULL,
	[raus?] [varchar](100) NULL,
	[Gesamterlöse] [decimal](28, 8) NULL,
	[Erlös FZG] [decimal](28, 8) NULL,
	[Einsatz Gesamt] [decimal](28, 8) NULL,
	[Einsatz FZG] [decimal](28, 8) NULL,
	[Erlös Garantie] [decimal](28, 8) NULL,
	[Erlös Provision] [decimal](28, 8) NULL,
	[Erlös Sonstiges] [decimal](28, 8) NULL,
	[Einsatz Sonstiges] [decimal](28, 8) NULL,
	[Invoice Date] [datetime] NULL,
	[Instands  Werkstatt] [decimal](28, 8) NULL,
	[Instands  Teile] [decimal](28, 8) NULL,
	[Instandsetzung ges ] [decimal](28, 8) NULL,
	[Alte Debitorennr2] [varchar](100) NULL,
	[Name_Vorbesitzer] [varchar](100) NULL,
	[Vorbesitzername] [varchar](100) NULL,
	[Verkäufernr Einkauf] [varchar](100) NULL,
	[Code_Einkäufer] [varchar](100) NULL,
	[Name_Einkäufer] [varchar](100) NULL,
	[Einkäufer Vorbesitzer] [varchar](100) NULL,
	[FZG_Detail] [varchar](200) NULL,
	[Einsatz Garantie] [varchar](100) NULL,
	[Summe Erlös FZG] [decimal](28, 8) NULL,
	[Plz Code_Deb] [varchar](100) NULL,
	[PLZ_1] [varchar](100) NULL,
	[PLZ_2] [varchar](100) NULL,
	[PLZ_3] [varchar](100) NULL,
	[PLZ_4] [varchar](100) NULL,
	[Modell_Beschreibung] [varchar](100) NULL,
	[Nr_Lieferant] [varchar](100) NULL,
	[Name_Lieferant_ori] [varchar](100) NULL,
	[Name_Lieferant] [varchar](100) NULL,
	[DB1] [decimal](28, 8) NULL,
	[Summe DB1] [decimal](28, 8) NULL,
	[DB1 < 0] [varchar](100) NULL,
	[Text 3] [varchar](100) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[NW_GW_EDS_FIBU_Verkauf_KER]    Script Date: 24.04.2019 11:47:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[NW_GW_EDS_FIBU_Verkauf_KER](
	[Nr] [varchar](100) NULL,
	[Name] [varchar](100) NULL,
	[Kontoart] [varchar](100) NULL,
	[Guv Bilanz] [varchar](100) NULL,
	[Soll Haben] [varchar](100) NULL,
	[Kostenstellen Buchung] [varchar](100) NULL,
	[Lfd Nr] [varchar](100) NULL,
	[Sachkontonr] [varchar](100) NULL,
	[Buchungsdatum] [datetime] NULL,
	[Belegart] [varchar](100) NULL,
	[Belegnr] [varchar](100) NULL,
	[Beschreibung] [varchar](100) NULL,
	[Gegenkontonr] [varchar](100) NULL,
	[Betrag_ori] [decimal](28, 8) NULL,
	[Kostenstellencode] [varchar](100) NULL,
	[Markencode] [varchar](100) NULL,
	[Benutzer Id] [varchar](100) NULL,
	[Herkunftscode] [varchar](100) NULL,
	[Nachbuchung] [varchar](100) NULL,
	[Menge_ori] [varchar](100) NULL,
	[Mwst Betrag] [decimal](28, 8) NULL,
	[Buchungsart] [varchar](100) NULL,
	[Geschäftsbuchungsgruppe] [varchar](100) NULL,
	[Produktbuchungsgruppe_FIBU] [varchar](100) NULL,
	[Gegenkontoart] [varchar](100) NULL,
	[Transaktionsnr] [varchar](100) NULL,
	[Sollbetrag] [decimal](28, 8) NULL,
	[Habenbetrag] [decimal](28, 8) NULL,
	[Belegdatum] [datetime] NULL,
	[Externe Belegnummer] [varchar](100) NULL,
	[Herkunftsart] [varchar](100) NULL,
	[Herkunftsnr] [varchar](100) NULL,
	[Filialcode] [varchar](100) NULL,
	[Hauptbereich] [varchar](100) NULL,
	[Fahrgestellnummer] [varchar](100) NULL,
	[Buchnummer] [varchar](100) NULL,
	[Fahrzeug-kz] [varchar](100) NULL,
	[Umgebucht] [varchar](100) NULL,
	[Storniert] [varchar](100) NULL,
	[Fahrzeugklassecode] [varchar](100) NULL,
	[Code] [varchar](100) NULL,
	[Name2] [varchar](100) NULL,
	[Code2] [varchar](100) NULL,
	[Bezeichnung] [varchar](100) NULL,
	[Betrag_1] [decimal](28, 8) NULL,
	[Hauptbetrieb] [varchar](100) NULL,
	[Standort_alt] [varchar](100) NULL,
	[Betrieb_1] [varchar](100) NULL,
	[Marke_ori] [varchar](100) NULL,
	[Mandant] [varchar](100) NULL,
	[Menge_1] [varchar](100) NULL,
	[Bookkeep Date] [datetime] NULL,
	[Text] [varchar](100) NULL,
	[KST_aus_Code] [varchar](100) NULL,
	[Kostenstelle_ori] [varchar](100) NULL,
	[KST_1] [varchar](100) NULL,
	[KST_2] [varchar](100) NULL,
	[Acct Nr] [varchar](100) NULL,
	[Betrag] [decimal](28, 8) NULL,
	[Menge] [varchar](100) NULL,
	[Betrieb] [varchar](100) NULL,
	[Benutzer] [varchar](100) NULL,
	[Fabrikat] [varchar](100) NULL,
	[Fahrzeugstatus] [varchar](100) NULL,
	[Model] [varchar](100) NULL,
	[Fahrzeugart] [varchar](100) NULL,
	[Konto] [varchar](100) NULL,
	[Verkaufsdatum] [datetime] NULL,
	[Produktbuchungsgruppe] [varchar](100) NULL,
	[Fahrzeugtyp] [varchar](100) NULL,
	[FZG] [varchar](100) NULL,
	[Fahrgestellnummer_FZG] [varchar](100) NULL,
	[Fahrzeugtyp_1] [varchar](100) NULL,
	[Einkaufslieferdatum_FZG] [datetime] NULL,
	[Heute] [datetime] NULL,
	[Standtage] [varchar](100) NULL,
	[Standtagestaffel] [varchar](100) NULL,
	[Ausstattungscode] [varchar](100) NULL,
	[Ausstattungskennzeichen] [varchar](100) NULL,
	[Beschreibung_Ausstattung] [varchar](100) NULL,
	[Farbe] [varchar](100) NULL,
	[Standort_1] [varchar](100) NULL,
	[Lagerortcode] [varchar](100) NULL,
	[Markencode_FZG] [varchar](100) NULL,
	[FZG_KZ_Summe] [varchar](100) NULL,
	[Verkäufer Nr Verkauf] [varchar](100) NULL,
	[Code_Verkäufer] [varchar](100) NULL,
	[Name_Verkäufer] [varchar](100) NULL,
	[Verkäufer] [varchar](100) NULL,
	[Debitorennr_FZG] [varchar](100) NULL,
	[Nr_Deb] [varchar](100) NULL,
	[Name_Deb] [varchar](100) NULL,
	[Kunde] [varchar](100) NULL,
	[Kundenart] [varchar](100) NULL,
	[Anzahl Vorbesitzer] [varchar](100) NULL,
	[Edv Nummer] [varchar](100) NULL,
	[Aktuelle Filialbuchnummer] [varchar](100) NULL,
	[Alter Fahrzeugstatus] [varchar](100) NULL,
	[Alte Debitorennr] [varchar](100) NULL,
	[Altes Verkaufsdatum] [datetime] NULL,
	[Alter Eigenverkauf] [varchar](100) NULL,
	[Alte Buchnummer] [varchar](100) NULL,
	[Alte Filialbuchnummer] [varchar](100) NULL,
	[Aktuelle Buchnummer] [varchar](100) NULL,
	[Einkaufscode] [varchar](100) NULL,
	[Tage Buchungs_Verkaufsdatum] [varchar](100) NULL,
	[Fahrzeugart_Konto] [varchar](100) NULL,
	[zwei_mal_verkauft] [varchar](100) NULL,
	[raus?] [varchar](100) NULL,
	[Gesamterlöse] [decimal](28, 8) NULL,
	[Erlös FZG] [decimal](28, 8) NULL,
	[Einsatz Gesamt] [decimal](28, 8) NULL,
	[Einsatz FZG] [decimal](28, 8) NULL,
	[Erlös Garantie] [decimal](28, 8) NULL,
	[Erlös Provision] [decimal](28, 8) NULL,
	[Erlös Sonstiges] [decimal](28, 8) NULL,
	[Einsatz Sonstiges] [decimal](28, 8) NULL,
	[Invoice Date] [datetime] NULL,
	[Instands  Werkstatt] [varchar](100) NULL,
	[Instands  Teile] [varchar](100) NULL,
	[Instandsetzung ges ] [varchar](100) NULL,
	[Alte Debitorennr2] [varchar](100) NULL,
	[Name_Vorbesitzer] [varchar](100) NULL,
	[Vorbesitzername] [varchar](100) NULL,
	[Verkäufernr Einkauf] [varchar](100) NULL,
	[Code_Einkäufer] [varchar](100) NULL,
	[Name_Einkäufer] [varchar](100) NULL,
	[Einkäufer Vorbesitzer] [varchar](100) NULL,
	[FZG_Detail] [varchar](300) NULL,
	[Einsatz Garantie] [varchar](100) NULL,
	[Summe Erlös FZG] [decimal](28, 8) NULL,
	[Plz Code_Deb] [varchar](100) NULL,
	[PLZ_1] [varchar](100) NULL,
	[PLZ_2] [varchar](100) NULL,
	[PLZ_3] [varchar](100) NULL,
	[PLZ_4] [varchar](100) NULL,
	[Modell_Beschreibung] [varchar](100) NULL,
	[Nr_Lieferant] [varchar](100) NULL,
	[Name_Lieferant_ori] [varchar](100) NULL,
	[Name_Lieferant] [varchar](100) NULL,
	[DB1] [decimal](28, 8) NULL,
	[Summe DB1] [decimal](28, 8) NULL,
	[DB1 < 0] [varchar](100) NULL,
	[Standort] [varchar](100) NULL,
	[Mb Makecode] [varchar](100) NULL,
	[Mb Locationcode] [varchar](100) NULL,
	[Mb Costcentercode] [varchar](100) NULL,
	[Mb Distributionchannelcode] [varchar](100) NULL,
	[Mb Costunitcode] [varchar](100) NULL,
	[Modelllinie] [varchar](100) NULL,
	[Mb Makecode2] [varchar](100) NULL,
	[Code_Cost_Unit] [varchar](100) NULL,
	[Description_Cost_Unit] [varchar](100) NULL,
	[umsatzabh  Kosten] [decimal](28, 8) NULL,
	[dir  Kosten] [decimal](28, 8) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[offene_Auftraege_EDS]    Script Date: 24.04.2019 11:47:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[offene_Auftraege_EDS](
	[Belegart] [varchar](100) NULL,
	[Nr] [varchar](100) NULL,
	[Verk An Deb -nr] [varchar](100) NULL,
	[Rech An Deb -nr] [varchar](100) NULL,
	[Rech An Name] [varchar](100) NULL,
	[Auftragsdatum] [datetime] NULL,
	[Buchungsdatum] [datetime] NULL,
	[Buchungsbeschreibung] [varchar](100) NULL,
	[Lagerortcode] [varchar](100) NULL,
	[Kostenstellencode] [varchar](100) NULL,
	[Markencode] [varchar](100) NULL,
	[Verkäufercode] [varchar](100) NULL,
	[Buchungsnr] [varchar](100) NULL,
	[Letzte Lieferscheinnr] [varchar](100) NULL,
	[Letzte Buchungsnr] [varchar](100) NULL,
	[Storno] [varchar](100) NULL,
	[Belegdatum] [datetime] NULL,
	[Externe Belegnummer] [varchar](100) NULL,
	[Nummernserie] [varchar](100) NULL,
	[Buchungsnr Serie] [varchar](100) NULL,
	[Lieferungsnr Serie] [varchar](100) NULL,
	[Benutzer Id] [varchar](100) NULL,
	[Ordertype] [varchar](100) NULL,
	[Werkstattbuchungsgruppe] [varchar](100) NULL,
	[Deaktivierungsdatum] [datetime] NULL,
	[Aktivierungsdatum] [datetime] NULL,
	[Fahrgestellnummer] [varchar](100) NULL,
	[Amtliches Kennzeichen] [varchar](100) NULL,
	[Km-stand] [varchar](100) NULL,
	[Modellcode] [varchar](100) NULL,
	[Fahrzeugmodellnr] [varchar](100) NULL,
	[Baujahr] [datetime] NULL,
	[Modell] [varchar](100) NULL,
	[Typ] [varchar](100) NULL,
	[Erstzulassung] [datetime] NULL,
	[Produktbuchungsgruppe] [varchar](100) NULL,
	[Auftragsuhrzeit] [datetime] NULL,
	[Abholdatum] [datetime] NULL,
	[Abholuhrzeit] [datetime] NULL,
	[Serviceberaternr] [varchar](100) NULL,
	[Fertigstellungsdatum] [datetime] NULL,
	[Datum Kundenzulassung] [datetime] NULL,
	[Fahrzeugklassencode] [varchar](100) NULL,
	[Fahrzeugartencode] [varchar](100) NULL,
	[Aw Typ] [varchar](100) NULL,
	[Aw Verrechnungscode] [varchar](100) NULL,
	[Aw Preisgruppe] [varchar](100) NULL,
	[Aktivierung] [varchar](100) NULL,
	[Buchnummer] [varchar](100) NULL,
	[Filialbuchnummer] [varchar](100) NULL,
	[Kostenstellencode Verkauf] [varchar](100) NULL,
	[Aw Preisgruppe Int Verr] [varchar](100) NULL,
	[Serviceberaternr Planung] [varchar](100) NULL,
	[Filialcode] [varchar](100) NULL,
	[Arbeiten Erledigt] [varchar](100) NULL,
	[Statuscode] [varchar](100) NULL,
	[Serviceberaternr Abholung] [varchar](100) NULL,
	[Filialcode Verkauf] [varchar](100) NULL,
	[Erstes Lieferdatum] [datetime] NULL,
	[Letztes Lieferdatum] [datetime] NULL,
	[Fahrer] [varchar](100) NULL,
	[Hauptbetrieb] [varchar](100) NULL,
	[Standort] [varchar](100) NULL,
	[Nr2] [varchar](100) NULL,
	[Vorname] [varchar](100) NULL,
	[Nachname] [varchar](100) NULL,
	[Serviceberater] [varchar](100) NULL,
	[Order Number] [varchar](100) NULL,
	[Markencode2] [varchar](100) NULL,
	[Fabrikat] [varchar](100) NULL,
	[Model] [varchar](100) NULL,
	[Fahrzeug] [varchar](100) NULL,
	[KST_aus_Code] [varchar](100) NULL,
	[Kostenstelle] [varchar](100) NULL,
	[Marke] [varchar](100) NULL,
	[Kunde] [varchar](100) NULL,
	[Anzahl Tage_ori] [varchar](100) NULL,
	[Durchgänge (Auftrag)_ori] [varchar](100) NULL,
	[erledigt_ja_nein] [varchar](100) NULL,
	[DG_2] [varchar](100) NULL,
	[Durchgänge (Auftrag)] [decimal](28, 8) NULL,
	[Belegart2] [varchar](100) NULL,
	[Belegnr] [varchar](100) NULL,
	[Zeilennr] [varchar](100) NULL,
	[Art] [varchar](100) NULL,
	[Nr3] [varchar](100) NULL,
	[Auftragsdatum2] [datetime] NULL,
	[Beschreibung] [varchar](100) NULL,
	[Einheit] [varchar](100) NULL,
	[Menge] [decimal](28, 8) NULL,
	[Vk-preis] [decimal](28, 8) NULL,
	[Mengenrabatt %] [decimal](28, 8) NULL,
	[Zeilenrabatt %] [decimal](28, 8) NULL,
	[Zeilenrabattbetrag] [decimal](28, 8) NULL,
	[Betrag] [decimal](28, 8) NULL,
	[Summe  (Betrag) Nr 2] [decimal](28, 8) NULL,
	[Summe  (Betrag) Nr 1] [decimal](28, 8) NULL,
	[Geschäftsbuchungsgruppe] [varchar](100) NULL,
	[Produktbuchungsgruppe2] [varchar](100) NULL,
	[Menge (basis)] [decimal](28, 8) NULL,
	[Vorgabezeit] [decimal](28, 8) NULL,
	[Menge Pro Stunde] [decimal](28, 8) NULL,
	[Menge (stunde)] [decimal](28, 8) NULL,
	[Kostenlos] [decimal](28, 8) NULL,
	[Arbeitswerte] [decimal](28, 8) NULL,
	[Teile] [decimal](28, 8) NULL,
	[Fremdl ] [decimal](28, 8) NULL,
	[Anzahl Tage] [decimal](28, 8) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[offene_Auftraege_EDS_C11]    Script Date: 24.04.2019 11:47:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[offene_Auftraege_EDS_C11](
	[Belegart] [varchar](100) NULL,
	[Nr] [varchar](100) NULL,
	[Verk An Deb -nr] [varchar](100) NULL,
	[Rech An Deb -nr] [varchar](100) NULL,
	[Rech An Name] [varchar](100) NULL,
	[Auftragsdatum] [datetime] NULL,
	[Buchungsdatum] [datetime] NULL,
	[Buchungsbeschreibung] [varchar](100) NULL,
	[Lagerortcode] [varchar](100) NULL,
	[Kostenstellencode] [varchar](100) NULL,
	[Verkäufercode] [varchar](100) NULL,
	[Buchungsnr] [varchar](100) NULL,
	[Letzte Lieferscheinnr] [varchar](100) NULL,
	[Letzte Buchungsnr] [varchar](100) NULL,
	[Storno] [varchar](100) NULL,
	[Belegdatum] [datetime] NULL,
	[Externe Belegnummer] [varchar](100) NULL,
	[Nummernserie] [varchar](100) NULL,
	[Buchungsnr Serie] [varchar](100) NULL,
	[Lieferungsnr Serie] [varchar](100) NULL,
	[Benutzer Id] [varchar](100) NULL,
	[Ordertype] [varchar](100) NULL,
	[Werkstattbuchungsgruppe] [varchar](100) NULL,
	[Deaktivierungsdatum] [datetime] NULL,
	[Aktivierungsdatum] [datetime] NULL,
	[Fahrgestellnummer] [varchar](100) NULL,
	[Amtliches Kennzeichen] [varchar](100) NULL,
	[Km-stand] [varchar](100) NULL,
	[Modellcode] [varchar](100) NULL,
	[Fahrzeugmodellnr] [varchar](100) NULL,
	[Baujahr] [varchar](100) NULL,
	[Modell] [varchar](100) NULL,
	[Typ] [varchar](100) NULL,
	[Erstzulassung] [varchar](100) NULL,
	[Produktbuchungsgruppe] [varchar](100) NULL,
	[Auftragsuhrzeit] [varchar](100) NULL,
	[Abholdatum] [datetime] NULL,
	[Abholuhrzeit] [varchar](100) NULL,
	[Serviceberaternr] [varchar](100) NULL,
	[Fertigstellungsdatum] [datetime] NULL,
	[Datum Kundenzulassung] [varchar](100) NULL,
	[Fahrzeugklassencode] [varchar](100) NULL,
	[Fahrzeugartencode] [varchar](100) NULL,
	[Aw Typ] [varchar](100) NULL,
	[Aw Verrechnungscode] [varchar](100) NULL,
	[Aw Preisgruppe] [varchar](100) NULL,
	[Aktivierung] [varchar](100) NULL,
	[Buchnummer] [varchar](100) NULL,
	[Filialbuchnummer] [varchar](100) NULL,
	[Kostenstellencode Verkauf] [varchar](100) NULL,
	[Aw Preisgruppe Int Verr] [varchar](100) NULL,
	[Serviceberaternr Planung] [varchar](100) NULL,
	[Filialcode] [varchar](100) NULL,
	[Arbeiten Erledigt] [varchar](100) NULL,
	[Statuscode] [varchar](100) NULL,
	[Serviceberaternr Abholung] [varchar](100) NULL,
	[Filialcode Verkauf] [varchar](100) NULL,
	[Erstes Lieferdatum] [datetime] NULL,
	[Letztes Lieferdatum] [datetime] NULL,
	[Fahrer] [varchar](100) NULL,
	[Hauptbetrieb] [varchar](100) NULL,
	[Standort] [varchar](100) NULL,
	[Nr2] [varchar](100) NULL,
	[Vorname] [varchar](100) NULL,
	[Nachname] [varchar](100) NULL,
	[Serviceberater] [varchar](100) NULL,
	[Order Number] [varchar](100) NULL,
	[Markencode] [varchar](100) NULL,
	[Fabrikat] [varchar](100) NULL,
	[Model] [varchar](100) NULL,
	[Fahrzeug] [varchar](100) NULL,
	[KST_aus_Code] [varchar](100) NULL,
	[Kostenstelle] [varchar](100) NULL,
	[Marke] [varchar](100) NULL,
	[Kunde] [varchar](100) NULL,
	[Anzahl Tage_ori] [varchar](100) NULL,
	[Durchgänge (Auftrag)_ori] [varchar](100) NULL,
	[erledigt_ja_nein] [varchar](100) NULL,
	[DG_2] [varchar](100) NULL,
	[Durchgänge (Auftrag)] [decimal](28, 8) NULL,
	[Belegart2] [varchar](100) NULL,
	[Belegnr] [varchar](100) NULL,
	[Zeilennr] [varchar](100) NULL,
	[Art] [varchar](100) NULL,
	[Nr3] [varchar](100) NULL,
	[Auftragsdatum2] [datetime] NULL,
	[Beschreibung] [varchar](100) NULL,
	[Einheit] [varchar](100) NULL,
	[Menge] [decimal](28, 8) NULL,
	[Vk-preis] [decimal](28, 8) NULL,
	[Mengenrabatt %] [decimal](28, 8) NULL,
	[Zeilenrabatt %] [decimal](28, 8) NULL,
	[Zeilenrabattbetrag] [decimal](28, 8) NULL,
	[Betrag] [decimal](28, 8) NULL,
	[Summe  (Betrag) Nr 2] [decimal](28, 8) NULL,
	[Summe  (Betrag) Nr 1] [decimal](28, 8) NULL,
	[Geschäftsbuchungsgruppe] [varchar](100) NULL,
	[Produktbuchungsgruppe2] [varchar](100) NULL,
	[Menge (basis)] [decimal](28, 8) NULL,
	[Vorgabezeit] [decimal](28, 8) NULL,
	[Menge Pro Stunde] [decimal](28, 8) NULL,
	[Menge (stunde)] [decimal](28, 8) NULL,
	[Kostenlos] [decimal](28, 8) NULL,
	[Arbeitswerte] [decimal](28, 8) NULL,
	[Teile] [decimal](28, 8) NULL,
	[Fremdl ] [decimal](28, 8) NULL,
	[Anzahl Tage] [decimal](28, 8) NULL,
	[Date] [datetime] NULL,
	[Company_ID] [varchar](100) NULL,
	[Department_ID] [varchar](100) NULL,
	[Employee_Function] [varchar](100) NULL,
	[Service_Advisor_Name] [varchar](100) NULL,
	[Turnover_Type_Desc] [varchar](100) NULL,
	[Order_Desc] [varchar](100) NULL,
	[Kostenstellencode_Werkstattzeile] [varchar](100) NULL,
	[Cost_Centre_Name] [varchar](100) NULL,
	[Make_Desc] [varchar](100) NULL,
	[Job_Amount] [decimal](28, 8) NULL,
	[Parts_Amount] [decimal](28, 8) NULL,
	[Parts_Purch_Amount] [decimal](28, 8) NULL,
	[Misc_Amount] [decimal](28, 8) NULL,
	[verk  Std ] [decimal](28, 8) NULL,
	[Order_Count] [decimal](28, 8) NULL,
	[Days_Since_Date] [decimal](28, 8) NULL,
	[Geschäftsbuchungsgruppe_Kopf] [varchar](100) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[OP_EDS]    Script Date: 24.04.2019 11:47:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[OP_EDS](
	[Nr] [varchar](100) NULL,
	[Name] [varchar](100) NULL,
	[Lfd Nr] [varchar](100) NULL,
	[Debitorennr] [varchar](100) NULL,
	[Buchungsdatum] [varchar](100) NULL,
	[Belegart] [varchar](100) NULL,
	[Belegnr] [varchar](100) NULL,
	[Beschreibung] [varchar](100) NULL,
	[Betrag] [varchar](100) NULL,
	[Restbetrag] [varchar](100) NULL,
	[Kostenstellencode] [varchar](100) NULL,
	[Markencode] [varchar](100) NULL,
	[Verkäufercode] [varchar](100) NULL,
	[Benutzer Id] [varchar](100) NULL,
	[Herkunftscode] [varchar](100) NULL,
	[Offen] [varchar](100) NULL,
	[Fälligkeitsdatum] [varchar](100) NULL,
	[Gegenkontoart] [varchar](100) NULL,
	[Gegenkontonr] [varchar](100) NULL,
	[Transaktionsnr] [varchar](100) NULL,
	[Sollbetrag] [varchar](100) NULL,
	[Habenbetrag] [varchar](100) NULL,
	[Belegdatum] [varchar](100) NULL,
	[Externe Belegnummer] [varchar](100) NULL,
	[Filialcode] [varchar](100) NULL,
	[Hauptbereich] [varchar](100) NULL,
	[Kundengruppencode] [varchar](100) NULL,
	[Fahrgestellnummer] [varchar](100) NULL,
	[Kassenbelegnr] [varchar](100) NULL,
	[Bemerkung] [varchar](100) NULL,
	[Hauptbetrieb] [varchar](100) NULL,
	[Betrieb] [varchar](100) NULL,
	[Bookkeep Date] [varchar](100) NULL,
	[Filial-Code] [varchar](100) NULL,
	[Filialbezeichnung] [varchar](100) NULL,
	[Standort] [varchar](100) NULL,
	[Verkäufer-Code] [varchar](100) NULL,
	[Verkäufer-Name] [varchar](100) NULL,
	[Sel Name_Verkauf] [varchar](100) NULL,
	[Kunde] [varchar](100) NULL,
	[Fälligkeit_Zeichen] [varchar](100) NULL,
	[Beleg] [varchar](100) NULL,
	[KST-Code] [varchar](100) NULL,
	[KST-Name] [varchar](100) NULL,
	[KST_1] [varchar](100) NULL,
	[Kostenstelle] [varchar](100) NULL,
	[Heute] [varchar](100) NULL,
	[Tage] [varchar](100) NULL,
	[Staffel] [varchar](100) NULL,
	[Rechnungsbetrag] [varchar](100) NULL,
	[KD-Gruppen-Code] [varchar](100) NULL,
	[KD-Gruppe-Beschreibung] [varchar](100) NULL,
	[Sel Name_ori] [varchar](100) NULL,
	[Bereich] [varchar](100) NULL,
	[Gesamtsaldo Kunde] [varchar](100) NULL,
	[Nachname] [varchar](100) NULL,
	[Vorname] [varchar](100) NULL,
	[Sel Name] [varchar](100) NULL,
	[Abwarten] [varchar](100) NULL,
	[Forderungsart] [varchar](100) NULL,
	[offen2] [varchar](100) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[Service_Ausgangsrechnung_C11]    Script Date: 24.04.2019 11:47:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[Service_Ausgangsrechnung_C11](
	[Nr_Rechnung] [varchar](100) NULL,
	[Verk An Deb -nr] [varchar](100) NULL,
	[Rech An Deb -nr] [varchar](100) NULL,
	[Auftragsdatum] [datetime] NULL,
	[Buchungsdatum] [datetime] NULL,
	[Lieferdatum] [datetime] NULL,
	[Buchungsbeschreibung] [varchar](100) NULL,
	[Markencode] [varchar](100) NULL,
	[Debitorenbuchungsgruppe] [varchar](100) NULL,
	[Geschäftsbuchungsgruppe] [varchar](100) NULL,
	[Belegdatum] [datetime] NULL,
	[Benutzer Id] [varchar](100) NULL,
	[Fahrgestellnummer] [varchar](100) NULL,
	[Amtliches Kennzeichen] [varchar](100) NULL,
	[Modell] [varchar](100) NULL,
	[Werkstattauftragsnummer] [varchar](100) NULL,
	[Kundengruppencode] [varchar](100) NULL,
	[Filialcode] [varchar](100) NULL,
	[Serviceberaternr] [varchar](100) NULL,
	[Nr_Rechnungskunde] [varchar](100) NULL,
	[Name_Rechnungskunde] [varchar](100) NULL,
	[Geschäftsbuchungsgruppe_Rechnungskunde] [varchar](100) NULL,
	[Plz Code_Rechnungskunde] [varchar](100) NULL,
	[Nachname_Rechnungskunde] [varchar](100) NULL,
	[Vorname_Rechnungskunde] [varchar](100) NULL,
	[Kundenart_Rechnungskunde] [varchar](100) NULL,
	[Nr_Fahrer] [varchar](100) NULL,
	[Name_Fahrer] [varchar](100) NULL,
	[Geschäftsbuchungsgruppe_Fahrer] [varchar](100) NULL,
	[Plz Code_Fahrer] [varchar](100) NULL,
	[Nachname_Fahrer] [varchar](100) NULL,
	[Vorname_Fahrer] [varchar](100) NULL,
	[Kundenart_Fahrer] [varchar](100) NULL,
	[Kundengruppe_Rechnungskunde] [varchar](100) NULL,
	[Kundengruppe_Fahrer] [varchar](100) NULL,
	[Hauptbetrieb] [varchar](100) NULL,
	[Standort] [varchar](100) NULL,
	[Nr_Employee] [varchar](100) NULL,
	[Vorname_Employee] [varchar](100) NULL,
	[Nachname_Employee] [varchar](100) NULL,
	[Funktion_Employee] [varchar](100) NULL,
	[Serviceberater] [varchar](100) NULL,
	[Umsatzart] [varchar](100) NULL,
	[Erstzulassung] [datetime] NULL,
	[Fahrzeugalter_Tage] [varchar](100) NULL,
	[Fahrzeugalter] [decimal](28, 8) NULL,
	[FZG-Altersstaffel] [varchar](100) NULL,
	[Marke] [varchar](100) NULL,
	[Fabrikat] [varchar](100) NULL,
	[Rechnung_Gutschrift] [varchar](100) NULL,
	[Auftragsstatus] [varchar](100) NULL,
	[Auftragsart] [varchar](100) NULL,
	[Ländercode_Fahrer] [varchar](100) NULL,
	[Land] [varchar](100) NULL,
	[PLZ_1_Stelle] [varchar](100) NULL,
	[PLZ_2_Stelle] [varchar](100) NULL,
	[PLZ_3_Stelle] [varchar](100) NULL,
	[PLZ_4_Stelle] [varchar](100) NULL,
	[PLZ] [varchar](100) NULL,
	[Zeilennr] [varchar](100) NULL,
	[Werkst Auftragsnr_Verk_Rg_Zeile] [varchar](100) NULL,
	[Werkst Auftragszeilennr_Verk_Rg_Zeile] [varchar](100) NULL,
	[Art] [varchar](100) NULL,
	[Nr_APO_Teile] [varchar](100) NULL,
	[Beschreibung] [varchar](100) NULL,
	[Einheit] [varchar](100) NULL,
	[Menge_alles] [decimal](28, 8) NULL,
	[Einstandspreis (mw)] [decimal](28, 8) NULL,
	[Betrag] [decimal](28, 8) NULL,
	[Kostenstellencode] [varchar](100) NULL,
	[Produktbuchungsgruppe] [varchar](100) NULL,
	[Einstandspreis] [decimal](28, 8) NULL,
	[Umsatz Lohn] [decimal](28, 8) NULL,
	[Umsatz Teile] [decimal](28, 8) NULL,
	[Umsatz Sonst ] [decimal](28, 8) NULL,
	[verk  Std ] [decimal](28, 8) NULL,
	[Menge_Werkstattposten] [decimal](28, 8) NULL,
	[Einstandsbetrag_Werkstattposten] [decimal](28, 8) NULL,
	[Einsatz Teile] [decimal](28, 8) NULL,
	[Menge Pro Stunde] [varchar](100) NULL,
	[Menge (stunde)] [varchar](100) NULL,
	[Auftragsnr_Werkstattposten] [varchar](100) NULL,
	[Auftragszeilennr_Werkstattposten] [varchar](100) NULL,
	[Vorgabezeit_Arb_Wertposten] [decimal](28, 8) NULL,
	[Ist-zeit_Arb_Wertposten] [varchar](100) NULL,
	[ben  Zeit] [varchar](100) NULL,
	[Menge_Teile] [decimal](28, 8) NULL,
	[DG_1] [varchar](100) NULL,
	[DG_2] [varchar](100) NULL,
	[DG] [decimal](28, 8) NULL,
	[Nr_Artikel] [varchar](100) NULL,
	[Gmpd Code_Artikel] [varchar](100) NULL,
	[Gmpd Subcode_Artikel] [varchar](100) NULL,
	[Bonuscode_Artikel] [varchar](100) NULL,
	[GMPD_Group] [varchar](100) NULL,
	[Repair_Group_Desc] [varchar](100) NULL,
	[DB1_><_EK] [varchar](100) NULL,
	[Date] [datetime] NULL,
	[Company_ID] [varchar](100) NULL,
	[Department_ID] [varchar](100) NULL,
	[Employee_Function] [varchar](100) NULL,
	[Service_Advisor_Name] [varchar](100) NULL,
	[Turnover_Type_Desc] [varchar](100) NULL,
	[Order_Desc_100] [varchar](100) NULL,
	[Invoice_Desc_100] [varchar](100) NULL,
	[Order_Desc_30] [varchar](100) NULL,
	[Invoice_Desc_30] [varchar](100) NULL,
	[Cost_Centre_ID] [varchar](100) NULL,
	[Make_Desc] [varchar](100) NULL,
	[Make_Group] [varchar](100) NULL,
	[Model_Desc] [varchar](100) NULL,
	[Customer_Group_Owner] [varchar](100) NULL,
	[Customer_Name_Owner] [varchar](100) NULL,
	[Cust_Zipcode_Country] [varchar](100) NULL,
	[Cust_Zipcode_First] [varchar](100) NULL,
	[Cust_Zipcode_Second] [varchar](100) NULL,
	[Cust_Zipcode_Third] [varchar](100) NULL,
	[Cust_Zipcode_Fourth] [varchar](100) NULL,
	[Cust_Zipcode] [varchar](100) NULL,
	[Car_Age] [varchar](100) NULL,
	[Werkstattbuchungsgruppe] [varchar](100) NULL,
	[Parts_Number] [varchar](100) NULL,
	[Invoice_Credit_Note] [varchar](100) NULL,
	[Sign_DB1] [varchar](100) NULL,
	[Order_Status] [varchar](100) NULL,
	[Order_Type_Desc] [varchar](100) NULL,
	[Job_Amount] [decimal](28, 8) NULL,
	[Parts_Amount] [decimal](28, 8) NULL,
	[Parts_Purch_Amount] [decimal](28, 8) NULL,
	[Misc_Amount] [decimal](28, 8) NULL,
	[Invoiced_Time] [decimal](28, 8) NULL,
	[Used_Time] [decimal](28, 8) NULL,
	[Quantity] [decimal](28, 8) NULL,
	[Order_Count] [decimal](28, 8) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[Service_Gutschriften_C11]    Script Date: 24.04.2019 11:47:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[Service_Gutschriften_C11](
	[Nr_Rechnungskunde] [varchar](100) NULL,
	[Name_Rechnungskunde] [varchar](100) NULL,
	[Geschäftsbuchungsgruppe_Rechnungskunde] [varchar](100) NULL,
	[Plz Code_Rechnungskunde] [varchar](100) NULL,
	[Nachname_Rechnungskunde] [varchar](100) NULL,
	[Vorname_Rechnungskunde] [varchar](100) NULL,
	[Kundenart_Rechnungskunde] [varchar](100) NULL,
	[Nr_Fahrer] [varchar](100) NULL,
	[Name_Fahrer] [varchar](100) NULL,
	[Geschäftsbuchungsgruppe_Fahrer] [varchar](100) NULL,
	[Plz Code_Fahrer] [varchar](100) NULL,
	[Nachname_Fahrer] [varchar](100) NULL,
	[Vorname_Fahrer] [varchar](100) NULL,
	[Kundenart_Fahrer] [varchar](100) NULL,
	[Kundengruppe_Rechnungskunde] [varchar](100) NULL,
	[Kundengruppe_Fahrer] [varchar](100) NULL,
	[Hauptbetrieb] [varchar](100) NULL,
	[Standort] [varchar](100) NULL,
	[Nr_Employee] [varchar](100) NULL,
	[Vorname_Employee] [varchar](100) NULL,
	[Nachname_Employee] [varchar](100) NULL,
	[Funktion_Employee] [varchar](100) NULL,
	[Serviceberater] [varchar](100) NULL,
	[Umsatzart] [varchar](100) NULL,
	[Erstzulassung] [datetime] NULL,
	[Fahrzeugalter_Tage] [varchar](100) NULL,
	[Fahrzeugalter] [varchar](100) NULL,
	[FZG-Altersstaffel] [varchar](100) NULL,
	[Marke] [varchar](100) NULL,
	[Fabrikat] [varchar](100) NULL,
	[Rechnung_Gutschrift] [varchar](100) NULL,
	[Auftragsstatus] [varchar](100) NULL,
	[Auftragsart] [varchar](100) NULL,
	[Ländercode_Fahrer] [varchar](100) NULL,
	[Land] [varchar](100) NULL,
	[PLZ_1_Stelle] [varchar](100) NULL,
	[PLZ_2_Stelle] [varchar](100) NULL,
	[PLZ_3_Stelle] [varchar](100) NULL,
	[PLZ_4_Stelle] [varchar](100) NULL,
	[PLZ] [varchar](100) NULL,
	[Menge_Werkstattposten] [decimal](28, 8) NULL,
	[Einstandsbetrag_Werkstattposten] [decimal](28, 8) NULL,
	[Einsatz Teile] [decimal](28, 8) NULL,
	[Menge_Teile] [decimal](28, 8) NULL,
	[DG_1] [varchar](100) NULL,
	[DG_2] [varchar](100) NULL,
	[DG] [decimal](28, 8) NULL,
	[Nr_Artikel] [varchar](100) NULL,
	[Gmpd Code_Artikel] [varchar](100) NULL,
	[Gmpd Subcode_Artikel] [varchar](100) NULL,
	[Bonuscode_Artikel] [varchar](100) NULL,
	[GMPD_Group] [varchar](100) NULL,
	[Repair_Group_Desc] [varchar](100) NULL,
	[DB1_><_EK] [varchar](100) NULL,
	[Date] [datetime] NULL,
	[Company_ID] [varchar](100) NULL,
	[Department_ID] [varchar](100) NULL,
	[Employee_Function] [varchar](100) NULL,
	[Service_Advisor_Name] [varchar](100) NULL,
	[Turnover_Type_Desc] [varchar](100) NULL,
	[Order_Desc_100] [varchar](100) NULL,
	[Invoice_Desc_100] [varchar](100) NULL,
	[Order_Desc_30] [varchar](100) NULL,
	[Invoice_Desc_30] [varchar](100) NULL,
	[Cost_Centre_ID] [varchar](100) NULL,
	[Make_Desc] [varchar](100) NULL,
	[Make_Group] [varchar](100) NULL,
	[Model_Desc] [varchar](100) NULL,
	[Customer_Group_Owner] [varchar](100) NULL,
	[Customer_Name_Owner] [varchar](100) NULL,
	[Cust_Zipcode_Country] [varchar](100) NULL,
	[Cust_Zipcode_First] [varchar](100) NULL,
	[Cust_Zipcode_Second] [varchar](100) NULL,
	[Cust_Zipcode_Third] [varchar](100) NULL,
	[Cust_Zipcode_Fourth] [varchar](100) NULL,
	[Cust_Zipcode] [varchar](100) NULL,
	[Car_Age] [varchar](100) NULL,
	[Nr_Gutschrift] [varchar](100) NULL,
	[Verk An Deb -nr] [varchar](100) NULL,
	[Rech An Deb -nr] [varchar](100) NULL,
	[Buchungsdatum] [datetime] NULL,
	[Lieferdatum] [datetime] NULL,
	[Buchungsbeschreibung] [varchar](100) NULL,
	[Markencode] [varchar](100) NULL,
	[Debitorenbuchungsgruppe] [varchar](100) NULL,
	[Geschäftsbuchungsgruppe] [varchar](100) NULL,
	[Belegdatum] [datetime] NULL,
	[Benutzer Id] [varchar](100) NULL,
	[Fahrgestellnummer] [varchar](100) NULL,
	[Amtliches Kennzeichen] [varchar](100) NULL,
	[Modell] [varchar](100) NULL,
	[Werkstattauftragsnummer] [varchar](100) NULL,
	[Filialcode] [varchar](100) NULL,
	[Serviceberaternr] [varchar](100) NULL,
	[Zeilennr] [varchar](100) NULL,
	[Werkst Auftragsnr_Verk_Rg_Zeile] [varchar](100) NULL,
	[Werkst Auftragszeilennr_Verk_Rg_Zeile] [varchar](100) NULL,
	[Art] [varchar](100) NULL,
	[Nr_APO_Teile] [varchar](100) NULL,
	[Beschreibung] [varchar](100) NULL,
	[Einheit] [varchar](100) NULL,
	[Menge_alles] [decimal](28, 8) NULL,
	[Einstandspreis (mw)] [decimal](28, 8) NULL,
	[Betrag] [decimal](28, 8) NULL,
	[Kostenstellencode] [varchar](100) NULL,
	[Produktbuchungsgruppe] [varchar](100) NULL,
	[Einstandspreis] [decimal](28, 8) NULL,
	[Umsatz Lohn] [decimal](28, 8) NULL,
	[Umsatz Teile] [decimal](28, 8) NULL,
	[Umsatz Sonst ] [decimal](28, 8) NULL,
	[verk  Std ] [decimal](28, 8) NULL,
	[Ausgleich-mit Belegnr] [varchar](100) NULL,
	[Ist-zeit_Arb_Wert_Posten] [varchar](100) NULL,
	[Belegnr_Arb_Wert_Posten] [varchar](100) NULL,
	[ben  Zeit] [varchar](100) NULL,
	[ja nein] [varchar](100) NULL,
	[Parts_Number] [varchar](100) NULL,
	[Invoice_Credit_Note] [varchar](100) NULL,
	[Sign_DB1] [varchar](100) NULL,
	[Order_Status] [varchar](100) NULL,
	[Order_Type_Desc] [varchar](100) NULL,
	[Job_Amount] [decimal](28, 8) NULL,
	[Parts_Amount] [decimal](28, 8) NULL,
	[Parts_Purch_Amount] [decimal](28, 8) NULL,
	[Misc_Amount] [decimal](28, 8) NULL,
	[Invoiced_Time] [decimal](28, 8) NULL,
	[Used_Time] [decimal](28, 8) NULL,
	[Quantity] [decimal](28, 8) NULL,
	[Order_Count] [decimal](28, 8) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[SKR_Absatzkanal]    Script Date: 24.04.2019 11:47:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[SKR_Absatzkanal](
	[Ebene21] [varchar](200) NULL,
	[Absatzkanal_mit_Bez] [varchar](200) NULL,
	[Ebene23] [varchar](200) NULL,
	[Ebene24] [varchar](200) NULL,
	[Ebene25] [varchar](200) NULL,
	[Ebene26] [varchar](200) NULL,
	[Ebene27] [varchar](200) NULL,
	[Ebene28] [varchar](200) NULL,
	[Ebene29] [varchar](200) NULL,
	[Ebene30] [varchar](200) NULL,
	[Absatzkanal] [varchar](200) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[SKR_Herkunft_KST]    Script Date: 24.04.2019 11:47:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[SKR_Herkunft_KST](
	[Ebene11] [varchar](200) NULL,
	[KST_mit_Bez] [varchar](200) NULL,
	[Ebene13] [varchar](200) NULL,
	[Ebene14] [varchar](200) NULL,
	[Ebene15] [varchar](200) NULL,
	[Ebene16] [varchar](200) NULL,
	[Ebene17] [varchar](200) NULL,
	[Ebene18] [varchar](200) NULL,
	[Ebene19] [varchar](200) NULL,
	[Ebene20] [varchar](200) NULL,
	[KST] [varchar](200) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[SKR_Kostenträger]    Script Date: 24.04.2019 11:47:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[SKR_Kostenträger](
	[Ebene31] [varchar](200) NULL,
	[Ebene32] [varchar](200) NULL,
	[Ebene33] [varchar](200) NULL,
	[Ebene34] [varchar](200) NULL,
	[Ebene35] [varchar](200) NULL,
	[Ebene36] [varchar](200) NULL,
	[Ebene37] [varchar](200) NULL,
	[Ebene38] [varchar](200) NULL,
	[Ebene39] [varchar](200) NULL,
	[Ebene40] [varchar](200) NULL,
	[Kostenträger_mit_Bez] [varchar](200) NULL,
	[Kostenträger] [varchar](200) NULL,
	[Ebene_Marke] [varchar](200) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[SKR_Marke]    Script Date: 24.04.2019 11:47:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[SKR_Marke](
	[Marke_mit_Bez] [varchar](100) NULL,
	[Ebene42] [varchar](100) NULL,
	[Ebene43] [varchar](100) NULL,
	[Ebene44] [varchar](100) NULL,
	[Ebene45] [varchar](100) NULL,
	[Ebene46] [varchar](100) NULL,
	[Ebene47] [varchar](100) NULL,
	[Ebene48] [varchar](100) NULL,
	[Ebene49] [varchar](100) NULL,
	[Ebene50] [varchar](100) NULL,
	[Marke] [varchar](100) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[Teile_Fremdwerkst]    Script Date: 24.04.2019 11:47:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[Teile_Fremdwerkst](
	[Nr] [varchar](100) NULL,
	[Name] [varchar](100) NULL,
	[Lfd Nr] [varchar](100) NULL,
	[Debitorennr] [varchar](100) NULL,
	[Buchungsdatum] [datetime] NULL,
	[Belegart] [varchar](100) NULL,
	[Belegnr] [varchar](100) NULL,
	[Beschreibung] [varchar](100) NULL,
	[Betrag_ori] [decimal](28, 8) NULL,
	[Restbetrag] [decimal](28, 8) NULL,
	[Kostenstellencode] [varchar](100) NULL,
	[Markencode] [varchar](100) NULL,
	[Verkäufercode] [varchar](100) NULL,
	[Benutzer Id] [varchar](100) NULL,
	[Herkunftscode] [varchar](100) NULL,
	[Offen] [varchar](100) NULL,
	[Fälligkeitsdatum] [datetime] NULL,
	[Gegenkontoart] [varchar](100) NULL,
	[Gegenkontonr] [varchar](100) NULL,
	[Transaktionsnr] [varchar](100) NULL,
	[Sollbetrag] [decimal](28, 8) NULL,
	[Habenbetrag] [decimal](28, 8) NULL,
	[Belegdatum] [datetime] NULL,
	[Externe Belegnummer] [varchar](100) NULL,
	[Filialcode] [varchar](100) NULL,
	[Hauptbereich] [varchar](100) NULL,
	[Kundengruppencode] [varchar](100) NULL,
	[Fahrgestellnummer] [varchar](100) NULL,
	[Kassenbelegnr] [varchar](100) NULL,
	[Bemerkung] [varchar](100) NULL,
	[Hauptbetrieb] [varchar](100) NULL,
	[Betrieb] [varchar](100) NULL,
	[Bookkeep Date] [datetime] NULL,
	[Filial-Code] [varchar](100) NULL,
	[Filialbezeichnung] [varchar](100) NULL,
	[Standort] [varchar](100) NULL,
	[Verkäufer-Code] [varchar](100) NULL,
	[Verkäufer-Name] [varchar](100) NULL,
	[Sel Name] [varchar](100) NULL,
	[Kunde] [varchar](100) NULL,
	[Fälligkeit_Zeichen] [datetime] NULL,
	[Beleg] [varchar](100) NULL,
	[KST-Code] [varchar](100) NULL,
	[KST-Name] [varchar](100) NULL,
	[KST_1] [varchar](100) NULL,
	[Kostenstelle] [varchar](100) NULL,
	[Heute] [datetime] NULL,
	[Tage] [varchar](100) NULL,
	[Staffel] [varchar](100) NULL,
	[offen2] [varchar](100) NULL,
	[Rechnungsbetrag] [decimal](28, 8) NULL,
	[KD-Gruppen-Code] [varchar](100) NULL,
	[KD-Gruppe-Beschreibung] [varchar](100) NULL,
	[Sel Name2] [varchar](100) NULL,
	[Bereich] [varchar](100) NULL,
	[Gesamtsaldo Kunde] [varchar](100) NULL,
	[Nachname] [varchar](100) NULL,
	[Vorname] [varchar](100) NULL,
	[Kundenart_ori] [varchar](100) NULL,
	[Kundenart] [varchar](100) NULL,
	[Einsatzwert] [decimal](28, 8) NULL,
	[Menge] [decimal](28, 8) NULL,
	[Vk-preis] [decimal](28, 8) NULL,
	[Betrag] [decimal](28, 8) NULL,
	[Summe Betrag] [decimal](28, 8) NULL,
	[Umsatz Teile] [decimal](28, 8) NULL,
	[Einsatz Teile] [decimal](28, 8) NULL,
	[Zeilennr] [varchar](100) NULL,
	[Beschreibung2] [varchar](100) NULL,
	[Beschreibung3] [varchar](100) NULL,
	[Debitorengruppencode] [varchar](100) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[Verarbeitung_AE_Plan_2018]    Script Date: 24.04.2019 11:47:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[Verarbeitung_AE_Plan_2018](
	[Verkäufer] [varchar](100) NULL,
	[Fahrzeugart] [varchar](100) NULL,
	[Invoice Date] [varchar](100) NULL,
	[Jan] [varchar](100) NULL,
	[Feb] [varchar](100) NULL,
	[Mrz] [varchar](100) NULL,
	[Apr] [varchar](100) NULL,
	[Mai] [varchar](100) NULL,
	[Jun] [varchar](100) NULL,
	[Jul] [varchar](100) NULL,
	[Aug] [varchar](100) NULL,
	[Sep] [varchar](100) NULL,
	[Okt] [varchar](100) NULL,
	[Nov] [varchar](100) NULL,
	[Dez] [varchar](100) NULL,
	[Hauptbetrieb] [varchar](100) NULL,
	[Standort] [varchar](100) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[Zeit_2_Aftersales]    Script Date: 24.04.2019 11:47:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[Zeit_2_Aftersales](
	[Employee No] [varchar](100) NULL,
	[Datum] [datetime] NULL,
	[Department No] [varchar](100) NULL,
	[Time Account No] [varchar](100) NULL,
	[Time Account Value] [numeric](18, 0) NULL,
	[Ta Class (general)] [numeric](18, 0) NULL,
	[Ta Class (statistics)] [numeric](18, 0) NULL,
	[Ta Class (absent Days)] [numeric](18, 0) NULL,
	[Ta Class (time Processing)] [numeric](18, 0) NULL,
	[Ta Class (individual)] [numeric](18, 0) NULL,
	[Ta Class (employee Info)] [numeric](18, 0) NULL,
	[Ta Class (vacation Reduction)] [numeric](18, 0) NULL,
	[Ta Formatting] [numeric](18, 0) NULL,
	[Generating Function] [numeric](18, 0) NULL,
	[Record Protected] [numeric](18, 0) NULL,
	[No] [varchar](100) NULL,
	[Description] [varchar](100) NULL,
	[Description 2] [varchar](100) NULL,
	[Zeitdauer] [decimal](28, 8) NULL,
	[Summe  (Zeitdauer) Nr 1] [decimal](28, 8) NULL,
	[gesamt Stunden] [decimal](28, 8) NULL,
	[Summe  (gesamt Stunden) Nr 3] [decimal](28, 8) NULL,
	[Summe  (gesamt Stunden) Nr 2] [decimal](28, 8) NULL,
	[Summe  (gesamt Stunden) Nr 1] [decimal](28, 8) NULL,
	[Wehr-  Zivildienst] [decimal](28, 8) NULL,
	[Innung Azubi] [decimal](28, 8) NULL,
	[W-fix Stunden] [decimal](28, 8) NULL,
	[Hauptbetrieb] [varchar](100) NULL,
	[Standort] [varchar](100) NULL,
	[First Name] [varchar](100) NULL,
	[Last Name] [varchar](100) NULL,
	[Monteur_Gruppe_ori] [varchar](100) NULL,
	[Abteilung] [varchar](100) NULL,
	[Order Number] [varchar](100) NULL,
	[Monteur_ori] [varchar](100) NULL,
	[Überstunden] [varchar](100) NULL,
	[Leaving Date] [datetime] NULL,
	[Group No 1] [varchar](100) NULL,
	[Group No 2] [varchar](100) NULL,
	[Group No 3] [varchar](100) NULL,
	[Tage Heute Leaving Date] [varchar](100) NULL,
	[Monteur_Gruppe] [varchar](100) NULL,
	[produktiv unproduktiv] [varchar](100) NULL,
	[Monatserster] [datetime] NULL,
	[Monatsletzter] [datetime] NULL,
	[Heute] [datetime] NULL,
	[Datum Tagesbericht] [datetime] NULL,
	[Employment Date] [datetime] NULL,
	[Schulung extern] [decimal](28, 8) NULL,
	[Krank] [decimal](28, 8) NULL,
	[Arzt] [decimal](28, 8) NULL,
	[Urlaub] [decimal](28, 8) NULL,
	[Sonderurlaub] [decimal](28, 8) NULL,
	[Fehlstunden] [decimal](28, 8) NULL,
	[Berufsschule] [decimal](28, 8) NULL,
	[Feiertag] [decimal](28, 8) NULL,
	[Zeitausgleich] [decimal](28, 8) NULL,
	[Kostenstelle] [varchar](100) NULL,
	[Filialcode_Employee] [varchar](100) NULL,
	[Kostenstellencode_Employee] [varchar](100) NULL,
	[Name_Kostenstelle] [varchar](100) NULL,
	[Betrieb] [varchar](100) NULL,
	[Monteur_Gruppe_2] [varchar](100) NULL,
	[Arbeitsvertragscode] [varchar](100) NULL,
	[Serviceberater] [varchar](100) NULL,
	[Abwesenheiten Serviceberater] [decimal](28, 8) NULL,
	[Urlaubstage] [decimal](28, 8) NULL,
	[Kranktage] [decimal](28, 8) NULL,
	[Schultage] [decimal](28, 8) NULL,
	[Standort_1] [varchar](100) NULL,
	[Serviceberater_KZ_Employee] [varchar](100) NULL,
	[Invoice Date] [datetime] NULL,
	[Funktion] [varchar](100) NULL,
	[Servicberater   sonst  MA] [varchar](100) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[Zeit_2_C11]    Script Date: 24.04.2019 11:47:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[Zeit_2_C11](
	[Employee No] [varchar](100) NULL,
	[Datum] [datetime] NULL,
	[Department No] [varchar](100) NULL,
	[Time Account No] [varchar](100) NULL,
	[Time Account Value] [decimal](28, 8) NULL,
	[No] [varchar](100) NULL,
	[Description] [varchar](100) NULL,
	[Description 2] [varchar](100) NULL,
	[Zeitdauer] [decimal](28, 8) NULL,
	[Summe  (Zeitdauer) Nr 1] [decimal](28, 8) NULL,
	[gesamt Stunden] [decimal](28, 8) NULL,
	[Summe  (gesamt Stunden) Nr 3] [decimal](28, 8) NULL,
	[Summe  (gesamt Stunden) Nr 2] [decimal](28, 8) NULL,
	[Summe  (gesamt Stunden) Nr 1] [decimal](28, 8) NULL,
	[Hauptbetrieb] [varchar](100) NULL,
	[Standort] [varchar](100) NULL,
	[First Name] [varchar](100) NULL,
	[Last Name] [varchar](100) NULL,
	[Monteur_Gruppe_ori_alt] [varchar](100) NULL,
	[Abteilung] [varchar](100) NULL,
	[Monteur] [varchar](100) NULL,
	[Leaving Date] [datetime] NULL,
	[Group No 1] [varchar](100) NULL,
	[Group No 2] [varchar](100) NULL,
	[Group No 3] [varchar](100) NULL,
	[Tage Heute Leaving Date] [varchar](100) NULL,
	[Monteur_Gruppe] [varchar](100) NULL,
	[produktiv unproduktiv] [varchar](100) NULL,
	[Monatserster] [datetime] NULL,
	[Monatsletzter] [datetime] NULL,
	[Heute] [datetime] NULL,
	[Datum Tagesbericht] [datetime] NULL,
	[Employment Date] [datetime] NULL,
	[Kostenstelle] [varchar](100) NULL,
	[Filialcode_Employee] [varchar](100) NULL,
	[Kostenstellencode_Employee] [varchar](100) NULL,
	[Name_Kostenstelle] [varchar](100) NULL,
	[Betrieb] [varchar](100) NULL,
	[Monteur_Gruppe_2] [varchar](100) NULL,
	[Arbeitsvertragscode] [varchar](100) NULL,
	[Task Type Group] [varchar](100) NULL,
	[Monteur_Gruppe_ori] [varchar](100) NULL,
	[Kontrolle] [decimal](28, 8) NULL,
	[Date] [varchar](100) NULL,
	[Company_ID] [varchar](100) NULL,
	[Department_ID] [varchar](100) NULL,
	[Mechanic_Group2] [varchar](100) NULL,
	[Mechanic] [varchar](100) NULL,
	[Mechanic_Productive] [varchar](100) NULL,
	[Mechanic_Group1] [varchar](100) NULL,
	[Order Number] [varchar](100) NULL,
	[Activity_Codes_Group1] [varchar](100) NULL,
	[Activity_Codes_Group2_ori] [varchar](100) NULL,
	[Activity_Codes_Group2] [varchar](100) NULL,
	[Activity_Desc] [varchar](100) NULL,
	[Mechanic_Trainee] [varchar](100) NULL,
	[produktiv] [varchar](100) NULL,
	[unproduktiv] [varchar](100) NULL,
	[abwesend] [decimal](28, 8) NULL,
	[Filialcode_Employee2] [varchar](100) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[Zeit_benutzte_verr_Zeit_LG_C11]    Script Date: 24.04.2019 11:47:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[Zeit_benutzte_verr_Zeit_LG_C11](
	[Employee No] [varchar](100) NULL,
	[Current Date] [datetime] NULL,
	[Department No] [varchar](100) NULL,
	[Order No] [varchar](100) NULL,
	[Task No] [varchar](100) NULL,
	[Dimension 1] [varchar](100) NULL,
	[Dimension 2] [varchar](100) NULL,
	[Dimension 3] [varchar](100) NULL,
	[Dimension 4] [varchar](100) NULL,
	[Time Account No] [varchar](100) NULL,
	[Time Account Value] [decimal](28, 8) NULL,
	[Zeit] [decimal](28, 8) NULL,
	[Summe  (Zeit) Nr 3] [decimal](28, 8) NULL,
	[Summe  (Zeit) Nr 2] [decimal](28, 8) NULL,
	[Summe  (Zeit) Nr 1] [decimal](28, 8) NULL,
	[Datum] [datetime] NULL,
	[Hauptbetrieb] [varchar](100) NULL,
	[Filialcode_Monteur] [varchar](100) NULL,
	[Standort] [varchar](100) NULL,
	[Betrieb] [varchar](100) NULL,
	[Kostenstellencode_Monteur] [varchar](100) NULL,
	[Monteur_Gruppe_ori_alt] [varchar](100) NULL,
	[Leaving Date] [datetime] NULL,
	[Tage Heute Leaving Date] [varchar](100) NULL,
	[Monteur_Gruppe] [varchar](100) NULL,
	[Nr_Monteur] [varchar](100) NULL,
	[Monteur_Gruppe_2] [varchar](100) NULL,
	[Vorname_Monteur] [varchar](100) NULL,
	[Nachname_Monteur] [varchar](100) NULL,
	[Monteur] [varchar](100) NULL,
	[Name_Kostenstelle_Monteur] [varchar](100) NULL,
	[Kostenstelle] [varchar](100) NULL,
	[benutzte Zeit] [decimal](28, 8) NULL,
	[Summe  (benutzte Zeit) Nr 2] [decimal](28, 8) NULL,
	[Summe  (benutzte Zeit) Nr 1] [decimal](28, 8) NULL,
	[verr  Zeit] [decimal](28, 8) NULL,
	[ben  Zeit gerundet] [decimal](28, 8) NULL,
	[Summe  (ben  Zeit gerundet) Nr 2] [decimal](28, 8) NULL,
	[Summe  (ben  Zeit gerundet) Nr 1] [decimal](28, 8) NULL,
	[Description] [varchar](100) NULL,
	[Anwesenheit] [varchar](100) NULL,
	[produktiv] [decimal](28, 8) NULL,
	[Arbeitsvertragscode] [varchar](100) NULL,
	[Pause] [varchar](100) NULL,
	[Sollzeit] [varchar](100) NULL,
	[Anwes  Netto] [varchar](100) NULL,
	[Task Type Group] [varchar](100) NULL,
	[Group No 1] [varchar](100) NULL,
	[Group No 3] [varchar](100) NULL,
	[Monteur_Gruppe_ori] [varchar](100) NULL,
	[Date] [varchar](100) NULL,
	[Company_ID] [varchar](100) NULL,
	[Department_ID] [varchar](100) NULL,
	[Mechanic_Group2] [varchar](100) NULL,
	[Mechanic] [varchar](100) NULL,
	[Mechanic_Productive] [varchar](100) NULL,
	[Mechanic_Group1] [varchar](100) NULL,
	[Order Number] [varchar](100) NULL,
	[Mechanic_Trainee] [varchar](100) NULL,
	[Invoiced_Time] [varchar](100) NULL,
	[Used_Time_Order] [decimal](28, 8) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [imr_csv].[Zeit_Stempelzeiten_Monteur_2_C11]    Script Date: 24.04.2019 11:47:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [imr_csv].[Zeit_Stempelzeiten_Monteur_2_C11](
	[Entry No] [varchar](100) NULL,
	[Employee No] [varchar](100) NULL,
	[Date_ori] [datetime] NULL,
	[Time Value] [datetime] NULL,
	[Begin End] [varchar](100) NULL,
	[Cause Of Absence Code] [varchar](100) NULL,
	[Terminal Code] [varchar](100) NULL,
	[Department Code] [varchar](100) NULL,
	[Make Code] [varchar](100) NULL,
	[User Id] [varchar](100) NULL,
	[Reason Code] [varchar](100) NULL,
	[Sorting] [varchar](100) NULL,
	[Posting Date] [datetime] NULL,
	[Order No] [varchar](100) NULL,
	[Service Job No] [varchar](100) NULL,
	[Closed] [varchar](100) NULL,
	[Task Type Code] [varchar](100) NULL,
	[Link No] [varchar](100) NULL,
	[Task Ledger Entry No] [varchar](100) NULL,
	[Corrected] [varchar](100) NULL,
	[Starting Time] [datetime] NULL,
	[Ending Time] [datetime] NULL,
	[Duration] [decimal](28, 8) NULL,
	[Time Acquisition Posted] [varchar](100) NULL,
	[Branch Code] [varchar](100) NULL,
	[Approved By User Id] [varchar](100) NULL,
	[Approved] [varchar](100) NULL,
	[Automatic Posting] [varchar](100) NULL,
	[Subject To Approval] [varchar](100) NULL,
	[Applied-to Entry No] [varchar](100) NULL,
	[Ledger Entry Origin] [varchar](100) NULL,
	[Correction Mode] [varchar](100) NULL,
	[Posting Time] [datetime] NULL,
	[Service Advisor No] [varchar](100) NULL,
	[Resource Group No] [varchar](100) NULL,
	[Tested] [varchar](100) NULL,
	[Location Code] [varchar](100) NULL,
	[Leave] [varchar](100) NULL,
	[Zeitdauer] [decimal](28, 8) NULL,
	[Summe  (Zeitdauer) Nr 1] [decimal](28, 8) NULL,
	[Code] [varchar](100) NULL,
	[Description_Task_Type] [varchar](100) NULL,
	[Task Statistic Group] [varchar](100) NULL,
	[Hauptbetrieb] [varchar](100) NULL,
	[Standort] [varchar](100) NULL,
	[No] [varchar](100) NULL,
	[Last Name] [varchar](100) NULL,
	[First Name] [varchar](100) NULL,
	[Monteur] [varchar](100) NULL,
	[Datum] [datetime] NULL,
	[Leaving Date] [datetime] NULL,
	[Group No 1] [varchar](100) NULL,
	[Group No 2] [varchar](100) NULL,
	[Group No 3] [varchar](100) NULL,
	[Monteur_Gruppe_ori_alt] [varchar](100) NULL,
	[Tage Heute Leaving Date] [varchar](100) NULL,
	[Monteur_Gruppe] [varchar](100) NULL,
	[produktiv unproduktiv] [varchar](100) NULL,
	[Monatserster] [datetime] NULL,
	[Monatsletzter] [datetime] NULL,
	[Heute] [datetime] NULL,
	[Datum Tagesbericht] [datetime] NULL,
	[Employment Date] [datetime] NULL,
	[Kostenstelle] [varchar](100) NULL,
	[unproduktiv_alt] [decimal](28, 8) NULL,
	[abwesend_ori] [varchar](100) NULL,
	[Extern] [varchar](100) NULL,
	[GWL] [varchar](100) NULL,
	[Intern] [varchar](100) NULL,
	[Filialcode_Employee] [varchar](100) NULL,
	[Kostenstellencode_Employee] [varchar](100) NULL,
	[Name_Kostenstelle] [varchar](100) NULL,
	[Betrieb] [varchar](100) NULL,
	[Monteur_Gruppe_2] [varchar](100) NULL,
	[Arbeitsvertragscode] [varchar](100) NULL,
	[Task Type Group] [varchar](100) NULL,
	[Monteur_Gruppe_ori] [varchar](100) NULL,
	[Date] [datetime] NULL,
	[Company_ID] [varchar](100) NULL,
	[Department_ID] [varchar](100) NULL,
	[Mechanic_Group2] [varchar](100) NULL,
	[Mechanic] [varchar](100) NULL,
	[Mechanic_Productive] [varchar](100) NULL,
	[Mechanic_Group1] [varchar](100) NULL,
	[Order Number] [varchar](100) NULL,
	[Activity_Codes_Group1] [varchar](100) NULL,
	[Activity_Codes_Group2] [varchar](100) NULL,
	[Activity_Desc] [varchar](100) NULL,
	[Mechanic_Trainee] [varchar](100) NULL,
	[produktiv] [decimal](28, 8) NULL,
	[unproduktiv] [decimal](28, 8) NULL,
	[abwesend] [decimal](28, 8) NULL,
	[TOY_produktiv_Zeit] [decimal](28, 8) NULL
) ON [PRIMARY]
GO