# title : OPERA Cloud RnA FinancialCommissions GraphQL API, # description : GraphQL API to cater for Detailed information on the commissions module, including Reservation and Travel Agent profile information, with commission codes, amounts, payment activity and processing status. Commission information can be reported across all properties by Travel Agent and Source profiles, bank account, guest information and dates. # 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. # - commissionagentDetailsChainCode input FinancialCommissionsQueryArgumentsType { """Active Flag""" commissionagentDetailsActiveYn: StringInput """Chain Code""" commissionagentDetailsChainCode: StringInput! @mandatoryInput """Company""" commissionagentDetailsCompany: StringInput """Corp ID""" commissionagentDetailsNameCode: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" commissionagentDetailsDsi: FloatInput """History Y/N""" commissionagentDetailsHistoryYn: StringInput """Inactive Date""" commissionagentDetailsInactiveDate: DateTimeInput """Organization ID""" commissionagentDetailsOrganizationId: FloatInput """JRN Update Date and Time""" commissionagentDetailsJrnupdatedttm: DateTimeInput """Last""" commissionagentDetailsLast: StringInput """Name ID""" commissionagentDetailsNameId: FloatInput """Internal ID to uniquely identify the Organization""" commissionagentDetailsOrganizationid: FloatInput """Profile Type""" commissionagentDetailsProfileType: StringInput """Profile Type Code""" commissionagentDetailsNameType: StringInput """Resort for which Job is registered.""" commissionagentDetailsResortRegistered: StringInput """Uppercase value of First Name.""" commissionagentDetailsSfirst: StringInput """The Uppercase value of Last or Company.""" commissionagentDetailsSname: StringInput """Internal Indexed field for Searching by Extended Byte First Name.""" commissionagentDetailsSxfirstName: StringInput """Internal Indexed field for Searching by Extended Byte Name.""" commissionagentDetailsSxname: StringInput """Top Account ID""" commissionagentDetailsProfileId: FloatInput """Update Date""" commissionagentDetailsUpdateDate: DateTimeInput """Account ID""" profilecommbankaccountDetailsAccountId: FloatInput """Central Xchange Date""" profilecommbankaccountDetailsCXchangeDate: DateInput """DSI Internal Data Source ID to identify Opera Chain and instance""" profilecommbankaccountDetailsDsi: FloatInput """JRN Update Date and Time""" profilecommbankaccountDetailsJrnupdatedttm: DateTimeInput """Name ID""" profilecommbankaccountDetailsNameId: FloatInput """Internal ID to uniquely identify the Organization""" profilecommbankaccountDetailsOrganizationid: FloatInput """Account ID""" profilecommbankaccountDetailsPcAccountId: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" profilecommbankaccountDetailsPcDsi: FloatInput """Internal ID to uniquely identify the Organization""" profilecommbankaccountDetailsPcOrganizationid: FloatInput """Code to uniquely identify the Property""" profilecommbankaccountDetailsPcResort: StringInput """Property""" profilecommbankaccountDetailsResort: StringInput """Actual Check In Date Time""" computedcommresvDetailsActualCheckInDateTime: DateTimeInput """Actual Check Out Date Time""" computedcommresvDetailsActualCheckOutDateTime: DateTimeInput """Actual Check-Out Date""" computedcommresvDetailsActualCheckOutDate: DateInput """Addressee Name ID""" computedcommresvDetailsAddresseeNameId: FloatInput """Arrival Date""" computedcommresvDetailsTruncBeginDate: DateInput """Billing Contact ID""" computedcommresvDetailsBillingContactId: FloatInput """Billing Contact Profile ID""" computedcommresvDetailsBillingcontactprofileid: FloatInput """Bonus Check ID""" computedcommresvDetailsBonusCheckId: FloatInput """Business Date Created""" computedcommresvDetailsBusinessDateCreated: DateInput """Central Xchange Date""" computedcommresvDetailsCXchangeDate: DateInput """CC JRN Update Date and Time""" computedcommresvDetailsCcjrnupdatedttm: DateTimeInput """Cancellation Date""" computedcommresvDetailsCancellationDate: DateTimeInput """Cancellation Number""" computedcommresvDetailsCancellationNo: StringInput """Credit Card ID""" computedcommresvDetailsCreditCardId: FloatInput """Custom Reference Number""" computedcommresvDetailsCustomReference: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" computedcommresvDetailsDsi: FloatInput """Departure Date""" computedcommresvDetailsTruncEndDate: DateInput """Endbusinessdate""" computedcommresvDetailsEndbusinessdate: DateInput """Event ID""" computedcommresvDetailsEventId: FloatInput """Date the folio was changed to closed.""" computedcommresvDetailsFolioCloseDate: DateInput """Guaranteecodeid""" computedcommresvDetailsGuaranteecodeid: StringInput """Guestprofileid""" computedcommresvDetailsGuestprofileid: FloatInput """Insert Action Instance ID""" computedcommresvDetailsInsertActionInstanceId: FloatInput """Insert Date""" computedcommresvDetailsInsertDate: DateTimeInput """Insert User""" computedcommresvDetailsInsertUser: FloatInput """Award Membership ID""" computedcommresvDetailsAwardMembershipId: FloatInput """JRN Update Date and Time""" computedcommresvDetailsJrnupdatedttm: DateTimeInput """Linked Departure Date""" computedcommresvDetailsEndDate: DateTimeInput """Internal ID to uniquely identify the Property""" computedcommresvDetailsLocationid: StringInput """Name Usage Type""" computedcommresvDetailsNameUsageType: StringInput """Internal ID to uniquely identify the Organization""" computedcommresvDetailsOrganizationid: FloatInput """Original End Date""" computedcommresvDetailsOriginalEndDate: DateInput """Parent Resv Name ID""" computedcommresvDetailsParentResvNameId: FloatInput """Parentreservationid""" computedcommresvDetailsParentreservationid: FloatInput """Identifies the charging status of the reservation after check out. O=Open Checkout P=Charging Privileges C=Closed Checkout.""" computedcommresvDetailsPostCoFlag: StringInput """Quote ID provided by external system.""" computedcommresvDetailsQuoteId: StringInput """Resv Contact ID""" computedcommresvDetailsResvContactId: FloatInput """Reservation Name ID""" computedcommresvDetailsResvNameId: FloatInput """Reservation Status""" computedcommresvDetailsResvStatus: StringInput """Reservation Type""" computedcommresvDetailsGuaranteeCode: StringInput """Reservationid""" computedcommresvDetailsReservationid: FloatInput """Property""" computedcommresvDetailsResort: StringInput """Auto generated charge number for Point Of Sale systems to identify guests.""" computedcommresvDetailsResortChargeNumber: StringInput """Reservation Nameid""" computedcommresvDetailsResvNameid: FloatInput """Resvcontactprofileid""" computedcommresvDetailsResvcontactprofileid: FloatInput """Rh Billing Contact ID""" computedcommresvDetailsRhBillingContactId: FloatInput """Rh Resv Contact ID""" computedcommresvDetailsRhResvContactId: FloatInput """Is the guest scheduled for automatic check out?""" computedcommresvDetailsScheduleCheckoutYn: StringInput """This is CAPITOL version of guest_first_name""" computedcommresvDetailsSguestFirstname: StringInput """Sguest Name""" computedcommresvDetailsSguestName: StringInput """Shared Confirmation Number""" computedcommresvDetailsConfirmationNo: StringInput """Shared Profile ID""" computedcommresvDetailsNameId: FloatInput """Shared Reservation Status""" computedcommresvDetailsReservationStatus: StringInput """Stores resv_name_id of the original multi room reservation from which this reservation is split off.""" computedcommresvDetailsSplitFromResvNameId: FloatInput """Splitfromreservationid""" computedcommresvDetailsSplitfromreservationid: FloatInput """This is the actual check out date with no time component.""" computedcommresvDetailsTruncActualCheckOutDate: DateInput """Universal Card ID used by interfaces for key encoding purposes.""" computedcommresvDetailsUniCardId: StringInput """Update Date""" computedcommresvDetailsUpdateDate: DateTimeInput """JRN Update Date and Time""" checkregisterDetailsJrnupdatedttm: DateTimeInput } type Query { """Detailed information on the commissions module including Reservation and Travel Agent profile information with commission codes amounts payment activity and processing status. Commission information can be reported across all properties by Travel Agent and Source profiles bank account guest information and dates.""" financialCommissions(limit: Int offset: Int input: FinancialCommissionsQueryArgumentsType!): [FinancialCommissionsType] } type FinancialCommissionsType { """Commission Agent Details""" commissionAgentDetails: FinancialCommissionsCommissionAgentDetailsType """Profile Commission Bank Account Details""" profileCommissionBankAccountDetails: FinancialCommissionsProfileCommissionBankAccountDetailsType """Computed Commission Reservation Details""" computedCommissionsReservationDetails: FinancialCommissionsComputedCommissionsReservationDetailsType """Check Register Details""" checkRegisterDetails: FinancialCommissionsCheckRegisterDetailsType financialCommissionsRecordCount: Int } type FinancialCommissionsCommissionAgentDetailsType { """AR Number""" aRNumber: String """The date this record was last updated by the ARC update program.""" aRCUpdateDate: Date """Account Email Primary""" accountEmailPrimary: String """Account Name 2""" accountName2: String """Account Name 3""" accountName3: 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 Code""" addressLanguageCode: String """Address Type""" addressType: 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 """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 Description""" businessSegementDescription: String """Business Segment""" businessSegment: String """Business Title""" businessTitle: String """Central Account Source""" centralAccountSource: String """Central Account Source Description""" centralAccountSourceDescription: 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 Mail Action""" centralMailAction: String """Central Mail Action Description""" centralMailActionDescription: String """Central Priority""" centralPriority: String """Central Priority Description""" centralPriorityDescription: 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 """Corp ID""" corpID: 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 Code""" countryCode: 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 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""" 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 """Profile Type Description""" profileTypeDescription: String """Protected""" protected: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Reference Currency""" referenceCurrency: String """Rep Account Type""" repAccountType: String """Reporting Influence""" repInfluence: String """Reporting Influence Desc""" repInfluenceDescription: String """Rep Name Type""" repNameType: String """Reporting Nationality Code""" repNationalityCode: String """Reporting Nationality Description""" repNationalityDescription: String """Reporting State Desc""" repStateDescription: String """Reporting Tax Type Desc""" repTaxTypeDescription: String """Reporting Title""" repTitle: 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 Description""" scopeCityDescription: String """Scope Description""" scopeDescription: String """Uppercase value of First Name.""" sfirst: String """The Uppercase value of Last or Company.""" sname: String """State""" state: String """State Description of the Guest of Payee""" stateDesc: String """State Description""" stateDescription: 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 """Title""" title: String """Top Account ID""" topAccountID: Float """Top Account Name""" topAccountName: 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 FinancialCommissionsProfileCommissionBankAccountDetailsType { """Account ID""" accountId: Float """Account Number""" accountNumber: String """Flag to identify bank type [O] OVOS user""" bankAcctType: String """Code for the bank account""" bankCode: String """Code for the bank accounts branch""" branchCode: String """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Commission Code""" centralCommissionCode: String """Central Commission Code Description""" centralCommissionCodeDescription: String """Central Min. Processing Amount""" centralMinProcessingAmount: Float """Check Report""" checkReport: String """Number of lines to be printed on check stub""" checkSubLines: Float """Commission Code""" commissionCode: String """Commission Code Description""" commissionCodeDescription: String """Currency""" currency: String """Currency Description""" currencyDescription: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Default YN""" defaultYN: String """Only one 'Y' value is permitted per resort / currency combination used mainly by interface to figure out default bank for resort and currency combination""" defaultForCurrencyYN: String """Deleted Flag""" deletedFlag: String """Bank name""" description: String """Check number allowed to be edited Y/N""" editCheckNumberYN: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Language""" language: String """Laptop Change""" laptopChange: Float """Last Export File Run Date""" lastExportDate: Date """Last Export Run File Number""" lastExportedFile: Float """Internal ID to uniquely identify the Property""" locationID: String """Internal""" maxCheckNo: Float """Minimum amount required to produce a check through commission processing for the selected account.""" minProcessingAmount: Float """Name ID""" nameId: Float """Last check number used by commisison handling module for bank account selected""" nextCheckNumber: Float """On Hold""" onHold: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Paid in AR""" paidInAR: Float """Payment Method""" paymentMethod: String """Indicate that the bank account uses Positive Pay Export.""" positivePayExportYN: String """Potential""" potential: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Account ID""" profileCommissionAccountId: Float """Created By User""" profileCommissionCreatedByUser: Float """Created On Date""" profileCommissionCreatedOnDate: DateTime """DSI Internal Data Source ID to identify Opera Chain and instance""" profileCommissionDSI: Float """Deleted Flag""" profileCommissionDeletedFlag: String """Profile Commission JRN Update Date""" profileCommissionJRNUpdateDate: DateTime """Profile Commission JRN Update Date and Time""" profileCommissionJRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Organization""" profileCommissionOrganizationID: Float """Internal Primary Key ID to uniquely identify the row""" profileCommissionPrimaryKeyID: Float """Code to uniquely identify the Property""" profileCommissionProperty: String """RnA Insertdate""" profileCommissionRnaInsertDate: DateTime """RnA Updatedate""" profileCommissionRnaUpdateDate: DateTime """Update Date""" profileCommissionUpdateDate: DateTime """Update User""" profileCommissionUpdateUser: Float """Property""" property: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Routing number for the bank account""" routingNumber: String """Source directory for importing commission information.""" sourceImportDir: String """Target directory where import files will be stored.""" targetImportDir: String """Indicate that bank account use 1099 report""" tax1099ReportYN: String """To Be Paid""" toBePaid: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float """Force validation of TA/Source IATA number during commision payment process.""" validateIATANumberYN: String } type FinancialCommissionsComputedCommissionsReservationDetailsType { """Indicates whether a prorated amount should be used for an Apartment Style Billing rate.""" aSBProratedYn: String """Accompanied YN""" accompaniedYN: String """Accompanying guest names.""" accompanyingName: String """Receivables Amount.""" accountsReceivablesOffset: Float """Indicate that this commission should be treated as a direct bill settlement.""" accountsReceivablesYN: String """Actual Check In Date Time""" actualCheckInDateTime: DateTime """Actual Check Out Date Time""" actualCheckOutDateTime: DateTime """Actual Check-In Date""" actualCheckInDate: Date """Actual Check-In Time""" actualCheckInTime: String """Actual Check-Out Date""" actualCheckOutDate: Date """Actual Check-Out Time""" actualCheckOutTime: String """Address ID""" addressId: Float """Addressee Name ID""" addresseeNameId: Float """Contains notes about user actions when user manually adjusts commission.""" adjustmentNote: String """Adults""" adults: Float """Adults Tax Free""" adultsTaxFree: Float """Indicates if the reservation has performed an Advance Check In.""" advanceCheckedInYn: String """Agencyprofileid""" agencyprofileid: Float """Indicates whether the room type inventory was taken from the allotment or House availabilty.""" allotmentRecordType: String """Block ID""" allotmentid: Float """SPG - Indicates if this stay is eligible for an Amenity.""" amenityEligibleYn: String """Amenity Level Code""" amenityLevelCode: String """Commission for TA.""" amount: Float """Amount Percent""" amountPercent: Float """Approval Amount""" approvalAmount: Float """Approval Amount Calc Method""" approvalAmountCalcMethod: Float """Approval Code""" approvalCode: String """Arrival Comments""" arrivalComments: String """Arrival Date""" arrivalDate: Date """Arrival Date Time""" arrivalDateTime: DateTime """Arrival Estimate Time""" arrivalEstimateTime: Date """Activity begin time""" arrivalTime: String """Arrivaltransportid""" arrivaltransportid: String """Not used.""" authorizedBillingYN: String """This stores the pmsp.logged_uid who authorizes the direct bill""" authorizedBy: Float """Authorizer ID""" authorizerId: Float """Auto Checkin Y/N""" autoCheckinYn: String """Activates auto population of routing instructions.""" autoPopulateRoutingYn: String """Auto Settle Days""" autoSettleDays: Float """Auto Settle Type""" autoSettleType: String """Auto Settle YN""" autoSettleYN: String """Award Code""" awardCode: String """Award code 1""" awardCode1: String """Award code 2""" awardCode2: String """Award code 3""" awardCode3: String """Award Code 4""" awardCode4: String """Award code 5""" awardCode5: String """Award Membership ID""" awardMembershipID: Float """Award Voucher number 1""" awardVoucher1: String """Award Voucher number 2""" awardVoucher2: String """Award Voucher number 3""" awardVoucher3: String """Award Voucher number 4""" awardVoucher4: String """Award Voucher number 5""" awardVoucher5: String """Room Type before the Upgrade Award""" awdUpgrFrom: String """Room Type after the Upgrade Award""" awdUpgrTo: String """Back To Back YN""" backToBackYN: String """Balance on the account.""" balance: Float """Base Rate Amount""" baseRateAmount: Float """Base Rate Code""" baseRateCode: String """Base Rate Currency Code""" baseRateCurrencyCode: String """Based On Rule""" basedOnRule: String """Baseratecurrencyid""" baseratecurrencyid: String """Begin City""" beginCity: String """Begin Datetime""" beginDatetime: DateTime """Begin District""" beginDistrict: String """Begin State""" beginState: String """Stores the actual guest check in date and time.""" beginSystemDateTime: DateTime """Bill Number""" billNumber: String """Billing Contact""" billingContact: String """Billing Contact Display Name""" billingContactDisplayName: String """Billing Contact ID""" billingContactId: Float """Billing Contact Name""" billingContactName: String """Billing Contact Profile ID""" billingcontactprofileid: Float """Block Code""" blockCode: String """Block Create Date""" blockCreateDate: DateTime """Block ID""" blockID: Float """Block Name""" blockName: String """Property this block belongs to.""" blockResort: String """Block Status""" blockStatus: String """Bonus Check ID""" bonusCheckId: Float """Booked Room Category""" bookedRoomCategory: String """Bookedroomcategoryid""" bookedroomcategoryid: String """Business Date Created""" businessDateCreated: Date """Business Datetime Created""" businessDatetimeCreated: DateTime """Bxgy Discount Y/N""" bxgyDiscountYn: String """Central Auto Post Amount""" cAutoPostAmount: Float """Central Base Rate Amount""" cBaseRateAmount: Float """Central Commissionable Revenue""" cCommissionableRevenue: Float """C Discount Amount""" cDiscountAmount: Float """C Discount Amt""" cDiscountAmt: Float """C Effective Rate Amount""" cEffectiveRateAmount: Float """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Fixed Charge""" cFixedCharge: Float """Central Gross Rate Amt""" cGrossRateAmount: Float """Central Local Base Rate Amount""" cLocalBaseRateAmount: Float """Central Net Room Amt""" cNetRoomAmount: Float """Central Original Base Rate""" cOriginalBaseRate: Float """Central Pkg Amt""" cPackageAmount: Float """Central Pkg Tax""" cPackageTax: Float """C Rate Amount""" cRateAmount: Float """Central Room Cost""" cRoomCost: Float """Central Room Tax""" cRoomTax: Float """Central Share Amount Original""" cShareAmountOriginal: Float """Central Upsell Charge""" cUpsellCharge: Float """CC JRN Update Date""" cCJRNUpdateDate: Date """CC JRN Update Date and Time""" cCJRNUpdateDateAndTime: DateTime """CC RNA Insertdate""" cCRNAInsertDate: DateTime """CC RNA Updatedate""" cCRNAUpdateDate: DateTime """Cancel Date""" cancelDate: Date """Cancel Reason""" cancelReason: String """Cancel Time""" cancelTime: String """Cancellation Date""" cancellationDate: DateTime """Cancellation Datetime""" cancellationDatetime: DateTime """Cancellation Number""" cancellationNumber: String """Cancellation Reason Description""" cancellationReasonDescription: String """Cancellationreasonid""" cancellationreasonid: String """The user who canceled this Reservation.""" cancelledBy: String """Card Number by Membership Class""" cardNumberByMembershipClass: String """Card Number by Membership Type""" cardNumberByMembershipType: String """Central Accounts Receivables Offset""" centralAccountsReceivablesOffset: Float """Central Amount""" centralAmount: Float """Central Approval Amount""" centralApprovalAmount: Float """Central Cancel Reason""" centralCancelReason: String """Central Commission Code""" centralCommissionCode: String """Central Commission Description""" centralCommissionDescription: String """Central Credit Limit""" centralCreditLimit: Float """Central Discount Reason""" centralDiscountReason: String """Central Discount Reason Description""" centralDiscountReasonDescription: String """Central FB Revenue""" centralFBRevenue: Float """Central Guest Type""" centralGuestType: String """Central Hurdle""" centralHurdle: Float """Central Package Code""" centralPackageCode: String """Central Package Code Description""" centralPackageCodeDescription: String """Central Package Forecast Group""" centralPackageForecastGroup: String """Central Package Forecast Group Description""" centralPackageForecastGroupDescription: String """Central Payment Amount""" centralPaymentAmount: Float """Central Prepaid""" centralPrepaid: Float """Central Projected FB Revenue""" centralProjectedFBRevenue: Float """Central Projected Room Revenue""" centralProjectedRoomRevenue: Float """Central Projected Total Revenue""" centralProjectedTotalRevenue: Float """Central Promotion Description""" centralPromotionDescription: String """Central Rateable Value""" centralRateableValue: Float """Central Reservation Type""" centralReservationType: String """Central Reservation Type Description""" centralReservationTypeDescription: String """Central Room Revenue""" centralRoomRevenue: Float """Central Room Type Code""" centralRoomTypeCode: String """Central Room Type Description""" centralRoomTypeDescription: String """Central Room Type To Charge Code""" centralRoomTypeToChargeCode: String """Central Room Type to Charge Description""" centralRoomTypeToChargeDescription: String """Central Shared Room Rate""" centralSharedRoomRate: Float """Central Special Request Description""" centralSpecialRequestDescription: String """Central Commission Code""" centralTACommissionCode: String """Central Commission Description""" centralTACommissionDescription: String """Central Tax""" centralTax: Float """Central Tax Type""" centralTaxType: String """Central Tax Type Description""" centralTaxTypeDescription: String """Central Total Cost of Stay""" centralTotalCostOfStay: Float """Central Total Revenue""" centralTotalRevenue: Float """Central Total Room Rate""" centralTotalRoomRate: Float """Central Waitlist Priority""" centralWaitlistPriority: String """Central Waitlist Priority Description""" centralWaitlistPriorityDescription: String """Central Waitlist Reason""" centralWaitlistReason: String """Central Waitlist Reason Description""" centralWaitlistReasonDescription: String """Channel Description""" channelDescription: String """Channel Order By""" channelOrderBy: Float """Channelid""" channelid: String """Check In Initiated By""" checkInInitiatedBy: String """Duration in seconds to complete Check-In""" checkinDuration: Float """Child Bucket 1""" childBucket1: Float """Child Bucket 4""" childBucket4: Float """Child Bucket 5""" childBucket5: Float """Children""" children: Float """Children Age Group 2)""" childrenAgeGroup2: Float """Children Age Group 3)""" childrenAgeGroup3: Float """Children Ages""" childrenAges: String """Commission status.""" commStatus: String """Commission Type""" commType: String """Commission Code""" commissionCode: String """Whether reservation has different rates codes of different commission codes.""" commissionCodeDifferenceYN: String """Commission Description""" commissionDescription: String """Commission Hold Code""" commissionHoldCode: String """Hold Code Description.""" commissionHoldDesc: String """Commission Paid""" commissionPaid: Float """Indicates to whom the commission will be paid: NULL T (Travel Agent) S (Source) and B (Both).""" commissionPayoutTo: String """Amount for which TA/Source receives commission.""" commissionableRevenue: Float """Commissionable YN""" commissionableYN: String """Commissionid""" commissionid: String """Comp House""" compHouse: String """Comp Type Code""" compTypeCode: String """Company City""" companyCity: String """Company Country""" companyCountry: String """Company ID""" companyID: Float """Company Name""" companyName: String """Company Profile Corporate ID""" companyProfileCorporateID: String """Company Profile ID""" companyProfileID: Float """Complimentary YN""" complimentaryYN: String """Compreasonid""" compreasonid: String """Begin Date""" computedCommissionsBeginDate: Date """Business Date Created""" computedCommissionsBusinessDateCreated: Date """Central Xchange Date""" computedCommissionsCExchangeDate: Date """Central Xchange Rate""" computedCommissionsCExchangeRate: Float """Primary Key.""" computedCommissionsCommissionId: Float """DSI Internal Data Source ID to identify Opera Chain and instance""" computedCommissionsDSI: Float """Deleted Flag""" computedCommissionsDeletedFlag: String """End Date""" computedCommissionsEndDate: Date """Exchange Rate""" computedCommissionsExchangeRate: Float """Hold Reason Code""" computedCommissionsHoldReasonCode: String """Insert Date""" computedCommissionsInsertDate: DateTime """Insert User""" computedCommissionsInsertUser: Float """Internal ID to uniquely identify the Organization""" computedCommissionsOrganizationID: Float """Internal Primary Key ID to uniquely identify the row""" computedCommissionsPrimaryKeyID: Float """Code to uniquely identify the Property""" computedCommissionsProperty: String """Resv Name ID""" computedCommissionsReservationNameId: Float """Travel Agent ID""" computedCommissionsTravelAgentId: Float """Update Date""" computedCommissionsUpdateDate: DateTime """Update User""" computedCommissionsUpdateUser: Float """Calculated reservation status.""" computedResvStatus: String """Confirmation Leg Number.""" confirmationLegNumber: Float """Consumer Y/N""" consumerYn: String """Contact Name; UDFC02 on reservation.""" contactName: String """Contact Profile ID""" contactProfileID: Float """Contact Profile Name""" contactProfileName: String """The name of the user who created the record.""" createdBy: String """Created By Default Property""" createdByDefaultResort: String """Created Date""" createdDate: Date """Refer to the same column name in the table IFC_WAKE""" createdTime: String """Credit Card Auth Date""" creditCardAuthDate: Date """Credit Card ID""" creditCardId: Float """Credit Limit""" creditLimit: Float """Indicates if the reservation has opted-in for auto payment when credit limit overage is detected.""" creditLimitAutoPayAllowYn: String """Cribs""" cribs: Float """Currency Code""" currencyCode: String """Custom Reference Number""" customReferenceNumber: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Country Specific Requirement for Nigeria.""" dateOfArrivalInCountry: Date """Decimal Positions""" decimalPositions: Float """Deleted Flag""" deletedFlag: String """Departtransportid""" departtransportid: String """Departure""" departure: Date """Departure Comments""" departureComments: String """Departure Date""" departureDate: Date """Departure Date Time""" departureDateTime: DateTime """Departure Time""" departureTime: String """Departure Transport Code""" departureTransportCode: String """Departure Transportation YN""" departureTransportationYN: String """Stores the Deposit maturity preference.""" depositMaturityType: String """Direct Bill Verify Response""" directBillVerifyResponse: String """Directbillauthby""" directbillauthby: Float """Discount Amount""" discountAmount: Float """Discount Amount""" discountAmt: Float """Discount Percentage.""" discountPercent: Float """Discount Prcnt""" discountPrcnt: Float """Discount Reason""" discountReason: String """Discount Reason Description""" discountReasonDescription: String """Discountreasonid""" discountreasonid: String """Display Color""" displayColor: String """Dml Sequence No""" dmlSeqNumber: Float """Do Not Move Room""" doNotMoveRoom: String """Do not move room flag.""" doNotMoveYN: String """Drop Off Carrier Code""" dropOffCarrierCode: String """Drop Off Date""" dropOffDate: Date """Drop Off Station""" dropOffStation: String """Drop Off Time""" dropOffTime: String """Drop Off Type""" dropOffType: String """Drop Off Type Description""" dropOffTypeDescription: String """Comments related to Estimated Time of Return.""" eTRComments: String """Not used.""" effectiveRateAmount: Float """Indicates if the reservation is eligible to receive room upgrades. Controlled by Central System.""" eligibleForUpgradeYn: String """Email Address""" emailAddress: String """Email Folio Y/N""" emailFolioYn: String """Email ID""" emailId: Float """Email Y/N""" emailYn: String """End City""" endCity: String """End Datetime""" endDatetime: DateTime """End District""" endDistrict: String """End State""" endState: String """Endbusinessdate""" endbusinessdate: Date """Entry Date into the country. (Croatian Requirements)""" entryDate: Date """(Customized) Entry point into the country. (Croatian Requirements)""" entryPoint: String """Name of file that contains the electronically signed registration card.""" esignedRegCardName: String """Estimated Departure Time""" estimatedDepartureTime: Date """Event ID""" eventId: Float """Exchange Posting Type""" exchangePostingType: String """Exchange Rate""" exchangeRate: Float """Exclude From Auto Authorization YN""" excludeFromAutoAuthorizationYN: String """The time when an Advance Checked-In Guest is expected to return to perform the actual Check-In.""" expectedTimeOfReturnETR: DateTime """Used for Croatian Requirement Exports to store a unique checkin number.""" exportCheckinresId: Float """Not used""" extSegNo: Float """Not used""" extSeqNumber: Float """Internal extension number for the main reservation""" extensionId: Float """Indicates if the guest has opted to receive Efolio through an external system.""" externalEfolioYn: String """External Reference""" externalReference: String """External References List""" externalReferencesList: String """Extra Beds""" extraBeds: Float """FB Revenue""" fBRevenue: Float """Fax ID""" faxId: Float """Should a confirmation be faxed for this reservation name? Y/N""" faxYn: String """This stores the codes for the rooms features. Currently not used""" feature: String """Financially Responsible Y/N""" financiallyResponsibleYn: String """Not used.""" fixedCharge: Float """Fixed Rate YN""" fixedRateYN: String """Oracle sequence to identify different attribute values of an address.""" folioAddrElementId: Float """Date the folio was changed to closed.""" folioCloseDate: Date """Folio Number""" folioNumber: String """Folio Text1""" folioText1: String """Folio Text2""" folioText2: String """Foreign Currency ID""" foreignCurrencyID: String """Free Child""" freeChild: Float """Frequent Flyer Membership YN""" frequentFlyerMembershipYN: String """Gross Rate Future""" grossRateFuture: Float """Gross Rate Past""" grossRatePast: Float """Group Name""" groupName: String """Group Profile AR Number""" groupProfileARNumber: Float """Group Profile AR Number (Central)""" groupProfileARNumberCentral: String """Group Profile Client ID""" groupProfileClientID: String """Group Profile ID""" groupProfileID: Float """Group Profile Name""" groupProfileName: String """Guarantee code before check in. Populated when the guarantee code is changed to CHECKED IN.""" guaranteeCodePreCi: String """Guaranteecodeid""" guaranteecodeid: String """Guest First Name""" guestFirstName: String """This is soundex of GUEST FIRST NAME - Phonotic sound.""" guestFirstNameSdx: String """This is soundex of GUEST LAST NAME - Phonotic sound.""" guestLastNameSdx: String """Signature of the guest""" guestSignature: String """Used for Police/Tourist Export""" guestStatus: String """Guest Type""" guestType: String """Guestprofileid""" guestprofileid: Float """Gueststatusid""" gueststatusid: String """Guesttypeid""" guesttypeid: String """Hold Amount""" holdAmount: Float """Hold Reason Code Description""" holdReasonCodeDescription: String """Hold Reason Description""" holdReasonDescription: String """Housekeeping Service Time""" housekeepingServiceTime: String """Hurdle""" hurdle: Float """Hurdle Override""" hurdleOverride: String """ID by Membership Class""" iDByMembershipClass: String """ID by Membership Type""" iDByMembershipType: String """Guest Address.""" individualCity: String """Country of the guest""" individualCountry: String """Individual First Name""" individualFirstName: String """Individual Last Name""" individualLastName: String """Insert Action Instance ID""" insertActionInstanceId: Float """Insert Date""" insertDate: DateTime """Insert DateTime""" insertDateTime: DateTime """Insert User""" insertUser: Float """Intermediary Y/N""" intermediaryYn: String """Award Membership ID""" internalAwardMembershipId: Float """Baseratecode""" internalBaseratecode: String """Block ID.""" internalBlockId: Float """Companyprofileid""" internalCompanyprofileid: Float """Groupprofileid""" internalGroupprofileid: Float """Sourceprofileid""" internalSourceprofileid: Float """Items and Quantities""" itemsQuantities: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Key Valid Until""" keyValidUntil: Date """Last Online-Printing Sequence Number used by this reservation.""" lastOnlinePrintSeq: Float """Latest date when a folio was printed using the "Periodic Batch Folios" option""" lastPeriodicFolioDate: Date """Not used.""" lastRoomNumber: String """Latest date when a direct bill settlement was automatically done using the "Direct Bill Batch Folios" option""" lastSettleDate: Date """Lead Time for ordering""" leadTimeDays: Float """Length of Stay""" lengthOfStay: Float """Linked Arrival Date""" linkedArrivalDate: DateTime """Linked Departure Date""" linkedDepartureDate: DateTime """Linked Room Type""" linkedRoomType: String """Membership ID""" listOfMembershipID: String """Local Base Rate Amount""" localBaseRateAmount: Float """Internal ID to uniquely identify the Property""" locationID: String """Loyalty Scheme Membership YN""" loyaltySchemeMembershipYN: String """Mail Y/N""" mailYn: String """Indicates if this Reservation has requested or processed a Manual Checkout for consumer mobility. Possible Values: NULL [R]equested [P]rocessed.""" manualCheckoutStatus: String """Stores the manually entered amount.""" manualEditYn: String """Indicates if the reservation was added from the Commissions menu and attached to the travel agent or source.""" manualReservationYN: String """Market Code""" marketCode: String """Marketid""" marketid: String """Mc Gen Begin District""" mcGenBeginDistrict: String """Mc Gen Begin State""" mcGenBeginState: String """Mc Gen End District""" mcGenEndDistrict: String """Mc Gen End State""" mcGenEndState: String """Mc Gen Next Country""" mcGenNextCountry: String """Mc Gen Previous Country""" mcGenPreviousCountry: String """Member Description""" memberDescription: String """Member Level""" memberLevel: String """Member Number""" memberNumber: String """Membership Class""" membershipClass: String """Membership Class Description""" membershipClassDescription: String """Membership Code""" membershipCode: String """Membership ID""" membershipId: Float """Membership Level by Membership Class""" membershipLevelByMembershipClass: String """Membership Type by Membership Class""" membershipTypeByMembershipClass: String """Stores when this Reservation has received a mobile action needed Alert for consumer mobility.""" mobileActionAlertIssued: Date """Marked as Y when the Phone Number/EMail Address is Opt In.""" mobileAudioKeyYn: String """Mobile Checkin Allowed Y/N""" mobileCheckinAllowedYn: String """Mobile Chkout Allowed""" mobileChkoutAllowed: String """Currency preferred by a Mobile Registered Guest.""" mobilePreferredCurrency: String """Indicates if the reservation is eligible to view the folio by sending a mobile message.""" mobileViewFolioAllowed: String """Name""" name: String """Name Usage Type""" nameUsageType: String """Next Country""" nextCountry: String """Country Specific Requirement for Nigeria.""" nextDestination: String """No of Rooms""" numberOfRooms: Float """On Hold YN""" onHoldYN: String """Indicates if reservation?s registration card was esigned via Opera.""" operaEsignedRegCardYn: String """Indicates if the guest has opted in to receive email through the batch folio option.""" optInBatchFolYn: String """Indicates if the reservation has opted-in for communications.""" optedForCommissionYN: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Origin Code""" originCode: String """Origin Of Booking""" originOfBooking: String """Not used.""" originalBaseRate: Float """Original End Date""" originalEndDate: Date """Original Start Date""" originalStartDate: Date """Indicates if commission for owner has been processed.""" ownerCommissionProcessedYN: String """Owner Ff Flag""" ownerFfFlag: String """Owner or Friends/Family""" ownerOrFriendsFamily: String """Package Code""" packageCode: String """Package Code Description""" packageCodeDescription: String """Package Forecast Group""" packageForecastGroup: String """Package Forecast Group Description""" packageForecastGroupDescription: String """Paid In AR Amount""" paidInArAmount: Float """Parent Resv Name ID""" parentReservationNameId: Float """Parentreservationid""" parentreservationid: Float """Part Allotment""" partAllotment: String """Party Code""" partyCode: String """Pax Number""" paxNo: Float """Payee Type Code.""" payeeType: String """Total amount of payment inclusive of VAT""" paymentAmount: Float """Payment ID""" paymentId: Float """Payment Method""" paymentMethod: String """Paymentmethodid""" paymentmethodid: String """Frequency in number of days when folios should be printed for this reservation""" periodicFolioFreq: Float """Indicates if the Phone Display Name is send to the Interface.""" phoneDisplayNameYn: String """Phone ID""" phoneId: Float """Physical Quantity""" physicalQuantity: Float """Pick Up Carrier Code""" pickUpCarrierCode: String """Pick Up Date""" pickUpDate: Date """Pick Up Station""" pickUpStation: String """Pick Up Transport Number""" pickUpTransportNumber: String """Pick Up Type""" pickUpType: String """Pick Up Type Description""" pickUpTypeDescription: String """Pick-Up Time""" pickUpTime: String """Pickup Required YN""" pickupRequiredYN: String """Points""" points: Float """Membership Points Eligibility Code.""" pointsEligibilityCode: String """Identifies the charging status of the reservation after check out. O=Open Checkout P=Charging Privileges C=Closed Checkout.""" postCoFlag: String """Indicates if the reservation has charging privileges after checkout.""" postStayChargingYN: String """Posting Allowed YN""" postingAllowedYN: String """Potential Amount""" potentialAmount: Float """Prepaid commission was edited Y/N.""" ppdEditYn: String """Remarks for the prepaid commission.""" ppdRemarks: String """This date flags if and when the record was reviewed from pre-arrival screen.""" preArrReviewedDt: DateTime """User id who reviewed the record.""" preArrReviewedUser: Float """Indicates if the reservation has charging privileges before arrival.""" preChargingYn: String """Indicates whether the reservation is pre-registered for internet check-in or not.""" preRegisteredYn: String """Preference""" preference: String """Preference Type""" preferenceType: String """Preferred Room Type""" preferredRoomType: String """Amount paid to TA/Source.""" prepaid: Float """Prepaid YN""" prepaidYN: String """Previous Country""" previousCountry: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Primary Share""" primaryShare: String """Print Rate YN""" printRateYN: String """Projected FB Revenue""" projectedFBRevenue: Float """Projected Room Revenue""" projectedRoomRevenue: Float """Projected Total Revenue""" projectedTotalRevenue: Float """Promotion Code""" promotionCode: String """Promotion Description""" promotionDescription: String """Indicates if the value set for the specific property.""" property: String """Total pseudo membership points accrued for the default membership type.""" pseudoMemTotalPoints: Float """Default membership type used with the Pseudo Membership Points calculation functionality.""" pseudoMemType: String """Purge Date""" purgeDate: DateTime """Purpose of stay.""" purposeOfStay: String """Number of Rooms""" quantity: Float """Queue priority of the reservation.""" queuePriority: Float """Queue Wait Time""" queueWaitTime: Float """Quote ID provided by external system.""" quoteId: String """Rate Amount""" rateAmount: Float """Rate Code""" rateCode: String """Event Reservation Rate Code Description""" rateCodeDescriptions: String """Tier ID for the Rate Detail.""" rateTier: Float """Stay rateable value.""" rateableValue: Float """Ratecodeid""" ratecodeid: String """Rd Housekeeping Expected Service Time""" rdHousekeepingExpectedServiceTime: String """Rd Reservation Status""" rdResvStatus: String """Rden Billing Contact ID""" rdenBillingContactId: Float """Rden Resv Contact ID""" rdenReservationContactId: Float """Rden Reservation Date""" rdenReservationDate: Date """Rden Property""" rdenResort: String """Rotation Rule to be configured for referral flag ?""" referralYn: String """Registration Card Number""" registrationCardNo: String """Registration Number""" registrationNumber: Float """Reinstate Date""" reinstateDate: DateTime """Reporting Channel""" repChannel: String """Reporting Channel Description""" repChannelDescription: String """Report ID""" reportId: String """Reservation Insert Source""" resInsertSource: String """Reservation Insert Source Type""" resInsertSourceType: String """Resv Contact ID""" reservationContactId: Float """Reservation Date""" reservationDate: DateTime """Reservation Name ID""" reservationNameID: Float """Reservation Status""" reservationStatus: String """Reservation Type""" reservationType: String """Reservation Type Description""" reservationTypeDescription: String """Reservationid""" reservationid: Float """Property""" resort: String """Auto generated charge number for Point Of Sale systems to identify guests.""" resortChargeNumber: String """Restriction Override""" restrictionOverride: String """Globally unique ID using SYS_GUID() as the source.""" resvGuid: String """Reservation Nameid""" resvNameid: Float """Not used in PMS currently.""" resvNumber: Float """Resvcontactprofileid""" resvcontactprofileid: Float """Revenue type (catering/rooms)""" revenueTypeCode: String """Rh Billing Contact ID""" rhBillingContactId: Float """Rh Resv Contact ID""" rhReservationContactId: Float """Rh Room Features""" rhRoomFeatures: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Room""" room: String """Room Category""" roomCategory: String """Room Class""" roomClass: String """Room Cost""" roomCost: Float """Room Instructions""" roomInstructions: String """Meeting Room Property""" roomResort: String """Room Revenue""" roomRevenue: Float """This is the Turndown room service time.""" roomServiceTime: String """Room Type Description""" roomTypeDescription: String """Room Type To Charge Code""" roomTypeToChargeCode: String """Room Type to Charge Description""" roomTypeToChargeDescription: String """Roomcategoryid""" roomcategoryid: String """Roomid""" roomid: String """Routing YN""" routingYN: String """Is the guest scheduled for automatic check out?""" scheduleCheckoutYn: String """This is CAPITOL version of guest_first_name""" sguestFirstname: String """Sguest Name""" sguestName: String """Share Confirmation Numbers""" shareConfirmationNumbers: String """Share ID.""" shareId: Float """Share Name""" shareName: String """Not used.""" sharePrcnt: Float """Type of revenue""" shareSeqNumber: Float """Share of Rate Amount""" shareOfRateAmount: Float """Shared Confirmation Number""" sharedConfirmationNo: String """Shared Guest Name""" sharedGuestName: String """Shared Profile ID""" sharedProfileID: Float """Shared Reservation Status""" sharedReservationStatus: String """Sharing YN""" sharingYN: String """Source City""" sourceCity: String """Source Code""" sourceCode: String """Source Country""" sourceCountry: String """Source Name""" sourceName: String """Source Profile AR Number""" sourceProfileARNumber: Float """Source Profile AR Number (Central)""" sourceProfileARNumberCentral: String """Source Profile IATA Number""" sourceProfileIATANumber: String """Source Profile ID""" sourceProfileID: Float """Source Profile Name""" sourceProfileName: String """Sourceid""" sourceid: String """Special Request""" specialRequest: String """Special Request Description""" specialRequestDescription: String """SPG Room Type Disclosure Flag. Indicates if the guest stationery will disclose the actual room type.""" spgDiscloseRoomTypeYn: String """SPG Suite Night Award Status.""" spgSuiteNightAwardStatus: String """SPG Upgrade Confirmed Room Type Label.""" spgUpgradeConfirmedRoomtype: String """SPG Upgrade Reason Code.""" spgUpgradeReasonCode: String """Stores resv_name_id of the original multi room reservation from which this reservation is split off.""" splitFromReservationNameId: Float """Splitfromreservationid""" splitfromreservationid: Float """Rate Tier used for exports(DRS).""" statisticalRateTier: Float """Room Type used to calculate statistics for export(DRS).""" statisticalRoomType: Float """Stay Record ID""" stayRecordId: Float """Suite Number""" suiteNumber: String """Super Search Index Text""" superSearchIndexText: String """Commission Code for TA/Source.""" tACommissionCode: String """Commission Description""" tACommissionDescription: String """Ta Record Locator""" taRecordLocator: String """Tax Amount for Commission.""" tax: Float """Tax exempt number on the profile""" taxExemptNumber: String """Date when this record has been extracted for 1099 report.""" taxFileDate: Date """Record status for 1099 report ( [N]-not sent [Y]-sent [M]-modified )""" taxFileStatus: String """Tax No of Stays""" taxNumberOfStays: Float """Tax Type""" taxType: String """Tax Type Description""" taxTypeDescription: String """Taxtypeid""" taxtypeid: String """Tiad""" tiad: String """Ticket Nos""" ticketNos: String """To Be Paid Amount""" toBePaidAmount: Float """Total Cost of Stay""" totalCostOfStay: Float """Total Revenue""" totalRevenue: Float """Total Room Rate""" totalRoomRate: Float """Track It Groups""" trackItGroups: String """Track It Types""" trackItTypes: String """Transactionid""" transactionid: Float """Travel Agent Address.""" travelAgentCity: String """Travel Agent Country""" travelAgentCountry: String """Travel Agent ID""" travelAgentID: Float """Travel Agent Name""" travelAgentName: String """Travel Agent Profile AR Number""" travelAgentProfileARNumber: Float """Travel Agent Profile AR Number (Central)""" travelAgentProfileARNumberCentral: String """Travel Agent Profile IATA Number""" travelAgentProfileIATANumber: String """Travel Agent Profile ID""" travelAgentProfileID: Float """Travel Agent Profile Name""" travelAgentProfileName: String """This is the actual check out date with no time component.""" truncActualCheckOutDate: Date """Turndown status of the room per reservation per day. C-Completed NR-Not required R-Requested.""" turndownStatus: String """Is the guest wants turndown facility or not ? Y/N""" turndownYN: 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 """Universal Card ID used by interfaces for key encoding purposes.""" uniCardId: String """Update Date""" updateDate: DateTime """Update Datetime""" updateDatetime: DateTime """Update User""" updateUser: Float """Updated By""" updatedBy: String """Updated By Default Property""" updatedByDefaultResort: String """Updated Date""" updatedDate: Date """Updated Time""" updatedTime: String """Incremental Upsell charges for the reservation date.""" upsellCharge: Float """Flag if the guest can do video checkout""" videoCheckoutYN: String """Visa Expiry Date""" visaExpiryDate: Date """Visa Issue Date""" visaIssueDate: Date """Visa Number""" visaNumber: String """Waitlist Comment""" waitlistComment: String """This is the waitlist telephone number.""" waitlistPhoneNumber: String """Waitlist Priority""" waitlistPriority: String """Waitlist Priority Description""" waitlistPriorityDescription: String """Waitlist Reason""" waitlistReason: String """Waitlist Reason Description""" waitlistReasonDescription: String """Waitlistpriorityid""" waitlistpriorityid: String """Waitlistreasonid""" waitlistreasonid: String """Walk-In YN""" walkInYN: String """Yieldable Y/N""" yieldableYn: String """Ym Code""" ymCode: String } type FinancialCommissionsCheckRegisterDetailsType { """Account ID""" accountId: Float """Batch Number""" batchNumber: Float """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Fc Total Check Amt""" cFCTotalCheckAmount: Float """Central Total Check Amt""" cTotalCheckAmount: Float """Central Vat Amt""" cVatAmount: Float """Central Check Amount""" centralCheckAmount: Float """Indicates Check Amount as Commission""" checkAmount: Float """Indicates Check issued in which Currency""" checkCurrency: String """Check Date""" checkDate: Date """Indicates Check No""" checkNumber: Float """Check Status""" checkStatus: String """Check Cleared Y/N""" clearedYn: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Name of the EFT file path""" eftFileName: String """Exchange Rate""" exchangeRate: Float """Indiacates commission + Tax amounts in Foreign Currency""" fCTotalCheckAmt: Float """Indicate if this check has been voided/discarded.""" failedYn: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Check number""" micrNo: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Payee""" payee: String """Date when current record has been exported for Positive Pay Check.""" positivePayDate: Date """Indicate status of record for Positive Pay Export.""" positivePayStatus: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Code to uniquely identify the Property""" property: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Status""" status: String """Status Date""" statusDate: DateTime """Payment Id""" taPaymentId: Float """Total Check Amount is commission + Tax amounts""" totalCheckAmt: Float """Travel Agent ID""" travelAgentId: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float """Tax Amount on Commission""" vatAmt: Float """Percentage of Tax on Commission""" vatPercnt: Float }