# title : OPERA Cloud RnA ARAccountsReceivable GraphQL API, # description : GraphQL API to cater for Detailed Accounts Receivable data, including Adjustments, Payments, Invoices and Posting for AR Accounts, with linked reservation data. # Compatible with OPERA Cloud RnA release 26.1.0.0. # This document and all content within is available under the Universal Permissive License v 1.0 # (https://oss.oracle.com/licenses/upl). Copyright (c) 2020,2026 Oracle and/or its affiliates # version : 26.1.0.0 # termsOfService : https://www.oracle.com/legal/terms.html # contact_email : hospitality_apis_ww_grp@oracle.com # license : https://opensource.org/licenses/upl directive @stream(if: Boolean, label: String, initialCount: Int = 0) on FIELD directive @conditionalInputPair(pair: Int) on INPUT_FIELD_DEFINITION directive @mandatoryInput on INPUT_FIELD_DEFINITION scalar Date scalar DateTime # Date format: "YYYY-MM-DD" input DateInput{ _eq: Date _ne: Date _in: [Date] _nin: [Date] _gt: Date _lt: Date _gte: Date _lte: Date _btn: DateRangeInput _isNull: Boolean } input DateRangeInput { start: Date! end: Date! } # Datetime format: "YYYY-MM-DD HH24:MI:SS" input DateTimeInput { _eq: DateTime _ne: DateTime _in: [DateTime] _nin: [DateTime] _gt: DateTime _lt: DateTime _gte: DateTime _lte: DateTime _btn: DateTimeRangeInput _isNull: Boolean } input DateTimeRangeInput { start: DateTime! end: DateTime! } input StringInput { _eq: String _ne: String _in: [String] _nin: [String] _gt: String _lt: String _gte: String _lte: String _isNull: Boolean } input FloatInput { _eq: Float _ne: Float _in: [Float] _nin: [Float] _gt: Float _lt: Float _gte: Float _lte: Float _btn: FloatRangeInput _isNull: Boolean } input FloatRangeInput { start: Float! end: Float! } # Mandatory filters: # The following filters are mandatory required filters. # Please ensure the request includes all the below fields. # - accountDetailsResort input ARAccountsReceivableQueryArgumentsType { """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! @mandatoryInput """Upper Case Name""" accountDetailsUpperCaseName: StringInput """Accountid""" artranadjdetailsDetailsAccountid: FloatInput """AR Led Credit""" artranadjdetailsDetailsArLedCredit: FloatInput """AR Led Debit""" artranadjdetailsDetailsArLedDebit: FloatInput """AR State""" artranadjdetailsDetailsArState: StringInput """Authorizer ID""" artranadjdetailsDetailsAuthorizerId: FloatInput """Bill Number""" artranadjdetailsDetailsBillNo: FloatInput """Bonus Check ID""" artranadjdetailsDetailsBonusCheckId: FloatInput """Business Date""" artranadjdetailsDetailsBusinessDate: DateInput """Central Xchange Date""" artranadjdetailsDetailsCXchangeDate: DateInput """Cashier ID""" artranadjdetailsDetailsCashierId: FloatInput """Cheque Number""" artranadjdetailsDetailsChequeNumber: StringInput """Closure Number""" artranadjdetailsDetailsClosureNo: FloatInput """Trx code of original transaction that was turned into a comp""" artranadjdetailsDetailsCompLinkTrxCode: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" artranadjdetailsDetailsDsi: FloatInput """Exchange difference posting transaction number of the posting that generated the exchange difference.""" artranadjdetailsDetailsExchDiffTrxNo: FloatInput """Number to identify the DML sequence.""" artranadjdetailsDetailsFinDmlSeqNo: FloatInput """Fintransactionid""" artranadjdetailsDetailsFintransactionid: FloatInput """Fintransid""" artranadjdetailsDetailsFintransid: FloatInput """Folio Number""" artranadjdetailsDetailsFolioNo: FloatInput """Folio View""" artranadjdetailsDetailsFolioView: FloatInput """From Resv ID""" artranadjdetailsDetailsFromResvId: FloatInput """Guest Account Credit""" artranadjdetailsDetailsGuestAccountCredit: FloatInput """Debit amount on the guest account""" artranadjdetailsDetailsGuestAccountDebit: FloatInput """Specifies the Hotel acct against which this transaction has beenposted.""" artranadjdetailsDetailsHotelAcct: StringInput """Insert Date""" artranadjdetailsDetailsInsertDate: DateTimeInput """Invoice Number""" artranadjdetailsDetailsInvoiceNo: FloatInput """JRN Update Date and Time""" artranadjdetailsDetailsJrnupdatedttm: DateTimeInput """Link Transaction No""" artranadjdetailsDetailsLinkTrxNo: FloatInput """Internal ID to uniquely identify the Property""" artranadjdetailsDetailsLocationid: StringInput """Name ID""" artranadjdetailsDetailsNameId: FloatInput """Internal ID to uniquely identify the Organization""" artranadjdetailsDetailsOrganizationid: FloatInput """Original Resv Name ID""" artranadjdetailsDetailsOriginalResvNameId: FloatInput """Original Room""" artranadjdetailsDetailsOriginalRoom: StringInput """Postit Number""" artranadjdetailsDetailsPostitNo: FloatInput """Product""" artranadjdetailsDetailsProduct: StringInput """Profileid""" artranadjdetailsDetailsProfileid: FloatInput """Code to uniquely identify the Property""" artranadjdetailsDetailsResort: StringInput """Rate Code""" artranadjdetailsDetailsRateCode: StringInput """Indicates the receipt type. Different receipts are identified by different types""" artranadjdetailsDetailsRecptType: StringInput """Resv Name ID""" artranadjdetailsDetailsResvNameId: FloatInput """Room""" artranadjdetailsDetailsRoom: StringInput """TRX_NO of the transaction associated with this rounding factor posting.""" artranadjdetailsDetailsRoundLinkTrxno: FloatInput """Link the posting to the routing instruction that is specified during the setup of routing instructions for guests.""" artranadjdetailsDetailsRoutingInstrnId: FloatInput """Tax Elements""" artranadjdetailsDetailsTaxElements: StringInput """Transaction Code Group""" artranadjdetailsDetailsTcGroup: StringInput """Transaction Code Subgroup""" artranadjdetailsDetailsTcSubgroup: StringInput """Tran Action ID""" artranadjdetailsDetailsTranActionId: FloatInput """Transaction Date""" artranadjdetailsDetailsTrxDate: DateInput """Transaction Number""" artranadjdetailsDetailsTrxNo: FloatInput """Transaction Number to Deposit Posting""" artranadjdetailsDetailsTrxNoHeader: FloatInput """Transcodeid""" artranadjdetailsDetailsTranscodeid: StringInput """Transaction Code""" artranadjdetailsDetailsTrxCode: StringInput """Transaction No Added By""" artranadjdetailsDetailsTrxNoAddedBy: FloatInput """The trx_no against which this transaction gets adjusted.""" artranadjdetailsDetailsTrxNoAdjust: FloatInput """Transaction No Against Package""" artranadjdetailsDetailsTrxNoAgainstPackage: 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 """Accountid""" arpostdetailsDetailsAccountid: FloatInput """AR Number""" arpostdetailsDetailsArNumber: FloatInput """Article ID""" arpostdetailsDetailsArticleId: FloatInput """Authorizer ID""" arpostdetailsDetailsAuthorizerId: FloatInput """Bill Number""" arpostdetailsDetailsBillNo: FloatInput """Bonus Check ID""" arpostdetailsDetailsBonusCheckId: FloatInput """Business Date""" arpostdetailsDetailsBusinessDate: DateInput """Central Xchange Date""" arpostdetailsDetailsCXchangeDate: DateInput """Cashier ID""" arpostdetailsDetailsCashierId: FloatInput """Cheque Number""" arpostdetailsDetailsChequeNumber: StringInput """Closure Number""" arpostdetailsDetailsClosureNo: FloatInput """Trx code of original transaction that was turned into a comp""" arpostdetailsDetailsCompLinkTrxCode: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" arpostdetailsDetailsDsi: FloatInput """Exchange difference posting transaction number of the posting that generated the exchange difference.""" arpostdetailsDetailsExchDiffTrxNo: FloatInput """Number to identify the DML sequence.""" arpostdetailsDetailsFinDmlSeqNo: FloatInput """Fintransid""" arpostdetailsDetailsFintransid: FloatInput """Folio Number""" arpostdetailsDetailsFolioNo: FloatInput """Folio View""" arpostdetailsDetailsFolioView: FloatInput """Folioid""" arpostdetailsDetailsFolioid: FloatInput """From Resv ID""" arpostdetailsDetailsFromResvId: FloatInput """Guest Account Credit""" arpostdetailsDetailsGuestAccountCredit: FloatInput """Debit amount on the guest account""" arpostdetailsDetailsGuestAccountDebit: FloatInput """Specifies the Hotel acct against which this transaction has beenposted.""" arpostdetailsDetailsHotelAcct: StringInput """Insert Date""" arpostdetailsDetailsInsertDate: DateTimeInput """Invoice Number""" arpostdetailsDetailsInvoiceNo: FloatInput """Invoice Status""" arpostdetailsDetailsArState: StringInput """JRN Update Date and Time""" arpostdetailsDetailsJrnupdatedttm: DateTimeInput """Link Transaction No""" arpostdetailsDetailsLinkTrxNo: FloatInput """Internal ID to uniquely identify the Property""" arpostdetailsDetailsLocationid: StringInput """Name ID""" arpostdetailsDetailsNameId: FloatInput """Internal ID to uniquely identify the Organization""" arpostdetailsDetailsOrganizationid: FloatInput """Original Resv Name ID""" arpostdetailsDetailsOriginalResvNameId: FloatInput """Original Room""" arpostdetailsDetailsOriginalRoom: StringInput """Post Date""" arpostdetailsDetailsTrxDate: DateInput """Postit Number""" arpostdetailsDetailsPostitNo: FloatInput """Product""" arpostdetailsDetailsProduct: StringInput """Profile ID""" arpostdetailsDetailsProfileid: FloatInput """Code to uniquely identify the Property""" arpostdetailsDetailsResort: StringInput """Rate Code""" arpostdetailsDetailsRateCode: StringInput """Indicates the receipt type. Different receipts are identified by different types""" arpostdetailsDetailsRecptType: StringInput """Resv Name ID""" arpostdetailsDetailsResvNameId: FloatInput """Reservationid""" arpostdetailsDetailsReservationid: FloatInput """Room""" arpostdetailsDetailsRoom: StringInput """Roomid""" arpostdetailsDetailsRoomid: StringInput """TRX_NO of the transaction associated with this rounding factor posting.""" arpostdetailsDetailsRoundLinkTrxno: FloatInput """Link the posting to the routing instruction that is specified during the setup of routing instructions for guests.""" arpostdetailsDetailsRoutingInstrnId: FloatInput """Tax Elements""" arpostdetailsDetailsTaxElements: StringInput """Transaction Code Group""" arpostdetailsDetailsTcGroup: StringInput """Transaction Code Subgroup""" arpostdetailsDetailsTcSubgroup: StringInput """Tran Action ID""" arpostdetailsDetailsTranActionId: FloatInput """Transaction Number""" arpostdetailsDetailsTrxNo: FloatInput """Transcodeid""" arpostdetailsDetailsTranscodeid: StringInput """Transaction Code""" arpostdetailsDetailsTrxCode: StringInput """Transaction No Added By""" arpostdetailsDetailsTrxNoAddedBy: FloatInput """The trx_no against which this transaction gets adjusted.""" arpostdetailsDetailsTrxNoAdjust: FloatInput """Transaction No Against Package""" arpostdetailsDetailsTrxNoAgainstPackage: FloatInput """Transaction No Header""" arpostdetailsDetailsTrxNoHeader: FloatInput """Account Type""" accounttypeDetailsAccountType: StringInput """Central Exchange Date""" accounttypeDetailsCXchangeDate: DateInput """DSI Internal Data Source ID to identify Opera Chain and instance""" accounttypeDetailsDsi: FloatInput """JRN Update Date and Time""" accounttypeDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Organization""" accounttypeDetailsOrganizationid: FloatInput """Property""" accounttypeDetailsResort: StringInput """Acctflagreasonid""" acctflagreasonDetailsAcctflagreasonid: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" acctflagreasonDetailsDsi: FloatInput """Flagged Reason Code""" acctflagreasonDetailsReasonCode: StringInput """JRN Update Date and Time""" acctflagreasonDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" acctflagreasonDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" acctflagreasonDetailsOrganizationid: FloatInput """Property""" acctflagreasonDetailsResort: StringInput """Agent""" employeeDetailsAppUser: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" employeeDetailsDsi: FloatInput """Cashier ID for the User""" employeeDetailsDefCashierId: FloatInput """Stores resort name to which user will log in every time""" employeeDetailsDefaultResort: StringInput """Employeeid""" employeeDetailsEmployeeid: FloatInput """JRN Update Date and Time""" employeeDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" employeeDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" employeeDetailsOrganizationid: FloatInput """Foreign key to NAME table that links this USER to an Employee""" employeeDetailsPersonNameId: FloatInput """Primary Rooms Owner Code""" employeeDetailsSrepCode: StringInput """User ID""" employeeDetailsAppUserId: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" accountnoteDetailsDsi: FloatInput """JRN Update Date and Time""" accountnoteDetailsJrnupdatedttm: DateTimeInput """Note ID""" accountnoteDetailsNoteId: FloatInput """Internal ID to uniquely identify the Organization""" accountnoteDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" accountnoteDetailsResort: StringInput """The primary key for this table.""" profileallDetailsNameId: FloatInput """Profile is active or not.""" profileallDetailsActiveYn: StringInput """This is a name_id (Profile number) of profiles that exist in a Central database in a typical CRS environment.""" profileallDetailsCrsNameid: FloatInput """Chain Code""" profileallDetailsChainCode: StringInput """The unique key of this name stores IATA# Company # etc.""" profileallDetailsNameCode: StringInput """The company group or company group user ID in hierarchical format""" profileallDetailsCompanyGroupId: StringInput """Used in S&C Module.""" profileallDetailsContactFlag: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" profileallDetailsDsi: FloatInput """Direct Bill Batch Type""" profileallDetailsDirectBillBatchType: StringInput """The last name of the individual Profile and Search name ofr the other Types of Profiles (Group Travel Agent & Source) are stored in this column.""" profileallDetailsLast: StringInput """Keep guest in history Y/N""" profileallDetailsHistoryYn: StringInput """The date the record was marked as inactive""" profileallDetailsInactiveDate: DateTimeInput """Index Name""" profileallDetailsIndexName: StringInput """Organization ID""" profileallDetailsOrganizationId: FloatInput """JRN Update Date and Time""" profileallDetailsJrnupdatedttm: DateTimeInput """The type of Profile.""" profileallDetailsNameType: StringInput """Internal ID to uniquely identify the Organization""" profileallDetailsOrganizationid: FloatInput """The primary key for this table.""" profileallDetailsProfileId: FloatInput """The type of Profile.""" profileallDetailsProfileType: StringInput """Resort for which Job is registered.""" profileallDetailsResortRegistered: StringInput """This column store the Name of the Company Profiles.""" profileallDetailsCompany: StringInput """The Uppercase value of Last or Company.""" profileallDetailsSname: StringInput """Internal Indexed field for Searching by Extended Byte Name.""" profileallDetailsSxname: StringInput """Uppercase value of First Name.""" profileallDetailsSfirst: StringInput """Used in QMS Module""" profileallDetailsSrepCode: StringInput """Internal Indexed field for Searching by Extended Byte First Name.""" profileallDetailsSxfirstName: StringInput """The date the record was modified""" profileallDetailsUpdateDate: DateTimeInput """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 Accounts Receivable data including Adjustments Payments Invoices and Posting for AR Accounts with linked reservation data.""" aRAccountsReceivable(limit: Int offset: Int input: ARAccountsReceivableQueryArgumentsType!): [ARAccountsReceivableType] } type ARAccountsReceivableType { """Account Details""" accountDetails: ARAccountsReceivableAccountDetailsType """AR Transaction Adjustment Details""" aRTransactionAdjustmentDetailsDetails: ARAccountsReceivableARTransactionAdjustmentDetailsDetailsType """AR Ledger""" aRLedgerDetails: ARAccountsReceivableARLedgerDetailsType """Invoice Header Details""" invoiceHeaderDetails: ARAccountsReceivableInvoiceHeaderDetailsType """AR Post Details""" aRPostDetailsDetails: ARAccountsReceivableARPostDetailsDetailsType """Account Type Details""" accountTypeDetails: ARAccountsReceivableAccountTypeDetailsType """Acct Flag Reason Details""" acctFlagReasonDetails: ARAccountsReceivableAcctFlagReasonDetailsType """Employee Details""" employeeDetails: ARAccountsReceivableEmployeeDetailsType """Account Note Details""" accountNoteDetails: ARAccountsReceivableAccountNoteDetailsType """Profile All Details""" profileAllInformationDetails: ARAccountsReceivableProfileAllInformationDetailsType """Resort Details""" propertyPropertyDetails: ARAccountsReceivablePropertyPropertyDetailsType aRAccountsReceivableRecordCount: Int } type ARAccountsReceivableAccountDetailsType { """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 ARAccountsReceivableARTransactionAdjustmentDetailsDetailsType { """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 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 """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 """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 Transaction Amount""" centralTransactionAmount: 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 """Credit Card ID""" creditCardId: Float """Currency""" currency: 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 """Depositlinkfintransid""" depositlinkfintransid: Float """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 """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 """Fintransactionid""" fintransactionid: Float """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 """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 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 """In House Credit""" inhCredit: Float """In House Debit""" inhDebit: Float """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Installments""" installments: Float """Invoice Close Date""" invoiceCloseDate: Date """Invoice Number""" invoiceNo: Float """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 """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 """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 """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 """Remark""" remark: 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 """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 """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 Amount""" transactionAmount: Float """Transaction Date""" transactionDate: Date """Trns From Account""" transactionFromAcct: Float """Transaction Number""" transactionNumber: Float """Transaction Number to Deposit Posting""" transactionNumberToDepositPosting: Float """Trns To Account""" transactionToAcct: Float """Specifies the Transaction Type. Possible values: [I]nitial Invoice [N]ormal Invoice [Z]ero Invoice.""" transactionType: String """Transcodearrangementid""" transcodearrangementid: Float """Transcodeid""" transcodeid: String """Transaction Activity Date""" trnsActivityDate: Date """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 """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 ARAccountsReceivableARLedgerDetailsType { """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 ARAccountsReceivableInvoiceHeaderDetailsType { """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 ARAccountsReceivableARPostDetailsDetailsType { """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 Open""" aROpen: Float """AR Transfer Date""" aRTransferDate: Date """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 """Accountid""" accountid: Float """Adjustment YN""" adjustmentYN: String """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 Number""" arNumber: Float """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 Aropen""" cAropen: 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 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 Credit""" centralARLedgerCredit: Float """Central AR Ledger Debit""" centralARLedgerDebit: Float """Central Amount""" centralAmount: Float """Central Paid""" centralPaid: Float """Central Posted Amount""" centralPostedAmount: 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 """Credit Card ID""" creditCardId: Float """Currency""" currency: 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 """FT Company""" fTCompany: String """FT First Name""" fTFirstName: String """FT Last Name""" fTLastName: String """FT Name Type""" fTNameType: String """Flexible Benefit Award certificate number.""" fbaCertificateNumber: String """Number to identify the DML sequence.""" financialDmlSeqNumber: Float """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 """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 Credit""" guestAccountCredit: Float """Debit amount on the guest account""" guestAccountDebit: Float """Last Name of the guest.""" guestname: String """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 """In House Credit""" inhCredit: Float """In House Debit""" inhDebit: Float """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Installments""" installments: Float """Invoice Age""" invoiceAge: Float """Invoice Close Date""" invoiceCloseDate: Date """Invoice Number""" invoiceNumber: Float """Invoice Status""" invoiceStatus: String """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 """Stores the original AR ledger debit amount for Direct Bill transactions.""" organizationArLedgerDebit: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """The original transaction amount sent to the financial API.""" originalPostedAmount: 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 """Amount paid.""" paid: Float """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 """Post Date""" postDate: Date """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 """Profile ID""" 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 """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 """Record Type""" recordType: String """Reference""" reference: String """Reporting Guestname""" repGuestname: String """ReportingTransaction Code Desc""" reportingTransactionCodeDesc: String """Stores Reservation_deposit_schedule_id from RESERVATION_DEPOSIT_SCHEDULE table to link the deposit payment to the deposit request.""" reservationDepositId: Float """Reservation First Name""" reservationFirstName: String """Resv Name ID""" reservationNameId: Float """Reservationid""" reservationid: Float """Resevation Last Name""" resevationLastName: String """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 """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 """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 Code desc""" transactionCodeDesc: String """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 ARAccountsReceivableAccountTypeDetailsType { """Account Type""" accountType: String """Account Type Description""" accountTypeDescription: String """Account Type ID""" accountTypeId: Float """Stores the aging delay in days which is used by the ar_unpaid report.""" agingDelayDays: Float """Central Account Type""" centralAccountType: String """Central Account Type Description""" centralAccountTypeDescription: String """Central Credit Limit""" centralCreditLimit: Float """Central Finance Charge Amount""" centralFinanceChargeAmount: Float """Central Exchange Date""" centralXchangeDate: Date """Central Exchange Rate""" centralXchangeRate: Float """Min Number of days to consider older invoices for the account to post finance charges.""" chargesOlderThanNDays: Float """Credit Limit""" creditLimit: Float """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedflag: String """Amount or Fee to charge to the Account for overdue invoices.""" financeChargeAmount: Float """Percentage to apply to the sum of older invoices.""" financeChargePercentage: Float """Inactive Flag""" inactiveflag: String """Used to include unallocated payments in the calculation of the finance charges.""" includeUnallocatedPaymentsYN: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Accounttypeid""" internalAccounttypeid: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Letter name that is send every end of month when the Reminder Cycle is set to [E]nd of Month.""" letterNameEndOfMonth: String """Internal ID to uniquely identify the Property""" locationID: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Name of the owner cashbook report to be given to auditors.""" ownerCashbookReport: String """Name of the owner statement report that needs to be send to the owner of the unit.""" ownerStatementName: String """Name of the owner summary report that needs to be send to the owner of the unit.""" ownerSummary: String """Day of the month when Night Audit will check for older invoices to post finance charges onto a new invoice.""" postOnDay: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Print Invoice Details on Statements Y/N.""" printInvoiceDetailsYn: String """Print Invoices With Details YN""" printInvoicesWithDetailsYN: String """Print Invoices Without Details YN""" printInvoicesWithoutDetailsYN: String """Print Seperate Folios YN""" printSeperateFoliosYN: String """Property""" property: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Indicates if the Reminder Cycle generation is based on calendar [D]ays or [E]nd of Month.""" reminderCycle: String """Reporting Item""" repItem: String """Reporting Item Name""" repItemName: String """Reporting Updatedate""" repUpdateDate: DateTime """Indicates if the Account Type will utilize the '(B)alance Brought Forward? single line or '(I)ndividual Open Items? when generating statements.""" statementMode: String """Name of the statement that needs to be sent to the account.""" statementName: String """Statement Name Description""" statementNameDescription: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ARAccountsReceivableAcctFlagReasonDetailsType { """Acctflagreasonid""" acctflagreasonid: String """Central Flagged Reason Code""" centralFlaggedReasonCode: String """Central Restricted Reason Description""" centralRestrictedReasonDescription: String """Central Sequence""" centralSequence: Float """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedflag: String """Flagged Reason Code""" flaggedReasonCode: String """Inactive Flag""" inactiveflag: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Property""" property: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Reporting Item""" repItem: String """Reporting Item Name""" repItemName: String """Reporting Item Orderby""" repItemOrderby: Float """Reporting Updatedate""" repUpdateDate: DateTime """Restricted Reason Description""" restrictedReasonDescription: String """Sequence""" sequence: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ARAccountsReceivableEmployeeDetailsType { """Allow user access to Configuration.""" accessConfig: String """Allow user access to End of Day.""" accessEod: String """Allow user access to Opera BI.""" accessObi: String """Allow user access to OCIS.""" accessOcis: String """Allow user access to Channel Mangement.""" accessOcm: String """Allow user access to OCRM.""" accessOcrm: String """Allow user access to Opera Revenue Management System.""" accessOrms: String """Allow user access to ORS.""" accessOrs: String """Allow user access to OXI.""" accessOxi: String """Allow user access to OXIHUB.""" accessOxihub: String """Allow user access to PMS.""" accessPms: String """Allow user access to SC.""" accessSc: String """Allow user access to OPERA S&C Analytics.""" accessScbi: String """Allow user access to SFA.""" accessSfa: String """Allow user access to Utilities.""" accessUtil: String """Indicates if user is allowed to login in the application.""" accountLockedOutYn: String """Agent""" agent: String """Defines the type of user.Valid values: U and G U-->User :: G-->Group""" appUserType: String """Date the authorizer became inactive""" authorizerInactiveDate: DateTime """Default rate code for this authorizer.""" authorizerRateCode: String """Denotes if this user is an authorizer. Allowable values are 'Y' and 'N'""" authorizerYn: String """Birth Date""" birthDate: Date """Business Title""" businessTitle: String """Business Title Description""" businessTitleDescription: String """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Hourly Rate""" cHourlyRate: Float """Central Weekly Salary""" cWeeklySalary: Float """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Date employee was hired""" dateHired: Date """Cashier ID for the User""" defCashierId: Float """Not Used""" defaultForm: String """Not used.""" defaultMfnResort: String """Defaults the Report Module to this Report Group""" defaultReportgroup: String """Stores resort name to which user will log in every time""" defaultResort: String """Deleted Flag""" deletedflag: String """Departmentid""" departmentid: String """Department E-Mail Address.""" deptEmail: String """Dept ID""" deptId: String """Pager number of department manager""" deptManagerPager: String """Description of the department""" deptName: String """Dept Order By""" deptOrderBy: Float """When account is disabled this date is set to date when account should be enabled again""" disabledUntil: Date """E Mail""" eMail: String """Employee Extension Number""" empExtension: String """Emp Status""" empStatus: String """Identifies a hotel employee for incentive programs.""" employeeIncentiveNumber: String """This column is used by Starwood Hotels for Storing their internal employee number""" employeeNumber: String """Employeeid""" employeeid: Float """Date on which user ID will be disabled.""" expiresOn: Date """First""" first: String """Requires the user to change the password at login.""" forcePasswordChangeYn: String """Max hours for Friday""" fridayMax: Float """Min hours for Friday""" fridayMin: Float """Stores General File path for Mailmerge""" generalFilepath: String """Number of Logins allowed after password has expired""" graceLogin: Float """Type of hire: F-Full Time P-Part Time""" hireType: String """If RATE_TYPE=H: hourly employee rate""" hourlyRate: Float """Hours Per Week""" hoursPerWeek: Float """Inactive Description""" inactiveDesc: String """Inactive Start Date""" inactiveFrom: Date """Reason Code for inactive status from REASON table""" inactiveReasonCode: String """Inactive End Date""" inactiveTo: Date """Inactive Flag""" inactiveflag: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Laptop ID""" laptopId: Float """Last""" last: String """Lead Address Code determines primary receipient""" leadAddress: String """Lead Address (email/fax no)""" leadAddressDet: String """Lead Communication Type""" leadComm: String """Internal ID to uniquely identify the Property""" locationID: String """Timestamp with the useraccount was locked out.""" lockoutDate: DateTime """Login Cro""" loginCro: String """Login Domain""" loginDomain: String """Employee Gender""" maleFemale: String """Maximum number of days allowed for checkout in Laptop Module""" maxCheckoutDays: Float """Maximum number of Opera Sessions allowed at single point of time.""" maxUserSessions: Float """User type for OCM mode: [C]orporate User""" mfnUserType: String """Middle""" middle: String """Indiciates if alerts are send to mobile registered guests for required action and manual checkout..""" mobileAlertsYn: String """Max hours for Monday""" mondayMax: Float """Min hours for Monday""" mondayMin: Float """Name Notes""" nameNotes: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Overtime Multiplier""" otMultiplier: Float """Period of Days the Password expires""" passwordChangeDays: Float """TimeStamp of last Password Change""" passwordLastChange: Date """Foreign key to NAME table that links this USER to an Employee""" personNameId: Float """Phone no.""" phoneNo: String """Phone Number""" phoneNumber: String """Indicates if this user can be excluded from user account lock.""" preventAccountLockout: String """Primary Block Owner Name""" primaryBlockOwnerName: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Primary Rooms Owner Code""" primaryRoomsOwnerCode: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Rate Type""" rateType: String """Receive Broadcast Msg""" receiveBroadcastMsg: String """Indicates if a terminated employee shall be rehired""" rehireYn: String """Salary Interval: M-Monthly W-Weekly""" salaryInterval: String """Max hours for Saturday""" saturdayMax: Float """Min hours for Saturday""" saturdayMin: Float """Indicates if this Application User can receive Alerts related to Service Requests.""" serviceRequestAlertsYn: String """Sfa Name""" sfaName: String """Assigned Sales Manager Group(s)""" srepGroup: String """Max hours for Sunday""" sundayMax: Float """Min hours for Sunday""" sundayMin: Float """Termination Reason""" termReason: String """Termination Date""" terminatedDate: Date """Territory""" territory: String """Max hours for Thursday""" thursdayMax: Float """Min hours for Thursday""" thursdayMin: Float """Time zone region selected by the employee.""" timezoneRegion: String """Max hours for Tuesday""" tuesdayMax: Float """Min hours for Tuesday""" tuesdayMin: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float """Store User File path. for Mailmerge""" userFilepath: String """User ID""" userID: Float """PBX ID - referred as password to access PBX system""" userPbxId: Float """Max hours for Wednesday""" wednesdayMax: Float """Min hours for Wednesday""" wednesdayMin: Float """Maximum total hours this employee can work per week""" weekMax: Float """Minimum total hours this employee can work per week""" weekMin: Float """Weekly Salary""" weeklySalary: Float """Workpermit Expiration date""" workPermitExpdate: Date """Working Permit Number""" workPermitNo: String } type ARAccountsReceivableAccountNoteDetailsType { """Account Code""" accountCode: Float """Accountid""" accountid: Float """Accountnoteid""" accountnoteid: Float """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedflag: String """Inactive Flag""" inactiveflag: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Internalflag""" internalflag: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Note Code""" noteCode: String """Note Details""" noteDetails: String """Note ID""" noteId: Float """Note Title""" noteTitle: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Code to uniquely identify the Property""" property: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ARAccountsReceivableProfileAllInformationDetailsType { """The primary key for this table.""" guestProfileID: Float """Account number.""" aRNumber: String """Account Receivable No. of this profile.""" aRNumberCentral: String """Indicates if a Credit Limit amount on Profile level will be required.""" aRCreditLimitYN: String """The ARC mailing flag (received from ARC Update program)""" aRCMailFlag: String """The ARC office type (received from ARC Update program)""" aRCOfficeType: String """The date this record was last updated by the ARC update program.""" aRCUpdateDate: Date """Billing contact person in company.""" accountBillingContact: String """Used in S&C Module.""" accountSource: String """Account Type of this Profile""" accountType: String """The description of this value.""" accountTypeDescription: String """The description of this value.""" accountsourceDesc: String """Mailing action codes.""" actionCode: String """Profile is active or not.""" activeYN: String """The first line of street address.""" address1: String """The second line of street address.""" address2: String """The third line of street address.""" address3: String """The fourth line of street address.""" address4: String """The primary key for this table.""" addressId: Float """Description for each language code.""" addressLangCodeDesc: String """Address Language Code""" addressLanguageCode: String """The type of address.""" addressType: String """Country Specific Requirement for Nigeria.""" alienRegistrationNo: String """All Resorts""" allResorts: String """Field which stores the multibyte envelop greeting used in S&C""" alternateEnvelopeGreeting: String """The Extended Byte Language of the Profile.""" alternateLanguage: String """Description for each language code.""" alternateLanguageDescription: String """Alternate Salutation""" alternateSalutation: String """Auto-Enroll Member YN""" autoEnrollMemberYN: String """Does profile have Availability Override Y/N""" availabilityOverride: String """The billing code for this name record.""" billingCode: String """Billing Instruction""" billingInstruction: String """For tour operators the type of billing profile for this name.""" billingProfileCode: String """Country of Birth""" birthCountry: String """Date of Birth of the Individual Profiles.""" birthDate: Date """Stores the encrypted birth date.""" birthDateStr: String """Place of Birth""" birthPlace: String """Any Message for the Restricted profile.""" blMsg: String """Used in S&C Module.""" businessSegment: String """The description of this value.""" businessSegmentDescription: String """The business title for this individual.""" businessTitle: String """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Profile Credit Limit""" cProfileCreditLimit: Float """This is a name_id (Profile number) of profiles that exist in a Central database in a typical CRS environment.""" cRSNameid: Float """This field tells whether this profile is a credit card profile or not.""" ccProfileYn: String """Central Account Type""" centralAccountType: String """Central Business Segment""" centralBusinessSegment: String """Central Business Segment Description""" centralBusinessSegmentDescription: String """Central Corporate ID Type""" centralCorporateIDType: String """The keyword to search on.""" centralDefaultKeyword: String """Central Guest Title Code""" centralGuestTitleCode: String """Central Inactive Reason""" centralInactiveReason: String """Central Inactive Reason Description""" centralInactiveReasonDescription: String """Central Mail Action Description""" centralMailActionDescription: String """Central Mailing Action Code""" centralMailingActionCode: String """Central Priority""" centralPriority: String """Central State Code""" centralStateCode: String """Central Territory""" centralTerritory: String """Central VIP Code""" centralVIPCode: String """Central VIP Description""" centralVIPDescription: String """Chain Code""" chainCode: String """The city for this address.""" city: String """The unique key of this name stores IATA# Company # etc.""" clientID: String """The user that has been assigned to this account for collections.""" collectionUserId: Float """Combined Name""" combinedName: String """This flag will be used in case Profiles are being controlled Centrally (CRS).""" commPayCentral: String """Not Used.""" comments: String """Commission Code for the Commission Percentage.""" commissionCode: String """Code for the commission for Travel Agent""" commissionCodes: String """Comm Curr ID""" commissionCurrencyId: String """Commission Code for the Commission Percentage.""" commissionid: String """Role in which this phone type belongs to.""" communicationRole1: String """Role in which this phone type belongs to.""" communicationRole2: String """Role in which this phone type belongs to.""" communicationRole3: String """The type of this phone number.""" communicationType1: String """The type of this phone number.""" communicationType2: String """The type of this phone number.""" communicationType3: String """The phone number for this record""" communicationValue1: String """The phone number for this record""" communicationValue2: String """The phone number for this record""" communicationValue3: String """Extended Byte Company Name""" companyAlternate: String """The company group or company group user ID in hierarchical format""" companyGroupId: String """Not used.""" companyNameId: Float """Competaion code .""" competition: String """The description of this value.""" competitionDesc: String """Used in S&C Module.""" contactYN: String """Group Contract number.""" contractNo: String """The date the group contract was received.""" contractRecvDate: Date """Corp Type Description""" corpTypeDesc: String """Specified whether Name_Code column has Company # or IATA #. For Company # the value will beCOMP and for IATA # the Value of this column will be IATA.""" corporateIDType: String """Country name.""" country: String """Country .""" countryCode: String """The user that created the record""" createdByUser: String """The date the record was created""" createdOnDate: DateTime """Credit rating.""" creditRating: String """Currency Code""" currencyCode: String """Currency Symbol like $ or EURO symbol""" currencySymbol: String """Double Opt In for AUTOENROLL_MEMBER_YN""" dOptInAutoenrollMemberFlg: String """Double Opt In for EMAIL_YN""" dOptInEmailFlg: String """Double Opt In for GUEST_PRIV_YN""" dOptInGuestPrivFlg: String """Double Opt In for MAIL_LIST""" dOptInMailListFlg: String """Double Opt In for MARKET_RESEARCH_YN""" dOptInMarketResearchFlg: String """Double Opt In for PHONE_YN""" dOptInPhoneFlg: String """Double Opt In for SMS_YN""" dOptInSmsFlg: String """Double Opt In for THIRD_PARTY_YN""" dOptInThirdPartyFlg: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Debtor Name""" debtorName: String """The number of digits after the decimal to allow for this currency.""" decimalPositions: Float """The keyword to search on.""" defaultKeyword: String """Deleted Flag""" deletedFlag: String """Used in S&C Module.""" department: String """Used in S&C Module.""" deptId: String """Used in QMS Module""" description: String """Direct Bill Batch Type""" directBillBatchType: String """Display Name""" displayName: String """Date on which the record is downloaded to laptop.""" downloadDate: Date """REsort name which has downloaded on the laptop.""" downloadResort: String """Owner of the record who downloaded on to laptop.""" downloadSrep: Float """The date when the E-Invoice liable flag was updated for this profile.""" eInvLiableLastUpdated: DateTime """Turkey Country requirement: Indicated if this profile e-Invoice liable. Folios generated for this profile will be directly sent to an external system.""" eInvoiceLiableYn: String """The phone number for this record""" email: String """Email YN""" emailYN: String """Field which stores the envelop greeting used in S&C""" envelopeGreeting: String """External Display Name""" externalDisplayName: String """The first name of an individual.""" externalFirstName: String """External ID used for V6 Interface stores the PMS guest number""" externalId: String """The last name of the individual profile.""" externalName: String """Not Used.""" externalReferenceRequ: String """During the booking process is the user required to enter the tour operator or TA record locator.""" externalReferenceRequired: String """Membership Card Number.""" fMembershipCardNumbers: String """Descripion of membership class""" fMembershipClassDesc: String """F Membership Classes""" fMembershipClasses: String """F Membership Codes""" fMembershipCodes: String """F Membership Descriptions""" fMembershipDescriptions: String """Primary Key for this table.""" fMembershipIds: String """Type of the Membership.""" fMembershipType: String """The ID of the external Database.""" fSubscriptionDb: String """The ID of the external Database.""" fSubscriptionYn: String """The phone number for this record""" faxNumber: String """The first name of an individual name.""" firstName: String """First Name Alternate""" firstNameAlternate: String """The keyword to search on.""" firstNameIncognito: String """The follow on for this individual (I.E: III etc).""" followOn: String """The name as communicated from the GDS. system. Filled on names that are created during the booking.""" gDSName: String """Not used.""" gDSTransactionNo: String """Indicates gender of Individual profile. Either (M)ale or F(emale)""" gender: String """Not used.""" geographicRegion: String """Not used.""" guestClassification: String """Country name.""" guestCountry: String """Currency code for the Commission payment.""" guestCurrencyCode: String """Description for each language code.""" guestLanguageCode: String """The last name of the individual Profile and Search name ofr the other Types of Profiles (Group Travel Agent & Source) are stored in this column.""" guestLastName: String """The middle name of this individual.""" guestMiddleName: String """Guest Name Suffix""" guestNameSuffix: String """Guest Privilege YN""" guestPrivilegeYN: String """The title of the individual.""" guestTitleCode: String """Has Requested Mail YN""" hasRequestedMailYN: String """Keep guest in history Y/N""" historyYN: String """Hold code for the Commission handling purposes.""" holdCode: String """Consortia for the IATA number.""" iataConsortia: String """The country where ID was issued""" idCountry: String """Issued date of Identification""" idDate: Date """This will store the value of LINKED_ATTACHMENTS.ATTACH_ID (Which maps to the physical table WORK_ORDERS.WO_NUMBER)""" idDocumentAttachId: Float """The place where ID was issued""" idPlace: String """Identification Type. Eg Passport Driving License etc""" idType: String """Country Specific Requirement for Nigeria.""" immigrationStatus: String """The date the record was marked as inactive""" inactiveDate: DateTime """Inactive Flag""" inactiveFlag: String """Reason why record was inactivated.""" inactiveReason: String """The description of this value.""" inactiveReasonDescription: String """Include travel agents/sources profile in 1099 reporting ?Y/N""" includeInTax1099Yn: String """Index Name""" indexName: String """The Industry this profile belongs to. Used only for the Non-Individual Profiles.""" industryCode: String """The description of this value.""" industryDesc: String """Used in S&C Module.""" influence: String """The description of this value.""" influenceDesc: String """Interest Code.""" interest: String """Indicates that this profile should be generating an internal bill instead of a regular bill during settlement.""" internalBillYn: String """Deleted Flag""" internalDeletedflag: String """Inactive Flag""" internalInactiveflag: String """Organization ID""" internalOrganizationId: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Primary language used for the profile.""" languageCode: String """Code to synchronize to Laptop values are 012.""" laptopChange: Float """Last Group""" lastGroup: String """Last Name Alternate""" lastNameAlternate: String """The keyword to search on.""" lastNameIncognito: String """Last Rate""" lastRate: Float """Last Rate Code""" lastRateCode: String """The room that is booked for this reservation leg.""" lastRoom: String """Last Room Property""" lastRoomProperty: String """Last Source""" lastSource: String """This contains the truncated component of end_date (i.e without timecomponent)""" lastStay: Date """Last property that updated this record.""" lastUpdatedResort: String """The legal company name for this company.""" legalCompany: String """Used in S&C Module.""" letterGreeting: String """The description of this value.""" mailActionDescription: String """This indicates whether the mailing list must be sent to the guest.""" mailList: String """The type of mail this user should be sent.""" mailType: String """Mailing action codes.""" mailingActionCode: String """Market Research YN""" marketResearchYN: String """Is this account a master account (Y/N)?""" masterAccountYn: String """Not used.""" nameTaxType: String """The type of Profile.""" nameType: String """The description of this value.""" nameTypeDescription: String """Not Used.""" name2: String """Not used.""" name3: String """Nationality""" nationality: String """Nationality of the individual.""" nationalityCode: String """The rate code for which this record applies.""" negotiatedRateCodes: String """This is a begin_date with no time component.""" nextStay: Date """The nickname of this individual.""" nickname: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Stores the original NAME_ID prior to a migration.""" origNameId: Float """Number of days a payment is due for the account.""" paymentDueDays: Float """The phone number for this record""" phone: String """The phone number for this record""" phoneWeb: String """Phone YN""" phoneYN: String """The postal code of this address.""" postalCode: String """City Extension mainly used for UK addresses.""" postalCodeExtension: String """Preferred Room Number""" preferredRoomNo: String """Not used.""" primaryAddressId: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Not Used.""" primaryNameId: Float """Primary Owner""" primaryOwner: String """Primary Owner Code""" primaryOwnerCode: String """Not used.""" primaryPhoneId: Float """Priority of the account""" priority: String """The description of this value.""" priorityDesc: String """Profile privacy flag determine if the profile is marked as private for a property.""" privacyFlagYN: String """Preference Code. Part of the Primary Key.""" productInterest: String """The profession of the Individual""" profession: String """Credit Limit amount for all AR accounts created in different properties for this profile.""" profileCreditLimit: Float """The primary key for this table.""" profileId: Float """The type of Profile.""" profileType: String """Resort for which Job is registered.""" propertyRegistered: String """Protected""" protected: String """Psuedo Profile Y/N""" psuedoProfileYn: String """The default rate structure for this name.""" rateStructure: String """The region for this name.""" region: String """The region for this name.""" regionid: String """Reporting Account Type Description""" repAccountTypeDescription: String """Reporting Accountsource""" repAccountsource: String """Reporting Accountsource Desc""" repAccountsourceDescription: String """Reporting Competition Code""" repCompetitionCode: String """Reporting Competition Desc""" repCompetitionDescription: String """Reporting Corp Type Desc""" repCorpTypeDescription: String """Reporting Industry Code""" repIndustryCode: String """Reporting Industry Desc""" repIndustryDescription: String """Reporting Influence""" repInfluence: String """Reporting Influence Desc""" repInfluenceDescription: String """Reporting Name Type""" repNameType: String """Reporting Name Type Description""" repNameTypeDescription: String """Rep Nationality Code""" repNationalityCode: String """Rep Nationality Description""" repNationalityDescription: String """Reporting Priority Desc""" repPriorityDescription: String """Reporting Rooms Potential""" repRoomsPotential: String """Reporting Rooms Potential Desc""" repRoomsPotentialDescription: String """Reporting Scope""" repScope: String """Reporting Scope City""" repScopeCity: String """Reporting Scope City Desc""" repScopeCityDescription: String """Reporting Scope Desc""" repScopeDescription: String """Reporting State Desc""" repStateDescription: String """Reporting Tax Type Desc""" repTaxTypeDescription: String """Reporting Territory Desc""" repTerritoryDescription: String """Reporting Title Name""" repTitleName: String """The primary membership # for this guest.""" repeatGuestId: String """User option to replace address in ORS with one from PMS.""" replaceAddress: String """This column store the Name of the Company Profiles.""" requestType: String """Normal Restricted and Cash Only informations are stored in this column.""" restricted: String """The description of this value.""" restrictedRule: String """Reservation Contact person.""" resvContact: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Potential no of rooms per year for a account""" roomsPotential: String """The description of this value.""" roomsPotentialDesc: String """Use this alert to text a notification.""" sMSYN: String """Salutation Greeting""" salutation: String """Scope of the account""" scope: String """Scope City""" scopeCity: String """The description of this value.""" scopeCityDesc: String """The description of this value.""" scopeDesc: String """The Uppercase value of Last or Company.""" searchName: String """Internal Indexed field for Searching by Extended Byte Name.""" searchNameAlternate: String """Uppercase value of First Name.""" sfirst: String """The soundex value for this company record. Used for performance reasons when finding a name based on the Sounds.""" soundExCompany: String """The soundex value for this individual record. Used for performance reasons when finding a name based on the sounds.""" soundExLast: String """Used in QMS Module""" srepCode: String """The state of this address.""" state: String """State Code""" stateCode: String """Description of the state.""" stateDescription: String """Summary Reference Currency for the Folio Generation.""" summRefCc: String """Summary Reference Currency for the Folio Generation.""" summRefCurrencyId: String """Used in Oracle Text Index.""" superSearchIndexText: String """Internal Indexed field for Searching by Extended Byte First Name.""" sxfirstName: String """Tax Category""" taxCategory: String """Not used.""" taxExemptStatus: String """The tax id of this name. Usually issued by a government agency. Used by 1099 printing.""" taxID1: String """Tax No""" taxID2: String """Tax Office Name""" taxOffice: String """Tax Type""" taxType: String """TERRITORY of a account""" territory: String """The description of this value.""" territoryDesc: String """Third Party YN""" thirdPartyYN: String """Title Alternate""" titleAlternate: String """The description of this value.""" titleName: String """Stores the suffix value of the selected title code. This will be used for Processing to External System.""" titleSuffix: Float """Sum of total number of stays on stay records for the time period.""" totalStay: Float """The type of tour operator. Only valid for tour operators/wholesalers.""" tourOperatorType: String """Code to Trace a record for all Triggered actions.""" traceCode: String """Description""" tracecodeDesc: String """What type of 1099 is issued to this name.""" typeOfTax1099: String """User defined character field.""" uDFC01: String """User defined character field.""" uDFC02: String """User defined character field.""" uDFC03: String """User defined character field.""" uDFC04: String """User defined character field.""" uDFC05: String """User defined character field.""" uDFC06: String """User defined character field.""" uDFC07: String """User defined character field.""" uDFC08: String """User defined character field.""" uDFC09: String """User defined character field.""" uDFC10: String """User defined character field.""" uDFC11: String """User defined character field.""" uDFC12: String """User defined character field.""" uDFC13: String """User defined character field.""" uDFC14: String """User defined character field.""" uDFC15: String """User defined character field.""" uDFC16: String """User defined character field.""" uDFC17: String """User defined character field.""" uDFC18: String """User defined character field.""" uDFC19: String """User defined character field.""" uDFC20: String """User defined character field.""" uDFC21: String """User defined character field.""" uDFC22: String """User defined character field.""" uDFC23: String """User defined character field.""" uDFC24: String """User defined character field.""" uDFC25: String """User defined character field.""" uDFC26: String """User defined character field.""" uDFC27: String """User defined character field.""" uDFC28: String """User defined character field.""" uDFC29: String """User defined character field.""" uDFC30: String """User defined character field.""" uDFC31: String """User defined character field.""" uDFC32: String """User defined character field.""" uDFC33: String """User defined character field.""" uDFC34: String """User defined character field.""" uDFC35: String """User defined character field.""" uDFC36: String """User defined character field.""" uDFC37: String """User defined character field.""" uDFC38: String """User defined character field.""" uDFC39: String """User defined character field.""" uDFC40: String """User defined date field.""" uDFD01: Date """User defined date field.""" uDFD02: Date """User defined date field.""" uDFD03: Date """User defined date field.""" uDFD04: Date """User defined date field.""" uDFD05: Date """User defined date field.""" uDFD06: Date """User defined date field.""" uDFD07: Date """User defined date field.""" uDFD08: Date """User defined date field.""" uDFD09: Date """User defined date field.""" uDFD10: Date """User defined date field.""" uDFD11: Date """User defined date field.""" uDFD12: Date """User defined date field.""" uDFD13: Date """User defined date field.""" uDFD14: Date """User defined date field.""" uDFD15: Date """User defined date field.""" uDFD16: Date """User defined date field.""" uDFD17: Date """User defined date field.""" uDFD18: Date """User defined date field.""" uDFD19: Date """User defined date field.""" uDFD20: Date """User defined number field.""" uDFN01: Float """User defined number field.""" uDFN02: Float """User defined number field.""" uDFN03: Float """User defined number field.""" uDFN04: Float """User defined number field.""" uDFN05: Float """User defined number field.""" uDFN06: Float """User defined number field.""" uDFN07: Float """User defined number field.""" uDFN08: Float """User defined number field.""" uDFN09: Float """User defined number field.""" uDFN10: Float """User defined number field.""" uDFN11: Float """User defined number field.""" uDFN12: Float """User defined number field.""" uDFN13: Float """User defined number field.""" uDFN14: Float """User defined number field.""" uDFN15: Float """User defined number field.""" uDFN16: Float """User defined number field.""" uDFN17: Float """User defined number field.""" uDFN18: Float """User defined number field.""" uDFN19: Float """User defined number field.""" uDFN20: Float """User defined number field.""" uDFN21: Float """User defined number field.""" uDFN22: Float """User defined number field.""" uDFN23: Float """User defined number field.""" uDFN24: Float """User defined number field.""" uDFN25: Float """User defined number field.""" uDFN26: Float """User defined number field.""" uDFN27: Float """User defined number field.""" uDFN28: Float """User defined number field.""" uDFN29: Float """User defined number field.""" uDFN30: Float """User defined number field.""" uDFN31: Float """User defined number field.""" uDFN32: Float """User defined number field.""" uDFN33: Float """User defined number field.""" uDFN34: Float """User defined number field.""" uDFN35: Float """User defined number field.""" uDFN36: Float """User defined number field.""" uDFN37: Float """User defined number field.""" uDFN38: Float """User defined number field.""" uDFN39: Float """User defined number field.""" uDFN40: Float """The date the record was modified""" updateDate: DateTime """The last date this record's fax # was updated.""" updateFaxDate: Date """The user that modified the record""" updateUser: String """Date on which the record is uploaded to laptop.""" uploadDate: Date """VIP Status of the Individual.""" vIPCode: String """The description of this value.""" vIPDescription: String """The Oracle Financials vendor id for this record. Used with the Oracle Financials A/P interface.""" vendorId: Float """The Oracle Financial vendor site id for this record. Used with the Oracle Financials A/P interface.""" vendorSiteId: Float """Not Used.""" vipAuthorization: String """Country Specific Requirement for Nigeria.""" visaValidityType: String """Xdisplay Name""" xdisplayName: String """Extended Byte middle name.""" xmiddleName: String } type ARAccountsReceivablePropertyPropertyDetailsType { """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 }