# title : OPERA Cloud RnA StatisticsReservationPace GraphQL API,
# description : GraphQL API to cater for The Reservation Pace subject area contains daily rooms and revenue information on reservations on the books as of specific dates in the past (snapshot dates) summarized by Property, PACERATECODE, Room Type, Channel and Rate Code.
#               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. 
# 		 - resvpacefactDetailsResort
# 		 - resvpacefactDetailsSnapshotDate
# 		 - resvpacefactDetailsStayDate


input StatisticsReservationPaceQueryArgumentsType {
  """Channel"""
  resvpacefactDetailsChannel: StringInput
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  resvpacefactDetailsDsi: FloatInput
  """Market Code"""
  resvpacefactDetailsMarketCode: StringInput
  """Internal ID to uniquely identify the Organization"""
  resvpacefactDetailsOrganizationid: FloatInput
  """Code to uniquely identify the Property"""
  resvpacefactDetailsResort: StringInput!                               @mandatoryInput
  """Rate Code"""
  resvpacefactDetailsRateCode: StringInput
  """Room Category"""
  resvpacefactDetailsRoomCategory: StringInput
  """Date the Snapshot was created"""
  resvpacefactDetailsSnapshotDate: DateInput!                           @mandatoryInput
  """Stay Date"""
  resvpacefactDetailsStayDate: DateInput!                               @mandatoryInput
  """Stay Date"""
  pacestaydateDetailsDaykey: DateInput
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  pacemarketDetailsDsi: FloatInput
  """JRN Update Date and Time"""
  pacemarketDetailsJrnupdatedttm: DateTimeInput
  """Market Code"""
  pacemarketDetailsMarketCode: StringInput
  """Market group attached to the market code"""
  pacemarketDetailsParentMarketCode: StringInput
  """Internal ID to uniquely identify the Organization"""
  pacemarketDetailsOrganizationid: FloatInput
  """Code to uniquely identify the Property"""
  pacemarketDetailsResort: StringInput
  """Base Rate Code"""
  paceratecodeDetailsBaseRateCode: StringInput
  """Begin Booking Date"""
  paceratecodeDetailsBeginBookingDate: DateInput
  """Commission Code"""
  paceratecodeDetailsCommissionCode: StringInput
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  paceratecodeDetailsDsi: FloatInput
  """Daily Rates Y/N"""
  paceratecodeDetailsDailyRatesYn: StringInput
  """The rate code on which this rate shedule is dynamically based on."""
  paceratecodeDetailsDbaseRateCode: StringInput
  """End Booking Date"""
  paceratecodeDetailsEndBookingDate: DateInput
  """Group Code"""
  paceratecodeDetailsGroupCode: StringInput
  """JRN Update Date and Time"""
  paceratecodeDetailsJrnupdatedttm: DateTimeInput
  """Indicates the lengh of Stay Unit in days. If value is > 1 then it is a pkg rate code."""
  paceratecodeDetailsLosUnit: FloatInput
  """Market Code"""
  paceratecodeDetailsMarketCode: StringInput
  """Max Los"""
  paceratecodeDetailsMaxLos: FloatInput
  """Max Occupancy"""
  paceratecodeDetailsMaxOccupancy: FloatInput
  """Minimum Occupancy"""
  paceratecodeDetailsMinOccupancy: FloatInput
  """Internal ID to uniquely identify the Organization"""
  paceratecodeDetailsOrganizationid: FloatInput
  """Indicates the order in which this rate should be displayed during the booking process when the ors_rate_sell_sequence functionality is active."""
  paceratecodeDetailsOrsSellSequence: FloatInput
  """Indicates whether the rate code is pending for approval or not"""
  paceratecodeDetailsPendingApprovalYn: StringInput
  """Yield rate bucket"""
  paceratecodeDetailsRateBucket: StringInput
  """Rate Code"""
  paceratecodeDetailsRateCode: StringInput
  """Rate Level this rate code belongs to."""
  paceratecodeDetailsRateLevel: FloatInput
  """Property"""
  paceratecodeDetailsResort: StringInput
  """Sell Sequence"""
  paceratecodeDetailsSellSequence: FloatInput
  """Source Code"""
  paceratecodeDetailsSourceCode: StringInput
  """Not used"""
  paceresortDetailsCrsResort: StringInput
  """Country Code"""
  paceresortDetailsCountryCode: StringInput
  """Currency Code"""
  paceresortDetailsCurrencyCode: StringInput
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  paceresortDetailsDsi: FloatInput
  """JRN Update Date and Time"""
  paceresortDetailsJrnupdatedttm: DateTimeInput
  """Internal"""
  paceresortDetailsNameIdLink: FloatInput
  """Internal ID to uniquely identify the Organization"""
  paceresortDetailsOrganizationid: FloatInput
  """Property"""
  paceresortDetailsResort: StringInput
  """Property Type"""
  paceresortDetailsResortType: StringInput
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  paceroomtypeDetailsDsi: FloatInput
  """JRN Update Date and Time"""
  paceroomtypeDetailsJrnupdatedttm: DateTimeInput
  """Label"""
  paceroomtypeDetailsLabel: StringInput
  """Internal ID to uniquely identify the Organization"""
  paceroomtypeDetailsOrganizationid: FloatInput
  """Code to uniquely identify the Property"""
  paceroomtypeDetailsResort: StringInput
  """Room Class"""
  paceroomtypeDetailsRoomClass: StringInput
  """Room Type"""
  paceroomtypeDetailsRoomCategory: StringInput
  """Yield Category"""
  paceroomtypeDetailsYieldCategory: StringInput
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  pacechannelDetailsDsi: FloatInput
  """Entity Name"""
  pacechannelDetailsEntityName: StringInput
  """JRN Update Date and Time"""
  pacechannelDetailsJrnupdatedttm: DateTimeInput
  """Language Code"""
  pacechannelDetailsLanguageCode: StringInput
  """Internal ID to uniquely identify the Organization"""
  pacechannelDetailsOrganizationid: FloatInput
  """Origin Code"""
  pacechannelDetailsAttributeCode: StringInput
  """Title Suffix"""
  pacechannelDetailsTitleSuffix: FloatInput
  """Snapshot Date Comparison"""
  resvpacesnapshotdimDetailsDaykey: DateInput
}
type Query {
  """The Reservation Pace subject area contains daily rooms and revenue information on reservations on the books as of specific dates in the past (snapshot dates) summarized by Property PACERATECODE Room Type Channel and Rate Code."""
  statisticsReservationPace(limit: Int offset: Int input: StatisticsReservationPaceQueryArgumentsType!): [StatisticsReservationPaceType]
}
type StatisticsReservationPaceType {
  """Reservation Pace Fact"""
  reservationPaceFactDetails: StatisticsReservationPaceReservationPaceFactDetailsType
  """Pace Stay Date Details"""
  paceStayDateDetails: StatisticsReservationPacePaceStayDateDetailsType
  """Pace Market Details"""
  paceMarketDetails: StatisticsReservationPacePaceMarketDetailsType
  """Pace Rate Code Details"""
  paceRateCodeDetails: StatisticsReservationPacePaceRateCodeDetailsType
  """Pace Property"""
  pacePropertyDetails: StatisticsReservationPacePacePropertyDetailsType
  """Pace Room Type Details"""
  paceRoomTypeDetails: StatisticsReservationPacePaceRoomTypeDetailsType
  """Pace Channel Details"""
  paceChannelDetails: StatisticsReservationPacePaceChannelDetailsType
  """Reservation Pace Snapshot"""
  reservationPaceSnapshotDetails: StatisticsReservationPaceReservationPaceSnapshotDetailsType
  statisticsReservationPaceRecordCount: Int
}
type StatisticsReservationPaceReservationPaceFactDetailsType {
  """Arrangement Adults"""
  arrAdults: Float
  """Arrangement Children"""
  arrChildren: Float
  """Arrangement Rooms"""
  arrRooms: Float
  """Amount."""
  budgetAmt: Float
  """Budget Rooms"""
  budgetRooms: Float
  """Central Budget Revenue"""
  cBudgetRevenue: Float
  """C DAG Revenue Ded"""
  cDAGRevenueDed: Float
  """C DAG Revenue Ndd"""
  cDAGRevenueNdd: Float
  """Central Forecast Revenue"""
  cForecastRevenue: Float
  """Central Ly Actual Revenue"""
  cLastYearActualRevenue: Float
  """Central Last Year Revenue"""
  cLastYearRevenue: Float
  """Central Ly Revenue Ndd"""
  cLastYearRevenueNdd: Float
  """Central Ly Room Revenue Blk Ded"""
  cLastYearRoomRevenueBlockDed: Float
  """Central Ly Room Revenue Blk Ndd"""
  cLastYearRoomRevenueBlockNdd: Float
  """Central Ly Room Revenue Res Blk Ded"""
  cLastYearRoomRevenueReservationBlockDed: Float
  """Central Ly Room Revenue Res Blk Ndd"""
  cLastYearRoomRevenueReservationBlockNdd: Float
  """Central Ly Room Revenue Res Ind Ded"""
  cLastYearRoomRevenueReservationIndividualDed: Float
  """Central Ly Room Revenue Res Ind Ndd"""
  cLastYearRoomRevenueReservationIndividualNdd: Float
  """Central Lywarvd"""
  cLywarvd: Float
  """Central Lywarvn"""
  cLywarvn: Float
  """Central Potential Revenue"""
  cPotentialRevenue: Float
  """Central Revenue"""
  cRevenue: Float
  """Central Revenue Block"""
  cRevenueBlock: Float
  """Central Revenue (N)"""
  cRevenueNonDeduct: Float
  """Central Revenue Resv Transient"""
  cRevenueReservationTransient: Float
  """Central Room Revenue Blk Ndd"""
  cRoomRevenueBlockNdd: Float
  """Central Room Revenue Res Blk Ded"""
  cRoomRevenueReservationBlockDed: Float
  """Central Room Revenue Res Blk Ndd"""
  cRoomRevenueReservationBlockNdd: Float
  """Central Room Revenue Res Ind Ndd"""
  cRoomRevenueReservationIndividualNdd: Float
  """C WGO Revenue Ded"""
  cWGORevenueDed: Float
  """C WGO Revenue Ndd"""
  cWGORevenueNdd: Float
  """C YGO Revenue Ded"""
  cYGORevenueDed: Float
  """C YGO Revenue Ndd"""
  cYGORevenueNdd: Float
  """C YWGO Revenue Ded"""
  cYWGORevenueDed: Float
  """C YWGO Revenue Ndd"""
  cYWGORevenueNdd: Float
  """Channel"""
  channel: String
  """D Snapshot Date"""
  dSnapshotDate: Date
  """DGO Revenue Ded"""
  dGORevenueDed: Float
  """DGO Revenue Ndd"""
  dGORevenueNdd: Float
  """DGO Rooms Ded"""
  dGORoomsDed: Float
  """DGO Rooms Ndd"""
  dGORoomsNdd: Float
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  dSI: Float
  """Forecast Amount"""
  forecastAmt: Float
  """Forecast Rooms"""
  forecastRooms: Float
  """Ly Arrangement Adults"""
  lastYearArrAdults: Float
  """Ly Arrangement Children"""
  lastYearArrChildren: Float
  """Ly Arrangement Rooms"""
  lastYearArrRooms: Float
  """Last Year Revenue"""
  lastYearRevenue: Float
  """Ly Room Revenue Block Ded"""
  lastYearRoomRevenueBlkDed: Float
  """Ly Room Revenue Block Ndd"""
  lastYearRoomRevenueBlkNdd: Float
  """Ly Room Revenue Reservation Blk Ded"""
  lastYearRoomRevenueResBlockDed: Float
  """Ly Room Revenue Reservation Blk Ndd"""
  lastYearRoomRevenueResBlockNdd: Float
  """Ly Room Revenue Reservation Ind Ded"""
  lastYearRoomRevenueResIndividualDed: Float
  """Ly Room Revenue Reservation Ind Ndd"""
  lastYearRoomRevenueResIndividualNdd: Float
  """Ly Stay Rooms Block Ded"""
  lastYearStayRoomsBlkDed: Float
  """Ly Stay Rooms Block Ndd"""
  lastYearStayRoomsBlkNdd: Float
  """Ly Stay Rooms Reservation Blk Ded"""
  lastYearStayRoomsResBlockDed: Float
  """Ly Stay Rooms Reservation Blk Ndd"""
  lastYearStayRoomsResBlockNdd: Float
  """Ly Stay Rooms Reservation Ind Ded"""
  lastYearStayRoomsResIndividualDed: Float
  """Ly Stay Rooms Reservation Ind Ndd"""
  lastYearStayRoomsResIndividualNdd: Float
  """Last Year Actual Rooms"""
  lyActualRooms: Float
  """Last Year Comp Room Nts"""
  lyCompRoomNts: Float
  """Last Year Oo Rooms"""
  lyOoRooms: Float
  """Last Year Revenue Ded"""
  lyRevenueDed: Float
  """Last Year Revenue Ndd"""
  lyRevenueNdd: Float
  """Last Year Rooms Ded"""
  lyRoomsDed: Float
  """Last Year Rooms Ndd"""
  lyRoomsNdd: Float
  """Lywarmd"""
  lywarmd: Float
  """Lywarmn"""
  lywarmn: Float
  """Lywarvd"""
  lywarvd: Float
  """Lywarvn"""
  lywarvn: Float
  """Market Code"""
  marketCode: String
  """Oo Rooms"""
  ooRooms: Float
  """Internal ID to uniquely identify the Organization"""
  organizationID: Float
  """Physical Rooms"""
  physicalRooms: Float
  """Potential Revenue"""
  potentialRevenue: Float
  """Code to uniquely identify the Property"""
  property: String
  """Rate Code"""
  rateCode: String
  """Revenue"""
  revenue: Float
  """Revenue Non Deduct"""
  revenueN: Float
  """Revenue Block"""
  revenueBlock: Float
  """Revenue Reservation Transient"""
  revenueResvTransient: Float
  """Room"""
  room: Float
  """Room Non Deduct"""
  roomN: Float
  """Room Block"""
  roomBlock: Float
  """Room Category"""
  roomCategory: String
  """Room Reservation Transient"""
  roomReservationTransient: Float
  """Room Revenue Block Ndd"""
  roomRevenueBlkNdd: Float
  """Room Revenue Reservation Blk Ded"""
  roomRevenueResBlockDed: Float
  """Room Revenue Reservation Blk Ndd"""
  roomRevenueResBlockNdd: Float
  """Room Revenue Reservation Ind Ndd"""
  roomRevenueResIndividualNdd: Float
  """Rooms To Sell"""
  roomsToSell: Float
  """Rowcount"""
  rowcount: Float
  """Date the Snapshot was created"""
  snapshotDate: Date
  """Stay Date"""
  stayDate: Date
  """Stay Exchange Rate"""
  stayExchangeRate: Float
  """Stay Rooms Block Ndd"""
  stayRoomsBlkNdd: Float
  """Stay Rooms Reservation Blk Ded"""
  stayRoomsResBlockDed: Float
  """Stay Rooms Reservation Blk Ndd"""
  stayRoomsResBlockNdd: Float
  """Stay Rooms Reservation Ind Ndd"""
  stayRoomsResIndividualNdd: Float
  """WGO Revenue Ded"""
  wGORevenueDed: Float
  """WGO Revenue Ndd"""
  wGORevenueNdd: Float
  """WGO Rooms Ded"""
  wGORoomsDed: Float
  """WGO Rooms Ndd"""
  wGORoomsNdd: Float
  """YGO Revenue Ded"""
  yGORevenueDed: Float
  """YGO Revenue Ndd"""
  yGORevenueNdd: Float
  """YGO Rooms Ded"""
  yGORoomsDed: Float
  """YGO Rooms Ndd"""
  yGORoomsNdd: Float
  """YWGO Revenue Ded"""
  yWGORevenueDed: Float
  """YWGO Revenue Ndd"""
  yWGORevenueNdd: Float
  """YWGO Rooms Ded"""
  yWGORoomsDed: Float
  """YWGO Rooms Ndd"""
  yWGORoomsNdd: Float
}
type StatisticsReservationPacePaceStayDateDetailsType {
  """Day Description."""
  dayDesc: String
  """Day End Date."""
  dayEndDate: Date
  """Day number of the month."""
  dayNumberOfMonth: Float
  """Day number of the quarter."""
  dayNumberOfQuarter: Float
  """Day number of the week."""
  dayNumberOfWeek: String
  """Day of the Year."""
  dayOfYear: Float
  """Day Timespan."""
  dayTimespan: Float
  """Month Timespan."""
  daysOfMonth: Float
  """Quarter Timespan."""
  daysOfQuarter: Float
  """Year Timespan."""
  daysOfYear: Float
  """Monthkey"""
  internalMonthkey: Float
  """Iso Week of Year"""
  isoWeekOfYear: String
  """Julian Daykey"""
  julianDaykey: String
  """Last Year Daykey"""
  lastYearDaykey: Date
  """Month Description."""
  monthComparison: String
  """Month End Date."""
  monthEndDate: Date
  """Month Key"""
  monthKey: String
  """Month Name."""
  monthName: String
  """Month of the year."""
  monthNumber: Float
  """Month of the quarter."""
  monthOfQuarter: Float
  """Month Year Key"""
  monthYrKey: String
  """Prior Julian Daykey"""
  priorJulianDaykey: String
  """Prior Month Key"""
  priorMonthKey: String
  """Prior Week Key"""
  priorWeekKey: String
  """Prior Year Daykey"""
  priorYearDaykey: Date
  """Prior Year Key"""
  priorYearKey: String
  """Prior Year Month Key"""
  priorYearMonthKey: String
  """Prior Year Quarter Key"""
  priorYearQuarterKey: String
  """Prior Year Week Key"""
  priorYearWeekKey: String
  """Quarter Description."""
  quarter: String
  """Quarter End Date."""
  quarterEndDate: Date
  """Quarter Key"""
  quarterKey: String
  """Quarter of the year."""
  quarterNumber: String
  """Stay Date"""
  stayDate: Date
  """Week Day"""
  weekDay: String
  """Week Dsc"""
  weekDsc: String
  """End date of the week."""
  weekEndDate: Date
  """Week End Dsc"""
  weekEndDsc: String
  """Week End Key"""
  weekEndKey: String
  """Week End Month Dsc"""
  weekEndMonthDsc: String
  """Week End Date of the Month."""
  weekEndMonthEndDate: Date
  """Week Key"""
  weekKey: String
  """Week of the year."""
  weekNumber: String
  """Week of the month."""
  weekOfMonth: String
  """Week Timespan."""
  weekTimespan: Float
  """Year Comparison"""
  yearComparison: Float
  """Year description."""
  yearDsc: String
  """Year End Date."""
  yearEndDate: Date
  """Year Key"""
  yearKey: String
}
type StatisticsReservationPacePaceMarketDetailsType {
  """Central Market Code"""
  centralMarketCode: String
  """Central Market Description"""
  centralMarketDescription: String
  """Central Market Group"""
  centralMarketGroup: String
  """Central Market Group Description"""
  centralMarketGroupDescription: String
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  dSI: Float
  """Deleted Flag"""
  deletedFlag: String
  """Display Color"""
  displayColor: String
  """Inactive Date"""
  inactiveDate: DateTime
  """Inactive Flag"""
  inactiveflag: String
  """Insert Date"""
  insertDate: DateTime
  """Insert User"""
  insertUser: Float
  """Deleted Flag"""
  internalDeletedflag: String
  """JRN Update Date"""
  jRNUpdateDate: Date
  """JRN Update Date and Time"""
  jRNUpdateDateAndTime: DateTime
  """Internal ID to uniquely identify the Property"""
  locationID: String
  """Market Code"""
  marketCode: String
  """Market Description"""
  marketDescription: String
  """Market group attached to the market code"""
  marketGroup: String
  """Market Group Description"""
  marketGroupDescription: String
  """Market Group Order By"""
  marketGroupOrderBy: Float
  """Market Order By"""
  marketOrderBy: Float
  """Marketgroupid"""
  marketgroupid: String
  """Marketid"""
  marketid: String
  """Internal ID to uniquely identify the Organization"""
  organizationID: Float
  """Internal Primary Key ID to uniquely identify the row"""
  primaryKeyID: Float
  """Print Group for Nationality Report"""
  printGroup: String
  """Code to uniquely identify the Property"""
  property: String
  """Reporting Item"""
  repItem: String
  """Reporting Item Name"""
  repItemName: String
  """Reporting Item Orderby"""
  repItemOrderby: Float
  """Reporting Market Sell Sequence"""
  repMarketSellSequence: Float
  """Reporting Parent Sell Sequence"""
  repParentSellSequence: Float
  """Reporting Updatedate"""
  repUpdateDate: DateTime
  """RnA Insertdate"""
  rnaInsertDate: DateTime
  """RnA Updatedate"""
  rnaUpdateDate: DateTime
  """Sc Orderby"""
  scOrderby: Float
  """Transaction Code"""
  trxCode: String
  """Update Date"""
  updateDate: DateTime
  """Update User"""
  updateUser: Float
}
type StatisticsReservationPacePaceRateCodeDetailsType {
  """Not null value in this column indicates that this is ASB Rate. This column also specifies the cycle of ASB rate. MC=Fixed Calendar Month Cycle WC=Fixed Calendar Week Cycle MF= Floating Monthly Cycle WF=Floating Weekly Cycle."""
  aSBRateCycle: String
  """Amount to be added to the base rate when shown on rate query"""
  addition: String
  """With Advanced Base Rate Parameter ON this field stores the rate code on which this rate schedule is dynamically based on."""
  advBaseRateCode: String
  """Indicates how rounding of advanced dynamic rate calculation is performed.[U]p  [D]own [N]one [C] -Up - keep decimal [F] -Down - keep decimal."""
  advBaseRounding: String
  """Identifies if during the availability check the calculated based amount should be compared to rate detail of BAR rate code."""
  advanceBaseCompareYN: String
  """Indicates if this rate code is an Advanced Daily Base Rate."""
  advanceDailyBaseYN: String
  """Indicates if this rate code is an Advanced Daily Rate."""
  advanceDailyRateYN: String
  """Alternative rate code if current rate is not available"""
  alternateRateCode: String
  """Flag to indicate whether to send Rate code to AVH or not."""
  availabilityUpdateYn: String
  """Back To Back Y/N"""
  backToBackYn: String
  """Base Amount"""
  baseAmount: Float
  """Flat or Percentage of the Base Rate"""
  baseFltPct: String
  """Base Rate Code"""
  baseRateCode: String
  """Indicates if rounding of rate is required"""
  baseRounding: String
  """Indicating a rate type such as flat rate or percentage rate. Possible values are: FLAT DIFFERENTIAL and NULL."""
  baseType: String
  """This column use to store Percentage or Amount difference between BAR Rate code and this Rate Code."""
  bbarBaseAmount: Float
  """This flag column identify that amount column represent Flat or Percentage value."""
  bbarBaseFltPct: String
  """This column identify the rounding formula for the BBAR Rate calculation."""
  bbarBaseRounding: String
  """This column will identify that Rate Code is Best BAR based rate code or not. Possible values are Y/N."""
  bbarBasedYn: String
  """Identifies if during the availability check the calculated based amount should be compared to rate detail of BBAR rate code."""
  bbarCompareYn: String
  """Bbar Y/N"""
  bbarYn: String
  """Begin Booking Date"""
  beginBookingDate: Date
  """PCR: Is breakfast is included in this rate code?"""
  breakfastInclYn: String
  """Breakfast Price"""
  breakfastPrice: Float
  """In case of ORMS when this flag is Y system ignore this rate code from Hurdle Check."""
  bypassHurdleYn: String
  """Indicates that this rate code will not go through rank validations if value is 'Y'."""
  bypassRankCheckYn: String
  """Central Base Amount"""
  cBaseAmount: Float
  """Central Bbar Base Amount"""
  cBbarBaseAmount: Float
  """Central Bfst Price"""
  cBreakfastPrice: Float
  """Central Dbase Amount"""
  cDbaseAmount: Float
  """Central Discount Rate Amount"""
  cDiscountRateAmount: Float
  """Central Dbl Rm Supplement Price"""
  cDoubleRoomSupplementPrice: Float
  """Central Xchange Date"""
  cExchangeDate: Date
  """Central Xchange Rate"""
  cExchangeRate: Float
  """Central Rate Floor"""
  cRateFloor: Float
  """Central Rate Level"""
  cRateLevel: Float
  """Central Rod Base Amount"""
  cRodBaseAmount: Float
  """Central Room Assignment Value"""
  cRoomAssignmentValue: Float
  """Stores the catering package code linked to this rate code."""
  catPackageCode: String
  """Specifies if a catering package is linked to this rate code."""
  cateringPackageYN: String
  """Central Rate Category"""
  centralRateCategory: String
  """Central Rate Category Description"""
  centralRateCategoryDescription: String
  """Central Rate Class"""
  centralRateClass: String
  """Central Rate Class Description"""
  centralRateClassDescription: String
  """Indicates the state of chaange of the rate code with values null=enabled D=disabled P=changes pending of approval"""
  changeState: String
  """Days the rate restriction is not available for arrival"""
  closedToArrival: String
  """Commission Code"""
  commissionCode: String
  """This field is used to populate rate code commission percentage for informational purposes for GDS and ORS reservation agents"""
  commissionPct: Float
  """Are commissions allowed for this rate code? Y/N"""
  commissionYn: String
  """PCR: Commissionable Percentage."""
  commissionablePerc: Float
  """Commissionable Y/N"""
  commissionableYn: String
  """Complimentary Y/N"""
  complimentaryYn: String
  """Introduced for Holidex inbound delta rate processing this column stores the value indicating the decimal position specific to the received the currency code."""
  currCodeDecimalPos: Float
  """Currency Code"""
  currencyCode: String
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  dSI: Float
  """Daily Rates Y/N"""
  dailyRatesYn: String
  """Day use reservation Y/N."""
  dayuseYn: String
  """Indicates either Flat amount or Percentage increase or decrease from the dynamic base rate."""
  dbaseAmount: Float
  """This flag identify that while checking availability calculated based amount should be compared to rate detail of rate code or not."""
  dbaseCompareYn: String
  """Flat or Percentage of the dynamic base rate code."""
  dbaseFltPct: String
  """The rate code on which this rate shedule is dynamically based on."""
  dbaseRateCode: String
  """Indicates if rounding of dynamic rate calculation is required."""
  dbaseRounding: String
  """Stores the double room supplement price."""
  dblRoomSupplementPrice: Float
  """For BAR dependent Rate Code this flag indicates that when all BAR Rates are closed the Rate Amount should be calculated based on the highest BAR Rate Amount instead of based on its own Rate Detail."""
  defaultToHighestBarYn: String
  """Deleted Flag"""
  deletedFlag: String
  """Stores the Deposit maturity preference."""
  depositMaturityPreference: String
  """Department code for the transaction."""
  deptCode: String
  """Discount rate amount value."""
  discountRateAmount: Float
  """Indicates if discount rate amount is a percentage value."""
  discountRatePercentageYn: String
  """Discount Flag."""
  discountYn: String
  """Display Regional"""
  displayRegional: String
  """Display Set"""
  displaySet: String
  """Indicates if the profile should be distributed to the external database."""
  distributeYn: String
  """Stores the double room supplement."""
  doubleRoomSupplementYN: String
  """End Booking Date"""
  endBookingDate: Date
  """Exchange Posting Type"""
  exchangePostingType: String
  """External Locked Y/N"""
  externalLockedYn: String
  """Introduced for Holidex inbound delta rate processing this column stores the value indicating at person level the extra charge begins."""
  extraPersonChargeBegins: Float
  """Fit Discount Level."""
  fitDiscountLevel: Float
  """Published Corporate Rate: Discount Percentage."""
  fitDiscountPerc: Float
  """Flat Or Percentage"""
  flatOrPercentage: String
  """Text displayed on the Folio"""
  folioText: String
  """Frequent Flyer Y/N"""
  frequentFlyerYn: String
  """Is this rate code available for GDS"""
  gDSAllowedYn: String
  """Group Code"""
  groupCode: String
  """To highlight on the rate query"""
  highlightRateAmountYn: String
  """House Use Y/N"""
  houseUseYn: String
  """Inactive Date"""
  inactiveDate: DateTime
  """Insert Date"""
  insertDate: DateTime
  """Insert User"""
  insertUser: Float
  """Location ID"""
  internalLocationId: String
  """Organization ID"""
  internalOrganizationId: Float
  """JRN Update Date"""
  jRNUpdateDate: Date
  """JRN Update Date and Time"""
  jRNUpdateDateAndTime: DateTime
  """Label"""
  label: String
  """Internal ID to uniquely identify the Property"""
  locationID: String
  """Long Info"""
  longInfo: String
  """Indicates the lengh of Stay Unit in days. If value is > 1 then it is a pkg rate code."""
  losUnit: Float
  """Flag to indicate if this is a loyalty program"""
  loyaltyProgramYn: String
  """Indicates mandatory reservation profiles. This is used to force entry of profiles on the reservation header if this rate is picked."""
  mandateResvProfiles: String
  """Market Code"""
  marketCode: String
  """Market Description"""
  marketDescription: String
  """Market Group Code"""
  marketGroupCode: String
  """Market Group Description"""
  marketGroupDescription: String
  """Contains the rate program information from the MARSHA interface."""
  marshaRateProgram: String
  """Max Dvance Booking"""
  maxDvanceBooking: Float
  """Max Los"""
  maxLos: Float
  """Max Occupancy"""
  maxOccupancy: Float
  """Flag used to determine if the rate code is to be sent to MyFidelio.net if the rate is being received from a V6 V7 V8 or OPMS on a lower version on which flag used to determine if the rate code is to be sent to MyFidelio.net does not exist on the rate header."""
  mfnUploadYn: String
  """Minimum Advance Booking"""
  minAdvanceBooking: Float
  """Minimum Occupancy"""
  minOccupancy: Float
  """Mobile Checkin Allowed Y/N"""
  mobileCheckinAllowedYn: String
  """Mobile Chkout Allowed"""
  mobileChkoutAllowed: String
  """Amount to be multiplied to the base rate when shown on rate query"""
  multiplication: String
  """Myfideliouploadflag"""
  myfideliouploadflag: String
  """Property is negotiated of search criteria or not."""
  negotiatedYN: String
  """Indicates if the rate code is occupancy based."""
  occupancyBasedYn: String
  """Indicates the occupancy level for hurdle evaluation."""
  occupancyLevel: Float
  """The operator type to use during the calculation of base rates. (ADD_TO SUBTRACT)"""
  operatorType: String
  """Order By"""
  orderBy: Float
  """Internal ID to uniquely identify the Organization"""
  organizationID: Float
  """Indicates the order in which this rate should be displayed during the booking process when the ors_rate_sell_sequence functionality is active."""
  orsSellSequence: Float
  """Indicates if we need to override package for hurdle evaluation."""
  overridePackageYn: String
  """Indicates Owners Rate Code. This is used to perform rolling noshow."""
  ownerRateYn: String
  """Wrapper transaction code tax inclusive Y/N"""
  packageTransactionTaxInclYN: String
  """Wrapper transaction code tax inclusive for weekend days Y/N"""
  packageTransactionWkTaxInclYN: String
  """Package Y/N"""
  packageYn: String
  """Packages"""
  packages: String
  """Indicates whether the rate code is pending for approval or not"""
  pendingApprovalYn: String
  """Package Transaction Code"""
  pkgTransactionCode: String
  """Package Transaction Code Wk"""
  pkgTransactionCodeWk: String
  """Number of nights for posting rhythm."""
  postingRhythmNights: Float
  """Posting Rhythum"""
  postingRhythum: String
  """Internal Primary Key ID to uniquely identify the row"""
  primaryKeyID: Float
  """Print Rate Y/N"""
  printRateYn: String
  """Indicates if restriction for rate is privileged or not."""
  privilegedRestrictionYn: String
  """Indicates if rate is privileged or not."""
  privilegedYn: String
  """Profit Transaction Code"""
  profitTransactionCode: String
  """Indicates if the value set for the specific property."""
  property: String
  """Property Name"""
  propertyName: String
  """Any number between -10 and +10. This adjustment factor will be applied to the daily ranking value of table RESORT_DAY_TYPE_DATES for the stay date to determine the Rate code rank value."""
  rankAdjustmentFactor: Float
  """Rank Value"""
  rankValue: Float
  """Yield rate bucket"""
  rateBucket: String
  """Rate Bucket Description"""
  rateBucketDescription: String
  """Indicates if rate Calendar factors such as adder/multiplier should be used for price calculation."""
  rateCalendarYn: String
  """Rate Category"""
  rateCategory: String
  """Rate Category Description"""
  rateCategoryDescription: String
  """Rate Class"""
  rateClass: String
  """Rate Class Description"""
  rateClassDescription: String
  """Rate Code"""
  rateCode: String
  """Rate Code Description"""
  rateCodeDescription: String
  """Rate Code ID"""
  rateCodeId: String
  """Rate Code Locked Y/N"""
  rateCodeLockedYn: String
  """Contains the minimum value of the rate amount which can be defined in the rate details."""
  rateFloor: Float
  """This flag indicates if the Rate Floor Rate is overridden for a particular Rate Code."""
  rateFloorOverrideYn: String
  """Does this rate include tax? Y/N"""
  rateIncludesTaxYn: String
  """Rate Level this rate code belongs to."""
  rateLevel: Float
  """Rateinfo Url"""
  rateinfoUrl: String
  """Needs to send this rate to GDS or not."""
  ratesToGDSYn: String
  """Redemption Rate Y/N"""
  redemptionRateYn: String
  """Reporting Market Code"""
  repMarketCode: String
  """Reporting Market Description"""
  repMarketDescription: String
  """Reporting Market Group Code"""
  repMarketGroupCode: String
  """Reporting Market Group Description"""
  repMarketGroupDescription: String
  """Reporting Rate Bucket"""
  repRateBucket: String
  """Reporting Rate Bucket Description"""
  repRateBucketDescription: String
  """Reporting Room Type Descs"""
  repRoomTypeDescs: String
  """Reporting Room Types"""
  repRoomTypes: String
  """Reporting Source Code"""
  repSourceCode: String
  """Reporting Source Description"""
  repSourceDescription: String
  """Reporting Source Group Code"""
  repSourceGroupCode: String
  """Reporting Source Group Description"""
  repSourceGroupDescription: String
  """Indicates if the posting rhythm on the rate code is repeated until the end of the stay otherwise the posting rhythm is applied only once."""
  repeatPostingRhythmYn: String
  """Property"""
  resort: String
  """RnA Insertdate"""
  rnaInsertDate: DateTime
  """RnA Updatedate"""
  rnaUpdateDate: DateTime
  """Rod Base Amount"""
  rodBaseAmount: Float
  """Rod Base Flt Pct"""
  rodBaseFltPct: String
  """Rod Base Rounding"""
  rodBaseRounding: String
  """Is the group code rate of day based"""
  rodBasedYn: String
  """Rod Y/N"""
  rodYn: String
  """Room Assignment Value"""
  roomAssignmentValue: Float
  """Room Type Descs"""
  roomTypeDescs: String
  """Room Types"""
  roomTypes: String
  """Holds a copy of the column begin_booking_date while the rate code is disabled or with changes pending of approval"""
  sdowBeginBookingDate: Date
  """Holds a copy of the column end_booking_date while the rate code is disabled or with changes pending of approval"""
  sdowEndBookingDate: Date
  """Sell Sequence"""
  sellSequence: Float
  """PCR: Are Service Charges included in this rate code?"""
  serviceInclYn: String
  """Service Percentage included."""
  servicePerc: Float
  """Information to be used in the rate query"""
  shortInfo: String
  """Flag used to show or hide rate column in Block Grid and used as default by block reservations."""
  showRateAmountYn: String
  """Source Code"""
  sourceCode: String
  """Source Description"""
  sourceDescription: String
  """Source Group Code"""
  sourceGroupCode: String
  """Source Group Description"""
  sourceGroupDescription: String
  """Percentage of included Tax."""
  taxIncludedPerc: Float
  """Tax is included in this rate."""
  taxIncludedYn: String
  """Indicates if the rate is a tiered rate."""
  tieredYn: String
  """Rate transaction code"""
  transactionCode: String
  """Transaction Code Wk"""
  transactionCodeWk: String
  """Transaction code is inclusive of tax Y/N"""
  transactionTaxInclYN: String
  """Transaction code is inclusive of tax for weekend days Y/N"""
  transactionWkTaxInclYN: String
  """Update Date"""
  updateDate: DateTime
  """Update User"""
  updateUser: Float
  """Indicates if the rate code can be upsold"""
  upsellYn: String
  """Flag to indicate if this is a voucher benefit rate code."""
  voucherBenefitRateYn: String
  """Indicates weekend days seperated by '' Eg 17 ie Sun and Sat"""
  weekendDays: String
  """Wk Dept Code"""
  wkDeptCode: String
  """Yield As"""
  yieldAs: String
  """Yieldable Y/N"""
  yieldableYn: String
  """Ym Code"""
  ymCode: String
}
type StatisticsReservationPacePacePropertyDetailsType {
  """Specifies if the AR acct No is mandatory(Y/N)"""
  aRAccountNumberMandYN: String
  """Internal"""
  aRBalanceTrxCode: String
  """Internal"""
  aRCreditTrxCode: String
  """Access Code"""
  accessCode: String
  """Aging bucket 1"""
  agingLevel1: Float
  """Aging bucket 2"""
  agingLevel2: Float
  """Aging bucket 3"""
  agingLevel3: Float
  """Aging bucket 4"""
  agingLevel4: Float
  """Aging bucket 5"""
  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
  """All Contacts"""
  allContacts: String
  """Allow loggin in to this resort(Y/N)"""
  allowLoginYn: String
  """Period for the allowance"""
  allowancePeriodAdj: String
  """Property is alternate or actual search."""
  alternateYn: String
  """Number format of AR account no."""
  arAccountNumberFormat: String
  """Default Account Type for an Agent for the Property"""
  arAgent: String
  """Default Account Type for a Company for the Property"""
  arCompany: 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
  """Internal"""
  awardsTimeout: Float
  """The base language of the Hotel"""
  baseLanguage: String
  """Begin Date"""
  beginDate: DateTime
  """Blackout period notes defaulted onto the FIT Contract at time of creation."""
  blackoutPeriodNotes: String
  """Block"""
  block: String
  """Book Y/N"""
  bookYn: String
  """Ball Room Area"""
  brArea: String
  """No of Ballroom Seats"""
  brSeats: Float
  """Brand Code"""
  brandCode: String
  """Financial Year of the Property"""
  budgetMonth: Float
  """Busblock Type"""
  busblockType: String
  """Business ID"""
  businessId: String
  """Business Reg Code"""
  businessRegCode: String
  """Central Credit Limit"""
  cCreditLimit: Float
  """Central Dbl Rate2"""
  cDoubleRate2: Float
  """Central Dbl Rate1"""
  cDoubleRate1: Float
  """Central Xchange Date"""
  cExchangeDate: Date
  """Central Xchange Rate"""
  cExchangeRate: Float
  """Central Sgl Rate2"""
  cSglRate2: Float
  """Central Sgl Rate1"""
  cSglRate1: Float
  """Central Sui Rate2"""
  cSuiRate2: Float
  """Central Sui Rate1"""
  cSuiRate1: Float
  """Central Tpl Rate2"""
  cTplRate2: Float
  """Central Tpl Rate1"""
  cTplRate1: Float
  """Central Warning Amount"""
  cWarningAmount: Float
  """CRO Code"""
  cROCode: String
  """Not used"""
  cRSResort: String
  """Internal"""
  cashShiftDrop: String
  """Cash Y/N"""
  cashYn: String
  """Catering Currency Code used when Catering Currency differs from base currency."""
  cateringCurrencyCode: String
  """Catering currency format."""
  cateringCurrencyFormat: String
  """Central Currency Code"""
  centralCurrencyCode: String
  """Central Currency Description"""
  centralCurrencyDescription: String
  """Central Property Type"""
  centralPropertyType: String
  """Chain Code"""
  chainCode: String
  """Chain Description"""
  chainDescription: String
  """Chain Mode"""
  chainMode: String
  """Internal"""
  checkExgPaidout: String
  """The Hotel official check intime"""
  checkInTime: DateTime
  """The Hotel official check out time"""
  checkOutTime: DateTime
  """Internal"""
  checkShiftDrop: String
  """Internal"""
  checkTrxcode: String
  """City"""
  city: String
  """City Description."""
  cityDescription: String
  """Communication Address for Contact 1 (E-mail / Fax #)"""
  comAddress: String
  """How this lead is to be sent. [EMAIL|FAX|PRINT]"""
  comMethod: String
  """Internal"""
  comNameXrefId: Float
  """Internal"""
  companyAddressType: String
  """Internal"""
  companyPhoneType: String
  """Config Y/N"""
  configYn: String
  """Internal"""
  configurationMode: String
  """Internal"""
  confirmRegcardPrinter: String
  """Copies"""
  copies: Float
  """Country Code"""
  countryCode: String
  """Country Mode"""
  countryMode: String
  """Country Name"""
  countryName: String
  """Credit Limit"""
  creditLimit: Float
  """Currency Code"""
  currencyCode: String
  """Number of decimals to designate currency"""
  currencyDecimals: Float
  """Currency Description"""
  currencyDescription: String
  """Not used"""
  currencyExgPaidout: String
  """Currency Symbol like $ or EURO symbol"""
  currencySymbol: String
  """Color that of the background"""
  curtainColor: String
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  dSI: Float
  """Date the aging should begin"""
  dateForAging: String
  """Type of separator to distinguish between DD MM and YYYY"""
  dateSeparator: String
  """Not used"""
  dblNum: String
  """Not used"""
  dblRate2: Float
  """Not used"""
  dblRate1: Float
  """Number of places for the default currency"""
  decimalPlaces: Float
  """Type of decimal separator"""
  decimalSeparator: String
  """Not used"""
  defaultCommissionPercentage: String
  """Not used"""
  defaultFaxType: String
  """Folio style to be used for all guests"""
  defaultFolioStyle: Float
  """Not used"""
  defaultGroupsRateCode: String
  """Default guest address format."""
  defaultGuestAddress: String
  """Future use"""
  defaultMembershipType: String
  """Future use"""
  defaultPostingRoom: String
  """Not used."""
  defaultPrepaidComm: String
  """Not Used"""
  defaultPrinter: String
  """Default property address format."""
  defaultPropertyAddress: String
  """Default rate code to be used to calculate the total revenue."""
  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
  """Not used."""
  defaultTrxCommissionCode: 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
  """Download Rest Y/N"""
  downloadRestYn: String
  """Pager number for the Manager on duty for the property."""
  dutyManagerPager: String
  """Email"""
  email: String
  """End Date"""
  endDate: DateTime
  """Exchange Posting Type"""
  exchangePostingType: String
  """Hotel code used for third party exports"""
  expHotelCode: String
  """Expiry Date"""
  expiryDate: Date
  """Future use"""
  extExpFileLocation: String
  """Future use"""
  extPropertyCode: String
  """Indicates that the property uses an external SC system."""
  externalScYn: String
  """Fax"""
  fax: String
  """Fax number formats."""
  faxNoFormat: String
  """Not used."""
  fileTransferFormat: String
  """Future use"""
  fiscalEndDate: Date
  """Future use"""
  fiscalPeriodType: String
  """Future use"""
  fiscalStartDate: Date
  """Fiscal Start Month"""
  fiscalStartMonth: Float
  """Fiscal Start Year"""
  fiscalStartYear: Float
  """Screen Painter flags to indicate whether an item is changable/ movable etc."""
  flags: String
  """Floor number of executive floor."""
  floorNumExecutiveFloor: 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
  """Not used"""
  font: Float
  """Future use"""
  genmgr: String
  """To define an upper limit to the number of rooms for Group"""
  groupRoomWarning: Float
  """Future use"""
  guestLookupTimeout: Float
  """Property Code."""
  hotelCode: String
  """Future use"""
  hotelFc: String
  """Hotel ID"""
  hotelId: String
  """Hotel Type"""
  hotelType: String
  """Future use"""
  imgDirectionId: Float
  """Future use"""
  imgHotelId: Float
  """Future use"""
  imgMapId: Float
  """Future use"""
  inactiveDaysForGuestProfil: 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
  """Insert Date"""
  insertDate: DateTime
  """Insert User"""
  insertUser: Float
  """Int Tax Included Y/N"""
  intTaxIncludedYn: String
  """Location ID"""
  internalLocationId: String
  """Organization ID"""
  internalOrganizationId: Float
  """Indicates if the Resources under this Type need to maintain inventory."""
  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
  """Name of Contact 1 (Free text or from RESORT_CONTACTS)"""
  leadsend: String
  """The owner who owns this property"""
  legalOwner: String
  """License Code"""
  licenseCode: String
  """Format for the local currency."""
  localCurrencyFormat: String
  """Internal ID to uniquely identify the Property"""
  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."""
  maxAdultsFamilyRoom: Float
  """Maximum children in family rooms."""
  maxChildrenFamilyRoom: Float
  """Not used"""
  maxNoNights: Float
  """Max Occupancy"""
  maxOccupancy: Float
  """Maxcreditdays"""
  maxcreditdays: Float
  """Indicates if 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
  """Notes"""
  notes: String
  """Total number of beds in this property"""
  numberBeds: Float
  """Total number of floors in this property"""
  numberFloors: Float
  """Number Rooms"""
  numberRooms: Float
  """Ops Mhot Y/N"""
  opsMhotYn: String
  """Ops Mht2 Y/N"""
  opsMht2Yn: String
  """Future use"""
  opusCurrencyCode: String
  """Internal ID to uniquely identify the Organization"""
  organizationID: Float
  """Future use"""
  ownership: String
  """Package Loss code for a particular package"""
  packageLoss: String
  """Package Profit code for a particular Package"""
  packageProfit: String
  """Market code for passerby"""
  passerbyMarket: String
  """Source code for passerby"""
  passerbySource: String
  """Path"""
  path: String
  """This is the value used in Interfaces to map  to a Resort Code."""
  pathId: Float
  """Payment Date"""
  paymentDate: DateTime
  """Future use"""
  perReservationRoomLimit: Float
  """Indicate if PMS was active on that date or not."""
  pmsActiveYn: String
  """Post Code"""
  postCode: String
  """Internal Primary Key ID to uniquely identify the row"""
  primaryKeyID: Float
  """Proinfo Url"""
  proinfoUrl: String
  """Property MAP URL."""
  propMapUrl: String
  """Property picture URL."""
  propPicUrl: String
  """Property"""
  property: String
  """Property Name"""
  propertyName: String
  """Property Type"""
  propertyType: String
  """Number of connecting rooms."""
  qtyConnectingRooms: Float
  """Number of double rooms."""
  qtyDoubleRooms: Float
  """Number of family rooms."""
  qtyFamilyRooms: Float
  """Number of guest elevators."""
  qtyGuestElevators: Float
  """Total of guest rooms floors."""
  qtyGuestRoomFloors: Float
  """Number of handicapped rooms."""
  qtyHandicappedRooms: Float
  """Number of non smoking rooms."""
  qtyNonSmokingRooms: Float
  """Number of single rooms."""
  qtySingleRooms: Float
  """Number of suites."""
  qtySuites: Float
  """Number of twin rooms."""
  qtyTwinRooms: Float
  """Future use"""
  quotedCurrency: String
  """Rate Tier Y/N"""
  rateTierYn: String
  """Records the date on which the reconciliation is done"""
  reconcileDate: DateTime
  """Region Code"""
  regionCode: String
  """Region Description"""
  regionDescription: String
  """Reporting Passerby Market"""
  repPasserbyMarket: String
  """Reporting Passerby Source"""
  repPasserbySource: String
  """Reporting State"""
  repState: String
  """Reporting State Desc"""
  repStateDescription: String
  """Report Y/N"""
  reportYn: String
  """Indicates if this menu item depends on the reservation."""
  reservationYN: String
  """Future use"""
  restaurant: Float
  """Total number of Sheets"""
  rhythmSheets: Float
  """Total number of Towels"""
  rhythmTowels: Float
  """RnA Insertdate"""
  rnaInsertDate: DateTime
  """RnA Updatedate"""
  rnaUpdateDate: DateTime
  """Room amenity."""
  roomAmenity: String
  """To store number of days before deleting the gest profile"""
  saveProfiles: Float
  """Sc Active Y/N"""
  scActiveYn: String
  """Script ID"""
  scriptId: Float
  """Future use"""
  season1: String
  """Future use"""
  season2: String
  """Future use"""
  season3: String
  """Future use"""
  season4: String
  """Future use"""
  season5: String
  """Send Lead As Booking"""
  sendLeadAsBooking: String
  """Sfa Active Y/N"""
  sfaActiveYn: String
  """Future use"""
  sglNum: String
  """Future use"""
  sglRate1: Float
  """Future use"""
  sglRate2: Float
  """Shop description."""
  shopDescription: String
  """Short date format for the property."""
  shortDateFormat: String
  """For default commission percentage"""
  sourceCommission: String
  """State"""
  state: String
  """State Description of the Guest of Payee"""
  stateDesc: String
  """The street of the property."""
  street: String
  """Future use"""
  suiNum: String
  """Future use"""
  suiRate1: Float
  """Future use"""
  suiRate2: Float
  """Internal"""
  summCurrencyCode: String
  """For default commission percentage"""
  taCommission: String
  """The direct dial phone number of this property"""
  telephone: String
  """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."""
  timezoneRegion: String
  """Toll free telephone number."""
  tollfree: String
  """Future use"""
  totalRooms: Float
  """Tourist Number"""
  touristNumber: String
  """Future use"""
  tplNum: String
  """Future use"""
  tplRate1: Float
  """Future use"""
  tplRate2: Float
  """Indicates whether the property handles multi byte characters and whether they are translateable or not"""
  translateMulticharYn: String
  """Turnaway Code"""
  turnawayCode: String
  """Update Date"""
  updateDate: DateTime
  """Update User"""
  updateUser: Float
  """VAT ID of this property."""
  vatId: String
  """Video check out start time."""
  videoCoStart: DateTime
  """Video check out end time."""
  videoCoStop: DateTime
  """Future use"""
  videocheckoutPrinter: String
  """Vos Active Y/N"""
  vosActiveYn: String
  """Future use"""
  wakeUpDelay: Float
  """Amount at which warning is raised."""
  warningAmount: Float
  """Webaddress of the property"""
  webaddress: String
  """Indicates weekend days seperated by '' Eg 17 ie Sun and Sat"""
  weekendDays: String
  """Numbers (1 thru 10) given to the resorts in the schema to print the tax collected by that resort in the gstfolio when proper merge codes are selected."""
  xresortNumber: Float
  """Internal"""
  zeroInvPurDays: Float
}
type StatisticsReservationPacePaceRoomTypeDetailsType {
  """Indicates if this room type is accessibility compliant."""
  accessibleYn: String
  """The date this record becomes valid for use by the system.  User enterable"""
  activeDate: Date
  """Activeflag"""
  activeflag: Date
  """Auto Checkin Y/N"""
  autoCheckinYn: String
  """Include room type in the rate header for Myfidelio rates."""
  autoIncludeYn: String
  """A setting of Y will automatically assign an available room number to any reservation that is made for this room type."""
  autoRoomAssignYn: String
  """Central Xchange Date"""
  cExchangeDate: Date
  """Central Xchange Rate"""
  cExchangeRate: Float
  """Central Increments"""
  cIncrements: Float
  """Central Initial Round Up"""
  cInitialRoundUp: Float
  """Central Orms Drtier1"""
  cORMSDrtier1: Float
  """Central Orms Drtier2"""
  cORMSDrtier2: Float
  """Central Orms Drtier3"""
  cORMSDrtier3: Float
  """Central Orms Drxtra 2nd Adult"""
  cORMSDrxtra2ndAdult: Float
  """Central Orms Drxtra Adult"""
  cORMSDrxtraAdult: Float
  """Central Orms Drxtra Child"""
  cORMSDrxtraChild: Float
  """Central Orms Upsell Amt"""
  cORMSUpsellAmount: Float
  """Central Rate Amount"""
  cRateAmount: Float
  """Central Rate Floor"""
  cRateFloor: Float
  """CRS Description"""
  cRSDescription: String
  """Can Delete Y/N"""
  canDeleteYn: String
  """Central Room Class"""
  centralRoomClass: String
  """Central Room Class Description"""
  centralRoomClassDescription: String
  """Central Room Type"""
  centralRoomType: String
  """Central Room Type Description"""
  centralRoomTypeDescription: String
  """Has this room category's long and short description been compiled from the feature list? Y/N"""
  compiled: String
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  dSI: Float
  """Default occupancy for the room type"""
  defOccupancy: Float
  """Default rate code to be used to calculate the total revenue."""
  defaultRateCode: String
  """Default Rate Description"""
  defaultRateDesc: String
  """Defaultratecodeid"""
  defaultratecodeid: String
  """Deleted Flag"""
  deletedFlag: String
  """Facility ID for eVisitor."""
  evisitorFacilityId: String
  """Genericroomflag"""
  genericroomflag: String
  """Room type shows in housekeeping Y/N"""
  housekeeping: String
  """Image ID"""
  imageId: Float
  """Inactive Date"""
  inactiveDate: DateTime
  """Inactive Flag"""
  inactiveflag: String
  """Increment value for rates by day by LOS."""
  increments: Float
  """Initial round up value for rates by day by LOS."""
  initialRoundUp: Float
  """Insert Date"""
  insertDate: DateTime
  """Insert User"""
  insertUser: Float
  """Deleted Flag"""
  internalDeletedflag: String
  """JRN Update Date"""
  jRNUpdateDate: Date
  """JRN Update Date and Time"""
  jRNUpdateDateAndTime: DateTime
  """Label"""
  label: String
  """Internal ID to uniquely identify the Property"""
  locationID: String
  """Long Description"""
  longDescription: String
  """Indicates if rooms of this room type will be available for Room Maintenance functionality."""
  maintenanceYn: String
  """Maximum number of persons that can be accommodated in this room type without providing an extra bed."""
  maxFixBedOccupancy: Float
  """Max Occupancy"""
  maxOccupancy: Float
  """The maximum occupancy of adults for this room category."""
  maxOccupancyAdults: Float
  """The maximum occupancy of children for this room category."""
  maxOccupancyChildren: Float
  """Not used"""
  maxRollaways: Float
  """Meetingroomflag"""
  meetingroomflag: String
  """Specifies which membership award room group the room category belongs to."""
  memberAwardRoomGrp: String
  """Minimum Occupancy"""
  minOccupancy: Float
  """Number Rooms"""
  numberRooms: Float
  """Relative amount increase per room category per yield category. Used only in ADF10."""
  oRMSUpsellAmt: Float
  """Order By"""
  orderBy: Float
  """Internal ID to uniquely identify the Organization"""
  organizationID: Float
  """The extra charge on child in age tier1"""
  ormsDrtier1: Float
  """The extra charge on child in age tier2"""
  ormsDrtier2: Float
  """The extra charge on child in age tier3"""
  ormsDrtier3: Float
  """The extra charge on 2nd adult."""
  ormsDrxtra2ndAdult: Float
  """Daily Rate extra adult additional charge for this room type."""
  ormsDrxtraAdult: Float
  """Daily Rate extra children additional charge for this room type."""
  ormsDrxtraChild: Float
  """Relative rank (low to high) of the room category per yield category."""
  ormsUpsellRank: Float
  """Ownerroomflag"""
  ownerroomflag: String
  """Physical Room Y/N"""
  physicalRoomYn: String
  """Internal Primary Key ID to uniquely identify the row"""
  primaryKeyID: Float
  """Code to uniquely identify the Property"""
  property: String
  """Pseudo Room YN"""
  pseudoRoomYN: String
  """Psuedo Room Type"""
  psuedoRoomType: String
  """Rate Amount"""
  rateAmount: Float
  """Rate Category"""
  rateCategory: String
  """Rate Category Description"""
  rateCategoryDesc: String
  """Rate Code"""
  rateCode: String
  """Contains the minimum value of the rate amount which can be defined in the rate details."""
  rateFloor: Float
  """Ratecategoryid"""
  ratecategoryid: String
  """Reporting Item"""
  repItem: String
  """Reporting Item Name"""
  repItemName: String
  """Reporting Item Orderby"""
  repItemOrderby: Float
  """Reporting Order By"""
  repOrderBy: Float
  """Reporting Rate Category"""
  repRateCategory: String
  """Reporting Rate Category Desc"""
  repRateCategoryDescription: String
  """Reporting Smoking Pref Desc"""
  repSmokingPrefDescription: String
  """Reporting Updatedate"""
  repUpdateDate: DateTime
  """When room categories are renamed this flag indicates which room category this category replaces."""
  replacesCategory: String
  """RnA Insertdate"""
  rnaInsertDate: DateTime
  """RnA Updatedate"""
  rnaUpdateDate: DateTime
  """Room Class"""
  roomClass: String
  """Room Class Description"""
  roomClassDescription: String
  """Room Pool that this room type belongs to. (Used in Marriott mode)."""
  roomPool: String
  """Room Type"""
  roomType: String
  """Room Type Description"""
  roomTypeDescription: String
  """Roomcategoryid"""
  roomcategoryid: String
  """Roomcategorypmsref"""
  roomcategorypmsref: String
  """Roomclassid"""
  roomclassid: String
  """URL where room information is stored."""
  roominfoUrl: String
  """Rotation Group"""
  rotationGroup: String
  """S Bedtype"""
  sBedtype: String
  """S Label"""
  sLabel: String
  """Sales strategy flag for Room Types: L=Lead U=Upsell A=Alternate."""
  salesFlag: String
  """Sell Thru Rule Y/N"""
  sellThruRuleYn: String
  """Room type sent to interface Y/N"""
  sendToInterfaceYn: String
  """Smoking Pref Description"""
  smokingPrefDesc: String
  """Smoking Preference"""
  smokingPreference: String
  """Suiteroomflag"""
  suiteroomflag: String
  """Update Date"""
  updateDate: DateTime
  """Update User"""
  updateUser: Float
  """Indicates if the rate code can be upsold"""
  upsellYn: String
  """Yield Category"""
  yieldCategory: String
  """Yieldableroomflag"""
  yieldableroomflag: String
}
type StatisticsReservationPacePaceChannelDetailsType {
  """Business Title"""
  businessTitle: String
  """Can Delete Y/N"""
  canDeleteYn: String
  """Central Origin Code"""
  centralOriginCode: String
  """Central Origin Description"""
  centralOriginDescription: String
  """Chain Code"""
  chainCode: String
  """Channelid"""
  channelid: String
  """Comments"""
  comments: String
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  dSI: Float
  """Deleted Flag"""
  deletedFlag: String
  """Display Color"""
  displayColor: String
  """Entity Name"""
  entityName: String
  """Contains a list of codes used by a vendor."""
  externalAttributeCodes: String
  """Inactive Date"""
  inactiveDate: DateTime
  """Inactive Flag"""
  inactiveflag: String
  """Insert Date"""
  insertDate: DateTime
  """Insert User"""
  insertUser: Float
  """Deleted Flag"""
  internalDeletedflag: String
  """JRN Update Date"""
  jRNUpdateDate: Date
  """JRN Update Date and Time"""
  jRNUpdateDateAndTime: DateTime
  """Language Code"""
  languageCode: String
  """Internal ID to uniquely identify the Property"""
  locationID: String
  """Indicates if the KEYWORD TYPE is to be copied from a Company Master to a Company Subsidiary."""
  masterSubKeywordYn: String
  """Order By"""
  orderBy: Float
  """Internal ID to uniquely identify the Organization"""
  organizationID: Float
  """Origin Code"""
  originCode: String
  """Origin Description"""
  originDescription: String
  """Internal Primary Key ID to uniquely identify the row"""
  primaryKeyID: Float
  """Ranking"""
  ranking: Float
  """Reporting Item"""
  repItem: String
  """Reporting Item Name"""
  repItemName: String
  """Reporting Item Orderby"""
  repItemOrderby: Float
  """Reporting Order By"""
  repOrderBy: Float
  """Reporting Updatedate"""
  repUpdateDate: DateTime
  """RnA Insertdate"""
  rnaInsertDate: DateTime
  """RnA Updatedate"""
  rnaUpdateDate: DateTime
  """Title Suffix"""
  titleSuffix: Float
  """Update Date"""
  updateDate: DateTime
  """Update User"""
  updateUser: Float
}
type StatisticsReservationPaceReservationPaceSnapshotDetailsType {
  """Day Description."""
  dayDesc: String
  """Day End Date."""
  dayEndDate: Date
  """Day number of the month."""
  dayNumberOfMonth: Float
  """Day number of the quarter."""
  dayNumberOfQuarter: Float
  """Day number of the week."""
  dayNumberOfWeek: String
  """Day of the Year."""
  dayOfYear: Float
  """Day Timespan."""
  dayTimespan: Float
  """Monthkey"""
  internalMonthkey: Float
  """Yearkey"""
  internalYearkey: Float
  """Iso Week of Year"""
  isoWeekOfYear: String
  """Julian Daykey"""
  julianDaykey: String
  """Last Year Daykey"""
  lastYearDaykey: Date
  """Month Description."""
  monthDsc: String
  """Month End Date."""
  monthEndDate: Date
  """Month Key"""
  monthKey: String
  """Month Name."""
  monthName: String
  """Month of the year."""
  monthNumber: Float
  """Month of the quarter."""
  monthOfQuarter: Float
  """Month Timespan."""
  monthTimespan: Float
  """Month Year Key"""
  monthYrKey: String
  """Prior Julian Daykey"""
  priorJulianDaykey: String
  """Prior Month Key"""
  priorMonthKey: String
  """Prior Week Key"""
  priorWeekKey: String
  """Prior Year Daykey"""
  priorYearDaykey: Date
  """Prior Year Key"""
  priorYearKey: String
  """Prior Year Month Key"""
  priorYearMonthKey: String
  """Prior Year Quarter Key"""
  priorYearQuarterKey: String
  """Prior Year Week Key"""
  priorYearWeekKey: String
  """Quarter Description."""
  quarterDsc: String
  """Quarter End Date."""
  quarterEndDate: Date
  """Quarter Key"""
  quarterKey: String
  """Quarter of the year."""
  quarterNumber: String
  """Quarter Timespan."""
  quarterTimespan: Float
  """Snapshot Date Comparison"""
  snapshotDateComparison: Date
  """Week Day"""
  weekDay: String
  """Week Dsc"""
  weekDsc: String
  """End date of the week."""
  weekEndDate: Date
  """Week End Dsc"""
  weekEndDsc: String
  """Week End Key"""
  weekEndKey: String
  """Week End Month Dsc"""
  weekEndMonthDsc: String
  """Week End Date of the Month."""
  weekEndMonthEndDate: Date
  """Week Key"""
  weekKey: String
  """Week of the year."""
  weekNumber: String
  """Week of the month."""
  weekOfMonth: String
  """Week Timespan."""
  weekTimespan: Float
  """Year description."""
  yearDsc: String
  """Year End Date."""
  yearEndDate: Date
  """Year Key"""
  yearKey: String
  """Year Timespan."""
  yearTimespan: Float
}