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

CREATE TABLE [dbo].[OP_ARI] (
   [Client_DB] [varchar](20) NOT NULL,
   [Document Type] [int] NOT NULL,
   [Document No] [varchar](30) NOT NULL,
   [User Id] [varchar](50) NOT NULL,
   [On Hold] [varchar](3) NOT NULL,
   [Branch Code] [varchar](10) NOT NULL,
   [Vin] [varchar](20) NOT NULL,
   [Comment] [varchar](300) NOT NULL,
   [offen] [float] NULL,
   [Gesamt offen KD (Info)] [float] NULL,
   [Invoice Date] [datetime] NOT NULL,
   [Hauptbetrieb] [varchar](1) NOT NULL,
   [Standort] [varchar](10) NOT NULL,
   [Sel Name] [varchar](124) NULL,
   [Kunde] [varchar](175) NULL,
   [Kunde_Dashboard] [varchar](123) NULL,
   [Beleg] [varchar](505) NULL,
   [Bereich] [varchar](16) NOT NULL,
   [Tage] [int] NULL,
   [Staffel] [nvarchar](17) NULL,
   [Mahnstufe] [int] NOT NULL,
   [Forderungsart] [varchar](17) NOT NULL,
   [Abwarten] [varchar](175) NULL,
   [Message To Recipient] [varchar](140) NOT NULL,
   [Haft_Kasko] [varchar](5) NULL,
   [Hauptbetrieb_ID] [varchar](20) NULL,
   [Hauptbetrieb_Name] [varchar](50) NULL,
   [Standort_ID] [varchar](20) NULL,
   [Standort_Name] [varchar](50) NULL,
   [Branch ID] [varchar](10) NULL,
   [< 2 Wochen] [float] NULL,
   [2 - 4 Wochen] [float] NULL,
   [4 - 6 Wochen] [float] NULL,
   [6 - 12 Wochen] [float] NULL,
   [> 12 Wochen] [float] NULL,
   [noch nicht fällg] [float] NULL
)


GO