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

GO

create view DBA.PartnersAudit
  as select INV.Bulstat as Bulstat, --идентификатор (ЕИК, друг),
    INV.Whom as PartnerName, --имена,
    (select top 1 "date"(I.TrueInvoiceHour) from DBA.Invoices as I where I.Whom = INV.Whom and I.Bulstat = INV.Bulstat order by I.InvoiceNo asc) as PartnerCreateDate, --Date(P.InsDateTime) - дата на първоначално конфигуриране в системата,
    (select top 1 "date"(I1.TrueInvoiceHour) from DBA.Invoices as I1 where I1.Whom = INV.Whom and I1.Bulstat = INV.Bulstat order by I1.InvoiceNo desc) as PartnerLastChangeDate, --дата на последна промяна,
    null as PartnerDeactivatedDate --дата на деактивиране (ако софтуерът разполага с функционалност за въвеждане на доставчици);
    from DBA.Invoices as INV
    group by INV.Bulstat,INV.Whom
//[v 18.12.2018]