C11/System/WERWISO/SQL/schema/ZdbSNCDatawarehouse/tables/fStempelzeiten.sql

CREATE TABLE [dbo].[fStempelzeiten] (
   [Mandant ID] [varchar](3) NULL,
   [Abwesenheitsart] [varchar](150) NULL,
   [Kostenstelle] [varchar](150) NULL,
   [Extern] [numeric](18,5) NULL,
   [GWL] [numeric](18,5) NULL,
   [Intern] [numeric](18,5) NULL,
   [Sollzeit] [numeric](18,5) NULL,
   [Anwesenheit Meister] [numeric](18,5) NULL,
   [Monteur Azubi] [varchar](150) NULL,
   [Standort_ID] [varchar](150) NULL,
   [Invoice Date] [date] NULL,
   [Order Number] [varchar](150) NULL,
   [Activity_Codes_Group_1] [varchar](150) NULL,
   [Activity_Codes_Group2] [varchar](150) NULL,
   [Activity_Desc] [varchar](150) NULL,
   [prod.] [numeric](18,5) NULL,
   [unprod.] [numeric](18,5) NULL,
   [Anwesenheit Mech Karo Lack] [numeric](18,5) NULL,
   [Abw.] [numeric](18,5) NULL,
   [Hauptbetrieb_ID] [varchar](150) NULL,
   [MonteurNr] [numeric](18,5) NULL
)


GO