A. A vendor record must be set up for the New South Wales Transportation Roads and Maritime System. The record must be set up as follows:
B. A comma delimited text file needs to be manually set up that will translate the toll description fields to a description that will print on the Toll invoice. The file must be set up as follows:
1. File name = TOLLS.txt
2. Record layout =
Foreign Operator ID (3 characters) - use trailing spaces if the code is not 3 characters long
Plaza ID (3 characters) - use trailing spaces if the code is not 3 characters long
Description = 30 characters
3. Example:
II. SPREADSHEET FORMAT100,1 ,SYDNEY BAY BRIDGE
The following table shows the record layout that is created by this program.
| Required Column Header |
Format |
Notes |
| Date |
DDMMYY |
date the toll was received by the rental company |
| Vendor-no |
8 character Vendor number |
"RMS" (this is the Vendor number of the toll issuer) |
| Offense-type |
2 character code |
Leave this column blank. The Ticket Charge Code record that
is to be used for the admin fee and taxes charged comes from the Charge
Code on the Vendor in the previous field will be used. |
| Citation |
up to 20 characters alphanumeric |
Toll citation number |
| Amount |
nnnnnn.nn |
The amount of the toll charge without any administration fees |
| License |
11 character vehicle license number |
License plate number of the vehicle involved |
| Ticket-date |
DDMMYY |
Date the toll occurred |
| Ticket-time |
HHMM (using a 24 hour clock [2pm = 1400)) |
Time the toll occurred |
| Description |
30 characters |
A description of the toll road or bridge from the file TOLLS.txt |
Create the spreadsheet on a PC or computer that is also used
to
access CARS+. Once the spreadsheet is done, save it in the csv format. Then on the same computer, sign into and access CARS+. Go to the Batch Ticket Processing Report program and with the cursor at the "OPTION"
field, press
F4 to upload the file. A browser window will appear. Select
the csv file from your PC and click "Send".
To access this program: To access the Convert ADF File program, type CNVADF (RET) at any menu "OPTION:" field or the appropriate line number on the Hertz Australia Sub-Menu of the Hertz Brand Menu. The screen will then display:
OPTION: ____ ADF FILE CONVERSION
1 ADF Filename
1BEGIN 2 3ERASE 4UPLOAD 5BACKUP 6SEARCH 7HELP 8Enter data as follows:
1. ADF FILENAME
Enter the name of the ascii comma delimited file containing the toll data.