C11/System/CARLO/SQL/schema/GC/tables/carlo.Auftraege_EDS_intern_C11.sql

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