update HotelOptions
set BulgName='Единен идентификационен номер'
where OptionName='FirmBulstat'

GO

ALTER VIEW "DBA"."v_IzdadeniSmetki" 
as select SmetkaNo=INV.InvoiceNo,
FakturaNo=if((INV.TrueInvoiceNo <> 0) and(INV.TrueInvoiceNo < 1000000000)) then INV.MaskaFaktura || substr('0000000000',1,9-length(INV.TrueInvoiceNo)) || INV.TrueInvoiceNo
else convert(varchar,INV.TrueInvoiceNo)
endif,
DokData=INV.InvoiceDateDt,
Klient=INV.Whom,
DanNo=INV.Bulstat,
Operator=ADMIN.ShortName,
SumaBDDS=round(TotalNoVAT,4),
DDS=round(VAT,4),
Suma=round(GrandTotal,4),
PlatVBroi=round(VBroi,4),
PlatPoSmetka=round(PoSmetka,4),
Plateni=round(VBroi+PoSmetka,4) from
DBA.Invoices as INV,DBA.v_PariPoSmetki as PARI,DBA.Admin where
INV.InvoiceNo = PARI.SmetkaNo and INV.KodAdmin = ADMIN.AdminNo


GO

update Relations
Set BGColName='ЕИН'
where TableName='v_IzdadeniSmetki' and ColName='DanNo'

GO

update HotelOptions
set BulgName='Единен идентификационен номер на хотела'
where OptionName='HotelBulstat'

GO

if (select count(*) from sys.syscolumns where tname='HotelOptions' and cname='VisbalFlag')=0 then

alter table HotelOptions
Add VisbalFlag integer default 1;

update HotelOptions
set VisbalFlag=1;

end if


GO

update HotelOptions
Set VisbalFlag=0
where OptionName='HotelTaxNumber' or OptionName='FirmTaxNumber'