C11/System/CARLO/SQL/schema/GC/tables/carlo.Zeit_2_Aftersales.sql

CREATE TABLE [carlo].[Zeit_2_Aftersales] (
   [Employee No] [varchar](100) NULL,
   [Datum] [datetime] NULL,
   [Department No] [varchar](100) NULL,
   [Time Account No] [varchar](100) NULL,
   [Time Account Value] [numeric](18,0) NULL,
   [Ta Class (general)] [numeric](18,0) NULL,
   [Ta Class (statistics)] [numeric](18,0) NULL,
   [Ta Class (absent Days)] [numeric](18,0) NULL,
   [Ta Class (time Processing)] [numeric](18,0) NULL,
   [Ta Class (individual)] [numeric](18,0) NULL,
   [Ta Class (employee Info)] [numeric](18,0) NULL,
   [Ta Class (vacation Reduction)] [numeric](18,0) NULL,
   [Ta Formatting] [numeric](18,0) NULL,
   [Generating Function] [numeric](18,0) NULL,
   [Record Protected] [numeric](18,0) NULL,
   [No] [varchar](100) NULL,
   [Description] [varchar](100) NULL,
   [Description 2] [varchar](100) NULL,
   [Zeitdauer] [decimal](28,8) NULL,
   [Summe  (Zeitdauer) Nr 1] [decimal](28,8) NULL,
   [gesamt Stunden] [decimal](28,8) NULL,
   [Summe  (gesamt Stunden) Nr 3] [decimal](28,8) NULL,
   [Summe  (gesamt Stunden) Nr 2] [decimal](28,8) NULL,
   [Summe  (gesamt Stunden) Nr 1] [decimal](28,8) NULL,
   [Wehr-  Zivildienst] [decimal](28,8) NULL,
   [Innung Azubi] [decimal](28,8) NULL,
   [W-fix Stunden] [decimal](28,8) NULL,
   [Hauptbetrieb] [varchar](100) NULL,
   [Standort] [varchar](100) NULL,
   [First Name] [varchar](100) NULL,
   [Last Name] [varchar](100) NULL,
   [Monteur_Gruppe_ori] [varchar](100) NULL,
   [Abteilung] [varchar](100) NULL,
   [Order Number] [varchar](100) NULL,
   [Monteur_ori] [varchar](100) NULL,
   [Überstunden] [varchar](100) NULL,
   [Leaving Date] [datetime] NULL,
   [Group No 1] [varchar](100) NULL,
   [Group No 2] [varchar](100) NULL,
   [Group No 3] [varchar](100) NULL,
   [Tage Heute Leaving Date] [varchar](100) NULL,
   [Monteur_Gruppe] [varchar](100) NULL,
   [produktiv unproduktiv] [varchar](100) NULL,
   [Monatserster] [datetime] NULL,
   [Monatsletzter] [datetime] NULL,
   [Heute] [datetime] NULL,
   [Datum Tagesbericht] [datetime] NULL,
   [Employment Date] [datetime] NULL,
   [Schulung extern] [decimal](28,8) NULL,
   [Krank] [decimal](28,8) NULL,
   [Arzt] [decimal](28,8) NULL,
   [Urlaub] [decimal](28,8) NULL,
   [Sonderurlaub] [decimal](28,8) NULL,
   [Fehlstunden] [decimal](28,8) NULL,
   [Berufsschule] [decimal](28,8) NULL,
   [Feiertag] [decimal](28,8) NULL,
   [Zeitausgleich] [decimal](28,8) NULL,
   [Kostenstelle] [varchar](100) NULL,
   [Filialcode_Employee] [varchar](100) NULL,
   [Kostenstellencode_Employee] [varchar](100) NULL,
   [Name_Kostenstelle] [varchar](100) NULL,
   [Betrieb] [varchar](100) NULL,
   [Monteur_Gruppe_2] [varchar](100) NULL,
   [Arbeitsvertragscode] [varchar](100) NULL,
   [Serviceberater] [varchar](100) NULL,
   [Abwesenheiten Serviceberater] [decimal](28,8) NULL,
   [Urlaubstage] [decimal](28,8) NULL,
   [Kranktage] [decimal](28,8) NULL,
   [Schultage] [decimal](28,8) NULL,
   [Standort_1] [varchar](100) NULL,
   [Serviceberater_KZ_Employee] [varchar](100) NULL,
   [Invoice Date] [datetime] NULL,
   [Funktion] [varchar](100) NULL,
   [Servicberater   sonst  MA] [varchar](100) NULL
)


GO