LOCOSOFT_import_dbo.sql 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203
  1. USE [LOCOSOFT]
  2. GO
  3. CREATE VIEW [dbo].[absence_calendar] AS
  4. SELECT * FROM [import].[absence_calendar]
  5. GO
  6. CREATE VIEW [dbo].[absence_reasons] AS
  7. SELECT * FROM [import].[absence_reasons]
  8. GO
  9. CREATE VIEW [dbo].[absence_types] AS
  10. SELECT * FROM [import].[absence_types]
  11. GO
  12. CREATE VIEW [dbo].[accounts_characteristics] AS
  13. SELECT * FROM [import].[accounts_characteristics]
  14. GO
  15. CREATE VIEW [dbo].[charge_type_descriptions] AS
  16. SELECT * FROM [import].[charge_type_descriptions]
  17. GO
  18. CREATE VIEW [dbo].[charge_types] AS
  19. SELECT * FROM [import].[charge_types]
  20. GO
  21. CREATE VIEW [dbo].[clearing_delay_types] AS
  22. SELECT * FROM [import].[clearing_delay_types]
  23. GO
  24. CREATE VIEW [dbo].[com_number_types] AS
  25. SELECT * FROM [import].[com_number_types]
  26. GO
  27. CREATE VIEW [dbo].[customer_codes] AS
  28. SELECT * FROM [import].[customer_codes]
  29. GO
  30. CREATE VIEW [dbo].[customer_com_numbers] AS
  31. SELECT * FROM [import].[customer_com_numbers]
  32. GO
  33. CREATE VIEW [dbo].[customer_to_customercodes] AS
  34. SELECT * FROM [import].[customer_to_customercodes]
  35. GO
  36. CREATE VIEW [dbo].[customers_suppliers] AS
  37. SELECT * FROM [import].[customers_suppliers]
  38. GO
  39. CREATE VIEW [dbo].[document_types] AS
  40. SELECT * FROM [import].[document_types]
  41. GO
  42. CREATE VIEW [dbo].[employees] AS
  43. SELECT * FROM [import].[employees]
  44. GO
  45. CREATE VIEW [dbo].[employees_breaktimes] AS
  46. SELECT * FROM [import].[employees_breaktimes]
  47. GO
  48. CREATE VIEW [dbo].[employees_history] AS
  49. SELECT * FROM [import].[employees_history]
  50. GO
  51. CREATE VIEW [dbo].[employees_worktimes] AS
  52. SELECT * FROM [import].[employees_worktimes]
  53. GO
  54. CREATE VIEW [dbo].[fuels] AS
  55. SELECT * FROM [import].[fuels]
  56. GO
  57. CREATE VIEW [dbo].[invoice_types] AS
  58. SELECT * FROM [import].[invoice_types]
  59. GO
  60. CREATE VIEW [dbo].[invoices] AS
  61. SELECT * FROM [import].[invoices]
  62. GO
  63. CREATE VIEW [dbo].[journal_accountings] AS
  64. SELECT * FROM [import].[journal_accountings]
  65. GO
  66. CREATE VIEW [dbo].[labour_types] AS
  67. SELECT * FROM [import].[labour_types]
  68. GO
  69. CREATE VIEW [dbo].[labours] AS
  70. SELECT * FROM [import].[labours]
  71. GO
  72. CREATE VIEW [dbo].[makes] AS
  73. SELECT * FROM [import].[makes]
  74. GO
  75. CREATE VIEW [dbo].[model_to_fuels] AS
  76. SELECT * FROM [import].[model_to_fuels]
  77. GO
  78. CREATE VIEW [dbo].[models] AS
  79. SELECT * FROM [import].[models]
  80. GO
  81. CREATE VIEW [dbo].[nominal_accounts] AS
  82. SELECT * FROM [import].[nominal_accounts]
  83. GO
  84. CREATE VIEW [dbo].[order_positions] AS
  85. SELECT * FROM [import].[order_positions]
  86. GO
  87. CREATE VIEW [dbo].[part_types] AS
  88. SELECT * FROM [import].[part_types]
  89. GO
  90. CREATE VIEW [dbo].[parts] AS
  91. SELECT * FROM [import].[parts]
  92. GO
  93. CREATE VIEW [dbo].[parts_rebate_groups_buy] AS
  94. SELECT * FROM [import].[parts_rebate_groups_buy]
  95. GO
  96. CREATE VIEW [dbo].[parts_rebate_groups_sell] AS
  97. SELECT * FROM [import].[parts_rebate_groups_sell]
  98. GO
  99. CREATE VIEW [dbo].[time_types] AS
  100. SELECT * FROM [import].[time_types]
  101. GO
  102. CREATE VIEW [dbo].[times] AS
  103. SELECT * FROM [import].[times]
  104. GO
  105. CREATE VIEW [dbo].[vat_keys] AS
  106. SELECT * FROM [import].[vat_keys]
  107. GO
  108. CREATE VIEW [dbo].[vehicle_bodys] AS
  109. SELECT * FROM [import].[vehicle_bodys]
  110. GO
  111. CREATE VIEW [dbo].[vehicles] AS
  112. SELECT * FROM [import].[vehicles]
  113. GO
  114. CREATE VIEW [dbo].[year_calendar] AS
  115. SELECT * FROM [import].[year_calendar]
  116. GO
  117. CREATE VIEW [dbo].[year_calendar_day_off_codes] AS
  118. SELECT * FROM [import].[year_calendar_day_off_codes]
  119. GO
  120. CREATE VIEW [dbo].[year_calendar_subsidiary_mapping] AS
  121. SELECT * FROM [import].[year_calendar_subsidiary_mapping]
  122. GO
  123. CREATE VIEW [dbo].[codes_vehicle_date] AS
  124. SELECT * FROM [import].[codes_vehicle_date]
  125. GO
  126. CREATE VIEW [dbo].[codes_vehicle_date_def] AS
  127. SELECT * FROM [import].[codes_vehicle_date_def]
  128. GO
  129. CREATE VIEW [dbo].[codes_vehicle_def] AS
  130. SELECT * FROM [import].[codes_vehicle_def]
  131. GO
  132. CREATE VIEW [dbo].[codes_vehicle_list] AS
  133. SELECT * FROM [import].[codes_vehicle_list]
  134. GO
  135. CREATE VIEW [dbo].[codes_vehicle_mileage] AS
  136. SELECT * FROM [import].[codes_vehicle_mileage]
  137. GO
  138. CREATE VIEW [dbo].[codes_vehicle_mileage_def] AS
  139. SELECT * FROM [import].[codes_vehicle_mileage_def]
  140. GO
  141. CREATE VIEW [dbo].[dealer_vehicles] AS
  142. SELECT * FROM [import].[dealer_vehicles]
  143. GO
  144. CREATE VIEW [dbo].[vehicle_buy_types] AS
  145. SELECT * FROM [import].[vehicle_buy_types]
  146. GO
  147. CREATE VIEW [dbo].[vehicle_pre_owned_codes] AS
  148. SELECT * FROM [import].[vehicle_pre_owned_codes]
  149. GO
  150. CREATE VIEW [dbo].[vehicle_sale_types] AS
  151. SELECT * FROM [import].[vehicle_sale_types]
  152. GO