# title : OPERA Cloud RnA ProfilesIndividuals GraphQL API, # description : GraphQL API to cater for Guest profile data including contact information, VIP codes, memberships and stay statistics with room and revenue details. # Compatible with OPERA Cloud RnA release 26.1.0.0. # This document and all content within is available under the Universal Permissive License v 1.0 # (https://oss.oracle.com/licenses/upl). Copyright (c) 2020,2026 Oracle and/or its affiliates # version : 26.1.0.0 # termsOfService : https://www.oracle.com/legal/terms.html # contact_email : hospitality_apis_ww_grp@oracle.com # license : https://opensource.org/licenses/upl directive @stream(if: Boolean, label: String, initialCount: Int = 0) on FIELD directive @conditionalInputPair(pair: Int) on INPUT_FIELD_DEFINITION directive @mandatoryInput on INPUT_FIELD_DEFINITION scalar Date scalar DateTime # Date format: "YYYY-MM-DD" input DateInput{ _eq: Date _ne: Date _in: [Date] _nin: [Date] _gt: Date _lt: Date _gte: Date _lte: Date _btn: DateRangeInput _isNull: Boolean } input DateRangeInput { start: Date! end: Date! } # Datetime format: "YYYY-MM-DD HH24:MI:SS" input DateTimeInput { _eq: DateTime _ne: DateTime _in: [DateTime] _nin: [DateTime] _gt: DateTime _lt: DateTime _gte: DateTime _lte: DateTime _btn: DateTimeRangeInput _isNull: Boolean } input DateTimeRangeInput { start: DateTime! end: DateTime! } input StringInput { _eq: String _ne: String _in: [String] _nin: [String] _gt: String _lt: String _gte: String _lte: String _isNull: Boolean } input FloatInput { _eq: Float _ne: Float _in: [Float] _nin: [Float] _gt: Float _lt: Float _gte: Float _lte: Float _btn: FloatRangeInput _isNull: Boolean } input FloatRangeInput { start: Float! end: Float! } # Conditional Mandatory filters: # At least one filter from each required filter pair must be provided. # Please ensure the request includes at least one filter from each required pair. # Pair - [1] # - profileallDetailsChainCode # Pair - [2] # - profileallDetailsActiveYn # - profileallDetailsCompanyGroupId # - profileallDetailsCrsNameid # - profileallDetailsInactiveDate # - profileallDetailsIndexName # - profileallDetailsJrnupdatedttm # - profileallDetailsNameCode # - profileallDetailsNameId # - profileallDetailsOrganizationId # - profileallDetailsProfileId # - profileallDetailsSfirst # - profileallDetailsSname # - profileallDetailsSrepCode # - profileallDetailsSxfirstName # - profileallDetailsSxname # - profileallDetailsUpdateDate input ProfilesIndividualsQueryArgumentsType { """The primary key for this table.""" profileallDetailsNameId: FloatInput @conditionalInputPair(pair: 2) """Profile is active or not.""" profileallDetailsActiveYn: StringInput @conditionalInputPair(pair: 2) """This is a name_id (Profile number) of profiles that exist in a Central database in a typical CRS environment.""" profileallDetailsCrsNameid: FloatInput @conditionalInputPair(pair: 2) """Chain Code""" profileallDetailsChainCode: StringInput @conditionalInputPair(pair: 1) """The unique key of this name stores IATA# Company # etc.""" profileallDetailsNameCode: StringInput @conditionalInputPair(pair: 2) """The company group or company group user ID in hierarchical format""" profileallDetailsCompanyGroupId: StringInput @conditionalInputPair(pair: 2) """Used in S&C Module.""" profileallDetailsContactFlag: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" profileallDetailsDsi: FloatInput """Direct Bill Batch Type""" profileallDetailsDirectBillBatchType: StringInput """The last name of the individual Profile and Search name ofr the other Types of Profiles (Group Travel Agent & Source) are stored in this column.""" profileallDetailsLast: StringInput """Keep guest in history Y/N""" profileallDetailsHistoryYn: StringInput """The date the record was marked as inactive""" profileallDetailsInactiveDate: DateTimeInput @conditionalInputPair(pair: 2) """Index Name""" profileallDetailsIndexName: StringInput @conditionalInputPair(pair: 2) """Organization ID""" profileallDetailsOrganizationId: FloatInput @conditionalInputPair(pair: 2) """JRN Update Date and Time""" profileallDetailsJrnupdatedttm: DateTimeInput @conditionalInputPair(pair: 2) """The type of Profile.""" profileallDetailsNameType: StringInput """Internal ID to uniquely identify the Organization""" profileallDetailsOrganizationid: FloatInput """The primary key for this table.""" profileallDetailsProfileId: FloatInput @conditionalInputPair(pair: 2) """The type of Profile.""" profileallDetailsProfileType: StringInput """Resort for which Job is registered.""" profileallDetailsResortRegistered: StringInput """This column store the Name of the Company Profiles.""" profileallDetailsCompany: StringInput """The Uppercase value of Last or Company.""" profileallDetailsSname: StringInput @conditionalInputPair(pair: 2) """Internal Indexed field for Searching by Extended Byte Name.""" profileallDetailsSxname: StringInput @conditionalInputPair(pair: 2) """Uppercase value of First Name.""" profileallDetailsSfirst: StringInput @conditionalInputPair(pair: 2) """Used in QMS Module""" profileallDetailsSrepCode: StringInput @conditionalInputPair(pair: 2) """Internal Indexed field for Searching by Extended Byte First Name.""" profileallDetailsSxfirstName: StringInput @conditionalInputPair(pair: 2) """The date the record was modified""" profileallDetailsUpdateDate: DateTimeInput @conditionalInputPair(pair: 2) """The first line of street address.""" profileaddressDetailsAddress1: StringInput """The second line of street address.""" profileaddressDetailsAddress2: StringInput """The third line of street address.""" profileaddressDetailsAddress3: StringInput """The fourth line of street address.""" profileaddressDetailsAddress4: StringInput """The primary key for this table.""" profileaddressDetailsAddressId: FloatInput """Address Language""" profileaddressDetailsLanguageCode: StringInput """Description for each language code.""" profileaddressDetailsLanguageDesc: StringInput """The type of address.""" profileaddressDetailsAddressType: StringInput """The description of this value.""" profileaddressDetailsAddressTypeDesc: StringInput """The postal barcode for the address.""" profileaddressDetailsBarcode: StringInput """Not used.""" profileaddressDetailsBeginDate: DateInput """Central State""" profileaddressDetailsRepStateCode: StringInput """Central State Description""" profileaddressDetailsRepState: StringInput """The Chain code of the chain for which this record belongs to.""" profileaddressDetailsChainCode: StringInput """The city for this address.""" profileaddressDetailsCity: StringInput """The Timestamp when this record was cleansed.""" profileaddressDetailsCleansedDatetime: DateTimeInput """The error message why this record was not cleansed.""" profileaddressDetailsCleansedErrormsg: StringInput """Specifies how the address elements match with the postal reference data.""" profileaddressDetailsCleansedMatchstatus: StringInput """Status of Address Cleansing. Null = Record is not cleansed. C = Cleansed. F = Failure.""" profileaddressDetailsCleansedStatus: StringInput """Validation Status as returned by the Address Cleansing System.""" profileaddressDetailsCleansedValidationstatus: StringInput """The unique key of this name stores IATA# Company # etc.""" profileaddressDetailsNameCode: StringInput """Country .""" profileaddressDetailsCountryCode: StringInput """Country name.""" profileaddressDetailsCountry: StringInput """The user that created the record""" profileaddressDetailsInsertUser: FloatInput """The date the record was created""" profileaddressDetailsInsertDate: DateTimeInput """DSI Internal Data Source ID to identify Opera Chain and instance""" profileaddressDetailsDsi: FloatInput """Deleted Y/n""" profileaddressDetailsDeletedFlag: StringInput """Not used.""" profileaddressDetailsEndDate: DateInput """The first name of an individual name.""" profileaddressDetailsFirst: StringInput """Not used.""" profileaddressDetailsForeignCountry: StringInput """Not used.""" profileaddressDetailsInCareOf: StringInput """The date the record was marked as inactive""" profileaddressDetailsInactiveDate: DateTimeInput """Inactive Y/n""" profileaddressDetailsInactiveFlag: StringInput """Organization ID""" profileaddressDetailsOrganizationId: FloatInput """JRN Update Date and Time""" profileaddressDetailsJrnupdatedttm: DateTimeInput """Code to synchronize with Laptop. (not used)""" profileaddressDetailsLaptopChange: FloatInput """Last property that updated this record.""" profileaddressDetailsLastUpdatedResort: StringInput """Name""" profileaddressDetailsName: StringInput """Internal ID to uniquely identify the Organization""" profileaddressDetailsOrganizationid: FloatInput """The postal code of this address.""" profileaddressDetailsZipCode: StringInput """City Extension mainly used for UK addresses.""" profileaddressDetailsCityExt: StringInput """Internal Primary Key ID to uniquely identify the row""" profileaddressDetailsPkid: FloatInput """Profile having Multiple Addresses Need to have one Primary Address for each Type.""" profileaddressDetailsPrimaryYn: StringInput """The primary key for this table.""" profileaddressDetailsProfileAddressId: FloatInput """The reference to the NAME record that owns this address.""" profileaddressDetailsNameId: FloatInput """The reference to the NAME record that owns this address.""" profileaddressDetailsProfileId: FloatInput """Province.""" profileaddressDetailsProvince: StringInput """RnA Insertdate""" profileaddressDetailsRnaInsertdate: DateTimeInput """RnA Updatedate""" profileaddressDetailsRnaUpdatedate: DateTimeInput """State""" profileaddressDetailsState: StringInput """The state of this address.""" profileaddressDetailsStateCode: StringInput """The date the record was modified""" profileaddressDetailsUpdateDate: DateTimeInput """The user that modified the record""" profileaddressDetailsUpdateUser: FloatInput """Not used.""" profilecommunicationDetailsAddressId: FloatInput """Not used.""" profilecommunicationDetailsBeginDate: DateInput """The Chain code of the chain for which this record belongs to.""" profilecommunicationDetailsChainCode: StringInput """The primary key for this table.""" profilecommunicationDetailsPmsPhoneId: FloatInput """Role in which this phone type belongs to.""" profilecommunicationDetailsRole: StringInput """The phone number for this record""" profilecommunicationDetailsPhoneNumber: StringInput """Country Code of the phone number.""" profilecommunicationDetailsCountryCode: StringInput """Numeric phone dialing prefix code for the country.""" profilecommunicationDetailsCountryDialingCode: FloatInput """Country Code of the phone number.""" profilecommunicationDetailsCountryId: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" profilecommunicationDetailsDsi: FloatInput """Phone_role to be used for default confirmation.""" profilecommunicationDetailsDefaultMethodFlag: StringInput """Deleted Flag""" profilecommunicationDetailsDeletedFlag: StringInput """Order in which the phone numbers should be displayed.""" profilecommunicationDetailsOrderby: FloatInput """Format type for email messages: HTML PLAIN text.""" profilecommunicationDetailsEmailFormat: StringInput """Optional language for e-mail.""" profilecommunicationDetailsEmailLanguage: StringInput """The date this record becomes invalid for use in the system. User enterable.""" profilecommunicationDetailsEndDate: DateInput """Telephone Extension.""" profilecommunicationDetailsExtension: StringInput """The first name of an individual name.""" profilecommunicationDetailsFirst: StringInput """The date the record was marked as inactive""" profilecommunicationDetailsInactiveDate: DateTimeInput """Inactive Flag""" profilecommunicationDetailsInactiveFlag: StringInput """Index Phone""" profilecommunicationDetailsIndexPhone: StringInput """The date the record was created""" profilecommunicationDetailsInsertDate: DateTimeInput """The user that created the record""" profilecommunicationDetailsInsertUser: FloatInput """Organization ID""" profilecommunicationDetailsOrganizationId: FloatInput """The reference to the name that owns this phone.""" profilecommunicationDetailsProfileId: FloatInput """JRN Update Date and Time""" profilecommunicationDetailsJrnupdatedttm: DateTimeInput """Code to synchronize with Laptop""" profilecommunicationDetailsLaptopChange: FloatInput """The last name of the individual Profile and Search name ofr the other Types of Profiles (Group Travel Agent & Source) are stored in this column.""" profilecommunicationDetailsLast: StringInput """Marked as Y when the Phone Number/EMail Address is Opt In.""" profilecommunicationDetailsMobileAudioKeyYn: StringInput """Internal ID to uniquely identify the Organization""" profilecommunicationDetailsOrganizationid: FloatInput """The primary key for this table.""" profilecommunicationDetailsPhoneId: FloatInput """The type of this phone number.""" profilecommunicationDetailsPhoneType: StringInput """Description of Phone Types.""" profilecommunicationDetailsPhoneTypeDescription: StringInput """The type of this phone number.""" profilecommunicationDetailsPhoneTypeId: StringInput """Internal Primary Key ID to uniquely identify the row""" profilecommunicationDetailsPkid: FloatInput """Indicates the primary telephone number in the case of multiple phone numbers on a profile.""" profilecommunicationDetailsPrimaryYn: StringInput """The reference to the name that owns this phone.""" profilecommunicationDetailsNameId: FloatInput """RnA Insertdate""" profilecommunicationDetailsRnaInsertdate: DateTimeInput """RnA Updatedate""" profilecommunicationDetailsRnaUpdatedate: DateTimeInput """Used for uploading the email to holidex if the value is Y.""" profilecommunicationDetailsShareEmailYn: StringInput """The date the record was modified""" profilecommunicationDetailsUpdateDate: DateTimeInput """The user that modified the record""" profilecommunicationDetailsUpdateUser: FloatInput """Indicates that the phone number has been validated using the Starwood API and is determined to be valid a value indicates that the phone number has not been validated.""" profilecommunicationDetailsValidYn: StringInput """Can Delete Y/N""" profilepreferenceDetailsCanDeleteYn: StringInput """Central Preference Code""" profilepreferenceDetailsRepPreferenceTypeCode: StringInput """Central Preference Description""" profilepreferenceDetailsRepDescription: StringInput """Central Preference Group""" profilepreferenceDetailsRepPreferenceType: StringInput """ASP chain code.""" profilepreferenceDetailsChainCode: StringInput """Not used.""" profilepreferenceDetailsChargeYn: StringInput """The user that created the record""" profilepreferenceDetailsInsertUser: FloatInput """The date the record was created""" profilepreferenceDetailsInsertDate: DateTimeInput """DSI Internal Data Source ID to identify Opera Chain and instance""" profilepreferenceDetailsDsi: FloatInput """Deleted Flag""" profilepreferenceDetailsDeletedFlag: StringInput """The display sequence of the Preferences.""" profilepreferenceDetailsOrderby: FloatInput """Unique ID in External System.""" profilepreferenceDetailsExternalPreferenceId: StringInput """The date the record was marked as inactive""" profilepreferenceDetailsInactiveDate: DateTimeInput """Inactive Flag""" profilepreferenceDetailsInactiveFlag: StringInput """Organization ID""" profilepreferenceDetailsOrganizationId: FloatInput """JRN Update Date and Time""" profilepreferenceDetailsJrnupdatedttm: DateTimeInput """Laptop Change Indicator""" profilepreferenceDetailsLaptopChange: FloatInput """The property that the record belongs to""" profilepreferenceDetailsLocationid: StringInput """Not Used.""" profilepreferenceDetailsMpcode: StringInput """Reference to the name that owns this record.""" profilepreferenceDetailsNameId: FloatInput """The property that the record belongs to""" profilepreferenceDetailsLocationId: StringInput """Internal ID to uniquely identify the Organization""" profilepreferenceDetailsOrganizationid: FloatInput """Preference Code. Part of the Primary Key.""" profilepreferenceDetailsPreference: StringInput """Description of the Preference.""" profilepreferenceDetailsDescription: StringInput """Description of the Preference Type.""" profilepreferenceDetailsPreferenceType: StringInput """Preference Code.""" profilepreferenceDetailsPreferenceId: StringInput """Preference Type.""" profilepreferenceDetailsPreferenceTypeCode: StringInput """Preference Type.""" profilepreferenceDetailsPreferenceTypeId: StringInput """Preference Code.""" profilepreferenceDetailsPreferenceValue: StringInput """Internal Primary Key ID to uniquely identify the row""" profilepreferenceDetailsPkid: FloatInput """Reference to the name that owns this record.""" profilepreferenceDetailsProfileId: FloatInput """Preference Code.""" profilepreferenceDetailsProfilePreferenceId: StringInput """The property that the record belongs to""" profilepreferenceDetailsResort: StringInput """Reporting Orderby""" profilepreferenceDetailsRepOrderby: FloatInput """RnA Insertdate""" profilepreferenceDetailsRnaInsertdate: DateTimeInput """RnA Updatedate""" profilepreferenceDetailsRnaUpdatedate: DateTimeInput """The date the record was modified""" profilepreferenceDetailsUpdateDate: DateTimeInput """The user that modified the record""" profilepreferenceDetailsUpdateUser: FloatInput """The Chain code of the chain for which this record belongs to.""" profiledocumentsDetailsChainCode: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" profiledocumentsDetailsDsi: FloatInput """Deleted Flag""" profiledocumentsDetailsDeletedFlag: StringInput """Unique ID for this table.""" profiledocumentsDetailsDocumentId: FloatInput """The place where the ID was issued.""" profiledocumentsDetailsIdPlace: StringInput """Store the ID value of linked_attachments.attach_id pointing to the physical table column that stores the scanned document.""" profiledocumentsDetailsIdDocumentAttachId: FloatInput """The country where the ID was issued""" profiledocumentsDetailsIdCountry: StringInput """Expiration date of the ID document.""" profiledocumentsDetailsIdExpirationDate: DateInput """Identification Issued date.""" profiledocumentsDetailsIdDate: DateInput """Encrypted identification number.""" profiledocumentsDetailsIdNumber: StringInput """Indicates if this record is the primary one for the ID type.""" profiledocumentsDetailsPrimaryYn: StringInput """Identification type e.g: PASSPORT DRIVING LICENSE etc.""" profiledocumentsDetailsIdType: StringInput """Date this record was inactivated.""" profiledocumentsDetailsInactiveDate: DateTimeInput """The date the record was created.""" profiledocumentsDetailsInsertDate: DateTimeInput """The user that created the record.""" profiledocumentsDetailsInsertUser: FloatInput """JRN Update Date and Time""" profiledocumentsDetailsJrnupdatedttm: DateTimeInput """The property this record belongs to can be "_GLOBAL".""" profiledocumentsDetailsLocationid: StringInput """The profile ID reference who owns this document.""" profiledocumentsDetailsNameId: FloatInput """Display Sequence.""" profiledocumentsDetailsOrderBy: FloatInput """Internal ID to uniquely identify the Organization""" profiledocumentsDetailsOrganizationid: FloatInput """Internal Primary Key ID to uniquely identify the row""" profiledocumentsDetailsPkid: FloatInput """The property this record belongs to can be "_GLOBAL".""" profiledocumentsDetailsResort: StringInput """RnA Insertdate""" profiledocumentsDetailsRnaInsertdate: DateTimeInput """RnA Updatedate""" profiledocumentsDetailsRnaUpdatedate: DateTimeInput """Internal indexed field to search for ID_NUMBER.""" profiledocumentsDetailsSIdNumber: StringInput """The date the record was modified.""" profiledocumentsDetailsUpdateDate: DateTimeInput """The user that modified the record.""" profiledocumentsDetailsUpdateUser: FloatInput """Central Credit Limit""" profilemembershipDetailsCCreditLimit: FloatInput """Central Xchange Date""" profilemembershipDetailsCXchangeDate: DateInput """Central Xchange Rate""" profilemembershipDetailsCXchangeRate: FloatInput """Chain code.""" profilemembershipDetailsChainCode: StringInput """Used by EIS Module.""" profilemembershipDetailsComments: StringInput """Used in the EIS Module.""" profilemembershipDetailsCreditLimit: FloatInput """Used in the EIS Module.""" profilemembershipDetailsCurrentPoints: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" profilemembershipDetailsDsi: FloatInput """Deleted Flag""" profilemembershipDetailsDeletedFlag: StringInput """Encoded string on the device.""" profilemembershipDetailsDeviceCode: StringInput """Date when device was disabled.""" profilemembershipDetailsDeviceDisableDate: DateInput """Points or miles earning preference.""" profilemembershipDetailsEarningPreference: StringInput """Code to indicate source used to enroll the member.""" profilemembershipDetailsEnrollmentCode: StringInput """Resort/CRO where enrollment is done.""" profilemembershipDetailsEnrolledAt: StringInput """Source from where the enrollment is done.""" profilemembershipDetailsEnrollmentSource: StringInput """Flag to determine member actions to include in the fulfillment extract""" profilemembershipDetailsExcludeFromBatch: StringInput """Expiration date of the Card.""" profilemembershipDetailsExpirationDate: DateInput """Grace Period Indicator""" profilemembershipDetailsGracePeriodIndicator: StringInput """The date the record was marked as inactive""" profilemembershipDetailsInactiveDate: DateTimeInput """The date the record was created""" profilemembershipDetailsInsertDate: DateTimeInput """The unique name of application user""" profilemembershipDetailsInsertUser: StringInput """Primary Key for this table.""" profilemembershipDetailsMembershipid: FloatInput """JRN Update Date and Time""" profilemembershipDetailsJrnupdatedttm: DateTimeInput """Used by EIS Module.""" profilemembershipDetailsJoinedDate: DateInput """Last Date Earning Preference was changed.""" profilemembershipDetailsMbrprefChangedDate: DateInput """Used in the EIS Module.""" profilemembershipDetailsMemberIndicator: StringInput """Used in the EIS Module.""" profilemembershipDetailsMemberSubtype: StringInput """Membergueststatusid""" profilemembershipDetailsMembergueststatusid: StringInput """Membership Active YN""" profilemembershipDetailsInactiveflag: StringInput """Primary key of this table""" profilemembershipDetailsMembershipClass: StringInput """Primary Key for this table.""" profilemembershipDetailsMembershipId: FloatInput """Level of this Membership Type.""" profilemembershipDetailsMembershipLevel: StringInput """Membership Level Description""" profilemembershipDetailsMembershipLevelDesc: StringInput """Membership Card Number.""" profilemembershipDetailsMembershipCardNo: StringInput """User defined field used by external system. Not used by OCIS upgradedowngrade or renewal process.""" profilemembershipDetailsMembershipStatus: StringInput """Type of the Membership.""" profilemembershipDetailsMembershipType: StringInput """Description of membership program type.""" profilemembershipDetailsMembershipTypeDesc: StringInput """Membershipenrollid""" profilemembershipDetailsMembershipenrollid: StringInput """Level of this Membership Type.""" profilemembershipDetailsMembershiplevelid: StringInput """Type of the Membership.""" profilemembershipDetailsMembershiptypeid: StringInput """Reference to the name that owns this record.""" profilemembershipDetailsNameId: FloatInput """Name as appeared on the Membership Card.""" profilemembershipDetailsNameOnCard: StringInput """The display sequence of the membership cards held by this profile if there are multiple membership cards.""" profilemembershipDetailsOrderBy: FloatInput """Internal ID to uniquely identify the Organization""" profilemembershipDetailsOrganizationid: FloatInput """Membership ID that accrues Miles.""" profilemembershipDetailsPartnerMembershipId: FloatInput """Used in the EIS Module.""" profilemembershipDetailsPointflag: StringInput """Internal Primary Key ID to uniquely identify the row""" profilemembershipDetailsPkid: FloatInput """Primary Membership YN""" profilemembershipDetailsPrimaryMembershipYn: StringInput """Used in the EIS Module.""" profilemembershipDetailsPrimaryairlineflag: StringInput """Used in the EIS Module.""" profilemembershipDetailsProcessExpirationDate: DateInput """Reference to the name that owns this record.""" profilemembershipDetailsProfileid: FloatInput """Current membership ranking value for this profile possible values: 1-10.""" profilemembershipDetailsRankValue: FloatInput """RnA Insertdate""" profilemembershipDetailsRnaInsertdate: DateTimeInput """RnA Updatedate""" profilemembershipDetailsRnaUpdatedate: DateTimeInput """Stores key track information for a universal card that may be different than the membership number.""" profilemembershipDetailsTrackData: StringInput """The date the record was modified""" profilemembershipDetailsUpdateDate: DateTimeInput """The unique name of application user""" profilemembershipDetailsUpdateUser: StringInput """Activity Due Date""" profilenoteDetailsActionDueDate: DateInput """Activity Type""" profilenoteDetailsActionType: StringInput """ASP chain code.""" profilenoteDetailsChainCode: StringInput """Indicates if this note is confidential.""" profilenoteDetailsConfidentialYn: StringInput """The user that created the record""" profilenoteDetailsInsertUser: FloatInput """The date the record was created""" profilenoteDetailsInsertDate: DateTimeInput """DSI Internal Data Source ID to identify Opera Chain and instance""" profilenoteDetailsDsi: FloatInput """Deleted Flag""" profilenoteDetailsDeletedFlag: StringInput """Unique ID in External System.""" profilenoteDetailsExternalNoteId: StringInput """Global Note Y/N""" profilenoteDetailsGlobalNoteYn: StringInput """Can a global note be created for this note code or not.""" profilenoteDetailsGlobalYn: StringInput """Inactive date of the record. This indicates that record is no longer in use and can be purged in by purge routine.""" profilenoteDetailsInactiveDate: DateInput """Inactive Flag""" profilenoteDetailsInactiveFlag: StringInput """Deleted Flag""" profilenoteDetailsDeletedflag: StringInput """Inactive Flag""" profilenoteDetailsInactiveflag: StringInput """Location Id""" profilenoteDetailsLocationId: StringInput """Organization ID""" profilenoteDetailsOrganizationId: FloatInput """JRN Update Date and Time""" profilenoteDetailsJrnupdatedttm: DateTimeInput """Indicator for Laptop change.""" profilenoteDetailsLaptopChange: FloatInput """Internal ID to uniquely identify the Property""" profilenoteDetailsLocationid: StringInput """Parent Name_id refers Name table.""" profilenoteDetailsNameId: FloatInput """The type of Profile.""" profilenoteDetailsNameType: StringInput """Indicates the Type of Note.""" profilenoteDetailsNoteCode: StringInput """Description of Note Code""" profilenoteDetailsNoteCodeDescription: StringInput """Primary Key for the Table""" profilenoteDetailsNoteId: FloatInput """Indicates if this note should be shown to guest. Future use.""" profilenoteDetailsInternalYn: StringInput """Title of the Note""" profilenoteDetailsNoteTitle: StringInput """The actual Note.""" profilenoteDetailsNotes: StringInput """Internal ID to uniquely identify the Organization""" profilenoteDetailsOrganizationid: FloatInput """Internal Primary Key ID to uniquely identify the row""" profilenoteDetailsPkid: FloatInput """Parent Name_id refers Name table.""" profilenoteDetailsProfileId: FloatInput """Profile Note ID""" profilenoteDetailsProfileNoteId: FloatInput """Property""" profilenoteDetailsResort: StringInput """RnA Insertdate""" profilenoteDetailsRnaInsertdate: DateTimeInput """RnA Updatedate""" profilenoteDetailsRnaUpdatedate: DateTimeInput """The date the record was modified""" profilenoteDetailsUpdateDate: DateTimeInput """The user that modified the record""" profilenoteDetailsUpdateUser: FloatInput """The Chain code of the chain for which this record belongs to.""" profilerelationshipDetailsChainCode: StringInput """This column store the Name of the Company Profiles.""" profilerelationshipDetailsCompany: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" profilerelationshipDetailsDsi: FloatInput """Deleted Flag""" profilerelationshipDetailsDeletedFlag: StringInput """The reference to the name that owns this relationship.""" profilerelationshipDetailsOwnerProfileNo: FloatInput """Guest Name""" profilerelationshipDetailsGuestName: StringInput """The date the record was marked as inactive""" profilerelationshipDetailsInactiveDate: DateTimeInput """Inactive Flag""" profilerelationshipDetailsInactiveFlag: StringInput """The date the record was created""" profilerelationshipDetailsInsertDate: DateTimeInput """The user that created the record""" profilerelationshipDetailsInsertUser: FloatInput """The property that the record belongs to""" profilerelationshipDetailsLocationId: StringInput """Organization ID""" profilerelationshipDetailsOrganizationId: FloatInput """The type of relationship this name id has to the relationship_to_name_id.""" profilerelationshipDetailsRelationshipId: StringInput """JRN Update Date and Time""" profilerelationshipDetailsJrnupdatedttm: DateTimeInput """Changed by laptop Y or N""" profilerelationshipDetailsLaptopChange: FloatInput """The property that the record belongs to""" profilerelationshipDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" profilerelationshipDetailsOrganizationid: FloatInput """The reference to the name that owns this relationship.""" profilerelationshipDetailsOwnerProfileId: FloatInput """Internal Primary Key ID to uniquely identify the row""" profilerelationshipDetailsPkid: FloatInput """Indicates the Primary relationship where Multiple Relationships are attached to a profile.""" profilerelationshipDetailsPrimaryFlag: StringInput """The primary key for this table.""" profilerelationshipDetailsProfilerelationshipId: FloatInput """The property that the record belongs to""" profilerelationshipDetailsProperty: StringInput """The type of relationship this name id has to the relationship_to_name_id.""" profilerelationshipDetailsRelationshipTypeCode: StringInput """Description of the relationship.""" profilerelationshipDetailsRelationshipDesc: StringInput """The primary key for this table.""" profilerelationshipDetailsRelationshipCode: FloatInput """Used in S&C Module""" profilerelationshipDetailsRelationshipRole: StringInput """Relationship To""" profilerelationshipDetailsRelatedToProfileName: StringInput """The reference to the name that the "Name_id" is related to.""" profilerelationshipDetailsRelatedToProfileId: FloatInput """The property that the record belongs to""" profilerelationshipDetailsResort: StringInput """RnA Insertdate""" profilerelationshipDetailsRnaInsertdate: DateTimeInput """RnA Updatedate""" profilerelationshipDetailsRnaUpdatedate: DateTimeInput """The reference to the name that the "Name_id" is related to.""" profilerelationshipDetailsRelatedProfileNo: FloatInput """The date the record was modified""" profilerelationshipDetailsUpdateDate: DateTimeInput """The user that modified the record""" profilerelationshipDetailsUpdateUser: FloatInput """Central Xchange Date""" individualdailystatDetailsCXchangeDate: DateInput """DSI Internal Data Source ID to identify Opera Chain and instance""" individualdailystatDetailsDsi: FloatInput """Journal Update Dttm""" individualdailystatDetailsJrnUpdateDttm: DateTimeInput """The system-generated Internal numeric ID that corresponds to the Travel Agent for which the current record applies. Part of Primary Key.""" individualdailystatDetailsNameId: FloatInput """Internal ID to uniquely identify the Organization""" individualdailystatDetailsOrganizationid: FloatInput """The property that the record belongs to""" individualdailystatDetailsResort: StringInput """The Business Date for which the current record applies. Part of Primary Key.""" individualdailystatDetailsStayDate: DateInput """Central Keyword Type""" namekeywordsDetailsRepKeywordType: StringInput """The Chain code of the chain for which this record belongs to.""" namekeywordsDetailsChainCode: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" namekeywordsDetailsDsi: FloatInput """Deleted Flag""" namekeywordsDetailsDeletedFlag: StringInput """Interface update status""" namekeywordsDetailsInterfaceUpdatedYn: StringInput """JRN Update Date and Time""" namekeywordsDetailsJrnupdatedttm: DateTimeInput """The keyword to search on.""" namekeywordsDetailsKeyword: StringInput """The soundex of this keyword.""" namekeywordsDetailsKeywordSoundex: StringInput """Derived value based on the Type of the profile for the Search purpose.""" namekeywordsDetailsKeywordType: StringInput """Code to synchronize with Laptop.""" namekeywordsDetailsLaptopChange: FloatInput """The name these keywords are derived from.""" namekeywordsDetailsNameId: FloatInput """Internal ID to uniquely identify the Organization""" namekeywordsDetailsOrganizationid: FloatInput """Internal Primary Key ID to uniquely identify the row""" namekeywordsDetailsPkid: FloatInput """RnA Insertdate""" namekeywordsDetailsRnaInsertdate: DateTimeInput """RnA Updatedate""" namekeywordsDetailsRnaUpdatedate: DateTimeInput """Update allowed status.""" namekeywordsDetailsUpdateAllowedYn: StringInput """JRN Update Date and Time""" profilesubscriptionDetailsJrnupdatedttm: DateTimeInput } type Query { """Guest profile data including contact information VIP codes memberships and stay statistics with room and revenue details.""" profilesIndividuals(limit: Int offset: Int input: ProfilesIndividualsQueryArgumentsType!): [ProfilesIndividualsType] } type ProfilesIndividualsType { """Profile All Details""" profileAllInformationDetails: ProfilesIndividualsProfileAllInformationDetailsType """Profile Address Details""" profileAddressDetails: ProfilesIndividualsProfileAddressDetailsType """Profile Communication Details""" profileCommunicationDetails: ProfilesIndividualsProfileCommunicationDetailsType """Profile Preference Details""" profilePreferenceDetails: ProfilesIndividualsProfilePreferenceDetailsType """Profile Documents Details""" profileDocumentsDetails: ProfilesIndividualsProfileDocumentsDetailsType """Profile Membership Details""" profileMembershipDetails: ProfilesIndividualsProfileMembershipDetailsType """Profile Note Details""" profileNoteDetails: ProfilesIndividualsProfileNoteDetailsType """Profile Relationship Details""" profileRelationshipDetails: ProfilesIndividualsProfileRelationshipDetailsType """Individual Daily Statistics""" individualDailyStatisticsDetails: ProfilesIndividualsIndividualDailyStatisticsDetailsType """Profile Keywords""" profileKeywordsDetails: ProfilesIndividualsProfileKeywordsDetailsType """Profile Subscription Details""" profileSubscriptionDetails: ProfilesIndividualsProfileSubscriptionDetailsType profilesIndividualsRecordCount: Int } type ProfilesIndividualsProfileAllInformationDetailsType { """The primary key for this table.""" guestProfileID: Float """Account number.""" aRNumber: String """Account Receivable No. of this profile.""" aRNumberCentral: String """Indicates if a Credit Limit amount on Profile level will be required.""" aRCreditLimitYN: String """The ARC mailing flag (received from ARC Update program)""" aRCMailFlag: String """The ARC office type (received from ARC Update program)""" aRCOfficeType: String """The date this record was last updated by the ARC update program.""" aRCUpdateDate: Date """Billing contact person in company.""" accountBillingContact: String """Used in S&C Module.""" accountSource: String """Account Type of this Profile""" accountType: String """The description of this value.""" accountTypeDescription: String """The description of this value.""" accountsourceDesc: String """Mailing action codes.""" actionCode: String """Profile is active or not.""" activeYN: String """The first line of street address.""" address1: String """The second line of street address.""" address2: String """The third line of street address.""" address3: String """The fourth line of street address.""" address4: String """The primary key for this table.""" addressId: Float """Description for each language code.""" addressLangCodeDesc: String """Address Language Code""" addressLanguageCode: String """The type of address.""" addressType: String """Country Specific Requirement for Nigeria.""" alienRegistrationNo: String """All Resorts""" allResorts: String """Field which stores the multibyte envelop greeting used in S&C""" alternateEnvelopeGreeting: String """The Extended Byte Language of the Profile.""" alternateLanguage: String """Description for each language code.""" alternateLanguageDescription: String """Alternate Salutation""" alternateSalutation: String """Auto-Enroll Member YN""" autoEnrollMemberYN: String """Does profile have Availability Override Y/N""" availabilityOverride: String """The billing code for this name record.""" billingCode: String """Billing Instruction""" billingInstruction: String """For tour operators the type of billing profile for this name.""" billingProfileCode: String """Country of Birth""" birthCountry: String """Date of Birth of the Individual Profiles.""" birthDate: Date """Stores the encrypted birth date.""" birthDateStr: String """Place of Birth""" birthPlace: String """Any Message for the Restricted profile.""" blMsg: String """Used in S&C Module.""" businessSegment: String """The description of this value.""" businessSegmentDescription: String """The business title for this individual.""" businessTitle: String """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Profile Credit Limit""" cProfileCreditLimit: Float """This is a name_id (Profile number) of profiles that exist in a Central database in a typical CRS environment.""" cRSNameid: Float """This field tells whether this profile is a credit card profile or not.""" ccProfileYn: String """Central Account Type""" centralAccountType: String """Central Business Segment""" centralBusinessSegment: String """Central Business Segment Description""" centralBusinessSegmentDescription: String """Central Corporate ID Type""" centralCorporateIDType: String """The keyword to search on.""" centralDefaultKeyword: String """Central Guest Title Code""" centralGuestTitleCode: String """Central Inactive Reason""" centralInactiveReason: String """Central Inactive Reason Description""" centralInactiveReasonDescription: String """Central Mail Action Description""" centralMailActionDescription: String """Central Mailing Action Code""" centralMailingActionCode: String """Central Priority""" centralPriority: String """Central State Code""" centralStateCode: String """Central Territory""" centralTerritory: String """Central VIP Code""" centralVIPCode: String """Central VIP Description""" centralVIPDescription: String """Chain Code""" chainCode: String """The city for this address.""" city: String """The unique key of this name stores IATA# Company # etc.""" clientID: String """The user that has been assigned to this account for collections.""" collectionUserId: Float """Combined Name""" combinedName: String """This flag will be used in case Profiles are being controlled Centrally (CRS).""" commPayCentral: String """Not Used.""" comments: String """Commission Code for the Commission Percentage.""" commissionCode: String """Code for the commission for Travel Agent""" commissionCodes: String """Comm Curr ID""" commissionCurrencyId: String """Commission Code for the Commission Percentage.""" commissionid: String """Role in which this phone type belongs to.""" communicationRole1: String """Role in which this phone type belongs to.""" communicationRole2: String """Role in which this phone type belongs to.""" communicationRole3: String """The type of this phone number.""" communicationType1: String """The type of this phone number.""" communicationType2: String """The type of this phone number.""" communicationType3: String """The phone number for this record""" communicationValue1: String """The phone number for this record""" communicationValue2: String """The phone number for this record""" communicationValue3: String """Extended Byte Company Name""" companyAlternate: String """The company group or company group user ID in hierarchical format""" companyGroupId: String """Not used.""" companyNameId: Float """Competaion code .""" competition: String """The description of this value.""" competitionDesc: String """Used in S&C Module.""" contactYN: String """Group Contract number.""" contractNo: String """The date the group contract was received.""" contractRecvDate: Date """Corp Type Description""" corpTypeDesc: String """Specified whether Name_Code column has Company # or IATA #. For Company # the value will beCOMP and for IATA # the Value of this column will be IATA.""" corporateIDType: String """Country name.""" country: String """Country .""" countryCode: String """The user that created the record""" createdByUser: String """The date the record was created""" createdOnDate: DateTime """Credit rating.""" creditRating: String """Currency Code""" currencyCode: String """Currency Symbol like $ or EURO symbol""" currencySymbol: String """Double Opt In for AUTOENROLL_MEMBER_YN""" dOptInAutoenrollMemberFlg: String """Double Opt In for EMAIL_YN""" dOptInEmailFlg: String """Double Opt In for GUEST_PRIV_YN""" dOptInGuestPrivFlg: String """Double Opt In for MAIL_LIST""" dOptInMailListFlg: String """Double Opt In for MARKET_RESEARCH_YN""" dOptInMarketResearchFlg: String """Double Opt In for PHONE_YN""" dOptInPhoneFlg: String """Double Opt In for SMS_YN""" dOptInSmsFlg: String """Double Opt In for THIRD_PARTY_YN""" dOptInThirdPartyFlg: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Debtor Name""" debtorName: String """The number of digits after the decimal to allow for this currency.""" decimalPositions: Float """The keyword to search on.""" defaultKeyword: String """Deleted Flag""" deletedFlag: String """Used in S&C Module.""" department: String """Used in S&C Module.""" deptId: String """Used in QMS Module""" description: String """Direct Bill Batch Type""" directBillBatchType: String """Display Name""" displayName: String """Date on which the record is downloaded to laptop.""" downloadDate: Date """REsort name which has downloaded on the laptop.""" downloadResort: String """Owner of the record who downloaded on to laptop.""" downloadSrep: Float """The date when the E-Invoice liable flag was updated for this profile.""" eInvLiableLastUpdated: DateTime """Turkey Country requirement: Indicated if this profile e-Invoice liable. Folios generated for this profile will be directly sent to an external system.""" eInvoiceLiableYn: String """The phone number for this record""" email: String """Email YN""" emailYN: String """Field which stores the envelop greeting used in S&C""" envelopeGreeting: String """External Display Name""" externalDisplayName: String """The first name of an individual.""" externalFirstName: String """External ID used for V6 Interface stores the PMS guest number""" externalId: String """The last name of the individual profile.""" externalName: String """Not Used.""" externalReferenceRequ: String """During the booking process is the user required to enter the tour operator or TA record locator.""" externalReferenceRequired: String """Membership Card Number.""" fMembershipCardNumbers: String """Descripion of membership class""" fMembershipClassDesc: String """F Membership Classes""" fMembershipClasses: String """F Membership Codes""" fMembershipCodes: String """F Membership Descriptions""" fMembershipDescriptions: String """Primary Key for this table.""" fMembershipIds: String """Type of the Membership.""" fMembershipType: String """The ID of the external Database.""" fSubscriptionDb: String """The ID of the external Database.""" fSubscriptionYn: String """The phone number for this record""" faxNumber: String """The first name of an individual name.""" firstName: String """First Name Alternate""" firstNameAlternate: String """The keyword to search on.""" firstNameIncognito: String """The follow on for this individual (I.E: III etc).""" followOn: String """The name as communicated from the GDS. system. Filled on names that are created during the booking.""" gDSName: String """Not used.""" gDSTransactionNo: String """Indicates gender of Individual profile. Either (M)ale or F(emale)""" gender: String """Not used.""" geographicRegion: String """Not used.""" guestClassification: String """Country name.""" guestCountry: String """Currency code for the Commission payment.""" guestCurrencyCode: String """Description for each language code.""" guestLanguageCode: String """The last name of the individual Profile and Search name ofr the other Types of Profiles (Group Travel Agent & Source) are stored in this column.""" guestLastName: String """The middle name of this individual.""" guestMiddleName: String """Guest Name Suffix""" guestNameSuffix: String """Guest Privilege YN""" guestPrivilegeYN: String """The title of the individual.""" guestTitleCode: String """Has Requested Mail YN""" hasRequestedMailYN: String """Keep guest in history Y/N""" historyYN: String """Hold code for the Commission handling purposes.""" holdCode: String """Consortia for the IATA number.""" iataConsortia: String """The country where ID was issued""" idCountry: String """Issued date of Identification""" idDate: Date """This will store the value of LINKED_ATTACHMENTS.ATTACH_ID (Which maps to the physical table WORK_ORDERS.WO_NUMBER)""" idDocumentAttachId: Float """The place where ID was issued""" idPlace: String """Identification Type. Eg Passport Driving License etc""" idType: String """Country Specific Requirement for Nigeria.""" immigrationStatus: String """The date the record was marked as inactive""" inactiveDate: DateTime """Inactive Flag""" inactiveFlag: String """Reason why record was inactivated.""" inactiveReason: String """The description of this value.""" inactiveReasonDescription: String """Include travel agents/sources profile in 1099 reporting ?Y/N""" includeInTax1099Yn: String """Index Name""" indexName: String """The Industry this profile belongs to. Used only for the Non-Individual Profiles.""" industryCode: String """The description of this value.""" industryDesc: String """Used in S&C Module.""" influence: String """The description of this value.""" influenceDesc: String """Interest Code.""" interest: String """Indicates that this profile should be generating an internal bill instead of a regular bill during settlement.""" internalBillYn: String """Deleted Flag""" internalDeletedflag: String """Inactive Flag""" internalInactiveflag: String """Organization ID""" internalOrganizationId: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Primary language used for the profile.""" languageCode: String """Code to synchronize to Laptop values are 012.""" laptopChange: Float """Last Group""" lastGroup: String """Last Name Alternate""" lastNameAlternate: String """The keyword to search on.""" lastNameIncognito: String """Last Rate""" lastRate: Float """Last Rate Code""" lastRateCode: String """The room that is booked for this reservation leg.""" lastRoom: String """Last Room Property""" lastRoomProperty: String """Last Source""" lastSource: String """This contains the truncated component of end_date (i.e without timecomponent)""" lastStay: Date """Last property that updated this record.""" lastUpdatedResort: String """The legal company name for this company.""" legalCompany: String """Used in S&C Module.""" letterGreeting: String """The description of this value.""" mailActionDescription: String """This indicates whether the mailing list must be sent to the guest.""" mailList: String """The type of mail this user should be sent.""" mailType: String """Mailing action codes.""" mailingActionCode: String """Market Research YN""" marketResearchYN: String """Is this account a master account (Y/N)?""" masterAccountYn: String """Not used.""" nameTaxType: String """The type of Profile.""" nameType: String """The description of this value.""" nameTypeDescription: String """Not Used.""" name2: String """Not used.""" name3: String """Nationality""" nationality: String """Nationality of the individual.""" nationalityCode: String """The rate code for which this record applies.""" negotiatedRateCodes: String """This is a begin_date with no time component.""" nextStay: Date """The nickname of this individual.""" nickname: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Stores the original NAME_ID prior to a migration.""" origNameId: Float """Number of days a payment is due for the account.""" paymentDueDays: Float """The phone number for this record""" phone: String """The phone number for this record""" phoneWeb: String """Phone YN""" phoneYN: String """The postal code of this address.""" postalCode: String """City Extension mainly used for UK addresses.""" postalCodeExtension: String """Preferred Room Number""" preferredRoomNo: String """Not used.""" primaryAddressId: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Not Used.""" primaryNameId: Float """Primary Owner""" primaryOwner: String """Primary Owner Code""" primaryOwnerCode: String """Not used.""" primaryPhoneId: Float """Priority of the account""" priority: String """The description of this value.""" priorityDesc: String """Profile privacy flag determine if the profile is marked as private for a property.""" privacyFlagYN: String """Preference Code. Part of the Primary Key.""" productInterest: String """The profession of the Individual""" profession: String """Credit Limit amount for all AR accounts created in different properties for this profile.""" profileCreditLimit: Float """The primary key for this table.""" profileId: Float """The type of Profile.""" profileType: String """Resort for which Job is registered.""" propertyRegistered: String """Protected""" protected: String """Psuedo Profile Y/N""" psuedoProfileYn: String """The default rate structure for this name.""" rateStructure: String """The region for this name.""" region: String """The region for this name.""" regionid: String """Reporting Account Type Description""" repAccountTypeDescription: String """Reporting Accountsource""" repAccountsource: String """Reporting Accountsource Desc""" repAccountsourceDescription: String """Reporting Competition Code""" repCompetitionCode: String """Reporting Competition Desc""" repCompetitionDescription: String """Reporting Corp Type Desc""" repCorpTypeDescription: String """Reporting Industry Code""" repIndustryCode: String """Reporting Industry Desc""" repIndustryDescription: String """Reporting Influence""" repInfluence: String """Reporting Influence Desc""" repInfluenceDescription: String """Reporting Name Type""" repNameType: String """Reporting Name Type Description""" repNameTypeDescription: String """Rep Nationality Code""" repNationalityCode: String """Rep Nationality Description""" repNationalityDescription: String """Reporting Priority Desc""" repPriorityDescription: String """Reporting Rooms Potential""" repRoomsPotential: String """Reporting Rooms Potential Desc""" repRoomsPotentialDescription: String """Reporting Scope""" repScope: String """Reporting Scope City""" repScopeCity: String """Reporting Scope City Desc""" repScopeCityDescription: String """Reporting Scope Desc""" repScopeDescription: String """Reporting State Desc""" repStateDescription: String """Reporting Tax Type Desc""" repTaxTypeDescription: String """Reporting Territory Desc""" repTerritoryDescription: String """Reporting Title Name""" repTitleName: String """The primary membership # for this guest.""" repeatGuestId: String """User option to replace address in ORS with one from PMS.""" replaceAddress: String """This column store the Name of the Company Profiles.""" requestType: String """Normal Restricted and Cash Only informations are stored in this column.""" restricted: String """The description of this value.""" restrictedRule: String """Reservation Contact person.""" resvContact: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Potential no of rooms per year for a account""" roomsPotential: String """The description of this value.""" roomsPotentialDesc: String """Use this alert to text a notification.""" sMSYN: String """Salutation Greeting""" salutation: String """Scope of the account""" scope: String """Scope City""" scopeCity: String """The description of this value.""" scopeCityDesc: String """The description of this value.""" scopeDesc: String """The Uppercase value of Last or Company.""" searchName: String """Internal Indexed field for Searching by Extended Byte Name.""" searchNameAlternate: String """Uppercase value of First Name.""" sfirst: String """The soundex value for this company record. Used for performance reasons when finding a name based on the Sounds.""" soundExCompany: String """The soundex value for this individual record. Used for performance reasons when finding a name based on the sounds.""" soundExLast: String """Used in QMS Module""" srepCode: String """The state of this address.""" state: String """State Code""" stateCode: String """Description of the state.""" stateDescription: String """Summary Reference Currency for the Folio Generation.""" summRefCc: String """Summary Reference Currency for the Folio Generation.""" summRefCurrencyId: String """Used in Oracle Text Index.""" superSearchIndexText: String """Internal Indexed field for Searching by Extended Byte First Name.""" sxfirstName: String """Tax Category""" taxCategory: String """Not used.""" taxExemptStatus: String """The tax id of this name. Usually issued by a government agency. Used by 1099 printing.""" taxID1: String """Tax No""" taxID2: String """Tax Office Name""" taxOffice: String """Tax Type""" taxType: String """TERRITORY of a account""" territory: String """The description of this value.""" territoryDesc: String """Third Party YN""" thirdPartyYN: String """Title Alternate""" titleAlternate: String """The description of this value.""" titleName: String """Stores the suffix value of the selected title code. This will be used for Processing to External System.""" titleSuffix: Float """Sum of total number of stays on stay records for the time period.""" totalStay: Float """The type of tour operator. Only valid for tour operators/wholesalers.""" tourOperatorType: String """Code to Trace a record for all Triggered actions.""" traceCode: String """Description""" tracecodeDesc: String """What type of 1099 is issued to this name.""" typeOfTax1099: String """User defined character field.""" uDFC01: String """User defined character field.""" uDFC02: String """User defined character field.""" uDFC03: String """User defined character field.""" uDFC04: String """User defined character field.""" uDFC05: String """User defined character field.""" uDFC06: String """User defined character field.""" uDFC07: String """User defined character field.""" uDFC08: String """User defined character field.""" uDFC09: String """User defined character field.""" uDFC10: String """User defined character field.""" uDFC11: String """User defined character field.""" uDFC12: String """User defined character field.""" uDFC13: String """User defined character field.""" uDFC14: String """User defined character field.""" uDFC15: String """User defined character field.""" uDFC16: String """User defined character field.""" uDFC17: String """User defined character field.""" uDFC18: String """User defined character field.""" uDFC19: String """User defined character field.""" uDFC20: String """User defined character field.""" uDFC21: String """User defined character field.""" uDFC22: String """User defined character field.""" uDFC23: String """User defined character field.""" uDFC24: String """User defined character field.""" uDFC25: String """User defined character field.""" uDFC26: String """User defined character field.""" uDFC27: String """User defined character field.""" uDFC28: String """User defined character field.""" uDFC29: String """User defined character field.""" uDFC30: String """User defined character field.""" uDFC31: String """User defined character field.""" uDFC32: String """User defined character field.""" uDFC33: String """User defined character field.""" uDFC34: String """User defined character field.""" uDFC35: String """User defined character field.""" uDFC36: String """User defined character field.""" uDFC37: String """User defined character field.""" uDFC38: String """User defined character field.""" uDFC39: String """User defined character field.""" uDFC40: String """User defined date field.""" uDFD01: Date """User defined date field.""" uDFD02: Date """User defined date field.""" uDFD03: Date """User defined date field.""" uDFD04: Date """User defined date field.""" uDFD05: Date """User defined date field.""" uDFD06: Date """User defined date field.""" uDFD07: Date """User defined date field.""" uDFD08: Date """User defined date field.""" uDFD09: Date """User defined date field.""" uDFD10: Date """User defined date field.""" uDFD11: Date """User defined date field.""" uDFD12: Date """User defined date field.""" uDFD13: Date """User defined date field.""" uDFD14: Date """User defined date field.""" uDFD15: Date """User defined date field.""" uDFD16: Date """User defined date field.""" uDFD17: Date """User defined date field.""" uDFD18: Date """User defined date field.""" uDFD19: Date """User defined date field.""" uDFD20: Date """User defined number field.""" uDFN01: Float """User defined number field.""" uDFN02: Float """User defined number field.""" uDFN03: Float """User defined number field.""" uDFN04: Float """User defined number field.""" uDFN05: Float """User defined number field.""" uDFN06: Float """User defined number field.""" uDFN07: Float """User defined number field.""" uDFN08: Float """User defined number field.""" uDFN09: Float """User defined number field.""" uDFN10: Float """User defined number field.""" uDFN11: Float """User defined number field.""" uDFN12: Float """User defined number field.""" uDFN13: Float """User defined number field.""" uDFN14: Float """User defined number field.""" uDFN15: Float """User defined number field.""" uDFN16: Float """User defined number field.""" uDFN17: Float """User defined number field.""" uDFN18: Float """User defined number field.""" uDFN19: Float """User defined number field.""" uDFN20: Float """User defined number field.""" uDFN21: Float """User defined number field.""" uDFN22: Float """User defined number field.""" uDFN23: Float """User defined number field.""" uDFN24: Float """User defined number field.""" uDFN25: Float """User defined number field.""" uDFN26: Float """User defined number field.""" uDFN27: Float """User defined number field.""" uDFN28: Float """User defined number field.""" uDFN29: Float """User defined number field.""" uDFN30: Float """User defined number field.""" uDFN31: Float """User defined number field.""" uDFN32: Float """User defined number field.""" uDFN33: Float """User defined number field.""" uDFN34: Float """User defined number field.""" uDFN35: Float """User defined number field.""" uDFN36: Float """User defined number field.""" uDFN37: Float """User defined number field.""" uDFN38: Float """User defined number field.""" uDFN39: Float """User defined number field.""" uDFN40: Float """The date the record was modified""" updateDate: DateTime """The last date this record's fax # was updated.""" updateFaxDate: Date """The user that modified the record""" updateUser: String """Date on which the record is uploaded to laptop.""" uploadDate: Date """VIP Status of the Individual.""" vIPCode: String """The description of this value.""" vIPDescription: String """The Oracle Financials vendor id for this record. Used with the Oracle Financials A/P interface.""" vendorId: Float """The Oracle Financial vendor site id for this record. Used with the Oracle Financials A/P interface.""" vendorSiteId: Float """Not Used.""" vipAuthorization: String """Country Specific Requirement for Nigeria.""" visaValidityType: String """Xdisplay Name""" xdisplayName: String """Extended Byte middle name.""" xmiddleName: String } type ProfilesIndividualsProfileAddressDetailsType { """The first line of street address.""" address1: String """The second line of street address.""" address2: String """The third line of street address.""" address3: String """The fourth line of street address.""" address4: String """The primary key for this table.""" addressID: Float """Address Language""" addressLanguage: String """Description for each language code.""" addressLanguageDescription: String """The type of address.""" addressType: String """The description of this value.""" addressTypeDesc: String """The postal barcode for the address.""" barcode: String """Not used.""" beginDate: Date """Central State""" centralState: String """Central State Description""" centralStateDescription: String """The Chain code of the chain for which this record belongs to.""" chainCode: String """The city for this address.""" city: String """The Timestamp when this record was cleansed.""" cleansedDatetime: DateTime """The error message why this record was not cleansed.""" cleansedErrormsg: String """Specifies how the address elements match with the postal reference data.""" cleansedMatchstatus: String """Status of Address Cleansing. Null = Record is not cleansed. C = Cleansed. F = Failure.""" cleansedStatus: String """Validation Status as returned by the Address Cleansing System.""" cleansedValidationstatus: String """The unique key of this name stores IATA# Company # etc.""" clientID: String """Country .""" countryCode: String """Country name.""" countryDescription: String """The user that created the record""" createdByUser: Float """The date the record was created""" createdOnDate: DateTime """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Y/n""" deletedYN: String """Not used.""" endDate: Date """The first name of an individual name.""" firstName: String """Not used.""" foreignCountry: String """Not used.""" inCareOf: String """The date the record was marked as inactive""" inactiveDate: DateTime """Inactive Y/n""" inactiveYN: String """Organization ID""" internalOrganizationId: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Code to synchronize with Laptop. (not used)""" laptopChange: Float """Last property that updated this record.""" lastUpdatedResort: String """Name""" name: String """Internal ID to uniquely identify the Organization""" organizationID: Float """The postal code of this address.""" postalCode: String """City Extension mainly used for UK addresses.""" postalCodeExtension: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Profile having Multiple Addresses Need to have one Primary Address for each Type.""" primaryYN: String """The primary key for this table.""" profileAddressId: Float """The reference to the NAME record that owns this address.""" profileId: Float """The reference to the NAME record that owns this address.""" profileIdx: Float """Province.""" province: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """State""" state: String """The state of this address.""" stateCode: String """The date the record was modified""" updateDate: DateTime """The user that modified the record""" updateUser: Float } type ProfilesIndividualsProfileCommunicationDetailsType { """Not used.""" addressId: Float """Not used.""" beginDate: Date """The Chain code of the chain for which this record belongs to.""" chainCode: String """The primary key for this table.""" communicationID: Float """Role in which this phone type belongs to.""" communicationRole: String """The phone number for this record""" communicationValue: String """Country Code of the phone number.""" countryCode: String """Numeric phone dialing prefix code for the country.""" countryDialingCode: Float """Country Code of the phone number.""" countryId: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Phone_role to be used for default confirmation.""" defaultMethodYN: String """Deleted Flag""" deletedFlag: String """Order in which the phone numbers should be displayed.""" displaySequence: Float """Format type for email messages: HTML PLAIN text.""" emailFormat: String """Optional language for e-mail.""" emailLanguage: String """The date this record becomes invalid for use in the system. User enterable.""" endDate: Date """Telephone Extension.""" extension: String """The first name of an individual name.""" firstName: String """The date the record was marked as inactive""" inactiveDate: DateTime """Inactive Flag""" inactiveFlag: String """Index Phone""" indexPhone: String """The date the record was created""" insertDate: DateTime """The user that created the record""" insertUser: Float """Organization ID""" internalOrganizationId: Float """The reference to the name that owns this phone.""" internalProfileId: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Code to synchronize with Laptop""" laptopChange: Float """The last name of the individual Profile and Search name ofr the other Types of Profiles (Group Travel Agent & Source) are stored in this column.""" lastName: String """Marked as Y when the Phone Number/EMail Address is Opt In.""" mobileAudioKeyYn: String """Internal ID to uniquely identify the Organization""" organizationID: Float """The primary key for this table.""" phoneId: Float """The type of this phone number.""" phoneType: String """Description of Phone Types.""" phoneTypeDescription: String """The type of this phone number.""" phoneTypeId: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Indicates the primary telephone number in the case of multiple phone numbers on a profile.""" primaryYN: String """The reference to the name that owns this phone.""" profileID: Float """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Used for uploading the email to holidex if the value is Y.""" shareEmailYn: String """The date the record was modified""" updateDate: DateTime """The user that modified the record""" updateUser: Float """Indicates that the phone number has been validated using the Starwood API and is determined to be valid a value indicates that the phone number has not been validated.""" validYn: String } type ProfilesIndividualsProfilePreferenceDetailsType { """Can Delete Y/N""" canDeleteYn: String """Central Preference Code""" centralPreferenceCode: String """Central Preference Description""" centralPreferenceDescription: String """Central Preference Group""" centralPreferenceGroup: String """ASP chain code.""" chainCode: String """Not used.""" chargeYn: String """The user that created the record""" createdByUser: Float """The date the record was created""" createdOnDate: DateTime """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """The display sequence of the Preferences.""" displaySequence: Float """Unique ID in External System.""" externalPreferenceId: String """The date the record was marked as inactive""" inactiveDate: DateTime """Inactive Flag""" inactiveFlag: String """Organization ID""" internalOrganizationId: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Laptop Change Indicator""" laptopChange: Float """The property that the record belongs to""" locationID: String """Not Used.""" mpcode: String """Reference to the name that owns this record.""" nameId: Float """The property that the record belongs to""" noteProperty: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Preference Code. Part of the Primary Key.""" preferenceCode: String """Description of the Preference.""" preferenceDescription: String """Description of the Preference Type.""" preferenceGroup: String """Preference Code.""" preferenceId: String """Preference Type.""" preferenceTypeCode: String """Preference Type.""" preferenceTypeId: String """Preference Code.""" preferenceValue: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Reference to the name that owns this record.""" profileId: Float """Preference Code.""" profilePreferenceId: String """The property that the record belongs to""" property: String """Reporting Orderby""" repOrderby: Float """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """The date the record was modified""" updateDate: DateTime """The user that modified the record""" updateUser: Float } type ProfilesIndividualsProfileDocumentsDetailsType { """The Chain code of the chain for which this record belongs to.""" chainCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Unique ID for this table.""" documentId: Float """The place where the ID was issued.""" guestIdentificationIDIssuePlace: String """Store the ID value of linked_attachments.attach_id pointing to the physical table column that stores the scanned document.""" idDocumentAttachId: Float """The country where the ID was issued""" identificationIDCountry: String """Expiration date of the ID document.""" identificationIDExpirationDate: Date """Identification Issued date.""" identificationIDIssueDate: Date """Encrypted identification number.""" identificationIDNumber: String """Indicates if this record is the primary one for the ID type.""" identificationIDPrimaryYN: String """Identification type e.g: PASSPORT DRIVING LICENSE etc.""" identificationIDType: String """Date this record was inactivated.""" inactiveDate: DateTime """The date the record was created.""" insertDate: DateTime """The user that created the record.""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """The property this record belongs to can be "_GLOBAL".""" locationID: String """The profile ID reference who owns this document.""" nameId: Float """Display Sequence.""" orderBy: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """The property this record belongs to can be "_GLOBAL".""" property: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Internal indexed field to search for ID_NUMBER.""" sIdNumber: String """The date the record was modified.""" updateDate: DateTime """The user that modified the record.""" updateUser: Float } type ProfilesIndividualsProfileMembershipDetailsType { """Central Credit Limit""" cCreditLimit: Float """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Chain code.""" chainCode: String """Used by EIS Module.""" comments: String """Used in the EIS Module.""" creditLimit: Float """Used in the EIS Module.""" currentPoints: Float """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Encoded string on the device.""" deviceCode: String """Date when device was disabled.""" deviceDisableDate: Date """Points or miles earning preference.""" earningPreference: String """Code to indicate source used to enroll the member.""" enrollmentCode: String """Resort/CRO where enrollment is done.""" enrollmentProperty: String """Source from where the enrollment is done.""" enrollmentSource: String """Flag to determine member actions to include in the fulfillment extract""" excludeFromBatch: String """Expiration date of the Card.""" expirationDate: Date """Grace Period Indicator""" gracePeriodIndicator: String """The date the record was marked as inactive""" inactiveDate: DateTime """The date the record was created""" insertDate: DateTime """The unique name of application user""" insertUser: String """Primary Key for this table.""" internalMembershipid: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Used by EIS Module.""" joinedDate: Date """Last Date Earning Preference was changed.""" mbrprefChangedDate: Date """Used in the EIS Module.""" memberIndicator: String """Used in the EIS Module.""" memberSubtype: String """Membergueststatusid""" membergueststatusid: String """Membership Active YN""" membershipActiveYN: String """Primary key of this table""" membershipClass: String """Primary Key for this table.""" membershipID: Float """Level of this Membership Type.""" membershipLevel: String """Membership Level Description""" membershipLevelDescription: String """Membership Card Number.""" membershipNumber: String """User defined field used by external system. Not used by OCIS upgradedowngrade or renewal process.""" membershipStatus: String """Type of the Membership.""" membershipType: String """Description of membership program type.""" membershipTypeDescription: String """Membershipenrollid""" membershipenrollid: String """Level of this Membership Type.""" membershiplevelid: String """Type of the Membership.""" membershiptypeid: String """Reference to the name that owns this record.""" nameId: Float """Name as appeared on the Membership Card.""" nameOnCard: String """The display sequence of the membership cards held by this profile if there are multiple membership cards.""" orderBy: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Membership ID that accrues Miles.""" partnerMembershipId: Float """Used in the EIS Module.""" pointflag: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Primary Membership YN""" primaryMembershipYN: String """Used in the EIS Module.""" primaryairlineflag: String """Used in the EIS Module.""" processExpirationDate: Date """Reference to the name that owns this record.""" profileid: Float """Current membership ranking value for this profile possible values: 1-10.""" ranking: Float """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Stores key track information for a universal card that may be different than the membership number.""" trackData: String """The date the record was modified""" updateDate: DateTime """The unique name of application user""" updateUser: String } type ProfilesIndividualsProfileNoteDetailsType { """Activity Due Date""" activityDueDate: Date """Activity Type""" activityType: String """ASP chain code.""" chainCode: String """Indicates if this note is confidential.""" confidentialYN: String """The user that created the record""" createdByUser: Float """The date the record was created""" createdOnDate: DateTime """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Unique ID in External System.""" externalNoteId: String """Global Note Y/N""" globalNoteYn: String """Can a global note be created for this note code or not.""" globalYn: String """Inactive date of the record. This indicates that record is no longer in use and can be purged in by purge routine.""" inactiveDate: Date """Inactive Flag""" inactiveFlag: String """Deleted Flag""" internalDeletedflag: String """Inactive Flag""" internalInactiveflag: String """Location Id""" internalLocationId: String """Organization ID""" internalOrganizationId: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Indicator for Laptop change.""" laptopChange: Float """Internal ID to uniquely identify the Property""" locationID: String """Parent Name_id refers Name table.""" nameId: Float """The type of Profile.""" nameType: String """Indicates the Type of Note.""" noteCode: String """Description of Note Code""" noteCodeDescription: String """Primary Key for the Table""" noteId: Float """Indicates if this note should be shown to guest. Future use.""" noteInternalYN: String """Title of the Note""" noteTitle: String """The actual Note.""" notes: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Parent Name_id refers Name table.""" profileId: Float """Profile Note ID""" profileNoteId: Float """Property""" resort: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """The date the record was modified""" updateDate: DateTime """The user that modified the record""" updateUser: Float } type ProfilesIndividualsProfileRelationshipDetailsType { """The Chain code of the chain for which this record belongs to.""" chainCode: String """This column store the Name of the Company Profiles.""" company: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """The reference to the name that owns this relationship.""" fromProfileID: Float """Guest Name""" guestName: String """The date the record was marked as inactive""" inactiveDate: DateTime """Inactive Flag""" inactiveFlag: String """The date the record was created""" insertDate: DateTime """The user that created the record""" insertUser: Float """The property that the record belongs to""" internalLocationId: String """Organization ID""" internalOrganizationId: Float """The type of relationship this name id has to the relationship_to_name_id.""" internalRelationshipId: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Changed by laptop Y or N""" laptopChange: Float """The property that the record belongs to""" locationID: String """Internal ID to uniquely identify the Organization""" organizationID: Float """The reference to the name that owns this relationship.""" ownerProfileId: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Indicates the Primary relationship where Multiple Relationships are attached to a profile.""" primaryYN: String """The primary key for this table.""" profilerelationshipId: Float """The property that the record belongs to""" property: String """The type of relationship this name id has to the relationship_to_name_id.""" relationshipCode: String """Description of the relationship.""" relationshipDescription: String """The primary key for this table.""" relationshipID: Float """Used in S&C Module""" relationshipRole: String """Relationship To""" relationshipTo: String """The reference to the name that the "Name_id" is related to.""" relationshipToNameID: Float """The property that the record belongs to""" resort: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """The reference to the name that the "Name_id" is related to.""" toProfileID: Float """The date the record was modified""" updateDate: DateTime """The user that modified the record""" updateUser: Float } type ProfilesIndividualsIndividualDailyStatisticsDetailsType { """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Fb Revenue""" cFBRevenue: Float """Central Fb Revenue Tax""" cFBRevenueTax: Float """Central Grp Fb Revenue""" cGroupFBRevenue: Float """Central Grp Fb Revenue Tax""" cGroupFBRevenueTax: Float """Central Grp Other Revenue""" cGroupOtherRevenue: Float """Central Grp Other Revenue Tax""" cGroupOtherRevenueTax: Float """Central Grp Room Revenue""" cGroupRoomRevenue: Float """Central Grp Room Revenue Tax""" cGroupRoomRevenueTax: Float """Central Grp Total Revenue""" cGroupTotalRevenue: Float """Central Grp Total Revenue Tax""" cGroupTotalRevenueTax: Float """Central Other Revenue""" cOtherRevenue: Float """Central Other Revenue Tax""" cOtherRevenueTax: Float """Central Room Revenue""" cRoomRevenue: Float """Central Room Revenue Tax""" cRoomRevenueTax: Float """Central Total Fb Revenue Tax""" cTotalFBRevenueTax: Float """Central Total Other Revenue Tax""" cTotalOtherRevenueTax: Float """Central Total Revenue""" cTotalRevenue: Float """Central Total Revenue Tax""" cTotalRevenueTax: Float """Central Total Room Revenue Tax""" cTotalRoomRevenueTax: Float """Central Total Total Revenue Tax""" cTotalTotalRevenueTax: Float """Cancels""" cancels: Float """Central FB Revenue""" centralFBRevenue: Float """Central Other Revenue""" centralOtherRevenue: Float """Central Room Revenue""" centralRoomRevenue: Float """Central Total Revenue""" centralTotalRevenue: Float """Context Cd""" contextCd: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """FB Revenue""" fBRevenue: Float """FB Revenue""" fbRevenue: Float """F&B Revenue Tax.""" fbRevenueTax: Float """Group F&B Revenue.""" grpFBRevenue: Float """Group F&B Revenue Tax.""" grpFBRevenueTax: Float """Group Number of Cancellations.""" grpNumberCancels: Float """Group Number of Nights.""" grpNumberNights: Float """Group Number of No Shows.""" grpNumberNumberShows: Float """Group Number of Stays.""" grpNumberStays: Float """Group Other Revenue.""" grpOtherRevenue: Float """Group Other Revenue Tax.""" grpOtherRevenueTax: Float """Group Room Revenue.""" grpRoomRevenue: Float """Group Room Revenue Tax.""" grpRoomRevenueTax: Float """Group Total Revenue.""" grpTotalRevenue: Float """Group Total Revenue Tax.""" grpTotalRevenueTax: Float """JRN Update Date""" jRNUpdateDate: Date """Journal Filerba""" jrnFilerba: Float """Journal Fileseqno""" jrnFileseqno: Float """Journal Flag""" jrnFlag: String """Journal Scn""" jrnScn: Float """Journal Slicing Ts""" jrnSlicingTs: DateTime """Journal Update Dttm""" jrnUpdateDttm: DateTime """The property that the record belongs to""" locationID: String """The system-generated Internal numeric ID that corresponds to the Travel Agent for which the current record applies. Part of Primary Key.""" nameId: Float """Name Type""" nameType: String """Number Shows""" noShows: Float """Number Cancels""" numberCancels: Float """Number Nights""" numberNights: Float """Number Number Shows""" numberNoShows: Float """Number Stays""" numberStays: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Other Revenue""" otherRevenue: Float """Other Revenue Tax""" otherRevenueTax: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """The property that the record belongs to""" property: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Room Nights""" roomNights: Float """Room Revenue""" roomRevenue: Float """Room Revenue Tax""" roomRevenueTax: Float """The Business Date for which the current record applies. Part of Primary Key.""" stayDate: Date """Month of Summary. Stores Year and Month as YYYYMM.""" stayMonth: Float """Year of Summary.""" stayYear: Float """Stays""" stays: Float """Total FB Revenue Tax""" totalFbRevenueTax: Float """Total of All Revenue for the current record's key value that does not fall under Room/Food/Beverage category.""" totalOtherRevenue: Float """Total Other Revenue Tax""" totalOtherRevenueTax: Float """Total Revenue Amount for the current record's key value.""" totalRevenue: Float """Total Revenue Tax""" totalRevenueTax: Float """Total Room Revenue Amount for the current record's key value.""" totalRoomRevenue: Float """Total Room Amount (Inc Packages and Taxes) for the Stay.""" totalRoomRevenueTax: Float """Total Total Revenue""" totalTotalRevenue: Float """Total Total Revenue Tax""" totalTotalRevenueTax: Float } type ProfilesIndividualsProfileKeywordsDetailsType { """Central Keyword Type""" centralKeywordType: String """The Chain code of the chain for which this record belongs to.""" chainCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Interface update status""" interfaceUpdatedYn: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """The keyword to search on.""" keyword: String """The soundex of this keyword.""" keywordSoundex: String """Derived value based on the Type of the profile for the Search purpose.""" keywordType: String """Code to synchronize with Laptop.""" laptopChange: Float """The name these keywords are derived from.""" nameId: Float """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 allowed status.""" updateAllowedYn: String } type ProfilesIndividualsProfileSubscriptionDetailsType { """Allow Duplicate Y/N""" allowDuplicateYn: String """Chain Code""" chainCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Indicates if the profile should be distributed to the external database.""" distributeYn: String """Ext DB Name ID""" extDBNameID: String """External Database Name""" externalDatabaseName: String """External Profile ID""" externalProfileId: String """Indicates if profile distribution should be forced.""" forceYn: String """Inactive Date""" inactiveDate: Date """Inactive Flag""" inactiveFlag: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Organization ID""" internalOrganizationId: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Date of Last Activity on the AR Account in regards to: transfers between accounts payments applied (not unallocated) un-applied reversed and invoice compressions un-compressions on the account.""" lastActivityDate: Date """The data when profile was last distributed.""" lastDistributeDate: Date """Name ID""" nameId: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Indicates action is pending for queque. It can take values 124""" pendingAction: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Profile ID""" profileId: Float """Profilesubscription ID""" profilesubscriptionId: Float """Query Code""" queryCode: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Update Date""" updateDate: DateTime """Update User""" updateUser: Float }