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

CREATE TABLE [optima].[NW_BE] (
   [Unit Number] [varchar](100) NULL,
   [Basis Number] [varchar](100) NULL,
   [Ecc Status] [varchar](100) NULL,
   [Vehicle Type] [varchar](100) NULL,
   [Transact Date] [datetime] NULL,
   [Handler] [varchar](100) NULL,
   [Car Creation Date] [datetime] NULL,
   [Pmt Term] [varchar](100) NULL,
   [Small Accessories] [varchar](100) NULL,
   [Small Inv Charge] [varchar](100) NULL,
   [Delivery Stop Code] [varchar](100) NULL,
   [Price Code] [varchar](100) NULL,
   [Discount Perc Work] [varchar](100) NULL,
   [Discount Limit] [varchar](100) NULL,
   [Internal Code] [varchar](100) NULL,
   [Tax Code] [varchar](100) NULL,
   [Unit Last Upd Dte] [datetime] NULL,
   [Depreciation] [varchar](100) NULL,
   [Transfer Tax] [varchar](100) NULL,
   [Book Keeping Code] [varchar](100) NULL,
   [Tax Handling] [varchar](100) NULL,
   [Interest Code] [varchar](100) NULL,
   [Mileage] [varchar](100) NULL,
   [Purch Department] [varchar](100) NULL,
   [Purch Salsman Code] [varchar](100) NULL,
   [Purch Invno] [varchar](100) NULL,
   [Purch Date] [datetime] NULL,
   [Sales Department] [varchar](100) NULL,
   [Sale Salesman] [varchar](100) NULL,
   [Sale Inv Number] [varchar](100) NULL,
   [Sale Date] [datetime] NULL,
   [Scrap Code] [varchar](100) NULL,
   [Unit In Change] [varchar](100) NULL,
   [Bud Sale Det] [decimal](28,8) 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,
   [Prev Owner] [varchar](100) NULL,
   [Owner] [varchar](100) 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,
   [Interest 1] [decimal](28,8) NULL,
   [Interest 2] [varchar](100) NULL,
   [Next Line Unit] [varchar](100) NULL,
   [Next Line 1] [varchar](100) NULL,
   [Transfer Line] [varchar](100) NULL,
   [Transfer Tax Hand] [varchar](100) NULL,
   [Transfer Acc Code] [varchar](100) NULL,
   [Transfer Tax Basis] [varchar](100) NULL,
   [Transfer Tax Pct] [varchar](100) NULL,
   [Transfer Sold] [varchar](100) NULL,
   [Purch Tax] [varchar](100) NULL,
   [Cost Tax] [varchar](100) NULL,
   [Or Mark] [varchar](100) NULL,
   [Transfer Date] [datetime] NULL,
   [Stock Days] [varchar](100) NULL,
   [Delete Proposal] [varchar](100) NULL,
   [Transfer Bbdb] [datetime] NULL,
   [Condition Unit] [varchar](100) NULL,
   [Buying Order No] [varchar](100) NULL,
   [Buying Order Date] [datetime] NULL,
   [Pa Number] [varchar](100) NULL,
   [Vehicle Update] [varchar](100) NULL,
   [Latest Update] [datetime] NULL,
   [Invoice Permission] [varchar](100) NULL,
   [Location Code] [varchar](100) NULL,
   [Account Purchase] [varchar](100) NULL,
   [Account Sales] [varchar](100) NULL,
   [Budg Price Vat] [varchar](100) NULL,
   [Recalc Code] [varchar](100) NULL,
   [Commision No] [varchar](100) NULL,
   [Delivery Date Veh] [datetime] NULL,
   [Reservation Date] [datetime] NULL,
   [Reservation Person] [varchar](100) NULL,
   [Reservation Text] [varchar](100) NULL,
   [Freight Balance] [varchar](100) NULL,
   [Trf Taxbasis Sales] [varchar](100) NULL,
   [Trf Taxbasis Purch] [varchar](100) NULL,
   [Sale Order No] [varchar](100) NULL,
   [Unit Sold] [varchar](100) NULL,
   [Trf Department] [varchar](100) NULL,
   [Order Arrival Date] [datetime] NULL,
   [Order Confirm Date] [datetime] NULL,
   [Price Label Date] [datetime] NULL,
   [Vat Table Work] [varchar](100) NULL,
   [Vat Table Normal] [varchar](100) NULL,
   [Vat Rate Code] [varchar](100) NULL,
   [Transfer Vat Rc] [varchar](100) NULL,
   [Cntract Due Date] [datetime] NULL,
   [Contract Date] [datetime] NULL,
   [Exp Arrival Time] [varchar](100) NULL,
   [Dealer Marking] [varchar](100) NULL,
   [Booking Dealer Nr] [varchar](100) NULL,
   [Desired Deliv Date] [datetime] NULL,
   [Valuation Date] [datetime] NULL,
   [Ford Int Date] [datetime] NULL,
   [Est Sales Price] [varchar](100) NULL,
   [Est Reference No] [varchar](100) NULL,
   [Reception Date] [datetime] NULL,
   [Bud Opt Price] [varchar](100) NULL,
   [Sale Price Date] [datetime] NULL,
   [Purch Origin Code] [varchar](100) NULL,
   [Price List Version] [varchar](100) NULL,
   [Price List Date] [varchar](100) NULL,
   [Unique Ident] [varchar](100) NULL,
   [Vehicle Type2] [varchar](100) NULL,
   [Vehicle Type Text] [varchar](100) NULL,
   [ECC_Status_Text] [varchar](100) NULL,
   [Basis Number2] [varchar](100) NULL,
   [Transact Date2] [datetime] NULL,
   [Handler2] [varchar](100) NULL,
   [Register Number] [varchar](100) NULL,
   [Chassis Number] [varchar](100) NULL,
   [Car Group] [varchar](100) NULL,
   [Car Status] [varchar](100) NULL,
   [Fac Model Code L] [varchar](100) NULL,
   [First Reg Date] [datetime] NULL,
   [Latest Reg Date] [datetime] NULL,
   [First Occur Date] [datetime] NULL,
   [Expected Arr Date] [datetime] NULL,
   [Arrival Date] [datetime] NULL,
   [Salesman Buy] [varchar](100) NULL,
   [Salesman Sale] [varchar](100) NULL,
   [Model Text] [varchar](100) NULL,
   [Orig Model Code1] [varchar](100) NULL,
   [Orig Model Code2] [varchar](100) NULL,
   [Colour Cf] [varchar](100) NULL,
   [Trim Txt] [varchar](100) NULL,
   [Model Line] [varchar](100) NULL,
   [Workshop Model] [varchar](100) NULL,
   [Fac Model Code S] [varchar](100) NULL,
   [Classification] [varchar](100) NULL,
   [Motor Number] [varchar](100) NULL,
   [Key Code] [varchar](100) NULL,
   [Year Model Cf] [varchar](100) NULL,
   [Cylinder Volume] [decimal](28,8) NULL,
   [Seats] [varchar](100) NULL,
   [Declaration Date] [datetime] NULL,
   [Declaration Place] [varchar](100) NULL,
   [Declaration Number] [varchar](100) NULL,
   [Equipment 1] [varchar](100) NULL,
   [Equipment 2] [varchar](100) NULL,
   [Equipment 3] [varchar](100) NULL,
   [Equipment 4] [varchar](100) NULL,
   [Mileage2] [varchar](100) NULL,
   [Misc 1 Cf] [varchar](100) NULL,
   [Misc 2 Cf] [varchar](100) NULL,
   [Misc 3 Cf] [varchar](100) NULL,
   [Misc 4 Cf] [varchar](100) NULL,
   [Misc 5 Cf] [varchar](100) NULL,
   [Misc 6 Cf] [varchar](100) NULL,
   [Misc 7 Cf] [varchar](100) NULL,
   [Misc 8 Cf] [varchar](100) NULL,
   [Misc 9 Cf] [varchar](100) NULL,
   [Misc 10 Cf] [varchar](100) NULL,
   [Motor Code] [varchar](100) NULL,
   [Gear Code] [varchar](100) NULL,
   [Drive Code] [varchar](100) NULL,
   [Colour Code] [varchar](100) NULL,
   [Trim Code] [varchar](100) NULL,
   [No Of Owners] [varchar](100) NULL,
   [Tuv Type] [varchar](100) NULL,
   [Tuv Date] [datetime] NULL,
   [Tuv Insp] [varchar](100) NULL,
   [Asu Type] [varchar](100) NULL,
   [Asu Date] [datetime] NULL,
   [Asu Insp] [varchar](100) NULL,
   [Type Year] [varchar](100) NULL,
   [Available] [varchar](100) NULL,
   [Cal Cost] [varchar](100) NULL,
   [Cal Cost Date] [datetime] NULL,
   [Stock Date] [datetime] NULL,
   [Purch Cal Date] [datetime] NULL,
   [Model Line Group] [varchar](100) NULL,
   [Model Type 2] [varchar](100) NULL,
   [Make] [varchar](100) NULL,
   [Hour Rate Table] [varchar](100) NULL,
   [Paid Date] [datetime] NULL,
   [Latest Inv Date] [datetime] NULL,
   [Purch Amount] [varchar](100) NULL,
   [Dealer Number] [varchar](100) NULL,
   [Dealer Marking2] [varchar](100) NULL,
   [Fueltype] [varchar](100) NULL,
   [Service Days] [varchar](100) NULL,
   [Hourly Repair Rate] [varchar](100) NULL,
   [Workshop Pricecode] [varchar](100) NULL,
   [Discount Perc Work2] [varchar](100) NULL,
   [Soldmark Date] [datetime] NULL,
   [Make Cd] [varchar](100) NULL,
   [Model Line2] [varchar](100) NULL,
   [Mod Lin Specify] [varchar](100) NULL,
   [Make Cd2] [varchar](100) NULL,
   [Workshop Model2] [varchar](100) NULL,
   [Make Cd3] [varchar](100) NULL,
   [Model Text2] [varchar](100) NULL,
   [Orig Model Code] [varchar](100) NULL,
   [Model Type] [varchar](100) NULL,
   [Model Group] [varchar](100) NULL,
   [Make Code] [varchar](100) NULL,
   [Hauptbetrieb] [varchar](100) NULL,
   [Standort] [varchar](100) NULL,
   [Department Type Id] [varchar](100) NULL,
   [Description] [varchar](100) NULL,
   [Fahrzeugart] [varchar](100) NULL,
   [Fabrikat_ori] [varchar](100) NULL,
   [Model] [varchar](100) NULL,
   [Modellbez] [varchar](100) NULL,
   [Fahrgestellnr] [varchar](100) NULL,
   [Farbe] [varchar](100) NULL,
   [FZG] [varchar](100) NULL,
   [Fahrzeugtyp] [varchar](100) NULL,
   [Global Make Cd] [varchar](100) NULL,
   [Description2] [varchar](100) NULL,
   [Einsatz] [decimal](28,8) NULL,
   [Menge] [varchar](100) NULL,
   [Heute] [datetime] NULL,
   [Standtage] [varchar](100) NULL,
   [Standtagestaffel] [varchar](100) NULL,
   [Car Letter] [varchar](100) NULL,
   [Fahrzeugart_Konsi] [varchar](100) NULL,
   [kalk_Kosten] [varchar](100) NULL,
   [Betrieb] [varchar](100) NULL,
   [Seller Code] [varchar](100) NULL,
   [Sel Name] [varchar](100) NULL,
   [VB_Einkauf] [varchar](100) NULL,
   [geplante Kosten] [decimal](28,8) NULL,
   [tatsächl  Kosten] [decimal](28,8) NULL,
   [geplanter VK] [decimal](28,8) NULL,
   [Fabrikat] [varchar](100) NULL,
   [Department_unique_change_history] [varchar](100) NULL,
   [Unique Ident_unique_change_history] [varchar](100) NULL,
   [MAXIMUM  (  Unique Ident_unique_change_history  )] [varchar](100) NULL
)


GO