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

GO


CREATE VIEW "DBA"."v_DDSProdagbi"  as select RedNo=Number(*),
    N=Invoices.InvoiceNo,
    Faktura=Invoices.TrueInvoiceNo,
    Ime=Invoices.Whom,
    DanN=Invoices.WhomDanNum,
    Suma=Invoices.GrandTotal,
    DDS=Invoices.VAT,
    SumaBezDDS=Invoices.TotalNoVAT,
    NeoblSuma=Invoices.WithoutVAT,
    FDate=Invoices.TrueInvoiceDate,"TYPE"='04',
    TypeName=DocTypes.DocName,Sdelka='ÓÑËÓÃÀ',
    Mask=Invoices.MaskaFaktura
    from "dba".Invoices,"dba".DocTypes
    where Invoices.TrueInvoiceNo<>0
    and    (    (Invoices.CancelInvoiceNo>0 and DocTypes.N=6  ) or (  (Invoices.CancelInvoiceNo=0 or Invoices.CancelInvoiceNo=-1) and DocTypes.N=4)   )