USE [utd]
GO
IF OBJECT_ID(N'[utd].[dbo].[_Справочник_Номенклатура]', N'U') IS NOT NULL DROP VIEW [utd].[dbo].[_Справочник_Номенклатура]
CREATE VIEW [dbo].[_Справочник_Номенклатура] AS
SELECT
       _IDRRef as Ссылка
      ,_Version as ВерсияДанных
      ,_Marked as ПометкаУдаления
      ,_IsMetadata as Предопределенный
      ,_ParentIDRRef as Родитель
      ,_Folder as ЭтоГруппа
      ,_Code as Код
      ,_Description as Наименование
      ,_Fld2586 as Tmax
      ,_Fld2587 as Tmin
      ,_Fld23745RRef as АвторПоследнегоИзменения
      ,_Fld2539 as Артикул
      ,_Fld24652 as АртикулПоставщикаДляИмпорта
      ,_Fld2588 as АртикулСАПР
      ,_Fld24404 as АртикулТР
      ,_Fld2540RRef as БазоваяЕдиницаИзмерения
      ,_Fld2611RRef as Брэнд
FROM _Reference152 (nolock)
GO
IF OBJECT_ID(N'[utd].[dbo].[_Справочник_Номенклатура_Электричество]', N'U') IS NOT NULL DROP VIEW [utd].[dbo].[_Справочник_Номенклатура_Электричество]
CREATE VIEW [dbo].[_Справочник_Номенклатура_Электричество] AS
SELECT
       _LineNo2617 as НомерСтроки
      ,_Fld2618RRef as ТипПодвода
      ,_Fld2619 as Мощность
      ,_Fld2620 as Напряжение
      ,_Fld2621 as Фаза
      ,_Fld2622 as X
      ,_Fld2623 as Y
      ,_Fld2624 as Z
      ,_Fld2625RRef as ХарактеристикаСАПР
      ,_Reference152_IDRRef as Ссылка
      ,_KeyField as _KeyField
FROM _Reference152_VT2616 (nolock)