# title : OPERA Cloud RnA SimpleReportsFinancialTransactions GraphQL API, # description : GraphQL API to cater for The Simple Reports Financial Transactions Subject Area simplifies creating and building adhoc reports, including the ability to create new reports. # 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. # - srfinancialtransactionsDetailsResort # - srfinancialtransactionsDetailsTrxDate input SimpleReportsFinancialTransactionsQueryArgumentsType { """AR Led Credit""" srfinancialtransactionsDetailsArLedCredit: FloatInput """AR Led Debit""" srfinancialtransactionsDetailsArLedDebit: FloatInput """AR Number""" srfinancialtransactionsDetailsArNumber: FloatInput """AR State""" srfinancialtransactionsDetailsArState: StringInput """Article ID""" srfinancialtransactionsDetailsArticleId: FloatInput """Authorizer ID""" srfinancialtransactionsDetailsAuthorizerId: FloatInput """Bill Number""" srfinancialtransactionsDetailsBillNo: FloatInput """Business Date""" srfinancialtransactionsDetailsBusinessDate: DateInput """Central Xchange Date""" srfinancialtransactionsDetailsCXchangeDate: DateInput """Cashier ID""" srfinancialtransactionsDetailsCashierId: FloatInput """Cheque Number""" srfinancialtransactionsDetailsChequeNumber: StringInput """Closure Number""" srfinancialtransactionsDetailsClosureNo: FloatInput """Trx code of original transaction that was turned into a comp""" srfinancialtransactionsDetailsCompLinkTrxCode: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" srfinancialtransactionsDetailsDsi: FloatInput """Folio Number""" srfinancialtransactionsDetailsFolioNo: FloatInput """Guest Account Credit""" srfinancialtransactionsDetailsGuestAccountCredit: FloatInput """Debit amount on the guest account""" srfinancialtransactionsDetailsGuestAccountDebit: FloatInput """Insert Date""" srfinancialtransactionsDetailsInsertDate: DateTimeInput """Invoice Number""" srfinancialtransactionsDetailsInvoiceNo: FloatInput """JRN Update Date and Time""" srfinancialtransactionsDetailsJrnupdatedttm: DateTimeInput """Name ID""" srfinancialtransactionsDetailsNameId: FloatInput """Internal ID to uniquely identify the Organization""" srfinancialtransactionsDetailsOrganizationid: FloatInput """Original Resv Name ID""" srfinancialtransactionsDetailsOriginalResvNameId: FloatInput """Product""" srfinancialtransactionsDetailsProduct: StringInput """Code to uniquely identify the Property""" srfinancialtransactionsDetailsResort: StringInput! @mandatoryInput """Rate Code""" srfinancialtransactionsDetailsRateCode: StringInput """Indicates the receipt type. Different receipts are identified by different types""" srfinancialtransactionsDetailsRecptType: StringInput """Resv Name ID""" srfinancialtransactionsDetailsResvNameId: FloatInput """Room""" srfinancialtransactionsDetailsRoom: StringInput """Link the posting to the routing instruction that is specified during the setup of routing instructions for guests.""" srfinancialtransactionsDetailsRoutingInstrnId: FloatInput """Tax Elements""" srfinancialtransactionsDetailsTaxElements: StringInput """Tran Action ID""" srfinancialtransactionsDetailsTranActionId: FloatInput """Transaction Code""" srfinancialtransactionsDetailsTrxCode: StringInput """Transaction Date""" srfinancialtransactionsDetailsTrxDate: DateInput! @mandatoryInput """Transaction No""" srfinancialtransactionsDetailsTrxNo: FloatInput """Transaction No Added By""" srfinancialtransactionsDetailsTrxNoAddedBy: FloatInput """The trx_no against which this transaction gets adjusted.""" srfinancialtransactionsDetailsTrxNoAdjust: FloatInput """Transaction No Against Package""" srfinancialtransactionsDetailsTrxNoAgainstPackage: 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 { """The Simple Reports Financial Transactions Subject Area simplifies creating and building adhoc reports including the ability to create new reports""" simpleReportsFinancialTransactions(limit: Int offset: Int input: SimpleReportsFinancialTransactionsQueryArgumentsType!): [SimpleReportsFinancialTransactionsType] } type SimpleReportsFinancialTransactionsType { """Sr Financial Transactions Details""" srFinancialTransactionsDetails: SimpleReportsFinancialTransactionsSrFinancialTransactionsDetailsType """Resort Details""" propertyPropertyDetails: SimpleReportsFinancialTransactionsPropertyPropertyDetailsType simpleReportsFinancialTransactionsRecordCount: Int } type SimpleReportsFinancialTransactionsSrFinancialTransactionsDetailsType { """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 Type Flag""" accountTypeFlag: String """Accounting Code""" accountingCode: String """Actual Exchange Rate""" actualExchangeRate: Float """Actual posting date and time for Interface. Contains the interface posting date and time in hotel date/time format for Interface Postings and Oracle insert date for regular postings.""" actualPostingDateTime: Date """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 """App User""" appUser: String """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 Code""" arrangementCode: String """Arrangement ID""" arrangementId: Float """Arrangement Type""" arrangementType: String """Article Code""" articleCode: String """Article ID""" articleId: 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 Change Due""" cChangeDue: 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 Non Revenue Amount""" cNonRevenueAmount: Float """Central Org Ar Led Debit""" cOrganizationARLedgerDebit: Float """Central Org Posted Amount""" cOrganizationPostedAmount: Float """Central Package Credit""" cPackageCredit: Float """Central Package Debit""" cPackageDebit: Float """Central Parallel Guest Credit""" cParallelGuestCredit: Float """Central Parallel Guest Debit""" cParallelGuestDebit: 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 """Cashier Credit""" cashierCredit: Float """Cashier Debit""" cashierDebit: Float """Cashier ID""" cashierId: Float """Cashier Name""" cashierName: String """Cc Code""" ccCode: String """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 """Cc Type""" ccType: String """Change Due""" changeDue: Float """Cheque Number""" chequeNumber: String """Closure Number""" closureNo: Float """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 Y/N""" compYn: String """Compressed Y/N""" compressedYn: String """Indicates if this transaction is used as part of a correction folio.""" correctionYn: String """Covers""" covers: String """Credit Card ID""" creditCardId: Float """Currency""" currency: 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 """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 """Future use""" depositLedgerTrxCode: String """Deposit Tax Transaction Code""" depositTaxTrxCode: String """Deposit Transaction ID""" depositTransactionId: String """Display Y/N""" displayYn: String """Stores the voucher_no from VOUCHERS_DETAILS to keep track of voucher amount consumed.""" electronicVoucherNo: Float """Euro Exchange Rate""" euroExchangeRate: Float """The flag indicates if it is an exchange rate difference posting when dual currency is on.""" exchangeDifferenceYn: String """Exchange Rate""" exchangeRate: Float """Flexible Benefit Award certificate number.""" fbaCertificateNumber: String """Number to identify the DML sequence.""" financialDmlSeqNumber: Float """Fiscal Bill Number""" fiscalBillNo: String """Distinguish ordinary postings from Fixed charge postings.""" fixedChargesYn: String """Folio Number""" folioNo: Float """Folio Type""" folioType: String """Folio View""" folioView: Float """Foreign Exchange commission amount.""" forexCommAmount: Float """Foreign Exchange commission percentage.""" forexCommPerc: Float """Type of Foreign Currency Exchange. B=Buy S=Sell.""" forexType: String """From Resv ID""" fromReservationId: 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.""" ftSubtype: String """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 """Guest Account Credit""" guestAccountCredit: Float """Debit amount on the guest account""" guestAccountDebit: Float """Identifies if this transaction has had inclusive taxes removed during comping.""" incTaxDeductedYn: String """Individual Cash""" indCash: 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 """Internal DB settlement Amount for Invoices Created in A/R excluding Credit Card Compressions.""" internalDbPayments: Float """Primary Key ID""" internalPrimaryKeyIDToUniquelyIdentifyTheRow: Float """Internal Y/N""" internalYn: String """Invoice Close Date""" invoiceCloseDate: Date """Invoice Number""" invoiceNo: Float """Invoice Type""" invoiceType: String """Is Credit 01""" isCredit01: Float """Is Debit 01""" isDebit01: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Link Transaction No""" linkTrxNumber: Float """Market Code""" marketCode: String """Membership ID""" membershipId: Float """Name ID""" nameId: Float """Name Tax Type""" nameTaxType: String """Net Amount""" netAmount: Float """Non Revenue Amount""" nonRevenueAmount: Float """Number Dialed.""" numberDialed: 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 """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 """Cuurency code for parrallel currency.""" parallelCurrency: String """Credit amount on the guest account stored in parrallel currency.""" parallelGuestCredit: Float """Debit amount on the guest account stored in parrallel currency.""" parallelGuestDebit: Float """Passerby Name""" passerbyName: String """Posted Amount""" postedAmount: Float """Posting Date""" postingDate: Date """Posting Rhythm""" postingRhythm: String """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 """Product""" product: String """Populated with [P] for package profit and [L] for package loss transactions.""" profitLossFlag: String """Code to uniquely identify the Property""" property: String """Property Bill Prefix""" propertyBillPrefix: String """Quantity""" quantity: Float """Quantity Code""" quantityCode: String """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 """Remark""" remark: String """Reporting Adv Gen Trx Code""" repAdvanceGenTransactionCode: String """Reporting Market Code""" repMarketCode: String """Reporting Product""" repProduct: String """Reporting Trx Code""" repTransactionCode: String """Reporting Tc Group""" repTransactionCodeGroup: String """Reporting Tc Subgroup""" repTransactionCodeSubgroup: String """Resv Name ID""" reservationNameId: Float """Revenue Amount.""" revenueAmt: Float """Stores the trx_no of the reversed payment.""" reversePaymentTrxNumber: Float """Revision Number""" revisionNo: Float """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Room""" room: String """Room Class""" roomClass: String """Stores the effective room nights with decimals making it significant for postings splits edits and adjustments. Required by B&B Hotels.""" roomNtsEffective: Float """Room Type""" roomType: String """Indicates if the transaction has been routed.""" routedYn: String """Link the posting to the routing instruction that is specified during the setup of routing instructions for guests.""" routingInstrnId: Float """Settlement Flag""" settlementFlag: String """Source Code""" sourceCode: String """Stores the type of split performed: [A]mount [Q]uantity [P]ercent.""" splitType: String """Identifies if the transaction is stamp duty.""" stampDutyYn: 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 Rate""" taxRate: Float """Tax Rate Type""" taxRateType: String """Tb Amount Gross""" tbAmountGross: Float """Tb Amount Net""" tbAmountNet: Float """Transaction Code Group""" tcGroup: String """Transaction Code Subgroup""" tcSubgroup: String """Transaction Code Transaction Type""" tcTransactionType: 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 """Tran Action ID""" tranActionId: Float """Transaction Description""" transactionDescription: String """Trns From Account""" transactionFromAcct: Float """Trns To Account""" transactionToAcct: Float """Transaction Activity Date""" trnsActivityDate: Date """Transaction Amount""" trxAmount: Float """Transaction Code""" trxCode: String """Transaction Code Added By""" trxCodeAddedBy: String """Transaction Code Type Added By""" trxCodeTypeAddedBy: String """Transaction Date""" trxDate: Date """Transaction No""" trxNumber: Float """Transaction No Added By""" trxNumberAddedBy: Float """The trx_no against which this transaction gets adjusted.""" trxNumberAdjust: Float """Transaction No Against Package""" trxNumberAgainstPackage: 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 """Transaction Type Sort""" trxTypeSort: Float """Tz Insert Date""" tzInsertDate: Date """Update Date""" updateDate: DateTime """Update User""" updateUser: Float """Vat Offset Y/N""" vatOffsetYn: String } type SimpleReportsFinancialTransactionsPropertyPropertyDetailsType { """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 }