ETL_DWH_LOCOSOFT/schema/GC_DWH_LOCOSOFT/tables/current_date_Prognose.sql

CREATE TABLE [dbo].[current_date_Prognose] (
   [Bundeslaender Id] [nvarchar](255) NULL,
   [Invoice Date] [datetime] NULL,
   [Wochentage Id] [nvarchar](255) NULL,
   [Arbeitstag Mofr] [int] NULL,
   [Zaehler Mofr] [int] NULL,
   [Summe Mofr] [int] NULL,
   [Arbeitstag Mosa] [int] NULL,
   [Zaehler Mosa] [int] NULL,
   [Summe Mosa] [int] NULL,
   [Feiertage Id] [int] NULL,
   [Jahr] [int] NULL,
   [Arbeitstag Nr Jahr] [bigint] NULL,
   [Gesamt Arbeitstage] [int] NULL,
   [Tag_Dashboard] [int] NULL,
   [Monat_Dashboard] [int] NULL,
   [Jahr_Dashboard] [int] NULL
)


GO