This program can be run from the menu or from the report driver (automatically created reports). Note, however, it produces a file for export only. A report is not printed from CARS+.

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

OPTION: MAJOR CLIENT FILE CREATE 1 Starting CDPID# FIRST 2 Ending CDPID# LAST 3 Contract # ALL 4 IT # ALL 5 Starting Customer# FIRST 6 Ending Customer# LAST 7 Starting Rate Code FIRST 8 Ending Rate Code LAST 9 Start DBR Date 11-17-09 10 End DBR Date 12-17-09 11 Open Location ALL 12 Default Class 13 Output Type F (F=Text File, E=Export (CSV) 1BEGIN 2 3ERASE 4 5BACKUP 6 7HELP 8

Enter data as follows:

	NOTE: Selection data can be entered in any ONE of the following: CDPID, CONTRACT, IT#, OR CUSTOMER. ONLY ONE of these four can be used.
1. STARTING CDPID#	Enter a starting CDPID number or press (RET) to default to the FIRST one on file. EXAMPLE: Press (RET)
2. ENDING CDPID#	Enter an ending CDPID number or press (RET) to default to the LAST one on file. EXAMPLE: Press (RET)
3. CONTRACT #	Enter up to 8 alphanumeric characters representing a corporate contract number or press (RET) to default to all contracts. EXAMPLE: Type 122345 (RET)
4. IT #	Enter up to 15 alphanumeric characters representing an IT code or press (RET) to default to all IT records. EXAMPLE: Press (RET)
5. STARTING CUSTOMER#	Enter up to 6 alphanumeric characters for a starting customer number (renter or bill-to), or press (RET) to default to the FIRST one on file. EXAMPLE: Press (RET)
6. ENDING CUSTOMER #	Enter up to 6 alphanumeric characters for a starting customer number (renter or bill-to), or press (RET) to default to the LAST one on file. EXAMPLE: Press (RET)
	NOTE: Selection data can be entered in any ONE of the following selections above: CDPID, CONTRACT, IT#, OR CUSTOMER. ONLY ONE of these four can be used.
7. STARTING RATE CODE	To limit the report to RAs with a particular Rate Code(s), enter the starting rate code. Press (RET) to begin with the 'FIRST' rate code. If the selection was by IT#, the rate refers to the voucher rate. For other selections, the rate refers to the rate on the RA. EXAMPLE: Press (RET)
8. ENDING RATE CODE	To limit the report to RAs with a particular Rate Code(s), enter the ending rate code. Press (RET) to end with the 'LAST' rate code. EXAMPLE: Press (RET)
9. START DBR DATE	Using the selected date format, enter the starting DBR date. Press RET to default to a month previous to the current date. The date range in this field and the next one refers to the closing DBR date of the RAs. EXAMPLE: Press (RET)
10. END DBR DATE	Using the selected date format, enter the ending DBR date. Press RET to default to the current day. The date range in this field and the next one refers to the closing DBR date of the RAs. EXAMPLE: Press (RET)
11. OPEN LOCATION	Enter: 1. Up to 6 alphanumeric characters to select a single location. 2. A Group Name representing several locations (see the Chapter Edit Group Names for a discussion on location groups). Remember, the first character of a Group Name is the plus sign "+". Press RETURN to accept the default of ALL locations. EXAMPLE: Type TUS (RET)
12. DEFAULT CLASS	The insurance company receiving the data has a single class that they prefer to reserve. Enter the class in this field.
13. OUTPUT TYPE	F = Text File E = Export (CSV File) EXAMPLE: Type F (RET)

The screen will then display:

OPTION: MAJOR CLIENT FILE CREATE 1 Starting CDPID# FIRST 2 Ending CDPID# LAST 3 Contract # 122345 4 IT # ALL 5 Starting Customer# FIRST 6 Ending Customer# LAST 7 Starting Rate Code FIRST 8 Ending Rate Code LAST 9 Start DBR Date 11-17-09 10 End DBR Date 12-17-09 11 Open Location ALL 12 Default Class 13 Output Type F (F=Text File, E=Export (CSV) 1PRINT 2 3 4 5BACKUP 6 7HELP 8

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

This program reads through the RA charge file looking for closed and posted records that fall within the requested date range and that opened at the requested location(s). Of course, the other criteria must be met as well: CDPID, Contract #, IT#, or Customer number.

For Hertz operations, local CDPID numbers are alpha-numeric and international CDPID numbers are strictly numeric. As a result, the CDPID selection fields can be used for local, international, or both.

For each RA found, the following data is written to a csv file placed in the CustDataExport directory off the CARS+ directory. Records are not flagged as having been exported; therefore, it is possible to send the same transaction more than once.Brand

CDPID
CDPID name
IT code
IT name (description)
RA bill-to #
Bill-to customer name
P. O. number
Claim number
State of the renting location (if using extended address feature, the state field. If not using extended address, the 3rd address line of the location address)
RA #
Edit indicator: If RA charge records exist for the RA with a DBR date earlier than the start date of the report, this field is set to "Y". Otherwise, "N".
Res confirmation number if there is one; otherwise, the reservation number
Auth number (data from the Hertz res. delivery field. 'voucher data'.)
User ID on the res.
RA renting location
Renting location name (description)
RA closing location
Closing location name (description)
Rate set
Renting customer number
Renting customer last name and first name
Payee type: If no voucher charges, "CUSTOMER". If a voucher and no out of voucher charges, "INSURER". Otherwise, "CO-CONTRIBUTION"
Vehicle class reserved
Vehicle class rented
Vehicle rate class (class charged)
Upgrade indicator (Y/N)
Company upgrade (If voucher class does not equal the rental class = Y; otherwise N)
Description of the rate class
License plate number of the vehicle
Model code of the vehicle
Color of the vehicle
Reservation pick up date
RA opening date
Reservation return date
RA closing date
Elapsed days (to one decimal position)
Chargeable days (plus a decimal fraction for any charged hours)
Daily rate
Total TIME charge
Odometer reading at open
Odometer reading at closed
Kms/Miles traveled (including exchanges)
Kms/Miles allowed per day
Kms/Miles allowed per rental
Excess Kms/Miles
Kms/Miles charged
Airport fee charge
Drop charge
Total of all other charges other than those with a specific field.
GST amount
Total of all charges excluding GST
Total of all charges including GST
Fuel charge plus GST on fuel charge
Total of all "O" type options plus GST calculated on these charges
Total of all Dep/Pay deposits and payments (DBR date falls within the requested date range, this is the total of Dep/Pay records through the cut off date of the report) Otherwise, the total of Dep/Pay records within in the requested date range.)
Upsell: charge for any "U" type option plus the GST on that amount; OR the difference between the Time records between the voucher record and the out of voucher record when the voucher class doesn't equal the RA class. GST added to this difference.)
Total customer charges: All RA charge records without a voucher sequence.
Original close? Y = no RA Charge records with a DBR date earlier than the starting date of the report. Otherwise, N.
An array that repeats 20 time consisting of RA charge rows (those with an amount and not cancelled:Option code

Option quantity
Option type
Hours
Hourly rate
Days
Daily rate
Weeks
Weekly rate
Months
Monthly rate
Extra days
Extra day rate
Charge

Damaged? Y = a damage report for the RA number; otherwise N. If Y, the following reported:

Damage report number
Customer present (Y/N)
Driver
Date
Third party
Damage covered (Y/N)
Damage charged