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

CREATE TABLE [import].[Employee] (
   [timestamp] [binary](8) NOT NULL,
   [No_] [varchar](20) NOT NULL,
   [First Name] [varchar](50) NOT NULL,
   [Middle Name] [varchar](50) NOT NULL,
   [Last Name] [varchar](50) NOT NULL,
   [Initials] [varchar](30) NOT NULL,
   [Job Title] [varchar](50) NOT NULL,
   [Search Name] [varchar](50) NOT NULL,
   [Address] [varchar](50) NOT NULL,
   [Address 2] [varchar](50) NOT NULL,
   [City] [varchar](50) NOT NULL,
   [Post Code] [varchar](20) NOT NULL,
   [County] [varchar](50) NOT NULL,
   [Phone No_] [varchar](50) NOT NULL,
   [Home Mobile Phone No_] [varchar](50) NOT NULL,
   [E-Mail] [varchar](80) NOT NULL,
   [Alt_ Address Code] [varchar](10) NOT NULL,
   [Alt_ Address Start Date] [datetime] NOT NULL,
   [Alt_ Address End Date] [datetime] NOT NULL,
   [Picture] [image] NULL,
   [Birth Date] [datetime] NOT NULL,
   [Social Security No_] [varchar](30) NOT NULL,
   [Union Code] [varchar](10) NOT NULL,
   [Union Membership No_] [varchar](30) NOT NULL,
   [Sex] [int] NOT NULL,
   [Country Code] [varchar](10) NOT NULL,
   [Manager No_] [varchar](20) NOT NULL,
   [Emplymt_ Contract Code] [varchar](10) NOT NULL,
   [Statistics Group Code] [varchar](10) NOT NULL,
   [Employment Date] [datetime] NOT NULL,
   [Status] [int] NOT NULL,
   [Inactive Date] [datetime] NOT NULL,
   [Cause of Inactivity Code] [varchar](10) NOT NULL,
   [Termination Date] [datetime] NOT NULL,
   [Grounds for Term_ Code] [varchar](10) NOT NULL,
   [Department Code] [varchar](10) NOT NULL,
   [Make Code] [varchar](10) NOT NULL,
   [Resource No_] [varchar](20) NOT NULL,
   [Last Date Modified] [datetime] NOT NULL,
   [Direct Phone No_] [varchar](30) NOT NULL,
   [Pager] [varchar](30) NOT NULL,
   [Fax No_] [varchar](30) NOT NULL,
   [Company E-Mail] [varchar](80) NOT NULL,
   [Title] [varchar](30) NOT NULL,
   [Salespers__Purch_ Code] [varchar](10) NOT NULL,
   [No_ Series] [varchar](10) NOT NULL,
   [Time Group Code] [varchar](10) NOT NULL,
   [Card No_] [varchar](20) NOT NULL,
   [PIN Code] [varchar](10) NOT NULL,
   [Address No_] [int] NOT NULL,
   [Date of Update] [datetime] NOT NULL,
   [Time of Update] [datetime] NOT NULL,
   [Updated by User ID] [varchar](20) NOT NULL,
   [Update Company] [varchar](30) NOT NULL,
   [Name] [varchar](30) NOT NULL,
   [Name 2] [varchar](30) NOT NULL,
   [Home Page 2] [varchar](30) NOT NULL,
   [Address Salutation Code] [varchar](10) NOT NULL,
   [Letter Salutation Code] [varchar](10) NOT NULL,
   [Title Code] [varchar](10) NOT NULL,
   [Action triggered by Card form] [tinyint] NOT NULL,
   [Service Advisor] [tinyint] NOT NULL,
   [Function Code] [varchar](10) NOT NULL,
   [Cash Reg_ Access Permitted] [tinyint] NOT NULL,
   [Pmt_ Discount Tolerance Amount] [decimal](38,20) NOT NULL,
   [Pmt_ Discount Tolerance %] [decimal](38,20) NOT NULL,
   [Time Clock Password] [varchar](10) NOT NULL,
   [Default Task Type Code] [varchar](10) NOT NULL,
   [Place of Birth] [varchar](30) NOT NULL,
   [Employee Group No_] [varchar](20) NOT NULL,
   [Task Type Group] [varchar](10) NOT NULL,
   [Efficiency %] [decimal](38,20) NOT NULL,
   [Time Acquisition activated] [tinyint] NOT NULL,
   [Afterw_ closestamp book_] [tinyint] NOT NULL,
   [Request Breaks] [int] NOT NULL,
   [Break tolerance %] [decimal](38,20) NOT NULL,
   [Street] [varchar](30) NOT NULL,
   [House No_] [varchar](10) NOT NULL,
   [Beschäftigungsverhältnis] [int] NOT NULL,
   [Former Address No_] [int] NOT NULL,
   [Client_DB] [varchar](50) NOT NULL
       DEFAULT ('1')

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


GO