# title : OPERA Cloud RnA ProfilesContacts GraphQL API, # description : GraphQL API to cater for The Contacts subject area contains Room Night and Revenue statistics broken down between booked and stays reservations and can be summarized by Property, Stay Date, Business Segment and Owner. # 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. # - contactDetailsChainCode input ProfilesContactsQueryArgumentsType { """Active Flag""" contactDetailsActiveYn: StringInput """The unique identifier of the CRS""" contactDetailsCrsNameid: FloatInput """Chain Code""" contactDetailsChainCode: StringInput! @mandatoryInput """Client ID""" contactDetailsNameCode: StringInput """Company""" contactDetailsCompany: StringInput """Linked internal ID for booker.""" contactDetailsCompanyGroupId: StringInput """Contact Profile ID""" contactDetailsNameId: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" contactDetailsDsi: FloatInput """Direct Bill Batch Type""" contactDetailsDirectBillBatchType: StringInput """History YN""" contactDetailsHistoryYn: StringInput """Inactive Date""" contactDetailsInactiveDate: DateTimeInput """Index Name""" contactDetailsIndexName: StringInput """JRN Update Date and Time""" contactDetailsJrnupdatedttm: DateTimeInput """Last Name""" contactDetailsLast: StringInput """Internal ID to uniquely identify the Organization""" contactDetailsOrganizationid: FloatInput """Resort for which Job is registered.""" contactDetailsResortRegistered: StringInput """The Uppercase value of Last or Company.""" contactDetailsSname: StringInput """Internal Indexed field for Searching by Extended Byte Name.""" contactDetailsSxname: StringInput """Uppercase value of First Name.""" contactDetailsSfirst: StringInput """Srep Code""" contactDetailsSrepCode: StringInput """Internal Indexed field for Searching by Extended Byte First Name.""" contactDetailsSxfirstName: StringInput """Update Date""" contactDetailsUpdateDate: DateTimeInput """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 """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 """DSI Internal Data Source ID to identify Opera Chain and instance""" profileownerDetailsDsi: FloatInput """JRN Update Date and Time""" profileownerDetailsJrnupdatedttm: DateTimeInput """Name ID""" profileownerDetailsNameId: FloatInput """Internal ID to uniquely identify the Organization""" profileownerDetailsOrganizationid: FloatInput """Property""" profileownerDetailsResort: StringInput """User ID""" profileownerDetailsUserId: FloatInput } type Query { """The Contacts subject area contains Room Night and Revenue statistics broken down between booked and stays reservations and can be summarized by Property Stay Date Business Segment and Owner.""" profilesContacts(limit: Int offset: Int input: ProfilesContactsQueryArgumentsType!): [ProfilesContactsType] } type ProfilesContactsType { """Contact Details""" contactDetails: ProfilesContactsContactDetailsType """Profile Address Details""" profileAddressDetails: ProfilesContactsProfileAddressDetailsType """Profile Communication Details""" profileCommunicationDetails: ProfilesContactsProfileCommunicationDetailsType """Profile Preference Details""" profilePreferenceDetails: ProfilesContactsProfilePreferenceDetailsType """Profile Membership Details""" profileMembershipDetails: ProfilesContactsProfileMembershipDetailsType """Profile Note Details""" profileNoteDetails: ProfilesContactsProfileNoteDetailsType """Profile Relationship Details""" profileRelationshipDetails: ProfilesContactsProfileRelationshipDetailsType """Profile Owner Details""" profileOwnerDetails: ProfilesContactsProfileOwnerDetailsType """Contact Daily Statistics""" contactDailyStatisticsDetails: ProfilesContactsContactDailyStatisticsDetailsType """Contact Monthly Statistics""" contactMonthlyStatisticsDetails: ProfilesContactsContactMonthlyStatisticsDetailsType """Contact Yearly Statistics""" contactYearlyStatisticsDetails: ProfilesContactsContactYearlyStatisticsDetailsType profilesContactsRecordCount: Int } type ProfilesContactsContactDetailsType { """Indicates if a Credit Limit amount on Profile level will be required.""" aRCreditLimitYN: String """AR Number""" aRNumber: 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 """Account Type""" accountType: String """Accountsource""" accountsource: String """Billing contact person in company.""" acctContact: String """Action Code""" actionCode: String """Active Flag""" activeFlag: String """Address Type""" addressType: String """Address1""" address1: String """Address2""" address2: String """Address3""" address3: String """Address4""" address4: String """Country Specific Requirement for Nigeria.""" alienRegistrationNo: String """All Properties""" allProperties: String """All Sales Reporting Codes""" allSalesRepCodes: String """Alternate First Name""" alternateFirstName: String """The Extended Byte Language of the Profile.""" alternateLanguage: String """Alternate Language Description""" alternateLanguageDescription: String """Alternate Name""" alternateName: String """Alternate Title""" alternateTitle: String """AR No Central""" arNumberCentral: String """Auto Pop Routing""" autoPopRouting: String """Autoenroll Member Y/N""" 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 """Birth Date""" birthDate: Date """Birth Date Str""" birthDateStr: String """Place of birth.""" birthPlace: String """Business Segment""" businessSegment: String """Business Segment Description""" businessSegmentDescription: String """Business Title""" businessTitle: String """The unique identifier of the CRS""" cRSNameid: Float """This field tells whether this profile is a credit card profile or not.""" ccProfileYn: String """Central Business Segment""" centralBusinessSegment: String """Central Business Segment Description""" centralBusinessSegmentDescription: String """Central Inactive Reason""" centralInactiveReason: String """Central Inactive Reason Description""" centralInactiveReasonDescription: String """Central Influence""" centralInfluence: String """Central Influence Description""" centralInfluenceDescription: String """Central Keyword""" centralKeyword: String """Central Mail Action Description""" centralMailActionDescription: String """Central Nationality""" centralNationality: String """Central Nationality Description""" centralNationalityDescription: String """Central Scope""" centralScope: String """Central Scope City""" centralScopeCity: String """Central Scope City Description""" centralScopeCityDescription: String """Central Scope Description""" centralScopeDescription: String """Central Territory""" centralTerritory: String """Central Territory Description""" centralTerritoryDescription: String """Central Title""" centralTitle: String """Central VIP Code""" centralVIPCode: String """Central VIP Code Description""" centralVIPCodeDescription: String """Chain Code""" chainCode: String """City""" city: String """City Ext""" cityExt: String """Client ID""" 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 """Commission Code""" commissionCode: String """Comm Curr ID""" commissionCurrencyId: String """Commissionid""" commissionid: String """Communication Role1""" communicationRole1: String """Communication Role2""" communicationRole2: String """Communication Role3""" communicationRole3: String """Communication Type1""" communicationType1: String """Communication Type2""" communicationType2: String """Communication Type3""" communicationType3: String """Communication Value1""" communicationValue1: String """Communication Value2""" communicationValue2: String """Communication Value3""" communicationValue3: String """Company""" company: String """Linked internal ID for booker.""" companyGroupId: String """Company Name ID""" companyNameId: Float """Competition Code""" competitionCode: String """Contact Email Primary""" contactEmailPrimary: String """Phone no.""" contactPhonePrimary: String """Contact Profile ID""" contactProfileID: Float """Contact YN""" contactYN: String """Contract Number (used for customers).""" contractNo: String """The date the group contract was received.""" contractRecvDate: Date """Country""" country: String """Country Code""" countryCode: String """Country Description""" countryDesc: String """Created by User""" createdByUser: String """Created on Date""" createdOnDate: DateTime """Credit Card Name""" creditCardName: String """Credit Card Type""" creditCardType: String """Credit Rating""" creditRating: String """Currency Code""" currencyCode: String """Currency Description""" currencyDescription: 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 """Deleted Flag""" deletedFlag: String """Department""" department: String """Dept ID""" deptId: String """Direct Bill Batch Type""" directBillBatchType: String """Display Name""" displayName: String """Download Date""" downloadDate: Date """Download Property""" downloadResort: String """Download Srep""" downloadSrep: Float """The date when the E-Invoice liable flag was updated for this profile.""" eInvLiableLastUpdated: DateTime """Indicates if the payee profile ID is E_INVOICE liable.""" eInvoiceLiableYn: String """Email Y/N""" emailYn: String """Envelope Greeting""" envelopeGreeting: String """Envelope Greeting Alternate""" envelopeGreetingAlternate: String """External Display Name""" externalDisplayName: String """External First Name""" externalFirstName: String """External ID""" externalId: String """External Name""" 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 """F Membership Card Numbers""" fMembershipCardNumbers: String """F Membership Class Description""" fMembershipClassDesc: String """F Membership Classes""" fMembershipClasses: String """F Membership Codes""" fMembershipCodes: String """F Membership Descriptions""" fMembershipDescriptions: String """F Membership Ids""" fMembershipIds: String """F Subscription Db""" fSubscriptionDb: String """F Subscription Y/N""" fSubscriptionYn: String """Fax Number""" faxNo: String """First Name""" firstName: String """First Name Incognito""" 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 """Gender""" gender: String """Not used.""" geographicRegion: String """Not used.""" guestClassification: String """Guest Priv Y/N""" guestPrivYn: String """History YN""" historyYN: String """Hold Code""" holdCode: 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.""" iataCompType: String """IATA Consortia""" iataConsortia: String """ID Country""" idCountry: String """ID Date""" idDate: Date """Store the ID value of linked_attachments.attach_id pointing to the physical table column that stores the scanned document.""" idDocumentAttachId: Float """ID Number""" idNumber: String """ID Place""" idPlace: String """ID Type""" idType: String """Country Specific Requirement for Nigeria.""" immigrationStatus: String """Inactive Date""" inactiveDate: DateTime """Inactive Flag""" inactiveFlag: String """Reason Code for inactive status from REASON table""" inactiveReason: String """Reason why record was inactivated.""" inactiveReasonDescription: String """Include travel agents/sources profile in 1099 reporting ?Y/N""" includeInTax1099Yn: String """Index Name""" indexName: String """Industry Code""" industryCode: String """Influence""" influence: String """Influence Description""" influenceDescription: String """Interest Code.""" interest: String """Internal bill that will be solely used for accounting purposes on barter agreements and interim billing amongst hotels which belong to the same owner.""" 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 """Keyword""" keyword: String """Language""" language: String """Language Description""" languageDescription: String """Laptop Change""" laptopChange: Float """Last Group""" lastGroup: String """Last Name""" lastName: String """Last Name Alternate""" lastNameAlternate: String """Last Name Incognito""" lastNameIncognito: String """Last Rate""" lastRate: Float """Not used.""" lastRoom: String """Last Room Property""" lastRoomResort: String """Last Source""" lastSource: String """Last Stay""" lastStay: Date """Last property that updated this record.""" lastUpdatedResort: String """Legal Company""" legalCompany: String """Letter Greeting""" letterGreeting: String """Mail Action Description""" mailActionDescription: String """Mail List YN""" mailListYN: String """The type of mail this user should be sent.""" mailType: String """Mail Y/N""" mailYn: String """Mailing Action Code""" mailingActionCode: String """Market Research Y/N""" marketResearchYn: String """Is this account a master account (Y/N)?""" masterAccountYn: String """Middle Name""" middleName: String """Name""" name: String """Not Used.""" nameComment: String """Name Tax Type""" nameTaxType: String """Name With Title""" nameWithTitle: String """Name2""" name2: String """Name3""" name3: String """Nationality Code""" nationalityCode: String """Nationality Description""" nationalityDescription: String """Negotiated Rate Codes""" negotiatedRateCodes: String """Next Stay""" 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 """Passport""" passport: String """Number of days a payment is due for the account.""" paymentDueDays: Float """Payment Methods Code""" paymentMethodsCode: String """Payment Methods Description""" paymentMethodsDesc: String """Phone Y/N""" phoneYn: 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""" priority: String """Profile privacy flag determine if the profile is marked as private for a property.""" privateYN: String """Product Interest""" productInterest: String """Profession of the guest""" profession: String """Profile Arrangement Codes""" profileArrCodes: String """Profile Arr Description""" profileArrangementDesc: String """Credit Limit amount for all AR accounts created in different properties for this profile.""" profileCreditLimit: Float """Profile ID""" profileId: Float """Profile Type""" profileType: String """Protected""" protected: String """Psuedo Profile Y/N""" psuedoProfileYn: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """The default rate structure for this name.""" rateStructure: String """Region""" region: String """Regionid""" regionid: String """Reporting Account Type""" repAccountType: 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 Iata Comp Type""" repIATACompType: String """Reporting Industry Code""" repIndustryCode: String """Reporting Industry Desc""" repIndustryDescription: String """Reporting Mail Action Codes""" repMailActionCodes: String """Reporting Name Type""" repNameType: String """Reporting Name Type Description""" repNameTypeDescription: String """Reporting Priority""" repPriority: String """Reporting Priority Desc""" repPriorityDescription: String """Reporting Rooms Potential""" repRoomsPotential: String """Reporting Rooms Potential Desc""" repRoomsPotentialDescription: String """Reporting State Code""" repStateCode: String """Reporting State Desc""" repStateDescription: String """Reporting Tax Type Desc""" repTaxTypeDescription: 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 """Resort for which Job is registered.""" resortRegistered: String """Restricted""" restricted: String """Restricted Rule""" restrictedRule: String """Reservation Contact person.""" resvContact: String """Rooms Potential""" roomsPotential: String """Sales Reporting""" salesRep: String """Sales Reporting Code""" salesRepCode: String """Salutation Greeting""" salutation: String """Salutation Alternate""" salutationAlternate: String """Scope""" scope: String """Scope City""" scopeCity: String """Scope City Description""" scopeCityDescription: String """Scope Description""" scopeDescription: 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 """Use this alert to text a notification.""" smsYn: 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 """Srep Code""" srepCode: String """State""" state: String """State Code""" stateCode: String """State Description of the Guest of Payee""" stateDesc: String """State Description""" stateDescription: String """Suffix""" suffix: String """Summ Ref Cc""" summRefCc: String """Summ Ref Curr ID""" summRefCurrencyId: String """Super Search Index Text""" superSearchIndexText: String """Internal Indexed field for Searching by Extended Byte First Name.""" sxfirstName: String """Tax Category""" taxCategory: String """Not used.""" taxExemptStatus: String """Tax ID 1""" taxID1: String """Tax ID 2""" taxID2: String """Tax Office Name""" taxOffice: String """Tax Type""" taxType: String """Tax Type Description""" taxTypeDescription: String """Territory""" territory: String """Territory Description""" territoryDescription: String """Third Party Y/N""" thirdPartyYn: String """Title""" title: String """Title Suffix""" titleSuffix: Float """Total Arrivals""" totalArrivals: Float """Total Arrivals Last Year""" totalArrivalsLastyear: Float """Total Cancelled Reservations""" totalCancelledReservations: Float """Total Cancelled Reservation Lastyear""" totalCancelledResvLastYear: Float """Total Cancelled Rooms""" totalCancelledRooms: Float """Total Cancelled Rooms Last Year""" totalCancelledRoomsLastyear: Float """Total Day Use Reservations""" totalDayUseReservations: Float """Total Day Use Reservation Lastyear""" totalDayUseResvLastYear: Float """Total Day Use Rooms""" totalDayUseRooms: Float """Total Day Use Rooms Last Year""" totalDayUseRoomsLastyear: Float """Total FB Revenue""" totalFbRevenue: Float """Total FB Revenue Lastyear""" totalFbRevenueLastYear: Float """Total Number Show Reservations""" totalNoShowReservations: Float """Total Number Show Rooms""" totalNoShowRooms: Float """Total Non Revenue""" totalNonRevenue: Float """Total Non Revenue Last Year""" totalNonRevenueLastyear: Float """Total No Show Reservation Lastyear""" totalNumberShowResvLastYear: Float """Total No Show Rooms Last Year""" totalNumberShowRoomsLastyear: Float """Total Other Revenue""" totalOtherRevenue: Float """Total Other Revenue Last Year""" totalOtherRevenueLastyear: Float """Total Reservation Nights""" totalReservationNights: Float """Total Reservation Nights Lastyear""" totalResvNightsLastYear: Float """Total Revenue""" totalRevenue: Float """Total Revenue Last Year""" totalRevenueLastyear: Float """Total Room Nights Last Year""" totalRoomNightsLastyear: Float """Total Room Revenue""" totalRoomRevenue: Float """Total Room Revenue Last Year""" totalRoomRevenueLastyear: Float """Sum of total number of stays on stay records for the time period.""" totalStays: Float """Total Stays Last Year""" totalStaysLastyear: Float """The type of tour operator. Only valid for tour operators/wholesalers.""" tourOperatorType: String """Trace Code""" traceCode: String """Trace Code Description""" traceCodeDescription: String """What type of 1099 is issued to this name.""" typeOfTax1099: String """UDFC01""" uDFC01: String """UDFC02""" uDFC02: String """UDFC03""" uDFC03: String """UDFC04""" uDFC04: String """UDFC05""" uDFC05: String """UDFC06""" uDFC06: String """UDFC07""" uDFC07: String """UDFC08""" uDFC08: String """UDFC09""" uDFC09: String """UDFC10""" uDFC10: String """UDFC11""" uDFC11: String """UDFC12""" uDFC12: String """UDFC13""" uDFC13: String """UDFC14""" uDFC14: String """UDFC15""" uDFC15: String """UDFC16""" uDFC16: String """UDFC17""" uDFC17: String """UDFC18""" uDFC18: String """UDFC19""" uDFC19: String """UDFC20""" uDFC20: String """UDFC21""" uDFC21: String """UDFC22""" uDFC22: String """UDFC23""" uDFC23: String """UDFC24""" uDFC24: String """UDFC25""" uDFC25: String """UDFC26""" uDFC26: String """UDFC27""" uDFC27: String """UDFC28""" uDFC28: String """UDFC29""" uDFC29: String """UDFC30""" uDFC30: String """UDFC31""" uDFC31: String """UDFC32""" uDFC32: String """UDFC33""" uDFC33: String """UDFC34""" uDFC34: String """UDFC35""" uDFC35: String """UDFC36""" uDFC36: String """UDFC37""" uDFC37: String """UDFC38""" uDFC38: String """UDFC39""" uDFC39: String """UDFC40""" uDFC40: String """UDFD01""" uDFD01: Date """UDFD02""" uDFD02: Date """UDFD03""" uDFD03: Date """UDFD04""" uDFD04: Date """UDFD05""" uDFD05: Date """UDFD06""" uDFD06: Date """UDFD07""" uDFD07: Date """UDFD08""" uDFD08: Date """UDFD09""" uDFD09: Date """UDFD10""" uDFD10: Date """UDFD11""" uDFD11: Date """UDFD12""" uDFD12: Date """UDFD13""" uDFD13: Date """UDFD14""" uDFD14: Date """UDFD15""" uDFD15: Date """UDFD16""" uDFD16: Date """UDFD17""" uDFD17: Date """UDFD18""" uDFD18: Date """UDFD19""" uDFD19: Date """UDFD20""" uDFD20: Date """UDFN01""" uDFN01: Float """UDFN02""" uDFN02: Float """UDFN03""" uDFN03: Float """UDFN04""" uDFN04: Float """UDFN05""" uDFN05: Float """UDFN06""" uDFN06: Float """UDFN07""" uDFN07: Float """UDFN08""" uDFN08: Float """UDFN09""" uDFN09: Float """UDFN10""" uDFN10: Float """UDFN11""" uDFN11: Float """UDFN12""" uDFN12: Float """UDFN13""" uDFN13: Float """UDFN14""" uDFN14: Float """UDFN15""" uDFN15: Float """UDFN16""" uDFN16: Float """UDFN17""" uDFN17: Float """UDFN18""" uDFN18: Float """UDFN19""" uDFN19: Float """UDFN20""" uDFN20: Float """UDFN21""" uDFN21: Float """UDFN22""" uDFN22: Float """UDFN23""" uDFN23: Float """UDFN24""" uDFN24: Float """UDFN25""" uDFN25: Float """UDFN26""" uDFN26: Float """UDFN27""" uDFN27: Float """UDFN28""" uDFN28: Float """UDFN29""" uDFN29: Float """UDFN30""" uDFN30: Float """UDFN31""" uDFN31: Float """UDFN32""" uDFN32: Float """UDFN33""" uDFN33: Float """UDFN34""" uDFN34: Float """UDFN35""" uDFN35: Float """UDFN36""" uDFN36: Float """UDFN37""" uDFN37: Float """UDFN38""" uDFN38: Float """UDFN39""" uDFN39: Float """UDFN40""" uDFN40: Float """Update Date""" updateDate: DateTime """The last date this record's fax # was updated.""" updateFaxDate: Date """Update User""" updateUser: String """Upload Date""" uploadDate: Date """VIP Code""" vIPCode: String """VIP Code Description""" vIPCodeDescription: String """Vendor ID""" 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 """Extended Byte Company Name""" xcompanyName: String """Extended Byte middle name.""" xmiddleName: String """Zipcode Code""" zipCode: String } type ProfilesContactsProfileAddressDetailsType { """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 ProfilesContactsProfileCommunicationDetailsType { """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 ProfilesContactsProfilePreferenceDetailsType { """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 ProfilesContactsProfileMembershipDetailsType { """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 ProfilesContactsProfileNoteDetailsType { """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 ProfilesContactsProfileRelationshipDetailsType { """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 ProfilesContactsProfileOwnerDetailsType { """Account Owner""" accountOwner: String """Account Owner Code""" accountOwnerCode: String """Account Owner Email""" accountOwnerEmail: String """Phone no.""" accountOwnerPhone: String """Account Owner Title""" accountOwnerTitle: String """Account Srep Code""" accountSrepCode: String """Central Account Owner Title""" centralAccountOwnerTitle: 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 """Inactive Date""" inactiveDate: DateTime """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 """Laptop Change""" laptopChange: Float """Location ID""" locationId: String """Name ID""" nameId: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Owner Profile ID""" ownerProfileId: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Primary YN""" primaryYN: String """Profile Owner ID""" profileOwnerId: Float """Indicates if the value set for the specific property.""" property: String """Relationship""" relationship: String """Relationshipid""" relationshipid: String """Property""" resort: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """To Type""" toType: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float """User ID""" userId: Float } type ProfilesContactsContactDailyStatisticsDetailsType { """Booked Average Daily Rate""" bookedAdr: Float """Booked Cancels""" bookedCancels: Float """Booked FB Revenue""" bookedFBRevenue: Float """Booked FB Revenue Tax""" bookedFBRevenueTax: Float """Booked Group Adr""" bookedGrpAverageDailyRate: Float """Booked Group Fb Revenue""" bookedGrpFBRevenue: Float """Booked Group Fb Revenue Tax""" bookedGrpFBRevenueTax: Float """Booked Group Number Cancels""" bookedGrpNumberCancels: Float """Booked Group Number Nights""" bookedGrpNumberNights: Float """Booked Group Number No Shows""" bookedGrpNumberNumberShows: Float """Booked Group Number Stays""" bookedGrpNumberStays: Float """Booked Group Other Revenue""" bookedGrpOtherRevenue: Float """Booked Group Other Revenue Tax""" bookedGrpOtherRevenueTax: Float """Booked Group Room Revenue""" bookedGrpRoomRevenue: Float """Booked Group Room Revenue Tax""" bookedGrpRoomRevenueTax: Float """Booked Group Total Revenue""" bookedGrpTotalRevenue: Float """Booked Group Total Revenue Tax""" bookedGrpTotalRevenueTax: Float """Booked Number Shows""" bookedNoShows: Float """Booked Number Cancels""" bookedNumberCancels: Float """Booked Number Nights""" bookedNumberNights: Float """Booked Number Number Shows""" bookedNumberNoShows: Float """Booked Number Stays""" bookedNumberStays: Float """Booked Other Revenue""" bookedOtherRevenue: Float """Booked Other Revenue Tax""" bookedOtherRevenueTax: Float """Booked Room Nights""" bookedRoomNights: Float """Booked Room Revenue""" bookedRoomRevenue: Float """Booked Room Revenue Tax""" bookedRoomRevenueTax: Float """Booked Stays""" bookedStays: Float """Booked Total Average Daily Rate""" bookedTotalAdr: Float """Booked Total FB Revenue""" bookedTotalFbRevenue: Float """Booked Total FB Revenue Tax""" bookedTotalFbRevenueTax: Float """Booked Total Other Revenue""" bookedTotalOtherRevenue: Float """Booked Total Other Revenue Tax""" bookedTotalOtherRevenueTax: Float """Booked Total Revenue""" bookedTotalRevenue: Float """Booked Total Revenue Tax""" bookedTotalRevenueTax: Float """Booked Total Room Revenue""" bookedTotalRoomRevenue: Float """Booked Total Room Revenue Tax""" bookedTotalRoomRevenueTax: Float """Booked Total Total Revenue""" bookedTotalTotalRevenue: Float """Booked Total Total Revenue Tax""" bookedTotalTotalRevenueTax: Float """Central Booked Grp Fb Revenue""" cBookedGroupFBRevenue: Float """Central Booked Grp Fb Revenue Tax""" cBookedGroupFBRevenueTax: Float """Central Booked Grp Other Revenue""" cBookedGroupOtherRevenue: Float """Central Booked Grp Other Revenue Tax""" cBookedGroupOtherRevenueTax: Float """Central Booked Grp Room Revenue""" cBookedGroupRoomRevenue: Float """Central Booked Grp Room Revenue Tax""" cBookedGroupRoomRevenueTax: Float """Central Booked Grp Total Revenue""" cBookedGroupTotalRevenue: Float """Central Booked Grp Total Revenue Tax""" cBookedGroupTotalRevenueTax: Float """Central Booked Total Fb Revenue""" cBookedTotalFBRevenue: Float """Central Booked Total Fb Revenue Tax""" cBookedTotalFBRevenueTax: Float """Central Booked Total Other Revenue""" cBookedTotalOtherRevenue: Float """Central Booked Total Other Revenue Tax""" cBookedTotalOtherRevenueTax: Float """Central Booked Total Room Revenue""" cBookedTotalRoomRevenue: Float """Central Booked Total Room Revenue Tax""" cBookedTotalRoomRevenueTax: Float """Central Booked Total Total Revenue""" cBookedTotalTotalRevenue: Float """Central Booked Total Total Revenue Tax""" cBookedTotalTotalRevenueTax: Float """Central Stayed Grp Fb Revenue""" cStayedGroupFBRevenue: Float """Central Stayed Grp Fb Revenue Tax""" cStayedGroupFBRevenueTax: Float """Central Stayed Grp Other Revenue""" cStayedGroupOtherRevenue: Float """Central Stayed Grp Other Revenue Tax""" cStayedGroupOtherRevenueTax: Float """Central Stayed Grp Room Revenue""" cStayedGroupRoomRevenue: Float """Central Stayed Grp Room Revenue Tax""" cStayedGroupRoomRevenueTax: Float """Central Stayed Grp Total Revenue""" cStayedGroupTotalRevenue: Float """Central Stayed Grp Total Revenue Tax""" cStayedGroupTotalRevenueTax: Float """Central Stayed Total Fb Revenue""" cStayedTotalFBRevenue: Float """Central Stayed Total Fb Revenue Tax""" cStayedTotalFBRevenueTax: Float """Central Stayed Total Other Revenue""" cStayedTotalOtherRevenue: Float """Central Stayed Total Other Revenue Tax""" cStayedTotalOtherRevenueTax: Float """Central Stayed Total Revenue""" cStayedTotalRevenue: Float """Central Stayed Total Revenue Tax""" cStayedTotalRevenueTax: Float """Central Stayed Total Room Revenue""" cStayedTotalRoomRevenue: Float """Central Stayed Total Room Revenue Tax""" cStayedTotalRoomRevenueTax: Float """Central Stayed Total Total Revenue""" cStayedTotalTotalRevenue: Float """Central Stayed Total Total Revenue Tax""" cStayedTotalTotalRevenueTax: Float """Central Total Fb Revenue Tax""" cTotalFBRevenueTax: Float """Central Total Other Revenue""" cTotalOtherRevenue: 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 """Cancels""" cancels: Float """Central Booked FB Revenue""" centralBookedFBRevenue: Float """Central Booked FB Revenue Tax""" centralBookedFBRevenueTax: Float """Central Booked Other Revenue""" centralBookedOtherRevenue: Float """Central Booked Other Revenue Tax""" centralBookedOtherRevenueTax: Float """Central Booked Room Revenue""" centralBookedRoomRevenue: Float """Central Booked Room Revenue Tax""" centralBookedRoomRevenueTax: Float """Central Booked Total Revenue""" centralBookedTotalRevenue: Float """Central Booked Total Revenue Tax""" centralBookedTotalRevenueTax: Float """Central FB Revenue""" centralFBRevenue: Float """Central FB Revenue Tax""" centralFBRevenueTax: Float """Central Other Revenue""" centralOtherRevenue: Float """Central Other Revenue Tax""" centralOtherRevenueTax: Float """Central Room Revenue""" centralRoomRevenue: Float """Central Room Revenue Tax""" centralRoomRevenueTax: Float """Central Stayed FB Revenue""" centralStayedFBRevenue: Float """Central Stayed FB Revenue Tax""" centralStayedFBRevenueTax: Float """Central Stayed Other Revenue""" centralStayedOtherRevenue: Float """Central Stayed Other Revenue Tax""" centralStayedOtherRevenueTax: Float """Central Stayed Room Revenue""" centralStayedRoomRevenue: Float """Central Stayed Room Revenue Tax""" centralStayedRoomRevenueTax: Float """Central Total Revenue""" centralTotalRevenue: Float """Central Total Revenue Tax""" centralTotalRevenueTax: 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 """F&B Revenue Tax.""" fBRevenueTax: Float """Group Adr""" grpAverageDailyRate: Float """Group F&B Revenue.""" grpFBRevenue: Float """Group F&B Revenue Tax.""" grpFBRevenueTax: Float """Group Number of Cancellations.""" grpNumberCancels: Float """Group Number of Nights.""" grpNumberNights: Float """Group Number of No Shows.""" grpNumberNumberShows: Float """Group Number of Stays.""" grpNumberStays: Float """Group Other Revenue.""" grpOtherRevenue: Float """Group Other Revenue Tax.""" grpOtherRevenueTax: Float """Group Room Revenue.""" grpRoomRevenue: Float """Group Room Revenue Tax.""" grpRoomRevenueTax: Float """Group Total Revenue.""" grpTotalRevenue: Float """Group Total Revenue Tax.""" grpTotalRevenueTax: Float """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 """Local Currency Code.""" localCurrency: String """Internal ID to uniquely identify the Property""" locationID: String """Name ID""" 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 """Code to uniquely identify the Property""" property: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Room Nights""" roomNights: Float """Room Revenue""" roomRevenue: Float """Room Revenue Tax""" roomRevenueTax: Float """Stay Date""" stayDate: Date """Month of Summary. Stores Year and Month as YYYYMM.""" stayMonth: Float """Year of Summary.""" stayYear: Float """Stayed Average Daily Rate""" stayedAdr: Float """Stayed Cancels""" stayedCancels: Float """Stayed FB Revenue""" stayedFBRevenue: Float """Stayed FB Revenue Tax""" stayedFBRevenueTax: Float """Stayed Group Adr""" stayedGrpAverageDailyRate: Float """Stayed Group Fb Revenue""" stayedGrpFBRevenue: Float """Stayed Group Fb Revenue Tax""" stayedGrpFBRevenueTax: Float """Stayed Group Number Cancels""" stayedGrpNumberCancels: Float """Stayed Group Number Nights""" stayedGrpNumberNights: Float """Stayed Group Number No Shows""" stayedGrpNumberNumberShows: Float """Stayed Group Number Stays""" stayedGrpNumberStays: Float """Stayed Group Other Revenue""" stayedGrpOtherRevenue: Float """Stayed Group Other Revenue Tax""" stayedGrpOtherRevenueTax: Float """Stayed Group Room Revenue""" stayedGrpRoomRevenue: Float """Stayed Group Room Revenue Tax""" stayedGrpRoomRevenueTax: Float """Stayed Group Total Revenue""" stayedGrpTotalRevenue: Float """Stayed Group Total Revenue Tax""" stayedGrpTotalRevenueTax: Float """Stayed Number Shows""" stayedNoShows: Float """Stayed Number Cancels""" stayedNumberCancels: Float """Stayed Number Nights""" stayedNumberNights: Float """Stayed Number Number Shows""" stayedNumberNoShows: Float """Stayed Number Stays""" stayedNumberStays: Float """Stayed Other Revenue""" stayedOtherRevenue: Float """Stayed Other Revenue Tax""" stayedOtherRevenueTax: Float """Stayed Room Nights""" stayedRoomNights: Float """Stayed Room Revenue""" stayedRoomRevenue: Float """Stayed Room Revenue Tax""" stayedRoomRevenueTax: Float """Stayed Stays""" stayedStays: Float """Stayed Total Average Daily Rate""" stayedTotalAdr: Float """Stayed Total FB Revenue""" stayedTotalFbRevenue: Float """Stayed Total FB Revenue Tax""" stayedTotalFbRevenueTax: Float """Stayed Total Other Revenue""" stayedTotalOtherRevenue: Float """Stayed Total Other Revenue Tax""" stayedTotalOtherRevenueTax: Float """Stayed Total Revenue""" stayedTotalRevenue: Float """Stayed Total Revenue Tax""" stayedTotalRevenueTax: Float """Stayed Total Room Revenue""" stayedTotalRoomRevenue: Float """Stayed Total Room Revenue Tax""" stayedTotalRoomRevenueTax: Float """Stayed Total Total Revenue""" stayedTotalTotalRevenue: Float """Stayed Total Total Revenue Tax""" stayedTotalTotalRevenueTax: Float """Stays""" stays: Float """Total Average Daily Rate""" totalAdr: Float """Total FB Revenue""" totalFbRevenue: Float """Total FB Revenue Tax""" totalFbRevenueTax: Float """Total Number Nights""" totalNumberNights: Float """Total Other Revenue""" totalOtherRevenue: Float """Total Other Revenue Tax""" totalOtherRevenueTax: Float """Total Revenue""" totalRevenue: Float """Total Revenue Tax""" totalRevenueTax: Float """Total Room Revenue""" totalRoomRevenue: Float """Total Room Amount (Inc Packages and Taxes) for the Stay.""" totalRoomRevenueTax: Float """Total Total Revenue""" totalTotalRevenue: Float """Total Total Revenue Tax""" totalTotalRevenueTax: Float } type ProfilesContactsContactMonthlyStatisticsDetailsType { """Average Daily Rate""" adr: Float """Booked FB Revenue""" bookedFBRevenue: Float """Booked Room Revenue""" bookedRoomRevenue: Float """Booked Room Revenue Tax""" bookedRoomRevenueTax: Float """Booked Stays""" bookedStays: Float """Central Cc Fb Revenue""" cCcFBRevenue: Float """Central Cc Fb Revenue Tax""" cCcFBRevenueTax: Float """Central Cc Grp Fb Revenue""" cCcGroupFBRevenue: Float """Central Cc Grp Fb Revenue Tax""" cCcGroupFBRevenueTax: Float """Central Cc Grp Misc Revenue""" cCcGroupMiscellaneousRevenue: Float """Central Cc Grp Misc Revenue Tax""" cCcGroupMiscellaneousRevenueTax: Float """Central Cc Grp Other Revenue""" cCcGroupOtherRevenue: Float """Central Cc Grp Other Revenue Tax""" cCcGroupOtherRevenueTax: Float """Central Cc Grp Room Revenue""" cCcGroupRoomRevenue: Float """Central Cc Grp Room Revenue Tax""" cCcGroupRoomRevenueTax: Float """Central Cc Grp Total Revenue""" cCcGroupTotalRevenue: Float """Central Cc Grp Total Revenue Tax""" cCcGroupTotalRevenueTax: Float """Central Cc Misc Revenue""" cCcMiscellaneousRevenue: Float """Central Cc Misc Revenue Tax""" cCcMiscellaneousRevenueTax: Float """Central Cc Other Revenue""" cCcOtherRevenue: Float """Central Cc Other Revenue Tax""" cCcOtherRevenueTax: Float """Central Cc Room Revenue""" cCcRoomRevenue: Float """Central Cc Room Revenue Tax""" cCcRoomRevenueTax: Float """Central Cc Total Revenue""" cCcTotalRevenue: Float """Central Cc Total Revenue Tax""" cCcTotalRevenueTax: Float """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Grp Fb Revenue""" cGroupFBRevenue: Float """Central Grp Fb Revenue Tax""" cGroupFBRevenueTax: Float """Central Grp Other Revenue""" cGroupOtherRevenue: Float """Central Grp Other Revenue Tax""" cGroupOtherRevenueTax: Float """Central Grp Room Revenue""" cGroupRoomRevenue: Float """Central Grp Room Revenue Tax""" cGroupRoomRevenueTax: Float """Central Grp Total Revenue""" cGroupTotalRevenue: Float """Central Grp Total Revenue Tax""" cGroupTotalRevenueTax: Float """Central Total Fb Revenue""" cTotalFBRevenue: Float """Central Total Fb Revenue Tax""" cTotalFBRevenueTax: Float """Central Total Other Revenue""" cTotalOtherRevenue: Float """Central Total Other Revenue Tax""" cTotalOtherRevenueTax: Float """Central Total Room Revenue""" cTotalRoomRevenue: Float """Central Total Room Revenue Tax""" cTotalRoomRevenueTax: Float """Central Total Total Revenue""" cTotalTotalRevenue: Float """Central Total Total Revenue Tax""" cTotalTotalRevenueTax: Float """Central Currency F&B Revenue.""" ccFbRevenue: Float """Central Currency F&B Revenue Tax.""" ccFbRevenueTax: Float """Central Currency Group F&B Revenue.""" ccGrpFBRevenue: Float """Central Currency Group F&B Revenue Tax.""" ccGrpFBRevenueTax: Float """Central Currency Group Misc. Revenue Tax.""" ccGrpMiscellaneousRevenue: Float """Central Currency Group Misc. Revenue Tax.""" ccGrpMiscellaneousRevenueTax: Float """Central Currency Group Other Revenue.""" ccGrpOtherRevenue: Float """Central Currency Group Other Revenue Tax.""" ccGrpOtherRevenueTax: Float """Central Currency Group Room Revenue.""" ccGrpRoomRevenue: Float """Central Currency Group Room Revenue Tax.""" ccGrpRoomRevenueTax: Float """Central Currency Group Total Revenue.""" ccGrpTotalRevenue: Float """Central Currency Group Total Revenue Tax.""" ccGrpTotalRevenueTax: Float """Central Currency Miscelleanous Revenue.""" ccMiscRevenue: Float """Central Currency Misc. Revenue Tax.""" ccMiscRevenueTax: Float """Central Currency Other Revenue.""" ccOtherRevenue: Float """Central Currency Other Revenue Tax.""" ccOtherRevenueTax: Float """Central Currency Room Revenue.""" ccRoomRevenue: Float """Central Currency Room Revenue Tax.""" ccRoomRevenueTax: Float """Central Currency Total Revenue.""" ccTotalRevenue: Float """Central Currency Total Revenue Tax.""" ccTotalRevenueTax: Float """Central Booked FB Revenue""" centralBookedFBRevenue: Float """Central Booked FB Revenue Tax""" centralBookedFBRevenueTax: Float """Central Booked Other Revenue Tax""" centralBookedOtherRevenueTax: Float """Central Currency Code""" centralCurrencyCode: String """Central Other Revenue""" centralOtherRevenue: Float """Central Stayed Room Revenue""" centralStayedRoomRevenue: Float """Central Stayed Room Revenue Tax""" centralStayedRoomRevenueTax: Float """Central Stayed Total Revenue""" centralStayedTotalRevenue: Float """Central Total Revenue Tax""" centralTotalRevenueTax: Float """Context Cd""" contextCd: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Group Adr""" grpAverageDailyRate: Float """Group F&B Revenue.""" grpFBRevenue: Float """Group F&B Revenue Tax.""" grpFBRevenueTax: Float """Group Number of Cancellations.""" grpNumberCancels: Float """Group Number of Nights.""" grpNumberNights: Float """Group Number of No Shows.""" grpNumberNumberShows: Float """Group Number of Stays.""" grpNumberStays: Float """Group Other Revenue.""" grpOtherRevenue: Float """Group Other Revenue Tax.""" grpOtherRevenueTax: Float """Group Room Revenue.""" grpRoomRevenue: Float """Group Room Revenue Tax.""" grpRoomRevenueTax: Float """Group Total Revenue.""" grpTotalRevenue: Float """Group Total Revenue Tax.""" grpTotalRevenueTax: Float """Insert Date""" insertDate: DateTime """Insert User""" insertUser: 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 """Local Currency Code.""" localCurrency: String """Internal ID to uniquely identify the Property""" locationID: String """Name ID""" nameId: Float """Name Type""" nameType: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Other Revenue""" otherRevenue: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Code to uniquely identify the Property""" property: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Room Nights""" roomNights: Float """Month of Summary. Stores Year and Month as YYYYMM.""" stayMonth: Float """Year of Summary.""" stayYear: Float """Used when name_type="CONTACT" to determine if stored information is booked or stayed statistics. Possible values [S]TAYED [B]OOKED [A]=ALL (STAYED and BOOKED). NULL will be considered [S]TAYED.""" stayedBooked: String """Stayed Cancels""" stayedCancels: Float """F&B Revenue Tax.""" stayedFBRevenueTax: Float """Stayed Number Shows""" stayedNoShows: Float """Stayed Other Revenue Tax""" stayedOtherRevenueTax: Float """Stayed Total Revenue""" stayedTotalRevenue: Float """Total Average Daily Rate""" totalAdr: Float """Total FB Revenue""" totalFbRevenue: Float """Total FB Revenue Tax""" totalFbRevenueTax: Float """Total Number Cancels""" totalNumberCancels: Float """Total Number Nights""" totalNumberNights: Float """Total Number Number Shows""" totalNumberNoShows: Float """Total Number Stays""" totalNumberStays: Float """Total Other Revenue""" totalOtherRevenue: Float """Total Other Revenue Tax""" totalOtherRevenueTax: Float """Total Revenue Tax""" totalRevenueTax: Float """Total Room Revenue""" totalRoomRevenue: Float """Total Room Amount (Inc Packages and Taxes) for the Stay.""" totalRoomRevenueTax: Float """Total Total Revenue""" totalTotalRevenue: Float """Total Total Revenue Tax""" totalTotalRevenueTax: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ProfilesContactsContactYearlyStatisticsDetailsType { """Average Daily Rate""" adr: Float """Booked Cancels""" bookedCancels: Float """F&B Revenue Tax.""" bookedFBRevenueTax: Float """Booked Number Shows""" bookedNoShows: Float """Booked Other Revenue Tax""" bookedOtherRevenueTax: Float """Central Cc Fb Revenue""" cCcFBRevenue: Float """Central Cc Fb Revenue Tax""" cCcFBRevenueTax: Float """Central Cc Grp Fb Revenue""" cCcGroupFBRevenue: Float """Central Cc Grp Fb Revenue Tax""" cCcGroupFBRevenueTax: Float """Central Cc Grp Misc Revenue""" cCcGroupMiscellaneousRevenue: Float """Central Cc Grp Misc Revenue Tax""" cCcGroupMiscellaneousRevenueTax: Float """Central Cc Grp Other Revenue""" cCcGroupOtherRevenue: Float """Central Cc Grp Other Revenue Tax""" cCcGroupOtherRevenueTax: Float """Central Cc Grp Room Revenue""" cCcGroupRoomRevenue: Float """Central Cc Grp Room Revenue Tax""" cCcGroupRoomRevenueTax: Float """Central Cc Grp Total Revenue""" cCcGroupTotalRevenue: Float """Central Cc Grp Total Revenue Tax""" cCcGroupTotalRevenueTax: Float """Central Cc Misc Revenue""" cCcMiscellaneousRevenue: Float """Central Cc Misc Revenue Tax""" cCcMiscellaneousRevenueTax: Float """Central Cc Other Revenue""" cCcOtherRevenue: Float """Central Cc Other Revenue Tax""" cCcOtherRevenueTax: Float """Central Cc Room Revenue""" cCcRoomRevenue: Float """Central Cc Room Revenue Tax""" cCcRoomRevenueTax: Float """Central Cc Total Revenue""" cCcTotalRevenue: Float """Central Cc Total Revenue Tax""" cCcTotalRevenueTax: Float """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Grp Fb Revenue""" cGroupFBRevenue: Float """Central Grp Fb Revenue Tax""" cGroupFBRevenueTax: Float """Central Grp Other Revenue""" cGroupOtherRevenue: Float """Central Grp Other Revenue Tax""" cGroupOtherRevenueTax: Float """Central Grp Room Revenue""" cGroupRoomRevenue: Float """Central Grp Room Revenue Tax""" cGroupRoomRevenueTax: Float """Central Grp Total Revenue""" cGroupTotalRevenue: Float """Central Grp Total Revenue Tax""" cGroupTotalRevenueTax: Float """Central Total Fb Revenue""" cTotalFBRevenue: Float """Central Total Fb Revenue Tax""" cTotalFBRevenueTax: Float """Central Total Other Revenue""" cTotalOtherRevenue: Float """Central Total Other Revenue Tax""" cTotalOtherRevenueTax: Float """Central Total Room Revenue""" cTotalRoomRevenue: Float """Central Total Room Revenue Tax""" cTotalRoomRevenueTax: Float """Central Total Total Revenue""" cTotalTotalRevenue: Float """Central Total Total Revenue Tax""" cTotalTotalRevenueTax: Float """Central Currency F&B Revenue.""" ccFbRevenue: Float """Central Currency F&B Revenue Tax.""" ccFbRevenueTax: Float """Central Currency Group F&B Revenue.""" ccGrpFBRevenue: Float """Central Currency Group F&B Revenue Tax.""" ccGrpFBRevenueTax: Float """Central Currency Group Misc. Revenue Tax.""" ccGrpMiscellaneousRevenue: Float """Central Currency Group Misc. Revenue Tax.""" ccGrpMiscellaneousRevenueTax: Float """Central Currency Group Other Revenue.""" ccGrpOtherRevenue: Float """Central Currency Group Other Revenue Tax.""" ccGrpOtherRevenueTax: Float """Central Currency Group Room Revenue.""" ccGrpRoomRevenue: Float """Central Currency Group Room Revenue Tax.""" ccGrpRoomRevenueTax: Float """Central Currency Group Total Revenue.""" ccGrpTotalRevenue: Float """Central Currency Group Total Revenue Tax.""" ccGrpTotalRevenueTax: Float """Central Currency Miscelleanous Revenue.""" ccMiscRevenue: Float """Central Currency Misc. Revenue Tax.""" ccMiscRevenueTax: Float """Central Currency Other Revenue.""" ccOtherRevenue: Float """Central Currency Other Revenue Tax.""" ccOtherRevenueTax: Float """Central Currency Room Revenue.""" ccRoomRevenue: Float """Central Currency Room Revenue Tax.""" ccRoomRevenueTax: Float """Central Currency Total Revenue.""" ccTotalRevenue: Float """Central Currency Total Revenue Tax.""" ccTotalRevenueTax: Float """Used when name_type="CONTACT" to determine if stored information is booked or stayed statistics. Possible values [S]TAYED [B]OOKED [A]=ALL (STAYED and BOOKED). NULL will be considered [S]TAYED.""" centralBookedRoomRevenueTax: String """Central Booked Total Revenue Tax""" centralBookedTotalRevenueTax: Float """Central Currency Code""" centralCurrencyCode: String """Central FB Revenue""" centralFBRevenue: Float """Central FB Revenue Tax""" centralFBRevenueTax: Float """Central Other Revenue""" centralOtherRevenue: Float """Central Room Revenue""" centralRoomRevenue: Float """Central Room Revenue Tax""" centralRoomRevenueTax: Float """Central Stayed Other Revenue Tax""" centralStayedOtherRevenueTax: Float """Central Stayed Total Revenue""" centralStayedTotalRevenue: 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 """Group Adr""" grpAverageDailyRate: Float """Group F&B Revenue.""" grpFBRevenue: Float """Group F&B Revenue Tax.""" grpFBRevenueTax: Float """Group Number of Cancellations.""" grpNumberCancels: Float """Group Number of Nights.""" grpNumberNights: Float """Group Number of No Shows.""" grpNumberNumberShows: Float """Group Number of Stays.""" grpNumberStays: Float """Group Other Revenue.""" grpOtherRevenue: Float """Group Other Revenue Tax.""" grpOtherRevenueTax: Float """Group Room Revenue.""" grpRoomRevenue: Float """Group Room Revenue Tax.""" grpRoomRevenueTax: Float """Group Total Revenue.""" grpTotalRevenue: Float """Group Total Revenue Tax.""" grpTotalRevenueTax: Float """Insert Date""" insertDate: DateTime """Insert User""" insertUser: 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 """Local Currency Code.""" localCurrency: String """Internal ID to uniquely identify the Property""" locationID: String """Name ID""" nameId: Float """Name Type""" nameType: 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 Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Room Revenue""" roomRevenue: Float """Room Revenue Tax""" roomRevenueTax: Float """Year of Summary.""" stayYear: Float """Stayed Other Revenue""" stayedOtherRevenue: Float """Stayed Room Nights""" stayedRoomNights: Float """Stayed Total Revenue""" stayedTotalRevenue: Float """Stayed Total Revenue Tax""" stayedTotalRevenueTax: Float """Stays""" stays: Float """Total Average Daily Rate""" totalAdr: Float """Total FB Revenue""" totalFbRevenue: Float """Total FB Revenue Tax""" totalFbRevenueTax: Float """Total Number Cancels""" totalNumberCancels: Float """Total Number Nights""" totalNumberNights: Float """Total Number Number Shows""" totalNumberNoShows: Float """Total Number Stays""" totalNumberStays: Float """Total Other Revenue""" totalOtherRevenue: Float """Total Other Revenue Tax""" totalOtherRevenueTax: Float """Total Room Revenue""" totalRoomRevenue: Float """Total Room Amount (Inc Packages and Taxes) for the Stay.""" totalRoomRevenueTax: Float """Total Total Revenue""" totalTotalRevenue: Float """Total Total Revenue Tax""" totalTotalRevenueTax: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float }