CREATE VIEW BookingLineDetails (ResNum, ReservationName, HotelCode, StartDate,EndDate,
            Status, Type, Class, NumberOfRooms, Adults, Children, Infants,
            RateCode, Rate, GroupCode, CompanyCode, TravelAgentCode,
            MarketSegment, MarketingArea, BookingMethod, ResCategory, PromotionCode)


As SELECT autonumbers.number, names.lastname, bookinglines.hotelcode,
bookinglines.startdate, bookinglines.enddate,BkgLineStatus.BkgLineStatus,
bookinglines.roomtype, bookinglines.roomclass,
bookinglines.numberofrooms,
bookinglines.numberofadultsinseg,bookinglines.numberofchildren,
bookinglines.numberofinfants, bookinglines.ratecode,
bookinglines.rateforbookline as Rate, reservationheader.GroupCode,
reservationheader.companycode, reservationheader.travelagentcode,
bookinglines.marketsegment, reservationheader.marketingarea,
reservationheader.bookingmethod,
reservationheader.category, reservationheader.promotioncode


FROM reservationheader, bookinglines, names, autonumbers, BkgLineStatus

WHERE bookinglines.status in (1,3,4,6,7,10,11,12,13,16) 
AND reservationheader.serialnumber = bookinglines.parentfileptrsernum
AND reservationheader.databasenumber = bookinglines.parentfileptrdbnum
AND autonumbers.parentfilenumber = 1180
AND autonumbers.parentfileptrsernum = reservationheader.serialnumber
AND autonumbers.databasenumber = reservationheader.databasenumber
AND names.serialnumber = reservationheader.resnameptrsernum
AND names.databasenumber = reservationheader.resnameptrdbnum
AND BkgLineStatus.bkgstatnumber = bookinglines.status #

CREATE VIEW CompanyAddressCodes 
(CompanyCode, CompanyName, CompanyStatus, Address1, Address2, Address3, Address4,
PostCode1, PostCode2, Country, PhoneNumber, FaxNumber, CreatedDate, MarketSegment, 
MarketingArea, BookingMethod, ReservationCategory, PromotionCode, CompanyType, 
AccountManager, SalesTerritory, SalesStatus, StatsCode1, StatsCode2, 
Interests1_1, Interests1_2, Interests1_3, Interests1_4,
Interests1_5, Interests1_6, Interests1_7, Interests1_8, Interests1_9, 
Interests1_10, Interests1_11, Interests1_12, Interests1_13, Interests1_14,
Interests1_15, Interests1_16, Interests1_17, Interests1_18, Interests1_19, 
Interests1_20, Interests1_21, Interests1_22, Interests1_23, Interests1_24,
Interests1_25, Interests1_26, Interests1_27, Interests1_28, Interests1_29, 
Interests1_30, Interests1_31, Interests1_32,
Interests2_1, Interests2_2, Interests2_3, Interests2_4,
Interests2_5, Interests2_6, Interests2_7, Interests2_8, Interests2_9, 
Interests2_10, Interests2_11, Interests2_12, Interests2_13, Interests2_14,
Interests2_15, Interests2_16, Interests2_17, Interests2_18, Interests2_19, 
Interests2_20, Interests2_21, Interests2_22, Interests2_23, Interests2_24,
Interests2_25, Interests2_26, Interests2_27, Interests2_28, Interests2_29, 
Interests2_30, Interests2_31, Interests2_32,
DefaultPayMethod, DefaultCoverage,
IATANumber, TAAssociation, TAAssocNumber,
SoleCommPC,DualCommPC) AS

select NameLink.CompanyCode, Names.LastName + Names.FirstName + Names.Title,
names.applicationtype,
Addresses.AddressLine2, Addresses.AddressLine3, Addresses.AddressLine4,
Addresses.AddressLine5, Addresses.Postcode1, Addresses.Postcode2, Addresses.Country,
TelephoneNumbers.Number, Telephone2.Number, companies.createddatedate,
Companies.MarketSegment, Companies.MarketAreaCode,
Companies.BookingMethodCode, Companies.ResCategoryCode,
Companies.PromotionCode, SalesInfo.CompanyType,
Salesinfo.salesperson, salesinfo.salesterritory,
salesinfo.salesstatus, salesinfo.statisticscode1,
salesinfo.statisticscode2,salesinfo.interests1bit0,
salesinfo.interests1bit1, salesinfo.interests1bit2, salesinfo.interests1bit3,
salesinfo.interests1bit4, salesinfo.interests1bit5, salesinfo.interests1bit6,
salesinfo.interests1bit7, salesinfo.interests1bit8, salesinfo.interests1bit9,
salesinfo.interests1bit10, salesinfo.interests1bit11, salesinfo.interests1bit12,
salesinfo.interests1bit13, salesinfo.interests1bit14, salesinfo.interests1bit15,
salesinfo.interests1bit16, salesinfo.interests1bit17, salesinfo.interests1bit18,
salesinfo.interests1bit19, salesinfo.interests1bit20, salesinfo.interests1bit21,
salesinfo.interests1bit22, salesinfo.interests1bit23, salesinfo.interests1bit24,
salesinfo.interests1bit25, salesinfo.interests1bit26, salesinfo.interests1bit27,
salesinfo.interests1bit28, salesinfo.interests1bit29, salesinfo.interests1bit30,
salesinfo.interests1bit31, salesinfo.interests2bit0, 
salesinfo.interests2bit1, salesinfo.interests2bit2, salesinfo.interests2bit3,
salesinfo.interests2bit4, salesinfo.interests2bit5, salesinfo.interests2bit6,
salesinfo.interests2bit7, salesinfo.interests2bit8, salesinfo.interests2bit9,
salesinfo.interests2bit10, salesinfo.interests2bit11, salesinfo.interests2bit12,
salesinfo.interests2bit13, salesinfo.interests2bit14, salesinfo.interests2bit15,
salesinfo.interests2bit16, salesinfo.interests2bit17, salesinfo.interests2bit18,
salesinfo.interests2bit19, salesinfo.interests2bit20, salesinfo.interests2bit21,
salesinfo.interests2bit22, salesinfo.interests2bit23, salesinfo.interests2bit24,
salesinfo.interests2bit25, salesinfo.interests2bit26, salesinfo.interests2bit27,
salesinfo.interests2bit28, salesinfo.interests2bit29, salesinfo.interests2bit30,
salesinfo.interests2bit31,  


Companies.PaymentMethod as DefaultPayMethod, companies.coveragecode as DefaultCoverage,
companies.iatanumber, companies.taassociation, companies.tanumber, 
companies.commpcsole as SoleCommPC, companies.commpcdual as DualCommPC


from NameLink, Names, Companies LEFT OUTER JOIN SalesInfo on Companies.CompanyCode
=Salesinfo.companycode, Addresses, TelephoneNumbers, TelephoneNumbers Telephone2
where NameLink.CompanyCode is not NULL and
Names.ParentFileNumber = 450 and
Names.ParentFilePtrSernum = NameLink.SerialNumber and
Names.ParentFilePtrDbnum = NameLink.DatabaseNumber and
Names.NameType = 2 and
Names.ApplicationType in (1,2)
and namelink.companycode = companies.companycode
and addresses.parentfilenumber = 1560
and addresses.parentfileptrsernum = companies.serialnumber
and addresses.parentfileptrdbnum = companies.databasenumber
and telephonenumbers.parentfilenumber = 1560
and telephonenumbers.parentfileptrsernum = companies.serialnumber
and telephonenumbers.parentfileptrdbnum = companies.databasenumber
and telephonenumbers.numbertype = 2
and telephone2.parentfilenumber = 1560
and telephone2.parentfileptrsernum = companies.serialnumber
and telephone2.parentfileptrdbnum = companies.databasenumber
and telephone2.numbertype = 3  #

CREATE VIEW CompanyCodeDetails (CompanyCode, CompanyName, CompanyStatus, 
CreatedDate, MarketSegment, 
MarketArea, BookingMethod, ResCategory, PromotionCode, CompanyType, AccountManager, 
SalesTerritory, SalesStatus, StatCode1, StatCode2, 
Interests1_1, Interests1_2, Interests1_3, Interests1_4,
Interests1_5, Interests1_6, Interests1_7, Interests1_8, Interests1_9, 
Interests1_10, Interests1_11, Interests1_12, Interests1_13, Interests1_14,
Interests1_15, Interests1_16, Interests1_17, Interests1_18, Interests1_19, 
Interests1_20, Interests1_21, Interests1_22, Interests1_23, Interests1_24,
Interests1_25, Interests1_26, Interests1_27, Interests1_28, Interests1_29, 
Interests1_30, Interests1_31, Interests1_32,
Interests2_1, Interests2_2, Interests2_3, Interests2_4,
Interests2_5, Interests2_6, Interests2_7, Interests2_8, Interests2_9, 
Interests2_10, Interests2_11, Interests2_12, Interests2_13, Interests2_14,
Interests2_15, Interests2_16, Interests2_17, Interests2_18, Interests2_19, 
Interests2_20, Interests2_21, Interests2_22, Interests2_23, Interests2_24,
Interests2_25, Interests2_26, Interests2_27, Interests2_28, Interests2_29, 
Interests2_30, Interests2_31, Interests2_32,
DefaultPayMethod, DefaultCoverage,
IATANumber, TAAssociation, TAAssocNumber,
SoleCommPC,DualCommPC) AS

select NameLink.CompanyCode, Names.LastName + Names.FirstName + Names.title,
names.applicationtype, companies.createddatedate,
Companies.MarketSegment, Companies.MarketAreaCode,
Companies.BookingMethodCode, Companies.ResCategoryCode,
Companies.PromotionCode, SalesInfo.CompanyType,
Salesinfo.salesperson, salesinfo.salesterritory,
salesinfo.salesstatus, salesinfo.statisticscode1,
salesinfo.statisticscode2,salesinfo.interests1bit0,
salesinfo.interests1bit1, salesinfo.interests1bit2, salesinfo.interests1bit3,
salesinfo.interests1bit4, salesinfo.interests1bit5, salesinfo.interests1bit6,
salesinfo.interests1bit7, salesinfo.interests1bit8, salesinfo.interests1bit9,
salesinfo.interests1bit10, salesinfo.interests1bit11, salesinfo.interests1bit12,
salesinfo.interests1bit13, salesinfo.interests1bit14, salesinfo.interests1bit15,
salesinfo.interests1bit16, salesinfo.interests1bit17, salesinfo.interests1bit18,
salesinfo.interests1bit19, salesinfo.interests1bit20, salesinfo.interests1bit21,
salesinfo.interests1bit22, salesinfo.interests1bit23, salesinfo.interests1bit24,
salesinfo.interests1bit25, salesinfo.interests1bit26, salesinfo.interests1bit27,
salesinfo.interests1bit28, salesinfo.interests1bit29, salesinfo.interests1bit30,
salesinfo.interests1bit31, salesinfo.interests2bit0, 
salesinfo.interests2bit1, salesinfo.interests2bit2, salesinfo.interests2bit3,
salesinfo.interests2bit4, salesinfo.interests2bit5, salesinfo.interests2bit6,
salesinfo.interests2bit7, salesinfo.interests2bit8, salesinfo.interests2bit9,
salesinfo.interests2bit10, salesinfo.interests2bit11, salesinfo.interests2bit12,
salesinfo.interests2bit13, salesinfo.interests2bit14, salesinfo.interests2bit15,
salesinfo.interests2bit16, salesinfo.interests2bit17, salesinfo.interests2bit18,
salesinfo.interests2bit19, salesinfo.interests2bit20, salesinfo.interests2bit21,
salesinfo.interests2bit22, salesinfo.interests2bit23, salesinfo.interests2bit24,
salesinfo.interests2bit25, salesinfo.interests2bit26, salesinfo.interests2bit27,
salesinfo.interests2bit28, salesinfo.interests2bit29, salesinfo.interests2bit30,
salesinfo.interests2bit31,  
Companies.PaymentMethod as DefaultPayMethod, companies.coveragecode as DefaultCoverage,
companies.iatanumber, companies.taassociation, companies.tanumber, 
companies.commpcsole as SoleCommPC, companies.commpcdual as DualCommPC


from NameLink, Names, Companies LEFT OUTER JOIN SalesInfo on Companies.CompanyCode
=Salesinfo.companycode
where NameLink.CompanyCode is not NULL and
Names.ParentFileNumber = 450 and
Names.ParentFilePtrSernum = NameLink.SerialNumber and
Names.ParentFilePtrDbnum = NameLink.DatabaseNumber and
Names.NameType = 2 and
Names.ApplicationType in (1,2)
and namelink.companycode = companies.companycode #

create view CompanyContacts (CompanyCode, CompanyName, CompanyStatus, ContactTitle, ContactForename,
ContactSurname, ContactJobTitle, ContactDept1, ContactDept2, ContactTelephone, ContactExtension,
ContactJobPosition, Interests1, Interests2, Interests3, Interests4,
Interests5, Interests6, Interests7, Interests8, Interests9, 
Interests10, Interests11, Interests12, Interests13, Interests14,
Interests15, Interests16, Interests17, Interests18, Interests19, 
Interests20, Interests21, Interests22, Interests23, Interests24,
Interests25, Interests26, Interests27, Interests28, Interests29, 
Interests30, Interests31, Interests32,
Flags) AS

select NameLink.CompanyCode, Names.LastName + Names.FirstName + Names.Title,
Names.ApplicationType,
name2.title, name2.firstname, name2.lastname,
contactnames.jobtitle, contactnames.department1, contactnames.department2, contactnames.telephone,
contactnames.extension, contactnames.jobposition, 
contactnames.interestsbit0, contactnames.interestsbit1, contactnames.interestsbit2,
contactnames.interestsbit3, contactnames.interestsbit4, contactnames.interestsbit5,
contactnames.interestsbit6, contactnames.interestsbit7, contactnames.interestsbit8,
contactnames.interestsbit9, contactnames.interestsbit10, contactnames.interestsbit11,
contactnames.interestsbit12, contactnames.interestsbit13, contactnames.interestsbit14,
contactnames.interestsbit15, contactnames.interestsbit16, contactnames.interestsbit17,
contactnames.interestsbit18, contactnames.interestsbit19, contactnames.interestsbit20,
contactnames.interestsbit21, contactnames.interestsbit22, contactnames.interestsbit23,
contactnames.interestsbit24, contactnames.interestsbit25, contactnames.interestsbit26,
contactnames.interestsbit27, contactnames.interestsbit28, contactnames.interestsbit29,
contactnames.interestsbit30, contactnames.interestsbit31,
contactnames.flags

from namelink, names, companies, contactnames, names as name2 

where NameLink.CompanyCode is not NULL and
Names.ParentFileNumber = 450 and
Names.ParentFilePtrSernum = NameLink.SerialNumber and
Names.ParentFilePtrDbnum = NameLink.DatabaseNumber and
Names.NameType = 2 and
Names.ApplicationType in (1,2)
and namelink.companycode = companies.companycode 
and contactnames.parentfilenumber = 1560 
and contactnames.parentfileptrsernum = companies.serialnumber
and contactnames.parentfileptrdbnum = companies.databasenumber
and name2.parentfilenumber = 310
and name2.parentfileptrsernum = contactnames.serialnumber
and name2.parentfileptrdbnum = contactnames.databasenumber #

CREATE VIEW CompanyNames (CompanyCode, CompanyName, CompanyStatus) AS
SELECT NameLink.CompanyCode, LastName + FirstName + Title, Names.ApplicationType
from NameLink, Names
where CompanyCode is not NULL and
Names.ParentFileNumber = 450 and
Names.ParentFilePtrSernum = NameLink.SerialNumber and
Names.ParentFilePtrDbnum = NameLink.DatabaseNumber and
Names.NameType = 2 and Names.ApplicationType in (1,2) #

CREATE VIEW FONLTransfers (SerialNumber, DatabaseNumber, FOHotel,
NLLedgerNumber, PostElementCode, TransactionType, CompanyCode,
HotelCode, DepartmentCode, ExpenseCode, ExpenseDescription,
Amount, FiscalDate) AS

select LedgerHold.SerialNumber, Ledgerhold.DatabaseNumber, LedgerHold.HotelCode,
LedgerHold.DestID, LedgerHold.PostElement, LedgerHold.SourceID, CANominalCodes.CompanyCode,
CANominalCodes.HotelCode, CANominalCodes.DepartmentCode, CANominalCodes.ExpenseCode,
CAExpenseCode.Expense, LedgerHold.Amount, LedgerHold.TransDate
from LedgerHold, CANominalCodes, CAExpenseCode
where LedgerHold.SourceApplication = 'FO'
and LedgerHold.DestApplication = 'NL'
and LedgerHold.DestAccountSernum=CANominalCodes.SerialNumber
and LedgerHold.DestAccountDbnum=CANominalCodes.DatabaseNumber
and CANominalCodes.ExpenseCode$=CAExpenseCode.ExpenseCode$ #

CREATE VIEW FOSLTransfers (SerialNumber, DatabaseNumber, FOHotel,
SLLedgerNumber, FolioNumber, FolioDescription, SLAccountCode,
SLAccountName, Amount, FiscalDate, SettledOn, SettledAt, SettledBy) AS
select LedgerHold.SerialNumber, Ledgerhold.DatabaseNumber, LedgerHold.HotelCode,
LedgerHold.DestID, LedgerHold.SourceAccountSernum, Folios.Description, LedgerHold.DestCode,
names.lastname+names.firstname+names.title, LedgerHold.Amount, LedgerHold.TransDate,
LedgerHold.CreatedDateDate, LedgerHold.CreatedDateTime, OperatorID.OperatorID
from LedgerHold, Folios, NameLink, Names, OperatorID
where LedgerHold.SourceApplication = 'FO'
and LedgerHold.DestApplication = 'SL'
and LedgerHold.SourceAccountSernum = Folios.SerialNumber
and LedgerHold.SourceAccountDbnum = Folios.DatabaseNumber
and LedgerHold.Destcode = namelink.companycode
and namelink.serialnumber = names.parentfileptrsernum
and namelink.databasenumber = names.parentfileptrdbnum
and names.parentfilenumber=450
and names.nametype=2
and Ledgerhold.CreatedOperator = OperatorID.OperatorNo #

CREATE VIEW GuestDetailsStays
(GuestID, Surname, Forename, Title, Address1, Address2, Address3, Address4,
Postcode1, Postcode2, Country, NumberofStays, NumberofBrochures,
VIPStatus, CompanyCode, MarketSegmentCode, LastCheckedOut, HotelCode,
StayArrivalDate,
Nights, Adults, Children, RoomNumber, RateCode, RateAmount, TotalRevenue,
RoomRevenue, FoodRevenue, BeverageRevenue, OtherRevenue) AS

select guests.serialnumber, names.LastName as Surname, names.FirstName as Forename, names.Title as title,
addresses.AddressLine2, addresses.AddressLine3, addresses.AddressLine4,
addresses.AddressLine5, addresses.PostCode1, addresses.PostCode2, 
addresses.Country, guests.NumberofStays, guests.BrochureRequests, 
guests.VIPstatus, guests.CompanyCode, 
guests.MarketSegment, guests.LastStay, 
staydetails.HotelCode, staydetails.ArrivalDate,
staydetails.NumberofNights, staydetails.NumberofAdults, 
staydetails.NumberofChildren, staydetails.RoomNumber,
staydetails.RateCode, staydetails.RateAmount, 
(staydetails.RoomRevenue+staydetails.FoodRevenue+
staydetails.BeverageRevenue+staydetails.OtherRevenue),
staydetails.RoomRevenue, staydetails.FoodRevenue, 
staydetails.BeverageRevenue,staydetails.OtherRevenue
from Guests, Names, StayDetails, Addresses
where guests.serialnumber = names.parentfileptrsernum
and guests.databasenumber = names.parentfileptrdbnum
and names.parentfilenumber = 1500
and guests.serialnumber = staydetails.guestptrsernum
and guests.databasenumber = staydetails.guestptrdbnum
and guests.serialnumber = addresses.parentfileptrsernum
and guests.databasenumber = addresses.parentfileptrdbnum #

CREATE VIEW InHouseGuests (HotelCode, Room, ResNumber, GuestLastName, FirstName, Title, BkgLineStart,
BkgLineEnd, RoomType, RoomClass, AdultsOnBkgLine, ChildrenOnBkgLine, InfantsOnBkgLine,
BkgLineRate, RateCode, GroupCode, CompanyCode, TACode, MarketSegment, MarketArea,
BookingMethod, ResCategory, Promotion) AS

select BookingLines.HotelCode, RoomSetup.RoomNumber, AutoNumbers.Number as ResNumber,
Names.Lastname, Names.FirstName, Names.Title, BookingLines.StartDate as BkgLineStart,
BookingLines.EndDate as BkgLineEnd, BookingLines.RoomType, BookingLines.RoomClass,
BookingLines.NumberOfAdultsinSeg as AdultsOnBkgLine,
BookingLines.NumberOfChildren as ChildrenOnBkgLine,
BookingLines.NumberOfInfants as InfantsOnBkgLine,
BookingLines.RateForBookLine as BkgLineRate, BookingLines.RateCode,
ReservationHeader.GroupCode, ReservationHeader.CompanyCode,
ReservationHeader.TravelAgentCode, BookingLines.MarketSegment,
ReservationHeader.MarketingArea, ReservationHeader.BookingMethod,
ReservationHeader.Category, ReservationHeader.PromotionCode

from ReservationHeader, Bookinglines, RoomAssignment, RoomSetup,
ReservationLink, Names, Autonumbers

where Bookinglines.status =1
and ReservationHeader.SerialNumber=BookingLines.ParentFilePtrSernum
and ReservationHeader.DatabaseNumber=BookingLines.ParentFilePtrDbnum
and AutoNumbers.ParentFileNumber = 1180
and AutoNumbers.ParentFilePtrSernum=ReservationHeader.SerialNumber
and AutoNumbers.ParentFilePtrDbnum=ReservationHeader.DatabaseNumber
and RoomAssignment.ParentFileNumber = 1200
and BookingLines.SerialNumber = RoomAssignment.parentFilePtrSernum
and Bookinglines.DatabaseNumber = RoomAssignment.ParentFilePtrDbnum
and RoomSetup.SerialNumber = RoomAssignment.RoomPtrSernum
and RoomSetup.DatabaseNumber = RoomAssignment.RoomPtrDbnum
and ReservationLink.ParentFileNumber = 1300
and ReservationLink.ParentFilePtrSernum = RoomAssignment.SerialNumber
and ReservationLink.ParentFilePtrDbnum = RoomAssignment.DatabaseNumber
and ReservationLink.NamePtrSernum = Names.SerialNumber
and ReservationLink.NamePtrDbnum = Names.DatabaseNumber
#
CREATE VIEW Stayovers (HotelCode, Room, ResNumber, GuestLastName, FirstName, Title, BkgLineStart,
BkgLineEnd, RoomType, RoomClass, AdultsOnBkgLine, ChildrenOnBkgLine, InfantsOnBkgLine,
BkgLineRate, RateCode, GroupCode, CompanyCode, TACode, MarketSegment, MarketArea,
BookingMethod, ResCategory, Promotion) AS
select BookingLines.HotelCode, RoomSetup.RoomNumber, AutoNumbers.Number as ResNumber,
Names.Lastname, Names.FirstName, Names.Title, BookingLines.StartDate as BkgLineStart,
BookingLines.EndDate as BkgLineEnd, BookingLines.RoomType, BookingLines.RoomClass,
BookingLines.NumberOfAdultsinSeg as AdultsOnBkgLine,
BookingLines.NumberOfChildren as ChildrenOnBkgLine,
BookingLines.NumberOfInfants as InfantsOnBkgLine,
BookingLines.RateForBookLine as BkgLineRate, BookingLines.RateCode,
ReservationHeader.GroupCode, ReservationHeader.CompanyCode,
ReservationHeader.TravelAgentCode, BookingLines.MarketSegment,
ReservationHeader.MarketingArea, ReservationHeader.BookingMethod,
ReservationHeader.Category, ReservationHeader.PromotionCode
from ReservationHeader, Bookinglines, RoomAssignment, RoomSetup,
ReservationLink, Names, Autonumbers
where Bookinglines.status =1
and ReservationHeader.SerialNumber=BookingLines.ParentFilePtrSernum
and ReservationHeader.DatabaseNumber=BookingLines.ParentFilePtrDbnum
and AutoNumbers.ParentFileNumber = 1180
and AutoNumbers.ParentFilePtrSernum=ReservationHeader.SerialNumber
and AutoNumbers.ParentFilePtrDbnum=ReservationHeader.DatabaseNumber
and RoomAssignment.ParentFileNumber = 1200
and BookingLines.SerialNumber = RoomAssignment.parentFilePtrSernum
and Bookinglines.DatabaseNumber = RoomAssignment.ParentFilePtrDbnum
and RoomSetup.SerialNumber = RoomAssignment.RoomPtrSernum
and RoomSetup.DatabaseNumber = RoomAssignment.RoomPtrDbnum
and ReservationLink.ParentFileNumber = 1300
and ReservationLink.ParentFilePtrSernum = RoomAssignment.SerialNumber
and ReservationLink.ParentFilePtrDbnum = RoomAssignment.DatabaseNumber
and ReservationLink.NamePtrSernum = Names.SerialNumber
and ReservationLink.NamePtrDbnum = Names.DatabaseNumber
AND BOOKINGLINES.ENDDATE > CURRENT_DATE()
AND (BOOKINGLINES.STARTDATE < CURRENT_DATE() OR BOOKINGLINES.PREVSEGPTRSERNUM IS NOT NULL)
#