# title : OPERA Cloud RnA ProfilesLoyalty GraphQL API,
# description : GraphQL API to cater for Detailed information on the Loyalty Program providing details on the Membership, Profiles, Stay Information and the ability to  track Awards and Claims.
#               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. 
# 		 - loyaltyprofilemembershipDetailsMembershipType


input ProfilesLoyaltyQueryArgumentsType {
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  loyaltyprofilemembershipDetailsDsi: FloatInput
  """Device Code"""
  loyaltyprofilemembershipDetailsDeviceCode: StringInput
  """Inactive Date"""
  loyaltyprofilemembershipDetailsInactiveDate: DateTimeInput
  """JRN Update Date and Time"""
  loyaltyprofilemembershipDetailsJrnupdatedttm: DateTimeInput
  """Membership Card Number"""
  loyaltyprofilemembershipDetailsMembershipCardNo: StringInput
  """Primary key of this table"""
  loyaltyprofilemembershipDetailsMembershipClass: StringInput
  """Membership ID"""
  loyaltyprofilemembershipDetailsMembershipId: FloatInput
  """Membership Level"""
  loyaltyprofilemembershipDetailsMembershipLevel: StringInput
  """Membership Type"""
  loyaltyprofilemembershipDetailsMembershipType: StringInput!           @mandatoryInput
  """Name ID"""
  loyaltyprofilemembershipDetailsNameId: FloatInput
  """Internal ID to uniquely identify the Organization"""
  loyaltyprofilemembershipDetailsOrganizationid: FloatInput
  """Membership ID that accrues Miles."""
  loyaltyprofilemembershipDetailsPartnerMembershipId: FloatInput
  """Update Date"""
  loyaltyprofilemembershipDetailsUpdateDate: DateTimeInput
  """JRN Update Date and Time"""
  membershipbenefitsDetailsJrnupdatedttm: DateTimeInput
  """Approval Status"""
  membershipclaimDetailsApprovalStatus: StringInput
  """Approve/Reject/None"""
  membershipclaimDetailsApproveReject: StringInput
  """Arrival Date"""
  membershipclaimDetailsArrivalDate: DateInput
  """Central Xchange Date"""
  membershipclaimDetailsCXchangeDate: DateInput
  """Information about the caller."""
  membershipclaimDetailsCallerInformation: StringInput
  """name of the person who called."""
  membershipclaimDetailsCallerName: StringInput
  """Chain Code"""
  membershipclaimDetailsChainCode: StringInput
  """Channel"""
  membershipclaimDetailsChannel: StringInput
  """Claim Adj Limit Code"""
  membershipclaimDetailsClaimAdjLimitCode: StringInput
  """Date claim was posted in the database."""
  membershipclaimDetailsClaimDate: DateInput
  """Primary key."""
  membershipclaimDetailsMembershipClaimId: FloatInput
  """User defined origin of claim."""
  membershipclaimDetailsClaimOrigin: StringInput
  """Source of the Claim"""
  membershipclaimDetailsClaimSource: StringInput
  """Status of the claim."""
  membershipclaimDetailsClaimStatus: StringInput
  """User Defined Claim Types"""
  membershipclaimDetailsClaimType: StringInput
  """Date and time cashier was closed."""
  membershipclaimDetailsCloseDate: DateInput
  """Comments"""
  membershipclaimDetailsComments: StringInput
  """Confirmation Number"""
  membershipclaimDetailsPmsResvNo: StringInput
  """Deleted Flag"""
  membershipclaimDetailsDeletedFlag: StringInput
  """Departure Date"""
  membershipclaimDetailsDepartureDate: DateInput
  """External Reference Number"""
  membershipclaimDetailsCrsBookNo: StringInput
  """Insert Date"""
  membershipclaimDetailsInsertDate: DateTimeInput
  """JRN Update Date and Time"""
  membershipclaimDetailsJrnupdatedttm: DateTimeInput
  """Market Code"""
  membershipclaimDetailsMarketCode: StringInput
  """Membership Claim Property"""
  membershipclaimDetailsResort: StringInput
  """Membership ID"""
  membershipclaimDetailsMembershipId: FloatInput
  """Membership Number"""
  membershipclaimDetailsMembershipCardNo: StringInput
  """Membership Trx ID"""
  membershipclaimDetailsMembershipTrxId: FloatInput
  """Membership Type"""
  membershipclaimDetailsMembershipType: StringInput
  """Name"""
  membershipclaimDetailsName: StringInput
  """Name ID"""
  membershipclaimDetailsNameId: FloatInput
  """Origin of Booking"""
  membershipclaimDetailsOriginOfBooking: StringInput
  """Owner"""
  membershipclaimDetailsClaimOwnerName: StringInput
  """Purpose of stay."""
  membershipclaimDetailsPurposeOfStay: StringInput
  """Rate Code"""
  membershipclaimDetailsRateCode: StringInput
  """Record Type"""
  membershipclaimDetailsRecordType: StringInput
  """Date when the user gets a response to his/her claim."""
  membershipclaimDetailsReplyByDate: DateInput
  """Reservation Status"""
  membershipclaimDetailsResvStatus: StringInput
  """Room"""
  membershipclaimDetailsRoom: StringInput
  """Submitter"""
  membershipclaimDetailsSubmitter: StringInput
  """Update Date"""
  membershipclaimDetailsUpdateDate: DateTimeInput
  """JRN Update Date and Time"""
  membershiphistoryDetailsJrnupdatedttm: DateTimeInput
  """JRN Update Date and Time"""
  membershipissuedawardsDetailsJrnupdatedttm: DateTimeInput
  """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
  """JRN Update Date and Time"""
  membershiptscheaderDetailsJrnupdatedttm: DateTimeInput
}
type Query {
  """Detailed information on the Loyalty Program providing details on the Membership Profiles Stay Information and the ability to  track Awards and Claims."""
  profilesLoyalty(limit: Int offset: Int input: ProfilesLoyaltyQueryArgumentsType!): [ProfilesLoyaltyType]
}
type ProfilesLoyaltyType {
  """Loyalty Profile Membership Details"""
  loyaltyProfileMembershipDetails: ProfilesLoyaltyLoyaltyProfileMembershipDetailsType
  """Membership Benefits Details"""
  membershipBenefitsDetails: ProfilesLoyaltyMembershipBenefitsDetailsType
  """Membership Claim Details"""
  membershipClaimDetails: ProfilesLoyaltyMembershipClaimDetailsType
  """Membership History Details"""
  membershipHistoryDetails: ProfilesLoyaltyMembershipHistoryDetailsType
  """Membership Issued Awards Details"""
  membershipIssuedAwardsDetails: ProfilesLoyaltyMembershipIssuedAwardsDetailsType
  """Membership Transactions Details"""
  membershipTransactionsDetails: ProfilesLoyaltyMembershipTransactionsDetailsType
  """Membership Transaction Header"""
  membershipTransactionHeaderDetails: ProfilesLoyaltyMembershipTransactionHeaderDetailsType
  """Expire Points By Date Details"""
  expirePointsByDateDetails: ProfilesLoyaltyExpirePointsByDateDetailsType
  profilesLoyaltyRecordCount: Int
}
type ProfilesLoyaltyLoyaltyProfileMembershipDetailsType {
  """Indicates if program allows Ad Hoc multipliers for points calculation."""
  allowAdhocMultiplierYn: String
  """Allow Dup Card Y/N"""
  allowDupCardYn: String
  """Flag indicating if points should be calculated for shared rooms."""
  allowSharesYn: String
  """This is used when the card no is auto generated and is based on some other value  like enrollment code."""
  autoCardNoBasedOn: String
  """Not used"""
  awardGenerationMethod: String
  """Not used"""
  batchDelayPeriod: Float
  """Flag to mark the booker program membership types."""
  bookerProgramYn: String
  """Central Cost Per Point"""
  cCostPerPoint: Float
  """Central Credit Limit"""
  cCreditLimit: Float
  """Central Xchange Date"""
  cExchangeDate: Date
  """Central Xchange Rate"""
  cExchangeRate: Float
  """Central Room Assignment Value"""
  cRoomAssignmentValue: Float
  """Valid values are ROLLING or CALENDAR.Rolling ? Indicates the membership will run from the same month for a determined amount of time.Calendar ? Indicates the calculation will occur every year at the end of the year."""
  calculationMethod: String
  """This signifies the number of months that points are valid for a membership type"""
  calculationMonths: Float
  """Can Delete Y/N"""
  canDeleteYn: String
  """The length of the card number for default card validation."""
  cardLength: Float
  """Card Prefix"""
  cardPrefix: String
  """Number of years card will be valid for this level."""
  cardValidYears: Float
  """Indicates if program is managed centrally or at Local property. If central then points will be calculated at ECIS else if program is local then points will be calculated and stored locally."""
  centralSetupYn: String
  """Chain Code"""
  chainCode: String
  """Indicates whether a change to this level is restricted once a guest attains this level."""
  changesRestrictedYn: String
  """Indicates if this membership type is Chip and Pin."""
  chipAndPinYn: String
  """Comments"""
  comments: String
  """Cost Per Point"""
  costPerPoint: Float
  """Credit Limit"""
  creditLimit: Float
  """Currency Code"""
  currencyCode: String
  """Used in the EIS Module."""
  currentPoints: Float
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  dSI: Float
  """Default value for membership status."""
  defaultMemStatus: String
  """Deleted Flag"""
  deletedFlag: String
  """Device Code"""
  deviceCode: String
  """Date when device was disabled."""
  deviceDisableDate: Date
  """Display Color"""
  displayColor: String
  """Downgrade"""
  downgrade: String
  """Number of months to consider for downgrade."""
  downgradePeriod: Float
  """Earning Preference"""
  earningPreference: String
  """Resort/CRO where enrollment is done."""
  enrolledAt: String
  """Code to indicate source used to enroll the member."""
  enrollmentCode: String
  """Enrollment code required flag."""
  enrollmentCodeReqYn: String
  """Enrollment Description"""
  enrollmentDescription: String
  """Source from where the enrollment is done."""
  enrollmentSource: String
  """Exception Type"""
  exceptionType: String
  """Exchange Rate Type"""
  exchangeRateType: String
  """Flag to determine member actions to include in the fulfillment extract"""
  excludeFromBatch: String
  """Expiration date of the Card."""
  expiration: Date
  """Expiration Date Required"""
  expirationDateRequired: String
  """Expiration month for membership types having a ROLLING calculation method."""
  expirationMonth: Float
  """Maximum number of days to process the External Processing Exception."""
  externalProcessDays: Float
  """Flag that affects how a Membership Type is added edited or deleted from a profile."""
  externallyControlledYn: String
  """Free form text that can ve configured to display on the folio of clients earning points under this program."""
  folioMessage: String
  """Folio Message for Credits."""
  folioMessageCredits: String
  """Folio Message Nonmembers"""
  folioMessageNonmembers: String
  """Folio message for non members who have a non-qualifying rate code."""
  folioMessageNonmembersNq: String
  """Folio message for members who have a non-qualifying rate code."""
  folioMessageNq: String
  """Fulfillment Y/N"""
  fulfillmentYn: String
  """Fulfilment Y/N"""
  fulfilmentYn: String
  """Used in EIS Module."""
  graceExpirationMonth: Float
  """Grace Period Indicator"""
  gracePeriodIndicator: String
  """Inactive Date"""
  inactiveDate: DateTime
  """Inactive YN"""
  inactiveYN: String
  """Insert Date"""
  insertDate: DateTime
  """Insert User"""
  insertUser: String
  """JRN Update Date"""
  jRNUpdateDate: Date
  """JRN Update Date and Time"""
  jRNUpdateDateAndTime: DateTime
  """Used by EIS Module."""
  joinDate: Date
  """Label"""
  label: String
  """Level Required"""
  levelRequired: String
  """Flag to indicate if this is a loyalty program"""
  loyaltyProgramYn: String
  """Used in EIS Module."""
  maxDowngradeLevel: String
  """Last Date Earning Preference was changed."""
  mbrprefChangedDate: Date
  """Membership Class Description"""
  memClassDescription: String
  """Membership Class Insert Date"""
  memClassInsertDate: DateTime
  """Membership Class Insert User"""
  memClassInsertUser: Float
  """Membership Class Update Date"""
  memClassUpdateDate: DateTime
  """Membership Class Update User"""
  memClassUpdateUser: Float
  """Membership Level Deleted Flag"""
  memLevelDeletedFlag: String
  """Membership Level Inactive Date"""
  memLevelInactiveDate: DateTime
  """Membership Level Insert Date"""
  memLevelInsertDate: DateTime
  """Membership Level Insert User"""
  memLevelInsertUser: Float
  """Membership Level Update Date"""
  memLevelUpdateDate: DateTime
  """Membership Level Update User"""
  memLevelUpdateUser: Float
  """Membership Type Card Valid Years"""
  memTypeCardValidYears: Float
  """Membership Type Inactive Date"""
  memTypeInactiveDate: DateTime
  """Membership Type Insert Date"""
  memTypeInsertDate: DateTime
  """Membership Type Insert User"""
  memTypeInsertUser: Float
  """Membership Type Order By"""
  memTypeOrderBy: Float
  """Membership Type Update Date"""
  memTypeUpdateDate: DateTime
  """Membership Type Update User"""
  memTypeUpdateUser: Float
  """Used in the EIS Module."""
  memberIndicator: String
  """Display set used for member info."""
  memberInfoDispSet: String
  """Not Used"""
  memberName: String
  """User defined field used by external system. Not used by OCIS upgradedowngrade or renewal process."""
  memberStatus: String
  """Used in the EIS Module."""
  memberSubtype: String
  """[A]utopopulate on Reservation [P]rompt on Reservation; Al[W]ays Prompt [N]o action."""
  membershipAction: String
  """Membership Card Number"""
  membershipCardNumber: String
  """Primary key of this table"""
  membershipClass: String
  """Membership ID"""
  membershipId: Float
  """Membership Level"""
  membershipLevel: String
  """Mem Level Central Xchange Date"""
  membershipLevelCExchangeDate: Date
  """Mem Level Central Xchange Rate"""
  membershipLevelCExchangeRate: Float
  """Membership Level Description"""
  membershipLevelDesc: String
  """The sequence of membership levels starting with 1 (The starting level) and increasing to the highest level."""
  membershipLevelRank: Float
  """Membership Type"""
  membershipType: String
  """Mem Type Central Xchange Date"""
  membershipTypeCExchangeDate: Date
  """Mem Type Central Xchange Rate"""
  membershipTypeCExchangeRate: Float
  """Membership Type Description"""
  membershipTypeDesc: String
  """Multiple rooms allowed for points exception."""
  multipleRoomsLimit: Float
  """Name ID"""
  nameId: Float
  """Name as appeared on the Membership Card."""
  nameOnCard: String
  """Number of transaction(s) for each stay. Value will be 2 in case of double dipping otherwise it will be null or 1."""
  numberOfTrx: Float
  """Indicates the type of card number validation which should be done."""
  numericValidation: String
  """Internal ID to uniquely identify the Organization"""
  organizationID: Float
  """Membership ID that accrues Miles."""
  partnerMembershipId: Float
  """Indicates that points are issued by central system"""
  pointsIssuedCentrallyYn: String
  """Label for points (i.e. Points or Miles)"""
  pointsLabel: String
  """Used in the EIS Module."""
  preferredCardYN: String
  """Used in the EIS Module."""
  primaryAirlinePartner: String
  """Internal Primary Key ID to uniquely identify the row"""
  primaryKeyID: Float
  """Primary Membership Y/N"""
  primaryMembershipYn: String
  """Used in the EIS Module."""
  processExpirationDate: Date
  """Indicates if resv_memberships should popup when a reservation is checked out."""
  promptAtCheckOut: String
  """Indicates if a prompt is required at checkin of a reservation if a membership number exists on profile and not attached to the reservation."""
  promptAtCheckin: String
  """Indicates if resv_memberships should popup when a reservation is created."""
  promptAtNewReservation: String
  """Indicates if resv_memberships should popup when a reservation is updated."""
  promptAtUpdateReservation: String
  """Rank Value"""
  rankValue: Float
  """Ranking"""
  ranking: Float
  """RnA Insertdate"""
  rnaInsertDate: DateTime
  """RnA Updatedate"""
  rnaUpdateDate: DateTime
  """Room Assignment Value"""
  roomAssignmentValue: Float
  """Send checkout reservation information to the interface for Courtesy Cards?"""
  sendChkoutToIfc: String
  """Sequence"""
  sequence: Float
  """Tier Administration"""
  tierAdministration: String
  """Stores key track information for a universal card that may be different than the membership number."""
  trackData: String
  """Indicates the maximum points that can be accrued per membership transaction."""
  transactionMaxPoints: Float
  """Tier Management Based on Date."""
  tscDateFlag: String
  """Indicates if card number validation is a UDF(User defined function) or Default validation is used."""
  udfCardValidationYn: String
  """Udf Formula"""
  udfFormula: String
  """Update Date"""
  updateDate: DateTime
  """Update User"""
  updateUser: String
  """Number of months to consider for upgrade."""
  upgradePeriod: Float
  """Indicates if the card is to be validated by an external system."""
  validationByIfc: String
  """VIP Status"""
  vipStatus: String
  """Years To Expire"""
  yearsToExpire: Float
}
type ProfilesLoyaltyMembershipBenefitsDetailsType {
  """Chain Code"""
  chainCode: String
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  dSI: Float
  """Deleted Flag"""
  deletedFlag: String
  """Inactive Date"""
  inactiveDate: DateTime
  """Inactive Y/N"""
  inactiveYn: String
  """Insert Date"""
  insertDate: DateTime
  """Insert User"""
  insertUser: Float
  """JRN Update Date"""
  jRNUpdateDate: Date
  """JRN Update Date and Time"""
  jRNUpdateDateAndTime: DateTime
  """Link to benefit code."""
  levelBenefitsCode: String
  """Level Benefits Description"""
  levelBenefitsDescription: String
  """Membership ID"""
  membershipId: Float
  """Membership Type"""
  membershipType: String
  """Internal ID to uniquely identify the Organization"""
  organizationID: Float
  """Internal Primary Key ID to uniquely identify the row"""
  primaryKeyID: Float
  """Processing Msg"""
  processingMsg: String
  """RNA Insert Date"""
  rNAInsertDate: DateTime
  """RNA Update Date"""
  rNAUpdateDate: DateTime
  """Update Date"""
  updateDate: DateTime
  """Update User"""
  updateUser: Float
}
type ProfilesLoyaltyMembershipClaimDetailsType {
  """Approval Status"""
  approvalStatus: String
  """Approve/Reject/None"""
  approveReject: String
  """Arrival Date"""
  arrivalDate: Date
  """Central Xchange Date"""
  cExchangeDate: Date
  """Central Xchange Rate"""
  cExchangeRate: Float
  """Central Membership Base Revenue"""
  cMembershipBaseRevenue: Float
  """Central Membership Bonus Revenue"""
  cMembershipBonusRevenue: Float
  """Information about the caller."""
  callerInformation: String
  """name of the person who called."""
  callerName: String
  """Chain Code"""
  chainCode: String
  """Channel"""
  channel: String
  """Claim Adj Limit Code"""
  claimAdjLimitCode: String
  """Date claim was posted in the database."""
  claimDate: Date
  """Primary key."""
  claimNumber: Float
  """User defined origin of claim."""
  claimOrigin: String
  """Claim Owner"""
  claimOwner: Float
  """Source of the Claim"""
  claimSource: String
  """Status of the claim."""
  claimStatus: String
  """User Defined Claim Types"""
  claimType: String
  """Date and time cashier was closed."""
  closeDate: Date
  """Comments"""
  comments: String
  """Confirmation Number"""
  confirmationNumber: String
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  dSI: Float
  """Deleted Flag"""
  deletedFlag: String
  """Departure Date"""
  departureDate: Date
  """External Reference Number"""
  externalReferenceNumber: String
  """Insert Date"""
  insertDate: DateTime
  """Insert User"""
  insertUser: Float
  """JRN Update Date"""
  jRNUpdateDate: Date
  """JRN Update Date and Time"""
  jRNUpdateDateAndTime: DateTime
  """Market Code"""
  marketCode: String
  """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 Claim Property"""
  membershipClaimProperty: String
  """Membership ID"""
  membershipId: Float
  """Membership Number"""
  membershipNumber: String
  """Membership Trx ID"""
  membershipTransactionId: Float
  """Membership Type"""
  membershipType: String
  """Name"""
  name: String
  """Name ID"""
  nameId: Float
  """Internal ID to uniquely identify the Organization"""
  organizationID: Float
  """Origin of Booking"""
  originOfBooking: String
  """Owner"""
  owner: String
  """Internal Primary Key ID to uniquely identify the row"""
  primaryKeyID: Float
  """Purpose of stay."""
  purposeOfStay: String
  """RNA Insert Date"""
  rNAInsertDate: DateTime
  """RNA Update Date"""
  rNAUpdateDate: DateTime
  """Rate Code"""
  rateCode: String
  """Tier ID for the Rate Detail."""
  rateTier: Float
  """Record Type"""
  recordType: String
  """Date when the user gets a response to his/her claim."""
  replyBy: Date
  """Reservation Name ID"""
  reservationNameID: Float
  """Reservation Status"""
  reservationStatus: String
  """Room"""
  room: String
  """Submitter"""
  submitter: String
  """Total Base Points"""
  totalBasePoints: Float
  """Total Bonus Points"""
  totalBonusPoints: Float
  """Total Miscellaneous Points"""
  totalMiscPoints: Float
  """Update Date"""
  updateDate: DateTime
  """Update User"""
  updateUser: Float
}
type ProfilesLoyaltyMembershipHistoryDetailsType {
  """Action ID"""
  actionID: Float
  """Action Type"""
  actionType: String
  """Chain Code"""
  chainCode: String
  """Change Type"""
  changeType: String
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  dSI: Float
  """Deleted Flag"""
  deletedFlag: String
  """Description"""
  description: String
  """Internal batch id."""
  extractBatchId: Float
  """Insert Date"""
  insertDate: DateTime
  """Insert User"""
  insertUser: Float
  """The name of the user who created the record."""
  insertUserName: String
  """JRN Update Date"""
  jRNUpdateDate: Date
  """JRN Update Date and Time"""
  jRNUpdateDateAndTime: DateTime
  """Membership ID"""
  membershipID: Float
  """New Value"""
  newValue: String
  """Old Value"""
  oldValue: String
  """Internal ID to uniquely identify the Organization"""
  organizationID: Float
  """Internal Primary Key ID to uniquely identify the row"""
  primaryKeyID: Float
  """RnA Insertdate"""
  rnaInsertDate: DateTime
  """RnA Updatedate"""
  rnaUpdateDate: DateTime
}
type ProfilesLoyaltyMembershipIssuedAwardsDetailsType {
  """Actual penalty points applied while cancelling the reservation_award record."""
  actualCancelPoints: Float
  """Arrival Date"""
  arrivalDate: Date
  """Should award be auto consumed when."""
  autoConsumedYn: String
  """Award Based On"""
  awardBasedOn: String
  """Award Code"""
  awardCode: String
  """Award Code Description"""
  awardCodeDescription: String
  """Flag to indicate that award has been consumed."""
  awardConsumedYn: String
  """Award ID"""
  awardID: Float
  """Current status of the award."""
  awardStatus: String
  """Value of the award in central currency."""
  awardValue: Float
  """Award Voucher Number"""
  awardVoucherNo: String
  """Billing Group"""
  billingGroup: String
  """Central Award Value"""
  cAwardValue: Float
  """Central Xchange Date"""
  cExchangeDate: Date
  """Central Xchange Rate"""
  cExchangeRate: Float
  """Central Redeemed Central Amount"""
  cRedeemedCentralAmount: Float
  """Central Redeemed Local Amount"""
  cRedeemedLocalAmount: Float
  """Central Total Central Amount"""
  cTotalCentralAmount: Float
  """Central Total Local Amount"""
  cTotalLocalAmount: Float
  """When award was cancelled."""
  cancelDate: Date
  """Number days before arrival to apply penalty for cancellation."""
  cancelDays: Float
  """Member statement ID."""
  cancelMemberStatementId: Float
  """Cancel Policy Type"""
  cancelPolicyType: String
  """Internal statement number."""
  cancelStatementId: Float
  """Unique id for the award cancellation if cancelled"""
  cancellationNumber: Float
  """Cancelled YN"""
  cancelledYN: String
  """Central Currency Code"""
  centralCurrencyCode: String
  """Chain Code"""
  chainCode: String
  """Comments"""
  comments: String
  """Confirmation Number"""
  confirmationNumber: String
  """Consumption Date"""
  consumptionDate: Date
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  dSI: Float
  """Date when award was issued."""
  dateAwarded: Date
  """Date when award is going to expire."""
  dateOfExpiry: Date
  """Deleted Flag"""
  deletedFlag: String
  """Departure Date"""
  departureDate: Date
  """Exchange Rate"""
  exchangeRate: Float
  """Exchange Rate Type"""
  exchangeRateType: String
  """External system transaction no."""
  extTrxNumber: String
  """External Reference Number"""
  externalReferenceNumber: String
  """Room label before the upgrade in case of an upgrade award"""
  fromRoomLabel: String
  """Used when award is based on upgrade of room. Indicates the room label from which upgrade took place."""
  fromRoomLabelName: String
  """Insert Date"""
  insertDate: DateTime
  """Insert User"""
  insertUser: Float
  """The room category which is valid for this property."""
  invRoomCategory: String
  """Issued Manually?"""
  issuedManuallyYn: String
  """JRN Update Date"""
  jRNUpdateDate: Date
  """JRN Update Date and Time"""
  jRNUpdateDateAndTime: DateTime
  """Local Resv Name ID"""
  localReservationNameId: Float
  """Member Statement ID"""
  memberStatementId: Float
  """Internal PK for the table."""
  membershipAwardId: Float
  """Membership Award Property"""
  membershipAwardProperty: String
  """Membership ID"""
  membershipId: Float
  """Membership Level"""
  membershipLevel: String
  """Membership Number"""
  membershipNumber: String
  """Membership Type"""
  membershipType: String
  """Name ID"""
  nameID: Float
  """Number of Nights"""
  numberOfNights: Float
  """Internal ID to uniquely identify the Organization"""
  organizationID: Float
  """Number of cancel penalty points."""
  penaltyPoints: Float
  """Pms Currency Code"""
  pmsCurrencyCode: String
  """Points"""
  points: Float
  """Internal Primary Key ID to uniquely identify the row"""
  primaryKeyID: Float
  """Product"""
  product: String
  """Pts Sch Code"""
  ptsSchCode: String
  """RNA Insert Date"""
  rNAInsertDate: DateTime
  """RNA Update Date"""
  rNAUpdateDate: DateTime
  """Rate Code"""
  rateCode: String
  """Amount value redeemed.(central/OCIS currency)"""
  redeemedCentralAmount: Float
  """Redeemed amount for points on bill in local (PMS) currency. This column is for Information purpose only."""
  redeemedLocalAmount: Float
  """Reservation Cancel Number"""
  reservationCancelNumber: String
  """Reservation Name ID"""
  reservationNameID: Float
  """Reservation Status"""
  reservationStatus: String
  """Room Label"""
  roomLabel: String
  """Room label when award is based on rate. Indicates what room category was used with rate code."""
  roomLabelName: String
  """Origin of the award."""
  source: String
  """Statement ID"""
  statementId: Float
  """Stay Date"""
  stayDate: Date
  """Stay Record ID"""
  stayRecordId: Float
  """Room label after the upgrade for an upgrade award"""
  toRoomLabel: String
  """Used when award is based on upgrade of room. Indicates the room label to which upgrade took place."""
  toRoomLabelName: String
  """Total amount.(central/OCIS currency)"""
  totalCentralAmount: Float
  """Total amount on bill in local (PMS) currency. This column is for Information purpose only."""
  totalLocalAmount: Float
  """Transaction Code"""
  trxCode: String
  """Transaction No"""
  trxNumber: Float
  """Update Date"""
  updateDate: DateTime
  """Update User"""
  updateUser: Float
}
type ProfilesLoyaltyMembershipTransactionsDetailsType {
  """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 ProfilesLoyaltyMembershipTransactionHeaderDetailsType {
  """Batch ID Code"""
  batchIDCode: Float
  """Card Number"""
  cardNumber: String
  """Chain Code"""
  chainCode: String
  """Complete"""
  complete: Float
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  dSI: Float
  """Deleted"""
  deleted: Float
  """Deleted Flag"""
  deletedFlag: String
  """Error message."""
  error: Float
  """Date for which routine had run."""
  evaluationDate: Date
  """Old membership card expiration date before upgradedowngrade or renewal."""
  expirationDate: Date
  """Period for which member transactions were evaluated. From date."""
  fromDate: Date
  """Insert User"""
  insertUser: Float
  """JRN Update Date"""
  jRNUpdateDate: Date
  """JRN Update Date and Time"""
  jRNUpdateDateAndTime: DateTime
  """Join Date"""
  joinDate: Date
  """Old membership level before upgrade or downgrade."""
  level: String
  """Locked"""
  locked: Float
  """Shows log of how and what was evaluated for the member."""
  log: String
  """Shows errors if any while processing for a member."""
  memError: String
  """Membership ID"""
  membershipId: Float
  """Membership Type"""
  membershipType: String
  """Membership Type Description"""
  membershipTypeDescription: String
  """Name"""
  name: String
  """New membership card expiration date after upgradedowngrade or renewal."""
  newExpirationDate: Date
  """New membership level."""
  newMembershipLevel: String
  """Order By"""
  orderBy: Float
  """Internal ID to uniquely identify the Organization"""
  organizationID: Float
  """Pending"""
  pending: Float
  """Internal Primary Key ID to uniquely identify the row"""
  primaryKeyID: Float
  """Process"""
  process: String
  """Process Date"""
  processDate: DateTime
  """RNA Insert Date"""
  rNAInsertDate: DateTime
  """RNA Update Date"""
  rNAUpdateDate: DateTime
  """Indicates if the re-qualification process was done."""
  reQualifyYn: String
  """Status of the record. like (NEW ERROR). Initial value is  NEW."""
  recordStatus: String
  """Record Type"""
  recordType: String
  """Shows errors if any while processing for report at report level."""
  reportError: String
  """Report Log."""
  reportLog: String
  """Status of the report. For future use."""
  reportStatus: String
  """Rfm Score Hdr ID"""
  rfmScoreHdrId: Float
  """Indicates if the batch is run for Tier Management Reset(TMR) flag active."""
  tmrActiveYn: String
  """Period for which member transactions were evaluated. To date."""
  toDate: Date
  """Total number of records to resync"""
  total: Float
  """User"""
  user: String
}
type ProfilesLoyaltyExpirePointsByDateDetailsType {
  """Chain Code"""
  chainCode: String
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  dSI: Float
  """Point Expiration date."""
  expirationDate: DateTime
  """Expire By Date"""
  expireByDate: Float
  """Membership ID"""
  membershipId: Float
  """Internal ID to uniquely identify the Organization"""
  organizationID: Float
  """Total Expire"""
  totalExpire: Float
}