# title : OPERA Cloud RnA BookingsBlockProductionChanges GraphQL API, # description : GraphQL API to cater for Detailed information on blocks and any changes to the number of rooms or revenue, by stay date, property and Block Owner. # 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. # - allotmentchangesnetDetailsResort # - allotmentchangesnetDetailsStayDate input BookingsBlockProductionChangesQueryArgumentsType { """Block ID""" allotmentchangesnetDetailsAllotmentHeaderId: FloatInput """System generated number that uniquely identifies a record in this table.""" allotmentchangesnetDetailsAllotChangeNetId: FloatInput """Central Xchange Date""" allotmentchangesnetDetailsCXchangeDate: DateInput """DSI Internal Data Source ID to identify Opera Chain and instance""" allotmentchangesnetDetailsDsi: FloatInput """Insert Date""" allotmentchangesnetDetailsInsertDate: DateTimeInput """JRN Update Date and Time""" allotmentchangesnetDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" allotmentchangesnetDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" allotmentchangesnetDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" allotmentchangesnetDetailsResort: StringInput! @mandatoryInput """Stay Date""" allotmentchangesnetDetailsStayDate: DateInput! @mandatoryInput """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 """Agent Contact Name ID""" allotmentDetailsAgentContactNameId: FloatInput """Agent Name ID""" allotmentDetailsAgentNameId: FloatInput """Block Code""" allotmentDetailsAllotmentCode: StringInput """Block ID""" allotmentDetailsAllotmentHeaderId: FloatInput """Block Owner Code""" allotmentDetailsOwnerCode: StringInput """External S&C vendor booking ID and used in HYATT-mode.""" allotmentDetailsBookingId: StringInput """Booking Status Order""" allotmentDetailsBookingStatusOrder: FloatInput """Determines block being [G] - Group or [W] - Wholesale.""" allotmentDetailsBlockType: StringInput """Central Xchange Date""" allotmentDetailsCXchangeDate: DateInput """Chain Code""" allotmentDetailsChainCode: StringInput """Company Name ID""" allotmentDetailsCompanyNameId: FloatInput """Contact Name ID""" allotmentDetailsContactNameId: FloatInput """Created Date""" allotmentDetailsInsertDate: DateTimeInput """DSI Internal Data Source ID to identify Opera Chain and instance""" allotmentDetailsDsi: FloatInput """Due Date Sorting Column.""" allotmentDetailsDueDateOrd: DateInput """End Date""" allotmentDetailsEndDate: DateInput """Insert User""" allotmentDetailsInsertUser: FloatInput """STAR MODE: ISAC opportunity ID.""" allotmentDetailsIsacOpptyId: StringInput """JRN Update Date and Time""" allotmentDetailsJrnupdatedttm: DateTimeInput """Market Code""" allotmentDetailsMarketCode: StringInput """Parent Block ID""" allotmentDetailsSuperBlockId: FloatInput """Parent Resort""" allotmentDetailsSuperBlockResort: StringInput """Profile Id. ( Name_Id ) of the Group Profile attached to this business block.""" allotmentDetailsMasterNameId: FloatInput """Internal ID to uniquely identify the Organization""" allotmentDetailsOrganizationid: FloatInput """ORMS Block Class""" allotmentDetailsOrmsBlockClass: StringInput """Owner""" allotmentDetailsOwner: FloatInput """Code to uniquely identify the Property""" allotmentDetailsResort: StringInput """Rate Code""" allotmentDetailsRateCode: StringInput """Reservation Type""" allotmentDetailsGuaranteeCode: StringInput """Room Status""" allotmentDetailsBookingStatus: StringInput """Shoulder End""" allotmentDetailsShoulderEndDate: DateInput """Shoulder Start""" allotmentDetailsShoulderBeginDate: DateInput """Source Name ID""" allotmentDetailsSourceNameId: FloatInput """Start Date""" allotmentDetailsBeginDate: DateInput """Tour Code.""" allotmentDetailsTourcode: StringInput """This is upper-case description of regular description column for fast search""" allotmentDetailsUdescription: StringInput """Updated Date""" allotmentDetailsUpdateDate: DateTimeInput """Multi Byte Description in uppercase""" allotmentDetailsXudescription: StringInput } type Query { """Detailed information on blocks and any changes to the number of rooms or revenue by stay date property and Block Owner.""" bookingsBlockProductionChanges(limit: Int offset: Int input: BookingsBlockProductionChangesQueryArgumentsType!): [BookingsBlockProductionChangesType] } type BookingsBlockProductionChangesType { """Block Changes Net""" blockChangesNetDetails: BookingsBlockProductionChangesBlockChangesNetDetailsType """Resort Details""" propertyPropertyDetails: BookingsBlockProductionChangesPropertyPropertyDetailsType """Block""" blockDetails: BookingsBlockProductionChangesBlockDetailsType bookingsBlockProductionChangesRecordCount: Int } type BookingsBlockProductionChangesBlockChangesNetDetailsType { """Block ID""" blockID: Float """System generated number that uniquely identifies a record in this table.""" blockProductionChangeID: Float """Block Status Change Date""" blockStatusChangeDate: Date """Block Status Description at Time of Change""" blockStatusDescriptionAtTimeOfChange: String """Block Status at Time of Change""" blockStatusAtTimeOfChange: String """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Fc Food Revenue""" cFCFoodRevenue: Float """Central Fc Food Revenue Tax""" cFCFoodRevenueTax: Float """Central Fc Non Revenue""" cFCNonRevenue: Float """Central Fc Non Revenue Tax""" cFCNonRevenueTax: Float """Central Fc Other Revenue""" cFCOtherRevenue: Float """Central Fc Other Revenue Tax""" cFCOtherRevenueTax: Float """Central Fc Room Revenue""" cFCRoomRevenue: Float """Central Fc Room Revenue Tax""" cFCRoomRevenueTax: Float """Central Fc Total Revenue""" cFCTotalRevenue: Float """Central Fc Total Revenue Tax""" cFCTotalRevenueTax: Float """Catering Srep""" catSrep: Float """Catering Srep Resort""" catSrepProperty: String """Central Block Status Description at Time of Change""" centralBlockStatusDescriptionAtTimeOfChange: String """Central Block Status at Time of Change""" centralBlockStatusAtTimeOfChange: String """Central Change in FB Revenue Net""" centralChangeInFBRevenueNet: Float """Central Change in FB Revenue Tax""" centralChangeInFBRevenueTax: Float """Central Change in Non Revenue Net""" centralChangeInNonRevenueNet: Float """Central Change in Non Revenue Tax""" centralChangeInNonRevenueTax: Float """Central Change in Other Revenue Net""" centralChangeInOtherRevenueNet: Float """Central Change in Other Revenue Tax""" centralChangeInOtherRevenueTax: Float """Central Change in Room Revenue Net""" centralChangeInRoomRevenueNet: Float """Central Change in Room Revenue Tax""" centralChangeInRoomRevenueTax: Float """Central Change in Total Revenue Net""" centralChangeInTotalRevenueNet: Float """Central Change in Total Revenue Tax""" centralChangeInTotalRevenueTax: Float """Change in FB Revenue Net""" changeInFBRevenueNet: Float """Change in FB Revenue Tax""" changeInFBRevenueTax: Float """Change in Non Revenue Net""" changeInNonRevenueNet: Float """Change in Non Revenue Tax""" changeInNonRevenueTax: Float """Change in Other Revenue Net""" changeInOtherRevenueNet: Float """Change in Other Revenue Tax""" changeInOtherRevenueTax: Float """Change in Room Nights""" changeInRoomNights: Float """Change in Room Revenue Net""" changeInRoomRevenueNet: Float """Change in Room Revenue Tax""" changeInRoomRevenueTax: Float """Change in Total Revenue Net""" changeInTotalRevenueNet: Float """Change in Total Revenue Tax""" changeInTotalRevenueTax: Float """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Exchange Date""" exchangeDate: Date """FC Food Revenue""" fcFoodRevenue: Float """FC Food Revenue Tax""" fcFoodRevenueTax: Float """FC Non Revenue""" fcNonRevenue: Float """FC Non Revenue Tax""" fcNonRevenueTax: Float """FC Other Revenue""" fcOtherRevenue: Float """FC Other Revenue Tax""" fcOtherRevenueTax: Float """FC Room Revenue""" fcRoomRevenue: Float """FC Room Revenue Tax""" fcRoomRevenueTax: Float """FC Total Revenue""" fcTotalRevenue: Float """FC Total Revenue Tax""" fcTotalRevenueTax: Float """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Laptop Change""" laptopChange: Float """Internal ID to uniquely identify the Property""" locationID: String """Main Srep""" mainSrep: Float """Main Srep Property""" mainSrepResort: 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 """Quoted Currency Code""" quotedCurrencyCode: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Rooms Srep""" roomsSrep: Float """Rms Srep Property""" roomsSrepResort: String """Stay Date""" stayDate: Date """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type BookingsBlockProductionChangesPropertyPropertyDetailsType { """The property that the record belongs to""" property: String """Number format of AR account no.""" aRAccountNoFormat: String """Specifies if the AR acct No is mandatory(Y/N)""" aRAccountNumberMandatoryYN: String """Default Account Type for an Agent for the Property""" aRAgent: String """Internal""" aRBalanceTrxCode: String """Default Account Type for a Company for the Property""" aRCompany: String """Internal""" aRCreditTrxCode: String """Default Account Type for a Group for the Property""" aRGroups: String """Default Account Type for Individual for the Property""" aRIndividuals: String """Internal""" aRSettleCode: String """Internal""" aRTypewriter: String """Access Code""" accessCode: String """Number of handicapped rooms.""" accessibleRooms: Float """Aging bucket 1""" agingLevel1: Float """Aging bucket 2""" agingLevel2: Float """Aging bucket 3""" agingLevel3: Float """Aging bucket 4""" agingLevel4: Float """Aging bucket 3""" agingLevel5: Float """The Airport Code for the airport near the property""" airport: String """Distance of the Airport specified in the AIRPORT_CODE column from the Property""" airportDistance: String """Time it takes to travel the distance between the Property and the Airport specified in AIRPORT_CODE column""" airportTime: String """Allow loggin in to this resort(Y/N)""" allowLoginYN: String """Period for the allowance""" allowancePeriodAdj: String """Internal""" awardsTimeout: Float """Ball Room Area""" ballroomArea: String """No of Ballroom Seats""" ballroomSeats: Float """The base language of the Hotel""" baseLanguage: String """It contains the reservation type to be used when making group block""" block: String """Brand Code of the property.""" brandCode: String """Financial Year of the Property""" budgetMonth: Float """The date this resort becomes valid for use by the system""" businessDate: Date """Value for the parameter.""" businessID: String """Value for the parameter.""" businessRegistrationCode: String """Code for the CRO""" cROCODE: String """Internal""" cashShiftDrop: String """Catering Currency Code used when Catering Currency differs from base currency.""" cateringCurrencyCode: String """Catering currency format.""" cateringCurrencyFormat: String """Central Exchange Date""" centralXchangeDate: Date """Central Exchange Rate""" centralXchangeRate: Float """Central Credit Limit""" centralCreditLimit: Float """Central Currency Code""" centralCurrencyCode: String """Central Currency Description""" centralCurrencyDescription: String """Central Double Rate2""" centralDblRate2: Float """Central Double Rate1""" centralDblRate1: Float """Central Passerby Market""" centralPasserbyMarket: String """Central Passerby Source""" centralPasserbySource: String """Central Property Type""" centralPropertyType: String """Central Sgl Rate1""" centralSglRate1: Float """Central Sgl Rate 2""" centralSglRate2: Float """Central State""" centralState: String """Central State Description""" centralStateDescription: String """Central Sui Rate1""" centralSuiRate1: Float """Central Sui Rate 2""" centralSuiRate2: Float """Central Tpl Rate1""" centralTplRate1: Float """Central Tpl Rate 2""" centralTplRate2: Float """Central Warning Amount""" centralWarningAmount: Float """Chain Code for the chain to which the property belongs""" chainCode: String """The description of this chain.""" chainDescription: String """Chain Mode""" chainMode: String """Internal""" checkExgPaidout: String """The Hotel official check out time""" checkOutTime: DateTime """Internal""" checkShiftDrop: String """Internal""" checkTrxcode: String """The Hotel official check intime""" checkInTime: DateTime """The physical city in which this property resides.""" city: String """City Description""" cityDescription: String """Internal""" comAddress: String """Internal""" comMethod: String """Internal""" comNameXrefId: Float """Internal""" companyAddressType: String """Internal""" companyPhoneType: String """Internal""" configurationMode: String """Internal""" confirmRegcardPrinter: String """Number of connecting rooms.""" connectingRooms: Float """The unique name of application user""" contacts: String """Number of copies to be printed""" copies: Float """Country name.""" country: String """The name of the country in which this property resides.""" countryCode: String """Value for the parameter.""" countryMode: String """The default credit limit for guests.""" creditLimit: Float """Currency Code.""" currencyCode: String """Currency Symbol like $ or EURO symbol""" currencyCodeSymbol: String """A description of this currency.""" currencyDescription: String """Format for the local currency.""" currencyFormat: String """Color that of the background""" curtainColor: String """DSI""" dSI: Float """Date the aging should begin""" dateForAging: String """Type of separator to distinguish between DD MM and YYYY""" dateSeparator: String """Number of places for the default currency""" decimalPlaces: Float """Type of decimal separator""" decimalSeparator: String """Number of decimals to designate currency""" decimals: Float """Folio style to be used for all guests""" defaultFolioStyle: Float """Default guest address format.""" defaultGuestAddress: String """Future use""" defaultMembershipType: String """Future use""" defaultPostingRoom: String """Default property address format.""" defaultPropertyAddress: String """Future use""" defaultRateCode: String """Rate code used to default a PCR rate code used in FIT Contracts.""" defaultRatecodePcr: String """Rate code used to default a RACK rate code used for FIT Contracts.""" defaultRatecodeRack: String """Default registration card for the property.""" defaultRegistrationCard: String """The Default reservation type for this property""" defaultReservationType: String """Deleted Flag""" deletedFlag: String """Future use""" depositLedgerTrxCode: String """Destination ID""" destinationId: String """Future use""" dfltPkgTranCode: String """Future use""" dfltTranCodeRateCode: String """Internal""" directions: String """Future use""" dirsales: String """LOGIN into the application is disabled.""" disableLoginYN: String """Number of double rooms.""" doubleRooms: Float """Download Rest YN""" downloadRestYN: String """Pager number for the Manager on duty for the property.""" dutyManagerPager: String """Email id for the property.""" email: String """Future use.""" endDate: Date """Default Exchange posting status for the property""" exchangePostingType: String """Floor number of executive floor.""" executiveFloorNumber: String """Hotel code used for third party exports""" expHotelCode: String """Future use""" extExpFileLocation: String """Future use""" extPropertyCode: String """Indicates that the property uses an external SC system.""" externalSCYN: String """Number of family rooms.""" familyRooms: Float """Fax number formats.""" faxNoFormat: String """The fax phone number""" faxNumber: String """Future use""" fiscalEndDate: Date """Future use""" fiscalPeriodType: String """Future use""" fiscalStartDate: Date """Fiscal Year Begin Month""" fiscalYearBeginMonth: Float """Fiscal Year Begin Year""" fiscalYearBeginYear: Float """Screen Painter flags to indicate whether an item is changable/ movable etc.""" flags: String """Future use""" flowCode: String """Property Free Nights Stay Tier.""" fnsTier: String """Other languages""" folioLanguage1: String """Other languages""" folioLanguage2: String """Other languages""" folioLanguage3: String """Other languages""" folioLanguage4: String """Future use""" genmgr: String """To define an upper limit to the number of rooms for Group""" groupRoomWarning: Float """Future use""" guestLookupTimeout: Float """Number of guest elevators.""" guestRoomElevators: Float """Total of guest rooms floors.""" guestRoomFloors: Float """Future use""" hotelCode: String """Future use""" hotelFC: String """Hotel id""" hotelID: String """Future use""" hotelType: String """Future use""" iMGDirectionID: Float """Future use""" iMGHotelID: Float """Future use""" iMGMapID: Float """Future use""" inactiveDaysForGuestProfile: Float """Inactive Flag""" inactiveFlag: String """Future use""" individualAddressType: String """Future use""" individualPhoneType: String """To define an upper limit to the number of rooms for group""" individualRoomWarning: Float """The date the record was created""" insertDate: DateTime """The user that created the record""" insertUser: Float """Int Tax Included YN""" intTaxIncludedYN: String """Future use""" inventoryYN: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """To calculate the entire availability of the Hotel for future reservations""" keepAvailability: Float """Latitude of the property in decimal""" latitude: Float """Future use""" leadsend: String """The owner who owns this property""" legalOwner: String """The property that the record belongs to""" locationID: String """Long date format for the property.""" longDateFormat: String """The default length of stay""" longStayControl: Float """Longitude of the property in decimal""" longitude: Float """Maximum adults in family rooms.""" maxAdultsInFamilyRoom: Float """Maximum children in family rooms.""" maxChildrenInFamilyRoom: Float """Future use""" maxOccupancy: Float """Maximum number of days that are allowed to credit a bill. (Country requirements.) Used in CASHIERING MODULE.""" maximumCreditDays: Float """Indicates whether the property supports MBS. Used in some file exports.""" mbsSupportedYN: String """Future use""" meetRooms: Float """Future use""" meetSeats: Float """Future use""" meetSpace: Float """Future use""" meetingFC: String """Minimum days for reminder letter.""" minDaysBet2ReminderLetter: Float """Internal""" nameIdLink: Float """Future use""" nightAuditCashierID: String """Number of non smoking rooms.""" nonSmokingRooms: Float """Notes for the property""" noteDetails: String """Total number of beds in this property""" numberOfBeds: Float """Total number of floors in this property""" numberOfFloors: Float """Number of Rooms""" numberOfRooms: Float """Future use""" opusCurrencyCode: String """Organization ID""" organizationID: Float """Organization Internal ID""" organizationInternalID: Float """Future use""" ownership: String """Package Loss code for a particular package""" packageLoss: String """Package Profit code for a particular Package""" packageProfit: String """Parent Org Code""" parentOrgCode: String """Market code""" passerbyMarket: String """Source code""" passerbySource: String """Path""" path: String """Minimim Payment Date for the Property used in Cross Property Postings. This will get updated while running the user defined procedure during the night audit process.""" paymentDate: DateTime """Future use""" perReservationRoomLimit: Float """The direct dial phone number of this property""" phoneNumber: String """The postal code of this property.""" postalCode: String """Primary Key ID""" primaryKeyID: Float """URL where property information is located.""" proinfoUrl: String """Property MAP URL.""" propMapUrl: String """Property picture URL.""" propPicUrl: String """The property that the record belongs to""" propertyCode: String """The name of this property.""" propertyName: String """Type of resort.""" propertyType: String """Future use""" quotedCurrency: String """RNA Insert Date""" rNAInsertdate: DateTime """RNA Update Date""" rNAUpdatedate: DateTime """Minimim last Reconciliation Date for the Property used in Cross Property Postings. This will get updated while running the user defined procedure during the night audit process.""" reconcileDate: DateTime """Future use""" regionCode: String """Description of the Region.""" regionDescription: String """Future use""" restaurant: Float """Total number of Sheets""" rhythmSheets: Float """Total number of Towels""" rhythmTowels: Float """Room amenity.""" roomAmenities: String """Future use""" sGLNum: String """Future use""" sGLRate1: Float """Future use""" sGLRate2: Float """Future use""" sUINum: String """Future use""" sUIRate1: Float """Future use""" sUIRate2: Float """To store number of days before deleting the gest profile""" saveProfiles: Float """Future use""" scriptID: Float """Future use""" season1: String """Future use""" season2: String """Future use""" season3: String """Future use""" season4: String """Future use""" season5: String """Indicates that the property accepts leads as bookings.""" sendLeadAsBooking: String """Shop description.""" shopDescription: String """Short date format for the property.""" shortDateFormat: String """Number of single rooms.""" singleRooms: Float """For default commission percentage""" sourceCommission: String """The state in which this property is located.""" state: String """Description of the state.""" stateDescription: String """The street of the property.""" street: String """Number of suites.""" suites: Float """Internal""" summCurrencyCode: String """For default commission percentage""" tACommission: String """Future use""" tPLNum: String """Future use""" tPLRate1: Float """Future use""" tPLRate2: Float """Formats for telephone number""" telephoneNoFormat: String """Separator for monetory values""" thousandSeparator: String """Default time format for the property.""" timeFormat: String """Time zone region selected by the employee.""" timeZone: String """Toll free telephone number.""" tollFree: String """Future use""" totalRooms: Float """Tourist Number""" touristNumber: String """Indicates whether the property handles multi byte characters and whether they are translateable or not""" translateMulticharYN: String """Turnaway code for the property.""" turnawayCode: String """Number of twin rooms.""" twinRooms: Float """The date the record was modified""" updateDate: DateTime """The user that modified the record""" updateUser: Float """VAT ID of this property.""" vatID: String """Future use""" videoCheckoutPrinter: String """Video check out start time.""" videoCheckoutStart: DateTime """Video check out end time.""" videoCheckoutStop: DateTime """Future use""" wakeUpDelay: Float """Amount at which warning is raised.""" warningAmount: Float """Webaddress of the property""" web: String """Weekend days for the property.""" weekendDays: String """Internal""" zeroInvPurDays: Float } type BookingsBlockProductionChangesBlockDetailsType { """Action ID""" actionId: Float """Actual Average Room Rate""" actualAverageRoomRate: Float """Actual F&B Revenue""" actualFBRevenue: Float """Other revenue""" actualOtherRevenue: Float """Actual Room Nights Sold""" actualRoomNightsSold: Float """Actual revenue of the room""" actualRoomRevenue: Float """Add Info""" addInfo: String """Agent Contact Name ID""" agentContactNameId: Float """Agent Name ID""" agentNameId: Float """Agentprofileid""" agentprofileid: Float """All Aliases""" allAliases: String """All Block Owners""" allBlockOwners: String """All Catering Owners""" allCateringOwners: String """All Company Contacts""" allCompanyContacts: String """All Rate Codes""" allRateCodes: String """All Room Owners""" allRoomOwners: String """All Room Pools""" allRoomPools: String """All Room Types""" allRoomTypes: String """All Source Contacts""" allSourceContacts: String """All Travel Agent Contacts""" allTravelAgentContacts: String """Allotment Origin""" allotmentOrigin: String """Type of Block alloted for the group.""" allotmentType: String """Allotmentcurrencyid""" allotmentcurrencyid: String """Block ID""" allotmentid: Float """Allow a pickup for a group with this booking status""" allowPickup: String """Multi Byte Description Field""" alternateBlockName: String """Alternate Dates""" alternateDates: String """Arrival Time""" arrivalTime: DateTime """URL pointing to Lead Attachments.""" attachmentURL: String """Attendees Guaranteed""" attendeesGuaranteed: Float """Indicates if forecast figures should be automatically loaded for this business block.""" autoLoadForecastYn: String """Average Rate""" averageRate: Float """Date when the BEO report was last printed for this business block.""" bEOLastPrint: DateTime """Stores the original block begin date. Any date ealier will be treated as a Shoulder date.""" beginDateOriginal: Date """Block Alias""" blockAlias: String """Block Code""" blockCode: String """Block Date Actual""" blockDateActual: Date """Block Date Definite""" blockDateDefinite: DateTime """Block Date Prospect""" blockDateProspect: DateTime """Block Date Tentative""" blockDateTentative: DateTime """Block Description""" blockDescription: String """Block ID""" blockID: Float """Classifies this allotment record: MASTER_ALLOCATION SUB_ALLOCATION SUB_BOOKING SUB_TOUR SUB_ITINERARY""" blockMode: String """Block Owner Code""" blockOwnerCode: String """Block Owner Full Name""" blockOwnerFullName: String """Block Package""" blockPackage: String """Block Package Description""" blockPackageDescription: String """Block Status""" blockStatus: String """Block Status Description""" blockStatusDescription: String """Block Type Code""" blockTypeCode: String """Block Type Code Description""" blockTypeCodeDescription: String """Blockpackageid""" blockpackageid: String """External S&C vendor booking ID and used in HYATT-mode.""" bookingId: String """Booking Method Order By""" bookingMethodOrderBy: Float """Booking Status Order""" bookingStatusOrder: Float """Determines block being [G] - Group or [W] - Wholesale.""" bookingType: String """Booking Type Description""" bookingTypeDescription: String """Bookingmethod Inactive Date""" bookingmethodInactiveDate: Date """Bookingsourceid""" bookingsourceid: String """Bookingstatusid""" bookingstatusid: String """Bookingtypeid""" bookingtypeid: String """Breakfast Description""" breakfastDescription: String """PCR: The estimated breakfast price for this ratecode.""" breakfastInclPrice: Float """PCR: Is breakfast is included in this rate code?""" breakfastInclYn: String """Breakfast Included""" breakfastIncluded: String """Breakfast Price""" breakfastPrice: Float """BWI eLeadID for tracking purposes.""" bwiLeadId: String """URL populated bu CRS.""" bwiUrl: String """Central Bfst Incl Price""" cBreakfastInclPrice: Float """Central Bfst Price""" cBreakfastPrice: Float """Central Comp Room Value""" cCompRoomValue: Float """Central Dbl Rm Supplement Price""" cDoubleRoomSupplementPrice: Float """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Fb Commission 1""" cFBCommission1: Float """Central Fb Commission 2""" cFBCommission2: Float """Central Porterage Price""" cPorteragePrice: Float """Central Rm Commission 1""" cRoomCommission1: Float """Central Rm Commission 2""" cRoomCommission2: Float """Central Service Charge""" cServiceCharge: Float """Central Service Fee""" cServiceFee: Float """CRS Guaranteed Y/N""" cRSGtdYn: String """Not Used""" cancelRule: String """Canceldestinationid""" canceldestinationid: String """Cancellation Destination""" cancellationDestination: String """Cancellation Destination Description""" cancellationDestinationDescription: String """Cancellation Number""" cancellationNumber: Float """Cancellation Penalty Amount""" cancellationPenaltyAmount: Float """Cancellationreasonid""" cancellationreasonid: String """Catering Cutoff""" catCutoff: Date """Cat Date Prospect""" catDateProspect: DateTime """Catering Owner""" catOwner: Float """Property of Catering Owner""" catOwnerProperty: String """Cat Return To Inventory""" catReturnToInventory: String """Cat Starting Status""" catStartingStatus: String """Catcurrencyid""" catcurrencyid: String """Catering Cancellation Date""" cateringCancellationDate: Date """Catering Cancellation Description""" cateringCancellationDescription: String """Catering Cancellation Number""" cateringCancellationNumber: Float """Catering Cancellation Reason""" cateringCancellationReason: String """Catering Currency""" cateringCurrency: String """Catering Date Actual""" cateringDateActual: Date """Catering Decision Date""" cateringDecisionDate: Date """Catering Deduct Inventory""" cateringDeductInventory: String """Catering Exchange Rate""" cateringExchangeRate: Float """Catering Followup Date""" cateringFollowupDate: Date """Catering only Revenue.""" cateringOnlyYN: String """Catering Order By""" cateringOrderBy: Float """Catering Owner Code""" cateringOwnerCode: String """Catering Owner Full Name""" cateringOwnerFullName: String """Catering Pkgs Y/N""" cateringPkgsYn: String """Catering Quote Currency""" cateringQuoteCurrency: String """Catering Status""" cateringStatus: String """Catering Status Color""" cateringStatusColor: String """Catering Status Description""" cateringStatusDescription: String """Catering Status Type describes Inventory behaviour""" cateringStatusType: String """Cateringcancelreasonid""" cateringcancelreasonid: Float """Cateringcurrencyid""" cateringcurrencyid: String """Catering Owner Employee ID""" cateringowneremployeeid: Float """Catering Quote Currency ID""" cateringquotecurrencyid: String """Cateringstatusid""" cateringstatusid: String """Cenral FB Revenue""" cenralFBRevenue: Float """Central Actual Average Room Rate""" centralActualAverageRoomRate: Float """Central Actual FB Revenue""" centralActualFBRevenue: Float """Central Actual Other Revenue""" centralActualOtherRevenue: Float """Central Actual Room Revenue""" centralActualRoomRevenue: Float """Central Average Room Rate""" centralAverageRoomRate: Float """Central Block Package""" centralBlockPackage: String """Central Block Package Description""" centralBlockPackageDescription: String """Central Block Status""" centralBlockStatus: String """Central Block Status Description""" centralBlockStatusDescription: String """Central Block Type Code""" centralBlockTypeCode: String """Central Block Type Code Description""" centralBlockTypeCodeDescription: String """Central Booking Type""" centralBookingType: String """Central Booking Type Description""" centralBookingTypeDescription: String """Central Cancellation Destination""" centralCancellationDestination: String """Central Cancellation Destination Description""" centralCancellationDestinationDescription: String """Central Cancellation Penalty Amount""" centralCancellationPenaltyAmount: Float """Central Catering Status""" centralCateringStatus: String """Central Catering Status Description""" centralCateringStatusDescription: String """Central Conversion Code""" centralConversionCode: String """Central Coversion Code Description""" centralCoversionCodeDescription: String """Central Industry Code""" centralIndustryCode: String """Central Industry Code Description""" centralIndustryCodeDescription: String """Central Items for this Block""" centralItemsForThisBlock: String """Central Market Description""" centralMarketDescription: String """Central Market code""" centralMarketCode: String """Central Meeting Budget""" centralMeetingBudget: Float """Central Meeting Revenue""" centralMeetingRevenue: Float """Central Origin Code""" centralOriginCode: String """Central Origin Code Description""" centralOriginCodeDescription: String """Central Other Revenue""" centralOtherRevenue: Float """Stores the name and phone number of the primary central owner.""" centralOwner: String """Central Payment""" centralPayment: String """Central Payment Description""" centralPaymentDescription: String """Central Ranking Code""" centralRankingCode: String """Central Ranking Code Description""" centralRankingCodeDescription: String """Central Reservation Method Code""" centralReservationMethodCode: String """Central Reservation Method Description""" centralReservationMethodDescription: String """Central Reservation Type""" centralReservationType: String """Central Reservation Type Description""" centralReservationTypeDescription: String """Central Room Revenue""" centralRoomRevenue: Float """Central Source Code""" centralSourceCode: String """Central Source Code Description""" centralSourceCodeDescription: String """Central Tax Amount""" centralTaxAmount: Float """Chain Code""" chainCode: String """Channelid""" channelid: String """Code""" code: String """Communication Address for Contact 1 (E-mail / Fax #)""" comAddress: String """Communication Address for Contact 2 (E-mail / Fax #)""" comAddress2: String """Communication Address for Contact 3 (E-mail / Fax #)""" comAddress3: String """How this lead is to be sent. [EMAIL|FAX|PRINT]""" comMethod: String """How this lead is to be sent. [EMAIL|FAX|PRINT|DATA]""" comMethod2: String """How this lead is to be sent. [EMAIL|FAX|PRINT|DATA]""" comMethod3: String """Commission Amount""" commissionAmount: String """PCR: Commissionable Percentage.""" commissionablePerc: Float """Commissionable Y/N""" commissionableYn: String """Complimentary Rooms based per Stay (Y) or per Night (N)""" compPerStayYn: String """Complimentary Rooms: Value given to Customer""" compRoomValue: Float """Number of complimentary Rooms""" compRooms: Float """Complimentary Rooms: Fixed amount (Y) or calculated (N)""" compRoomsFixedYn: String """Company All""" companyAll: String """Company Name ID""" companyNameId: Float """Companyprofileid""" companyprofileid: Float """Competition""" competition: String """Contact Name ID""" contactNameId: Float """Contactprofileid""" contactprofileid: Float """Contract Number""" contractNumber: String """Control Block Y/N""" controlBlockLocally: String """Conversion Code""" conversionCode: String """Coversion Code Description""" coversionCodeDescription: String """The name of the user who created the record.""" createdBy: String """Created Date""" createdDate: DateTime """Indicates if the block was created as an Opportunity""" createdAsOpportunityYN: String """Credit Card ID""" creditCardId: Float """Currency""" currency: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Date Acl""" dateAcl: Date """Date Cfl""" dateCfl: Date """Date Definite""" dateDefinite: DateTime """Date Lsl""" dateLsl: Date """Date Opened for Pickup""" dateOpenedForPickup: Date """Date Pel""" datePel: DateTime """Date Tdl""" dateTdl: DateTime """Date Tentative""" dateTentative: DateTime """Stores the double room supplement price.""" dblRoomSupplementPrice: Float """Deduct the reservations with this booking status from the inventory""" deductInventory: String """Defualt Posting Master ID""" defaultPmReservationNameId: Float """Deleted Flag""" deletedflag: String """Departure Time""" departureTime: DateTime """Description""" description: String """Distributed""" distributed: String """Timestamp of the last date/time the distributed_yn flag was set to Y.""" distributedDate: DateTime """Dml Sequence No""" dmlSeqNumber: Float """Stores the double room supplement.""" doubleRoomSupplementYN: String """Download Date""" downloadDate: Date """Download Property""" downloadResort: String """Download Srep""" downloadSrep: Float """Due Date""" dueDate: Date """Due Date Sorting Column.""" dueDateOrd: Date """End Date""" endDate: Date """Stores the original block End date. Any date later will be treated as a Shoulder date.""" endDateOriginal: Date """Endbusinessdate""" endbusinessdate: Date """Event Attendees""" eventAttendees: Float """Exchange Posting Type""" exchangePostingType: String """Exchange Rate""" exchangeRate: Float """The message that will pop up if the block is excluded (not allowed) to modify/create reservation/cancel reservation.""" exclusionMessage: String """External Reference""" externalReference: String """External RFP ID.""" externalRfpId: String """External RFP System Identification Code.""" externalRfpSystem: String """Externally Locked""" externallyLocked: String """Projected F&B Revenue.""" fBRevenue: Float """Currency code for the F&B Agendas attached to the business block.""" fbAgendaCurrency: String """stores FB commission for Agent 1""" fbCommission1: Float """stores FB commission for Agent 2""" fbCommission2: Float """Operation Mode for FIT Contracts [ SFA=SFA control RC=Ratecode RA=RateAmounts ]""" fitContractMode: String """Fit Discount Level.""" fitDiscountLevel: Float """Published Corporate Rate: Discount Percentage.""" fitDiscountPerc: Float """Fitdiscounttype""" fitdiscounttype: String """Determines if rate check is done for Occ1 or Occ1 and Additional Rate.""" flatRateYn: String """Followup Date""" followupDate: Date """Can the Function space booked under master allocation or master block be overbooked by sub-allocations or sub-blocks ?""" fsOverbookingYn: String """Function Type""" functionType: String """Group IATA Number.""" giid: String """Greek Contract Number.""" greekContractNr: String """Group Account ID""" groupAccountID: Float """Guaranteecodeid""" guaranteecodeid: String """Rate Guaranteed Y/N.""" guaranteedRate: String """Guaranteed YN""" guaranteedYN: String """Hideacctinfoflag""" hideacctinfoflag: String """SCH Mode: Number of days before the arrival date a reservation can be canceled without losing the deposit.""" hlxCanxNoticeDays: Float """SCH Mode: Determines if Travel Agent commission will be paid on reservations booked through the HOLIDEX Plus TACP program.""" hlxCommissionableYn: String """SCH Mode: All Description DD Secured.""" hlxDdSecuredYn: String """SCH Mode: Number of Days Deposit due to guarantee the guest booking.""" hlxDepositDays: Float """SCH Mode: Secured from DI Display.""" hlxDiSecuredYn: String """SCH Mode: Housing Information Secured.""" hlxHousinginfoSecuredYn: String """SCH Mode: Rates Secured from All Displays""" hlxRateAllSecuredYn: String """SCH Mode: Rates Secured from GNR.""" hlxRatesGnrSecuredYn: String """SCH Mode: Return One Day at a time.""" hlxReturnEachDayYn: String """Inactive Date""" inactiveDate: Date """Inactive Flag""" inactiveflag: String """Indicates the Non-Compete code of a block.""" industryCode: String """Industry Code Description""" industryCodeDescription: String """Not Used""" info: String """Information Board""" informationBoard: String """Insert User""" insertUser: Float """Inventory Control""" inventoryControl: String """Inventory Cut-Off Date""" inventoryCutOffDate: Date """Inventory Cut-Off Days""" inventoryCutOffDays: Float """STAR MODE: ISAC opportunity ID.""" isacOpptyId: String """Items""" items: String """Items for this Block""" itemsForThisBlock: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """If set to ?Y? lead will not be converted to booking upon lead sending.""" keepLeadControlYN: String """Laptop Change""" laptopChange: Float """Lead Origin""" leadOrigin: String """Lead Sent YN""" leadSentYN: String """Lead Source""" leadSource: String """Lead Type""" leadType: String """Indication that the Property has updated the Lead Information will prevent further SFA updates.""" leadchangeBypropertyYn: String """Leaderrorflag""" leaderrorflag: String """Leadisnewflag""" leadisnewflag: String """Leadoriginid""" leadoriginid: String """Leadreceivedflag""" leadreceivedflag: String """Name of Contact 1 (Free text or from RESORT_CONTACTS)""" leadsend: String """Name of Contact 2 (Free text or from RESORT_CONTACTS)""" leadsend2: String """Name of Contact 3 (Free text or from RESORT_CONTACTS)""" leadsend3: String """Leadserverpendingflag""" leadserverpendingflag: String """Leadsourceid""" leadsourceid: String """Leadstatus""" leadstatus: String """STAR MODE: Date when the OPERA block was linked to an ISAC opportunity.""" linkDate: Date """Internal ID to uniquely identify the Property""" locationID: String """Competitor to whom the booking was lost.""" lostTo: String """Mainmarket""" mainmarket: String """Mainmarketid""" mainmarketid: String """Block was cutoff manullay""" manuallyCutoffYN: String """MARRIOTT mode: Marsha Event Type.""" marEventType: String """MARRIOTT mode: Marsha column for Housing Protected.""" marHouseProtectYn: String """MARRIOTT mode: Specifies if the Marsha block has a rolling end date.""" marRollEndDateYn: String """Market Code""" marketCode: String """Market Description""" marketDescription: String """Marketid""" marketid: String """Parent Block ID""" masterBlockID: Float """Parent Resort""" masterBlockProperty: String """Profile Id. ( Name_Id ) of the Group Profile attached to this business block.""" masterNameId: Float """Meeting Budget""" meetingBudget: Float """Meeting Revenue for SFA""" meetingRevenue: Float """Offset Type""" offsetType: String """Order By""" orderBy: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Stores the original ALLOTMENT_HEADER_ID prior to a migration.""" origAllotmentHeaderId: Float """Origin Code""" originCode: String """Origin Code Description""" originCodeDescription: String """Original Block Start Date used as identifier in the HOLIDEX interface.""" originalBeginDateHolidex: Date """Original End Date""" originalEndDate: Date """Not used""" originalRateCode: String """Original Start Date""" originalStartDate: Date """Originalratecodeid""" originalratecodeid: String """ORMS Block Class""" ormsBlockClass: String """ORMS Final Block""" ormsFinalBlock: String """Reason for which a review of the ORMS forecast is required. If the value is null it means forecast has been reviewed. If the value is Forecast increased (FI) Forecast decreased (FD) Blocked Rooms increased (BRI) Blocked Rooms decreased (BRD) New block (NB) User required review (URR) then it means forecast has not been reviewed.""" ormsForecastReviewReason: String """ORMS Transient Block""" ormsTransientBlock: String """Projected Other Revenue.""" otherRevenue: Float """Owner""" owner: Float """Owner Property""" ownerResort: String """Owneremployeeid""" owneremployeeid: Float """Ownerlocationd""" ownerlocationd: String """Parentallotmentid""" parentallotmentid: Float """Payment""" payment: String """Payment Description""" paymentDescription: String """Paymentmethodid""" paymentmethodid: String """Persons Per Room""" personsPerRoom: Float """Porterage Included""" porterageIncluded: String """Porterage Price""" porteragePrice: Float """Pot Average Room Rate""" potAverageRoomRate: Float """Pot FB Revenue1""" potFbRevenue1: Float """Pot Other Revenue1""" potOtherRevenue1: Float """Projected Room Nights.""" potRoomNights: Float """Pot Room Revenue1""" potRoomRevenue1: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Print Rate""" printRate: String """Profile ID""" profileId: Float """Program""" program: String """Code to uniquely identify the Property""" property: String """Indicates if events in webProposal should be combined in the generated XML.""" proposalCombineEventsYn: String """Decision Date Selection: [R]ooms Decision Date / [C]atering Decision Date.""" proposalDecisionSelection: String """Stores the user choice for either [R]ooms or [C]atering follow-up date to be passed to webProposal. NULL is treated as Rooms follow-up date.""" proposalFollowupSelection: String """If Y then Alternate Names will be used in the webProposal XML tags for and .""" proposalInclAltNamesYn: String """Owner Selection: [O]verall Owner / [R]ooms Owner / [C]atering Owner.""" proposalOwnerSelection: String """Proposal Sent Date""" proposalSentDate: DateTime """Show price per event on webProposal.""" proposalShowEventpriceYn: String """Show PMS roomtypes on webProposal otherwise S&C roomtypes are shown.""" proposalShowPmsRoomTypeYn: String """Show function space names on webProposal.""" proposalShowSpacenameYn: String """Unit of measurement used for function spaces in webProposal XML. Possible values: METRIC IMPERIAL or NONE.""" proposalSpaceMeasurement: String """Proposal View Token""" proposalViewToken: String """Indicates that negotiated rates need to be published.""" publishRatesYn: String """Indicates the ranking of a block.""" rankingCode: String """Ranking Code Description""" rankingCodeDescription: String """Rate Code""" rateCode: String """Indicates if the rate code can be overridden.""" rateOverride: String """Reason why the rate code was overridden used for FIT Contracts.""" rateOverrideReason: String """Indicates that a Rate Protection exists for this booking: [A]ll [S]ome [N]one. No other group can be booked using rates lower than the one that is flagged as rate protect.""" rateProtect: String """Rate Tier""" rateTier: Float """Ratecodeid""" ratecodeid: String """Ready for Distribution""" readyForDistribution: String """Indicates if a lead has been regenerated (copied and lost) by the system and differentiates between leads that have been lost by the user or due to changes to the lead master.""" regeneratedLeadYn: String """Rep Bookingmethod Orderby""" repBookingmethodOrderby: Float """Rep Bs Order By""" repBsOrderBy: Float """Rep Cat Order By""" repCatOrderBy: Float """Reply Date""" replDate: DateTime """Reply Communication Method""" replVia: String """Lead Replystatus [ACL|TDL]""" replstatus: String """Reply By""" replyBy: Float """Representative""" representative: String """Reservation Method""" reservationMethod: String """Reservation Type""" reservationType: String """The Description of the Guarantee code.""" reservationTypeDescription: String """Reservationid""" reservationid: Float """Reserve Inventory YN""" reserveInventoryYN: String """Final resort where Booking is confirmed -via Lead process.""" resortBooked: String """Default discount percentage applied to catering items.""" resourceDiscountPercent: Float """Response Time.""" respTime: Float """The unit of time (from UNIT_OF_TIME table).""" respTimeCode: String """Return the reservations with this booking status from the inventory""" returnToInventory: String """Not used""" rivMarketSegment: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """stores Rooms commission for Agent 1""" roomCommission1: Float """stores Rooms commission for Agent 2""" roomCommission2: Float """Room Nights Sold""" roomNightsSold: Float """Room Owner Code""" roomOwnerCode: String """Room Owner Full Name""" roomOwnerFullName: String """Projected Room Revenue.""" roomRevenue: Float """Transaction Code for posting room revenue from blocked reservations.""" roomRevenueTransactionCode: String """Room Status""" roomStatus: String """Rooming List Due""" roomingListDue: Date """Stores Rooming List Rules.""" roomingListRules: String """Rooms Cancellation Date""" roomsCancellationDate: Date """Rooms Cancellation Reason""" roomsCancellationReason: String """Rooms Cancellation Reason Description""" roomsCancellationReasonDescription: String """Rooms Currency""" roomsCurrency: String """Rooms Decision Date""" roomsDecisionDate: Date """Rooms Exchange Rate""" roomsExchangeRate: Float """Rooms Owner""" roomsOwner: Float """Property of Rooms Salesmanager""" roomsOwnerResort: String """Rooms Per Day""" roomsPerDay: Float """Rooms Quote Currency""" roomsQuoteCurrency: String """Roomsowneremployeeid""" roomsowneremployeeid: Float """Not used""" salesId: String """Sbegindate""" sbegindate: Date """Quote ID reference for the last printed catering quote report (S&C Quotation Report).""" scQuoteId: String """Sell Thru Indicator.""" sellThruYn: String """Identifies if a business block needs to be send to Central based on KEY_PROFILE_YN in NAME.""" sendToCentralYn: String """Senddate""" senddate: Date """Sent By""" sentBy: Float """Sent Date""" sentDate: DateTime """Sent Via""" sentVia: String """Service Charge""" serviceCharge: Float """Service Fee Amount per room/night""" serviceFee: Float """Service Fee applies?""" serviceFeeYn: String """PCR: Are Service Charges included in this rate code?""" serviceInclYn: String """Service Percentage included.""" servicePerc: Float """Shoulder End""" shoulderEnd: Date """Shoulder Start""" shoulderStart: Date """Flag used to show or hide rate column in Block Grid and used as default by block reservations.""" showRateAmountYN: String """Snapshot has been created""" snapshotSetup: String """Source Code""" sourceCode: String """Source Code Description""" sourceCodeDescription: String """Source Contact All""" sourceContactAll: String """Source Name ID""" sourceNameId: Float """Sourceid""" sourceid: Float """Sourceprofprofileid""" sourceprofprofileid: Float """Start Date""" startDate: Date """Booking starting status (intial pickup)""" startingStatus: String """Status""" status: String """Status Color""" statusColor: String """Type of booking status (initial)""" statusType: String """Sub Allocation YN""" subAllocationYN: String """Super Search Index Text""" superSearchIndexText: String """Suppress Rate""" suppressRate: String """Indicates if original grid will be copied to contract grid. Performed in the allotment_detail trigger.""" syncContractYn: String """Synchronize Sub-Blocks with Master Block if Y""" synchronize: String """Tax Amount""" taxAmount: Float """Percentage of included Tax.""" taxIncludedPerc: Float """Tax is included in this rate.""" taxIncludedYn: String """Tax Type""" taxType: String """Taxtypeid""" taxtypeid: String """To be Determined Rates""" tbdRates: String """Tdl Reason""" tdlReason: String """Not used""" tentativeLevel: Float """Stores the TLPe - Response ID""" tlpResponseid: String """Stores the TLPe - Result URL.""" tlpUrl: String """Tour Code.""" tourCode: String """Trace Code""" traceCode: String """Trace Description""" traceDescription: String """Indicate that no other block of the same industry can be booked for the selected dates.Non-Compete indicator : [A]ll [S]ome [N]one.""" trackChangesYN: String """Travel Agent All""" travelAgentAll: String """Travel Agent Record Locator""" travelAgentRecordLocator: String """Turndownreasonid""" turndownreasonid: Float """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 """Not in use.""" ualias: String """This is upper-case description of regular description column for fast search""" udescription: String """Update Date by LEAD REPLY.""" updateDateExternal: Date """Update User""" updateUser: Float """Updated By""" updatedBy: String """Updated Date""" updatedDate: DateTime """Upload Date""" uploadDate: Date """Indicates if this business block can be booked via the web (OWS).""" webBookable: String """Indicates if this business block allows overbooking when rooms are available on the non-deduct block grid even if there are no rooms available on the house level.""" webOverbookYN: String """Multi Byte Description in uppercase""" xudescription: String }