# title : OPERA Cloud RnA ProfilesNotes GraphQL API,
# description : GraphQL API to cater for Profile note types and note details, including internal and confidential flags, and the profile details they are associated with.
#               Compatible with OPERA Cloud RnA release 26.1.0.0.
#               This document and all content within is available under the Universal Permissive License v 1.0 
#               (https://oss.oracle.com/licenses/upl). Copyright (c) 2020,2026 Oracle and/or its affiliates
# version : 26.1.0.0
# termsOfService : https://www.oracle.com/legal/terms.html
# contact_email : hospitality_apis_ww_grp@oracle.com
# license : https://opensource.org/licenses/upl

directive @stream(if: Boolean, label: String, initialCount: Int = 0) on FIELD
directive @conditionalInputPair(pair: Int) on INPUT_FIELD_DEFINITION
directive @mandatoryInput on INPUT_FIELD_DEFINITION
scalar Date
scalar DateTime

# Date format: "YYYY-MM-DD"
input DateInput{
  _eq: Date
  _ne: Date
  _in: [Date]
  _nin: [Date]
  _gt: Date
  _lt: Date
  _gte: Date
  _lte: Date
  _btn: DateRangeInput
  _isNull: Boolean
}
input DateRangeInput {
  start: Date!
  end: Date!
}

# Datetime format: "YYYY-MM-DD HH24:MI:SS"
input DateTimeInput {
  _eq: DateTime
  _ne: DateTime
  _in: [DateTime]
  _nin: [DateTime]
  _gt: DateTime
  _lt: DateTime
  _gte: DateTime
  _lte: DateTime
  _btn: DateTimeRangeInput
  _isNull: Boolean
}
input DateTimeRangeInput {
  start: DateTime!
  end: DateTime!
}

input StringInput {
  _eq: String
  _ne: String
  _in: [String]
  _nin: [String]
  _gt: String
  _lt: String
  _gte: String
  _lte: String
  _isNull: Boolean
}

input FloatInput {
  _eq: Float
  _ne: Float
  _in: [Float]
  _nin: [Float]
  _gt: Float
  _lt: Float
  _gte: Float
  _lte: Float
  _btn: FloatRangeInput
  _isNull: Boolean
}
input FloatRangeInput {
  start: Float!
  end: Float!
}

# Mandatory filters:
# The following filters are mandatory required filters. 
# Please ensure the request includes all the below fields. 
# 		 - profilenoteDetailsChainCode


input ProfilesNotesQueryArgumentsType {
  """Activity Due Date"""
  profilenoteDetailsActionDueDate: DateInput
  """Activity Type"""
  profilenoteDetailsActionType: StringInput
  """ASP chain code."""
  profilenoteDetailsChainCode: StringInput!                             @mandatoryInput
  """Indicates if this note is confidential."""
  profilenoteDetailsConfidentialYn: StringInput
  """The user that created the record"""
  profilenoteDetailsInsertUser: FloatInput
  """The date the record was created"""
  profilenoteDetailsInsertDate: DateTimeInput
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  profilenoteDetailsDsi: FloatInput
  """Deleted Flag"""
  profilenoteDetailsDeletedFlag: StringInput
  """Unique ID in External System."""
  profilenoteDetailsExternalNoteId: StringInput
  """Global Note Y/N"""
  profilenoteDetailsGlobalNoteYn: StringInput
  """Can a global note be created for this note code or not."""
  profilenoteDetailsGlobalYn: StringInput
  """Inactive date of the record. This indicates that record is no longer in use and can be purged in by purge routine."""
  profilenoteDetailsInactiveDate: DateInput
  """Inactive Flag"""
  profilenoteDetailsInactiveFlag: StringInput
  """Deleted Flag"""
  profilenoteDetailsDeletedflag: StringInput
  """Inactive Flag"""
  profilenoteDetailsInactiveflag: StringInput
  """Location Id"""
  profilenoteDetailsLocationId: StringInput
  """Organization ID"""
  profilenoteDetailsOrganizationId: FloatInput
  """JRN Update Date and Time"""
  profilenoteDetailsJrnupdatedttm: DateTimeInput
  """Indicator for Laptop change."""
  profilenoteDetailsLaptopChange: FloatInput
  """Internal ID to uniquely identify the Property"""
  profilenoteDetailsLocationid: StringInput
  """Parent Name_id refers Name table."""
  profilenoteDetailsNameId: FloatInput
  """The type of Profile."""
  profilenoteDetailsNameType: StringInput
  """Indicates the Type of Note."""
  profilenoteDetailsNoteCode: StringInput
  """Description of Note Code"""
  profilenoteDetailsNoteCodeDescription: StringInput
  """Primary Key for the Table"""
  profilenoteDetailsNoteId: FloatInput
  """Indicates if this note should be shown to guest. Future use."""
  profilenoteDetailsInternalYn: StringInput
  """Title of the Note"""
  profilenoteDetailsNoteTitle: StringInput
  """The actual Note."""
  profilenoteDetailsNotes: StringInput
  """Internal ID to uniquely identify the Organization"""
  profilenoteDetailsOrganizationid: FloatInput
  """Internal Primary Key ID to uniquely identify the row"""
  profilenoteDetailsPkid: FloatInput
  """Parent Name_id refers Name table."""
  profilenoteDetailsProfileId: FloatInput
  """Profile Note ID"""
  profilenoteDetailsProfileNoteId: FloatInput
  """Property"""
  profilenoteDetailsResort: StringInput
  """RnA Insertdate"""
  profilenoteDetailsRnaInsertdate: DateTimeInput
  """RnA Updatedate"""
  profilenoteDetailsRnaUpdatedate: DateTimeInput
  """The date the record was modified"""
  profilenoteDetailsUpdateDate: DateTimeInput
  """The user that modified the record"""
  profilenoteDetailsUpdateUser: FloatInput
  """The primary key for this table."""
  profileallDetailsNameId: FloatInput
  """Profile is active or not."""
  profileallDetailsActiveYn: StringInput
  """This is a  name_id (Profile number) of profiles that exist in a Central database in a typical CRS environment."""
  profileallDetailsCrsNameid: FloatInput
  """Chain Code"""
  profileallDetailsChainCode: StringInput
  """The unique key of this name stores IATA# Company # etc."""
  profileallDetailsNameCode: StringInput
  """The company group or company group user ID in hierarchical format"""
  profileallDetailsCompanyGroupId: StringInput
  """Used in S&C Module."""
  profileallDetailsContactFlag: StringInput
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  profileallDetailsDsi: FloatInput
  """Direct Bill Batch Type"""
  profileallDetailsDirectBillBatchType: StringInput
  """The last name of the individual Profile and Search name ofr the other Types of Profiles (Group Travel Agent & Source) are stored in this column."""
  profileallDetailsLast: StringInput
  """Keep guest in history Y/N"""
  profileallDetailsHistoryYn: StringInput
  """The date the record was marked as inactive"""
  profileallDetailsInactiveDate: DateTimeInput
  """Index Name"""
  profileallDetailsIndexName: StringInput
  """Organization ID"""
  profileallDetailsOrganizationId: FloatInput
  """JRN Update Date and Time"""
  profileallDetailsJrnupdatedttm: DateTimeInput
  """The type of Profile."""
  profileallDetailsNameType: StringInput
  """Internal ID to uniquely identify the Organization"""
  profileallDetailsOrganizationid: FloatInput
  """The primary key for this table."""
  profileallDetailsProfileId: FloatInput
  """The type of Profile."""
  profileallDetailsProfileType: StringInput
  """Resort for which Job is registered."""
  profileallDetailsResortRegistered: StringInput
  """This column store the Name of the Company Profiles."""
  profileallDetailsCompany: StringInput
  """The Uppercase value of Last or Company."""
  profileallDetailsSname: StringInput
  """Internal Indexed field for Searching by Extended Byte Name."""
  profileallDetailsSxname: StringInput
  """Uppercase value of First Name."""
  profileallDetailsSfirst: StringInput
  """Used in QMS Module"""
  profileallDetailsSrepCode: StringInput
  """Internal Indexed field for Searching by Extended Byte First Name."""
  profileallDetailsSxfirstName: StringInput
  """The date the record was modified"""
  profileallDetailsUpdateDate: DateTimeInput
}
type Query {
  """Profile note types and note details including internal and confidential flags and the profile details they are associated with."""
  profilesNotes(limit: Int offset: Int input: ProfilesNotesQueryArgumentsType!): [ProfilesNotesType]
}
type ProfilesNotesType {
  """Profile Note Details"""
  profileNoteDetails: ProfilesNotesProfileNoteDetailsType
  """Profile All Details"""
  profileAllInformationDetails: ProfilesNotesProfileAllInformationDetailsType
  profilesNotesRecordCount: Int
}
type ProfilesNotesProfileNoteDetailsType {
  """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 ProfilesNotesProfileAllInformationDetailsType {
  """The primary key for this table."""
  guestProfileID: Float
  """Account number."""
  aRNumber: String
  """Account Receivable No. of this profile."""
  aRNumberCentral: String
  """Indicates if a Credit Limit amount on Profile level will be required."""
  aRCreditLimitYN: String
  """The ARC mailing flag (received from ARC Update program)"""
  aRCMailFlag: String
  """The ARC office type (received from ARC Update program)"""
  aRCOfficeType: String
  """The date this record was last updated by the ARC update program."""
  aRCUpdateDate: Date
  """Billing contact person in company."""
  accountBillingContact: String
  """Used in S&C Module."""
  accountSource: String
  """Account Type of this Profile"""
  accountType: String
  """The description of this value."""
  accountTypeDescription: String
  """The description of this value."""
  accountsourceDesc: String
  """Mailing action codes."""
  actionCode: String
  """Profile is active or not."""
  activeYN: String
  """The first line of street address."""
  address1: String
  """The second line of street address."""
  address2: String
  """The third line of street address."""
  address3: String
  """The fourth line of street address."""
  address4: String
  """The primary key for this table."""
  addressId: Float
  """Description for each language code."""
  addressLangCodeDesc: String
  """Address Language Code"""
  addressLanguageCode: String
  """The type of address."""
  addressType: String
  """Country Specific Requirement for Nigeria."""
  alienRegistrationNo: String
  """All Resorts"""
  allResorts: String
  """Field which stores the multibyte envelop greeting used in S&C"""
  alternateEnvelopeGreeting: String
  """The Extended Byte Language of the Profile."""
  alternateLanguage: String
  """Description for each language code."""
  alternateLanguageDescription: String
  """Alternate Salutation"""
  alternateSalutation: String
  """Auto-Enroll Member YN"""
  autoEnrollMemberYN: String
  """Does profile have Availability Override Y/N"""
  availabilityOverride: String
  """The billing code for this name record."""
  billingCode: String
  """Billing Instruction"""
  billingInstruction: String
  """For tour operators the type of billing profile for this name."""
  billingProfileCode: String
  """Country of Birth"""
  birthCountry: String
  """Date of Birth of the Individual Profiles."""
  birthDate: Date
  """Stores the encrypted birth date."""
  birthDateStr: String
  """Place of Birth"""
  birthPlace: String
  """Any Message for the Restricted profile."""
  blMsg: String
  """Used in S&C Module."""
  businessSegment: String
  """The description of this value."""
  businessSegmentDescription: String
  """The business title for this individual."""
  businessTitle: String
  """Central Xchange Date"""
  cExchangeDate: Date
  """Central Xchange Rate"""
  cExchangeRate: Float
  """Central Profile Credit Limit"""
  cProfileCreditLimit: Float
  """This is a  name_id (Profile number) of profiles that exist in a Central database in a typical CRS environment."""
  cRSNameid: Float
  """This field tells whether this profile is a credit card profile or not."""
  ccProfileYn: String
  """Central Account Type"""
  centralAccountType: String
  """Central Business Segment"""
  centralBusinessSegment: String
  """Central Business Segment Description"""
  centralBusinessSegmentDescription: String
  """Central Corporate ID Type"""
  centralCorporateIDType: String
  """The keyword to search on."""
  centralDefaultKeyword: String
  """Central Guest Title Code"""
  centralGuestTitleCode: String
  """Central Inactive Reason"""
  centralInactiveReason: String
  """Central Inactive Reason Description"""
  centralInactiveReasonDescription: String
  """Central Mail Action Description"""
  centralMailActionDescription: String
  """Central Mailing Action Code"""
  centralMailingActionCode: String
  """Central Priority"""
  centralPriority: String
  """Central State Code"""
  centralStateCode: String
  """Central Territory"""
  centralTerritory: String
  """Central VIP Code"""
  centralVIPCode: String
  """Central VIP Description"""
  centralVIPDescription: String
  """Chain Code"""
  chainCode: String
  """The city for this address."""
  city: String
  """The unique key of this name stores IATA# Company # etc."""
  clientID: String
  """The user that has been assigned to this account for collections."""
  collectionUserId: Float
  """Combined Name"""
  combinedName: String
  """This flag will be used in case Profiles are being controlled Centrally (CRS)."""
  commPayCentral: String
  """Not Used."""
  comments: String
  """Commission Code for the Commission Percentage."""
  commissionCode: String
  """Code for the commission for Travel Agent"""
  commissionCodes: String
  """Comm Curr ID"""
  commissionCurrencyId: String
  """Commission Code for the Commission Percentage."""
  commissionid: String
  """Role in which this phone type belongs to."""
  communicationRole1: String
  """Role in which this phone type belongs to."""
  communicationRole2: String
  """Role in which this phone type belongs to."""
  communicationRole3: String
  """The type of this phone number."""
  communicationType1: String
  """The type of this phone number."""
  communicationType2: String
  """The type of this phone number."""
  communicationType3: String
  """The phone number for this record"""
  communicationValue1: String
  """The phone number for this record"""
  communicationValue2: String
  """The phone number for this record"""
  communicationValue3: String
  """Extended Byte Company Name"""
  companyAlternate: String
  """The company group or company group user ID in hierarchical format"""
  companyGroupId: String
  """Not used."""
  companyNameId: Float
  """Competaion code ."""
  competition: String
  """The description of this value."""
  competitionDesc: String
  """Used in S&C Module."""
  contactYN: String
  """Group Contract number."""
  contractNo: String
  """The date the group contract was received."""
  contractRecvDate: Date
  """Corp Type Description"""
  corpTypeDesc: String
  """Specified whether Name_Code column has Company # or IATA #. For Company # the value will beCOMP and for IATA # the Value of this column will be IATA."""
  corporateIDType: String
  """Country name."""
  country: String
  """Country ."""
  countryCode: String
  """The user that created the record"""
  createdByUser: String
  """The date the record was created"""
  createdOnDate: DateTime
  """Credit rating."""
  creditRating: String
  """Currency Code"""
  currencyCode: String
  """Currency Symbol like $ or EURO symbol"""
  currencySymbol: String
  """Double Opt In for  AUTOENROLL_MEMBER_YN"""
  dOptInAutoenrollMemberFlg: String
  """Double Opt In for  EMAIL_YN"""
  dOptInEmailFlg: String
  """Double Opt In for  GUEST_PRIV_YN"""
  dOptInGuestPrivFlg: String
  """Double Opt In for  MAIL_LIST"""
  dOptInMailListFlg: String
  """Double Opt In for  MARKET_RESEARCH_YN"""
  dOptInMarketResearchFlg: String
  """Double Opt In for  PHONE_YN"""
  dOptInPhoneFlg: String
  """Double Opt In for  SMS_YN"""
  dOptInSmsFlg: String
  """Double Opt In for  THIRD_PARTY_YN"""
  dOptInThirdPartyFlg: String
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  dSI: Float
  """Debtor Name"""
  debtorName: String
  """The number of digits after the decimal to allow for this currency."""
  decimalPositions: Float
  """The keyword to search on."""
  defaultKeyword: String
  """Deleted Flag"""
  deletedFlag: String
  """Used in S&C Module."""
  department: String
  """Used in S&C Module."""
  deptId: String
  """Used in QMS Module"""
  description: String
  """Direct Bill Batch Type"""
  directBillBatchType: String
  """Display Name"""
  displayName: String
  """Date on which the record is downloaded to laptop."""
  downloadDate: Date
  """REsort name which has downloaded on the laptop."""
  downloadResort: String
  """Owner of the record who downloaded on to laptop."""
  downloadSrep: Float
  """The date when the E-Invoice liable flag was updated for this profile."""
  eInvLiableLastUpdated: DateTime
  """Turkey Country requirement: Indicated if this profile e-Invoice liable. Folios generated for this profile will be directly sent to an external system."""
  eInvoiceLiableYn: String
  """The phone number for this record"""
  email: String
  """Email YN"""
  emailYN: String
  """Field which stores the envelop greeting used in S&C"""
  envelopeGreeting: String
  """External Display Name"""
  externalDisplayName: String
  """The first name of an individual."""
  externalFirstName: String
  """External ID used for V6 Interface stores the PMS guest number"""
  externalId: String
  """The last name of the individual profile."""
  externalName: String
  """Not Used."""
  externalReferenceRequ: String
  """During the booking process is the user required to enter the tour operator or TA record locator."""
  externalReferenceRequired: String
  """Membership Card Number."""
  fMembershipCardNumbers: String
  """Descripion of membership class"""
  fMembershipClassDesc: String
  """F Membership Classes"""
  fMembershipClasses: String
  """F Membership Codes"""
  fMembershipCodes: String
  """F Membership Descriptions"""
  fMembershipDescriptions: String
  """Primary Key for this table."""
  fMembershipIds: String
  """Type of the Membership."""
  fMembershipType: String
  """The ID of the external Database."""
  fSubscriptionDb: String
  """The ID of the external Database."""
  fSubscriptionYn: String
  """The phone number for this record"""
  faxNumber: String
  """The first name of an individual name."""
  firstName: String
  """First Name Alternate"""
  firstNameAlternate: String
  """The keyword to search on."""
  firstNameIncognito: String
  """The follow on for this individual (I.E: III etc)."""
  followOn: String
  """The name as communicated from the GDS. system.  Filled on names that are created during the booking."""
  gDSName: String
  """Not used."""
  gDSTransactionNo: String
  """Indicates gender of Individual profile. Either (M)ale or F(emale)"""
  gender: String
  """Not used."""
  geographicRegion: String
  """Not used."""
  guestClassification: String
  """Country name."""
  guestCountry: String
  """Currency code for the Commission payment."""
  guestCurrencyCode: String
  """Description for each language code."""
  guestLanguageCode: String
  """The last name of the individual Profile and Search name ofr the other Types of Profiles (Group Travel Agent & Source) are stored in this column."""
  guestLastName: String
  """The middle name of this individual."""
  guestMiddleName: String
  """Guest Name Suffix"""
  guestNameSuffix: String
  """Guest Privilege YN"""
  guestPrivilegeYN: String
  """The title of the individual."""
  guestTitleCode: String
  """Has Requested Mail YN"""
  hasRequestedMailYN: String
  """Keep guest in history Y/N"""
  historyYN: String
  """Hold code for the Commission handling purposes."""
  holdCode: String
  """Consortia for the IATA number."""
  iataConsortia: String
  """The country where ID was issued"""
  idCountry: String
  """Issued date of Identification"""
  idDate: Date
  """This will store the value of LINKED_ATTACHMENTS.ATTACH_ID (Which maps to the physical table WORK_ORDERS.WO_NUMBER)"""
  idDocumentAttachId: Float
  """The place where ID was issued"""
  idPlace: String
  """Identification Type. Eg Passport Driving License etc"""
  idType: String
  """Country Specific Requirement for Nigeria."""
  immigrationStatus: String
  """The date the record was marked as inactive"""
  inactiveDate: DateTime
  """Inactive Flag"""
  inactiveFlag: String
  """Reason why record was inactivated."""
  inactiveReason: String
  """The description of this value."""
  inactiveReasonDescription: String
  """Include travel agents/sources profile in 1099 reporting ?Y/N"""
  includeInTax1099Yn: String
  """Index Name"""
  indexName: String
  """The Industry this profile belongs to. Used only for the Non-Individual Profiles."""
  industryCode: String
  """The description of this value."""
  industryDesc: String
  """Used in S&C Module."""
  influence: String
  """The description of this value."""
  influenceDesc: String
  """Interest Code."""
  interest: String
  """Indicates that this profile should be generating an internal bill instead of a regular bill during settlement."""
  internalBillYn: String
  """Deleted Flag"""
  internalDeletedflag: String
  """Inactive Flag"""
  internalInactiveflag: String
  """Organization ID"""
  internalOrganizationId: Float
  """JRN Update Date"""
  jRNUpdateDate: Date
  """JRN Update Date and Time"""
  jRNUpdateDateAndTime: DateTime
  """Primary language used for the profile."""
  languageCode: String
  """Code to synchronize to Laptop values are 012."""
  laptopChange: Float
  """Last Group"""
  lastGroup: String
  """Last Name Alternate"""
  lastNameAlternate: String
  """The keyword to search on."""
  lastNameIncognito: String
  """Last Rate"""
  lastRate: Float
  """Last Rate Code"""
  lastRateCode: String
  """The room that is booked for this reservation leg."""
  lastRoom: String
  """Last Room Property"""
  lastRoomProperty: String
  """Last Source"""
  lastSource: String
  """This contains the truncated component of end_date (i.e without timecomponent)"""
  lastStay: Date
  """Last property that updated this record."""
  lastUpdatedResort: String
  """The legal company name for this company."""
  legalCompany: String
  """Used in S&C Module."""
  letterGreeting: String
  """The description of this value."""
  mailActionDescription: String
  """This indicates whether the mailing list must be sent to the guest."""
  mailList: String
  """The type of mail this user should be sent."""
  mailType: String
  """Mailing action codes."""
  mailingActionCode: String
  """Market Research YN"""
  marketResearchYN: String
  """Is this account a master account (Y/N)?"""
  masterAccountYn: String
  """Not used."""
  nameTaxType: String
  """The type of Profile."""
  nameType: String
  """The description of this value."""
  nameTypeDescription: String
  """Not Used."""
  name2: String
  """Not used."""
  name3: String
  """Nationality"""
  nationality: String
  """Nationality of the individual."""
  nationalityCode: String
  """The rate code for which this record applies."""
  negotiatedRateCodes: String
  """This is a begin_date  with no  time component."""
  nextStay: Date
  """The nickname of this individual."""
  nickname: String
  """Internal ID to uniquely identify the Organization"""
  organizationID: Float
  """Stores the original NAME_ID prior to a migration."""
  origNameId: Float
  """Number of days a payment is due for the account."""
  paymentDueDays: Float
  """The phone number for this record"""
  phone: String
  """The phone number for this record"""
  phoneWeb: String
  """Phone YN"""
  phoneYN: String
  """The postal code of this address."""
  postalCode: String
  """City Extension mainly used for UK addresses."""
  postalCodeExtension: String
  """Preferred Room Number"""
  preferredRoomNo: String
  """Not used."""
  primaryAddressId: Float
  """Internal Primary Key ID to uniquely identify the row"""
  primaryKeyID: Float
  """Not Used."""
  primaryNameId: Float
  """Primary Owner"""
  primaryOwner: String
  """Primary Owner Code"""
  primaryOwnerCode: String
  """Not used."""
  primaryPhoneId: Float
  """Priority of the account"""
  priority: String
  """The description of this value."""
  priorityDesc: String
  """Profile privacy flag determine if the profile is marked as private for a property."""
  privacyFlagYN: String
  """Preference Code. Part of the Primary Key."""
  productInterest: String
  """The profession of the Individual"""
  profession: String
  """Credit Limit amount for all AR accounts created in different properties for this profile."""
  profileCreditLimit: Float
  """The primary key for this table."""
  profileId: Float
  """The type of Profile."""
  profileType: String
  """Resort for which Job is registered."""
  propertyRegistered: String
  """Protected"""
  protected: String
  """Psuedo Profile Y/N"""
  psuedoProfileYn: String
  """The default rate structure for this name."""
  rateStructure: String
  """The region for this name."""
  region: String
  """The region for this name."""
  regionid: String
  """Reporting Account Type Description"""
  repAccountTypeDescription: String
  """Reporting Accountsource"""
  repAccountsource: String
  """Reporting Accountsource Desc"""
  repAccountsourceDescription: String
  """Reporting Competition Code"""
  repCompetitionCode: String
  """Reporting Competition Desc"""
  repCompetitionDescription: String
  """Reporting Corp Type Desc"""
  repCorpTypeDescription: String
  """Reporting Industry Code"""
  repIndustryCode: String
  """Reporting Industry Desc"""
  repIndustryDescription: String
  """Reporting Influence"""
  repInfluence: String
  """Reporting Influence Desc"""
  repInfluenceDescription: String
  """Reporting Name Type"""
  repNameType: String
  """Reporting Name Type Description"""
  repNameTypeDescription: String
  """Rep Nationality Code"""
  repNationalityCode: String
  """Rep Nationality Description"""
  repNationalityDescription: String
  """Reporting Priority Desc"""
  repPriorityDescription: String
  """Reporting Rooms Potential"""
  repRoomsPotential: String
  """Reporting Rooms Potential Desc"""
  repRoomsPotentialDescription: String
  """Reporting Scope"""
  repScope: String
  """Reporting Scope City"""
  repScopeCity: String
  """Reporting Scope City Desc"""
  repScopeCityDescription: String
  """Reporting Scope Desc"""
  repScopeDescription: String
  """Reporting State Desc"""
  repStateDescription: String
  """Reporting Tax Type Desc"""
  repTaxTypeDescription: String
  """Reporting Territory Desc"""
  repTerritoryDescription: String
  """Reporting Title Name"""
  repTitleName: String
  """The primary membership # for this guest."""
  repeatGuestId: String
  """User option to replace address in ORS with one from PMS."""
  replaceAddress: String
  """This column store the Name of the Company Profiles."""
  requestType: String
  """Normal Restricted and Cash Only informations are stored in this column."""
  restricted: String
  """The description of this value."""
  restrictedRule: String
  """Reservation Contact person."""
  resvContact: String
  """RnA Insertdate"""
  rnaInsertDate: DateTime
  """RnA Updatedate"""
  rnaUpdateDate: DateTime
  """Potential no of rooms per year for a account"""
  roomsPotential: String
  """The description of this value."""
  roomsPotentialDesc: String
  """Use this alert to text a notification."""
  sMSYN: String
  """Salutation Greeting"""
  salutation: String
  """Scope of the account"""
  scope: String
  """Scope City"""
  scopeCity: String
  """The description of this value."""
  scopeCityDesc: String
  """The description of this value."""
  scopeDesc: String
  """The Uppercase value of Last or Company."""
  searchName: String
  """Internal Indexed field for Searching by Extended Byte Name."""
  searchNameAlternate: String
  """Uppercase value of First Name."""
  sfirst: String
  """The soundex value for this company record.  Used for performance reasons when finding a name based on the Sounds."""
  soundExCompany: String
  """The soundex value for this individual record. Used for performance reasons when finding a name based on the sounds."""
  soundExLast: String
  """Used in QMS Module"""
  srepCode: String
  """The state of this address."""
  state: String
  """State Code"""
  stateCode: String
  """Description of the state."""
  stateDescription: String
  """Summary Reference Currency for the Folio Generation."""
  summRefCc: String
  """Summary Reference Currency for the Folio Generation."""
  summRefCurrencyId: String
  """Used in Oracle Text Index."""
  superSearchIndexText: String
  """Internal Indexed field for Searching by Extended Byte First Name."""
  sxfirstName: String
  """Tax Category"""
  taxCategory: String
  """Not used."""
  taxExemptStatus: String
  """The tax id of this name.  Usually issued by a government agency.  Used by 1099 printing."""
  taxID1: String
  """Tax No"""
  taxID2: String
  """Tax Office Name"""
  taxOffice: String
  """Tax Type"""
  taxType: String
  """TERRITORY of  a account"""
  territory: String
  """The description of this value."""
  territoryDesc: String
  """Third Party YN"""
  thirdPartyYN: String
  """Title Alternate"""
  titleAlternate: String
  """The description of this value."""
  titleName: String
  """Stores the suffix value of the selected title code.  This will be used for Processing to External System."""
  titleSuffix: Float
  """Sum of total number of stays on stay records for the time period."""
  totalStay: Float
  """The type of tour operator. Only valid for tour operators/wholesalers."""
  tourOperatorType: String
  """Code to Trace a record for all Triggered actions."""
  traceCode: String
  """Description"""
  tracecodeDesc: String
  """What type of 1099 is issued to this name."""
  typeOfTax1099: String
  """User defined character field."""
  uDFC01: String
  """User defined character field."""
  uDFC02: String
  """User defined character field."""
  uDFC03: String
  """User defined character field."""
  uDFC04: String
  """User defined character field."""
  uDFC05: String
  """User defined character field."""
  uDFC06: String
  """User defined character field."""
  uDFC07: String
  """User defined character field."""
  uDFC08: String
  """User defined character field."""
  uDFC09: String
  """User defined character field."""
  uDFC10: String
  """User defined character field."""
  uDFC11: String
  """User defined character field."""
  uDFC12: String
  """User defined character field."""
  uDFC13: String
  """User defined character field."""
  uDFC14: String
  """User defined character field."""
  uDFC15: String
  """User defined character field."""
  uDFC16: String
  """User defined character field."""
  uDFC17: String
  """User defined character field."""
  uDFC18: String
  """User defined character field."""
  uDFC19: String
  """User defined character field."""
  uDFC20: String
  """User defined character field."""
  uDFC21: String
  """User defined character field."""
  uDFC22: String
  """User defined character field."""
  uDFC23: String
  """User defined character field."""
  uDFC24: String
  """User defined character field."""
  uDFC25: String
  """User defined character field."""
  uDFC26: String
  """User defined character field."""
  uDFC27: String
  """User defined character field."""
  uDFC28: String
  """User defined character field."""
  uDFC29: String
  """User defined character field."""
  uDFC30: String
  """User defined character field."""
  uDFC31: String
  """User defined character field."""
  uDFC32: String
  """User defined character field."""
  uDFC33: String
  """User defined character field."""
  uDFC34: String
  """User defined character field."""
  uDFC35: String
  """User defined character field."""
  uDFC36: String
  """User defined character field."""
  uDFC37: String
  """User defined character field."""
  uDFC38: String
  """User defined character field."""
  uDFC39: String
  """User defined character field."""
  uDFC40: String
  """User defined date field."""
  uDFD01: Date
  """User defined date field."""
  uDFD02: Date
  """User defined date field."""
  uDFD03: Date
  """User defined date field."""
  uDFD04: Date
  """User defined date field."""
  uDFD05: Date
  """User defined date field."""
  uDFD06: Date
  """User defined date field."""
  uDFD07: Date
  """User defined date field."""
  uDFD08: Date
  """User defined date field."""
  uDFD09: Date
  """User defined date field."""
  uDFD10: Date
  """User defined date field."""
  uDFD11: Date
  """User defined date field."""
  uDFD12: Date
  """User defined date field."""
  uDFD13: Date
  """User defined date field."""
  uDFD14: Date
  """User defined date field."""
  uDFD15: Date
  """User defined date field."""
  uDFD16: Date
  """User defined date field."""
  uDFD17: Date
  """User defined date field."""
  uDFD18: Date
  """User defined date field."""
  uDFD19: Date
  """User defined date field."""
  uDFD20: Date
  """User defined number field."""
  uDFN01: Float
  """User defined number field."""
  uDFN02: Float
  """User defined number field."""
  uDFN03: Float
  """User defined number field."""
  uDFN04: Float
  """User defined number field."""
  uDFN05: Float
  """User defined number field."""
  uDFN06: Float
  """User defined number field."""
  uDFN07: Float
  """User defined number field."""
  uDFN08: Float
  """User defined number field."""
  uDFN09: Float
  """User defined number field."""
  uDFN10: Float
  """User defined number field."""
  uDFN11: Float
  """User defined number field."""
  uDFN12: Float
  """User defined number field."""
  uDFN13: Float
  """User defined number field."""
  uDFN14: Float
  """User defined number field."""
  uDFN15: Float
  """User defined number field."""
  uDFN16: Float
  """User defined number field."""
  uDFN17: Float
  """User defined number field."""
  uDFN18: Float
  """User defined number field."""
  uDFN19: Float
  """User defined number field."""
  uDFN20: Float
  """User defined number field."""
  uDFN21: Float
  """User defined number field."""
  uDFN22: Float
  """User defined number field."""
  uDFN23: Float
  """User defined number field."""
  uDFN24: Float
  """User defined number field."""
  uDFN25: Float
  """User defined number field."""
  uDFN26: Float
  """User defined number field."""
  uDFN27: Float
  """User defined number field."""
  uDFN28: Float
  """User defined number field."""
  uDFN29: Float
  """User defined number field."""
  uDFN30: Float
  """User defined number field."""
  uDFN31: Float
  """User defined number field."""
  uDFN32: Float
  """User defined number field."""
  uDFN33: Float
  """User defined number field."""
  uDFN34: Float
  """User defined number field."""
  uDFN35: Float
  """User defined number field."""
  uDFN36: Float
  """User defined number field."""
  uDFN37: Float
  """User defined number field."""
  uDFN38: Float
  """User defined number field."""
  uDFN39: Float
  """User defined number field."""
  uDFN40: Float
  """The date the record was modified"""
  updateDate: DateTime
  """The last date this record's fax # was updated."""
  updateFaxDate: Date
  """The user that modified the record"""
  updateUser: String
  """Date on which the record is uploaded to laptop."""
  uploadDate: Date
  """VIP Status of the Individual."""
  vIPCode: String
  """The description of this value."""
  vIPDescription: String
  """The Oracle Financials vendor id for this record.  Used with the Oracle Financials A/P interface."""
  vendorId: Float
  """The Oracle Financial vendor site id for this record.  Used with the Oracle Financials A/P interface."""
  vendorSiteId: Float
  """Not Used."""
  vipAuthorization: String
  """Country Specific Requirement for Nigeria."""
  visaValidityType: String
  """Xdisplay Name"""
  xdisplayName: String
  """Extended Byte middle name."""
  xmiddleName: String
}