Use this program to:

• Copy over tour operator records from the production data base in Company 00 to the Training/Testing data base in Company 99.

To access the program, type COPYTR (RET) at any menu "OPTION:" field or the appropriate number on the RV Operations Menu. The screen will then display:

OPTION: IMPORT DOMESTIC FREEDOM RATES 1 From File named 2 Overwrite existing Y 3 Seed Rules Record Default Group 1BEGIN 2 3ERASE 4 5 6 7HELP 8

Enter data as follows:

1. FROM FILE NAME	Enter the full path name of the ascii file to be processed.
2. OVERWRITE EXISTING	Enter: Y = Yes, existing Freedom records in the Rental Rules and Rate Files should be replaced with the data from this file. N = No, only insert new records to the Rental Rules and Rate Files do not re-write any existing records. EXAMPLE: Type Y (RET)
3. SEED RULES RECORD DEFAULT GROUP	Enter an existing Rate Set Code that should be used for creating a new Rules record if the spreadsheet contains a row with a Rate Set and Rate Product Code combination that does not already exist. The rules record for the Rate set entered here will be cloned with all it's rule settings for the new Rate Set from the import file. EXAMPLE: Type SO (RET)

PRESS "F1" AT "OPTION:" TO BEGIN .

Setting up the Freedom Rate Excel spread sheet:

the columns are:

1. Rate Set
2. Rate Product Code
3. Rate Class
4. Effective Date and Time in the format YYYYMMDD HHMM0 (20120101 00000)
5. Period Max Days
6. Daily Rate - (it may include decimals) - also used for the XDAY rate.
7. Period Rate
8. Max Days

EXAMPLE:

DN FRDT E27 20120101 00000 4 74 297 90
SO FRDT E27 20120101 00000 4 74 297 90
NJ FRDT E27 20120101 00000 4 97 387 90
DN FRDT C19 20120101 00000 9 95 981 37
SO FRDT C19 20120101 00000 9 50 531 37
NJ FRDT C19 20120101 00000 9 90 801 37

For Rate Set DN, the FRDT rate for Class E27 starting on January 1st, 2012 will be $297.00 for a 4 day period. Days beyond the first 4 days will be charged at an additional $74.00/day. The maximum rental length for this rate product is 90 days. For Class C19, the price is $981.00 for a 9 day period with extra days charged at $95.00/day up to 37 days total.

NOTE: The daily and period prices can be set to zero in the spreadsheet. When that is done, it means that the rate is to be manually set by the rental agent at the time of opening the rental agreement. For safety sake, if this is desired, the following additional setup should be done:

• The Rate Rules record must say that the rate is editable.
• The Rate Rules record should be defined to prevent zero rates in RA OPEN thus forcing the edit.
• Rental agents must be given edit capabilities in Edit User Access File.