ETL_DWH_LOCOSOFT/schema/GC/tables/locosoft.Aftersales_Rechnungen_ben_AW_final.sql

CREATE TABLE [locosoft].[Aftersales_Rechnungen_ben_AW_final] (
   [Invoice Type] [varchar](100) NULL,
   [Invoice Number] [varchar](100) NULL,
   [Subsidiary] [varchar](100) NULL,
   [Invoice Date] [datetime] NULL,
   [Service Date] [datetime] NULL,
   [Is Canceled] [varchar](100) NULL,
   [Vehicle Number] [varchar](100) NULL,
   [Invoice_Type_Invoice_Number] [varchar](100) NULL,
   [Hauptbetrieb] [varchar](100) NULL,
   [Standort] [varchar](100) NULL,
   [Serviceberater] [varchar](100) NULL,
   [Umsatzart] [varchar](100) NULL,
   [Fabrikat] [varchar](100) NULL,
   [Description_Makes] [varchar](100) NULL,
   [Description_Models] [varchar](200) NULL,
   [Model] [varchar](100) NULL,
   [Fahrzeug] [varchar](400) NULL,
   [Kostenstelle] [varchar](100) NULL,
   [Marke] [varchar](100) NULL,
   [Auftragsart] [varchar](100) NULL,
   [Geschäftsart] [varchar](100) NULL,
   [Kunde] [varchar](100) NULL,
   [Time Units] [varchar](100) NULL,
   [Time Units_Zahl] [decimal](19,8) NULL,
   [AW Std ] [varchar](100) NULL,
   [verk  Std _] [decimal](19,8) NULL,
   [Order Number] [varchar](300) NULL,
   [Order Number_Rg_Ausg] [varchar](200) NULL,
   [Kundenart] [varchar](100) NULL,
   [Summe Duration Minutes] [varchar](100) NULL,
   [Order Number_ben_AW] [varchar](100) NULL,
   [Anzahl_Datensätze_1] [varchar](100) NULL,
   [Anzahl_Datensätze_2] [varchar](100) NULL,
   [ben  Std ] [decimal](19,8) NULL
)


GO