Before you can activate the Reservation Interface, you must make certain preparations and become familiar with a few operating instructions. If you ordered the reservation interface as part of your new CARS+ installation, some of the following items may have been included with your system. Please check with your sales representative if you have questions.
I. SETUP
A. CARS+ Setup.
1. Security Menu Access
a. Using the "Select Items for Menus" program, create a new Menu Type using the name RESINT. On the second page grant RESINT access to the RESMENU and the Reservation Interface program. You should assign this menu a Menu Type Number so that only a limited number of users can make changes.
b. Using the "Edit User Access File" program, create a new record as follows:
Employee: RESINT
Password: RZMRGX
Menu Type: RESINT
Create Bill-to: N
Work File Path:
RW Initials: RW
Company ID: 00 (or appropriate number)
RW Password:
Fleet access page 2 N
Allow bad cust N
Allow rate edit N
2. Edit Terminal Records.
Enter the "Edit Terminal Records" program. The terminal record for the reservation port must be set up as a "VDT". In addition, enter into Field 4, "CARS+ report printer", the device name or print spooler to be used by the interface program. Unless you dedicate a printer exclusively for reservation interface, you should ALWAYS make use of a print spooler.
3. Class, Location and FOP
The following codes in your data files MUST MATCH the codes used by the Europcar Reservation Center, or have a corresponding res conversion record:
a. Class Codes.
b. Location Codes.
All location codes, both owned and foreign.
c. Rate Codes.
If a conversion record is not found and the Rate Product Code sent in a reservation does not match a Rate Code in the CARS+ Edit Rental Rules/Rates, the Rate Template record REZ-D will be used.
4. Europcar Res Control Record
Using the program, Edit Europcar Res Control Record, configure the system for receiving reservations from Europcar's Reservation Center.
5. Extract Codes
Using the program Edit Extract Codes, map the Option Codes used by Europcar (called Extraction Type Codes) to the corresponding CARS+ Option Codes.
6. Reservation Conversion Records
Reservation conversion records can be set up for Location Codes, Class Codes and Rate Product Codes.
A hierarchy exists within the conversion code records. Records are read in the following sequence:
User Location Type Sequence RZMRGX pickup Location not blank looked for first RZMRGX blank (all Locations) not blank tried next RZMRGX pickup Location blank tried next blank pickup Location not blank tried next blank blank (all Locations) not blank tried next blank blank blank tried last
7. Europcar Unique Forms of Payment Codes
Using the program Customer File Update and the F4 key, create the following unique FOP Codes:8. International Tour (IT) Records
CUST# (FOP Code) Last Name (Description) Customer Type VCHR VOUCHER anything other than C,CC,B,BC,INS or WHL TOUR TOUR anything other than C,CC,B,BC,INS or WHL PROMO PROMO anything other than C,CC,B,BC,INS or WHL
Using the program Edit IT Codes:
a. Set up records for all wholesale customers that issue vouchers as follows;
CARS+ field Enter 1. IT CODE BAC_ACCT_ID 9. TOUR FAMILY "N" 13. CUST # The CARS+ Customer Number of the country to be invoiced for that wholesaler's vouchers
This will be an ISO Country Code and should match the value in the field ORG_ID-BKS_OF28. RETAIL RATE the out of voucher rate 48-56. IT Rate Array (in the lower right corner of the screen) the CARS+ net rate to be used
b. Set up IT records for Europcar and Full Value and Stated Value Vouchers as follows;
| CARS+ field |
Enter |
| 1. IT CODE |
"EC" followed by the ISO Code for the Country in the field
ORG_ID_BKS_OF example: ECUK is for FVVs and SVVs from the United
Kingdom |
| 9. TOUR FAMILY |
"V" |
| 13. CUST # | The CARS+ Customer Number of the country to be invoiced for that wholesaler's vouchers This will be an ISO Country Code and should match the value in the field ORG_ID-BKS_OF |
c. Set up one IT record for Europcar "Prepaid" Vouchers as follows;
| CARS+ field |
Enter |
| 1. IT CODE |
"ECPPD" |
| 9. TOUR FAMILY |
"S" |
| 13. CUST # | The CARS+ Customer Number for "Prepaid" vouchers. This will be the account against which all receivables for this type of transaction will be posted. |
9. Rate Codes
Although, all of the Rate Types described in the chapter Edit Rental Rules and Rates are supported by the CARS+ Reservation, RA Open and RA Close programs, they are NOT all supported by Europcar's International Reservation Center or the Europecar Reservation delivery system. The following chart indicates the rate types that are NOT supported by the Eueopcar res logic. Therefore none of the rez templates nor any Rate Code sent by Europcar should be defined as one of the unsupported types.
RATE TYPE
SUPPORTED
STANDARD Y WEEKEND Y TIERED Y FIXED TIERED Y STEP-TIERED Y HOURLY N CHAUFFEUR HOURLY N PERIOD N CALENDAR DAY N HOTEL CALCULATED N INCLUSIVE Y SEASONAL N RETURN SPECIFIC N PACKAGE N DAILY AVERAGED N
10. Europcar Country Text File
In the CARS+ directorys config directory set up a text file named ECCTRY.txt that will serve as a translation table of the Europcar ORG_ID_BKS_OF country codes to the corresponding ISO Country Code. The format is the Booking code followed by the ISO country Code. For example the booking code for the United Kingdom is "4". The record in ECCTRY.txt should be 4^UK (where ^ is a space).
II. Operations.
All activities are automatic when the interface is operating. That is, reservations are automatically received from the internet and then automatically merged into your Reservation File. A printout of reservations received is generated as each batch is processed.
The Data
The transmission sent by the Europcar Reservation Center is formatted into multiple lines of data. A sample reservation as printed by the Reservation Merge program looks like this:
------------------------------------------------------------------------------
RES_MSG /xmlns=x-schema:res.dtd------------------------------------------------------------------------------
The correspondence between Europcar and CARS+ data fields is outlined on the following pages. Fields followed by an asterisk "*" are either required or validated against data in your files. If Europcar sends a reservation without valid data in one or more of these data fields, the merge program may reject the reservation.
EUROPCAR TO CARS+ CORRESPONDENCE CHART
| Europcar data field | CARS+ data field | Comment |
| RES_NBR |
Res-conf-no* |
|
| RES_STAT |
see comment |
R value is a request. The Europcar control record can be set to create a request res from this incomming status. S value Sold res CF value confirmed request. If a request res is found the status will be set to open, if request res is not found an open res will be created. CC value is a cancel. (Note: On occasion, you might receive a CC record before you receive the original reservation. This will result in a reject.) |
| STA_STN_ID_CHECKOUT |
Res-loc-out* |
|
| PROJ_CO_TMSP |
Res-date-out* |
|
| PROJ_CO_TMSP_HR |
Res-time-out* |
|
| STA_STN_ID_CHECKIN |
Res-loc-in |
|
| PROJ_CI_TMSP |
Res-date-in |
|
| PROJ_CI_TMSP_HR |
Res-time-in |
|
| CTR_CON_ID_RENT |
Res-corp-rate-id |
|
| NO_RT_QUOTE_FLG |
see comment |
A Y value indicates no rate was quoted. the program uses a
default rate set and product code from the Europcar res control record
to do an initial rate/rules lookup |
|
PRC_PROD_INST_CD |
see comment |
The first six characters are written to Res-rq. The program
first attempts to find a res conversion record for the code sent then
tries to do a rate lookup using the produce code if all attempts fail it uses a template code of REZ-D. |
| PRD_PROD_ID |
Res-rate-family |
|
| VCA_CAT_CD_ACTL |
Res-veh-class* |
|
| CHC_VCA_CAT_CD_CHGD |
Res-rt-class |
|
| CRSC_GDS_CD |
Res-resprt-type |
If this field is blank a default value of GW will be written to the Res-resprt-type field |
| PNR_RCD_LOC |
Cust-locator |
|
| FLGT_NBR |
Res-flight-number |
|
| CLR_TEL CLR_TEL_EXT |
Res-local-contact |
|
| VCA_CAT_CD_PRFRD |
Notes line 1 |
|
| VMK_MK_ID_CONTRACTED |
Notes line 1 |
|
| VMD_MOD_ID_CHGD_PRFRD |
Notes line 1 |
|
| MOD_INTNL_DESC |
Notes line 1 |
|
| TVL_RMK |
Notes line 2 |
|
| INSTR_LN1 |
Notes line 3 |
|
| INSTR_LN2 |
Notes line 4 |
|
| INSTR_LN3 |
Notes line 5 |
|
| Renter data |
||
| DRV_DVR_ID |
Res-superres-no Cust-superrez-no |
Used to do customer record lookup of previous renters |
| DVR_SRNM |
Cust-last-name* |
|
| DVR_FRST_NAME |
Cust-first-name |
|
| SEX |
Cust-gender |
|
| DVR_DT_OF_BRTH |
Cust-birth-date |
|
| ADDR_LN1 |
Cust-st-2 |
|
| ADDR_LN2 |
Cust-st-1 |
|
| CIT |
Cust-city |
|
| CRY_ARIMP_CRY_CD |
Cust-state |
|
| POST_CD |
Cust-zip-cod |
|
| LIC_NBR |
Cust-dl-number |
|
| EXP_DT |
Cust-dl-expire-date |
|
| CRY_ARIMP_CRY_CD_ISS |
Cust-dl-state |
|
| NBR |
Cust-phone-no Res-phone-no |
|
| DRIVER_ID | The Europcar control record can be set to use this as the reservations CDPID instead of the CTR_CON_ID_RENT field value | |
| Vendor data |
||
| IATA_EC_IATA_NBR |
Res-vend-no Vend-no |
|
| LGL_NAME |
Vend-nam |
|
| ADDR_LN1 |
Vend-adrs-1 |
|
| ADDR_LN2 |
Vend-adrs-2 |
|
| CIT |
Vend-1099-city |
|
| POST_CD |
Vend-1099-1099-zipcode |
|
| ORG_ID |
Vend-orig-id |
|
| PLAN_ID |
Vend-comm-plan |
|
| Charge data |
||
| Rut_cd |
see comment |
If Rut_cd is missing the the field cluster for a rental charge, it is assumed that the rate is a daily rate. |
| If RUT_CD= "P" for RCT_CHG_TYP = "00001" |
Reschg-primary-rate for TIME |
The CHG_AMT for RCT_CHG_TYP 00001 will be added to the CHG_AMT
of RCT_CHG_TYP 00052. The sum will be divided by the anticipated rental days to arrive as a daily rate |
| Res-rate-family |
This field if not blank will be used to look up the vendor commission percent rather than using the Res-rte-prod. |
|
| Method of payments |
The method of payment array in the reservation allows for three FOPs. Any may be a voucher (there cannot be more than one voucher on a single reservation) a credit card or a Europcar charge card. For each field mentioned below there is a second and third field with the same name but the extension "_SECDRY" and "_SECDRY_THIRD". All sets of fields are tested for the existence of a voucher. | |
| MPT_MOP_TYP_CD |
see comment |
This field defines the payment type. CC=credit card, VCH=voucher, EP=Europcar charge card |
| MOP_MOP_CD_PTNTLY |
see comment |
This field contains the credit card or voucher type |
| Credit card data |
||
| CR_CARD_NBR |
Res-fop-no |
|
| CR_CARD_EXP_DT |
Res-fop-expire-date |
|
| Europcar charge card |
Europcar charge cards create FVV type vouchers |
|
| Vouchers |
||
| If IND-ISS-TYP-ECV-LIB = "E VOUCHER" |
The following are the fields that are up dated by an E voucher
(Europcar term for voucherless voucher). If the res has an e-voucher
but any of the fields listed below are missing, the reservation will not be rejected and a note with the voucher information will be created. |
|
| MOP_MOP_CD_PTNTLY |
EVT and ETO values, these are traditional S subwindow voucherless tour voucher EOTTO and CFG values, these are FVV type vouchers EXO value is a SVV type voucher |
|
| EXTNL-VCHR-ID |
Vchval-no |
|
| VCA-CAR-CD-VCHR |
Vchval-class |
|
| VCHR-DAYS |
Vchval-days |
|
| BAC-ACCT-ID |
Vchval-it-no |
This will be used to look up the proper net prices from the IT-rate array |
| Vchval-cus-no | It-cus-no | |
| BAC-ACCT-ID | Vchval-bill-acct | |
| if VCHR-VAL = "FULL CREDIT" or VCHR-FULL-CR-IND = "Y" |
This is a FVV |
|
| Dep-pc-it-no |
This is made up of the characters "EC" plus the ICO country code in the ECCTRY.txt file for the value in ORG-ID-BKS-OF |
|
| BAC-ACCT-ID |
Dep-voucher |
|
| EXTRNL-VCHR-ID |
Res-hidden-notes |
|
| Dep-res |
Res-no |
|
| Dep-fop |
It-cus-no |
|
| Dep-auth-amt |
"99999 |
|
| Dep-promo-type |
It-family |
|
| Dep-type |
"P" |
|
| Dep-amt |
"0" |
|
| If IND-ISS-TYP-ECV-LIB = anything other than "E VOUCHER" |
This is NOT a voucherless voucher |
|
| Vchval-no |
blank (thus making this an incomplete voucher) |
|
| VCA-CAT-CD-VCHR |
Vchval-class |
|
| VCHR-DAYS |
Vchval-days |
|
| BAC-ACCT-ID |
Vchval-it-no |
This and the class will be used to look up the proper CARS+ net rate |
| Vchval-cus-no |
It-cus-no |
|
| BAC-ACCT-ID |
Vchval-bill-acct |
|
| if VCHR-VAL = "FULL CREDIT" or VCHR-FULL-CR-IND = "Y" | No voucher is created for the reservation. The renter is
required to present the voucher at the time of open. Voucher related
data will be written to the visible reservation notes file |
|
| Delivery and Collection data |
||
| CNTCT_DEL_COL_FLG |
see comment |
field value indicates if this is Delivery or Collection data, DEL=Delivery, COL=Collection |
| TMSP_FOR_DLVR_COLL |
Date |
|
| TMSP_FOR_DLVR_COLL_HR |
Time |
|
| ADDR_LN1 |
Build-no |
|
| ADDR_LN2 |
Street |
|
| ADDR_LN3 |
Locality |
|
| ADDR_LN4 |
Town |
|
| ADDR_LN5 |
Country |
|
| POST_CD |
Zip |
|
| TEL_NBR |
Phone-no |
|
| INSTR_LN1 INSTR_LN2 |
Notes |
|
| Stopsell indicators |
||
| VHCL_GRP_STOPSL_OVRD |
see comment |
a Y value in this field indicates that the vehicle class is in a stopsell status for this location and the reservation will be rejected. This can be overridden by a setting in the Europcar control record |
| STN_STOPSL_OVRD_FLG |
see comment | a Y value in this field indicates that this location is in a
stopsell status and the reservation will be rejected. This can be
overridden by a setting in the Europcar control record |
| PROD_STOPSL_OVRD_FLG |
see comment | a Y valud in this field indicates that this rate product is in a stopsell status and the reservation will be rejected. This can be
overridden by a setting in the Europcar control record |
| STN_SCHED_OVRD_FLG |
see comment | a Y value in this field indicates a schedual stopsell status and the reservation will be rejected. This can be overridden by a setting
in the Europcar control record |
Any other data sent by Europcar will print on the Interface Report but will be ignored by the merge program.
Receive Program
The receive program captures and stores data, and initiates other processing. This program should not be terminated while a transmission is in progress because one or more lines of data may be lost. Also data just received will not be processed.
With each transmission a temporary batch file is created. When the receive program senses that transmission is completed (indicated by a 1 minute pause), the merge program is called to process the batch. The receive program is suspended until this is completed. Data which arrives while the receive program is suspended is buffered and held under control of the operating system. The receive program adds a "date stamp" line at the start of each batch.
Merge Program and Report
The merge program adds, modifies, or cancels reservations, vendors and customers as requested, and prints a report of all activity. The program executes as if it were a CARS+ employee on the same port as the modem and thus requires a CARS+ terminal record with an employee name of "RESINT" and a password of "RZMRG7" (see the section on set-up earlier in this chapter).
The printed report shows data as received along with notes to explain what kind of updates were made to the database and to indicate invalid or modified data fields. At the end of the report is a summary of the number of reservations in the batch, the number rejected, added, modified, and cancelled.
For each rejected reservation, the report gives 2 types of information.
1. Actual data received.
2. Error messages and comments concerning individual data fields.
Reservation Error Messages
There are two kinds of errors that result in the rejection of a reservation. The first is missing or invalid data. The following are reasons why a reservation may be rejected due to a data problem:
Data error Comment Rct_chg_typ = 00001 and Rut-cd if present is NOT = "D" or "P"
The reservation will be rejected
For any other Rct-chg-Type:
if Rut_cd = "C" and the corresponding CARS+ calc method in OPTRTE is NOT "P"
if Rut_cd = "R" and the corresponding CARS+ calc method in OPTRTE is NOT "F"
if Rut_cd = "D" and the corresponding CARS+ calc method in OPTRTE is NOT "D"
The reservation will be rejected.
Any other data sent by Europcar will print on the Interface Report but will be ignored by the merge program.
Notes on Usage and System Requirements
When reservations are rejected due to invalid data, it is suggested that you enter the information manually via the Reservation Update program. When a number of reservations are rejected, you should ask Europcar to retransmit them. There is no harm to receiving reservations already accepted because CARS+ will automatically reject duplicates.
The entire reservation interface process (receive and merge programs) will require about the same amount of memory as one active user.