USE [CARLO] GO CREATE SCHEMA imr_csv 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