IF (EXISTS(Select * from sys.systable where LCase(table_name) = LCase('PayTypesAudit')))
THEN Drop view PayTypesAudit
END IF

GO

create view DBA.PayTypesAudit
  as select PT.PayTypeN as PayTypeCode, --код,
    PT.PayTypeName as PayTypeName, --наименование,
    "Date"(PT.CreateDate) as PayTypeCreateDate, --дата на първоначално конфигуриране в системата,
    "Date"(PT.LastChanged) as PayTypeChangeDate, --дата на последна промяна,
    null as PayTypeDate --дата на деактивиране;
    from DBA.PayTypes as PT
    where PT.PayTypeN in( 1,3,4 ) 
//[v 18.12.2018]