For Hertz operations outside of North America not doing EDRB or GAR feed to OKC, Hertz provides an Excel template for those operations to report closed rental transactions. The resulting record layout is referred to by OKC as the "Radius" file.

This program is used to create a csv file of data from CARS+ which can be imported into Excel, thus shortening the task of providing the Excel spreadsheet to OKC. Data from the following types of RAs is included:

Running this Program Automatically:

In normal operation, this program is not run manually. Instead, it should be set up to be run on a scheduled basis, for example once a week or once a month. When run automatically, the ASCII CSV file that is created will be emailed to the address(es) specified by the user. Please contact Thermeon Customer Support to arrange for the scheduled running of this program.

User Note: This program is used to send filled reservations to OKC for Travel Agency Commission processing. No-Showed or cancelled reservations MUST be sent via the Res No-No File Creation program. Both programs must be used to report transactions to OKC.

Locations not operating their system in USD currency:
There must be a record in Edit Exchange Rates with an effective date that is in effect for the data being transmitted. The Exchange record must have "USD" in Field 1 (From Curr Code) and the currency code from the Location File (as entered on Page 3, field 3) in Field 2 (To Curr Code). An example is shown below.

OPTION: EDIT EXCHANGE RATES

1 From Curr Code USD
2 To Curr Code ARS
3 Posting Company
4 Net Vchr Code
5 Effective Date 03-22-14
6 Effective Time 0600
7 Divide by Rate .202839
8 Multiply by Rate 2.000000






1BEGIN 2NEXT 3ERASE 4PREVIOUS 5BACKUP 6 7HELP 8


This program searches the Exchange Rate file for an effective record as described above. If a valid exchange record is not found, the amounts will not be converted to USD.

To access the Hertz Radius File Creation program, type RADIUS (RET) at any menu "OPTION:" field or the appropriate line number on the Hertz Data Transmissions menu. The screen will then display:


OPTION: __ Hertz Radius File Creation

1 Start Date 06-24-14
2 End Date 06-24-14
3 New Only Y
4 Post Records Y
5 Print/Display P
6 Create ASCII file Y



1BEGIN 2 3ERASE 4 5BACKUP 6 7HELP 8


Enter data as follows:

1. START DATE

The date range in Fields 1 and 2 is used to select closed and posted RAs whose closing DBR date falls within the range.

Using your selected date format, enter the Starting Date. Press RET to default to today's date.

EXAMPLE: Type 060114 (RET).

2. END DATE

Using your selected date format, enter the Ending Date. Press RET to default to today's date.

EXAMPLE: Type 062014 (RET)

3. NEW ONLY

Enter:

Y = Yes, include only those RAs on which have not been marked as having been posted.

N = No, all RAs within the date range should be included - whether or not the RA has been previously reported (has been posted).

EXAMPLE: Type Y (RET).

4. POST RECORDS

Enter:

Y = Yes, mark the RAs selected as having been posted.

N = No, do not update the RAs.

EXAMPLE: Type: Y (RET)

User tip: When this field is marked with "Y", printing is required in Field 5.

5. PRINT/DISPLAY

Enter:

P = Print a hard copy of this report on your terminal's assigned printer.

D = Display this report on your terminal screen.

EXAMPLE: Type P (RET)

User tip: When Field #4 indicates that posting is requested, the response in this field must be "P" to print the report.

6. CREATE
ASCII FILE?

Enter:

Y = Yes. The program will produce a comma delimited ACSII file of the report data. The data included in the ASCII file is as follows:

RA Number
Closing date and location
Opening date and location
Customer's first name and last name
Rate Code and Rate Class
Discount indicator
Second subtotal (in US Dollars)
Res. confirmation number (with check digit)
CDP# (this field is left blank if the CDP# is greater than 900000000)
PC number
#1 Club Number
FT Code
FT Number

N = No. An ASCII file will not be created.

EXAMPLE: Type Y (RET)

NOTES:

  1. The ASCII CSV file is placed in the directory named "radius" under the CARS+ base installation directory. The file name will be RADIUS.YYYYMMDD.csv, where YYYY = 4 digit year, MM = 2-digit month and DD = 2-digit day representing the date the file was created.
  2. The ASCII CSV file is not accessible to CARS+Internet users. See note on "running this program automatically" at the beginning of this chapter.


The screen will then display:


OPTION: __ Hertz Radius File Creation

1 Start Date 06-01-14
2 End Date 06-20-14
3 New Only Y
4 Post Records Y
5 Print/Display P
6 Create ASCII file Y


1BEGIN 2 3ERASE 4 5BACKUP 6 7HELP 8


PRESS "F1" AT "OPTION" TO SAVE.