C11/System/OPTIMA/SQL/exec/CARLO_Fehlende_Tabellen.sql

USE [CARLO]
GO
/****** Object:  Table [import].[Abnehmergruppe_VW]    Script Date: 17.09.2018 17:27:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[Abnehmergruppe_VW](
	[timestamp] [binary](8) NOT NULL,
	[Debitorengruppencode] [varchar](20) NOT NULL,
	[Abnehmergruppe] [varchar](10) NOT NULL,
	[Beschreibung] [varchar](30) NOT NULL,
	[Abn_-Grp_ 4-stellig] [varchar](10) NOT NULL,
	[Skoda Abnehmergr_] [varchar](10) NOT NULL,
	[Abnehmergruppe Autopart] [varchar](10) NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [Abnehmergruppe VW$0] PRIMARY KEY CLUSTERED 
(
	[Debitorengruppencode] 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 [import].[Fahrzeug Hauptgruppe]    Script Date: 17.09.2018 17:27:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[Fahrzeug_Hauptgruppe](
	[timestamp] [binary](8) NOT NULL,
	[Markencode] [varchar](10) NOT NULL,
	[Code] [varchar](10) NOT NULL,
	[Beschreibung] [varchar](50) NOT NULL,
	[Beschreibung 2] [varchar](50) NOT NULL,
	[Beschreibung updaten] [tinyint] NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [Fahrzeug Hauptgruppe$0] PRIMARY KEY CLUSTERED 
(
	[Markencode] ASC,
	[Code] 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 [import].[Fahrzeug Untergruppe]    Script Date: 17.09.2018 17:27:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[Fahrzeug_Untergruppe](
	[timestamp] [binary](8) NOT NULL,
	[Markencode] [varchar](10) NOT NULL,
	[Code] [varchar](10) NOT NULL,
	[Gehört zu Hauptgruppe] [varchar](10) NOT NULL,
	[Beschreibung] [varchar](30) NOT NULL,
	[Beschreibung 2] [varchar](30) NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [Fahrzeug Untergruppe$0] PRIMARY KEY CLUSTERED 
(
	[Markencode] ASC,
	[Code] ASC,
	[Gehört zu Hauptgruppe] 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 [import].[Herkunftscode]    Script Date: 17.09.2018 17:27:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[Herkunftscode](
	[timestamp] [binary](8) NOT NULL,
	[Code] [varchar](10) NOT NULL,
	[Beschreibung] [varchar](50) NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [Herkunftscode$0] PRIMARY KEY CLUSTERED 
(
	[Code] 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 [import].[Kontensch_Kontrolle Sachp BKR]    Script Date: 17.09.2018 17:27:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[Kontensch_Kontrolle_Sachp_BKR](
	[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,
	[Menge2] [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,
	[GUV_Bilanz] [int] NOT NULL,
	[Plausibel] [tinyint] NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [Kontensch_Kontrolle Sachp BKR$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 [import].[Kostenträgerbuchungsgruppe]    Script Date: 17.09.2018 17:27:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[Kostentraegerbuchungsgruppe](
	[timestamp] [binary](8) NOT NULL,
	[Code] [varchar](10) NOT NULL,
	[Text] [varchar](50) NOT NULL,
	[Kostenartencode] [varchar](20) NOT NULL,
	[Materialzuschl_kontocode] [varchar](20) NOT NULL,
	[Fertigungzuschl_kontocode] [varchar](20) NOT NULL,
	[Fremdl_Zuschl_kontocode] [varchar](20) NOT NULL,
	[Vertriebszuschl_kontocode] [varchar](20) NOT NULL,
	[Verwalt_Zuschl_kontocode] [varchar](20) NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [Kostenträgerbuchungsgruppe$0] PRIMARY KEY CLUSTERED 
(
	[Code] 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 [import].[Kostenträgerkonto]    Script Date: 17.09.2018 17:27:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[Kostentraegerkonto](
	[timestamp] [binary](8) NOT NULL,
	[Nr_] [varchar](20) NOT NULL,
	[Name] [varchar](30) NOT NULL,
	[Suchbegriff] [varchar](30) NOT NULL,
	[Kostenartenart] [int] NOT NULL,
	[Buchungsart] [int] NOT NULL,
	[Kostenträgerkontencharakter] [int] NOT NULL,
	[Einrückung] [int] NOT NULL,
	[Gesperrt] [tinyint] NOT NULL,
	[Zusammenzählung] [varchar](30) NOT NULL,
	[Steuerlich] [tinyint] NOT NULL,
	[Betriebswirtschaftlich] [tinyint] NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [Kostenträgerkonto$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 [import].[Kostenträgerposten]    Script Date: 17.09.2018 17:27:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[Kostentraegerposten](
	[timestamp] [binary](8) NOT NULL,
	[Lfd_ Nr_] [int] NOT NULL,
	[Kore Kostenträgernr_] [varchar](10) NOT NULL,
	[Buchungsdatum] [datetime] NOT NULL,
	[Buchungsart] [int] NOT NULL,
	[Herkunftsnr_] [varchar](20) NOT NULL,
	[Belegnr_] [varchar](20) NOT NULL,
	[Text] [varchar](50) NOT NULL,
	[Kostenträgerkontocode] [varchar](20) NOT NULL,
	[Geschäft Buch_-Gr_] [varchar](10) NOT NULL,
	[Produkt Buch_-Gr_] [varchar](10) NOT NULL,
	[Verkäufer_Einkäufer] [varchar](10) NOT NULL,
	[Bwl Betrag] [decimal](38, 20) NOT NULL,
	[Bwl Betrag fix] [decimal](38, 20) NOT NULL,
	[Bwl Betrag var] [decimal](38, 20) NOT NULL,
	[Steuerl_ Betrag] [decimal](38, 20) NOT NULL,
	[Steuerl_ Betrag fix] [decimal](38, 20) NOT NULL,
	[Steuerl_ Betrag var] [decimal](38, 20) NOT NULL,
	[Menge] [decimal](38, 20) NOT NULL,
	[Belegdatum] [datetime] NOT NULL,
	[Profitcentercode] [varchar](10) NOT NULL,
	[Projektnr_] [varchar](20) NOT NULL,
	[Ländercode] [varchar](10) NOT NULL,
	[Orginalbelegnr_] [varchar](20) NOT NULL,
	[Ursachencode] [varchar](10) NOT NULL,
	[Herkunftscode] [varchar](10) NOT NULL,
	[Kore Kostenstellennr_] [varchar](10) NOT NULL,
	[Verrechnungssatz fix] [decimal](38, 20) NOT NULL,
	[Verrechnungssatz var] [decimal](38, 20) NOT NULL,
	[Ergebnisträgercode] [varchar](10) NOT NULL,
	[Kostenträgerkontencharakter] [int] NOT NULL,
	[Kostenträger Buch_-Gr_] [varchar](10) NOT NULL,
	[Betriebsstättecode] [varchar](10) NOT NULL,
	[Bezugsgrößencode] [varchar](10) NOT NULL,
	[Verrechneter Betrag fix] [decimal](38, 20) NOT NULL,
	[Verrechnete Betrag var] [decimal](38, 20) NOT NULL,
	[Berechnungsperiode] [datetime] NOT NULL,
	[Kostenartencode] [varchar](20) NOT NULL,
	[verrechnen an Kostenstelle] [tinyint] NOT NULL,
	[Lfd_ Nr_ Kostenstellenposten] [int] NOT NULL,
	[Lfd_ Nr_ Sachposten] [int] NOT NULL,
	[Benutzer ID] [varchar](10) NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [Kostenträgerposten$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 [import].[MB Branchcode Mapping]    Script Date: 17.09.2018 17:27:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[MB_Branchcode_Mapping](
	[timestamp] [binary](8) NOT NULL,
	[Main Area] [int] NOT NULL,
	[CARLO Branchcode] [varchar](10) NOT NULL,
	[MB Locationcode] [varchar](2) NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [MB Branchcode Mapping$0] PRIMARY KEY CLUSTERED 
(
	[Main Area] ASC,
	[CARLO Branchcode] 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 [import].[MB Costcenter]    Script Date: 17.09.2018 17:27:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[MB_Costcenter](
	[timestamp] [binary](8) NOT NULL,
	[Code] [varchar](2) NOT NULL,
	[Description] [varchar](100) NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [MB Costcenter$0] PRIMARY KEY CLUSTERED 
(
	[Code] 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 [import].[MB Costcentercode Mapping]    Script Date: 17.09.2018 17:27:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[MB_Costcentercode_Mapping](
	[timestamp] [binary](8) NOT NULL,
	[CARLO Costcentercode] [varchar](10) NOT NULL,
	[CARLO Makecode] [varchar](10) NOT NULL,
	[CARLO Product Posting Group] [varchar](10) NOT NULL,
	[MB Costcentercode] [varchar](2) NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [MB Costcentercode Mapping$0] PRIMARY KEY CLUSTERED 
(
	[CARLO Costcentercode] ASC,
	[CARLO Makecode] ASC,
	[CARLO Product Posting Group] 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 [import].[MB Costunit]    Script Date: 17.09.2018 17:27:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[MB_Costunit](
	[timestamp] [binary](8) NOT NULL,
	[MB Makecode] [varchar](2) NOT NULL,
	[Code] [varchar](2) NOT NULL,
	[Description] [varchar](100) NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [MB Costunit$0] PRIMARY KEY CLUSTERED 
(
	[MB Makecode] ASC,
	[Code] 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 [import].[MB Costunitcode Mapping]    Script Date: 17.09.2018 17:27:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[MB_Costunitcode_Mapping](
	[timestamp] [binary](8) NOT NULL,
	[Main Area] [int] NOT NULL,
	[CARLO Product Posting Group] [varchar](10) NOT NULL,
	[CARLO Makecode] [varchar](10) NOT NULL,
	[CARLO Vehicle Class Code] [varchar](10) NOT NULL,
	[MB Costunitcode] [varchar](2) NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [MB Costunitcode Mapping$0] PRIMARY KEY CLUSTERED 
(
	[Main Area] ASC,
	[CARLO Product Posting Group] ASC,
	[CARLO Makecode] ASC,
	[CARLO Vehicle Class Code] 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 [import].[MB Distr_-channelcode Mapping]    Script Date: 17.09.2018 17:27:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[MB_Distr_Channelcode_Mapping](
	[timestamp] [binary](8) NOT NULL,
	[CARLO Business Posting Group] [varchar](10) NOT NULL,
	[MB Distributionchannelcode] [varchar](2) NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [MB Distr_-channelcode Mapping$0] PRIMARY KEY CLUSTERED 
(
	[CARLO Business Posting Group] 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 [import].[MB Distributionchannel]    Script Date: 17.09.2018 17:27:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[MB_Distributionchannel](
	[timestamp] [binary](8) NOT NULL,
	[Code] [varchar](2) NOT NULL,
	[Description] [varchar](100) NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [MB Distributionchannel$0] PRIMARY KEY CLUSTERED 
(
	[Code] 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 [import].[MB Location]    Script Date: 17.09.2018 17:27:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[MB_Location](
	[timestamp] [binary](8) NOT NULL,
	[Code] [varchar](2) NOT NULL,
	[Description] [varchar](100) NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [MB Location$0] PRIMARY KEY CLUSTERED 
(
	[Code] 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 [import].[MB Locationcode Mapping]    Script Date: 17.09.2018 17:27:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[MB_Locationcode_Mapping](
	[timestamp] [binary](8) NOT NULL,
	[Main Area] [int] NOT NULL,
	[CARLO Locationcode] [varchar](10) NOT NULL,
	[MB Locationcode] [varchar](2) NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [MB Locationcode Mapping$0] PRIMARY KEY CLUSTERED 
(
	[Main Area] ASC,
	[CARLO Locationcode] 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 [import].[MB Make]    Script Date: 17.09.2018 17:27:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[MB_Make](
	[timestamp] [binary](8) NOT NULL,
	[Code] [varchar](2) NOT NULL,
	[Description] [varchar](100) NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [MB Make$0] PRIMARY KEY CLUSTERED 
(
	[Code] 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 [import].[MB Make KBA No_ Mapping]    Script Date: 17.09.2018 17:27:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[MB_Make_KBA_No_Mapping](
	[timestamp] [binary](8) NOT NULL,
	[MB Makecode] [varchar](10) NOT NULL,
	[KBA Manufact_ No_] [varchar](10) NOT NULL,
	[HbvMasking] [varchar](10) NOT NULL,
	[FactMasking] [varchar](10) NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [MB Make KBA No_ Mapping$0] PRIMARY KEY CLUSTERED 
(
	[MB Makecode] 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 [import].[MB Makecode Mapping]    Script Date: 17.09.2018 17:27:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[MB_Makecode_Mapping](
	[timestamp] [binary](8) NOT NULL,
	[Main Area] [int] NOT NULL,
	[CARLO Makecode] [varchar](10) NOT NULL,
	[Vehicle Type] [int] NOT NULL,
	[CARLO Branch Code] [varchar](10) NOT NULL,
	[MB Makecode] [varchar](2) NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [MB Makecode Mapping$0] PRIMARY KEY CLUSTERED 
(
	[Main Area] ASC,
	[CARLO Makecode] ASC,
	[Vehicle Type] ASC,
	[CARLO Branch Code] 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 [import].[MB Setup]    Script Date: 17.09.2018 17:27:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[MB_Setup](
	[timestamp] [binary](8) NOT NULL,
	[Primary Key] [varchar](1) NOT NULL,
	[Kat_ Prüfung Plausibilität] [int] NOT NULL,
	[Kat_ Erm_ PKW_NFZ Differenzrg_] [int] NOT NULL,
	[Anz_ Stellen BKR Kontenrahmen] [int] NOT NULL,
	[Anz_ Stellen lok_ Kontenrahmen] [int] NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [MB Setup$0] PRIMARY KEY CLUSTERED 
(
	[Primary Key] 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 [import].[Modell Line Neu]    Script Date: 17.09.2018 17:27:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[Modell_Line_Neu](
	[timestamp] [binary](8) NOT NULL,
	[Fgstnr1-9] [varchar](9) NOT NULL,
	[von Modelljahr] [int] NOT NULL,
	[bis Modelljahr] [int] NOT NULL,
	[GMUD Modellinie] [varchar](3) NOT NULL,
	[Aufbau] [varchar](3) NOT NULL,
	[Bezeichnung] [varchar](30) NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [Modell Line Neu$0] PRIMARY KEY CLUSTERED 
(
	[Fgstnr1-9] ASC,
	[von Modelljahr] 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 [import].[Modell-Aufbauten]    Script Date: 17.09.2018 17:27:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[Modell_Aufbauten](
	[timestamp] [binary](8) NOT NULL,
	[Modellinie] [varchar](3) NOT NULL,
	[Aufbau] [varchar](3) NOT NULL,
	[Beschreibung] [varchar](50) NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [Modell-Aufbauten$0] PRIMARY KEY CLUSTERED 
(
	[Modellinie] ASC,
	[Aufbau] 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 [import].[Modellinien]    Script Date: 17.09.2018 17:27:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[Modellinien](
	[timestamp] [binary](8) NOT NULL,
	[Modellinie] [varchar](3) NOT NULL,
	[Modelljahr von] [int] NOT NULL,
	[Modelljahr bis] [int] NOT NULL,
	[Beschreibung] [varchar](50) NOT NULL,
	[Modell] [varchar](20) NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [Modellinien$0] PRIMARY KEY CLUSTERED 
(
	[Modellinie] ASC,
	[Modelljahr von] 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 [import].[Model-Linien alt]    Script Date: 17.09.2018 17:27:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[Model_Linien_alt](
	[timestamp] [binary](8) NOT NULL,
	[Fgstnr8-9] [varchar](2) NOT NULL,
	[von Modelljahr] [int] NOT NULL,
	[bis Modelljahr] [int] NOT NULL,
	[Cosco Modellinie] [varchar](3) NOT NULL,
	[GMUD Modelline] [varchar](3) NOT NULL,
	[GMUD Aufbau] [varchar](3) NOT NULL,
	[Bezeichnung] [varchar](30) NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [Model-Linien alt$0] PRIMARY KEY CLUSTERED 
(
	[Fgstnr8-9] ASC,
	[von Modelljahr] 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 [import].[Modelljahre]    Script Date: 17.09.2018 17:27:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[Modelljahre](
	[timestamp] [binary](8) NOT NULL,
	[Code] [varchar](30) NOT NULL,
	[Beschreibung] [varchar](100) NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [Modelljahre$0] PRIMARY KEY CLUSTERED 
(
	[Code] 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 [import].[Produktklasse]    Script Date: 17.09.2018 17:27:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[Produktklasse](
	[timestamp] [binary](8) NOT NULL,
	[Code] [varchar](10) NOT NULL,
	[Beschreibung] [varchar](30) NOT NULL,
	[Vertriebskennzeichen] [varchar](10) NOT NULL,
    [Client_DB] [varchar](50) NOT NULL,
 CONSTRAINT [Produktklasse$0] PRIMARY KEY CLUSTERED 
(
	[Code] 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