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

CREATE TABLE [dbo].[Forderungen] (
   [Client_DB] [varchar](20) NULL,
   [Document Type] [varchar](20) NULL,
   [Document No] [varchar](30) NULL,
   [User Id] [varchar](50) NULL,
   [On Hold] [varchar](20) NULL,
   [Branch Code] [varchar](20) NULL,
   [Vin] [varchar](20) NULL,
   [Comment] [varchar](200) NULL,
   [offen] [decimal](28,8) NULL,
   [Gesamt offen KD (Info)] [decimal](28,8) NULL,
   [Invoice Date] [datetime] NULL,
   [Hauptbetrieb] [varchar](20) NULL,
   [Standort] [varchar](20) NULL,
   [Sel Name] [varchar](100) NULL,
   [Kunde] [varchar](100) NULL,
   [Kunde_Dashboard] [varchar](100) NULL,
   [Beleg] [varchar](200) NULL,
   [Bereich] [varchar](20) NULL,
   [Tage] [int] NULL,
   [Staffel] [varchar](20) NULL,
   [Mahnstufe] [varchar](10) NULL,
   [Forderungsart] [varchar](20) NULL,
   [Abwarten] [varchar](100) NULL,
   [Message To Recipient] [varchar](100) NULL,
   [Haft_Kasko] [varchar](20) NULL,
   [Hauptbetrieb_ID] [varchar](20) NULL,
   [Hauptbetrieb_Name] [varchar](50) NULL,
   [Standort_ID] [varchar](20) NULL,
   [Standort_Name] [varchar](50) NULL,
   [Branch ID] [varchar](20) NULL,
   [< 2 Wochen] [decimal](28,8) NULL,
   [2 - 4 Wochen] [decimal](28,8) NULL,
   [4 - 6 Wochen] [decimal](28,8) NULL,
   [6 - 12 Wochen] [decimal](28,8) NULL,
   [> 12 Wochen] [decimal](28,8) NULL,
   [noch nicht fällig] [decimal](28,8) NULL
)


GO