This program generates a csv report for Gold Choice Rentals.

To access the program, type GLDEXP (RET) at any menu "OPTION:" field or the appropriate number on the Data Transmission Submenu of the Hertz Menu. The screen will then display:

OPTION: __ GOLD CHOICE EXPORT


1 Open Location TUS
2 Start Date 02-24-14
3 End Date 02-24-14




1PRINT 2 3ERASE 4 5 6 7HELP 8

Enter data as follows:

1. OPEN LOCATION For the opening 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 "+". In addition, for this report, a Location Group will trigger "subtotal roll-ups" (if the group contains groups within groups, subtotals will print for each group level). For more information on this feature, refer to the section on Subtotal Roll-Ups at the end of the Edit Group Names chapter.
  3. "ALL" to include all location
EXAMPLE: Type TUS (RET)
2. START DATE The date range in this field and the next one refers to the return date on the RA. Press RET to default to today's date or enter another start date.

EXAMPLE: Press (RET)

3. END DATE The date range in this field and the one above refers to the return date on the RA. Press RET to default to today's date or enter another end date.

EXAMPLE: Press (RET)

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

The RA file is examined for closed RAs that opened at the selected location(s) and have a return date that falls within the date range requested. For each RA selected, the following data is placed in a csv file record.

Column
 Column Heading
 Data
A
 RA Number

 RA number
B
 RA Version
 RA-dbr-version
C
 No. 1 Club

 Cust. # 1 club number
D
 REV_MGT_ID

 Opening employee (with all leading alpha characters removed)
E
 DATE & TIME

 Opening date and time
F
 Location Alpha

 Opening location (as converted to Alpha Code via CVTCOD)
G
 Location Number

 Opening location number
H
 TYPE OF TRANSACTION

 GCEXCH If gold and preprinted and RA-veh-prv-class is not blank
GCRENT if gold and not preprinted
Otherwise GCEXIT
I
 RES CLASS

 vehicle class on the reservation attached to the RA
J
 VEHICLE CLASS

 vehicle class on the RA
K
 UPSELL AMOUNT

 charge from any U type option
L
 Gold Transaction
 Y = Res-stat2-n1-type is defined as gold on the reservation attached to the RA and RA-preprint=Y
N = #1 club number on the RA
otherwise blank
M
 FPO
 B = RA-prepaid-fuel=Y and Res-fpo= Y
A = RA-prepaid-fuel=Y and Res-fpo is not Y
Blank if RA-prepaid-fuel=N
N
 Service Level

 Res-stat2-n1-type of RA-res-no
O
 USR_PREP

 RA preprint employee (with all leading alpha characters removed)
P
 PP_USR_PREP

 RA opening employee (with all leading alpha characters removed)
Q
 GLD_ACPT_LVL_1

 Res-27 of RA-res-no
R
 GLD_ACPT_LVL_2

 Res-A2 of RA-res-no
S
 GLD_ACPT_LVL_3

 Res-A3 of RA-res-no
T
 GLD_ACPT_LVL_4

 Res-A4 of RA-res-no
U
 GLD_ACPT_LVL_5

 Res-A5 of RA-res-no
V
 RES_BOOKED_FPO_IND

 Res-fpo-flag
W
 CDP

 RA CDPID
X
 CDP Name

 RA CDPID name


The file is named: tRLSGLDyyyymmddhhmm.csv and is placed in the RLSGLD subdirectory of CARS+.

User tip: The logic for FPO in this export is different than the corresponding logic in the HTZDRB and HIRDRB.