# title : OPERA Cloud RnA StatisticsManagersReport GraphQL API, # description : GraphQL API to cater for Past statistics including rooms and revenue figures, arrivals, departures and occupancy broken out by multiple time periods. # Compatible with OPERA Cloud RnA release 26.1.0.0. # This document and all content within is available under the Universal Permissive License v 1.0 # (https://oss.oracle.com/licenses/upl). Copyright (c) 2020,2026 Oracle and/or its affiliates # version : 26.1.0.0 # termsOfService : https://www.oracle.com/legal/terms.html # contact_email : hospitality_apis_ww_grp@oracle.com # license : https://opensource.org/licenses/upl directive @stream(if: Boolean, label: String, initialCount: Int = 0) on FIELD directive @conditionalInputPair(pair: Int) on INPUT_FIELD_DEFINITION directive @mandatoryInput on INPUT_FIELD_DEFINITION scalar Date scalar DateTime # Date format: "YYYY-MM-DD" input DateInput{ _eq: Date _ne: Date _in: [Date] _nin: [Date] _gt: Date _lt: Date _gte: Date _lte: Date _btn: DateRangeInput _isNull: Boolean } input DateRangeInput { start: Date! end: Date! } # Datetime format: "YYYY-MM-DD HH24:MI:SS" input DateTimeInput { _eq: DateTime _ne: DateTime _in: [DateTime] _nin: [DateTime] _gt: DateTime _lt: DateTime _gte: DateTime _lte: DateTime _btn: DateTimeRangeInput _isNull: Boolean } input DateTimeRangeInput { start: DateTime! end: DateTime! } input StringInput { _eq: String _ne: String _in: [String] _nin: [String] _gt: String _lt: String _gte: String _lte: String _isNull: Boolean } input FloatInput { _eq: Float _ne: Float _in: [Float] _nin: [Float] _gt: Float _lt: Float _gte: Float _lte: Float _btn: FloatRangeInput _isNull: Boolean } input FloatRangeInput { start: Float! end: Float! } # Mandatory filters: # The following filters are mandatory required filters. # Please ensure the request includes all the below fields. # - managersreportDetailsBusinessDate # - managersreportDetailsResort input StatisticsManagersReportQueryArgumentsType { """Business Date""" managersreportDetailsBusinessDate: DateInput! @mandatoryInput """DSI Internal Data Source ID to identify Opera Chain and instance""" managersreportDetailsDsi: FloatInput """JRN Update Date and Time""" managersreportDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" managersreportDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" managersreportDetailsResort: StringInput! @mandatoryInput """Room Class""" managersreportDetailsRoomClass: StringInput """Business Date""" gregeriancalendarDetailsDaykey: DateInput """Calendar""" gregeriancalendarDetailsCalendarcode: StringInput """Calendarpkid""" gregeriancalendarDetailsCalendarpkid: FloatInput """Periodpkid""" gregeriancalendarDetailsPeriodpkid: FloatInput """Quarter""" gregeriancalendarDetailsQuartercode: StringInput """Quarterpkid""" gregeriancalendarDetailsQuarterpkid: FloatInput """Year""" gregeriancalendarDetailsYearcode: FloatInput """Yearpkid""" gregeriancalendarDetailsYearpkid: FloatInput """Business Date""" fiscalcalendarDetailsDaykey: DateInput """Calendar""" fiscalcalendarDetailsCalendarcode: StringInput """Calendarpkid""" fiscalcalendarDetailsCalendarpkid: FloatInput """Periodpkid""" fiscalcalendarDetailsPeriodpkid: FloatInput """Quarter""" fiscalcalendarDetailsQuartercode: StringInput """Quarterpkid""" fiscalcalendarDetailsQuarterpkid: FloatInput """Year""" fiscalcalendarDetailsYearcode: FloatInput """Yearpkid""" fiscalcalendarDetailsYearpkid: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" rateseasondayDetailsDsi: FloatInput """End Date""" rateseasondayDetailsEndDate: DateInput """JRN Update Date and Time""" rateseasondayDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" rateseasondayDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" rateseasondayDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" rateseasondayDetailsResort: StringInput """Rate Code""" rateseasondayDetailsRateCode: StringInput """Rateseasonid""" rateseasondayDetailsRateseasonid: StringInput """Season Code""" rateseasondayDetailsSeason: StringInput """Start Date""" rateseasondayDetailsBeginDate: DateInput """Currency Code""" foreigncurrencyDetailsCurrencyCode: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" foreigncurrencyDetailsDsi: FloatInput """JRN Update Date and Time""" foreigncurrencyDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" foreigncurrencyDetailsOrganizationid: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" roomclassDetailsDsi: FloatInput """JRN Update Date and Time""" roomclassDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" roomclassDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" roomclassDetailsResort: StringInput """Room Class""" roomclassDetailsRoomClass: StringInput """The property that the record belongs to""" resortDetailsResort: StringInput """Number format of AR account no.""" resortDetailsArAcctNoFormat: StringInput """Specifies if the AR acct No is mandatory(Y/N)""" resortDetailsArAcctNoMandYn: StringInput """Default Account Type for an Agent for the Property""" resortDetailsArAgent: StringInput """Internal""" resortDetailsArBalTrxCode: StringInput """Default Account Type for a Company for the Property""" resortDetailsArCompany: StringInput """Internal""" resortDetailsArCreditTrxCode: StringInput """Default Account Type for a Group for the Property""" resortDetailsArGroups: StringInput """Default Account Type for Individual for the Property""" resortDetailsArIndividuals: StringInput """Internal""" resortDetailsArSettleCode: StringInput """Internal""" resortDetailsArTypewriter: StringInput """Access Code""" resortDetailsAccessCode: StringInput """Number of handicapped rooms.""" resortDetailsQtyHandicappedRooms: FloatInput """Aging bucket 1""" resortDetailsAgingLevel1: FloatInput """Aging bucket 2""" resortDetailsAgingLevel2: FloatInput """Aging bucket 3""" resortDetailsAgingLevel3: FloatInput """Aging bucket 4""" resortDetailsAgingLevel4: FloatInput """Aging bucket 3""" resortDetailsAgingLevel5: FloatInput """The Airport Code for the airport near the property""" resortDetailsAirport: StringInput """Distance of the Airport specified in the AIRPORT_CODE column from the Property""" resortDetailsAirportDistance: StringInput """Time it takes to travel the distance between the Property and the Airport specified in AIRPORT_CODE column""" resortDetailsAirportTime: StringInput """Allow loggin in to this resort(Y/N)""" resortDetailsAllowLoginYn: StringInput """Period for the allowance""" resortDetailsAllowancePeriodAdj: StringInput """Internal""" resortDetailsAwardsTimeout: FloatInput """Ball Room Area""" resortDetailsBrArea: StringInput """No of Ballroom Seats""" resortDetailsBrSeats: FloatInput """The base language of the Hotel""" resortDetailsBaseLanguage: StringInput """It contains the reservation type to be used when making group block""" resortDetailsBlock: StringInput """Brand Code of the property.""" resortDetailsBrandCode: StringInput """Financial Year of the Property""" resortDetailsBudgetMonth: FloatInput """The date this resort becomes valid for use by the system""" resortDetailsBeginDate: DateInput """Value for the parameter.""" resortDetailsBusinessId: StringInput """Value for the parameter.""" resortDetailsBusinessRegCode: StringInput """Code for the CRO""" resortDetailsCroCode: StringInput """Internal""" resortDetailsCashShiftDrop: StringInput """Catering Currency Code used when Catering Currency differs from base currency.""" resortDetailsCateringCurrencyCode: StringInput """Catering currency format.""" resortDetailsCateringCurrencyFormat: StringInput """Central Exchange Date""" resortDetailsCXchangeDate: DateInput """Central Exchange Rate""" resortDetailsCXchangeRate: FloatInput """Central Credit Limit""" resortDetailsCCreditLimit: FloatInput """Central Currency Code""" resortDetailsCentralCurrencyCode: StringInput """Central Currency Description""" resortDetailsCentralCurrencyDesc: StringInput """Central Double Rate2""" resortDetailsCDblRate2: FloatInput """Central Double Rate1""" resortDetailsCDblRate1: FloatInput """Central Passerby Market""" resortDetailsRepPasserbyMarket: StringInput """Central Passerby Source""" resortDetailsRepPasserbySource: StringInput """Central Property Type""" resortDetailsRepResortType: StringInput """Central Sgl Rate1""" resortDetailsCSglRate1: FloatInput """Central Sgl Rate 2""" resortDetailsCSglRate2: FloatInput """Central State""" resortDetailsRepState: StringInput """Central State Description""" resortDetailsRepStateDesc: StringInput """Central Sui Rate1""" resortDetailsCSuiRate1: FloatInput """Central Sui Rate 2""" resortDetailsCSuiRate2: FloatInput """Central Tpl Rate1""" resortDetailsCTplRate1: FloatInput """Central Tpl Rate 2""" resortDetailsCTplRate2: FloatInput """Central Warning Amount""" resortDetailsCWarningAmount: FloatInput """Chain Code for the chain to which the property belongs""" resortDetailsChainCode: StringInput """The description of this chain.""" resortDetailsChainDescription: StringInput """Chain Mode""" resortDetailsChainMode: StringInput """Internal""" resortDetailsCheckExgPaidout: StringInput """The Hotel official check out time""" resortDetailsCheckOutTime: DateTimeInput """Internal""" resortDetailsCheckShiftDrop: StringInput """Internal""" resortDetailsCheckTrxcode: StringInput """The Hotel official check intime""" resortDetailsCheckInTime: DateTimeInput """The physical city in which this property resides.""" resortDetailsCity: StringInput """City Description""" resortDetailsCityDescription: StringInput """Internal""" resortDetailsComAddress: StringInput """Internal""" resortDetailsComMethod: StringInput """Internal""" resortDetailsComNameXrefId: FloatInput """Internal""" resortDetailsCompanyAddressType: StringInput """Internal""" resortDetailsCompanyPhoneType: StringInput """Internal""" resortDetailsConfigurationMode: StringInput """Internal""" resortDetailsConfirmRegcardPrinter: StringInput """Number of connecting rooms.""" resortDetailsQtyConnectingRooms: FloatInput """The unique name of application user""" resortDetailsAllContacts: StringInput """Number of copies to be printed""" resortDetailsCopies: FloatInput """Country name.""" resortDetailsCountryName: StringInput """The name of the country in which this property resides.""" resortDetailsCountryCode: StringInput """Value for the parameter.""" resortDetailsCountryMode: StringInput """The default credit limit for guests.""" resortDetailsCreditLimit: FloatInput """Currency Code.""" resortDetailsCurrencyCode: StringInput """Currency Symbol like $ or EURO symbol""" resortDetailsCurrencySymbol: StringInput """A description of this currency.""" resortDetailsCurrencyName: StringInput """Format for the local currency.""" resortDetailsLocalCurrencyFormat: StringInput """Color that of the background""" resortDetailsCurtainColor: StringInput """DSI""" resortDetailsDsi: FloatInput """Date the aging should begin""" resortDetailsDateForAging: StringInput """Type of separator to distinguish between DD MM and YYYY""" resortDetailsDateSeparator: StringInput """Number of places for the default currency""" resortDetailsDecimalPlaces: FloatInput """Type of decimal separator""" resortDetailsDecimalSeparator: StringInput """Number of decimals to designate currency""" resortDetailsCurrencyDecimals: FloatInput """Folio style to be used for all guests""" resortDetailsDefaultFolioStyle: FloatInput """Default guest address format.""" resortDetailsDefaultGuestAddress: StringInput """Future use""" resortDetailsDefaultMembershipType: StringInput """Future use""" resortDetailsDefaultPostingRoom: StringInput """Default property address format.""" resortDetailsDefaultPropertyAddress: StringInput """Future use""" resortDetailsDefaultRateCode: StringInput """Rate code used to default a PCR rate code used in FIT Contracts.""" resortDetailsDefaultRatecodePcr: StringInput """Rate code used to default a RACK rate code used for FIT Contracts.""" resortDetailsDefaultRatecodeRack: StringInput """Default registration card for the property.""" resortDetailsDefaultRegistrationCard: StringInput """The Default reservation type for this property""" resortDetailsDefaultReservationType: StringInput """Deleted Flag""" resortDetailsDeletedFlag: StringInput """Future use""" resortDetailsDepositLedTrxCode: StringInput """Destination ID""" resortDetailsDestinationId: StringInput """Future use""" resortDetailsDfltPkgTranCode: StringInput """Future use""" resortDetailsDfltTranCodeRateCode: StringInput """Internal""" resortDetailsDirections: StringInput """Future use""" resortDetailsDirsales: StringInput """LOGIN into the application is disabled.""" resortDetailsDisableLoginYn: StringInput """Number of double rooms.""" resortDetailsQtyDoubleRooms: FloatInput """Download Rest YN""" resortDetailsDownloadRestYn: StringInput """Pager number for the Manager on duty for the property.""" resortDetailsDutyManagerPager: StringInput """Email id for the property.""" resortDetailsEmail: StringInput """Future use.""" resortDetailsEndDate: DateInput """Default Exchange posting status for the property""" resortDetailsExchangePostingType: StringInput """Floor number of executive floor.""" resortDetailsFloorNumExecutiveFloor: StringInput """Hotel code used for third party exports""" resortDetailsExpHotelCode: StringInput """Future use""" resortDetailsExtExpFileLocation: StringInput """Future use""" resortDetailsExtPropertyCode: StringInput """Indicates that the property uses an external SC system.""" resortDetailsExternalScYn: StringInput """Number of family rooms.""" resortDetailsQtyFamilyRooms: FloatInput """Fax number formats.""" resortDetailsFaxNoFormat: StringInput """The fax phone number""" resortDetailsFax: StringInput """Future use""" resortDetailsFiscalEndDate: DateInput """Future use""" resortDetailsFiscalPeriodType: StringInput """Future use""" resortDetailsFiscalStartDate: DateInput """Fiscal Year Begin Month""" resortDetailsFiscalStartMonth: FloatInput """Fiscal Year Begin Year""" resortDetailsFiscalStartYear: FloatInput """Screen Painter flags to indicate whether an item is changable/ movable etc.""" resortDetailsFlags: StringInput """Future use""" resortDetailsFlowCode: StringInput """Property Free Nights Stay Tier.""" resortDetailsFnsTier: StringInput """Other languages""" resortDetailsFolioLanguage1: StringInput """Other languages""" resortDetailsFolioLanguage2: StringInput """Other languages""" resortDetailsFolioLanguage3: StringInput """Other languages""" resortDetailsFolioLanguage4: StringInput """Future use""" resortDetailsGenmgr: StringInput """To define an upper limit to the number of rooms for Group""" resortDetailsGroupRoomWarning: FloatInput """Future use""" resortDetailsGuestLookupTimeout: FloatInput """Number of guest elevators.""" resortDetailsQtyGuestElevators: FloatInput """Total of guest rooms floors.""" resortDetailsQtyGuestRoomFloors: FloatInput """Future use""" resortDetailsHotelCode: StringInput """Future use""" resortDetailsHotelFc: StringInput """Hotel id""" resortDetailsHotelId: StringInput """Future use""" resortDetailsHotelType: StringInput """Future use""" resortDetailsImgDirectionId: FloatInput """Future use""" resortDetailsImgHotelId: FloatInput """Future use""" resortDetailsImgMapId: FloatInput """Future use""" resortDetailsInactiveDaysForGuestProfil: FloatInput """Inactive Flag""" resortDetailsInactiveFlag: StringInput """Future use""" resortDetailsIndividualAddressType: StringInput """Future use""" resortDetailsIndividualPhoneType: StringInput """To define an upper limit to the number of rooms for group""" resortDetailsIndividualRoomWarning: FloatInput """The date the record was created""" resortDetailsInsertDate: DateTimeInput """The user that created the record""" resortDetailsInsertUser: FloatInput """Int Tax Included YN""" resortDetailsIntTaxIncludedYn: StringInput """Future use""" resortDetailsInventoryYn: StringInput """JRN Update Date and Time""" resortDetailsJrnupdatedttm: DateTimeInput """To calculate the entire availability of the Hotel for future reservations""" resortDetailsKeepAvailability: FloatInput """Latitude of the property in decimal""" resortDetailsLatitude: FloatInput """Future use""" resortDetailsLeadsend: StringInput """The owner who owns this property""" resortDetailsLegalOwner: StringInput """The property that the record belongs to""" resortDetailsLocationId: StringInput """Long date format for the property.""" resortDetailsLongDateFormat: StringInput """The default length of stay""" resortDetailsLongStayControl: FloatInput """Longitude of the property in decimal""" resortDetailsLongitude: FloatInput """Maximum adults in family rooms.""" resortDetailsMaxAdultsFamilyRoom: FloatInput """Maximum children in family rooms.""" resortDetailsMaxChildrenFamilyRoom: FloatInput """Future use""" resortDetailsMaxOccupancy: FloatInput """Maximum number of days that are allowed to credit a bill. (Country requirements.) Used in CASHIERING MODULE.""" resortDetailsMaxcreditdays: FloatInput """Indicates whether the property supports MBS. Used in some file exports.""" resortDetailsMbsSupportedYn: StringInput """Future use""" resortDetailsMeetRooms: FloatInput """Future use""" resortDetailsMeetSeats: FloatInput """Future use""" resortDetailsMeetSpace: FloatInput """Future use""" resortDetailsMeetingFc: StringInput """Minimum days for reminder letter.""" resortDetailsMinDaysBet2ReminderLetter: FloatInput """Internal""" resortDetailsNameIdLink: FloatInput """Future use""" resortDetailsNightAuditCashierId: StringInput """Number of non smoking rooms.""" resortDetailsQtyNonSmokingRooms: FloatInput """Notes for the property""" resortDetailsNotes: StringInput """Total number of beds in this property""" resortDetailsNumberBeds: FloatInput """Total number of floors in this property""" resortDetailsNumberFloors: FloatInput """Number of Rooms""" resortDetailsNumberRooms: FloatInput """Future use""" resortDetailsOpusCurrencyCode: StringInput """Organization ID""" resortDetailsOrganizationId: FloatInput """Organization Internal ID""" resortDetailsOrganizationid: FloatInput """Future use""" resortDetailsOwnership: StringInput """Package Loss code for a particular package""" resortDetailsPackageLoss: StringInput """Package Profit code for a particular Package""" resortDetailsPackageProfit: StringInput """Parent Org Code""" resortDetailsParentOrgCode: StringInput """Market code""" resortDetailsPasserbyMarket: StringInput """Source code""" resortDetailsPasserbySource: StringInput """Path""" resortDetailsPath: StringInput """Minimim Payment Date for the Property used in Cross Property Postings. This will get updated while running the user defined procedure during the night audit process.""" resortDetailsPaymentDate: DateTimeInput """Future use""" resortDetailsPerReservationRoomLimit: FloatInput """The direct dial phone number of this property""" resortDetailsTelephone: StringInput """The postal code of this property.""" resortDetailsPostCode: StringInput """Primary Key ID""" resortDetailsPkid: FloatInput """URL where property information is located.""" resortDetailsProinfoUrl: StringInput """Property MAP URL.""" resortDetailsPropMapUrl: StringInput """Property picture URL.""" resortDetailsPropPicUrl: StringInput """The property that the record belongs to""" resortDetailsLocationid: StringInput """The name of this property.""" resortDetailsName: StringInput """Type of resort.""" resortDetailsResortType: StringInput """Future use""" resortDetailsQuotedCurrency: StringInput """RNA Insert Date""" resortDetailsRnaInsertdate: DateTimeInput """RNA Update Date""" resortDetailsRnaUpdatedate: DateTimeInput """Minimim last Reconciliation Date for the Property used in Cross Property Postings. This will get updated while running the user defined procedure during the night audit process.""" resortDetailsReconcileDate: DateTimeInput """Future use""" resortDetailsRegionCode: StringInput """Description of the Region.""" resortDetailsRegionDescription: StringInput """Future use""" resortDetailsRestaurant: FloatInput """Total number of Sheets""" resortDetailsRhythmSheets: FloatInput """Total number of Towels""" resortDetailsRhythmTowels: FloatInput """Room amenity.""" resortDetailsRoomAmenity: StringInput """Future use""" resortDetailsSglNum: StringInput """Future use""" resortDetailsSglRate1: FloatInput """Future use""" resortDetailsSglRate2: FloatInput """Future use""" resortDetailsSuiNum: StringInput """Future use""" resortDetailsSuiRate1: FloatInput """Future use""" resortDetailsSuiRate2: FloatInput """To store number of days before deleting the gest profile""" resortDetailsSaveProfiles: FloatInput """Future use""" resortDetailsScriptId: FloatInput """Future use""" resortDetailsSeason1: StringInput """Future use""" resortDetailsSeason2: StringInput """Future use""" resortDetailsSeason3: StringInput """Future use""" resortDetailsSeason4: StringInput """Future use""" resortDetailsSeason5: StringInput """Indicates that the property accepts leads as bookings.""" resortDetailsSendLeadAsBooking: StringInput """Shop description.""" resortDetailsShopDescription: StringInput """Short date format for the property.""" resortDetailsShortDateFormat: StringInput """Number of single rooms.""" resortDetailsQtySingleRooms: FloatInput """For default commission percentage""" resortDetailsSourceCommission: StringInput """The state in which this property is located.""" resortDetailsState: StringInput """Description of the state.""" resortDetailsStateDesc: StringInput """The street of the property.""" resortDetailsStreet: StringInput """Number of suites.""" resortDetailsQtySuites: FloatInput """Internal""" resortDetailsSummCurrencyCode: StringInput """For default commission percentage""" resortDetailsTaCommission: StringInput """Future use""" resortDetailsTplNum: StringInput """Future use""" resortDetailsTplRate1: FloatInput """Future use""" resortDetailsTplRate2: FloatInput """Formats for telephone number""" resortDetailsTelephoneNoFormat: StringInput """Separator for monetory values""" resortDetailsThousandSeparator: StringInput """Default time format for the property.""" resortDetailsTimeFormat: StringInput """Time zone region selected by the employee.""" resortDetailsTimezoneRegion: StringInput """Toll free telephone number.""" resortDetailsTollfree: StringInput """Future use""" resortDetailsTotRooms: FloatInput """Tourist Number""" resortDetailsTouristNumber: StringInput """Indicates whether the property handles multi byte characters and whether they are translateable or not""" resortDetailsTranslateMulticharYn: StringInput """Turnaway code for the property.""" resortDetailsTurnawayCode: StringInput """Number of twin rooms.""" resortDetailsQtyTwinRooms: FloatInput """The date the record was modified""" resortDetailsUpdateDate: DateTimeInput """The user that modified the record""" resortDetailsUpdateUser: FloatInput """VAT ID of this property.""" resortDetailsVatId: StringInput """Future use""" resortDetailsVideocheckoutPrinter: StringInput """Video check out start time.""" resortDetailsVideoCoStart: DateTimeInput """Video check out end time.""" resortDetailsVideoCoStop: DateTimeInput """Future use""" resortDetailsWakeUpDelay: FloatInput """Amount at which warning is raised.""" resortDetailsWarningAmount: FloatInput """Webaddress of the property""" resortDetailsWebaddress: StringInput """Weekend days for the property.""" resortDetailsWeekendDays: StringInput """Internal""" resortDetailsZeroInvPurDays: FloatInput } type Query { """Past statistics including rooms and revenue figures arrivals departures and occupancy broken out by multiple time periods.""" statisticsManagersReport(limit: Int offset: Int input: StatisticsManagersReportQueryArgumentsType!): [StatisticsManagersReportType] } type StatisticsManagersReportType { """Managers Report Details""" managersReportDetails: StatisticsManagersReportManagersReportDetailsType """Gregerian Calendar""" gregerianCalendarDetails: StatisticsManagersReportGregerianCalendarDetailsType """Fiscal Calendar""" fiscalCalendarDetails: StatisticsManagersReportFiscalCalendarDetailsType """Rate Season Daily Details""" rateSeasonDayDetails: StatisticsManagersReportRateSeasonDayDetailsType """Foreign Currency Details""" foreignCurrencyDetails: StatisticsManagersReportForeignCurrencyDetailsType """Room Class Details""" roomClassDetails: StatisticsManagersReportRoomClassDetailsType """Resort Details""" propertyPropertyDetails: StatisticsManagersReportPropertyPropertyDetailsType statisticsManagersReportRecordCount: Int } type StatisticsManagersReportManagersReportDetailsType { """Not Used""" adultsFree: Float """Number of Adults in House.""" adultsInHouse: Float """Advance Food Revenue""" advFoodRevenue: Float """Advance Non Revenue""" advNonRevenue: Float """Advance Other Revenue""" advOtherRevenue: Float """Advance Room Revenue""" advRoomRevenue: Float """Advance Total Food Tax""" advTotalFoodTax: Float """Advance Total Non Revenue Tax""" advTotalNonRevenueTax: Float """Advance Total Other Tax""" advTotalOtherTax: Float """Advance Total Revenue""" advTotalRevenue: Float """Advance Total Room Tax""" advTotalRoomTax: Float """Advance Total Tax""" advTotalTax: Float """Total amount of postings today where the transaction code is marked as room revenue for reservations that have a travel agent profile attached to the reservation.""" agentRoomRevenue: Float """Total tax amount of postings today where the transaction code is marked as room revenue for reservations that have a travel agent profile attached to the reservation.""" agentRoomTax: Float """Number of rooms in house that have a Travel Agent attached to the reservation.""" agentRooms: Float """Total amount of postings today where the transaction code is marked as revenue for reservations that have a travel agent profile attached to the reservation.""" agentTotalRevenue: Float """Total tax amount of postings today where the transaction code is marked as revenue for reservations that have a travel agent profile attached to the reservation.""" agentTotalTax: Float """Number of adults and children arriving today""" arrivalPersons: Float """Number of reservations with an arrival date of today.""" arrivalReservations: Float """Number of Rooms with an arrival date today""" arrivalRooms: Float """Total rooms in hotel minus rooms occupied""" availableRooms: Float """Not Used""" averageAgeToday: Float """Average Daily Rate without Comp & House""" averageDailyRateMinusComplimentaryHouseUse: Float """Not used""" averageDailyRevenue: Float """Not Used""" bedsAvailable: Float """Number of rooms with birthday field equal to today""" birthdays: Float """Number of Nights for all reservations that are considered for Rooms Occupied a membership number of the default membership type attached to the reserveration with a block code attached to the reservation. If no default membership type is defined then any membership attached to the reservation will be considered. Used for Calculation of Average Length of Stay.""" blockMemLosNights: Float """Total amount of all postings today where the transaction code is marked as Revenue and the transaction type is Lodging a membership number of the default membership type attached to the reserveration with a block code attached to the reservation. If no default membership type is defined then any membership attached to the reservation will be considered.""" blockMemRoomRevenue: Float """Total tax amount of all postings today where the transaction code is marked as Revenue and the transaction type is Lodging a membership number of the default membership type attached to the reserveration with a block code attached to the reservation. If no default membership type is defined then any membership attached to the reservation will be considered.""" blockMemRoomRevenueTax: Float """Number of rooms with a membership number of the default membership type attached to the reserveration with a block code attached to the reservation. If no default membership type is defined then any membership attached to the reservation will be considered.""" blockMemRooms: Float """Total amount of all postings today where the transaction code is marked as Revenue a membership number of the default membership type attached to the reserveration with a block code attached to the reservation. If no default membership type is defined then any membership attached to the reservation will be considered.""" blockMemTotalRevenue: Float """Total tax amount of all postings today where the transaction code is marked as Revenue a membership number of the default membership type attached to the reserveration with a block code attached to the reservation. If no default membership type is defined then any membership attached to the reservation will be considered.""" blockMemTotalRevenueTax: Float """Counts all reservations that are considered for Rooms Occupied a membership number of the default membership type attached to the reserveration with a block code attached to the reservation. If no default membership type is defined then any membership attached to the reservation will be considered. Used for Calculation of Average Length of Stay.""" blockMembershipLosResv: Float """Business Date""" businessDate: Date """Central Adv Food Revenue""" cAdvanceFoodRevenue: Float """Central Adv Non Revenue""" cAdvanceNonRevenue: Float """Central Adv Other Revenue""" cAdvanceOtherRevenue: Float """Central Adv Room Revenue""" cAdvanceRoomRevenue: Float """Central Adv Total Food Tax""" cAdvanceTotalFoodTax: Float """Central Adv Total Non Revenue Tax""" cAdvanceTotalNonRevenueTax: Float """Central Adv Total Other Tax""" cAdvanceTotalOtherTax: Float """Central Adv Total Revenue""" cAdvanceTotalRevenue: Float """Central Adv Total Room Tax""" cAdvanceTotalRoomTax: Float """Central Adv Total Tax""" cAdvanceTotalTax: Float """Central Agent Room Revenue""" cAgentRoomRevenue: Float """Central Agent Room Tax""" cAgentRoomTax: Float """Central Agent Total Revenue""" cAgentTotalRevenue: Float """Central Agent Total Tax""" cAgentTotalTax: Float """Central Blk Mem Room Revenue""" cBlockMembershipRoomRevenue: Float """Central Blk Mem Room Revenue Tax""" cBlockMembershipRoomRevenueTax: Float """Central Blk Mem Total Revenue""" cBlockMembershipTotalRevenue: Float """Central Blk Mem Total Revenue Tax""" cBlockMembershipTotalRevenueTax: Float """Central Company Room Revenue""" cCompanyRoomRevenue: Float """Central Company Room Tax""" cCompanyRoomTax: Float """Central Company Total Revenue""" cCompanyTotalRevenue: Float """Central Company Total Tax""" cCompanyTotalTax: Float """Central Xchange Date""" cExchangeDate: Date """Central Es Adv Food Revenue""" cExtendedStayAdvanceFoodRevenue: Float """Central Es Adv Food Tax""" cExtendedStayAdvanceFoodTax: Float """Central Es Adv Non Revenue""" cExtendedStayAdvanceNonRevenue: Float """Central Es Adv Non Revenue Tax""" cExtendedStayAdvanceNonRevenueTax: Float """Central Es Adv Other Revenue""" cExtendedStayAdvanceOtherRevenue: Float """Central Es Adv Other Tax""" cExtendedStayAdvanceOtherTax: Float """Central Es Adv Room Revenue""" cExtendedStayAdvanceRoomRevenue: Float """Central Es Adv Room Tax""" cExtendedStayAdvanceRoomTax: Float """Central Es Adv Total Revenue""" cExtendedStayAdvanceTotalRevenue: Float """Central Es Adv Total Tax""" cExtendedStayAdvanceTotalTax: Float """Central Es Food Revenue""" cExtendedStayFoodRevenue: Float """Central Es Food Tax""" cExtendedStayFoodTax: Float """Central Es Non Revenue""" cExtendedStayNonRevenue: Float """Central Es Non Revenue Tax""" cExtendedStayNonRevenueTax: Float """Central Es Other Revenue""" cExtendedStayOtherRevenue: Float """Central Es Other Tax""" cExtendedStayOtherTax: Float """Central Es Room Revenue""" cExtendedStayRoomRevenue: Float """Central Es Room Tax""" cExtendedStayRoomTax: Float """Central Es Total Revenue""" cExtendedStayTotalRevenue: Float """Central Es Total Tax""" cExtendedStayTotalTax: Float """Central Ff Food Bev Revenue""" cFfFoodBevRevenue: Float """Central Ff Other Revenue""" cFfOtherRevenue: Float """Central Ff Rent Food Bev Rev""" cFfRentFoodBevRevenue: Float """Central Ff Rent Other Rev""" cFfRentOtherRevenue: Float """Central Ff Rent Room Rev""" cFfRentRoomRevenue: Float """Central Ff Room Revenue""" cFfRoomRevenue: Float """Central Fit Mem Room Revenue""" cFitMembershipRoomRevenue: Float """Central Fit Mem Room Revenue Tax""" cFitMembershipRoomRevenueTax: Float """Central Fit Mem Total Revenue""" cFitMembershipTotalRevenue: Float """Central Fit Mem Total Revenue Tax""" cFitMembershipTotalRevenueTax: Float """Central Flgd Food Revenue""" cFlaggedFoodRevenue: Float """Central Flgd Non Revenue""" cFlaggedNonRevenue: Float """Central Flgd Other Revenue""" cFlaggedOtherRevenue: Float """Central Flgd Payment""" cFlaggedPayment: Float """Central Flgd Room Revenue""" cFlaggedRoomRevenue: Float """Central Flgd Total Food Tax""" cFlaggedTotalFoodTax: Float """Central Flgd Total Non Revenue Tax""" cFlaggedTotalNonRevenueTax: Float """Central Flgd Total Other Tax""" cFlaggedTotalOtherTax: Float """Central Flgd Total Revenue""" cFlaggedTotalRevenue: Float """Central Flgd Total Room Tax""" cFlaggedTotalRoomTax: Float """Central Flgd Total Tax""" cFlaggedTotalTax: Float """Central Owner Food Bev Revenue""" cOwnerFoodBevRevenue: Float """Central Owner Other Revenue""" cOwnerOtherRevenue: Float """Central Owner Rent Food Bev Rev""" cOwnerRentFoodBevRevenue: Float """Central Owner Rent Other Rev""" cOwnerRentOtherRevenue: Float """Central Owner Rent Room Rev""" cOwnerRentRoomRevenue: Float """Central Owner Room Revenue""" cOwnerRoomRevenue: Float """Central Payment""" cPayment: Float """Central Repeat Room Revenue""" cRepeatRoomRevenue: Float """Central Repeat Room Tax""" cRepeatRoomTax: Float """Central Repeat Total Revenue""" cRepeatTotalRevenue: Float """Central Repeat Total Tax""" cRepeatTotalTax: Float """Number of cancelled reservations with an arrival date today.""" cancelReservation: Float """Number of cancelled rooms with an arrival date today.""" cancelRooms: Float """Number of Cancellations that were taken today for any date""" cancellationsMadeToday: Float """Central Average Daily Rate (minus Complimentary and House Use)""" centralAverageDailyRateMinusComplimentaryHouseUse: Float """Central Average Daily Revenue""" centralAverageDailyRevenue: Float """Central Currency Code""" centralCurrencyCode: String """Central Exchange Rate""" centralExchangeRate: Float """Central FB Revenue""" centralFBRevenue: Float """Central FB Tax""" centralFBTax: Float """Central Group Revenue""" centralGroupRevenue: Float """Central Group Room Revenue""" centralGroupRoomRevenue: Float """Central Group Room Tax""" centralGroupRoomTax: Float """Central Group Tax""" centralGroupTax: Float """Central Individual Revenue""" centralIndividualRevenue: Float """Central Individual Room Revenue""" centralIndividualRoomRevenue: Float """Central Membership Revenue""" centralMembershipRevenue: Float """Central Membership Total Tax""" centralMembershipTotalTax: Float """Central Other Revenue""" centralOtherRevenue: Float """Central Other Tax""" centralOtherTax: Float """Central Rack Rate Total for All Rooms""" centralRackRateTotalForAllRooms: Float """Central Rack Rate Total for Occupied Rooms""" centralRackRateTotalForOccupiedRooms: Float """Central Room Revenue""" centralRoomRevenue: Float """Central Room Tax""" centralRoomTax: Float """Central Total Revenue""" centralTotalRevenue: Float """Central Total Tax""" centralTotalTax: Float """Central Yield for All Rooms""" centralYieldForAllRooms: Float """Central Yield for Occupied Rooms""" centralYieldForOccupiedRooms: Float """Centralcurrencyid""" centralcurrencyid: String """Not Used""" childrenFree: Float """Children in House.""" childrenInHouse: Float """Children1""" children1: Float """Children2""" children2: Float """Children3""" children3: Float """Children4""" children4: Float """Children5""" children5: Float """Number of clean rooms""" cleanRooms: Float """Total adults of reservations with a rate code marked as complimentary""" compAdults: Float """Total beds in rooms that have a rate code marked as comp""" compBeds: Float """Total children of reservations with a rate code marked as complimentary""" compChildren: Float """Total number of rooms reserved having a rate code marked as comp starting tomorrow for 31 days.""" compNext31Days: Float """Total number of rooms reserved having a rate code marked as comp starting tomorrow for 365 days.""" compNext365Days: Float """Total number of rooms reserved having a rate code marked as comp starting tomorrow for the remainder of the current calendar month.""" compRestOfMonth: Float """Total number of rooms reserved having a rate code marked as comp starting tomorrow for the remainder of the current calendar year.""" compRestOfYear: Float """Total number of rooms reserved having a rate code marked as comp for tomorrow.""" compTomorrow: Float """Total number of rooms reserved having a rate code marked as comp starting tomorrow for 7 days.""" compWeek: Float """Total amount of postings today where the transaction code is marked as room revenue for reservations that have a company profile attached to the reservation.""" companyRoomRevenue: Float """Total tax amount of postings today where the transaction code is marked as room revenue for reservations that have a company profile attached to the reservation.""" companyRoomTax: Float """Number of rooms that have a company profile attached to the reservation""" companyRooms: Float """Total amount of postings today where the transaction code is marked as revenue for reservations that have a company profile attached to the reservation.""" companyTotalRevenue: Float """Total tax amount of postings today where the transaction code is marked as revenue for reservations that have a company profile attached to the reservation.""" companyTotalTax: Float """Number of rooms that have a rate code marked as comp""" complimentaryRooms: Float """Context Cd""" contextCd: String """Not Used""" cribs: Float """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Day Use Reservations""" dayUseReservations: Float """Number of reservations where the arrival date and departure date equal today""" dayUseRooms: Float """Total number of adults of day-use reservations.""" dayuseAdults: Float """Total number of children of day-use reservations.""" dayuseChildren: Float """Total number of day-use rooms reserved starting tomorrow for 1 calendar month""" dayuseMonth: Float """Total number of day-use rooms reserved starting tomorrow for 31 days.""" dayuseNext31Days: Float """Total number of day-use rooms reserved starting tomorrow for 365 days.""" dayuseNext365Days: Float """Total number of day-use rooms reserved starting tomorrow for the remainder of the current calendar month.""" dayuseRestOfMonth: Float """Total number of day-use rooms reserved starting tomorrow for the remainder of the current calendar year.""" dayuseRestOfYear: Float """Total number of day-use rooms reserved for tomorrow.""" dayuseTomorrow: Float """Total number of day-use rooms reserved starting tomorrow for 7 days.""" dayuseWeek: Float """Total number of day-use rooms reserved starting tomorrow for 1 calendar year.""" dayuseYear: Float """Number of rooms with an arrival date euqal to today with a reservation type of deduct""" definiteArrivalRooms: Float """Deleted Flag""" deletedFlag: String """Number of persons with a departure date equal to today""" departurePersons: Float """Number of rooms with a departure date equal to today""" departureRooms: Float """Number of rooms with a houskeeping status of DI""" dirtyRooms: Float """Number of rooms where each room has occupancy max greater than 1 and numbe of persons in-house is 1""" doublesAsSingles: Float """Number of persons for checked out rooms with an original departure date greater than today""" earlyDeparturePersons: Float """Number of checked out rooms with an original departure date greater than today""" earlyDepartureRooms: Float """Exchange Rate""" exchangeRate: Float """Number of CRS Reservations Arrival extended to next day due to No Show counting share reservations as one.""" extNoshowCRSRes: Float """Number of Persons Arrival extended to next day due to No Show.""" extNoshowPrs: Float """Number of Reservations Arrival extended to next day due to No Show.""" extNoshowRes: Float """Number of Rooms Arrival extended to next day due to No Show.""" extNoshowRoom: Float """Extended stay distributed food and beverage revenue.""" extendedStayAdvFoodRevenue: Float """Extended stay distributed food and beverage taxes.""" extendedStayAdvFoodTax: Float """Extended stay distributed non-revenue.""" extendedStayAdvNonRevenue: Float """Extended stay distributed non-revenue taxes.""" extendedStayAdvNonRevenueTax: Float """Extended stay distributed other revenue.""" extendedStayAdvOtherRevenue: Float """Extended stay distributed other taxes.""" extendedStayAdvOtherTax: Float """Extended stay distributed room revenue.""" extendedStayAdvRoomRevenue: Float """Extended stay distributed room taxes.""" extendedStayAdvRoomTax: Float """Extended stay distributed total revenue.""" extendedStayAdvTotalRevenue: Float """Extended stay distributed total taxes.""" extendedStayAdvTotalTax: Float """Extended stay complimentary rooms.""" extendedStayCompRooms: Float """Extended stay food and beverage revenue.""" extendedStayFoodRevenue: Float """Extended stay food and beverage taxes.""" extendedStayFoodTax: Float """Extended stay house-use rooms.""" extendedStayHouseUseRooms: Float """Extended stay non-revenue.""" extendedStayNonRevenue: Float """Extended stay non-revenue taxes.""" extendedStayNonRevenueTax: Float """Extended stay occupied rooms.""" extendedStayOccupancyRooms: Float """Extended stay other revenue.""" extendedStayOtherRevenue: Float """Extended stay other taxes.""" extendedStayOtherTax: Float """Number of persons where an original departure date equal to today""" extendedStayPersons: Float """Number of rooms where an original departure date equal to today""" extendedStayRoom: Float """Extended stay room revenue.""" extendedStayRoomRevenue: Float """Extended stay room taxes.""" extendedStayRoomTax: Float """Extended stay total revenue.""" extendedStayTotalRevenue: Float """Extended stay total taxes.""" extendedStayTotalTax: Float """Total amount of all postings today where the Transaction Code is marked as Revenue and the Transaction Type is Food and Beverage .""" fBRevenue: Float """Total tax amount of all postings today where the Transaction Code is marked as Revenue and the Transaction Type is Food and Beverage .""" fBTax: Float """Food and Beverage Revenue generated by Authorized Users who are in rooms that are not part of the Rental Program where the Transaction Code is marked as 'Revenue' and the Transaction Type is 'Food and Beverage'.""" ffFoodBevRevenue: Float """Revenue generated by Authorized Users who are in rooms that are not part of the Rental Program where the transaction Codes are defined as 'other'.""" ffOtherRevenue: Float """Food and Beverage Revenue generated by Authorized Users who are in rooms that are part of the Rental Program where the Transaction Code is marked as 'Revenue' and the Transaction Type is 'Food and Beverage'.""" ffRentFoodBevRev: Float """Revenue generated by Authorized Users who are in rooms that are part of the Rental Program where the transaction Codes are defined as 'other'.""" ffRentOtherRev: Float """Lodging Revenue generated by Authorized Users who are in rooms that are part of the Rental Program. (Revenue defined as lodging)""" ffRentRoomRev: Float """Authorized Users who are in rooms that are part of the Rental Program.""" ffRentRooms: Float """Lodging Revenue generated by Authorized Users who are in rooms that are not part of the Rental Program. (Revenue defined as lodging)""" ffRoomRevenue: Float """Authorized Users who are in rooms that are not part of the Rental Program.""" ffRooms: Float """Number of nights for all reservations that are considered for Rooms Occupied a membership number of the default membership type attached to the reserveration with no block code attached to the reservation. If no default membership type is defined then any membership attached to the reservation will be considered. Used for Calculation of Average Length of Stay.""" fitMemLosNights: Float """Total amount of all postings today where the transaction code is marked as Revenue and the transaction type is Lodging a membership number of the default membership type attached to the reserveration with no block code attached to the reservation. If no default membership type is defined then any membership attached to the reservation will be considered.""" fitMemRoomRevenue: Float """Total tax amount of all postings today where the transaction code is marked as Revenue and the transaction type is Lodging a membership number of the default membership type attached to the reserveration with no block code attached to the reservation. If no default membership type is defined then any membership attached to the reservation will be considered.""" fitMemRoomRevenueTax: Float """Number of rooms with a membership number of the default membership type attached to the reserveration with no block code attached to the reservation. If no default membership type is defined then any membership attached to the reservation will be considered.""" fitMemRooms: Float """Total amount of all postings today where the transaction code is marked as Revenue a membership number of the default membership type attached to the reserveration with no block code attached to the reservation. If no default membership type is defined then any membership attached to the reservation will be considered.""" fitMemTotalRevenue: Float """Total tax amount of all postings today where the transaction code is marked as Revenue a membership number of the default membership type attached to the reserveration with no block code attached to the reservation. If no default membership type is defined then any membership attached to the reservation will be considered.""" fitMemTotalRevenueTax: Float """Counts all reservations that are considered for Rooms Occupied a membership number of the default membership type attached to the reserveration with no block code attached to the reservation. If no default membership type is defined then any membership attached to the reservation will be considered. Used for Calculation of Average Length of Stay.""" fitMembershipLosResv: Float """Flagged Food Revenue""" flgdFoodRevenue: Float """Flagged Non Revenue""" flgdNonRevenue: Float """Flagged Other Revenue""" flgdOtherRevenue: Float """Flagged Total Payments.""" flgdPayment: Float """Flagged Room Revenue""" flgdRoomRevenue: Float """Flagged Total Food Tax""" flgdTotalFoodTax: Float """Flagged Total Non Revenue Tax""" flgdTotalNonRevenueTax: Float """Flagged Total Other Tax""" flgdTotalOtherTax: Float """Flagged Total Revenue""" flgdTotalRevenue: Float """Flagged Total Room Tax""" flgdTotalRoomTax: Float """Flagged Total Tax""" flgdTotalTax: Float """Number of Adults and Children for Rooms In-House with a Block code attached to the reservation""" groupPrs: Float """Total amount of postings today where the Transaction Code is marked as Revenue for reservations that have a Block Code attached""" groupRevenue: Float """Number of Rooms that have a block code attached to the reservation.""" groupRoom: Float """Total amount of postings today where the Transaction Code is marked as Revenue and a Transaction Code Type is Lodging for reservations that have a Block Code attached""" groupRoomRevenue: Float """Total tax amount of postings today where the Transaction Code is marked as Revenue and a Transaction Code Type is Lodging for reservations that have a Block Code attached""" groupRoomTax: Float """Number of Rooms that have a Group profile attached to the reservation.""" groupRooms: Float """Total tax amount of postings today where the Transaction Code is marked as Revenue for reservations that have a Block Code attached""" groupTax: Float """Number of Adults and Children for Rooms In-House""" guestsInHouse: Float """Total adults of reservations with a rate code marked as house use""" houseUseAdults: Float """Total beds in rooms that have a rate code marked as house use""" houseUseBeds: Float """Total children of reservations with a rate code marked as house use""" houseUseChildren: Float """Total number of rooms reserved having a rate code marked as house-use starting tomorrow for 31 days.""" houseUseNext31Days: Float """Total number of rooms reserved having a rate code marked as house-use starting tomorrow for 365 days.""" houseUseNext365Days: Float """Total number of rooms reserved having a rate code marked as house-use starting tomorrow for the remainder of the current calendar month.""" houseUseRestOfMonth: Float """Total number of rooms reserved having a rate code marked as house-use starting tomorrow for the remainder of the current calendar year.""" houseUseRestOfYear: Float """Total number of rooms reserved having a rate code marked as house-use for tomorrow.""" houseUseTomorrow: Float """Total number of rooms reserved having a rate code marked as house-use starting tomorrow for 7 days.""" houseUseWeek: Float """Number of Rooms In-House that have a rate code marked as House Use""" houseUseRooms: Float """Amount of all MAX_OCCUPANCY columns from all rooms.""" inHouseMaximumOccupancy: Float """Number of persons with a departure date equal to today and no block code attached""" individualDeparturePersons: Float """Number of Rooms with a Departure Date equal to today and no block code attached to the reservation.""" individualDepartureRooms: Float """Number of Adults and Children for Rooms In-House with no Block code attached to the reservation""" individualGuests: Float """Number of Adults and Children with a Departure Date equal to today a membership number of the default membership type attached to the reserveration with no block code attached to the reservation. If no default membership type is defined then any membership attached to the reservation will be considered.""" individualMembershipDeparturePersons: Float """Number of Rooms with a Departure Date equal to today a membership number of the default membership type attached to the reserveration with no block code attached to the reservation. If no default membership type is defined then any membership attached to the reservation will be considered.""" individualMembershipDepartureRooms: Float """Total amount of postings today where the Transaction Code is marked as Revenue for reservations that do not have a Block Code attached""" individualRevenue: Float """Total amount of postings today where the Transaction Code is marked as Revenue and a Transaction Code Type is Lodging for reservations that do not have a Block Code attached""" individualRoomRevenue: Float """Number of Rooms that do not have a block code attached to the reservation.""" individualRooms: Float """Number of Rooms that have a Housekeeping Status of IP""" inspectedRooms: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Number of Reservations that were cancelled today with an arrival date equal to today.""" lateCancelReservation: Float """Number of rooms that were cancelled today with an arrival date equal to today.""" lateCancelRooms: Float """Internal ID to uniquely identify the Property""" locationID: String """Number of Adults and Children with a Departure Date equal to today and a membership number of the default membership type attached to the reservation. If no default membership type is defined then any membership attached to the reservation will be considered.""" membershipDeparturePersons: Float """Number of Rooms with a Departure Date equal to today and a membership number of the default membership type attached to the reservation. If no default membership type is defined then any membership attached to the reservation will be considered.""" membershipDepartureRooms: Float """Number of Adults and Children for Rooms In-House with a membership number of the default membership type attached to the reservation. If no default membership type is defined then any membership attached to the reservation will be considered.""" membershipInHousePersons: Float """Total amount of postings today where the Transaction Code is marked as Revenue for reservations that have a membership number of the default membership type attached to the reservation. If no default membership type is defined then any membership attached to the reservation will be considered.""" membershipRevenue: Float """Total tax amount of postings today where the Transaction Code is marked as Revenue for reservations that have a membership number of the default membership type attached to the reservation. If no default membership type is defined then any membership attached to the reservation will be considered.""" membershipTotalTax: Float """All rooms with guests greater than 1""" multipleOccupancyRooms: Float """Number of Adults and Children with a Reservation Status of No Show""" noShowPersons: Float """Number of Rooms with a Reservation Status of No Show""" noShowRooms: Float """Number of arrivals with a previous status of non-deduct prior to check-in.""" nonDeductibleArrivals: Float """Number of noshow reservations with an arrival date of today.""" noshowReservations: Float """Number of Blocks where todays date falls between the start date and end date""" numberOfGroup: Float """Occupancy""" occupancy: Float """Total beds in occupied rooms""" occupancyBeds: Float """Total number of rooms reserved starting tomorrow for 31 days.""" occupancyNext31Days: Float """Total number of rooms reserved starting tomorrow for 365 days.""" occupancyNext365Days: Float """Total number of rooms reserved starting tomorrow for the remainder of the current calendar month.""" occupancyRestOfMonth: Float """Total number of rooms reserved starting tomorrow for the remainder of the current calendar year.""" occupancyRestOfYear: Float """Number of rooms In-House with a Front Office status of OCC""" occupiedRooms: Float """Total number of rooms reserved starting tomorrow for 1 calendar month.""" occupiedRoomsMonth: Float """Number of Rooms Occupied tomorrow divided by Total Rooms in Hotel multiplied by 100""" occupiedRoomsTomorrow: Float """Total number of rooms reserved starting tomorrow for 7 days.""" occupiedRoomsWeek: Float """Total number of rooms reserved starting tomorrow for 1 calendar year.""" occupiedRoomsYear: Float """Total beds in rooms marked as out of order for today""" oooBeds: Float """Total number of rooms marked as Out of Order starting tomorrow for 31 days.""" oooRoomsNext31Days: Float """Total number of rooms marked as Out of Order starting tomorrow for 365 days.""" oooRoomsNext365Days: Float """Total number of rooms marked as Out of Order starting tomorrow for the remainder of the current calendar month.""" oooRoomsRestOfMonth: Float """Total number of rooms marked as Out of Order starting tomorrow for the remainder of the current calendar year.""" oooRoomsRestOfYear: Float """Total number of rooms marked as Out of Order for tomorrow.""" oooRoomsTomorrow: Float """Total number of rooms marked as Out of Order starting tomorrow for 7 days.""" oooRoomsWeek: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Total beds in rooms marked as out of service for today""" osBeds: Float """Total number of rooms marked as Out of Service starting tomorrow for 31 days.""" osRoomsNext31Days: Float """Total number of rooms marked as Out of Service starting tomorrow for 365 days.""" osRoomsNext365Days: Float """Total number of rooms marked as Out of Service starting tomorrow for the remainder of the current calendar month.""" osRoomsRestOfMonth: Float """Total number of rooms marked as Out of Service starting tomorrow for the remainder of the current calendar year.""" osRoomsRestOfYear: Float """Total number of rooms marked as Out of Service for tomorrow.""" osRoomsTomorrow: Float """Total number of rooms marked as Out of Service starting tomorrow for 7 days.""" osRoomsWeek: Float """Other Revenue""" otherRevenue: Float """Total tax amount of all postings today where the Transaction Code is marked as Revenue and the Transaction Code Type is not Lodging Food and Beverage Tax or Non Hotel Supplies""" otherTax: Float """Number of Rooms marked as Out of Order for today""" outOfOrderRooms: Float """Out of Service Rooms""" outOfServiceRooms: Float """Food and Beverage Revenue generated by an owner who is not in the Rental Program where the transaction code is marked as 'Revenue' and the Transaction Type is 'Food and Beverage'.""" ownerFoodBevRevenue: Float """Other Revenue generated by an owner who is not in the Rental Program where the transaction codes are defined as 'other'.""" ownerOtherRevenue: Float """Food and Beverage Revenue generated by an owner who is in the Rental Program where the transaction code is marked as 'Revenue' and the Transaction Type is 'Food and Beverage'.""" ownerRentFoodBevRev: Float """Other Revenue generated by an owner who is in the Rental Program where the transaction codes are defined as 'other'.""" ownerRentOtherRev: Float """Lodging Revenue generated by owners who are in the Rental Program. (Revenue defined as lodging)""" ownerRentRoomRev: Float """Owners who are in rooms that are part of the Rental Program.""" ownerRentRooms: Float """Rooms that are part of the Rental Program that are out of order.""" ownerRentRoomsOoo: Float """Lodging Revenue generated by owners who are not in the Rental Program. (Revenue defined as lodging)""" ownerRoomRevenue: Float """Owners who are in rooms that are not part of the Rental Program.""" ownerRooms: Float """Number of Rooms in Hotel that are linked to an active OVOS contract.""" ownerRoomsInHotel: Float """Rooms that are not part of the Rental Program that are out of order.""" ownerRoomsOoo: Float """Total amount of postings today that have a Transaction Code linked to a Group of Payment""" payment: Float """Pc Occupancy 1""" pcOccupancy1: Float """Pc Occupancy 2""" pcOccupancy2: Float """Rooms Occupied divided by Total Rooms in Hotel multiplied by 100""" perOccupancy: Float """Rooms Occupied minus Comp & House divided by Total Rooms in Hotel multiplied by 100""" perOccupancyWoCompHouse: Float """Rooms Occupied minus Comp House and Out of Order divided by Total Rooms in Hotel multiplied by 100""" perOccupancyWoCompHouseOo: Float """Total beds of all rooms in the property""" physicalBeds: Float """Rooms in the Hotel""" physicalRooms: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Code to uniquely identify the Property""" property: String """Amount of Brochure Rate on each room""" rackRateTotalForAllRooms: Float """Amount of Brochure Rate on each room with a Front Office status of OCC""" rackRateTotalForOccupiedRooms: Float """Reporting Room Class""" repRoomClass: String """Reporting Room Class Description""" repRoomClassDescription: String """Number of persons in-house that are repeating guests""" repeatPersons: Float """Total amount of postings today where the transaction code is marked as room revenue for reservations made by a repeating guest.""" repeatRoomRevenue: Float """Total tax amount of postings today where the transaction code is marked as room revenue for reservations made by a repeating guest.""" repeatRoomTax: Float """Number of rooms occupied by a repeating guest""" repeatRooms: Float """Total amount of postings today where the transaction code is marked as revenue for reservations made by a repeating guest.""" repeatTotalRevenue: Float """Total tax amount of postings today where the transaction code is marked as revenue for reservations made by a repeating guest.""" repeatTotalTax: Float """Number of Reservations that were created today for any date.""" reservation: Float """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Not Used""" rollaways: Float """Room Class""" roomClass: String """Room Class Description""" roomClassDescription: String """Total number of nights from all Reservations Made Today""" roomNightsReservedToday: Float """Room Revenue""" roomRevenue: Float """Room Tax""" roomTax: Float """Roomclassdailytotalid""" roomclassdailytotalid: String """Roomclassid""" roomclassid: String """Number of rooms that were cancelled today for any date.""" roomsCancelledToday: Float """All rooms with total of 1 guest""" singleOccupancyRooms: Float """Number of Rooms that have a Source profile attached to the reservation.""" sourceRooms: Float """Number of Adults and Children with an Arrival Date equal to tomorrow""" tomorrowArrivalPersons: Float """Number of Rooms with an Arrival Date equal to tomorrow""" tomorrowArrivalRooms: Float """Number of Adults and Children with a Departure Date equal to tomorrow""" tomorrowDeparturePersons: Float """Number of Rooms with a Departure Date equal to tomorrow""" tomorrowDepartureRooms: Float """Total Revenue""" totalRevenue: Float """Total Tax""" totalTax: Float """Number of Turnaways recorded today for any date.""" turnaway: Float """Number of Adults and Children for Rooms In-House with a VIP code attached to the profile.""" vIPGuest: Float """Number of Adults and Children where the Walk-In button was used to make the reservation.""" walkInPersons: Float """Number of Rooms where the Walk-In button was used to make the reservation.""" walkInRooms: Float """Amount of Room Revenue divided by Brochure Rate on each room multiplied by 100""" yieldForAllRooms: Float """Amount of Room Revenue divided by Brochure Rate on each room listed as a Front Office status of OCC multiplied by 100""" yieldForOccupiedRooms: Float } type StatisticsManagersReportGregerianCalendarDetailsType { """Business Date""" businessDate: Date """Calendar""" calendar: String """Calendar Description""" calendarDescription: String """Calendarpkid""" calendarpkid: Float """Calendartype""" calendartype: String """Daydesc""" daydesc: String """Dayenddate""" dayenddate: Date """Daytimespan""" daytimespan: Float """Default Calendar Y/N""" defaultCalendarYn: String """Month Description""" monthDescription: String """Period""" period: String """Period End Date""" periodEndDate: Date """Period Start Date""" periodStartDate: Date """Periodpkid""" periodpkid: Float """Periodtimespan""" periodtimespan: Float """Quarter""" quarter: String """Quarter Description""" quarterDescription: String """Quarter End Date""" quarterEndDate: Date """Quarter Start Date""" quarterStartDate: Date """Quarterpkid""" quarterpkid: Float """Quartertimespan""" quartertimespan: Float """Weekcode""" weekcode: String """Weekdesc""" weekdesc: String """Weekenddate""" weekenddate: Date """Weekkey""" weekkey: String """Weekstartdate""" weekstartdate: Date """Weektimespan""" weektimespan: Float """Year""" year: Float """Year Description""" yearDescription: String """Year End Date""" yearEndDate: Date """Year Start Date""" yearStartDate: Date """Yearpkid""" yearpkid: Float """Yeartimespan""" yeartimespan: Float } type StatisticsManagersReportFiscalCalendarDetailsType { """Business Date""" businessDate: Date """Calendar""" calendar: String """Calendar Description""" calendarDescription: String """Calendarpkid""" calendarpkid: Float """Calendartype""" calendartype: String """Daydesc""" daydesc: String """Dayenddate""" dayenddate: Date """Daytimespan""" daytimespan: Float """Default Calendar Y/N""" defaultCalendarYn: String """Month Description""" monthDescription: String """Period""" period: String """Period End Date""" periodEndDate: Date """Period Start Date""" periodStartDate: Date """Periodpkid""" periodpkid: Float """Periodtimespan""" periodtimespan: Float """Quarter""" quarter: String """Quarter Description""" quarterDescription: String """Quarter End Date""" quarterEndDate: Date """Quarter Start Date""" quarterStartDate: Date """Quarterpkid""" quarterpkid: Float """Quartertimespan""" quartertimespan: Float """Weekcode""" weekcode: String """Weekdesc""" weekdesc: String """Weekenddate""" weekenddate: Date """Weekkey""" weekkey: String """Weekstartdate""" weekstartdate: Date """Weektimespan""" weektimespan: Float """Year""" year: Float """Year Description""" yearDescription: String """Year End Date""" yearEndDate: Date """Year Start Date""" yearStartDate: Date """Yearpkid""" yearpkid: Float """Yeartimespan""" yeartimespan: Float } type StatisticsManagersReportRateSeasonDayDetailsType { """Central Season Code""" centralSeasonCode: String """Central Season Description""" centralSeasonDescription: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Day Key""" dayKey: Date """Row deleted YN (if set to 'Y' then the row joined by SEQ from postal_codes will not be displayed).""" deletedYn: String """Display Color""" displayColor: String """End Date""" endDate: Date """Inactive Date""" inactiveDate: DateTime """Inactive Y/N""" inactiveYn: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Code to uniquely identify the Property""" property: String """Rate Code""" rateCode: String """Ratecodeid""" ratecodeid: String """Rateseasonid""" rateseasonid: String """Reporting Item""" repItem: String """Reporting Item Name""" repItemName: String """Reporting Item Orderby""" repItemOrderby: Float """Reporting Updatedate""" repUpdateDate: DateTime """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Season Code""" seasonCode: String """Season Description""" seasonDescription: String """Start Date""" startDate: Date """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type StatisticsManagersReportForeignCurrencyDetailsType { """Abbreviation""" abbreviation: String """Active YN""" activeYN: String """Can Delete Y/N""" canDeleteYn: String """Chain Code""" chainCode: String """Curr Action ID""" currencyActionId: Float """Currency Code""" currencyCode: String """Currency Description""" currencyDescription: String """Currency Symbol like $ or EURO symbol""" currencySymbol: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Decimals""" decimals: Float """Deleted Flag""" deletedFlag: String """Foreign Currency ID""" foreignCurrencyID: String """Format Mask""" formatMask: String """Inactive Date""" inactiveDate: DateTime """Inactive Flag""" inactiveflag: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Deleted Flag""" internalDeletedflag: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Indicates if this Currency Exchange Rate is available for consumer mobility.""" mobileYn: String """Multiply""" multiply: Float """Order By""" orderBy: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """This will be significant after EURO conversion. The currency before the Euro conversion gets a value Y.""" previousLocalCurrencyYn: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Indicates whether this currency code can be sold though currency exchange.""" sellCurrency: String """Indicates whether the currency is Euro participant.""" trianMethodYn: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float """Indicates if this currency can be used for Credit Card payments.""" usedForCcPaymentsYn: String } type StatisticsManagersReportRoomClassDetailsType { """Can Delete Y/N""" canDeleteYn: String """Central Room Class""" centralRoomClass: String """Central Room Class Description""" centralRoomClassDescription: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedflag: String """Inactive Date""" inactiveDate: DateTime """Inactive Flag""" inactiveflag: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Code to uniquely identify the Property""" property: String """Reporting Item""" repItem: String """Reporting Item Name""" repItemName: String """Reporting Item Orderby""" repItemOrderby: Float """Reporting Sell Sequence""" repSellSequence: Float """Reporting Updatedate""" repUpdateDate: DateTime """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Room Class""" roomClass: String """Room Class Description""" roomClassDescription: String """Roomclassid""" roomclassid: String """Sell Sequence""" sellSequence: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type StatisticsManagersReportPropertyPropertyDetailsType { """The property that the record belongs to""" property: String """Number format of AR account no.""" aRAccountNoFormat: String """Specifies if the AR acct No is mandatory(Y/N)""" aRAccountNumberMandatoryYN: String """Default Account Type for an Agent for the Property""" aRAgent: String """Internal""" aRBalanceTrxCode: String """Default Account Type for a Company for the Property""" aRCompany: String """Internal""" aRCreditTrxCode: String """Default Account Type for a Group for the Property""" aRGroups: String """Default Account Type for Individual for the Property""" aRIndividuals: String """Internal""" aRSettleCode: String """Internal""" aRTypewriter: String """Access Code""" accessCode: String """Number of handicapped rooms.""" accessibleRooms: Float """Aging bucket 1""" agingLevel1: Float """Aging bucket 2""" agingLevel2: Float """Aging bucket 3""" agingLevel3: Float """Aging bucket 4""" agingLevel4: Float """Aging bucket 3""" agingLevel5: Float """The Airport Code for the airport near the property""" airport: String """Distance of the Airport specified in the AIRPORT_CODE column from the Property""" airportDistance: String """Time it takes to travel the distance between the Property and the Airport specified in AIRPORT_CODE column""" airportTime: String """Allow loggin in to this resort(Y/N)""" allowLoginYN: String """Period for the allowance""" allowancePeriodAdj: String """Internal""" awardsTimeout: Float """Ball Room Area""" ballroomArea: String """No of Ballroom Seats""" ballroomSeats: Float """The base language of the Hotel""" baseLanguage: String """It contains the reservation type to be used when making group block""" block: String """Brand Code of the property.""" brandCode: String """Financial Year of the Property""" budgetMonth: Float """The date this resort becomes valid for use by the system""" businessDate: Date """Value for the parameter.""" businessID: String """Value for the parameter.""" businessRegistrationCode: String """Code for the CRO""" cROCODE: String """Internal""" cashShiftDrop: String """Catering Currency Code used when Catering Currency differs from base currency.""" cateringCurrencyCode: String """Catering currency format.""" cateringCurrencyFormat: String """Central Exchange Date""" centralXchangeDate: Date """Central Exchange Rate""" centralXchangeRate: Float """Central Credit Limit""" centralCreditLimit: Float """Central Currency Code""" centralCurrencyCode: String """Central Currency Description""" centralCurrencyDescription: String """Central Double Rate2""" centralDblRate2: Float """Central Double Rate1""" centralDblRate1: Float """Central Passerby Market""" centralPasserbyMarket: String """Central Passerby Source""" centralPasserbySource: String """Central Property Type""" centralPropertyType: String """Central Sgl Rate1""" centralSglRate1: Float """Central Sgl Rate 2""" centralSglRate2: Float """Central State""" centralState: String """Central State Description""" centralStateDescription: String """Central Sui Rate1""" centralSuiRate1: Float """Central Sui Rate 2""" centralSuiRate2: Float """Central Tpl Rate1""" centralTplRate1: Float """Central Tpl Rate 2""" centralTplRate2: Float """Central Warning Amount""" centralWarningAmount: Float """Chain Code for the chain to which the property belongs""" chainCode: String """The description of this chain.""" chainDescription: String """Chain Mode""" chainMode: String """Internal""" checkExgPaidout: String """The Hotel official check out time""" checkOutTime: DateTime """Internal""" checkShiftDrop: String """Internal""" checkTrxcode: String """The Hotel official check intime""" checkInTime: DateTime """The physical city in which this property resides.""" city: String """City Description""" cityDescription: String """Internal""" comAddress: String """Internal""" comMethod: String """Internal""" comNameXrefId: Float """Internal""" companyAddressType: String """Internal""" companyPhoneType: String """Internal""" configurationMode: String """Internal""" confirmRegcardPrinter: String """Number of connecting rooms.""" connectingRooms: Float """The unique name of application user""" contacts: String """Number of copies to be printed""" copies: Float """Country name.""" country: String """The name of the country in which this property resides.""" countryCode: String """Value for the parameter.""" countryMode: String """The default credit limit for guests.""" creditLimit: Float """Currency Code.""" currencyCode: String """Currency Symbol like $ or EURO symbol""" currencyCodeSymbol: String """A description of this currency.""" currencyDescription: String """Format for the local currency.""" currencyFormat: String """Color that of the background""" curtainColor: String """DSI""" dSI: Float """Date the aging should begin""" dateForAging: String """Type of separator to distinguish between DD MM and YYYY""" dateSeparator: String """Number of places for the default currency""" decimalPlaces: Float """Type of decimal separator""" decimalSeparator: String """Number of decimals to designate currency""" decimals: Float """Folio style to be used for all guests""" defaultFolioStyle: Float """Default guest address format.""" defaultGuestAddress: String """Future use""" defaultMembershipType: String """Future use""" defaultPostingRoom: String """Default property address format.""" defaultPropertyAddress: String """Future use""" defaultRateCode: String """Rate code used to default a PCR rate code used in FIT Contracts.""" defaultRatecodePcr: String """Rate code used to default a RACK rate code used for FIT Contracts.""" defaultRatecodeRack: String """Default registration card for the property.""" defaultRegistrationCard: String """The Default reservation type for this property""" defaultReservationType: String """Deleted Flag""" deletedFlag: String """Future use""" depositLedgerTrxCode: String """Destination ID""" destinationId: String """Future use""" dfltPkgTranCode: String """Future use""" dfltTranCodeRateCode: String """Internal""" directions: String """Future use""" dirsales: String """LOGIN into the application is disabled.""" disableLoginYN: String """Number of double rooms.""" doubleRooms: Float """Download Rest YN""" downloadRestYN: String """Pager number for the Manager on duty for the property.""" dutyManagerPager: String """Email id for the property.""" email: String """Future use.""" endDate: Date """Default Exchange posting status for the property""" exchangePostingType: String """Floor number of executive floor.""" executiveFloorNumber: String """Hotel code used for third party exports""" expHotelCode: String """Future use""" extExpFileLocation: String """Future use""" extPropertyCode: String """Indicates that the property uses an external SC system.""" externalSCYN: String """Number of family rooms.""" familyRooms: Float """Fax number formats.""" faxNoFormat: String """The fax phone number""" faxNumber: String """Future use""" fiscalEndDate: Date """Future use""" fiscalPeriodType: String """Future use""" fiscalStartDate: Date """Fiscal Year Begin Month""" fiscalYearBeginMonth: Float """Fiscal Year Begin Year""" fiscalYearBeginYear: Float """Screen Painter flags to indicate whether an item is changable/ movable etc.""" flags: String """Future use""" flowCode: String """Property Free Nights Stay Tier.""" fnsTier: String """Other languages""" folioLanguage1: String """Other languages""" folioLanguage2: String """Other languages""" folioLanguage3: String """Other languages""" folioLanguage4: String """Future use""" genmgr: String """To define an upper limit to the number of rooms for Group""" groupRoomWarning: Float """Future use""" guestLookupTimeout: Float """Number of guest elevators.""" guestRoomElevators: Float """Total of guest rooms floors.""" guestRoomFloors: Float """Future use""" hotelCode: String """Future use""" hotelFC: String """Hotel id""" hotelID: String """Future use""" hotelType: String """Future use""" iMGDirectionID: Float """Future use""" iMGHotelID: Float """Future use""" iMGMapID: Float """Future use""" inactiveDaysForGuestProfile: Float """Inactive Flag""" inactiveFlag: String """Future use""" individualAddressType: String """Future use""" individualPhoneType: String """To define an upper limit to the number of rooms for group""" individualRoomWarning: Float """The date the record was created""" insertDate: DateTime """The user that created the record""" insertUser: Float """Int Tax Included YN""" intTaxIncludedYN: String """Future use""" inventoryYN: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """To calculate the entire availability of the Hotel for future reservations""" keepAvailability: Float """Latitude of the property in decimal""" latitude: Float """Future use""" leadsend: String """The owner who owns this property""" legalOwner: String """The property that the record belongs to""" locationID: String """Long date format for the property.""" longDateFormat: String """The default length of stay""" longStayControl: Float """Longitude of the property in decimal""" longitude: Float """Maximum adults in family rooms.""" maxAdultsInFamilyRoom: Float """Maximum children in family rooms.""" maxChildrenInFamilyRoom: Float """Future use""" maxOccupancy: Float """Maximum number of days that are allowed to credit a bill. (Country requirements.) Used in CASHIERING MODULE.""" maximumCreditDays: Float """Indicates whether the property supports MBS. Used in some file exports.""" mbsSupportedYN: String """Future use""" meetRooms: Float """Future use""" meetSeats: Float """Future use""" meetSpace: Float """Future use""" meetingFC: String """Minimum days for reminder letter.""" minDaysBet2ReminderLetter: Float """Internal""" nameIdLink: Float """Future use""" nightAuditCashierID: String """Number of non smoking rooms.""" nonSmokingRooms: Float """Notes for the property""" noteDetails: String """Total number of beds in this property""" numberOfBeds: Float """Total number of floors in this property""" numberOfFloors: Float """Number of Rooms""" numberOfRooms: Float """Future use""" opusCurrencyCode: String """Organization ID""" organizationID: Float """Organization Internal ID""" organizationInternalID: Float """Future use""" ownership: String """Package Loss code for a particular package""" packageLoss: String """Package Profit code for a particular Package""" packageProfit: String """Parent Org Code""" parentOrgCode: String """Market code""" passerbyMarket: String """Source code""" passerbySource: String """Path""" path: String """Minimim Payment Date for the Property used in Cross Property Postings. This will get updated while running the user defined procedure during the night audit process.""" paymentDate: DateTime """Future use""" perReservationRoomLimit: Float """The direct dial phone number of this property""" phoneNumber: String """The postal code of this property.""" postalCode: String """Primary Key ID""" primaryKeyID: Float """URL where property information is located.""" proinfoUrl: String """Property MAP URL.""" propMapUrl: String """Property picture URL.""" propPicUrl: String """The property that the record belongs to""" propertyCode: String """The name of this property.""" propertyName: String """Type of resort.""" propertyType: String """Future use""" quotedCurrency: String """RNA Insert Date""" rNAInsertdate: DateTime """RNA Update Date""" rNAUpdatedate: DateTime """Minimim last Reconciliation Date for the Property used in Cross Property Postings. This will get updated while running the user defined procedure during the night audit process.""" reconcileDate: DateTime """Future use""" regionCode: String """Description of the Region.""" regionDescription: String """Future use""" restaurant: Float """Total number of Sheets""" rhythmSheets: Float """Total number of Towels""" rhythmTowels: Float """Room amenity.""" roomAmenities: String """Future use""" sGLNum: String """Future use""" sGLRate1: Float """Future use""" sGLRate2: Float """Future use""" sUINum: String """Future use""" sUIRate1: Float """Future use""" sUIRate2: Float """To store number of days before deleting the gest profile""" saveProfiles: Float """Future use""" scriptID: Float """Future use""" season1: String """Future use""" season2: String """Future use""" season3: String """Future use""" season4: String """Future use""" season5: String """Indicates that the property accepts leads as bookings.""" sendLeadAsBooking: String """Shop description.""" shopDescription: String """Short date format for the property.""" shortDateFormat: String """Number of single rooms.""" singleRooms: Float """For default commission percentage""" sourceCommission: String """The state in which this property is located.""" state: String """Description of the state.""" stateDescription: String """The street of the property.""" street: String """Number of suites.""" suites: Float """Internal""" summCurrencyCode: String """For default commission percentage""" tACommission: String """Future use""" tPLNum: String """Future use""" tPLRate1: Float """Future use""" tPLRate2: Float """Formats for telephone number""" telephoneNoFormat: String """Separator for monetory values""" thousandSeparator: String """Default time format for the property.""" timeFormat: String """Time zone region selected by the employee.""" timeZone: String """Toll free telephone number.""" tollFree: String """Future use""" totalRooms: Float """Tourist Number""" touristNumber: String """Indicates whether the property handles multi byte characters and whether they are translateable or not""" translateMulticharYN: String """Turnaway code for the property.""" turnawayCode: String """Number of twin rooms.""" twinRooms: Float """The date the record was modified""" updateDate: DateTime """The user that modified the record""" updateUser: Float """VAT ID of this property.""" vatID: String """Future use""" videoCheckoutPrinter: String """Video check out start time.""" videoCheckoutStart: DateTime """Video check out end time.""" videoCheckoutStop: DateTime """Future use""" wakeUpDelay: Float """Amount at which warning is raised.""" warningAmount: Float """Webaddress of the property""" web: String """Weekend days for the property.""" weekendDays: String """Internal""" zeroInvPurDays: Float }