# title : OPERA Cloud RnA SalesManagerGoals GraphQL API,
# description : GraphQL API to cater for The Sales Manager Goals subject Area enable the end users to retrieve information / create reports to compare the goals set for the Sales Managers against completed activities, and against statistical revenue data associated to profiles.
#               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. 
# 		 - salesmanagerDetailsSrepCode


input SalesManagerGoalsQueryArgumentsType {
  """Chain Code"""
  salesmanagerDetailsChainCode: StringInput
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  salesmanagerDetailsDsi: FloatInput
  """First Name"""
  salesmanagerDetailsFirst: StringInput
  """JRN Update Date and Time"""
  salesmanagerDetailsJrnupdatedttm: DateTimeInput
  """Last Name"""
  salesmanagerDetailsLast: StringInput
  """Name ID"""
  salesmanagerDetailsNameId: FloatInput
  """Internal ID to uniquely identify the Organization"""
  salesmanagerDetailsOrganizationid: FloatInput
  """Owner Code"""
  salesmanagerDetailsSrepCode: StringInput!                             @mandatoryInput
  """Activity Type"""
  employeegoalDetailsActType: StringInput
  """Activitytypeid"""
  employeegoalDetailsActivitytypeid: StringInput
  """Budget Type"""
  employeegoalDetailsBudgetType: StringInput
  """Central Xchange Date"""
  employeegoalDetailsCXchangeDate: DateInput
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  employeegoalDetailsDsi: FloatInput
  """Employeegoalid"""
  employeegoalDetailsEmployeegoalid: FloatInput
  """Employeeid"""
  employeegoalDetailsEmployeeid: FloatInput
  """JRN Update Date and Time"""
  employeegoalDetailsJrnupdatedttm: DateTimeInput
  """Internal ID to uniquely identify the Property"""
  employeegoalDetailsLocationid: StringInput
  """Internal ID to uniquely identify the Organization"""
  employeegoalDetailsOrganizationid: FloatInput
  """Period Code"""
  employeegoalDetailsPeriodCode: StringInput
  """Period Type"""
  employeegoalDetailsPeriodType: StringInput
  """Code to uniquely identify the Property"""
  employeegoalDetailsResort: StringInput
  """Primary Key"""
  employeegoalDetailsGoalId: FloatInput
  """Goal Types"""
  employeegoalDetailsGoalType: StringInput
  """User ID"""
  employeegoalDetailsNameId: FloatInput
  """Year ID"""
  employeegoalDetailsYearId: FloatInput
  """Activity Completed"""
  workordersDetailsCompletedYn: StringInput
  """Activity Created On"""
  workordersDetailsCreatedDate: DateTimeInput
  """Activity End Date"""
  workordersDetailsEndDate: DateTimeInput
  """Activity ID"""
  workordersDetailsWoNumber: FloatInput
  """Description of the Problem reported"""
  workordersDetailsProblemDesc: StringInput
  """Activity Priority"""
  workordersDetailsPriorityCode: StringInput
  """Activity Start Date"""
  workordersDetailsStartDate: DateTimeInput
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  workordersDetailsDsi: FloatInput
  """Est Uot Code"""
  workordersDetailsEstUotCode: StringInput
  """JRN Update Date and Time"""
  workordersDetailsJrnupdatedttm: DateTimeInput
  """Location Code"""
  workordersDetailsLocationCode: StringInput
  """Internal ID to uniquely identify the Property"""
  workordersDetailsLocationid: StringInput
  """Internal ID to uniquely identify the Organization"""
  workordersDetailsOrganizationid: FloatInput
  """Wo_number to which current work order is a sub work ordergenerated work_order number"""
  workordersDetailsParentWoNumber: FloatInput
  """Plant Item Code"""
  workordersDetailsPlantItemCode: StringInput
  """Code to uniquely identify the Property"""
  workordersDetailsResort: StringInput
  """Reason Code"""
  workordersDetailsReasonCode: StringInput
  """Request type that need to be generated."""
  workordersDetailsRequestTypeId: StringInput
  """Stores the Campaign Type Template ID used for a campaign."""
  workordersDetailsRequestTypeTemplatesId: FloatInput
  """Status Code"""
  workordersDetailsStatusCode: StringInput
  """Linked Survey ID"""
  workordersDetailsSurveyId: FloatInput
  """Task Code"""
  workordersDetailsTaskCode: FloatInput
  """Taskitem Number"""
  workordersDetailsTaskitemNumber: FloatInput
  """Type Code"""
  workordersDetailsTypeCode: StringInput
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  owneraccountdailystatDetailsDsi: FloatInput
  """Organization ID"""
  owneraccountdailystatDetailsOrganizationId: FloatInput
  """JRN Update Date and Time"""
  owneraccountdailystatDetailsJrnupdatedttm: DateTimeInput
  """Location ID"""
  owneraccountdailystatDetailsLocationId: StringInput
  """Name ID"""
  owneraccountdailystatDetailsNameId: FloatInput
  """Internal ID to uniquely identify the Organization"""
  owneraccountdailystatDetailsOrganizationid: FloatInput
  """Owner Profile ID"""
  owneraccountdailystatDetailsOwnerProfileId: FloatInput
  """Profile Owner ID"""
  owneraccountdailystatDetailsProfileOwnerId: FloatInput
  """Property"""
  owneraccountdailystatDetailsResort: StringInput
  """User ID"""
  owneraccountdailystatDetailsUserId: FloatInput
}
type Query {
  """The Sales Manager Goals subject Area enable the end users to retrieve information / create reports to compare the goals set for the Sales Managers against completed activities and against statistical revenue data associated to profiles."""
  salesManagerGoals(limit: Int offset: Int input: SalesManagerGoalsQueryArgumentsType!): [SalesManagerGoalsType]
}
type SalesManagerGoalsType {
  """Sales Manager Details"""
  salesManagerDetails: SalesManagerGoalsSalesManagerDetailsType
  """Employee Goal Details"""
  employeeGoalDetails: SalesManagerGoalsEmployeeGoalDetailsType
  """Work Orders Details"""
  workOrdersDetails: SalesManagerGoalsWorkOrdersDetailsType
  """Owner Account Daily Statistics"""
  ownerAccountDailyStatisticsDetails: SalesManagerGoalsOwnerAccountDailyStatisticsDetailsType
  salesManagerGoalsRecordCount: Int
}
type SalesManagerGoalsSalesManagerDetailsType {
  """Chain Code"""
  chainCode: String
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  dSI: Float
  """First Name"""
  firstName: String
  """Full Name"""
  fullName: String
  """JRN Update Date"""
  jRNUpdateDate: Date
  """JRN Update Date and Time"""
  jRNUpdateDateAndTime: DateTime
  """Last Name"""
  lastName: String
  """Middle Name"""
  middleName: String
  """Name ID"""
  nameId: Float
  """Internal ID to uniquely identify the Organization"""
  organizationID: Float
  """Owner Code"""
  ownerCode: String
  """Internal Primary Key ID to uniquely identify the row"""
  primaryKeyID: Float
  """RNA Insert Date"""
  rNAInsertDate: DateTime
  """RNA Update Date"""
  rNAUpdateDate: DateTime
}
type SalesManagerGoalsEmployeeGoalDetailsType {
  """Number of Activities"""
  activityNumber: Float
  """Activity Type"""
  activityType: String
  """Activitytypeid"""
  activitytypeid: String
  """App Insert User"""
  appInsertUser: String
  """App Update User"""
  appUpdateUser: String
  """Arrival Period End Date"""
  arrivalEndDate: Date
  """Arrival Goal if Y"""
  arrivalGoalYN: String
  """Arrival Period Start"""
  arrivalStartDate: Date
  """Arrivalgoalflag"""
  arrivalgoalflag: String
  """Au Srep Code"""
  auSrepCode: String
  """Budget Type"""
  budgetType: String
  """Central Catering Avg Check"""
  cCateringAvgCheck: Float
  """Central Catering Fb Revenue"""
  cCateringFBRevenue: Float
  """Central Catering Other Revenue"""
  cCateringOtherRevenue: Float
  """Central Xchange Date"""
  cExchangeDate: Date
  """Central Xchange Rate"""
  cExchangeRate: Float
  """Central Room Avg Rate"""
  cRoomAvgRate: Float
  """Central Room Revenue"""
  cRoomRevenue: Float
  """Average Guestcheck per period"""
  cateringAverageCheck: Float
  """Catering Covers per period"""
  cateringCovers: Float
  """Food/Beverage Revenue per period"""
  cateringFBRevenue: Float
  """Other Revenue per period"""
  cateringOtherRevenue: Float
  """Central Activity Type"""
  centralActivityType: String
  """Central Market Code"""
  centralMarketCode: String
  """Chain Code"""
  chainCode: String
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  dSI: Float
  """Deleted Flag"""
  deletedFlag: String
  """Employeegoalid"""
  employeegoalid: Float
  """Employeeid"""
  employeeid: Float
  """First Name"""
  firstName: String
  """Full Name"""
  fullName: String
  """Inactive Date"""
  inactiveDate: Date
  """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
  """Laptop Change"""
  laptopChange: Float
  """Last Name"""
  lastName: String
  """Internal ID to uniquely identify the Property"""
  locationID: String
  """Market Code"""
  marketCode: String
  """Marketid"""
  marketid: String
  """Middle Name"""
  middleName: String
  """Internal ID to uniquely identify the Organization"""
  organizationID: Float
  """Period Code"""
  periodCode: String
  """Period Type"""
  periodType: String
  """Internal Primary Key ID to uniquely identify the row"""
  primaryKeyID: Float
  """Production Period End Date"""
  productionEndDate: Date
  """Production Period Start"""
  productionStartDate: Date
  """Code to uniquely identify the Property"""
  property: String
  """RnA Insertdate"""
  rnaInsertDate: DateTime
  """RnA Updatedate"""
  rnaUpdateDate: DateTime
  """Room Avg Rate"""
  roomAvgRate: Float
  """Room Nights"""
  roomNights: Float
  """Room Revenue"""
  roomRevenue: Float
  """Primary Key"""
  salesGoalID: Float
  """Srep Code"""
  srepCode: String
  """Goal Types"""
  type: String
  """Update Date"""
  updateDate: DateTime
  """Update User"""
  updateUser: Float
  """User ID"""
  userID: Float
  """Year ID"""
  yearId: Float
}
type SalesManagerGoalsWorkOrdersDetailsType {
  """Account All"""
  accountAll: String
  """Total amount for the specific Activity."""
  activityAmount: Float
  """Activity Class"""
  activityClass: String
  """Activity Completed"""
  activityCompleted: String
  """Activity Completed By"""
  activityCompletedBy: String
  """Activity Completion Date"""
  activityCompletionDate: Float
  """Activity Created By"""
  activityCreatedBy: String
  """Activity Created On"""
  activityCreatedOn: DateTime
  """Activity End Date"""
  activityEndDate: DateTime
  """Activity ID"""
  activityID: Float
  """Description of the Problem reported"""
  activityName: String
  """Activity Notes"""
  activityNotes: String
  """Activity Owner Code"""
  activityOwnerCode: DateTime
  """Activity Priority"""
  activityPriority: String
  """Activity Result"""
  activityResult: String
  """Activity Start Date"""
  activityStartDate: DateTime
  """Activity Trace Code"""
  activityTraceCode: String
  """Activity Type"""
  activityType: String
  """Activity Type Description"""
  activityTypeDescription: String
  """Activity Updated By"""
  activityUpdatedBy: String
  """Activity Updated On"""
  activityUpdatedOn: DateTime
  """Activity User Name ID"""
  activityUserNameID: String
  """User who assigned the task."""
  assignedBy: Float
  """Date on which this work order was assigned to someone else"""
  assignedOnDate: DateTime
  """Attachment Location"""
  attachmentLocation: String
  """Owner who created this attachment. [ACCOUNT CONTACT ACTIVITY or BOOKING]"""
  attachmentOwner: String
  """Attendees"""
  attendees: Float
  """Author"""
  author: Float
  """Block All"""
  blockAll: String
  """Central Activity Amount"""
  cActivityAmount: Float
  """Central Deposit Amount"""
  cDepositAmount: Float
  """Central Est Cat Revenue"""
  cEstCateringRevenue: Float
  """Central Est Other Revenue"""
  cEstOtherRevenue: Float
  """Central Est Rm Revenue"""
  cEstRoomRevenue: Float
  """Central Xchange Date"""
  cExchangeDate: Date
  """Central Xchange Rate"""
  cExchangeRate: Float
  """Central Total Labor Cost"""
  cTotalLaborCost: Float
  """Central Total Parts Cost"""
  cTotalPartsCost: Float
  """Stores the status codes for Campaign Management"""
  campaignStatusCode: String
  """Category Code"""
  categoryCode: String
  """Central Activity Type"""
  centralActivityType: String
  """Central Activity Type Description"""
  centralActivityTypeDescription: String
  """Chain Code"""
  chainCode: String
  """Completed By"""
  completedBy: Float
  """Contact All"""
  contactAll: String
  """Created By"""
  createdBy: Float
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  dSI: Float
  """Database ID"""
  databaseId: String
  """Deleted Flag"""
  deletedFlag: String
  """This defines the oprder of execution between two sub work orders as one of them may be dependent on the other."""
  dependingOnWoNumber: Float
  """Deposit Amount"""
  depositAmount: Float
  """Owner of the Deposit. It can be Opera (O) or Cencept (C)."""
  depositOwner: String
  """Dept to which the employee who created the work order belongs"""
  deptOfAction: String
  """Download Date"""
  downloadDate: DateTime
  """Download Property"""
  downloadResort: String
  """Download Srep"""
  downloadSrep: Float
  """Due Date"""
  dueDate: DateTime
  """End Time"""
  endTime: String
  """Estimated revenue."""
  estCatRevenue: Float
  """Estimated others revenue."""
  estOtherRevenue: Float
  """Estimated room nights."""
  estRoomNights: Float
  """Estimated room revenue."""
  estRoomRevenue: Float
  """Time estimated to complete the work order"""
  estTimeToComplete: Float
  """Est Uot Code"""
  estUotCode: String
  """External System"""
  externalSystem: String
  """External System ID."""
  externalSystemId: String
  """Room status at the tome of creation of work order if it happens to be in a room"""
  foRoomStatus: String
  """Full Name"""
  fullName: String
  """Indicates if a Campain generated this activity."""
  generatedByCampaign: String
  """The frequency ID which generated this activity."""
  generatedByFreqId: Float
  """Global Y/N"""
  globalYn: String
  """Whether the work order is guest originated or not"""
  guestOriginatedYn: String
  """Whether this location is a a guest room or not"""
  guestRoomYn: String
  """Guest Type"""
  guestType: String
  """Whether the work order is having high priority or not."""
  highPriorityYn: String
  """Inactive Date"""
  inactiveDate: DateTime
  """Insert Date"""
  insertDate: DateTime
  """Insert User"""
  insertUser: Float
  """Internal Y/N"""
  internalYn: String
  """JRN Update Date"""
  jRNUpdateDate: Date
  """JRN Update Date and Time"""
  jRNUpdateDateAndTime: DateTime
  """Laptop Change"""
  laptopChange: Float
  """Location Code"""
  locationCode: String
  """Internal ID to uniquely identify the Property"""
  locationID: String
  """Decides whether a particular workorder is a master or sub or none."""
  masterSub: String
  """Number of minutes before the activity start time when the alert will be raised. (Default value)"""
  minutesBeforeAlert: Float
  """Name ID"""
  nameID: Float
  """Has the user been notified about this activity ?"""
  notifiedYn: String
  """Internal ID to uniquely identify the Organization"""
  organizationID: Float
  """Stores the original WORK_NUMBER prior to a migration."""
  origWoNumber: Float
  """Owner Email"""
  ownerEmail: String
  """Phone no."""
  ownerPhone: String
  """Owner Title"""
  ownerTitle: String
  """Wo_number to which current work order is a sub work ordergenerated work_order number"""
  parentWoNumber: Float
  """Plant Item Code"""
  plantItemCode: String
  """Internal Primary Key ID to uniquely identify the row"""
  primaryKeyID: Float
  """Whether the priority was manually changed or not"""
  priorityChangedYn: String
  """Private Y/N"""
  privateYn: String
  """Code to uniquely identify the Property"""
  property: String
  """Proposal Sent Date"""
  proposalSentDate: DateTime
  """Proposal View Token"""
  proposalViewToken: String
  """Reason Code"""
  reasonCode: String
  """Emp number of the person who has released this workorder"""
  releasedBy: Float
  """Date on which a work orderwas released"""
  releasedDate: DateTime
  """Stores the request template ID for Campaign Management."""
  requestTemplateId: Float
  """Request type that need to be generated."""
  requestTypeId: String
  """Stores the Campaign Type Template ID used for a campaign."""
  requestTypeTemplatesId: Float
  """RnA Insertdate"""
  rnaInsertDate: DateTime
  """RnA Updatedate"""
  rnaUpdateDate: DateTime
  """Room"""
  room: String
  """Default method for sending a Request Type."""
  sendMethod: String
  """Scheduled workorder .reminder to display on date"""
  showOn: DateTime
  """Start Time"""
  startTime: String
  """Status Code"""
  statusCode: String
  """Linked Survey ID"""
  surveyId: Float
  """Empnumber of the person who has accepted this workorder"""
  takenBy: Float
  """Date on which an employee has accepted this workorder"""
  takenDate: DateTime
  """Task Code"""
  taskCode: Float
  """Taskitem Number"""
  taskitemNumber: Float
  """Indicated if the activity times are converted to database time zone."""
  timezoneConvertedYn: String
  """Calculated Labor cost spent for this workorder"""
  totalLaborCost: Float
  """Calculate total parts cost spent for this workorder"""
  totalPartsCost: Float
  """Type Code"""
  typeCode: String
  """Update User"""
  updateUser: Float
  """Upload Date"""
  uploadDate: DateTime
  """Extension of the user"""
  userExt: String
}
type SalesManagerGoalsOwnerAccountDailyStatisticsDetailsType {
  """Account Owner"""
  accountOwner: String
  """Account Owner Code"""
  accountOwnerCode: String
  """Account Owner Email"""
  accountOwnerEmail: String
  """Phone no."""
  accountOwnerPhone: String
  """Account Owner Title"""
  accountOwnerTitle: String
  """Account Srep Code"""
  accountSrepCode: String
  """Average Daily Rate"""
  adr: Float
  """Central Xchange Date"""
  cExchangeDate: Date
  """Central Xchange Rate"""
  cExchangeRate: Float
  """Central Grp Fb Revenue"""
  cGroupFBRevenue: Float
  """Central Grp Fb Revenue Tax"""
  cGroupFBRevenueTax: Float
  """Central Grp Other Revenue"""
  cGroupOtherRevenue: Float
  """Central Grp Other Revenue Tax"""
  cGroupOtherRevenueTax: Float
  """Central Grp Room Revenue"""
  cGroupRoomRevenue: Float
  """Central Grp Room Revenue Tax"""
  cGroupRoomRevenueTax: Float
  """Central Grp Total Revenue"""
  cGroupTotalRevenue: Float
  """Central Grp Total Revenue Tax"""
  cGroupTotalRevenueTax: Float
  """Central Total Fb Revenue"""
  cTotalFBRevenue: Float
  """Central Total Fb Revenue Tax"""
  cTotalFBRevenueTax: Float
  """Central Total Other Revenue"""
  cTotalOtherRevenue: Float
  """Central Total Other Revenue Tax"""
  cTotalOtherRevenueTax: Float
  """Central Total Room Revenue"""
  cTotalRoomRevenue: Float
  """Central Total Room Revenue Tax"""
  cTotalRoomRevenueTax: Float
  """Central Total Total Revenue"""
  cTotalTotalRevenue: Float
  """Central Total Total Revenue Tax"""
  cTotalTotalRevenueTax: Float
  """Central Individual FB Revenue Net"""
  centralIndividualFBRevenueNet: Float
  """Central Individual FB Revenue Tax"""
  centralIndividualFBRevenueTax: Float
  """Central Individual Other Revenue Net"""
  centralIndividualOtherRevenueNet: Float
  """Central Individual Other Revenue Tax"""
  centralIndividualOtherRevenueTax: Float
  """Central Individual Room Revenue Net"""
  centralIndividualRoomRevenueNet: Float
  """Central Individual Room Revenue Tax"""
  centralIndividualRoomRevenueTax: Float
  """Central Individual Total Revenue Net"""
  centralIndividualTotalRevenueNet: Float
  """Central Individual Total Revenue Tax"""
  centralIndividualTotalRevenueTax: Float
  """Chain Code"""
  chainCode: String
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  dSI: Float
  """Deleted Flag"""
  deletedFlag: String
  """Description"""
  description: String
  """Group Adr"""
  grpAverageDailyRate: Float
  """Group F&B Revenue."""
  grpFBRevenue: Float
  """Group F&B Revenue Tax."""
  grpFBRevenueTax: Float
  """Group Number of Cancellations."""
  grpNumberCancels: Float
  """Group Number of Nights."""
  grpNumberNights: Float
  """Group Number of No Shows."""
  grpNumberNumberShows: Float
  """Group Number of Stays."""
  grpNumberStays: Float
  """Group Other Revenue."""
  grpOtherRevenue: Float
  """Group Other Revenue Tax."""
  grpOtherRevenueTax: Float
  """Group Room Revenue."""
  grpRoomRevenue: Float
  """Group Room Revenue Tax."""
  grpRoomRevenueTax: Float
  """Group Total Revenue."""
  grpTotalRevenue: Float
  """Group Total Revenue Tax."""
  grpTotalRevenueTax: Float
  """Inactive Date"""
  inactiveDate: DateTime
  """Inactive Flag"""
  inactiveFlag: String
  """Individual Cancels"""
  individualCancels: Float
  """Individual FB Revenue Net"""
  individualFBRevenueNet: Float
  """F&B Revenue Tax."""
  individualFBRevenueTax: Float
  """Individual Number Shows"""
  individualNoShows: Float
  """Individual Other Revenue Net"""
  individualOtherRevenueNet: Float
  """Individual Other Revenue Tax"""
  individualOtherRevenueTax: Float
  """Individual Room Nights"""
  individualRoomNights: Float
  """Individual Room Revenue Net"""
  individualRoomRevenueNet: Float
  """Individual Stays"""
  individualStays: Float
  """Individual Total Revenue Net"""
  individualTotalRevenueNet: Float
  """Individual Total Revenue Tax"""
  individualTotalRevenueTax: Float
  """Insert Date"""
  insertDate: DateTime
  """Insert User"""
  insertUser: Float
  """Organization ID"""
  internalOrganizationId: Float
  """JRN Update Date"""
  jRNUpdateDate: Date
  """JRN Update Date and Time"""
  jRNUpdateDateAndTime: DateTime
  """Laptop Change"""
  laptopChange: Float
  """Local Currency Code."""
  localCurrency: String
  """Location ID"""
  locationId: String
  """Name ID"""
  nameId: Float
  """Name Type"""
  nameType: String
  """Internal ID to uniquely identify the Organization"""
  organizationID: Float
  """Owner Profile ID"""
  ownerProfileId: Float
  """Internal Primary Key ID to uniquely identify the row"""
  primaryKeyID: Float
  """Primary YN"""
  primaryYN: String
  """Profile Owner ID"""
  profileOwnerId: Float
  """Indicates if the value set for the specific property."""
  property: String
  """Relationship"""
  relationship: String
  """Relationshipid"""
  relationshipid: String
  """Property"""
  resort: String
  """RnA Insertdate"""
  rnaInsertDate: DateTime
  """RnA Updatedate"""
  rnaUpdateDate: DateTime
  """Room Revenue Tax"""
  roomRevenueTax: Float
  """Stay Date"""
  stayDate: Date
  """Month of Summary. Stores Year and Month as YYYYMM."""
  stayMonth: Float
  """Year of Summary."""
  stayYear: Float
  """To Type"""
  toType: String
  """Total Average Daily Rate"""
  totalAdr: Float
  """Total FB Revenue"""
  totalFbRevenue: Float
  """Total FB Revenue Tax"""
  totalFbRevenueTax: Float
  """Total Number Cancels"""
  totalNumberCancels: Float
  """Total Number Nights"""
  totalNumberNights: Float
  """Total Number Number Shows"""
  totalNumberNoShows: Float
  """Total Number Stays"""
  totalNumberStays: Float
  """Total Other Revenue"""
  totalOtherRevenue: Float
  """Total Other Revenue Tax"""
  totalOtherRevenueTax: Float
  """Total Room Revenue"""
  totalRoomRevenue: Float
  """Total Room Amount (Inc Packages and Taxes) for the Stay."""
  totalRoomRevenueTax: Float
  """Total Total Revenue"""
  totalTotalRevenue: Float
  """Total Total Revenue Tax"""
  totalTotalRevenueTax: Float
  """Update Date"""
  updateDate: DateTime
  """Update User"""
  updateUser: Float
  """User ID"""
  userId: Float
}