# title : OPERA Cloud RnA ARAgingReport GraphQL API, # description : GraphQL API to cater for Detailed information on accounts receivable transactions including aging bucket of invoices, open transaction amounts, folio information and the account details. # Compatible with OPERA Cloud RnA release 26.1.0.0. # This document and all content within is available under the Universal Permissive License v 1.0 # (https://oss.oracle.com/licenses/upl). Copyright (c) 2020,2026 Oracle and/or its affiliates # version : 26.1.0.0 # termsOfService : https://www.oracle.com/legal/terms.html # contact_email : hospitality_apis_ww_grp@oracle.com # license : https://opensource.org/licenses/upl directive @stream(if: Boolean, label: String, initialCount: Int = 0) on FIELD directive @conditionalInputPair(pair: Int) on INPUT_FIELD_DEFINITION directive @mandatoryInput on INPUT_FIELD_DEFINITION scalar Date scalar DateTime # Date format: "YYYY-MM-DD" input DateInput{ _eq: Date _ne: Date _in: [Date] _nin: [Date] _gt: Date _lt: Date _gte: Date _lte: Date _btn: DateRangeInput _isNull: Boolean } input DateRangeInput { start: Date! end: Date! } # Datetime format: "YYYY-MM-DD HH24:MI:SS" input DateTimeInput { _eq: DateTime _ne: DateTime _in: [DateTime] _nin: [DateTime] _gt: DateTime _lt: DateTime _gte: DateTime _lte: DateTime _btn: DateTimeRangeInput _isNull: Boolean } input DateTimeRangeInput { start: DateTime! end: DateTime! } input StringInput { _eq: String _ne: String _in: [String] _nin: [String] _gt: String _lt: String _gte: String _lte: String _isNull: Boolean } input FloatInput { _eq: Float _ne: Float _in: [Float] _nin: [Float] _gt: Float _lt: Float _gte: Float _lte: Float _btn: FloatRangeInput _isNull: Boolean } input FloatRangeInput { start: Float! end: Float! } # Mandatory filters: # The following filters are mandatory required filters. # Please ensure the request includes all the below fields. # - aragingreportDetailsResort # - aragingreportDetailsTrxDate input ARAgingReportQueryArgumentsType { """JRN Update Date and Time""" aragingreportDetailsJrnupdatedttm: DateTimeInput """Code to uniquely identify the Property""" aragingreportDetailsResort: StringInput! @mandatoryInput """Transaction Date""" aragingreportDetailsTrxDate: DateInput! @mandatoryInput """Central Xchange Date""" transcodeDetailsCXchangeDate: DateInput """DSI Internal Data Source ID to identify Opera Chain and instance""" transcodeDetailsDsi: FloatInput """JRN Update Date and Time""" transcodeDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" transcodeDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" transcodeDetailsOrganizationid: FloatInput """Property""" transcodeDetailsResort: StringInput """Transcodeid""" transcodeDetailsTranscodeid: StringInput """Trx Code""" transcodeDetailsTrxCode: StringInput """Bill Generation Date""" folioDetailsBillGenerationDate: DateInput """Bill Number""" folioDetailsBillNo: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" folioDetailsDsi: FloatInput """Folio Number""" folioDetailsFolioNo: FloatInput """Unique number to identify the entry.""" folioDetailsFolioSeqNo: FloatInput """Identify the FOLIO TYPE.""" folioDetailsFltType: StringInput """Folio View""" folioDetailsFolioView: FloatInput """Date when folio is created""" folioDetailsFoDate: DateInput """JRN Update Date and Time""" folioDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" folioDetailsLocationid: StringInput """Name ID""" folioDetailsNameId: FloatInput """Internal ID to uniquely identify the Organization""" folioDetailsOrganizationid: FloatInput """Postit Number""" folioDetailsPostitNo: FloatInput """Code to uniquely identify the Property""" folioDetailsResort: StringInput """Resv Name ID""" folioDetailsResvNameId: FloatInput """Date on which the folio is created or date of the checkout.""" folioDetailsTimestamp: DateInput """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 """Account Code""" accountDetailsAccountCode: FloatInput """Account Number""" accountDetailsAccountNo: StringInput """Name on the account in upper case.""" accountDetailsAccountSname: StringInput """Account Type Flag""" accountDetailsAccTypeFlag: StringInput """Account Type ID""" accountDetailsAccountTypeId: FloatInput """Accountid""" accountDetailsAccountid: FloatInput """Address ID""" accountDetailsAddressId: FloatInput """Begin Date""" accountDetailsBeginDate: DateInput """Central Exchange Date""" accountDetailsCXchangeDate: DateInput """DSI Internal Data Source ID to identify Opera Chain and instance""" accountDetailsDsi: FloatInput """Email ID""" accountDetailsEmailId: FloatInput """End Date""" accountDetailsEndDate: DateInput """Fax ID""" accountDetailsFaxId: FloatInput """Accounttypeid""" accountDetailsAccounttypeid: FloatInput """JRN Update Date and Time""" accountDetailsJrnupdatedttm: DateTimeInput """Date of Last Activity on the AR Account in regards to: transfers between accounts payments applied (not unallocated) un-applied reversed and invoice compressions un-compressions on the account.""" accountDetailsLastActivityDate: DateTimeInput """Internal ID to uniquely identify the Property""" accountDetailsLocationid: StringInput """Name ID""" accountDetailsNameId: FloatInput """Internal ID to uniquely identify the Organization""" accountDetailsOrganizationid: FloatInput """Phone ID""" accountDetailsPhoneId: FloatInput """Profileid""" accountDetailsProfileid: FloatInput """Code to uniquely identify the Property""" accountDetailsResort: StringInput """Upper Case Name""" accountDetailsUpperCaseName: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" calendarperioddayDetailsDsi: FloatInput """End Date""" calendarperioddayDetailsEndDate: DateInput """JRN Update Date and Time""" calendarperioddayDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" calendarperioddayDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" calendarperioddayDetailsOrganizationid: FloatInput """Period Code""" calendarperioddayDetailsCode: StringInput """Indicates Scope of the period. Eg. QUARTER - MONTH -WEEK. Used primarily in OBI.""" calendarperioddayDetailsPeriodScope: StringInput """Period Type Description""" calendarperioddayDetailsPeriodTypeDesc: StringInput """Code to uniquely identify the Property""" calendarperioddayDetailsResort: StringInput """Start Date""" calendarperioddayDetailsStartDate: DateInput """Year ID""" calendarperioddayDetailsYearId: FloatInput """Yearsetupid""" calendarperioddayDetailsYearsetupid: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" financialperioddayDetailsDsi: FloatInput """End Date""" financialperioddayDetailsEndDate: DateInput """JRN Update Date and Time""" financialperioddayDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" financialperioddayDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" financialperioddayDetailsOrganizationid: FloatInput """Period Code""" financialperioddayDetailsCode: StringInput """Indicates Scope of the period. Eg. QUARTER - MONTH -WEEK. Used primarily in OBI.""" financialperioddayDetailsPeriodScope: StringInput """Period Type""" financialperioddayDetailsPeriodType: StringInput """Periodsetupid""" financialperioddayDetailsPeriodsetupid: FloatInput """Code to uniquely identify the Property""" financialperioddayDetailsResort: StringInput """Start Date""" financialperioddayDetailsStartDate: DateInput """Year ID""" financialperioddayDetailsYearId: FloatInput """AR Led Debit""" arledgerDetailsArLedDebit: FloatInput """AR Number""" arledgerDetailsArNumber: FloatInput """AR State""" arledgerDetailsArState: StringInput """Authorizer ID""" arledgerDetailsAuthorizerId: FloatInput """Bill Number""" arledgerDetailsBillNo: FloatInput """Bonus Check ID""" arledgerDetailsBonusCheckId: FloatInput """Business Date""" arledgerDetailsBusinessDate: DateInput """Central Xchange Date""" arledgerDetailsCXchangeDate: DateInput """Cashier ID""" arledgerDetailsCashierId: FloatInput """Cheque Number""" arledgerDetailsChequeNumber: StringInput """Closure Number""" arledgerDetailsClosureNo: FloatInput """Trx code of original transaction that was turned into a comp""" arledgerDetailsCompLinkTrxCode: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" arledgerDetailsDsi: FloatInput """Exchange difference posting transaction number of the posting that generated the exchange difference.""" arledgerDetailsExchDiffTrxNo: FloatInput """Number to identify the DML sequence.""" arledgerDetailsFinDmlSeqNo: FloatInput """Fintransid""" arledgerDetailsFintransid: FloatInput """Folio Number""" arledgerDetailsFolioNo: FloatInput """Folio View""" arledgerDetailsFolioView: FloatInput """From Resv ID""" arledgerDetailsFromResvId: FloatInput """Guest Account Credit""" arledgerDetailsGuestAccountCredit: FloatInput """Debit amount on the guest account""" arledgerDetailsGuestAccountDebit: FloatInput """Specifies the Hotel acct against which this transaction has beenposted.""" arledgerDetailsHotelAcct: StringInput """Insert Date""" arledgerDetailsInsertDate: DateTimeInput """Cashierid""" arledgerDetailsCashierid: FloatInput """Invoice Close Date""" arledgerDetailsInvoiceCloseDate: DateInput """JRN Update Date and Time""" arledgerDetailsJrnupdatedttm: DateTimeInput """Link Transaction No""" arledgerDetailsLinkTrxNo: FloatInput """Internal ID to uniquely identify the Property""" arledgerDetailsLocationid: StringInput """Name ID""" arledgerDetailsNameId: FloatInput """Internal ID to uniquely identify the Organization""" arledgerDetailsOrganizationid: FloatInput """Original Resv Name ID""" arledgerDetailsOriginalResvNameId: FloatInput """Original Room""" arledgerDetailsOriginalRoom: StringInput """Postit Number""" arledgerDetailsPostitNo: FloatInput """Product""" arledgerDetailsProduct: StringInput """Code to uniquely identify the Property""" arledgerDetailsResort: StringInput """Rate Code""" arledgerDetailsRateCode: StringInput """Indicates the receipt type. Different receipts are identified by different types""" arledgerDetailsRecptType: StringInput """Resv Name ID""" arledgerDetailsResvNameId: FloatInput """Room""" arledgerDetailsRoom: StringInput """TRX_NO of the transaction associated with this rounding factor posting.""" arledgerDetailsRoundLinkTrxno: FloatInput """Tax Elements""" arledgerDetailsTaxElements: StringInput """Transaction Code Group""" arledgerDetailsTcGroup: StringInput """Transaction Code Subgroup""" arledgerDetailsTcSubgroup: StringInput """Tran Action ID""" arledgerDetailsTranActionId: FloatInput """Transaction Date""" arledgerDetailsTrxDate: DateInput """Transaction Number""" arledgerDetailsTrxNo: FloatInput """Transaction Code""" arledgerDetailsTrxCode: StringInput """Transaction No Added By""" arledgerDetailsTrxNoAddedBy: FloatInput """The trx_no against which this transaction gets adjusted.""" arledgerDetailsTrxNoAdjust: FloatInput """Transaction No Against Package""" arledgerDetailsTrxNoAgainstPackage: FloatInput """Transaction No Header""" arledgerDetailsTrxNoHeader: FloatInput """AR Transfer Date""" invoiceheaderDetailsArTransferDate: DateInput """Account Code""" invoiceheaderDetailsAccountCode: FloatInput """Accountid""" invoiceheaderDetailsAccountid: FloatInput """Addressee Name ID""" invoiceheaderDetailsAddresseeNameId: FloatInput """Central Xchange Date""" invoiceheaderDetailsCXchangeDate: DateInput """DSI Internal Data Source ID to identify Opera Chain and instance""" invoiceheaderDetailsDsi: FloatInput """Fintransid""" invoiceheaderDetailsFintransid: FloatInput """Folio Number""" invoiceheaderDetailsFolioNo: FloatInput """Folioid""" invoiceheaderDetailsFolioid: FloatInput """Invoice Number""" invoiceheaderDetailsInvoiceNo: FloatInput """Status of the invoice (H)old (O)pen or (C)losed.""" invoiceheaderDetailsInvStatus: StringInput """JRN Update Date and Time""" invoiceheaderDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" invoiceheaderDetailsLocationid: StringInput """Compressed Invoice No for which multiple invoices have been compressed to.""" invoiceheaderDetailsMasterInvoiceNo: FloatInput """Name ID""" invoiceheaderDetailsNameId: FloatInput """Internal ID to uniquely identify the Organization""" invoiceheaderDetailsOrganizationid: FloatInput """Post Date""" invoiceheaderDetailsBusinessDate: DateInput """Code to uniquely identify the Property""" invoiceheaderDetailsResort: StringInput """Indicator whether to purge the Account.""" invoiceheaderDetailsPurgeYn: StringInput """Resv Name ID""" invoiceheaderDetailsResvNameId: FloatInput """Transaction Date""" invoiceheaderDetailsTrxDate: DateInput """Transcodeid""" invoiceheaderDetailsTranscodeid: StringInput """Transaction Code""" invoiceheaderDetailsTrxCode: StringInput """Transaction No""" invoiceheaderDetailsTrxNo: 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 } type Query { """Detailed information on accounts receivable transactions including aging bucket of invoices open transaction amounts folio information and the account details.""" aRAgingReport(limit: Int offset: Int input: ARAgingReportQueryArgumentsType!): [ARAgingReportType] } type ARAgingReportType { """AR Aging Report""" aRAgingReportDetails: ARAgingReportARAgingReportDetailsType """Transaction Code""" transactionCodeDetails: ARAgingReportTransactionCodeDetailsType """Folio Details""" folioDetails: ARAgingReportFolioDetailsType """Financial Transaction""" financialTransactionDetails: ARAgingReportFinancialTransactionDetailsType """Account Details""" accountDetails: ARAgingReportAccountDetailsType """Calendar Period Daily Details""" calendarPeriodDayDetails: ARAgingReportCalendarPeriodDayDetailsType """Financial Period Daily Details""" financialPeriodDayDetails: ARAgingReportFinancialPeriodDayDetailsType """AR Ledger""" aRLedgerDetails: ARAgingReportARLedgerDetailsType """Invoice Header Details""" invoiceHeaderDetails: ARAgingReportInvoiceHeaderDetailsType """Resort Details""" propertyPropertyDetails: ARAgingReportPropertyPropertyDetailsType aRAgingReportRecordCount: Int } type ARAgingReportARAgingReportDetailsType { """AR Ledger Debit""" aRLedgerDebit: Float """Account Code""" accountCode: Float """Account Name""" accountName: String """NOT IN USE""" accountNumber: String """Account Type""" accountType: String """Accountid""" accountid: Float """Age 1""" age1: Float """Age 2""" age2: Float """Age 3""" age3: Float """Age 4""" age4: Float """Age 5""" age5: Float """Age 6""" age6: Float """Agingbucket""" agingbucket: Float """AR Transfer Date""" arTransferDate: Date """Bill Number""" billNumber: Float """Contact information.""" billingContactName: String """Business Date""" businessDate: Date """Central Ar Led Credit""" cARLedgerCredit: Float """Central Ar Led Debit""" cARLedgerDebit: Float """Central Amount""" cAmount: Float """Central Contract Curr Diff""" cContractCurrencyDifference: Float """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Org Amt""" cOrganizationAmount: Float """Central Org Amt Contract""" cOrganizationAmountContract: Float """Central Org Amt Curr Diff""" cOrganizationAmountCurrencyDifference: Float """Central Org Amt Parallel""" cOrganizationAmountParallel: Float """Central Parallel Curr Diff""" cParallelCurrencyDifference: Float """Central Account Type""" centralAccountType: String """Central Open AR Transaction Amount""" centralOpenARTransactionAmount: Float """Date on which the guest was checked out.""" checkOutDate: Date """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Date the aging should begin""" dateForAging: String """Fintransid""" fintransid: Float """Folio Number""" folioNo: Float """Folioid""" folioid: Float """Checkout Date""" internalCheckoutDate: Date """Invoice Age""" invoiceAge: Float """Invoice Close Date""" invoiceCloseDate: Date """Invoice Number""" invoiceNo: Float """Invoice Number""" invoiceNumber: Float """Invoice Status""" invoiceStatus: String """Invoiceamount""" invoiceamount: Float """Invoiceid""" invoiceid: Float """Invoiceprofileid""" invoiceprofileid: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Compressed Invoice No for which multiple invoices have been compressed to.""" masterInvoiceNo: Float """Name ID""" nameId: Float """Open AR Transaction Amount""" openARTransactionAmount: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """The owner room where this invoice/payment belongs to.""" ownerRoom: String """Ownerroomid""" ownerroomid: String """Pms Business Date""" pmsBusinessDate: Date """Date + time the phone charge was posted.""" postDate: Date """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 """Resv Name ID""" reservationNameId: Float """Reservationid""" reservationid: Float """Room""" room: String """Roomid""" roomid: String """Trns From Account""" transactionFromAcct: Float """Trns To Account""" transactionToAcct: Float """Transactionid""" transactionid: Float """Transcodeid""" transcodeid: String """Transferfromaccountid""" transferfromaccountid: Float """Transfertoaccountid""" transfertoaccountid: Float """Transaction Code""" trxCode: String """Transaction Date""" trxDate: Date """Transaction No""" trxNumber: Float } type ARAgingReportTransactionCodeDetailsType { """AR Ledger Payments YN""" aRLedgerPaymentsYN: String """Ar Name ID""" aRNameId: Float """Account Number""" accountNumber: String """Accounting Code""" accountingCode: String """Acctrecvprofileid""" acctrecvprofileid: Float """Adj Trx Code""" adjTrxCode: String """Adjtranscodeid""" adjtranscodeid: String """Arrange Code""" arrangeCode: String """Arrangement Code""" arrangementCode: String """Central Default Price""" cDefaultPrice: Float """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Export Bucket""" cExportBucket: Float """Central Max Amt""" cMaxAmount: Float """Central Min Amt""" cMinimumAmount: Float """CC Code""" cCCode: String """Crs Tax Description""" cRSTaxDesc: String """Cash Transaction Code YN""" cashTransactionCodeYN: String """Cc Type""" ccType: String """Cental Subgroup""" centalSubgroup: String """Central Adjustment Transaction Code""" centralAdjustmentTransactionCode: String """Central Transaction Code""" centralTransactionCode: String """Central Transaction Code Group""" centralTransactionCodeGroup: String """Charge Deferred Until Checkout YN""" chargeDeferredUntilCheckoutYN: String """Check Number Mandatory YN""" checkNumberMandatoryYN: String """Class 1 Mandatory Y/N""" class1MandatoryYn: String """Class 2 Mandatory Y/N""" class2MandatoryYn: String """Commission Code""" commissionCode: Float """Comp Nights Y/N""" compNightsYn: String """Comp Payment Y/N""" compPaymentYn: String """Complimentary YN""" complimentaryYN: String """Corp Prop Flag""" corpPropFlag: String """Corporate Description""" corporateDescription: String """To indicate that the transaction code can be used as a Deposit Transaction Code in Cross Postings. There can be only one transaction code per one resort.""" crossPostingDepositYN: String """To indicate that the transaction code can be used as a Payment Transaction Code in Cross Postings. There can be only one transaction code per one resort.""" crossPostingPaymentYN: String """To indicate that the transaction code can be used as a Sales Transaction Code in Cross Postings. There can be only one transaction code per one resort.""" crossPostingSalesYN: String """Currency Code""" currencyCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Daily Plan Folio""" dailyPlanFolio: Float """Ded Owner Rev Y/N""" dedOwnerRevenueYN: String """Default Price""" defaultPrice: Float """Deleted Flag""" deletedFlag: String """Deposit Ledger Payments YN""" depositLedgerPaymentsYN: String """Deposit Posting Only Y/N""" depositPostingOnlyYn: String """Stores the type of the deposit: possible values "RECEIPT" or "FOLIO".""" depositType: String """E Invoice Y/N""" eInvoiceYn: String """Expense Folio""" expenseFolio: Float """Export Bucket""" exportBucket: Float """External Payment Code""" externalPaymentCode: String """Fiscal Payment Y/N""" fiscalPaymentYn: String """Fiscal Transaction Code Type""" fiscalTrxCodeType: String """Foreign Currency ID""" foreignCurrencyID: String """Group Deleted Flag""" gDeletedFlag: String """Group Description""" gDescription: String """Group Insert Date""" gInsertDate: DateTime """Group Insert User""" gInsertUser: Float """Group Order By""" gOrderBy: Float """Group Rep Description""" gRepDescription: String """Group Result Included In Sum Array""" gResultIncludedInSumArray: String """Group Revenuegroupflag""" gRevenuegroupflag: String """Group Tct Class Type1""" gTctClassType1: String """Group Tct Class Type2""" gTctClassType2: String """Group Update Date""" gUpdateDate: DateTime """Group Update User""" gUpdateUser: Float """Group""" group: String """G Class 1 Mandatory Y/N""" groupClass1MandatoryYN: String """G Class 2 Mandatory Y/N""" groupClass2MandatoryYN: String """Group Folio""" groupFolio: Float """G Individual Revenue Gp""" groupIndRevenueGroup: String """G Internal Y/N""" groupInternalYN: String """Gp Points Redemption Y/N""" groupPointsRedemptionYN: String """G Reporting Item""" groupRepItem: String """G Reporting Item Name""" groupRepItemName: String """G Reporting Item Orderby""" groupRepItemOrderby: Float """G Reporting Order By""" groupRepOrderBy: Float """G Reporting Updatedate""" groupRepUpdateDate: DateTime """G Transaction Code Transaction Type""" groupTcTransactionType: String """Guest Ledger Payments YN""" guestLedgerPaymentsYN: String """Inactive Date""" inactiveDate: Date """Inactive Flag""" inactiveflag: String """Include In 8300 Y/N""" includeIn8300Yn: String """Include In Deposit Rule Y/N""" includeInDepositRuleYn: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Deleted Flag""" internalDeletedflag: String """Transaction Code Sub-Group""" internalTransactionCodeSubGroup: String """Internal Y/N""" internalYn: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Manual Post Covers Y/N""" manualPostCoversYn: String """Manual Posting Allowed YN""" manualPostingAllowedYN: String """Maximum Amount""" maximumAmount: Float """Membership YN""" membershipYN: String """Minimum Amount""" minimumAmount: Float """Non Taxable Y/N""" nonTaxableYn: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Owner Rev Y/N""" ownerRevenueYN: String """Payment Tax Invoice Y/N""" paymentTaxInvoiceYn: String """Payment Type""" paymentType: String """Paymentmethodid""" paymentmethodid: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Flag to indicate if a receipt has to be printed on posting the transaction used in Opera 9.""" printReceiptYN: String """Type of process that generated this payment. IE PaymentCheck out AR or Passerby.""" processingType: String """Property""" property: String """Quantity Code""" quantityCode: String """Rep Description""" repDescription: String """Reporting Item""" repItem: String """Reporting Item Name""" repItemName: String """Reporting Item Orderby""" repItemOrderby: Float """Reporting Updatedate""" repUpdateDate: DateTime """Result Included In Sum Array""" resultIncludedInSumArray: String """Rev Bucket ID""" revenueBucketId: Float """Rev Gp ID""" revenueGroupId: Float """Revenue YN""" revenueYN: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Rotation Rev Y/N""" rotationRevenueYN: String """Round Factor Y/N""" roundFactorYn: String """Service Recovery Adjustment.""" serviceRecoveryTrxCode: String """Sub-Group Deleted Flag""" sgDeletedFlag: String """Sub-Group Description""" sgDescription: String """Sub-Group Insert Date""" sgInsertDate: DateTime """Sub-Group Insert User""" sgInsertUser: Float """Sub-Group Order By""" sgOrderBy: Float """Sub-Group Result Included In Sum Array""" sgResultIncludedInSumArray: String """Sub-Group Revenuegroupflag""" sgRevenuegroupflag: String """Sub-Group Taxflag""" sgTaxflag: String """Sub-Group Update Date""" sgUpdateDate: DateTime """Sub-Group Update User""" sgUpdateUser: Float """Sg Class 1 Mandatory Y/N""" subGroupClass1MandatoryYN: String """Sg Class 2 Mandatory Y/N""" subGroupClass2MandatoryYN: String """Sg Frequent Flyer Y/N""" subGroupFrequentFlyerYN: String """Sg Gp Points Redemption Y/N""" subGroupGroupPointsRedemptionYN: String """Sg Individual Revenue Gp""" subGroupIndRevenueGroup: String """Sg Internal Y/N""" subGroupInternalYN: String """Sg Reporting Description""" subGroupRepDescription: String """Sg Reporting Order By""" subGroupRepOrderBy: Float """Sg Transaction Code Group And Subgroup""" subGroupTcGroupAndSubgroup: String """Sg Transaction Code Transaction Type""" subGroupTcTransactionType: String """Sub-Group Type""" subGroupType: String """Tax Code Number""" taxCodeNumber: Float """Tax Inclusive YN""" taxInclusiveYN: String """Tax YN""" taxYN: String """Not Used.""" tcBofInterface: String """Not Used.""" tcBofInterface2: String """Not Used.""" tcBofRefCode: String """Not Used.""" tcBofRefCode2: String """Not Used.""" tcResort2: String """Transaction Code Transaction Type""" tcTransactionType: String """Tcl Code Dflt Cl1""" tclCodeDfltCl1: String """Tcl Code Dflt Cl2""" tclCodeDfltCl2: String """Trx Action ID""" transactionActionId: Float """Transaction Code Description""" transactionCodeDescription: String """Transaction Code Group""" transactionCodeGroup: String """Not Used.""" transactionCodeResort: String """Transaction Code Sub-group""" transactionCodeSubGroup: String """Transaction Code Type""" transactionCodeType: String """Transaction Type""" transactionType: String """Transcodearrangementid""" transcodearrangementid: String """Transcodeid""" transcodeid: String """Trx Code""" trxCode: String """Transaction Code Display""" trxCodeDisplay: String """Transaction Service Type""" trxServiceType: String """Transaction Tax Type Code""" trxTaxTypeCode: String """UPC""" uPC: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ARAgingReportFolioDetailsType { """Bill Generation Date""" billGenerationDate: Date """Bill Number""" billNumber: Float """Businessdate""" businessdate: Date """Cashier ID""" cashierId: Float """Check Exchange Receipt Number""" checkExchangeReceiptNumber: Float """Internal number to represent the currency exchange receipt number.""" currencyExchangeReceiptNumber: Float """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Folio Number""" folioNo: Float """Unique number to identify the entry.""" folioSeqNumber: Float """The status to identify whether a guest is getting checked out.""" folioStatus: String """Folio Style""" folioStyle: String """Identify the FOLIO TYPE.""" folioType: String """Folio View""" folioView: Float """Folioid""" folioid: Float """Date when folio is created""" frontOfficeDate: Date """Full Folio Number""" fullFolioNo: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Update Date""" internalUpdatedate: DateTime """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Name""" name: String """Name ID""" nameId: Float """Number Reprints.""" numberReprints: Float """No of persons currently using the account""" numberOfPersons: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Phone Details""" phoneDetails: String """Postit Number""" postitNo: Float """Postityn""" postityn: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Identifying the process""" processIdent: String """Profileid""" profileid: Float """Code to uniquely identify the Property""" property: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Resv Name ID""" reservationNameId: Float """Reservationid""" reservationid: Float """Resvdeptrno""" resvdeptrno: Float """Resvenddate""" resvenddate: Date """Revision Number""" revisionNumber: Float """State""" state: String """Template path for report defination""" templatePath: String """Date on which the folio is created or date of the checkout.""" timestamp: Date """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ARAgingReportFinancialTransactionDetailsType { """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 ARAgingReportAccountDetailsType { """Account Code""" accountCode: Float """Indicates if a Credit Limit amount will be required "Y" will take precedence over the credit limit amount on Profile level.""" accountCreditLimitYn: String """Account Name""" accountName: String """Account Number""" accountNumber: String """Name on the account in upper case.""" accountSname: String """Status of an account. (Normal Restricted)""" accountStatus: String """Message prompt when the AR Account is defined as restricted.""" accountStatusMsg: String """Account Type""" accountType: String """Account Type Flag""" accountTypeFlag: String """Account Type ID""" accountTypeId: Float """Accountid""" accountid: Float """Acctflagreasonid""" acctflagreasonid: String """Active YN""" activeYN: String """Address ID""" addressId: Float """Address1""" address1: String """Address2""" address2: String """Address3""" address3: String """Age.""" age: Float """Agent""" agent: String """Application User ID of the Account Controller/Agent""" agentUserId: Float """Agentemployeeid""" agentemployeeid: Float """Balance on the account.""" balance: Float """Include the account in batch statement""" batchStmtYn: String """Begin Date""" beginDate: Date """Central Account Type""" centralAccountType: String """Central Balance""" centralBalance: Float """Central Credit Limit""" centralCreditLimit: Float """Central Flagged Reason Code""" centralFlaggedReasonCode: String """Central State""" centralState: String """Central Exchange Date""" centralXchangeDate: Date """Central Exchange Rate""" centralXchangeRate: Float """City""" city: String """Company""" company: String """Contact information.""" contact: String """Country""" country: String """Country Code""" countryCode: String """Country Name""" countryName: String """Credit Limit""" creditLimit: Float """Date when the Credit Limit was updated.""" creditLimitUpdatedOn: DateTime """Summary Currency Code""" currencyCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Debtor Name""" debtorName: String """Deleted Flag""" deletedflag: String """Email""" email: String """Email Addr""" emailAddr: String """Email ID""" emailId: Float """Indicates if the email address can be used to send Statements and Reminders by default.""" emailOptInYn: String """End Date""" endDate: Date """Fax""" fax: String """Fax ID""" faxId: Float """Fax Number""" faxNumber: String """The flagged reason code from table AR$_FLAGGED_REASONS.""" flaggedReasonCode: String """Inactive Date""" inactiveDate: DateTime """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Accounttypeid""" internalAccounttypeid: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Date of Last Activity on the AR Account in regards to: transfers between accounts payments applied (not unallocated) un-applied reversed and invoice compressions un-compressions on the account.""" lastActivityDate: DateTime """Fax number to which the last reminder letter was sent.""" lastRemFaxNo: String """Fax number to which the last statement was sent.""" lastStmtFaxNo: String """Internal ID to uniquely identify the Property""" locationID: String """Date on which the last reminder letter was printed.""" lstRemPrtDate: Date """Date on which the last reminder letter was sent.""" lstRemSent: Date """Name of the reminder letter""" lstRemText: String """Stores the statement number of the last statement sent for a particular AR account.""" lstStmtNoSent: Float """Date of Last reminderletter sent""" lstStmtSent: DateTime """If Y the Payment due date calculation begins from the last day of the month of invoice generation date if N then calculation starts from the day of the invoice generation.""" monthEndCalcYn: String """NA Address 1""" nAAddress1: String """NA Address 2""" nAAddress2: String """NA Address 3""" nAAddress3: String """Na City""" naCity: String """Na Country Name""" naCountryName: String """Na State""" naState: String """Na State Description""" naStateDescription: String """Name ID""" nameId: Float """No of persons currently using the account""" numberOfPersons: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Number of days a payment is due for the account.""" paymentDueDays: Float """Status indicator to show the account as a permanent account. User will not be able to delete the account if it is Y""" permAccountYN: String """Phone""" phone: String """Phone ID""" phoneId: Float """Phone Number""" phoneNumber: String """Postal Code""" postalCode: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Primary Y/N""" primaryYn: String """Profileid""" profileid: Float """Code to uniquely identify the Property""" property: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Reporting State Description""" repStateDescription: String """Revenue Pool""" revenuePool: String """State""" state: String """State Description""" stateDescription: String """Status""" status: String """Summaryforeigncurrid""" summaryforeigncurrid: String """Super Search Index Text""" superSearchIndexText: String """Supplement""" supplement: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float """Upper Case Name""" upperCaseName: String """Zip code.""" zip: String } type ARAgingReportCalendarPeriodDayDetailsType { """Chain Code""" chainCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Day Key""" dayKey: Date """Deleted Flag""" deletedFlag: String """End Date""" endDate: Date """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 """Indicates the Parent Period of the current period scope. Used primarily in OBI. Eg. YEAR - QUARTER - MONTH -WEEK""" parentPeriod: String """Parentperiodid""" parentperiodid: String """Period Code""" periodCode: String """Period Description""" periodDescription: String """Indicates Scope of the period. Eg. QUARTER - MONTH -WEEK. Used primarily in OBI.""" periodScope: String """Period Type""" periodType: String """Period Type Description""" periodTypeDesc: String """Periodsetupid""" periodsetupid: Float """Periodsetuppmsref""" periodsetuppmsref: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Code to uniquely identify the Property""" property: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Start Date""" startDate: Date """Update Date""" updateDate: DateTime """Update User""" updateUser: Float """Year""" year: Float """Year Description""" yearDescription: String """Year End Date.""" yearEndDate: Date """Year ID""" yearId: Float """Year Start Date.""" yearStartDate: Date """Year Type.""" yearType: String """Yearsetupid""" yearsetupid: Float } type ARAgingReportFinancialPeriodDayDetailsType { """Chain Code""" chainCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Day Key""" dayKey: Date """Deleted Flag""" deletedFlag: String """End Date""" endDate: Date """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 """Indicates the Parent Period of the current period scope. Used primarily in OBI. Eg. YEAR - QUARTER - MONTH -WEEK""" parentPeriod: String """Parentperiodid""" parentperiodid: String """Period Code""" periodCode: String """Period Description""" periodDescription: String """Indicates Scope of the period. Eg. QUARTER - MONTH -WEEK. Used primarily in OBI.""" periodScope: String """Period Type""" periodType: String """Period Type Description""" periodTypeDesc: String """Periodsetupid""" periodsetupid: Float """Periodsetuppmsref""" periodsetuppmsref: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Code to uniquely identify the Property""" property: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Start Date""" startDate: Date """Update Date""" updateDate: DateTime """Update User""" updateUser: Float """Year""" year: Float """Year Description""" yearDescription: String """Year End Date.""" yearEndDate: Date """Year ID""" yearId: Float """Year Start Date.""" yearStartDate: Date """Year Type.""" yearType: String """Yearsetupid""" yearsetupid: Float } type ARAgingReportARLedgerDetailsType { """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 """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""" aSBFlag: String """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 """Indicates the automatic adjustment posting for advanced generates. Possible values are ?NA? ?CO?.""" advGenerateAdjustment: String """Identifies if this Advance Bill has been reversed.""" advanceBillReversedYn: String """Identifies if this transaction was generated by Advance Bill.""" advanceBillYn: String """Transaction code of the master posting of the automatic adjustment posting for advanced generates.""" advanceGenerateTrxCode: String """The charge / generate is eligible as part of advanced generates functionality.""" advancedGenerateYn: String """Distinguish "Same day" package from a next day package by storing N/S.""" allowanceType: String """Amount""" amount: Float """Approval Code""" approvalCode: String """Approval Date""" approvalDate: Date """Approval Status""" approvalStatus: String """AR Led Credit""" arLedgerCredit: Float """AR Led Debit""" arLedgerDebit: Float """AR Number""" arNumber: Float """AR State""" arState: String """AR Transfer Date""" arTransferDate: Date """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 """Authorizer ID""" authorizerId: Float """Indicates if this column was automatically created for Automatic Credit Bills.""" autoCreditbillYn: String """Auto Settle Y/N""" autoSettleYn: String """Bill Number""" billNo: 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 Ar Led Credit""" cARLedgerCredit: Float """Central Ar Led Debit""" cARLedgerDebit: Float """Central Cashier Credit""" cCashierCredit: Float """Central Cashier Debit""" cCashierDebit: Float """Central Cashier Opening Balance""" cCashierOpeningBalance: Float """Central Cc Trx Fee Amount""" cCcTransactionFeeAmount: 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 Dep Led Credit""" cDepLedgerCredit: Float """Central Dep Led Debit""" cDepLedgerDebit: Float """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Forex Comm Amount""" cForexCommissionAmount: Float """Central Gross Amount""" cGrossAmount: Float """Central Guest Account Credit""" cGuestAccountCredit: Float """Central Guest Account Debit""" cGuestAccountDebit: Float """Central Inh Credit""" cInHouseCredit: Float """Central Inh Debit""" cInHouseDebit: Float """Central Net Amount""" cNetAmount: Float """Central Org Ar Led Debit""" cOrganizationARLedgerDebit: Float """Central Org Posted Amount""" cOrganizationPostedAmount: Float """Central Package Allowance""" cPackageAllowance: Float """Central Package Credit""" cPackageCredit: Float """Central Package Debit""" cPackageDebit: 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 Posted Amount""" cPostedAmount: Float """Central Price Per Unit""" cPricePerUnit: Float """Central Revenue Amt""" cRevenueAmount: Float """Central Tax Rate""" cTaxRate: Float """Central Trx Amount""" cTransactionAmount: Float """Indicates if points are to be calculated.""" calcPointsYn: 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 """Fee (surcharge) amount for a credit card transaction.""" ccTrxFeeAmount: Float """Central AR Ledger Amount""" centralARLedgerAmount: Float """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 """Cheque Number""" chequeNumber: String """Closure Number""" closureNo: 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 """Compressed Y/N""" compressedYn: String """Currency code for contract currency.""" contractCurrency: String """Contract equivalent to the GROSS_AMOUNT field value for the transaction number this record applies to.""" contractGrossAmount: Float """Stores the credit amount on the guest account in contract currency.""" contractGuestCredit: Float """Stores the debit amount on the guest account in contract currency.""" contractGuestDebit: Float """Contract equivalent to the NET_AMOUNT field value for the transaction number this record applies to.""" contractNetAmount: Float """Indicates if this transaction is used as part of a correction folio.""" correctionYn: String """Coupon Number""" couponNo: String """Covers""" covers: String """Currency Code""" currencyCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Indicates whether the generated tax is because of a deferred tax generation scenario""" deferredTaxesYn: String """Deferred Y/N""" deferredYn: String """Deleted Flag""" deletedFlag: String """Dep Ledger Credit""" depLedgerCredit: Float """Dep Ledger Debit""" depLedgerDebit: Float """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 Transaction ID""" depositTransactionId: String """Display Y/N""" displayYn: String """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 """The flag indicates if it is an exchange rate difference posting when dual currency is on.""" 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 """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.""" financialTransactionSubtype: String """Fintransid""" fintransid: Float """Fiscal Bill Number""" fiscalBillNo: String """Fiscal Transaction Code Type""" fiscalTrxCodeType: String """Distinguish ordinary postings from Fixed charge postings.""" fixedChargesYn: String """Folio Number""" folioNo: Float """Folio Type""" folioType: 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 """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 Credit""" guestAccountCredit: Float """Debit amount on the guest account""" guestAccountDebit: Float """Indicates transaction is on hold.""" holdYn: String """Specifies the Hotel acct against which this transaction has beenposted.""" hotelAcct: String """Identifies if this transaction has had inclusive taxes removed during comping.""" incTaxDeductedYn: String """Ind Adjustment Y/N""" individualAdjustmentYN: String """In House Credit""" inhCredit: Float """In House Debit""" inhDebit: Float """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Installments""" installments: Float """Cashierid""" internalCashierid: Float """Invoice Close Date""" invoiceCloseDate: Date """Invoice Number""" invoiceNo: 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 """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 """Number Dialed.""" numberDialed: String """Transaction Description.""" oTransactionDesc: String """Stores original bill number after void.""" orgBillNumber: Float """Stores original folio type after void.""" orgFolioType: 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 """Original Resv Name ID""" originalReservationNameId: Float """Original Room""" originalRoom: 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.""" packageCredit: Float """Debit amount on the guest package account""" packageDebit: 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 """Cuurency code for parrallel currency.""" parallelCurrency: String """Parallel Gross Amount""" parallelGrossAmount: Float """Credit amount on the guest account stored in parrallel currency.""" parallelGuestCredit: Float """Debit amount on the guest account stored in parrallel currency.""" parallelGuestDebit: Float """Parallel Net Amount""" parallelNetAmount: 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 """Posted Amount""" postedAmount: Float """Posting Date""" postingDate: Date """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 """Indicates whether this particular transaction has been included in an 8300 tax form yet.""" processed8300Yn: String """Product""" product: String """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 """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Rate Code""" rateCode: String """Reason Code""" reasonCode: String """Recpt Number""" receiptNo: Float """Indicates the receipt type. Different receipts are identified by different types""" receiptType: String """Reference""" reference: String """Stores Reservation_deposit_schedule_id from RESERVATION_DEPOSIT_SCHEDULE table to link the deposit payment to the deposit request.""" reservationDepositId: Float """Resv Name ID""" reservationNameId: Float """Reservationid""" reservationid: Float """Revenue Amount.""" revenueAmt: Float """Stores the trx_no of the reversed payment.""" reversePaymentTrxNumber: Float """Revision Number""" revisionNo: Float """Room""" room: String """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 """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 """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 """Stores the type of split performed: [A]mount [Q]uantity [P]ercent.""" splitType: String """Supplement""" supplement: String """Current transaction uses Net or Gross revenue for Travel Agent commission calculation.""" taCommissionNetYn: String """The value 'Y' indicates that the commission has been paid for the transaction.""" taCommissionableYn: String """Target Property""" targetResort: String """Tax Elements""" taxElements: String """Indicates whether tax has been generated for a particuar posting.""" taxGeneratedYn: String """Tax Inclusive Y/N""" 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 Date""" transactionDate: Date """Trns From Account""" transactionFromAcct: Float """Transaction Number""" transactionNumber: Float """Trns To Account""" transactionToAcct: Float """Transcodearrangementid""" transcodearrangementid: Float """Transcodeid""" transcodeid: String """Transaction Activity Date""" trnsActivityDate: Date """Transaction Amount""" trxAmount: Float """Transaction Code""" trxCode: String """Transaction No Added By""" trxNumberAddedBy: Float """The trx_no against which this transaction gets adjusted.""" trxNumberAdjust: Float """Transaction No Against Package""" trxNumberAgainstPackage: Float """Transaction No Header""" trxNumberHeader: Float """Stores the Trx_No of the main transaction being split.""" trxNumberSplit: Float """Transaction Service Type""" trxServiceType: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float """Flag to identify an Upsell posting.""" upsellChargeYn: String """Vat Offset Y/N""" vatOffsetYn: String } type ARAgingReportInvoiceHeaderDetailsType { """AR Debit""" aRDebit: Float """AR Ledger Credit""" aRLedgerCredit: Float """AR Transfer Date""" aRTransferDate: Date """Account Code""" accountCode: Float """Account Type Flag""" accountTypeFlag: String """Accountid""" accountid: Float """Addressee Name ID""" addresseeNameId: Float """Adjustment Y/N""" adjustmentYn: String """Adjustmentflag""" adjustmentflag: String """Aging bucket number.""" agingBucket: Float """Aging Business Date""" agingBusinessDate: Date """Amount""" amount: Float """Bill Number""" billNumber: Float """Central Ar Led Credit""" cARLedgerCredit: Float """Central Ar Led Debit""" cARLedgerDebit: Float """Central Amount""" cAmount: Float """Central Contract Curr Diff""" cContractCurrencyDifference: Float """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Org Amt""" cOrganizationAmount: Float """Central Org Amt Contract""" cOrganizationAmountContract: Float """Central Org Amt Curr Diff""" cOrganizationAmountCurrencyDifference: Float """Central Org Amt Parallel""" cOrganizationAmountParallel: Float """Central Paid""" cPaid: Float """Central Parallel Curr Diff""" cParallelCurrencyDifference: Float """Cashier ID""" cashierId: Float """Central Profile ID""" centralProfileID: String """Date on which the guest was checked out.""" checkOutDate: Date """Date of Compression.""" compressDate: Date """Compressed Y/N""" compressedYn: String """Currency difference for contract amount. Used for Dual Currency functionality.""" contractCurrDifference: Float """Currency Code of the contract currency. Used for Dual Currency functionality.""" contractCurrencyCode: String """Stores the transaction number for which this credit bill is created.""" creditedToTrxNumber: Float """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Date the aging should begin""" dateForAging: String """Deleted Flag""" deletedFlag: String """Export Invoice Type""" expInvoiceType: String """Export Original Invoice""" expOriginalInvoice: String """Receipt Date sent from external systems.""" externalReceiptDate: Date """Fintransid""" fintransid: Float """Fiscal Bill Number""" fiscalBillNo: String """Folio Number""" folioNo: Float """Folio Text 1""" folioText1: String """Folio Text 2""" folioText2: String """Folio Type""" folioType: String """Folioid""" folioid: Float """Insert Date""" insertDate: DateTime """Insert User""" insertUser: String """Invoice Age""" invoiceAge: Float """Invoice Close Date""" invoiceCloseDate: Date """Application User who closed the invoice.""" invoiceClosedBy: String """Invoice Number""" invoiceNumber: Float """Status of the invoice (H)old (O)pen or (C)losed.""" invoiceStatus: String """Invoice Type""" invoiceType: String """Invoiceid""" invoiceid: Float """Invoiceprofileid""" invoiceprofileid: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Compressed Invoice No for which multiple invoices have been compressed to.""" masterInvoiceNumber: Float """Name""" name: String """Name ID""" nameId: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Original Amount""" originalAmount: Float """Original Amount in contract currency. Used for Dual Currency functionality.""" originalAmountContractCurrency: Float """Currency difference for the original amount in local currency. Used for Dual Currency functionality.""" originalAmountCurrencyDifference: Float """Original Amount in parallel currency. Used for Dual Currency functionality.""" originalAmountDualCurrency: Float """The owner room where this invoice/payment belongs to.""" ownerRoom: String """Ownerroomid""" ownerroomid: String """Amount paid.""" paid: Float """Currency difference for parallel amount. Used for Dual Currency functionality.""" parallelCurrDifference: Float """Currency Code of the parallel currency. Used for Dual Currency functionality.""" parallelCurrencyCode: String """Payment Number used for chain specific functionality.""" paymentNo: String """Post Date""" postDate: Date """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Printed Date""" printedDate: Date """Printed Y/N""" printedYn: String """Profile ID""" profileID: String """Code to uniquely identify the Property""" property: String """Indicator whether to purge the Account.""" purgeYn: String """Reference""" reference: String """Remark""" remark: String """Reminder Cycle that was generated for this invoice""" reminderCycle: Float """Date of the reminder letter that was sent""" reminderDate: Date """Resv Name ID""" reservationNameId: Float """Reservationid""" reservationid: Float """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Room""" room: String """Roomid""" roomid: String """Statement Number""" statementNumber: Float """Tran Action ID""" tranActionId: Float """Transaction Activity Date""" transactionActivityDate: DateTime """Transaction Date""" transactionDate: Date """Trns From Account""" transactionFromAcct: Float """Trns To Account""" transactionToAcct: Float """Transcodeid""" transcodeid: String """Transferfromaccountid""" transferfromaccountid: Float """Transfertoaccountid""" transfertoaccountid: Float """Transaction Code""" trxCode: String """Transaction No""" trxNumber: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: String } type ARAgingReportPropertyPropertyDetailsType { """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 }