# title : OPERA Cloud RnA BookingsBlock GraphQL API, # description : GraphQL API to cater for Block header and grid details, including actual and potential room and revenue statistics, catering events, and the associated profile and reservations data. # Compatible with OPERA Cloud RnA release 26.1.0.0. # This document and all content within is available under the Universal Permissive License v 1.0 # (https://oss.oracle.com/licenses/upl). Copyright (c) 2020,2026 Oracle and/or its affiliates # version : 26.1.0.0 # termsOfService : https://www.oracle.com/legal/terms.html # contact_email : hospitality_apis_ww_grp@oracle.com # license : https://opensource.org/licenses/upl directive @stream(if: Boolean, label: String, initialCount: Int = 0) on FIELD directive @conditionalInputPair(pair: Int) on INPUT_FIELD_DEFINITION directive @mandatoryInput on INPUT_FIELD_DEFINITION scalar Date scalar DateTime # Date format: "YYYY-MM-DD" input DateInput{ _eq: Date _ne: Date _in: [Date] _nin: [Date] _gt: Date _lt: Date _gte: Date _lte: Date _btn: DateRangeInput _isNull: Boolean } input DateRangeInput { start: Date! end: Date! } # Datetime format: "YYYY-MM-DD HH24:MI:SS" input DateTimeInput { _eq: DateTime _ne: DateTime _in: [DateTime] _nin: [DateTime] _gt: DateTime _lt: DateTime _gte: DateTime _lte: DateTime _btn: DateTimeRangeInput _isNull: Boolean } input DateTimeRangeInput { start: DateTime! end: DateTime! } input StringInput { _eq: String _ne: String _in: [String] _nin: [String] _gt: String _lt: String _gte: String _lte: String _isNull: Boolean } input FloatInput { _eq: Float _ne: Float _in: [Float] _nin: [Float] _gt: Float _lt: Float _gte: Float _lte: Float _btn: FloatRangeInput _isNull: Boolean } input FloatRangeInput { start: Float! end: Float! } # Conditional Mandatory filters: # At least one filter from each required filter pair must be provided. # Please ensure the request includes at least one filter from each required pair. # Pair - [1] # - allotmentDetailsChainCode # - allotmentDetailsResort # Pair - [2] # - allotmentDetailsAgentContactNameId # - allotmentDetailsAgentNameId # - allotmentDetailsAllotmentHeaderId # - allotmentDetailsBeginDate # - allotmentDetailsBookingId # - allotmentDetailsBookingStatusOrder # - allotmentDetailsCXchangeDate # - allotmentDetailsCompanyNameId # - allotmentDetailsContactNameId # - allotmentDetailsDueDateOrd # - allotmentDetailsEndDate # - allotmentDetailsInsertDate # - allotmentDetailsInsertUser # - allotmentDetailsIsacOpptyId # - allotmentDetailsJrnupdatedttm # - allotmentDetailsMasterNameId # - allotmentDetailsOwner # - allotmentDetailsShoulderBeginDate # - allotmentDetailsShoulderEndDate # - allotmentDetailsSourceNameId # - allotmentDetailsSuperBlockId # - allotmentDetailsTourcode # - allotmentDetailsUpdateDate input BookingsBlockQueryArgumentsType { """Agent Contact Name ID""" allotmentDetailsAgentContactNameId: FloatInput @conditionalInputPair(pair: 2) """Agent Name ID""" allotmentDetailsAgentNameId: FloatInput @conditionalInputPair(pair: 2) """Block Code""" allotmentDetailsAllotmentCode: StringInput """Block ID""" allotmentDetailsAllotmentHeaderId: FloatInput @conditionalInputPair(pair: 2) """Block Owner Code""" allotmentDetailsOwnerCode: StringInput """External S&C vendor booking ID and used in HYATT-mode.""" allotmentDetailsBookingId: StringInput @conditionalInputPair(pair: 2) """Booking Status Order""" allotmentDetailsBookingStatusOrder: FloatInput @conditionalInputPair(pair: 2) """Determines block being [G] - Group or [W] - Wholesale.""" allotmentDetailsBlockType: StringInput """Central Xchange Date""" allotmentDetailsCXchangeDate: DateInput @conditionalInputPair(pair: 2) """Chain Code""" allotmentDetailsChainCode: StringInput @conditionalInputPair(pair: 1) """Company Name ID""" allotmentDetailsCompanyNameId: FloatInput @conditionalInputPair(pair: 2) """Contact Name ID""" allotmentDetailsContactNameId: FloatInput @conditionalInputPair(pair: 2) """Created Date""" allotmentDetailsInsertDate: DateTimeInput @conditionalInputPair(pair: 2) """DSI Internal Data Source ID to identify Opera Chain and instance""" allotmentDetailsDsi: FloatInput """Due Date Sorting Column.""" allotmentDetailsDueDateOrd: DateInput @conditionalInputPair(pair: 2) """End Date""" allotmentDetailsEndDate: DateInput @conditionalInputPair(pair: 2) """Insert User""" allotmentDetailsInsertUser: FloatInput @conditionalInputPair(pair: 2) """STAR MODE: ISAC opportunity ID.""" allotmentDetailsIsacOpptyId: StringInput @conditionalInputPair(pair: 2) """JRN Update Date and Time""" allotmentDetailsJrnupdatedttm: DateTimeInput @conditionalInputPair(pair: 2) """Market Code""" allotmentDetailsMarketCode: StringInput """Parent Block ID""" allotmentDetailsSuperBlockId: FloatInput @conditionalInputPair(pair: 2) """Parent Resort""" allotmentDetailsSuperBlockResort: StringInput """Profile Id. ( Name_Id ) of the Group Profile attached to this business block.""" allotmentDetailsMasterNameId: FloatInput @conditionalInputPair(pair: 2) """Internal ID to uniquely identify the Organization""" allotmentDetailsOrganizationid: FloatInput """ORMS Block Class""" allotmentDetailsOrmsBlockClass: StringInput """Owner""" allotmentDetailsOwner: FloatInput @conditionalInputPair(pair: 2) """Code to uniquely identify the Property""" allotmentDetailsResort: StringInput @conditionalInputPair(pair: 1) """Rate Code""" allotmentDetailsRateCode: StringInput """Reservation Type""" allotmentDetailsGuaranteeCode: StringInput """Room Status""" allotmentDetailsBookingStatus: StringInput """Shoulder End""" allotmentDetailsShoulderEndDate: DateInput @conditionalInputPair(pair: 2) """Shoulder Start""" allotmentDetailsShoulderBeginDate: DateInput @conditionalInputPair(pair: 2) """Source Name ID""" allotmentDetailsSourceNameId: FloatInput @conditionalInputPair(pair: 2) """Start Date""" allotmentDetailsBeginDate: DateInput @conditionalInputPair(pair: 2) """Tour Code.""" allotmentDetailsTourcode: StringInput @conditionalInputPair(pair: 2) """This is upper-case description of regular description column for fast search""" allotmentDetailsUdescription: StringInput """Updated Date""" allotmentDetailsUpdateDate: DateTimeInput @conditionalInputPair(pair: 2) """Multi Byte Description in uppercase""" allotmentDetailsXudescription: StringInput """Alias""" blockaliasesDetailsAlias: StringInput """Allotment Header ID""" blockaliasesDetailsAllotmentHeaderId: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" blockaliasesDetailsDsi: FloatInput """JRN Update Date and Time""" blockaliasesDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" blockaliasesDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" blockaliasesDetailsResort: StringInput """Not in use.""" blockaliasesDetailsUalias: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" marketDetailsDsi: FloatInput """JRN Update Date and Time""" marketDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" marketDetailsLocationid: StringInput """Market Code""" marketDetailsMarketCode: StringInput """Market group attached to the market code""" marketDetailsParentMarketCode: StringInput """Marketgroupid""" marketDetailsMarketgroupid: StringInput """Marketid""" marketDetailsMarketid: StringInput """Internal ID to uniquely identify the Organization""" marketDetailsOrganizationid: FloatInput """Property""" marketDetailsResort: StringInput """Allotment Header ID""" allotmentratesDetailsAllotmentHeaderId: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" allotmentratesDetailsDsi: FloatInput """JRN Update Date and Time""" allotmentratesDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" allotmentratesDetailsLocationid: StringInput """Offset Type""" allotmentratesDetailsOffsetType: StringInput """Internal ID to uniquely identify the Organization""" allotmentratesDetailsOrganizationid: FloatInput """Property""" allotmentratesDetailsResort: StringInput """Rate Code""" allotmentratesDetailsRateCode: StringInput """Record Type""" allotmentratesDetailsRecordType: StringInput """Book ID""" allotmentownerDetailsBookId: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" allotmentownerDetailsDsi: FloatInput """JRN Update Date and Time""" allotmentownerDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" allotmentownerDetailsLocationid: StringInput """Name ID""" allotmentownerDetailsUserId: FloatInput """Internal ID to uniquely identify the Organization""" allotmentownerDetailsOrganizationid: FloatInput """Owner Type""" allotmentownerDetailsOwnerType: StringInput """Code to uniquely identify the Property""" allotmentownerDetailsResort: StringInput """Property User belongs to""" allotmentownerDetailsUserResort: StringInput """Booking ID""" allotmentprofilecompanyDetailsBookingId: FloatInput """Company ID""" allotmentprofilecompanyDetailsLinkId: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" allotmentprofilecompanyDetailsDsi: FloatInput """JRN Update Date and Time""" allotmentprofilecompanyDetailsJrnupdatedttm: DateTimeInput """Link Type""" allotmentprofilecompanyDetailsLinkType: StringInput """Internal ID to uniquely identify the Property""" allotmentprofilecompanyDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" allotmentprofilecompanyDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" allotmentprofilecompanyDetailsResort: StringInput """Booking ID""" allotmentprofilecompanycontactDetailsBookingId: FloatInput """Company Contact ID""" allotmentprofilecompanycontactDetailsLinkId: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" allotmentprofilecompanycontactDetailsDsi: FloatInput """JRN Update Date and Time""" allotmentprofilecompanycontactDetailsJrnupdatedttm: DateTimeInput """Link Type""" allotmentprofilecompanycontactDetailsLinkType: StringInput """Internal ID to uniquely identify the Property""" allotmentprofilecompanycontactDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" allotmentprofilecompanycontactDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" allotmentprofilecompanycontactDetailsResort: StringInput """Booking ID""" allotmentprofilesourceDetailsBookingId: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" allotmentprofilesourceDetailsDsi: FloatInput """JRN Update Date and Time""" allotmentprofilesourceDetailsJrnupdatedttm: DateTimeInput """Link Type""" allotmentprofilesourceDetailsLinkType: StringInput """Internal ID to uniquely identify the Property""" allotmentprofilesourceDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" allotmentprofilesourceDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" allotmentprofilesourceDetailsResort: StringInput """Source ID""" allotmentprofilesourceDetailsLinkId: FloatInput """Booking ID""" allotmentprofilesourcecontactDetailsBookingId: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" allotmentprofilesourcecontactDetailsDsi: FloatInput """JRN Update Date and Time""" allotmentprofilesourcecontactDetailsJrnupdatedttm: DateTimeInput """Link Type""" allotmentprofilesourcecontactDetailsLinkType: StringInput """Internal ID to uniquely identify the Property""" allotmentprofilesourcecontactDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" allotmentprofilesourcecontactDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" allotmentprofilesourcecontactDetailsResort: StringInput """Source Contact ID""" allotmentprofilesourcecontactDetailsLinkId: FloatInput """Booking ID""" allotmentprofiletaDetailsBookingId: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" allotmentprofiletaDetailsDsi: FloatInput """JRN Update Date and Time""" allotmentprofiletaDetailsJrnupdatedttm: DateTimeInput """Link Type""" allotmentprofiletaDetailsLinkType: StringInput """Internal ID to uniquely identify the Property""" allotmentprofiletaDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" allotmentprofiletaDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" allotmentprofiletaDetailsResort: StringInput """Travel Agent ID""" allotmentprofiletaDetailsLinkId: FloatInput """Booking ID""" allotmentprofiletacontactDetailsBookingId: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" allotmentprofiletacontactDetailsDsi: FloatInput """JRN Update Date and Time""" allotmentprofiletacontactDetailsJrnupdatedttm: DateTimeInput """Link Type""" allotmentprofiletacontactDetailsLinkType: StringInput """Internal ID to uniquely identify the Property""" allotmentprofiletacontactDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" allotmentprofiletacontactDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" allotmentprofiletacontactDetailsResort: StringInput """Travel Agent Contact ID""" allotmentprofiletacontactDetailsLinkId: FloatInput """Allotment_detail_id -- Sequence generated column.""" allotmentdetailDetailsAllotmentDetailId: FloatInput """Allotment Header ID""" allotmentdetailDetailsAllotmentHeaderId: FloatInput """Block ID""" allotmentdetailDetailsAllotmentid: FloatInput """Change Date""" allotmentdetailDetailsChangeDate: DateInput """Cutoff Date""" allotmentdetailDetailsCutoffDate: DateInput """DSI Internal Data Source ID to identify Opera Chain and instance""" allotmentdetailDetailsDsi: FloatInput """Allotmentdetailid""" allotmentdetailDetailsAllotmentdetailid: FloatInput """JRN Update Date and Time""" allotmentdetailDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" allotmentdetailDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" allotmentdetailDetailsOrganizationid: FloatInput """Record Type""" allotmentdetailDetailsRecordType: StringInput """Property""" allotmentdetailDetailsResort: StringInput """Roomcategoryid""" allotmentdetailDetailsRoomcategoryid: StringInput """Stay Day""" allotmentdetailDetailsAllotmentDate: DateInput """DSI Internal Data Source ID to identify Opera Chain and instance""" eventrevenueDetailsDsi: FloatInput """Event ID""" eventrevenueDetailsEventId: FloatInput """Eventrevenueid""" eventrevenueDetailsEventrevenueid: FloatInput """Eventid""" eventrevenueDetailsEventid: FloatInput """JRN Update Date and Time""" eventrevenueDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" eventrevenueDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" eventrevenueDetailsOrganizationid: FloatInput """Package Revenue YN""" eventrevenueDetailsPkgRevenueYn: StringInput """Packagerevenueflag""" eventrevenueDetailsPackagerevenueflag: StringInput """Property""" eventrevenueDetailsResort: StringInput """Revenue Type""" eventrevenueDetailsRevType: StringInput """Revenuetypeid""" eventrevenueDetailsRevenuetypeid: StringInput """Actual Check In Date Time""" reservationDetailsActualCheckInDateTime: DateTimeInput """Actual Check Out Date Time""" reservationDetailsActualCheckOutDateTime: DateTimeInput """Actual Check-Out Date""" reservationDetailsActualCheckOutDate: DateInput """Addressee Name ID""" reservationDetailsAddresseeNameId: FloatInput """Block ID""" reservationDetailsAllotmentid: FloatInput """Arrival Date""" reservationDetailsTruncBeginDate: DateInput """Billing Contact ID""" reservationDetailsBillingContactId: FloatInput """Billing Contact Profile ID""" reservationDetailsBillingcontactprofileid: FloatInput """Block ID""" reservationDetailsAllotmentHeaderId: FloatInput """Bonus Check ID""" reservationDetailsBonusCheckId: FloatInput """Business Date Created""" reservationDetailsBusinessDateCreated: DateInput """Central Xchange Date""" reservationDetailsCXchangeDate: DateInput """Cancellation Date""" reservationDetailsCancellationDate: DateTimeInput """Cancellation Number""" reservationDetailsCancellationNo: StringInput """Chain Code""" reservationDetailsChainCode: StringInput """Shared Confirmation Number""" reservationDetailsConfirmationNo: StringInput """Credit Card ID""" reservationDetailsCreditCardId: FloatInput """Custom Reference Number""" reservationDetailsCustomReference: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" reservationDetailsDsi: FloatInput """Departure Date""" reservationDetailsTruncEndDate: DateInput """End Datetime""" reservationDetailsEnddatetime: DateTimeInput """Endbusinessdate""" reservationDetailsEndbusinessdate: DateInput """Event ID""" reservationDetailsEventId: FloatInput """Date the folio was changed to closed.""" reservationDetailsFolioCloseDate: DateInput """Guaranteecodeid""" reservationDetailsGuaranteecodeid: StringInput """Guestprofileid""" reservationDetailsGuestprofileid: FloatInput """Insert Action Instance ID""" reservationDetailsInsertActionInstanceId: FloatInput """Insert Date""" reservationDetailsInsertDate: DateTimeInput """Insert DateTime""" reservationDetailsInsertdatetime: DateTimeInput """Insert User""" reservationDetailsInsertUser: FloatInput """Award Membership ID""" reservationDetailsAwardMembershipId: FloatInput """JRN Update Date and Time""" reservationDetailsJrnupdatedttm: DateTimeInput """Linked Departure Date""" reservationDetailsEndDate: DateTimeInput """Internal ID to uniquely identify the Property""" reservationDetailsLocationid: StringInput """Name Usage Type""" reservationDetailsNameUsageType: StringInput """Internal ID to uniquely identify the Organization""" reservationDetailsOrganizationid: FloatInput """Original End Date""" reservationDetailsOriginalEndDate: DateInput """Parent Resv Name ID""" reservationDetailsParentResvNameId: FloatInput """Parentreservationid""" reservationDetailsParentreservationid: FloatInput """Identifies the charging status of the reservation after check out. O=Open Checkout P=Charging Privileges C=Closed Checkout.""" reservationDetailsPostCoFlag: StringInput """Quote ID provided by external system.""" reservationDetailsQuoteId: StringInput """Resv Contact ID""" reservationDetailsResvContactId: FloatInput """Reservation Name ID""" reservationDetailsResvNameId: FloatInput """Reservation Status""" reservationDetailsResvStatus: StringInput """Reservation Type""" reservationDetailsGuaranteeCode: StringInput """Reservationid""" reservationDetailsReservationid: FloatInput """Property""" reservationDetailsResort: StringInput """Auto generated charge number for Point Of Sale systems to identify guests.""" reservationDetailsResortChargeNumber: StringInput """Reservation Nameid""" reservationDetailsResvNameid: FloatInput """Resvcontactprofileid""" reservationDetailsResvcontactprofileid: FloatInput """Rh Billing Contact ID""" reservationDetailsRhBillingContactId: FloatInput """Rh Resv Contact ID""" reservationDetailsRhResvContactId: FloatInput """Room Category""" reservationDetailsRoomCategory: StringInput """Roomcategoryid""" reservationDetailsRoomcategoryid: StringInput """Is the guest scheduled for automatic check out?""" reservationDetailsScheduleCheckoutYn: StringInput """This is CAPITOL version of guest_first_name""" reservationDetailsSguestFirstname: StringInput """Sguest Name""" reservationDetailsSguestName: StringInput """Shared Profile ID""" reservationDetailsNameId: FloatInput """Shared Reservation Status""" reservationDetailsReservationStatus: StringInput """Stores resv_name_id of the original multi room reservation from which this reservation is split off.""" reservationDetailsSplitFromResvNameId: FloatInput """Splitfromreservationid""" reservationDetailsSplitfromreservationid: FloatInput """This is the actual check out date with no time component.""" reservationDetailsTruncActualCheckOutDate: DateInput """Universal Card ID used by interfaces for key encoding purposes.""" reservationDetailsUniCardId: StringInput """Update Date""" reservationDetailsUpdateDate: DateTimeInput """Update Datetime""" reservationDetailsUpdatedatetime: DateTimeInput """Central Xchange Date""" resvdepositscheduleDetailsCXchangeDate: DateInput """DSI Internal Data Source ID to identify Opera Chain and instance""" resvdepositscheduleDetailsDsi: FloatInput """JRN Update Date and Time""" resvdepositscheduleDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" resvdepositscheduleDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" resvdepositscheduleDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" resvdepositscheduleDetailsResort: StringInput """Resv Deposit Schedule ID""" resvdepositscheduleDetailsResvDepositScheduleId: FloatInput """AR Ledger Credit""" financialtransDetailsArLedCredit: FloatInput """AR Ledger Debit""" financialtransDetailsArLedDebit: FloatInput """AR State""" financialtransDetailsArState: StringInput """Account Code""" financialtransDetailsArNumber: FloatInput """Accountid""" financialtransDetailsAccountid: FloatInput """Article ID""" financialtransDetailsArticleId: FloatInput """Authemployeeid""" financialtransDetailsAuthemployeeid: FloatInput """Bonus Check ID""" financialtransDetailsBonusCheckId: FloatInput """Business Date""" financialtransDetailsBusinessDate: DateInput """Central Xchange Date""" financialtransDetailsCXchangeDate: DateInput """Central Xchange Rate""" financialtransDetailsCXchangeRate: FloatInput """Cashier ID""" financialtransDetailsCashierId: FloatInput """Chain Code""" financialtransDetailsChainCode: StringInput """Check Number""" financialtransDetailsChequeNumber: StringInput """Closure Number""" financialtransDetailsClosureNo: FloatInput """Trx code of original transaction that was turned into a comp""" financialtransDetailsCompLinkTrxCode: StringInput """Complinktranscodeid""" financialtransDetailsComplinktranscodeid: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" financialtransDetailsDsi: FloatInput """Exchange difference posting transaction number of the posting that generated the exchange difference.""" financialtransDetailsExchDiffTrxNo: FloatInput """Number to identify the DML sequence.""" financialtransDetailsFinDmlSeqNo: FloatInput """Fintransactionid""" financialtransDetailsFintransactionid: FloatInput """Fintransid""" financialtransDetailsFintransid: FloatInput """Folio Number""" financialtransDetailsBillNo: FloatInput """Folio View""" financialtransDetailsFolioView: FloatInput """Folioid""" financialtransDetailsFolioid: FloatInput """From Resv ID""" financialtransDetailsFromResvId: FloatInput """This is the transaction type which says whether it is a Consumption(C) Payment (FC) or Package (PK) and it is inherited from transaction code.""" financialtransDetailsFtSubtype: StringInput """Guest Account Ledger Credit""" financialtransDetailsGuestAccountCredit: FloatInput """Debit amount on the guest account""" financialtransDetailsGuestAccountDebit: FloatInput """Specifies the Hotel acct against which this transaction has beenposted.""" financialtransDetailsHotelAcct: StringInput """Insert Date""" financialtransDetailsInsertDate: DateTimeInput """Articleid""" financialtransDetailsArticleid: FloatInput """Businessdate""" financialtransDetailsBusinessdate: DateInput """Cashierid""" financialtransDetailsCashierid: FloatInput """Internal Window ID""" financialtransDetailsFolioNo: FloatInput """Invoice Number""" financialtransDetailsInvoiceNo: FloatInput """JRN Update Date and Time""" financialtransDetailsJrnupdatedttm: DateTimeInput """Link Transaction No""" financialtransDetailsLinkTrxNo: FloatInput """Internal ID to uniquely identify the Property""" financialtransDetailsLocationid: StringInput """Name ID""" financialtransDetailsNameId: FloatInput """Internal ID to uniquely identify the Organization""" financialtransDetailsOrganizationid: FloatInput """Original Resv Name ID""" financialtransDetailsOriginalResvNameId: FloatInput """Original Room""" financialtransDetailsOriginalRoom: StringInput """Originalresvid""" financialtransDetailsOriginalresvid: FloatInput """Package""" financialtransDetailsProduct: StringInput """Credit amount on the guest package account.""" financialtransDetailsPackageCredit: FloatInput """Debit amount on the guest package account""" financialtransDetailsPackageDebit: FloatInput """Packagelinkfintransid""" financialtransDetailsPackagelinkfintransid: FloatInput """Parentfintransid""" financialtransDetailsParentfintransid: FloatInput """Postit Number""" financialtransDetailsPostitNo: FloatInput """Productid""" financialtransDetailsProductid: StringInput """Profileid""" financialtransDetailsProfileid: FloatInput """Code to uniquely identify the Property""" financialtransDetailsResort: StringInput """Rate Code""" financialtransDetailsRateCode: StringInput """Ratecodeid""" financialtransDetailsRatecodeid: StringInput """Indicates the receipt type. Different receipts are identified by different types""" financialtransDetailsRecptType: StringInput """Reservationid""" financialtransDetailsReservationid: FloatInput """Room Number""" financialtransDetailsRoom: StringInput """Roomid""" financialtransDetailsRoomid: StringInput """TRX_NO of the transaction associated with this rounding factor posting.""" financialtransDetailsRoundLinkTrxno: FloatInput """Link the posting to the routing instruction that is specified during the setup of routing instructions for guests.""" financialtransDetailsRoutingInstrnId: FloatInput """Tax Elements""" financialtransDetailsTaxElements: StringInput """Transaction Code Group""" financialtransDetailsTcGroup: StringInput """Transaction Code Subgroup""" financialtransDetailsTcSubgroup: StringInput """Tran Action ID""" financialtransDetailsTranActionId: FloatInput """Transaction Code""" financialtransDetailsTranscodeid: StringInput """Transaction Date""" financialtransDetailsTrxDate: DateInput """Transaction Number Added By""" financialtransDetailsTrxNoAddedBy: FloatInput """Transaction Reservation Name ID""" financialtransDetailsResvNameId: FloatInput """Transaction Code""" financialtransDetailsTrxCode: StringInput """Trx Number""" financialtransDetailsTrxNo: FloatInput """Trx Number Against Package""" financialtransDetailsTrxNoAgainstPackage: FloatInput """The trx_no against which this transaction gets adjusted.""" financialtransDetailsTrxNoAdjust: FloatInput """Transaction No Header""" financialtransDetailsTrxNoHeader: FloatInput """User ID""" financialtransDetailsAuthorizerId: FloatInput """Central Xchange Date""" reservationcancelpolicyDetailsCXchangeDate: DateInput """DSI Internal Data Source ID to identify Opera Chain and instance""" reservationcancelpolicyDetailsDsi: FloatInput """External ID""" reservationcancelpolicyDetailsExternalId: StringInput """JRN Update Date and Time""" reservationcancelpolicyDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" reservationcancelpolicyDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" reservationcancelpolicyDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" reservationcancelpolicyDetailsResort: StringInput """Internal""" reservationcancelpolicyDetailsResvCancelPolicyId: FloatInput """Resv Name ID""" reservationcancelpolicyDetailsResvNameId: FloatInput """Always CRO.""" blockaccessexclusionsDetailsAccessSourceType: StringInput """Allotment Header ID""" blockaccessexclusionsDetailsAllotmentHeaderId: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" blockaccessexclusionsDetailsDsi: FloatInput """CRO code.""" blockaccessexclusionsDetailsAccessSourceValue: StringInput """JRN Update Date and Time""" blockaccessexclusionsDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" blockaccessexclusionsDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" blockaccessexclusionsDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" blockaccessexclusionsDetailsResort: StringInput """Block ID""" allotmentnoteDetailsAllotmentid: FloatInput """Allotmentnoteid""" allotmentnoteDetailsAllotmentnoteid: FloatInput """Book ID""" allotmentnoteDetailsBookId: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" allotmentnoteDetailsDsi: FloatInput """JRN Update Date and Time""" allotmentnoteDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" allotmentnoteDetailsLocationid: StringInput """Note ID""" allotmentnoteDetailsNoteId: FloatInput """Internal ID to uniquely identify the Organization""" allotmentnoteDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" allotmentnoteDetailsResort: StringInput """Allotment Header ID""" allotmentproductDetailsAllotmentHeaderId: FloatInput """System Generated number that uniquely identifies a record in this table.""" allotmentproductDetailsAllotmentProductId: FloatInput """Block ID""" allotmentproductDetailsAllotmentid: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" allotmentproductDetailsDsi: FloatInput """Allotmentproductid""" allotmentproductDetailsAllotmentproductid: FloatInput """Productid""" allotmentproductDetailsProductid: StringInput """JRN Update Date and Time""" allotmentproductDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" allotmentproductDetailsLocationid: StringInput """Offset Type""" allotmentproductDetailsOffsetType: StringInput """Internal ID to uniquely identify the Organization""" allotmentproductDetailsOrganizationid: FloatInput """Product ID""" allotmentproductDetailsProductId: StringInput """Code to uniquely identify the Property""" allotmentproductDetailsResort: StringInput """Allotment Header ID""" allotmentitemDetailsAllotmentHeaderId: FloatInput """Block ID""" allotmentitemDetailsAllotmentid: FloatInput """Allotmentitemid""" allotmentitemDetailsAllotmentitemid: FloatInput """Cateringitemid""" allotmentitemDetailsCateringitemid: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" allotmentitemDetailsDsi: FloatInput """ID""" allotmentitemDetailsId: FloatInput """Item ID""" allotmentitemDetailsItemId: FloatInput """JRN Update Date and Time""" allotmentitemDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" allotmentitemDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" allotmentitemDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" allotmentitemDetailsResort: StringInput """Allotment Header ID""" allotmenttraceDetailsAllotmentHeaderId: FloatInput """Block ID""" allotmenttraceDetailsAllotmentid: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" allotmenttraceDetailsDsi: FloatInput """JRN Update Date and Time""" allotmenttraceDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" allotmenttraceDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" allotmenttraceDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" allotmenttraceDetailsResort: StringInput """Trace ID""" allotmenttraceDetailsTraceId: FloatInput """Primary Key ID.""" allotmentalternatedatesDetailsAllotmentAltDateSeqno: FloatInput """Allotment Header ID""" allotmentalternatedatesDetailsAllotmentHeaderId: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" allotmentalternatedatesDetailsDsi: FloatInput """JRN Update Date and Time""" allotmentalternatedatesDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" allotmentalternatedatesDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" allotmentalternatedatesDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" allotmentalternatedatesDetailsResort: StringInput """Allotment Header ID""" sellmessagesDetailsAllotmentHeaderId: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" sellmessagesDetailsDsi: FloatInput """JRN Update Date and Time""" sellmessagesDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" sellmessagesDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" sellmessagesDetailsOrganizationid: FloatInput """Property""" sellmessagesDetailsResort: StringInput """Rate Code""" sellmessagesDetailsRateCode: StringInput """Room Category""" sellmessagesDetailsRoomCategory: StringInput """The primary key for this table.""" sellmessagesDetailsSellId: FloatInput """The property that the record belongs to""" resortDetailsResort: StringInput """Number format of AR account no.""" resortDetailsArAcctNoFormat: StringInput """Specifies if the AR acct No is mandatory(Y/N)""" resortDetailsArAcctNoMandYn: StringInput """Default Account Type for an Agent for the Property""" resortDetailsArAgent: StringInput """Internal""" resortDetailsArBalTrxCode: StringInput """Default Account Type for a Company for the Property""" resortDetailsArCompany: StringInput """Internal""" resortDetailsArCreditTrxCode: StringInput """Default Account Type for a Group for the Property""" resortDetailsArGroups: StringInput """Default Account Type for Individual for the Property""" resortDetailsArIndividuals: StringInput """Internal""" resortDetailsArSettleCode: StringInput """Internal""" resortDetailsArTypewriter: StringInput """Access Code""" resortDetailsAccessCode: StringInput """Number of handicapped rooms.""" resortDetailsQtyHandicappedRooms: FloatInput """Aging bucket 1""" resortDetailsAgingLevel1: FloatInput """Aging bucket 2""" resortDetailsAgingLevel2: FloatInput """Aging bucket 3""" resortDetailsAgingLevel3: FloatInput """Aging bucket 4""" resortDetailsAgingLevel4: FloatInput """Aging bucket 3""" resortDetailsAgingLevel5: FloatInput """The Airport Code for the airport near the property""" resortDetailsAirport: StringInput """Distance of the Airport specified in the AIRPORT_CODE column from the Property""" resortDetailsAirportDistance: StringInput """Time it takes to travel the distance between the Property and the Airport specified in AIRPORT_CODE column""" resortDetailsAirportTime: StringInput """Allow loggin in to this resort(Y/N)""" resortDetailsAllowLoginYn: StringInput """Period for the allowance""" resortDetailsAllowancePeriodAdj: StringInput """Internal""" resortDetailsAwardsTimeout: FloatInput """Ball Room Area""" resortDetailsBrArea: StringInput """No of Ballroom Seats""" resortDetailsBrSeats: FloatInput """The base language of the Hotel""" resortDetailsBaseLanguage: StringInput """It contains the reservation type to be used when making group block""" resortDetailsBlock: StringInput """Brand Code of the property.""" resortDetailsBrandCode: StringInput """Financial Year of the Property""" resortDetailsBudgetMonth: FloatInput """The date this resort becomes valid for use by the system""" resortDetailsBeginDate: DateInput """Value for the parameter.""" resortDetailsBusinessId: StringInput """Value for the parameter.""" resortDetailsBusinessRegCode: StringInput """Code for the CRO""" resortDetailsCroCode: StringInput """Internal""" resortDetailsCashShiftDrop: StringInput """Catering Currency Code used when Catering Currency differs from base currency.""" resortDetailsCateringCurrencyCode: StringInput """Catering currency format.""" resortDetailsCateringCurrencyFormat: StringInput """Central Exchange Date""" resortDetailsCXchangeDate: DateInput """Central Exchange Rate""" resortDetailsCXchangeRate: FloatInput """Central Credit Limit""" resortDetailsCCreditLimit: FloatInput """Central Currency Code""" resortDetailsCentralCurrencyCode: StringInput """Central Currency Description""" resortDetailsCentralCurrencyDesc: StringInput """Central Double Rate2""" resortDetailsCDblRate2: FloatInput """Central Double Rate1""" resortDetailsCDblRate1: FloatInput """Central Passerby Market""" resortDetailsRepPasserbyMarket: StringInput """Central Passerby Source""" resortDetailsRepPasserbySource: StringInput """Central Property Type""" resortDetailsRepResortType: StringInput """Central Sgl Rate1""" resortDetailsCSglRate1: FloatInput """Central Sgl Rate 2""" resortDetailsCSglRate2: FloatInput """Central State""" resortDetailsRepState: StringInput """Central State Description""" resortDetailsRepStateDesc: StringInput """Central Sui Rate1""" resortDetailsCSuiRate1: FloatInput """Central Sui Rate 2""" resortDetailsCSuiRate2: FloatInput """Central Tpl Rate1""" resortDetailsCTplRate1: FloatInput """Central Tpl Rate 2""" resortDetailsCTplRate2: FloatInput """Central Warning Amount""" resortDetailsCWarningAmount: FloatInput """Chain Code for the chain to which the property belongs""" resortDetailsChainCode: StringInput """The description of this chain.""" resortDetailsChainDescription: StringInput """Chain Mode""" resortDetailsChainMode: StringInput """Internal""" resortDetailsCheckExgPaidout: StringInput """The Hotel official check out time""" resortDetailsCheckOutTime: DateTimeInput """Internal""" resortDetailsCheckShiftDrop: StringInput """Internal""" resortDetailsCheckTrxcode: StringInput """The Hotel official check intime""" resortDetailsCheckInTime: DateTimeInput """The physical city in which this property resides.""" resortDetailsCity: StringInput """City Description""" resortDetailsCityDescription: StringInput """Internal""" resortDetailsComAddress: StringInput """Internal""" resortDetailsComMethod: StringInput """Internal""" resortDetailsComNameXrefId: FloatInput """Internal""" resortDetailsCompanyAddressType: StringInput """Internal""" resortDetailsCompanyPhoneType: StringInput """Internal""" resortDetailsConfigurationMode: StringInput """Internal""" resortDetailsConfirmRegcardPrinter: StringInput """Number of connecting rooms.""" resortDetailsQtyConnectingRooms: FloatInput """The unique name of application user""" resortDetailsAllContacts: StringInput """Number of copies to be printed""" resortDetailsCopies: FloatInput """Country name.""" resortDetailsCountryName: StringInput """The name of the country in which this property resides.""" resortDetailsCountryCode: StringInput """Value for the parameter.""" resortDetailsCountryMode: StringInput """The default credit limit for guests.""" resortDetailsCreditLimit: FloatInput """Currency Code.""" resortDetailsCurrencyCode: StringInput """Currency Symbol like $ or EURO symbol""" resortDetailsCurrencySymbol: StringInput """A description of this currency.""" resortDetailsCurrencyName: StringInput """Format for the local currency.""" resortDetailsLocalCurrencyFormat: StringInput """Color that of the background""" resortDetailsCurtainColor: StringInput """DSI""" resortDetailsDsi: FloatInput """Date the aging should begin""" resortDetailsDateForAging: StringInput """Type of separator to distinguish between DD MM and YYYY""" resortDetailsDateSeparator: StringInput """Number of places for the default currency""" resortDetailsDecimalPlaces: FloatInput """Type of decimal separator""" resortDetailsDecimalSeparator: StringInput """Number of decimals to designate currency""" resortDetailsCurrencyDecimals: FloatInput """Folio style to be used for all guests""" resortDetailsDefaultFolioStyle: FloatInput """Default guest address format.""" resortDetailsDefaultGuestAddress: StringInput """Future use""" resortDetailsDefaultMembershipType: StringInput """Future use""" resortDetailsDefaultPostingRoom: StringInput """Default property address format.""" resortDetailsDefaultPropertyAddress: StringInput """Future use""" resortDetailsDefaultRateCode: StringInput """Rate code used to default a PCR rate code used in FIT Contracts.""" resortDetailsDefaultRatecodePcr: StringInput """Rate code used to default a RACK rate code used for FIT Contracts.""" resortDetailsDefaultRatecodeRack: StringInput """Default registration card for the property.""" resortDetailsDefaultRegistrationCard: StringInput """The Default reservation type for this property""" resortDetailsDefaultReservationType: StringInput """Deleted Flag""" resortDetailsDeletedFlag: StringInput """Future use""" resortDetailsDepositLedTrxCode: StringInput """Destination ID""" resortDetailsDestinationId: StringInput """Future use""" resortDetailsDfltPkgTranCode: StringInput """Future use""" resortDetailsDfltTranCodeRateCode: StringInput """Internal""" resortDetailsDirections: StringInput """Future use""" resortDetailsDirsales: StringInput """LOGIN into the application is disabled.""" resortDetailsDisableLoginYn: StringInput """Number of double rooms.""" resortDetailsQtyDoubleRooms: FloatInput """Download Rest YN""" resortDetailsDownloadRestYn: StringInput """Pager number for the Manager on duty for the property.""" resortDetailsDutyManagerPager: StringInput """Email id for the property.""" resortDetailsEmail: StringInput """Future use.""" resortDetailsEndDate: DateInput """Default Exchange posting status for the property""" resortDetailsExchangePostingType: StringInput """Floor number of executive floor.""" resortDetailsFloorNumExecutiveFloor: StringInput """Hotel code used for third party exports""" resortDetailsExpHotelCode: StringInput """Future use""" resortDetailsExtExpFileLocation: StringInput """Future use""" resortDetailsExtPropertyCode: StringInput """Indicates that the property uses an external SC system.""" resortDetailsExternalScYn: StringInput """Number of family rooms.""" resortDetailsQtyFamilyRooms: FloatInput """Fax number formats.""" resortDetailsFaxNoFormat: StringInput """The fax phone number""" resortDetailsFax: StringInput """Future use""" resortDetailsFiscalEndDate: DateInput """Future use""" resortDetailsFiscalPeriodType: StringInput """Future use""" resortDetailsFiscalStartDate: DateInput """Fiscal Year Begin Month""" resortDetailsFiscalStartMonth: FloatInput """Fiscal Year Begin Year""" resortDetailsFiscalStartYear: FloatInput """Screen Painter flags to indicate whether an item is changable/ movable etc.""" resortDetailsFlags: StringInput """Future use""" resortDetailsFlowCode: StringInput """Property Free Nights Stay Tier.""" resortDetailsFnsTier: StringInput """Other languages""" resortDetailsFolioLanguage1: StringInput """Other languages""" resortDetailsFolioLanguage2: StringInput """Other languages""" resortDetailsFolioLanguage3: StringInput """Other languages""" resortDetailsFolioLanguage4: StringInput """Future use""" resortDetailsGenmgr: StringInput """To define an upper limit to the number of rooms for Group""" resortDetailsGroupRoomWarning: FloatInput """Future use""" resortDetailsGuestLookupTimeout: FloatInput """Number of guest elevators.""" resortDetailsQtyGuestElevators: FloatInput """Total of guest rooms floors.""" resortDetailsQtyGuestRoomFloors: FloatInput """Future use""" resortDetailsHotelCode: StringInput """Future use""" resortDetailsHotelFc: StringInput """Hotel id""" resortDetailsHotelId: StringInput """Future use""" resortDetailsHotelType: StringInput """Future use""" resortDetailsImgDirectionId: FloatInput """Future use""" resortDetailsImgHotelId: FloatInput """Future use""" resortDetailsImgMapId: FloatInput """Future use""" resortDetailsInactiveDaysForGuestProfil: FloatInput """Inactive Flag""" resortDetailsInactiveFlag: StringInput """Future use""" resortDetailsIndividualAddressType: StringInput """Future use""" resortDetailsIndividualPhoneType: StringInput """To define an upper limit to the number of rooms for group""" resortDetailsIndividualRoomWarning: FloatInput """The date the record was created""" resortDetailsInsertDate: DateTimeInput """The user that created the record""" resortDetailsInsertUser: FloatInput """Int Tax Included YN""" resortDetailsIntTaxIncludedYn: StringInput """Future use""" resortDetailsInventoryYn: StringInput """JRN Update Date and Time""" resortDetailsJrnupdatedttm: DateTimeInput """To calculate the entire availability of the Hotel for future reservations""" resortDetailsKeepAvailability: FloatInput """Latitude of the property in decimal""" resortDetailsLatitude: FloatInput """Future use""" resortDetailsLeadsend: StringInput """The owner who owns this property""" resortDetailsLegalOwner: StringInput """The property that the record belongs to""" resortDetailsLocationId: StringInput """Long date format for the property.""" resortDetailsLongDateFormat: StringInput """The default length of stay""" resortDetailsLongStayControl: FloatInput """Longitude of the property in decimal""" resortDetailsLongitude: FloatInput """Maximum adults in family rooms.""" resortDetailsMaxAdultsFamilyRoom: FloatInput """Maximum children in family rooms.""" resortDetailsMaxChildrenFamilyRoom: FloatInput """Future use""" resortDetailsMaxOccupancy: FloatInput """Maximum number of days that are allowed to credit a bill. (Country requirements.) Used in CASHIERING MODULE.""" resortDetailsMaxcreditdays: FloatInput """Indicates whether the property supports MBS. Used in some file exports.""" resortDetailsMbsSupportedYn: StringInput """Future use""" resortDetailsMeetRooms: FloatInput """Future use""" resortDetailsMeetSeats: FloatInput """Future use""" resortDetailsMeetSpace: FloatInput """Future use""" resortDetailsMeetingFc: StringInput """Minimum days for reminder letter.""" resortDetailsMinDaysBet2ReminderLetter: FloatInput """Internal""" resortDetailsNameIdLink: FloatInput """Future use""" resortDetailsNightAuditCashierId: StringInput """Number of non smoking rooms.""" resortDetailsQtyNonSmokingRooms: FloatInput """Notes for the property""" resortDetailsNotes: StringInput """Total number of beds in this property""" resortDetailsNumberBeds: FloatInput """Total number of floors in this property""" resortDetailsNumberFloors: FloatInput """Number of Rooms""" resortDetailsNumberRooms: FloatInput """Future use""" resortDetailsOpusCurrencyCode: StringInput """Organization ID""" resortDetailsOrganizationId: FloatInput """Organization Internal ID""" resortDetailsOrganizationid: FloatInput """Future use""" resortDetailsOwnership: StringInput """Package Loss code for a particular package""" resortDetailsPackageLoss: StringInput """Package Profit code for a particular Package""" resortDetailsPackageProfit: StringInput """Parent Org Code""" resortDetailsParentOrgCode: StringInput """Market code""" resortDetailsPasserbyMarket: StringInput """Source code""" resortDetailsPasserbySource: StringInput """Path""" resortDetailsPath: StringInput """Minimim Payment Date for the Property used in Cross Property Postings. This will get updated while running the user defined procedure during the night audit process.""" resortDetailsPaymentDate: DateTimeInput """Future use""" resortDetailsPerReservationRoomLimit: FloatInput """The direct dial phone number of this property""" resortDetailsTelephone: StringInput """The postal code of this property.""" resortDetailsPostCode: StringInput """Primary Key ID""" resortDetailsPkid: FloatInput """URL where property information is located.""" resortDetailsProinfoUrl: StringInput """Property MAP URL.""" resortDetailsPropMapUrl: StringInput """Property picture URL.""" resortDetailsPropPicUrl: StringInput """The property that the record belongs to""" resortDetailsLocationid: StringInput """The name of this property.""" resortDetailsName: StringInput """Type of resort.""" resortDetailsResortType: StringInput """Future use""" resortDetailsQuotedCurrency: StringInput """RNA Insert Date""" resortDetailsRnaInsertdate: DateTimeInput """RNA Update Date""" resortDetailsRnaUpdatedate: DateTimeInput """Minimim last Reconciliation Date for the Property used in Cross Property Postings. This will get updated while running the user defined procedure during the night audit process.""" resortDetailsReconcileDate: DateTimeInput """Future use""" resortDetailsRegionCode: StringInput """Description of the Region.""" resortDetailsRegionDescription: StringInput """Future use""" resortDetailsRestaurant: FloatInput """Total number of Sheets""" resortDetailsRhythmSheets: FloatInput """Total number of Towels""" resortDetailsRhythmTowels: FloatInput """Room amenity.""" resortDetailsRoomAmenity: StringInput """Future use""" resortDetailsSglNum: StringInput """Future use""" resortDetailsSglRate1: FloatInput """Future use""" resortDetailsSglRate2: FloatInput """Future use""" resortDetailsSuiNum: StringInput """Future use""" resortDetailsSuiRate1: FloatInput """Future use""" resortDetailsSuiRate2: FloatInput """To store number of days before deleting the gest profile""" resortDetailsSaveProfiles: FloatInput """Future use""" resortDetailsScriptId: FloatInput """Future use""" resortDetailsSeason1: StringInput """Future use""" resortDetailsSeason2: StringInput """Future use""" resortDetailsSeason3: StringInput """Future use""" resortDetailsSeason4: StringInput """Future use""" resortDetailsSeason5: StringInput """Indicates that the property accepts leads as bookings.""" resortDetailsSendLeadAsBooking: StringInput """Shop description.""" resortDetailsShopDescription: StringInput """Short date format for the property.""" resortDetailsShortDateFormat: StringInput """Number of single rooms.""" resortDetailsQtySingleRooms: FloatInput """For default commission percentage""" resortDetailsSourceCommission: StringInput """The state in which this property is located.""" resortDetailsState: StringInput """Description of the state.""" resortDetailsStateDesc: StringInput """The street of the property.""" resortDetailsStreet: StringInput """Number of suites.""" resortDetailsQtySuites: FloatInput """Internal""" resortDetailsSummCurrencyCode: StringInput """For default commission percentage""" resortDetailsTaCommission: StringInput """Future use""" resortDetailsTplNum: StringInput """Future use""" resortDetailsTplRate1: FloatInput """Future use""" resortDetailsTplRate2: FloatInput """Formats for telephone number""" resortDetailsTelephoneNoFormat: StringInput """Separator for monetory values""" resortDetailsThousandSeparator: StringInput """Default time format for the property.""" resortDetailsTimeFormat: StringInput """Time zone region selected by the employee.""" resortDetailsTimezoneRegion: StringInput """Toll free telephone number.""" resortDetailsTollfree: StringInput """Future use""" resortDetailsTotRooms: FloatInput """Tourist Number""" resortDetailsTouristNumber: StringInput """Indicates whether the property handles multi byte characters and whether they are translateable or not""" resortDetailsTranslateMulticharYn: StringInput """Turnaway code for the property.""" resortDetailsTurnawayCode: StringInput """Number of twin rooms.""" resortDetailsQtyTwinRooms: FloatInput """The date the record was modified""" resortDetailsUpdateDate: DateTimeInput """The user that modified the record""" resortDetailsUpdateUser: FloatInput """VAT ID of this property.""" resortDetailsVatId: StringInput """Future use""" resortDetailsVideocheckoutPrinter: StringInput """Video check out start time.""" resortDetailsVideoCoStart: DateTimeInput """Video check out end time.""" resortDetailsVideoCoStop: DateTimeInput """Future use""" resortDetailsWakeUpDelay: FloatInput """Amount at which warning is raised.""" resortDetailsWarningAmount: FloatInput """Webaddress of the property""" resortDetailsWebaddress: StringInput """Weekend days for the property.""" resortDetailsWeekendDays: StringInput """Internal""" resortDetailsZeroInvPurDays: FloatInput """Block ID""" allotmentsubscriptionDetailsBookingId: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" allotmentsubscriptionDetailsDsi: FloatInput """Ext Allotment ID""" allotmentsubscriptionDetailsExtAllotmentId: StringInput """This is the Interface_id of the System which sent/Received Allotment""" allotmentsubscriptionDetailsInterfaceId: StringInput """JRN Update Date""" allotmentsubscriptionDetailsJrnUpdateDttm: DateTimeInput """Internal ID to uniquely identify the Property""" allotmentsubscriptionDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" allotmentsubscriptionDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" allotmentsubscriptionDetailsResort: StringInput } type Query { """Block header and grid details including actual and potential room and revenue statistics catering events and the associated profile and reservations data.""" bookingsBlock(limit: Int offset: Int input: BookingsBlockQueryArgumentsType!): [BookingsBlockType] } type BookingsBlockType { """Block""" blockDetails: BookingsBlockBlockDetailsType """Block Aliases Details""" blockAliasesDetails: BookingsBlockBlockAliasesDetailsType """Market Details""" marketDetails: BookingsBlockMarketDetailsType """Block Rates""" blockRatesDetails: BookingsBlockBlockRatesDetailsType """Block Owner""" blockOwnerDetails: BookingsBlockBlockOwnerDetailsType """Block Profile Company""" blockCompanyProfileDetails: BookingsBlockBlockCompanyProfileDetailsType """Block Profile Company Contact""" blockCompanyContactProfileDetails: BookingsBlockBlockCompanyContactProfileDetailsType """Block Profile Source""" blockSourceProfileDetails: BookingsBlockBlockSourceProfileDetailsType """Block ProfileSource Contact""" blockSourceContactProfileDetails: BookingsBlockBlockSourceContactProfileDetailsType """Block Profile Travel Agent""" blockTravelAgentProfileDetails: BookingsBlockBlockTravelAgentProfileDetailsType """Block Profile Travel Agent Contact""" blockTravelAgentContactProfileDetails: BookingsBlockBlockTravelAgentContactProfileDetailsType """Block Detail""" blockDetailDetails: BookingsBlockBlockDetailDetailsType """Event Revenue Details""" eventRevenueDetails: BookingsBlockEventRevenueDetailsType """Reservation Details""" reservationDetails: BookingsBlockReservationDetailsType """Reservation Deposit Schedule""" reservationDepositScheduleDetails: BookingsBlockReservationDepositScheduleDetailsType """Financial Transaction""" financialTransactionDetails: BookingsBlockFinancialTransactionDetailsType """Reservation Cancel Policy Details""" reservationCancelPolicyDetails: BookingsBlockReservationCancelPolicyDetailsType """Block Access Exclusions Details""" blockAccessExclusionsDetails: BookingsBlockBlockAccessExclusionsDetailsType """Block Note""" blockNoteDetails: BookingsBlockBlockNoteDetailsType """Block Product""" blockProductDetails: BookingsBlockBlockProductDetailsType """Block Item""" blockItemDetails: BookingsBlockBlockItemDetailsType """Block Trace""" blockTraceDetails: BookingsBlockBlockTraceDetailsType """Block Alternate Dates""" blockAlternateDatesDetails: BookingsBlockBlockAlternateDatesDetailsType """Sell Messages Details""" sellMessagesDetails: BookingsBlockSellMessagesDetailsType """Resort Details""" propertyPropertyDetails: BookingsBlockPropertyPropertyDetailsType """Allotment Subscription""" allotmentSubscriptionDetails: BookingsBlockAllotmentSubscriptionDetailsType bookingsBlockRecordCount: Int } type BookingsBlockBlockDetailsType { """Action ID""" actionId: Float """Actual Average Room Rate""" actualAverageRoomRate: Float """Actual F&B Revenue""" actualFBRevenue: Float """Other revenue""" actualOtherRevenue: Float """Actual Room Nights Sold""" actualRoomNightsSold: Float """Actual revenue of the room""" actualRoomRevenue: Float """Add Info""" addInfo: String """Agent Contact Name ID""" agentContactNameId: Float """Agent Name ID""" agentNameId: Float """Agentprofileid""" agentprofileid: Float """All Aliases""" allAliases: String """All Block Owners""" allBlockOwners: String """All Catering Owners""" allCateringOwners: String """All Company Contacts""" allCompanyContacts: String """All Rate Codes""" allRateCodes: String """All Room Owners""" allRoomOwners: String """All Room Pools""" allRoomPools: String """All Room Types""" allRoomTypes: String """All Source Contacts""" allSourceContacts: String """All Travel Agent Contacts""" allTravelAgentContacts: String """Allotment Origin""" allotmentOrigin: String """Type of Block alloted for the group.""" allotmentType: String """Allotmentcurrencyid""" allotmentcurrencyid: String """Block ID""" allotmentid: Float """Allow a pickup for a group with this booking status""" allowPickup: String """Multi Byte Description Field""" alternateBlockName: String """Alternate Dates""" alternateDates: String """Arrival Time""" arrivalTime: DateTime """URL pointing to Lead Attachments.""" attachmentURL: String """Attendees Guaranteed""" attendeesGuaranteed: Float """Indicates if forecast figures should be automatically loaded for this business block.""" autoLoadForecastYn: String """Average Rate""" averageRate: Float """Date when the BEO report was last printed for this business block.""" bEOLastPrint: DateTime """Stores the original block begin date. Any date ealier will be treated as a Shoulder date.""" beginDateOriginal: Date """Block Alias""" blockAlias: String """Block Code""" blockCode: String """Block Date Actual""" blockDateActual: Date """Block Date Definite""" blockDateDefinite: DateTime """Block Date Prospect""" blockDateProspect: DateTime """Block Date Tentative""" blockDateTentative: DateTime """Block Description""" blockDescription: String """Block ID""" blockID: Float """Classifies this allotment record: MASTER_ALLOCATION SUB_ALLOCATION SUB_BOOKING SUB_TOUR SUB_ITINERARY""" blockMode: String """Block Owner Code""" blockOwnerCode: String """Block Owner Full Name""" blockOwnerFullName: String """Block Package""" blockPackage: String """Block Package Description""" blockPackageDescription: String """Block Status""" blockStatus: String """Block Status Description""" blockStatusDescription: String """Block Type Code""" blockTypeCode: String """Block Type Code Description""" blockTypeCodeDescription: String """Blockpackageid""" blockpackageid: String """External S&C vendor booking ID and used in HYATT-mode.""" bookingId: String """Booking Method Order By""" bookingMethodOrderBy: Float """Booking Status Order""" bookingStatusOrder: Float """Determines block being [G] - Group or [W] - Wholesale.""" bookingType: String """Booking Type Description""" bookingTypeDescription: String """Bookingmethod Inactive Date""" bookingmethodInactiveDate: Date """Bookingsourceid""" bookingsourceid: String """Bookingstatusid""" bookingstatusid: String """Bookingtypeid""" bookingtypeid: String """Breakfast Description""" breakfastDescription: String """PCR: The estimated breakfast price for this ratecode.""" breakfastInclPrice: Float """PCR: Is breakfast is included in this rate code?""" breakfastInclYn: String """Breakfast Included""" breakfastIncluded: String """Breakfast Price""" breakfastPrice: Float """BWI eLeadID for tracking purposes.""" bwiLeadId: String """URL populated bu CRS.""" bwiUrl: String """Central Bfst Incl Price""" cBreakfastInclPrice: Float """Central Bfst Price""" cBreakfastPrice: Float """Central Comp Room Value""" cCompRoomValue: Float """Central Dbl Rm Supplement Price""" cDoubleRoomSupplementPrice: Float """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Fb Commission 1""" cFBCommission1: Float """Central Fb Commission 2""" cFBCommission2: Float """Central Porterage Price""" cPorteragePrice: Float """Central Rm Commission 1""" cRoomCommission1: Float """Central Rm Commission 2""" cRoomCommission2: Float """Central Service Charge""" cServiceCharge: Float """Central Service Fee""" cServiceFee: Float """CRS Guaranteed Y/N""" cRSGtdYn: String """Not Used""" cancelRule: String """Canceldestinationid""" canceldestinationid: String """Cancellation Destination""" cancellationDestination: String """Cancellation Destination Description""" cancellationDestinationDescription: String """Cancellation Number""" cancellationNumber: Float """Cancellation Penalty Amount""" cancellationPenaltyAmount: Float """Cancellationreasonid""" cancellationreasonid: String """Catering Cutoff""" catCutoff: Date """Cat Date Prospect""" catDateProspect: DateTime """Catering Owner""" catOwner: Float """Property of Catering Owner""" catOwnerProperty: String """Cat Return To Inventory""" catReturnToInventory: String """Cat Starting Status""" catStartingStatus: String """Catcurrencyid""" catcurrencyid: String """Catering Cancellation Date""" cateringCancellationDate: Date """Catering Cancellation Description""" cateringCancellationDescription: String """Catering Cancellation Number""" cateringCancellationNumber: Float """Catering Cancellation Reason""" cateringCancellationReason: String """Catering Currency""" cateringCurrency: String """Catering Date Actual""" cateringDateActual: Date """Catering Decision Date""" cateringDecisionDate: Date """Catering Deduct Inventory""" cateringDeductInventory: String """Catering Exchange Rate""" cateringExchangeRate: Float """Catering Followup Date""" cateringFollowupDate: Date """Catering only Revenue.""" cateringOnlyYN: String """Catering Order By""" cateringOrderBy: Float """Catering Owner Code""" cateringOwnerCode: String """Catering Owner Full Name""" cateringOwnerFullName: String """Catering Pkgs Y/N""" cateringPkgsYn: String """Catering Quote Currency""" cateringQuoteCurrency: String """Catering Status""" cateringStatus: String """Catering Status Color""" cateringStatusColor: String """Catering Status Description""" cateringStatusDescription: String """Catering Status Type describes Inventory behaviour""" cateringStatusType: String """Cateringcancelreasonid""" cateringcancelreasonid: Float """Cateringcurrencyid""" cateringcurrencyid: String """Catering Owner Employee ID""" cateringowneremployeeid: Float """Catering Quote Currency ID""" cateringquotecurrencyid: String """Cateringstatusid""" cateringstatusid: String """Cenral FB Revenue""" cenralFBRevenue: Float """Central Actual Average Room Rate""" centralActualAverageRoomRate: Float """Central Actual FB Revenue""" centralActualFBRevenue: Float """Central Actual Other Revenue""" centralActualOtherRevenue: Float """Central Actual Room Revenue""" centralActualRoomRevenue: Float """Central Average Room Rate""" centralAverageRoomRate: Float """Central Block Package""" centralBlockPackage: String """Central Block Package Description""" centralBlockPackageDescription: String """Central Block Status""" centralBlockStatus: String """Central Block Status Description""" centralBlockStatusDescription: String """Central Block Type Code""" centralBlockTypeCode: String """Central Block Type Code Description""" centralBlockTypeCodeDescription: String """Central Booking Type""" centralBookingType: String """Central Booking Type Description""" centralBookingTypeDescription: String """Central Cancellation Destination""" centralCancellationDestination: String """Central Cancellation Destination Description""" centralCancellationDestinationDescription: String """Central Cancellation Penalty Amount""" centralCancellationPenaltyAmount: Float """Central Catering Status""" centralCateringStatus: String """Central Catering Status Description""" centralCateringStatusDescription: String """Central Conversion Code""" centralConversionCode: String """Central Coversion Code Description""" centralCoversionCodeDescription: String """Central Industry Code""" centralIndustryCode: String """Central Industry Code Description""" centralIndustryCodeDescription: String """Central Items for this Block""" centralItemsForThisBlock: String """Central Market Description""" centralMarketDescription: String """Central Market code""" centralMarketCode: String """Central Meeting Budget""" centralMeetingBudget: Float """Central Meeting Revenue""" centralMeetingRevenue: Float """Central Origin Code""" centralOriginCode: String """Central Origin Code Description""" centralOriginCodeDescription: String """Central Other Revenue""" centralOtherRevenue: Float """Stores the name and phone number of the primary central owner.""" centralOwner: String """Central Payment""" centralPayment: String """Central Payment Description""" centralPaymentDescription: String """Central Ranking Code""" centralRankingCode: String """Central Ranking Code Description""" centralRankingCodeDescription: String """Central Reservation Method Code""" centralReservationMethodCode: String """Central Reservation Method Description""" centralReservationMethodDescription: String """Central Reservation Type""" centralReservationType: String """Central Reservation Type Description""" centralReservationTypeDescription: String """Central Room Revenue""" centralRoomRevenue: Float """Central Source Code""" centralSourceCode: String """Central Source Code Description""" centralSourceCodeDescription: String """Central Tax Amount""" centralTaxAmount: Float """Chain Code""" chainCode: String """Channelid""" channelid: String """Code""" code: String """Communication Address for Contact 1 (E-mail / Fax #)""" comAddress: String """Communication Address for Contact 2 (E-mail / Fax #)""" comAddress2: String """Communication Address for Contact 3 (E-mail / Fax #)""" comAddress3: String """How this lead is to be sent. [EMAIL|FAX|PRINT]""" comMethod: String """How this lead is to be sent. [EMAIL|FAX|PRINT|DATA]""" comMethod2: String """How this lead is to be sent. [EMAIL|FAX|PRINT|DATA]""" comMethod3: String """Commission Amount""" commissionAmount: String """PCR: Commissionable Percentage.""" commissionablePerc: Float """Commissionable Y/N""" commissionableYn: String """Complimentary Rooms based per Stay (Y) or per Night (N)""" compPerStayYn: String """Complimentary Rooms: Value given to Customer""" compRoomValue: Float """Number of complimentary Rooms""" compRooms: Float """Complimentary Rooms: Fixed amount (Y) or calculated (N)""" compRoomsFixedYn: String """Company All""" companyAll: String """Company Name ID""" companyNameId: Float """Companyprofileid""" companyprofileid: Float """Competition""" competition: String """Contact Name ID""" contactNameId: Float """Contactprofileid""" contactprofileid: Float """Contract Number""" contractNumber: String """Control Block Y/N""" controlBlockLocally: String """Conversion Code""" conversionCode: String """Coversion Code Description""" coversionCodeDescription: String """The name of the user who created the record.""" createdBy: String """Created Date""" createdDate: DateTime """Indicates if the block was created as an Opportunity""" createdAsOpportunityYN: String """Credit Card ID""" creditCardId: Float """Currency""" currency: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Date Acl""" dateAcl: Date """Date Cfl""" dateCfl: Date """Date Definite""" dateDefinite: DateTime """Date Lsl""" dateLsl: Date """Date Opened for Pickup""" dateOpenedForPickup: Date """Date Pel""" datePel: DateTime """Date Tdl""" dateTdl: DateTime """Date Tentative""" dateTentative: DateTime """Stores the double room supplement price.""" dblRoomSupplementPrice: Float """Deduct the reservations with this booking status from the inventory""" deductInventory: String """Defualt Posting Master ID""" defaultPmReservationNameId: Float """Deleted Flag""" deletedflag: String """Departure Time""" departureTime: DateTime """Description""" description: String """Distributed""" distributed: String """Timestamp of the last date/time the distributed_yn flag was set to Y.""" distributedDate: DateTime """Dml Sequence No""" dmlSeqNumber: Float """Stores the double room supplement.""" doubleRoomSupplementYN: String """Download Date""" downloadDate: Date """Download Property""" downloadResort: String """Download Srep""" downloadSrep: Float """Due Date""" dueDate: Date """Due Date Sorting Column.""" dueDateOrd: Date """End Date""" endDate: Date """Stores the original block End date. Any date later will be treated as a Shoulder date.""" endDateOriginal: Date """Endbusinessdate""" endbusinessdate: Date """Event Attendees""" eventAttendees: Float """Exchange Posting Type""" exchangePostingType: String """Exchange Rate""" exchangeRate: Float """The message that will pop up if the block is excluded (not allowed) to modify/create reservation/cancel reservation.""" exclusionMessage: String """External Reference""" externalReference: String """External RFP ID.""" externalRfpId: String """External RFP System Identification Code.""" externalRfpSystem: String """Externally Locked""" externallyLocked: String """Projected F&B Revenue.""" fBRevenue: Float """Currency code for the F&B Agendas attached to the business block.""" fbAgendaCurrency: String """stores FB commission for Agent 1""" fbCommission1: Float """stores FB commission for Agent 2""" fbCommission2: Float """Operation Mode for FIT Contracts [ SFA=SFA control RC=Ratecode RA=RateAmounts ]""" fitContractMode: String """Fit Discount Level.""" fitDiscountLevel: Float """Published Corporate Rate: Discount Percentage.""" fitDiscountPerc: Float """Fitdiscounttype""" fitdiscounttype: String """Determines if rate check is done for Occ1 or Occ1 and Additional Rate.""" flatRateYn: String """Followup Date""" followupDate: Date """Can the Function space booked under master allocation or master block be overbooked by sub-allocations or sub-blocks ?""" fsOverbookingYn: String """Function Type""" functionType: String """Group IATA Number.""" giid: String """Greek Contract Number.""" greekContractNr: String """Group Account ID""" groupAccountID: Float """Guaranteecodeid""" guaranteecodeid: String """Rate Guaranteed Y/N.""" guaranteedRate: String """Guaranteed YN""" guaranteedYN: String """Hideacctinfoflag""" hideacctinfoflag: String """SCH Mode: Number of days before the arrival date a reservation can be canceled without losing the deposit.""" hlxCanxNoticeDays: Float """SCH Mode: Determines if Travel Agent commission will be paid on reservations booked through the HOLIDEX Plus TACP program.""" hlxCommissionableYn: String """SCH Mode: All Description DD Secured.""" hlxDdSecuredYn: String """SCH Mode: Number of Days Deposit due to guarantee the guest booking.""" hlxDepositDays: Float """SCH Mode: Secured from DI Display.""" hlxDiSecuredYn: String """SCH Mode: Housing Information Secured.""" hlxHousinginfoSecuredYn: String """SCH Mode: Rates Secured from All Displays""" hlxRateAllSecuredYn: String """SCH Mode: Rates Secured from GNR.""" hlxRatesGnrSecuredYn: String """SCH Mode: Return One Day at a time.""" hlxReturnEachDayYn: String """Inactive Date""" inactiveDate: Date """Inactive Flag""" inactiveflag: String """Indicates the Non-Compete code of a block.""" industryCode: String """Industry Code Description""" industryCodeDescription: String """Not Used""" info: String """Information Board""" informationBoard: String """Insert User""" insertUser: Float """Inventory Control""" inventoryControl: String """Inventory Cut-Off Date""" inventoryCutOffDate: Date """Inventory Cut-Off Days""" inventoryCutOffDays: Float """STAR MODE: ISAC opportunity ID.""" isacOpptyId: String """Items""" items: String """Items for this Block""" itemsForThisBlock: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """If set to ?Y? lead will not be converted to booking upon lead sending.""" keepLeadControlYN: String """Laptop Change""" laptopChange: Float """Lead Origin""" leadOrigin: String """Lead Sent YN""" leadSentYN: String """Lead Source""" leadSource: String """Lead Type""" leadType: String """Indication that the Property has updated the Lead Information will prevent further SFA updates.""" leadchangeBypropertyYn: String """Leaderrorflag""" leaderrorflag: String """Leadisnewflag""" leadisnewflag: String """Leadoriginid""" leadoriginid: String """Leadreceivedflag""" leadreceivedflag: String """Name of Contact 1 (Free text or from RESORT_CONTACTS)""" leadsend: String """Name of Contact 2 (Free text or from RESORT_CONTACTS)""" leadsend2: String """Name of Contact 3 (Free text or from RESORT_CONTACTS)""" leadsend3: String """Leadserverpendingflag""" leadserverpendingflag: String """Leadsourceid""" leadsourceid: String """Leadstatus""" leadstatus: String """STAR MODE: Date when the OPERA block was linked to an ISAC opportunity.""" linkDate: Date """Internal ID to uniquely identify the Property""" locationID: String """Competitor to whom the booking was lost.""" lostTo: String """Mainmarket""" mainmarket: String """Mainmarketid""" mainmarketid: String """Block was cutoff manullay""" manuallyCutoffYN: String """MARRIOTT mode: Marsha Event Type.""" marEventType: String """MARRIOTT mode: Marsha column for Housing Protected.""" marHouseProtectYn: String """MARRIOTT mode: Specifies if the Marsha block has a rolling end date.""" marRollEndDateYn: String """Market Code""" marketCode: String """Market Description""" marketDescription: String """Marketid""" marketid: String """Parent Block ID""" masterBlockID: Float """Parent Resort""" masterBlockProperty: String """Profile Id. ( Name_Id ) of the Group Profile attached to this business block.""" masterNameId: Float """Meeting Budget""" meetingBudget: Float """Meeting Revenue for SFA""" meetingRevenue: Float """Offset Type""" offsetType: String """Order By""" orderBy: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Stores the original ALLOTMENT_HEADER_ID prior to a migration.""" origAllotmentHeaderId: Float """Origin Code""" originCode: String """Origin Code Description""" originCodeDescription: String """Original Block Start Date used as identifier in the HOLIDEX interface.""" originalBeginDateHolidex: Date """Original End Date""" originalEndDate: Date """Not used""" originalRateCode: String """Original Start Date""" originalStartDate: Date """Originalratecodeid""" originalratecodeid: String """ORMS Block Class""" ormsBlockClass: String """ORMS Final Block""" ormsFinalBlock: String """Reason for which a review of the ORMS forecast is required. If the value is null it means forecast has been reviewed. If the value is Forecast increased (FI) Forecast decreased (FD) Blocked Rooms increased (BRI) Blocked Rooms decreased (BRD) New block (NB) User required review (URR) then it means forecast has not been reviewed.""" ormsForecastReviewReason: String """ORMS Transient Block""" ormsTransientBlock: String """Projected Other Revenue.""" otherRevenue: Float """Owner""" owner: Float """Owner Property""" ownerResort: String """Owneremployeeid""" owneremployeeid: Float """Ownerlocationd""" ownerlocationd: String """Parentallotmentid""" parentallotmentid: Float """Payment""" payment: String """Payment Description""" paymentDescription: String """Paymentmethodid""" paymentmethodid: String """Persons Per Room""" personsPerRoom: Float """Porterage Included""" porterageIncluded: String """Porterage Price""" porteragePrice: Float """Pot Average Room Rate""" potAverageRoomRate: Float """Pot FB Revenue1""" potFbRevenue1: Float """Pot Other Revenue1""" potOtherRevenue1: Float """Projected Room Nights.""" potRoomNights: Float """Pot Room Revenue1""" potRoomRevenue1: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Print Rate""" printRate: String """Profile ID""" profileId: Float """Program""" program: String """Code to uniquely identify the Property""" property: String """Indicates if events in webProposal should be combined in the generated XML.""" proposalCombineEventsYn: String """Decision Date Selection: [R]ooms Decision Date / [C]atering Decision Date.""" proposalDecisionSelection: String """Stores the user choice for either [R]ooms or [C]atering follow-up date to be passed to webProposal. NULL is treated as Rooms follow-up date.""" proposalFollowupSelection: String """If Y then Alternate Names will be used in the webProposal XML tags for and .""" proposalInclAltNamesYn: String """Owner Selection: [O]verall Owner / [R]ooms Owner / [C]atering Owner.""" proposalOwnerSelection: String """Proposal Sent Date""" proposalSentDate: DateTime """Show price per event on webProposal.""" proposalShowEventpriceYn: String """Show PMS roomtypes on webProposal otherwise S&C roomtypes are shown.""" proposalShowPmsRoomTypeYn: String """Show function space names on webProposal.""" proposalShowSpacenameYn: String """Unit of measurement used for function spaces in webProposal XML. Possible values: METRIC IMPERIAL or NONE.""" proposalSpaceMeasurement: String """Proposal View Token""" proposalViewToken: String """Indicates that negotiated rates need to be published.""" publishRatesYn: String """Indicates the ranking of a block.""" rankingCode: String """Ranking Code Description""" rankingCodeDescription: String """Rate Code""" rateCode: String """Indicates if the rate code can be overridden.""" rateOverride: String """Reason why the rate code was overridden used for FIT Contracts.""" rateOverrideReason: String """Indicates that a Rate Protection exists for this booking: [A]ll [S]ome [N]one. No other group can be booked using rates lower than the one that is flagged as rate protect.""" rateProtect: String """Rate Tier""" rateTier: Float """Ratecodeid""" ratecodeid: String """Ready for Distribution""" readyForDistribution: String """Indicates if a lead has been regenerated (copied and lost) by the system and differentiates between leads that have been lost by the user or due to changes to the lead master.""" regeneratedLeadYn: String """Rep Bookingmethod Orderby""" repBookingmethodOrderby: Float """Rep Bs Order By""" repBsOrderBy: Float """Rep Cat Order By""" repCatOrderBy: Float """Reply Date""" replDate: DateTime """Reply Communication Method""" replVia: String """Lead Replystatus [ACL|TDL]""" replstatus: String """Reply By""" replyBy: Float """Representative""" representative: String """Reservation Method""" reservationMethod: String """Reservation Type""" reservationType: String """The Description of the Guarantee code.""" reservationTypeDescription: String """Reservationid""" reservationid: Float """Reserve Inventory YN""" reserveInventoryYN: String """Final resort where Booking is confirmed -via Lead process.""" resortBooked: String """Default discount percentage applied to catering items.""" resourceDiscountPercent: Float """Response Time.""" respTime: Float """The unit of time (from UNIT_OF_TIME table).""" respTimeCode: String """Return the reservations with this booking status from the inventory""" returnToInventory: String """Not used""" rivMarketSegment: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """stores Rooms commission for Agent 1""" roomCommission1: Float """stores Rooms commission for Agent 2""" roomCommission2: Float """Room Nights Sold""" roomNightsSold: Float """Room Owner Code""" roomOwnerCode: String """Room Owner Full Name""" roomOwnerFullName: String """Projected Room Revenue.""" roomRevenue: Float """Transaction Code for posting room revenue from blocked reservations.""" roomRevenueTransactionCode: String """Room Status""" roomStatus: String """Rooming List Due""" roomingListDue: Date """Stores Rooming List Rules.""" roomingListRules: String """Rooms Cancellation Date""" roomsCancellationDate: Date """Rooms Cancellation Reason""" roomsCancellationReason: String """Rooms Cancellation Reason Description""" roomsCancellationReasonDescription: String """Rooms Currency""" roomsCurrency: String """Rooms Decision Date""" roomsDecisionDate: Date """Rooms Exchange Rate""" roomsExchangeRate: Float """Rooms Owner""" roomsOwner: Float """Property of Rooms Salesmanager""" roomsOwnerResort: String """Rooms Per Day""" roomsPerDay: Float """Rooms Quote Currency""" roomsQuoteCurrency: String """Roomsowneremployeeid""" roomsowneremployeeid: Float """Not used""" salesId: String """Sbegindate""" sbegindate: Date """Quote ID reference for the last printed catering quote report (S&C Quotation Report).""" scQuoteId: String """Sell Thru Indicator.""" sellThruYn: String """Identifies if a business block needs to be send to Central based on KEY_PROFILE_YN in NAME.""" sendToCentralYn: String """Senddate""" senddate: Date """Sent By""" sentBy: Float """Sent Date""" sentDate: DateTime """Sent Via""" sentVia: String """Service Charge""" serviceCharge: Float """Service Fee Amount per room/night""" serviceFee: Float """Service Fee applies?""" serviceFeeYn: String """PCR: Are Service Charges included in this rate code?""" serviceInclYn: String """Service Percentage included.""" servicePerc: Float """Shoulder End""" shoulderEnd: Date """Shoulder Start""" shoulderStart: Date """Flag used to show or hide rate column in Block Grid and used as default by block reservations.""" showRateAmountYN: String """Snapshot has been created""" snapshotSetup: String """Source Code""" sourceCode: String """Source Code Description""" sourceCodeDescription: String """Source Contact All""" sourceContactAll: String """Source Name ID""" sourceNameId: Float """Sourceid""" sourceid: Float """Sourceprofprofileid""" sourceprofprofileid: Float """Start Date""" startDate: Date """Booking starting status (intial pickup)""" startingStatus: String """Status""" status: String """Status Color""" statusColor: String """Type of booking status (initial)""" statusType: String """Sub Allocation YN""" subAllocationYN: String """Super Search Index Text""" superSearchIndexText: String """Suppress Rate""" suppressRate: String """Indicates if original grid will be copied to contract grid. Performed in the allotment_detail trigger.""" syncContractYn: String """Synchronize Sub-Blocks with Master Block if Y""" synchronize: String """Tax Amount""" taxAmount: Float """Percentage of included Tax.""" taxIncludedPerc: Float """Tax is included in this rate.""" taxIncludedYn: String """Tax Type""" taxType: String """Taxtypeid""" taxtypeid: String """To be Determined Rates""" tbdRates: String """Tdl Reason""" tdlReason: String """Not used""" tentativeLevel: Float """Stores the TLPe - Response ID""" tlpResponseid: String """Stores the TLPe - Result URL.""" tlpUrl: String """Tour Code.""" tourCode: String """Trace Code""" traceCode: String """Trace Description""" traceDescription: String """Indicate that no other block of the same industry can be booked for the selected dates.Non-Compete indicator : [A]ll [S]ome [N]one.""" trackChangesYN: String """Travel Agent All""" travelAgentAll: String """Travel Agent Record Locator""" travelAgentRecordLocator: String """Turndownreasonid""" turndownreasonid: Float """UDFC01""" uDFC01: String """UDFC02""" uDFC02: String """UDFC03""" uDFC03: String """UDFC04""" uDFC04: String """UDFC05""" uDFC05: String """UDFC06""" uDFC06: String """UDFC07""" uDFC07: String """UDFC08""" uDFC08: String """UDFC09""" uDFC09: String """UDFC10""" uDFC10: String """UDFC11""" uDFC11: String """UDFC12""" uDFC12: String """UDFC13""" uDFC13: String """UDFC14""" uDFC14: String """UDFC15""" uDFC15: String """UDFC16""" uDFC16: String """UDFC17""" uDFC17: String """UDFC18""" uDFC18: String """UDFC19""" uDFC19: String """UDFC20""" uDFC20: String """UDFC21""" uDFC21: String """UDFC22""" uDFC22: String """UDFC23""" uDFC23: String """UDFC24""" uDFC24: String """UDFC25""" uDFC25: String """UDFC26""" uDFC26: String """UDFC27""" uDFC27: String """UDFC28""" uDFC28: String """UDFC29""" uDFC29: String """UDFC30""" uDFC30: String """UDFC31""" uDFC31: String """UDFC32""" uDFC32: String """UDFC33""" uDFC33: String """UDFC34""" uDFC34: String """UDFC35""" uDFC35: String """UDFC36""" uDFC36: String """UDFC37""" uDFC37: String """UDFC38""" uDFC38: String """UDFC39""" uDFC39: String """UDFC40""" uDFC40: String """UDFD01""" uDFD01: Date """UDFD02""" uDFD02: Date """UDFD03""" uDFD03: Date """UDFD04""" uDFD04: Date """UDFD05""" uDFD05: Date """UDFD06""" uDFD06: Date """UDFD07""" uDFD07: Date """UDFD08""" uDFD08: Date """UDFD09""" uDFD09: Date """UDFD10""" uDFD10: Date """UDFD11""" uDFD11: Date """UDFD12""" uDFD12: Date """UDFD13""" uDFD13: Date """UDFD14""" uDFD14: Date """UDFD15""" uDFD15: Date """UDFD16""" uDFD16: Date """UDFD17""" uDFD17: Date """UDFD18""" uDFD18: Date """UDFD19""" uDFD19: Date """UDFD20""" uDFD20: Date """UDFN01""" uDFN01: Float """UDFN02""" uDFN02: Float """UDFN03""" uDFN03: Float """UDFN04""" uDFN04: Float """UDFN05""" uDFN05: Float """UDFN06""" uDFN06: Float """UDFN07""" uDFN07: Float """UDFN08""" uDFN08: Float """UDFN09""" uDFN09: Float """UDFN10""" uDFN10: Float """UDFN11""" uDFN11: Float """UDFN12""" uDFN12: Float """UDFN13""" uDFN13: Float """UDFN14""" uDFN14: Float """UDFN15""" uDFN15: Float """UDFN16""" uDFN16: Float """UDFN17""" uDFN17: Float """UDFN18""" uDFN18: Float """UDFN19""" uDFN19: Float """UDFN20""" uDFN20: Float """UDFN21""" uDFN21: Float """UDFN22""" uDFN22: Float """UDFN23""" uDFN23: Float """UDFN24""" uDFN24: Float """UDFN25""" uDFN25: Float """UDFN26""" uDFN26: Float """UDFN27""" uDFN27: Float """UDFN28""" uDFN28: Float """UDFN29""" uDFN29: Float """UDFN30""" uDFN30: Float """UDFN31""" uDFN31: Float """UDFN32""" uDFN32: Float """UDFN33""" uDFN33: Float """UDFN34""" uDFN34: Float """UDFN35""" uDFN35: Float """UDFN36""" uDFN36: Float """UDFN37""" uDFN37: Float """UDFN38""" uDFN38: Float """UDFN39""" uDFN39: Float """UDFN40""" uDFN40: Float """Not in use.""" ualias: String """This is upper-case description of regular description column for fast search""" udescription: String """Update Date by LEAD REPLY.""" updateDateExternal: Date """Update User""" updateUser: Float """Updated By""" updatedBy: String """Updated Date""" updatedDate: DateTime """Upload Date""" uploadDate: Date """Indicates if this business block can be booked via the web (OWS).""" webBookable: String """Indicates if this business block allows overbooking when rooms are available on the non-deduct block grid even if there are no rooms available on the house level.""" webOverbookYN: String """Multi Byte Description in uppercase""" xudescription: String } type BookingsBlockBlockAliasesDetailsType { """Alias""" alias: String """Allotment Header ID""" allotmentHeaderId: Float """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Code to uniquely identify the Property""" property: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Not in use.""" ualias: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type BookingsBlockMarketDetailsType { """Central Market Code""" centralMarketCode: String """Central Market Description""" centralMarketDescription: String """Central Market Group Code""" centralMarketGroupCode: String """Central Market Group Description""" centralMarketGroupDescription: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Display Color""" displayColor: String """Inactive Date""" inactiveDate: DateTime """Inactive YN""" inactiveYN: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Deleted Flag""" internalDeletedflag: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Market Code""" marketCode: String """Market Description""" marketDescription: String """Market Display Sequence""" marketDisplaySequence: Float """Market group attached to the market code""" marketGroupCode: String """Market Group Description""" marketGroupDescription: String """Market Group Display Sequence""" marketGroupDisplaySequence: Float """Marketgroupid""" marketgroupid: String """Marketid""" marketid: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Print Group for Nationality Report""" printGroup: String """Property""" property: String """Reporting Item""" repItem: String """Reporting Item Name""" repItemName: String """Reporting Item Orderby""" repItemOrderby: Float """Reporting Market Sell Sequence""" repMarketSellSequence: Float """Reporting Parent Sell Sequence""" repParentSellSequence: Float """Reporting Updatedate""" repUpdateDate: DateTime """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Sc Orderby""" scOrderby: Float """Transaction Code""" trxCode: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type BookingsBlockBlockRatesDetailsType { """Allotment Header ID""" allotmentHeaderId: Float """Begin Date""" beginDate: Date """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Description""" description: String """End Date""" endDate: Date """Inactive Date""" inactiveDate: DateTime """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Negotiated rate Y/N""" negotiatedYN: String """Offset Type""" offsetType: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Primary YN""" primaryYN: String """Property""" property: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Rate Code""" rateCode: String """Not used""" rateCodeLocked: String """Rate Type""" rateType: String """Record Type""" recordType: String } type BookingsBlockBlockOwnerDetailsType { """Book ID""" bookId: Float """Catering Owner Title""" cateringOwnerTitle: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Description""" description: String """Full Name""" fullName: String """Inactive Date""" inactiveDate: DateTime """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Laptop Change""" laptopChange: Float """Internal ID to uniquely identify the Property""" locationID: String """Name ID""" nameID: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Owner Email""" ownerEmail: String """Phone no.""" ownerPhone: String """Owner Type""" ownerType: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Primary SFA owner before the property owner was assigned""" primarySfaYn: String """Primary YN""" primaryYN: String """Code to uniquely identify the Property""" property: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Relationship""" relationship: String """Rooms Owner Code""" roomsOwnerCode: String """To Type""" toType: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float """Property User belongs to""" userResort: String } type BookingsBlockBlockCompanyProfileDetailsType { """Address 1""" address1: String """Address 2""" address2: String """Address 3""" address3: String """Address 4""" address4: String """Booking ID""" bookingID: Float """City""" city: String """Company ID""" companyID: Float """Country Code""" countryCode: String """Country Description""" countryDescription: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Description""" description: String """Display Name""" displayName: String """E Mail""" eMail: String """External YN""" externalYN: String """Inactive Date""" inactiveDate: DateTime """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Laptop Change""" laptopChange: Float """Link Type""" linkType: String """Internal ID to uniquely identify the Property""" locationID: String """Name Type""" nameType: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Phone no.""" phoneNo: String """Postal Code""" postalCode: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Primary YN""" primaryYN: String """Defines if this linked profile is the Default to be used when creating activities and printing BEOs S&C ProForma and S&C Contracts.""" printAccountYN: String """Code to uniquely identify the Property""" property: String """Province""" province: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Relationship""" relationship: String """State""" state: String """To Type""" toType: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type BookingsBlockBlockCompanyContactProfileDetailsType { """Address 1""" address1: String """Address 2""" address2: String """Address 3""" address3: String """Address 4""" address4: String """Booking ID""" bookingID: Float """City""" city: String """Company Contact ID""" companyContactID: Float """Country Code""" countryCode: String """Country Description""" countryDescription: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Description""" description: String """Display Name""" displayName: String """E Mail""" eMail: String """External YN""" externalYN: String """Inactive Date""" inactiveDate: DateTime """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Laptop Change""" laptopChange: Float """Link Type""" linkType: String """Internal ID to uniquely identify the Property""" locationID: String """Name Type""" nameType: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Phone no.""" phoneNo: String """Postal Code""" postalCode: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Primary YN""" primaryYN: String """Defines if this linked profile is the Default to be used when creating activities and printing BEOs S&C ProForma and S&C Contracts.""" printAccountYN: String """Code to uniquely identify the Property""" property: String """Province""" province: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Relationship""" relationship: String """State""" state: String """To Type""" toType: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type BookingsBlockBlockSourceProfileDetailsType { """Address 1""" address1: String """Address 2""" address2: String """Address 3""" address3: String """Address 4""" address4: String """Booking ID""" bookingID: Float """City""" city: String """Country Code""" countryCode: String """Country Description""" countryDescription: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Description""" description: String """Display Name""" displayName: String """E Mail""" eMail: String """External YN""" externalYN: String """Inactive Date""" inactiveDate: DateTime """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Laptop Change""" laptopChange: Float """Link Type""" linkType: String """Internal ID to uniquely identify the Property""" locationID: String """Name Type""" nameType: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Phone no.""" phoneNo: String """Postal Code""" postalCode: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Primary YN""" primaryYN: String """Defines if this linked profile is the Default to be used when creating activities and printing BEOs S&C ProForma and S&C Contracts.""" printAccountYN: String """Code to uniquely identify the Property""" property: String """Province""" province: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Relationship""" relationship: String """Source ID""" sourceID: Float """State""" state: String """To Type""" toType: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type BookingsBlockBlockSourceContactProfileDetailsType { """Address 1""" address1: String """Address 2""" address2: String """Address 3""" address3: String """Address 4""" address4: String """Booking ID""" bookingID: Float """City""" city: String """Country Code""" countryCode: String """Country Description""" countryDescription: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Description""" description: String """Display Name""" displayName: String """E Mail""" eMail: String """External YN""" externalYN: String """Inactive Date""" inactiveDate: DateTime """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Laptop Change""" laptopChange: Float """Link Type""" linkType: String """Internal ID to uniquely identify the Property""" locationID: String """Name Type""" nameType: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Phone no.""" phoneNo: String """Postal Code""" postalCode: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Primary YN""" primaryYN: String """Defines if this linked profile is the Default to be used when creating activities and printing BEOs S&C ProForma and S&C Contracts.""" printAccountYN: String """Code to uniquely identify the Property""" property: String """Province""" province: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Relationship""" relationship: String """Source Contact ID""" sourceContactID: Float """State""" state: String """To Type""" toType: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type BookingsBlockBlockTravelAgentProfileDetailsType { """Address 1""" address1: String """Address 2""" address2: String """Address 3""" address3: String """Address 4""" address4: String """Booking ID""" bookingID: Float """City""" city: String """Country Code""" countryCode: String """Country Description""" countryDescription: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Description""" description: String """Display Name""" displayName: String """E Mail""" eMail: String """External YN""" externalYN: String """Inactive Date""" inactiveDate: DateTime """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Laptop Change""" laptopChange: Float """Link Type""" linkType: String """Internal ID to uniquely identify the Property""" locationID: String """Name Type""" nameType: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Phone no.""" phoneNo: String """Postal Code""" postalCode: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Primary YN""" primaryYN: String """Defines if this linked profile is the Default to be used when creating activities and printing BEOs S&C ProForma and S&C Contracts.""" printAccountYN: String """Code to uniquely identify the Property""" property: String """Province""" province: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Relationship""" relationship: String """State""" state: String """To Type""" toType: String """Travel Agent ID""" travelAgentID: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type BookingsBlockBlockTravelAgentContactProfileDetailsType { """Address 1""" address1: String """Address 2""" address2: String """Address 3""" address3: String """Address 4""" address4: String """Booking ID""" bookingID: Float """City""" city: String """Country Code""" countryCode: String """Country Description""" countryDescription: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Description""" description: String """Display Name""" displayName: String """E Mail""" eMail: String """External YN""" externalYN: String """Inactive Date""" inactiveDate: Date """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Laptop Change""" laptopChange: Float """Link Type""" linkType: String """Internal ID to uniquely identify the Property""" locationID: String """Name Type""" nameType: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Phone no.""" phoneNo: String """Postal Code""" postalCode: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Primary YN""" primaryYN: String """Defines if this linked profile is the Default to be used when creating activities and printing BEOs S&C ProForma and S&C Contracts.""" printAccountYN: String """Code to uniquely identify the Property""" property: String """Province""" province: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Relationship""" relationship: String """State""" state: String """To Type""" toType: String """Travel Agent Contact ID""" travelAgentContactID: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type BookingsBlockBlockDetailDetailsType { """Action ID""" actionId: Float """Number of rooms that are in "contracted" status in this business block for the particular room type & date that this record corresponds to.""" aggregateContractOccupancy: Float """Aggregate Pickup Occupancy""" aggregatePickupOccupancy: Float """Aggregate Prospective Occupancy""" aggregateProspectiveOccupancy: Float """Allotment_detail_id -- Sequence generated column.""" allotmentDetailId: Float """Allotment Header ID""" allotmentHeaderId: Float """Allotmentbusinessdate""" allotmentbusinessdate: Date """Block ID""" allotmentid: Float """Indicates if Employee is available for task assignment.""" available: Float """Block End Date""" blockEndDate: Date """Blocked Occ 1""" blockedOcc1: Float """Blocked Occ 2""" blockedOcc2: Float """Blocked Occ 3""" blockedOcc3: Float """Blocked Occ 4""" blockedOcc4: Float """Projected number of rooms with Quadruple occupancy when the business block is in the Initial status ( not open for pickup yet ) for the particular room type & date that this record corresponds to.""" blockedOccupancy4: Float """Blocked Rooms""" blockedRooms: Float """Stores the Booking Position room pickup.""" bookingPosition: Float """Central Discount Amt""" cDiscountAmount: Float """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Materialization Amnt""" cMaterializationAmnt: Float """Central Pickup Rate2""" cPickupRate2: Float """Central Pickup Rate1""" cPickupRate1: Float """Central Pickup Rate3""" cPickupRate3: Float """Central Pickup Rate4""" cPickupRate4: Float """Central Pickup Rateap""" cPickupRateap: Float """Central Contract Revenue""" centralContractRevenue: Float """Central Order By""" centralOrderBy: Float """Central Pickup Revenue""" centralPickupRevenue: Float """Central Prospective Revenue""" centralProspectiveRevenue: Float """Central Rate Amount for 1 PAX""" centralRateAmountFor1PAX: Float """Central Rate Amount for 2 PAX""" centralRateAmountFor2PAX: Float """Central Rate Amount for 3 PAX""" centralRateAmountFor3PAX: Float """Central Rate Amount for 4 PAX""" centralRateAmountFor4PAX: Float """Central Rate Amount per Additional Person""" centralRateAmountPerAdditionalPerson: Float """Central Rate Amount per Child""" centralRateAmountPerChild: Float """Central Room Pool Description""" centralRoomPoolDescription: String """Change Date""" changeDate: Date """Number of rooms with Triple occupancy that are in "contracted" status in this business block for the particular room type & date that this record corresponds to.""" contractOccupancy3: Float """Number of rooms with Single occupancy that are in "contracted" status in this business block for the particular room type & date that this record corresponds to.""" contractOccupancyBy1PAX: Float """Number of rooms with Double occupancy that are in "contracted" status in this business block for the particular room type & date that this record corresponds to.""" contractOccupancyBy2PAX: Float """Number of rooms with Quadruple occupancy that are in "contracted" status in this business block for the particular room type & date that this record corresponds to.""" contractOccupancyBy4PAX: Float """Contract Revenue""" contractRevenue: Float """The name of the user who created the record.""" createdBy: String """Created Date""" createdDate: DateTime """Current Rooms""" currentRooms: Float """Cutoff Date""" cutoffDate: Date """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Discount Amount""" discountAmt: Float """Discount Percentage.""" discountPct: Float """Discount Reason Code""" discountReasonCode: String """Dml Sequence No""" dmlSeqNumber: Float """Elastic""" elastic: Float """Not Used.""" elasticSold: Float """Fixed Rate Y/N""" fixedRateYn: String """Insert User""" insertUser: Float """Allotmentdetailid""" internalAllotmentdetailid: Float """Indicates how the inventory for this allotment date is controlled. Possible values: [K]eep in the block Release to [M]aster Release to [H]ouse.""" inventoryControlMode: String """Last date when column inventory_deduct was changed.""" inventoryDate: DateTime """Stores either forecast_to_sell/to_sell/sold column depending on Record Type.""" inventoryDeduct: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Laptop Change""" laptopChange: Float """Internal ID to uniquely identify the Property""" locationID: String """Materialization Amnt""" materializationAmnt: Float """OTB Occ 1""" oTBOcc1: Float """OTB Occ 2""" oTBOcc2: Float """OTB Occ 3""" oTBOcc3: Float """OTB Occ 4""" oTBOcc4: Float """OTB Rooms""" oTBRooms: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """FORCASTED_TO_SELL inventory""" originalRooms: Float """Not Used.""" physicalConversionFactor: Float """Number of rooms with Single occupancy that are in "Picked Up" status in this business block for the particular room type & date that this record corresponds to.""" pickupOccupancyBy1PAX: Float """Number of rooms with Double occupancy that are in "Picked Up" status in this business block for the particular room type & date that this record corresponds to.""" pickupOccupancyBy2PAX: Float """Number of rooms with Triple occupancy that are in "Picked Up" status in this business block for the particular room type & date that this record corresponds to.""" pickupOccupancyBy3PAX: Float """Number of rooms with Quadruple occupancy that are in "Picked Up" status in this business block for the particular room type & date that this record corresponds to.""" pickupOccupancyBy4PAX: Float """Rate ( Amount ) to be used for rooms with Single occupancy in this business block for the particular room type & date that this record corresponds to.""" pickupRate1: Float """Rate ( Amount ) to be used for rooms with Double occupancy in this business block for the particular room type & date that this record corresponds to.""" pickupRate2: Float """Rate ( Amount ) to be used for rooms with Triple occupancy in this business block for the particular room type & date that this record corresponds to.""" pickupRate3: Float """Rate ( Amount ) to be used for rooms with Quadruple occupancy in this business block for the particular room type & date that this record corresponds to.""" pickupRate4: Float """Rate ( Amount ) to be used for rooms with occupancy more than 4 in this business block for the particular room type & date that this record corresponds to.""" pickupRateap: Float """Pickup Revenue""" pickupRevenue: Float """Pool Order By""" poolOrderBy: Float """Pool Property""" poolResort: String """Pool Room Category""" poolRoomCategory: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Projected number of rooms with Single occupancy when the business block is in the Initial status ( not open for pickup yet ) for the particular room type & date that this record corresponds to.""" prospectiveOccupancyBy1PAX: Float """Projected number of rooms with Double occupancy when the business block is in the Initial status ( not open for pickup yet ) for the particular room type & date that this record corresponds to.""" prospectiveOccupancyBy2PAX: Float """Projected number of rooms with Triple occupancy when the business block is in the Initial status ( not open for pickup yet ) for the particular room type & date that this record corresponds to.""" prospectiveOccupancyBy3PAX: Float """Prospective Revenue""" prospectiveRevenue: Float """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """2 person rate""" rate2: Float """4 person rate""" rate4: Float """1 person rate""" rateAmountFor1PAX: Float """3 person rate""" rateAmountFor3PAX: Float """Additional person rate.""" rateAmountPerAdditionalPerson: Float """Rate amount to be applied for children in this business block for the room type and date that this record corresponds to ..""" rateAmountPerChild: Float """Record Type""" recordType: String """Number of rooms released by block cutoff""" released: Float """Property""" resort: String """Room Cat Order By""" roomCatOrderBy: Float """Room Cat Property""" roomCatResort: String """Room Category""" roomCategory: String """Room Class""" roomClass: String """Room Pool that this room type belongs to. (Used in Marriott mode).""" roomPool: String """Room Pool Code""" roomPoolCode: String """Room Pool Description""" roomPoolDescription: String """Room Room Class""" roomRoomClass: String """Room Type""" roomType: String """Room Type Description""" roomTypeDescription: String """Roomcategoryid""" roomcategoryid: String """Roomclassid""" roomclassid: String """Sc Room Category""" scRoomCategory: String """Scroomcategoryid""" scroomcategoryid: String """Shoulder Date YN""" shoulderDateYN: String """Stay Day""" stayDay: Date """Number of rooms allotted by Sub-Allocations for the Master-Allocation.""" subBlockPickup: Float """Update User""" updateUser: Float """Updated By""" updatedBy: String """Updated Date""" updatedDate: DateTime } type BookingsBlockEventRevenueDetailsType { """Actual Cost""" actualCost: Float """Actual Revenue""" actualRevenue: Float """Block ID""" allotmentid: Float """Billed Cost""" billedCost: Float """Billed Revenue""" billedRevenue: Float """Block Begin Date""" blockBeginDate: Date """Block End Date""" blockEndDate: Date """Block ID""" blockID: Float """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Actual Cost""" centralActualCost: Float """Central Actual Revenue""" centralActualRevenue: Float """Central Billed Cost""" centralBilledCost: Float """Central Billed Revenue""" centralBilledRevenue: Float """Central Expected Cost""" centralExpectedCost: Float """Central Expected Revenue""" centralExpectedRevenue: Float """Central Forecast Revenue""" centralForecastRevenue: Float """Central Guaranteed Cost""" centralGuaranteedCost: Float """Central Guaranteed Revenue""" centralGuaranteedRevenue: Float """Central On the Books Revenue""" centralOnTheBooksRevenue: Float """Central Total Forecasted Revenue""" centralTotalForecastedRevenue: Float """Custom Y/N""" customYn: String """Customrevtypeflag""" customrevtypeflag: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Event ID""" eventID: Float """Event Status""" eventStatus: String """Eventrevenueid""" eventrevenueid: Float """Expected Cost""" expectedCost: Float """Expected Revenue""" expectedRevenue: Float """Flat Rate YN""" flatRateYN: String """Flat YN""" flatYN: String """Forecast Catering Revenue""" forecastCateringRevenue: Float """Forecast Revenue""" forecastRevenue: Float """Indicates if the event forecast revenue has been modified by the user.""" forecastRevenueEditedYN: String """Even though resources may be booked only the forecasted values will drive reporting revenue and production revenues.""" forecastRevenueOnlyYn: String """Guaranteed Cost""" guaranteedCost: Float """Guaranteed Revenue""" guaranteedRevenue: Float """Ignore Forecast YN""" ignoreForecastYN: String """Inactive Date""" inactiveDate: DateTime """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Eventid""" internalEventid: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Minimum Revenue Y/N""" minimumRevenueYn: String """On the Books Attendees""" onTheBooksAttendees: Float """On the Books Revenue""" onTheBooksRevenue: Float """Order By""" orderBy: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Package Revenue YN""" packageRevenueYN: String """Packagerevenueflag""" packagerevenueflag: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Property""" property: String """Revenue Group""" revenueGroup: String """Revenue Type""" revenueType: String """Revenuetypeid""" revenuetypeid: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Update Date""" updateDate: DateTime """Update User""" updateUser: Float """Use Forecast Value Only YN""" useForecastValueOnlyYN: String } type BookingsBlockReservationDetailsType { """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 """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 """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 """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 """Attached Date""" attachedDate: Date """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 """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 """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 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 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 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 """Chain Code""" chainCode: 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 Code""" commissionCode: String """Commission Description""" commissionDescription: String """Commission Hold Code""" commissionHoldCode: String """Commission Paid""" commissionPaid: Float """Indicates to whom the commission will be paid: NULL T (Travel Agent) S (Source) and B (Both).""" commissionPayoutTo: String """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 """Calculated reservation status.""" computedResvStatus: String """Confirmation Leg Number.""" confirmationLegNumber: Float """Shared Confirmation Number""" confirmationNo: String """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 """Deleted Flag""" deletedFlag: String """Departtransportid""" departtransportid: String """Departure Comments""" departureComments: String """Departure Date""" departureDate: Date """Departure Date Time""" departureDateTime: Date """Departure Time""" departureTime: String """Departure Transport Code""" departureTransportCode: String """Departure Transportation YN""" departureTransportationYN: String """Stores the Deposit maturity preference.""" depositMaturityType: String """Detatched Date""" detatchedDate: Date """Detatched YN""" detatchedYN: 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 """F&B Revenue Remaining""" fBRevenueRemaining: 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 """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 """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 """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 """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 """Parent Resv Name ID""" parentReservationNameId: Float """Parentreservationid""" parentreservationid: Float """Part Allotment""" partAllotment: String """Party Code""" partyCode: String """Pax Number""" paxNo: Float """Total amount of payment inclusive of VAT""" paymentAmount: 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 """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 """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 """Room Revenue Remaining""" roomRevenueRemaining: 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 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 """Ta Record Locator""" taRecordLocator: String """Tax exempt number on the profile""" taxExemptNumber: 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 """Total Cost of Stay""" totalCostOfStay: Float """Total Revenue""" totalRevenue: Float """Total Revenue Remaining""" totalRevenueRemaining: 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 BookingsBlockReservationDepositScheduleDetailsType { """Deposit Amount for the Activity. Populated by Concept system currently.""" activityDeposit: Float """Central Activity Deposit""" cActivityDeposit: Float """Central Cancel Pnlty Amount""" cCancelPnltyAmount: Float """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Foreign Deposit Amount""" cForeignDepositAmount: Float """Date the reservation can be cancelled""" cancelDeadline: Date """Amount to be charged for a cancellation""" cancelPnltyAmount: Float """Central Deposit Amount Outstanding""" centralDepositAmountOutstanding: Float """Central Deposit Amount Requested""" centralDepositAmountRequested: Float """Central Total Deposit Payments""" centralTotalDepositPayments: Float """Comments""" comments: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Deposit Amount Outstanding""" depositAmountOutstanding: Float """Deposit Amount Requested""" depositAmountRequested: Float """Deposit Due Date""" depositDueDate: Date """Deposit Percentage""" depositPercentage: Float """ID will be populated for reversal records to link the main deposit request.""" depositReqLinkId: Float """Deposit Req Receipt Number""" depositReqReceiptNo: Float """Identifies if this record is a deposit request reversal.""" depositReqReversalYn: String """Deposit Rule""" depositRule: String """Deposit Rule Description""" depositRuleDescription: String """Deposit Rule Type""" depositRuleType: String """Deposit Schedule Resv Name ID""" depositScheduleReservationNameId: Float """Stores the type of the deposit: possible values "RECEIPT" or "FOLIO".""" depositType: String """Dml Sequence No""" dmlSeqNumber: Float """Exchange Rate info used for cancelation penalty if Rate code is in a difference currency.""" exchangeRateInfo: String """External ID""" externalId: String """Deposit Amount in Foreign currency if Rate code is in a different currency.""" foreignDepositAmount: Float """Insert Action Instance ID""" insertActionInstanceId: Float """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Manual Y/N""" manualYn: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Not used""" paymentFlag: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Processed Y/N""" processedYn: String """Product ID""" productId: String """Code to uniquely identify the Property""" property: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Rate Dc Sequence""" rateDcSeq: Float """Resv Deposit Schedule ID""" reservationDepositScheduleId: Float """Deposit Amount due to pure room charges.""" roomDeposit: Float """Amount of the transaction that resulted in the form being required""" totalDepositPayments: Float """Transaction Date""" trxDate: Date """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type BookingsBlockFinancialTransactionDetailsType { """AR Charge Transfer YN""" aRChargeTransferFlagYN: String """Indicates if an individual charge has been transferred to another invoice in AR. Used to disallow operations such as the transfer of same charge multiple times editing an already transferred charge etc.""" aRChargeTransferYN: String """AR Ledger Credit""" aRLedgerCredit: Float """AR Ledger Debit""" aRLedgerDebit: Float """AR State""" aRState: String """AR Transfer Date""" aRTransferDate: Date """Set Y to transactions when the application parameter ONLY POST TAXES ONCE FOR APARTMENT STYLE BILLING CHARGES is set. Proper rows and net amount will be shown in reports when the parameter is turned on or off.""" aSBOnlyPostTaxesOnceYn: String """Populate the tax rows that are inserted for Trial balance with "ASB_TB_TAX". Other reports and screens will hide these transactions.""" aSBTaxFlag: String """Account Code""" accountCode: Float """Account Name""" accountName: String """Account Number""" accountNumber: String """Account Type Flag""" accountTypeFlag: String """Accountid""" accountid: Float """Adjustment YN""" adjustmentYN: String """Transaction code of the master posting of the automatic adjustment posting for advanced generates.""" advGenerateTrxCode: String """Identifies if this Advance Bill has been reversed.""" advanceBillReversedYn: String """Identifies if this transaction was generated by Advance Bill.""" advanceBillYn: String """The charge / generate is eligible as part of advanced generates functionality.""" advancedGenerateYn: String """Indicates the automatic adjustment posting for advanced generates. Possible values are ?NA? ?CO?.""" advancedGeneratedAdjustment: String """Advgentranscodeid""" advgentranscodeid: String """Distinguish "Same day" package from a next day package by storing N/S.""" allowanceType: String """Indicates ASB transactions: Rental charge for an [A]partment Style Rental Cycle [O]ffsetting transaction for Rental charge for an Apartment Style Rental Cycle [N]ightly Rental Posting [W]aived Nights Rental Posting""" apartmentStyleBillingType: String """Approval Code""" approvalCode: String """Approval Date""" approvalDate: Date """Approval Status""" approvalStatus: String """Arrangement Code""" arrangementCode: String """Arrangement Description for the Transaction Code.""" arrangementDesc: String """Arrangement ID""" arrangementId: Float """Article ID""" articleId: Float """Indicates the associated receipt number printed for a particular receipt type.""" associatedReceiptNo: Float """Indicates the associated transaction number for a particular receipt type.""" associatedTrxNumber: Float """Authemployeeid""" authemployeeid: Float """Authorizer""" authorizer: String """Indicates if this column was automatically created for Automatic Credit Bills.""" autoCreditbillYn: String """Auto Settle Y/N""" autoSettleYn: String """Billing Event ID""" billingEventID: Float """Bonus Check ID""" bonusCheckId: Float """Bucket code related to this redemption.""" bucketCode: String """Indicates that this transaction was a gaming bucket redemption.""" bucketRedempYn: String """Business Date""" businessDate: Date """Central Cashier Opening Balance""" cCashierOpeningBalance: Float """Central Change Due""" cChangeDue: Float """Central Contract Gross Amount""" cContractGrossAmount: Float """Central Contract Guest Credit""" cContractGuestCredit: Float """Central Contract Guest Debit""" cContractGuestDebit: Float """Central Contract Net Amount""" cContractNetAmount: Float """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Forex Comm Amount""" cForexCommissionAmount: Float """Central Org Ar Led Debit""" cOrganizationARLedgerDebit: Float """Central Org Posted Amount""" cOrganizationPostedAmount: Float """Central Package Allowance""" cPackageAllowance: Float """Central Parallel Gross Amount""" cParallelGrossAmount: Float """Central Parallel Guest Credit""" cParallelGuestCredit: Float """Central Parallel Guest Debit""" cParallelGuestDebit: Float """Central Parallel Net Amount""" cParallelNetAmount: Float """Central Payment Surcharge Amt""" cPaymentSurchargeAmount: Float """Central Tax Rate""" cTaxRate: Float """Central Vat Amount""" cVatAmount: Float """CC Approval Code""" cCApproval: String """Calculate Points YN""" calculatePointsYN: String """Cash Bag Number""" cashBagNumber: String """Cashier""" cashier: String """Cashier Credit""" cashierCredit: Float """Cashier Debit""" cashierDebit: Float """Cashier ID""" cashierID: Float """Cashier Opening Balance""" cashierOpeningBalance: Float """Identifies if this record was the result of a credit card refund possible values: REFUND or OVERRIDE.OVERRIDE means a user authorized a refund amount larger than the original cc charge.""" ccRefundPosting: String """Central AR Ledger Credit""" centralARLedgerCredit: Float """Central AR Ledger Debit""" centralARLedgerDebit: Float """Central Advanced Generated Transaction Code""" centralAdvancedGeneratedTransactionCode: String """Central Cashier Credit""" centralCashierCredit: Float """Central Cashier Debit""" centralCashierDebit: Float """Central Credit Card Surcharge""" centralCreditCardSurcharge: Float """Central Deposit Amount Paid""" centralDepositAmountPaid: Float """Central Deposit Ledger Credit""" centralDepositLedgerCredit: Float """Central Deposit Ledger Debit""" centralDepositLedgerDebit: Float """Central Gross Amount""" centralGrossAmount: Float """Central Guest Account Ledger Credit""" centralGuestAccountLedgerCredit: Float """Central Guest Account Ledger Debit""" centralGuestAccountLedgerDebit: Float """Central In-House Credit""" centralInHouseCredit: Float """Central In-House Debit""" centralInHouseDebit: Float """Central Market Code""" centralMarketCode: String """Central Market Description""" centralMarketDescription: String """Central Market Group Code""" centralMarketGroupCode: String """Central Market Group Description""" centralMarketGroupDescription: String """Central Net Amount""" centralNetAmount: Float """Central Non Revenue Amount""" centralNonRevenueAmount: Float """Central Package""" centralPackage: String """Central Package Ledger Credit""" centralPackageLedgerCredit: Float """Central Package Ledger Debit""" centralPackageLedgerDebit: Float """Central Posted Amount in Base Currency""" centralPostedAmountInBaseCurrency: Float """Central Price Per Unit""" centralPricePerUnit: Float """Central Revenue Included""" centralRevenueIncluded: Float """Central Transaction Code Description""" centralTransactionCodeDescription: String """Central Trial Balance Amount Gross""" centralTrialBalanceAmountGross: Float """Central Trial Balance Amount Net""" centralTrialBalanceAmountNet: Float """Chain Code""" chainCode: String """Change Due""" changeDue: Float """This field will store the file number for the guest check PNG file which has to be appended to the application settings base URL.""" checkFileId: String """Check Number""" checkNumber: String """Closure Number""" closureNumber: Float """Y => tax posting for a collecting agent""" collectionAgentPostingYn: String """Comments""" comments: String """Trx code of original transaction that was turned into a comp""" compLinkTrxCode: String """Trx no of original transaction that was turned into a comp""" compLinkTrxNumber: Float """Comp Type Code""" compTypeCode: String """Complinktranscodeid""" complinktranscodeid: String """Compressed Y/N""" compressedYn: String """Contract Foreign Currency ID""" contractforeigncurrencyid: String """Indicates if this transaction is used as part of a correction folio.""" correctionYn: String """Coupon Number""" couponNo: String """Covers""" covers: String """Credit Card ID""" creditCardId: Float """Fee (surcharge) amount for a credit card transaction.""" creditCardSurcharge: Float """Credit YN""" creditYN: String """Currency Code""" currencyCode: String """This is the custom charge date populated by Property Charge Adjustments.""" customChargeDate: Date """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Debit YN""" debitYN: String """Deferred Y/N""" deferredYn: String """Deleted Flag""" deletedFlag: String """Indicates if the posting is a deposit posting as part of the Guest Ledger Deposits functionality. Also indicates if the charge has been offset after checkin. Possible values [PRX]""" depPostingFlag: String """Indicates if this row is a deposit tax which has been transfered.""" depTaxTransferedYn: String """Deposit Ledger Credit""" depositLedgerCredit: Float """Deposit Ledger Debit""" depositLedgerDebit: Float """Deposit Transaction ID""" depositTransactionId: String """Depositlinkfintransid""" depositlinkfintransid: Float """Displayflag""" displayflag: String """Cuurency code for parrallel currency.""" dualCurrency: String """Dual Currency Gross Amount""" dualCurrencyGrossAmount: Float """Credit amount on the guest account stored in parrallel currency.""" dualCurrencyGuestCredit: Float """Debit amount on the guest account stored in parrallel currency.""" dualCurrencyGuestDebit: Float """Dual Currency Net Amount""" dualCurrencyNetAmount: Float """Transactions statement date used for OVOS statement reports to allocate transactions into required statement period.""" effectiveDate: Date """Stores the voucher_no from VOUCHERS_DETAILS to keep track of voucher amount consumed.""" electronicVoucherNo: Float """File Name of the Electronically Signed Payment Receipt.""" esignedReceiptName: String """Euro Exchange Rate""" euroExchangeRate: Float """Exchange difference posting transaction number of the posting that generated the exchange difference.""" exchDifferenceTrxNumber: Float """Exchange Date""" exchangeDate: Date """Exchange Difference YN""" exchangeDifferenceYN: String """Exchange Rate""" exchangeRate: Float """Type of currency exchange conducted. Possible values: [E]xchange [S]ettlement [C]ommission [M]embership [EC] Exchange Check [P]osting.""" exchangeType: String """Export Invoice Type""" expInvoiceType: String """Export Original Invoice""" expOriginalInvoice: String """Oxi interface to External System Result message text.""" extSysResultMsg: String """Transaction ID from external system.""" extTransactionId: String """Flexible Benefit Award certificate number.""" fbaCertificateNumber: String """Number to identify the DML sequence.""" financialDmlSeqNumber: Float """Financial Transaction Code Type""" financialTransactionCodeType: String """Fintransactionid""" fintransactionid: Float """Fintransid""" fintransid: Float """Fiscal Bill Number""" fiscalBillNo: String """Fixed Charges YN""" fixedChargesYN: String """Folio Number""" folioNo: Float """Folio Type""" folioType: String """Folio Type Join""" folioTypeJoin: String """Folio View""" folioView: Float """Folioid""" folioid: Float """Foreign Currency ID""" foreignCurrencyID: String """Foreign Exchange commission amount.""" forexCommAmount: Float """Foreign Exchange commission percentage.""" forexCommPerc: Float """Populate as Y for transactions posted with application settings 1)Currency Exchange Tax and 2)Currency Exchange Offset.""" forexTaxYn: String """Type of Foreign Currency Exchange. B=Buy S=Sell.""" forexType: String """From Resv ID""" fromReservationId: Float """Column has become unused after the chage of business rules down the line.""" ftGeneratedType: String """This is the transaction type which says whether it is a Consumption(C) Payment (FC) or Package (PK) and it is inherited from transaction code.""" ftSubtype: String """General Cashier Id.""" genCashierId: Float """HYATT mode: Gold Passport Award Cancel Code. Field will be populated for transactions that are created when awards redeemed in the past are cancelled e.g. when a Folio is Re-opened.""" gpAwardCancelCode: String """HYATT mode: Gold Passport Award Code associated with the redemption of points. Field will be populated for a payment transaction.""" gpAwardCode: String """Gross Amount""" grossAmount: Float """HYATT mode: Indicates if an Award Transaction was cancelled.""" groupAwardCancelledYN: String """Guest Account Ledger Credit""" guestAccountLedgerCredit: Float """Debit amount on the guest account""" guestAccountLedgerDebit: Float """Guest Country""" guestCountry: String """Guest Country Code""" guestCountryCode: String """Specifies the Hotel acct against which this transaction has beenposted.""" hotelAcct: String """In-House Credit""" inHouseCredit: Float """In-House Debit""" inHouseDebit: Float """Identifies if this transaction has had inclusive taxes removed during comping.""" incTaxDeductedYn: String """Ind Adjustment Y/N""" individualAdjustmentYN: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """The name of the user who created the record.""" insertUserName: String """Installments""" installments: Float """Articleid""" internalArticleid: Float """Businessdate""" internalBusinessdate: Date """Cashierid""" internalCashierid: Float """Internal Window ID""" internalWindowId: Float """Internal YN""" internalYN: String """Invoice Close Date""" invoiceCloseDate: Date """Invoice Number""" invoiceNumber: Float """Invoice Type""" invoiceType: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Link Transaction No""" linkTrxNumber: Float """Internal ID to uniquely identify the Property""" locationID: String """Market Code""" marketCode: String """Market Description""" marketDescription: String """Market Display Sequence""" marketDisplaySequence: Float """Market Group Code""" marketGroupCode: String """Market Group Description""" marketGroupDescription: String """Market Group Display Sequence""" marketGroupDisplaySequence: Float """Marketid""" marketid: String """Membership ID""" membershipID: Float """Sequence number generated automatically when packages are posted during manual room and tax.""" mtrxNoAgainstPackage: Float """Name ID""" nameId: Float """Name Tax Type""" nameTaxType: String """Net Amount""" netAmount: Float """Non Revenue Amount""" nonRevenueAmount: Float """Number Dialed.""" numberDialed: String """Transaction Description.""" oTransactionDesc: String """Currency code for contract currency.""" oVOSCurrency: String """Contract equivalent to the GROSS_AMOUNT field value for the transaction number this record applies to.""" oVOSGrossAmount: Float """Stores the credit amount on the guest account in contract currency.""" oVOSGuestCredit: Float """Stores the debit amount on the guest account in contract currency.""" oVOSGuestDebit: Float """Contract equivalent to the NET_AMOUNT field value for the transaction number this record applies to.""" oVOSNetAmount: Float """On Hold YN""" onHoldYN: String """The original transaction amount sent to the financial API.""" orgPostedAmount: Float """Stores the original AR ledger debit amount for Direct Bill transactions.""" organizationArLedgerDebit: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Stores original bill number after void.""" originalBillNumber: Float """Stores original folio type after void.""" originalFolioNumber: String """Original Resv Name ID""" originalReservationNameId: Float """Original Room""" originalRoom: String """Originalresvid""" originalresvid: Float """Others Bag Number""" othersBagNumber: String """Package""" package: String """Package Allowance amount of a package that has an allowance.""" packageAllowance: Float """Arrangement code from the package associated to this transaction.""" packageArrangementCode: String """Credit amount on the guest package account.""" packageLedgerCredit: Float """Debit amount on the guest package account""" packageLedgerDebit: Float """Identifies the type of a package posting. Possible values are: PKG_WRAPPER INCLTAX_PKG_ROOM EXCLTAX_PKG_ROOM INCLTAX_PKG_WITH_ALLOWANCE EXCLTAX_PKG_WITH_ALLOWANCE INCLTAX_PKG_WITHOUT_ALLOWANCE EXCLTAX_PKG_WITHOUT_ALLOWANCE""" packageTrxType: String """Packagelinkfintransid""" packagelinkfintransid: Float """Parallel Foreign Currency ID""" parallelforeigncurrencyid: String """Parentfintransid""" parentfintransid: Float """Passerby Name.""" passerByName: String """Payment Surcharge Amount.""" paymentSurchargeAmt: Float """Payment Surcharge Type. Currency for the CASH payment method.""" paymentSurchargeType: String """Payment Type""" paymentType: String """Payments-Reference""" paymentsReference: String """Posted Amount in Base Currency""" postedAmountInBaseCurrency: Float """Posted Amount in Transaction Currency""" postedAmountInTransactionCurrency: Float """Posting Date""" postingDate: DateTime """Posting Rhythm""" postingRhythm: String """Source Profile of the posting coming from IFC. Related to 9700 functionality.""" postingSourceNameId: Float """Indicates if the posting is part of a rate code posting (RATE CODE) or if posted manually (MANUAL).""" postingType: String """Postit Number""" postitNo: Float """Postit Y/N""" postitYn: String """Price Per Unit""" pricePerUnit: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Processed 8300 YN""" processed8300YN: String """Productid""" productid: String """Profileid""" profileid: Float """Populated with [P] for package profit and [L] for package loss transactions.""" profitLossFlag: String """Proforma Y/N""" proformaYn: String """Code to uniquely identify the Property""" property: String """Property Bill Prefix""" propertyBillPrefix: String """Quantity""" quantity: Float """Queue Name""" queueName: String """Rate Code""" rateCode: String """Ratecodeid""" ratecodeid: String """Receipt Number""" receiptNumber: Float """Indicates the receipt type. Different receipts are identified by different types""" receiptType: String """Reporting Trx Code""" repTransactionCode: String """Reporting Tc Group""" repTransactionCodeGroup: String """Reporting Tc Group Desc""" repTransactionCodeGroupDescription: String """Reporting Tc Subgroup""" repTransactionCodeSubgroup: String """Reporting Tc Subgroup Desc""" repTransactionCodeSubgroupDescription: String """Stores Reservation_deposit_schedule_id from RESERVATION_DEPOSIT_SCHEDULE table to link the deposit payment to the deposit request.""" reservationDepositId: Float """Reservationid""" reservationid: Float """Resvenddate""" resvenddate: Date """Revenue Amount.""" revenueAmount: Float """Stores the trx_no of the reversed payment.""" reversePaymentTrxNumber: Float """Revision Number""" revisionNo: Float """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Room Class""" roomClass: String """Room Nts""" roomNts: Float """Stores the effective room nights with decimals making it significant for postings splits edits and adjustments. Required by B&B Hotels.""" roomNtsEffective: Float """Room Number""" roomNumber: String """Roomid""" roomid: String """Round Factor Y/N""" roundFactorYn: String """TRX_NO of the transaction associated with this rounding factor posting.""" roundLinkTrxno: Float """Indicates if the transaction has been routed.""" routedYn: String """Routing date for comp routings - populated only if routed transaction has trx date less than business date.""" routingDate: Date """Link the posting to the routing instruction that is specified during the setup of routing instructions for guests.""" routingInstrnId: Float """Service Charge Included Revenue Tax Percent""" serviceChargeIncludedRevenueTaxPercent: Float """Indicates if the transaction is a service recovery adjustment.""" serviceRecoveryAdjustmentYn: String """Stores the department code responsible for the adjustment.""" serviceRecoveryDeptCode: String """Settlement Flag""" settlementFlag: String """Source Code""" sourceCode: String """Current transaction uses Net or Gross revenue for Source commission calculation.""" sourceCommissionNetYn: String """Source Description""" sourceDescription: String """Source Display Sequence""" sourceDisplaySequence: Float """Source Group Code""" sourceGroupCode: String """Source Group Description""" sourceGroupDescription: String """Source Group Display Sequence""" sourceGroupDisplaySequence: Float """Sourceid""" sourceid: String """Stores the type of split performed: [A]mount [Q]uantity [P]ercent.""" splitType: String """Identifies if the transaction is stamp duty.""" stampDutyYN: String """Supplement""" supplement: String """Current transaction uses Net or Gross revenue for Travel Agent commission calculation.""" taCommissionNetYn: String """Target Property""" targetResort: String """Targetlocationid""" targetlocationid: String """Tax Deferred Until Check-Out YN""" taxDeferredUntilCheckOutYN: String """Tax Elements""" taxElements: String """Tax Generated YN""" taxGeneratedYN: String """Tax Inclusive YN""" taxInclusiveYN: String """Tax Invoice No""" taxInvNumber: String """Tax Rate""" taxRate: Float """Tax Rate Type""" taxRateType: String """Transaction Code Group""" tcGroup: String """Transaction Code Subgroup""" tcSubgroup: String """Class1 Code.""" tclCode1: String """Class1 Code.""" tclCode2: String """Threshold Diversion ID""" thresholdDiversionId: Float """Stores the corresponding quantity of the threshold for QUANTITY and MINUTES types.""" thresholdEntityQty: Float """Threshold Entity Type""" thresholdEntityType: String """Flag to identify how the posting was treated.[THRESHOLD_ALLOWED] --> OPERA treated this of ?Allowed? type at the time of posting.[THRESHOLD_REQUIRED] --> OPERA treated this of ?Required? type at the time of posting.[null / blank] --> not a diversion related transaction.""" thresholdTreatmentFlag: String """To Resv Name ID""" toReservationNameId: Float """Tran Action ID""" tranActionId: Float """Transaction Activity Date""" transactionActivityDate: Date """Transaction Code""" transactionCode: String """Transaction Code Description""" transactionCodeDescription: String """Tc Group Description""" transactionCodeGroupDesc: String """Tc Subgroup Description""" transactionCodeSubgroupDesc: String """Transaction Date""" transactionDate: Date """Transaction Number Added By""" transactionNumberAddedBy: Float """Transaction Posting Date""" transactionPostingDate: Date """Time transaction was posted.""" transactionPostingTime: String """Time transaction was posted with seconds.""" transactionPostingTimeWithSeconds: String """Transaction Reservation Name ID""" transactionReservationNameID: Float """Transaction Status""" transactionStatus: String """Transaction Type""" transactionType: String """Transaction from Account""" transactionFromAccount: Float """Transaction to Account""" transactionToAccount: Float """Transactions-Reason Code""" transactionsReasonCode: String """Transcodearrangementid""" transcodearrangementid: Float """Transferfromaccountid""" transferfromaccountid: Float """Transferfromresvid""" transferfromresvid: Float """Transfertoaccountid""" transfertoaccountid: Float """Transfertoresvid""" transfertoresvid: Float """Travel Agent Commissionable YN""" travelAgentCommissionableYN: String """Trial Balance Amount Gross""" trialBalanceAmountGross: Float """Trial Balance Amount Net""" trialBalanceAmountNet: Float """Transaction Code""" trxCode: String """Trx Number""" trxNo: Float """Trx Number Against Package""" trxNoAgainstPackage: Float """The trx_no against which this transaction gets adjusted.""" trxNumberAdjust: Float """Transaction No Header""" trxNumberHeader: Float """Stores the Trx_No of the main transaction being split.""" trxNumberSplit: Float """Transaction Service Type""" trxServiceType: String """Transaction type: possible values: [CACH].""" trxType: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float """Flag to identify an Upsell posting.""" upsellChargeYn: String """User ID""" userID: Float """Tax Amount for Commission.""" vatAmount: Float """Vat Offset Y/N""" vatOffsetYn: String """Vendor Tran ID""" vendorTranID: String } type BookingsBlockReservationCancelPolicyDetailsType { """Percentage to be charged for the cancellation""" percentCancellation: Float """Percentage due for the cancellation""" percentDue: Float """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Foreign Cancel Amount""" cForeignCancelAmount: Float """Cancel Date.""" cancellationDate: DateTime """Cancellation Penalty""" cancellationPenalty: String """Amount to be charged for the cancellation""" cancellationPenaltyAmount: Float """Cancellation Penalty Type""" cancellationPenaltyType: String """Cancellation Rule Description""" cancellationRuleDescription: String """Central Cancellation Penalty Amount""" centralCancellationPenaltyAmount: Float """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Description""" description: String """Dml Sequence No""" dmlSeqNumber: Float """Exchange Rate info used for cancelation penalty if Rate code is in a difference currency.""" exchangeRateInfo: String """External ID""" externalId: String """Cancel Amount in Foreign currency if Rate code is in a different currency.""" foreignCancelAmount: Float """Insert Action Instance ID""" insertActionInstanceId: Float """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Manual Y/N""" manualYn: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Processed Y/N""" processedYn: String """Code to uniquely identify the Property""" property: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Rate Dc Sequence""" rateDcSeq: Float """Internal""" reservationCancelPolicyId: Float """Resv Name ID""" reservationNameId: Float """Room Nights""" roomNights: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type BookingsBlockBlockAccessExclusionsDetailsType { """The message that will pop up if the block is excluded (not allowed) to modify/create reservation/cancel reservation.""" accessExclusionMessage: String """Always CRO.""" accessSourceType: String """Allotment Header ID""" allotmentHeaderId: Float """Has permission to cancel reservations for the block.""" allowCancelReservation: String """Has permission to create reservations for the block.""" allowCreateReservation: String """Has permission to modify reservations for the block.""" allowModifyReservation: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Hide(Y) / Display (N): Access excluded business blocks in availability screen.""" hideFromAvailabilityScreen: String """CRO code.""" hub: String """Inactive""" inactive: String """Inactive Date""" inactiveDate: DateTime """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Code to uniquely identify the Property""" property: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type BookingsBlockBlockNoteDetailsType { """Block ID""" allotmentid: Float """Allotmentnoteid""" allotmentnoteid: Float """Block Begin Date""" blockBeginDate: Date """Block End Date""" blockEndDate: Date """Book ID""" bookId: Float """The name of the user who created the record.""" createdBy: String """Created Date""" createdDate: DateTime """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedflag: String """External ID""" externalId: Float """Inactive Date""" inactiveDate: Date """Inactive Flag""" inactiveflag: String """Insert User""" insertUser: Float """Internal YN""" internalYN: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Laptop Change""" laptopChange: Float """Leadnoteflag""" leadnoteflag: String """Internal ID to uniquely identify the Property""" locationID: String """Foreign Key on book$notes.note_id.""" masterNoteId: Float """Note Code""" noteCode: String """Note Details""" noteDetails: String """Note ID""" noteId: Float """Note Title""" noteTitle: String """Note Type Code""" noteTypeCode: String """Notetypeid""" notetypeid: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Parentnoteid""" parentnoteid: Float """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 """Update User""" updateUser: Float """Updated By""" updatedBy: String """Updated Date""" updatedDate: DateTime } type BookingsBlockBlockProductDetailsType { """Action ID""" actionId: Float """Allotment Header ID""" allotmentHeaderId: Float """System Generated number that uniquely identifies a record in this table.""" allotmentProductId: Float """Block ID""" allotmentid: Float """Begin Date""" beginDate: Date """Block Begin Date""" blockBeginDate: Date """Block End Date""" blockEndDate: Date """Calculation Rule""" calculationRule: String """Central Package Allowance""" centralPackageAllowance: Float """Central Package Code""" centralPackageCode: String """Central Package Decsription""" centralPackageDecsription: String """Central Price""" centralPrice: Float """Currency""" currency: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedflag: String """Dml Sequence No""" dmlSeqNumber: Float """End Date""" endDate: Date """Formula""" formula: String """Inactive Flag""" inactiveflag: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Allotmentproductid""" internalAllotmentproductid: Float """Productid""" internalProductid: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Laptop Change""" laptopChange: Float """Internal ID to uniquely identify the Property""" locationID: String """Offset Type""" offsetType: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Allowance for the product.""" packageAllowance: Float """Package Code""" packageCode: String """Package Description""" packageDescription: String """Posting Rhythm""" postingRhythm: String """Indicates if the posting is part of a rate code posting (RATE CODE) or if posted manually (MANUAL).""" postingType: String """Price""" price: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Product Group""" productGroup: String """Product ID""" productId: String """Product Source""" productSource: String """Code to uniquely identify the Property""" property: String """Quantity Excluded""" qtyExcluded: Float """Quantity""" quantity: Float """Rate Code""" rateCode: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type BookingsBlockBlockItemDetailsType { """Allotment Header ID""" allotmentHeaderId: Float """Block ID""" allotmentid: Float """Allotmentitemid""" allotmentitemid: Float """Item available from this time.""" availableFrom: Date """Available From Time""" availableFromTime: String """Item available until this time.""" availableTo: Date """Available To Time""" availableToTime: String """Begin Date""" beginDate: Date """Block Begin Date""" blockBeginDate: Date """Block End Date""" blockEndDate: Date """Central Price""" cPrice: Float """Cateringitemid""" cateringitemid: Float """Central Item Description""" centralItemDescription: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedflag: String """End Date""" endDate: Date """Hourly Y/N""" hourlyYn: String """ID""" id: Float """Inactive Flag""" inactiveflag: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Item Class""" itemClass: String """Item Code""" itemCode: String """Item Description""" itemDescription: String """Item ID""" itemId: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Price""" price: Float """Price Code""" priceCode: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Code to uniquely identify the Property""" property: String """Quantity""" quantity: Float """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Rate Name""" rateName: String """Reporting Item Class""" repItemClass: String """Revenue Type""" revenueType: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type BookingsBlockBlockTraceDetailsType { """Action ID""" actionId: Float """Allotment Header ID""" allotmentHeaderId: Float """Block ID""" allotmentid: Float """Allotmenttraceid""" allotmenttraceid: Float """Block End Date""" blockEndDate: Date """Central Department Description""" centralDepartmentDescription: String """The name of the user who created the record.""" createdBy: String """Created On""" createdOn: DateTime """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Department Code""" departmentCode: String """Department Description""" departmentDescription: String """Dml Sequence No""" dmlSeqNumber: Float """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Code to uniquely identify the Property""" property: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Resolved By""" resolvedBy: String """Resolved On""" resolvedOn: DateTime """Trace Date""" traceDate: Date """Trace ID""" traceId: Float """Trace Status""" traceStatus: String """Trace Text""" traceText: String """Trace Time""" traceTime: String """Tracebusinessdate""" tracebusinessdate: DateTime """Update User""" updateUser: Float """Updated By""" updatedBy: String """Updated On""" updatedOn: DateTime } type BookingsBlockBlockAlternateDatesDetailsType { """Primary Key ID.""" allotmentAltDateSeqno: Float """Allotment Header ID""" allotmentHeaderId: Float """Alternate Departure Date.""" alternateEndDate: Date """Alternate Arrival Date.""" alternateStartDate: Date """Arrival Date""" arrivalDate: Date """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Departure Date""" departureDate: Date """2 Person Rate.""" doubleOccupancyRate: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Indicates if this record corresponds with the main booking dates.""" mainBookDatesYn: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Indicates the preferred alternate date.""" preferredYn: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Priority""" priority: Float """Code to uniquely identify the Property""" property: String """3 Person Rate.""" quadrupleOccupancyRate: Float """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Room Type""" roomType: String """Sc Room Category""" scRoomCategory: String """1 Person Rate.""" singleOccupancyRate: Float """3 Person Rate.""" tripleOccupancyRate: Float } type BookingsBlockSellMessagesDetailsType { """Allotment Header ID""" allotmentHeaderId: Float """Begin Date""" beginDate: Date """Block Code""" blockCode: String """Central Room Type""" centralRoomType: String """Chain Code""" chainCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """End Date""" endDate: Date """Inactive Date""" inactiveDate: DateTime """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Language""" language: String """Internal ID to uniquely identify the Property""" locationID: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Property""" property: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Rate Code""" rateCode: String """Room Category""" roomCategory: String """Room Type""" roomType: String """The primary key for this table.""" sellId: Float """The actual message to be displayed.""" sellMessage: String """Sequence""" sequence: Float """Stick the message on top of the screen without scrolling it.""" stickyFlag: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type BookingsBlockPropertyPropertyDetailsType { """The property that the record belongs to""" property: String """Number format of AR account no.""" aRAccountNoFormat: String """Specifies if the AR acct No is mandatory(Y/N)""" aRAccountNumberMandatoryYN: String """Default Account Type for an Agent for the Property""" aRAgent: String """Internal""" aRBalanceTrxCode: String """Default Account Type for a Company for the Property""" aRCompany: String """Internal""" aRCreditTrxCode: String """Default Account Type for a Group for the Property""" aRGroups: String """Default Account Type for Individual for the Property""" aRIndividuals: String """Internal""" aRSettleCode: String """Internal""" aRTypewriter: String """Access Code""" accessCode: String """Number of handicapped rooms.""" accessibleRooms: Float """Aging bucket 1""" agingLevel1: Float """Aging bucket 2""" agingLevel2: Float """Aging bucket 3""" agingLevel3: Float """Aging bucket 4""" agingLevel4: Float """Aging bucket 3""" agingLevel5: Float """The Airport Code for the airport near the property""" airport: String """Distance of the Airport specified in the AIRPORT_CODE column from the Property""" airportDistance: String """Time it takes to travel the distance between the Property and the Airport specified in AIRPORT_CODE column""" airportTime: String """Allow loggin in to this resort(Y/N)""" allowLoginYN: String """Period for the allowance""" allowancePeriodAdj: String """Internal""" awardsTimeout: Float """Ball Room Area""" ballroomArea: String """No of Ballroom Seats""" ballroomSeats: Float """The base language of the Hotel""" baseLanguage: String """It contains the reservation type to be used when making group block""" block: String """Brand Code of the property.""" brandCode: String """Financial Year of the Property""" budgetMonth: Float """The date this resort becomes valid for use by the system""" businessDate: Date """Value for the parameter.""" businessID: String """Value for the parameter.""" businessRegistrationCode: String """Code for the CRO""" cROCODE: String """Internal""" cashShiftDrop: String """Catering Currency Code used when Catering Currency differs from base currency.""" cateringCurrencyCode: String """Catering currency format.""" cateringCurrencyFormat: String """Central Exchange Date""" centralXchangeDate: Date """Central Exchange Rate""" centralXchangeRate: Float """Central Credit Limit""" centralCreditLimit: Float """Central Currency Code""" centralCurrencyCode: String """Central Currency Description""" centralCurrencyDescription: String """Central Double Rate2""" centralDblRate2: Float """Central Double Rate1""" centralDblRate1: Float """Central Passerby Market""" centralPasserbyMarket: String """Central Passerby Source""" centralPasserbySource: String """Central Property Type""" centralPropertyType: String """Central Sgl Rate1""" centralSglRate1: Float """Central Sgl Rate 2""" centralSglRate2: Float """Central State""" centralState: String """Central State Description""" centralStateDescription: String """Central Sui Rate1""" centralSuiRate1: Float """Central Sui Rate 2""" centralSuiRate2: Float """Central Tpl Rate1""" centralTplRate1: Float """Central Tpl Rate 2""" centralTplRate2: Float """Central Warning Amount""" centralWarningAmount: Float """Chain Code for the chain to which the property belongs""" chainCode: String """The description of this chain.""" chainDescription: String """Chain Mode""" chainMode: String """Internal""" checkExgPaidout: String """The Hotel official check out time""" checkOutTime: DateTime """Internal""" checkShiftDrop: String """Internal""" checkTrxcode: String """The Hotel official check intime""" checkInTime: DateTime """The physical city in which this property resides.""" city: String """City Description""" cityDescription: String """Internal""" comAddress: String """Internal""" comMethod: String """Internal""" comNameXrefId: Float """Internal""" companyAddressType: String """Internal""" companyPhoneType: String """Internal""" configurationMode: String """Internal""" confirmRegcardPrinter: String """Number of connecting rooms.""" connectingRooms: Float """The unique name of application user""" contacts: String """Number of copies to be printed""" copies: Float """Country name.""" country: String """The name of the country in which this property resides.""" countryCode: String """Value for the parameter.""" countryMode: String """The default credit limit for guests.""" creditLimit: Float """Currency Code.""" currencyCode: String """Currency Symbol like $ or EURO symbol""" currencyCodeSymbol: String """A description of this currency.""" currencyDescription: String """Format for the local currency.""" currencyFormat: String """Color that of the background""" curtainColor: String """DSI""" dSI: Float """Date the aging should begin""" dateForAging: String """Type of separator to distinguish between DD MM and YYYY""" dateSeparator: String """Number of places for the default currency""" decimalPlaces: Float """Type of decimal separator""" decimalSeparator: String """Number of decimals to designate currency""" decimals: Float """Folio style to be used for all guests""" defaultFolioStyle: Float """Default guest address format.""" defaultGuestAddress: String """Future use""" defaultMembershipType: String """Future use""" defaultPostingRoom: String """Default property address format.""" defaultPropertyAddress: String """Future use""" defaultRateCode: String """Rate code used to default a PCR rate code used in FIT Contracts.""" defaultRatecodePcr: String """Rate code used to default a RACK rate code used for FIT Contracts.""" defaultRatecodeRack: String """Default registration card for the property.""" defaultRegistrationCard: String """The Default reservation type for this property""" defaultReservationType: String """Deleted Flag""" deletedFlag: String """Future use""" depositLedgerTrxCode: String """Destination ID""" destinationId: String """Future use""" dfltPkgTranCode: String """Future use""" dfltTranCodeRateCode: String """Internal""" directions: String """Future use""" dirsales: String """LOGIN into the application is disabled.""" disableLoginYN: String """Number of double rooms.""" doubleRooms: Float """Download Rest YN""" downloadRestYN: String """Pager number for the Manager on duty for the property.""" dutyManagerPager: String """Email id for the property.""" email: String """Future use.""" endDate: Date """Default Exchange posting status for the property""" exchangePostingType: String """Floor number of executive floor.""" executiveFloorNumber: String """Hotel code used for third party exports""" expHotelCode: String """Future use""" extExpFileLocation: String """Future use""" extPropertyCode: String """Indicates that the property uses an external SC system.""" externalSCYN: String """Number of family rooms.""" familyRooms: Float """Fax number formats.""" faxNoFormat: String """The fax phone number""" faxNumber: String """Future use""" fiscalEndDate: Date """Future use""" fiscalPeriodType: String """Future use""" fiscalStartDate: Date """Fiscal Year Begin Month""" fiscalYearBeginMonth: Float """Fiscal Year Begin Year""" fiscalYearBeginYear: Float """Screen Painter flags to indicate whether an item is changable/ movable etc.""" flags: String """Future use""" flowCode: String """Property Free Nights Stay Tier.""" fnsTier: String """Other languages""" folioLanguage1: String """Other languages""" folioLanguage2: String """Other languages""" folioLanguage3: String """Other languages""" folioLanguage4: String """Future use""" genmgr: String """To define an upper limit to the number of rooms for Group""" groupRoomWarning: Float """Future use""" guestLookupTimeout: Float """Number of guest elevators.""" guestRoomElevators: Float """Total of guest rooms floors.""" guestRoomFloors: Float """Future use""" hotelCode: String """Future use""" hotelFC: String """Hotel id""" hotelID: String """Future use""" hotelType: String """Future use""" iMGDirectionID: Float """Future use""" iMGHotelID: Float """Future use""" iMGMapID: Float """Future use""" inactiveDaysForGuestProfile: Float """Inactive Flag""" inactiveFlag: String """Future use""" individualAddressType: String """Future use""" individualPhoneType: String """To define an upper limit to the number of rooms for group""" individualRoomWarning: Float """The date the record was created""" insertDate: DateTime """The user that created the record""" insertUser: Float """Int Tax Included YN""" intTaxIncludedYN: String """Future use""" inventoryYN: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """To calculate the entire availability of the Hotel for future reservations""" keepAvailability: Float """Latitude of the property in decimal""" latitude: Float """Future use""" leadsend: String """The owner who owns this property""" legalOwner: String """The property that the record belongs to""" locationID: String """Long date format for the property.""" longDateFormat: String """The default length of stay""" longStayControl: Float """Longitude of the property in decimal""" longitude: Float """Maximum adults in family rooms.""" maxAdultsInFamilyRoom: Float """Maximum children in family rooms.""" maxChildrenInFamilyRoom: Float """Future use""" maxOccupancy: Float """Maximum number of days that are allowed to credit a bill. (Country requirements.) Used in CASHIERING MODULE.""" maximumCreditDays: Float """Indicates whether the property supports MBS. Used in some file exports.""" mbsSupportedYN: String """Future use""" meetRooms: Float """Future use""" meetSeats: Float """Future use""" meetSpace: Float """Future use""" meetingFC: String """Minimum days for reminder letter.""" minDaysBet2ReminderLetter: Float """Internal""" nameIdLink: Float """Future use""" nightAuditCashierID: String """Number of non smoking rooms.""" nonSmokingRooms: Float """Notes for the property""" noteDetails: String """Total number of beds in this property""" numberOfBeds: Float """Total number of floors in this property""" numberOfFloors: Float """Number of Rooms""" numberOfRooms: Float """Future use""" opusCurrencyCode: String """Organization ID""" organizationID: Float """Organization Internal ID""" organizationInternalID: Float """Future use""" ownership: String """Package Loss code for a particular package""" packageLoss: String """Package Profit code for a particular Package""" packageProfit: String """Parent Org Code""" parentOrgCode: String """Market code""" passerbyMarket: String """Source code""" passerbySource: String """Path""" path: String """Minimim Payment Date for the Property used in Cross Property Postings. This will get updated while running the user defined procedure during the night audit process.""" paymentDate: DateTime """Future use""" perReservationRoomLimit: Float """The direct dial phone number of this property""" phoneNumber: String """The postal code of this property.""" postalCode: String """Primary Key ID""" primaryKeyID: Float """URL where property information is located.""" proinfoUrl: String """Property MAP URL.""" propMapUrl: String """Property picture URL.""" propPicUrl: String """The property that the record belongs to""" propertyCode: String """The name of this property.""" propertyName: String """Type of resort.""" propertyType: String """Future use""" quotedCurrency: String """RNA Insert Date""" rNAInsertdate: DateTime """RNA Update Date""" rNAUpdatedate: DateTime """Minimim last Reconciliation Date for the Property used in Cross Property Postings. This will get updated while running the user defined procedure during the night audit process.""" reconcileDate: DateTime """Future use""" regionCode: String """Description of the Region.""" regionDescription: String """Future use""" restaurant: Float """Total number of Sheets""" rhythmSheets: Float """Total number of Towels""" rhythmTowels: Float """Room amenity.""" roomAmenities: String """Future use""" sGLNum: String """Future use""" sGLRate1: Float """Future use""" sGLRate2: Float """Future use""" sUINum: String """Future use""" sUIRate1: Float """Future use""" sUIRate2: Float """To store number of days before deleting the gest profile""" saveProfiles: Float """Future use""" scriptID: Float """Future use""" season1: String """Future use""" season2: String """Future use""" season3: String """Future use""" season4: String """Future use""" season5: String """Indicates that the property accepts leads as bookings.""" sendLeadAsBooking: String """Shop description.""" shopDescription: String """Short date format for the property.""" shortDateFormat: String """Number of single rooms.""" singleRooms: Float """For default commission percentage""" sourceCommission: String """The state in which this property is located.""" state: String """Description of the state.""" stateDescription: String """The street of the property.""" street: String """Number of suites.""" suites: Float """Internal""" summCurrencyCode: String """For default commission percentage""" tACommission: String """Future use""" tPLNum: String """Future use""" tPLRate1: Float """Future use""" tPLRate2: Float """Formats for telephone number""" telephoneNoFormat: String """Separator for monetory values""" thousandSeparator: String """Default time format for the property.""" timeFormat: String """Time zone region selected by the employee.""" timeZone: String """Toll free telephone number.""" tollFree: String """Future use""" totalRooms: Float """Tourist Number""" touristNumber: String """Indicates whether the property handles multi byte characters and whether they are translateable or not""" translateMulticharYN: String """Turnaway code for the property.""" turnawayCode: String """Number of twin rooms.""" twinRooms: Float """The date the record was modified""" updateDate: DateTime """The user that modified the record""" updateUser: Float """VAT ID of this property.""" vatID: String """Future use""" videoCheckoutPrinter: String """Video check out start time.""" videoCheckoutStart: DateTime """Video check out end time.""" videoCheckoutStop: DateTime """Future use""" wakeUpDelay: Float """Amount at which warning is raised.""" warningAmount: Float """Webaddress of the property""" web: String """Weekend days for the property.""" weekendDays: String """Internal""" zeroInvPurDays: Float } type BookingsBlockAllotmentSubscriptionDetailsType { """Block ID""" bookingId: Float """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Allow exchange of the block""" exchangeYN: String """Ext Allotment ID""" extBookingID: String """This is External systems reference no or Block Code""" externalReference: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """This is the Interface_id of the System which sent/Received Allotment""" interfaceID: String """JRN Update Date and Time""" jRNUpdateDate: Date """JRN Update Date""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Code to uniquely identify the Property""" property: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """This field stores the revision token from Marsha interface for Marriott.""" revisionToken: String """UDFC01""" uDFC01: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float }