C11/System/LOCOSOFT/SQL/exec/LOCOSOFT_import_Create.sql

USE [LOCOSOFT]
GO

CREATE SCHEMA import
GO

/****** Object:  Table [import].[absence_calendar]    Script Date: 02.10.2019 13:41:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[absence_calendar](
	[employee_number] [int] NOT NULL,
	[date] [datetime] NOT NULL,
	[unique_dummy] [int] NOT NULL,
	[type] [varchar](10) NULL,
	[is_payed] [smallint] NULL,
	[day_contingent] [numeric](4, 2) NULL,
	[reason] [varchar](10) NULL,
	[booking_flag] [varchar](10) NULL,
 CONSTRAINT [absence_calendar_temp_20180403051118_pkey] PRIMARY KEY CLUSTERED 
(
	[employee_number] ASC,
	[date] ASC,
	[unique_dummy] 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].[absence_reasons]    Script Date: 02.10.2019 13:41:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[absence_reasons](
	[id] [varchar](10) NOT NULL,
	[description] [varchar](50) NULL,
	[is_annual_vacation] [smallint] NULL,
 CONSTRAINT [absence_reasons_temp_20180403051147_pkey] PRIMARY KEY CLUSTERED 
(
	[id] 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].[absence_types]    Script Date: 02.10.2019 13:41:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[absence_types](
	[type] [varchar](10) NOT NULL,
	[description] [varchar](50) NULL,
 CONSTRAINT [absence_types_temp_20180403051149_pkey] PRIMARY KEY CLUSTERED 
(
	[type] 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].[accounts_characteristics]    Script Date: 02.10.2019 13:41:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[accounts_characteristics](
	[subsidiary_to_company_ref] [bigint] NOT NULL,
	[skr51_branch] [bigint] NOT NULL,
	[skr51_make] [bigint] NOT NULL,
	[skr51_cost_center] [bigint] NOT NULL,
	[skr51_sales_channel] [bigint] NOT NULL,
	[skr51_cost_unit] [bigint] NOT NULL,
	[skr51_brach_name] [varchar](50) NULL,
	[skr51_make_description] [varchar](50) NULL,
	[skr51_cost_center_name] [varchar](50) NULL,
	[skr51_sales_channel_name] [varchar](50) NULL,
	[skr51_cost_unit_name] [varchar](50) NULL,
 CONSTRAINT [accounts_characteristics_temp_20180403051152_pkey] PRIMARY KEY CLUSTERED 
(
	[subsidiary_to_company_ref] ASC,
	[skr51_branch] ASC,
	[skr51_make] ASC,
	[skr51_cost_center] ASC,
	[skr51_sales_channel] ASC,
	[skr51_cost_unit] 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].[charge_type_descriptions]    Script Date: 02.10.2019 13:41:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[charge_type_descriptions](
	[type] [int] NOT NULL,
	[description] [varchar](100) NULL,
 CONSTRAINT [charge_type_descriptions_temp_20180403051215_pkey] PRIMARY KEY CLUSTERED 
(
	[type] 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].[charge_types]    Script Date: 02.10.2019 13:41:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[charge_types](
	[type] [int] NOT NULL,
	[subsidiary] [int] NOT NULL,
	[timeunit_rate] [numeric](9, 3) NULL,
	[department] [int] NULL,

 CONSTRAINT [charge_types_temp_20180403051210_pkey] PRIMARY KEY CLUSTERED 
(
	[type] ASC,
	[subsidiary] 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].[clearing_delay_types]    Script Date: 02.10.2019 13:41:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[clearing_delay_types](
	[type] [varchar](10) NOT NULL,
	[description] [varchar](50) NULL,

 CONSTRAINT [clearing_delay_types_temp_20180403051217_pkey] PRIMARY KEY CLUSTERED 
(
	[type] 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].[codes_vehicle_date]    Script Date: 02.10.2019 13:41:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[codes_vehicle_date](
	[vehicle_number] [int] NOT NULL,
	[code] [varchar](10) NOT NULL,
	[date] [datetime] NULL,
 CONSTRAINT [pk_codes_vehicle_date] PRIMARY KEY CLUSTERED 
(
	[vehicle_number] 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].[codes_vehicle_date_def]    Script Date: 02.10.2019 13:41:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[codes_vehicle_date_def](
	[code] [varchar](10) NOT NULL,
	[is_defined_by_dms] [varchar](10) NULL,
	[month_increase_factor] [int] NULL,
	[show_in_211_from_or_to] [varchar](10) NULL,
	[is_backdate_on_exceeding] [varchar](10) NULL,
	[description] [varchar](100) NULL,
 CONSTRAINT [pk_codes_vehicle_date_def] 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].[codes_vehicle_def]    Script Date: 02.10.2019 13:41:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[codes_vehicle_def](
	[code] [varchar](10) NOT NULL,
	[is_defined_by_dms] [varchar](10) NULL,
	[format] [varchar](10) NULL,
	[length] [int] NULL,
	[decimal] [int] NULL,
	[description] [varchar](100) NULL,
 CONSTRAINT [pk_codes_vehicle_def] 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].[codes_vehicle_list]    Script Date: 02.10.2019 13:41:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[codes_vehicle_list](
	[vehicle_number] [int] NOT NULL,
	[code] [varchar](10) NOT NULL,
	[value_format] [varchar](10) NULL,
	[value_text] [varchar](100) NULL,
	[value_numeric] [numeric](18, 9) NULL,
	[value_date] [datetime] NULL,
 CONSTRAINT [pk_codes_vehicle_list] PRIMARY KEY CLUSTERED 
(
	[vehicle_number] 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].[codes_vehicle_mileage]    Script Date: 02.10.2019 13:41:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[codes_vehicle_mileage](
	[vehicle_number] [int] NOT NULL,
	[code] [varchar](10) NOT NULL,
	[kilometer] [int] NULL,
 CONSTRAINT [pk_codes_vehicle_mileage] PRIMARY KEY CLUSTERED 
(
	[vehicle_number] 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].[codes_vehicle_mileage_def]    Script Date: 02.10.2019 13:41:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[codes_vehicle_mileage_def](
	[code] [varchar](10) NOT NULL,
	[is_defined_by_dms] [varchar](10) NULL,
	[mileage_increase_factor] [int] NULL,
	[show_in_211_from_or_to] [varchar](10) NULL,
	[description] [varchar](100) NULL,
 CONSTRAINT [pk_codes_vehicle_mileage_def] 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].[com_number_types]    Script Date: 02.10.2019 13:41:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[com_number_types](
	[typ] [varchar](10) NOT NULL,
	[description] [varchar](50) NULL,
	[is_office_number] [smallint] NULL,
 CONSTRAINT [com_number_types_temp_20180403051220_pkey] PRIMARY KEY CLUSTERED 
(
	[typ] 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].[customer_codes]    Script Date: 02.10.2019 13:41:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[customer_codes](
	[code] [int] NOT NULL,
	[description] [varchar](50) NULL,
 CONSTRAINT [customer_codes_temp_20180403051844_pkey] 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].[customer_com_numbers]    Script Date: 02.10.2019 13:41:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[customer_com_numbers](
	[customer_number] [int] NOT NULL,
	[counter] [bigint] NOT NULL,
	[com_type] [varchar](10) NULL,
	[is_reference] [smallint] NULL,
	[only_on_1st_tab] [smallint] NULL,
	[address] [varchar](100) NULL,
	[has_contact_person_fields] [smallint] NULL,
	[contact_salutation] [varchar](50) NULL,
	[contact_firstname] [varchar](100) NULL,
	[contact_lastname] [varchar](100) NULL,
	[contact_description] [varchar](100) NULL,
	[note] [varchar](100) NULL,
 CONSTRAINT [customer_com_numbers_temp_20180403051846_pkey] PRIMARY KEY CLUSTERED 
(
	[customer_number] ASC,
	[counter] 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].[customer_to_customercodes]    Script Date: 02.10.2019 13:41:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[customer_to_customercodes](
	[customer_number] [int] NOT NULL,
	[customer_code] [int] NOT NULL,
 CONSTRAINT [customer_to_customercodes_temp_20180403052118_pkey] PRIMARY KEY CLUSTERED 
(
	[customer_number] ASC,
	[customer_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].[customers_suppliers]    Script Date: 02.10.2019 13:41:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[customers_suppliers](
	[customer_number] [int] NOT NULL,
	[subsidiary] [int] NULL,
	[is_supplier] [smallint] NULL,
	[is_natural_person] [smallint] NULL,
	[is_dummy_customer] [smallint] NULL,
	[salutation_code] [varchar](50) NULL,
	[name_prefix] [varchar](50) NULL,
	[first_name] [varchar](50) NULL,
	[family_name] [varchar](50) NULL,
	[name_postfix] [varchar](50) NULL,
	[country_code] [varchar](10) NULL,
	[zip_code] [varchar](50) NULL,
	[home_city] [varchar](50) NULL,
	[home_street] [varchar](50) NULL,
	[parts_rebate_group_buy] [int] NULL,
	[parts_rebate_group_sell] [int] NULL,
	[rebate_labour_percent] [numeric](9, 5) NULL,
	[rebate_material_percent] [numeric](9, 5) NULL,
	[rebate_new_vehicles_percent] [numeric](9, 5) NULL,
	[cash_discount_percent] [numeric](9, 5) NULL,
	[vat_id_number] [varchar](50) NULL,
	[vat_id_number_checked_date] [datetime] NULL,
    [vat_id_free_code_1] [int] NULL,
    [vat_id_free_code_2] [int] NULL,
	[birthday] [datetime] NULL,
	[last_contact] [datetime] NULL,
	[preferred_com_number_type] [varchar](10) NULL,
	[created_date] [datetime] NULL,
	[created_employee_no] [int] NULL,
	[updated_date] [datetime] NULL,
	[updated_employee_no] [int] NULL,
	[name_updated_date] [datetime] NULL,
	[name_updated_employee_no] [int] NULL,
 CONSTRAINT [customers_suppliers_temp_20180403051222_pkey] PRIMARY KEY CLUSTERED 
(
	[customer_number] 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].[dealer_vehicles]    Script Date: 02.10.2019 13:41:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[dealer_vehicles](
	[dealer_vehicle_type] [varchar](10) NOT NULL,
	[dealer_vehicle_number] [int] NOT NULL,
	[vehicle_number] [int] NULL,
	[location] [varchar](50) NULL,
	[buyer_customer_no] [int] NULL,
	[deregistration_date] [datetime] NULL,
	[refinancing_start_date] [datetime] NULL,
	[refinancing_end_date] [datetime] NULL,
	[refinancing_value] [numeric](9, 2) NULL,
	[refinancing_refundment] [numeric](9, 2) NULL,
	[refinancing_bank_customer_no] [int] NULL,
	[refinanc_interest_free_date] [datetime] NULL,
	[in_subsidiary] [int] NULL,
	[in_buy_salesman_number] [int] NULL,
	[in_buy_order_no] [varchar](50) NULL,
	[in_buy_order_no_date] [datetime] NULL,
	[in_buy_invoice_no] [varchar](50) NULL,
	[in_buy_invoice_no_date] [datetime] NULL,
	[in_buy_edp_order_no] [varchar](50) NULL,
	[in_buy_edp_order_no_date] [datetime] NULL,
	[in_opel_production_no] [varchar](50) NULL,
	[in_is_trade_in_ken] [varchar](10) NULL,
	[in_is_trade_in_kom] [int] NULL,
	[in_used_vehicle_buy_type] [varchar](10) NULL,
	[in_buy_list_price] [numeric](9, 2) NULL,
	[in_arrival_date] [datetime] NULL,
	[in_expected_arrival_date] [datetime] NULL,
	[in_accounting_document_type] [varchar](10) NULL,
	[in_accounting_document_number] [int] NULL,
	[in_accounting_document_date] [datetime] NULL,
	[in_acntg_exceptional_group] [varchar](10) NULL,
	[in_acntg_cost_unit_new_vehicle] [numeric](2, 0) NULL,
	[in_accounting_make] [numeric](2, 0) NULL,
	[in_registration_reference] [varchar](50) NULL,
	[in_expected_repair_cost] [numeric](9, 2) NULL,
	[in_order_status] [varchar](10) NULL,
	[out_subsidiary] [int] NULL,
	[out_is_ready_for_sale] [varchar](10) NULL,
	[out_ready_for_sale_date] [datetime] NULL,
	[out_sale_type] [varchar](10) NULL,
	[out_sales_contract_number] [int] NULL,
	[out_sales_contract_date] [datetime] NULL,
	[out_is_sales_contract_confrmed] [varchar](10) NULL,
	[out_salesman_number_1] [int] NULL,
	[out_salesman_number_2] [int] NULL,
	[out_desired_shipment_date] [datetime] NULL,
	[out_is_registration_included] [varchar](10) NULL,
	[out_recommended_retail_price] [numeric](9, 2) NULL,
	[out_extra_expenses] [numeric](9, 2) NULL,
	[out_sale_price] [numeric](9, 2) NULL,
	[out_sale_price_dealer] [numeric](9, 2) NULL,
	[out_sale_price_minimum] [numeric](9, 2) NULL,
	[out_sale_price_internet] [numeric](9, 2) NULL,
	[out_estimated_invoice_value] [numeric](9, 2) NULL,
	[out_discount_percent_vehicle] [numeric](9, 5) NULL,
	[out_discount_percent_accessory] [numeric](9, 5) NULL,
	[out_order_number] [int] NULL,
	[out_invoice_type] [int] NULL,
	[out_invoice_number] [int] NULL,
	[out_invoice_date] [datetime] NULL,
	[out_deposit_invoice_type] [int] NULL,
	[out_deposit_invoice_number] [int] NULL,
	[out_deposit_value] [numeric](9, 2) NULL,
	[out_license_plate] [varchar](50) NULL,
	[out_make_number] [int] NULL,
	[out_model_code] [varchar](50) NULL,
	[out_license_plate_country] [varchar](50) NULL,
	[out_license_plate_season] [varchar](50) NULL,
	[calc_basic_charge] [numeric](9, 2) NULL,
	[calc_accessory] [numeric](9, 2) NULL,
	[calc_extra_expenses] [numeric](9, 2) NULL,
	[calc_usage_value_encr_external] [numeric](9, 2) NULL,
	[calc_usage_value_encr_internal] [numeric](9, 2) NULL,
	[calc_usage_value_encr_other] [numeric](9, 2) NULL,
	[calc_total_writedown] [numeric](9, 2) NULL,
	[calc_cost_percent_stockingdays] [numeric](3, 0) NULL,
	[calc_interest_percent_stkdays] [numeric](6, 3) NULL,
	[calc_actual_payed_interest] [numeric](9, 2) NULL,
	[calc_commission_for_arranging] [numeric](9, 2) NULL,
	[calc_commission_for_salesman] [numeric](9, 2) NULL,
	[calc_cost_internal_invoices] [numeric](9, 2) NULL,
	[calc_cost_other] [numeric](9, 2) NULL,
	[calc_sales_aid] [numeric](9, 2) NULL,
	[calc_sales_aid_finish] [numeric](9, 2) NULL,
	[calc_sales_aid_bonus] [numeric](9, 2) NULL,
	[calc_returns_workshop] [numeric](9, 2) NULL,
	[exclusive_reserved_employee_no] [int] NULL,
	[exclusive_reserved_until] [datetime] NULL,
	[pre_owned_car_code] [varchar](10) NULL,
	[is_sale_internet] [varchar](10) NULL,
	[is_sale_prohibit] [varchar](10) NULL,
	[is_agency_business] [varchar](10) NULL,
	[is_rental_or_school_vehicle] [varchar](10) NULL,
	[previous_owner_number] [int] NULL,
	[mileage_km] [int] NULL,
	[mileage_miles] [int] NULL,
	[memo] [varchar](255) NULL,
	[keys_box_number] [int] NULL,
	[last_change_date] [datetime] NULL,
	[last_change_employee_no] [int] NULL,
	[created_date] [datetime] NULL,
	[created_employee_no] [int] NULL,
	[financing_example_ref] [int] NULL,
    [leasing_example_ref] [int] NULL,
 CONSTRAINT [pk_dealer_vehicles] PRIMARY KEY CLUSTERED 
(
	[dealer_vehicle_type] ASC,
	[dealer_vehicle_number] 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].[document_types]    Script Date: 02.10.2019 13:41:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[document_types](
	[document_type_in_journal] [varchar](255) NOT NULL,
	[document_type_description] [varchar](255) NULL,
 CONSTRAINT [document_types_temp_20180403052123_pkey] PRIMARY KEY CLUSTERED 
(
	[document_type_in_journal] 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].[employees]    Script Date: 02.10.2019 13:41:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[employees](
	[employee_number] [int] NOT NULL,
	[validity_date] [datetime] NULL,
	[is_latest_record] [smallint] NULL,
	[subsidiary] [int] NULL,
	[has_constant_salary] [smallint] NULL,
	[name] [varchar](50) NULL,
	[initials] [varchar](10) NULL,
	[customer_number] [int] NULL,
	[mechanic_number] [int] NULL,
	[salesman_number] [int] NULL,
	[is_business_executive] [smallint] NULL,
	[is_master_craftsman] [smallint] NULL,
	[employment_date] [datetime] NULL,
	[termination_date] [datetime] NULL,
	[leave_date] [datetime] NULL,
	[is_flextime] [smallint] NULL,
	[break_time_registration] [varchar](10) NULL,
	[productivity_factor] [decimal](2,1),
 CONSTRAINT [employees_temp_20180403052145624678_pkey] PRIMARY KEY CLUSTERED 
(
	[employee_number] 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].[employees_breaktimes]    Script Date: 02.10.2019 13:41:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[employees_breaktimes](
	[is_latest_record] [smallint] NULL,
	[employee_number] [int] NOT NULL,
	[validity_date] [datetime] NOT NULL,
	[dayofweek] [int] NOT NULL,
	[break_start] [decimal](6, 3) NOT NULL,
	[break_end] [decimal](6, 3) NULL,
 CONSTRAINT [employees_breaktimes_temp_20180403052126_pkey] PRIMARY KEY CLUSTERED 
(
	[employee_number] ASC,
	[validity_date] ASC,
	[dayofweek] ASC,
	[break_start] 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].[employees_history]    Script Date: 02.10.2019 13:41:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[employees_history](
	[employee_number] [int] NOT NULL,
	[validity_date] [datetime] NOT NULL,
	[is_latest_record] [smallint] NULL,
	[subsidiary] [int] NULL,
	[has_constant_salary] [smallint] NULL,
	[name] [varchar](50) NULL,
	[initials] [varchar](10) NULL,
	[customer_number] [int] NULL,
	[mechanic_number] [int] NULL,
	[salesman_number] [int] NULL,
	[is_business_executive] [smallint] NULL,
	[is_master_craftsman] [smallint] NULL,
	[employment_date] [datetime] NULL,
	[termination_date] [datetime] NULL,
	[leave_date] [datetime] NULL,
	[is_flextime] [smallint] NULL,
	[break_time_registration] [varchar](10) NULL,
	[productivity_factor] [decimal](2,1),
 CONSTRAINT [employees_history_temp_20180403052128_pkey] PRIMARY KEY CLUSTERED 
(
	[employee_number] ASC,
	[validity_date] 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].[employees_worktimes]    Script Date: 02.10.2019 13:41:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[employees_worktimes](
	[is_latest_record] [smallint] NULL,
	[employee_number] [int] NOT NULL,
	[validity_date] [datetime] NOT NULL,
	[dayofweek] [int] NOT NULL,
	[work_duration] [decimal](6, 3) NULL,
	[worktime_start] [decimal](6, 3) NULL,
	[worktime_end] [decimal](6, 3) NULL,
 CONSTRAINT [employees_worktimes_temp_20180403052130_pkey] PRIMARY KEY CLUSTERED 
(
	[employee_number] ASC,
	[validity_date] ASC,
	[dayofweek] 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].[fuels]    Script Date: 02.10.2019 13:41:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[fuels](
	[code] [varchar](10) NOT NULL,
	[description] [varchar](255) NULL,
 CONSTRAINT [fuels_temp_20180403052131_pkey] 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].[invoice_types]    Script Date: 02.10.2019 13:41:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[invoice_types](
	[type] [int] NOT NULL,
	[description] [varchar](255) NULL,
 CONSTRAINT [invoice_types_temp_20180403052756_pkey] PRIMARY KEY CLUSTERED 
(
	[type] 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].[invoices]    Script Date: 02.10.2019 13:41:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[invoices](
	[invoice_type] [int] NOT NULL,
	[invoice_number] [int] NOT NULL,
	[subsidiary] [int] NULL,
	[order_number] [int] NULL,
	[paying_customer] [int] NULL,
	[order_customer] [int] NULL,
	[invoice_date] [datetime] NULL,
	[service_date] [datetime] NULL,
	[is_canceled] [smallint] NULL,
	[cancelation_number] [int] NULL,
	[cancelation_date] [datetime] NULL,
	[cancelation_employee] [int] NULL,
	[is_own_vehicle] [smallint] NULL,
	[is_credit] [smallint] NULL,
	[credit_invoice_type] [int] NULL,
	[credit_invoice_number] [int] NULL,
	[odometer_reading] [int] NULL,
	[creating_employee] [int] NULL,
	[internal_cost_account] [int] NULL,
	[vehicle_number] [int] NULL,
	[full_vat_basevalue] [numeric](9, 2) NULL,
	[full_vat_percentage] [numeric](4, 2) NULL,
	[full_vat_value] [numeric](18, 2) NULL,
	[reduced_vat_basevalue] [numeric](9, 2) NULL,
	[reduced_vat_percentage] [numeric](4, 2) NULL,
	[reduced_vat_value] [numeric](18, 2) NULL,
	[used_part_vat_value] [numeric](9, 2) NULL,
	[job_amount_net] [numeric](18, 2) NULL,
	[job_amount_gross] [numeric](18, 2) NULL,
	[job_rebate] [numeric](9, 2) NULL,
	[part_amount_net] [numeric](18, 2) NULL,
	[part_amount_gross] [numeric](18, 2) NULL,
	[part_rebate] [numeric](9, 2) NULL,
	[part_disposal] [numeric](9, 2) NULL,
	[total_gross] [numeric](18, 2) NULL,
	[total_net] [numeric](18, 2) NULL,
 CONSTRAINT [invoices_temp_20180403052133_pkey] PRIMARY KEY CLUSTERED 
(
	[invoice_type] ASC,
	[invoice_number] 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].[journal_accountings]    Script Date: 02.10.2019 13:41:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[journal_accountings](
	[accounting_date] [datetime] NOT NULL,
	[document_type] [varchar](255) NOT NULL,
	[document_number] [bigint] NOT NULL,
	[position_in_document] [bigint] NOT NULL,
	[customer_number] [bigint] NULL,
	[nominal_account_number] [bigint] NULL,
	[is_balanced] [varchar](10) NULL,
	[clearing_number] [bigint] NULL,
	[document_date] [datetime] NULL,
	[posted_value] [bigint] NULL,
	[debit_or_credit] [varchar](10) NULL,
	[posted_count] [bigint] NULL,
	[branch_number] [bigint] NULL,
	[customer_contra_account] [bigint] NULL,
	[nominal_contra_account] [bigint] NULL,
	[contra_account_text] [varchar](50) NULL,
	[account_form_page_number] [bigint] NULL,
	[account_form_page_line] [bigint] NULL,
	[serial_number_each_month] [bigint] NULL,
	[employee_number] [bigint] NULL,
	[invoice_date] [varchar](50) NULL,
	[invoice_number] [varchar](50) NULL,
	[dunning_level] [varchar](50) NULL,
	[last_dunning_date] [varchar](50) NULL,
	[journal_page] [bigint] NULL,
	[journal_line] [bigint] NULL,
	[cash_discount] [bigint] NULL,
	[term_of_payment] [bigint] NULL,
	[posting_text] [varchar](100) NULL,
	[vehicle_reference] [varchar](50) NULL,
	[vat_id_number] [varchar](50) NULL,
	[account_statement_number] [bigint] NULL,
	[account_statement_page] [bigint] NULL,
	[vat_key] [varchar](50) NULL,
	[days_for_cash_discount] [bigint] NULL,
	[day_of_actual_accounting] [datetime] NULL,
	[skr51_branch] [bigint] NULL,
	[skr51_make] [bigint] NULL,
	[skr51_cost_center] [bigint] NULL,
	[skr51_sales_channel] [bigint] NULL,
	[skr51_cost_unit] [bigint] NULL,
	[previously_used_account_no] [varchar](50) NULL,
	[free_form_accounting_text] [varchar](255) NULL,
	[free_form_document_text] [varchar](255) NULL,
 CONSTRAINT [journal_accountings_import_20180403120809_pkey] PRIMARY KEY CLUSTERED 
(
	[accounting_date] ASC,
	[document_type] ASC,
	[document_number] ASC,
	[position_in_document] 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].[labour_types]    Script Date: 02.10.2019 13:41:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[labour_types](
	[code] [varchar](10) NOT NULL,
	[description] [varchar](255) NULL,
 CONSTRAINT [labour_types_temp_20180403071554_pkey] 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].[labours]    Script Date: 02.10.2019 13:41:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[labours](
	[order_number] [int] NOT NULL,
	[order_position] [int] NOT NULL,
	[order_position_line] [int] NOT NULL,
	[subsidiary] [int] NULL,
	[is_invoiced] [smallint] NULL,
	[invoice_type] [int] NULL,
	[invoice_number] [int] NULL,
	[employee_no] [int] NULL,
	[mechanic_no] [int] NULL,
	[labour_operation_id] [varchar](50) NULL,
	[is_nominal] [smallint] NULL,
	[time_units] [varchar](50) NULL,
	[net_price_in_order] [numeric](9, 2) NULL,
	[rebate_percent] [numeric](4, 2) NULL,
	[goodwill_percent] [numeric](4, 1) NULL,
	[charge_type] [int] NOT NULL,
	[text_line] [varchar](100) NULL,
	[usage_value] [decimal](9,2),
 CONSTRAINT [labours_temp_20180403070609_pkey] PRIMARY KEY CLUSTERED 
(
	[order_number] ASC,
	[order_position] ASC,
	[order_position_line] ASC,
	[charge_type] 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].[makes]    Script Date: 02.10.2019 13:41:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[makes](
	[make_number] [int] NOT NULL,
	[is_actual_make] [smallint] NULL,
	[description] [varchar](255) NULL,
	[group_name] [varchar](10) NULL,
	[make_id_in_group] [varchar](10) NULL,
	[internal_labour_group] [int] NULL,
	[is_production_year_visible] [smallint] NULL,
	[is_transmission_no_visible] [smallint] NULL,
	[is_engine_no_visible] [smallint] NULL,
	[is_ricambi_no_visible] [smallint] NULL,
	[ricambi_label] [varchar](50) NULL,
	[is_preset_finance_stock_rate] [smallint] NULL,
	[rate_free_days_new_vehicle] [int] NULL,
	[rate_free_days_demo_vehicle] [int] NULL,
	[special_service_2_interval] [numeric](4, 1) NULL,
	[special_service_3_interval] [numeric](4, 1) NULL,
 CONSTRAINT [makes_temp_20180403071556_pkey] PRIMARY KEY CLUSTERED 
(
	[make_number] 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_to_fuels]    Script Date: 02.10.2019 13:41:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[model_to_fuels](
	[make_number] [int] NOT NULL,
	[model_code] [varchar](50) NOT NULL,
	[code] [varchar](10) NOT NULL,
 CONSTRAINT [model_to_fuels_temp_20180403072157_pkey] PRIMARY KEY CLUSTERED 
(
	[make_number] ASC,
	[model_code] 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].[models]    Script Date: 02.10.2019 13:41:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[models](
	[make_number] [int] NOT NULL,
	[model_code] [varchar](50) NOT NULL,
	[is_actual_model] [smallint] NULL,
	[model_currently_available] [smallint] NULL,
	[replacing_model_code] [varchar](50) NULL,
	[description] [varchar](255) NULL,
	[gear_count] [int] NULL,
	[seat_count] [int] NULL,
	[door_count] [int] NULL,
	[cylinder_count] [int] NULL,
	[vehicle_body] [varchar](10) NULL,
	[model_labour_group] [varchar](10) NULL,
	[has_hour_meter] [smallint] NULL,
	[source_extern] [smallint] NULL,
	[free_form_vehicle_class] [varchar](10) NULL,
	[vin_begin] [varchar](50) NULL,
	[vehicle_pool_code] [varchar](50) NULL,
	[vehicle_pool_engine_code] [varchar](10) NULL,
	[is_manual_transmission] [smallint] NULL,
	[is_all_wheel_drive] [smallint] NULL,
	[is_plugin_hybride] [smallint] NULL,
	[unloaded_weight] [int] NULL,
	[gross_vehicle_weight] [int] NULL,
	[power_kw] [int] NULL,
	[power_kw_at_rotation] [int] NULL,
	[cubic_capacity] [int] NULL,
	[german_kba_hsn] [varchar](10) NULL,
	[german_kba_tsn] [varchar](50) NULL,
	[annual_tax] [numeric](9, 2) NULL,
	[model_year] [varchar](50) NULL,
	[model_year_postfix] [varchar](10) NULL,
	[suggested_net_retail_price] [numeric](9, 2) NULL,
	[suggested_net_shipping_cost] [numeric](9, 2) NULL,
	[european_pollutant_class] [varchar](10) NULL,
	[efficiency_class] [varchar](10) NULL,
	[emission_code] [varchar](10) NULL,
	[carbondioxid_emission] [int] NULL,
	[nox_exhoust] [numeric](4, 3) NULL,
	[particle_exhoust] [numeric](4, 3) NULL,
	[external_schwacke_code] [varchar](50) NULL,
	[skr_carrier_flag] [int] NULL,
	[free_form_model_specification] [varchar](10) NULL,
	[external_technical_type] [varchar](10) NULL,
	[european_fuel_consumption_over] [numeric](4, 2) NULL,
	[european_fuel_consumption_coun] [numeric](4, 2) NULL,
	[european_fuel_consumption_city] [numeric](4, 2) NULL,
	[energy_consumption] [varchar](50) NULL,
	[insurance_class_liability] [int] NULL,
	[insurance_class_part_comprehen] [int] NULL,
	[insurance_class_full_comprehen] [int] NULL,
 CONSTRAINT [models_temp_20180403071559_pkey] PRIMARY KEY CLUSTERED 
(
	[make_number] ASC,
	[model_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].[nominal_accounts]    Script Date: 02.10.2019 13:41:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[nominal_accounts](
	[subsidiary_to_company_ref] [bigint] NOT NULL,
	[nominal_account_number] [bigint] NOT NULL,
	[account_description] [varchar](255) NULL,
	[is_profit_loss_account] [varchar](255) NULL,
	[vat_key] [varchar](255) NULL,
	[create_date] [datetime] NULL,
	[create_employee_number] [bigint] NULL,
	[oldest_accountable_month] [datetime] NULL,
 CONSTRAINT [nominal_accounts_temp_20180403072205_pkey] PRIMARY KEY CLUSTERED 
(
	[nominal_account_number] ASC,
	[subsidiary_to_company_ref] 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].[order_positions]    Script Date: 02.10.2019 13:41:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[order_positions](
	[order_number] [int] NOT NULL,
	[order_position] [int] NOT NULL,
	[labour_type] [varchar](10) NULL,
	[subsidiary] [int] NULL,
	[is_invoiced] [smallint] NULL,
	[invoice_type] [int] NULL,
	[invoice_number] [int] NULL,
	[order_date] [datetime] NULL,
	[estimated_inbound_time] [datetime] NULL,
	[estimated_outbound_time] [datetime] NULL,
	[order_print_date] [datetime] NULL,
	[order_taking_employee_no] [int] NULL,
	[order_delivery_employee_no] [int] NULL,
	[vehicle_number] [int] NULL,
	[dealer_vehicle_type] [varchar](10),
    [dealer_vehicle_number] [int],
	[order_mileage] [int] NULL,
	[order_customer] [int] NULL,
	[paying_customer] [int] NULL,
	[holder_number] [int] NULL,
	[parts_rebate_group_sell] [int] NULL,
	[clearing_delay_type] [varchar](10) NULL,
 CONSTRAINT [order_positions_temp_20180403072206_pkey] PRIMARY KEY CLUSTERED 
(
	[order_number] ASC,
	[order_position] 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].[part_types]    Script Date: 02.10.2019 13:41:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[part_types](
	[type] [int] NOT NULL,
	[description] [varchar](50) NULL,
 CONSTRAINT [part_types_temp_20180403073033_pkey] PRIMARY KEY CLUSTERED 
(
	[type] 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].[parts]    Script Date: 02.10.2019 13:41:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[parts](
	[order_number] [int] NOT NULL,
	[order_position] [int] NOT NULL,
	[order_position_line] [int] NOT NULL,
	[subsidiary] [int] NULL,
	[is_invoiced] [smallint] NULL,
	[invoice_type] [int] NULL,
	[invoice_number] [int] NULL,
	[employee_no] [int] NULL,
	[mechanic_no] [int] NULL,
	[part_number] [varchar](50) NULL,
	[stock_no] [int] NULL,
	[stock_removal_date] [datetime] NULL,
	[amount] [numeric](9, 2) NULL,
	[sum] [numeric](9, 2) NULL,
	[rebate_percent] [numeric](4, 2) NULL,
	[goodwill_percent] [numeric](4, 1) NULL,
	[parts_type] [int] NULL,
	[text_line] [varchar](50) NULL,
	[usage_value] [decimal](9,2),
 CONSTRAINT [parts_temp_20180403072452_pkey] PRIMARY KEY CLUSTERED 
(
	[order_number] ASC,
	[order_position] ASC,
	[order_position_line] 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].[parts_rebate_groups_buy]    Script Date: 02.10.2019 13:41:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[parts_rebate_groups_buy](
	[code] [int] NOT NULL,
	[description] [varchar](50) NULL,
 CONSTRAINT [parts_rebate_groups_buy_temp_20180403073031_pkey] 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].[parts_rebate_groups_sell]    Script Date: 02.10.2019 13:41:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[parts_rebate_groups_sell](
	[code] [int] NOT NULL,
	[description] [varchar](50) NULL,
 CONSTRAINT [parts_rebate_groups_sell_temp_20180403073032_pkey] 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].[time_types]    Script Date: 02.10.2019 13:41:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[time_types](
	[type] [int] NOT NULL,
	[description] [varchar](50) NULL,
 CONSTRAINT [time_types_temp_20180403073113_pkey] PRIMARY KEY CLUSTERED 
(
	[type] 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].[times]    Script Date: 02.10.2019 13:41:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[times](
	[employee_number] [int] NOT NULL,
	[order_number] [int] NOT NULL,
	[start_time] [datetime] NOT NULL,
	[type] [int] NULL,
	[order_positions] [varchar](10) NOT NULL,
	[end_time] [datetime] NULL,
	[duration_minutes] [int] NULL,
	[exact_duration_seconds] [bigint] NULL,
 CONSTRAINT [times_temp_20180403073035_pkey] PRIMARY KEY CLUSTERED 
(
	[employee_number] ASC,
	[order_number] ASC,
	[start_time] ASC,
	[order_positions] 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].[vat_keys]    Script Date: 02.10.2019 13:41:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[vat_keys](
	[subsidiary_to_company_ref] [bigint] NOT NULL,
	[vat_key] [varchar](255) NOT NULL,
	[key_validity_date] [datetime] NULL,
	[branch] [bigint] NULL,
	[description] [varchar](255) NULL,
	[vat_rate] [bigint] NULL,
	[create_date] [datetime] NULL,
	[vat_account] [bigint] NULL,
	[advanced_turnover_tax_pos] [bigint] NULL,
 CONSTRAINT [vat_keys_temp_20180403073114_pkey] PRIMARY KEY CLUSTERED 
(
	[vat_key] ASC,
	[subsidiary_to_company_ref] 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].[vehicle_bodys]    Script Date: 02.10.2019 13:41:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[vehicle_bodys](
	[code] [varchar](10) NOT NULL,
	[description] [varchar](255) NULL,
 CONSTRAINT [vehicle_bodys_temp_20180403073935_pkey] 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].[vehicle_buy_types]    Script Date: 02.10.2019 13:41:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[vehicle_buy_types](
	[code] [varchar](10) NOT NULL,
	[description] [varchar](100) NULL,
 CONSTRAINT [pk_vehicle_buy_types] 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].[vehicle_pre_owned_codes]    Script Date: 02.10.2019 13:41:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[vehicle_pre_owned_codes](
	[code] [varchar](10) NOT NULL,
	[description] [varchar](100) NULL,
 CONSTRAINT [pk_vehicle_pre_owned_codes] 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].[vehicle_sale_types]    Script Date: 02.10.2019 13:41:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[vehicle_sale_types](
	[code] [varchar](10) NOT NULL,
	[description] [varchar](100) NULL,
 CONSTRAINT [pk_vehicle_sale_types] 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].[vehicles]    Script Date: 02.10.2019 13:41:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[vehicles](
	[internal_number] [int] NOT NULL,
	[vin] [varchar](50) NULL,
	[license_plate] [varchar](50) NULL,
	[license_plate_country] [varchar](10) NULL,
	[license_plate_season] [varchar](10) NULL,
	[make_number] [int] NULL,
	[free_form_make_text] [varchar](10) NULL,
	[model_code] [varchar](50) NULL,
	[free_form_model_text] [varchar](50) NULL,
	[is_roadworthy] [smallint] NULL,
	[is_customer_vehicle] [smallint] NULL,
	[dealer_vehicle_type] [varchar](10) NULL,
	[dealer_vehicle_number] [int] NULL,
	[first_registration_date] [varchar](50) NULL,
	[readmission_date] [datetime] NULL,
	[next_service_date] [datetime] NULL,
	[next_service_km] [int] NULL,
	[next_service_miles] [int] NULL,
	[production_year] [varchar](50) NULL,
	[owner_number] [int] NULL,
	[holder_number] [int] NULL,
	[previous_owner_number] [int] NULL,
	[previous_owner_counter] [int] NULL,
	[last_holder_change_date] [datetime] NULL,
	[german_kba_hsn] [varchar](10) NULL,
	[german_kba_tsn] [varchar](50) NULL,
	[austria_nat_code] [varchar](50) NULL,
	[is_prefer_km] [smallint] NULL,
	[mileage_km] [int] NULL,
	[mileage_miles] [int] NULL,
	[odometer_reading_date] [datetime] NULL,
	[engine_number] [varchar](50) NULL,
	[gear_number] [varchar](50) NULL,
	[unloaded_weight] [int] NULL,
	[gross_vehicle_weight] [int] NULL,
	[power_kw] [int] NULL,
	[cubic_capacity] [int] NULL,
	[is_all_accidents_repaired] [smallint] NULL,
	[accidents_counter] [int] NULL,
	[has_tyre_pressure_sensor] [smallint] NULL,
	[carkey_number] [varchar](50) NULL,
	[internal_source_flag] [varchar](10) NULL,
	[emission_code] [varchar](10) NULL,
	[first_sold_country] [varchar](10) NULL,
	[first_sold_dealer_code] [int] NULL,
	[body_paint_code] [varchar](50) NULL,
	[body_paint_description] [varchar](50) NULL,
	[is_body_paint_metallic] [smallint] NULL,
	[interior_paint_code] [varchar](50) NULL,
	[interior_paint_description] [varchar](50) NULL,
	[trim_code] [varchar](50) NULL,
	[trim_description] [varchar](50) NULL,
	[fine_dust_label] [varchar](10) NULL,
	[internal_assignment] [varchar](10) NULL,
	[ricambi_free_input] [varchar](50) NULL,
	[document_number] [varchar](10) NULL,
	[salesman_number] [int] NULL,
	[sale_date] [varchar](50) NULL,
	[next_emission_test_date] [datetime] NULL,
	[next_general_inspection_date] [datetime] NULL,
	[next_rust_inspection_date] [datetime] NULL,
	[next_exceptional_inspection_da] [datetime] NULL,
	[last_change_date] [datetime] NULL,
	[last_change_employee_no] [int] NULL,
	[created_date] [datetime] NULL,
	[created_employee_no] [int] NULL,
	[last_change_subsidiary] [int] NULL,
 CONSTRAINT [vehicles_temp_20180403073115_pkey] PRIMARY KEY CLUSTERED 
(
	[internal_number] 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].[year_calendar]    Script Date: 02.10.2019 13:41:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[year_calendar](
	[calendar_id] [int] NOT NULL,
	[date] [datetime] NOT NULL,
	[day_off_declaration] [int] NULL,
	[is_school_holid] [smallint] NULL,
	[is_public_holid] [smallint] NULL,
	[day_note] [varchar](50) NULL,
 CONSTRAINT [year_calendar_temp_20180403073936_pkey] PRIMARY KEY CLUSTERED 
(
	[calendar_id] ASC,
	[date] 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].[year_calendar_day_off_codes]    Script Date: 02.10.2019 13:41:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[year_calendar_day_off_codes](
	[code] [int] NOT NULL,
	[description] [varchar](50) NULL,
 CONSTRAINT [year_calendar_day_off_codes_temp_20180403073938_pkey] 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].[year_calendar_subsidiary_mapping]    Script Date: 02.10.2019 13:41:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [import].[year_calendar_subsidiary_mapping](
	[subsidiary] [int] NOT NULL,
	[year] [int] NOT NULL,
	[calendar_id] [int] NULL,

 CONSTRAINT [year_calendar_subsidiary_mapping_temp_20180403073940_pkey] PRIMARY KEY CLUSTERED 
(
	[subsidiary] ASC,
	[year] 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 [import].[absence_calendar] ADD  DEFAULT ('0') FOR [employee_number]
GO
ALTER TABLE [import].[absence_calendar] ADD  DEFAULT ('0000-00-00') FOR [date]
GO
ALTER TABLE [import].[absence_calendar] ADD  DEFAULT ('0') FOR [unique_dummy]
GO
ALTER TABLE [import].[absence_reasons] ADD  DEFAULT ('') FOR [id]
GO
ALTER TABLE [import].[absence_types] ADD  DEFAULT ('') FOR [type]
GO
ALTER TABLE [import].[accounts_characteristics] ADD  DEFAULT ('0') FOR [skr51_branch]
GO
ALTER TABLE [import].[accounts_characteristics] ADD  DEFAULT ('0') FOR [skr51_make]
GO
ALTER TABLE [import].[accounts_characteristics] ADD  DEFAULT ('0') FOR [skr51_cost_center]
GO
ALTER TABLE [import].[accounts_characteristics] ADD  DEFAULT ('0') FOR [skr51_sales_channel]
GO
ALTER TABLE [import].[accounts_characteristics] ADD  DEFAULT ('0') FOR [skr51_cost_unit]
GO
ALTER TABLE [import].[charge_type_descriptions] ADD  DEFAULT ('0') FOR [type]
GO
ALTER TABLE [import].[charge_types] ADD  DEFAULT ('0') FOR [type]
GO
ALTER TABLE [import].[charge_types] ADD  DEFAULT ('0') FOR [subsidiary]
GO
ALTER TABLE [import].[clearing_delay_types] ADD  DEFAULT ('') FOR [type]
GO
ALTER TABLE [import].[com_number_types] ADD  CONSTRAINT [DF__com_number___typ__412EB0B6]  DEFAULT ('') FOR [typ]
GO
ALTER TABLE [import].[customer_codes] ADD  DEFAULT ('0') FOR [code]
GO
ALTER TABLE [import].[customer_com_numbers] ADD  DEFAULT ('0') FOR [customer_number]
GO
ALTER TABLE [import].[customer_com_numbers] ADD  DEFAULT ('0') FOR [counter]
GO
ALTER TABLE [import].[customer_to_customercodes] ADD  DEFAULT ('0') FOR [customer_number]
GO
ALTER TABLE [import].[customer_to_customercodes] ADD  DEFAULT ('0') FOR [customer_code]
GO
ALTER TABLE [import].[customers_suppliers] ADD  CONSTRAINT [DF__customers__custo__7CCECB3B]  DEFAULT ('0') FOR [customer_number]
GO
ALTER TABLE [import].[document_types] ADD  DEFAULT ('') FOR [document_type_in_journal]
GO
ALTER TABLE [import].[employees] ADD  DEFAULT ('0') FOR [employee_number]
GO
ALTER TABLE [import].[employees_history] ADD  DEFAULT ('0') FOR [employee_number]
GO
ALTER TABLE [import].[employees_history] ADD  DEFAULT ('0000-00-00') FOR [validity_date]
GO
ALTER TABLE [import].[fuels] ADD  DEFAULT ('') FOR [code]
GO
ALTER TABLE [import].[invoice_types] ADD  DEFAULT ('0') FOR [type]
GO
ALTER TABLE [import].[invoices] ADD  DEFAULT ('0') FOR [invoice_type]
GO
ALTER TABLE [import].[invoices] ADD  DEFAULT ('0') FOR [invoice_number]
GO
ALTER TABLE [import].[journal_accountings] ADD  CONSTRAINT [DF__journal_a__accou__4C6B5938]  DEFAULT ('2010-01-01 00:00:00') FOR [accounting_date]
GO
ALTER TABLE [import].[journal_accountings] ADD  CONSTRAINT [DF__journal_a__docum__4D5F7D71]  DEFAULT ('') FOR [document_type]
GO
ALTER TABLE [import].[journal_accountings] ADD  CONSTRAINT [DF__journal_a__docum__4E53A1AA]  DEFAULT ('0') FOR [document_number]
GO
ALTER TABLE [import].[journal_accountings] ADD  CONSTRAINT [DF__journal_a__posit__4F47C5E3]  DEFAULT ('0') FOR [position_in_document]
GO
ALTER TABLE [import].[labour_types] ADD  CONSTRAINT [DF__labour_typ__code__74AE54BC]  DEFAULT ('') FOR [code]
GO
ALTER TABLE [import].[labours] ADD  DEFAULT ('0') FOR [order_number]
GO
ALTER TABLE [import].[labours] ADD  DEFAULT ('0') FOR [order_position]
GO
ALTER TABLE [import].[labours] ADD  DEFAULT ('0') FOR [order_position_line]
GO
ALTER TABLE [import].[labours] ADD  DEFAULT ('0') FOR [charge_type]
GO
ALTER TABLE [import].[makes] ADD  DEFAULT ('0') FOR [make_number]
GO
ALTER TABLE [import].[model_to_fuels] ADD  DEFAULT ('0') FOR [make_number]
GO
ALTER TABLE [import].[model_to_fuels] ADD  DEFAULT ('') FOR [model_code]
GO
ALTER TABLE [import].[model_to_fuels] ADD  DEFAULT ('') FOR [code]
GO
ALTER TABLE [import].[models] ADD  DEFAULT ('0') FOR [make_number]
GO
ALTER TABLE [import].[models] ADD  DEFAULT ('') FOR [model_code]
GO
ALTER TABLE [import].[nominal_accounts] ADD  CONSTRAINT [DF_nominal_accounts_subsidiary_to_company_ref]  DEFAULT ((0)) FOR [subsidiary_to_company_ref]
GO
ALTER TABLE [import].[nominal_accounts] ADD  CONSTRAINT [DF__nominal_a__nomin__13B23093]  DEFAULT ('0') FOR [nominal_account_number]
GO
ALTER TABLE [import].[order_positions] ADD  CONSTRAINT [DF__order_pos__order__14270015]  DEFAULT ('0') FOR [order_number]
GO
ALTER TABLE [import].[order_positions] ADD  CONSTRAINT [DF__order_pos__order__151B244E]  DEFAULT ('0') FOR [order_position]
GO
ALTER TABLE [import].[part_types] ADD  DEFAULT ('0') FOR [type]
GO
ALTER TABLE [import].[parts] ADD  DEFAULT ('0') FOR [order_number]
GO
ALTER TABLE [import].[parts] ADD  DEFAULT ('0') FOR [order_position]
GO
ALTER TABLE [import].[parts] ADD  DEFAULT ('0') FOR [order_position_line]
GO
ALTER TABLE [import].[parts_rebate_groups_buy] ADD  DEFAULT ('0') FOR [code]
GO
ALTER TABLE [import].[parts_rebate_groups_sell] ADD  DEFAULT ('0') FOR [code]
GO
ALTER TABLE [import].[time_types] ADD  DEFAULT ('0') FOR [type]
GO
ALTER TABLE [import].[times] ADD  DEFAULT ('0') FOR [employee_number]
GO
ALTER TABLE [import].[times] ADD  DEFAULT ('0') FOR [order_number]
GO
ALTER TABLE [import].[times] ADD  DEFAULT ('0') FOR [start_time]
GO
ALTER TABLE [import].[times] ADD  DEFAULT ('') FOR [order_positions]
GO
ALTER TABLE [import].[vat_keys] ADD  CONSTRAINT [DF_vat_keys_subsidiary_to_company_ref]  DEFAULT ((0)) FOR [subsidiary_to_company_ref]
GO
ALTER TABLE [import].[vat_keys] ADD  CONSTRAINT [DF__vat_keys__vat_ke__210C2BB1]  DEFAULT ('') FOR [vat_key]
GO
ALTER TABLE [import].[vehicle_bodys] ADD  DEFAULT ('') FOR [code]
GO
ALTER TABLE [import].[vehicles] ADD  CONSTRAINT [DF__vehicles__intern__3864608B]  DEFAULT ('0') FOR [internal_number]
GO
ALTER TABLE [import].[year_calendar] ADD  DEFAULT ('0') FOR [calendar_id]
GO
ALTER TABLE [import].[year_calendar] ADD  DEFAULT ('0000-00-00') FOR [date]
GO
ALTER TABLE [import].[year_calendar_day_off_codes] ADD  DEFAULT ('0') FOR [code]
GO
ALTER TABLE [import].[year_calendar_subsidiary_mapping] ADD  DEFAULT ('0') FOR [subsidiary]
GO
ALTER TABLE [import].[year_calendar_subsidiary_mapping] ADD  DEFAULT ('0') FOR [year]
GO