The file layouts or file descriptions are listed here to help you decide which file to use for your select report. If one file layout is the same as another file layout only one of those files will contain dictionary items. The dictionary items are necessary for you to get the information you need. If you need information from the current reservation file you will use RMSRESV. If you need information from the reservation archive file (RMSRSVA) then you will type in the "USING" clause in your select sentence. For example RMSRESVA USING RMSRESV.DCT… .
The list below contains a common name for the file in the first column and a short descriptive phrase to let you know more about the file in the second column. The third column on the far right is the actual name of the file. To see more about what is in the file, type the file name in the sentence or clause command text box of your report generator. To do that, go to Custom Reports and select Maintain a Select Report. Then click on new to clear the screen of any previous reports. Type the file name whose dictionary items you would like to view into the sentence or clause command text box. Press <enter> on your keyboard and the file name will move up into the Current Sentence part of your screen. Then click on the [help] button. An alphabetical list of the field names (also called dictionary- items) available for use for that file will be displayed. Field names are the labels given each piece of data in the file you have chosen to use. For example, the field name for the date of arrival in the reservation file is called ARRIVAL. The names of the dictionary items will help you determine if the information you are seeking is in that file.
Most Commonly Used Files:
|
Mailing List |
All of your names and addresses. |
RMSMAIL |
|
Reservations, Current |
All current reservations |
RMSRESV |
|
Reservations, Archived |
All the reservations you have ever archived, unless you have done a selective purge. Uses RMSRESV.DCT. |
RMSRSVA |
|
Reservations, Cancelled |
The Cancelled reservations. Uses RMSRESV.DCT. |
RMSDRESV |
|
Owner file |
Contains the owner’s information |
RMSOWNER |
|
Unit File |
Contains most of the unit information that you see when you choose the Unit file from the files menu. |
RMSUNIT |
|
Work orders, Current |
Work orders, current |
RMSWORKO |
|
Work orders, Archive file |
Work orders, archive file. Uses RMSWORKO.DCT |
RMSWORKA |
|
Work orders, Cancelled |
Work orders, cancelled. Uses RMSWORKO.DCT |
RMSWORKC |
Reservations
|
Equipment ordered, current |
Contains your equipment orders that are current. |
RMSEQORD |
|
Equipment ordered, archived |
Equipment order information that has been finalized and archived. Uses RMSEQORD.DCT. |
RMSEQOA |
|
Equipment ordered, (deleted) |
Equipment orders you cancelled. Uses RMSEQORD.DCT. |
RMSEQOD |
|
Golf Reports |
Golf non-processed reports pending |
RMSGNPRO |
|
Golf Tee Times |
Golf tee time transactions including, what course, what time, how many in the group & cost. |
RMSGFTRN |
|
Tenant file |
Long term tenant information including names, addresses & employment. |
RMSLEASE |
|
Maintenance File |
Maintenance block transactions (descriptions), which unit, who blocked the unit & why it was blocked. |
RMSMAINT |
|
Non-processed Reports |
Non-processed reports pending, that is the changes cancellations and new reservations that have occurred since the last time the reports were run. |
RMSNPRO |
|
Next Arrival File |
Next arrival file (a utility is used to maintain this file. It not self-maintaining and not usually used for Select Reports.) |
RMSNXTAR |
|
Unit Clean Status File |
Unit clean status transactions such as unit number, date & crew. |
RMSUSTAT |
|
|
|
|
Accounting
|
Annual 1099 Report |
1099 information for owners & vendors |
RMS1099 |
|
Annual 1099 Report-Timeshare owners |
1099 information for time-share owners (time-share systems only) |
RMS1099T |
|
Credit card charges, current |
Credit card charge transactions, current reservations |
RMSCCHG |
|
Credit card charges, archived |
Credit card charge transactions, archived reservations. Uses RMSCCHG.DCT. |
RMSACCHG |
|
Credit card charges, cancelled |
Credit card charge transactions, cancelled reservations. Uses RMSCCHG.DCT. |
RMSCCCHG |
|
Chart of Accounts Listing |
General Ledger Accounts, includes budget info if entered |
RMSCHART |
|
Check Register Report |
Includes name on check, number, amount, date, unit, status etc. |
RMSCHKRG |
|
Accounts payable transactions (checks), current (not processed) |
Contains current transaction information for payables not just checks. |
RMSCHKWT |
|
Payables, archived |
Accounts payable transactions (checks), archived (processed). Uses RMSCHKWT.DCT. |
RMSCKWTA |
|
Check attachment file |
A temporary file the system uses to store information that will not fit on the stub. For example when you are consolidating invoices from one particular vendor. |
RMSCKATT |
|
Credit memos, current |
Current accounts payable credit memos. |
RMSCMMO |
|
Credit memos, archived |
Accounts payable credit memo, archived. Uses RMSCMMO.DCT. |
RMSCMMOA |
|
Reservation and Owner Statement transactions |
Reservation and unit transactions, current reservations and current owner credits, owner debits and work orders . |
RMSDTRAN |
|
Reservation transactions, cancelled |
Reservation transactions, cancelled reservations. Uses RMSDTRAN.DCT. |
RMSCTRAN |
|
General Ledger transactions, current |
Account, amount, and other details depending on the transaction. |
RMSGLTRN |
|
General Ledger transactions, archived |
Contains all the details of the archived transactions. Uses RMSGLTNA.DCT. |
RMSGLTNA |
|
General Ledger, closings |
General Ledger close period information |
RMSPOST |
|
Reprint statements report |
Reprint owner statement information |
RMSSTMT |
|
Unit to Date Totals file |
Unit to-date totals |
RMSUTOTS |
|
Unit to Date Totals file, time-share |
Unit to-date totals, time-share units |
RMSUTOTT |
|
Vouchers, current |
Accounts Payable Voucher transactions, current |
RMSVCHR |
|
Vouchers, archived |
Accounts Payable Voucher transactions, archived. Uses RMSVCHR.DCT. |
RMSVCHRA |
|
Work Orders, current |
Work order distribution transactions, |
RMSWRKD |
|
Work Orders, archived |
Work order distribution transactions, archived. Uses RMSWRKD.DCT. |
RMSWRKA |
|
Reservation and Owner Statement transactions, finalized |
Reservation and unit transactions, archived reservations and unit owner statement transactions (owner debits, owner credits, work orders that are finalized). Uses RMSDTRAN.DCT |
RMSTRNA |
Set Up
|
Sales Agent File |
All of the information regarding the sales agents you entered into your RMS |
RMSAGENT |
|
Amenities File |
Everything you have in your amenities file. |
RMSAMEN |
|
Characteristics File |
All the information in your Characteristics File |
RMSCHAR |
|
Charges File |
Everything you have included in your charges file |
RMSCHRG |
|
|
|
|
|
City, State & Zip code file |
Used to lookup zip codes and display the city and state. |
RMSCTYST |
|
Golf Courses |
A List of all your Golf courses and their description info and address information. |
RMSGOLF |
|
Equipment File |
Information regarding what equipment that you are able to rent in RMS. |
RMSEQUIP |
|
Key File |
Everything in your key file including key number, unit number and description. |
RMSKEY |
|
Operator Initials File |
Contains all your operator’s names and initials |
RMSOPER |
|
Package File |
All the details you have entered about your packages including, which amenities and equipment are included in the package. |
RMSPACK |
|
Package Rates |
Special package rates, rate keys and descriptions |
RMSPK2RT |
|
Rate Definition File |
Contains all the rate information including type, date, description and year. |
RMSRATDF |
|
Recurring Fees File |
Recurring fee information you have setup in the system to control your recurring fees. |
RMSRECUR |
|
Season File |
Contains the season information including the key, dates and year. |
RMSSEASN |
|
Season Supplement File |
Holds the minimum stay and check-in days allowed information. |
RMSSESUP |
|
States File |
This is where the state abbreviations are stored. |
RMSTATES |
|
Owners File, Timeshare |
All the owner information for timeshare owners is in this file. |
RMSTMOWN |
|
Unit Inventory File |
Contains all the information you have entered into the unit inventory file. |
RMSUINV |
|
Vendor File |
All the information on the vendor records. |
RMSVNDR |
Notes
|
Notes, Mail File |
Mail notes file uses RMSRNOT.DCT |
RMSMNOT |
|
Reservation Notes File |
Notes you have entered in the reservation notes file. |
RMSRNOT |
|
Reservation Notes, Archived |
Uses RMSRNOT.DCT |
RMSRNOTA |
|
Reservation Notes, Cancelled |
Uses RMSRNOT.DCT |
RMSRNOTC |
|
System Notes |
Uses RMSRNOT.DCT |
RMSSNOT |
|
Unit Notes File |
Uses RMSRNOT.DCT |
RMSUNOT |
|
Work Order Notes File |
Uses RMSRNOT.DCT |
RMSWNOT |
|
Work Order Notes, Archived |
Uses RMSRNOT.DCT |
RMSWNOTA |
|
Work Order Notes, Cancelled |
Uses RMSRNOT.DCT |
RMSWNOTC |
System
The System files are not used in select reports. They are listed here for reference only.
|
Control File |
|
RMSCNTL |
|
Program File |
|
RMSCOMP |
|
Reservation Date Tracking File |
|
RMSDATES |
|
Messages File |
Contains text prompts that are in message boxes including error messages. |
RMSMSGS |
|
Screen Entry Requirements |
For program use only. |
RMSVALID |
|
Video Attributes |
For program use only. |
RMSVIDEO |
|
Temporary system file |
A system file used to store information before it is processed. |
RMSWORK |
|
Check attachment file |
A temporary file the system uses to store information that will not fit on the stub and therefore is designated for an attachment to a check. For example: consolidating many invoices from one particular vendor. |
RMSCKATT |
|
User Letter Definitions |
User Designed Letters line text. |
RMSREPRT |
|
Work Order Templates file |
Any work order templates are stored in this file |
RMSWOTPL |
|
Accounts Payable Templates |
Accounts payable templates are stored in this file. |
RMSCKTPL |
|
Payment Templates |
SYSTEM FILE |
RMSPYTPL |