C11/System/WERWISO/SQL/schema/ZdbSNCDatawarehouseDATEV/tables/fBuchungsbelege.sql

CREATE TABLE [dbo].[fBuchungsbelege] (
   [Mandant ID] [varchar](3) NULL,
   [Konto] [int] NULL,
   [Belegdatum] [datetime] NULL,
   [BU-Schlüssel] [varchar](50) NULL,
   [Gegenkonto] [int] NULL,
   [Buchungstext] [varchar](100) NULL,
   [Belegfeld 1] [varchar](50) NULL,
   [BSNr] [varchar](50) NULL,
   [Herkunft-Kz] [varchar](50) NULL,
   [Belegfeld 2] [varchar](50) NULL,
   [KOST1 - Kostenstelle] [varchar](50) NULL,
   [KOST2 - Kostenstelle] [varchar](50) NULL,
   [Kost-Menge] [int] NULL,
   [Stück] [int] NULL,
   [Buchungs GUID] [varchar](50) NOT NULL,
   [Leistungsdatum] [date] NULL,
   [Datum Zuord  Steuerperiode] [date] NULL,
   [Konto_Datev_Kontenbeschriftung] [numeric](18,0) NULL,
   [Kontobeschriftung_Datev_Kontenbeschriftung] [varchar](255) NULL,
   [Kostenstelle_Traeger] [varchar](50) NULL,
   [Kurzbezeichnung] [varchar](50) NULL,
   [Langbezeichnung] [varchar](100) NULL,
   [Konto_Zeichen] [varchar](10) NULL,
   [Länge_Konto_Zeichen] [int] NULL,
   [Standort_ID] [varchar](8) NULL,
   [Marke_ID] [varchar](8) NULL,
   [KST_ID] [varchar](8) NULL,
   [Absatzkanal_ID] [varchar](8) NULL,
   [Antriebsart_ID] [varchar](8) NULL,
   [Bookkeep Date] [datetime] NULL,
   [Kostenträger_ID] [varchar](11) NULL,
   [Acct Nr] [varchar](19) NULL,
   [Umsatz Soll] [numeric](18,5) NULL,
   [Umsatz Haben] [numeric](18,5) NULL,
   [Betrag] [numeric](18,5) NULL,
   [PK_Auto] [int] NOT NULL,
   [Marke_mit_Bez] [varchar](63) NULL,
   [Kostenträger_mit_Bez] [varchar](106) NULL,
   [Absatzkanal_mit_Bez] [varchar](63) NULL,
   [Text] [varchar](153) NULL,
   [KST_mit_Bez] [varchar](63) NULL

   ,CONSTRAINT [PK_fBuchungsbelege] PRIMARY KEY CLUSTERED ([Buchungs GUID], [PK_Auto])
)


GO