# title : OPERA Cloud RnA InventoryRoomsManagement GraphQL API, # description : GraphQL API to cater for Provides detailed information on room maintenance and out of order/service assignments broken down by property, time and room dimensions. Also provides reservations and profile details for service requests. # 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. # - roomDetailsResort input InventoryRoomsManagementQueryArgumentsType { """DSI Internal Data Source ID to identify Opera Chain and instance""" roomDetailsDsi: FloatInput """JRN Update Date and Time""" roomDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" roomDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" roomDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" roomDetailsResort: StringInput! @mandatoryInput """Room""" roomDetailsRoompmsref: StringInput """Room Number""" roomDetailsRoom: StringInput """Roomid""" roomDetailsRoomid: StringInput """JRN Update Date and Time""" roomrepairsDetailsJrnupdatedttm: DateTimeInput """JRN Update Date and Time""" roommaintenanceDetailsJrnupdatedttm: DateTimeInput """The business date this service request was closed.""" resortservicerequestsDetailsCloseBusinessDateTime: DateInput """DSI Internal Data Source ID to identify Opera Chain and instance""" resortservicerequestsDetailsDsi: FloatInput """Insert Date""" resortservicerequestsDetailsInsertDate: DateTimeInput """JRN Update Date and Time""" resortservicerequestsDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" resortservicerequestsDetailsLocationid: StringInput """Name ID""" resortservicerequestsDetailsNameId: FloatInput """Internal ID to uniquely identify the Organization""" resortservicerequestsDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" resortservicerequestsDetailsResort: StringInput """Resv Name ID""" resortservicerequestsDetailsResvNameId: FloatInput """Room Number""" resortservicerequestsDetailsRoom: StringInput """Service request classification code.""" resortservicerequestsDetailsServiceRequestCode: StringInput """Sequence generated no Identifier for service request.""" resortservicerequestsDetailsServiceRequestId: FloatInput """Status""" resortservicerequestsDetailsStatus: StringInput """JRN Update Date and Time""" reservationdailyelementsDetailsJrnupdatedttm: DateTimeInput """The property that the record belongs to""" resortDetailsResort: StringInput """Number format of AR account no.""" resortDetailsArAcctNoFormat: StringInput """Specifies if the AR acct No is mandatory(Y/N)""" resortDetailsArAcctNoMandYn: StringInput """Default Account Type for an Agent for the Property""" resortDetailsArAgent: StringInput """Internal""" resortDetailsArBalTrxCode: StringInput """Default Account Type for a Company for the Property""" resortDetailsArCompany: StringInput """Internal""" resortDetailsArCreditTrxCode: StringInput """Default Account Type for a Group for the Property""" resortDetailsArGroups: StringInput """Default Account Type for Individual for the Property""" resortDetailsArIndividuals: StringInput """Internal""" resortDetailsArSettleCode: StringInput """Internal""" resortDetailsArTypewriter: StringInput """Access Code""" resortDetailsAccessCode: StringInput """Number of handicapped rooms.""" resortDetailsQtyHandicappedRooms: FloatInput """Aging bucket 1""" resortDetailsAgingLevel1: FloatInput """Aging bucket 2""" resortDetailsAgingLevel2: FloatInput """Aging bucket 3""" resortDetailsAgingLevel3: FloatInput """Aging bucket 4""" resortDetailsAgingLevel4: FloatInput """Aging bucket 3""" resortDetailsAgingLevel5: FloatInput """The Airport Code for the airport near the property""" resortDetailsAirport: StringInput """Distance of the Airport specified in the AIRPORT_CODE column from the Property""" resortDetailsAirportDistance: StringInput """Time it takes to travel the distance between the Property and the Airport specified in AIRPORT_CODE column""" resortDetailsAirportTime: StringInput """Allow loggin in to this resort(Y/N)""" resortDetailsAllowLoginYn: StringInput """Period for the allowance""" resortDetailsAllowancePeriodAdj: StringInput """Internal""" resortDetailsAwardsTimeout: FloatInput """Ball Room Area""" resortDetailsBrArea: StringInput """No of Ballroom Seats""" resortDetailsBrSeats: FloatInput """The base language of the Hotel""" resortDetailsBaseLanguage: StringInput """It contains the reservation type to be used when making group block""" resortDetailsBlock: StringInput """Brand Code of the property.""" resortDetailsBrandCode: StringInput """Financial Year of the Property""" resortDetailsBudgetMonth: FloatInput """The date this resort becomes valid for use by the system""" resortDetailsBeginDate: DateInput """Value for the parameter.""" resortDetailsBusinessId: StringInput """Value for the parameter.""" resortDetailsBusinessRegCode: StringInput """Code for the CRO""" resortDetailsCroCode: StringInput """Internal""" resortDetailsCashShiftDrop: StringInput """Catering Currency Code used when Catering Currency differs from base currency.""" resortDetailsCateringCurrencyCode: StringInput """Catering currency format.""" resortDetailsCateringCurrencyFormat: StringInput """Central Exchange Date""" resortDetailsCXchangeDate: DateInput """Central Exchange Rate""" resortDetailsCXchangeRate: FloatInput """Central Credit Limit""" resortDetailsCCreditLimit: FloatInput """Central Currency Code""" resortDetailsCentralCurrencyCode: StringInput """Central Currency Description""" resortDetailsCentralCurrencyDesc: StringInput """Central Double Rate2""" resortDetailsCDblRate2: FloatInput """Central Double Rate1""" resortDetailsCDblRate1: FloatInput """Central Passerby Market""" resortDetailsRepPasserbyMarket: StringInput """Central Passerby Source""" resortDetailsRepPasserbySource: StringInput """Central Property Type""" resortDetailsRepResortType: StringInput """Central Sgl Rate1""" resortDetailsCSglRate1: FloatInput """Central Sgl Rate 2""" resortDetailsCSglRate2: FloatInput """Central State""" resortDetailsRepState: StringInput """Central State Description""" resortDetailsRepStateDesc: StringInput """Central Sui Rate1""" resortDetailsCSuiRate1: FloatInput """Central Sui Rate 2""" resortDetailsCSuiRate2: FloatInput """Central Tpl Rate1""" resortDetailsCTplRate1: FloatInput """Central Tpl Rate 2""" resortDetailsCTplRate2: FloatInput """Central Warning Amount""" resortDetailsCWarningAmount: FloatInput """Chain Code for the chain to which the property belongs""" resortDetailsChainCode: StringInput """The description of this chain.""" resortDetailsChainDescription: StringInput """Chain Mode""" resortDetailsChainMode: StringInput """Internal""" resortDetailsCheckExgPaidout: StringInput """The Hotel official check out time""" resortDetailsCheckOutTime: DateTimeInput """Internal""" resortDetailsCheckShiftDrop: StringInput """Internal""" resortDetailsCheckTrxcode: StringInput """The Hotel official check intime""" resortDetailsCheckInTime: DateTimeInput """The physical city in which this property resides.""" resortDetailsCity: StringInput """City Description""" resortDetailsCityDescription: StringInput """Internal""" resortDetailsComAddress: StringInput """Internal""" resortDetailsComMethod: StringInput """Internal""" resortDetailsComNameXrefId: FloatInput """Internal""" resortDetailsCompanyAddressType: StringInput """Internal""" resortDetailsCompanyPhoneType: StringInput """Internal""" resortDetailsConfigurationMode: StringInput """Internal""" resortDetailsConfirmRegcardPrinter: StringInput """Number of connecting rooms.""" resortDetailsQtyConnectingRooms: FloatInput """The unique name of application user""" resortDetailsAllContacts: StringInput """Number of copies to be printed""" resortDetailsCopies: FloatInput """Country name.""" resortDetailsCountryName: StringInput """The name of the country in which this property resides.""" resortDetailsCountryCode: StringInput """Value for the parameter.""" resortDetailsCountryMode: StringInput """The default credit limit for guests.""" resortDetailsCreditLimit: FloatInput """Currency Code.""" resortDetailsCurrencyCode: StringInput """Currency Symbol like $ or EURO symbol""" resortDetailsCurrencySymbol: StringInput """A description of this currency.""" resortDetailsCurrencyName: StringInput """Format for the local currency.""" resortDetailsLocalCurrencyFormat: StringInput """Color that of the background""" resortDetailsCurtainColor: StringInput """DSI""" resortDetailsDsi: FloatInput """Date the aging should begin""" resortDetailsDateForAging: StringInput """Type of separator to distinguish between DD MM and YYYY""" resortDetailsDateSeparator: StringInput """Number of places for the default currency""" resortDetailsDecimalPlaces: FloatInput """Type of decimal separator""" resortDetailsDecimalSeparator: StringInput """Number of decimals to designate currency""" resortDetailsCurrencyDecimals: FloatInput """Folio style to be used for all guests""" resortDetailsDefaultFolioStyle: FloatInput """Default guest address format.""" resortDetailsDefaultGuestAddress: StringInput """Future use""" resortDetailsDefaultMembershipType: StringInput """Future use""" resortDetailsDefaultPostingRoom: StringInput """Default property address format.""" resortDetailsDefaultPropertyAddress: StringInput """Future use""" resortDetailsDefaultRateCode: StringInput """Rate code used to default a PCR rate code used in FIT Contracts.""" resortDetailsDefaultRatecodePcr: StringInput """Rate code used to default a RACK rate code used for FIT Contracts.""" resortDetailsDefaultRatecodeRack: StringInput """Default registration card for the property.""" resortDetailsDefaultRegistrationCard: StringInput """The Default reservation type for this property""" resortDetailsDefaultReservationType: StringInput """Deleted Flag""" resortDetailsDeletedFlag: StringInput """Future use""" resortDetailsDepositLedTrxCode: StringInput """Destination ID""" resortDetailsDestinationId: StringInput """Future use""" resortDetailsDfltPkgTranCode: StringInput """Future use""" resortDetailsDfltTranCodeRateCode: StringInput """Internal""" resortDetailsDirections: StringInput """Future use""" resortDetailsDirsales: StringInput """LOGIN into the application is disabled.""" resortDetailsDisableLoginYn: StringInput """Number of double rooms.""" resortDetailsQtyDoubleRooms: FloatInput """Download Rest YN""" resortDetailsDownloadRestYn: StringInput """Pager number for the Manager on duty for the property.""" resortDetailsDutyManagerPager: StringInput """Email id for the property.""" resortDetailsEmail: StringInput """Future use.""" resortDetailsEndDate: DateInput """Default Exchange posting status for the property""" resortDetailsExchangePostingType: StringInput """Floor number of executive floor.""" resortDetailsFloorNumExecutiveFloor: StringInput """Hotel code used for third party exports""" resortDetailsExpHotelCode: StringInput """Future use""" resortDetailsExtExpFileLocation: StringInput """Future use""" resortDetailsExtPropertyCode: StringInput """Indicates that the property uses an external SC system.""" resortDetailsExternalScYn: StringInput """Number of family rooms.""" resortDetailsQtyFamilyRooms: FloatInput """Fax number formats.""" resortDetailsFaxNoFormat: StringInput """The fax phone number""" resortDetailsFax: StringInput """Future use""" resortDetailsFiscalEndDate: DateInput """Future use""" resortDetailsFiscalPeriodType: StringInput """Future use""" resortDetailsFiscalStartDate: DateInput """Fiscal Year Begin Month""" resortDetailsFiscalStartMonth: FloatInput """Fiscal Year Begin Year""" resortDetailsFiscalStartYear: FloatInput """Screen Painter flags to indicate whether an item is changable/ movable etc.""" resortDetailsFlags: StringInput """Future use""" resortDetailsFlowCode: StringInput """Property Free Nights Stay Tier.""" resortDetailsFnsTier: StringInput """Other languages""" resortDetailsFolioLanguage1: StringInput """Other languages""" resortDetailsFolioLanguage2: StringInput """Other languages""" resortDetailsFolioLanguage3: StringInput """Other languages""" resortDetailsFolioLanguage4: StringInput """Future use""" resortDetailsGenmgr: StringInput """To define an upper limit to the number of rooms for Group""" resortDetailsGroupRoomWarning: FloatInput """Future use""" resortDetailsGuestLookupTimeout: FloatInput """Number of guest elevators.""" resortDetailsQtyGuestElevators: FloatInput """Total of guest rooms floors.""" resortDetailsQtyGuestRoomFloors: FloatInput """Future use""" resortDetailsHotelCode: StringInput """Future use""" resortDetailsHotelFc: StringInput """Hotel id""" resortDetailsHotelId: StringInput """Future use""" resortDetailsHotelType: StringInput """Future use""" resortDetailsImgDirectionId: FloatInput """Future use""" resortDetailsImgHotelId: FloatInput """Future use""" resortDetailsImgMapId: FloatInput """Future use""" resortDetailsInactiveDaysForGuestProfil: FloatInput """Inactive Flag""" resortDetailsInactiveFlag: StringInput """Future use""" resortDetailsIndividualAddressType: StringInput """Future use""" resortDetailsIndividualPhoneType: StringInput """To define an upper limit to the number of rooms for group""" resortDetailsIndividualRoomWarning: FloatInput """The date the record was created""" resortDetailsInsertDate: DateTimeInput """The user that created the record""" resortDetailsInsertUser: FloatInput """Int Tax Included YN""" resortDetailsIntTaxIncludedYn: StringInput """Future use""" resortDetailsInventoryYn: StringInput """JRN Update Date and Time""" resortDetailsJrnupdatedttm: DateTimeInput """To calculate the entire availability of the Hotel for future reservations""" resortDetailsKeepAvailability: FloatInput """Latitude of the property in decimal""" resortDetailsLatitude: FloatInput """Future use""" resortDetailsLeadsend: StringInput """The owner who owns this property""" resortDetailsLegalOwner: StringInput """The property that the record belongs to""" resortDetailsLocationId: StringInput """Long date format for the property.""" resortDetailsLongDateFormat: StringInput """The default length of stay""" resortDetailsLongStayControl: FloatInput """Longitude of the property in decimal""" resortDetailsLongitude: FloatInput """Maximum adults in family rooms.""" resortDetailsMaxAdultsFamilyRoom: FloatInput """Maximum children in family rooms.""" resortDetailsMaxChildrenFamilyRoom: FloatInput """Future use""" resortDetailsMaxOccupancy: FloatInput """Maximum number of days that are allowed to credit a bill. (Country requirements.) Used in CASHIERING MODULE.""" resortDetailsMaxcreditdays: FloatInput """Indicates whether the property supports MBS. Used in some file exports.""" resortDetailsMbsSupportedYn: StringInput """Future use""" resortDetailsMeetRooms: FloatInput """Future use""" resortDetailsMeetSeats: FloatInput """Future use""" resortDetailsMeetSpace: FloatInput """Future use""" resortDetailsMeetingFc: StringInput """Minimum days for reminder letter.""" resortDetailsMinDaysBet2ReminderLetter: FloatInput """Internal""" resortDetailsNameIdLink: FloatInput """Future use""" resortDetailsNightAuditCashierId: StringInput """Number of non smoking rooms.""" resortDetailsQtyNonSmokingRooms: FloatInput """Notes for the property""" resortDetailsNotes: StringInput """Total number of beds in this property""" resortDetailsNumberBeds: FloatInput """Total number of floors in this property""" resortDetailsNumberFloors: FloatInput """Number of Rooms""" resortDetailsNumberRooms: FloatInput """Future use""" resortDetailsOpusCurrencyCode: StringInput """Organization ID""" resortDetailsOrganizationId: FloatInput """Organization Internal ID""" resortDetailsOrganizationid: FloatInput """Future use""" resortDetailsOwnership: StringInput """Package Loss code for a particular package""" resortDetailsPackageLoss: StringInput """Package Profit code for a particular Package""" resortDetailsPackageProfit: StringInput """Parent Org Code""" resortDetailsParentOrgCode: StringInput """Market code""" resortDetailsPasserbyMarket: StringInput """Source code""" resortDetailsPasserbySource: StringInput """Path""" resortDetailsPath: StringInput """Minimim Payment Date for the Property used in Cross Property Postings. This will get updated while running the user defined procedure during the night audit process.""" resortDetailsPaymentDate: DateTimeInput """Future use""" resortDetailsPerReservationRoomLimit: FloatInput """The direct dial phone number of this property""" resortDetailsTelephone: StringInput """The postal code of this property.""" resortDetailsPostCode: StringInput """Primary Key ID""" resortDetailsPkid: FloatInput """URL where property information is located.""" resortDetailsProinfoUrl: StringInput """Property MAP URL.""" resortDetailsPropMapUrl: StringInput """Property picture URL.""" resortDetailsPropPicUrl: StringInput """The property that the record belongs to""" resortDetailsLocationid: StringInput """The name of this property.""" resortDetailsName: StringInput """Type of resort.""" resortDetailsResortType: StringInput """Future use""" resortDetailsQuotedCurrency: StringInput """RNA Insert Date""" resortDetailsRnaInsertdate: DateTimeInput """RNA Update Date""" resortDetailsRnaUpdatedate: DateTimeInput """Minimim last Reconciliation Date for the Property used in Cross Property Postings. This will get updated while running the user defined procedure during the night audit process.""" resortDetailsReconcileDate: DateTimeInput """Future use""" resortDetailsRegionCode: StringInput """Description of the Region.""" resortDetailsRegionDescription: StringInput """Future use""" resortDetailsRestaurant: FloatInput """Total number of Sheets""" resortDetailsRhythmSheets: FloatInput """Total number of Towels""" resortDetailsRhythmTowels: FloatInput """Room amenity.""" resortDetailsRoomAmenity: StringInput """Future use""" resortDetailsSglNum: StringInput """Future use""" resortDetailsSglRate1: FloatInput """Future use""" resortDetailsSglRate2: FloatInput """Future use""" resortDetailsSuiNum: StringInput """Future use""" resortDetailsSuiRate1: FloatInput """Future use""" resortDetailsSuiRate2: FloatInput """To store number of days before deleting the gest profile""" resortDetailsSaveProfiles: FloatInput """Future use""" resortDetailsScriptId: FloatInput """Future use""" resortDetailsSeason1: StringInput """Future use""" resortDetailsSeason2: StringInput """Future use""" resortDetailsSeason3: StringInput """Future use""" resortDetailsSeason4: StringInput """Future use""" resortDetailsSeason5: StringInput """Indicates that the property accepts leads as bookings.""" resortDetailsSendLeadAsBooking: StringInput """Shop description.""" resortDetailsShopDescription: StringInput """Short date format for the property.""" resortDetailsShortDateFormat: StringInput """Number of single rooms.""" resortDetailsQtySingleRooms: FloatInput """For default commission percentage""" resortDetailsSourceCommission: StringInput """The state in which this property is located.""" resortDetailsState: StringInput """Description of the state.""" resortDetailsStateDesc: StringInput """The street of the property.""" resortDetailsStreet: StringInput """Number of suites.""" resortDetailsQtySuites: FloatInput """Internal""" resortDetailsSummCurrencyCode: StringInput """For default commission percentage""" resortDetailsTaCommission: StringInput """Future use""" resortDetailsTplNum: StringInput """Future use""" resortDetailsTplRate1: FloatInput """Future use""" resortDetailsTplRate2: FloatInput """Formats for telephone number""" resortDetailsTelephoneNoFormat: StringInput """Separator for monetory values""" resortDetailsThousandSeparator: StringInput """Default time format for the property.""" resortDetailsTimeFormat: StringInput """Time zone region selected by the employee.""" resortDetailsTimezoneRegion: StringInput """Toll free telephone number.""" resortDetailsTollfree: StringInput """Future use""" resortDetailsTotRooms: FloatInput """Tourist Number""" resortDetailsTouristNumber: StringInput """Indicates whether the property handles multi byte characters and whether they are translateable or not""" resortDetailsTranslateMulticharYn: StringInput """Turnaway code for the property.""" resortDetailsTurnawayCode: StringInput """Number of twin rooms.""" resortDetailsQtyTwinRooms: FloatInput """The date the record was modified""" resortDetailsUpdateDate: DateTimeInput """The user that modified the record""" resortDetailsUpdateUser: FloatInput """VAT ID of this property.""" resortDetailsVatId: StringInput """Future use""" resortDetailsVideocheckoutPrinter: StringInput """Video check out start time.""" resortDetailsVideoCoStart: DateTimeInput """Video check out end time.""" resortDetailsVideoCoStop: DateTimeInput """Future use""" resortDetailsWakeUpDelay: FloatInput """Amount at which warning is raised.""" resortDetailsWarningAmount: FloatInput """Webaddress of the property""" resortDetailsWebaddress: StringInput """Weekend days for the property.""" resortDetailsWeekendDays: StringInput """Internal""" resortDetailsZeroInvPurDays: FloatInput } type Query { """Provides detailed information on room maintenance and out of order/service assignments broken down by property time and room dimensions. Also provides reservations and profile details for service requests.""" inventoryRoomsManagement(limit: Int offset: Int input: InventoryRoomsManagementQueryArgumentsType!): [InventoryRoomsManagementType] } type InventoryRoomsManagementType { """Room Details""" roomDetails: InventoryRoomsManagementRoomDetailsType """Room Repairs Details""" roomRepairsDetails: InventoryRoomsManagementRoomRepairsDetailsType """Room Maintenance Details""" roomMaintenanceDetails: InventoryRoomsManagementRoomMaintenanceDetailsType """Property Service Requests""" propertyServiceRequestsDetails: InventoryRoomsManagementPropertyServiceRequestsDetailsType """Reservation Daily Elements Details""" reservationDailyElementsDetails: InventoryRoomsManagementReservationDailyElementsDetailsType """Resort Details""" propertyPropertyDetails: InventoryRoomsManagementPropertyPropertyDetailsType inventoryRoomsManagementRecordCount: Int } type InventoryRoomsManagementRoomDetailsType { """Accessible""" accessible: String """Area in sqft""" areaF: Float """Area in sqm""" areaM: Float """Assign Assign Status""" assignAssignStatus: String """Room assignment date""" assignDate: DateTime """Assign Reason Desc""" assignReasonDesc: String """Assign Type""" assignType: String """Assignemployeeid""" assignemployeeid: Float """Assignreasonid""" assignreasonid: String """Bed Type""" bedType: String """Building""" building: String """Building Group""" buildingGroup: String """Business Date""" businessDate: Date """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Minimum Revenue""" cMinimumRevenue: Float """Central Rack Rate""" cRackRate: Float """Central Meeting Room Type""" centralMeetingRoomType: String """Central Room Class""" centralRoomClass: String """Central Room Type""" centralRoomType: String """Central Room Type Description""" centralRoomTypeDescription: String """Combination Room YN""" combinationRoomYN: String """Comments""" comments: String """Suite component room numbers""" componentRoom: String """Connecting Room Number""" connectingRoomNumber: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Indicates the section to which employee belongs.""" daySection: String """Deduct YN""" deductYN: String """Defatulratecodeid""" defatulratecodeid: String """Default Rate Description""" defaultRateDesc: String """Deleted Flag""" deletedflag: String """Credits associated with the task after departure.""" departureCredits: Float """Description""" description: String """Diary name to show room in""" diaryName: String """Diarydisplayflag""" diarydisplayflag: String """Discrepancy""" discrepancy: String """Number of doors""" doors: String """Section the room belongs to for evening housekeeping""" eveningSection: String """Facility ID for eVisitor.""" evisitorFacilityId: String """Stores event types which do not require alternate spaces.""" excludedEventTypes: String """Direction room faces""" facing: String """Floor""" floor: String """The persons staying in room according to Front office.""" foPers: Float """Defines if the function space needs an alternate space when booked.""" forceAlternateYn: String """The front desk location this room should check in to.""" frontDeskLocation: String """Front Office Status of the room i.e.: Vacant or Occupied.""" frontOfficeStatus: String """Minutes occupied that define the room as 100% utilized. Maximum is 1440 minutes.""" fullUtilizationTime: Float """Generic YN""" genericYN: String """Handicapflag""" handicapflag: String """Max Height in ft""" heightmaxF: Float """Max Height in m""" heightmaxM: Float """Minumum heigth of room (feet)""" heightminF: Float """Minumum heigth of room (meters)""" heightminM: Float """Date and time when room will be released from hold.""" holdDateTime: DateTime """Hold type from resort_assignment_reasons table.""" holdType: String """User that is holding the room.""" holdUser: Float """Sequence for automatically generated task assignment.""" housekeepingAssignmentOrderBy: Float """Housekeeping Inspected date""" housekeepingInspDate: Date """Houskeeping inspected employee id""" housekeepingInspEmpId: String """The number of persons staying in the room according to housekeeping""" housekeepingPers: Float """The status of this room according to housekeeping""" housekeepingStatus: String """Image ID""" imageId: Float """Inactive Flag""" inactiveflag: String """Include in Statistics YN""" includeInStatisticsYN: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Tempflag""" internalTempflag: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """The current key code for this room. Used to create keys for a room.""" keyCode: String """Privileges available for this key""" keyOptions: String """The last check out date for this room.""" lastCheckOutDate: Date """The last meter reading for condos that track electrical usage of rented rooms.""" lastMeterReading: Float """Length (feet)""" lengthF: Float """Length (meters)""" lengthM: Float """Number of lights in the room""" light: String """Internal ID to uniquely identify the Property""" locationID: String """Loudspeakersflag""" loudspeakersflag: String """Maximum number of days before the catering event date that the space can be booked on the web.""" maxAdvance: Float """Function Space Maximum Capacity.""" maxCapacity: Float """Maximum number of groups for a Shared function space allowed.""" maxSharedGroups: Float """Maximum Occupancy""" maximumOccupancy: Float """The unit of measurement for this square units (IE: Feet Meters etc)""" measurement: String """Type of meeting room""" meetingRoomType: String """Meeting Room YN""" meetingRoomYN: String """Meetingroom Type Description""" meetingroomTypeDesc: String """Meetingroom Type Sequence""" meetingroomTypeSeq: Float """Type of microphone sockets""" microphoneSocketTypes: String """Number of microphone sockets""" microphoneSockets: Float """Minimum number of days before the catering event date that the space can be booked on the web.""" minAdvance: Float """Minimum Capacity""" minCapacity: Float """Minimum Revenue""" minimumRevenue: Float """Specifies the number of beds in this room.""" numberOfBeds: Float """Current room condition updated daily.(ie StayOverDueOutExpected etc)""" occupancyCondition: String """Discrepancy between front desk and housekeeping""" occupantDiscrepancy: Float """Used for pseudo rooms. If Y then this pseudo room will be included in Online Printing for reservation changes.""" onlinePrintingYn: String """Display sequence 2""" orderBy2: Float """Display sequence 3""" orderBy3: Float """Display sequence 4""" orderBy4: Float """Display sequence 5""" orderBy5: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Stores a Grade associated with a unit to determine the room display order in Room Assignment and Room Plan screens.""" ovosGradeCode: String """Room can be OVOS unit.""" ovosUnitYn: String """Not used""" pcode: String """Person discrepancy between front desk and houskeeping""" personDiscrepancy: Float """Phone Number""" phoneNumber: String """Physical Number of Rooms""" physicalNumberOfRooms: Float """Houskeeping credits for cleaning room in pickup status""" pickupCredits: 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 """Default rate for the room""" publishedRateAmount: Float """Default rate code to be used to calculate the total revenue.""" publishedRateCode: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Rate Code""" rateCode: String """Rating""" rating: String """Reporting Assign Reason Desc""" repAssignReasonDescription: String """Reporting Bed Type Desc""" repBedTypeDescription: String """Reporting Meetingroom Type Desc""" repMeetingroomTypeDescription: String """Reporting Meetingroom Type Seq""" repMeetingroomTypeSequence: Float """Reporting Room Class Sell Seq""" repRoomClassSellSequence: Float """Reporting Room Features Descs""" repRoomFeaturesDescs: String """Reporting Room Status Reason""" repRoomStatusReason: String """Reporting Room Status Reason Desc""" repRoomStatusReasonDescription: String """Room return status""" returnStatus: String """Room""" room: String """Room Assignment Rating.""" roomAssignmentRating: Float """Room Category Bedtype""" roomCategoryBedtype: String """Room Category Desc""" roomCategoryDesc: String """Room Class""" roomClass: String """Room Class Central Description""" roomClassCentralDescription: String """Room Class Description""" roomClassDescription: String """Room Class Sequence""" roomClassSequence: Float """Room Condition""" roomCondition: String """Room Feature Description""" roomFeatureDescription: String """This stores the codes for the rooms features. Currently not used""" roomFeatures: String """Room Number""" roomNumber: String """Room Parity""" roomParity: String """Room Status""" roomStatus: String """Room Status Description""" roomStatusDescription: String """The date as of which the room_status is valid.""" roomStatusFromDate: Date """Room Status Reason""" roomStatusReason: String """Room Status Reason Description""" roomStatusReasonDesc: String """Room status remarks""" roomStatusRemarks: String """The date till which the room_status is valid.(Used during OO and OS status of rooms )""" roomStatusToDate: Date """Room Type""" roomType: String """Total Count of the number of days the room was used.""" roomUseCount: Float """Roomcategoryid""" roomcategoryid: String """Roomclassid""" roomclassid: String """Roomid""" roomid: String """Roomstatusreasonid""" roomstatusreasonid: String """Sequence""" sequence: Float """Current guest service status code for this room. Example: Service status can be DND (Do Not Disturb) or MUP (Make Up Room)""" serviceStatus: String """Notes for the setup of the room""" setupNotes: String """Shareableflag""" shareableflag: String """Smoking""" smoking: String """Smoking Preferences""" smokingPreferences: String """The square units for this room (IE: if a condo in the US likely the square feet of this room)""" squareUnits: Float """Stayover Credits""" stayoverCredits: Float """Standard or Suite""" suiteType: String """Suite YN""" suiteYN: String """Supplement""" supplement: String """Temp Flag""" tempFlag: String """Number for the booth""" translationboothNum: Float """Turn Down""" turnDown: String """Houskeeping credits for Turndown.""" turndownCredits: Float """Number of TV or radio sockets""" tvRadioSockets: Float """Unit""" unit: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float """Flag makes a Function Space visible on the web.""" visibleOnWebYn: String """Web Booking Y/N""" webBookingYn: String """Room weigth (feet)""" weightF: Float """Room weigth (meters)""" weightM: Float """Width (feet)""" widthF: Float """Width (meters)""" widthM: Float } type InventoryRoomsManagementRoomRepairsDetailsType { """Flag to override "Out of Order/Service" rotation configuration for OVOS while calculating rotation points.""" calculateRotationYn: String """Completed Date""" completedDate: DateTime """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deduct Inventory""" deductInventory: String """Deleted Flag""" deletedFlag: String """End Time""" endTime: Date """From Date""" fromDate: Date """Include In Statistic""" includeInStatistic: String """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 """Reason Code""" reasonCode: String """Reason Description""" reasonDescription: String """Special remarks for the repair or reason for repair.""" remarks: String """Reporting Reason Code""" repReasonCode: String """Reporting Reason Code Desc""" repReasonCodeDescription: String """Indicates the source of repairs.Eg HK etc (Yet to define new values)""" repairType: String """Room return status""" returnStatus: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Room""" room: String """Room Status""" roomStatus: String """Sequence""" seq: Float """Through Date""" throughDate: Date } type InventoryRoomsManagementRoomMaintenanceDetailsType { """User who assigned the task.""" assignedBy: Float """Assigned By User Name""" assignedByUserName: String """Date when the task was assigned.""" assignedOn: DateTime """Assigned To""" assignedTo: Float """Assigned User""" assignedUser: String """Created On""" createdOn: DateTime """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Date when this task is due.""" expectedBy: Date """Insert User""" insertUser: Float """The name of the user who created the record.""" insertUserName: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Internal maintenance id""" maintenanceId: Float """Maintenance Reason""" maintenanceReason: String """Maintenance Reason Description""" maintenanceReasonDescription: 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 """Remarks""" remarks: String """Resolved""" resolved: String """Resolved By""" resolvedBy: Float """Resolved By User Name""" resolvedByUserName: String """Date when the trace was resolved.""" resolvedOn: DateTime """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Room""" room: String """Update User""" updateUser: Float """Updated By""" updatedBy: String """Updated On""" updatedOn: DateTime } type InventoryRoomsManagementPropertyServiceRequestsDetailsType { """Description of the action for completion.""" actionTaken: String """The business date this service request was closed.""" closeBusinessDateTime: Date """User ID who closed this service request.""" closedBy: String """Name of the hotel employee who closed this Service Request.""" closedByUserName: String """Followed up Description.""" closureActionTaken: String """The business date this service request was completed.""" completionBusinessDateTime: Date """Confirmation Number""" confirmationNumber: String """Communication method picked from guest profile.""" contactMethod: String """Contact Method Description""" contactMethodDescription: String """Name of the hotel employee who guaranteed this Service Request completion.""" contactedBy: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Date Closed""" dateClosed: Date """Date Completed""" dateCompleted: Date """Date Opened""" dateOpened: Date """Deleted Flag""" deletedFlag: String """Department""" department: String """Department Description""" departmentDescription: String """Guest Name""" guestName: String """Inactive Date""" inactiveDate: Date """Insert Date""" insertDate: DateTime """Insert User""" insertUser: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Name ID""" nameId: Float """The business date this service request was created.""" openBusinessDateTime: Date """User ID who opened this service request.""" openedBy: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Priority""" priority: String """Priority Description""" priorityDescription: String """Code to uniquely identify the Property""" property: String """Remarks""" remarks: String """Reporting Department Desc""" repDepartmentDescription: String """Rep Dept ID""" reportingDeptId: String """Resv Name ID""" reservationNameId: Float """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Room Number""" roomNumber: String """Service request classification code.""" serviceRequestCode: String """Service Request Description""" serviceRequestDescription: String """Sequence generated no Identifier for service request.""" serviceRequestId: Float """Service Type""" serviceType: String """Status""" status: String """Time Closed""" timeClosed: String """Time Completed""" timeCompleted: String """Time Opened""" timeOpened: String """Update Date""" updateDate: DateTime """Update User""" updateUser: String } type InventoryRoomsManagementReservationDailyElementsDetailsType { """Adults""" adults: Float """Allotment Header ID""" allotmentHeaderId: Float """Indicates whether the room type inventory was taken from the allotment or House availabilty.""" allotmentRecordType: String """Room Type before the Upgrade Award""" awdUpgrFrom: String """Room Type after the Upgrade Award""" awdUpgrTo: String """Base Rate Amount""" baseRateAmount: Float """Block ID.""" blockId: Float """Property this block belongs to.""" blockResort: String """Booked Room Category""" bookedRoomCategory: String """Central Base Rate Amount""" cBaseRateAmount: Float """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Original Base Rate""" cOriginalBaseRate: Float """Central Rate Amount""" cRateAmount: Float """Central Room Cost""" cRoomCost: Float """Cancellation Code""" cancellationCode: String """Cancellation Date""" cancellationDate: Date """Cancellation Number""" cancellationNo: Float """Cancellation Reason Description""" cancellationReasonDesc: String """Children""" children: Float """Cribs""" cribs: Float """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Day Use Y/N""" dayUseYn: String """Deleted Flag""" deletedFlag: String """Dml Sequence No""" dmlSeqNumber: Float """Due Out Y/N""" dueOutYn: String """Exchange Rate""" exchangeRate: Float """Not used""" extSegNo: Float """Not used""" extSeqNumber: Float """External Reference""" externalReference: String """Extra Beds""" extraBeds: Float """Guarantee Code""" guaranteeCode: String """Housekeeping Expected Service Time""" housekeepingExpectedServiceTime: String """Insert Action Instance ID""" insertActionInstanceId: Float """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 """Market Code""" marketCode: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Origin of Booking""" originOfBooking: String """Not used.""" originalBaseRate: Float """Physical Quantity""" physicalQuantity: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Code to uniquely identify the Property""" property: String """Quantity""" quantity: Float """Rate Amount""" rateAmount: Float """Reservation Date""" reservationDate: Date """Reservation Daily El Seq""" resvDailyElSequence: Float """Reservation Status""" resvStatus: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Room""" room: String """Room Assignment""" roomAssignment: String """Room Category""" roomCategory: String """Room Class""" roomClass: String """Room Cost""" roomCost: Float """Room Instructions""" roomInstructions: String """Turn Down Status""" turnDownStatusDescription: String """Turndown status of the room per reservation per day. C-Completed NR-Not required R-Requested.""" turndownStatus: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type InventoryRoomsManagementPropertyPropertyDetailsType { """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 }