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

CREATE TABLE [import].[Department] (
   [timestamp] [timestamp] NOT NULL,
   [Code] [varchar](10) NOT NULL,
   [Name] [varchar](50) NOT NULL,
   [Consolidation Code] [varchar](10) NOT NULL,
   [KRMSKR51] [varchar](2) NOT NULL,
   [Client_DB] [varchar](50) NOT NULL
       DEFAULT ('1')

   ,CONSTRAINT [Department$0] PRIMARY KEY CLUSTERED ([Code], [Client_DB])
)


GO