ACTIVITY$LINK

This table stores the relationships between activities and contacts, accounts, and business blocks.

AGENCY_TEMP

Internal.

AGENT_STAT_DAILY

This table stores statistical information about travel agents on a daily basis.

ALLOTMENT_ACTION

This table records the changes of block bookings for each property.

ALLOTMENT_CHANGES

Table that stores the history of the allotment_detail table.

ALLOTMENT_CHANGES_NET

Table that records the Change log information for a Block per stay date.

ALLOTMENT$DETAIL

This table stores for each property details of each block booking.

ALLOTMENT$HEADER

This table stores for each property block booking information.

ALLOTMENT_PRODUCTS

This table stores the products attached to block bookings for each property.

ALLOTMENT_RATES

Stores rate codes belonging to unique Contract/Business Block ID.

ALLOTMENT_RESTRICTIONS

Stores allotment restriction details.

ALLOTMENT_ROOMTYPE_PRIORITIES

This table stores for each property the room type priorities of a block booking.

ALLOTMENT_SNAPSHOT

The table that stores the snapshots of the block room grids.

ALLOTMENT_TRACES

This table stores traces attached to block bookings for each property.

AR$_ACCOUNT

This table stores the ar account setup for each property.

AR$_MAILING_HISTORY

Table is for storage of AR Reminders sent to the AR Accounts.

AR$_NOTES

Stores notes related to the AR Account code.

AR$_STMT_HISTORY

For each property, this table stores information regarding statements sent to A/R accounts and is used to allow for resending the statements.

AR$_TRACES

Stores AR Trace information for the AR Accounts.

AR_ACTION

For each property, this table stores user log information regarding changes/events made to an A/R account.

AR_CREDIT_CARD_SETTLE

For each property, this table stores records for bundled transactions for credit card invoices in Accounts Receivable.

AR_CREDIT_TRNS_LIST

For each property, this table stores information regarding transactions created from credit card invoices.

AR_INVOICE_HEADER

For each property, this table stores all transactions related to A/R.

AR_NOFAX_RECORDS

This table is used to store records for each property from A/R batch statements where the field Fax_No is null.

AUDIT_BOX

Summary of transactions for a day to match the receipts with the postings for that day.

AUTHORIZER$_LIMITS_DETAILS

Detailed routing information for each authorizer.

AUTHORIZER$_LIMITS_HEADER

Routing instructions defined for an authorizer.

AWARD_REQUESTS

This table stores award details for each guest for each property.

BATCH_REQUESTS

This table is used to keep track of the reports that would get printed during night audit.

BOOK$BILLING

Billing instructions per Block.

BOOK$NOTES

Multiple notes for the Block header.

BOOK$OWNER

Owners of the Block header.

BOOKING$LINK

Business Block header relationships.

BOOK$PROFILE_LINK

Table linking Business Blocks to Business Profiles.

BUSINESS$PROFILE_FORECAST_DTLS

Potential Forecast details.

BUSINESS$PROFILE_LINK

Table linking Account and Business Profile.

BUSINESS$PROFILE_NOTES

Notes for a Business Potential.

BUSINESS$PROFILE_OWNER

Owner of the Business Potential.

BUSINESS$PROFILE_REVENUE

Revenue for a Business Potential.

BUSINESS_EVENTS

This table stores the Business events information.

BUSINESS$PROFILE

Information about Business Potential.

CHECK_REGISTER

This table stores all details for each check in each account.

COMMISSION_PAYMENTS

This table stores payment information of commission payments paid to travel agents and sources.

COMMISSION_PROCESS_ACTION

This table records changes made within the commission handling module.

COMMISSION_RESV_DATA

This table gathers and stores commissionable data from all reservations that have checked out prior to that business day.

COMPANY_STAT_DAILY

This table stores for each property statistical information about companies on a daily basis. ( The Column Descriptions for this table are the same as for the table AGENT_STAT_DAILY )

COMPUTED_COMMISSIONS

This table stores computed values for commissions for all travel agents and sources.

CONCURRENT_STATUS

This table stores the information of when the last job has been processed.

CONFIGURATION_ACTION

This table stores the journaling information for Opera's system configuration.

CONTACT_STAT_DAILY

Statistical information about reservation contacts.

CR_CARD_SETTLE

This table stores the credit card settlement information of credit cards to be settled.

CUSTOM_FACILITY_CODES_SCHEDULE

This table stores the custom facility details.

CUSTOM_FACILITY_TASK_SCHEDULE

THis table stores the custom facility task details.

DAILY_EL_LOG_TEMP

This table is used to record changes in rate code, room type, adults, children, market code, origin of booking, for the days of the reservation on which a change happens.

EMP_NON_AVAIL

This table stores for each employee non-availability details such as vacation request dates, leave, jury duty, military leave.

EMP_SCHEDULE

This table stores the scheduled hours of each employee for each date .The data for this table is derived from EMP_AVAIL, EMP_NON_AVAIL, EMP_DETAILS, and EMP_WORK_CATEGORIES.

ERROR_LOG

This table is used to log error conditions and error messages raised by night audit procedures.

EVENT$CHANGES

Event Changes information.

EVENT$CHANGELOG

Stores the Event Change Log

EVENT$CHANGELOG_DETAILS

Stores the Event Change Log Details

EVENT$ITEM

Booked Items for an Event.

EVENT$ITEM_DEPARTMENT

Responsible departments for booked items.

EVENT$ITEMGROUP

Multiple items grouped into a single price for items.

EVENT$LINK

Internal

EVENT$MENU_DETAILS

Booked Menu Definition which contains the Menu items.

EVENT$MENU

Booked menus for an Event.

EVENT$MENUITEM_DEPARTMENT

Responsible Department for the booked Menu Items.

EVENT$MENU_REVENUE

Revenue Type Summary of Booked Menus.

EVENT$NOTES

Event Notes.

EVENT$RESERVATION

Event Reservation Info.

EVENT$RESERVATION_SHARE

Attendees for a shared Event.

EVENT$STATUS_CHANGES

Changes to the Event Status.

EXCEPTION_LOG

Internal

FACILITY_SCHEDULE_DATES

Stores the Facility Schedule dates details.

FB$AGENDA

Meeting Agenda records linked to Business Blocks.

FB$AGENDA_NOTES

Meeting Agenda Notes.

FB$AGENDA_RESOURCE

All Resources associated with a meeting agenda.

FB$AGENDA_REVENUE

Revenue associated with a meeting agenda split by revenue type.

FIN$_TRAN_ACTION

This table logs actions performed in the Cashiering module of Opera PMS.

FIN_TRAN_DETAIL

This table stores rate code descriptions in multiple languages for the respective guests.

FINANCIAL_TRANSACTIONS

All transactions related to cashiering.

FINANCIAL_TRANSACTIONS_JRNL

Journal entries of changes made to financial transactions tables.

FIXED_CHARGES

This table stores the fixed charges that are to be paid by each guest.

FOLIOS

This table stores all Bill Numbers and Window Numbers per reservation. This table lets you determine the reservation for which the fixed bill or window is used for.

FOLIO$_TAX

Summary of revenue information per bill.

FORECAST_DATA_LOAD_STATUS

This table is used to show the status of data load during synchronization of forecast tables through scripts especially during situations when forecast data gets out of synch with transaction data.

FORECAST_PROCESSOR_FAILURES

Records which the forecast processor failed to process.

FORECAST_PROCESSOR_STATUS

This table stores the records processed by the forecast processor dequeues from the forecast queue.

GAMING$_TRIP

Player data for each trip from the PTS system.

GEM$EVENT

Events.

GEM$EVENTGROUP

Multiple groups defined per Business Block.

GEM$EVENT_PKG

Gem event pkg.

GEM$EVENT_PKG_REVENUE

Gem event details.

GEM$EVENT_REVENUE

Event Revenues containing summarized Revenue Types.

GL_NUMBERS

This table represents the operating company's General Ledger Chart of Accounts numbers.

GROUP_STAT_DAILY

This table stores for each property statistical information about groups on a daily basis. ( The Column Descriptions for this table are the same as for the table AGENT_STAT_DAILY )

GUEST$_ENROLLMENT

Stores guest enrollment details.

GUEST$_LOOKUP

Stores guest membership details.

GUEST_CHECK_DETAILS

This table stores all checks sent by POS terminals.

GUEST_ENROLLMENT_PREF

This table stores all guest enrollment preferences to be transmitted to the CRS along with guest enrollment records.

GUEST_LOOKUP

This table stores the guest enrollment information stored in the central reservation system.

GUEST_LOOKUP_PREF

This table stores the guest enrollment preference information stored in the central reservation system.

GUEST_RSV_MESSAGES

This table stores messages for guests attached to specific reservations.

GUEST_RSV_TRACES

This table stores traces for guests attached to specific reservations.

GUEST_TRACES

This table stores traces for guests.

HK_DAILY_TASK_ROOM

This table stores room information linked with daily housekeeping tasks.

IFC_ACT_TABLE

Communication between Opera and Interfaces.

IFC_DATA

This table stores inquiries from the Micros 8700 POS terminal.

IFC_WAKE

This table stores wake up call data for date for each room.

IFC_WAKE_JRNL

This table stores the user activity for each wake up call created.

INVENTORY_CONTROL_ACTION

This table stores the actions for overbooking and sell limits for business events.

LABOR_USED

Labor info that was used while working on the work orders.

LEAD$

Leads for Business Block.

LOCATORS

This table stores the locator information for the guest.

MARKET_STAT_DAILY

Summary table. This table stores for each property statistical information about markets on a daily basis. ( The Column Descriptions for this table are the same as for the table AGENT_STAT_DAILY ).

MEAL_VOUCHERS_TEMP

This table stores meal vouchers that will be printed by the system.

MEETING_ROOM$INVENTORY

Meeting Room Inventory details.

MEETING_ROOM$WAITLIST

Waitlisted Function Spaces

MEMBERSHIPS

This table stores the membership information for each profile.

NA_FINREPORT_STATUS

This table stores the status (Filed, Printed, Filed/Printed) of the financial reports ran during the night audit.

NA_PARAMETERS

This table stores the parameters for a night audit.

NA_REPORT_PARAMETERS

This table stores the parameters for the reports.

NAME$NOTES

Notes for all types of profiles.

NAME$PREFERENCES

Preferences for each profile at each property.

NAME$_CREDIT_CARD

Credit cards for a particular profile for past stays.

NAME_KEYWORDS

Profile keywords.

NAME_POTENTIALS

Potential Information of Guest Statistics.

NAME_RESORT

Profile attributes which are property specific.

NAME_VIRTUAL#

Virtual Numbers allocated permanently to guest profiles.

NIGHT_AUDIT_CHECK

Night audit procedures completed for guests.

NIGHT_AUDIT_JURNAL

 This table stores the procedures run and their status (e.g., completed or failed) for each business date.

NIGHT_AUDIT_JURNAL_DETAILS

This table is used to log the errors that occurred during night audit.

NO_TO_SELL_LOG_TEMP

Internal table. Used in Business events module.

PARTS_USED

Parts used for work orders to be fixed.

PAYMENT_APPLICATION

This table is used to store payments to one invoice or to multiple invoices. 

PAYMENT_TAX

Tax Invoices and information relating to tax payments.

PAYMENT_TAX_JRNL

Tax Invoices and information relating to tax payments.

PMS_FORECAST_QUEUE_TABLE

Forecast Processor Queue Table

PMS_MEMBERS

This table is required for the installation wizard form for extracting inventory.

POLICE_IFC

Reservation records for Police Interface.

POLICE_IFC_JRNL

Changes made to reservation records for Police Interface.

PROFILE_ACTION

This table stores the action log for each profile.

PROFILE_STAT_DAILY

This table stores for each property statistical information about individuals on a daily basis.  (The Column Descriptions for this table are the same as for the table AGENT_STAT_DAILY )

RATE_ACTION

This table stores the user activity log for the Rate module. Each column dependent upon the action that takes place.

RATE_CODE_STAT_DAILY

Summary table. This table stores for each property statistical information about rate codes on a daily basis. ( The Column Descriptions for this table are the same as for the table AGENT_STAT_DAILY )

RATE_DAILY_SOLD

This table stores the number of rooms sold on a daily basis for each room type and each rate code.

RATE_STRATEGY

This table stores the rate strategies defined to be run during the night audit to reflect the changes in rate codes and rate sets.

REPORT_TABLE

Temporary storage of report output data.

REP_MANAGER

Data for the Managers Report.

REQUEST

This table stores all the report requests sent via Concurrent Manager.

REQUEST_PARAMETERS

This table stores all the parameters related to requests.

REQUEST_STATUS

This table stores the list of possible completion statuses for concurrent manager requests.

REQ_FOR_PUBL_ITEMS

Internal

RESERVATION_ACTION

This table stores for each property user log information regarding changes/events made to reservations.

RESERVATION_ALERTS

Alert messages for reservations.

RESERVATION_BALANCES

 This table stores for each property the reservation balance for all in-house guests and guests checked out within the last month.

RESERVATION_CANCEL_POLICY

This table stores the cancellation policy.

RESERVATION_COMMENT

This table stores for each property reservation comments for each reservation.

RESERVATION_CONF_LETTER

This table stores for each property information regarding each confirmation letter sent for each reservation per company, guest, group, source, or travel agent.

RESERVATION_DAILY_ELEMENTS

This table stores for each property room resource information (room, room type) for each date for each reservation in a daily format, including some information that can be different on different days during the stay of the guest (e.g., rate code, market code, etc.)

RESERVATION_DAILY_ELEMENT_NAME

This table implements the many-to-many relationship between the RESERVATION_NAME table and RESERVATION_DAILY_ELEMENTS table. This table stores for each property information regarding the number of adults, children, and the rate amount for each reservation for each date.

RESERVATION_DEPOSIT_SCHEDULE

This table stores for each property information regarding each reservation's requested deposit schedule.

RESERVATION_HEADER

This table stores the reservation heading information for each reservation at each property.

RESERVATION$_HISTORY

This table stores for each property all information pertaining to reservation history records that have been imported from a previous system and all manual reservation history records that are created through the user interface.

RESERVATION_LINKAGE_CNR

This table stores the linkage information between reservations associated with connected suites functionality.

RESERVATION_NAME

This table stores one record per reservation for each property.

RESERVATION_NAME_JRNL

This table stores for each property the old information prior to the updates to the RESERVATION_NAME table.

RESERVATION_OVERRIDES

Stores reservation override details.

RESERVATION_PACE

Transaction data for reservation pace report.

RESERVATION$_PAYMENT_METHODS

Reservation Payment details

RESERVATION_PRODUCTS

This table stores for each property the package elements a reservation additionally purchases or those package elements which are included by a rate code but deselected in the reservation.

RESERVATION_PROMOTIONS

This table stores for each property the promotions for a reservation.

RESERVATION_RECEIPTS

This table stores for each property for each reservation the approval amounts, approval code, etc., related to credit card authorizations.

RESERVATION_RECEIPTS_JRNL

This table stores for each property the old information prior to the updates to the RESERVATION_RECEIPTS table.

RESERVATION_REGRETS

This table stores for each property the turnaway information for each attempt to make a reservation.

RESERVATION$_RESTRICTIONS

Rate restrictions for the property.

RESERVATION_SPECIAL_REQUESTS

This table stores for each property special requests for each reservation.

RESERVATION_STAT_DAILY

Detailed Reservation statistical Information.

RESERVATION_STAT_DAILY_DUMMY

Temporary storage of reservation_stat_daily.

RESERVATION_STAT_DAY_SUM

Summary reservation statistical information.

RESERVATION_SUMMARY

This table stores for each reservation, block, and housekeeping event its forecast data.

RESERVATION_VIRTUAL#

This table stores for each property the virtual numbers allocated to each reservation.

RESORT_CALENDAR_EVENTS

This table stores the event codes for the property.

RESORT_CALENDAR_EVENT_DATES

This table stores the dates of the events for the property.

RESORT_HK_DAILY_TASK

This table stores housekeeping daily task information to be performed by housekeeping personnel.

RESORT_HK_DAILY_TASK_EMP

This table stores all the employees assigned to a task. The task sequence number identifies the task for which the employee was assigned.

RESORT_HK_EMPLOYEE_POINTS

This table stores earned housekeeping points by date per property.

RESOURCE$NOTES

Notes for Event resources.

ROOM_MAINTENANCE

This table stores room maintenance information for each room in each property.

ROOM_REPAIRS

This table stores out of order and out of service information for each room at each property.

ROOM_CATEGORY_STATISTICS

Statistical Information about room types on a daily basis.

ROOM_STATISTICS

 This table is used in the housekeeping module for verification of synchronization between housekeeping and front desk for each room at each property for each date.

SC$ATTACHMENT

Attachments in Sales & Catering.

SH_ENROLLMENT_STATISTICS

This table stores statistical information for each enrolled guest and is populated during the Guest Lookup process from CRS. For Starwood properties.

SOURCE_PROF_STAT_DAILY

This table stores for each property statistical information about profile sources on a daily basis.
( The Column Descriptions for this table are the same as for the table AGENT_STAT_DAILY ).

SOURCE_STAT_DAILY

Summary table. This table stores for each property statistical information about origin of booking sources on a daily basis. ( The Column Descriptions for this table are the same as for the table AGENT_STAT_DAILY )

STAT_DATA_ELEMENTS

Stores reservation data elements for OPERA Statistics.

SUMMARY_REFRESH_LOG

This table stores for each property the refresh time of the summary table updates (the 'Last Run Date' of night audit procedures).

TEMP_ADDON_CALCULATIONS

This table stores information required for the generated transaction.

TEMP_NA_REPORTS

This table stores the report module IDs that need to be printed during Night Audit.

TEMP$_REG_CARDS

This table stores registration card information.

TEMP_ROOM_CAT

This table stores room categories for inventory calculations.

TEMP_ROOM_CLASS

This table stores room classes for inventory calculations.

TMP_RESERVATION_PERSON_LIST

This table is used by the get_share_info function in the Reservation module.

TMP_TAXCALC

This table stores the revenue information while populating forecast tables. This is purely a temporary table.

TRIAL_BALANCE

This table stores the summarized transactions for that business date during night audit.

TRX$_CODES_ACTION

This table stores the actions taken on the transaction codes.

TRX$_CODES_COMP_XREF

Gaming link table to cross reference what transactions can be comped.

TRX$_CODES_JRNL

This table stores journal entries of changes made to the TRX$_CODES table.

TRX_ROUTING_INSTRUCTIONS

This table stores the details of routing instructions.

UPDATE_MARKET_CODE_EXCEPTIONS

This table stores all exceptions for market code changes locked at time of change.

US_1099

Stores data for the IRS Forms 1099 and 8300.

US_1099_PERIODS

Stores the periods for the data in US_1099 table.

WORKORDER_PAGER

Linked table of work_orders and sent_to_page.

WORK_ORDERS

Work orders created.

WORK_ORDERS_RESV

Work order table for each reservation.

YM_NAME_ADJUSTMENTS

This Table stores the Information of Adjustment codes attached to each Profile for the Yield Management functionality.

YM_RATE_SET_ADJUSTMENTS

This Table stores the Information of Adjustment codes attached to each rate set  for the Yield Management functionality.