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

CREATE TABLE [optima].[offene_Auftraege] (
   [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] [varchar](100) 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,
   [Order Number] [varchar](100) NULL,
   [Line Number] [varchar](100) NULL,
   [Key Prod Code] [varchar](100) NULL,
   [Key Make Cd] [varchar](100) NULL,
   [Delivery Date2] [datetime] NULL,
   [Line Group Code] [varchar](100) NULL,
   [Transact Date2] [datetime] NULL,
   [Handler2] [varchar](100) NULL,
   [State Code2] [varchar](100) NULL,
   [Person Code] [varchar](100) NULL,
   [Program] [varchar](100) NULL,
   [Function Code] [varchar](100) NULL,
   [Order Linetype] [varchar](100) NULL,
   [Order Linetype 2] [varchar](100) NULL,
   [Order Linetype 3] [varchar](100) NULL,
   [Resulting Line] [varchar](100) NULL,
   [Resulting Line 2] [varchar](100) NULL,
   [Job Code] [varchar](100) NULL,
   [Print Invoice] [varchar](100) NULL,
   [Reduction Code] [varchar](100) NULL,
   [Reduction Amount] [varchar](100) NULL,
   [Reduction Code 2] [varchar](100) NULL,
   [Reduction Pos] [varchar](100) NULL,
   [Split Code] [varchar](100) NULL,
   [Split Code 2] [varchar](100) NULL,
   [Small Accessories2] [varchar](100) NULL,
   [Picked] [varchar](100) NULL,
   [Mechanic Code] [varchar](100) NULL,
   [Salesman2] [varchar](100) NULL,
   [Discount Table] [varchar](100) NULL,
   [Discount Code] [varchar](100) NULL,
   [Claim Code Ind] [varchar](100) NULL,
   [Claim Number] [varchar](100) NULL,
   [Kit Fixed Price Cd] [varchar](100) NULL,
   [R Delivery Date] [datetime] NULL,
   [Wust Code] [varchar](100) NULL,
   [Status2] [varchar](100) NULL,
   [Stock2] [varchar](100) NULL,
   [Gross Discount] [varchar](100) NULL,
   [Statistic Code] [varchar](100) NULL,
   [Decimal Indicator] [varchar](100) NULL,
   [Add Cost Code] [varchar](100) NULL,
   [Discount Perc] [varchar](100) NULL,
   [Discount Perc 2] [varchar](100) NULL,
   [Discount] [decimal](28,8) NULL,
   [Stdprice] [decimal](28,8) NULL,
   [Lines Net Value] [decimal](28,8) NULL,
   [Tax Code 1] [varchar](100) NULL,
   [Vat Rate Code] [varchar](100) NULL,
   [Tax C U] [varchar](100) NULL,
   [Tax Drawn] [varchar](100) NULL,
   [Line Misc Adds] [varchar](100) NULL,
   [Line Misc Adds Per] [varchar](100) NULL,
   [Claim Trouble Cd] [varchar](100) NULL,
   [Split Type] [varchar](100) NULL,
   [Split Am Main] [varchar](100) NULL,
   [Split Am Sub1] [varchar](100) NULL,
   [Split Am Sub2] [varchar](100) NULL,
   [Prod Code] [varchar](100) NULL,
   [Make Cd2] [varchar](100) NULL,
   [Product Group] [varchar](100) NULL,
   [Prod Name] [varchar](100) NULL,
   [Location] [varchar](100) NULL,
   [Location 2] [varchar](100) NULL,
   [Location 3] [varchar](100) NULL,
   [Deductable] [varchar](100) NULL,
   [Order Quantity] [varchar](100) NULL,
   [Delivery Quantity] [varchar](100) NULL,
   [Spec Purch Price] [decimal](28,8) NULL,
   [Re Purchase Price] [decimal](28,8) NULL,
   [Line Costs] [decimal](28,8) NULL,
   [Costprice Tax] [decimal](28,8) NULL,
   [Claim Return Code] [varchar](100) NULL,
   [Inv Total Number] [varchar](100) NULL,
   [Special Price] [varchar](100) NULL,
   [Sales Price] [decimal](28,8) NULL,
   [Sales Price Incl] [decimal](28,8) NULL,
   [Orig Order No] [varchar](100) NULL,
   [Orig Line No] [varchar](100) NULL,
   [Orig Creation Code] [varchar](100) NULL,
   [Back Order Cd] [varchar](100) NULL,
   [Back Order] [varchar](100) NULL,
   [Internal Transfer] [varchar](100) NULL,
   [Stdprice 2] [decimal](28,8) NULL,
   [Quantity Disc Code] [varchar](100) NULL,
   [Campaign Code] [varchar](100) NULL,
   [Replace Code] [varchar](100) NULL,
   [N Main Part No] [varchar](100) NULL,
   [Line Textline 1] [varchar](100) NULL,
   [Line Textline 2] [varchar](100) NULL,
   [Line Textline 3] [varchar](100) NULL,
   [Line Text Code] [varchar](100) NULL,
   [Line Code] [varchar](100) NULL,
   [Line Workshop] [varchar](100) NULL,
   [Back Reg Code] [varchar](100) NULL,
   [Requisition Num] [varchar](100) NULL,
   [Repair Code] [varchar](100) NULL,
   [Repair Group] [varchar](100) NULL,
   [Repair Name] [varchar](100) NULL,
   [Rate Price Code] [varchar](100) NULL,
   [Time Rate] [varchar](100) NULL,
   [Used Time] [varchar](100) NULL,
   [Est Time] [decimal](28,8) NULL,
   [Inv Time] [decimal](28,8) NULL,
   [Repair Code 2] [varchar](100) NULL,
   [Repair Pos] [varchar](100) NULL,
   [Line Comment] [varchar](100) NULL,
   [Inspection 1] [varchar](100) NULL,
   [Inspection 2] [varchar](100) NULL,
   [Work Date] [datetime] NULL,
   [Start Time] [varchar](100) NULL,
   [End Date2] [datetime] NULL,
   [End Time2] [varchar](100) NULL,
   [Workshop Area] [varchar](100) NULL,
   [W Main Repair No] [varchar](100) NULL,
   [Kit Group] [varchar](100) NULL,
   [Kit Code] [varchar](100) NULL,
   [Workshop Model2] [varchar](100) NULL,
   [Kit Text] [varchar](100) NULL,
   [Kit Fixed Price] [varchar](100) NULL,
   [Class Rule] [varchar](100) NULL,
   [Kit One Line] [varchar](100) NULL,
   [Kit One Lineprice] [varchar](100) NULL,
   [Kit Catalog Code] [varchar](100) NULL,
   [Kit Parts Disc Per] [varchar](100) NULL,
   [Kit Work Disc Per] [varchar](100) NULL,
   [Kit Misc Disc Per] [varchar](100) NULL,
   [Kit Delete] [varchar](100) NULL,
   [Kit Price Diff] [varchar](100) NULL,
   [Kit Print Split] [varchar](100) NULL,
   [Type Ol] [varchar](100) NULL,
   [Transaction Code 2] [varchar](100) NULL,
   [Txt Ol] [varchar](100) NULL,
   [Amount Ol] [varchar](100) NULL,
   [Cash Account] [varchar](100) NULL,
   [Repair Code Accu] [varchar](100) NULL,
   [Recommended Price] [decimal](28,8) NULL,
   [Cost Price Work] [varchar](100) NULL,
   [Time Code 1] [varchar](100) NULL,
   [Used Time Type 1] [varchar](100) NULL,
   [Cost Price Type 1] [varchar](100) NULL,
   [Time Code 2] [varchar](100) NULL,
   [Used Time Type 2] [varchar](100) NULL,
   [Cost Price Type 2] [varchar](100) NULL,
   [Discount Allowance] [varchar](100) NULL,
   [Create After Rc] [varchar](100) NULL,
   [Repeat Repair] [varchar](100) NULL,
   [Inv Time Cost] [varchar](100) NULL,
   [Time Code] [varchar](100) NULL,
   [Factor Code] [varchar](100) NULL,
   [Reduction Factor 1] [varchar](100) NULL,
   [Resulting Line 1] [varchar](100) NULL,
   [External Stock] [varchar](100) NULL,
   [Repair Group Type] [varchar](100) NULL,
   [Automatic Created] [varchar](100) NULL,
   [Incomplete Line] [varchar](100) NULL,
   [Incomplete Line 2] [varchar](100) NULL,
   [Order Linetype 4] [varchar](100) NULL,
   [Consignment Code] [varchar](100) NULL,
   [Part Group] [varchar](100) NULL,
   [Misc 1] [varchar](100) NULL,
   [Misc 2] [varchar](100) NULL,
   [Misc 3] [varchar](100) NULL,
   [Misc 4] [varchar](100) NULL,
   [Misc 5] [varchar](100) NULL,
   [Misc 6] [varchar](100) NULL,
   [Order Line Transm] [varchar](100) NULL,
   [Orig Prod Code] [varchar](100) NULL,
   [Orig Make Cd] [varchar](100) NULL,
   [Orig Prod Group] [varchar](100) NULL,
   [Buyers Reference] [varchar](100) NULL,
   [Ccc Category] [varchar](100) NULL,
   [Ccc] [varchar](100) NULL,
   [External Origin] [varchar](100) NULL,
   [Stock Shop List] [varchar](100) NULL,
   [Line Reference] [varchar](100) NULL,
   [Work Type Code] [varchar](100) NULL,
   [Customer Complaint] [varchar](100) NULL,
   [Job Code Descr] [varchar](100) NULL,
   [Text 200] [varchar](200) NULL,
   [Create Msc] [varchar](100) NULL,
   [Special Lock No] [varchar](100) NULL,
   [Supplier Code] [varchar](100) NULL,
   [Requisition Number] [varchar](100) NULL,
   [Used Time Int] [varchar](100) NULL,
   [Est Time Int] [decimal](28,8) NULL,
   [Inv Time Int] [decimal](28,8) NULL,
   [Make Time Unit] [varchar](100) NULL,
   [Deposit Type] [varchar](100) NULL,
   [Line Status] [varchar](100) NULL,
   [Sales Unit Std] [varchar](100) NULL,
   [Sales Unit Alt] [varchar](100) NULL,
   [Order Quantity Alt Unit] [varchar](100) NULL,
   [Oil] [varchar](100) NULL,
   [Deductible Vat] [varchar](100) NULL,
   [Qty Sold Negative] [varchar](100) NULL,
   [Orig Cost Price] [decimal](28,8) NULL,
   [Requested Quantity] [varchar](100) NULL,
   [Unique Ident2] [varchar](100) NULL,
   [Stat Code] [varchar](100) NULL,
   [Stat Specify] [varchar](100) NULL,
   [Department Type Id] [varchar](100) NULL,
   [Description2] [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,
   [Seller Code2] [varchar](100) NULL,
   [Sel Name_Monteur] [varchar](100) NULL,
   [Sel Department2] [varchar](100) NULL,
   [Sel First Name_Monteur] [varchar](100) NULL,
   [Sel Family Name_Monteur] [varchar](100) NULL,
   [Repair Group2] [varchar](100) NULL,
   [Make Cd3] [varchar](100) NULL,
   [AW_Faktor] [varchar](100) NULL,
   [Fabrikat_ori] [varchar](100) NULL,
   [Repair Grp 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,
   [Monteur] [varchar](100) NULL,
   [Auftragsart] [varchar](100) NULL,
   [Auftragsstatus] [varchar](100) NULL,
   [Umsatz Teile Service] [decimal](28,8) NULL,
   [Umsatz Lohn] [decimal](28,8) NULL,
   [Umsatz Teile (nur Teile)] [decimal](28,8) NULL,
   [Status_1] [varchar](100) NULL,
   [verk  Stunden] [decimal](28,8) NULL,
   [Soll-Stunden (Auftrag)] [decimal](28,8) NULL,
   [benutzte Zeit (Auftrag)] [varchar](100) NULL,
   [Umsatz Sonstiges] [varchar](100) NULL,
   [verk  AW] [decimal](28,8) NULL,
   [Kunde] [varchar](100) NULL,
   [Soll AW] [varchar](100) NULL,
   [benutzte AW] [varchar](100) NULL,
   [Global Make Cd] [varchar](100) NULL,
   [Description] [varchar](100) NULL,
   [Model] [varchar](100) NULL,
   [Fahrzeug] [varchar](100) NULL,
   [Auftrag_Det_S] [varchar](255) NULL,
   [Auftrag_Det_T] [varchar](255) NULL,
   [Anzahl Tage] [varchar](100) NULL,
   [Order Number2] [varchar](100) NULL,
   [Fabrikat] [varchar](100) NULL
)


GO