C11/System/AUTOLINE/SQL/schema/AUTOLINE/tables/import.NL_NominalDepartmentCodes.sql

CREATE TABLE [import].[NL_NominalDepartmentCodes] (
   [CostCentre] [decimal](6,0) NOT NULL,
   [ShortName] [varchar](8) NULL,
   [Description001] [varchar](50) NULL,
   [Description002] [varchar](50) NULL,
   [Description003] [varchar](50) NULL,
   [Description004] [varchar](50) NULL,
   [Description005] [varchar](50) NULL,
   [Description006] [varchar](50) NULL,
   [Description007] [varchar](30) NULL,
   [Description008] [varchar](30) NULL,
   [Description009] [varchar](30) NULL,
   [MACode] [decimal](6,0) NULL,
   [CostCentreGroup] [varchar](3) NULL,
   [MAAnalysisCode] [varchar](16) NULL,
   [AccountingDivision] [varchar](2) NULL,
   [UserDefinedCode] [varchar](16) NULL,
   [ExternalSystemCode] [varchar](16) NULL,
   [Client_DB] [varchar](50) NOT NULL
       DEFAULT ('1')

   ,CONSTRAINT [NL_NominalDepartmentCodes$0] PRIMARY KEY CLUSTERED ([CostCentre], [Client_DB])
)


GO