# title : OPERA Cloud RnA ConfigurationChain GraphQL API, # description : GraphQL API to cater for The Chain Configuration Subject Area contains configuration/setting attributes from components such as Enterprise Administration, Financial Administration, Booking Administration and Client Relations Administration in OPERA. # 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. # - chainDetailsChainCode input ConfigurationChainQueryArgumentsType { """Chain""" chainDetailsChainCode: StringInput! @mandatoryInput """DSI Internal Data Source ID to identify Opera Chain and instance""" chainDetailsDsi: FloatInput """JRN Update Date and Time""" chainDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" chainDetailsOrganizationid: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" memenrollmentcodeDetailsDsi: FloatInput """Enrollment Code""" memenrollmentcodeDetailsAttributeCode: StringInput """Entity Name""" memenrollmentcodeDetailsEntityName: StringInput """JRN Update Date and Time""" memenrollmentcodeDetailsJrnupdatedttm: DateTimeInput """Language Code""" memenrollmentcodeDetailsLanguageCode: StringInput """Internal ID to uniquely identify the Organization""" memenrollmentcodeDetailsOrganizationid: FloatInput """Title Suffix""" memenrollmentcodeDetailsTitleSuffix: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" memenrollgroupDetailsDsi: FloatInput """Enrollment group that includes the enrollment code(s) to which this rule applies.""" memenrollgroupDetailsMemEnrollGroup: StringInput """JRN Update Date and Time""" memenrollgroupDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" memenrollgroupDetailsOrganizationid: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" memmarketgroupDetailsDsi: FloatInput """JRN Update Date and Time""" memmarketgroupDetailsJrnupdatedttm: DateTimeInput """Market Group Code""" memmarketgroupDetailsMemMarketGroup: StringInput """Internal ID to uniquely identify the Organization""" memmarketgroupDetailsOrganizationid: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" membershiptypeDetailsDsi: FloatInput """JRN Update Date and Time""" membershiptypeDetailsJrnupdatedttm: DateTimeInput """Membershiptypeid""" membershiptypeDetailsMembershiptypeid: StringInput """Internal ID to uniquely identify the Organization""" membershiptypeDetailsOrganizationid: FloatInput """Type""" membershiptypeDetailsMembershipType: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" memresortgroupDetailsDsi: FloatInput """JRN Update Date and Time""" memresortgroupDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" memresortgroupDetailsOrganizationid: FloatInput """Property Group Code""" memresortgroupDetailsMemResortGroup: StringInput """JRN Update Date and Time""" memrategroupDetailsJrnupdatedttm: DateTimeInput """DSI Internal Data Source ID to identify Opera Chain and instance""" memrevenuegroupDetailsDsi: FloatInput """JRN Update Date and Time""" memrevenuegroupDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" memrevenuegroupDetailsOrganizationid: FloatInput """Membership rate group.""" memrevenuegroupDetailsMemRevenueGroup: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" memrevenuetypeDetailsDsi: FloatInput """JRN Update Date and Time""" memrevenuetypeDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" memrevenuetypeDetailsOrganizationid: FloatInput """Revenue Bucket Code""" memrevenuetypeDetailsExportBucketCode: StringInput """Revenue Types defined for OIS memberships.""" memrevenuetypeDetailsMembershipRevenueType: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" memroomgroupDetailsDsi: FloatInput """JRN Update Date and Time""" memroomgroupDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" memroomgroupDetailsOrganizationid: FloatInput """Room Group Code""" memroomgroupDetailsMemRoomGroup: StringInput """Central Xchange Date""" hubDetailsCXchangeDate: DateInput """Not used""" hubDetailsCrsResort: StringInput """Country""" hubDetailsCountryCode: StringInput """Currency""" hubDetailsCurrencyCode: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" hubDetailsDsi: FloatInput """HUB""" hubDetailsResort: StringInput """JRN Update Date and Time""" hubDetailsJrnupdatedttm: DateTimeInput """Internal""" hubDetailsNameIdLink: FloatInput """Internal ID to uniquely identify the Organization""" hubDetailsOrganizationid: FloatInput """Property Type""" hubDetailsResortType: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" notetypeDetailsDsi: FloatInput """JRN Update Date and Time""" notetypeDetailsJrnupdatedttm: DateTimeInput """Note Type""" notetypeDetailsNoteCode: StringInput """Note Type Code""" notetypeDetailsNoteTypeCode: StringInput """Notes Group""" notetypeDetailsNoteType: StringInput """Notetypeid""" notetypeDetailsNotetypeid: StringInput """Internal ID to uniquely identify the Organization""" notetypeDetailsOrganizationid: FloatInput """Code""" resorttypeDetailsResortType: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" resorttypeDetailsDsi: FloatInput """JRN Update Date and Time""" resorttypeDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" resorttypeDetailsOrganizationid: FloatInput """Currency Code""" foreigncurrencyDetailsCurrencyCode: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" foreigncurrencyDetailsDsi: FloatInput """JRN Update Date and Time""" foreigncurrencyDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" foreigncurrencyDetailsOrganizationid: FloatInput """Code""" itemraterulesDetailsCode: StringInput """Code ID""" itemraterulesDetailsCodeId: FloatInput """Code Type""" itemraterulesDetailsCodeType: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" itemraterulesDetailsDsi: FloatInput """JRN Update Date and Time""" itemraterulesDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" itemraterulesDetailsOrganizationid: FloatInput """Country""" postalcodeDetailsCountryCode: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" postalcodeDetailsDsi: FloatInput """JRN Update Date and Time""" postalcodeDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" postalcodeDetailsOrganizationid: FloatInput """The Beginning Postal Code Range for this state.""" postalcodeDetailsPostalCodeFrom: StringInput """The ending Postal Code for the State.""" postalcodeDetailsPostalCodeTo: StringInput """Uppercase value of CITY column.""" postalcodeDetailsScity: StringInput """Sequence""" postalcodeDetailsSeq: FloatInput """State""" postalcodeDetailsStateCode: StringInput """Code""" iddocumenttypeDetailsDocumentType: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" iddocumenttypeDetailsDsi: FloatInput """JRN Update Date and Time""" iddocumenttypeDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" iddocumenttypeDetailsOrganizationid: FloatInput """Code""" languageDetailsLanguageCode: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" languageDetailsDsi: FloatInput """JRN Update Date and Time""" languageDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" languageDetailsOrganizationid: FloatInput """ISO Country code""" languageDetailsTranslationLanguageCode: StringInput """Code""" regionDetailsRegionCode: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" regionDetailsDsi: FloatInput """JRN Update Date and Time""" regionDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" regionDetailsOrganizationid: FloatInput """Regionid""" regionDetailsRegionid: StringInput """Code""" stateDetailsStateCode: StringInput """Country""" stateDetailsCountryCode: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" stateDetailsDsi: FloatInput """JRN Update Date and Time""" stateDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" stateDetailsOrganizationid: FloatInput """Stateid""" stateDetailsStateid: StringInput """Primary key of this table""" membershipclassDetailsMembershipClass: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" membershipclassDetailsDsi: FloatInput """JRN Update Date and Time""" membershipclassDetailsJrnupdatedttm: DateTimeInput """Membershipclassid""" membershipclassDetailsMembershipclassid: StringInput """Internal ID to uniquely identify the Organization""" membershipclassDetailsOrganizationid: FloatInput """Chain Code""" confirmationformatDetailsChainCode: StringInput """Primary key column for the table""" confirmationformatDetailsFormatCode: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" confirmationformatDetailsDsi: FloatInput """Format Type""" confirmationformatDetailsFormatType: StringInput """JRN Update Date and Time""" confirmationformatDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" confirmationformatDetailsOrganizationid: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" communicationtypeDetailsDsi: FloatInput """JRN Update Date and Time""" communicationtypeDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" communicationtypeDetailsOrganizationid: FloatInput """Type""" communicationtypeDetailsPhoneType: StringInput """Code""" profilepreferencetypeDetailsPreferenceType: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" profilepreferencetypeDetailsDsi: FloatInput """JRN Update Date and Time""" profilepreferencetypeDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" profilepreferencetypeDetailsOrganizationid: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" profilenameDetailsDsi: FloatInput """JRN Update Date and Time""" profilenameDetailsJrnupdatedttm: DateTimeInput """Set of words that represent a profile name.""" profilenameDetailsNameString: StringInput """Internal ID to uniquely identify the Organization""" profilenameDetailsOrganizationid: FloatInput """Type""" profilenameDetailsNameType: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" configrelationshipDetailsDsi: FloatInput """From Relationship Code""" configrelationshipDetailsRelationship: StringInput """Organization ID""" configrelationshipDetailsOrganizationId: FloatInput """JRN Update Date and Time""" configrelationshipDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" configrelationshipDetailsOrganizationid: FloatInput """Module related to this Name Type whether it is used in PMS S&C etc.""" configrelationshipDetailsRelationCategory: StringInput """Relationship ID""" configrelationshipDetailsRelationshipId: StringInput """Claim Type Code""" memclaimtypeDetailsAttributeCode: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" memclaimtypeDetailsDsi: FloatInput """Entity Name""" memclaimtypeDetailsEntityName: StringInput """JRN Update Date and Time""" memclaimtypeDetailsJrnupdatedttm: DateTimeInput """Language Code""" memclaimtypeDetailsLanguageCode: StringInput """Internal ID to uniquely identify the Organization""" memclaimtypeDetailsOrganizationid: FloatInput """Title Suffix""" memclaimtypeDetailsTitleSuffix: FloatInput """Award Code""" memawardsDetailsAwardType: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" memawardsDetailsDsi: FloatInput """JRN Update Date and Time""" memawardsDetailsJrnupdatedttm: DateTimeInput """Membership Type""" memawardsDetailsMembershipType: StringInput """Internal ID to uniquely identify the Organization""" memawardsDetailsOrganizationid: FloatInput """Pts Sch Code""" memawardsDetailsPtsSchCode: StringInput """Code to indicate source used to enroll the member.""" membershipenrollDetailsEnrollmentCode: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" membershipenrollDetailsDsi: FloatInput """JRN Update Date and Time""" membershipenrollDetailsJrnupdatedttm: DateTimeInput """Enrollment group that includes the enrollment code(s) to which this rule applies.""" membershipenrollDetailsMemEnrollGroup: StringInput """Internal ID to uniquely identify the Organization""" membershipenrollDetailsOrganizationid: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" membershiplevelDetailsDsi: FloatInput """JRN Update Date and Time""" membershiplevelDetailsJrnupdatedttm: DateTimeInput """Level Code""" membershiplevelDetailsMembershipLevel: StringInput """Membership Type""" membershiplevelDetailsMembershipType: StringInput """Membershiplevelid""" membershiplevelDetailsMembershiplevelid: StringInput """Membershiptypeid""" membershiplevelDetailsMembershiptypeid: StringInput """Internal ID to uniquely identify the Organization""" membershiplevelDetailsOrganizationid: FloatInput """Start range of credit card no""" memcardrangesDetailsCardnoFrom: StringInput """End range of credit card no""" memcardrangesDetailsCardnoTo: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" memcardrangesDetailsDsi: FloatInput """JRN Update Date and Time""" memcardrangesDetailsJrnupdatedttm: DateTimeInput """Membership Type""" memcardrangesDetailsMembershipType: StringInput """Internal ID to uniquely identify the Organization""" memcardrangesDetailsOrganizationid: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" memlevelbenefitsDetailsDsi: FloatInput """JRN Update Date and Time""" memlevelbenefitsDetailsJrnupdatedttm: DateTimeInput """Link to benefit code.""" memlevelbenefitsDetailsBenefitCode: StringInput """Membership Type""" memlevelbenefitsDetailsMembershipType: StringInput """Internal ID to uniquely identify the Organization""" memlevelbenefitsDetailsOrganizationid: FloatInput """Attached Market Codes""" memmarketgroupcodeDetailsMarketCode: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" memmarketgroupcodeDetailsDsi: FloatInput """JRN Update Date and Time""" memmarketgroupcodeDetailsJrnupdatedttm: DateTimeInput """Membership Market Group""" memmarketgroupcodeDetailsMemMarketGroup: StringInput """Internal ID to uniquely identify the Organization""" memmarketgroupcodeDetailsOrganizationid: FloatInput """Attached Rate Code""" memrategroupcodeDetailsRateCode: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" memrategroupcodeDetailsDsi: FloatInput """JRN Update Date and Time""" memrategroupcodeDetailsJrnupdatedttm: DateTimeInput """Membership Rate Group""" memrategroupcodeDetailsMemRateGroup: StringInput """Internal ID to uniquely identify the Organization""" memrategroupcodeDetailsOrganizationid: FloatInput """Revenue Types defined for OIS memberships.""" memrevenuegroupcodeDetailsMembershipRevenueType: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" memrevenuegroupcodeDetailsDsi: FloatInput """JRN Update Date and Time""" memrevenuegroupcodeDetailsJrnupdatedttm: DateTimeInput """Membership rate group.""" memrevenuegroupcodeDetailsMemRevenueGroup: StringInput """Internal ID to uniquely identify the Organization""" memrevenuegroupcodeDetailsOrganizationid: FloatInput """Next status of the status column""" resortbookingstatusnextDetailsNextStatus: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" resortbookingstatusnextDetailsDsi: FloatInput """JRN Update Date and Time""" resortbookingstatusnextDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" resortbookingstatusnextDetailsOrganizationid: FloatInput """Status""" resortbookingstatusnextDetailsStatus: StringInput } type Query { """The Chain Configuration Subject Area contains configuration/setting attributes from components such as Enterprise Administration Financial Administration Booking Administration and Client Relations Administration in OPERA.""" configurationChain(limit: Int offset: Int input: ConfigurationChainQueryArgumentsType!): [ConfigurationChainType] } type ConfigurationChainType { """Chain Details""" chainDetails: ConfigurationChainChainDetailsType """Membership Enrollment Code""" membershipEnrollmentCodeDetails: ConfigurationChainMembershipEnrollmentCodeDetailsType """Membership Enroll Group""" membershipEnrollGroupDetails: ConfigurationChainMembershipEnrollGroupDetailsType """Membership Market Group""" membershipMarketGroupMembershipMarketGroupDetails: ConfigurationChainMembershipMarketGroupMembershipMarketGroupDetailsType """Membership Market Group""" membershipMarketGroupDetails: ConfigurationChainMembershipMarketGroupDetailsType """Membership Type Details""" membershipTypeDetails: ConfigurationChainMembershipTypeDetailsType """Membership Property Group""" membershipPropertyGroupDetails: ConfigurationChainMembershipPropertyGroupDetailsType """Membership Rate Group""" membershipRateGroupDetails: ConfigurationChainMembershipRateGroupDetailsType """Membership Revenue Group""" membershipRevenueGroupDetails: ConfigurationChainMembershipRevenueGroupDetailsType """Membership Revenue Type""" membershipRevenueTypeDetails: ConfigurationChainMembershipRevenueTypeDetailsType """Membership Room Group""" membershipRoomGroupDetails: ConfigurationChainMembershipRoomGroupDetailsType """Hub Details""" hubDetails: ConfigurationChainHubDetailsType """Note Type Details""" noteTypeDetails: ConfigurationChainNoteTypeDetailsType """Property Type""" propertyTypeDetails: ConfigurationChainPropertyTypeDetailsType """Foreign Currency Details""" foreignCurrencyDetails: ConfigurationChainForeignCurrencyDetailsType """Item Rate Rules Details""" itemRateRulesDetails: ConfigurationChainItemRateRulesDetailsType """Postal Code Details""" postalCodeDetails: ConfigurationChainPostalCodeDetailsType """ID Document Type""" iDDocumentTypeDetails: ConfigurationChainIDDocumentTypeDetailsType """Language Details""" languageDetails: ConfigurationChainLanguageDetailsType """Region Details""" regionDetails: ConfigurationChainRegionDetailsType """State Details""" stateDetails: ConfigurationChainStateDetailsType """Membership Class Details""" membershipClassDetails: ConfigurationChainMembershipClassDetailsType """Confirmation Format Details""" confirmationFormatDetails: ConfigurationChainConfirmationFormatDetailsType """Communication Type Details""" communicationTypeDetails: ConfigurationChainCommunicationTypeDetailsType """Profile Preference Type Details""" profilePreferenceTypeDetails: ConfigurationChainProfilePreferenceTypeDetailsType """Profile Profile""" profileProfileDetails: ConfigurationChainProfileProfileDetailsType """Configuration Relationship""" configurationRelationshipDetails: ConfigurationChainConfigurationRelationshipDetailsType """Membership Claim Type""" membershipClaimTypeDetails: ConfigurationChainMembershipClaimTypeDetailsType """Membership Awards""" membershipAwardsDetails: ConfigurationChainMembershipAwardsDetailsType """Membership Enroll Details""" membershipEnrollDetails: ConfigurationChainMembershipEnrollDetailsType """Membership Level Details""" membershipLevelDetails: ConfigurationChainMembershipLevelDetailsType """Membership Card Ranges""" membershipCardRangesDetails: ConfigurationChainMembershipCardRangesDetailsType """Membership Level Benefits""" membershipLevelBenefitsDetails: ConfigurationChainMembershipLevelBenefitsDetailsType """Membership Market Group Code""" membershipMarketGroupCodeDetails: ConfigurationChainMembershipMarketGroupCodeDetailsType """Membership Rate Group Code""" membershipRateGroupCodeDetails: ConfigurationChainMembershipRateGroupCodeDetailsType """Membership Revenue Group Code""" membershipRevenueGroupCodeDetails: ConfigurationChainMembershipRevenueGroupCodeDetailsType """Property Booking Status Next""" propertyBookingStatusNextDetails: ConfigurationChainPropertyBookingStatusNextDetailsType configurationChainRecordCount: Int } type ConfigurationChainChainDetailsType { """Chain used for ASP Y/N.""" aspYn: String """Begin Date""" beginDate: Date """Booking conditions chainwide such as commission policies for TA Group policies Cancellation/Deposit/Guarantee and family and child rules.""" bookingConditions: String """Central Chain""" centralChain: String """Central Description""" centralDescription: String """Chain""" chain: String """Chain Name""" chainName: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Description""" description: String """End Date""" endDate: Date """Specifies if frequent flier cards are accepted by the chain (Y/N).""" frequentFlierCardsAcceptYn: String """The city of the Head Office of the chain.""" hoCity: String """The country of the Head Office of the chain.""" hoCountry: String """The email ID of the Head Office of the chain.""" hoEmail: String """The fax number of the Head Office of the chain.""" hoFax: String """The postal code of the Head Office of the chain.""" hoPostCode: String """The state of the Head Office of the chain.""" hoState: String """The street of the Head Office of the chain.""" hoStreet: String """The phone number of the Head Office of the chain.""" hoTelephone: String """Img Chain ID""" imgChainId: Float """Inactive Date""" inactiveDate: Date """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """File name of the chains' logo""" logoFileName: String """Loyalty program data.""" loyaltyProgram: String """Marketing Text""" marketingText: String """Name ID""" nameId: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Reporting Item""" repItem: String """Reporting Item Name""" repItemName: String """Reporting Item Orderby""" repItemOrderby: Float """Reporting Updatedate""" repUpdateDate: DateTime """Script ID""" scriptId: Float """Sharing Profiles across the Chain.""" shareProfilesYN: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainMembershipEnrollmentCodeDetailsType { """Business Title""" businessTitle: String """Can Delete Y/N""" canDeleteYn: String """Chain Code""" chainCode: String """Comments""" comments: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedflag: String """Display Color""" displayColor: String """Enrollment Code""" enrollmentCode: String """Enrollment Description""" enrollmentDescription: String """Entity Name""" entityName: String """Contains a list of codes used by a vendor.""" externalAttributeCodes: String """Inactive Date""" inactiveDate: DateTime """Inactive Flag""" inactiveflag: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Language Code""" languageCode: String """Internal ID to uniquely identify the Property""" locationID: String """Indicates if the KEYWORD TYPE is to be copied from a Company Master to a Company Subsidiary.""" masterSubKeywordYn: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Code to uniquely identify the Property""" property: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Ranking""" ranking: Float """Reporting Attribute Code""" repAttributeCode: String """Reporting Description""" repDescription: String """Reporting Item""" repItem: String """Reporting Item Name""" repItemName: String """Reporting Item Orderby""" repItemOrderby: Float """Reporting Order By""" repOrderBy: Float """Reporting Updatedate""" repUpdateDate: DateTime """Sequence""" sequence: Float """Title Suffix""" titleSuffix: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainMembershipEnrollGroupDetailsType { """Chain Code""" chainCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Enrollment group that includes the enrollment code(s) to which this rule applies.""" enrollmentGroupCode: String """Enrollment Group Description""" enrollmentGroupDescription: String """Include Exclude""" includeExclude: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Sequence""" sequence: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainMembershipMarketGroupMembershipMarketGroupDetailsType { """Chain Code""" chainCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Include Exclude""" includeExclude: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime } type ConfigurationChainMembershipMarketGroupDetailsType { """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Market Group Code""" marketGroupCode: String """Market Group Description""" marketGroupDescription: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Sequence""" sequence: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainMembershipTypeDetailsType { """Active YN""" activeYN: String """Activity Period Years""" activityPeriodYears: String """Indicates if program allows Ad Hoc multipliers for points calculation.""" allowAdhocMultiplierYn: String """Allow Duplicate Card Numbers YN""" allowDuplicateCardNumbersYN: String """Flag indicating if points should be calculated for shared rooms.""" allowSharesYn: String """Alternate Name Protected YN""" alternateNameProtectedYN: String """This is used when the card no is auto generated and is based on some other value like enrollment code.""" autoCardNoBasedOn: String """Auto Gen Card Prefix""" autoGenCardPrefix: String """Auto Populate Number From Name YN""" autoPopulateNumberFromNameYN: String """Not used""" awardGenerationMethod: String """Award Point Expiry Date Years""" awardPointExpiryDateYears: String """Award Redeem Threshold""" awardRedeemThreshold: String """Defines what the rule is based on the type of condition which need to be satisfied in order to qualify for this rule. Valid values are MEMBERSHIP RATE_CODE REFERENCE VIP.""" basedOn: String """Flag to mark the booker program membership types.""" bookerProgramYn: String """Central Cost Per Point""" cCostPerPoint: Float """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: 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 """Valid values are ROLLING_MONTHS and CALENDAR_MONTHS.""" calculationPeriod: String """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.""" centrallyManagedYN: String """Chain Code""" chainCode: 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.""" checkInYN: String """Indicates if resv_memberships should popup when a reservation is checked out.""" checkOutYN: String """Indicates if this membership type is Chip and Pin.""" chipAndPinYn: String """Primary key of this table""" class: String """Cost Per Point""" costPerPoint: Float """Currency Code""" currencyCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Default value for membership status.""" defaultMemberStatus: String """Not used""" delayInDays: Float """Deleted Flag""" deletedFlag: String """Description""" description: String """Number of months to consider for downgrade.""" downgradePeriod: Float """Downgrade Period Year""" downgradePeriodYr: String """Downgrade/Renewal YN""" downgradeRenewalYN: String """Enrollcoderequiredflag""" enrollcoderequiredflag: String """Enrollment code required flag.""" enrollmentCodeRequiredYN: String """Exception Type""" exceptionType: String """Exchange Rate Type""" exchangeRateType: String """Exclude Profile From Purge YN""" excludeProfileFromPurgeYN: String """Expiration Date Required YN""" expirationDateRequiredYN: String """Expiration month for membership types having a ROLLING calculation method.""" expirationMonth: Float """Expiry Period""" expiryPeriod: String """External Database""" externalDatabase: String """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 """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 """Foreign Currency ID""" foreignCurrencyID: String """Format for Random Number Generation.""" format: String """From Sequence Number""" fromSequenceNumber: Float """Fulfillment YN""" fulfillmentYN: String """Used in EIS Module.""" graceExpirationMonth: Float """Grace Period Years""" gracePeriodYears: String """Inactive Date""" inactiveDate: DateTime """Inactive Flag""" inactiveflag: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Deleted Flag""" internalDeletedflag: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Level Required YN""" levelRequiredYN: String """Free form text that can ve configured to display on the folio of clients earning points under this program.""" memberFolioMessage: String """Display set used for member info.""" memberInfoDispSet: String """[A]utopopulate on Reservation [P]rompt on Reservation; Al[W]ays Prompt [N]o action.""" membershipAction: String """Membership Action Details""" membershipActionDetails: String """Membershipclassid""" membershipclassid: String """Membershiptypeid""" membershiptypeid: String """Multiple rooms allowed for points exception.""" multipleRoomsLimit: Float """Name Protected YN""" nameProtectedYN: String """Name on Card From Alt Name YN""" nameOnCardFromAltNameYN: String """Indicates if resv_memberships should popup when a reservation is created.""" newReservationYN: String """Indicates the type of card number validation which should be done.""" numericValidation: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Points Calculation Method""" pointsCalculationMethod: String """Indicates that points are issued by central system""" pointsIssuedCentrallyYn: String """Label for points (i.e. Points or Miles)""" pointsLabel: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Primary YN""" primaryYN: String """Print Folio Message On Confirmation YN""" printFolioMessageOnConfirmationYN: String """Promptatcheckinflag""" promptatcheckinflag: String """Random Generation YN""" randomGenerationYN: String """Rank""" rank: Float """Requalify on Upgrade YN""" requalifyOnUpgradeYN: String """Required on Stay Period YN""" requiredOnStayPeriodYN: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Rule for posting NOSHOW revenue.""" rule: String """Save Card Number History YN""" saveCardNumberHistoryYN: String """Send checkout reservation information to the interface for Courtesy Cards?""" sendChkoutToIfc: String """Sendcheckouttoifcflag""" sendcheckouttoifcflag: String """Sequence""" sequence: Float """Tier Expiration Month""" tierExpirationMonth: String """Tier Management Reset YN""" tierManagementResetYN: String """To Sequence Number""" toSequenceNumber: Float """Indicates the maximum points that can be accrued per membership transaction.""" transactionMaxPoints: Float """Tier Management Based on Date.""" tscDateFlag: String """Type""" type: 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 """Indicates if resv_memberships should popup when a reservation is updated.""" updateReservationYN: String """Update User""" updateUser: Float """Number of months to consider for upgrade.""" upgradePeriod: Float """Upgrade Period Year""" upgradePeriodYr: String """Indicates if the card is to be validated by an external system.""" validationByIfc: String """Validation Rule""" validationRule: String """Validationbyifcflag""" validationbyifcflag: String """Years To Expire""" yearsToExpire: Float } type ConfigurationChainMembershipPropertyGroupDetailsType { """Used to indicate the specific grouping in order to eliminate stay exceptions like back to back stays.""" backToBack: String """Chain Code""" chainCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Include Exclude""" includeExclude: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Property Group Code""" propertyGroupCode: String """Property Group Description""" propertyGroupDescription: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Sequence""" sequence: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainMembershipRateGroupDetailsType { """Chain Code""" chainCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Include Exclude""" includeExclude: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Rate Group Code""" rateGroupCode: String """Rate Group Description""" rateGroupDescription: String """Sequence""" sequence: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainMembershipRevenueGroupDetailsType { """Chain Code""" chainCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Include Exclude""" includeExclude: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Membership rate group.""" revenueGroupCode: String """Revenue Group Description""" revenueGroupDescription: String """Sequence""" sequence: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainMembershipRevenueTypeDetailsType { """Chain Code""" chainCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Indicates if the Revenue Type is valid for calculating Frequent Flyer Points.""" frequentFlyerPoints: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Label""" label: String """Indicates if the Revenue Type is valid for calculating Membership Points.""" membershipPoints: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Revenue Bucket Code""" revenueBucketCode: String """Revenue Bucket Description""" revenueBucketDescription: String """Revenue Types defined for OIS memberships.""" revenueTypeCode: String """Revenue Type Description""" revenueTypeDescription: String """Sequence""" sequence: Float """Filled in case of bucket rules where Award and Tier points can be computed same but implemented differently.""" tierPoints: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainMembershipRoomGroupDetailsType { """Chain Code""" chainCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Room Group Code""" roomGroupCode: String """Room Group Description""" roomGroupDescription: String """Room Types""" roomTypes: String """Sequence""" sequence: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainHubDetailsType { """Specifies if the AR acct No is mandatory(Y/N)""" aRAccountNumberMandYN: String """Internal""" aRBalanceTrxCode: String """Internal""" aRCreditTrxCode: String """Access Code""" accessCode: String """Default property address format.""" address: String """Aging bucket 1""" agingLevel1: Float """Aging bucket 2""" agingLevel2: Float """Aging bucket 3""" agingLevel3: Float """Aging bucket 4""" agingLevel4: Float """Aging bucket 5""" agingLevel5: Float """The Airport Code for the airport near the property""" airport: String """Distance of the Airport specified in the AIRPORT_CODE column from the Property""" airportDistance: String """Time it takes to travel the distance between the Property and the Airport specified in AIRPORT_CODE column""" airportTime: String """Allow loggin in to this resort(Y/N)""" allowLoginYn: String """Period for the allowance""" allowancePeriodAdj: String """Number format of AR account no.""" arAccountNumberFormat: String """Default Account Type for an Agent for the Property""" arAgent: String """Default Account Type for a Company for the Property""" arCompany: String """Default Account Type for a Group for the Property""" arGroups: String """Default Account Type for Individual for the Property""" arIndividuals: String """Internal""" arSettleCode: String """Internal""" arTypewriter: String """Internal""" awardsTimeout: Float """The base language of the Hotel""" baseLanguage: String """Begin Date""" beginDate: Date """Blackout period notes defaulted onto the FIT Contract at time of creation.""" blackoutPeriodNotes: String """Block""" block: String """Ball Room Area""" brArea: String """No of Ballroom Seats""" brSeats: Float """Brand Code""" brandCode: String """Financial Year of the Property""" budgetMonth: Float """Central Credit Limit""" cCreditLimit: Float """Central Dbl Rate2""" cDoubleRate2: Float """Central Dbl Rate1""" cDoubleRate1: Float """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Sgl Rate2""" cSglRate2: Float """Central Sgl Rate1""" cSglRate1: Float """Central Sui Rate2""" cSuiRate2: Float """Central Sui Rate1""" cSuiRate1: Float """Central Tpl Rate2""" cTplRate2: Float """Central Tpl Rate1""" cTplRate1: Float """Central Warning Amount""" cWarningAmount: Float """Not used""" cRSResort: String """Internal""" cashShiftDrop: String """Catering Currency Code used when Catering Currency differs from base currency.""" cateringCurrencyCode: String """Catering currency format.""" cateringCurrencyFormat: String """Chain Code""" chainCode: String """Internal""" checkExgPaidout: String """The Hotel official check intime""" checkInTime: Date """The Hotel official check out time""" checkOutTime: Date """Internal""" checkShiftDrop: String """Internal""" checkTrxcode: String """City""" city: String """Communication Address for Contact 1 (E-mail / Fax #)""" comAddress: String """How this lead is to be sent. [EMAIL|FAX|PRINT]""" comMethod: String """Internal""" comNameXrefId: Float """Internal""" companyAddressType: String """Internal""" companyPhoneType: String """Internal""" configurationMode: String """Internal""" confirmRegcardPrinter: String """Copies""" copies: Float """Country""" country: String """Credit Limit""" creditLimit: Float """Cro Code""" croCode: String """Currency""" currency: String """Number of decimals to designate currency""" currencyDecimals: Float """Not used""" currencyExgPaidout: String """Format for the local currency.""" currencyFormat: String """Currency Symbol like $ or EURO symbol""" currencySymbol: String """Color that of the background""" curtainColor: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Date the aging should begin""" dateForAging: String """Type of separator to distinguish between DD MM and YYYY""" dateSeparator: String """Not used""" dblNum: String """Not used""" dblRate2: Float """Not used""" dblRate1: Float """Number of places for the default currency""" decimalPlaces: Float """Type of decimal separator""" decimalSeparator: String """Not used""" defaultCommissionPercentage: String """Not used""" defaultFaxType: String """Folio style to be used for all guests""" defaultFolioStyle: Float """Not used""" defaultGroupsRateCode: String """Default guest address format.""" defaultGuestAddress: String """Future use""" defaultMembershipType: String """Future use""" defaultPostingRoom: String """Not used.""" defaultPrepaidComm: String """Not Used""" defaultPrinter: String """Default rate code to be used to calculate the total revenue.""" defaultRateCode: String """Rate code used to default a PCR rate code used in FIT Contracts.""" defaultRatecodePcr: String """Rate code used to default a RACK rate code used for FIT Contracts.""" defaultRatecodeRack: String """Default registration card for the property.""" defaultRegistrationCard: String """The Default reservation type for this property""" defaultReservationType: String """Not used.""" defaultTrxCommissionCode: String """Deleted Flag""" deletedFlag: String """Future use""" depositLedgerTrxCode: String """Destination ID""" destinationId: String """Future use""" dfltPkgTranCode: String """Future use""" dfltTranCodeRateCode: String """Internal""" directions: String """Future use""" dirsales: String """LOGIN into the application is disabled.""" disableLoginYn: String """Download Rest Y/N""" downloadRestYn: String """Pager number for the Manager on duty for the property.""" dutyManagerPager: String """Email""" email: String """End Date""" endDate: Date """Exchange Posting Type""" exchangePostingType: String """Hotel code used for third party exports""" expHotelCode: String """Expiry Date""" expiryDate: Date """Future use""" extExpFileLocation: String """Future use""" extPropertyCode: String """Indicates that the property uses an external SC system.""" externalScYn: String """Fax""" fax: String """Fax number formats.""" faxNoFormat: String """Not used.""" fileTransferFormat: String """Future use""" fiscalEndDate: Date """Future use""" fiscalPeriodType: String """Future use""" fiscalStartDate: Date """Screen Painter flags to indicate whether an item is changable/ movable etc.""" flags: String """Floor number of executive floor.""" floorNumExecutiveFloor: String """Future use""" flowCode: String """Property Free Nights Stay Tier.""" fnsTier: String """Other languages""" folioLanguage1: String """Other languages""" folioLanguage2: String """Other languages""" folioLanguage3: String """Other languages""" folioLanguage4: String """Not used""" font: Float """Future use""" genmgr: String """To define an upper limit to the number of rooms for Group""" groupRoomWarning: Float """Future use""" guestLookupTimeout: Float """Property Code.""" hotelCode: String """Future use""" hotelFc: String """Hotel ID""" hotelId: String """Hotel Type""" hotelType: String """HUB""" hub: String """Future use""" imgDirectionId: Float """Future use""" imgHotelId: Float """Future use""" imgMapId: Float """Future use""" inactiveDaysForGuestProfil: Float """Future use""" individualAddressType: String """Future use""" individualPhoneType: String """To define an upper limit to the number of rooms for group""" individualRoomWarning: Float """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Int Tax Included Y/N""" intTaxIncludedYn: String """Indicates if the Resources under this Type need to maintain inventory.""" inventoryYn: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """To calculate the entire availability of the Hotel for future reservations""" keepAvailability: Float """Latitude of the property in decimal""" latitude: Float """Name of Contact 1 (Free text or from RESORT_CONTACTS)""" leadsend: String """The owner who owns this property""" legalOwner: String """License Code""" licenseCode: String """Long date format for the property.""" longDateFormat: String """The default length of stay""" longStayControl: Float """Longitude of the property in decimal""" longitude: Float """Maximum adults in family rooms.""" maxAdultsFamilyRoom: Float """Maximum children in family rooms.""" maxChildrenFamilyRoom: Float """Maximum number of days that are allowed to credit a bill. (Country requirements.) Used in CASHIERING MODULE.""" maxCreditDays: Float """Not used""" maxNoNights: Float """Max Occupancy""" maxOccupancy: Float """Indicates if the property supports MBS. Used in some file exports.""" mbsSupportedYn: String """Future use""" meetRooms: Float """Future use""" meetSeats: Float """Future use""" meetSpace: Float """Future use""" meetingFc: String """Minimum days for reminder letter.""" minDaysBet2ReminderLetter: Float """Name""" name: String """Internal""" nameIdLink: Float """Future use""" nightAuditCashierId: String """Notes""" notes: String """Total number of beds in this property""" numberBeds: Float """Total number of floors in this property""" numberFloors: Float """Number Rooms""" numberRooms: Float """Future use""" opusCurrencyCode: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Future use""" ownership: String """Package Loss code for a particular package""" packageLoss: String """Package Profit code for a particular Package""" packageProfit: String """Market code for passerby""" passerbyMarket: String """Source code for passerby""" passerbySource: String """Path""" path: String """This is the value used in Interfaces to map to a Resort Code.""" pathId: Float """Payment Date""" paymentDate: Date """Future use""" perReservationRoomLimit: Float """Postal Code""" postalCode: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Property MAP URL.""" propMapUrl: String """Property picture URL.""" propPicUrl: String """URL where property information is located.""" propinfoUrl: String """Number of connecting rooms.""" qtyConnectingRooms: Float """Number of double rooms.""" qtyDoubleRooms: Float """Number of family rooms.""" qtyFamilyRooms: Float """Number of guest elevators.""" qtyGuestElevators: Float """Total of guest rooms floors.""" qtyGuestRoomFloors: Float """Number of handicapped rooms.""" qtyHandicappedRooms: Float """Number of non smoking rooms.""" qtyNonSmokingRooms: Float """Number of single rooms.""" qtySingleRooms: Float """Number of suites.""" qtySuites: Float """Number of twin rooms.""" qtyTwinRooms: Float """Future use""" quotedCurrency: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Records the date on which the reconciliation is done""" reconcileDate: Date """Region Code""" regionCode: String """Property Type""" resortType: String """Future use""" restaurant: Float """Total number of Sheets""" rhythmSheets: Float """Total number of Towels""" rhythmTowels: Float """Room amenity.""" roomAmenity: String """To store number of days before deleting the gest profile""" saveProfiles: Float """Script ID""" scriptId: Float """Future use""" season1: String """Future use""" season2: String """Future use""" season3: String """Future use""" season4: String """Future use""" season5: String """Indicates that the property accepts leads as bookings.""" sendLeadAsBookingYn: String """Future use""" sglNum: String """Future use""" sglRate1: Float """Future use""" sglRate2: Float """Shop description.""" shopDescription: String """Short date format for the property.""" shortDateFormat: String """For default commission percentage""" sourceCommission: String """State""" state: String """The street of the property.""" street: String """Future use""" suiNum: String """Future use""" suiRate1: Float """Future use""" suiRate2: Float """Internal""" summCurrencyCode: String """For default commission percentage""" taCommission: String """The direct dial phone number of this property""" telephone: String """Formats for telephone number""" telephoneNoFormat: String """Separator for monetory values""" thousandSeparator: String """Default time format for the property.""" timeFormat: String """Time zone region selected by the employee.""" timeZone: String """Toll free telephone number.""" tollFree: String """Future use""" totalRooms: Float """Tourist Number""" touristNumber: String """Future use""" tplNum: String """Future use""" tplRate1: Float """Future use""" tplRate2: Float """Indicates whether the property handles multi byte characters and whether they are translateable or not""" translateMulticharYn: String """Turnaway Code""" turnawayCode: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float """VAT ID of this property.""" vatId: String """Video check out start time.""" videoCoStart: Date """Video check out end time.""" videoCoStop: Date """Future use""" videocheckoutPrinter: String """Future use""" wakeUpDelay: Float """Amount at which warning is raised.""" warningAmount: Float """Webaddress of the property""" webaddress: String """Indicates weekend days seperated by '' Eg 17 ie Sun and Sat""" weekendDays: String """Numbers (1 thru 10) given to the resorts in the schema to print the tax collected by that resort in the gstfolio when proper merge codes are selected.""" xresortNumber: Float """Internal""" zeroInvPurDays: Float } type ConfigurationChainNoteTypeDetailsType { """Can Delete Y/N""" canDeleteYn: String """Chain Code""" chainCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Stores the default note text.""" defaultNoteText: String """Specifies if the note type has default note to be populated when selected.""" defaultNoteTextYN: String """Default Note Type YN""" defaultNoteTypeYN: String """Deleted Flag""" deletedFlag: String """Indicate if the note is for departments.""" deptNoteYn: String """Global Y/N""" globalYn: String """Hel text for notes.""" helpText: String """Inactive Date""" inactiveDate: DateTime """Inactive Flag""" inactiveflag: String """Deleted Flag""" internalDeletedflag: String """Internal YN""" internalYN: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """User defined note class.""" noteClass: String """Note Type""" noteType: String """Note Type Code""" noteTypeCode: String """Note Type Description""" noteTypeDescription: String """Notes Group""" notesGroup: String """Notetypeid""" notetypeid: String """Notetypepmsref""" notetypepmsref: String """Comma separated list of areas where this notification will be shown. Possible values are 'PROFILE' 'CHECK IN' 'RESERVATION' 'CHECK OUT' 'NEVER'.""" notificationAreas: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Changing internal_yn is allowed for Y and changing internal_yn is not allowed for N while creating/modifying notes.""" overrideInternalYN: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Indicates whether the description can be modified by the user or not""" protectDescriptionYn: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Sequence""" sequence: Float """Determines if notes of this note type will be included in the webProposal XML.""" webProposalYn: String } type ConfigurationChainPropertyTypeDetailsType { """Central Code""" centralCode: String """Central Description""" centralDescription: String """Central Sequence""" centralSequence: Float """Chain Code""" chainCode: String """Code""" code: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Description""" description: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Reporting Item""" repItem: String """Reporting Item Name""" repItemName: String """Reporting Item Orderby""" repItemOrderby: Float """Reporting Updatedate""" repUpdateDate: DateTime """Sequence""" sequence: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainForeignCurrencyDetailsType { """Abbreviation""" abbreviation: String """Active YN""" activeYN: String """Can Delete Y/N""" canDeleteYn: String """Chain Code""" chainCode: String """Curr Action ID""" currencyActionId: Float """Currency Code""" currencyCode: String """Currency Description""" currencyDescription: String """Currency Symbol like $ or EURO symbol""" currencySymbol: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Decimals""" decimals: Float """Deleted Flag""" deletedFlag: String """Foreign Currency ID""" foreignCurrencyID: String """Format Mask""" formatMask: String """Inactive Date""" inactiveDate: DateTime """Inactive Flag""" inactiveflag: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Deleted Flag""" internalDeletedflag: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Indicates if this Currency Exchange Rate is available for consumer mobility.""" mobileYn: String """Multiply""" multiply: Float """Order By""" orderBy: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """This will be significant after EURO conversion. The currency before the Euro conversion gets a value Y.""" previousLocalCurrencyYn: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Indicates whether this currency code can be sold though currency exchange.""" sellCurrency: String """Indicates whether the currency is Euro participant.""" trianMethodYn: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float """Indicates if this currency can be used for Credit Card payments.""" usedForCcPaymentsYn: String } type ConfigurationChainItemRateRulesDetailsType { """Central Description""" centralDescription: String """Central Sequence""" centralSequence: Float """Chain Code""" chainCode: String """Code""" code: String """Code ID""" codeId: Float """Code Type""" codeType: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Description""" description: String """Display Y/N""" displayYn: String """Specifies that the space is not available for this setup style for the entire day.""" fulldayYn: String """Inactive Date""" inactiveDate: DateTime """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Reporting Item""" repItem: String """Reporting Item Name""" repItemName: String """Reporting Item Orderby""" repItemOrderby: Float """Reporting Updatedate""" repUpdateDate: DateTime """Rep Code ID""" reportingCodeId: String """Sequence""" sequence: Float """Web Booking Y/N""" webBookingYn: String """Setdown Time for web bookings.""" webSetdown: Float """Setup Time for web bookings.""" webSetup: Float } type ConfigurationChainPostalCodeDetailsType { """Chain Code""" chainCode: String """City""" city: String """Country""" country: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Row deleted YN (if set to 'Y' then the row joined by SEQ from postal_codes will not be displayed).""" deletedYn: String """Description""" description: String """District""" district: String """Fiscal Region""" fiscalRegion: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Organization""" organizationID: Float """The Beginning Postal Code Range for this state.""" postalCodeFrom: String """The ending Postal Code for the State.""" postalCodeTo: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Region Code""" regionCode: String """Uppercase value of CITY column.""" scity: String """Sequence""" seq: Float """State""" state: String """Territory code related to this Postal Code.""" territory: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainIDDocumentTypeDetailsType { """Chain Code""" chainCode: String """Check for Duplicates flag.""" checkForDuplicatesYn: String """Code""" code: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Description""" description: String """Possible values are: PASSPORT DRIVER_LICENSE VISA ID UNKNOWN or NULL.""" iDRole: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Sequence""" sequence: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainLanguageDetailsType { """Chain Code""" chainCode: String """Code""" code: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Description for each language code.""" description: String """Indicates if this language is a valid Alternate Language for Enrollment / Lookup.""" enrollmentAltYn: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Specific geographic political or cultural region (used in the OperaXMLP Java servlet for translation and formatting)""" locale: String """Type of characters that this language uses i.e.: LATIN ARABIC CYRILLIC CHINESE_CANTONESE or CHINESE_MANDARIN.""" nativeWritingSystem: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Preferred Language for Return Addresses. Used for Address Cleansing using AddressDoctor V5.""" preferredLanguageAdV5: String """Character set used for the returned address. Used for Address Cleansing using AddressDoctor V5.""" preferredScriptAdV5: String """Language of the Returned address.""" preferredlanguage: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """NLS_DATE_LANGUAGE code used in Reports""" reportDateLanguage: String """ISO Country code""" translationLanguage: String } type ConfigurationChainRegionDetailsType { """Chain Code""" chainCode: String """Code""" code: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedflag: String """Inactive Flag""" inactiveflag: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Region Description""" regionDescription: String """Regionid""" regionid: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Sequence""" sequence: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainStateDetailsType { """Chain Code""" chainCode: String """Code""" code: String """Country""" country: String """Countryid""" countryid: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedflag: String """Description""" description: String """Inactive Date""" inactiveDate: DateTime """Inactive Flag""" inactiveflag: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Reporting Description""" repDescription: String """Reporting Item""" repItem: String """Reporting Item Name""" repItemName: String """Reporting Item Orderby""" repItemOrderby: Float """Reporting Order By""" repOrderBy: Float """Reporting Updatedate""" repUpdateDate: DateTime """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Sequence""" sequence: Float """State Code""" stateCode: String """Stateid""" stateid: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainMembershipClassDetailsType { """Chain Code""" chainCode: String """Primary key of this table""" code: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Description""" description: String """Frequent Flyer YN""" frequentFlyerYN: String """Inactive Flag""" inactiveflag: Float """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Deleted Flag""" internalDeletedflag: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Loyalty Program YN""" loyaltyProgramYN: String """Membershipclassid""" membershipclassid: 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 """Sequence""" sequence: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainConfirmationFormatDetailsType { """Can Delete Y/N""" canDeleteYn: String """Chain Code""" chainCode: String """Primary key column for the table""" code: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Description""" description: String """The format definition which includes the elements of address.""" formatDefinition: String """Format Type""" formatType: String """Inactive Date""" inactiveDate: DateTime """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Sales Address Format YN""" salesAddressFormatYN: String """Sequence""" sequence: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainCommunicationTypeDetailsType { """Can Delete Y/N""" canDeleteYn: String """Chain Code""" chainCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Description""" description: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Role""" role: String """Sequence""" sequence: Float """Indicate if SMS text messages can be send via this communication type.""" textMessagingEnabledYN: String """Type""" type: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainProfilePreferenceTypeDetailsType { """Indicates if Sub Types are allowed.""" allowSubTypesYn: String """Can Delete Y/N""" canDeleteYn: String """Central Code""" centralCode: String """Central Description""" centralDescription: String """Central Sequence""" centralSequence: Float """Chain Code""" chainCode: String """Code""" code: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Description""" description: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Maximum quantity of preferences which can be selected for this preference type.""" quantity: Float """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Reporting Item""" repItem: String """Reporting Item Name""" repItemName: String """Reporting Item Orderby""" repItemOrderby: Float """Reporting Updatedate""" repUpdateDate: DateTime """Indicator whether this preference type can be used in reservations.""" reservationYN: String """Sequence""" sequence: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainProfileProfileDetailsType { """Chain Code""" chainCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Set of words that represent a profile name.""" name: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Type""" type: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainConfigurationRelationshipDetailsType { """Can Delete Y/N""" canDeleteYn: String """Chain Code""" chainCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """From Description""" fromDescription: String """From Relationship Code""" fromRelationshipCode: String """From Relationship Type.""" fromRelationshipType: String """Global Y/N""" globalYn: String """Has Hierarchy YN""" hasHierarchyYN: String """Indicates if custom profile protection is not applicable for this relationship type.""" ignoreProtectionYn: String """Inactive Date""" inactiveDate: DateTime """Inactive Flag""" inactiveFlag: String """Individualflag""" individualflag: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Inactive Flag""" internalInactiveflag: String """Organization ID""" internalOrganizationId: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Primaryflag""" primaryflag: String """Rate""" rate: String """Module related to this Name Type whether it is used in PMS S&C etc.""" relationCategory: String """Relationship ID""" relationshipId: String """Used in S&C Module""" relationshipRole: String """Relationshippms""" relationshippms: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Temp Flag""" tempFlag: String """Description of the To Relationship.""" toDescription: String """To Relationship type.""" toRelationshipCode: String """To Relationship Type""" toRelationshipType: String """Toindividualflag""" toindividualflag: String """Toinheritratesflag""" toinheritratesflag: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainMembershipClaimTypeDetailsType { """Business Title""" businessTitle: String """Can Delete Y/N""" canDeleteYn: String """Chain Code""" chainCode: String """Claim Type Code""" claimTypeCode: String """Claim Type Description""" claimTypeDescription: String """Comments""" comments: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedflag: String """Display Color""" displayColor: String """Entity Name""" entityName: String """Contains a list of codes used by a vendor.""" externalAttributeCodes: String """Inactive Date""" inactiveDate: DateTime """Inactive Flag""" inactiveflag: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Language Code""" languageCode: String """Internal ID to uniquely identify the Property""" locationID: String """Indicates if the KEYWORD TYPE is to be copied from a Company Master to a Company Subsidiary.""" masterSubKeywordYn: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Code to uniquely identify the Property""" property: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Ranking""" ranking: Float """Reporting Attribute Code""" repAttributeCode: String """Reporting Description""" repDescription: String """Reporting Item""" repItem: String """Reporting Item Name""" repItemName: String """Reporting Item Orderby""" repItemOrderby: Float """Reporting Order By""" repOrderBy: Float """Reporting Updatedate""" repUpdateDate: DateTime """Sequence""" sequence: Float """Title Suffix""" titleSuffix: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainMembershipAwardsDetailsType { """Indicates if award consumtion is tracked by the system. If value is Y then system keeps a track of availability of award after it is issued.""" autoConsumeYn: String """Indicates if the Award is a Stay Pkg Element or other.""" awardBasedOn: String """Award Based On Desc""" awardBasedOnDesc: String """Award Code""" awardCode: String """Award Description""" awardDescription: String """Enter a number to indicate the number of awards to be given.""" awardQuantity: Float """Value of the award in central currency.""" awardValue: Float """Billing Group""" billingGroup: String """Central Award Value""" cAwardValue: Float """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Number points deducted is award is cancelled.""" cancelPenaltyChargePoints: Float """Number days before arrival to apply penalty for cancellation.""" cancelPenaltyDays: Float """Cancel Penalty Type""" cancelPenaltyType: String """Cancel Policy Type""" cancelPolicyType: String """Chain Code""" chainCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Display Set""" displaySet: String """End Sell Date""" endSellDate: Date """Exchange Rate Type""" exchangeRateType: String """Force verification whether Rate or Product for the Award is valid at reservation.""" forceVerificationYn: String """This column identify that should we ignore Financial transactions in OPERA or not? Y - Financial transaction is not required in OPERA while giving award as it may be recorded in some external system and only points accounting is done in OCIS.""" ignoreFtTransactionYN: String """Inactive Date""" inactiveDate: Date """Inactive YN""" inactiveYN: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Label""" label: String """Max percent of total value to be allowed to convert money to points.""" maxPercentAllowed: Float """Membership Level""" membershipLevel: String """Membership Type""" membershipType: String """Message for Other awards.""" messageLine1: String """Message for Other awards.""" messageLine2: String """Message for Other awards.""" messageLine3: String """Message for Other awards.""" messageLine4: String """Nights YN""" nightsYN: String """Number of Nights""" numberOfNights: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Points Required""" pointsRequired: Float """Points Required Desc""" pointsRequiredDesc: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Pts Sch Code""" ptsSchCode: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Indicates if the membership award upgrade is based on room category (N) or room category group (Y).""" roomCategoryGroupYN: String """Sequence""" sequence: Float """Start Sell Date""" startSellDate: Date """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainMembershipEnrollDetailsType { """Code to indicate source used to enroll the member.""" attachedEnrollmentCode: String """Attached Enrollment Description""" attachedEnrollmentDescription: String """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 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 """Enrollment group that includes the enrollment code(s) to which this rule applies.""" memEnrollGroup: String """Membershipenrollid""" membershipenrollid: 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 """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainMembershipLevelDetailsType { """Auto-Renewal After""" autoRenewalAfter: String """Central VIP Code""" centralVIPCode: String """Central VIP Code Description""" centralVIPCodeDescription: String """Chain Code""" chainCode: String """Indicates whether a change to this level is restricted once a guest attains this level.""" changesRestrictedYN: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Display Color Code""" displayColorCode: String """Display Color Description""" displayColorDescription: String """Double Dipping YN""" doubleDippingYN: String """Number of years card will be valid for this level.""" expiryPeriod: Float """Fulfillment YN""" fulfillmentYN: String """Inactive Date""" inactiveDate: DateTime """Inactive YN""" inactiveYN: 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 """Label""" label: String """Level Code""" levelCode: String """Used in EIS Module.""" maxDowngradeLevel: String """Max. Downgrade Level Description""" maxDowngradeLevelDescription: String """Membership Type""" membershipType: String """Membershiplevelid""" membershiplevelid: String """Membershiplevelpmsref""" membershiplevelpmsref: String """Membershiptypeid""" membershiptypeid: 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 """Order By""" orderBy: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """The sequence of membership levels starting with 1 (The starting level) and increasing to the highest level.""" rank: Float """Renew Card on Stay YN""" renewCardOnStayYN: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Update Date""" updateDate: DateTime """Update User""" updateUser: Float """VIP Code""" vIPCode: String """VIP Code Description""" vIPCodeDescription: String } type ConfigurationChainMembershipCardRangesDetailsType { """Start range of credit card no""" cardRangeFrom: String """End range of credit card no""" cardRangeTo: String """Chain Code""" chainCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Membership Type""" membershipType: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainMembershipLevelBenefitsDetailsType { """Chain Code""" chainCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """From Date""" fromDate: Date """Inactive Date""" inactiveDate: Date """Inactive YN""" 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.""" levelCode: String """Level Description""" levelDescription: String """Membership Type""" membershipType: String """Min value for membership level. This is the minumum membership level member gets for enrolling into this program.""" minimumMembershipLevel: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """To Date""" toDate: Date """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainMembershipMarketGroupCodeDetailsType { """Attached Market Codes""" attachedMarketCodes: String """Attached Market Description""" attachedMarketDescription: String """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 """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Membership Market Group""" memMarketGroup: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainMembershipRateGroupCodeDetailsType { """Attached Rate Code""" attachedRateCode: String """Attached Rate Code Description""" attachedRateCodeDescription: String """Chain Code""" chainCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: 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 """Membership Rate Group""" memRateGroup: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainMembershipRevenueGroupCodeDetailsType { """Revenue Types defined for OIS memberships.""" attachedRevenueGroupCode: String """Attached Revenue Group Description""" attachedRevenueGroupDescription: String """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 """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Membership rate group.""" memRevenueGroup: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ConfigurationChainPropertyBookingStatusNextDetailsType { """Central Code""" centralCode: String """Central Description""" centralDescription: String """Chain Code""" chainCode: String """Next status of the status column""" code: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Description""" description: String """Display Color""" displayColor: String """Inactive Date""" inactiveDate: DateTime """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Order By""" orderBy: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Status""" status: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float }