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

GO

Create  VIEW "DBA"."v_VtdVauchers"  as select vv.VaucherNum,
    ContractName=c.FullName,
    vv.DateReg,
    vv.DateArrive,
    vv.DateLeave,
    vv.ValNumLodgings,
    BP.BoardPlanName,
    vv.AdultsNumber,
    vv.ChildNumber,
    vv.CancelInvoiceNo,
    vv.TrueInvoceNo,
    vv.InvoiceNo
    from "dba".VtdVauchers as vv
    ,"dba".Contracts as c,"dba".BoardPlan as BP
    where vv.ContractNo=c.ContractNo
    and BP.N=vv.ValBoardPlan


GO


Update Relations
Set ColName='InvoiceNo',RelationCol='InvoiceNo',Function='InvoiceNo'
where TableName='v_VtdVauchers' and  ColName='TrueInvoceNo' and BGColName='СметкаNo'

GO

if (Select count(*) from Relations where TableName='v_VtdVauchers' and ColName='TrueInvoceNo' and BGColName='фактура No')=0 then

INSERT INTO Relations(TableName,ColName,BGTableName,BGColName,RelationTable,RelationCol,SelectCol,N,
Function,Suma,Mask,Align,Sortirane,Zadaljitelna,Promenliva,FilterList,DftFilter,
Shirina,Opisanie,DftLike,AutoStretch,Spravka,PoslData)
 VALUES('v_VtdVauchers','TrueInvoceNo','Ваучери','фактура No',
 'VtdVauchers','TrueInvoceNo',2,
 GetFreeNInRelations('VtdVauchers', Null, Null, 10),
 'TrueInvoceNo','','',0,0,'0','0','','',80,'',0,0,1,TODAY())

end if;