C11/System/OPTIMA/SQL/schema/GC/tables/NW_GW_VK_CSV.sql

CREATE TABLE [dbo].[NW_GW_VK_CSV] (
   [Unit Number] [varchar](10) NOT NULL,
   [Invoice Date] [datetime] NOT NULL,
   [Hauptbetrieb] [bigint] NULL,
   [Standort_Verkaufskostenstelle] [varchar](50) NULL,
   [Verkäufer] [varchar](50) NULL,
   [Fabrikat_ori] [varchar](50) NULL,
   [Model] [varchar](50) NULL,
   [Modellbez] [varchar](50) NULL,
   [Fahrgestellnr] [varchar](50) NULL,
   [Fahrzeugart] [varchar](50) NULL,
   [Fahrzeugtyp] [varchar](50) NULL,
   [Kunde] [varchar](100) NULL,
   [Kundenart] [varchar](50) NULL,
   [Geschäftsart] [varchar](50) NULL,
   [Farbe] [varchar](100) NULL,
   [ECC_Status_Text] [varchar](50) NULL,
   [FZG] [varchar](100) NULL,
   [FZG_1] [varchar](100) NULL,
   [FZG_Liste_1] [varchar](100) NULL,
   [Sel Name_EK_vpp43] [varchar](50) NULL,
   [Einkäufer] [varchar](100) NULL,
   [Vorbesitzer] [varchar](100) NULL,
   [FZG_Liste_2] [varchar](100) NULL,
   [FZG_Liste_3] [varchar](100) NULL,
   [FZG_Liste_4] [varchar](100) NULL,
   [Line Type] [bigint] NULL,
   [Document Date] [datetime] NULL,
   [Document Nr] [bigint] NULL,
   [Order Date] [datetime] NULL,
   [Order Number] [bigint] NULL,
   [Transaction Code] [bigint] NULL,
   [Specify_vpp5a] [varchar](50) NULL,
   [Reference] [varchar](50) NULL,
   [Costs] [decimal](28,8) NULL,
   [Orders Grossvalue] [decimal](28,8) NULL,
   [Discount] [decimal](28,8) NULL,
   [Book Keeping Code] [varchar](50) NULL,
   [Erlös] [decimal](28,8) NULL,
   [Sonst  Erlöse] [decimal](28,8) NULL,
   [Ums  Fracht und Überf ] [decimal](28,8) NULL,
   [Nachlass] [decimal](28,8) NULL,
   [Provisionen] [decimal](28,8) NULL,
   [EK Fahrzeug] [decimal](28,8) NULL,
   [FZG-Kosten] [decimal](28,8) NULL,
   [Einsatz] [decimal](28,8) NULL,
   [VK_Hilfen] [decimal](28,8) NULL,
   [Standtage] [bigint] NULL,
   [Fabrikat_manuell] [varchar](50) NULL,
   [Mandant] [varchar](50) NULL,
   [Department_unit_change_hist] [varchar](50) NULL,
   [Unique Ident_unit_change_hist] [varchar](50) NOT NULL,
   [Maximum_Unique_Ident] [bigint] NULL,
   [Standort] [varchar](50) NULL,
   [TR Code] [varchar](50) NULL,
   [Zipcode] [varchar](10) NULL,
   [Fabrikat_GC_Marke_ori] [varchar](50) NULL,
   [Hauptbetrieb_ID] [varchar](50) NOT NULL,
   [Hauptbetrieb_Name] [varchar](50) NULL,
   [Fabrikat] [varchar](50) NULL,
   [Order By_ori] [bigint] NULL,
   [Modell_Beschreibung] [varchar](50) 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,
   [FZG_Erlös] [decimal](28,8) NULL,
   [Einsatz_FZG] [decimal](28,8) NULL,
   [Erlös_Prov] [decimal](28,8) NULL,
   [Erlös_Überf ] [decimal](28,8) NULL,
   [Erlös Sonst ] [decimal](28,8) NULL,
   [Order By] [bigint] NULL,
   [Einkäufer Vorbesitzer] [varchar](200) NULL,
   [DB1 < 0] [varchar](50) NULL,
   [Name_Einkäufer] [varchar](100) NULL,
   [Konto] [varchar](50) NULL,
   [Buch_Text] [varchar](100) NULL,
   [Name_Lieferant] [varchar](100) NULL,
   [Erlös Prov] [decimal](28,8) NULL,
   [Erlös_FZG] [decimal](28,8) NULL,
   [Erlös Überf ] [decimal](28,8) NULL,
   [Einsatz FZG] [decimal](28,8) NULL,
   [Menge_1] [bigint] NULL,
   [Anzahl_Datensätze] [bigint] NULL,
   [Menge] [decimal](28,8) NULL,
   [DB1] [decimal](28,8) NULL,
   [Summe_DB1] [decimal](28,8) NULL,
   [FZG_Detail] [varchar](200) NULL,
   [Standort_ID] [varchar](50) NULL,
   [Standort_Name] [varchar](50) NULL,
   [Jahr_Invoice_Date] [int] NULL,
   [Monat_Invoice_Date] [int] NULL,
   [Jahr_Monat] [int] NULL,
   [Monat_Text] [varchar](20) NULL,
   [Unique_Ident_Unit_History] [varchar](50) NOT NULL

   ,CONSTRAINT [PK_NW_GW_VK_CSV_1] PRIMARY KEY CLUSTERED ([Unit Number], [Invoice Date], [Unique Ident_unit_change_hist], [Hauptbetrieb_ID], [Unique_Ident_Unit_History])
)


GO