123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203 |
- USE [LOCOSOFT]
- GO
- CREATE VIEW [dbo].[absence_calendar] AS
- SELECT * FROM [import].[absence_calendar]
- GO
- CREATE VIEW [dbo].[absence_reasons] AS
- SELECT * FROM [import].[absence_reasons]
- GO
- CREATE VIEW [dbo].[absence_types] AS
- SELECT * FROM [import].[absence_types]
- GO
- CREATE VIEW [dbo].[accounts_characteristics] AS
- SELECT * FROM [import].[accounts_characteristics]
- GO
- CREATE VIEW [dbo].[charge_type_descriptions] AS
- SELECT * FROM [import].[charge_type_descriptions]
- GO
- CREATE VIEW [dbo].[charge_types] AS
- SELECT * FROM [import].[charge_types]
- GO
- CREATE VIEW [dbo].[clearing_delay_types] AS
- SELECT * FROM [import].[clearing_delay_types]
- GO
- CREATE VIEW [dbo].[com_number_types] AS
- SELECT * FROM [import].[com_number_types]
- GO
- CREATE VIEW [dbo].[customer_codes] AS
- SELECT * FROM [import].[customer_codes]
- GO
- CREATE VIEW [dbo].[customer_com_numbers] AS
- SELECT * FROM [import].[customer_com_numbers]
- GO
- CREATE VIEW [dbo].[customer_to_customercodes] AS
- SELECT * FROM [import].[customer_to_customercodes]
- GO
- CREATE VIEW [dbo].[customers_suppliers] AS
- SELECT * FROM [import].[customers_suppliers]
- GO
- CREATE VIEW [dbo].[document_types] AS
- SELECT * FROM [import].[document_types]
- GO
- CREATE VIEW [dbo].[employees] AS
- SELECT * FROM [import].[employees]
- GO
- CREATE VIEW [dbo].[employees_breaktimes] AS
- SELECT * FROM [import].[employees_breaktimes]
- GO
- CREATE VIEW [dbo].[employees_history] AS
- SELECT * FROM [import].[employees_history]
- GO
- CREATE VIEW [dbo].[employees_worktimes] AS
- SELECT * FROM [import].[employees_worktimes]
- GO
- CREATE VIEW [dbo].[fuels] AS
- SELECT * FROM [import].[fuels]
- GO
- CREATE VIEW [dbo].[invoice_types] AS
- SELECT * FROM [import].[invoice_types]
- GO
- CREATE VIEW [dbo].[invoices] AS
- SELECT * FROM [import].[invoices]
- GO
- CREATE VIEW [dbo].[journal_accountings] AS
- SELECT * FROM [import].[journal_accountings]
- GO
- CREATE VIEW [dbo].[labour_types] AS
- SELECT * FROM [import].[labour_types]
- GO
- CREATE VIEW [dbo].[labours] AS
- SELECT * FROM [import].[labours]
- GO
- CREATE VIEW [dbo].[makes] AS
- SELECT * FROM [import].[makes]
- GO
- CREATE VIEW [dbo].[model_to_fuels] AS
- SELECT * FROM [import].[model_to_fuels]
- GO
- CREATE VIEW [dbo].[models] AS
- SELECT * FROM [import].[models]
- GO
- CREATE VIEW [dbo].[nominal_accounts] AS
- SELECT * FROM [import].[nominal_accounts]
- GO
- CREATE VIEW [dbo].[order_positions] AS
- SELECT * FROM [import].[order_positions]
- GO
- CREATE VIEW [dbo].[part_types] AS
- SELECT * FROM [import].[part_types]
- GO
- CREATE VIEW [dbo].[parts] AS
- SELECT * FROM [import].[parts]
- GO
- CREATE VIEW [dbo].[parts_rebate_groups_buy] AS
- SELECT * FROM [import].[parts_rebate_groups_buy]
- GO
- CREATE VIEW [dbo].[parts_rebate_groups_sell] AS
- SELECT * FROM [import].[parts_rebate_groups_sell]
- GO
- CREATE VIEW [dbo].[time_types] AS
- SELECT * FROM [import].[time_types]
- GO
- CREATE VIEW [dbo].[times] AS
- SELECT * FROM [import].[times]
- GO
- CREATE VIEW [dbo].[vat_keys] AS
- SELECT * FROM [import].[vat_keys]
- GO
- CREATE VIEW [dbo].[vehicle_bodys] AS
- SELECT * FROM [import].[vehicle_bodys]
- GO
- CREATE VIEW [dbo].[vehicles] AS
- SELECT * FROM [import].[vehicles]
- GO
- CREATE VIEW [dbo].[year_calendar] AS
- SELECT * FROM [import].[year_calendar]
- GO
- CREATE VIEW [dbo].[year_calendar_day_off_codes] AS
- SELECT * FROM [import].[year_calendar_day_off_codes]
- GO
- CREATE VIEW [dbo].[year_calendar_subsidiary_mapping] AS
- SELECT * FROM [import].[year_calendar_subsidiary_mapping]
- GO
- CREATE VIEW [dbo].[codes_vehicle_date] AS
- SELECT * FROM [import].[codes_vehicle_date]
- GO
- CREATE VIEW [dbo].[codes_vehicle_date_def] AS
- SELECT * FROM [import].[codes_vehicle_date_def]
- GO
- CREATE VIEW [dbo].[codes_vehicle_def] AS
- SELECT * FROM [import].[codes_vehicle_def]
- GO
- CREATE VIEW [dbo].[codes_vehicle_list] AS
- SELECT * FROM [import].[codes_vehicle_list]
- GO
- CREATE VIEW [dbo].[codes_vehicle_mileage] AS
- SELECT * FROM [import].[codes_vehicle_mileage]
- GO
- CREATE VIEW [dbo].[codes_vehicle_mileage_def] AS
- SELECT * FROM [import].[codes_vehicle_mileage_def]
- GO
- CREATE VIEW [dbo].[dealer_vehicles] AS
- SELECT * FROM [import].[dealer_vehicles]
- GO
- CREATE VIEW [dbo].[vehicle_buy_types] AS
- SELECT * FROM [import].[vehicle_buy_types]
- GO
- CREATE VIEW [dbo].[vehicle_pre_owned_codes] AS
- SELECT * FROM [import].[vehicle_pre_owned_codes]
- GO
- CREATE VIEW [dbo].[vehicle_sale_types] AS
- SELECT * FROM [import].[vehicle_sale_types]
- GO
|