C11/System/ARI/SQL/schema/GC_DWH_ARI/tables/Offene_Auftraege.sql

CREATE TABLE [dbo].[Offene_Auftraege] (
   [Client_DB] [varchar](20) NOT NULL,
   [Make Code] [varchar](20) NOT NULL,
   [Model] [varchar](50) NOT NULL,
   [Hauptbetrieb] [varchar](1) NOT NULL,
   [Standort] [varchar](2) NULL,
   [Serviceberater] [varchar](101) NULL,
   [Umsatzart] [varchar](6) NOT NULL,
   [Kunde] [varchar](123) NOT NULL,
   [benutzte AW] [float] NULL,
   [Durchgänge] [numeric](13,12) NULL,
   [Tage offen] [float] NULL,
   [gebuchte Teile] [float] NULL,
   [Order Number] [varchar](20) NULL,
   [Invoice Date] [datetime] NOT NULL,
   [Anz. Tage letzte Stemp.] [int] NULL,
   [Intern/Extern] [varchar](6) NOT NULL,
   [Tage über Abholtermin] [float] NULL,
   [Order Number_intern_neu] [varchar](649) NULL,
   [Kostenstelle] [varchar](1) NOT NULL,
   [Fahrzeug] [varchar](20) NOT NULL,
   [Teile] [float] NULL,
   [Fremdl.] [float] NULL,
   [Umsatz Auftrag] [float] NULL,
   [Tag_Dashboard] [int] NULL,
   [Monat_Dashboard] [int] NULL,
   [Jahr_Dashboard] [int] NULL,
   [Location Code] [varchar](10) NOT NULL,
   [Hauptbetrieb_ID] [varchar](20) NULL,
   [Hauptbetrieb_Name] [varchar](50) NULL,
   [Standort_ID] [varchar](20) NULL,
   [Standort_Name] [varchar](50) NULL,
   [Branch ID] [varchar](10) NULL
)


GO