C11/System/ARI/SQL/schema/GC_DWH_ARI/tables/Kalender_Matrix.sql

CREATE TABLE [dbo].[Kalender_Matrix] (
   [Datum] [date] NULL,
   [Tag_im_Jahr] [int] NOT NULL,
   [Wochentag] [nvarchar](30) NULL,
   [Wochentag_int] [int] NULL,
   [Periode] [int] NULL,
   [Kalenderwoche] [int] NULL,
   [Quartal_int] [int] NULL,
   [Datum_str] [varchar](30) NULL,
   [Datum_int] [int] NULL,
   [MoFr] [int] NOT NULL,
   [MoSa] [int] NOT NULL,
   [Jahr] [varchar](30) NULL,
   [Quartal] [varchar](30) NULL,
   [Monat] [varchar](30) NULL,
   [Tag] [varchar](30) NULL,
   [Heute] [date] NULL,
   [Heute_Vorjahr] [date] NULL,
   [Heute_Vormonat] [date] NULL,
   [Aktueller Tag] [int] NOT NULL,
   [Gestern] [int] NOT NULL,
   [M bisher] [int] NOT NULL,
   [M bisher Vorjahr] [int] NOT NULL,
   [M bisher / M bisher VJ] [int] NULL,
   [Voriger M bisher] [int] NOT NULL,
   [M bisher gruppiert] [int] NULL,
   [Q bisher] [int] NOT NULL,
   [Voriges Q bisher] [int] NOT NULL,
   [Q bisher gruppiert] [int] NULL,
   [J bisher] [int] NOT NULL,
   [Voriges J bisher] [int] NOT NULL,
   [J bisher gruppiert] [int] NULL,
   [Aktueller Monat] [int] NOT NULL,
   [Vormonat (-1)] [int] NOT NULL,
   [Vormonat (-2)] [int] NOT NULL,
   [Vormonat (-3)] [int] NOT NULL,
   [Akt. Monat Vorjahr] [int] NOT NULL,
   [Vormonat (-1) Vorjahr] [int] NOT NULL,
   [Vormonat (-2) Vorjahr] [int] NOT NULL,
   [Vormonat (-3) Vorjahr] [int] NOT NULL,
   [letzte 6 Monate] [int] NOT NULL,
   [letzte 12 Monate] [int] NOT NULL,
   [per Vormonat] [int] NOT NULL,
   [per Vormonat (-2)] [int] NOT NULL,
   [per Vormonat (-3)] [int] NOT NULL,
   [per Vormonat Vorjahr] [int] NOT NULL,
   [per Vormonat (-2) Vorjahr] [int] NOT NULL,
   [per Vormonat (-3) Vorjahr] [int] NOT NULL,
   [Aktuelles Jahr] [int] NOT NULL,
   [letztes Jahr] [int] NOT NULL,
   [3 Monate bis Vormonat (-2)] [int] NOT NULL,
   [Quartal (-1)] [int] NOT NULL,
   [Quartal (-2)] [int] NOT NULL,
   [Quartal (-3)] [int] NOT NULL,
   [Quartal (-1) Vorjahr] [int] NOT NULL,
   [Quartal (-2) Vorjahr] [int] NOT NULL,
   [Quartal (-3) Vorjahr] [int] NOT NULL,
   [Quartal (-1) kum.] [int] NOT NULL,
   [Quartal (-1) kum. Vorjahr] [int] NOT NULL,
   [letzte 11 Monate] [int] NOT NULL,
   [letzte 13 Monate] [int] NOT NULL,
   [letzte 3 Tage] [int] NOT NULL,
   [letzte 7 Tage] [int] NOT NULL,
   [letzte 14 Tage] [int] NOT NULL,
   [letzte 30 Tage] [int] NOT NULL
)


GO