CREATE VARIABLE bvrUserN INT
Go
CREATE VARIABLE bvrUserIme CHAR(80)
Go
CREATE VARIABLE bvrSkladN INT
Go
CREATE VARIABLE bvrSkladIme CHAR(100)
Go
CREATE VARIABLE bvrData1 DATE
Go
CREATE VARIABLE bvrData2 DATE
Go
CREATE VARIABLE bvrData3 DATE
Go
CREATE VARIABLE bvrFromData DATE
Go
CREATE VARIABLE bvrArriveData DATE
Go
CREATE VARIABLE bvrDrobPari INT
Go
CREATE VARIABLE bvrDrobKolic INT
Go
CREATE VARIABLE bvrConnectID INT
Go
CREATE VARIABLE bvrCUrrKode INT
Go
CREATE VARIABLE bvrKratkoPtnIme SMALLINT
Go
CREATE VARIABLE bvrKratkoFktIme SMALLINT
Go
CREATE VARIABLE bvrImportStokaKod SMALLINT
Go
CREATE VARIABLE bvrNEW_LINE CHAR(2)
Go
CREATE VARIABLE bvrProcInd INT
Go
CREATE VARIABLE bvrALL_FILTER CHAR(20)
Go
CREATE VARIABLE bvrErrorMessage CHAR(200)
Go
CREATE VARIABLE bvrDDSPart decimal(12,4)
Go
CREATE VARIABLE bvrCodeLen INT
Go
CREATE VARIABLE bvrMesec INT
Go
CREATE VARIABLE bvrYear INT
Go
CREATE VARIABLE bvrGuest INT
Go
CREATE VARIABLE bvrBroi INT
Go
CREATE VARIABLE bvrFirstSeasson INT
Go
CREATE VARIABLE bvrLastSeasson INT
Go
CREATE VARIABLE bvrOfficDivider INT
Go
CREATE VARIABLE bvrOfficReminder INT
Go
CREATE VARIABLE bvrOfficContrIncl char(30)
Go
CREATE VARIABLE bvrNightDivider INT
Go
CREATE VARIABLE bvrNightReminder INT
Go
CREATE VARIABLE bvrRoomStr VARCHAR(1500)
Go
CREATE VARIABLE bvrFlagRes SMALLINT
Go
CREATE VARIABLE bvrMinPrice decimal(12,2)
Go
CREATE VARIABLE bvrMaxPrice decimal(12,2)
Go
CREATE VARIABLE bvrExecDir VARCHAR(255)
Go
CREATE VARIABLE bvrHotelName VARCHAR(30)
Go
CREATE VARIABLE bvrMaxDaysReg INT // max. broi dni za nastaniavane
Go
CREATE VARIABLE bvrFreeFiscalBon SMALLINT
GO
CREATE VARIABLE bvrOazisTime Time //ivaylo
Go
CREATE VARIABLE bvrArtificialTimeUslugi Time //Dobrin
Go
CREATE VARIABLE bvrArtificialTime Time //Dobrin
Go
CREATE VARIABLE bvrGuestType INT
Go
CREATE VARIABLE bvrSpaGuest VARCHAR(30)
Go
CREATE VARIABLE bvrSpaGuestType VARCHAR(30)
Go
CREATE VARIABLE bvrFirstdeposit integer  // kasa
Go
CREATE VARIABLE bvrLastdeposit integer   // kasa
Go
CREATE VARIABLE bvrVtdDiscOverVal integer
Go
CREATE VARIABLE bvrExportData datetime
Go
SET  bvrVtdDiscOverVal=0
Go
SET bvrBroi=0
Go
SET bvrFirstSeasson=0
Go
SET bvrLastSeasson=0;
Go
SET bvrUserN=1
Go
SET bvrDrobPari=2
Go
SET bvrDrobKolic=0
Go
SET bvrKratkoPtnIme=1
Go
SET bvrCUrrKode=0
Go
SET bvrKratkoFktIme=0
Go
SET bvrMinPrice=0
Go
SET bvrMaxPrice=0
Go
SET bvrImportStokaKod=0  //Local: 0 - Import stoka by name; 1 - by code
Go
SET bvrNEW_LINE='\n'
Go
SET bvrALL_FILTER=' <Всички>'
Go
SET OPTION "DATE_ORDER"='DMY'
Go
SET OPTION "DATE_FORMAT"='DD.MM.YYYY'
Go
SET OPTION "TIME_FORMAT"='HH:NN'
Go
SET bvrDDSPart=0.2
Go
SET bvrCodeLen=7
Go
SET bvrMesec=Month(current date)
Go
SET bvrYear=Year(current date)
Go
SET bvrData1=current date
Go
SET bvrData2=current date
Go
SET bvrData3=current date
Go
SET bvrOfficDivider=1  //Local: 3
Go
SET bvrOfficReminder=1  //Local: 1
Go
SET  bvrNightDivider=1
Go
SET bvrNightReminder=1
Go
SET bvrRoomStr=''
Go
SET bvrFlagRes=0
Go
SET bvrOfficContrIncl='%' //Local: '%ITS%'
Go
SET bvrConnectID=Connection_property('Number')
Go
SET bvrMaxDaysReg = 4000
Go
Set bvrGuestType=0
Go
Set bvrSpaGuest=''
Go
CREATE TABLE #Articles (ArticleNumber integer, ArticleDateRegDt date, ArticleName Varchar(200), Measure Varchar(10), ArticleQty numeric(12,2), MaxQty numeric(12,2), MinQty numeric(12,2), ArticlePrice double, RegNo integer, CreditNo integer, ArticleSum double, TipDDS integer, Discount double, ServiceNo integer, PriceInvCurrency double, ArticleSumInvCurrency double, TranslateName varchar(200), PriceInvWithDDS double, ArticleSumWithDDS double,RegDate date,KodCurrency integer default 1,DDS double,SpaResID integer default -1,RealLodgNum integer default 0, ZIndex integer default 0, RentMonth integer default -1, RentYear integer default 1000,VatRate numeric(3,3) default 0,DDSType integer default 1)
Go
CREATE TABLE #PaymentTypes (PaymentType integer, Sum double, KodCurrency integer, AccountNumber Varchar(16), Symbol varchar(10), GuestNo integer, GroupNo integer, RoomNo integer, ReserveNo integer, PTVid integer, ContractNo Integer)
Go
CREATE TABLE #GuestsForBill (GuestName varchar(40), GuestNo integer, RoomName varchar(6), Balance double, Contract varchar(40), ContractNo Integer)
Go
CREATE TABLE #Package (ServiceNo integer unique, ServicePrice numeric(12,2), KodCurrency integer)
Go
CREATE TABLE #VaucherArticles(ArticleNumber integer, VaucherN Integer, VaucherNum varchar(30),VaucherSeason varchar(20),VaucherBoard varchar(20),VaucherRoomType varchar(20),VaucherBedType varchar(20),Measure Varchar(10), Adult Integer,Child Integer,Nights Integer, TotalNights Integer,SinglePrice double,GrandTotal Double, ArticleName Varchar(40), GuestName varchar(100), CreditNo integer, Discount numeric(12,2) , ServiceNo integer, Currency Integer, TranslateName varchar(40),TranslateSeason varchar(20),TranslateBed varchar(20), TranslateGuestName varchar(100),SeasonNo Integer,HumanKind Integer,AdultType Integer,ExtraBed Integer,BoardPlan Integer,RoomType Integer,RowType Integer,ForVaucherN Integer,OtherDiskN integer default -1, TempGuestID integer default 0)
Go
CREATE TABLE #TempData (n int not null default autoincrement, D0 VARCHAR(255), D1 VARCHAR(255),D2 VARCHAR(255),D3 VARCHAR(255),D4 VARCHAR(255),D5 VARCHAR(255),D6 VARCHAR(255),D7 VARCHAR(255),D8 VARCHAR(255),D9 VARCHAR(255),D10 VARCHAR(255),D11 VARCHAR(255),D12 VARCHAR(255),D13 VARCHAR(255),D14 VARCHAR(255),D15 VARCHAR(255),D16 VARCHAR(255))
Go
CREATE VARIABLE bvrConToRiscont varchar(100)
GO
SET bvrConToRiscont='0C 06 0C'
GO
CREATE VARIABLE bvrPayChislo integer
GO
SET bvrPayChislo=0
GO
CREATE TABLE #ArticleLodgings (RegNum integer, "Name" varchar(100), RealLodgingsNum integer, Price numeric(12,4), Qty integer, MaxQty integer, MinQty integer, ZIndex integer, TipDDS integer, ServiceNoLodging integer, RentMonth integer default -1, RentYear integer default 1000,VatRate numeric(3,3) default 0,DDSType integer default 1)
GO
CREATE VARIABLE bvrSpravkaM integer
GO
SET bvrSpravkaM=1
GO
CREATE VARIABLE bvrSpravkaY integer
GO
SET bvrSpravkaY=2009
GO
CREATE TABLE #RLegloDni (N integer)
GO
CREATE VARIABLE bvrSpravkaM1 integer;
go
set bvrSpravkaM1=1
go
CREATE VARIABLE bvrSpravkaY1 integer;
go
set bvrSpravkaY1=2009
go
CREATE VARIABLE bvrSpravkaM2 integer;
go
set bvrSpravkaM2=1
go
CREATE VARIABLE bvrSpravkaY2 integer;
go
set bvrSpravkaY2=2009
go
CREATE VARIABLE bvrPayYear1 integer;
GO
set bvrPayYear1=YEAR(today(*))
GO
CREATE VARIABLE bvrPayYear2 integer;
GO
set bvrPayYear2=YEAR(today(*))
GO
CREATE VARIABLE bvrPayYear3 integer;
GO
set bvrPayYear3=YEAR(today(*))
GO
CREATE VARIABLE bvrPayYear4 integer;
GO
set bvrPayYear4=YEAR(today(*))
GO
CREATE VARIABLE bvrPayYear5 integer;
GO
set bvrPayYear5=YEAR(today(*))
GO
CREATE TABLE #AddrCardPayments(Mes varchar(10),MesReal integer,lvUG1 Numeric(12,2),kvUG1 varchar(20),lvUG2 Numeric(12,2),kvUG2 varchar(20),lvUG3 Numeric(12,2),kvUG3 varchar(20),lvUG4 Numeric(12,2),kvUG4 varchar(20),lvUG5 Numeric(12,2),kvUG5 varchar(20));
go
create table #OwePaidRentForMonth(GNo integer, "Month" varchar(10), DaysInMonth integer, "Year" integer, "Name" varchar(40),Uni varchar(200), Kurs varchar(50),Spec varchar(100), FN varchar(20), Address varchar(50), City varchar(50), Sex char(1), PriceKind varchar(40), Usluga varchar(60), Cena numeric(12,2), Kol numeric(12,2), SumOwe numeric(12,2), KolPaid numeric(12,2), SumPaid numeric(12,2), Razlika numeric(12,2), RealDatePayed date, Koef numeric(12,2), BrStudenti integer, RName varchar(6), CountryName varchar(40), PriceKindType varchar (60), PayType integer, PayTypeStr varchar(20), Subsidy double)
go
create table #OwePaidRentLodg(GNo integer, "Month" varchar(10), DaysInMonth integer, "Year" integer, "Name" varchar(40),Uni varchar(200), Kurs varchar(50),Spec varchar(100), FN varchar(20), Address varchar(50), City varchar(50), Sex char(1), PriceKind varchar(40), Usluga varchar(60), Cena numeric(12,2), Kol numeric(12,2), SumOwe numeric(12,2), KolPaid numeric(12,2), SumPaid numeric(12,2), Razlika numeric(12,2), RealDatePayed date, BrStudenti integer, RName varchar(6), CountryName varchar(40), PayType integer, PayTypeStr varchar(20))
go
create table #OwePaidRentLodgConso(HotelId integer, HotelName varchar(30), HotelCity varchar(50), GNo integer, "Month" varchar(10), DaysInMonth integer, "Year" integer, "Name" varchar(40),Uni varchar(200), Kurs varchar(50),Spec varchar(100), FN varchar(20), Address varchar(50), City varchar(50), Sex char(1), PriceKind varchar(40), Usluga varchar(60), Cena numeric(12,2), Kol numeric(12,2), SumOwe numeric(12,2), KolPaid numeric(12,2), SumPaid numeric(12,2), Razlika numeric(12,2), RealDatePayed date, BrStudenti integer, RName varchar(6), CountryName varchar(40))
go
create table #FreeBedsForPeriod(CurrentDate Date, HotelName varchar(30), TotalBeds integer, Students integer, FreeBeds integer, Unusable integer, PercentUsed numeric(12, 4), UniName varchar (80), Uni varchar(80), OverBooked integer)
go
create table #OwePaidRentMonth(GuestNo integer, NameMonth Varchar(10), Year integer, Name Varchar(40), UniName Varchar(200), Kurs Varchar(50), Spec Varchar(100), FN Varchar(20), Address Varchar(50), City Varchar(50), Sex char, PriceKind Varchar(40),	Usluga Varchar(60),	Cena double,	Kol double,	SumOwe double,	KolPaid double,	SumPaid double,	Razlika double,	RealDatePaid date,	Koef double,	RoomName Varchar(6),	Country Varchar(40),	DaysInMonth integer, PriceKindType varchar(60), PayType integer, PayTypeStr varchar(20), Subsidy double)
go
create table #OwePaidRentMonthConso(GuestNo integer, NameMonth Varchar(10), Year integer, Name Varchar(40), UniName Varchar(200), Kurs Varchar(50), Spec Varchar(100), FN Varchar(20), Address Varchar(50), City Varchar(50), Sex char, PriceKind Varchar(40),	Usluga Varchar(60),	Cena double,	Kol double,	SumOwe double,	KolPaid double,	SumPaid double,	Razlika double,	RealDatePaid date,	Koef double,	RoomName Varchar(6),	Country Varchar(40),	DaysInMonth integer, HotelName Varchar(30), PriceKindType Varchar(60), Subsidy double)
go
create table #OwePaidRentForMonthConso(GNo integer, "Month" varchar(10), DaysInMonth integer, "Year" integer, "Name" varchar(40),Uni varchar(200), Kurs varchar(50),Spec varchar(100), FN varchar(20), Address varchar(50), City varchar(50), Sex char(1), PriceKind varchar(40), Usluga varchar(60), Cena numeric(12,2), Kol numeric(12,2), SumOwe numeric(12,2), KolPaid numeric(12,2), SumPaid numeric(12,2), Razlika numeric(12,2), RealDatePayed date, Koef numeric(12,2), BrStudenti integer, RName varchar(6), CountryName varchar(40), HotelName Varchar(30), PriceKindType Varchar(60), Subsidy double)
go