C11/System/NAVISION/SQL/schema/NAVISION_BYD/tables/import.Employee_T.sql

CREATE TABLE [import].[Employee_T] (
   [timestamp] [binary](8) NOT NULL,
   [No_] [varchar](20) NOT NULL,
   [ID No_] [varchar](20) NOT NULL,
   [Search Item] [varchar](30) NOT NULL,
   [Name] [varchar](50) NOT NULL,
   [Last Name] [varchar](30) NOT NULL,
   [First Name] [varchar](30) NOT NULL,
   [Street] [varchar](30) NOT NULL,
   [Post Code] [varchar](20) NOT NULL,
   [City] [varchar](30) NOT NULL,
   [Business Phone No_] [varchar](30) NOT NULL,
   [Private Business Phone No_] [varchar](30) NOT NULL,
   [Fax] [varchar](30) NOT NULL,
   [E-Mail] [varchar](80) NOT NULL,
   [Homepage] [varchar](80) NOT NULL,
   [Sex] [int] NOT NULL,
   [No_ Series] [varchar](10) NOT NULL,
   [Employee No_ - Payroll] [varchar](20) NOT NULL,
   [Target Company - Payroll] [varchar](30) NOT NULL,
   [Destination Journal - Payroll] [varchar](10) NOT NULL,
   [RI_Def_ Task Type TP] [varchar](20) NOT NULL,
   [Destination Company - Sync_] [varchar](30) NOT NULL,
   [Employee No_ - Resource] [varchar](20) NOT NULL,
   [Rented Employees Duty Planning] [tinyint] NOT NULL,
   [Vaca_Car_Fwd_Prev_Y_ Inactive] [tinyint] NOT NULL,
   [Soft-Terminal Coming Inactive] [tinyint] NOT NULL,
   [Soft-Terminal Leaving Inactive] [tinyint] NOT NULL,
   [Soft-Terminal Errand Inactive] [tinyint] NOT NULL,
   [Soft-Terminal Break Inactive] [tinyint] NOT NULL,
   [Soft-Terminal Dept_ Inactive] [tinyint] NOT NULL,
   [Date of Birth] [datetime] NOT NULL,
   [Employment Date] [datetime] NOT NULL,
   [Leaving Date] [datetime] NOT NULL,
   [Begin of Plan Continuation] [datetime] NOT NULL,
   [Begin Special Day Continuation] [datetime] NOT NULL,
   [Fixed-term Contract until] [datetime] NOT NULL,
   [Medical Checkup] [datetime] NOT NULL,
   [Begin Time of Probation] [datetime] NOT NULL,
   [End Time of Probation] [datetime] NOT NULL,
   [Begin Work Permit] [datetime] NOT NULL,
   [End Work Permit] [datetime] NOT NULL,
   [Begin Integration] [datetime] NOT NULL,
   [End Integration] [datetime] NOT NULL,
   [Begin altern_ Vac_ Year] [datetime] NOT NULL,
   [End altern_ Vac_ Year] [datetime] NOT NULL,
   [Working Days _ Week] [int] NOT NULL,
   [Contract No_ - Payroll] [varchar](10) NOT NULL,
   [Employee No_ - Resource EUID] [int] NOT NULL,
   [MS-Project Import Inactive] [tinyint] NOT NULL,
   [Department No_] [varchar](10) NOT NULL,
   [Division No_] [varchar](10) NOT NULL,
   [Activity No_] [varchar](10) NOT NULL,
   [Company No_] [varchar](10) NOT NULL,
   [Pay Group No_] [varchar](10) NOT NULL,
   [State No_] [int] NOT NULL,
   [Group No_ 1] [varchar](10) NOT NULL,
   [Group No_ 2] [varchar](10) NOT NULL,
   [Group No_ 3] [varchar](10) NOT NULL,
   [Time Object No_] [varchar](20) NOT NULL,
   [Key Reference No_] [varchar](10) NOT NULL,
   [Sorting Planning Programs] [int] NOT NULL,
   [Day Object on Pub_ Holidays] [varchar](10) NOT NULL,
   [Employee User ID] [varchar](20) NOT NULL,
   [Bar Code Coming Clocking] [varchar](20) NOT NULL,
   [Bar Code Leaving Clocking] [varchar](20) NOT NULL,
   [Destination Journal - FDC] [int] NOT NULL,
   [Company Reference] [int] NOT NULL,
   [FDC Permissions] [int] NOT NULL,
   [Dynamic Agreed Vacation] [int] NOT NULL,
   [Std_ Vac_ Entitlem_ Days] [decimal](38,20) NOT NULL,
   [Handic_ Vac_ Entitlem_ Days] [decimal](38,20) NOT NULL,
   [Spec_ Vac_2 Entitlem_ Days] [decimal](38,20) NOT NULL,
   [Spec_ Vac_3 Entitlem_ Days] [decimal](38,20) NOT NULL,
   [Std_Vac_Days Car_Fwd_Prev_Y_] [decimal](38,20) NOT NULL,
   [Handic_ Vac_1 Days Car_ Fwd_] [decimal](38,20) NOT NULL,
   [Special Vac_2 Days Car_ Fwd_] [decimal](38,20) NOT NULL,
   [Special Vac_3 Days Car_ Fwd_] [decimal](38,20) NOT NULL,
   [Rem_ Vac_ Days taken] [decimal](38,20) NOT NULL,
   [Rem_ Vac_ Days planned] [decimal](38,20) NOT NULL,
   [Standard Vac_ Entitlement Hrs_] [decimal](38,20) NOT NULL,
   [Handic_ Vac_1 Entitlement Hrs_] [decimal](38,20) NOT NULL,
   [Special Vac_2 Entitlement (H)] [decimal](38,20) NOT NULL,
   [Std_ Vac_Car_Fwd_Prev_Y_(H)] [decimal](38,20) NOT NULL,
   [Handic_ Vac_1 Hours Car_ Fwd_] [decimal](38,20) NOT NULL,
   [Spec_ Vac_2 Hours Car_ Fwd_] [decimal](38,20) NOT NULL,
   [Rem_ Vac_ Hours taken] [decimal](38,20) NOT NULL,
   [Rem_ Vac_ Hrs_ Planned] [decimal](38,20) NOT NULL,
   [Plan Continuation Active] [tinyint] NOT NULL,
   [Rem_ Handic_ Vac_ Days taken] [decimal](38,20) NOT NULL,
   [Rem_ Handic_ Vac_ Days planned] [decimal](38,20) NOT NULL,
   [Options Auto_ Day Finished] [int] NOT NULL,
   [Coming Auto_ Day Finished] [datetime] NOT NULL,
   [Leaving Auto_ Day Finished] [datetime] NOT NULL,
   [Order Continuation Inactive] [tinyint] NOT NULL,
   [Soft-Terminal Vac_ Inactive] [tinyint] NOT NULL,
   [Soft-Terminal Passw_ Inactive] [tinyint] NOT NULL,
   [Soft-Terminal Order Inactive] [tinyint] NOT NULL,
   [Payroll Integration Inactive] [tinyint] NOT NULL,
   [Absent Integration Inactive] [tinyint] NOT NULL,
   [End of Last Plan Continuation] [datetime] NOT NULL,
   [End of last Special Day Cont_] [datetime] NOT NULL,
   [Date of Last Change] [datetime] NOT NULL,
   [Time of Last Change] [datetime] NOT NULL,
   [User No_ of Last Change] [varchar](20) NOT NULL,
   [Date of Last Processing] [datetime] NOT NULL,
   [Duty Planning Inactive] [tinyint] NOT NULL,
   [Synchronization Inactive] [tinyint] NOT NULL,
   [Access Data Active] [tinyint] NOT NULL,
   [All Modules Inactive] [tinyint] NOT NULL,
   [Employee Planning Inactive] [tinyint] NOT NULL,
   [Terminal Acquisition Inactive] [tinyint] NOT NULL,
   [Time Processing Inactive] [tinyint] NOT NULL,
   [Values Car_ Fwd_ Inactive] [tinyint] NOT NULL,
   [Payroll_Absent Int_ Inactive] [tinyint] NOT NULL,
   [Reports Inactive] [tinyint] NOT NULL,
   [Autom_ Plan Cont_ Inactive] [tinyint] NOT NULL,
   [Integration FDC Inactive] [tinyint] NOT NULL,
   [Integr_ FDC unprod_ Inactive] [tinyint] NOT NULL,
   [Soft Terminal Password] [varchar](20) NOT NULL,
   [Monday Absent Days Hours] [decimal](38,20) NOT NULL,
   [Tuesday Absent Days Hours] [decimal](38,20) NOT NULL,
   [Wednesday Absent Days Hours] [decimal](38,20) NOT NULL,
   [Thursday Absent Days Hours] [decimal](38,20) NOT NULL,
   [Friday Absent Days Hours] [decimal](38,20) NOT NULL,
   [Saturday Absent Days Hours] [decimal](38,20) NOT NULL,
   [Sunday Absent Days Hours] [decimal](38,20) NOT NULL,
   [Monday Absent Days Minutes] [decimal](38,20) NOT NULL,
   [Tuesday Absent Days Minutes] [decimal](38,20) NOT NULL,
   [Wednesday Absent Days Minutes] [decimal](38,20) NOT NULL,
   [Thursday Absent Days Minutes] [decimal](38,20) NOT NULL,
   [Friday Absent Days Minutes] [decimal](38,20) NOT NULL,
   [Saturday Absent Days Minutes] [decimal](38,20) NOT NULL,
   [Sunday Absent Days Minutes] [decimal](38,20) NOT NULL,
   [VIP] [tinyint] NOT NULL,
   [Month of Birth] [int] NOT NULL,
   [Day of Birth] [int] NOT NULL,
   [Last Total Key] [varchar](120) NOT NULL,
   [Last Order Clocking] [varchar](20) NOT NULL,
   [Last Task Clocking] [varchar](20) NOT NULL,
   [Date of Last Order Clocking] [datetime] NOT NULL,
   [Date of Last Task Clocking] [datetime] NOT NULL,
   [Counter] [int] NOT NULL,
   [SP_Target Hours] [decimal](38,20) NOT NULL,
   [SP_Target Shifts] [decimal](38,20) NOT NULL,
   [SP_Early Shifts] [decimal](38,20) NOT NULL,
   [SP_Late Shifts] [decimal](38,20) NOT NULL,
   [SP_Night Shifts] [decimal](38,20) NOT NULL,
   [SP_Special Shifts] [decimal](38,20) NOT NULL,
   [SP_Vacation] [decimal](38,20) NOT NULL,
   [SP_Sick] [decimal](38,20) NOT NULL,
   [SP_Misc_] [decimal](38,20) NOT NULL,
   [SP_Total Shifts] [decimal](38,20) NOT NULL,
   [SP_Total Hours] [decimal](38,20) NOT NULL,
   [Coming - Order Begin] [int] NOT NULL,
   [Com-Order_Num_Days before] [int] NOT NULL,
   [Last Clocking Dimension 1] [varchar](20) NOT NULL,
   [Last Clocking Dimension 2] [varchar](20) NOT NULL,
   [Last Clocking Dimension 3] [varchar](20) NOT NULL,
   [Last Clocking Dimension 4] [varchar](20) NOT NULL,
   [Date of Last Clocking Dim_ 1] [datetime] NOT NULL,
   [Date of Last Clocking Dim_ 2] [datetime] NOT NULL,
   [Date of Last Clocking Dim_ 3] [datetime] NOT NULL,
   [Date of Last Clocking Dim_ 4] [datetime] NOT NULL,
   [Present] [tinyint] NOT NULL,
   [Absent] [tinyint] NOT NULL,
   [Address No_] [int] NOT NULL,
   [Action triggered by Card form] [tinyint] NOT NULL,
   [Updated by User ID] [varchar](20) NOT NULL,
   [Update Company] [varchar](30) NOT NULL,
   [Department Code] [varchar](10) NOT NULL,
   [Make Code] [varchar](10) NOT NULL,
   [Default Task Type Code] [varchar](10) NOT NULL,
   [Place of Birth] [varchar](30) NOT NULL,
   [Task Type Group] [varchar](10) NOT NULL,
   [Efficiency %] [decimal](38,20) NOT NULL,
   [Time Acquisition activated] [tinyint] NOT NULL,
   [Booking of Endstamp afterw] [tinyint] NOT NULL,
   [Break Clocking] [int] NOT NULL,
   [Break tolerance %] [decimal](38,20) NOT NULL,
   [Resource No_] [varchar](20) NOT NULL,
   [Rating PEREAS] [decimal](38,20) NOT NULL,
   [PrintFromTimeClock] [tinyint] NOT NULL,
   [User ID] [varchar](20) NOT NULL,
   [Client_DB] [varchar](50) NOT NULL
       DEFAULT ('1')

   ,CONSTRAINT [Employee_T$0] PRIMARY KEY CLUSTERED ([No_], [Client_DB])
)


GO