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

GO

create view DBA.FiscalDeviceFilterAudit
  as select Printers.N as FiscalDeviceN,
    Printers.Name || ' (' || Printers.FP_SERIAL_NOM || ')' as FiscalDeviceName
    from DBA.Printers
    where Trim(Printers.Name) <> '' and Trim(Printers.Driver) <> ''
    and Trim(Printers.FP_Fiscal_NOM) <> '' and Trim(Printers.FP_SERIAL_NOM) <> ''
//[v 18.12.2018]
