# title : OPERA Cloud RnA ProfilesAccounts GraphQL API, # description : GraphQL API to cater for The Profiles-Accounts subject area contains Account Room Night and Revenue statistics broken down between Group and Individual stays and can be summarized by Property, Stay Date, Business Segment, Owner and Profile Type. # Compatible with OPERA Cloud RnA release 26.1.0.0. # This document and all content within is available under the Universal Permissive License v 1.0 # (https://oss.oracle.com/licenses/upl). Copyright (c) 2020,2026 Oracle and/or its affiliates # version : 26.1.0.0 # termsOfService : https://www.oracle.com/legal/terms.html # contact_email : hospitality_apis_ww_grp@oracle.com # license : https://opensource.org/licenses/upl directive @stream(if: Boolean, label: String, initialCount: Int = 0) on FIELD directive @conditionalInputPair(pair: Int) on INPUT_FIELD_DEFINITION directive @mandatoryInput on INPUT_FIELD_DEFINITION scalar Date scalar DateTime # Date format: "YYYY-MM-DD" input DateInput{ _eq: Date _ne: Date _in: [Date] _nin: [Date] _gt: Date _lt: Date _gte: Date _lte: Date _btn: DateRangeInput _isNull: Boolean } input DateRangeInput { start: Date! end: Date! } # Datetime format: "YYYY-MM-DD HH24:MI:SS" input DateTimeInput { _eq: DateTime _ne: DateTime _in: [DateTime] _nin: [DateTime] _gt: DateTime _lt: DateTime _gte: DateTime _lte: DateTime _btn: DateTimeRangeInput _isNull: Boolean } input DateTimeRangeInput { start: DateTime! end: DateTime! } input StringInput { _eq: String _ne: String _in: [String] _nin: [String] _gt: String _lt: String _gte: String _lte: String _isNull: Boolean } input FloatInput { _eq: Float _ne: Float _in: [Float] _nin: [Float] _gt: Float _lt: Float _gte: Float _lte: Float _btn: FloatRangeInput _isNull: Boolean } input FloatRangeInput { start: Float! end: Float! } # Conditional Mandatory filters: # At least one filter from each required filter pair must be provided. # Please ensure the request includes at least one filter from each required pair. # Pair - [1] # - profileaccountsDetailsChainCode # Pair - [2] # - profileaccountsDetailsActiveYn # - profileaccountsDetailsInactiveDate # - profileaccountsDetailsJrnupdatedttm # - profileaccountsDetailsNameId # - profileaccountsDetailsOrganizationId # - profileaccountsDetailsProfileId # - profileaccountsDetailsSfirst # - profileaccountsDetailsSname # - profileaccountsDetailsSxfirstName # - profileaccountsDetailsSxname # - profileaccountsDetailsUpdateDate input ProfilesAccountsQueryArgumentsType { """Account ID""" profileaccountsDetailsProfileId: FloatInput @conditionalInputPair(pair: 2) """Active Flag""" profileaccountsDetailsActiveYn: StringInput @conditionalInputPair(pair: 2) """Chain Code""" profileaccountsDetailsChainCode: StringInput @conditionalInputPair(pair: 1) """Company""" profileaccountsDetailsCompany: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" profileaccountsDetailsDsi: FloatInput """History Y/N""" profileaccountsDetailsHistoryYn: StringInput """IATA Number""" profileaccountsDetailsNameCode: StringInput """Inactive Date""" profileaccountsDetailsInactiveDate: DateTimeInput @conditionalInputPair(pair: 2) """Organization ID""" profileaccountsDetailsOrganizationId: FloatInput @conditionalInputPair(pair: 2) """JRN Update Date and Time""" profileaccountsDetailsJrnupdatedttm: DateTimeInput @conditionalInputPair(pair: 2) """Last""" profileaccountsDetailsLast: StringInput """Name ID""" profileaccountsDetailsNameId: FloatInput @conditionalInputPair(pair: 2) """Internal ID to uniquely identify the Organization""" profileaccountsDetailsOrganizationid: FloatInput """Profile Type""" profileaccountsDetailsProfileType: StringInput """Profile Type Code""" profileaccountsDetailsNameType: StringInput """Resort for which Job is registered.""" profileaccountsDetailsResortRegistered: StringInput """The Uppercase value of Last or Company.""" profileaccountsDetailsSname: StringInput @conditionalInputPair(pair: 2) """Uppercase value of First Name.""" profileaccountsDetailsSfirst: StringInput @conditionalInputPair(pair: 2) """Internal Indexed field for Searching by Extended Byte First Name.""" profileaccountsDetailsSxfirstName: StringInput @conditionalInputPair(pair: 2) """Internal Indexed field for Searching by Extended Byte Name.""" profileaccountsDetailsSxname: StringInput @conditionalInputPair(pair: 2) """Update Date""" profileaccountsDetailsUpdateDate: DateTimeInput @conditionalInputPair(pair: 2) """Chain Code""" profileforecastDetailsChainCode: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" profileforecastDetailsDsi: FloatInput """JRN Update Date and Time""" profileforecastDetailsJrnupdatedttm: DateTimeInput """Link ID""" profileforecastDetailsLinkId: FloatInput """Link Type""" profileforecastDetailsLinkType: StringInput """Internal ID to uniquely identify the Organization""" profileforecastDetailsOrganizationid: FloatInput """Profile ID""" profileforecastDetailsProfileId: 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 """Account ID""" profilecommissionDetailsAccountId: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" profilecommissionDetailsDsi: FloatInput """JRN Update Date and Time""" profilecommissionDetailsJrnupdatedttm: DateTimeInput """Name ID""" profilecommissionDetailsNameId: FloatInput """Internal ID to uniquely identify the Organization""" profilecommissionDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" profilecommissionDetailsResort: StringInput """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""" accountmonthlystatDetailsDsi: FloatInput """Name ID""" accountmonthlystatDetailsNameId: FloatInput """Name Type""" accountmonthlystatDetailsNameType: StringInput """Internal ID to uniquely identify the Organization""" accountmonthlystatDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" accountmonthlystatDetailsResort: StringInput """Month of Summary. Stores Year and Month as YYYYMM.""" accountmonthlystatDetailsStayMonth: FloatInput """Year of Summary.""" accountmonthlystatDetailsStayYear: FloatInput """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.""" accountmonthlystatDetailsStayedBooked: StringInput """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 """DSI Internal Data Source ID to identify Opera Chain and instance""" accountdailystatDetailsDsi: FloatInput """Name ID""" accountdailystatDetailsNameId: FloatInput """Internal ID to uniquely identify the Organization""" accountdailystatDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" accountdailystatDetailsResort: 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 """Level Ten Name ID.""" profilerelationshiphierDetailsBottomId: FloatInput """Lowest Level Name Type.""" profilerelationshiphierDetailsBottomNameType: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" profilerelationshiphierDetailsDsi: FloatInput """JRN Update Date and Time""" profilerelationshiphierDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" profilerelationshiphierDetailsOrganizationid: FloatInput """Master Name ID.""" profilerelationshiphierDetailsTopId: FloatInput """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 """DSI Internal Data Source ID to identify Opera Chain and instance""" accountyearlystatDetailsDsi: FloatInput """Name ID""" accountyearlystatDetailsNameId: FloatInput """Internal ID to uniquely identify the Organization""" accountyearlystatDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" accountyearlystatDetailsResort: StringInput """Year of Summary.""" accountyearlystatDetailsStayYear: FloatInput """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.""" accountyearlystatDetailsStayedBooked: StringInput """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 """Agent ID""" resvdailystatsDetailsAgentId: FloatInput """Allotment Header ID""" resvdailystatsDetailsAllotmentHeaderId: FloatInput """Bi Resv Name ID""" resvdailystatsDetailsBiResvNameId: FloatInput """Business Date""" resvdailystatsDetailsBusinessDate: DateInput """Company ID""" resvdailystatsDetailsCompanyId: FloatInput """Contact ID""" resvdailystatsDetailsContactId: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" resvdailystatsDetailsDsi: FloatInput """Group ID""" resvdailystatsDetailsGroupId: FloatInput """Guest Profile ID""" resvdailystatsDetailsNameId: FloatInput """Resv Name ID""" resvdailystatsDetailsResvNameId: FloatInput """JRN Update Date and Time""" resvdailystatsDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" resvdailystatsDetailsOrganizationid: FloatInput """Parent Company ID""" resvdailystatsDetailsParentCompanyId: FloatInput """Code to uniquely identify the Property""" resvdailystatsDetailsResort: StringInput """Rate Code""" resvdailystatsDetailsRateCode: StringInput """Room""" resvdailystatsDetailsRoom: StringInput """Source Prof ID""" resvdailystatsDetailsSourceProfId: FloatInput """Update Date""" resvdailystatsDetailsUpdateDate: DateTimeInput """DSI Internal Data Source ID to identify Opera Chain and instance""" saleprofileownerDetailsDsi: FloatInput """JRN Update Date and Time""" saleprofileownerDetailsJrnupdatedttm: DateTimeInput """Name ID""" saleprofileownerDetailsNameId: FloatInput """Internal ID to uniquely identify the Organization""" saleprofileownerDetailsOrganizationid: FloatInput """Property""" saleprofileownerDetailsResort: StringInput """User ID""" saleprofileownerDetailsUserId: FloatInput """Agent Contact Name ID""" allotmentDetailsAgentContactNameId: FloatInput """Agent Name ID""" allotmentDetailsAgentNameId: FloatInput """Block Code""" allotmentDetailsAllotmentCode: StringInput """Block ID""" allotmentDetailsAllotmentHeaderId: FloatInput """Block Owner Code""" allotmentDetailsOwnerCode: StringInput """External S&C vendor booking ID and used in HYATT-mode.""" allotmentDetailsBookingId: StringInput """Booking Status Order""" allotmentDetailsBookingStatusOrder: FloatInput """Determines block being [G] - Group or [W] - Wholesale.""" allotmentDetailsBlockType: StringInput """Central Xchange Date""" allotmentDetailsCXchangeDate: DateInput """Chain Code""" allotmentDetailsChainCode: StringInput """Company Name ID""" allotmentDetailsCompanyNameId: FloatInput """Contact Name ID""" allotmentDetailsContactNameId: FloatInput """Created Date""" allotmentDetailsInsertDate: DateTimeInput """DSI Internal Data Source ID to identify Opera Chain and instance""" allotmentDetailsDsi: FloatInput """Due Date Sorting Column.""" allotmentDetailsDueDateOrd: DateInput """End Date""" allotmentDetailsEndDate: DateInput """Insert User""" allotmentDetailsInsertUser: FloatInput """STAR MODE: ISAC opportunity ID.""" allotmentDetailsIsacOpptyId: StringInput """JRN Update Date and Time""" allotmentDetailsJrnupdatedttm: DateTimeInput """Market Code""" allotmentDetailsMarketCode: StringInput """Parent Block ID""" allotmentDetailsSuperBlockId: FloatInput """Parent Resort""" allotmentDetailsSuperBlockResort: StringInput """Profile Id. ( Name_Id ) of the Group Profile attached to this business block.""" allotmentDetailsMasterNameId: FloatInput """Internal ID to uniquely identify the Organization""" allotmentDetailsOrganizationid: FloatInput """ORMS Block Class""" allotmentDetailsOrmsBlockClass: StringInput """Owner""" allotmentDetailsOwner: FloatInput """Code to uniquely identify the Property""" allotmentDetailsResort: StringInput """Rate Code""" allotmentDetailsRateCode: StringInput """Reservation Type""" allotmentDetailsGuaranteeCode: StringInput """Room Status""" allotmentDetailsBookingStatus: StringInput """Shoulder End""" allotmentDetailsShoulderEndDate: DateInput """Shoulder Start""" allotmentDetailsShoulderBeginDate: DateInput """Source Name ID""" allotmentDetailsSourceNameId: FloatInput """Start Date""" allotmentDetailsBeginDate: DateInput """Tour Code.""" allotmentDetailsTourcode: StringInput """This is upper-case description of regular description column for fast search""" allotmentDetailsUdescription: StringInput """Updated Date""" allotmentDetailsUpdateDate: DateTimeInput """Multi Byte Description in uppercase""" allotmentDetailsXudescription: StringInput } type Query { """The Profiles-Accounts subject area contains Account Room Night and Revenue statistics broken down between Group and Individual stays and can be summarized by Property Stay Date Business Segment Owner and Profile Type.""" profilesAccounts(limit: Int offset: Int input: ProfilesAccountsQueryArgumentsType!): [ProfilesAccountsType] } type ProfilesAccountsType { """Profile Accounts Details""" profileAccountsDetails: ProfilesAccountsProfileAccountsDetailsType """Profile Forecast Details""" profileForecastDetails: ProfilesAccountsProfileForecastDetailsType """Profile Communication Details""" profileCommunicationDetails: ProfilesAccountsProfileCommunicationDetailsType """Profile Commission Details""" profileCommissionDetails: ProfilesAccountsProfileCommissionDetailsType """Profile Relationship Details""" profileRelationshipDetails: ProfilesAccountsProfileRelationshipDetailsType """Account Monthly Statistics""" accountMonthlyStatisticsDetails: ProfilesAccountsAccountMonthlyStatisticsDetailsType """Profile Address Details""" profileAddressDetails: ProfilesAccountsProfileAddressDetailsType """Account Daily Statistics""" accountDailyStatisticsDetails: ProfilesAccountsAccountDailyStatisticsDetailsType """Profile Note Details""" profileNoteDetails: ProfilesAccountsProfileNoteDetailsType """Profile Relationship Hier Details""" profileRelationshipHierDetails: ProfilesAccountsProfileRelationshipHierDetailsType """Profile Preference Details""" profilePreferenceDetails: ProfilesAccountsProfilePreferenceDetailsType """Account Yearly Statistics""" accountYearlyStatisticsDetails: ProfilesAccountsAccountYearlyStatisticsDetailsType """Profile Owner Details""" profileOwnerDetails: ProfilesAccountsProfileOwnerDetailsType """Reservation Daily Statistics""" reservationDailyStatisticsDetails: ProfilesAccountsReservationDailyStatisticsDetailsType """Sales Goals Profile Owner Details""" saleProfileOwnerDetails: ProfilesAccountsSaleProfileOwnerDetailsType """Block""" blockDetails: ProfilesAccountsBlockDetailsType profilesAccountsRecordCount: Int } type ProfilesAccountsProfileAccountsDetailsType { """AR Number""" aRNumber: String """The date this record was last updated by the ARC update program.""" aRCUpdateDate: Date """Account Email Primary""" accountEmailPrimary: String """Account ID""" accountID: Float """Account Name""" accountName: String """Account Name 2""" accountName2: String """Account Name 3""" accountName3: String """Account Owner Title""" accountOwnerTitle: String """Account Owners(All)""" accountOwnersAll: String """Phone no.""" accountPhonePrimary: String """Account Phone Web""" accountPhoneWeb: String """Account Source""" accountSource: String """Account Source Description""" accountSourceDescription: String """Account Type""" accountType: String """Account Type Description""" accountTypeDescription: String """Billing contact person in company.""" acctContact: String """Action Code""" actionCode: String """Active Flag""" activeFlag: String """Address 1""" address1: String """Address 2""" address2: String """Address 3""" address3: String """Address 4""" address4: String """Address Lang Code Description""" addressLangCodeDesc: String """Address Language""" addressLanguage: String """Address Language Code""" addressLanguageCode: String """Address Type""" addressType: String """All Properties""" allProperties: String """The Extended Byte Language of the Profile.""" alternateLanguage: String """Alternate Language Description""" alternateLanguageDescription: String """Alternate Name""" alternateName: String """Alternate Salutation""" alternateSalutation: String """Alternate Title""" alternateTitle: String """AR No Central""" arNumberCentral: String """Autoenroll Member Y/N""" autoenrollMemberYn: String """Billing Instruction""" billingInstruction: String """For tour operators the type of billing profile for this name.""" billingProfileCode: String """Birth Date""" birthDate: Date """Birth Date Str""" birthDateStr: String """Place of birth.""" birthPlace: String """Bl Msg""" blMsg: String """Business Potential""" businessPotential: String """Business Potential Description""" businessPotentialDescription: String """Business Segement""" businessSegement: String """Business Segement Description""" businessSegementDescription: String """Business Title""" businessTitle: String """Central Account Owner Title""" centralAccountOwnerTitle: String """Central Account Source""" centralAccountSource: String """Central Account Source Description""" centralAccountSourceDescription: String """Central Account Type""" centralAccountType: String """Central Account Type Description""" centralAccountTypeDescription: String """Central Business Potential""" centralBusinessPotential: String """Central Business Potential Description""" centralBusinessPotentialDescription: String """Central Business Segement Description""" centralBusinessSegementDescription: String """Central Business Segment""" centralBusinessSegment: String """Central Competition Code""" centralCompetitionCode: String """Central Competition Code Description""" centralCompetitionCodeDescription: String """Central Corporate Type""" centralCorporateType: String """Central Corporate Type Description""" centralCorporateTypeDescription: String """Central Inactive Reason""" centralInactiveReason: String """Central Inactive Reason Description""" centralInactiveReasonDescription: String """Central Industry Code""" centralIndustryCode: String """Central Industry Code Description""" centralIndustryCodeDescription: String """Central Keyword""" centralKeyword: String """Central Priority""" centralPriority: String """Central Priority Description""" centralPriorityDescription: String """Central Profile Type Code""" centralProfileTypeCode: String """Central Profile Type Description""" centralProfileTypeDescription: String """Central Scope""" centralScope: String """Central Scope City""" centralScopeCity: String """Central Scope City Description""" centralScopeCityDescription: String """Central Scope Description""" centralScopeDescription: String """Central State""" centralState: String """Central Territory""" centralTerritory: String """Central Territory Description""" centralTerritoryDescription: String """Chain Code""" chainCode: String """City""" city: String """City Ext""" cityExt: String """Combined Name""" combinedName: String """Commission Code""" commissionCode: String """Commission Code All""" commissionCodeAll: 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 """Competition Code""" competitionCode: String """Competition Code Description""" competitionCodeDescription: 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.""" corporateType: String """Corporate Type Description""" corporateTypeDescription: String """Country""" country: String """Country Description""" countryDescription: 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 """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Email Y/N""" emailYn: String """Envelope Greeting""" envelopeGreeting: String """External ID""" externalId: String """F Subscription Db""" fSubscriptionDb: String """F Subscription Y/N""" fSubscriptionYn: String """Fax Number""" faxNo: String """First""" first: String """Gender""" gender: String """Guest Priv Y/N""" guestPrivYn: String """History Y/N""" historyYn: String """Hold Code""" holdCode: String """IATA Number""" iATANumber: String """IATA Consortia""" iataConsortia: 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 """Industry Code""" industryCode: String """Industry Code Description""" industryCodeDescription: String """Interest Code.""" interest: 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 """Last""" last: String """Last Group""" lastGroup: String """Last Rate""" lastRate: Float """Not used.""" lastRoom: String """Last Source""" lastSource: String """Last Stay""" lastStay: Date """Legal Company""" legalCompany: String """Letter Greeting""" letterGreeting: String """Mail Action""" mailAction: String """Mail Action Description""" mailActionDescription: String """Mail List""" mailList: String """The type of mail this user should be sent.""" mailType: String """Mail Y/N""" mailYn: String """Market Research Y/N""" marketResearchYn: String """Middle""" middle: String """Name ID""" nameId: Float """Nationality Code""" nationalityCode: String """Nationality Description""" nationalityDescription: String """Negotiated Rate""" negotiatedRate: String """Next Stay""" nextStay: Date """The nickname of this individual.""" nickname: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Number of days a payment is due for the account.""" paymentDueDays: Float """Postal Code""" postalCode: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Primary Owner""" primaryOwner: String """Primary Owner Code""" primaryOwnerCode: String """Priority""" priority: String """Priority Description""" priorityDescription: String """Product Interest""" productInterest: String """Profession of the guest""" profession: String """Profile Language Description""" profileLanguageDescription: String """Profile privacy flag determine if the profile is marked as private for a property.""" profilePrivacyFlg: String """Profile Type""" profileType: String """Profile Type Code""" profileTypeCode: String """Profile Type Description""" profileTypeDescription: String """Protected""" protected: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Reference Currency""" referenceCurrency: String """Reporting Influence""" repInfluence: String """Reporting Influence Desc""" repInfluenceDescription: String """Rep Mail Action Codes""" repMailActionCodes: String """Rep Mail Action Desc""" repMailActionDesc: String """Reporting Nationality Code""" repNationalityCode: String """Reporting Nationality Description""" repNationalityDescription: String """Reporting State Desc""" repStateDescription: String """Reporting Tax Type Desc""" repTaxTypeDescription: String """Reporting Title Name""" repTitleName: String """Reporting Vip Name""" repVIPName: String """Reporting Vip Status""" repVIPStatus: 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 """Salutation Greeting""" salutation: String """Scope""" scope: String """Scope City""" scopeCity: String """Scope City Decription""" scopeCityDecription: String """Scope Description""" scopeDescription: String """The Uppercase value of Last or Company.""" searchAccountName: String """Uppercase value of First Name.""" sfirst: String """State""" state: String """State Code""" stateCode: String """State Description of the Guest of Payee""" stateDesc: String """Internal Indexed field for Searching by Extended Byte First Name.""" sxfirstName: String """Internal Indexed field for Searching by Extended Byte Name.""" sxname: String """Tax1 Number""" tax1No: String """Tax2 Number""" tax2No: String """Tax Category""" taxCategory: String """Tax Type""" taxType: String """Tax Type Description""" taxTypeDescription: String """Territory""" territory: String """Territory Description""" territoryDescription: String """Third Party Y/N""" thirdPartyYn: String """Trace Code""" traceCode: String """Trace Code Description""" traceCodeDescription: 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 """VIP Name""" vipName: String """VIP Status""" vipStatus: String """Extended Byte Company Name""" xcompanyName: String """Xenvelope Greeting""" xenvelopeGreeting: String """Xfirst Name""" xfirstName: String """Xlast Name""" xlastName: String """Extended Byte middle name.""" xmiddleName: String } type ProfilesAccountsProfileForecastDetailsType { """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Forecast FB Revenue""" centralForecastFBRevenue: Float """Central Forecast Other Revenue""" centralForecastOtherRevenue: Float """Central Forecast Room Average Rate""" centralForecastRoomAverageRate: Float """Central Forecast Room Revenue""" centralForecastRoomRevenue: Float """Chain Code""" chainCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Description""" description: String """Forecast FB Revenue""" forecastFBRevenue: Float """Forecast Insert Date""" forecastInsertDate: DateTime """Forecast Insert User""" forecastInsertUser: Float """Forecast Other Revenue""" forecastOtherRevenue: Float """Forecast Period Code""" forecastPeriodCode: String """Period End Date""" forecastPeriodEnd: Date """Period Start Date""" forecastPeriodStart: Date """Average Room Rate""" forecastRoomAverageRate: Float """Forecast Room Nights""" forecastRoomNights: Float """Forecast Room Revenue""" forecastRoomRevenue: Float """Specifies the forecast split mode. Possible values are: GROUP NON-GROUP and blank.""" forecastSplitMode: String """Forecast Type""" forecastType: String """Forecast Update Date""" forecastUpdateDate: DateTime """Forecast Update User""" forecastUpdateUser: Float """Inactive Date""" inactiveDate: DateTime """The name of the user who created the record.""" insertUserName: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Laptop Change""" laptopChange: Float """Link Chain Code""" linkChainCode: String """Link ID""" linkId: Float """Link Insert Date""" linkInsertDate: DateTime """Link Insert User""" linkInsertUser: Float """Link Laptop Change""" linkLaptopChange: Float """Link Type""" linkType: String """Internal ID to uniquely identify the Property""" locationID: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Period""" period: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Primary Y/N""" primaryYn: String """Profile ID""" profileId: Float """Code to uniquely identify the Property""" property: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Relationship""" relationship: String """To Type""" toType: String """Update User Name""" updateUserName: String } type ProfilesAccountsProfileCommunicationDetailsType { """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 ProfilesAccountsProfileCommissionDetailsType { """Account ID""" accountId: Float """Central Commission Code""" centralCommissionCode: String """Central Commission Code Description""" centralCommissionCodeDescription: String """Commission Code""" commissionCode: String """Commission Code Description""" commissionCodeDescription: String """Created By User""" createdByUser: Float """Created On Date""" createdOnDate: DateTime """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Laptop Change""" laptopChange: Float """Internal ID to uniquely identify the Property""" locationID: String """Name ID""" nameId: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Code to uniquely identify the Property""" property: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ProfilesAccountsProfileRelationshipDetailsType { """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 ProfilesAccountsAccountMonthlyStatisticsDetailsType { """Average Daily Rate""" adr: 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 """Cancels""" cancels: 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 Currency Code""" centralCurrencyCode: String """Central FB Revenue Net""" centralFBRevenueNet: Float """Central FB Revenue Tax""" centralFBRevenueTax: Float """Central Group FB Revenue Net""" centralGroupFBRevenueNet: Float """Central Group FB Revenue Tax""" centralGroupFBRevenueTax: Float """Central Group Other Revenue Net""" centralGroupOtherRevenueNet: Float """Central Group Other Revenue Tax""" centralGroupOtherRevenueTax: Float """Central Group Room Revenue Net""" centralGroupRoomRevenueNet: Float """Central Group Room Revenue Tax""" centralGroupRoomRevenueTax: Float """Central Group Total Revenue Net""" centralGroupTotalRevenueNet: Float """Central Group Total Revenue Tax""" centralGroupTotalRevenueTax: Float """Central Individual FB Revenue Net""" centralIndividualFBRevenueNet: Float """Central Individual FB Revenue Tax""" centralIndividualFBRevenueTax: Float """Central Individual Other Revenue Net""" centralIndividualOtherRevenueNet: Float """Central Individual Other Revenue Tax""" centralIndividualOtherRevenueTax: Float """Central Individual Room Revenue Net""" centralIndividualRoomRevenueNet: Float """Central Individual Room Revenue Tax""" centralIndividualRoomRevenueTax: Float """Central Individual Total Revenue Net""" centralIndividualTotalRevenueNet: Float """Central Individual Total Revenue Tax""" centralIndividualTotalRevenueTax: Float """Central Other Revenue Net""" centralOtherRevenueNet: Float """Central Other Revenue Tax""" centralOtherRevenueTax: Float """Central Room Revenue Net""" centralRoomRevenueNet: Float """Central Room Revenue Tax""" centralRoomRevenueTax: Float """Central Total Revenue Net""" centralTotalRevenueNet: 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 Net""" fBRevenueNet: Float """FB Revenue Tax""" fBRevenueTax: Float """Group Number of Cancellations.""" groupCancels: Float """Group F&B Revenue.""" groupFBRevenueNet: Float """Group F&B Revenue Tax.""" groupFBRevenueTax: Float """Group Number of No Shows.""" groupNoShows: Float """Group Other Revenue.""" groupOtherRevenueNet: Float """Group Other Revenue Tax.""" groupOtherRevenueTax: Float """Group Number of Nights.""" groupRoomNights: Float """Group Room Revenue.""" groupRoomRevenueNet: Float """Group Room Revenue Tax.""" groupRoomRevenueTax: Float """Group Number of Stays.""" groupStays: Float """Group Total Revenue.""" groupTotalRevenueNet: Float """Group Total Revenue Tax.""" groupTotalRevenueTax: Float """Group Adr""" grpAverageDailyRate: Float """Individual Cancels""" individualCancels: Float """Individual FB Revenue Net""" individualFBRevenueNet: Float """F&B Revenue Tax.""" individualFBRevenueTax: Float """Individual Number Shows""" individualNoShows: Float """Individual Other Revenue Net""" individualOtherRevenueNet: Float """Individual Other Revenue Tax""" individualOtherRevenueTax: Float """Individual Room Nights""" individualRoomNights: Float """Individual Room Revenue Net""" individualRoomRevenueNet: Float """Individual Room Revenue Tax""" individualRoomRevenueTax: Float """Individual Stays""" individualStays: Float """Individual Total Revenue Net""" individualTotalRevenueNet: Float """Individual Total Revenue Tax""" individualTotalRevenueTax: 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 """Number Shows""" noShows: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Other Revenue Net""" otherRevenueNet: 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 Net""" roomRevenueNet: Float """Total Room Amount (Inc Packages and Taxes) for the Stay.""" roomRevenueTax: 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 """Stays""" stays: Float """Total Average Daily Rate""" totalAdr: Float """Total Revenue Net""" totalRevenueNet: Float """Total Revenue Tax""" totalRevenueTax: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ProfilesAccountsProfileAddressDetailsType { """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 ProfilesAccountsAccountDailyStatisticsDetailsType { """Average Daily Rate""" adr: Float """Cancels""" cancels: Float """Central FB Revenue Net""" centralFBRevenueNet: Float """Central FB Revenue Tax""" centralFBRevenueTax: Float """Central Group FB Revenue Net""" centralGroupFBRevenueNet: Float """Central Group FB Revenue Tax""" centralGroupFBRevenueTax: Float """Central Group Other Revenue Net""" centralGroupOtherRevenueNet: Float """Central Group Other Revenue Tax""" centralGroupOtherRevenueTax: Float """Central Group Room Revenue Net""" centralGroupRoomRevenueNet: Float """Central Group Room Revenue Tax""" centralGroupRoomRevenueTax: Float """Central Group Total Revenue Net""" centralGroupTotalRevenueNet: Float """Central Group Total Revenue Tax""" centralGroupTotalRevenueTax: Float """Central Individual FB Revenue Net""" centralIndividualFBRevenueNet: Float """Central Individual FB Revenue Tax""" centralIndividualFBRevenueTax: Float """Central Individual Other Revenue Net""" centralIndividualOtherRevenueNet: Float """Central Individual Other Revenue Tax""" centralIndividualOtherRevenueTax: Float """Central Individual Room Revenue Net""" centralIndividualRoomRevenueNet: Float """Central Individual Room Revenue Tax""" centralIndividualRoomRevenueTax: Float """Central Individual Total Revenue Net""" centralIndividualTotalRevenueNet: Float """Central Individual Total Revenue Tax""" centralIndividualTotalRevenueTax: Float """Central Other Revenue Net""" centralOtherRevenueNet: Float """Central Other Revenue Tax""" centralOtherRevenueTax: Float """Central Room Revenue Net""" centralRoomRevenueNet: Float """Central Room Revenue Tax""" centralRoomRevenueTax: Float """Central Total Revenue Net""" centralTotalRevenueNet: Float """Central Total Revenue Tax""" centralTotalRevenueTax: Float """Central Exchange Date""" centralXchangeDate: Date """Central Exchange Rate""" centralXchangeRate: Float """Context Cd""" contextCd: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """FB Revenue Net""" fBRevenueNet: Float """FB Revenue Tax""" fBRevenueTax: Float """Group Number of Cancellations.""" groupCancels: Float """Group F&B Revenue.""" groupFBRevenueNet: Float """Group F&B Revenue Tax.""" groupFBRevenueTax: Float """Group Number of No Shows.""" groupNoShows: Float """Group Other Revenue.""" groupOtherRevenueNet: Float """Group Other Revenue Tax.""" groupOtherRevenueTax: Float """Group Number of Nights.""" groupRoomNights: Float """Group Room Revenue.""" groupRoomRevenueNet: Float """Group Room Revenue Tax.""" groupRoomRevenueTax: Float """Group Number of Stays.""" groupStays: Float """Group Total Revenue.""" groupTotalRevenueNet: Float """Group Total Revenue Tax.""" groupTotalRevenueTax: Float """Group Adr""" grpAverageDailyRate: Float """Individual Cancels""" individualCancels: Float """Individual FB Revenue Net""" individualFBRevenueNet: Float """F&B Revenue Tax.""" individualFBRevenueTax: Float """Individual Number Shows""" individualNoShows: Float """Individual Other Revenue Net""" individualOtherRevenueNet: Float """Individual Other Revenue Tax""" individualOtherRevenueTax: Float """Individual Room Nights""" individualRoomNights: Float """Individual Room Revenue Net""" individualRoomRevenueNet: Float """Individual Room Revenue Tax""" individualRoomRevenueTax: Float """Individual Stays""" individualStays: Float """Individual Total Revenue Net""" individualTotalRevenueNet: Float """Individual Total Revenue Tax""" individualTotalRevenueTax: 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 """Internal ID to uniquely identify the Organization""" organizationID: Float """Other Revenue Net""" otherRevenueNet: 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 Net""" roomRevenueNet: Float """Total Room Amount (Inc Packages and Taxes) for the Stay.""" roomRevenueTax: Float """Stay Date""" stayDate: Date """Month of Summary. Stores Year and Month as YYYYMM.""" stayMonth: Float """Year of Summary.""" stayYear: Float """Stays""" stays: Float """Total Average Daily Rate""" totalAdr: Float """Total Revenue Net""" totalRevenueNet: Float """Total Revenue Tax""" totalRevenueTax: Float } type ProfilesAccountsProfileNoteDetailsType { """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 ProfilesAccountsProfileRelationshipHierDetailsType { """Level Ten Name ID.""" bottomId: Float """Lowest Level Name Type.""" bottomNameType: String """Chain Code""" chainCode: String """Context Cd""" contextCd: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Relationship with Type.""" relToType: String """Relationship Type.""" relType: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Master Name ID.""" topId: Float """Current Level or Record in relationship hierarchy.""" totalLevels: Float } type ProfilesAccountsProfilePreferenceDetailsType { """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 ProfilesAccountsAccountYearlyStatisticsDetailsType { """Average Daily Rate""" adr: 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 """Cancels""" cancels: 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 Cc FB Revenue""" centralCcFbRevenue: Float """Central Cc FB Revenue Tax""" centralCcFbRevenueTax: Float """Central Cc Group Fb Revenue""" centralCcGrpFBRevenue: Float """Central Cc Group Fb Revenue Tax""" centralCcGrpFBRevenueTax: Float """Central Cc Group Misc Revenue""" centralCcGrpMiscellaneousRevenue: Float """Central Cc Group Misc Revenue Tax""" centralCcGrpMiscellaneousRevenueTax: Float """Central Cc Group Other Revenue""" centralCcGrpOtherRevenue: Float """Central Cc Group Other Revenue Tax""" centralCcGrpOtherRevenueTax: Float """Central Cc Group Room Revenue""" centralCcGrpRoomRevenue: Float """Central Cc Group Room Revenue Tax""" centralCcGrpRoomRevenueTax: Float """Central Cc Group Total Revenue""" centralCcGrpTotalRevenue: Float """Central Cc Group Total Revenue Tax""" centralCcGrpTotalRevenueTax: Float """Central Cc Miscellaneous Revenue""" centralCcMiscRevenue: Float """Central Cc Miscellaneous Revenue Tax""" centralCcMiscRevenueTax: Float """Central Cc Other Revenue""" centralCcOtherRevenue: Float """Central Cc Other Revenue Tax""" centralCcOtherRevenueTax: Float """Central Cc Room Revenue""" centralCcRoomRevenue: Float """Central Currency Code""" centralCurrencyCode: String """Central FB Revenue Net""" centralFBRevenueNet: Float """Central FB Revenue Tax""" centralFBRevenueTax: Float """Central Group FB Revenue Net""" centralGroupFBRevenueNet: Float """Central Group FB Revenue Tax""" centralGroupFBRevenueTax: Float """Central Group Other Revenue Net""" centralGroupOtherRevenueNet: Float """Central Group Other Revenue Tax""" centralGroupOtherRevenueTax: Float """Central Group Room Revenue Net""" centralGroupRoomRevenueNet: Float """Central Group Room Revenue Tax""" centralGroupRoomRevenueTax: Float """Central Group Total Revenue Net""" centralGroupTotalRevenueNet: Float """Central Group Total Revenue Tax""" centralGroupTotalRevenueTax: Float """Central Individual FB Revenue Net""" centralIndividualFBRevenueNet: Float """Central Individual FB Revenue Tax""" centralIndividualFBRevenueTax: Float """Central Individual Other Revenue Net""" centralIndividualOtherRevenueNet: Float """Central Individual Other Revenue Tax""" centralIndividualOtherRevenueTax: Float """Central Individual Room Revenue Net""" centralIndividualRoomRevenueNet: Float """Central Individual Room Revenue Tax""" centralIndividualRoomRevenueTax: Float """Central Individual Total Revenue Net""" centralIndividualTotalRevenueNet: Float """Central Individual Total Revenue Tax""" centralIndividualTotalRevenueTax: Float """Central Other Revenue Net""" centralOtherRevenueNet: Float """Central Other Revenue Tax""" centralOtherRevenueTax: Float """Central Room Revenue Net""" centralRoomRevenueNet: Float """Central Room Revenue Tax""" centralRoomRevenueTax: Float """Central Total Revenue Net""" centralTotalRevenueNet: 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 Net""" fBRevenueNet: Float """FB Revenue Tax""" fBRevenueTax: Float """Group Number of Cancellations.""" groupCancels: Float """Group F&B Revenue.""" groupFBRevenueNet: Float """Group F&B Revenue Tax.""" groupFBRevenueTax: Float """Group Number of No Shows.""" groupNoShows: Float """Group Other Revenue.""" groupOtherRevenueNet: Float """Group Other Revenue Tax.""" groupOtherRevenueTax: Float """Group Number of Nights.""" groupRoomNights: Float """Group Room Revenue.""" groupRoomRevenueNet: Float """Group Room Revenue Tax.""" groupRoomRevenueTax: Float """Group Number of Stays.""" groupStays: Float """Group Total Revenue.""" groupTotalRevenueNet: Float """Group Total Revenue Tax.""" groupTotalRevenueTax: Float """Group Adr""" grpAverageDailyRate: Float """Individual Cancels""" individualCancels: Float """Individual FB Revenue Net""" individualFBRevenueNet: Float """F&B Revenue Tax.""" individualFBRevenueTax: Float """Individual Number Shows""" individualNoShows: Float """Individual Other Revenue Net""" individualOtherRevenueNet: Float """Individual Other Revenue Tax""" individualOtherRevenueTax: Float """Individual Room Nights""" individualRoomNights: Float """Individual Room Revenue Net""" individualRoomRevenueNet: Float """Individual Room Revenue Tax""" individualRoomRevenueTax: Float """Individual Stays""" individualStays: Float """Individual Total Revenue Net""" individualTotalRevenueNet: Float """Individual Total Revenue Tax""" individualTotalRevenueTax: 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 """Number Shows""" noShows: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Other Revenue Net""" otherRevenueNet: 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 Net""" roomRevenueNet: Float """Total Room Amount (Inc Packages and Taxes) for the Stay.""" roomRevenueTax: 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 """Stays""" stays: Float """Total Average Daily Rate""" totalAdr: Float """Total Revenue Net""" totalRevenueNet: Float """Total Revenue Tax""" totalRevenueTax: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ProfilesAccountsProfileOwnerDetailsType { """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 ProfilesAccountsReservationDailyStatisticsDetailsType { """Adults""" adults: Float """Adults Tax Free""" adultsTaxFree: Float """Agent ID""" agentId: Float """Agentprofileid""" agentprofileid: Float """Allotment Header ID""" allotmentHeaderId: Float """Block ID""" allotmentid: Float """Arrival Persons""" arrivalPersons: Float """Arrival Rooms""" arrivalRooms: Float """Begin Date""" beginDate: Date """Bi Resv Name ID""" biReservationNameId: Float """Birth Date""" birthDate: Date """Booked Room Category""" bookedRoomCategory: String """Bookedroomcategoryid""" bookedroomcategoryid: String """Business Date""" businessDate: Date """Business Date Created""" businessDateCreated: Date """Central Adv Total Other Tax""" cAdvanceTotalOtherTax: Float """Central Cash Room Revenue""" cCashRoomRevenue: Float """Central Comp Room Revenue""" cCompRoomRevenue: Float """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Flgd Food Revenue""" cFlaggedFoodRevenue: Float """Central Flgd Non Revenue""" cFlaggedNonRevenue: Float """Central Flgd Other Revenue""" cFlaggedOtherRevenue: Float """Central Flgd Room Revenue""" cFlaggedRoomRevenue: Float """Central Flgd Total Food Tax""" cFlaggedTotalFoodTax: Float """Central Flgd Total Non Revenue Tax""" cFlaggedTotalNonRevenueTax: Float """Central Flgd Total Other Tax""" cFlaggedTotalOtherTax: Float """Central Flgd Total Revenue""" cFlaggedTotalRevenue: Float """Central Flgd Total Room Tax""" cFlaggedTotalRoomTax: Float """Central Flgd Total Tax""" cFlaggedTotalTax: Float """Central Pr Adv Total Food Tax""" cPrAdvanceTotalFoodTax: Float """Central Rate Amount""" cRateAmount: Float """Central Rs Adv Food Revenue""" cRsAdvanceFoodRevenue: Float """Central Rs Adv Food Tax""" cRsAdvanceFoodTax: Float """Central Rs Adv Non Revenue""" cRsAdvanceNonRevenue: Float """Central Rs Adv Non Revenue Tax""" cRsAdvanceNonRevenueTax: Float """Central Rs Adv Other Revenue""" cRsAdvanceOtherRevenue: Float """Central Rs Adv Other Tax""" cRsAdvanceOtherTax: Float """Central Rs Adv Room Revenue""" cRsAdvanceRoomRevenue: Float """Central Rs Adv Room Tax""" cRsAdvanceRoomTax: Float """Central Rs Adv Total Revenue""" cRsAdvanceTotalRevenue: Float """Central Rs Adv Total Tax""" cRsAdvanceTotalTax: Float """Central Upsold Revenue""" cUpsoldRevenue: Float """Cancellation Date""" cancellationDate: DateTime """Cancelled Persons""" cancelledPersons: Float """Cancelled Reservations""" cancelledReservations: Float """Cancelled Rooms""" cancelledRooms: Float """Cash Room Nts""" cashRoomNts: Float """Cash Room Revenue""" cashRoomRevenue: Float """Central Currency Code""" centralCurrencyCode: String """Central Distributed Food Revenue""" centralDistributedFoodRevenue: Float """Central Distributed Food Revenue (as Payee""" centralDistributedFoodRevenueAsPayee: Float """Central Distributed Non Revenue""" centralDistributedNonRevenue: Float """Central Distributed Non-Revenue (as Payee""" centralDistributedNonRevenueAsPayee: Float """Central Distributed Other Revenue""" centralDistributedOtherRevenue: Float """Central Distributed Other Revenue (as Payee""" centralDistributedOtherRevenueAsPayee: Float """Central Distributed Room Revenue""" centralDistributedRoomRevenue: Float """Central Distributed Room Revenue (as Payee""" centralDistributedRoomRevenueAsPayee: Float """Central Distributed Total Food Tax (as Payee""" centralDistributedTotalFoodTaxAsPayee: Float """Central Distributed Total Non Revenue Tax""" centralDistributedTotalNonRevenueTax: Float """Central Distributed Total Non-Revenue Tax (as Payee""" centralDistributedTotalNonRevenueTaxAsPayee: Float """Central Distributed Total Other Tax (as Payee""" centralDistributedTotalOtherTaxAsPayee: Float """Central Distributed Total Revenue""" centralDistributedTotalRevenue: Float """Central Distributed Total Revenue (as Payee""" centralDistributedTotalRevenueAsPayee: Float """Central Distributed Total Room Tax""" centralDistributedTotalRoomTax: Float """Central Distributed Total Room Tax (as Payee""" centralDistributedTotalRoomTaxAsPayee: Float """Central Distributed Total Tax""" centralDistributedTotalTax: Float """Central Distributed Total Tax (as Payee""" centralDistributedTotalTaxAsPayee: Float """Central Exchange Rate""" centralExchangeRate: Float """Central Food Revenue""" centralFoodRevenue: Float """Central Food Revenue (as Payee""" centralFoodRevenueAsPayee: Float """Central Market Code""" centralMarketCode: String """Central Market Description""" centralMarketDescription: String """Central Market Group Code""" centralMarketGroupCode: String """Central Market Group Description""" centralMarketGroupDescription: String """Central Non Revenue""" centralNonRevenue: Float """Central Non-Revenue (as Payee""" centralNonRevenueAsPayee: Float """Central Origin Code""" centralOriginCode: String """Central Origin Description""" centralOriginDescription: String """Central Original Room Type""" centralOriginalRoomType: String """Central Other Revenue""" centralOtherRevenue: Float """Central Other Revenue (as Payee""" centralOtherRevenueAsPayee: Float """Central Package Food Revenue""" centralPackageFoodRevenue: Float """Central Package Food Revenue (as Payee""" centralPackageFoodRevenueAsPayee: Float """Central Package Non Revenue""" centralPackageNonRevenue: Float """Central Package Non-Revenue (as Payee""" centralPackageNonRevenueAsPayee: Float """Central Package Other Revenue""" centralPackageOtherRevenue: Float """Central Package Other Revenue (as Payee""" centralPackageOtherRevenueAsPayee: Float """Central Package Room Revenue""" centralPackageRoomRevenue: Float """Central Package Room Revenue (as Payee""" centralPackageRoomRevenueAsPayee: Float """Central Rate Category""" centralRateCategory: String """Central Room Revenue""" centralRoomRevenue: Float """Central Room Revenue (as Payee""" centralRoomRevenueAsPayee: Float """Central Source Code""" centralSourceCode: String """Central Source Description""" centralSourceDescription: String """Central Source Group Code""" centralSourceGroupCode: String """Central Source Group Description""" centralSourceGroupDescription: String """Central Total Food Tax""" centralTotalFoodTax: Float """Central Total Food Tax Generated (as Payee""" centralTotalFoodTaxGeneratedAsPayee: Float """Central Total Non Revenue Tax""" centralTotalNonRevenueTax: Float """Central Total Non-Revenue Tax (as Payee""" centralTotalNonRevenueTaxAsPayee: Float """Central Total Other Tax""" centralTotalOtherTax: Float """Central Total Other Tax (as Payee""" centralTotalOtherTaxAsPayee: Float """Central Total Package Revenue""" centralTotalPackageRevenue: Float """Central Total Package Revenue (as Payee""" centralTotalPackageRevenueAsPayee: Float """Central Total Revenue""" centralTotalRevenue: Float """Central Total Revenue (as Payee""" centralTotalRevenueAsPayee: Float """Central Total Room Tax""" centralTotalRoomTax: Float """Central Total Room Tax (as Payee""" centralTotalRoomTaxAsPayee: Float """Central Total Tax""" centralTotalTax: Float """Central Total Tax (as Payee""" centralTotalTaxAsPayee: Float """Centralcurrencyid""" centralcurrencyid: String """Channelid""" channelid: String """Children""" children: Float """Children Tax Free""" childrenTaxFree: Float """Children1""" children1: Float """Children2""" children2: Float """Children3""" children3: Float """Children4""" children4: Float """Children5""" children5: Float """City""" city: String """Cityid""" cityid: String """Comp Room Nts""" compRoomNts: Float """Comp Room Revenue""" compRoomRevenue: Float """Company ID""" companyId: Float """Company Profile ID""" companyProfileID: Float """Company Profile Name""" companyProfileName: String """Compflag""" compflag: String """Complimentary YN""" complimentaryYN: String """Contact ID""" contactId: Float """Contact Profile ID""" contactProfileID: Float """Contactflag""" contactflag: String """Country""" country: String """Country Main Group""" countryMainGroup: String """Country Name""" countryName: String """Countrygroupid""" countrygroupid: String """Countryid""" countryid: String """Cribs""" cribs: Float """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Day Use Persons""" dayUsePersons: Float """Day Use Reservations""" dayUseReservations: Float """Day Use Rooms""" dayUseRooms: Float """Deleted Flag""" deletedFlag: String """Departure Persons""" departurePersons: Float """Departure Rooms""" departureRooms: Float """Distributed Food Revenue""" distributedFoodRevenue: Float """Distributed Food Revenue (as Payee""" distributedFoodRevenueAsPayee: Float """Distributed Non Revenue""" distributedNonRevenue: Float """Distributed Non-Revenue (as Payee""" distributedNonRevenueAsPayee: Float """Distributed Other Revenue""" distributedOtherRevenue: Float """Distributed Other Revenue (as Payee""" distributedOtherRevenueAsPayee: Float """Distributed Room Revenue""" distributedRoomRevenue: Float """Distributed Room Revenue (as Payee""" distributedRoomRevenueAsPayee: Float """Distributed Total Food Tax as Payee""" distributedTotalFoodTaxAsPayee: Float """Distributed Total Non Revenue Tax""" distributedTotalNonRevenueTax: Float """Distributed Total Non-Revenue Tax (as Payee""" distributedTotalNonRevenueTaxAsPayee: Float """Distributed Total Other Tax""" distributedTotalOtherTax: Float """Distributed Total Other Tax (as Payee""" distributedTotalOtherTaxAsPayee: Float """Distributed Total Revenue""" distributedTotalRevenue: Float """Distributed Total Revenue (as Payee""" distributedTotalRevenueAsPayee: Float """Distributed Total Room Tax""" distributedTotalRoomTax: Float """Distributed Total Room Tax (as Payee""" distributedTotalRoomTaxAsPayee: Float """Distributed Total Tax""" distributedTotalTax: Float """Distributed Total Tax (as Payee""" distributedTotalTaxAsPayee: Float """District""" district: String """Due Out Y/N""" dueOutYn: String """Dueoutflag""" dueoutflag: String """End Date""" endDate: Date """Endbusinessdate""" endbusinessdate: Date """Extended stay tier of the reservation on the business date. Based on the length of stay and the rate tier configuration if active or OPERA standard rate tiers.""" extendedStayTier: Float """Extra Beds""" extraBeds: Float """Fiscalregioncode""" fiscalregioncode: String """Flagged Food Revenue""" flgdFoodRevenue: Float """Flagged Non Revenue""" flgdNonRevenue: Float """Flagged Other Revenue""" flgdOtherRevenue: Float """Flagged Room Revenue""" flgdRoomRevenue: Float """Flagged Total Food Tax""" flgdTotalFoodTax: Float """Flagged Total Non Revenue Tax""" flgdTotalNonRevenueTax: Float """Flagged Total Other Tax""" flgdTotalOtherTax: Float """Flagged Total Revenue""" flgdTotalRevenue: Float """Flagged Total Room Tax""" flgdTotalRoomTax: Float """Flagged Total Tax""" flgdTotalTax: Float """Food Revenue""" foodRevenue: Float """Food Revenue (as Payee""" foodRevenueAsPayee: Float """Freqflyermembtype""" freqflyermembtype: String """Freqguestmembtype""" freqguestmembtype: String """Group ID""" groupId: Float """Group Profile ID""" groupProfileID: Float """Group Profile Name""" groupProfileName: String """Guest Profile ID""" guestProfileID: Float """Gueststatusid""" gueststatusid: String """House Use Y/N""" houseUseYn: String """Houseuseflag""" houseuseflag: String """Insert Date""" insertDate: DateTime """Companyprofileid""" internalCompanyprofileid: Float """Contactprofileid""" internalContactprofileid: Float """Deleted Flag""" internalDeletedflag: String """Groupprofileid""" internalGroupprofileid: Float """Membershipid""" internalMembershipid: Float """Resv Name ID""" internalReservationNameId: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Market Code""" marketCode: String """Market Description""" marketDescription: String """Market Display Sequence""" marketDisplaySequence: Float """Market Group Code""" marketGroupCode: String """Market Group Description""" marketGroupDescription: String """Market Group Display Sequence""" marketGroupDisplaySequence: Float """Marketgroupid""" marketgroupid: String """Marketid""" marketid: String """Membership Card Number""" membershipCardNo: String """Membership ID""" membershipId: Float """Multiple Occupancy Rooms""" multipleOccupancyRooms: Float """Nationality""" nationality: String """Nationality Code""" nationalityCode: String """Nationalityid""" nationalityid: String """Nights""" nights: Float """Number Show Reservations""" noShowReservations: Float """No-Show Persons""" noShowPersons: Float """No-Show Rooms""" noShowRooms: Float """Non Revenue""" nonRevenue: Float """Non-Revenue (as Payee""" nonRevenueAsPayee: Float """No of Stays""" numberOfStays: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Origin Code""" originCode: String """Origin Description""" originDescription: String """Original End Date""" originalEndDate: Date """Stores the room type associated with the reservation at the moment of booking.""" originalRoomCategory: String """Other Revenue""" otherRevenue: Float """Other Revenue (as Payee""" otherRevenueAsPayee: Float """Number of Rooms marked as Out of Order for today""" outOfOrderRooms: Float """Out of Service Rooms""" outOfServiceRooms: Float """Owner Rental Y/N""" ownerRentalYn: String """Ownerfriendfamilyflag""" ownerfriendfamilyflag: String """Ownerrentalflag""" ownerrentalflag: String """Package Food Revenue""" packageFoodRevenue: Float """Package Food Revenue (as Payee""" packageFoodRevenueAsPayee: Float """Package Non Revenue""" packageNonRevenue: Float """Package Non-Revenue (as Payee""" packageNonRevenueAsPayee: Float """Package Other Revenue""" packageOtherRevenue: Float """Package Other Revenue (as Payee""" packageOtherRevenueAsPayee: Float """Package Room Revenue""" packageRoomRevenue: Float """Package Room Revenue (as Payee""" packageRoomRevenueAsPayee: Float """Parent Company ID""" parentCompanyId: Float """Parentcompanyprofileid""" parentcompanyprofileid: Float """Physical Quantity""" physicalQuantity: Float """Physical Rooms""" physicalRooms: Float """Pr Advance Total Food Tax""" prAdvTotalFoodTax: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Primary Y/N""" primaryYn: Float """Primaryflag""" primaryflag: Float """Profiledailytotalid""" profiledailytotalid: Float """Profileid""" profileid: Float """Promotion Code""" promotionCode: String """Promotion Code Description""" promotionCodeDesc: String """Promotionid""" promotionid: String """Code to uniquely identify the Property""" property: String """Pseudo Room YN""" pseudoRoomYN: String """Pseudoroomflag""" pseudoroomflag: String """Quantity""" quantity: Float """Rate Amount""" rateAmount: Float """Rate Category""" rateCategory: String """Rate Code""" rateCode: String """Ratecategoryid""" ratecategoryid: String """Ratecodeid""" ratecodeid: String """Region Code""" regionCode: String """Regionid""" regionid: String """Reporting Promotion Code""" repPromotionCode: String """Reporting Promotion Code Desc""" repPromotionCodeDescription: String """Reservation Arrivals""" reservationArrivals: Float """Reservation Date""" reservationDate: Date """Reservation Name ID""" reservationNameID: Float """Reservation Nights""" reservationNights: Float """Reservation No of Stays""" reservationNumberOfStays: Float """Reservation Status""" reservationStatus: String """Reservationid""" reservationid: Float """Resvenddate""" resvenddate: Date """Resvinsertsource""" resvinsertsource: String """Resvinsertsourcetype""" resvinsertsourcetype: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Room""" room: String """Room Adults""" roomAdults: Float """Room Category""" roomCategory: String """Room Children""" roomChildren: Float """Room Class""" roomClass: String """Room Nights""" roomNights: Float """Room Reservation Status""" roomReservationStatus: String """Room Revenue""" roomRevenue: Float """Room Revenue (as Payee""" roomRevenueAsPayee: Float """Roomcategoryid""" roomcategoryid: String """Roomclassid""" roomclassid: String """Roomid""" roomid: String """Distributed food revenue generated as staying guest.""" rsAdvFoodRevenue: Float """Distributed food tax generated as staying guest.""" rsAdvFoodTax: Float """Distributed non revenue generated as staying guest.""" rsAdvNonRevenue: Float """Distributed non-revenue tax generated as staying guest""" rsAdvNonRevenueTax: Float """Distributed other revenue generated as staying guest.""" rsAdvOtherRevenue: Float """Distributed other tax generated as staying guest.""" rsAdvOtherTax: Float """Distributed room revenue generated as staying guest.""" rsAdvRoomRevenue: Float """Distributed room tax generated as staying guest.""" rsAdvRoomTax: Float """Distributed total revenue generated as staying guest.""" rsAdvTotalRevenue: Float """Distributed total tax amount generated as staying guest.""" rsAdvTotalTax: Float """Single Occupancy Rooms""" singleOccupancyRooms: Float """Source Code""" sourceCode: String """Source Description""" sourceDescription: String """Source Display Sequence""" sourceDisplaySequence: Float """Source Group Code""" sourceGroupCode: String """Source Group Description""" sourceGroupDescription: String """Source Group Display Sequence""" sourceGroupDisplaySequence: Float """Source Prof ID""" sourceProfId: Float """Source Profile ID""" sourceProfileID: Float """Sourcegroupid""" sourcegroupid: String """Sourceid""" sourceid: String """Sourceprofprofileid""" sourceprofprofileid: Float """State Code""" stateCode: String """Stateid""" stateid: String """Stay Adults""" stayAdults: Float """Stay Children""" stayChildren: Float """Stay Persons""" stayPersons: Float """Total Food Tax""" totalFoodTax: Float """Total Food Tax Generated (as Payee""" totalFoodTaxGeneratedAsPayee: Float """Total Non Revenue Tax""" totalNonRevenueTax: Float """Total Non-Revenue Tax (as Payee""" totalNonRevenueTaxAsPayee: Float """Total Other Tax""" totalOtherTax: Float """Total Other Tax (as Payee""" totalOtherTaxAsPayee: Float """Total Package Revenue""" totalPackageRevenue: Float """Total Package Revenue (as Payee""" totalPackageRevenueAsPayee: Float """Total Revenue""" totalRevenue: Float """Total Revenue (as Payee""" totalRevenueAsPayee: Float """Total Room Tax""" totalRoomTax: Float """Total Room Tax (as Payee""" totalRoomTaxAsPayee: Float """Total Tax""" totalTax: Float """Total Tax (as Payee""" totalTaxAsPayee: Float """Travel Agent Profile ID""" travelAgentProfileID: Float """Travel Agent Profile Name""" travelAgentProfileName: String """Update Date""" updateDate: DateTime """Upsold Revenue""" upsoldRevenue: Float """VIP Status""" vIPStatus: String """Walkin Y/N""" walkinYn: String """Walkinflag""" walkinflag: String """Zipcode Code""" zipCode: String } type ProfilesAccountsSaleProfileOwnerDetailsType { """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: Date """Inactive Flag""" inactiveFlag: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Organization ID""" internalOrganizationId: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """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 """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 """Sale Profile Owner ID""" saleProfileOwnerId: Float """To Type""" toType: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float """User ID""" userId: Float } type ProfilesAccountsBlockDetailsType { """Action ID""" actionId: Float """Actual Average Room Rate""" actualAverageRoomRate: Float """Actual F&B Revenue""" actualFBRevenue: Float """Other revenue""" actualOtherRevenue: Float """Actual Room Nights Sold""" actualRoomNightsSold: Float """Actual revenue of the room""" actualRoomRevenue: Float """Add Info""" addInfo: String """Agent Contact Name ID""" agentContactNameId: Float """Agent Name ID""" agentNameId: Float """Agentprofileid""" agentprofileid: Float """All Aliases""" allAliases: String """All Block Owners""" allBlockOwners: String """All Catering Owners""" allCateringOwners: String """All Company Contacts""" allCompanyContacts: String """All Rate Codes""" allRateCodes: String """All Room Owners""" allRoomOwners: String """All Room Pools""" allRoomPools: String """All Room Types""" allRoomTypes: String """All Source Contacts""" allSourceContacts: String """All Travel Agent Contacts""" allTravelAgentContacts: String """Allotment Origin""" allotmentOrigin: String """Type of Block alloted for the group.""" allotmentType: String """Allotmentcurrencyid""" allotmentcurrencyid: String """Block ID""" allotmentid: Float """Allow a pickup for a group with this booking status""" allowPickup: String """Multi Byte Description Field""" alternateBlockName: String """Alternate Dates""" alternateDates: String """Arrival Time""" arrivalTime: DateTime """URL pointing to Lead Attachments.""" attachmentURL: String """Attendees Guaranteed""" attendeesGuaranteed: Float """Indicates if forecast figures should be automatically loaded for this business block.""" autoLoadForecastYn: String """Average Rate""" averageRate: Float """Date when the BEO report was last printed for this business block.""" bEOLastPrint: DateTime """Stores the original block begin date. Any date ealier will be treated as a Shoulder date.""" beginDateOriginal: Date """Block Alias""" blockAlias: String """Block Code""" blockCode: String """Block Date Actual""" blockDateActual: Date """Block Date Definite""" blockDateDefinite: DateTime """Block Date Prospect""" blockDateProspect: DateTime """Block Date Tentative""" blockDateTentative: DateTime """Block Description""" blockDescription: String """Block ID""" blockID: Float """Classifies this allotment record: MASTER_ALLOCATION SUB_ALLOCATION SUB_BOOKING SUB_TOUR SUB_ITINERARY""" blockMode: String """Block Owner Code""" blockOwnerCode: String """Block Owner Full Name""" blockOwnerFullName: String """Block Package""" blockPackage: String """Block Package Description""" blockPackageDescription: String """Block Status""" blockStatus: String """Block Status Description""" blockStatusDescription: String """Block Type Code""" blockTypeCode: String """Block Type Code Description""" blockTypeCodeDescription: String """Blockpackageid""" blockpackageid: String """External S&C vendor booking ID and used in HYATT-mode.""" bookingId: String """Booking Method Order By""" bookingMethodOrderBy: Float """Booking Status Order""" bookingStatusOrder: Float """Determines block being [G] - Group or [W] - Wholesale.""" bookingType: String """Booking Type Description""" bookingTypeDescription: String """Bookingmethod Inactive Date""" bookingmethodInactiveDate: Date """Bookingsourceid""" bookingsourceid: String """Bookingstatusid""" bookingstatusid: String """Bookingtypeid""" bookingtypeid: String """Breakfast Description""" breakfastDescription: String """PCR: The estimated breakfast price for this ratecode.""" breakfastInclPrice: Float """PCR: Is breakfast is included in this rate code?""" breakfastInclYn: String """Breakfast Included""" breakfastIncluded: String """Breakfast Price""" breakfastPrice: Float """BWI eLeadID for tracking purposes.""" bwiLeadId: String """URL populated bu CRS.""" bwiUrl: String """Central Bfst Incl Price""" cBreakfastInclPrice: Float """Central Bfst Price""" cBreakfastPrice: Float """Central Comp Room Value""" cCompRoomValue: Float """Central Dbl Rm Supplement Price""" cDoubleRoomSupplementPrice: Float """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Fb Commission 1""" cFBCommission1: Float """Central Fb Commission 2""" cFBCommission2: Float """Central Porterage Price""" cPorteragePrice: Float """Central Rm Commission 1""" cRoomCommission1: Float """Central Rm Commission 2""" cRoomCommission2: Float """Central Service Charge""" cServiceCharge: Float """Central Service Fee""" cServiceFee: Float """CRS Guaranteed Y/N""" cRSGtdYn: String """Not Used""" cancelRule: String """Canceldestinationid""" canceldestinationid: String """Cancellation Destination""" cancellationDestination: String """Cancellation Destination Description""" cancellationDestinationDescription: String """Cancellation Number""" cancellationNumber: Float """Cancellation Penalty Amount""" cancellationPenaltyAmount: Float """Cancellationreasonid""" cancellationreasonid: String """Catering Cutoff""" catCutoff: Date """Cat Date Prospect""" catDateProspect: DateTime """Catering Owner""" catOwner: Float """Property of Catering Owner""" catOwnerProperty: String """Cat Return To Inventory""" catReturnToInventory: String """Cat Starting Status""" catStartingStatus: String """Catcurrencyid""" catcurrencyid: String """Catering Cancellation Date""" cateringCancellationDate: Date """Catering Cancellation Description""" cateringCancellationDescription: String """Catering Cancellation Number""" cateringCancellationNumber: Float """Catering Cancellation Reason""" cateringCancellationReason: String """Catering Currency""" cateringCurrency: String """Catering Date Actual""" cateringDateActual: Date """Catering Decision Date""" cateringDecisionDate: Date """Catering Deduct Inventory""" cateringDeductInventory: String """Catering Exchange Rate""" cateringExchangeRate: Float """Catering Followup Date""" cateringFollowupDate: Date """Catering only Revenue.""" cateringOnlyYN: String """Catering Order By""" cateringOrderBy: Float """Catering Owner Code""" cateringOwnerCode: String """Catering Owner Full Name""" cateringOwnerFullName: String """Catering Pkgs Y/N""" cateringPkgsYn: String """Catering Quote Currency""" cateringQuoteCurrency: String """Catering Status""" cateringStatus: String """Catering Status Color""" cateringStatusColor: String """Catering Status Description""" cateringStatusDescription: String """Catering Status Type describes Inventory behaviour""" cateringStatusType: String """Cateringcancelreasonid""" cateringcancelreasonid: Float """Cateringcurrencyid""" cateringcurrencyid: String """Catering Owner Employee ID""" cateringowneremployeeid: Float """Catering Quote Currency ID""" cateringquotecurrencyid: String """Cateringstatusid""" cateringstatusid: String """Cenral FB Revenue""" cenralFBRevenue: Float """Central Actual Average Room Rate""" centralActualAverageRoomRate: Float """Central Actual FB Revenue""" centralActualFBRevenue: Float """Central Actual Other Revenue""" centralActualOtherRevenue: Float """Central Actual Room Revenue""" centralActualRoomRevenue: Float """Central Average Room Rate""" centralAverageRoomRate: Float """Central Block Package""" centralBlockPackage: String """Central Block Package Description""" centralBlockPackageDescription: String """Central Block Status""" centralBlockStatus: String """Central Block Status Description""" centralBlockStatusDescription: String """Central Block Type Code""" centralBlockTypeCode: String """Central Block Type Code Description""" centralBlockTypeCodeDescription: String """Central Booking Type""" centralBookingType: String """Central Booking Type Description""" centralBookingTypeDescription: String """Central Cancellation Destination""" centralCancellationDestination: String """Central Cancellation Destination Description""" centralCancellationDestinationDescription: String """Central Cancellation Penalty Amount""" centralCancellationPenaltyAmount: Float """Central Catering Status""" centralCateringStatus: String """Central Catering Status Description""" centralCateringStatusDescription: String """Central Conversion Code""" centralConversionCode: String """Central Coversion Code Description""" centralCoversionCodeDescription: String """Central Industry Code""" centralIndustryCode: String """Central Industry Code Description""" centralIndustryCodeDescription: String """Central Items for this Block""" centralItemsForThisBlock: String """Central Market Description""" centralMarketDescription: String """Central Market code""" centralMarketCode: String """Central Meeting Budget""" centralMeetingBudget: Float """Central Meeting Revenue""" centralMeetingRevenue: Float """Central Origin Code""" centralOriginCode: String """Central Origin Code Description""" centralOriginCodeDescription: String """Central Other Revenue""" centralOtherRevenue: Float """Stores the name and phone number of the primary central owner.""" centralOwner: String """Central Payment""" centralPayment: String """Central Payment Description""" centralPaymentDescription: String """Central Ranking Code""" centralRankingCode: String """Central Ranking Code Description""" centralRankingCodeDescription: String """Central Reservation Method Code""" centralReservationMethodCode: String """Central Reservation Method Description""" centralReservationMethodDescription: String """Central Reservation Type""" centralReservationType: String """Central Reservation Type Description""" centralReservationTypeDescription: String """Central Room Revenue""" centralRoomRevenue: Float """Central Source Code""" centralSourceCode: String """Central Source Code Description""" centralSourceCodeDescription: String """Central Tax Amount""" centralTaxAmount: Float """Chain Code""" chainCode: String """Channelid""" channelid: String """Code""" code: String """Communication Address for Contact 1 (E-mail / Fax #)""" comAddress: String """Communication Address for Contact 2 (E-mail / Fax #)""" comAddress2: String """Communication Address for Contact 3 (E-mail / Fax #)""" comAddress3: String """How this lead is to be sent. [EMAIL|FAX|PRINT]""" comMethod: String """How this lead is to be sent. [EMAIL|FAX|PRINT|DATA]""" comMethod2: String """How this lead is to be sent. [EMAIL|FAX|PRINT|DATA]""" comMethod3: String """Commission Amount""" commissionAmount: String """PCR: Commissionable Percentage.""" commissionablePerc: Float """Commissionable Y/N""" commissionableYn: String """Complimentary Rooms based per Stay (Y) or per Night (N)""" compPerStayYn: String """Complimentary Rooms: Value given to Customer""" compRoomValue: Float """Number of complimentary Rooms""" compRooms: Float """Complimentary Rooms: Fixed amount (Y) or calculated (N)""" compRoomsFixedYn: String """Company All""" companyAll: String """Company Name ID""" companyNameId: Float """Companyprofileid""" companyprofileid: Float """Competition""" competition: String """Contact Name ID""" contactNameId: Float """Contactprofileid""" contactprofileid: Float """Contract Number""" contractNumber: String """Control Block Y/N""" controlBlockLocally: String """Conversion Code""" conversionCode: String """Coversion Code Description""" coversionCodeDescription: String """The name of the user who created the record.""" createdBy: String """Created Date""" createdDate: DateTime """Indicates if the block was created as an Opportunity""" createdAsOpportunityYN: String """Credit Card ID""" creditCardId: Float """Currency""" currency: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Date Acl""" dateAcl: Date """Date Cfl""" dateCfl: Date """Date Definite""" dateDefinite: DateTime """Date Lsl""" dateLsl: Date """Date Opened for Pickup""" dateOpenedForPickup: Date """Date Pel""" datePel: DateTime """Date Tdl""" dateTdl: DateTime """Date Tentative""" dateTentative: DateTime """Stores the double room supplement price.""" dblRoomSupplementPrice: Float """Deduct the reservations with this booking status from the inventory""" deductInventory: String """Defualt Posting Master ID""" defaultPmReservationNameId: Float """Deleted Flag""" deletedflag: String """Departure Time""" departureTime: DateTime """Description""" description: String """Distributed""" distributed: String """Timestamp of the last date/time the distributed_yn flag was set to Y.""" distributedDate: DateTime """Dml Sequence No""" dmlSeqNumber: Float """Stores the double room supplement.""" doubleRoomSupplementYN: String """Download Date""" downloadDate: Date """Download Property""" downloadResort: String """Download Srep""" downloadSrep: Float """Due Date""" dueDate: Date """Due Date Sorting Column.""" dueDateOrd: Date """End Date""" endDate: Date """Stores the original block End date. Any date later will be treated as a Shoulder date.""" endDateOriginal: Date """Endbusinessdate""" endbusinessdate: Date """Event Attendees""" eventAttendees: Float """Exchange Posting Type""" exchangePostingType: String """Exchange Rate""" exchangeRate: Float """The message that will pop up if the block is excluded (not allowed) to modify/create reservation/cancel reservation.""" exclusionMessage: String """External Reference""" externalReference: String """External RFP ID.""" externalRfpId: String """External RFP System Identification Code.""" externalRfpSystem: String """Externally Locked""" externallyLocked: String """Projected F&B Revenue.""" fBRevenue: Float """Currency code for the F&B Agendas attached to the business block.""" fbAgendaCurrency: String """stores FB commission for Agent 1""" fbCommission1: Float """stores FB commission for Agent 2""" fbCommission2: Float """Operation Mode for FIT Contracts [ SFA=SFA control RC=Ratecode RA=RateAmounts ]""" fitContractMode: String """Fit Discount Level.""" fitDiscountLevel: Float """Published Corporate Rate: Discount Percentage.""" fitDiscountPerc: Float """Fitdiscounttype""" fitdiscounttype: String """Determines if rate check is done for Occ1 or Occ1 and Additional Rate.""" flatRateYn: String """Followup Date""" followupDate: Date """Can the Function space booked under master allocation or master block be overbooked by sub-allocations or sub-blocks ?""" fsOverbookingYn: String """Function Type""" functionType: String """Group IATA Number.""" giid: String """Greek Contract Number.""" greekContractNr: String """Group Account ID""" groupAccountID: Float """Guaranteecodeid""" guaranteecodeid: String """Rate Guaranteed Y/N.""" guaranteedRate: String """Guaranteed YN""" guaranteedYN: String """Hideacctinfoflag""" hideacctinfoflag: String """SCH Mode: Number of days before the arrival date a reservation can be canceled without losing the deposit.""" hlxCanxNoticeDays: Float """SCH Mode: Determines if Travel Agent commission will be paid on reservations booked through the HOLIDEX Plus TACP program.""" hlxCommissionableYn: String """SCH Mode: All Description DD Secured.""" hlxDdSecuredYn: String """SCH Mode: Number of Days Deposit due to guarantee the guest booking.""" hlxDepositDays: Float """SCH Mode: Secured from DI Display.""" hlxDiSecuredYn: String """SCH Mode: Housing Information Secured.""" hlxHousinginfoSecuredYn: String """SCH Mode: Rates Secured from All Displays""" hlxRateAllSecuredYn: String """SCH Mode: Rates Secured from GNR.""" hlxRatesGnrSecuredYn: String """SCH Mode: Return One Day at a time.""" hlxReturnEachDayYn: String """Inactive Date""" inactiveDate: Date """Inactive Flag""" inactiveflag: String """Indicates the Non-Compete code of a block.""" industryCode: String """Industry Code Description""" industryCodeDescription: String """Not Used""" info: String """Information Board""" informationBoard: String """Insert User""" insertUser: Float """Inventory Control""" inventoryControl: String """Inventory Cut-Off Date""" inventoryCutOffDate: Date """Inventory Cut-Off Days""" inventoryCutOffDays: Float """STAR MODE: ISAC opportunity ID.""" isacOpptyId: String """Items""" items: String """Items for this Block""" itemsForThisBlock: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """If set to ?Y? lead will not be converted to booking upon lead sending.""" keepLeadControlYN: String """Laptop Change""" laptopChange: Float """Lead Origin""" leadOrigin: String """Lead Sent YN""" leadSentYN: String """Lead Source""" leadSource: String """Lead Type""" leadType: String """Indication that the Property has updated the Lead Information will prevent further SFA updates.""" leadchangeBypropertyYn: String """Leaderrorflag""" leaderrorflag: String """Leadisnewflag""" leadisnewflag: String """Leadoriginid""" leadoriginid: String """Leadreceivedflag""" leadreceivedflag: String """Name of Contact 1 (Free text or from RESORT_CONTACTS)""" leadsend: String """Name of Contact 2 (Free text or from RESORT_CONTACTS)""" leadsend2: String """Name of Contact 3 (Free text or from RESORT_CONTACTS)""" leadsend3: String """Leadserverpendingflag""" leadserverpendingflag: String """Leadsourceid""" leadsourceid: String """Leadstatus""" leadstatus: String """STAR MODE: Date when the OPERA block was linked to an ISAC opportunity.""" linkDate: Date """Internal ID to uniquely identify the Property""" locationID: String """Competitor to whom the booking was lost.""" lostTo: String """Mainmarket""" mainmarket: String """Mainmarketid""" mainmarketid: String """Block was cutoff manullay""" manuallyCutoffYN: String """MARRIOTT mode: Marsha Event Type.""" marEventType: String """MARRIOTT mode: Marsha column for Housing Protected.""" marHouseProtectYn: String """MARRIOTT mode: Specifies if the Marsha block has a rolling end date.""" marRollEndDateYn: String """Market Code""" marketCode: String """Market Description""" marketDescription: String """Marketid""" marketid: String """Parent Block ID""" masterBlockID: Float """Parent Resort""" masterBlockProperty: String """Profile Id. ( Name_Id ) of the Group Profile attached to this business block.""" masterNameId: Float """Meeting Budget""" meetingBudget: Float """Meeting Revenue for SFA""" meetingRevenue: Float """Offset Type""" offsetType: String """Order By""" orderBy: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Stores the original ALLOTMENT_HEADER_ID prior to a migration.""" origAllotmentHeaderId: Float """Origin Code""" originCode: String """Origin Code Description""" originCodeDescription: String """Original Block Start Date used as identifier in the HOLIDEX interface.""" originalBeginDateHolidex: Date """Original End Date""" originalEndDate: Date """Not used""" originalRateCode: String """Original Start Date""" originalStartDate: Date """Originalratecodeid""" originalratecodeid: String """ORMS Block Class""" ormsBlockClass: String """ORMS Final Block""" ormsFinalBlock: String """Reason for which a review of the ORMS forecast is required. If the value is null it means forecast has been reviewed. If the value is Forecast increased (FI) Forecast decreased (FD) Blocked Rooms increased (BRI) Blocked Rooms decreased (BRD) New block (NB) User required review (URR) then it means forecast has not been reviewed.""" ormsForecastReviewReason: String """ORMS Transient Block""" ormsTransientBlock: String """Projected Other Revenue.""" otherRevenue: Float """Owner""" owner: Float """Owner Property""" ownerResort: String """Owneremployeeid""" owneremployeeid: Float """Ownerlocationd""" ownerlocationd: String """Parentallotmentid""" parentallotmentid: Float """Payment""" payment: String """Payment Description""" paymentDescription: String """Paymentmethodid""" paymentmethodid: String """Persons Per Room""" personsPerRoom: Float """Porterage Included""" porterageIncluded: String """Porterage Price""" porteragePrice: Float """Pot Average Room Rate""" potAverageRoomRate: Float """Pot FB Revenue1""" potFbRevenue1: Float """Pot Other Revenue1""" potOtherRevenue1: Float """Projected Room Nights.""" potRoomNights: Float """Pot Room Revenue1""" potRoomRevenue1: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Print Rate""" printRate: String """Profile ID""" profileId: Float """Program""" program: String """Code to uniquely identify the Property""" property: String """Indicates if events in webProposal should be combined in the generated XML.""" proposalCombineEventsYn: String """Decision Date Selection: [R]ooms Decision Date / [C]atering Decision Date.""" proposalDecisionSelection: String """Stores the user choice for either [R]ooms or [C]atering follow-up date to be passed to webProposal. NULL is treated as Rooms follow-up date.""" proposalFollowupSelection: String """If Y then Alternate Names will be used in the webProposal XML tags for and .""" proposalInclAltNamesYn: String """Owner Selection: [O]verall Owner / [R]ooms Owner / [C]atering Owner.""" proposalOwnerSelection: String """Proposal Sent Date""" proposalSentDate: DateTime """Show price per event on webProposal.""" proposalShowEventpriceYn: String """Show PMS roomtypes on webProposal otherwise S&C roomtypes are shown.""" proposalShowPmsRoomTypeYn: String """Show function space names on webProposal.""" proposalShowSpacenameYn: String """Unit of measurement used for function spaces in webProposal XML. Possible values: METRIC IMPERIAL or NONE.""" proposalSpaceMeasurement: String """Proposal View Token""" proposalViewToken: String """Indicates that negotiated rates need to be published.""" publishRatesYn: String """Indicates the ranking of a block.""" rankingCode: String """Ranking Code Description""" rankingCodeDescription: String """Rate Code""" rateCode: String """Indicates if the rate code can be overridden.""" rateOverride: String """Reason why the rate code was overridden used for FIT Contracts.""" rateOverrideReason: String """Indicates that a Rate Protection exists for this booking: [A]ll [S]ome [N]one. No other group can be booked using rates lower than the one that is flagged as rate protect.""" rateProtect: String """Rate Tier""" rateTier: Float """Ratecodeid""" ratecodeid: String """Ready for Distribution""" readyForDistribution: String """Indicates if a lead has been regenerated (copied and lost) by the system and differentiates between leads that have been lost by the user or due to changes to the lead master.""" regeneratedLeadYn: String """Rep Bookingmethod Orderby""" repBookingmethodOrderby: Float """Rep Bs Order By""" repBsOrderBy: Float """Rep Cat Order By""" repCatOrderBy: Float """Reply Date""" replDate: DateTime """Reply Communication Method""" replVia: String """Lead Replystatus [ACL|TDL]""" replstatus: String """Reply By""" replyBy: Float """Representative""" representative: String """Reservation Method""" reservationMethod: String """Reservation Type""" reservationType: String """The Description of the Guarantee code.""" reservationTypeDescription: String """Reservationid""" reservationid: Float """Reserve Inventory YN""" reserveInventoryYN: String """Final resort where Booking is confirmed -via Lead process.""" resortBooked: String """Default discount percentage applied to catering items.""" resourceDiscountPercent: Float """Response Time.""" respTime: Float """The unit of time (from UNIT_OF_TIME table).""" respTimeCode: String """Return the reservations with this booking status from the inventory""" returnToInventory: String """Not used""" rivMarketSegment: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """stores Rooms commission for Agent 1""" roomCommission1: Float """stores Rooms commission for Agent 2""" roomCommission2: Float """Room Nights Sold""" roomNightsSold: Float """Room Owner Code""" roomOwnerCode: String """Room Owner Full Name""" roomOwnerFullName: String """Projected Room Revenue.""" roomRevenue: Float """Transaction Code for posting room revenue from blocked reservations.""" roomRevenueTransactionCode: String """Room Status""" roomStatus: String """Rooming List Due""" roomingListDue: Date """Stores Rooming List Rules.""" roomingListRules: String """Rooms Cancellation Date""" roomsCancellationDate: Date """Rooms Cancellation Reason""" roomsCancellationReason: String """Rooms Cancellation Reason Description""" roomsCancellationReasonDescription: String """Rooms Currency""" roomsCurrency: String """Rooms Decision Date""" roomsDecisionDate: Date """Rooms Exchange Rate""" roomsExchangeRate: Float """Rooms Owner""" roomsOwner: Float """Property of Rooms Salesmanager""" roomsOwnerResort: String """Rooms Per Day""" roomsPerDay: Float """Rooms Quote Currency""" roomsQuoteCurrency: String """Roomsowneremployeeid""" roomsowneremployeeid: Float """Not used""" salesId: String """Sbegindate""" sbegindate: Date """Quote ID reference for the last printed catering quote report (S&C Quotation Report).""" scQuoteId: String """Sell Thru Indicator.""" sellThruYn: String """Identifies if a business block needs to be send to Central based on KEY_PROFILE_YN in NAME.""" sendToCentralYn: String """Senddate""" senddate: Date """Sent By""" sentBy: Float """Sent Date""" sentDate: DateTime """Sent Via""" sentVia: String """Service Charge""" serviceCharge: Float """Service Fee Amount per room/night""" serviceFee: Float """Service Fee applies?""" serviceFeeYn: String """PCR: Are Service Charges included in this rate code?""" serviceInclYn: String """Service Percentage included.""" servicePerc: Float """Shoulder End""" shoulderEnd: Date """Shoulder Start""" shoulderStart: Date """Flag used to show or hide rate column in Block Grid and used as default by block reservations.""" showRateAmountYN: String """Snapshot has been created""" snapshotSetup: String """Source Code""" sourceCode: String """Source Code Description""" sourceCodeDescription: String """Source Contact All""" sourceContactAll: String """Source Name ID""" sourceNameId: Float """Sourceid""" sourceid: Float """Sourceprofprofileid""" sourceprofprofileid: Float """Start Date""" startDate: Date """Booking starting status (intial pickup)""" startingStatus: String """Status""" status: String """Status Color""" statusColor: String """Type of booking status (initial)""" statusType: String """Sub Allocation YN""" subAllocationYN: String """Super Search Index Text""" superSearchIndexText: String """Suppress Rate""" suppressRate: String """Indicates if original grid will be copied to contract grid. Performed in the allotment_detail trigger.""" syncContractYn: String """Synchronize Sub-Blocks with Master Block if Y""" synchronize: String """Tax Amount""" taxAmount: Float """Percentage of included Tax.""" taxIncludedPerc: Float """Tax is included in this rate.""" taxIncludedYn: String """Tax Type""" taxType: String """Taxtypeid""" taxtypeid: String """To be Determined Rates""" tbdRates: String """Tdl Reason""" tdlReason: String """Not used""" tentativeLevel: Float """Stores the TLPe - Response ID""" tlpResponseid: String """Stores the TLPe - Result URL.""" tlpUrl: String """Tour Code.""" tourCode: String """Trace Code""" traceCode: String """Trace Description""" traceDescription: String """Indicate that no other block of the same industry can be booked for the selected dates.Non-Compete indicator : [A]ll [S]ome [N]one.""" trackChangesYN: String """Travel Agent All""" travelAgentAll: String """Travel Agent Record Locator""" travelAgentRecordLocator: String """Turndownreasonid""" turndownreasonid: Float """UDFC01""" uDFC01: String """UDFC02""" uDFC02: String """UDFC03""" uDFC03: String """UDFC04""" uDFC04: String """UDFC05""" uDFC05: String """UDFC06""" uDFC06: String """UDFC07""" uDFC07: String """UDFC08""" uDFC08: String """UDFC09""" uDFC09: String """UDFC10""" uDFC10: String """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 """Not in use.""" ualias: String """This is upper-case description of regular description column for fast search""" udescription: String """Update Date by LEAD REPLY.""" updateDateExternal: Date """Update User""" updateUser: Float """Updated By""" updatedBy: String """Updated Date""" updatedDate: DateTime """Upload Date""" uploadDate: Date """Indicates if this business block can be booked via the web (OWS).""" webBookable: String """Indicates if this business block allows overbooking when rooms are available on the non-deduct block grid even if there are no rooms available on the house level.""" webOverbookYN: String """Multi Byte Description in uppercase""" xudescription: String }