# title : OPERA Cloud RnA RatesTiers GraphQL API, # description : GraphQL API to cater for Rate tier definition by length of stays. # 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. # - ratetierDetailsResort input RatesTiersQueryArgumentsType { """DSI Internal Data Source ID to identify Opera Chain and instance""" ratetierDetailsDsi: FloatInput """JRN Update Date and Time""" ratetierDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" ratetierDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" ratetierDetailsResort: StringInput! @mandatoryInput """Tier ID for the Rate Detail.""" ratetierDetailsTierId: FloatInput """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""" ratecodedetailsDetailsDsi: FloatInput """End Date""" ratecodedetailsDetailsEndDate: DateInput """JRN Update Date and Time""" ratecodedetailsDetailsJrnupdatedttm: DateTimeInput """Rate set id of the base rates rate set.""" ratecodedetailsDetailsLinkRateSetId: FloatInput """Market Code""" ratecodedetailsDetailsMarketCode: StringInput """Internal ID to uniquely identify the Organization""" ratecodedetailsDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" ratecodedetailsDetailsResort: StringInput """Rate Code""" ratecodedetailsDetailsRateCode: StringInput """Rate Set ID""" ratecodedetailsDetailsRateSetId: FloatInput """Season Code""" ratecodedetailsDetailsSeasonCode: StringInput """Source Code""" ratecodedetailsDetailsSourceCode: StringInput """Start Date""" ratecodedetailsDetailsBeginDate: DateInput """Tier ID for the Rate Detail.""" ratecodedetailsDetailsTierId: FloatInput } type Query { """Rate tier definition by length of stays.""" ratesTiers(limit: Int offset: Int input: RatesTiersQueryArgumentsType!): [RatesTiersType] } type RatesTiersType { """Rate Tier Details""" rateTierDetails: RatesTiersRateTierDetailsType """Resort Details""" propertyPropertyDetails: RatesTiersPropertyPropertyDetailsType """Rate Code Details Details""" rateCodeDetailsDetails: RatesTiersRateCodeDetailsDetailsType ratesTiersRecordCount: Int } type RatesTiersRateTierDetailsType { """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedflag: String """LOS start day for the tier.""" fromLengthOfStay: 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 """Ratetierid""" ratetierid: Float """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Tier ID for the Rate Detail.""" tierID: Float """LOS end day for the tier except for the last day.""" toLengthOfStay: Float } type RatesTiersPropertyPropertyDetailsType { """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 RatesTiersRateCodeDetailsDetailsType { """Amount to be added after rounding""" addAfterRounding: Float """Adult Charge""" adultCharge: Float """Threshold for number of adults on a reservation. Additional charge will be added when reservation exceeds this threshold.""" adultsThreshold: Float """Amount used to calculate price for adults when the number of adults on the reservation exceed the adult threshold.""" adultsThresholdCharge: Float """Indicates either Flat amount or Percentage increase or decrease from the advanced dynamic base rate.""" advBaseAmount: Float """Calculate as Flat [FLT] or Percentage [PCT] amount of the advanced dynamic base rate code.""" advBaseFltPct: String """Identifies the Advanced Daily Base Rate Code from which this rate detail was copied.""" advDailyBaseRateCode: String """Identifies if during the availability check the calculated based amount should be compared to rate detail of BAR rate code.""" advanceBaseCompareYN: String """Age Range for Bucket 1""" ageRangeForBucket1: String """Age Range for Bucket 2""" ageRangeForBucket2: String """Age Range for Bucket 3""" ageRangeForBucket3: String """Indicate the amount type for the 1 Adult. A [FLAT] or [DIFFERENTIAL] amount.""" amount1Type: String """Indicate the amount type for the 2 Adult. A [FLAT] or [DIFFERENTIAL] amount.""" amount2Type: String """Indicate the amount type for the 3 Adult. A [FLAT] or [DIFFERENTIAL] amount.""" amount3Type: String """Indicate the amount type for the 4 Adult. A [FLAT] or [DIFFERENTIAL] amount.""" amount4Type: String """Indicate the amount type for the 5 Adult. A [FLAT] or [DIFFERENTIAL] amount.""" amount5Type: String """Amount for 1 Person""" amountFor1Person: Float """Amount for 2 Persons""" amountFor2Persons: Float """Amount for 3 Persons""" amountFor3Persons: Float """Amount for 4 Persons""" amountFor4Persons: Float """Amount for 5 adults""" amountFor5Persons: Float """Stores the Percentage or Amount difference between BAR Rate code and this Rate Code.""" barAmount: Float """Identifies if the amount column represents a Flat [FLT] or Percentage [PCT] value.""" barFltPct: String """Identifies the rounding formula for the BBAR Rate calculation.""" barRounding: String """Is this schedule applied to bar by los rate pushing also.""" barYn: String """Central Adult Charge""" cAdultCharge: Float """Central Adults Threshold Charge""" cAdultsThresholdCharge: Float """Central Adv Base Amount""" cAdvanceBaseAmount: Float """Central Amount 1""" cAmount1: Float """Central Amount 2""" cAmount2: Float """Central Amount 3""" cAmount3: Float """Central Amount 4""" cAmount4: Float """Central Amount 5""" cAmount5: Float """Central Bar Amount""" cBarAmount: Float """Central Child Charge 1""" cChildCharge1: Float """Central Child Charge 2""" cChildCharge2: Float """Central Child Charge 3""" cChildCharge3: Float """Central Child Own Charge 1""" cChildOwnCharge1: Float """Central Child Own Charge 2""" cChildOwnCharge2: Float """Central Child Own Charge 3""" cChildOwnCharge3: Float """Central Child Own Charge 4""" cChildOwnCharge4: Float """Central Children Charge""" cChildrenCharge: Float """Central Children Threshold Charge""" cChildrenThresholdCharge: Float """Central Diff Amount 1""" cDifferenceAmount1: Float """Central Diff Amount 2""" cDifferenceAmount2: Float """Central Diff Amount 3""" cDifferenceAmount3: Float """Central Diff Amount 4""" cDifferenceAmount4: Float """Central Diff Amount 5""" cDifferenceAmount5: Float """Central Diff Amount Extra Adult""" cDifferenceAmountExtraAdult: Float """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Flat Increase""" cFlatIncrease: Float """Central Los1 Amt""" cLos1Amount: Float """Central Los10 Amt""" cLos10Amount: Float """Central Los11 Amt""" cLos11Amount: Float """Central Los12 Amt""" cLos12Amount: Float """Central Los13 Amt""" cLos13Amount: Float """Central Los14 Amt""" cLos14Amount: Float """Central Los2 Amt""" cLos2Amount: Float """Central Los3 Amt""" cLos3Amount: Float """Central Los4 Amt""" cLos4Amount: Float """Central Los5 Amt""" cLos5Amount: Float """Central Los6 Amt""" cLos6Amount: Float """Central Los7 Amt""" cLos7Amount: Float """Central Los8 Amt""" cLos8Amount: Float """Central Los9 Amt""" cLos9Amount: Float """Central Maximum Amount 1""" cMaximumAmount1: Float """Central Maximum Amount 2""" cMaximumAmount2: Float """Central Minimum Amount 1""" cMinimumAmount1: Float """Central Minimum Amount 2""" cMinimumAmount2: Float """Central Occupants Threshold Charge""" cOccupantsThresholdCharge: Float """Central Package Rate Stay Over""" cPackageRateStayOver: Float """Central Room Cost""" cRoomCost: Float """Indicates Global rate update was (P)ercent or (F)lat""" calculationFlag: String """Stores the catering package price code for the package linked to the rate code in rate header.""" catPackagePriceCode: String """Central Market Code""" centralMarketCode: String """Central Market Description""" centralMarketDescription: String """Central Market Group Code""" centralMarketGroupCode: String """Central Market Group Description""" centralMarketGroupDescription: String """Central Package Code""" centralPackageCode: String """Central Room Type""" centralRoomType: String """Central Room Type Description""" centralRoomTypeDescription: String """Central Season Code""" centralSeasonCode: String """Central Source Code""" centralSourceCode: String """Central Source Description""" centralSourceDescription: String """Central Source Group Code""" centralSourceGroupCode: String """Central Source Group Description""" centralSourceGroupDescription: String """Indicates whether the child 1 count will be excluded while calculating the total occupants threshold excess amount.""" childExcThreshold1: String """Indicates whether the child 2 count will be excluded while calculating the total occupants threshold excess amount.""" childExcThreshold2: String """Indicates whether the child 3 count will be excluded while calculating the total occupants threshold excess amount.""" childExcThreshold3: String """Child Own Charge 1""" childOwnCharge1: Float """Child Own Charge 2""" childOwnCharge2: Float """Child Own Charge 3""" childOwnCharge3: Float """Child Own Charge 4""" childOwnCharge4: Float """Number of children that will stay free.""" childrenFreeStay: Float """Children Charge""" childrenCharge: Float """Threshold for number of children on a reservation. Additional charge will be added when reservation exceeds this threshold.""" childrenThreshold: Float """Amount used to calculate price for children when the number of children on the reservation exceed the children threshold.""" childrenThresholdCharge: Float """Currency Code""" currencyCode: String """Currency Description""" currencyDescription: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedflag: String """Deposit required Y/N""" depositRequieredYn: String """Contains a flat/percentage value for 1 Adult differential.""" differenceAmount1: Float """Contains a flat/percentage value for 2 Adult differential.""" differenceAmount2: Float """Contains a flat/percentage value for 3 Adult differential.""" differenceAmount3: Float """Contains a flat/percentage value for 4 Adult differential.""" differenceAmount4: Float """Contains a flat/percentage value for 5 Adult differential.""" differenceAmount5: Float """Contains a flat/percentage value for Extra Adult differential.""" differenceAmountExtraAdult: Float """Indicate if percentage value for 1 Adult differential should be used.""" differencePercentage1Yn: String """Indicate if percentage value for 2 Adult differential should be used.""" differencePercentage2Yn: String """Indicate if percentage value for 3 Adult differential should be used.""" differencePercentage3Yn: String """Indicate if percentage value for 4 Adult differential should be used.""" differencePercentage4Yn: String """Indicate if percentage value for 5 Adult differential should be used.""" differencePercentage5Yn: String """Indicate if percentage value for Extra Adult differential should be used.""" differencePercentageExtraAdultYn: String """End Date""" endDate: Date """This field is required by OXI to store the external system rate_set_id to be used for locating the record in rate_set table during an update.""" externalRateSetId: Float """Indicate the amount type for the Extra Adult. A [FLAT] or [DIFFERENTIAL] amount.""" extraAdultType: String """Flat Increase Amount""" flatIncrease: Float """Indicates if Rate set created by Global Rate Update""" globalRateUpdateYn: String """Inactive Date""" inactiveDate: Date """Inactive Flag""" inactiveflag: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Location ID""" internalLocationId: String """Organization ID""" internalOrganizationId: Float """Ratesetid""" internalRatesetid: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """LOS1 amount for prevailing rate code.""" lengthOfStay1Amount: Float """LOS10 amount for prevailing rate code.""" lengthOfStay10Amount: Float """LOS11 amount for prevailing rate code.""" lengthOfStay11Amount: Float """LOS12 amount for prevailing rate code.""" lengthOfStay12Amount: Float """LOS13 amount for prevailing rate code.""" lengthOfStay13Amount: Float """LOS14 amount for prevailing rate code.""" lengthOfStay14Amount: Float """LOS2 amount for prevailing rate code.""" lengthOfStay2Amount: Float """LOS3 amount for prevailing rate code.""" lengthOfStay3Amount: Float """LOS4 amount for prevailing rate code.""" lengthOfStay4Amount: Float """LOS5 amount for prevailing rate code.""" lengthOfStay5Amount: Float """LOS6 amount for prevailing rate code.""" lengthOfStay6Amount: Float """LOS7 amount for prevailing rate code.""" lengthOfStay7Amount: Float """LOS8 amount for prevailing rate code.""" lengthOfStay8Amount: Float """LOS9 amount for prevailing rate code.""" lengthOfStay9Amount: Float """Rate set id of the base rates rate set.""" linkRateSetId: Float """Internal ID to uniquely identify the Property""" locationID: String """Market Code""" marketCode: String """Market Description""" marketDescription: String """Market Group Code""" marketGroupCode: String """Market Group Description""" marketGroupDescription: String """Maximum rate amount value for 1 adult.""" maximumAmount1: Float """Maximum rate amount value for 2 adults.""" maximumAmount2: Float """Represents every x number of children to get free "num_children_stay_free" """ minChildrenForFreeStay: Float """Minimum rate amount value for 1 adult.""" minimumAmount1: Float """Minimum rate amount value for 2 adults.""" minimumAmount2: Float """Not used""" minimumClosingProbability: Float """Threshold for number of occupants on a reservation. Additional charge will be added when reservation exceeds this threshold.""" occupantsThreshold: Float """Amount used to calculate price for occupants when the number of occupants on the reservation exceed the occupant threshold.""" occupantsThresholdCharge: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """The amount to charge per extra adult on every additional day of stay for a package that extends beyo""" packageAdultStayOver: Float """The amount to charge per extra child on every additional day of stay for a package that extends beyo""" packageChildrenStayOver: Float """Package Code""" packageCode: String """The amount to charge extra on every additional day of stay for a package that extends beyond the inc""" packageRateStayOver: Float """Not used""" percentIncrease: Float """Points Required""" pointsRequired: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Code to uniquely identify the Property""" property: String """Rate Available on Fridays YN""" rateAvailableOnFridaysYN: String """Rate Available on Mondays YN""" rateAvailableOnMondaysYN: String """Rate Available on Saturdays YN""" rateAvailableOnSaturdaysYN: String """Rate Available on Sundays YN""" rateAvailableOnSundaysYN: String """Rate Available on Thursdays YN""" rateAvailableOnThursdaysYN: String """Rate Available on Tuesdays YN""" rateAvailableOnTuesdaysYN: String """Rate Available on Wednesdays YN""" rateAvailableOnWednesdaysYN: String """Rate Code""" rateCode: String """Event Reservation Rate Code Description""" rateCodeDesc: String """Rate Code ID""" rateCodeId: String """Rate Rule""" rateRule: String """Rate Set ID""" rateSetId: Float """Child charge for defined rate bucket 1.""" rateForChildInAgeBucket1: Float """Child charge for defined rate bucket 2.""" rateForChildInAgeBucket2: Float """Child charge for defined rate bucket 3.""" rateForChildInAgeBucket3: Float """Indicates if the rate amounts are activated.""" ratesActiveYn: String """Ratetierid""" ratetierid: Float """Reporting Season Desc""" repSeasonDescription: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Room Cost""" roomCost: Float """Room Type""" roomType: String """Room Type Description""" roomTypeDescription: String """Type of rounding after rate_update""" roundToNearest: Float """Season""" season: String """Season Code""" seasonCode: String """User defined description for season.""" seasonDesc: String """Source Code""" sourceCode: String """Source Description""" sourceDescription: String """Source Group Code""" sourceGroupCode: String """Source Group Description""" sourceGroupDescription: String """Start Date""" startDate: Date """Tier ID for the Rate Detail.""" tierId: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float }