IF (EXISTS (select Table_name from SysTable where LCase(Table_name)=LCase('v_PayTypes'))) THEN
Drop View v_PayTypes
END IF

GO

CREATE VIEW "DBA"."v_PayTypes"  as
select
    DataPay=ResMoney.DateMoneyDt,
    PayType=PayTypes.PayTypeName,
    AllSum=ResMoney.Sum*DayRates.ExchangeRate,
    AllSumVlt=ResMoney.Sum,
    Valuta=Currencies.Symbol,
    DayRates.ExchangeRate,
    PTVidName=PTV.Description,
    DocNomer=ResMoney.AccountNumber,
    Smetka=(if  ResMoney.VaucherInvoiceNo is null then ResMoney.InvoiceNo else if ResMoney.InvoiceNo is null then ResMoney.VaucherInvoiceNo endif endif)
    from "dba".PayTypes,"dba".ResMoney,"dba".DayRates,"DBA".Currencies,"dba".PayTypesVids as PTV
    where ResMoney.Payment=PayTypes.PayTypeN
    and ResMoney.Currency=DayRates.KodCurrency and ResMoney.DateMoneyDt=DayRates.DateDt
    and ResMoney.Currency=Currencies.KodCurrency
    and DateMoneyDt>=bvrData1 and DateMoneyDt<=bvrData2
    and ResMoney.PTVid=PTV.N