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

CREATE TABLE [dbo].[Belege] (
   [Client_DB] [varchar](20) NULL,
   [Department Code] [varchar](20) NULL,
   [Make Code] [varchar](20) NULL,
   [Branch Code] [varchar](20) NULL,
   [Bookkeep Date] [datetime] NULL,
   [Acct Nr] [varchar](20) NULL,
   [Betrag] [decimal](28,8) NULL,
   [Text] [varchar](300) NULL,
   [Beleg] [varchar](300) NULL,
   [VIN] [varchar](20) NULL,
   [Hauptbetrieb_ID] [varchar](20) NULL,
   [Hauptbetrieb_Name] [varchar](50) NULL,
   [Standort_ID] [varchar](20) NULL,
   [Standort_Name] [varchar](50) NULL,
   [Marke] [varchar](20) NULL,
   [Fabrikat_Sortierung] [int] NULL,
   [Datum] [date] NULL,
   [Jahr/Monat] [varchar](20) NULL,
   [Aktueller Tag] [date] NULL,
   [Monatserster] [date] NULL,
   [Monatsletzter] [date] NULL,
   [MUN_DATE] [varchar](100) NULL,
   [Mitgliedsname] [varchar](50) NULL,
   [Beginn Geschäftsjahr] [date] NULL,
   [Monat_Jahr] [varchar](20) NULL,
   [Jahr] [varchar](20) NULL,
   [Monat] [varchar](20) NULL,
   [Monat_kurz] [nvarchar](4000) NULL
)


GO