CREATE TABLE [optima].[Department] (
   [CLIENT_DB] [varchar](20) NOT NULL,
   [SALES_DEPARTMENT] [char](4) NOT NULL,
   [NEW_DEPARTMENT] [char](4) NULL,
   [DESCRIPTION] [varchar](50) NULL,
   [DEPARTMENT_TYPE_ID] [char](4) NULL,
   [DEPARTMENT_DESC] [varchar](50) NULL,
   [DEPARTMENT_GROUP] [numeric](2,0) NULL,
   [SITE_ID] [char](10) NULL,
   [SITE_DESC] [varchar](30) NULL,
   [STRATEGIC_AREA_ID] [char](10) NULL,
   [STRATEGIC_AREA_DESC] [varchar](30) NULL,
   [SKR51] [int] NOT NULL,
   [Hauptbetrieb_ID] [varchar](20) NOT NULL,
   [Standort_ID] [varchar](10) NULL,
   [Marke_ID] [varchar](10) NULL,
   [Kostenstelle_ID] [varchar](4) NULL
)


GO