# title : OPERA Cloud RnA StatisticsForecastSummary GraphQL API, # description : GraphQL API to cater for Future on the books information including rooms, revenue and persons with breakdowns by room types, market code, source code and periods of time. # 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. # - forecastsummaryDetailsConsideredDate # - forecastsummaryDetailsResort input StatisticsForecastSummaryQueryArgumentsType { """DSI Internal Data Source ID to identify Opera Chain and instance""" forecastsummaryDetailsDsi: FloatInput """Event Type""" forecastsummaryDetailsEventType: StringInput """JRN Update Date and Time""" forecastsummaryDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" forecastsummaryDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" forecastsummaryDetailsResort: StringInput! @mandatoryInput """Room Category""" forecastsummaryDetailsRoomCategory: StringInput """Stay Date""" forecastsummaryDetailsConsideredDate: DateInput! @mandatoryInput """Active YN""" parentcompanyprofileDetailsActiveYn: StringInput """The unique identifier of the CRS""" parentcompanyprofileDetailsCrsNameid: FloatInput """Corporate ID""" parentcompanyprofileDetailsNameCode: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" parentcompanyprofileDetailsDsi: FloatInput """Direct Bill Batch Type""" parentcompanyprofileDetailsDirectBillBatchType: StringInput """History YN""" parentcompanyprofileDetailsHistoryYn: StringInput """Inactive Date""" parentcompanyprofileDetailsInactiveDate: DateInput """Index Name""" parentcompanyprofileDetailsIndexName: StringInput """JRN Update Date and Time""" parentcompanyprofileDetailsJrnupdatedttm: DateTimeInput """Last""" parentcompanyprofileDetailsLast: StringInput """Internal ID to uniquely identify the Organization""" parentcompanyprofileDetailsOrganizationid: FloatInput """Resort for which Job is registered.""" parentcompanyprofileDetailsResortRegistered: StringInput """The Uppercase value of Last or PARENTCOMPANYPROFILE.""" parentcompanyprofileDetailsSname: StringInput """Internal Indexed field for Searching by Extended Byte Name.""" parentcompanyprofileDetailsSxname: StringInput """Uppercase value of First Name.""" parentcompanyprofileDetailsSfirst: StringInput """Srep Code""" parentcompanyprofileDetailsSrepCode: StringInput """Internal Indexed field for Searching by Extended Byte First Name.""" parentcompanyprofileDetailsSxfirstName: StringInput """Update Date""" parentcompanyprofileDetailsUpdateDate: DateTimeInput """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 """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 """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 """DSI Internal Data Source ID to identify Opera Chain and instance""" marketDetailsDsi: FloatInput """JRN Update Date and Time""" marketDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" marketDetailsLocationid: StringInput """Market Code""" marketDetailsMarketCode: StringInput """Market group attached to the market code""" marketDetailsParentMarketCode: StringInput """Marketgroupid""" marketDetailsMarketgroupid: StringInput """Marketid""" marketDetailsMarketid: StringInput """Internal ID to uniquely identify the Organization""" marketDetailsOrganizationid: FloatInput """Property""" marketDetailsResort: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" rateclassesDetailsDsi: FloatInput """JRN Update Date and Time""" rateclassesDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" rateclassesDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" rateclassesDetailsResort: StringInput """Rate Class""" rateclassesDetailsRateClass: StringInput """Property code""" rateclassesDetailsResortResort: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" sourcetableDetailsDsi: FloatInput """JRN Update Date and Time""" sourcetableDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" sourcetableDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" sourcetableDetailsOrganizationid: FloatInput """Property""" sourcetableDetailsResort: StringInput """Source Code""" sourcetableDetailsSourceCode: StringInput """Sourceid""" sourcetableDetailsSourceid: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" bookingstatusDetailsDsi: FloatInput """JRN Update Date and Time""" bookingstatusDetailsJrnupdatedttm: DateTimeInput """Old Block Status""" bookingstatusDetailsStatus: StringInput """Internal ID to uniquely identify the Organization""" bookingstatusDetailsOrganizationid: FloatInput """Code""" nationalityDetailsAttributeCode: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" nationalityDetailsDsi: FloatInput """Entity Name""" nationalityDetailsEntityName: StringInput """JRN Update Date and Time""" nationalityDetailsJrnupdatedttm: DateTimeInput """Language Code""" nationalityDetailsLanguageCode: StringInput """Nationalityid""" nationalityDetailsNationalityid: StringInput """Internal ID to uniquely identify the Organization""" nationalityDetailsOrganizationid: FloatInput """Title Suffix""" nationalityDetailsTitleSuffix: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" ratecategoriesDetailsDsi: FloatInput """JRN Update Date and Time""" ratecategoriesDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" ratecategoriesDetailsOrganizationid: FloatInput """Property""" ratecategoriesDetailsResort: StringInput """Rate Category""" ratecategoriesDetailsRateCategory: StringInput """Rate Class""" ratecategoriesDetailsRateClass: StringInput """Base Rate Code""" ratecodeDetailsBaseRateCode: StringInput """Business Date""" ratecodeDetailsBeginBookingDate: DateInput """Central Xchange Date""" ratecodeDetailsCXchangeDate: DateInput """Commission Code""" ratecodeDetailsCommissionCode: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" ratecodeDetailsDsi: FloatInput """Daily Rates Y/N""" ratecodeDetailsDailyRatesYn: StringInput """The rate code on which this rate shedule is dynamically based on.""" ratecodeDetailsDbaseRateCode: StringInput """Display Sequence""" ratecodeDetailsSellSequence: FloatInput """End Date""" ratecodeDetailsEndBookingDate: DateInput """Group Code""" ratecodeDetailsGroupCode: StringInput """JRN Update Date and Time""" ratecodeDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" ratecodeDetailsLocationid: StringInput """Market Code""" ratecodeDetailsMarketCode: StringInput """Maximum Days Advance Booking""" ratecodeDetailsMaxDvanceBooking: FloatInput """Maximum Length of Stay""" ratecodeDetailsMaxLos: FloatInput """Maximum Occupancy""" ratecodeDetailsMaxOccupancy: FloatInput """Minimum Days Advance Booking""" ratecodeDetailsMinAdvanceBooking: FloatInput """Minimum Occupancy""" ratecodeDetailsMinOccupancy: FloatInput """Order By""" ratecodeDetailsOrderBy: FloatInput """Internal ID to uniquely identify the Organization""" ratecodeDetailsOrganizationid: FloatInput """Original Rate Code""" ratecodeDetailsRateCode: StringInput """Indicates the order in which this rate should be displayed during the booking process when the ors_rate_sell_sequence functionality is active.""" ratecodeDetailsOrsSellSequence: FloatInput """Indicates whether the rate code is pending for approval or not""" ratecodeDetailsPendingApprovalYn: StringInput """Code to uniquely identify the Property""" ratecodeDetailsResort: StringInput """Yield rate bucket""" ratecodeDetailsRateBucket: StringInput """Rate Code ID""" ratecodeDetailsRateCodeId: StringInput """Rate Level this rate code belongs to.""" ratecodeDetailsRateLevel: FloatInput """Source Code""" ratecodeDetailsSourceCode: StringInput """Rate transaction code""" ratecodeDetailsTransactionCode: StringInput """Indicates the lengh of Stay Unit in days. If value is > 1 then it is a pkg rate code.""" ratecodeDetailsLosUnit: FloatInput """Central Xchange Date""" roomcategoryDetailsCXchangeDate: DateInput """DSI Internal Data Source ID to identify Opera Chain and instance""" roomcategoryDetailsDsi: FloatInput """JRN Update Date and Time""" roomcategoryDetailsJrnupdatedttm: DateTimeInput """Label""" roomcategoryDetailsLabel: StringInput """Internal ID to uniquely identify the Property""" roomcategoryDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" roomcategoryDetailsOrganizationid: FloatInput """Product Class""" roomcategoryDetailsYieldCategory: StringInput """Code to uniquely identify the Property""" roomcategoryDetailsResort: StringInput """Room Type""" roomcategoryDetailsRoomCategory: StringInput """Roomcategoryid""" roomcategoryDetailsRoomcategoryid: StringInput """Roomcategorypmsref""" roomcategoryDetailsRoomcategorypmsref: StringInput """Roomclassid""" roomcategoryDetailsRoomclassid: StringInput """Country Code""" countryDetailsCountryCode: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" countryDetailsDsi: FloatInput """JRN Update Date and Time""" countryDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" countryDetailsOrganizationid: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" channelDetailsDsi: FloatInput """Entity Name""" channelDetailsEntityName: StringInput """JRN Update Date and Time""" channelDetailsJrnupdatedttm: DateTimeInput """Language Code""" channelDetailsLanguageCode: StringInput """Internal ID to uniquely identify the Organization""" channelDetailsOrganizationid: FloatInput """Origin Code""" channelDetailsAttributeCode: StringInput """Title Suffix""" channelDetailsTitleSuffix: FloatInput """Code""" regionDetailsRegionCode: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" regionDetailsDsi: FloatInput """JRN Update Date and Time""" regionDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" regionDetailsOrganizationid: FloatInput """Regionid""" regionDetailsRegionid: StringInput } type Query { """Future on the books information including rooms revenue and persons with breakdowns by room types market code source code and periods of time.""" statisticsForecastSummary(limit: Int offset: Int input: StatisticsForecastSummaryQueryArgumentsType!): [StatisticsForecastSummaryType] } type StatisticsForecastSummaryType { """Forecast Summary Details""" forecastSummaryDetails: StatisticsForecastSummaryForecastSummaryDetailsType """Parent Company Details""" parentCompanyProfileDeatils: StatisticsForecastSummaryParentCompanyProfileDeatilsType """Fiscal Calendar""" fiscalCalendarDetails: StatisticsForecastSummaryFiscalCalendarDetailsType """Gregerian Calendar""" gregerianCalendarDetails: StatisticsForecastSummaryGregerianCalendarDetailsType """Rate Season Daily Details""" rateSeasonDayDetails: StatisticsForecastSummaryRateSeasonDayDetailsType """Foreign Currency Details""" foreignCurrencyDetails: StatisticsForecastSummaryForeignCurrencyDetailsType """Room Class Details""" roomClassDetails: StatisticsForecastSummaryRoomClassDetailsType """Resort Details""" propertyPropertyDetails: StatisticsForecastSummaryPropertyPropertyDetailsType """Market Details""" marketDetails: StatisticsForecastSummaryMarketDetailsType """Rate Classes Details""" rateClassesDetails: StatisticsForecastSummaryRateClassesDetailsType """Source Table Details""" sourceTableDetails: StatisticsForecastSummarySourceTableDetailsType """Booking Status Details""" bookingStatusDetails: StatisticsForecastSummaryBookingStatusDetailsType """Nationality Details""" nationalityDetails: StatisticsForecastSummaryNationalityDetailsType """Rate Categories Details""" rateCategoriesDetails: StatisticsForecastSummaryRateCategoriesDetailsType """Rate Code Details""" rateCodeDetails: StatisticsForecastSummaryRateCodeDetailsType """Room Category Details""" roomCategoryDetails: StatisticsForecastSummaryRoomCategoryDetailsType """Country Details""" countryDetails: StatisticsForecastSummaryCountryDetailsType """Channel Details""" channelDetails: StatisticsForecastSummaryChannelDetailsType """Region Details""" regionDetails: StatisticsForecastSummaryRegionDetailsType statisticsForecastSummaryRecordCount: Int } type StatisticsForecastSummaryForecastSummaryDetailsType { """Adults""" adults: Float """Adults Tax Free""" adultsTaxFree: Float """Agent ID""" agentId: Float """Allotment Header ID""" allotmentHeaderId: Float """Block ID""" allotmentid: Float """Arrival Persons""" arrivalPersons: Float """Arrival Rooms""" arrivalRooms: Float """Block Status""" blockStatus: String """Booked Room Category""" bookedRoomCategory: String """Booking Status""" bookingStatus: String """Bookingstatusid""" bookingstatusid: String """Business Date Created""" businessDateCreated: Date """Central Day Use Net Room Revenue""" cDayUseNetRoomRevenue: Float """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Fc Extra Revenue""" cFCExtraRevenue: Float """Central Fc Food Revenue""" cFCFoodRevenue: Float """Central Fc Food Revenue Tax""" cFCFoodRevenueTax: Float """Central Fc Gross Rate""" cFCGrossRate: Float """Central Fc Net Room Revenue""" cFCNetRoomRevenue: Float """Central Fc Non Revenue""" cFCNonRevenue: Float """Central Fc Non Revenue Tax""" cFCNonRevenueTax: Float """Central Fc Other Revenue""" cFCOtherRevenue: Float """Central Fc Other Revenue Tax""" cFCOtherRevenueTax: Float """Central Fc Room Revenue""" cFCRoomRevenue: Float """Central Fc Room Revenue Tax""" cFCRoomRevenueTax: Float """Central Fc Total Revenue""" cFCTotalRevenue: Float """Central Fc Total Revenue Tax""" cFCTotalRevenueTax: Float """Central Food Revenue Tax""" cFoodRevenueTax: Float """Central Non Revenue Tax""" cNonRevenueTax: Float """Central Other Revenue Tax""" cOtherRevenueTax: Float """Central Room Revenue Tax""" cRoomRevenueTax: Float """Central Total Revenue Tax""" cTotalRevenueTax: Float """Central Currency Code""" centralCurrencyCode: String """Central Day Use Extra Revenue""" centralDayUseExtraRevenue: Float """Central Day Use Gross Rate""" centralDayUseGrossRate: Float """Central Exchange Rate""" centralExchangeRate: Float """Central Extra Revenue""" centralExtraRevenue: Float """Central Food Revenue""" centralFoodRevenue: Float """Central Gross Rate""" centralGrossRate: Float """Central Net Room Revenue""" centralNetRoomRevenue: Float """Central Non Revenue""" centralNonRevenue: Float """Central Other Revenue""" centralOtherRevenue: Float """Central Room Revenue""" centralRoomRevenue: Float """Central Room Type""" centralRoomType: String """Central Total Revenue""" centralTotalRevenue: Float """Central Waitlist Extra Revenue""" centralWaitlistExtraRevenue: Float """Central Waitlist Gross Rate""" centralWaitlistGrossRate: Float """Central Waitlist Net Room Revenue""" centralWaitlistNetRoomRevenue: Float """Centralcurrencyid""" centralcurrencyid: String """Channel""" channel: String """Channelid""" channelid: String """Children""" children: Float """Children Tax Free""" childrenTaxFree: Float """Children1""" children1: Float """Children2""" children2: Float """Children3""" children3: Float """Children4""" children4: Float """Children5""" children5: Float """City""" city: String """Considereddate""" considereddate: Date """Country""" country: String """Countryid""" countryid: String """Cribs""" cribs: Float """Currency Code""" currencyCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Day Use Extra Revenue""" dayUseExtraRevenue: Float """Day Use Gross Rate""" dayUseGrossRate: Float """Day Use Net Room Revenue""" dayUseNetRoomRevenue: Float """Day Use Persons""" dayUsePersons: Float """Day Use Rooms""" dayUseRooms: Float """Day Use Y/N""" dayUseYn: String """Departure Persons""" departurePersons: Float """Departure Rooms""" departureRooms: Float """District""" district: String """Event Type""" eventType: String """Exchange Date""" exchangeDate: Date """Extra Beds""" extraBeds: Float """Extra Revenue""" extraRevenue: Float """FC Extra Revenue""" fcExtraRevenue: Float """FC Food Revenue""" fcFoodRevenue: Float """FC Food Revenue Tax""" fcFoodRevenueTax: Float """FC Gross Rate""" fcGrossRate: Float """FC Net Room Revenue""" fcNetRoomRevenue: Float """FC Non Revenue""" fcNonRevenue: Float """FC Non Revenue Tax""" fcNonRevenueTax: Float """FC Other Revenue""" fcOtherRevenue: Float """FC Other Revenue Tax""" fcOtherRevenueTax: Float """FC Room Revenue""" fcRoomRevenue: Float """FC Room Revenue Tax""" fcRoomRevenueTax: Float """FC Total Revenue""" fcTotalRevenue: Float """FC Total Revenue Tax""" fcTotalRevenueTax: Float """Food Revenue""" foodRevenue: Float """Food Revenue Tax""" foodRevenueTax: Float """Gender""" gender: String """Gross Rate""" grossRate: Float """Group ID""" groupId: Float """ID""" id: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Market Code""" marketCode: String """Marketid""" marketid: String """Multiple Occupancy Rooms""" multipleOccupancyRooms: Float """Nationality""" nationality: String """Nationalityid""" nationalityid: String """Net Room Revenue""" netRoomRevenue: Float """Non Revenue""" nonRevenue: Float """Non Revenue Tax""" nonRevenueTax: Float """Number of Guests""" numberOfGuests: Float """Number of Rooms""" numberOfRooms: Float """Number of Rooms marked as Out of Order for today""" oooRooms: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Os Rooms""" osRooms: Float """Other Revenue""" otherRevenue: Float """Other Revenue Tax""" otherRevenueTax: Float """Owner Ff Flag""" ownerFfFlag: String """Owner Rental Flag""" ownerRentalFlag: String """Parent Company ID""" parentCompanyId: Float """Parentcompanyprofileid""" parentcompanyprofileid: Float """Picked-Up Block Rooms""" pickedUpBlockRooms: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Code to uniquely identify the Property""" property: String """Pseudo Room YN""" pseudoRoomYN: String """Quantity""" quantity: Float """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Rate Category""" rateCategory: String """Rate Class""" rateClass: String """Rate Code""" rateCode: String """Ratecategoryid""" ratecategoryid: String """Rateclassid""" rateclassid: String """Ratecodeid""" ratecodeid: String """Region Code""" regionCode: String """Regionid""" regionid: String """Remaining Block Rooms""" remainingBlockRooms: Float """Reservation Insert Source""" resInsertSource: String """Reservation Inventory Type""" reservationInventoryType: String """Reservation Type""" reservationType: String """Reservation Daily Total ID""" reservationdailytotalid: Float """Reservationid""" reservationid: String """Reservation Status""" resvStatus: String """Room Category""" roomCategory: String """Room Class""" roomClass: String """Room Revenue""" roomRevenue: Float """Room Revenue Tax""" roomRevenueTax: Float """Room Type""" roomType: String """Roomclassid""" roomclassid: String """Single Occupancy Rooms""" singleOccupancyRooms: Float """Source Code""" sourceCode: String """Source Prof ID""" sourceProfId: Float """Sourceid""" sourceid: String """State""" state: String """Stay Date""" stayDate: Date """Total Revenue""" totalRevenue: Float """Total Revenue Tax""" totalRevenueTax: Float """Trunc End Date""" truncEndDate: Date """Trunc Start Date""" truncStartDate: Date """Turndown status of the room per reservation per day. C-Completed NR-Not required R-Requested.""" turndownStatus: String """Update Business Date""" updateBusinessDate: Date """Update Date""" updateDate: DateTime """VIP Status""" vipStatus: String """Waitlist Extra Revenue""" waitlistExtraRevenue: Float """Waitlist Gross Rate""" waitlistGrossRate: Float """Waitlist Net Room Revenue""" waitlistNetRoomRevenue: Float """Waitlist Persons""" waitlistPersons: Float """Waitlist Rooms""" waitlistRooms: Float """Zipcode Code""" zipCode: String } type StatisticsForecastSummaryParentCompanyProfileDeatilsType { """AR Number""" aRNumber: String """AR Number (Central)""" aRNumberCentral: String """Indicates if a Credit Limit amount on Profile level will be required.""" aRCreditLimitYN: String """The ARC mailing flag (received from ARC Update program)""" aRCMailFlag: String """The ARC office type (received from ARC Update program)""" aRCOfficeType: String """The date this record was last updated by the ARC update program.""" aRCUpdateDate: Date """Billing contact person in PARENTCOMPANYPROFILE.""" accountBillingContact: String """Account Source""" accountSource: String """Account Type""" accountType: String """Action Code""" actionCode: String """Active YN""" activeYN: String """Address 1""" address1: String """Address 2""" address2: String """Address 3""" address3: String """Address 4""" address4: String """Country Specific Requirement for Nigeria.""" alienRegistrationNo: String """All Owner Codes""" allOwnerCodes: String """The Extended Byte Language of the Profile.""" alternateLanguage: String """Alternate Middle Name""" alternateMiddleName: String """Alternate Salutation""" alternateSalutation: String """Alternate Title""" alternateTitle: String """Auto Pop Routing""" autoPopRouting: String """Autoenroll Member Y/N""" autoenrollMemberYn: String """Does profile have Availability Override Y/N""" availabilityOverride: String """The billing code for this name record.""" billingCode: String """Billing Instruction""" billingInstruction: String """For tour operators the type of billing profile for this name.""" billingProfileCode: String """Country of birth.""" birthCountry: String """Birth Date""" birthDate: Date """Birth Date Str""" birthDateStr: String """Place of birth.""" birthPlace: String """Bl Msg""" blMsg: String """Business Title""" businessTitle: String """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Profile Credit Limit""" cProfileCreditLimit: Float """The unique identifier of the CRS""" cRSNameid: Float """Cash Bl Individual""" cashBlInd: String """This field tells whether this profile is a credit card profile or not.""" ccProfileYn: String """Central Account Type""" centralAccountType: String """Central Corporate ID Type""" centralCorporateIDType: String """Central Default Keyword""" centralDefaultKeyword: String """Central Nationality""" centralNationality: String """Central Nationality Code""" centralNationalityCode: String """Central Priority""" centralPriority: String """Central State Code""" centralStateCode: String """Central Territory""" centralTerritory: String """Chain Code""" chainCode: String """City""" city: String """The user that has been assigned to this account for collections.""" collectionUserId: Float """Combined Name""" combinedName: String """Commission Code""" commissionCode: String """Communication Type 1""" communicationType1: String """Communication Type 2""" communicationType2: String """Communication Type 3""" communicationType3: String """Communication Value 1""" communicationValue1: String """Communication Value 2""" communicationValue2: String """Communication Value 3""" communicationValue3: String """Competition""" competition: String """Contract Number (used for customers).""" contractNo: String """The date the group contract was received.""" contractRecvDate: Date """Corporate ID""" corporateID: String """Specified whether Name_Code column has PARENTCOMPANYPROFILE # or IATA #. For PARENTCOMPANYPROFILE # the value will beCOMP and for IATA # the Value of this column will be IATA.""" corporateIDType: String """Country""" country: String """Country Code""" countryCode: String """Credit Card Name""" creditCardName: String """Credit Card Type""" creditCardType: String """Credit Rating""" creditRating: String """Currency Code""" currencyCode: String """Currency Description""" currencyDescription: String """Double Opt In for AUTOENROLL_MEMBER_YN""" dOptInAutoenrollMemberFlg: String """Double Opt In for EMAIL_YN""" dOptInEmailFlg: String """Double Opt In for GUEST_PRIV_YN""" dOptInGuestPrivFlg: String """Double Opt In for MAIL_LIST""" dOptInMailListFlg: String """Double Opt In for MARKET_RESEARCH_YN""" dOptInMarketResearchFlg: String """Double Opt In for PHONE_YN""" dOptInPhoneFlg: String """Double Opt In for SMS_YN""" dOptInSmsFlg: String """Double Opt In for THIRD_PARTY_YN""" dOptInThirdPartyFlg: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Default Keyword""" defaultKeyword: String """Deleted Flag""" deletedFlag: String """Department""" department: String """Dept ID""" deptId: String """Direct Bill Batch Type""" directBillBatchType: String """Display Name""" displayName: String """Download Date""" downloadDate: Date """Download Property""" downloadResort: String """Download Srep""" downloadSrep: Float """The date when the E-Invoice liable flag was updated for this profile.""" eInvLiableLastUpdated: Date """Indicates if the payee profile ID is E_INVOICE liable.""" eInvoiceLiableYn: String """Email""" email: String """Email Y/N""" emailYn: String """Envelope Greeting""" envelopeGreeting: String """External ID""" externalId: String """Not Used.""" externalReferenceRequ: String """During the booking process is the user required to enter the tour operator or TA record locator.""" externalReferenceRequired: String """F Membership Card Numbers""" fMembershipCardNumbers: String """F Membership Class Description""" fMembershipClassDesc: String """F Membership Classes""" fMembershipClasses: String """F Membership Codes""" fMembershipCodes: String """F Membership Descriptions""" fMembershipDescriptions: String """F Membership Ids""" fMembershipIds: String """F Subscription Db""" fSubscriptionDb: String """F Subscription Y/N""" fSubscriptionYn: String """Fax Number""" faxNumber: String """First""" first: String """The follow on for this individual (I.E: III etc).""" followOn: String """The name as communicated from the GDS. system. Filled on names that are created during the booking.""" gDSName: String """Not used.""" gDSTransactionNo: String """Gender""" gender: String """Not used.""" geographicRegion: String """Not used.""" guestClassification: String """Guest Priv Y/N""" guestPrivYn: String """History YN""" historyYN: String """Hold Code""" holdCode: String """IATA Consortia""" iataConsortia: String """ID Country""" idCountry: String """ID Date""" idDate: Date """Store the ID value of linked_attachments.attach_id pointing to the physical table column that stores the scanned document.""" idDocumentAttachId: Float """ID Number""" idNumber: String """ID Place""" idPlace: String """ID Type""" idType: String """Country Specific Requirement for Nigeria.""" immigrationStatus: String """Inactive Date""" inactiveDate: Date """Inactive Flag""" inactiveFlag: String """Reason why record was inactivated.""" inactiveReason: String """Include travel agents/sources profile in 1099 reporting ?Y/N""" includeInTax1099Yn: String """Incognito First Name""" incognitoFirstName: String """Incognito Last Name""" incognitoLastName: String """Index Name""" indexName: String """Industry Code""" industryCode: String """Influence""" influence: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: String """Interest Code.""" interest: String """Internal bill that will be solely used for accounting purposes on barter agreements and interim billing amongst hotels which belong to the same owner.""" internalBillYn: String """Deleted Flag""" internalDeletedflag: String """Inactive Flag""" internalInactiveflag: String """Organization ID""" internalOrganizationId: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Language""" language: String """Language Code""" languageCode: String """Laptop Change""" laptopChange: Float """Last""" last: String """Last Group""" lastGroup: String """Last Rate""" lastRate: Float """Not used.""" lastRoom: String """Last Source""" lastSource: String """Last Stay""" lastStay: Date """Last property that updated this record.""" lastUpdatedResort: String """Letter Greeting""" letterGreeting: String """Mail List YN""" mailListYN: String """The type of mail this user should be sent.""" mailType: String """Mail Y/N""" mailYn: String """Market Research Y/N""" marketResearchYn: String """Markets""" markets: String """Is this account a master account (Y/N)?""" masterAccountYn: String """Middle""" middle: String """Name""" name: String """Name 2""" name2: String """Name 3""" name3: String """Not Used.""" nameComment: String """Name Tax Type""" nameTaxType: String """Name With Title""" nameWithTitle: String """Nationality""" nationality: String """Nationality Code""" nationalityCode: String """Negotiated Rate Codes""" negotiatedRateCodes: String """Next Stay""" nextStay: Date """The nickname of this individual.""" nickname: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Stores the original NAME_ID prior to a migration.""" origNameId: Float """Passport""" passport: String """Number of days a payment is due for the account.""" paymentDueDays: Float """Payment Methods Code""" paymentMethodsCode: String """Payment Methods Description""" paymentMethodsDesc: String """Phone no.""" phoneNumber: String """Phone Y/N""" phoneYn: String """Postal Code""" postalCode: String """Preferred Room Number""" preferredRoomNo: String """Not used.""" primaryAddressId: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Not Used.""" primaryNameId: Float """Primary Owner""" primaryOwner: String """Primary Owner Code""" primaryOwnerCode: String """Not used.""" primaryPhoneId: Float """Priority""" priority: String """Profile privacy flag determine if the profile is marked as private for a property.""" privateYN: String """Product Interest""" productInterest: String """Profession of the guest""" profession: String """Profile Arrangement Codes""" profileArrCodes: String """Profile Arr Description""" profileArrangementDesc: String """Credit Limit amount for all AR accounts created in different properties for this profile.""" profileCreditLimit: Float """Profile Type""" profileType: String """Resort for which Job is registered.""" propertyRegistered: String """Protected""" protected: String """Psuedo Profile Y/N""" psuedoProfileYn: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """The default rate structure for this name.""" rateStructure: String """Region""" region: String """Reporting Account Type Description""" repAccountTypeDescription: String """Reporting Accountsource Desc""" repAccountsourceDescription: String """Reporting Competition Desc""" repCompetitionDescription: String """Reporting Corp Type Desc""" repCorpTypeDescription: String """Reporting Inactive Reason""" repInactiveReason: String """Reporting Inactive Reason Code""" repInactiveReasonCode: String """Reporting Industry Desc""" repIndustryDescription: String """Reporting Influence Desc""" repInfluenceDescription: String """Reporting Mail Action Desc""" repMailActionDescription: String """Reporting Markets Desc""" repMarketsDescription: String """Reporting Name Type""" repNameType: String """Reporting Name Type Description""" repNameTypeDescription: String """Reporting Priority Desc""" repPriorityDescription: String """Reporting Rooms Potential Desc""" repRoomsPotentialDescription: String """Reporting Scope City Desc""" repScopeCityDescription: String """Reporting Scope Desc""" repScopeDescription: String """Reporting State Desc""" repStateDescription: String """Reporting Territory Desc""" repTerritoryDescription: String """Reporting Title""" repTitle: String """Reporting Title Name""" repTitleName: String """Reporting Vip Name""" repVIPName: String """Reporting Vip Status""" repVIPStatus: String """The primary membership # for this guest.""" repeatGuestId: String """User option to replace address in ORS with one from PMS.""" replaceAddress: String """Reservation Contact person.""" resvContact: String """Rooms Potential""" roomsPotential: String """Salutation Greeting""" salutation: String """Scope""" scope: String """Scope City""" scopeCity: String """The Uppercase value of Last or PARENTCOMPANYPROFILE.""" searchName: String """Internal Indexed field for Searching by Extended Byte Name.""" searchNameAlternate: String """Uppercase value of First Name.""" sfirst: String """Use this alert to text a notification.""" smsYn: String """The soundex value for this individual record. Used for performance reasons when finding a name based on the sounds.""" soundExLast: String """Srep Code""" srepCode: String """State""" state: String """State Code""" stateCode: String """Suffix""" suffix: String """Summ Ref Cc""" summRefCc: String """Super Search Index Text""" superSearchIndexText: String """Internal Indexed field for Searching by Extended Byte First Name.""" sxfirstName: String """Tax Category""" taxCategory: String """Not used.""" taxExemptStatus: String """Tax ID 1""" taxID1: String """Tax ID 2""" taxID2: String """Tax Office Name""" taxOffice: String """Tax Type""" taxType: String """Territory""" territory: String """Third Party Y/N""" thirdPartyYn: String """Title""" title: String """Title Suffix""" titleSuffix: Float """Total Arrivals""" totalArrivals: Float """Total Arrivals Last Year""" totalArrivalsLastyear: Float """Total Cancelled Reservations""" totalCancelledReservations: Float """Total Cancelled Reservation Lastyear""" totalCancelledResvLastYear: Float """Total Cancelled Rooms""" totalCancelledRooms: Float """Total Cancelled Rooms Last Year""" totalCancelledRoomsLastyear: Float """Total Day Use Reservations""" totalDayUseReservations: Float """Total Day Use Reservation Lastyear""" totalDayUseResvLastYear: Float """Total Day Use Rooms""" totalDayUseRooms: Float """Total Day Use Rooms Last Year""" totalDayUseRoomsLastyear: Float """Total FB Revenue""" totalFbRevenue: Float """Total FB Revenue Lastyear""" totalFbRevenueLastYear: Float """Total Number Show Reservations""" totalNoShowReservations: Float """Total Number Show Rooms""" totalNoShowRooms: Float """Total Non Revenue""" totalNonRevenue: Float """Total Non Revenue Last Year""" totalNonRevenueLastyear: Float """Total No Show Reservation Lastyear""" totalNumberShowResvLastYear: Float """Total No Show Rooms Last Year""" totalNumberShowRoomsLastyear: Float """Total Other Revenue""" totalOtherRevenue: Float """Total Other Revenue Last Year""" totalOtherRevenueLastyear: Float """Total Reservation Nights""" totalReservationNights: Float """Total Reservation Nights Lastyear""" totalResvNightsLastYear: Float """Total Revenue""" totalRevenue: Float """Total Revenue Last Year""" totalRevenueLastyear: Float """Total Room Nights Last Year""" totalRoomNightsLastyear: Float """Total Room Revenue""" totalRoomRevenue: Float """Total Room Revenue Last Year""" totalRoomRevenueLastyear: Float """Sum of total number of stays on stay records for the time period.""" totalStays: Float """Total Stays Last Year""" totalStaysLastyear: Float """The type of tour operator. Only valid for tour operators/wholesalers.""" tourOperatorType: String """Trace Code""" traceCode: String """What type of 1099 is issued to this name.""" typeOfTax1099: String """UDFC01""" uDFC01: String """UDFC02""" uDFC02: String """UDFC03""" uDFC03: String """UDFC04""" uDFC04: String """UDFC05""" uDFC05: String """UDFC06""" uDFC06: String """UDFC07""" uDFC07: String """UDFC08""" uDFC08: String """UDFC09""" uDFC09: String """UDFC10""" uDFC10: String """UDFC11""" uDFC11: String """UDFC12""" uDFC12: String """UDFC13""" uDFC13: String """UDFC14""" uDFC14: String """UDFC15""" uDFC15: String """UDFC16""" uDFC16: String """UDFC17""" uDFC17: String """UDFC18""" uDFC18: String """UDFC19""" uDFC19: String """UDFC20""" uDFC20: String """UDFC21""" uDFC21: String """UDFC22""" uDFC22: String """UDFC23""" uDFC23: String """UDFC24""" uDFC24: String """UDFC25""" uDFC25: String """UDFC26""" uDFC26: String """UDFC27""" uDFC27: String """UDFC28""" uDFC28: String """UDFC29""" uDFC29: String """UDFC30""" uDFC30: String """UDFC31""" uDFC31: String """UDFC32""" uDFC32: String """UDFC33""" uDFC33: String """UDFC34""" uDFC34: String """UDFC35""" uDFC35: String """UDFC36""" uDFC36: String """UDFC37""" uDFC37: String """UDFC38""" uDFC38: String """UDFC39""" uDFC39: String """UDFC40""" uDFC40: String """UDFD01""" uDFD01: Date """UDFD02""" uDFD02: Date """UDFD03""" uDFD03: Date """UDFD04""" uDFD04: Date """UDFD05""" uDFD05: Date """UDFD06""" uDFD06: Date """UDFD07""" uDFD07: Date """UDFD08""" uDFD08: Date """UDFD09""" uDFD09: Date """UDFD10""" uDFD10: Date """UDFD11""" uDFD11: Date """UDFD12""" uDFD12: Date """UDFD13""" uDFD13: Date """UDFD14""" uDFD14: Date """UDFD15""" uDFD15: Date """UDFD16""" uDFD16: Date """UDFD17""" uDFD17: Date """UDFD18""" uDFD18: Date """UDFD19""" uDFD19: Date """UDFD20""" uDFD20: Date """UDFN01""" uDFN01: Float """UDFN02""" uDFN02: Float """UDFN03""" uDFN03: Float """UDFN04""" uDFN04: Float """UDFN05""" uDFN05: Float """UDFN06""" uDFN06: Float """UDFN07""" uDFN07: Float """UDFN08""" uDFN08: Float """UDFN09""" uDFN09: Float """UDFN10""" uDFN10: Float """UDFN11""" uDFN11: Float """UDFN12""" uDFN12: Float """UDFN13""" uDFN13: Float """UDFN14""" uDFN14: Float """UDFN15""" uDFN15: Float """UDFN16""" uDFN16: Float """UDFN17""" uDFN17: Float """UDFN18""" uDFN18: Float """UDFN19""" uDFN19: Float """UDFN20""" uDFN20: Float """UDFN21""" uDFN21: Float """UDFN22""" uDFN22: Float """UDFN23""" uDFN23: Float """UDFN24""" uDFN24: Float """UDFN25""" uDFN25: Float """UDFN26""" uDFN26: Float """UDFN27""" uDFN27: Float """UDFN28""" uDFN28: Float """UDFN29""" uDFN29: Float """UDFN30""" uDFN30: Float """UDFN31""" uDFN31: Float """UDFN32""" uDFN32: Float """UDFN33""" uDFN33: Float """UDFN34""" uDFN34: Float """UDFN35""" uDFN35: Float """UDFN36""" uDFN36: Float """UDFN37""" uDFN37: Float """UDFN38""" uDFN38: Float """UDFN39""" uDFN39: Float """UDFN40""" uDFN40: Float """Update Date""" updateDate: DateTime """The last date this record's fax # was updated.""" updateFaxDate: Date """Update User""" updateUser: String """Upload Date""" uploadDate: Date """Vendor ID""" vendorId: Float """The Oracle Financial vendor site id for this record. Used with the Oracle Financials A/P interface.""" vendorSiteId: Float """Not Used.""" vipAuthorization: String """VIP Name""" vipName: String """VIP Status""" vipStatus: String """Country Specific Requirement for Nigeria.""" visaValidityType: String """Xenvelope Greeting""" xenvelopeGreeting: String """Xfirst Name""" xfirstName: String """Xlast Name""" xlastName: String } type StatisticsForecastSummaryFiscalCalendarDetailsType { """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 StatisticsForecastSummaryGregerianCalendarDetailsType { """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 StatisticsForecastSummaryRateSeasonDayDetailsType { """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 StatisticsForecastSummaryForeignCurrencyDetailsType { """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 StatisticsForecastSummaryRoomClassDetailsType { """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 StatisticsForecastSummaryPropertyPropertyDetailsType { """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 } type StatisticsForecastSummaryMarketDetailsType { """Central Market Code""" centralMarketCode: String """Central Market Description""" centralMarketDescription: String """Central Market Group Code""" centralMarketGroupCode: String """Central Market Group Description""" centralMarketGroupDescription: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Display Color""" displayColor: String """Inactive Date""" inactiveDate: DateTime """Inactive YN""" inactiveYN: 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 """Internal ID to uniquely identify the Property""" locationID: String """Market Code""" marketCode: String """Market Description""" marketDescription: String """Market Display Sequence""" marketDisplaySequence: Float """Market group attached to the market code""" marketGroupCode: String """Market Group Description""" marketGroupDescription: String """Market Group Display Sequence""" marketGroupDisplaySequence: Float """Marketgroupid""" marketgroupid: String """Marketid""" marketid: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Print Group for Nationality Report""" printGroup: String """Property""" property: String """Reporting Item""" repItem: String """Reporting Item Name""" repItemName: String """Reporting Item Orderby""" repItemOrderby: Float """Reporting Market Sell Sequence""" repMarketSellSequence: Float """Reporting Parent Sell Sequence""" repParentSellSequence: Float """Reporting Updatedate""" repUpdateDate: DateTime """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Sc Orderby""" scOrderby: Float """Transaction Code""" trxCode: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type StatisticsForecastSummaryRateClassesDetailsType { """Central Rate Class""" centralRateClass: String """Central Rate Class Description""" centralRateClassDescription: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedflag: String """Display Sequence""" displaySequence: Float """End Date""" endDate: Date """Inactive Date""" inactiveDate: DateTime """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Location ID""" internalLocationId: String """Organization ID""" internalOrganizationId: 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 Class""" rateClass: String """Rate Class Description""" rateClassDescription: String """Rate Class ID""" rateClassId: String """Reporting Item""" repItem: String """Reporting Item Name""" repItemName: String """Reporting Item Orderby""" repItemOrderby: Float """Reporting Sell Sequence""" repSellSequence: Float """Reporting Updatedate""" repUpdateDate: DateTime """Property code""" resortResort: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Start Date""" startDate: Date """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type StatisticsForecastSummarySourceTableDetailsType { """Central Sequence""" centralSequence: Float """Central Source Code""" centralSourceCode: String """Central Source Description""" centralSourceDescription: String """Central Source Group Code""" centralSourceGroupCode: String """Central Source Group Description""" centralSourceGroupDescription: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Row deleted YN (if set to 'Y' then the row joined by SEQ from postal_codes will not be displayed).""" deletedYn: String """Deleted Flag""" deletedflag: String """Inactive Date""" inactiveDate: Date """Inactive YN""" inactiveFlagYN: String """Inactive Y/N""" inactiveYn: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Indicates if the source code is marked to track internet sales.""" internetSalesYn: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Lastuseddatetime""" lastuseddatetime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Parentsourceid""" parentsourceid: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Property""" property: 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 """Sequence""" sequence: Float """Source Code""" sourceCode: String """Source Description""" sourceDescription: String """Source Display Sequence""" sourceDisplaySequence: Float """Source group of the source code""" sourceGroupCode: String """Source Group Description""" sourceGroupDescription: String """Source Group Display Sequence""" sourceGroupDisplaySequence: Float """Sourceid""" sourceid: String """Temp Y/N""" tempYn: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type StatisticsForecastSummaryBookingStatusDetailsType { """Allow Pickup YN""" allowPickupYN: String """Bookingstatusid""" bookingstatusid: String """Catering Status Type""" cateringStatusType: String """Cateringdeductinvflag""" cateringdeductinvflag: String """Central Description""" centralDescription: String """Central Event Status""" centralEventStatus: String """Central Sequence""" centralSequence: Float """Chain Code""" chainCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deductinventoryflag""" deductinventoryflag: String """Default reservation type""" defaultReservationType: String """Deleted Flag""" deletedflag: String """Description""" description: String """Show the booking status in the diary""" diaryYN: String """Display Color""" displayColor: String """Indicates an FIT statuscode.""" fitStatusYn: String """Inactive Flag""" inactiveflag: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Indicates if this Booking Status is an Initial Lead status.""" leadStatusYn: String """Will store the information whether the details_ok_yn flag of allotment_header will be set to Y. This operation is done at trigger level.""" logCateringYn: String """Indicates that the blocks in this status will be considered by ORMS for forecasting.""" oRMSYN: String """Old Block Status""" oldBlockStatus: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Property""" property: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Type of the reason for the booking status""" reasonType: String """Reporting Item""" repItem: String """Reporting Item Name""" repItemName: String """Reporting Item Orderby""" repItemOrderby: Float """Reporting Updatedate""" repUpdateDate: DateTime """Return Inventory YN""" returnInventoryYN: String """Room Status Type""" roomStatusType: String """Sequence""" sequence: Float """Booking starting status (intial pickup)""" startingYN: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type StatisticsForecastSummaryNationalityDetailsType { """Business Title""" businessTitle: String """Can Delete Y/N""" canDeleteYn: String """Central Description""" centralDescription: String """Central Nationality Code""" centralNationalityCode: String """Central Sequence""" centralSequence: Float """Chain Code""" chainCode: String """Code""" code: String """Comments""" comments: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Description""" description: String """Display Color""" displayColor: String """Entity Name""" entityName: String """Contains a list of codes used by a vendor.""" externalAttributeCodes: String """Inactive Date""" inactiveDate: Date """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 """Language Code""" languageCode: String """Internal ID to uniquely identify the Property""" locationID: String """Indicates if the KEYWORD TYPE is to be copied from a Company Master to a Company Subsidiary.""" masterSubKeywordYn: String """Nationalityid""" nationalityid: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Property""" property: String """Ranking""" ranking: Float """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 """Sequence""" sequence: Float """Title Suffix""" titleSuffix: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type StatisticsForecastSummaryRateCategoriesDetailsType { """Business Date""" businessDate: Date """Central Description""" centralDescription: String """Central Rate Category""" centralRateCategory: String """Central Rate Class""" centralRateClass: String """Central Rate Class Description""" centralRateClassDescription: String """Central Sequence""" centralSequence: Float """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedflag: String """Display the rate category Y/N""" displayDefaultYn: String """Display Set""" displaySet: String """End Date""" endDate: Date """Export Bucket Code""" exportBucketCode: String """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 """Property""" property: String """Rate Category""" rateCategory: String """Rate Category Description""" rateCategoryDescription: String """Rate Class""" rateClass: String """Rate Class Description""" rateClassDescription: String """Rate Tier""" rateTier: String """Ratecategoryid""" ratecategoryid: String """Ratetierid""" ratetierid: 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 """Sequence""" sequence: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type StatisticsForecastSummaryRateCodeDetailsType { """Not null value in this column indicates that this is ASB Rate. This column also specifies the cycle of ASB rate. MC=Fixed Calendar Month Cycle WC=Fixed Calendar Week Cycle MF= Floating Monthly Cycle WF=Floating Weekly Cycle.""" aSBRateCycle: String """Amount to be added to the base rate when shown on rate query""" addition: String """With Advanced Base Rate Parameter ON this field stores the rate code on which this rate schedule is dynamically based on.""" advBaseRateCode: String """Indicates how rounding of advanced dynamic rate calculation is performed.[U]p [D]own [N]one [C] -Up - keep decimal [F] -Down - keep decimal.""" advBaseRounding: String """Identifies if during the availability check the calculated based amount should be compared to rate detail of BAR rate code.""" advanceBaseCompareYN: String """Indicates if this rate code is an Advanced Daily Base Rate.""" advanceDailyBaseYN: String """Indicates if this rate code is an Advanced Daily Rate.""" advanceDailyRateYN: String """Alternative rate code if current rate is not available""" alternateRateCode: String """Flag to indicate whether to send Rate code to AVH or not.""" availabilityUpdateYn: String """Back To Back YN""" backToBackYN: String """Base Amount""" baseAmount: Float """Flat or Percentage of the Base Rate""" baseFltPct: String """Base Rate Code""" baseRateCode: String """Indicates if rounding of rate is required""" baseRounding: String """Indicating a rate type such as flat rate or percentage rate. Possible values are: FLAT DIFFERENTIAL and NULL.""" baseType: String """This column use to store Percentage or Amount difference between BAR Rate code and this Rate Code.""" bbarBaseAmount: Float """This flag column identify that amount column represent Flat or Percentage value.""" bbarBaseFltPct: String """This column identify the rounding formula for the BBAR Rate calculation.""" bbarBaseRounding: String """This column will identify that Rate Code is Best BAR based rate code or not. Possible values are Y/N.""" bbarBasedYn: String """Identifies if during the availability check the calculated based amount should be compared to rate detail of BBAR rate code.""" bbarCompareYn: String """Bbar Y/N""" bbarYn: String """Block Name""" blockName: String """PCR: Is breakfast is included in this rate code?""" breakfastInclYn: String """Breakfast Price""" breakfastPrice: Float """Business Date""" businessDate: Date """In case of ORMS when this flag is Y system ignore this rate code from Hurdle Check.""" bypassHurdleYn: String """Indicates that this rate code will not go through rank validations if value is 'Y'.""" bypassRankCheckYn: String """Central Base Amount""" cBaseAmount: Float """Central Bbar Base Amount""" cBbarBaseAmount: Float """Central Bfst Price""" cBreakfastPrice: Float """Central Dbase Amount""" cDbaseAmount: Float """Central Discount Rate Amount""" cDiscountRateAmount: Float """Central Dbl Rm Supplement Price""" cDoubleRoomSupplementPrice: Float """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Rate Floor""" cRateFloor: Float """Central Rate Level""" cRateLevel: Float """Central Rod Base Amount""" cRodBaseAmount: Float """Central Room Assignment Value""" cRoomAssignmentValue: Float """Stores the catering package code linked to this rate code.""" catPackageCode: String """Specifies if a catering package is linked to this rate code.""" cateringPackageYN: String """Central Market Code""" centralMarketCode: String """Central Market Description""" centralMarketDescription: String """Central Market Group Code""" centralMarketGroupCode: String """Central Market Group Description""" centralMarketGroupDescription: String """Central Rate Bucket""" centralRateBucket: String """Central Rate Bucket Description""" centralRateBucketDescription: String """Central Rate Category""" centralRateCategory: String """Central Rate Category Description""" centralRateCategoryDescription: String """Central Rate Class""" centralRateClass: String """Central Rate Class Description""" centralRateClassDescription: String """Central Room Type""" centralRoomType: String """Central Room Type Description""" centralRoomTypeDescription: String """Central Source Code""" centralSourceCode: String """Central Source Description""" centralSourceDescription: String """Central Source Group Code""" centralSourceGroupCode: String """Central Source Group Description""" centralSourceGroupDescription: String """Indicates the state of chaange of the rate code with values null=enabled D=disabled P=changes pending of approval""" changeState: String """This field is used to populate rate code commission percentage for informational purposes for GDS and ORS reservation agents""" commissionPercent: Float """Commission Code""" commissionCode: String """Are commissions allowed for this rate code? Y/N""" commissionYn: String """PCR: Commissionable Percentage.""" commissionablePerc: Float """Commissionable Y/N""" commissionableYn: String """Complimentary YN""" complimentaryYN: String """Introduced for Holidex inbound delta rate processing this column stores the value indicating the decimal position specific to the received the currency code.""" currCodeDecimalPos: Float """Currency Code""" currencyCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Daily Rates Y/N""" dailyRatesYn: String """Day use reservation Y/N.""" dayUseYN: String """Days the rate restriction is not available for arrival""" daysWhenClosedToArrival: String """Indicates either Flat amount or Percentage increase or decrease from the dynamic base rate.""" dbaseAmount: Float """This flag identify that while checking availability calculated based amount should be compared to rate detail of rate code or not.""" dbaseCompareYn: String """Flat or Percentage of the dynamic base rate code.""" dbaseFltPct: String """The rate code on which this rate shedule is dynamically based on.""" dbaseRateCode: String """Indicates if rounding of dynamic rate calculation is required.""" dbaseRounding: String """Stores the double room supplement price.""" dblRoomSupplementPrice: Float """For BAR dependent Rate Code this flag indicates that when all BAR Rates are closed the Rate Amount should be calculated based on the highest BAR Rate Amount instead of based on its own Rate Detail.""" defaultToHighestBarYn: String """Deleted Flag""" deletedFlag: String """Stores the Deposit maturity preference.""" depositMaturityPreference: String """Department code for the transaction.""" deptCode: String """Discount rate amount value.""" discountRateAmount: Float """Indicates if discount rate amount is a percentage value.""" discountRatePercentageYn: String """Discount Flag.""" discountYN: String """Display Sequence""" displaySequence: Float """Display Set""" displaySet: String """Indicates if the profile should be distributed to the external database.""" distributeYn: String """Stores the double room supplement.""" doubleRoomSupplementYN: String """End Date""" endDate: Date """Indicates if the value set for the specific property.""" eventProperty: String """Exchange Type""" exchangeType: String """Externally Controlled YN""" externallyControlledYN: String """Introduced for Holidex inbound delta rate processing this column stores the value indicating at person level the extra charge begins.""" extraPersonChargeBegins: Float """Fit Discount Level.""" fitDiscountLevel: Float """Published Corporate Rate: Discount Percentage.""" fitDiscountPerc: Float """Flat YN""" flatYN: String """Text displayed on the Folio""" folioText: String """Frequent Flyer YN""" frequentFlyerYN: String """Is this rate code available for GDS""" gDSAllowedYN: String """Group Code""" groupCode: String """To highlight on the rate query""" highlightRateAmountYn: String """House-Use YN""" houseUseYN: String """Inactive Date""" inactiveDate: Date """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Location ID""" internalLocationId: String """Organization ID""" internalOrganizationId: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Long Info""" longInfo: String """Flag to indicate if this is a loyalty program""" loyaltyProgramYN: String """Indicates mandatory reservation profiles. This is used to force entry of profiles on the reservation header if this rate is picked.""" mandateResvProfiles: String """Market Code""" marketCode: String """Market Description""" marketDescription: String """Market Group Code""" marketGroupCode: String """Market Group Description""" marketGroupDescription: String """Contains the rate program information from the MARSHA interface.""" marshaRateProgram: String """Maximum Days Advance Booking""" maximumDaysAdvanceBooking: Float """Maximum Length of Stay""" maximumLengthOfStay: Float """Maximum Occupancy""" maximumOccupancy: Float """Flag used to determine if the rate code is to be sent to MyFidelio.net if the rate is being received from a V6 V7 V8 or OPMS on a lower version on which flag used to determine if the rate code is to be sent to MyFidelio.net does not exist on the rate header.""" mfnUploadYn: String """Minimum Days Advance Booking""" minimumDaysAdvanceBooking: Float """Minimum Occupancy""" minimumOccupancy: Float """Mobile Checkin Allowed Y/N""" mobileCheckinAllowedYn: String """Mobile Chkout Allowed""" mobileChkoutAllowed: String """Amount to be multiplied to the base rate when shown on rate query""" multiplication: String """MyFidelio Upload YN""" myFidelioUploadYN: String """Property is negotiated of search criteria or not.""" negotiatedYN: String """Indicates if the rate code is occupancy based.""" occupancyBasedYn: String """Indicates the occupancy level for hurdle evaluation.""" occupancyLevel: Float """The operator type to use during the calculation of base rates. (ADD_TO SUBTRACT)""" operatorType: String """Order By""" orderBy: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Original Rate Code""" originalRateCode: String """Indicates the order in which this rate should be displayed during the booking process when the ors_rate_sell_sequence functionality is active.""" orsSellSequence: Float """Indicates if we need to override package for hurdle evaluation.""" overridePackageYn: String """Indicates Owners Rate Code. This is used to perform rolling noshow.""" ownerRateYN: String """Package Transaction Code""" packageTransactionCode: String """Package Transaction Code Weekend""" packageTransactionCodeWeekend: String """Wrapper transaction code tax inclusive Y/N""" packageTransactionTaxInclYN: String """Transaction code is inclusive of tax Y/N""" packageTransactionTaxIncludedYN: String """Wrapper transaction code tax inclusive for weekend days Y/N""" packageTransactionWkTaxInclYN: String """Package YN""" packageYN: String """Packages""" packages: String """Indicates whether the rate code is pending for approval or not""" pendingApprovalYn: String """Posting Rhythm""" postingRhythm: String """Number of nights for posting rhythm.""" postingRhythmNights: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Print Rate Y/N""" printRateYn: String """Indicates if restriction for rate is privileged or not.""" privilegedRestrictionYn: String """Indicates if rate is privileged or not.""" privilegedYn: String """Profit Transaction Code""" profitTransactionCode: String """Code to uniquely identify the Property""" property: String """Property Name""" propertyName: String """Any number between -10 and +10. This adjustment factor will be applied to the daily ranking value of table RESORT_DAY_TYPE_DATES for the stay date to determine the Rate code rank value.""" rankAdjustmentFactor: Float """Rank Value""" rankValue: Float """Yield rate bucket""" rateBucket: String """Rate Bucket Description""" rateBucketDescription: String """Indicates if rate Calendar factors such as adder/multiplier should be used for price calculation.""" rateCalendarYn: String """Rate Category""" rateCategory: String """Rate Category Description""" rateCategoryDescription: String """Rate Class""" rateClass: String """Rate Class Description""" rateClassDescription: String """Rate Code ID""" rateCodeId: String """Rate Code Locked Y/N""" rateCodeLockedYn: String """Contains the minimum value of the rate amount which can be defined in the rate details.""" rateFloor: Float """This flag indicates if the Rate Floor Rate is overridden for a particular Rate Code.""" rateFloorOverrideYn: String """Does this rate include tax? Y/N""" rateIncludesTaxYn: String """Rate Label""" rateLabel: String """Rate Level this rate code belongs to.""" rateLevel: Float """Needs to send this rate to GDS or not.""" rateUpdateYN: String """Rateinfo Url""" rateinfoUrl: String """Redemption Rate YN""" redemptionRateYN: String """Regional Availability YN""" regionalAvailabilityYN: String """Indicates if the posting rhythm on the rate code is repeated until the end of the stay otherwise the posting rhythm is applied only once.""" repeatPostingRhythmYn: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Rod Base Amount""" rodBaseAmount: Float """Rod Base Flt Pct""" rodBaseFltPct: String """Rod Base Rounding""" rodBaseRounding: String """Is the group code rate of day based""" rodBasedYn: String """Rod Y/N""" rodYn: String """Room Assignment Value""" roomAssignmentValue: Float """Room Type""" roomType: String """Room Type Description""" roomTypeDescription: String """Holds a copy of the column begin_booking_date while the rate code is disabled or with changes pending of approval""" sdowBeginBookingDate: Date """Holds a copy of the column end_booking_date while the rate code is disabled or with changes pending of approval""" sdowEndBookingDate: Date """PCR: Are Service Charges included in this rate code?""" serviceInclYn: String """Service Percentage included.""" servicePerc: Float """Information to be used in the rate query""" shortInfo: String """Flag used to show or hide rate column in Block Grid and used as default by block reservations.""" showRateAmountYn: String """Source Code""" sourceCode: String """Source Description""" sourceDescription: String """Source Group Code""" sourceGroupCode: String """Source Group Description""" sourceGroupDescription: String """Percentage of included Tax.""" taxIncludedPerc: Float """Tax is included in this rate.""" taxIncludedYn: String """Indicates if the rate is a tiered rate.""" tieredYN: String """Rate transaction code""" transactionCode: String """Transaction Code Weekend""" transactionCodeWeekend: String """Transaction code is inclusive of tax for weekend days Y/N""" transactionTaxWeekendIncludedYN: String """Indicates the lengh of Stay Unit in days. If value is > 1 then it is a pkg rate code.""" unitOfLengthOfStay: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float """Indicates if the rate code can be upsold""" upsellYn: String """Flag to indicate if this is a voucher benefit rate code.""" voucherBenefitRateYn: String """Indicates weekend days seperated by '' Eg 17 ie Sun and Sat""" weekendDays: String """Wk Dept Code""" wkDeptCode: String """Yield As""" yieldAs: String """Yieldable YN""" yieldableYN: String """Ym Code""" ymCode: String } type StatisticsForecastSummaryRoomCategoryDetailsType { """Indicates if this room type is accessibility compliant.""" accessibleRoomType: String """The date this record becomes valid for use by the system. User enterable""" activeDate: Date """Activeflag""" activeflag: Date """Auto Checkin Y/N""" autoCheckinYn: String """Include room type in the rate header for Myfidelio rates.""" autoPopulate: String """A setting of Y will automatically assign an available room number to any reservation that is made for this room type.""" autoRoomAssignYn: String """Bed Type""" bedType: String """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Increments""" cIncrements: Float """Central Initial Round Up""" cInitialRoundUp: Float """Central Orms Drtier1""" cORMSDrtier1: Float """Central Orms Drtier2""" cORMSDrtier2: Float """Central Orms Drtier3""" cORMSDrtier3: Float """Central Orms Drxtra 2nd Adult""" cORMSDrxtra2ndAdult: Float """Central Orms Drxtra Adult""" cORMSDrxtraAdult: Float """Central Orms Drxtra Child""" cORMSDrxtraChild: Float """Central Orms Upsell Amt""" cORMSUpsellAmount: Float """Central Rate Amount""" cRateAmount: Float """Central Rate Floor""" cRateFloor: Float """CRS Description""" cRSDescription: String """Can Delete Y/N""" canDeleteYn: String """Central Room Class""" centralRoomClass: String """Central Room Class Description""" centralRoomClassDescription: String """Central Room Type""" centralRoomType: String """Central Room Type Description""" centralRoomTypeDescription: String """Has this room category's long and short description been compiled from the feature list? Y/N""" compiled: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Default occupancy for the room type""" defaultOccupancy: Float """Default rate code to be used to calculate the total revenue.""" defaultRateCode: String """Default Rate Description""" defaultRateDesc: String """Defaultratecodeid""" defaultratecodeid: String """Deleted Flag""" deletedFlag: String """Facility ID for eVisitor.""" evisitorFacilityId: String """Generic YN""" genericYN: String """Room type shows in housekeeping Y/N""" housekeeping: String """Image ID""" imageId: Float """Inactive Date""" inactiveDate: DateTime """Inactive Flag""" inactiveflag: String """Increment value for rates by day by LOS.""" increments: Float """Initial round up value for rates by day by LOS.""" initialRoundUp: Float """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Deleted Flag""" internalDeletedflag: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Label""" label: String """Internal ID to uniquely identify the Property""" locationID: String """Long Description""" longDescription: String """Indicates if rooms of this room type will be available for Room Maintenance functionality.""" maintenance: String """Maximum number of persons that can be accommodated in this room type without providing an extra bed.""" maxFixBedOccupancy: Float """Not used""" maxRollaways: Float """The maximum occupancy of adults for this room category.""" maximumAdults: Float """The maximum occupancy of children for this room category.""" maximumChildren: Float """Maximum Occupancy""" maximumOccupancy: Float """Meeting Room YN""" meetingRoomYN: String """Specifies which membership award room group the room category belongs to.""" memberAwardRoomGrp: String """Minimum Occupancy""" minimumOccupancy: Float """Number of Rooms""" numberOfRooms: Float """Relative amount increase per room category per yield category. Used only in ADF10.""" oRMSUpsellAmt: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """The extra charge on child in age tier1""" ormsDrtier1: Float """The extra charge on child in age tier2""" ormsDrtier2: Float """The extra charge on child in age tier3""" ormsDrtier3: Float """The extra charge on 2nd adult.""" ormsDrxtra2ndAdult: Float """Daily Rate extra adult additional charge for this room type.""" ormsDrxtraAdult: Float """Daily Rate extra children additional charge for this room type.""" ormsDrxtraChild: Float """Relative rank (low to high) of the room category per yield category.""" ormsUpsellRank: Float """Ownerroomflag""" ownerroomflag: String """Physical""" physical: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Product Class""" productClass: String """Code to uniquely identify the Property""" property: String """Pseudo Room Type""" pseudoRoomType: String """Pseudo Room YN""" pseudoRoomYN: String """Rate Amount""" rateAmount: Float """Rate Category""" rateCategory: String """Rate Category Description""" rateCategoryDesc: String """Rate Code""" rateCode: String """Contains the minimum value of the rate amount which can be defined in the rate details.""" rateFloor: Float """Ratecategoryid""" ratecategoryid: String """Reporting Item""" repItem: String """Reporting Item Name""" repItemName: String """Reporting Item Orderby""" repItemOrderby: Float """Reporting Order By""" repOrderBy: Float """Reporting Rate Category""" repRateCategory: String """Reporting Rate Category Desc""" repRateCategoryDescription: String """Reporting Smoking Pref Desc""" repSmokingPrefDescription: String """Reporting Updatedate""" repUpdateDate: DateTime """When room categories are renamed this flag indicates which room category this category replaces.""" replacesCategory: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Room Class""" roomClass: String """Room Class Description""" roomClassDescription: String """URL where room information is stored.""" roomInfoURL: String """Room Pool that this room type belongs to. (Used in Marriott mode).""" roomPool: String """Room Type""" roomType: String """Charged Room Type Description""" roomTypeDescription: String """Roomcategoryid""" roomcategoryid: String """Roomcategorypmsref""" roomcategorypmsref: String """Roomclassid""" roomclassid: String """Rotation Group""" rotationGroup: String """S Label""" sLabel: String """Sales strategy flag for Room Types: L=Lead U=Upsell A=Alternate.""" salesFlag: String """Sell Thru Rule Y/N""" sellThruRuleYn: String """Room type sent to interface Y/N""" sendIFC: String """Sequence""" sequence: Float """Smoking""" smoking: String """Smoking Pref Description""" smokingPrefDesc: String """Suite YN""" suiteYN: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float """Indicates if the rate code can be upsold""" upsellYn: String """Yield Status""" yieldStatus: String } type StatisticsForecastSummaryCountryDetailsType { """Defines the mode used to invoke Addressdoctor service [INTERACTIVE or FASTCOMPLETION]""" addressdoctorMode: String """Can Delete Y/N""" canDeleteYn: String """Chain Code""" chainCode: String """Country""" country: String """Country Code""" countryCode: String """Country Main Group""" countryMainGroup: String """Countryid""" countryid: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Indicates if the Country Flag should be displayed on the front end.""" displayCountryFlagYn: String """Guest Address Format Codes. For Confirmation Letters.""" guestAddressFormat: String """Inactive Date""" inactiveDate: DateTime """Inactive Flag""" inactiveflag: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Deleted Flag""" internalDeletedflag: String """ISO standard code for the country""" isoCode: String """ISO standard name for the country""" isoName: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Name""" name: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Print Sequence""" printSequence: Float """Property Address Format Codes. For Confirmation Letters.""" propertyAddressFormat: String """Region Code""" regionCode: String """Regionid""" regionid: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Display sequence for LOVs""" showSequence: Float """Internal""" statisticCode: String """Status""" status: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type StatisticsForecastSummaryChannelDetailsType { """Business Title""" businessTitle: String """Can Delete Y/N""" canDeleteYn: String """Central Origin Code""" centralOriginCode: String """Central Origin Description""" centralOriginDescription: String """Central Sequence""" centralSequence: Float """Chain Code""" chainCode: String """Channelid""" channelid: String """Comments""" comments: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Display Color""" displayColor: String """Entity Name""" entityName: String """Contains a list of codes used by a vendor.""" externalAttributeCodes: 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 """Language Code""" languageCode: String """Indicates if the KEYWORD TYPE is to be copied from a Company Master to a Company Subsidiary.""" masterSubKeywordYn: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Origin Code""" originCode: String """Origin Description""" originDescription: String """Origin Display Sequence""" originDisplaySequence: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Property""" property: String """Ranking""" ranking: Float """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 """Title Suffix""" titleSuffix: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type StatisticsForecastSummaryRegionDetailsType { """Chain Code""" chainCode: String """Code""" code: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedflag: String """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 Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Region Description""" regionDescription: String """Regionid""" regionid: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Sequence""" sequence: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float }