C11/System/OPTIMA/SQL/schema/GC/tables/optima.NW_GW_VK.sql

CREATE TABLE [optima].[NW_GW_VK] (
   [Register Number] [varchar](100) NULL,
   [Workshop Model] [varchar](100) NULL,
   [Transact Date] [datetime] NULL,
   [Handler] [varchar](100) NULL,
   [Department] [varchar](100) NULL,
   [Order Date] [datetime] NULL,
   [Invoice Date] [datetime] NULL,
   [Costs] [decimal](28,8) NULL,
   [Orders Grossvalue] [decimal](28,8) NULL,
   [Basis Number] [varchar](100) NULL,
   [Mileage] [varchar](100) NULL,
   [Model Text] [varchar](100) NULL,
   [Arrival Date] [datetime] NULL,
   [Make Cd] [varchar](100) NULL,
   [Chassis Number] [varchar](100) NULL,
   [Hauptbetrieb] [varchar](100) NULL,
   [Standort] [varchar](100) NULL,
   [Kundenart] [varchar](100) NULL,
   [Geschäftsart] [varchar](100) NULL,
   [Kunde] [varchar](100) NULL,
   [Global Make Cd] [varchar](100) NULL,
   [Fabrikat_ori] [varchar](100) NULL,
   [Model] [varchar](100) NULL,
   [Fabrikat] [varchar](100) NULL,
   [Order Number] [varchar](100) NULL,
   [Unit Number] [varchar](100) NULL,
   [Ecc Status] [varchar](100) NULL,
   [Vehicle Type] [varchar](100) NULL,
   [Vehicle Type_vpp5r] [varchar](100) NULL,
   [Vehicle Type Text_vpp5r] [varchar](100) NULL,
   [Car Creation Date] [datetime] NULL,
   [Depreciation] [varchar](100) NULL,
   [Book Keeping Code] [varchar](100) NULL,
   [Book Keeping Code_vpp5m] [varchar](100) NULL,
   [Specify_vpp5m] [varchar](100) NULL,
   [Purch Department] [varchar](100) NULL,
   [Purch Salsman Code] [varchar](100) NULL,
   [Purch Date] [datetime] NULL,
   [Reception Date] [datetime] NULL,
   [Sales Department] [varchar](100) NULL,
   [Department Type Id_Dep] [varchar](100) NULL,
   [Description_Dep] [varchar](100) NULL,
   [Sale Salesman] [varchar](100) NULL,
   [Seller Code_vpp43] [varchar](100) NULL,
   [Sel Name_vpp43] [varchar](100) NULL,
   [Sel Family Name_vpp43] [varchar](100) NULL,
   [Sale Inv Number] [varchar](100) NULL,
   [Sale Date] [datetime] NULL,
   [Bud Sale Det] [varchar](100) NULL,
   [Bud Purch Price] [decimal](28,8) NULL,
   [Bud Reg Fee] [decimal](28,8) NULL,
   [Bud Deduct Fee] [decimal](28,8) NULL,
   [Bud Cost] [decimal](28,8) NULL,
   [Purch Price Unit] [decimal](28,8) NULL,
   [Cost Unit] [decimal](28,8) NULL,
   [Sales Price Unit] [decimal](28,8) NULL,
   [Reg Fee] [decimal](28,8) NULL,
   [Stock Days] [varchar](100) NULL,
   [Buying Order No] [varchar](100) NULL,
   [Buying Order Date] [datetime] NULL,
   [Pa Number] [varchar](100) NULL,
   [Location Code] [varchar](100) NULL,
   [Owner] [varchar](100) NULL,
   [Prev Owner] [varchar](100) NULL,
   [Account Purchase] [varchar](100) NULL,
   [Account Sales] [varchar](100) NULL,
   [Customer Number_Cust] [varchar](100) NULL,
   [Name_Cust] [varchar](100) NULL,
   [Customer Group_Cust] [varchar](100) NULL,
   [Customer Group_vpp48] [varchar](100) NULL,
   [Cust Group Specify_vpp48] [varchar](100) NULL,
   [Order Arrival Date] [datetime] NULL,
   [Order Confirm Date] [datetime] NULL,
   [Contract Date] [datetime] NULL,
   [Owner Code] [varchar](100) NULL,
   [First Reg Date] [datetime] NULL,
   [Latest Reg Date] [datetime] NULL,
   [Salesman Buy] [varchar](100) NULL,
   [Salesman Sale] [varchar](100) NULL,
   [Colour Cf] [varchar](100) NULL,
   [Model Line] [varchar](100) NULL,
   [Model Line_vpp5q] [varchar](100) NULL,
   [Mod Lin Specify_vpp5q] [varchar](100) NULL,
   [Mileage2] [varchar](100) NULL,
   [Motor Code] [varchar](100) NULL,
   [Drive Code] [varchar](100) NULL,
   [Colour Code] [varchar](100) NULL,
   [Make] [varchar](100) NULL,
   [Description_Global_Make] [varchar](100) NULL,
   [Orig Inv Date] [datetime] NULL,
   [Latest Inv Date] [datetime] NULL,
   [Standort_Verkaufskostenstelle] [varchar](100) NULL,
   [Verkäufer] [varchar](100) NULL,
   [Modellbez] [varchar](100) NULL,
   [Fahrgestellnr] [varchar](100) NULL,
   [Fahrzeugart] [varchar](100) NULL,
   [Fahrzeugtyp] [varchar](100) NULL,
   [Farbe] [varchar](100) NULL,
   [ECC_Status_Text] [varchar](100) NULL,
   [FZG] [varchar](100) NULL,
   [FZG_1] [varchar](100) NULL,
   [FZG_Liste_1] [varchar](100) NULL,
   [Sel Name_EK_vpp43] [varchar](100) 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,
   [Unit Number_Unit_Hist] [varchar](100) NULL,
   [Line Type] [varchar](100) NULL,
   [Line No] [varchar](100) NULL,
   [Program] [varchar](100) NULL,
   [Function Code] [varchar](100) NULL,
   [Document Date] [datetime] NULL,
   [Document Nr] [varchar](100) NULL,
   [Transaction Code] [varchar](100) NULL,
   [Transaction Code_vpp5a] [varchar](100) NULL,
   [Specify_vpp5a] [varchar](100) NULL,
   [Reference] [varchar](100) NULL,
   [Discount] [decimal](28,8) NULL,
   [Classification Dte] [datetime] NULL,
   [Book Keeping Code2] [varchar](100) NULL,
   [Destination] [varchar](100) NULL,
   [Int Voucher No] [varchar](100) 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] [varchar](100) NULL,
   [Mandant] [varchar](100) NULL,
   [Department_unit_change_hist] [varchar](100) NULL,
   [Unique Ident_unit_change_hist] [varchar](100) NULL,
   [Maximum_Unique_Ident] [varchar](100) NULL,
   [TR Code] [varchar](100) NULL,
   [Zipcode] [varchar](100) NULL
)


GO