# title : OPERA Cloud RnA ProfilesStayRecords GraphQL API,
# description : GraphQL API to cater for Provides information on Stay Records statistics of guest stay and its respective Membership Transactions details for a profile.
#               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!
}


# Conditional Mandatory filters:
# At least one filter from each required filter pair must be provided. 
# Please ensure the request includes at least one filter from each required pair. 
# Pair - [1] 
# 		 - stayrecordsDetailsChainCode 
# 		 - stayrecordsDetailsResort 
# Pair - [2] 
# 		 - stayrecordsDetailsAllotmentHeaderId 
# 		 - stayrecordsDetailsArrivalDate 
# 		 - stayrecordsDetailsCompanyNameId 
# 		 - stayrecordsDetailsDepartureDate 
# 		 - stayrecordsDetailsGroupNameId 
# 		 - stayrecordsDetailsGuestNameId 
# 		 - stayrecordsDetailsInternalShareId 
# 		 - stayrecordsDetailsJrnUpdateDttm 
# 		 - stayrecordsDetailsLegNo 
# 		 - stayrecordsDetailsLocalResvNameId 
# 		 - stayrecordsDetailsMembershipTrxLinkId 
# 		 - stayrecordsDetailsMiscNameId 
# 		 - stayrecordsDetailsPmsCompanyId 
# 		 - stayrecordsDetailsPmsGroupId 
# 		 - stayrecordsDetailsPmsMiscId 
# 		 - stayrecordsDetailsPmsNameId 
# 		 - stayrecordsDetailsPmsResvNameId 
# 		 - stayrecordsDetailsPmsResvNo 
# 		 - stayrecordsDetailsPmsTravelId 
# 		 - stayrecordsDetailsPmsWholesalerId 
# 		 - stayrecordsDetailsPosCode 
# 		 - stayrecordsDetailsRoomNumber 
# 		 - stayrecordsDetailsStayRecordId 
# 		 - stayrecordsDetailsTravelNameId 
# 		 - stayrecordsDetailsUpdateDate 
# 		 - stayrecordsDetailsWholesalerNameId 

input ProfilesStayRecordsQueryArgumentsType {
  """Allotment Header ID"""
  stayrecordsDetailsAllotmentHeaderId: FloatInput                       @conditionalInputPair(pair: 2)
  """Arrival"""
  stayrecordsDetailsArrivalDate: DateInput                              @conditionalInputPair(pair: 2)
  """Chain Code"""
  stayrecordsDetailsChainCode: StringInput                              @conditionalInputPair(pair: 1)
  """Company Name ID"""
  stayrecordsDetailsCompanyNameId: FloatInput                           @conditionalInputPair(pair: 2)
  """Departure"""
  stayrecordsDetailsDepartureDate: DateInput                            @conditionalInputPair(pair: 2)
  """Group Name ID"""
  stayrecordsDetailsGroupNameId: FloatInput                             @conditionalInputPair(pair: 2)
  """Guest Name ID"""
  stayrecordsDetailsGuestNameId: FloatInput                             @conditionalInputPair(pair: 2)
  """Internal Share ID"""
  stayrecordsDetailsInternalShareId: FloatInput                         @conditionalInputPair(pair: 2)
  """JRN Update Date and Time"""
  stayrecordsDetailsJrnUpdateDttm: DateTimeInput                        @conditionalInputPair(pair: 2)
  """Leg No"""
  stayrecordsDetailsLegNo: FloatInput                                   @conditionalInputPair(pair: 2)
  """Local Reservation Name ID"""
  stayrecordsDetailsLocalResvNameId: FloatInput                         @conditionalInputPair(pair: 2)
  """Membership TRX Link ID"""
  stayrecordsDetailsMembershipTrxLinkId: FloatInput                     @conditionalInputPair(pair: 2)
  """Misc Name ID"""
  stayrecordsDetailsMiscNameId: FloatInput                              @conditionalInputPair(pair: 2)
  """PMS  Group ID"""
  stayrecordsDetailsPmsGroupId: StringInput                             @conditionalInputPair(pair: 2)
  """PMS  Misc ID"""
  stayrecordsDetailsPmsMiscId: StringInput                              @conditionalInputPair(pair: 2)
  """PMS  Name ID"""
  stayrecordsDetailsPmsNameId: StringInput                              @conditionalInputPair(pair: 2)
  """PMS Company ID"""
  stayrecordsDetailsPmsCompanyId: StringInput                           @conditionalInputPair(pair: 2)
  """PMS Confirmation Number"""
  stayrecordsDetailsPmsResvNameId: StringInput                          @conditionalInputPair(pair: 2)
  """PMS Resv No"""
  stayrecordsDetailsPmsResvNo: StringInput                              @conditionalInputPair(pair: 2)
  """PMS Travel ID"""
  stayrecordsDetailsPmsTravelId: StringInput                            @conditionalInputPair(pair: 2)
  """PMS Wholesaler ID"""
  stayrecordsDetailsPmsWholesalerId: StringInput                        @conditionalInputPair(pair: 2)
  """POS Code"""
  stayrecordsDetailsPosCode: StringInput                                @conditionalInputPair(pair: 2)
  """Property"""
  stayrecordsDetailsResort: StringInput                                 @conditionalInputPair(pair: 1)
  """Room Number"""
  stayrecordsDetailsRoomNumber: StringInput                             @conditionalInputPair(pair: 2)
  """Source Name ID"""
  stayrecordsDetailsWholesalerNameId: FloatInput                        @conditionalInputPair(pair: 2)
  """Stay Record ID"""
  stayrecordsDetailsStayRecordId: FloatInput                            @conditionalInputPair(pair: 2)
  """Travel Agent Name ID"""
  stayrecordsDetailsTravelNameId: FloatInput                            @conditionalInputPair(pair: 2)
  """Update Date"""
  stayrecordsDetailsUpdateDate: DateInput                               @conditionalInputPair(pair: 2)
  """Adjustment Y/N"""
  membershiptransactionsDetailsAdjustmentYn: StringInput
  """Arrival Date"""
  membershiptransactionsDetailsBeginDate: DateInput
  """Points calculated automatically"""
  membershiptransactionsDetailsAutomaticYn: StringInput
  """Billing group for base award points."""
  membershiptransactionsDetailsBaseBillingGroup: StringInput
  """Billing Group"""
  membershiptransactionsDetailsBillingGroup: StringInput
  """Billing group for bonus award points."""
  membershiptransactionsDetailsBonusBillingGroup: StringInput
  """Booked Room Label"""
  membershiptransactionsDetailsBookedRoomLabel: StringInput
  """Central Xchange Date"""
  membershiptransactionsDetailsCXchangeDate: DateInput
  """CRS Booking Number"""
  membershiptransactionsDetailsCrsBookNo: StringInput
  """Chain Code"""
  membershiptransactionsDetailsChainCode: StringInput
  """Claim Adj Limit Code"""
  membershiptransactionsDetailsClaimAdjLimitCode: StringInput
  """Currency Code"""
  membershiptransactionsDetailsCurrencyCode: StringInput
  """Date when the record was exported."""
  membershiptransactionsDetailsDataExportedDate: DateInput
  """Flag to indicate if record was exported."""
  membershiptransactionsDetailsDataExportedYn: StringInput
  """Deleted Flag"""
  membershiptransactionsDetailsDeletedFlag: StringInput
  """Departure Date"""
  membershiptransactionsDetailsEndDate: DateInput
  """Exception Type"""
  membershiptransactionsDetailsExceptionType: StringInput
  """Point Expiration date."""
  membershiptransactionsDetailsPointsExpirationDate: DateTimeInput
  """This flag indicate if grace renewals was done."""
  membershiptransactionsDetailsGraceRenewalFlg: StringInput
  """Inactive Date"""
  membershiptransactionsDetailsInactiveDate: DateInput
  """Insert Date"""
  membershiptransactionsDetailsInsertDate: DateTimeInput
  """JRN Update Date and Time"""
  membershiptransactionsDetailsJrnupdatedttm: DateTimeInput
  """Member Statement ID"""
  membershiptransactionsDetailsMemberStatementId: FloatInput
  """Membership Card Number"""
  membershiptransactionsDetailsMembershipCardNo: StringInput
  """Membership ID"""
  membershiptransactionsDetailsMembershipId: FloatInput
  """Membership Level"""
  membershiptransactionsDetailsMembershipLevel: StringInput
  """Membership Trx ID"""
  membershiptransactionsDetailsMembershipTrxId: FloatInput
  """Membership Trx Link ID"""
  membershiptransactionsDetailsMembershipTrxLinkId: FloatInput
  """Membership Type"""
  membershiptransactionsDetailsMembershipType: StringInput
  """Multiple Membership ID"""
  membershiptransactionsDetailsMultipleMembershipId: FloatInput
  """Name ID"""
  membershiptransactionsDetailsNameId: FloatInput
  """Used in membership tier upgrade rule to indicate new membership level."""
  membershiptransactionsDetailsNewMemberLevel: StringInput
  """Notes"""
  membershiptransactionsDetailsUserNotes: StringInput
  """Internal ID to uniquely identify the Organization"""
  membershiptransactionsDetailsOrganizationid: FloatInput
  """Used in membership tier upgrade rule to indicate original member level was upgraded to."""
  membershiptransactionsDetailsOrigMemberLevel: StringInput
  """Date when points expired before it was extended."""
  membershiptransactionsDetailsOrigPointsExpirationDate: DateTimeInput
  """PMS Reservation Number"""
  membershiptransactionsDetailsPmsResvNo: StringInput
  """Ref to parent transaction."""
  membershiptransactionsDetailsParentMembershipTrxId: FloatInput
  """Pms Name ID"""
  membershiptransactionsDetailsPmsNameId: StringInput
  """Pms Resv Name ID"""
  membershiptransactionsDetailsPmsResvNameId: StringInput
  """Iindicate membership exceptions of back to back stay and multiple rooms. Valid values are YN and E."""
  membershiptransactionsDetailsPointsAcYn: StringInput
  """Flag to indicate if points are calculated."""
  membershiptransactionsDetailsPointsCalculatedYn: StringInput
  """Date when points were created."""
  membershiptransactionsDetailsPointsCreditDate: DateInput
  """Point reject reason."""
  membershiptransactionsDetailsPointsRejectedReason: StringInput
  """Rule code for adjustment transactions."""
  membershiptransactionsDetailsAdjRuleCode: StringInput
  """Population Method"""
  membershiptransactionsDetailsPopulationMethod: StringInput
  """Pos Code"""
  membershiptransactionsDetailsPosCode: StringInput
  """Internal Primary Key ID to uniquely identify the row"""
  membershiptransactionsDetailsPkid: FloatInput
  """Any error messages generated during calculation."""
  membershiptransactionsDetailsProcessingMessages: StringInput
  """Profile Promotion 1"""
  membershiptransactionsDetailsPromotionCode2: StringInput
  """Profile Promotion 2"""
  membershiptransactionsDetailsPromotionCode3: StringInput
  """Code to uniquely identify the Property"""
  membershiptransactionsDetailsResort: StringInput
  """Rate Promotion Code"""
  membershiptransactionsDetailsPromotionCode1: StringInput
  """Rate Promotion Description"""
  membershiptransactionsDetailsPromotionCode1Desc: StringInput
  """Record Type Code"""
  membershiptransactionsDetailsRecordType: StringInput
  """Record Type Description"""
  membershiptransactionsDetailsRecordTypeDesc: StringInput
  """Reservation Status"""
  membershiptransactionsDetailsResvStatus: StringInput
  """Room Label"""
  membershiptransactionsDetailsRoomLabel: StringInput
  """Stay Record ID"""
  membershiptransactionsDetailsStayRecordId: FloatInput
  """Type of action performed."""
  membershiptransactionsDetailsTierAction: StringInput
  """Transaction date."""
  membershiptransactionsDetailsMembershipTrxDate: DateInput
  """Transaction Type"""
  membershiptransactionsDetailsTransactionType: StringInput
  """Update Date"""
  membershiptransactionsDetailsUpdateDate: DateTimeInput
  """CRT Process Status"""
  stayrecordsmembershipsDetailsCtrProcessStatus: StringInput
  """Membership ID"""
  stayrecordsmembershipsDetailsMembershipId: FloatInput
  """Membership Type"""
  stayrecordsmembershipsDetailsMembershipType: StringInput
  """Name ID"""
  stayrecordsmembershipsDetailsNameId: FloatInput
  """Property"""
  stayrecordsmembershipsDetailsResort: StringInput
  """Record Type"""
  stayrecordsmembershipsDetailsRecordType: StringInput
  """Report ID"""
  stayrecordsmembershipsDetailsReportId: FloatInput
  """Stay Record ID"""
  stayrecordsmembershipsDetailsStayRecordId: FloatInput
}
type Query {
  """Provides information on Stay Records statistics of guest stay and its respective Membership Transactions details for a profile"""
  profilesStayRecords(limit: Int offset: Int input: ProfilesStayRecordsQueryArgumentsType!): [ProfilesStayRecordsType]
}
type ProfilesStayRecordsType {
  """Stay Records"""
  stayRecords: ProfilesStayRecordsStayRecordsType
  """Membership Transactions Details"""
  membershipTransactionsDetails: ProfilesStayRecordsMembershipTransactionsDetailsType
  """Stay Records Memberships"""
  stayRecordsMemberships: ProfilesStayRecordsStayRecordsMembershipsType
  profilesStayRecordsRecordCount: Int
}
type ProfilesStayRecordsStayRecordsType {
  """Address 1"""
  address1: String
  """Address 2"""
  address2: String
  """Address 3"""
  address3: String
  """Address 4"""
  address4: String
  """Adjustment YN"""
  adjustmentYN: String
  """Adults"""
  adults: Float
  """Allotment Code"""
  allotmentCode: String
  """Allotment Header ID"""
  allotmentHeaderID: Float
  """Arrival"""
  arrival: Date
  """Block Code"""
  averageRateAmount: Float
  """Base Rate Currency Code"""
  baseRateCurrencyCode: String
  """Booked Arrival Date"""
  bookedArrivalDate: Date
  """Booked Departure Date"""
  bookedDepartureDate: Date
  """Booked Room Type"""
  bookedRoomType: String
  """Booking Date"""
  bookingDate: Date
  """Central Base Rate Amount"""
  cCentralBaseRateAmount: Float
  """CRS Book No"""
  cRSBookNo: String
  """Cancellation Date"""
  cancellationDate: Date
  """Cancelled Room Nights"""
  cancelledRoomNights: Float
  """Central Base Rate Amount"""
  centralBaseRateAmount: Float
  """Central Currency"""
  centralCurrency: String
  """Central FB Revenue"""
  centralFBRevenue: Float
  """Central FB Revenue Tax"""
  centralFBRevenueTax: Float
  """Central Local Base Rate Amount"""
  centralLocalBaseRateAmount: Float
  """Central Misc Revenue"""
  centralMiscRevenue: Float
  """Central Misc Revenue Tax"""
  centralMiscRevenueTax: Float
  """Central Other Revenue"""
  centralOtherRevenue: Float
  """Central Other Revenue Tax"""
  centralOtherRevenueTax: Float
  """Central Room Revenue"""
  centralRoomRevenue: Float
  """Central Room Revenue Tax"""
  centralRoomRevenueTax: Float
  """Central Total Revenue"""
  centralTotalRevenue: Float
  """Central Xchange Date"""
  centralXchangeDate: Date
  """Central Xchange Rate"""
  centralXchangeRate: Float
  """Chain Code"""
  chainCode: String
  """Children"""
  children: Float
  """City"""
  city: String
  """Company Name"""
  companyName: String
  """Company Name ID"""
  companyNameID: Float
  """Complimentary"""
  complimentary: String
  """Country"""
  country: String
  """DSI"""
  dSI: Float
  """Daily Room Details YN"""
  dailyRoomDetailsYN: String
  """Deleted Flag"""
  deletedFlag: String
  """Departure"""
  departure: Date
  """Exchange Rate"""
  exchangeRate: Float
  """F&B Revenue"""
  fBRevenue: Float
  """F&B Revenue Tax"""
  fBRevenueTax: Float
  """Group Name"""
  groupName: String
  """Group Name ID"""
  groupNameID: Float
  """Guest Name"""
  guestName: String
  """Guest Name ID"""
  guestNameID: Float
  """IATA Consortia"""
  iATAConsortia: String
  """Insert Date"""
  insertDate: DateTime
  """Insert user"""
  insertUser: Float
  """Internal Share ID"""
  internalShareID: Float
  """JRN Update Date"""
  jRNUpdateDate: Date
  """JRN Update Date and Time"""
  jRNUpdateDateAndTime: DateTime
  """Leg No"""
  legNo: Float
  """Local Reservation Name ID"""
  localReservationNameID: Float
  """Market Code"""
  marketCode: String
  """Membership TRX Link ID"""
  membershipTRXLinkID: Float
  """Misc Name ID"""
  miscNameID: Float
  """Misc Revenue Tax"""
  miscRevenueTax: Float
  """Miscellaneous Revenue"""
  miscellaneousRevenue: Float
  """No Show Room Nights"""
  noShowRoomNights: Float
  """Number Stay"""
  numberStay: Float
  """Number of Nughts"""
  numberOfNughts: Float
  """Organization ID"""
  organizationID: Float
  """Origin Code"""
  originCode: String
  """Original Source"""
  originalSource: String
  """Other Revenue"""
  otherRevenue: Float
  """Other Revenue Tax"""
  otherRevenueTax: Float
  """PKID"""
  pKID: Float
  """PMS  Group ID"""
  pMSGroupID: String
  """PMS  Misc ID"""
  pMSMiscID: String
  """PMS  Name ID"""
  pMSNameID: String
  """PMS Company ID"""
  pMSCompanyID: String
  """PMS Confirmation Number"""
  pMSConfirmationNumber: String
  """PMS Resv No"""
  pMSResvNo: String
  """PMS Travel ID"""
  pMSTravelID: String
  """PMS Wholesaler ID"""
  pMSWholesalerID: String
  """POS Code"""
  pOSCode: String
  """Payment Method"""
  paymentMethod: String
  """Points YN"""
  pointsYN: String
  """Primary Sharer"""
  primarySharer: String
  """Promotion Code"""
  promotionCode: String
  """Promotion Code  2"""
  promotionCode2: String
  """Promotion Code  3"""
  promotionCode3: String
  """Promotion Code Desc"""
  promotionCodeDesc: String
  """Property"""
  property: String
  """Property Currency"""
  propertyCurrency: String
  """Pseudo YN"""
  pseudoYN: String
  """RNA Insert Date"""
  rNAInsertDate: DateTime
  """RNA Update Date"""
  rNAUpdateDate: DateTime
  """Rate"""
  rate: Float
  """Rate Code"""
  rateCode: String
  """Reservation Name ID"""
  reservationNameID: Float
  """Reservation Source Code"""
  reservationSourceCode: String
  """Reservation Source Type"""
  reservationSourceType: String
  """Reservation Status"""
  reservationStatus: String
  """Room Number"""
  roomNumber: String
  """Room Revenue"""
  roomRevenue: Float
  """Room Revenue Tax"""
  roomRevenueTax: Float
  """Room Type"""
  roomType: String
  """Share Number"""
  shareNumber: String
  """Source Code"""
  sourceCode: String
  """Source Name"""
  sourceName: String
  """Source Name ID"""
  sourceNameID: Float
  """Source Record Locator"""
  sourceRecordLocator: String
  """State"""
  state: String
  """Status"""
  status: String
  """Status Description"""
  statusDescription: String
  """Stay Record ID"""
  stayRecordID: Float
  """Total Revenue"""
  totalRevenue: Float
  """Travel Agent Name"""
  travelAgentName: String
  """Travel Agent Name ID"""
  travelAgentNameID: 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
  """UDFD01"""
  uDFD01: Date
  """UDFD02"""
  uDFD02: Date
  """UDFD03"""
  uDFD03: Date
  """UDFD04"""
  uDFD04: Date
  """UDFD05"""
  uDFD05: Date
  """UDFN01"""
  uDFN01: Float
  """UDFN02"""
  uDFN02: Float
  """UDFN03"""
  uDFN03: Float
  """UDFN04"""
  uDFN04: Float
  """UDFN05"""
  uDFN05: Float
  """Update Date"""
  updateDate: Date
  """Update User"""
  updateUser: Float
  """User Notes"""
  userNotes: String
}
type ProfilesStayRecordsMembershipTransactionsDetailsType {
  """Adjustment Y/N"""
  adjustmentYn: String
  """Arrival Date"""
  arrivalDate: Date
  """Points calculated automatically"""
  automaticYn: String
  """Average Rate Amount"""
  averageRateAmount: Float
  """Unique Identifier assigned to that award"""
  awardOrderNo: Float
  """Unique award request id."""
  awardRequestId: Float
  """Billing group for base award points."""
  baseBillingGroup: String
  """Base Nights"""
  baseNights: Float
  """Base Points"""
  basePoints: Float
  """Base Revenue"""
  baseRevenue: Float
  """Base Stay"""
  baseStay: Float
  """Billing Group"""
  billingGroup: String
  """Billing group for bonus award points."""
  bonusBillingGroup: String
  """Bonus Nights"""
  bonusNights: Float
  """Bonus Points"""
  bonusPoints: Float
  """Bonus Revenue"""
  bonusRevenue: Float
  """Bonus Stay"""
  bonusStay: Float
  """Booked Room Label"""
  bookedRoomLabel: String
  """Central Xchange Date"""
  cExchangeDate: Date
  """Central Xchange Rate"""
  cExchangeRate: Float
  """Central Total Eligible Credit Earn"""
  cTotalEligibleCreditEarn: Float
  """Central Total Revenue"""
  cTotalRevenue: Float
  """CRS Booking Number"""
  cRSBookingNumber: String
  """Central Base Revenue"""
  centralBaseRevenue: Float
  """Central Bonus Revenue"""
  centralBonusRevenue: Float
  """Central Points Cost"""
  centralPointsCost: Float
  """Chain Code"""
  chainCode: String
  """Claim Adj Limit Code"""
  claimAdjLimitCode: String
  """Currency Code"""
  currencyCode: String
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  dSI: Float
  """Date when the record was exported."""
  dataExportedDate: Date
  """Flag to indicate if record was exported."""
  dataExportedYn: String
  """Deleted Flag"""
  deletedFlag: String
  """Departure Date"""
  departureDate: Date
  """Exception Type"""
  exceptionType: String
  """Exchange rate ID for 'TRF' transactions."""
  exchRateId: Float
  """Point Expiration date."""
  expirationDate: DateTime
  """This flag indicate if grace renewals was done."""
  graceRenewalFlg: String
  """Inactive Date"""
  inactiveDate: Date
  """Insert Date"""
  insertDate: DateTime
  """Insert User"""
  insertUser: Float
  """JRN Update Date"""
  jRNUpdateDate: Date
  """JRN Update Date and Time"""
  jRNUpdateDateAndTime: DateTime
  """Member Statement ID"""
  memberStatementId: Float
  """Membership Card Number"""
  membershipCardNo: String
  """Membership ID"""
  membershipId: Float
  """Membership Level"""
  membershipLevel: String
  """Membership Trx ID"""
  membershipTransactionId: Float
  """Membership Trx Link ID"""
  membershipTransactionLinkId: Float
  """Membership Type"""
  membershipType: String
  """Miscellaneous Points"""
  miscPoints: Float
  """Multiple Membership ID"""
  multipleMembershipId: Float
  """Name ID"""
  nameId: Float
  """Used in membership tier upgrade rule to indicate new membership level."""
  newMemberLevel: String
  """Nights"""
  nights: Float
  """Nights Number"""
  nightsNo: Float
  """Notes"""
  notes: String
  """Points prior to this transaction"""
  oldBalancePoints: Float
  """Internal ID to uniquely identify the Organization"""
  organizationID: Float
  """Used in membership tier upgrade rule to indicate original member level was upgraded to."""
  origMemberLevel: String
  """Date when points expired before it was extended."""
  origPointsExpirationDate: DateTime
  """PMS Reservation Number"""
  pMSReservationNo: String
  """Ref to parent transaction."""
  parentMembershipTransactionId: Float
  """Pms Name ID"""
  pmsNameId: String
  """Pms Resv Name ID"""
  pmsReservationNameId: String
  """Iindicate membership exceptions of back to back stay and multiple rooms. Valid values are YN and E."""
  pointsAcYn: String
  """Flag to indicate if points are calculated."""
  pointsCalculationYN: String
  """Points Cost"""
  pointsCost: Float
  """Date when points were created."""
  pointsCreditDate: Date
  """Point reject reason."""
  pointsRejectedReason: String
  """Rule code for adjustment transactions."""
  pointsRule: String
  """Population Method"""
  populationMethod: String
  """Pos Code"""
  posCode: String
  """Internal Primary Key ID to uniquely identify the row"""
  primaryKeyID: Float
  """Any error messages generated during calculation."""
  processingMessages: String
  """Profile Promotion 1"""
  profilePromotion1: String
  """Profile Promotion 2"""
  profilePromotion2: String
  """Code to uniquely identify the Property"""
  property: String
  """Number of membership qualifying nights on a reservation."""
  qualifyingNights: Float
  """RNA Insert Date"""
  rNAInsertDate: DateTime
  """RNA Update Date"""
  rNAUpdateDate: DateTime
  """Rate Promotion Code"""
  ratePromotionCode: String
  """Rate Promotion Description"""
  ratePromotionDescription: String
  """Record Type Code"""
  recordTypeCode: String
  """Record Type Description"""
  recordTypeDescription: String
  """Reference"""
  reference: String
  """Reservation Name ID"""
  reservationNameID: Float
  """Reservation Status"""
  reservationStatus: String
  """Room Label"""
  roomLabel: String
  """Statement ID"""
  statementId: Float
  """Total stay."""
  stay: Float
  """Stay Record ID"""
  stayRecordId: Float
  """Type of action performed."""
  tierAction: String
  """Total monetary value of transactions on the guest account eligible to redeem Instant Award payments."""
  totalEligibleAwardRedeem: Float
  """Total monetary value of transactions on the guest account eligible to earn membership credits."""
  totalEligibleCreditEarn: Float
  """Total Points"""
  totalPoints: Float
  """Total Revenue"""
  totalRevenue: Float
  """Transaction date."""
  transactionDate: Date
  """Transaction Type"""
  transactionType: String
  """Update Date"""
  updateDate: DateTime
  """Update User"""
  updateUser: Float
  """Username"""
  username: String
}
type ProfilesStayRecordsStayRecordsMembershipsType {
  """CRT Code"""
  cRTCode: String
  """CRT Membership Level"""
  cRTMembershipLevel: String
  """CRT Process Status"""
  cRTProcessStatus: String
  """Central Exchange Date"""
  centralExchangeDate: Date
  """Central Exchange Rate"""
  centralExchangeRate: Float
  """Central Membership Base Revenue"""
  centralMembershipBaseRevenue: Float
  """Central Membership Bonus Revenue"""
  centralMembershipBonusRevenue: Float
  """Central Points Cost"""
  centralPointsCost: Float
  """Chain Code"""
  chainCode: String
  """DSI"""
  dSI: Float
  """Deleted Flag"""
  deletedFlag: String
  """Error Message"""
  errorMessage: String
  """JRN Update Date and Time"""
  jRNUpdateDateAndTime: DateTime
  """Membership Base Nights"""
  membershipBaseNights: Float
  """Membership Base Revenue"""
  membershipBaseRevenue: Float
  """Membership Base Stay"""
  membershipBaseStay: Float
  """Membership Bonus Nights"""
  membershipBonusNights: Float
  """Membership Bonus Revenue"""
  membershipBonusRevenue: Float
  """Membership Bonus Stay"""
  membershipBonusStay: Float
  """Membership ID"""
  membershipID: Float
  """Membership Level"""
  membershipLevel: String
  """Membership Number"""
  membershipNumber: String
  """Membership Type"""
  membershipType: String
  """Name ID"""
  nameID: Float
  """Name Role"""
  nameRole: String
  """Organization ID"""
  organizationID: Float
  """Points Computed Date"""
  pointsComputedDate: Date
  """Points Cost"""
  pointsCost: Float
  """Points Eligible YN"""
  pointsEligibleYN: String
  """Population Method"""
  populationMethod: String
  """Primary Key ID"""
  primaryKeyID: Float
  """Processing Message"""
  processingMessage: String
  """Promotion Code 1"""
  promotionCode1: String
  """Promotion Code 2"""
  promotionCode2: String
  """Promotion Code 3"""
  promotionCode3: String
  """Property"""
  property: String
  """RNA Insert Date"""
  rNAInsertDate: DateTime
  """RNA Update Date"""
  rNAUpdateDate: Date
  """Record Type"""
  recordType: String
  """Report ID"""
  reportID: Float
  """Stay Record ID"""
  stayRecordID: Float
  """Total Base Points"""
  totalBasePoints: Float
  """Total Bonus Points"""
  totalBonusPoints: Float
  """Total Misc Points"""
  totalMiscPoints: Float
  """Total Points"""
  totalPoints: Float
  """Valid YN"""
  validYN: String
}