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

CREATE TABLE [carlo].[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](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,
   [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,
   [Rabatt Lohn %] [decimal](28,8) NULL,
   [Rabatt Lohn] [decimal](28,8) NULL,
   [Rabatt Teile %] [decimal](28,8) NULL,
   [Rabatt Teile] [decimal](28,8) NULL,
   [Rabatt Sonst %] [decimal](28,8) NULL,
   [Rabatt Sonst] [decimal](28,8) NULL
)


GO