roomMaster Tables

ACCEXPT Account Export File

ACCGROUP Account Groups

ACCGRP Account Group

ACCHIST Account History File

ACCHIST2 Account History File (13 month)

ACCOUNTL Account Types Language Table

ACCOUNTS Account Types

ADVANCE Advance Deposit Ledger

APPLOG Application Log File

CALMEMO Calendar Memo File

CATEGORY POS - Category Master File

CITYDT City Ledger Invoice Detail

CITYHD City Ledger Header

CITYPY City Ledger Batch Header

CITYPYDT City Ledger Pays and Adjustments

CONFIG Configuration File

DAILYACT Daily Audit Recap File

DATAAREA Local Data Area

DEMHIST Demographic History

DEMHIST2 Demographic History 13 month

DENIALS Lost of Revenue Denials

FOLIOAUT Folio Authorizations

FOLIODT Folio Detail File

FOLIOHD Folio Header File

FOLIOTRN Folio Transaction File

FORECAST Forecasting File

GROUPDTL Group Detail

GROUPS Group Information

GROUPSLS Group Sales

HISTDT History Detail

HISTHD History Header

HISTTRN Folio Transaction

INNWEB RM.NET - Message Table

INVDTL POS - Inventory Detail

INVHDR POS - Inventory Master

INVMDR POS - Inventory Modifiers

INVMODC POS - Modifiers Category

INVMODO POS - Modifier Objects

INVSALE POS - Inventory Sales

IRTABLE1 RM.NET - Rooms Booking Requests

IRTABLE2 RM.NET- Room Setup

IRTABLE3 RM.NET- Payment type setup

IRTABLE4 RM.NET- Message Table

IRTABLE5 RM.NET- Audit Log

IRTABLE6 RM.NET - Promotions

IRTABLE7 RM.NET - Statistics Table

IRTABLE8 RM.NET - Trap Duplicates

IRTABLE9 RM.NET - Shopping Cart

IRTABLEJ RM.NET- Java Scripts

JOURNAL Transaction Journal File

JOURNAL1 Change Journal Header

JOURNAL2 Change Journal Detail

JOURNALH Transaction Journal File (History)

KEYLOCKS Keylock Interface File

LOCATION POS - Location Master File

LETSCHEDDT Letter Scheduler Detail

LETSCHEDHD Letter Scheduler Header

LETSCHEDLG Letter Scheduler Log

LOSTF Lost and found

MAILDETL Mail Detail File

MAILFILE Mail Labels File

MAILHEAD Mailbox Header

MAILMRGE Generic Mail Merge

MAINJOUR Maintenance Item Journal

MAINLOG Maintenance Logging File

MANUFACT POS - Vendor File

MESHEAD Message Header

ONORDER POS - On Order File

OTHERCHARGE Other Charges

PACKAGE Package Header

PassBook PastBookings

PCENTERC Profit Centers for City Ledger

PCENTERG Profit Centers for Groups

PCENTERT Profit Centers for Travel Agents

POSDSCDT POS - Discount Detail

POSDSCHD POS - Discount Header

POSHLDDT POS - Check Detail (On Hold)

POSHLDHD POS - Check Header (On Hold)

POSHSTDT POS - Check Detail (History)

POSHSTHD POS - Check Header (History)

POSLOGDT POS - Check Detail (Closed)

POSLOGHD POS - Check Header (Closed)

POSMSG POS - Kitchen Message File

POSSAVE POS - PMS Check Reprint

POSSPEC POS - Special Items

POSTABLE POS Table Location Map

POSTAUDIT EPI - Audit File

POSTBID EPI - Bidrectional Messages

POSTBUFF EPI - Buffer file

POSTCFIG EPI - Configuration File

POSTCHRG EPI - Charge File

POSTIPS POS - Tip History

POSTLOG EPI - Log File

POSTOVR EPI - Override File

POSVOIDS POS - Todays Voids

PRINTERS POS - Printer Setup

PSPOST POS Posting File

PSTMTBL POS - Time Table File

RATCLOSE Rate Closures

RATES Rates File

RATHIST Rate History File

RATHIST2 Rate History File (13 month)

REPORTS Report Listing

REPORTSH Reports Header File

RESERVE Reservations File

RESRULES Close reservation file

ROOMANAL Rooms Analysis

ROOMBOOK Room Bookings

ROOMITEM Room Items

ROOMLIST Rooming List

ROOMS Room Setup

ROOMSOLD Rooms Sold by Date

ROOMSOOO Rooms Out of Order

RUNTIMES User Runtime Variables

RWREPORT Report Wizard

SALESPER POS - Employee Master File

SERVICES Guest Services

SCHCATEGORY iQ-Schedule - Calendars

SCHEVENT iQ-Schedule - Events

SCHNOTES iQ-Schedule - Notes

SCHPOS iQ-Schedule - Point of Sale

SCHRES1 iQ-Schedule - Calendar Resources

SCHRES2 iQ-Schedule - People Resources

SCHTOUR iQ-Schedule - Tours

SQLFILE SQL WorkFile

SQLFILE2 SQL WorkFile (control number)

STALOC POS - Station Location

STANDMSG Standard Message

STAYHIST Nights Analysis

SUBCATEG POS - Sub Category File

SUBGRP Sub Groups

SUBNAME More Names file

TABLES Standard Configuration Table

TCQW_ELEMENTS Query Elements

TCQW_FIELDS Query Fields

TCQW_QUERIES Query Definitions

TRANFORM Translation Format

TRANHIST Transaction History

TRAVDETL Travel Agent Detail

TRAVHEAD Travel Agent Header

TRNGROUP Transaction history by group

UNITMEAS POS - Unit of Measure File

USERHIST User Field Analysis

USERREPT User Report Selection

USERS User Profiles

VIEW_FolioBalance Get Folio Balances

VIEW_HoldTypes Get Hold Types

VIEW_RoomBook Room Availability

VIEW_RoomTypes Get Room Types

VIEW_UserField1 Get Userfield 1 Descriptions

VIEW_UserField2 Get Userfield 2 Descriptions

VIEW_Usernames Get Employee Usernames

VIPFILE Guest Profiles

WORKAREA Work Area for Night Close

YMPACEBK Yield Management Pace Booking

YMPROFILE Yield Management Profile

YMTABLE Yield Management Yield Table

ZIPCODES Zipcode Database