C11/System/CARLO/SQL/exec/Carlo_temp.sql

USE [CARLO]
GO
/****** Object:  Table [temp].[Arbeitswertposten]    Script Date: 30.04.2019 14:25:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [temp].[Arbeitswertposten](
	[timestamp] [binary](8) NOT NULL,
	[Lfd_ Nr_] [int] NOT NULL,
	[Lagerortcode] [varchar](10) NOT NULL,
	[Belegnr_] [varchar](20) NOT NULL,
	[Buchungsdatum] [datetime] NOT NULL,
	[Arbeitswertnr_] [varchar](20) NOT NULL,
	[Markencode] [varchar](10) NOT NULL,
	[Verrechnungsgruppennr_] [varchar](20) NOT NULL,
	[Beschreibung] [varchar](50) NOT NULL,
	[Arbeitstypcode] [varchar](10) NOT NULL,
	[Einheitencode] [varchar](10) NOT NULL,
	[Menge] [decimal](38, 20) NOT NULL,
	[EK-Preis] [decimal](38, 20) NOT NULL,
	[Einstandspreis] [decimal](38, 20) NOT NULL,
	[Einstandsbetrag] [decimal](38, 20) NOT NULL,
	[VK-Preis] [decimal](38, 20) NOT NULL,
	[Verkaufsbetrag] [decimal](38, 20) NOT NULL,
	[Kostenstellencode] [varchar](10) NOT NULL,
	[Menge pro Stunde] [decimal](38, 20) NOT NULL,
	[Menge (Stunde)] [decimal](38, 20) NOT NULL,
	[Benutzer ID] [varchar](20) NOT NULL,
	[Herkunftscode] [varchar](10) NOT NULL,
	[Fakturierbar] [tinyint] NOT NULL,
	[Buch_-Blatt Name] [varchar](10) NOT NULL,
	[Ursachencode] [varchar](10) NOT NULL,
	[Geschäftsbuchungsgruppe] [varchar](10) NOT NULL,
	[Produktbuchungsgruppe] [varchar](10) NOT NULL,
	[Belegdatum] [datetime] NOT NULL,
	[Externe Belegnummer] [varchar](20) NOT NULL,
	[Nummernserie] [varchar](10) NOT NULL,
	[Hauptgruppencode] [varchar](10) NOT NULL,
	[Untergruppencode] [varchar](10) NOT NULL,
	[Positionsgruppencode] [varchar](10) NOT NULL,
	[Verk_ an Deb_-Nr_] [varchar](20) NOT NULL,
	[Rech_ an Deb_-Nr_] [varchar](20) NOT NULL,
	[Fahrgestellnummer] [varchar](20) NOT NULL,
	[Fahrzeugtyp] [varchar](30) NOT NULL,
	[Paketnr_] [varchar](20) NOT NULL,
	[Paketversionsnr_] [int] NOT NULL,
	[Vorgabezeit] [decimal](38, 20) NOT NULL,
	[Ist-Zeit] [decimal](38, 20) NOT NULL,
	[Postenart] [int] NOT NULL,
	[Vorgabezeitart] [int] NOT NULL,
	[Werkstattauftragsnr_] [varchar](20) NOT NULL,
	[Werkstattauftragszeilennr_] [int] NOT NULL,
	[Belegtyp] [int] NOT NULL,
	[Vorgabezeit (Stunde)] [decimal](38, 20) NOT NULL,
	[Filialcode] [varchar](10) NOT NULL,
	[Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [Arbeitswertposten$0] PRIMARY KEY CLUSTERED 
(
	[Lfd_ Nr_] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [temp].[Artikel]    Script Date: 30.04.2019 14:25:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [temp].[Artikel](
	[timestamp] [binary](8) NOT NULL,
	[Nr_] [varchar](20) NOT NULL,
	[Nummer 2] [varchar](20) NOT NULL,
	[Beschreibung] [varchar](30) NOT NULL,
	[Suchbegriff] [varchar](30) NOT NULL,
	[Beschreibung 2] [varchar](30) NOT NULL,
	[Klasse] [varchar](10) NOT NULL,
	[Basiseinheitencode] [varchar](10) NOT NULL,
	[Preisfaktor] [int] NOT NULL,
	[Lagerbuchungsgruppe] [varchar](10) NOT NULL,
	[Regalnummer] [varchar](10) NOT NULL,
	[Verk_-Mengenrabattcode] [varchar](20) NOT NULL,
	[Deb_-_Artikelrabattgr_] [varchar](10) NOT NULL,
	[Rech_-Rabatt zulassen] [tinyint] NOT NULL,
	[Statistikgruppe] [int] NOT NULL,
	[Provisionsgruppe] [int] NOT NULL,
	[VK-Preis] [decimal](38, 20) NOT NULL,
	[VK-Preis_DB - Berechnung] [int] NOT NULL,
	[DB %] [decimal](38, 20) NOT NULL,
	[Lagerabgangsmethode] [int] NOT NULL,
	[Einstandspreis] [decimal](38, 20) NOT NULL,
	[Einstandspreis (fest)] [decimal](38, 20) NOT NULL,
	[EK-Preis (neuester)] [decimal](38, 20) NOT NULL,
	[Einstandspreis (durchschn_)] [decimal](38, 20) NOT NULL,
	[Mindest VK-Preis] [decimal](38, 20) NOT NULL,
	[Kosten %] [decimal](38, 20) NOT NULL,
	[Kreditorennr_] [varchar](20) NOT NULL,
	[Kred_-Artikelnr_] [varchar](20) NOT NULL,
	[Lieferzeit] [varchar](20) NOT NULL,
	[Minimalbestand] [decimal](38, 20) NOT NULL,
	[Maximalbestand] [decimal](38, 20) NOT NULL,
	[Bestellmenge] [decimal](38, 20) NOT NULL,
	[Alternative Artikelnr_] [varchar](20) NOT NULL,
	[Richtpreis] [decimal](38, 20) NOT NULL,
	[Abgabenteil %] [decimal](38, 20) NOT NULL,
	[Abgabencode] [varchar](10) NOT NULL,
	[Bruttogewicht] [decimal](38, 20) NOT NULL,
	[Nettogewicht] [decimal](38, 20) NOT NULL,
	[Anzahl pro Paket] [decimal](38, 20) NOT NULL,
	[Volumen] [decimal](38, 20) NOT NULL,
	[Haltbarkeit] [varchar](10) NOT NULL,
	[Frachtform] [varchar](10) NOT NULL,
	[Zollpos_] [varchar](10) NOT NULL,
	[Zollfaktor] [decimal](38, 20) NOT NULL,
	[Herkunftsland] [varchar](10) NOT NULL,
	[Budgetierte Menge] [decimal](38, 20) NOT NULL,
	[Budgetierter Betrag] [decimal](38, 20) NOT NULL,
	[Budgetierter DB] [decimal](38, 20) NOT NULL,
	[Gesperrt] [tinyint] NOT NULL,
	[Korrigiert am] [datetime] NOT NULL,
	[VK-Preis inkl_ MWSt] [tinyint] NOT NULL,
	[MWSt Geschäftsbuch_-Gr_(Preis)] [varchar](10) NOT NULL,
	[Produktbuchungsgruppe] [varchar](10) NOT NULL,
	[Bild] [image] NULL,
	[Ursprungsland] [varchar](10) NOT NULL,
	[Automat_ Textbaustein] [tinyint] NOT NULL,
	[Nummernserie] [varchar](10) NOT NULL,
	[Steuergruppencode] [varchar](10) NOT NULL,
	[MWSt Produktbuchungsgruppe] [varchar](10) NOT NULL,
	[Reservieren] [int] NOT NULL,
	[Einstandspreis (durchschn)(BW)] [decimal](38, 20) NOT NULL,
	[Stücklistenebene] [int] NOT NULL,
	[Losgröße] [decimal](38, 20) NOT NULL,
	[Seriennr_ Nummernserie] [varchar](10) NOT NULL,
	[Datum letzte Einst_-Preisber_] [datetime] NOT NULL,
	[Materialkosten pro Einheit] [decimal](38, 20) NOT NULL,
	[Bearbeitungskosten pro Einheit] [decimal](38, 20) NOT NULL,
	[Gemeinkosten pro Einheit] [decimal](38, 20) NOT NULL,
	[Ausschuß %] [decimal](38, 20) NOT NULL,
	[Dispositionsmethodencode] [varchar](10) NOT NULL,
	[Ohne Lagerbewertung] [tinyint] NOT NULL,
	[Anzahl Zyklen zusammenfassen] [int] NOT NULL,
	[Minimale Losgröße] [decimal](38, 20) NOT NULL,
	[Maximale Losgröße] [decimal](38, 20) NOT NULL,
	[Sicherheitsbestand] [decimal](38, 20) NOT NULL,
	[Losgrößenrundungsfaktor] [decimal](38, 20) NOT NULL,
	[Sicherheitszuschlag Lieferzeit] [varchar](20) NOT NULL,
	[Buchungsmethode] [int] NOT NULL,
	[Beschaffungsmethode] [int] NOT NULL,
	[Rundungspräzision] [decimal](38, 20) NOT NULL,
	[Verkauf Einheitencode] [varchar](10) NOT NULL,
	[Einkauf Einheitencode] [varchar](10) NOT NULL,
	[Bestellzyklus] [varchar](20) NOT NULL,
	[Gängigkeitsschlüssel] [int] NOT NULL,
	[Neuteilekennung] [tinyint] NOT NULL,
	[Bonusberechtigung] [tinyint] NOT NULL,
	[Lagerwert] [decimal](38, 20) NOT NULL,
	[letzte Berechnung am] [datetime] NOT NULL,
	[letzte Berechnung um] [datetime] NOT NULL,
	[Reifenkennzeichen] [tinyint] NOT NULL,
	[MakeCode] [varchar](10) NOT NULL,
	[Faserlage] [int] NOT NULL,
	[Profilform] [varchar](30) NOT NULL,
	[Profiltiefe (mm)] [int] NOT NULL,
	[Reifeinbreite (mm)] [int] NOT NULL,
	[Querschnittsverhältnis] [int] NOT NULL,
	[Felgendurchmesser in Zoll] [int] NOT NULL,
	[Tragfähigkeitskennzahl] [varchar](10) NOT NULL,
	[Geschwindigkeitskennzeichen] [varchar](10) NOT NULL,
	[Schlauchlos] [tinyint] NOT NULL,
	[Mischung] [varchar](30) NOT NULL,
	[Spikes] [tinyint] NOT NULL,
	[Version Nr_] [varchar](30) NOT NULL,
	[Lochkreisdurchmesser] [decimal](38, 20) NOT NULL,
	[Nabendurchmesser] [decimal](38, 20) NOT NULL,
	[Reifenart] [int] NOT NULL,
	[Sortierung AT] [varchar](20) NOT NULL,
	[Pseudoartikel] [tinyint] NOT NULL,
	[Carline] [tinyint] NOT NULL,
	[Bonuscode] [varchar](10) NOT NULL,
	[GMPD Code] [varchar](10) NOT NULL,
	[GMPD Subcode] [varchar](1) NOT NULL,
	[Gefahrgutkennzeichen] [varchar](10) NOT NULL,
	[Codierungsindikator] [tinyint] NOT NULL,
	[Rush Zuschlags Indikator] [tinyint] NOT NULL,
	[VOR Zuschlags Indikator] [tinyint] NOT NULL,
	[TI-Nummer] [varchar](20) NOT NULL,
	[Nummer Altes DMS] [varchar](20) NOT NULL,
	[Fabrikat_Warenart] [varchar](10) NOT NULL,
	[NEWADA Kostenart] [int] NOT NULL,
	[NEWADA Nachlassart] [int] NOT NULL,
	[Getriebecode] [varchar](10) NOT NULL,
	[Keine Lagerführung] [tinyint] NOT NULL,
	[Listenpreis (MW)] [decimal](38, 20) NOT NULL,
	[Artikelgruppencode] [varchar](10) NOT NULL,
	[Manuelle Preiskalkulation] [tinyint] NOT NULL,
	[VK-Preis mit MWSt] [decimal](38, 20) NOT NULL,
	[Kaution für Hauptartikel] [tinyint] NOT NULL,
	[Artikelart] [int] NOT NULL,
	[Markencode] [varchar](10) NOT NULL,
	[Fahrzeugartencode] [varchar](10) NOT NULL,
	[Fahrzeugklassecode] [varchar](10) NOT NULL,
	[AU Kategoriecode] [varchar](10) NOT NULL,
	[Motorcode] [varchar](10) NOT NULL,
	[Modellcode] [varchar](20) NOT NULL,
	[Garantiesatz %] [decimal](38, 20) NOT NULL,
	[Datum gültig ab] [datetime] NOT NULL,
	[MVEG Verbrauch] [decimal](38, 20) NOT NULL,
	[NOVA Steuer %] [decimal](38, 20) NOT NULL,
	[NOVA Berechnungsart] [varchar](10) NOT NULL,
	[Motorartcode] [varchar](20) NOT NULL,
	[Getriebeartcode] [varchar](20) NOT NULL,
	[Hubraum (ccm)] [decimal](38, 20) NOT NULL,
	[KBA Hersteller] [varchar](10) NOT NULL,
	[KBA Typ] [varchar](10) NOT NULL,
	[Zylinder] [int] NOT NULL,
	[Leistung (KW)] [int] NOT NULL,
	[Leistung (PS)] [int] NOT NULL,
	[Bereifung] [varchar](15) NOT NULL,
	[Leergewicht (KG)] [decimal](38, 20) NOT NULL,
	[Gesamtgewicht (KG)] [decimal](38, 20) NOT NULL,
	[Dachlast (KG)] [decimal](38, 20) NOT NULL,
	[Anhängelast (KG)] [decimal](38, 20) NOT NULL,
	[Stützlast (KG)] [decimal](38, 20) NOT NULL,
	[Allrad] [tinyint] NOT NULL,
	[Anzahl Achsen] [int] NOT NULL,
	[Radstand (mm)] [decimal](38, 20) NOT NULL,
	[Achslast vorne (KG)] [int] NOT NULL,
	[Achslast hinten (KG)] [int] NOT NULL,
	[Marktsegmentcode] [varchar](10) NOT NULL,
	[Anzahl Türen] [int] NOT NULL,
	[Fahrzeugtyp] [varchar](80) NOT NULL,
	[Mindestabnahme (Basis)] [decimal](38, 20) NOT NULL,
	[Hersteller Dispostatus] [varchar](10) NOT NULL,
	[Dispostatus] [varchar](10) NOT NULL,
	[Dispogruppe] [varchar](10) NOT NULL,
	[Manuelle Dispo] [tinyint] NOT NULL,
	[Blockademenge] [decimal](38, 20) NOT NULL,
	[Hauptgruppencode] [varchar](10) NOT NULL,
	[Untergruppencode] [varchar](10) NOT NULL,
	[Positionsgruppencode] [varchar](10) NOT NULL,
	[AW Typ] [varchar](30) NOT NULL,
	[Ersetzungsstatus] [int] NOT NULL,
	[Alter Ersetzungsstatus] [int] NOT NULL,
	[Beschreibung updaten] [tinyint] NOT NULL,
	[Rabatte zulassen] [tinyint] NOT NULL,
	[Listenpreis (MW) inkl_ MWSt] [decimal](38, 20) NOT NULL,
	[AW Verrechnungscode] [varchar](10) NOT NULL,
	[Ers_Stat zurückge_ Benutzer ID] [varchar](20) NOT NULL,
	[Ers_Stat zurückgesetzt Datum] [datetime] NOT NULL,
	[Einsendepflicht] [int] NOT NULL,
	[Ausstattungsklasse] [varchar](20) NOT NULL,
	[Keinen Werkstattzuschlag] [tinyint] NOT NULL,
	[Korrigiert um] [datetime] NOT NULL,
	[Angelegt am] [datetime] NOT NULL,
	[Angelegt um] [datetime] NOT NULL,
	[Kautionsgültigkeit in Tagen] [int] NOT NULL,
	[Saisonfaktor] [varchar](10) NOT NULL,
	[Manuelle Disposition ab Datum] [datetime] NOT NULL,
	[Mindestverpack_- Menge (Basis)] [decimal](38, 20) NOT NULL,
	[Nachschubkennzeichencode] [varchar](10) NOT NULL,
	[Hersteller Positionszähler] [decimal](38, 20) NOT NULL,
	[Herstellerdisposition ab Datum] [datetime] NOT NULL,
	[Grossverpackungsmenge (Basis)] [decimal](38, 20) NOT NULL,
	[Hersteller Dispositionshinweis] [varchar](10) NOT NULL,
	[Einstandspr_ (durchschn_ MW)] [decimal](38, 20) NOT NULL,
	[Einstandspr_ (durchschn_ BW)] [decimal](38, 20) NOT NULL,
	[Prod_ Buch_ Grp_ aus Fahrzeug] [tinyint] NOT NULL,
	[Werterhöhende Massnahme?] [tinyint] NOT NULL,
	[Palettentyp] [varchar](20) NOT NULL,
	[Menge pro Palettentyp] [decimal](38, 20) NOT NULL,
	[TradeClub Part] [tinyint] NOT NULL,
	[CRM Überführungscode] [varchar](10) NOT NULL,
	[Bauart] [int] NOT NULL,
	[Marketingcode] [varchar](10) NOT NULL,
	[VIN necessary] [tinyint] NOT NULL,
	[Prod_ Remark nec_] [tinyint] NOT NULL,
	[Leasing Nebenkosten] [varchar](10) NOT NULL,
	[Manufacturer No_] [varchar](20) NOT NULL,
	[Text 1] [varchar](30) NOT NULL,
	[Text 2] [varchar](30) NOT NULL,
	[Text 3] [varchar](30) NOT NULL,
	[Text 4] [varchar](30) NOT NULL,
	[Ja_Nein 1] [tinyint] NOT NULL,
	[Ja_Nein 2] [tinyint] NOT NULL,
	[Datum 1] [datetime] NOT NULL,
	[Datum 2] [datetime] NOT NULL,
	[Zusatzcode 1] [varchar](10) NOT NULL,
	[Zusatzcode 2] [varchar](10) NOT NULL,
	[Dezimal 1] [decimal](38, 20) NOT NULL,
	[Dezimal 2] [decimal](38, 20) NOT NULL,
	[UnNumber] [varchar](10) NOT NULL,
	[Grundmodell] [varchar](20) NOT NULL,
	[Modell Code] [varchar](20) NOT NULL,
	[Package Code] [varchar](10) NOT NULL,
	[Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [Artikel$0] PRIMARY KEY CLUSTERED 
(
	[Nr_] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [temp].[Debitorenposten]    Script Date: 30.04.2019 14:25:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [temp].[Debitorenposten](
	[timestamp] [binary](8) NOT NULL,
	[Lfd_ Nr_] [int] NOT NULL,
	[Debitorennr_] [varchar](20) NOT NULL,
	[Buchungsdatum] [datetime] NOT NULL,
	[Belegart] [int] NOT NULL,
	[Belegnr_] [varchar](20) NOT NULL,
	[Beschreibung] [varchar](50) NOT NULL,
	[Währungscode] [varchar](10) NOT NULL,
	[Betrag] [decimal](38, 20) NOT NULL,
	[Restbetrag] [decimal](38, 20) NOT NULL,
	[Urspr_ Betrag (MW)] [decimal](38, 20) NOT NULL,
	[Restbetrag (MW)] [decimal](38, 20) NOT NULL,
	[Betrag (MW)] [decimal](38, 20) NOT NULL,
	[Verkauf (MW)] [decimal](38, 20) NOT NULL,
	[DB (MW)] [decimal](38, 20) NOT NULL,
	[Rechnungsrabatt (MW)] [decimal](38, 20) NOT NULL,
	[Verk_ an Deb_-Nr_] [varchar](20) NOT NULL,
	[Debitorenbuchungsgruppe] [varchar](10) NOT NULL,
	[Kostenstellencode] [varchar](10) NOT NULL,
	[Markencode] [varchar](10) NOT NULL,
	[Verkäufercode] [varchar](10) NOT NULL,
	[Benutzer ID] [varchar](20) NOT NULL,
	[Herkunftscode] [varchar](10) NOT NULL,
	[Abwarten] [varchar](3) NOT NULL,
	[Ausgleich-mit Belegart] [int] NOT NULL,
	[Ausgleich-mit Belegnr_] [varchar](20) NOT NULL,
	[Offen] [tinyint] NOT NULL,
	[Fälligkeitsdatum] [datetime] NOT NULL,
	[Skontodatum] [datetime] NOT NULL,
	[Skonto möglich] [decimal](38, 20) NOT NULL,
	[Skonto gewährt (MW)] [decimal](38, 20) NOT NULL,
	[Positiv] [tinyint] NOT NULL,
	[Geschlossen von Lfd_ Nr_] [int] NOT NULL,
	[Geschlossen am] [datetime] NOT NULL,
	[Geschlossen mit Betrag] [decimal](38, 20) NOT NULL,
	[Ausgleichs ID] [varchar](20) NOT NULL,
	[Buch_-Blatt Name] [varchar](10) NOT NULL,
	[Ursachencode] [varchar](10) NOT NULL,
	[Gegenkontoart] [int] NOT NULL,
	[Gegenkontonr_] [varchar](20) NOT NULL,
	[Transaktionsnr_] [int] NOT NULL,
	[Geschl_ mit Betrag (MW)] [decimal](38, 20) NOT NULL,
	[Sollbetrag] [decimal](38, 20) NOT NULL,
	[Habenbetrag] [decimal](38, 20) NOT NULL,
	[Sollbetrag (MW)] [decimal](38, 20) NOT NULL,
	[Habenbetrag (MW)] [decimal](38, 20) NOT NULL,
	[Belegdatum] [datetime] NOT NULL,
	[Externe Belegnummer] [varchar](20) NOT NULL,
	[Zins berechnen] [tinyint] NOT NULL,
	[Abschlußzinsen berechnet] [tinyint] NOT NULL,
	[Nummernserie] [varchar](10) NOT NULL,
	[Geschlossen von Währungscode] [varchar](10) NOT NULL,
	[Geschlossen mit Währungsbetrag] [decimal](38, 20) NOT NULL,
	[Rundungswährung] [varchar](10) NOT NULL,
	[Rundungsbetrag] [decimal](38, 20) NOT NULL,
	[Rundungsbetrag MW] [decimal](38, 20) NOT NULL,
	[Debit Date] [datetime] NOT NULL,
	[Date Pre-Notification] [datetime] NOT NULL,
	[Mandate No_] [varchar](20) NOT NULL,
	[Due Date SEPA] [datetime] NOT NULL,
	[Mandate debit type] [int] NOT NULL,
	[Kundengruppencode] [varchar](20) NOT NULL,
	[Filialcode] [varchar](10) NOT NULL,
	[Hauptbereich] [int] NOT NULL,
	[Pmt_ Disc_ Base] [decimal](38, 20) NOT NULL,
	[Fahrgestellnummer] [varchar](20) NOT NULL,
	[Kassenbelegnr_] [varchar](20) NOT NULL,
	[Bemerkung] [varchar](30) NOT NULL,
	[Datev - Receivables Account] [varchar](20) NOT NULL,
	[Datev - Document No_] [varchar](30) NOT NULL,
	[Datev - Document No_ Assigned] [tinyint] NOT NULL,
	[Datev - imported] [tinyint] NOT NULL,
	[Datev - Line No_] [int] NOT NULL,
	[Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [Debitorenposten$0] PRIMARY KEY CLUSTERED 
(
	[Lfd_ Nr_] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [temp].[Fahrzeug]    Script Date: 30.04.2019 14:25:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [temp].[Fahrzeug](
	[timestamp] [binary](8) NOT NULL,
	[Fahrgestellnummer] [varchar](20) NOT NULL,
	[Fahrzeugstatus] [int] NOT NULL,
	[Modell] [varchar](30) NOT NULL,
	[Suchbegriff] [varchar](30) NOT NULL,
	[Typ] [varchar](30) NOT NULL,
	[Klasse] [varchar](10) NOT NULL,
	[Einheitencode] [varchar](10) NOT NULL,
	[Fahrzeugmodellnr_] [varchar](20) NOT NULL,
	[Statistikgruppe] [int] NOT NULL,
	[VK-Preis] [decimal](38, 20) NOT NULL,
	[VK-Preis_DB - Berechnung] [int] NOT NULL,
	[DB %] [decimal](38, 20) NOT NULL,
	[Einstandspreis] [decimal](38, 20) NOT NULL,
	[Einstandspreis (fest)] [decimal](38, 20) NOT NULL,
	[EK-Preis (neuester)] [decimal](38, 20) NOT NULL,
	[Einstandspreis (durchschn_)] [decimal](38, 20) NOT NULL,
	[Mindest VK-Preis] [decimal](38, 20) NOT NULL,
	[Kosten %] [decimal](38, 20) NOT NULL,
	[Kreditorennr_] [varchar](20) NOT NULL,
	[Kred_-Artikelnr_] [varchar](20) NOT NULL,
	[Lieferzeit] [varchar](20) NOT NULL,
	[Richtpreis] [decimal](38, 20) NOT NULL,
	[Bruttogewicht] [decimal](38, 20) NOT NULL,
	[Nettogewicht] [decimal](38, 20) NOT NULL,
	[Zollpos_] [varchar](10) NOT NULL,
	[Zollfaktor] [decimal](38, 20) NOT NULL,
	[Herkunftsland] [varchar](10) NOT NULL,
	[Gesperrt] [tinyint] NOT NULL,
	[Korrigiert am] [datetime] NOT NULL,
	[Lagerortcode] [varchar](10) NOT NULL,
	[VK-Preis inkl_ MWSt] [tinyint] NOT NULL,
	[MWSt Geschäftsbuch_-Gr_(Preis)] [varchar](10) NOT NULL,
	[Produktbuchungsgruppe] [varchar](10) NOT NULL,
	[Bild] [image] NULL,
	[MWSt Produktbuchungsgruppe] [varchar](10) NOT NULL,
	[Ursprungsland] [varchar](10) NOT NULL,
	[Nummernserie] [varchar](10) NOT NULL,
	[Kostenstellencode] [varchar](10) NOT NULL,
	[Markencode] [varchar](10) NOT NULL,
	[Variantencode] [varchar](10) NOT NULL,
	[Debitorennr_] [varchar](20) NOT NULL,
	[Amtliches Kennzeichen] [varchar](11) NOT NULL,
	[Km-Stand] [decimal](38, 20) NOT NULL,
	[Fahrleistung p_a_] [decimal](38, 20) NOT NULL,
	[Baujahr] [datetime] NOT NULL,
	[Erstzulassung] [datetime] NOT NULL,
	[Anzahl Vorbesitzer] [int] NOT NULL,
	[KFZ Briefnr_] [varchar](8) NOT NULL,
	[EDV Nummer] [varchar](10) NOT NULL,
	[Motorcode] [varchar](10) NOT NULL,
	[Motornummer] [varchar](20) NOT NULL,
	[Schlüsselnr_] [varchar](20) NOT NULL,
	[Fahrzeugklassecode] [varchar](10) NOT NULL,
	[AU Kategoriecode] [varchar](10) NOT NULL,
	[Hubraum (ccm)] [decimal](38, 20) NOT NULL,
	[Fahrzeugartencode] [varchar](10) NOT NULL,
	[AW Typ] [varchar](30) NOT NULL,
	[KBA Hersteller] [varchar](10) NOT NULL,
	[KBA Typ] [varchar](10) NOT NULL,
	[Datum Kundenzulassung] [datetime] NOT NULL,
	[Anlagedatum] [datetime] NOT NULL,
	[Modellcode] [varchar](20) NOT NULL,
	[Getriebeartcode] [varchar](20) NOT NULL,
	[Motorartcode] [varchar](20) NOT NULL,
	[Marktsegmentcode] [varchar](10) NOT NULL,
	[Zylinder] [int] NOT NULL,
	[Leistung (KW)] [int] NOT NULL,
	[Leistung (PS)] [int] NOT NULL,
	[Bereifung] [varchar](15) NOT NULL,
	[Leergewicht (KG)] [decimal](38, 20) NOT NULL,
	[Gesamtgewicht (KG)] [decimal](38, 20) NOT NULL,
	[Dachlast (KG)] [decimal](38, 20) NOT NULL,
	[Anhängelast (KG)] [decimal](38, 20) NOT NULL,
	[Stützlast (KG)] [decimal](38, 20) NOT NULL,
	[Allrad] [tinyint] NOT NULL,
	[Anzahl Achsen] [int] NOT NULL,
	[Radstand (mm)] [decimal](38, 20) NOT NULL,
	[Achslast vorne (KG)] [int] NOT NULL,
	[Achslast hinten (KG)] [int] NOT NULL,
	[Abmeldedatum] [datetime] NOT NULL,
	[Anzahl Türen] [int] NOT NULL,
	[Händlerstatus] [varchar](10) NOT NULL,
	[Eigenverkauf] [tinyint] NOT NULL,
	[Einkaufsdatum] [datetime] NOT NULL,
	[Abgangsdatum] [datetime] NOT NULL,
	[Aktuelle Filialbuchnummer] [varchar](20) NOT NULL,
	[import Fzg_] [tinyint] NOT NULL,
	[Alter Fahrzeugstatus] [int] NOT NULL,
	[Alte Debitorennr_] [varchar](20) NOT NULL,
	[Altes Verkaufsdatum] [datetime] NOT NULL,
	[Alter Eigenverkauf] [tinyint] NOT NULL,
	[Adressnr_] [int] NOT NULL,
	[Alte Buchnummer] [varchar](20) NOT NULL,
	[Alte Filialbuchnummer] [varchar](20) NOT NULL,
	[Einkaufslieferdatum] [datetime] NOT NULL,
	[Lagerbuchungsgruppe] [varchar](10) NOT NULL,
	[Text 1] [varchar](30) NOT NULL,
	[Text 2] [varchar](30) NOT NULL,
	[Ja_Nein 1] [tinyint] NOT NULL,
	[Ja_Nein 2] [tinyint] NOT NULL,
	[Datum 1] [datetime] NOT NULL,
	[Datum 2] [datetime] NOT NULL,
	[Zusatzcode 1] [varchar](10) NOT NULL,
	[Zusatzcode 2] [varchar](10) NOT NULL,
	[Text 3] [varchar](30) NOT NULL,
	[Text 4] [varchar](30) NOT NULL,
	[Aktuelle Buchnummer] [varchar](20) NOT NULL,
	[Brutto Ertrag (MW)] [decimal](38, 20) NOT NULL,
	[Brutto Ertrag %] [decimal](38, 20) NOT NULL,
	[Verkaufsdatum] [datetime] NOT NULL,
	[Aktuelle Preisauszeichnung] [int] NOT NULL,
	[Manuelle Preiskalkulation] [tinyint] NOT NULL,
	[AW Verrechnungscode] [varchar](10) NOT NULL,
	[Schwackecode] [varchar](30) NOT NULL,
	[Lagerfachcode] [varchar](10) NOT NULL,
	[Korrigiert um] [datetime] NOT NULL,
	[Fabrikationscode] [varchar](20) NOT NULL,
	[Unfallwagen] [tinyint] NOT NULL,
	[Gastank-Nummer] [varchar](30) NOT NULL,
	[Gastank-Einbaudatum] [datetime] NOT NULL,
	[mit Nova] [tinyint] NOT NULL,
	[NoVa verrechnet] [tinyint] NOT NULL,
	[NoVa % Satz] [decimal](38, 20) NOT NULL,
	[Modelllinie] [varchar](3) NOT NULL,
	[GM-Modelljahr] [int] NOT NULL,
	[COSCO-Modelljahr] [varchar](1) NOT NULL,
	[Aufbau] [varchar](3) NOT NULL,
	[Techn_ Motorbeschreibung] [varchar](6) NOT NULL,
	[Opel Getriebe Code] [varchar](3) NOT NULL,
	[CC-Kennzeichen] [int] NOT NULL,
	[Letztes CC-Kennzeichen] [int] NOT NULL,
	[Le_ CC-Kz_ Gültig bis] [datetime] NOT NULL,
	[Standort] [varchar](20) NOT NULL,
	[Motorbezeichnung] [varchar](30) NOT NULL,
	[Getriebecode] [varchar](10) NOT NULL,
	[Getriebenummer] [varchar](20) NOT NULL,
	[Getriebebezeichnung] [varchar](30) NOT NULL,
	[G2-Karte] [int] NOT NULL,
	[OPEL Mobilservicecard am] [datetime] NOT NULL,
	[GW Karte] [varchar](20) NOT NULL,
	[Verkäufer Nr_ Verkauf] [varchar](10) NOT NULL,
	[GW-Code] [varchar](3) NOT NULL,
	[Vorbesitzer] [varchar](20) NOT NULL,
	[Vorbesitzername] [varchar](30) NOT NULL,
	[Kommisionsnummer] [varchar](30) NOT NULL,
	[EÜP] [varchar](30) NOT NULL,
	[ZBV-Text 1] [varchar](30) NOT NULL,
	[ZBV-Text 2] [varchar](30) NOT NULL,
	[Kalk_Kosten] [varchar](30) NOT NULL,
	[Portica GW-Code] [varchar](10) NOT NULL,
	[Modelljahr] [int] NOT NULL,
	[Mandantenname] [varchar](30) NOT NULL,
	[Webmobile Export] [tinyint] NOT NULL,
	[Standtage Umlagerung] [int] NOT NULL,
	[Anzahl Bilder] [int] NOT NULL,
	[Verkäufernr Einkauf] [varchar](10) NOT NULL,
	[Dezimal 1] [decimal](38, 20) NOT NULL,
	[Dezimal 2] [decimal](38, 20) NOT NULL,
	[EU Fahrzeug] [int] NOT NULL,
	[Status intern] [int] NOT NULL,
	[Status intern seit] [datetime] NOT NULL,
	[Bauart] [int] NOT NULL,
	[Anzahl Sitze] [int] NOT NULL,
	[Einkaufscode] [varchar](50) NOT NULL,
	[Buy Back Rückstellung] [decimal](38, 20) NOT NULL,
	[Fakturprämie] [decimal](38, 20) NOT NULL,
	[Abnahmeprämie] [decimal](38, 20) NOT NULL,
	[Fahrer] [varchar](30) NOT NULL,
	[PNL-Kennzeichen] [int] NOT NULL,
	[Letztes PNL-Kennzeichen] [int] NOT NULL,
	[Le_ PNL-Kz_ Gültig bis] [datetime] NOT NULL,
	[Inventarnr_] [varchar](20) NOT NULL,
	[Kostenstelle KDW_KDC] [varchar](10) NOT NULL,
	[Fzg_-Grp_ KDW_KDC] [varchar](10) NOT NULL,
	[Max_ Instandsetzungsbetrag] [decimal](38, 20) NOT NULL,
	[Stammnummer KDW_KDC] [varchar](10) NOT NULL,
	[Abt__Name G_-Fzg_ KDW] [varchar](20) NOT NULL,
	[SEAT Mobilitätsgarantie] [datetime] NOT NULL,
	[GW Karte am] [datetime] NOT NULL,
	[Base Process No_] [varchar](20) NOT NULL,
	[Einkaufskanal] [varchar](20) NOT NULL,
	[Nutzlast] [int] NOT NULL,
	[Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [Fahrzeug$0] PRIMARY KEY CLUSTERED 
(
	[Fahrgestellnummer] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [temp].[Fahrzeug_Ausstattung]    Script Date: 30.04.2019 14:25:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [temp].[Fahrzeug_Ausstattung](
	[timestamp] [binary](8) NOT NULL,
	[Fahrgestellnummer] [varchar](20) NOT NULL,
	[Zeilennr_] [int] NOT NULL,
	[Markencode] [varchar](10) NOT NULL,
	[Fahrzeugmodellnr_] [varchar](20) NOT NULL,
	[Ausstattungscode] [varchar](20) NOT NULL,
	[Interner Code] [varchar](10) NOT NULL,
	[Ausstattungskennzeichen] [int] NOT NULL,
	[Kurzbezeichnung] [varchar](10) NOT NULL,
	[Beschreibung] [varchar](30) NOT NULL,
	[Beschreibung 2] [varchar](30) NOT NULL,
	[Verkaufspreis] [decimal](38, 20) NOT NULL,
	[Einstandspreis] [decimal](38, 20) NOT NULL,
	[Verkaufsbetrag] [decimal](38, 20) NOT NULL,
	[Einstandsbetrag] [decimal](38, 20) NOT NULL,
	[Einkaufsrabattbetrag] [decimal](38, 20) NOT NULL,
	[Einkaufsrabatt %] [decimal](38, 20) NOT NULL,
	[Stückliste] [tinyint] NOT NULL,
	[Serienausstattung] [tinyint] NOT NULL,
	[Einbaudatum] [datetime] NOT NULL,
	[Art] [int] NOT NULL,
	[Menge] [decimal](38, 20) NOT NULL,
	[Art der Übernahme] [int] NOT NULL,
	[Sortieroption] [int] NOT NULL,
	[Verkaufsbetrag inkl_ MWSt] [decimal](38, 20) NOT NULL,
	[MWSt %] [decimal](38, 20) NOT NULL,
	[MWSt Bemessungsbetrag] [decimal](38, 20) NOT NULL,
	[Differenzbesteuerung] [tinyint] NOT NULL,
	[Listenpreis] [decimal](38, 20) NOT NULL,
	[Listenpreis inkl_ MWSt] [decimal](38, 20) NOT NULL,
	[Lagerbuchungsgruppe] [varchar](10) NOT NULL,
	[Produktbuchungsgruppe] [varchar](10) NOT NULL,
	[Werkstattauftragsnr_] [varchar](20) NOT NULL,
	[Radiocode] [varchar](20) NOT NULL,
	[Ausstattungsklasse] [varchar](20) NOT NULL,
	[Interner Code suchen] [tinyint] NOT NULL,
	[Ersetzt Ausstattungscode] [varchar](20) NOT NULL,
	[Ersetzt Interner Code] [varchar](10) NOT NULL,
	[Korrigiert am] [datetime] NOT NULL,
	[Korrigiert um] [datetime] NOT NULL,
	[Nicht Drucken] [tinyint] NOT NULL,
	[Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [Fahrzeug Ausstattung$0] PRIMARY KEY CLUSTERED 
(
	[Fahrgestellnummer] ASC,
	[Zeilennr_] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [temp].[Sachposten]    Script Date: 30.04.2019 14:25:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [temp].[Sachposten](
	[timestamp] [binary](8) NOT NULL,
	[Lfd_ Nr_] [int] NOT NULL,
	[Sachkontonr_] [varchar](20) NOT NULL,
	[Buchungsdatum] [datetime] NOT NULL,
	[Belegart] [int] NOT NULL,
	[Belegnr_] [varchar](20) NOT NULL,
	[Beschreibung] [varchar](50) NOT NULL,
	[Gegenkontonr_] [varchar](20) NOT NULL,
	[Betrag] [decimal](38, 20) NOT NULL,
	[Kostenstellencode] [varchar](10) NOT NULL,
	[Markencode] [varchar](10) NOT NULL,
	[Benutzer ID] [varchar](20) NOT NULL,
	[Herkunftscode] [varchar](10) NOT NULL,
	[Systembuchung] [tinyint] NOT NULL,
	[Nachbuchung] [tinyint] NOT NULL,
	[Projektnr_] [varchar](20) NOT NULL,
	[Menge] [decimal](38, 20) NOT NULL,
	[MWSt Betrag] [decimal](38, 20) NOT NULL,
	[Konzernmandantencode] [varchar](10) NOT NULL,
	[Buch_-Blatt Name] [varchar](10) NOT NULL,
	[Ursachencode] [varchar](10) NOT NULL,
	[Buchungsart] [int] NOT NULL,
	[Geschäftsbuchungsgruppe] [varchar](10) NOT NULL,
	[Produktbuchungsgruppe] [varchar](10) NOT NULL,
	[Gegenkontoart] [int] NOT NULL,
	[Transaktionsnr_] [int] NOT NULL,
	[Sollbetrag] [decimal](38, 20) NOT NULL,
	[Habenbetrag] [decimal](38, 20) NOT NULL,
	[Belegdatum] [datetime] NOT NULL,
	[Externe Belegnummer] [varchar](20) NOT NULL,
	[Herkunftsart] [int] NOT NULL,
	[Herkunftsnr_] [varchar](20) NOT NULL,
	[Nummernserie] [varchar](10) NOT NULL,
	[Steuergebietscode] [varchar](20) NOT NULL,
	[Steuerpflichtig] [tinyint] NOT NULL,
	[Steuergruppencode] [varchar](10) NOT NULL,
	[Verbrauchssteuer] [tinyint] NOT NULL,
	[MWSt Geschäftsbuchungsgruppe] [varchar](10) NOT NULL,
	[MWSt Produktbuchungsgruppe] [varchar](10) NOT NULL,
	[Betrag (BW)] [decimal](38, 20) NOT NULL,
	[Sollbetrag (BW)] [decimal](38, 20) NOT NULL,
	[Habenbetrag (BW)] [decimal](38, 20) NOT NULL,
	[FA-Nr_] [varchar](20) NOT NULL,
	[Anlage Postenart] [int] NOT NULL,
	[Anlagenposten Lfd_ Nr_] [int] NOT NULL,
	[Ausgleichs ID] [varchar](20) NOT NULL,
	[geschlossen] [tinyint] NOT NULL,
	[AT-USt_ Betrag] [decimal](38, 20) NOT NULL,
	[Filialcode] [varchar](10) NOT NULL,
	[Hauptbereich] [int] NOT NULL,
	[Fahrgestellnummer] [varchar](20) NOT NULL,
	[Buchnummer] [varchar](20) NOT NULL,
	[Fahrzeug-Kz] [int] NOT NULL,
	[Umgebucht] [tinyint] NOT NULL,
	[Storniert] [tinyint] NOT NULL,
	[Storno für Lfd_ Nr_] [int] NOT NULL,
	[Umbuchung für Lfd_ Nr_] [int] NOT NULL,
	[Datev lfd_Exportnr_] [int] NOT NULL,
	[Alte Sachkontonr_] [varchar](20) NOT NULL,
	[Autom_Ausgleich LfdNr_] [int] NOT NULL,
	[Fahrzeugklassecode] [varchar](10) NOT NULL,
	[geschlossen am] [datetime] NOT NULL,
	[MB_Makecode] [varchar](2) NOT NULL,
	[MB_Locationcode] [varchar](2) NOT NULL,
	[MB_Costcentercode] [varchar](2) NOT NULL,
	[MB_Distributionchannelcode] [varchar](2) NOT NULL,
	[MB_Costunitcode] [varchar](2) NOT NULL,
	[MB_Taxationcode] [varchar](2) NOT NULL,
	[Value Entry No_] [int] NOT NULL,
	[BKR Fzg_-Markencode] [varchar](10) NOT NULL,
	[BKR Datenmarkencode] [varchar](10) NOT NULL,
	[Alter Kostenstellencode] [varchar](10) NOT NULL,
	[Alter Markencode] [varchar](10) NOT NULL,
	[Datev - Allready Transferred] [tinyint] NOT NULL,
	[Datev - Sales VAT Account] [varchar](20) NOT NULL,
	[Datev - Purchase VAT Account] [varchar](20) NOT NULL,
	[Datev - Reverse Chrg_ VAT Acc_] [varchar](20) NOT NULL,
	[Datev - VAT Calculation Type] [int] NOT NULL,
	[Datev - Currency Code] [varchar](10) NOT NULL,
	[Datev - Currency Factor] [decimal](38, 20) NOT NULL,
	[Datev - Amount] [decimal](38, 20) NOT NULL,
	[Datev - VAT Amount] [decimal](38, 20) NOT NULL,
	[Datev - Document No_] [varchar](30) NOT NULL,
	[Datev - Document No_ Assigned] [tinyint] NOT NULL,
	[Datev - imported] [tinyint] NOT NULL,
	[Datev - G_L Account No_] [varchar](20) NOT NULL,
	[Datev - Line No_] [int] NOT NULL,
	[Datev - Issue L + L] [int] NOT NULL,
	[Datev - Func_ Addition L + L] [int] NOT NULL,
	[Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [Sachposten$0] PRIMARY KEY CLUSTERED 
(
	[Lfd_ Nr_] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [temp].[Time_Entry_T]    Script Date: 30.04.2019 14:25:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [temp].[Time_Entry_T](
	[timestamp] [binary](8) NOT NULL,
	[Employee No_] [varchar](20) NOT NULL,
	[Current Date] [datetime] NOT NULL,
	[Department No_] [varchar](10) NOT NULL,
	[Order No_] [varchar](20) NOT NULL,
	[Task No_] [varchar](20) NOT NULL,
	[Dimension 1] [varchar](20) NOT NULL,
	[Dimension 2] [varchar](20) NOT NULL,
	[Dimension 3] [varchar](20) NOT NULL,
	[Dimension 4] [varchar](20) NOT NULL,
	[Time Account No_] [varchar](10) NOT NULL,
	[Time Account Value] [decimal](38, 20) NOT NULL,
	[TA Class (General)] [int] NOT NULL,
	[TA Class (Statistics)] [int] NOT NULL,
	[TA Class (Missing Day)] [int] NOT NULL,
	[TA Class (Time Processing)] [int] NOT NULL,
	[TA Class (Individual)] [int] NOT NULL,
	[TA Class (Employee Info)] [int] NOT NULL,
	[TA Class (Vacation Reduction)] [int] NOT NULL,
	[TA Formatting] [int] NOT NULL,
	[Generate Function] [int] NOT NULL,
	[Record protected] [tinyint] NOT NULL,
	[Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [Time Entry_T$0] PRIMARY KEY CLUSTERED 
(
	[Employee No_] ASC,
	[Current Date] ASC,
	[Department No_] ASC,
	[Order No_] ASC,
	[Task No_] ASC,
	[Dimension 1] ASC,
	[Dimension 2] ASC,
	[Dimension 3] ASC,
	[Dimension 4] ASC,
	[Time Account No_] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [temp].[Verkaufsrechnungskopf]    Script Date: 30.04.2019 14:25:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [temp].[Verkaufsrechnungskopf](
	[timestamp] [binary](8) NOT NULL,
	[Nr_] [varchar](20) NOT NULL,
	[Verk_ an Deb_-Nr_] [varchar](20) NOT NULL,
	[Rech_ an Deb_-Nr_] [varchar](20) NOT NULL,
	[Rech_ an Name] [varchar](30) NOT NULL,
	[Rech_ an Name 2] [varchar](30) NOT NULL,
	[Rech_ an Adresse] [varchar](30) NOT NULL,
	[Rech_ an Adresse 2] [varchar](30) NOT NULL,
	[Rech_ an Ort] [varchar](30) NOT NULL,
	[Rech_ an Kontaktperson] [varchar](30) NOT NULL,
	[Ihre Referenz] [varchar](30) NOT NULL,
	[Lief_ an Code] [varchar](10) NOT NULL,
	[Lief_ an Name] [varchar](30) NOT NULL,
	[Lief_ an Name 2] [varchar](30) NOT NULL,
	[Lief_ an Adresse] [varchar](30) NOT NULL,
	[Lief_ an Adresse 2] [varchar](30) NOT NULL,
	[Lief_ an Ort] [varchar](30) NOT NULL,
	[Lief_ an Kontaktperson] [varchar](30) NOT NULL,
	[Auftragsdatum] [datetime] NOT NULL,
	[Buchungsdatum] [datetime] NOT NULL,
	[Lieferdatum] [datetime] NOT NULL,
	[Buchungsbeschreibung] [varchar](50) NOT NULL,
	[Zlg_-Bedingungscode] [varchar](10) NOT NULL,
	[Fälligkeitsdatum] [datetime] NOT NULL,
	[Skonto %] [decimal](38, 20) NOT NULL,
	[Skontodatum] [datetime] NOT NULL,
	[Lieferbedingungscode] [varchar](10) NOT NULL,
	[Lagerortcode] [varchar](10) NOT NULL,
	[Kostenstellencode] [varchar](10) NOT NULL,
	[Markencode] [varchar](10) NOT NULL,
	[Debitorenbuchungsgruppe] [varchar](10) NOT NULL,
	[Währungscode] [varchar](10) NOT NULL,
	[Währungsfaktor] [decimal](38, 20) NOT NULL,
	[Preisgruppencode] [varchar](10) NOT NULL,
	[VK-Preise inkl_ MWSt] [tinyint] NOT NULL,
	[Mengenrabatt zulassen] [tinyint] NOT NULL,
	[Rechnungsrabattcode] [varchar](20) NOT NULL,
	[Deb_-_Artikelrabattgr_] [varchar](10) NOT NULL,
	[Sprachcode] [varchar](10) NOT NULL,
	[Verkäufercode] [varchar](10) NOT NULL,
	[Auftragsnummer] [varchar](20) NOT NULL,
	[Anzahl gedruckt] [int] NOT NULL,
	[Abwarten] [varchar](3) NOT NULL,
	[Ausgleich-mit Belegart] [int] NOT NULL,
	[Ausgleich-mit Belegnr_] [varchar](20) NOT NULL,
	[Gegenkontonr_] [varchar](20) NOT NULL,
	[Projektnr_] [varchar](20) NOT NULL,
	[USt-IdNr_] [varchar](20) NOT NULL,
	[Ursachencode] [varchar](10) NOT NULL,
	[Geschäftsbuchungsgruppe] [varchar](10) NOT NULL,
	[EU Dreiecksgeschäft] [tinyint] NOT NULL,
	[Art des Geschäftes] [varchar](10) NOT NULL,
	[Verkehrszweig] [varchar](10) NOT NULL,
	[MWSt Ländercode] [varchar](10) NOT NULL,
	[Verk_ an Name] [varchar](30) NOT NULL,
	[Verk_ an Name 2] [varchar](30) NOT NULL,
	[Verk_ an Adresse] [varchar](30) NOT NULL,
	[Verk_ an Adresse 2] [varchar](30) NOT NULL,
	[Verk_ an Ort] [varchar](30) NOT NULL,
	[Verk_ an Kontaktperson] [varchar](30) NOT NULL,
	[Rech_ an PLZ Code] [varchar](20) NOT NULL,
	[Rech_ an Bundesregion] [varchar](30) NOT NULL,
	[Rech_ an Ländercode] [varchar](10) NOT NULL,
	[Verk_ an PLZ Code] [varchar](20) NOT NULL,
	[Verk_ an Bundesregion] [varchar](30) NOT NULL,
	[Verk_ an Ländercode] [varchar](10) NOT NULL,
	[Lief_ an PLZ Code] [varchar](20) NOT NULL,
	[Lief_ an Bundesregion] [varchar](30) NOT NULL,
	[Lief_ an Ländercode] [varchar](10) NOT NULL,
	[Gegenkontoart] [int] NOT NULL,
	[Einladehafen] [varchar](10) NOT NULL,
	[Storno] [tinyint] NOT NULL,
	[Belegdatum] [datetime] NOT NULL,
	[Externe Belegnummer] [varchar](20) NOT NULL,
	[Ursprungsregion] [varchar](10) NOT NULL,
	[Verfahren] [varchar](10) NOT NULL,
	[Zahlungsformcode] [varchar](10) NOT NULL,
	[Spediteurcode] [varchar](10) NOT NULL,
	[Paket Verfolgungsnr_] [varchar](30) NOT NULL,
	[Zugeordnete Nr_ Serie] [varchar](10) NOT NULL,
	[Nummernserie] [varchar](10) NOT NULL,
	[Auftragsnr_ Serie] [varchar](10) NOT NULL,
	[Zugeordnete Nr_] [varchar](20) NOT NULL,
	[Benutzer ID] [varchar](20) NOT NULL,
	[Herkunftscode] [varchar](10) NOT NULL,
	[Steuergebietscode] [varchar](20) NOT NULL,
	[Steuerpflichtig] [tinyint] NOT NULL,
	[MWSt Geschäftsbuchungsgruppe] [varchar](10) NOT NULL,
	[MWSt Bemessungsgr_ Skonto %] [decimal](38, 20) NOT NULL,
	[Adressnr_] [varchar](20) NOT NULL,
	[Drucksteuerung] [int] NOT NULL,
	[Fahrgestellnummer] [varchar](20) NOT NULL,
	[Amtliches Kennzeichen] [varchar](11) NOT NULL,
	[Modell] [varchar](30) NOT NULL,
	[Befund_-Antragnr_] [varchar](20) NOT NULL,
	[Befund_-Jobnr_] [int] NOT NULL,
	[Unfall Reparatur] [tinyint] NOT NULL,
	[Keine Weitergabe pers_ Daten] [tinyint] NOT NULL,
	[aus NEWADA erzeugt] [tinyint] NOT NULL,
	[NEWADA NW-Komm-Nr_] [varchar](10) NOT NULL,
	[NEWADA Betriebsnr_] [varchar](10) NOT NULL,
	[Archived] [int] NOT NULL,
	[Auftragsart] [int] NOT NULL,
	[Kundenbestätigungdatum] [datetime] NOT NULL,
	[Preisgleitklauseldatum] [datetime] NOT NULL,
	[Werkstattauftragsnummer] [varchar](20) NOT NULL,
	[Artikel VK-Preisgruppe] [varchar](10) NOT NULL,
	[Rabatt ausweisen] [tinyint] NOT NULL,
	[Bestellart] [varchar](10) NOT NULL,
	[Rechnungsrabatt %] [decimal](38, 20) NOT NULL,
	[Verk_ an Adressanredecode] [varchar](10) NOT NULL,
	[Rech_ an Adressanredecode] [varchar](10) NOT NULL,
	[Lief_ an Adressanredecode] [varchar](10) NOT NULL,
	[Fahrzeug VK-Preisgruppe] [varchar](10) NOT NULL,
	[Ausstattungs VK-Preisgruppe] [varchar](10) NOT NULL,
	[Kopftexte in Folgebeleg übern_] [tinyint] NOT NULL,
	[Fusstexte in Folgebeleg übern_] [tinyint] NOT NULL,
	[Kundengruppencode] [varchar](10) NOT NULL,
	[Cockpit Lfd_ Nr_] [int] NOT NULL,
	[Werkst_ Auftragsnr_] [varchar](20) NOT NULL,
	[Werkst_ Auftragszeilennr_] [int] NOT NULL,
	[Cockpit Lfd_ Nr_ Buchung] [int] NOT NULL,
	[Belegversand] [int] NOT NULL,
	[Erstes Lieferdatum] [datetime] NOT NULL,
	[Letztes Lieferdatum] [datetime] NOT NULL,
	[Hauptlieferdatum] [datetime] NOT NULL,
	[Filialcode] [varchar](10) NOT NULL,
	[Fahrzeug VK-Preisdatum] [datetime] NOT NULL,
	[POS] [tinyint] NOT NULL,
	[Barzahlung] [tinyint] NOT NULL,
	[Barzahlung Belegart] [int] NOT NULL,
	[Kassenbeleg] [varchar](20) NOT NULL,
	[Aktionen erstellt] [tinyint] NOT NULL,
	[Serviceberaternr_] [varchar](20) NOT NULL,
	[LDC Errorcode] [varchar](10) NOT NULL,
	[LDC Data] [tinyint] NOT NULL,
	[Auftragszeit] [datetime] NOT NULL,
	[LDC Reasoncode] [varchar](10) NOT NULL,
	[LDC Ref Ack_Ship] [varchar](20) NOT NULL,
	[Tour Code] [varchar](20) NOT NULL,
	[LDC ext_ Auftragsnummer] [varchar](20) NOT NULL,
	[Finanzierung_Leasing] [tinyint] NOT NULL,
	[Finanzierung_Leasing Bank] [varchar](30) NOT NULL,
	[TradeClub Membership No_] [varchar](30) NOT NULL,
	[Dispounwirksam] [tinyint] NOT NULL,
	[Garantiesperre] [tinyint] NOT NULL,
	[Kundenkontaktprogramm] [tinyint] NOT NULL,
	[Service Mobil] [tinyint] NOT NULL,
	[Hauspreis] [tinyint] NOT NULL,
	[Verkäuferprovision] [decimal](38, 20) NOT NULL,
	[Vermittlerprovision] [decimal](38, 20) NOT NULL,
	[Wertschecks] [decimal](38, 20) NOT NULL,
	[Fahrer] [varchar](30) NOT NULL,
	[Sonstige Provision] [decimal](38, 20) NOT NULL,
	[Abnahmeprämie] [decimal](38, 20) NOT NULL,
	[Sonstige Prämie] [decimal](38, 20) NOT NULL,
	[BKO Prämie in %] [decimal](38, 20) NOT NULL,
	[Fakturaprämie] [decimal](38, 20) NOT NULL,
	[Zulassungprämie] [decimal](38, 20) NOT NULL,
	[Händleranteil Finanzierung] [decimal](38, 20) NOT NULL,
	[GW-Überzahlung] [decimal](38, 20) NOT NULL,
	[Abnahmeprämie %] [decimal](38, 20) NOT NULL,
	[Fakturaprämie %] [decimal](38, 20) NOT NULL,
	[Zulassungsprämie %] [decimal](38, 20) NOT NULL,
	[Sonstige Prämie %] [decimal](38, 20) NOT NULL,
	[Vermittlung] [tinyint] NOT NULL,
	[Werksauftragsnr_] [varchar](20) NOT NULL,
	[Inventarnr_] [varchar](20) NOT NULL,
	[Kontonummer KDW_KDC] [varchar](10) NOT NULL,
	[Ext_ Debitorenkonto] [varchar](20) NOT NULL,
	[Ext_ Debitorennr_] [varchar](20) NOT NULL,
	[Ext_ Belegnr_] [varchar](20) NOT NULL,
	[Kostenstelle KDW_KDC] [varchar](10) NOT NULL,
	[Stammnummer KDW_KSC] [varchar](10) NOT NULL,
	[Auftragskategorie KDW_KDC] [varchar](10) NOT NULL,
	[Abt__Name G_-Fzg_ KDW] [varchar](20) NOT NULL,
	[Bewegungsart KDW_KDC] [int] NOT NULL,
	[Team _ Abteilung KDW_KDC] [varchar](10) NOT NULL,
	[Schaden Nr_] [varchar](13) NOT NULL,
	[Schadenart] [int] NOT NULL,
	[Schadendatum] [datetime] NOT NULL,
	[Abtretungskennzeichen] [int] NOT NULL,
	[VVD-Rechnung] [tinyint] NOT NULL,
	[Leasing-Nummer] [varchar](10) NOT NULL,
	[Rechnungsüberschrift] [varchar](30) NOT NULL,
	[TV-Fahrgest_ Nr_] [varchar](20) NOT NULL,
	[Belegkategorie] [varchar](10) NOT NULL,
	[Process No_] [varchar](20) NOT NULL,
	[Service Contract Lock] [tinyint] NOT NULL,
	[Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [Verkaufsrechnungskopf$0] PRIMARY KEY CLUSTERED 
(
	[Nr_] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [temp].[Verkaufsrechnungszeile]    Script Date: 30.04.2019 14:25:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [temp].[Verkaufsrechnungszeile](
	[timestamp] [binary](8) NOT NULL,
	[Belegnr_] [varchar](20) NOT NULL,
	[Zeilennr_] [int] NOT NULL,
	[Verk_ an Deb_-Nr_] [varchar](20) NOT NULL,
	[Art] [int] NOT NULL,
	[Nr_] [varchar](20) NOT NULL,
	[Lagerortcode] [varchar](10) NOT NULL,
	[Buchungsgruppe] [varchar](10) NOT NULL,
	[Mengenrabattcode] [varchar](20) NOT NULL,
	[Lieferdatum] [datetime] NOT NULL,
	[Beschreibung] [varchar](50) NOT NULL,
	[Beschreibung 2] [varchar](50) NOT NULL,
	[Einheit] [varchar](10) NOT NULL,
	[Menge] [decimal](38, 20) NOT NULL,
	[VK-Preis] [decimal](38, 20) NOT NULL,
	[Einstandspreis (MW)] [decimal](38, 20) NOT NULL,
	[MWSt %] [decimal](38, 20) NOT NULL,
	[Mengenrabatt %] [decimal](38, 20) NOT NULL,
	[Zeilenrabatt %] [decimal](38, 20) NOT NULL,
	[Zeilenrabattbetrag] [decimal](38, 20) NOT NULL,
	[Betrag] [decimal](38, 20) NOT NULL,
	[Betrag inkl_ MWSt] [decimal](38, 20) NOT NULL,
	[Rech_-Rabatt zulassen] [tinyint] NOT NULL,
	[Bruttogewicht] [decimal](38, 20) NOT NULL,
	[Nettogewicht] [decimal](38, 20) NOT NULL,
	[Anzahl pro Paket] [decimal](38, 20) NOT NULL,
	[Volumen] [decimal](38, 20) NOT NULL,
	[Ausgleich mit Artikelposten] [int] NOT NULL,
	[Kostenstellencode] [varchar](10) NOT NULL,
	[Markencode] [varchar](10) NOT NULL,
	[Preisgruppencode] [varchar](10) NOT NULL,
	[Mengenrabatt zulassen] [tinyint] NOT NULL,
	[Projektnr_] [varchar](20) NOT NULL,
	[Ausgleich mit Projektposten] [int] NOT NULL,
	[Hauptaktivitätscode] [varchar](10) NOT NULL,
	[Unteraktivitätscode] [varchar](10) NOT NULL,
	[Teilaktivitätscode] [varchar](10) NOT NULL,
	[Projektp_ Ausgl_-ID] [varchar](20) NOT NULL,
	[Ausgl_ u_ schließen (Proj_)] [tinyint] NOT NULL,
	[Arbeitstypencode] [varchar](10) NOT NULL,
	[Seriennr_] [varchar](20) NOT NULL,
	[Deb_-_Artikelrabatt %] [decimal](38, 20) NOT NULL,
	[Rechnungsrabattbetrag] [decimal](38, 20) NOT NULL,
	[Direktlieferung] [tinyint] NOT NULL,
	[Geschäftsbuchungsgruppe] [varchar](10) NOT NULL,
	[Produktbuchungsgruppe] [varchar](10) NOT NULL,
	[MWSt Berechnungsart] [int] NOT NULL,
	[Art des Geschäftes] [varchar](10) NOT NULL,
	[Verkehrszweig] [varchar](10) NOT NULL,
	[Gehört zu Zeilennr_] [int] NOT NULL,
	[Einladehafen] [varchar](10) NOT NULL,
	[Ursprungsregion] [varchar](10) NOT NULL,
	[Verfahren] [varchar](10) NOT NULL,
	[Steuergebietscode] [varchar](20) NOT NULL,
	[Steuerpflichtig] [tinyint] NOT NULL,
	[Steuergruppencode] [varchar](10) NOT NULL,
	[MWSt Geschäftsbuchungsgruppe] [varchar](10) NOT NULL,
	[MWSt Produktbuchungsgruppe] [varchar](10) NOT NULL,
	[Rahmenauftragsnr_] [varchar](20) NOT NULL,
	[Rahmenauftragszeilennr_] [int] NOT NULL,
	[MWSt Bemessungsgrundlage] [decimal](38, 20) NOT NULL,
	[Einstandspreis] [decimal](38, 20) NOT NULL,
	[Buchnummer] [varchar](20) NOT NULL,
	[Variantencode] [varchar](10) NOT NULL,
	[Lagerfachcode] [varchar](10) NOT NULL,
	[Menge pro Einheit] [decimal](38, 20) NOT NULL,
	[Einheitencode] [varchar](10) NOT NULL,
	[Menge (Basis)] [decimal](38, 20) NOT NULL,
	[Suchbegriff] [varchar](30) NOT NULL,
	[Bonuscode] [varchar](10) NOT NULL,
	[Auftragsnummer] [varchar](20) NOT NULL,
	[Auftragszeilennr_] [int] NOT NULL,
	[Buchungsdatum] [datetime] NOT NULL,
	[Filialbuchnummer] [varchar](20) NOT NULL,
	[Auftragsart] [int] NOT NULL,
	[Artikelart] [int] NOT NULL,
	[Fahrgestellnummer] [varchar](20) NOT NULL,
	[Fahrzeugstatus] [int] NOT NULL,
	[Zulassungsdatum] [datetime] NOT NULL,
	[Km-Stand] [int] NOT NULL,
	[Geplante Lieferwoche] [datetime] NOT NULL,
	[Amtliches Kennzeichen] [varchar](20) NOT NULL,
	[Einrückung] [int] NOT NULL,
	[Zusammenzählung] [varchar](30) NOT NULL,
	[Werkst_ Auftragsnr_] [varchar](20) NOT NULL,
	[Werkst_ Auftragszeilennr_] [int] NOT NULL,
	[Arbeitswertmarkencode] [varchar](10) NOT NULL,
	[Arbeitswertnr_] [varchar](20) NOT NULL,
	[AT-USt_ Bemessungsgrundlage] [decimal](38, 20) NOT NULL,
	[AT-USt %] [decimal](38, 20) NOT NULL,
	[AT-USt_ Betrag] [decimal](38, 20) NOT NULL,
	[AT-MWSt_ %] [decimal](38, 20) NOT NULL,
	[Rabatte zulassen] [tinyint] NOT NULL,
	[Cockpit Lfd_ Nr_] [int] NOT NULL,
	[Gedruckte Kautionen] [decimal](38, 20) NOT NULL,
	[Zusatzartikel] [int] NOT NULL,
	[Kundengruppencode] [varchar](10) NOT NULL,
	[Artikelgruppencode] [varchar](10) NOT NULL,
	[Mengenmultiplikator] [decimal](38, 20) NOT NULL,
	[Cockpit Lfd_ Nr_ Buchung] [int] NOT NULL,
	[Kulanz] [tinyint] NOT NULL,
	[Autom_ Zuschlag] [tinyint] NOT NULL,
	[Werkst_ Zuschlagscode] [varchar](10) NOT NULL,
	[Aus Fzg_ AusstattRech_ BelArt] [int] NOT NULL,
	[Aus Fzg_ AusstattRech_ BelNr_] [varchar](20) NOT NULL,
	[Aus Fzg_ AusstattRech_ BelZeil] [int] NOT NULL,
	[Aus Fzg_ AusstattRech_ ZeilArt] [int] NOT NULL,
	[Aus Fzg_ AusstattRech_ Nr_] [varchar](20) NOT NULL,
	[Aus Fzg_ AusstattRech_ IntCode] [varchar](10) NOT NULL,
	[Einsendepflicht] [int] NOT NULL,
	[Verkaufszeile Belegnr_] [varchar](20) NOT NULL,
	[Verkaufszeile Zeilennr_] [int] NOT NULL,
	[Verkaufszeile Belegart] [int] NOT NULL,
	[Hauptdebitor] [tinyint] NOT NULL,
	[Fahrzeug VK-Preisdatum] [datetime] NOT NULL,
	[Regalnummer] [varchar](10) NOT NULL,
	[Erstes Lieferdatum] [datetime] NOT NULL,
	[Letztes Lieferdatum] [datetime] NOT NULL,
	[Geschl_ von Lieferungsnr_] [varchar](20) NOT NULL,
	[Abschl_ Liefermenge] [decimal](38, 20) NOT NULL,
	[Liefernr_ nicht geschlossen] [varchar](20) NOT NULL,
	[Restliefermenge] [decimal](38, 20) NOT NULL,
	[LDC Errorcode] [varchar](10) NOT NULL,
	[LDC Data] [tinyint] NOT NULL,
	[Auftragszeit] [datetime] NOT NULL,
	[LDC Reasoncode] [varchar](10) NOT NULL,
	[LDC PartNo_] [varchar](20) NOT NULL,
	[LDC DealerBinRemark] [varchar](20) NOT NULL,
	[LDC Ref Ack_Ship] [varchar](20) NOT NULL,
	[Tour Code] [varchar](20) NOT NULL,
	[Menge urspr_ bestellt] [decimal](38, 20) NOT NULL,
	[Externe Auftragsnummer] [varchar](20) NOT NULL,
	[Ext_ Auftr_Zeilennr] [int] NOT NULL,
	[Lieferadresscode] [varchar](20) NOT NULL,
	[Bestellart] [varchar](20) NOT NULL,
	[LDC Urspr_ Artikelnummer] [varchar](20) NOT NULL,
	[LDC Urspr_ Suchbegriff] [varchar](30) NOT NULL,
	[Urspr_ Cockpit Zeilennr_] [int] NOT NULL,
	[Bonus %] [decimal](38, 20) NOT NULL,
	[Vergütung %] [decimal](38, 20) NOT NULL,
	[Rechnungszeile CIO] [int] NOT NULL,
	[TradeClub Part] [tinyint] NOT NULL,
	[Anteil %] [decimal](38, 20) NOT NULL,
	[Dispounwirksam] [tinyint] NOT NULL,
	[Datenmarkencode] [varchar](10) NOT NULL,
	[BKR Fzg_-Markencode] [varchar](10) NOT NULL,
	[BKR Datenmarkencode] [varchar](10) NOT NULL,
	[Belegkategorie] [varchar](10) NOT NULL,
	[Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [Verkaufsrechnungszeile$0] PRIMARY KEY CLUSTERED 
(
	[Belegnr_] ASC,
	[Zeilennr_] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [temp].[Werkstattposten]    Script Date: 30.04.2019 14:25:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [temp].[Werkstattposten](
	[timestamp] [binary](8) NOT NULL,
	[Lfd_ Nr_] [int] NOT NULL,
	[Auftragsnr_] [varchar](20) NOT NULL,
	[Buchungsdatum] [datetime] NOT NULL,
	[Belegnr_] [varchar](20) NOT NULL,
	[Art] [int] NOT NULL,
	[Nr_] [varchar](20) NOT NULL,
	[Beschreibung] [varchar](50) NOT NULL,
	[Menge] [decimal](38, 20) NOT NULL,
	[EK-Preis] [decimal](38, 20) NOT NULL,
	[Einstandspreis] [decimal](38, 20) NOT NULL,
	[Einstandsbetrag] [decimal](38, 20) NOT NULL,
	[VK-Preis] [decimal](38, 20) NOT NULL,
	[Verkaufsbetrag] [decimal](38, 20) NOT NULL,
	[Res_-Gruppennr_] [varchar](20) NOT NULL,
	[Einheitencode] [varchar](10) NOT NULL,
	[Res_ Leistungsgrad %] [decimal](38, 20) NOT NULL,
	[Lagerortcode] [varchar](10) NOT NULL,
	[Fakturierbar] [tinyint] NOT NULL,
	[Ressourcenart] [int] NOT NULL,
	[Werkstattbuchungsgruppe] [varchar](20) NOT NULL,
	[Kostenstellencode] [varchar](10) NOT NULL,
	[Markencode] [varchar](10) NOT NULL,
	[Arbeitstypencode] [varchar](10) NOT NULL,
	[Preisgruppencode] [varchar](10) NOT NULL,
	[Benutzer ID] [varchar](20) NOT NULL,
	[Herkunftscode] [varchar](10) NOT NULL,
	[Seriennr_] [varchar](20) NOT NULL,
	[Angeknüpftes Budget] [tinyint] NOT NULL,
	[Hauptaktivitätscode] [varchar](10) NOT NULL,
	[Unteraktivitätscode] [varchar](10) NOT NULL,
	[Teilaktivitätscode] [varchar](10) NOT NULL,
	[Betrag für Aktiv_] [decimal](38, 20) NOT NULL,
	[Aktiv_ Betrag] [decimal](38, 20) NOT NULL,
	[Betrag für Deaktiv_] [decimal](38, 20) NOT NULL,
	[Deaktiv_ Betrag] [decimal](38, 20) NOT NULL,
	[Postenart] [int] NOT NULL,
	[Positiv] [tinyint] NOT NULL,
	[Menge bewertet] [decimal](38, 20) NOT NULL,
	[Buch_-Blatt Name] [varchar](10) NOT NULL,
	[Ursachencode] [varchar](10) NOT NULL,
	[Art des Geschäftes] [varchar](10) NOT NULL,
	[Verkehrszweig] [varchar](10) NOT NULL,
	[Ländercode] [varchar](10) NOT NULL,
	[Geschäftsbuchungsgruppe] [varchar](10) NOT NULL,
	[Produktbuchungsgruppe] [varchar](10) NOT NULL,
	[Hafen] [varchar](10) NOT NULL,
	[Belegdatum] [datetime] NOT NULL,
	[Externe Belegnummer] [varchar](20) NOT NULL,
	[Bundesland] [varchar](10) NOT NULL,
	[Verfahren] [varchar](10) NOT NULL,
	[Nummernserie] [varchar](10) NOT NULL,
	[Einstandsbetrag (BW)] [decimal](38, 20) NOT NULL,
	[Verkaufsbetrag (BW)] [decimal](38, 20) NOT NULL,
	[Betrag für Deaktiv_ (BW)] [decimal](38, 20) NOT NULL,
	[Betrag für Aktiv_ (BW)] [decimal](38, 20) NOT NULL,
	[Deaktiv_ Betrag (BW)] [decimal](38, 20) NOT NULL,
	[Aktiv_ Betrag (BW)] [decimal](38, 20) NOT NULL,
	[Storniert] [tinyint] NOT NULL,
	[Buchnr_] [varchar](20) NOT NULL,
	[Variantencode] [varchar](10) NOT NULL,
	[Lagerfachcode] [varchar](10) NOT NULL,
	[Menge pro Einheit] [decimal](38, 20) NOT NULL,
	[Menge (Basis)] [decimal](38, 20) NOT NULL,
	[Zeitart] [int] NOT NULL,
	[Jobnr_] [int] NOT NULL,
	[Zugeh_ Postennr_] [int] NOT NULL,
	[Fahrzeugtyp] [varchar](30) NOT NULL,
	[Paketnr_] [varchar](20) NOT NULL,
	[Kostenstellencode Verkauf] [varchar](10) NOT NULL,
	[Verrechnungspreis] [decimal](38, 20) NOT NULL,
	[Verrechnungsbetrag] [decimal](38, 20) NOT NULL,
	[Verrechnungsbetrag (BW)] [decimal](38, 20) NOT NULL,
	[Aktivierung] [tinyint] NOT NULL,
	[Abgeschlossen] [tinyint] NOT NULL,
	[Fahrgestellnummer] [varchar](20) NOT NULL,
	[Zugeh_ Fahrzeugpostennr_] [int] NOT NULL,
	[Fzg_ Post_ Lfd_ Nr_ (Eig_ A_)] [int] NOT NULL,
	[Datenmarkencode] [varchar](10) NOT NULL,
	[Menge pro Stunde] [decimal](38, 20) NOT NULL,
	[Menge (Stunde)] [decimal](38, 20) NOT NULL,
	[Artikelgruppencode] [varchar](10) NOT NULL,
	[Belegtyp] [int] NOT NULL,
	[Fahrzeugartencode] [varchar](10) NOT NULL,
	[Fahrzeugklassecode] [varchar](10) NOT NULL,
	[Fahrzeugstatus] [int] NOT NULL,
	[Filialbuchnummer] [varchar](20) NOT NULL,
	[Marktsegmentcode] [varchar](10) NOT NULL,
	[Hauptgruppencode] [varchar](10) NOT NULL,
	[Untergruppencode] [varchar](10) NOT NULL,
	[Positionsgruppencode] [varchar](10) NOT NULL,
	[Kundengruppencode] [varchar](20) NOT NULL,
	[Ist-Menge (Stunde)] [decimal](38, 20) NOT NULL,
	[Verrechnungsgruppennr_] [varchar](20) NOT NULL,
	[Vorgabezeit] [decimal](38, 20) NOT NULL,
	[Vorgabezeitart] [int] NOT NULL,
	[Herkunftsart] [int] NOT NULL,
	[Herkunftsnr_] [varchar](20) NOT NULL,
	[Herkunftsnr_(Zahlung)] [varchar](20) NOT NULL,
	[Hauptdebitor] [tinyint] NOT NULL,
	[Auftragszeilennr_] [int] NOT NULL,
	[Zeit von] [datetime] NOT NULL,
	[Zeit bis] [datetime] NOT NULL,
	[Interne Verrechnung erfolgt] [tinyint] NOT NULL,
	[Filialcode] [varchar](10) NOT NULL,
	[Verrechnungspreis fix] [tinyint] NOT NULL,
	[Auftrag erledigt] [tinyint] NOT NULL,
	[Werterhöhende Massnahme] [tinyint] NOT NULL,
	[Tätigkeitserf_ Verbindungsnr_] [int] NOT NULL,
	[Lagerbuchungsgruppeart] [int] NOT NULL,
	[Lagerbuchungsgruppe] [varchar](10) NOT NULL,
	[Ausstattungscode] [varchar](20) NOT NULL,
	[Filialcode Verkauf] [varchar](10) NOT NULL,
	[Buchungsdatum (letzte Rechn_)] [datetime] NOT NULL,
	[Offen] [tinyint] NOT NULL,
	[Geschlossen von Lfd_ Nr_] [int] NOT NULL,
	[Geschlossen am] [datetime] NOT NULL,
	[Geschlossen mit Menge] [decimal](38, 20) NOT NULL,
	[Offene Menge] [decimal](38, 20) NOT NULL,
	[Int_ Debitor Satz in %] [decimal](38, 20) NOT NULL,
	[Betrag int_ zu verrechnen] [decimal](38, 20) NOT NULL,
	[Betrag int_ zu verrechnen (BW)] [decimal](38, 20) NOT NULL,
	[Betrag int_ verrechnet] [decimal](38, 20) NOT NULL,
	[Betrag int_ verrechnet (BW)] [decimal](38, 20) NOT NULL,
	[Serviceberaternr_] [varchar](20) NOT NULL,
	[Mitarbeiternr_] [varchar](20) NOT NULL,
	[Tätigkeitsartcode] [varchar](10) NOT NULL,
	[Int_ gebuchter Rabatt] [decimal](38, 20) NOT NULL,
	[Int_ gebuchter Rabatt (BW)] [decimal](38, 20) NOT NULL,
	[Rabatt zu stornieren] [decimal](38, 20) NOT NULL,
	[Rabatt zu stornieren (BW)] [decimal](38, 20) NOT NULL,
	[Marketingcode] [varchar](10) NOT NULL,
	[Monteur Nr_ 1] [varchar](20) NOT NULL,
	[AW Mont_ 1] [decimal](38, 20) NOT NULL,
	[Monteur Nr_ 2] [varchar](20) NOT NULL,
	[AW Mont_ 2] [decimal](38, 20) NOT NULL,
	[BKR Fzg_-Markencode] [varchar](10) NOT NULL,
	[BKR Datenmarkencode] [varchar](10) NOT NULL,
	[Produktbuchungsgruppe Verkauf] [varchar](10) NOT NULL,
	[Salespers__Purch_ Code] [varchar](10) NOT NULL,
	[Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [Werkstattposten$0] PRIMARY KEY CLUSTERED 
(
	[Lfd_ Nr_] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [temp].[Wertposten]    Script Date: 30.04.2019 14:25:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [temp].[Wertposten](
	[timestamp] [binary](8) NOT NULL,
	[Lfd_ Nr_] [int] NOT NULL,
	[Artikelnr_] [varchar](20) NOT NULL,
	[Buchungsdatum] [datetime] NOT NULL,
	[Artikelpostenart] [int] NOT NULL,
	[Herkunftsnr_] [varchar](20) NOT NULL,
	[Belegnr_] [varchar](20) NOT NULL,
	[Beschreibung] [varchar](50) NOT NULL,
	[Lagerortcode] [varchar](10) NOT NULL,
	[Lagerbuchungsgruppe] [varchar](10) NOT NULL,
	[Herkunftsbuchungsgruppe] [varchar](10) NOT NULL,
	[Artikelposten Lfd_ Nr_] [int] NOT NULL,
	[Bewertete Menge] [decimal](38, 20) NOT NULL,
	[Fakturierte Menge] [decimal](38, 20) NOT NULL,
	[Lagerwert pro Einheit] [decimal](38, 20) NOT NULL,
	[Betrag] [decimal](38, 20) NOT NULL,
	[Verk_-_Einkäufercode] [varchar](10) NOT NULL,
	[Rabattbetrag] [decimal](38, 20) NOT NULL,
	[Benutzer ID] [varchar](20) NOT NULL,
	[Herkunftscode] [varchar](10) NOT NULL,
	[Kostenstellencode] [varchar](20) NOT NULL,
	[Markencode] [varchar](20) NOT NULL,
	[Herkunftsart] [int] NOT NULL,
	[Lagerwert reguliert] [decimal](38, 20) NOT NULL,
	[Gebuchter Lagerwert] [decimal](38, 20) NOT NULL,
	[Ursachencode] [varchar](10) NOT NULL,
	[Direktlieferung] [tinyint] NOT NULL,
	[Buch_-Blatt Name] [varchar](10) NOT NULL,
	[Geschäftsbuchungsgruppe] [varchar](10) NOT NULL,
	[Produktbuchungsgruppe] [varchar](10) NOT NULL,
	[Belegdatum] [datetime] NOT NULL,
	[Externe Belegnummer] [varchar](20) NOT NULL,
	[Lagerwert reguliert (BW)] [decimal](38, 20) NOT NULL,
	[Gebuchter Lagerwert (BW)] [decimal](38, 20) NOT NULL,
	[Lagerwert pro Einheit (BW)] [decimal](38, 20) NOT NULL,
	[Soll-Kosten] [tinyint] NOT NULL,
	[Artikel Zu-_Abschlagsnr_] [varchar](20) NOT NULL,
	[Bew_ z_ Einst_-Pr_(durchschn_)] [tinyint] NOT NULL,
	[Teil Neubewertung] [tinyint] NOT NULL,
	[Einfluss auf Lagerwert] [tinyint] NOT NULL,
	[Bewertungsdatum] [datetime] NOT NULL,
	[Postenart] [int] NOT NULL,
	[Abweichungsart] [int] NOT NULL,
	[Buchnummer] [varchar](20) NOT NULL,
	[FA-Nr_] [varchar](20) NOT NULL,
	[Variantencode] [varchar](10) NOT NULL,
	[Lagerfachcode] [varchar](10) NOT NULL,
	[Artikelart] [int] NOT NULL,
	[Rechnungsrabatt] [decimal](38, 20) NOT NULL,
	[Mengenrabatt] [decimal](38, 20) NOT NULL,
	[Verkaufsrabatt] [decimal](38, 20) NOT NULL,
	[Verkaufsaufschlag] [decimal](38, 20) NOT NULL,
	[Umgebuchter Betrag] [decimal](38, 20) NOT NULL,
	[Umgebuchter Betrag (BW)] [decimal](38, 20) NOT NULL,
	[Umbuchungsdatum] [datetime] NOT NULL,
	[Hauptbereich] [int] NOT NULL,
	[Herkunftsnr_(Zahlung)] [varchar](20) NOT NULL,
	[Auftragsnr_] [varchar](20) NOT NULL,
	[Kautionsartikel] [tinyint] NOT NULL,
	[Filialcode] [varchar](10) NOT NULL,
	[Anlagedatum] [datetime] NOT NULL,
	[Anlagezeit] [datetime] NOT NULL,
	[Fahrgestellnummer] [varchar](20) NOT NULL,
	[Int_ Debitor Satz in %] [decimal](38, 20) NOT NULL,
	[Fahrzeugstatus] [int] NOT NULL,
	[Fahrzeugklassecode] [varchar](10) NOT NULL,
	[Datenmarkencode] [varchar](10) NOT NULL,
	[BKR Fzg_-Markencode] [varchar](10) NOT NULL,
	[BKR Datenmarkencode] [varchar](10) NOT NULL,
	[Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [Wertposten$0] PRIMARY KEY CLUSTERED 
(
	[Lfd_ Nr_] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [temp].[Arbeitswertposten] ADD  DEFAULT ('1') FOR [Client_DB]
GO
ALTER TABLE [temp].[Artikel] ADD  DEFAULT ('1') FOR [Client_DB]
GO
ALTER TABLE [temp].[Fahrzeug] ADD  DEFAULT ('1') FOR [Client_DB]
GO
ALTER TABLE [temp].[Fahrzeug_Ausstattung] ADD  DEFAULT ('1') FOR [Client_DB]
GO
ALTER TABLE [temp].[Time_Entry_T] ADD  DEFAULT ('1') FOR [Client_DB]
GO
ALTER TABLE [temp].[Verkaufsrechnungskopf] ADD  DEFAULT ('1') FOR [Client_DB]
GO
ALTER TABLE [temp].[Verkaufsrechnungszeile] ADD  DEFAULT ('1') FOR [Client_DB]
GO
ALTER TABLE [temp].[Werkstattposten] ADD  DEFAULT ('1') FOR [Client_DB]
GO
ALTER TABLE [temp].[Wertposten] ADD  DEFAULT ('1') FOR [Client_DB]
GO