CREATE TABLE [optima].[offene_Auftraege_Kopf] (
   [Order Number_ori] [varchar](100) NULL,
   [Register Number] [varchar](100) NULL,
   [Status] [varchar](100) NULL,
   [State Key Date] [datetime] NULL,
   [Debit Account] [varchar](100) NULL,
   [Invoice Number] [varchar](100) NULL,
   [Workshop Model] [varchar](100) NULL,
   [State Code] [varchar](100) NULL,
   [Transact Date] [datetime] NULL,
   [Handler] [varchar](100) NULL,
   [Delivery Account] [varchar](100) NULL,
   [Department] [varchar](100) NULL,
   [Debet Department] [varchar](100) NULL,
   [Salesman] [varchar](100) NULL,
   [Debit Perm] [varchar](100) NULL,
   [Order Date] [datetime] NULL,
   [Delivery Date] [datetime] NULL,
   [Invoice Date] [datetime] NULL,
   [Tax Code] [varchar](100) NULL,
   [Tax Perc] [varchar](100) NULL,
   [Pmt Term] [varchar](100) NULL,
   [Next Line Number] [varchar](100) NULL,
   [Duedate 1] [datetime] NULL,
   [Payment Text] [varchar](100) NULL,
   [Costs] [decimal](28,8) NULL,
   [Purch Tax] [decimal](28,8) NULL,
   [Orders Grossvalue] [decimal](28,8) NULL,
   [Tax Share] [decimal](28,8) NULL,
   [Discount Amount] [decimal](28,8) NULL,
   [Price Code] [varchar](100) NULL,
   [Misc Adds] [varchar](100) NULL,
   [Stock] [varchar](100) NULL,
   [Place Code] [varchar](100) NULL,
   [Internal Code] [varchar](100) NULL,
   [Customer Group] [varchar](100) NULL,
   [Small Accessories] [varchar](100) NULL,
   [Invoice Copy Code] [varchar](100) NULL,
   [Basis Number] [varchar](100) NULL,
   [Mileage] [varchar](100) NULL,
   [Prev Status] [varchar](100) NULL,
   [Sales Class Number] [varchar](100) NULL,
   [Invoice Disc Perc] [varchar](100) NULL,
   [Invoice Rounded] [varchar](100) NULL,
   [Invoice Charge] [varchar](100) NULL,
   [Sales Tax Free] [decimal](28,8) NULL,
   [Title] [varchar](100) NULL,
   [Name] [varchar](100) NULL,
   [Street Addr] [varchar](100) NULL,
   [Addr 2] [varchar](100) NULL,
   [Zipcode] [varchar](100) NULL,
   [Mail Addr] [varchar](100) NULL,
   [Discount Limit] [varchar](100) NULL,
   [Reference Number] [varchar](100) NULL,
   [Expected Order Tim] [varchar](100) NULL,
   [Bol Tax Share] [varchar](100) NULL,
   [Model Text] [varchar](100) NULL,
   [Workshop Pricecode] [varchar](100) NULL,
   [Split Counter] [varchar](100) NULL,
   [Arrival Time] [varchar](100) NULL,
   [Arrival Date] [datetime] NULL,
   [End Date] [datetime] NULL,
   [End Time] [varchar](100) NULL,
   [Fac Model Code S] [varchar](100) NULL,
   [Make Cd] [varchar](100) NULL,
   [Year Model] [varchar](100) NULL,
   [Transfer Make Cd] [varchar](100) NULL,
   [Chassis Number] [varchar](100) NULL,
   [Workshop Team] [varchar](100) NULL,
   [Commission Salesman] [varchar](100) NULL,
   [Ref Ident Inv Total] [varchar](100) NULL,
   [Ref Ident Sales Class] [varchar](100) NULL,
   [Use Parts Pre Picking] [varchar](100) NULL,
   [Ldc Order] [varchar](100) NULL,
   [Fhg Report] [varchar](100) NULL,
   [Actual Inv Date Time] [datetime] NULL,
   [Conv Flag] [varchar](100) NULL,
   [Unique Ident] [varchar](100) NULL,
   [Stat Code] [varchar](100) NULL,
   [Stat Specify] [varchar](100) NULL,
   [Department Type Id] [varchar](100) NULL,
   [Description] [varchar](100) NULL,
   [Seller Code] [varchar](100) NULL,
   [Sel Name] [varchar](100) NULL,
   [Sel Department] [varchar](100) NULL,
   [Sel First Name] [varchar](100) NULL,
   [Sel Family Name] [varchar](100) NULL,
   [Customer Group2] [varchar](100) NULL,
   [Cust Group Specify] [varchar](100) NULL,
   [Hauptbetrieb] [varchar](100) NULL,
   [Standort] [varchar](100) NULL,
   [Marke] [varchar](100) NULL,
   [Kostenstelle] [varchar](100) NULL,
   [Kundenart] [varchar](100) NULL,
   [Umsatzart] [varchar](100) NULL,
   [Geschäftsart] [varchar](100) NULL,
   [Serviceberater] [varchar](100) NULL,
   [Auftragsart] [varchar](100) NULL,
   [Auftragsstatus] [varchar](100) NULL,
   [Status_1] [varchar](100) NULL,
   [Kunde] [varchar](100) NULL,
   [Global Make Cd] [varchar](100) NULL,
   [Description2] [varchar](100) NULL,
   [Fabrikat_ori] [varchar](100) NULL,
   [Model] [varchar](100) NULL,
   [Fahrzeug] [varchar](100) NULL,
   [Durchgänge (Auftrag)] [varchar](100) NULL,
   [Rechnung Gutschrift] [varchar](100) NULL,
   [Order Number] [varchar](100) NULL,
   [Order Number Rg_Ausgang] [varchar](100) NULL,
   [Auftrag_Det_S] [varchar](255) NULL,
   [Fabrikat] [varchar](100) NULL
)


GO
