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