C11/System/AUTOLINE/SQL/schema/GC_DWH_AUTOLINE/tables/Verkauf.sql

CREATE TABLE [dbo].[Verkauf] (
   [Vehicledescriptio002] [varchar](100) NULL,
   [Fullchassis] [varchar](30) NULL,
   [Customername] [varchar](152) NULL,
   [Hauptbetrieb_ID] [varchar](50) NOT NULL,
   [Hauptbetrieb_Name] [varchar](1) NOT NULL,
   [Standort_ID] [varchar](3) NULL,
   [Standort_Name] [varchar](26) NULL,
   [Verkäufer] [varchar](30) NULL,
   [Fabrikat] [varchar](14) NULL,
   [Model] [varchar](50) NULL,
   [FZG] [varchar](209) NULL,
   [Kunde] [varchar](163) NULL,
   [Fahrzeugart] [varchar](14) NOT NULL,
   [Fahrzeugtyp] [varchar](6) NOT NULL,
   [Konto] [varchar](1) NOT NULL,
   [Fahrzeugtyp_1] [varchar](1) NOT NULL,
   [Kundenart] [varchar](54) NULL,
   [FZG_Detail] [varchar](379) NULL,
   [PLZ_1] [varchar](1) NULL,
   [PLZ_2] [varchar](2) NULL,
   [PLZ_3] [varchar](3) NULL,
   [PLZ_4] [varchar](4) NULL,
   [PLZ Code_Deb] [varchar](10) NULL,
   [Name_Lieferant] [varchar](100) NULL,
   [Modell_Beschreibung] [varchar](100) NULL,
   [Name_Einkäufer] [varchar](8) NULL,
   [DB1 < 0] [varchar](7) NOT NULL,
   [Menge] [numeric](11,1) NOT NULL,
   [Erlös_FZG] [decimal](18,2) NULL,
   [Einsatz FZG] [decimal](19,2) NULL,
   [Invoice Date] [datetime] NULL,
   [Standtage] [int] NULL,
   [FZG-Nr] [varchar](51) NULL,
   [Baudatum] [datetime] NULL,
   [Vorauss. Lieferung] [datetime] NULL,
   [Zul.-Datum] [datetime] NULL,
   [GMK Datum (tatsächl.)] [datetime] NULL,
   [WB Nummer] [varchar](20) NULL,
   [GMK Datum (tatsächl.)_Datum] [datetime] NULL,
   [Gesch Kosten Stuetzung] [decimal](38,2) NULL,
   [Gesch Kosten Gesamt] [decimal](38,2) NULL,
   [Tatsaechl Kosten Stuetzung] [decimal](38,2) NULL,
   [Tatsaechl Kosten Gesamt] [decimal](38,2) NULL,
   [Differenz] [decimal](38,2) NULL,
   [Differenz Stuetzung] [decimal](38,2) NULL,
   [Summe Offene Aufträge] [numeric](38,12) NULL,
   [GMK Datum] [date] NULL,
   [Jahr/Monat_GMK] [varchar](20) NULL,
   [Monatserster_GMK] [date] NULL,
   [Monat_Jahr_GMK] [varchar](20) NULL,
   [Datum_GMK] [date] NULL,
   [Datum] [date] NULL,
   [Jahr/Monat] [varchar](20) NULL,
   [Aktueller Tag] [date] NULL,
   [Monatserster] [date] NULL,
   [Monatsletzter] [date] NULL,
   [MUN_DATE] [varchar](100) NULL,
   [Mitgliedsname] [varchar](50) NULL,
   [Beginn Geschäftsjahr] [date] NULL,
   [Monat_Jahr] [varchar](20) NULL,
   [Jahr] [varchar](20) NULL,
   [Monat] [varchar](20) NULL,
   [Monat_kurz] [nvarchar](4000) NULL
)


GO