CREATE TABLE [carlo].[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](255) NULL, [Invoice_Desc_100] [varchar](255) NULL, [Order_Desc_30] [varchar](255) NULL, [Invoice_Desc_30] [varchar](255) 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 ) GO