# title : OPERA Cloud RnA ProfilesAddresses GraphQL API,
# description : GraphQL API to cater for All associated addresses including primary and secondary addresses, and address types which can be associated with the proper profile 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!
}

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


input ProfilesAddressesQueryArgumentsType {
  """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!                          @mandatoryInput
  """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
  """Active Flag"""
  profileDetailsActiveYn: StringInput
  """Anonymization Status possible values: REQUESTED ANONYMIZED."""
  profileDetailsAnonymizationStatus: StringInput
  """The unique identifier of the CRS"""
  profileDetailsCrsNameid: FloatInput
  """Company"""
  profileDetailsCompany: StringInput
  """Linked internal ID for booker."""
  profileDetailsCompanyGroupId: StringInput
  """Contact Flag"""
  profileDetailsContactFlag: StringInput
  """Contact Owner Code"""
  profileDetailsSrepCode: StringInput
  """Corp ID"""
  profileDetailsNameCode: StringInput
  """DSI Internal Data Source ID to identify Opera Chain and instance"""
  profileDetailsDsi: FloatInput
  """Direct Bill Batch Type"""
  profileDetailsDirectBillBatchType: StringInput
  """History Y/N"""
  profileDetailsHistoryYn: StringInput
  """Inactive Date"""
  profileDetailsInactiveDate: DateInput
  """Index Name"""
  profileDetailsIndexName: StringInput
  """Organization ID"""
  profileDetailsOrganizationId: FloatInput
  """JRN Update Date and Time"""
  profileDetailsJrnupdatedttm: DateTimeInput
  """Last"""
  profileDetailsLast: StringInput
  """Name ID"""
  profileDetailsNameId: FloatInput
  """Internal ID to uniquely identify the Organization"""
  profileDetailsOrganizationid: FloatInput
  """Profile Type"""
  profileDetailsProfileType: StringInput
  """Profile Type Code"""
  profileDetailsNameType: StringInput
  """Resort for which Job is registered."""
  profileDetailsResortRegistered: StringInput
  """Uppercase value of First Name."""
  profileDetailsSfirst: StringInput
  """The Uppercase value of Last or Company."""
  profileDetailsSname: StringInput
  """Internal Indexed field for Searching by Extended Byte First Name."""
  profileDetailsSxfirstName: StringInput
  """Internal Indexed field for Searching by Extended Byte Name."""
  profileDetailsSxname: StringInput
  """Top Account ID"""
  profileDetailsProfileId: FloatInput
  """Update Date"""
  profileDetailsUpdateDate: DateTimeInput
}
type Query {
  """All associated addresses including primary and secondary addresses and address types which can be associated with the proper profile and profile type."""
  profilesAddresses(limit: Int offset: Int input: ProfilesAddressesQueryArgumentsType!): [ProfilesAddressesType]
}
type ProfilesAddressesType {
  """Profile Address Details"""
  profileAddressDetails: ProfilesAddressesProfileAddressDetailsType
  """Profile Details"""
  profileInformationDetails: ProfilesAddressesProfileInformationDetailsType
  profilesAddressesRecordCount: Int
}
type ProfilesAddressesProfileAddressDetailsType {
  """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 ProfilesAddressesProfileInformationDetailsType {
  """Indicates if a Credit Limit amount on Profile level will be required."""
  aRCreditLimitYN: String
  """AR Number"""
  aRNumber: String
  """The ARC mailing flag (received from ARC Update program)"""
  aRCMailFlag: String
  """The ARC office type (received from ARC Update program)"""
  aRCOfficeType: String
  """The date this record was last updated by the ARC update program."""
  aRCUpdateDate: Date
  """Account Email Primary"""
  accountEmailPrimary: String
  """Account Name"""
  accountName: String
  """Account Name 2"""
  accountName2: String
  """Account Name 3"""
  accountName3: String
  """Account Owner Code"""
  accountOwnerCode: String
  """Phone no."""
  accountPhonePrimary: String
  """Account Source"""
  accountSource: String
  """Account Type"""
  accountType: String
  """Account Type Description"""
  accountTypeDescription: String
  """Accountsource Description"""
  accountsourceDesc: 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 ID"""
  addressId: Float
  """Address Lang Code Description"""
  addressLangCodeDesc: String
  """Address Language Code"""
  addressLanguageCode: String
  """Address Type"""
  addressType: String
  """Country Specific Requirement for Nigeria."""
  alienRegistrationNo: String
  """All Owners"""
  allOwners: String
  """All Resorts"""
  allResorts: 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
  """System Date when the guest was anonymized in OPERA."""
  anonymizationDate: Date
  """Anonymization Status possible values: REQUESTED ANONYMIZED."""
  anonymizationStatus: String
  """AR No Central"""
  arNumberCentral: String
  """Auto Pop Routing"""
  autoPopRouting: String
  """Autoenroll Member Y/N"""
  autoenrollMemberYn: String
  """Does profile have Availability Override Y/N"""
  availabilityOverride: String
  """The billing code for this name record."""
  billingCode: String
  """Billing Instruction"""
  billingInstruction: String
  """For tour operators the type of billing profile for this name."""
  billingProfileCode: String
  """Country of birth."""
  birthCountry: String
  """Birth Date"""
  birthDate: Date
  """Birth Date Str"""
  birthDateStr: String
  """Place of birth."""
  birthPlace: String
  """Bl Msg"""
  blMsg: String
  """Business Potential"""
  businessPotential: String
  """Business Segement"""
  businessSegement: String
  """Business Title"""
  businessTitle: String
  """Central Xchange Date"""
  cExchangeDate: Date
  """Central Xchange Rate"""
  cExchangeRate: Float
  """Central Profile Credit Limit"""
  cProfileCreditLimit: Float
  """The unique identifier of the CRS"""
  cRSNameid: Float
  """Cash Bl Individual"""
  cashBlInd: String
  """This field tells whether this profile is a credit card profile or not."""
  ccProfileYn: String
  """Central Account Source Description"""
  centralAccountSourceDescription: String
  """Central Account Type Description"""
  centralAccountTypeDescription: String
  """Central Business Potential Description"""
  centralBusinessPotentialDescription: String
  """Central Business Segement Description"""
  centralBusinessSegementDescription: String
  """Central Competition Code Description"""
  centralCompetitionCodeDescription: String
  """Central Corporate Type Description"""
  centralCorporateTypeDescription: String
  """Central IATA Number"""
  centralIATANumber: String
  """Central Inactive Reason"""
  centralInactiveReason: String
  """Central Inactive Reason Description"""
  centralInactiveReasonDescription: String
  """Central Industry Code Description"""
  centralIndustryCodeDescription: String
  """Central Keyword"""
  centralKeyword: String
  """Central Mail Action Description"""
  centralMailActionDescription: String
  """Central Priority"""
  centralPriority: String
  """Central Priority Description"""
  centralPriorityDescription: String
  """Central Profile Type Description"""
  centralProfileTypeDescription: String
  """Central Scope City Description"""
  centralScopeCityDescription: String
  """Central Scope Description"""
  centralScopeDescription: String
  """Central Source Owner Title"""
  centralSourceOwnerTitle: 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
  """The user that has been assigned to this account for collections."""
  collectionUserId: Float
  """Combined Name"""
  combinedName: String
  """This flag will be used in case Profiles are being controlled Centrally (CRS)."""
  commPayCentral: String
  """Commission Code"""
  commissionCode: String
  """Commission Codes"""
  commissionCodes: String
  """Comm Curr ID"""
  commissionCurrencyId: String
  """Commissionid"""
  commissionid: String
  """Communication Role1"""
  communicationRole1: String
  """Communication Role2"""
  communicationRole2: String
  """Communication Role3"""
  communicationRole3: String
  """Communication Type1"""
  communicationType1: String
  """Communication Type2"""
  communicationType2: String
  """Communication Type3"""
  communicationType3: String
  """Communication Value1"""
  communicationValue1: String
  """Communication Value2"""
  communicationValue2: String
  """Communication Value3"""
  communicationValue3: String
  """Comp Pre Approval Required Y/N"""
  compPreApprovalRequiredYn: String
  """Company"""
  company: String
  """Linked internal ID for booker."""
  companyGroupId: String
  """Company Name ID"""
  companyNameId: Float
  """Competition Code"""
  competitionCode: String
  """Competition Description"""
  competitionDesc: String
  """Contact Flag"""
  contactFlag: String
  """Contact Owner Code"""
  contactOwnerCode: String
  """Contract Number (used for customers)."""
  contractNo: String
  """The date the group contract was received."""
  contractRecvDate: Date
  """Corp ID"""
  corpID: String
  """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."""
  corporateType: String
  """Country"""
  country: String
  """Country Code"""
  countryCode: String
  """Country Description"""
  countryDesc: String
  """Created By User"""
  createdByUser: String
  """Created On Date"""
  createdOnDate: DateTime
  """Credit Card Name"""
  creditCardName: String
  """Credit Card Type"""
  creditCardType: String
  """Credit Rating"""
  creditRating: String
  """Currency Code"""
  currencyCode: String
  """Currency Description"""
  currencyDescription: String
  """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
  """Decimal Positions"""
  decimalPositions: Float
  """Deleted Flag"""
  deletedFlag: String
  """Department"""
  department: String
  """Dept ID"""
  deptId: String
  """Direct Bill Batch Type"""
  directBillBatchType: String
  """Download Date"""
  downloadDate: Date
  """Download Property"""
  downloadResort: String
  """Download Srep"""
  downloadSrep: Float
  """The date when the E-Invoice liable flag was updated for this profile."""
  eInvLiableLastUpdated: Date
  """Indicates if the payee profile ID is E_INVOICE liable."""
  eInvoiceLiableYn: String
  """Email Y/N"""
  emailYn: String
  """Envelope Greeting"""
  envelopeGreeting: String
  """External Display Name"""
  externalDisplayName: String
  """External First Name"""
  externalFirstName: String
  """External ID"""
  externalId: String
  """External Name"""
  externalName: String
  """Not Used."""
  externalReferenceRequ: String
  """During the booking process is the user required to enter the tour operator or TA record locator."""
  externalReferenceRequired: String
  """F Membership Card Numbers"""
  fMembershipCardNumbers: String
  """F Membership Class Description"""
  fMembershipClassDesc: String
  """F Membership Classes"""
  fMembershipClasses: String
  """F Membership Codes"""
  fMembershipCodes: String
  """F Membership Descriptions"""
  fMembershipDescriptions: String
  """F Membership Ids"""
  fMembershipIds: String
  """F Membership Type"""
  fMembershipType: String
  """F Subscription Db"""
  fSubscriptionDb: String
  """F Subscription Y/N"""
  fSubscriptionYn: String
  """Fax Number"""
  faxNo: String
  """First"""
  first: String
  """The follow on for this individual (I.E: III etc)."""
  followOn: String
  """The name as communicated from the GDS. system.  Filled on names that are created during the booking."""
  gDSName: String
  """Not used."""
  gDSTransactionNo: String
  """Gender"""
  gender: String
  """Not used."""
  geographicRegion: String
  """Not used."""
  guestClassification: String
  """Guest Priv Y/N"""
  guestPrivYn: String
  """History Y/N"""
  historyYn: String
  """Hold Code"""
  holdCode: String
  """IATA Consortia"""
  iataConsortia: String
  """ID Country"""
  idCountry: String
  """ID Date"""
  idDate: Date
  """Store the ID value of linked_attachments.attach_id pointing to the physical table column that stores the scanned document."""
  idDocumentAttachId: Float
  """ID Number"""
  idNumber: String
  """ID Place"""
  idPlace: String
  """ID Type"""
  idType: String
  """Country Specific Requirement for Nigeria."""
  immigrationStatus: String
  """Inactive Date"""
  inactiveDate: Date
  """Inactive Flag"""
  inactiveFlag: String
  """Reason Code for inactive status from REASON table"""
  inactiveReasonCode: String
  """Reason why record was inactivated."""
  inactiveReasonDescription: String
  """Include travel agents/sources profile in 1099 reporting ?Y/N"""
  includeInTax1099Yn: String
  """Incognito First Name"""
  incognitoFirstName: String
  """Incognito Last Name"""
  incognitoLastName: String
  """Index Name"""
  indexName: String
  """Industry Code"""
  industryCode: String
  """Industry Description"""
  industryDesc: String
  """Influence"""
  influence: String
  """Influence Description"""
  influenceDesc: String
  """Insert User ID"""
  insertUserId: Float
  """Interest Code."""
  interest: String
  """Internal bill that will be solely used for accounting purposes on barter agreements and interim billing amongst hotels which belong to the same owner."""
  internalBillYn: String
  """Deleted Flag"""
  internalDeletedflag: String
  """Inactive Flag"""
  internalInactiveflag: String
  """Organization ID"""
  internalOrganizationId: Float
  """JRN Update Date"""
  jRNUpdateDate: Date
  """JRN Update Date and Time"""
  jRNUpdateDateAndTime: DateTime
  """Keyword"""
  keyword: String
  """Laptop Change"""
  laptopChange: Float
  """Last"""
  last: String
  """Last Group"""
  lastGroup: String
  """Last Rate"""
  lastRate: Float
  """Last Rate Code"""
  lastRateCode: String
  """Not used."""
  lastRoom: String
  """Last Room Property"""
  lastRoomResort: String
  """Last Source"""
  lastSource: String
  """Last Stay"""
  lastStay: Date
  """Last property that updated this record."""
  lastUpdatedResort: String
  """Legal Company"""
  legalCompany: String
  """Letter Greeting"""
  letterGreeting: String
  """Mail Action Codes"""
  mailActionCodes: String
  """Mail Action Description"""
  mailActionDesc: 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
  """Markets Description"""
  marketsDesc: String
  """Is this account a master account (Y/N)?"""
  masterAccountYn: String
  """Middle"""
  middle: String
  """Name"""
  name: String
  """Not Used."""
  nameComment: String
  """Name ID"""
  nameId: Float
  """Name Tax Type"""
  nameTaxType: String
  """Name Type Description"""
  nameTypeDescription: String
  """Name With Title"""
  nameWithTitle: String
  """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
  """Stores the original NAME_ID prior to a migration."""
  origNameId: Float
  """Passport"""
  passport: String
  """Number of days a payment is due for the account."""
  paymentDueDays: Float
  """Payment Methods Code"""
  paymentMethodsCode: String
  """Payment Methods Description"""
  paymentMethodsDesc: String
  """Phone Web"""
  phoneWeb: String
  """Phone Y/N"""
  phoneYn: String
  """Postal Code"""
  postalCode: String
  """Preferred Room Number"""
  preferredRoomNo: String
  """Not used."""
  primaryAddressId: Float
  """Internal Primary Key ID to uniquely identify the row"""
  primaryKeyID: Float
  """Not Used."""
  primaryNameId: Float
  """Primary Owner"""
  primaryOwner: String
  """Primary Owner Code"""
  primaryOwnerCode: String
  """Not used."""
  primaryPhoneId: Float
  """Priority"""
  priority: String
  """Priority Description"""
  priorityDesc: String
  """Product Interest"""
  productInterest: String
  """Product Interest Codes"""
  productInterestCodes: String
  """Profession of the guest"""
  profession: String
  """Profile Arrangement Codes"""
  profileArrCodes: String
  """Profile Arr Description"""
  profileArrangementDesc: String
  """Credit Limit amount for all AR accounts created in different properties for this profile."""
  profileCreditLimit: Float
  """Profile Language"""
  profileLanguage: 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
  """Protected"""
  protected: String
  """Province"""
  province: String
  """Psuedo Profile Y/N"""
  psuedoProfileYn: String
  """The default rate structure for this name."""
  rateStructure: String
  """Region"""
  region: String
  """Regionid"""
  regionid: String
  """Rep Account Type"""
  repAccountType: String
  """Reporting Accountsource"""
  repAccountsource: String
  """Reporting Competition Code"""
  repCompetitionCode: String
  """Rep IATA Comp Type"""
  repIataCompType: String
  """Reporting Industry Code"""
  repIndustryCode: String
  """Reporting Influence"""
  repInfluence: String
  """Reporting Influence Desc"""
  repInfluenceDescription: String
  """Reporting Mail Action Codes"""
  repMailActionCodes: String
  """Reporting Markets"""
  repMarkets: String
  """Reporting Nationality Code"""
  repNationalityCode: String
  """Reporting Nationality Description"""
  repNationalityDescription: String
  """Reporting Rooms Potential"""
  repRoomsPotential: String
  """Reporting Scope"""
  repScope: String
  """Reporting Scope City"""
  repScopeCity: String
  """Reporting State Desc"""
  repStateDescription: String
  """Reporting Tax Type"""
  repTaxType: String
  """Reporting Tax Type Desc"""
  repTaxTypeDescription: String
  """Reporting Title Name"""
  repTitleName: String
  """Reporting Vip Name"""
  repVIPName: String
  """Reporting Vip Status"""
  repVIPStatus: String
  """The primary membership # for this guest."""
  repeatGuestId: String
  """User option to replace address in ORS with one from PMS."""
  replaceAddress: String
  """Resort for which Job is registered."""
  resortRegistered: String
  """Restricted Rule"""
  restrictedRule: String
  """Reservation Contact person."""
  resvContact: String
  """RnA Insertdate"""
  rnaInsertDate: DateTime
  """RnA Updatedate"""
  rnaUpdateDate: DateTime
  """Rooms Potential Description"""
  roomsPotentialDesc: String
  """Salutation Greeting"""
  salutation: String
  """Scope"""
  scope: String
  """Scope City"""
  scopeCity: String
  """Scope City Description"""
  scopeCityDesc: String
  """Scope Description"""
  scopeDesc: String
  """Uppercase value of First Name."""
  sfirst: String
  """Use this alert to text a notification."""
  smsYn: String
  """The Uppercase value of Last or Company."""
  sname: 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
  """Source Owner Title"""
  sourceOwnerTitle: String
  """State"""
  state: String
  """State Description of the Guest of Payee"""
  stateDesc: String
  """State Description"""
  stateDescription: String
  """Suffix"""
  suffix: String
  """Summ Ref Cc"""
  summRefCc: String
  """Summ Ref Curr ID"""
  summRefCurrencyId: String
  """Super Search Index Text"""
  superSearchIndexText: String
  """Internal Indexed field for Searching by Extended Byte First Name."""
  sxfirstName: String
  """Internal Indexed field for Searching by Extended Byte Name."""
  sxname: String
  """Tax1 Number"""
  tax1No: String
  """Tax2 Number"""
  tax2No: String
  """Tax Category"""
  taxCategory: String
  """Not used."""
  taxExemptStatus: String
  """Tax Office Name"""
  taxOffice: String
  """Tax Type"""
  taxType: String
  """Tax Type Description"""
  taxTypeDesc: String
  """Territory"""
  territory: String
  """Territory Description"""
  territoryDesc: String
  """Third Party Y/N"""
  thirdPartyYn: String
  """Title Name"""
  titleName: String
  """Title Suffix"""
  titleSuffix: Float
  """Top Account ID"""
  topAccountID: Float
  """Total Arrivals"""
  totalArrivals: Float
  """Total Arrivals Last Year"""
  totalArrivalsLastyear: Float
  """Total Cancelled Reservations"""
  totalCancelledReservations: Float
  """Total Cancelled Reservation Lastyear"""
  totalCancelledResvLastYear: Float
  """Total Cancelled Rooms"""
  totalCancelledRooms: Float
  """Total Cancelled Rooms Last Year"""
  totalCancelledRoomsLastyear: Float
  """Total Day Use Reservations"""
  totalDayUseReservations: Float
  """Total Day Use Reservation Lastyear"""
  totalDayUseResvLastYear: Float
  """Total Day Use Rooms"""
  totalDayUseRooms: Float
  """Total Day Use Rooms Last Year"""
  totalDayUseRoomsLastyear: Float
  """Total FB Revenue"""
  totalFbRevenue: Float
  """Total FB Revenue Lastyear"""
  totalFbRevenueLastYear: Float
  """Total Number Show Reservations"""
  totalNoShowReservations: Float
  """Total Number Show Rooms"""
  totalNoShowRooms: Float
  """Total Non Revenue"""
  totalNonRevenue: Float
  """Total Non Revenue Last Year"""
  totalNonRevenueLastyear: Float
  """Total No Show Reservation Lastyear"""
  totalNumberShowResvLastYear: Float
  """Total No Show Rooms Last Year"""
  totalNumberShowRoomsLastyear: Float
  """Total Other Revenue"""
  totalOtherRevenue: Float
  """Total Other Revenue Last Year"""
  totalOtherRevenueLastyear: Float
  """Total Reservation Nights"""
  totalReservationNights: Float
  """Total Reservation Nights Lastyear"""
  totalResvNightsLastYear: Float
  """Total Revenue"""
  totalRevenue: Float
  """Total Revenue Last Year"""
  totalRevenueLastyear: Float
  """Total Room Nights Last Year"""
  totalRoomNightsLastyear: Float
  """Total Room Revenue"""
  totalRoomRevenue: Float
  """Total Room Revenue Last Year"""
  totalRoomRevenueLastyear: Float
  """Sum of total number of stays on stay records for the time period."""
  totalStays: Float
  """Total Stays Last Year"""
  totalStaysLastyear: Float
  """The type of tour operator. Only valid for tour operators/wholesalers."""
  tourOperatorType: String
  """Trace Code"""
  traceCode: String
  """Tracecode Description"""
  tracecodeDesc: String
  """What type of 1099 is issued to this name."""
  typeOfTax1099: String
  """UDFC01"""
  uDFC01: String
  """UDFC02"""
  uDFC02: String
  """UDFC03"""
  uDFC03: String
  """UDFC04"""
  uDFC04: String
  """UDFC05"""
  uDFC05: String
  """UDFC06"""
  uDFC06: String
  """UDFC07"""
  uDFC07: String
  """UDFC08"""
  uDFC08: String
  """UDFC09"""
  uDFC09: String
  """UDFC10"""
  uDFC10: String
  """UDFC11"""
  uDFC11: String
  """UDFC12"""
  uDFC12: String
  """UDFC13"""
  uDFC13: String
  """UDFC14"""
  uDFC14: String
  """UDFC15"""
  uDFC15: String
  """UDFC16"""
  uDFC16: String
  """UDFC17"""
  uDFC17: String
  """UDFC18"""
  uDFC18: String
  """UDFC19"""
  uDFC19: String
  """UDFC20"""
  uDFC20: String
  """UDFC21"""
  uDFC21: String
  """UDFC22"""
  uDFC22: String
  """UDFC23"""
  uDFC23: String
  """UDFC24"""
  uDFC24: String
  """UDFC25"""
  uDFC25: String
  """UDFC26"""
  uDFC26: String
  """UDFC27"""
  uDFC27: String
  """UDFC28"""
  uDFC28: String
  """UDFC29"""
  uDFC29: String
  """UDFC30"""
  uDFC30: String
  """UDFC31"""
  uDFC31: String
  """UDFC32"""
  uDFC32: String
  """UDFC33"""
  uDFC33: String
  """UDFC34"""
  uDFC34: String
  """UDFC35"""
  uDFC35: String
  """UDFC36"""
  uDFC36: String
  """UDFC37"""
  uDFC37: String
  """UDFC38"""
  uDFC38: String
  """UDFC39"""
  uDFC39: String
  """UDFC40"""
  uDFC40: String
  """UDFD01"""
  uDFD01: Date
  """UDFD02"""
  uDFD02: Date
  """UDFD03"""
  uDFD03: Date
  """UDFD04"""
  uDFD04: Date
  """UDFD05"""
  uDFD05: Date
  """UDFD06"""
  uDFD06: Date
  """UDFD07"""
  uDFD07: Date
  """UDFD08"""
  uDFD08: Date
  """UDFD09"""
  uDFD09: Date
  """UDFD10"""
  uDFD10: Date
  """UDFD11"""
  uDFD11: Date
  """UDFD12"""
  uDFD12: Date
  """UDFD13"""
  uDFD13: Date
  """UDFD14"""
  uDFD14: Date
  """UDFD15"""
  uDFD15: Date
  """UDFD16"""
  uDFD16: Date
  """UDFD17"""
  uDFD17: Date
  """UDFD18"""
  uDFD18: Date
  """UDFD19"""
  uDFD19: Date
  """UDFD20"""
  uDFD20: Date
  """UDFN01"""
  uDFN01: Float
  """UDFN02"""
  uDFN02: Float
  """UDFN03"""
  uDFN03: Float
  """UDFN04"""
  uDFN04: Float
  """UDFN05"""
  uDFN05: Float
  """UDFN06"""
  uDFN06: Float
  """UDFN07"""
  uDFN07: Float
  """UDFN08"""
  uDFN08: Float
  """UDFN09"""
  uDFN09: Float
  """UDFN10"""
  uDFN10: Float
  """UDFN11"""
  uDFN11: Float
  """UDFN12"""
  uDFN12: Float
  """UDFN13"""
  uDFN13: Float
  """UDFN14"""
  uDFN14: Float
  """UDFN15"""
  uDFN15: Float
  """UDFN16"""
  uDFN16: Float
  """UDFN17"""
  uDFN17: Float
  """UDFN18"""
  uDFN18: Float
  """UDFN19"""
  uDFN19: Float
  """UDFN20"""
  uDFN20: Float
  """UDFN21"""
  uDFN21: Float
  """UDFN22"""
  uDFN22: Float
  """UDFN23"""
  uDFN23: Float
  """UDFN24"""
  uDFN24: Float
  """UDFN25"""
  uDFN25: Float
  """UDFN26"""
  uDFN26: Float
  """UDFN27"""
  uDFN27: Float
  """UDFN28"""
  uDFN28: Float
  """UDFN29"""
  uDFN29: Float
  """UDFN30"""
  uDFN30: Float
  """UDFN31"""
  uDFN31: Float
  """UDFN32"""
  uDFN32: Float
  """UDFN33"""
  uDFN33: Float
  """UDFN34"""
  uDFN34: Float
  """UDFN35"""
  uDFN35: Float
  """UDFN36"""
  uDFN36: Float
  """UDFN37"""
  uDFN37: Float
  """UDFN38"""
  uDFN38: Float
  """UDFN39"""
  uDFN39: Float
  """UDFN40"""
  uDFN40: Float
  """Update Date"""
  updateDate: DateTime
  """The last date this record's fax # was updated."""
  updateFaxDate: Date
  """Update User"""
  updateUser: String
  """Update User ID"""
  updateUserId: Float
  """Upload Date"""
  uploadDate: Date
  """Vendor ID"""
  vendorId: Float
  """The Oracle Financial vendor site id for this record.  Used with the Oracle Financials A/P interface."""
  vendorSiteId: Float
  """Not Used."""
  vipAuthorization: String
  """VIP Name"""
  vipName: String
  """VIP Status"""
  vipStatus: String
  """Country Specific Requirement for Nigeria."""
  visaValidityType: 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
}