# title : OPERA Cloud RnA SimpleReportsBookingsReservation GraphQL API, # description : GraphQL API to cater for The Simple Reports Bookings Reservation Subject Area simplifies creating and building adhoc reports, including the ability to create new reports. # 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. # - reservationgeneralDetailsResort # - reservationgeneralDetailsTruncArrival # - reservationgeneralDetailsTruncDeparture input SimpleReportsBookingsReservationQueryArgumentsType { """Actual Check In Date""" reservationgeneralDetailsActualCheckInDate: DateTimeInput """Actual Check Out Date""" reservationgeneralDetailsActualCheckOutDate: DateTimeInput """Addressee Name ID""" reservationgeneralDetailsAddresseeNameId: FloatInput """Trunc Arrival""" reservationgeneralDetailsTruncArrival: DateInput! @mandatoryInput """Award Membership ID""" reservationgeneralDetailsAwardMembershipId: FloatInput """Billing Contact ID""" reservationgeneralDetailsBillingContactId: FloatInput """Bonus Check ID""" reservationgeneralDetailsBonusCheckId: FloatInput """Business Date Created""" reservationgeneralDetailsBusinessDateCreated: DateInput """Cancellation Date""" reservationgeneralDetailsCancellationDate: DateTimeInput """Cancellation Number""" reservationgeneralDetailsCancellationNo: StringInput """Confirmation Number""" reservationgeneralDetailsConfirmationNo: StringInput """Custom Reference""" reservationgeneralDetailsCustomReference: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" reservationgeneralDetailsDsi: FloatInput """Departure""" reservationgeneralDetailsDeparture: DateTimeInput """Trunc Departure""" reservationgeneralDetailsTruncDeparture: DateInput! @mandatoryInput """Event ID""" reservationgeneralDetailsEventId: FloatInput """External Reference""" reservationgeneralDetailsExternalReference: StringInput """Date the folio was changed to closed.""" reservationgeneralDetailsFolioCloseDate: DateInput """Guarantee Code""" reservationgeneralDetailsGuaranteeCode: StringInput """Guest Name ID""" reservationgeneralDetailsGuestNameId: FloatInput """Insert User""" reservationgeneralDetailsInsertUser: FloatInput """JRN Update Date and Time""" reservationgeneralDetailsJrnupdatedttm: DateTimeInput """Name Usage Type""" reservationgeneralDetailsNameUsageType: StringInput """Internal ID to uniquely identify the Organization""" reservationgeneralDetailsOrganizationid: FloatInput """Original End Date""" reservationgeneralDetailsOriginalEndDate: DateInput """Parent Resv Name ID""" reservationgeneralDetailsParentResvNameId: FloatInput """Identifies the charging status of the reservation after check out. O=Open Checkout P=Charging Privileges C=Closed Checkout.""" reservationgeneralDetailsPostCoFlag: StringInput """Code to uniquely identify the Property""" reservationgeneralDetailsResort: StringInput! @mandatoryInput """Quote ID provided by external system.""" reservationgeneralDetailsQuoteId: StringInput """Resv Contact ID""" reservationgeneralDetailsResvContactId: FloatInput """Resv Name ID""" reservationgeneralDetailsResvNameId: FloatInput """Auto generated charge number for Point Of Sale systems to identify guests.""" reservationgeneralDetailsResortChargeNumber: StringInput """Reservation Status""" reservationgeneralDetailsResvStatus: StringInput """Is the guest scheduled for automatic check out?""" reservationgeneralDetailsScheduleCheckoutYn: StringInput """Upper case of First name of the Guest who stayed in this hotel for this reservation. This is used forthe Search purposes.""" reservationgeneralDetailsSfirstGuestName: StringInput """Sguest Name""" reservationgeneralDetailsSguestName: StringInput """Stores resv_name_id of the original multi room reservation from which this reservation is split off.""" reservationgeneralDetailsSplitFromResvNameId: FloatInput """This is the actual check out date with no time component.""" reservationgeneralDetailsTruncActualCheckOutDate: DateInput """Universal Card ID used by interfaces for key encoding purposes.""" reservationgeneralDetailsUniCardId: StringInput """Update Date""" reservationgeneralDetailsUpdateDate: 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 { """The Simple Reports Bookings Reservation Subject Area simplifies creating and building adhoc reports including the ability to create new reports.""" simpleReportsBookingsReservation(limit: Int offset: Int input: SimpleReportsBookingsReservationQueryArgumentsType!): [SimpleReportsBookingsReservationType] } type SimpleReportsBookingsReservationType { """Reservation General Details""" reservationGeneralDetails: SimpleReportsBookingsReservationReservationGeneralDetailsType """Resort Details""" propertyPropertyDetails: SimpleReportsBookingsReservationPropertyPropertyDetailsType simpleReportsBookingsReservationRecordCount: Int } type SimpleReportsBookingsReservationReservationGeneralDetailsType { """Indicates whether a prorated amount should be used for an Apartment Style Billing rate.""" aSBProratedYn: String """Accompanying guest names.""" accompanyingNames: String """Identifies if this reservation has accompanying guests Y/N""" accompanyingYn: String """Actual Check In Date""" actualCheckInDate: DateTime """Actual Check Out Date""" actualCheckOutDate: DateTime """Address ID""" addressId: Float """Addressee Name""" addresseeName: String """Addressee Name ID""" addresseeNameId: Float """Adults""" adults: Float """Adults Tax Free""" adultsTaxFree: Float """Indicates if the reservation has performed an Advance Check In.""" advanceCheckedInYn: String """Country Specific Requirement for Nigeria.""" alienRegistrationNo: String """Allotment Header ID""" allotmentHeaderId: Float """Indicates whether the room type inventory was taken from the allotment or House availabilty.""" allotmentRecordType: String """The Extended Byte Language of the Profile.""" alternateLanguage: String """Alternate Salutation""" alternateSalutation: String """Alternate Title""" alternateTitle: String """SPG - Indicates if this stay is eligible for an Amenity.""" amenityEligibleYn: String """Amenity Level Code""" amenityLevelCode: String """Amount Percent""" amountPercent: Float """Anonymization Status possible values: REQUESTED ANONYMIZED.""" anonymizationStatus: String """Approval Amount Calc Method""" approvalAmountCalcMethod: Float """Arrival""" arrival: DateTime """Arrival Carrier Code""" arrivalCarrierCode: String """Arrival Comments""" arrivalComments: String """Trunc Arrival""" arrivalDate: Date """Arrival Date Time""" arrivalDateTime: DateTime """Arrival Estimate Time""" arrivalEstimateTime: Date """Arrival Station Code""" arrivalStationCode: String """Arrival System Date Time""" arrivalSystemDateTime: DateTime """Arrival Time""" arrivalTime: String """Arrival Tranportation Y/N""" arrivalTranportationYn: String """Arrival Transport Code""" arrivalTransportCode: String """Arrival Transport Type""" arrivalTransportType: String """Not used.""" authorisedBillingYn: String """Authorizer ID""" authorizerId: Float """Auto Checkin Y/N""" autoCheckinYn: String """Auto Settle Days""" autoSettleDays: Float """Auto Settle Y/N""" autoSettleYn: String """Award Code""" awardCode: String """Award code 1""" awardCode1: String """Award code 2""" awardCode2: String """Award code 3""" awardCode3: String """Award Code 4""" awardCode4: String """Award code 5""" awardCode5: String """Award Membership ID""" awardMembershipId: Float """Award Voucher number 1""" awardVoucher1: String """Award Voucher number 2""" awardVoucher2: String """Award Voucher number 3""" awardVoucher3: String """Award Voucher number 4""" awardVoucher4: String """Award Voucher number 5""" awardVoucher5: String """Room Type before the Upgrade Award""" awdUpgrFrom: String """Room Type after the Upgrade Award""" awdUpgrTo: String """Balance on the account.""" balance: Float """Base Rate Amount""" baseRateAmount: Float """Base Rate Code""" baseRateCode: String """Base Rate Currency Code""" baseRateCurrencyCode: String """Based On Rule""" basedOnRule: String """Billing Contact ID""" billingContactId: Float """Billing Contact Name""" billingContactName: String """Block Code""" blockCode: String """Block ID.""" blockId: Float """Property this block belongs to.""" blockResort: String """Bonus Check ID""" bonusCheckId: Float """Booked Room Category""" bookedRoomCategory: String """This column holds the label (description) of room category originally booked not necessarily the one in which the guest stayed.""" bookedRoomCategoryLabel: String """Business Date Created""" businessDateCreated: Date """Business Title""" businessTitle: String """Bxgy Discount Y/N""" bxgyDiscountYn: String """Central Credit Limit""" cCreditLimit: Float """Central Discount Amt""" cDiscountAmount: Float """Central Hurdle""" cHurdle: Float """Central Local Base Rate Amount""" cLocalBaseRateAmount: Float """Central Rateable Value""" cRateableValue: Float """Cancellation Date""" cancellationDate: DateTime """Cancellation Number""" cancellationNo: String """Cancellation Reason Code""" cancellationReasonCode: String """Cancellation Reason Description""" cancellationReasonDesc: String """Channel""" channel: String """Duration in seconds to complete Check-In""" checkinDuration: Float """Children""" children: Float """Children Tax Free""" childrenTaxFree: Float """Children1""" children1: Float """Children2""" children2: Float """Children3""" children3: Float """Children4""" children4: Float """Children5""" children5: Float """Comments""" comments: String """Commission Code""" commissionCode: String """Commission Paid""" commissionPaid: Float """Indicates to whom the commission will be paid: NULL T (Travel Agent) S (Source) and B (Both).""" commissionPayoutTo: String """Commissionable Y/N""" commissionableYn: String """Comp Type Code""" compTypeCode: String """Company ID""" companyId: Float """Company Name""" companyName: String """Complimentary Y/N""" complimentaryYn: String """Calculated reservation status.""" computedResvStatus: String """Confirmation Leg Number.""" confirmationLegNo: Float """Confirmation letter name is stored.""" confirmationLetter: String """Confirmation Letter ID""" confirmationLetterId: Float """Confirmation Number""" confirmationNo: String """Consumer Y/N""" consumerYn: String """Contact Name ID""" contactNameId: Float """Credit Limit""" creditLimit: Float """Indicates if the reservation has opted-in for auto payment when credit limit overage is detected.""" creditLimitAutoPayAllowYn: String """Cribs""" cribs: Float """Currency Code""" currencyCode: String """Custom Reference""" customReference: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Country Specific Requirement for Nigeria.""" dateOfArrivalInCountry: Date """Business Date when the business block was opened for pickup.""" dateOpenedForPickup: Date """Deleted Flag""" deletedFlag: String """Departure""" departure: DateTime """Departure Carrier Code""" departureCarrierCode: String """Departure Comments""" departureComments: String """Trunc Departure""" departureDate: Date """Departure Date Time""" departureDateTime: Date """Departure Estimate Time""" departureEstimateTime: Date """Departure Station Code""" departureStationCode: String """Departure Time""" departureTime: String """Departure Transport Code""" departureTransportCode: String """Departure Transport Type""" departureTransportType: String """Departure Transportation Y/N""" departureTransportationYn: String """Direct Bill Verify Response""" directBillVerifyResponse: String """Discount Amount""" discountAmt: Float """Discount Prcnt""" discountPrcnt: Float """Discount Reason Code""" discountReasonCode: String """Display Color""" displayColor: String """Do Not Move Room""" doNotMoveRoom: String """Do not move room flag.""" doNotMoveYn: String """Not used.""" effectiveRateAmount: Float """Indicates if the reservation is eligible to receive room upgrades. Controlled by Central System.""" eligibleForUpgradeYn: String """Email Address""" emailAddress: String """Email Folio Y/N""" emailFolioYn: String """Entry Date into the country. (Croatian Requirements)""" entryDate: Date """(Customized) Entry point into the country. (Croatian Requirements)""" entryPoint: String """Comments related to Estimated Time of Return.""" etrComments: String """Event ID""" eventId: Float """Exchange Date""" exchangeDate: Date """Exchange Posting Type""" exchangePostingType: String """Exchange Rate""" exchangeRate: Float """The time when an Advance Checked-In Guest is expected to return to perform the actual Check-In.""" expectedTimeOfReturn: DateTime """Not used""" extSegNo: Float """Not used""" extSeqNumber: Float """Internal extension number for the main reservation""" extensionId: Float """Indicates if the guest has opted to receive Efolio through an external system.""" externalEfolioYn: String """Reservation leg number for itinerary reservations.""" externalLegNo: Float """External Reference""" externalReference: String """Type of external reference depending from what external system the number was passed.""" externalReferenceType: String """Extn Number""" extnNumber: Float """Extn Type""" extnType: String """Extra Beds""" extraBeds: Float """FB Revenue""" fbRevenue: Float """Financially Responsible Y/N""" financiallyResponsibleYn: String """Incremental Upsell Charge for the first night.""" firstNightUpsell: Float """Not used.""" fixedCharge: Float """Fixed Rate Y/N""" fixedRateYn: String """Oracle sequence to identify different attribute values of an address.""" folioAddrElementId: Float """Date the folio was changed to closed.""" folioCloseDate: Date """Folio Text1""" folioText1: String """Folio Y/N""" folioYn: String """GDS Record Locator""" gDSRecordLocator: String """Group ID""" groupId: Float """Group Name""" groupName: String """Guarantee Code""" guaranteeCode: String """The Description of the Guarantee code.""" guaranteeCodeDesc: String """Country of the guest""" guestCountry: String """Guest Country Description""" guestCountryDesc: String """Guest Email""" guestEmail: String """Guest First Name""" guestFirstName: String """This is soundex of GUEST FIRST NAME - Phonotic sound.""" guestFirstNameSdx: String """The code of the Guest Language for reporting purposes.""" guestLanguage: String """The Description of the Language Code. Used only during the Conversion process.""" guestLanguageDesc: String """This is soundex of GUEST LAST NAME - Phonotic sound.""" guestLastNameSdx: String """Middle name of the Guest who stayed in this hotel for this reservation.""" guestMiddleName: String """Guest Name""" guestName: String """Guest Name ID""" guestNameId: Float """Not used.""" guestPhone: String """Guest Priv Y/N""" guestPrivYn: String """Signature of the guest""" guestSignature: String """Used for Police/Tourist Export""" guestStatus: String """Guest Title""" guestTitle: String """Guest Title Description""" guestTitleDesc: String """Guest Type""" guestType: String """Guest Vip Description""" guestVIPDesc: String """Not used.""" hasAnyShareFixedRateYn: String """House Use Y/N""" houseUseYn: String """Housekeeping Expected Service Time""" housekeepingExpectedServiceTime: String """Hurdle""" hurdle: Float """This will be taken from the field OVERRIDE in the HURDLE_RATES table. This entry does not indicate that the rateable value of the reservation was less than the hurdle rate at the time of booking. In fact if any date of the reservation touches an overri""" hurdleOverride: String """Country Specific Requirement for Nigeria.""" immigrationStatus: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Insert User""" insertUserName: String """Intermediary Y/N""" intermediaryYn: String """Primary Key ID""" internalPrimaryKeyIDToUniquelyIdentifyTheRow: Float """Invoice Item Codes""" invItemCodes: String """Invoice Item Ids""" invItemIds: String """Indicates if the reservation has already been upsold.""" isUpsoldYn: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Privileges available for this key""" keyOptions: String """Key Valid Until""" keyValidUntil: Date """Last Direct Bill Batch Date""" lastDirectBillBatchDate: Date """Last Online-Printing Sequence Number used by this reservation.""" lastOnlinePrintSeq: Float """Latest date when a folio was printed using the "Periodic Batch Folios" option""" lastPeriodicFolioDate: Date """Not used.""" lastRoom: String """Latest date when a direct bill settlement was automatically done using the "Direct Bill Batch Folios" option""" lastSettleDate: Date """Local Base Rate Amount""" localBaseRateAmount: Float """Not used.""" locatorYn: String """Maintain Room Features""" maintainRoomFeatures: String """Indicates if this Reservation has requested or processed a Manual Checkout for consumer mobility. Possible Values: NULL [R]equested [P]rocessed.""" manualCheckoutStatus: String """Market Code""" marketCode: String """Description of the Market Code.""" marketDesc: String """Indicates if this a master or slave reservation for perfect share""" masterShare: String """Not used.""" mealplanYn: String """Membership ID""" membershipId: Float """Membership Level""" membershipLevel: String """Membership Number""" membershipNumber: String """Membership Rank""" membershipRank: Float """Membership Type""" membershipType: String """Identifies if there were any messages for the Guest on this reservation.""" messageYn: String """Marked as Y when the Phone Number/EMail Address is Opt In.""" mobileAudioKeyYn: String """Not used.""" multipleAdultsYn: String """Multiple Billing Contact ID Yn""" multipleBillingContactIdYN: String """Multiple Blocks Y/N""" multipleBlocksYn: String """Not used.""" multipleBookedRoomCateringYN: String """Not used.""" multipleChildrenYn: String """Not used.""" multipleCommentsYn: String """Multiple Comm Code Y/N""" multipleCommissionCodeYN: String """Multiple Company ID Yn""" multipleCompanyIdYN: String """Multiple Cribs Y/N""" multipleCribsYn: String """Multiple Currency Code Y/N""" multipleCurrencyCodeYn: String """Multiple Discount Amt Y/N""" multipleDiscountAmountYN: String """Multiple Discount Prcnt Y/N""" multipleDiscountPrcntYn: String """Multiple Extensions Y/N""" multipleExtensionsYn: String """Multiple Fixed Rate""" multipleFixedRate: String """Multiple Group ID Yn""" multipleGroupIdYN: String """Not used.""" multipleMarketCodeYn: String """Multiple Memberships Y/N""" multipleMembershipsYn: String """Not used.""" multipleOriginOfBookingYN: String """Multiple Pts Eligibility Y/N""" multiplePtsEligibilityYn: String """Not used.""" multipleRateCodeYn: String """Multiple Resv Contact ID Yn""" multipleReservationContactIdYN: String """Not used.""" multipleRoomCategoryYn: String """Not used.""" multipleRoomYn: String """Multiple Segments Y/N""" multipleSegmentsYn: String """Not used.""" multipleShareAmountYn: String """Multiple Source ID Yn""" multipleSourceIdYN: String """Multiple Travel Agent ID Yn""" multipleTravelAgentIdYN: String """Multiple Xbeds Y/N""" multipleXbedsYn: String """Not used.""" multipleYn: String """Name Tax Description""" nameTaxDescription: String """Name Tax Type""" nameTaxType: String """Name Type""" nameType: String """Name Usage Type""" nameUsageType: String """Nationality""" nationality: String """Country Specific Requirement for Nigeria.""" nextDestination: String """Nights""" nights: Float """No of Rooms""" numberOfRooms: Float """Indicates if the guest has opted in to receive email through the batch folio option.""" optInBatchFolYn: String """Indicates if the reservation has opted-in for communications.""" optedForCommissionYN: String """Room Category prior to upsale.""" orgRoomCategory: String """Room Category Label prior to upsale.""" orgRoomCategoryLabel: String """Total Cost of Stay prior to upsale.""" orgStayCost: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Origin of Booking""" originOfBooking: String """Description of the Origin of Booking code.""" originOfBookingDesc: String """Original Arrival""" originalArrival: Date """Not used.""" originalBaseRate: Float """Original End Date""" originalEndDate: Date """Override Turndown Flag Y/N""" overrideTurndownFlagYn: String """Owner Ff Flag""" ownerFfFlag: String """Param Mobility""" paramMobility: String """Parent Resv Name ID""" parentReservationNameId: Float """Party Code""" partyCode: String """Total amount of payment inclusive of VAT""" paymentAmount: Float """Payment Method""" paymentMethod: String """Payment Method Description""" paymentMethodDesc: String """Frequency in number of days when folios should be printed for this reservation""" periodicFolioFreq: Float """Indicates if the Phone Display Name is send to the Interface.""" phoneDisplayNameYn: String """Phone ID""" phoneId: Float """Physical Quantity""" physicalQuantity: Float """Pms Business Date""" pmsBusinessDate: Date """Points""" points: Float """Membership Points Eligibility Code.""" pointsEligibilityCode: String """Points Eligibility Description""" pointsEligibilityDesc: String """Indicates if the reservation has charging privileges after checkout.""" postChargingYn: String """Identifies the charging status of the reservation after check out. O=Open Checkout P=Charging Privileges C=Closed Checkout.""" postCoFlag: String """Posting Allowed Y/N""" postingAllowedYn: String """Indicates if the reservation has charging privileges before arrival.""" preChargingYn: String """Indicates whether the reservation is pre-registered for internet check-in or not.""" preRegisteredYn: String """Not used.""" preferredRoomType: String """Print Rate Y/N""" printRateYn: String """Products Codes""" products: String """Prof Loyalty Segment Codes""" profLoyaltySegmentCodes: String """Promotions.""" promotions: String """Code to uniquely identify the Property""" property: String """Psuedo Room Type""" psuedoRoomType: String """Purge Date""" purgeDate: DateTime """Purpose of stay.""" purposeOfStay: String """Quote ID provided by external system.""" quoteId: String """Rate Code""" rateCode: String """Rate Mobile Chkout Allowed""" rateMobileChkoutAllowed: String """Stay rateable value.""" rateableValue: Float """Rden Billing Contact ID""" rdenBillingContactId: Float """Rden Resv Contact ID""" rdenReservationContactId: Float """Rden Reservation Date""" rdenReservationDate: Date """Rden Property""" rdenResort: String """Rotation Rule to be configured for referral flag ?""" referralYn: String """Registration Card Number""" registrationCardNo: String """Reinstate Date""" reinstateDate: DateTime """Reporting Cancellation Reason Code""" repCancellationReasonCode: String """Reporting Channel""" repChannel: String """Reporting Commission Code""" repCommissionCode: String """Reporting Discount Reason""" repDiscountReason: String """Reporting Guarantee Code""" repGuaranteeCode: String """Reporting Guarantee Code Desc""" repGuaranteeCodeDescription: String """Reporting Guest Type""" repGuestType: String """Reporting Name Tax Type""" repNameTaxType: String """Reporting Name Tax Type Desc""" repNameTaxTypeDescription: String """Reporting Product Codes""" repProductCodes: String """Reporting Room Category Label""" repRoomCategoryLabel: String """Reporting Wl Priority""" repWlPriority: String """Reporting Wl Reason Code""" repWlReasonCode: String """Reporting Wl Reason Desc""" repWlReasonDescription: String """Reservation Insert Source""" resInsertSource: String """Reservation Insert Source Type""" resInsertSourceType: String """Resv Cl Destination ID""" reservationClDestinationId: String """Internal""" reservationConfLetterId: Float """Resv Contact ID""" reservationContactId: Float """Reservation Date""" reservationDate: DateTime """Resv Name ID""" reservationNameId: Float """Reservation Preferences""" reservationPreferences: String """Auto generated charge number for Point Of Sale systems to identify guests.""" resortChargeNumber: String """This field will be populated with a "Y" if the user has overridden any restriction with the exception of a hurdle override to accept the reservation.""" restrictionOverride: String """Reservation Cl Destination""" resvClDestination: String """Reservation Conf Letter Lta""" resvConfLetterLta: DateTime """Reservation Conf Letter Status""" resvConfLetterStatus: String """Reservation Contact Name""" resvContactName: String """Reservation Loyalty Segment Codes""" resvLoyaltySegmentCodes: String """Not used in PMS currently.""" resvNumber: Float """Reservation Status""" resvStatus: String """Revenue type (catering/rooms)""" revenueTypeCode: String """Rn Billing Contact ID""" rnBillingContactId: Float """Rn Resv Contact ID""" rnReservationContactId: Float """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Room""" room: String """Room Category""" roomCategory: String """Room Category Label""" roomCategoryLabel: String """Room Class""" roomClass: String """Room Cost""" roomCost: Float """This stores the codes for the rooms features. Currently not used""" roomFeatures: String """Room Instructions""" roomInstructions: String """Meeting Room Property""" roomResort: String """Room Revenue""" roomRevenue: Float """This is the Turndown room service time.""" roomServiceTime: String """Routing Y/N""" routingYn: String """Is the guest scheduled for automatic check out?""" scheduleCheckoutYn: String """Upper case of First name of the Guest who stayed in this hotel for this reservation. This is used forthe Search purposes.""" sfirstGuestName: String """Sguest Name""" sguestName: String """Share Amount""" shareAmount: Float """Share ID.""" shareId: Float """Not used.""" sharePrcnt: Float """Type of revenue""" shareSeqNumber: Float """Shared Y/N""" sharedYn: String """The Uppercase value of Last or Company.""" sname: String """Source ID""" sourceId: Float """Source Name""" sourceName: String """Special Requests""" specialRequests: String """SPG Room Type Disclosure Flag. Indicates if the guest stationery will disclose the actual room type.""" spgDiscloseRoomTypeYn: String """SPG Suite Night Award Status.""" spgSuiteNightAwardStatus: String """SPG Upgrade Confirmed Room Type Label.""" spgUpgradeConfirmedRoomtype: String """SPG Upgrade Reason Code.""" spgUpgradeReasonCode: String """Stores resv_name_id of the original multi room reservation from which this reservation is split off.""" splitFromReservationNameId: Float """Rate Tier used for exports(DRS).""" statisticalRateTier: Float """Statistical Room Label""" statisticalRoomLabel: String """Room Type used to calculate statistics for export(DRS).""" statisticalRoomType: Float """Suite With""" suiteWith: String """Super Search Index Text""" superSearchIndexText: String """Internal Indexed field for Searching by Extended Byte First Name.""" sxfirstName: String """Internal Indexed field for Searching by Extended Byte Name.""" sxname: String """Record status.""" sysStatus: String """Ta Record Locator""" taRecordLocator: String """Tax exempt number on the profile""" taxExemptNo: String """Tax No of Stays""" taxNumberOfStays: Float """Tax Registration Number""" taxRegistrationNo: Float """Tiad""" tiad: String """Total Revenue""" totalRevenue: Float """Total Cost of Stay after upsale.""" totalStayCostAfterUpsell: Float """Total Upsell Charge""" totalUpsellCharge: Float """Identifies if there were any traces for the Guest on this reservation.""" traceYn: String """Travel Agent ID""" travelAgentId: Float """Travel Agent Name""" travelAgentName: String """This is the actual check out date with no time component.""" truncActualCheckOutDate: Date """Turndown status of the room per reservation per day. C-Completed NR-Not required R-Requested.""" turndownStatus: String """Udfc01""" udfc01: String """Udfc02""" udfc02: String """Udfc03""" udfc03: String """Udfc04""" udfc04: String """Udfc05""" udfc05: String """Udfc06""" udfc06: String """Udfc07""" udfc07: String """Udfc08""" udfc08: String """Udfc09""" udfc09: String """Udfc10""" udfc10: String """Udfc11""" udfc11: String """Udfc12""" udfc12: String """Udfc13""" udfc13: String """Udfc14""" udfc14: String """Udfc15""" udfc15: String """Udfc16""" udfc16: String """Udfc17""" udfc17: String """Udfc18""" udfc18: String """Udfc19""" udfc19: String """Udfc20""" udfc20: String """Udfc21""" udfc21: String """Udfc22""" udfc22: String """Udfc23""" udfc23: String """Udfc24""" udfc24: String """Udfc25""" udfc25: String """Udfc26""" udfc26: String """Udfc27""" udfc27: String """Udfc28""" udfc28: String """Udfc29""" udfc29: String """Udfc30""" udfc30: String """Udfc31""" udfc31: String """Udfc32""" udfc32: String """Udfc33""" udfc33: String """Udfc34""" udfc34: String """Udfc35""" udfc35: String """Udfc36""" udfc36: String """Udfc37""" udfc37: String """Udfc38""" udfc38: String """Udfc39""" udfc39: String """Udfc40""" udfc40: String """Udfd01""" udfd01: Date """Udfd02""" udfd02: Date """Udfd03""" udfd03: Date """Udfd04""" udfd04: Date """Udfd05""" udfd05: Date """Udfd06""" udfd06: Date """Udfd07""" udfd07: Date """Udfd08""" udfd08: Date """Udfd09""" udfd09: Date """Udfd10""" udfd10: Date """Udfd11""" udfd11: Date """Udfd12""" udfd12: Date """Udfd13""" udfd13: Date """Udfd14""" udfd14: Date """Udfd15""" udfd15: Date """Udfd16""" udfd16: Date """Udfd17""" udfd17: Date """Udfd18""" udfd18: Date """Udfd19""" udfd19: Date """Udfd20""" udfd20: Date """Udfn01""" udfn01: Float """Udfn02""" udfn02: Float """Udfn03""" udfn03: Float """Udfn04""" udfn04: Float """Udfn05""" udfn05: Float """Udfn06""" udfn06: Float """Udfn07""" udfn07: Float """Udfn08""" udfn08: Float """Udfn09""" udfn09: Float """Udfn10""" udfn10: Float """Udfn11""" udfn11: Float """Udfn12""" udfn12: Float """Udfn13""" udfn13: Float """Udfn14""" udfn14: Float """Udfn15""" udfn15: Float """Udfn16""" udfn16: Float """Udfn17""" udfn17: Float """Udfn18""" udfn18: Float """Udfn19""" udfn19: Float """Udfn20""" udfn20: Float """Udfn21""" udfn21: Float """Udfn22""" udfn22: Float """Udfn23""" udfn23: Float """Udfn24""" udfn24: Float """Udfn25""" udfn25: Float """Udfn26""" udfn26: Float """Udfn27""" udfn27: Float """Udfn28""" udfn28: Float """Udfn29""" udfn29: Float """Udfn30""" udfn30: Float """Udfn31""" udfn31: Float """Udfn32""" udfn32: Float """Udfn33""" udfn33: Float """Udfn34""" udfn34: Float """Udfn35""" udfn35: Float """Udfn36""" udfn36: Float """Udfn37""" udfn37: Float """Udfn38""" udfn38: Float """Udfn39""" udfn39: Float """Udfn40""" udfn40: Float """Universal Card ID used by interfaces for key encoding purposes.""" uniCardId: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float """Update User""" updateUserName: String """Incremental Upsell charges for the reservation date.""" upsellCharge: Float """Upsell Rule ID""" upsellRuleId: Float """User ID who upsold the reservation.""" upsoldByUserId: Float """Flag if the guest can do video checkout""" videoCheckoutYn: String """VIP Status""" vip: String """Visa Expiration Date""" visaExpirationDate: Date """Visa Issue Date""" visaIssueDate: Date """Visa Number""" visaNumber: String """Country Specific Requirement for Nigeria.""" visaValidityType: String """Walkin Y/N""" walkinYn: String """Wl Priority""" wlPriority: String """Wl Reason Code""" wlReasonCode: String """Wl Reason Description""" wlReasonDescription: String """This is the waitlist telephone number.""" wlTelephoneNo: String """Extended Byte Company Name""" xcompanyName: String """Xfirst Name""" xfirstName: String """Xlast Name""" xlastName: String """Yieldable Y/N""" yieldableYn: String """Ym Code""" ymCode: String } type SimpleReportsBookingsReservationPropertyPropertyDetailsType { """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 }