This chapter provides instructions for using the CARS+ interface to receive reservations from the Sixt International Reservation Center. Simply stated, the process works as follows:

1. CARS+ generates an XML request to Sixt for a list of all reservations that have either been created or edited since the last request was made.
2. Sixt responds with a list of all appropriate Reservation IDs.

For each reservation ID received:
1. CARS+ generates another XML request to Sixt containing the ID of the reservation desired.
2. Sixt responds with an XML transmission of the detailed reservation data.
3. When CARS+ receives that XML message, it is placed it in a batch file. This data is then merged into the CARS+ Reservation file along with all other reservations. A report of the data received and its disposition is automatically generated so that a complete audit trail is maintained.

Before the Reservation Interface can be activated, certain preparations must be made, and you must 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 Thermeon Customer Support 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:       	RZMRGS
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. Vehicle Class and Location Codes

The following codes in your data files MUST MATCH the codes used by the Sixt Reservation Center, or have a corresponding res conversion record (see comment 6 below):

a. Class Codes.

b. Location Codes.

All location codes, both owned and foreign.

4. Rate Codes

Sixt has the following two rate related codes in a reservation:

Rate Code: This 8-character code is NOT identical to the CARS+ Rate Product Code. It does NOT convey the rules as to how the Time charges are to be calculated. The Sixt Rate Code code is stored in both the reservation and the resulting RA, but it is NOT used as the CARS+ Rate Product. CARS+ may use it to do rate look-ups as described below. It may also be used at times in the CDPID logic (see the CDPID discussion below).

User tip: The Sixt 8-character rate code is displayed in the D subwindow of Reservations in the "Quoted Rate" field.

Rate Plan: This 2-character numeric code does correspond to a CARS+ Rate Product Code, in that it does convey rate calculation rules such as if the rate is a daily rate, weekend rate, package rate, etc. Within CARS+ this is an attribute of a Rate Product -- not a separate fact applied to a rate.

As of the time of this writing, the following Sixt Rate Plan Codes are recognized by CARS+:

Sixt Plan Code*	Description	Set Up Rate Rule as follows in CARS+	Free Miles per day	Notes	Set up prices as follows**
1	for 1-4 days ***	Standard rate	unlimited		in daily column only
11	for 1-4 days	Standard rate	200km		in daily column only
12	for 1-4 days	Standard rate	300km		in daily column only
2	for 5-27 days	Package rate	unlimited		in daily column only
21	for 5-27 days	Package rate	200km		in daily column only
22	for 5-27 days	Package rate	300km		in daily column only
41	for 28+ days	Standard rate with 28 the Days per Month (Page 1 Field 29a) and the Type set to "C" (page 1 Field 29b)	a monthly allowance		a local rate in Daily and Xday columns
42	for 28+ days	unknown at this time	unknown		unknown
3	short weekend- cars	Weekend rate (Friday noon to Monday 9am - max 3 days)	unlimited		a local rate in daily column
31	short weekend- cars	Weekend rate (Friday noon to Monday 9am - max 3 days)	200km		a local rate in daily column
32	short weekend- cars	Weekend rate (Friday noon to Monday 9am - max 3 days)	300km		a local rate in daily column
6	long weekend - cars	Weekend Rate (Thursday noon to Tuesday 9am - max 4 days)	unlimited		a local rate in daily column
61	long weekend - cars	Weekend Rate (Thursday noon to Tuesday 9am - max 4 days)	200km		a local rate in daily column
62	long weekend - cars	Weekend Rate (Thursday noon to Tuesday 9am - max 4 days)	300km		a local rate in daily column
9	short weekend- trucks	Weekend rate (Saturday 1am to Monday 9am - max 3 days)	Unlimited		a local rate in daily column
91	short weekend- trucks	Weekend rate (Saturday 1am to Monday 9am - max 3 days)	200km		a local rate in daily column
92	short weekend- trucks	Weekend rate (Saturday 1am to Monday 9am - max 3 days)	300km		a local rate in daily column
5	long weekend - trucks	Weekend rate (Friday 1am to Monday 9am - max 4 days)	unlimited		a local rate in daily column
51	long weekend - trucks	Weekend rate (Friday 1am to Monday 9am - max 4 days)	200km		a local rate in daily column
52	long weekend - trucks	Weekend rate (Friday 1am to Monday 9am - max 4 days)	300km		a local rate in daily column

* The Rate Plan Codes in bold are the "Standard Plan Numbers" used by Sixt. The others are referred to as "Optional" plans and may or may not be used by individual licensees.

** Sixt does NOT always send all the TIME prices that CARS+ requires to do a rental. Sixt sends either a single rate or a calculated time charge for the anticipated rental length. CARS+ uses whatever is sent to it by Sixt. The set up instructions for rates in the chart above are to add to the rates sent so as to have the full rate structure that CARS+ requires. As long as the vehicle is kept for the reserved time, the renter will be charged what Sixt quoted. But should the renter return early or extend the rental, the extra local prices will be used to calculate the difference.

***Rate Plan 1 is normally a daily rate for 1 to 4 days. On occasion, however, Sixt sends it as a package rate for reservations that are more than 4 days. In this case, the package rate is divided by the number of days in order to calculate a daily rate.

4a. Rate Templates

The following Rate Product Codes must be set up in the Edit Rentals Rules and Rates program as rate templates. The Rate Product Code in CARS+ for templates is made up of the following:

Sixt Rate Plan followed by the Currency Code Sixt has sent the rate in. This is required even if the operation works in a single currency.

As an example, an operation that receives reservations both in Mexican Pesos and US Dollars would need Rate Product Template Codes:
1MXP, 1USD, 2MXP, 2USD, 41MXP, 41USD, etc.

4b. Mapping Sixt Rate Codes to CARS+ Rate Product Codes for Inclusive Rates

Because the Sixt Rate Code and Rate Plan together communicate what CARS+ has in it's Rate Product Code, a conversion record can be set up in CARS+ to map a Sixt Rate Code and Sixt Rate Plan to a corresponding Rate Product Code. This is not necessary for every rate, but it IS required when the rate is inclusive.

Mapping is done through the use of the program Edit Sixt Rate Plans. For example, the following record maps the Sixt Rate Code MX7LL000 when sent with Sixt Rate Plan 01 to the CARS+ Rate Product OWS:

OPTION: __ EDIT SIXT RATE PLANS 1 Rate Code MX7LL000 2 Rate Plan 1 3 CARS+ Rate Prod OWS 1SAVE 2NEXT 3ERASE 4DELETE 5BACKUP 6 7HELP 8

If this same Sixt Rate Code (MX7LL000) can be sent for a weekend rental with Rate Plan Code 03, a second record will be required as follows:

OPTION: __ EDIT SIXT RATE PLANS 1 Rate Code MX7LL000 2 Rate Plan 3 3 CARS+ Rate Prod OWSWKND 1SAVE 2NEXT 3ERASE 4DELETE 5BACKUP 6 7HELP 8

This is because within CARS+, a rate can either be defined as a standard day/week/month rate or it can be a weekend rate. It cannot be both.

As a general rule: Rate Plans that involve a uncalculated daily, weekly or monthly prices should be mapped to a standard rate, while Plans that involve a pre-calculated charge should be mapped to a package rate.

Sixt has thousands of Rate Codes and if each Code can be sent with each of the five Standard Plan Numbers, that would require over 5,000 records within this mapping table. Fortunately, as mentioned above, that is not required. The only required piece of data that CARS+ needs that is NOT sent in the reservation is a list of Options that are included in the daily rate. Within CARS+ that is defined by the Inclusive Option Set Code on the rate product record. No similar code exists in a Sixt reservation. As a result, only those Sixt Rate Codes that involve included items need to be mapped to a CARS+ Rate Product Code. All other Sixt Rate Codes can make use of the Rate Product Templates in the CARS+ Rate File.

5c. How Rates are looked up by the merge program

When receiving a new reservation from Sixt, the reservation interface program will first check if the Sixt Rate Code and Sixt Rate Plan map to a CARS+ Rate Product in Edit Sixt Rate Plans. If a map is found, that CARS+ rate will be used. If a mapping record is not found, the program will combine the Sixt Rate Plan and the Currency Code sent and look for a template record in Edit Rental Rules and Rates. If a match is found, the template rules record will be used along with the prices sent in the reservation. If a template cannot be found, the reservation will be rejected. This is true of both tour net rates and retail rates.

RATE TYPES THAT ARE NOT SUPPORTED BY THE SIXT RESERVATION FEED

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 Sixt's International Reservation Center or the Sixt Reservation delivery system. The following chart indicates the rate types that are NOT supported by the Sixt res logic. Therefore none of the rez templates nor any Rate Code sent by Germany 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	Y
DAILY AVERAGED	N

5. CDPID Codes

To understand how to set up CDPID records in CARS+, you must understand how CARS+ looks up CDPID Codes when merging in a SIXT reservation.

a. CARS+ attempts to find a record in the Corporate Accounts file that matches the value in the XML schema element reservation/payment/corpNo. If a match is found, the value in the corpNo field is stored in the reservation as the CDPID, and the transaction will receive the rights and privileges associated with that corporate account. Additionally the Source Code in the Corporate Account record is used as the Source Code on the reservation.

b. If a Corporate Account cannot be found, the program will use the Sixt Rate Code (ie MXSIE000) and attempt to find a matching record in the Corporate Contract file (Contract not Account file). If a match is found:

• A new Corporate Account record will be created using reservation/payment/corpNo as the CDPID number and the Sixt Rate Code from the reservation as the Contract number. The corpNo will also be stored as the "name" of the account as no name is supplied by the reservation feed.
  
• The resulting Corporate Account number will be written to the reservation as the CDPID number.

c. If the corpNo cannot be found in the Corporate Account file and the Sixt Rate Code cannot be found in the Corporate Contract file, the value in Reservation/payment/corpNo will be ignored, but the reservation will be merged into the CARS+ Reservation file.

Set-Up Steps:

a. Set up Corporate Accounts and Corporate Contracts for those Sixt corpNo's that should be offered unique privileges that are different than those of the average corporate rental.

b. Set up Corporate Contracts for the Sixt Rate Codes that should be granted privileges in CARS+. For example, in Mexico 99% of the corporate rentals come with Sixt Rate Code MXXEU000. Setting this up as a Corporate Contract and assigning it the common Privilege Codes will grant all accounts with that Rate Code the same privileges.

CDPID Hierarchy:

CARS+ uses the following hierarchy when assigning a CDPID# to a reservation.

• If the res has a validated value in the element reservation/payment/corpNo, it is used.
• If the res has a value in reservation/payment/corpNo that cannot be validated against the Corporate Accounts file, it will attempt to make one from the value here and the Rate Code.
• If none of the above are true and the reservation has a voucher, any CDPID# assigned to the voucher issuer's IT record will be used.
• As a last resort, any CDPID # assigned to the Reservation Source Code used will be applied to the reservation.

Inclusive Corporate Rates

If corporate rates are inclusive of options other than Time:

• Set up a Privilege Code that grants the options at no charge
• Assign that Privilege Code to the Corporate Contract created from the Sixt Rate Code.

This will:

• Prevent Counter Agents from selling Options that are included.
• But unlike inclusive items on Net Tour Rates, NO revenue will be extracted from the Time revenue for these included items.

6. Source Codes

The Source Code on a reservation can come from 3 places:

a. If there is a CDPID on the reservation (see section above) and the Corporate Account has a Source Code, that code is used. This includes reservations that use IT Codes when the IT Code refers to a Corporate Account with a Source Code.

b. If there is no Source Code from a CDPID, the Source Code for the Sixt rate in Edit Sixt Rate Plans is used.

c. If there is not a Source Code from Edit Sixt Rate Plans, the 3 middle characters of the Sixt Rate Code are used as the Source Code. For example, the Sixt Rate MX5LL000 would use 5LL as the Source Code.

User tip: Use the program Edit Source Groups to create 'groups' of Source Codes for reporting purposes.

7. Extra Codes

Using the program Edit Res Option Conversion Codes map the Option Codes used by Sixt (called "Extra Codes") to the corresponding CARS+ Option Codes.

8. Reservation Conversion Records

Reservation conversion records can also be set up for Location Codes and Class Codes using the program Edit Conversion Records if the codes you currently use do not match those used by Sixt.

9. Voucher Issuers

Sixt reservations can contain the following three types of tour vouchers:

• Prepaid = For these vouchers, Sixt in Germany has already collected the funds for the voucher at the time the reservation was created. As such, Sixt's headquarters in Germany is invoiced for the voucher value.
• Central Billed = Although Germany has not been prepaid for these vouchers, they will invoice the tour operator for the voucher value from the headquarters in Germany. As a result, vouchers of these type are also billed against Sixt in Germany by the licensee.
• Direct Bill = These are the least frequent of the three voucher types. In this case, although the reservation is booked through Sixt in Germany, it is the responsibility of the individual licensee to invoice the tour operator directly for the voucher value. Sixt in Germany is NOT involved in the voucher invoicing at all.

Using the program Edit IT Codes, set up three kind of records:

a. Set up a single record for all prepaid vouchers for which you will invoice Sixt in Germany (this code will be placed in the Pre-Paid IT field of Edit Sixt Res Control record):

CARS+ Field	Enter
1. IT CODE	any code that you wish to represent Sixt in Germany
9. TOUR FAMILY	"S"
13. CUST #	The CARS+ Customer Number of Sixt in Germany to be invoiced for these vouchers
15. CDPID	This field is optional and can be used to have a particular Source Code used for reservations with this IT Code. Set up a Corporate Account record with the Source Code and enter the CDPID number in this field.
28. RETAIL RATE	the out of voucher rate
48-56. IT Rate Array (in the lower right corner of the screen)	Note: these fields are NOT used, the value of the voucher is sent pre-calculated by Sixt in the reservation.

b. Set up a single record for all Central Billed vouchers for which you will invoice Sixt in Germany (this code will be placed in the Wholesale Voucher IT field of Edit Sixt Res Control record):

CARS+ Field	Enter
1. IT CODE	any code that you wish to represent Central Billed Vouchers (it cannot be the same code used for Pre-paid above)
9. TOUR FAMILY	"T"
13. CUST #	The CARS+ Customer Number of the tour operator to be invoiced for these vouchers (this Customer must be assigned Customer Type "WHL").
15. CDPID	This field is optional and can be used to have a particular Source Code used for reservations with this IT Code. Set up a Corporate Account record with the Source Code and enter the CDPID number in this field.
28. RETAIL RATE	the out of voucher rate
48-56. IT Rate Array (in the lower right corner of the screen)	these fields are NOT used, the value of the voucher is sent pre-calculated by Sixt in the reservation.
Page 2 Field 8 GROSS MARKUP %	This optional field makes the daily out of voucher rate an amount marked up from the voucher net rate by the percentage entered here. For example entering 10 here will cause the out of voucher rate on a $50.00 per day voucher to be $55.00. This does NOT replace the need for entering a Rate Product Code in field 28 on page one. When this field is used, the "Rules" associated with the Rate Code in field 28 are used along with the grossed up retail rate produced by this field.

c. Set up records for each individual wholesale customer that issues vouchers which must be invoiced directly by your operation:

CARS+ Field	Enter
1. IT CODE	Agency Number of the tour operator as used by Sixt in the reservations
9. TOUR FAMILY	"T"
13. CUST #	The CARS+ Customer Number of the tour operator to be invoiced for these vouchers (this Customer must be assigned Customer Type "WHL").
15. CDPID	This field is optional and can be used to have a particular Source Code used for reservations with this IT Code. Set up a Corporate Account record with the Source Code and enter the CDPID number in this field.
28. RETAIL RATE	the out of voucher rate
48-56. IT Rate Array (in the lower right corner of the screen)	these fields are NOT used, the value of the voucher is sent pre-calculated by Sixt in the reservation.
Page 2 Field 8 GROSS MARKUP %	This optional field makes the daily out of voucher rate a an amount marked up from the voucher net rate by the percentage entered here. For example entering 10 here will cause the out of voucher rate on a $50..0 per day voucher to be $55.00. This does NOT replace the need for entering a Rate Product Code in field 28 on page one. When this field is used, the "Rules" associated with the Rate Code in field 28 are used along with the grossed up retail rate produced by this field.

Inclusive vouchers: Unlike other types of IT tour operators, Sixt tour operators are NOT set up with any indication as to what is included in the voucher in the IT record. Whatever may be included is indicated in the reservation data sent by Germany.

A Conversion Record can be created to reference an Option Set that is made up of inclusive items. The following example is for the Sixt rate code 'MX67M000". The characters in positions 3, 4, and 5 (67M) are entered in the "Convert From" field. Note that the Convert Type (Field 4) is "OS" (Option Set). The Option Set made up of the inclusive items is entered in Field 6 (OWS). This is for vouchers only; not retail reservations.

OPTION: __ EDIT CONVERSION RECORDS 1 User 2 Location 3 Convert From 67M 4 Convert Type OS 5 Eff Date 01-01-15 6 Convert To OWS 7 Comment WS-BROKER 1SAVE 2NEXT 3ERASE 4DELETE 5BACKUP 6 7HELP 8

If no Option Set conversion is found, the program will read through all existing Option Sets in the Option Set file in an attempt to find an existing Option Set that includes the items marked as included and a second Option Set for those items marked as exempt in the reservation. If no match is found, a new Option Set will automatically be set up by the interface program. Both the inclusive and exempt Option Set Codes are stored in the CARS+ reservation record.

NOTE: Because the net rates and the indication of inclusivity cannot be set up in the IT file but rather are indicated in the reservation data from Germany, walkup tour vouchers cannot be supported in CARS+ for these accounts.

Currency Conversion: Voucher revenue is converted to domestic currency when the reservation being merged into CARS+. The exchange rate in effect at that time is used.

Prepaid Amount: A note is added to the Reservation showing the total of the prepaid amount. This is the time charge for the voucher plus the tax.

10. Sixt Res Control File Record. Reservations in the COBRA Reservation System in Germany are sorted by the pick-up location's country. A separate record must exist in this file for each country in which you have renting locations. For an example, if you rent cars both in Australia and New Zealand, a record for each of these countries must be set up. Enter the 2 character Country Code for the country whose reservations are to be requested from COBRA. After the IT records are set up, set up the Sixt Control Record using the program Edit Sixt Res Control Record. Use the IT records that were set up in steps 8a and 8b above. This screen is also used to define the A/R Customer account that is used for Sixt Corporate Charge Cards.

11. Edit Res Check Source Record. When setting up a new client, the first time the interface is run from cron, it will attempt to download every reservation posted since the start of time. Consequently, it may be desirable to set a start date whereby the interface will download only those reservations posted on that date or later. This is done through the program Edit Res Check Source Records. Program name is EDTRZS.

The screen will then display:

OPTION: __ EDIT RZCHK SOURCE RECORDS 1 Source ID 2 Source Name 3 Highest Batch # 4 Processed Last Batch 1SAVE 2NEXT 3ERASE 4DELETE 5BACKUP 6 7HELP 8

Enter data as follows:

1. SOURCE ID	Enter the characters "SX" for Sixt. EXAMPLE: Type SX (RET)
2, SOURCE NAME	Enter any appropriate description. EXAMPLE: Type SIXT RES INTERFACE (RET)
3. HIGHEST BATCH #	This field is not used on the Sixt res Interface program.
4. PROCESSED LAST MATCH	In a working system, this field will contain the date and time of the last time the interface program was run. The next time the program is run, it will request from Sixt all reservations that have either been booked or edited since this date and time. When turning on the Sixt Res Interface for the first time, enter the date and time of the oldest reservation that should be sent. For example, entering the date October 1st 2013 will cause the first time the program is run to request all reservations that were created or edited since the first of October up though the present date and time. EXAMPLE: Type 100113 0000 (RET)

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 report of reservations received is generated as each batch is processed.

The Data

The transmission sent by the Sixt Reservation Center is formatted into multiple lines of data. Here is a sample reservation as printed by the Reservation Merge program:

------------------------------------------------------------------------------

  
    
      
        9003454378
        VIECO315Y
        
        
        RS
        
        de_DE
        CDAR
        32
        32
        false
        false
        
        
        FC-Voucher 6219-85314 (BN) by mail to
        ap1406 and the TA. (Kerstin Wellert, 17.01.2013,
        20:34:00)
        06201193
        
        517848
        
        MU0737
        
        
          AUXEU000
          41
          0
          false
        
        
          20130121
          1000
          
            1406
            Melbourne Airport
          
        
        
          20130222
          1000
          
            1406
            Melbourne Airport
          
        
        
        
        
          
          
          
            33331
            
            
            
          
          
          AMORT
          BERNHARD
          
            
            
            
            
            AT
          
        
        
        
          T
          Rental days
          1
          1
          
            AUD
            877.76
            10
          
        
        
          X
          Extra days
          1
          4
          
            AUD
            31.35
            10
          
        
        
          U
          Registration fee / Road tax
          1
          32
          
            AUD
            5.5
            10
          
        
        
          Y
          Premium location fee
          1
          1
          
            AUD
            240.75
            10
          
        
        
          
            CUSTOMER
            0
            0
          
          
            MANUAL
            0
            0
          
          141.99
          AUD
          1419.91
          10
        
        
          CC
          902885
          
          
          
            
            0
          
          
            
            0
          
        
        
          KNORR-BREMSE DIVISION IFE GMBH
          KBIFE RAIL WAIDHOFEN A
          
            33.A STRASSE 1
            3331
            KEMATEN AN DER YBBS
            
            AT
          
        
        
        
        
      
    
  

------------------------------------------------------------------------------

The correspondence between Sixt 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 Sixt sends a reservation without valid data in one or more of these data fields, the merge program may reject the reservation.

SIXT TO CARS+ CORRESPONDENCE CHART

The first column contains the XML schema element name, the second contains the corresponding CARS+ field name to which the data is written. The final column contains the field code for the same data in Sixt's old reservation delivery format done with a comma delimited emailed message.

Sixt field	CARS+ field	Notes	CSV field
reservationNo	res-conf-no	This is also the batch number of the raw reservation data. This batch number can be used to manually re-merge this reservation into the system.	mvnr
securityCode	Res hidden notes	must be stored and returned to Sixt	extr
reference1	Res-po-no	order number external	ordn
reference2		order number external	secr
Status	Res-status	Status-Definition=CARS+ Status OF-offer= R, RQ-request=R, DEN-request denied=C, CNL-cancel=C, RS-reservation=O, NS-noshow=CARS+ flags reservations as No Show we do not accept this designation from Germany, therefore these records are ignored RA-rental agmt= nothing comparable in CARS+, these also are ignored	star
revision		correction for RA#	konr
language			spra
group	Res-veh-class, Res-rt-class	Acriss vehicle class	grp
duration			tage
voucherDays	Vchval-days		vot
isLongterm			long
hasOwnInsurance			coi
vipStatus	Cust-type of renter	VIP status of renter	vip
customerRemark			bem
stationRemark	Ntsfil-text for reservation		bem2
iataNo1	Res-vend-no		iata
iataNo2		Presently ignored	iata2
agencyNo1	Vchval-it	This is the Sixt code for the issuer of a tour voucher. This field is validated against the IT file. If a record cannot be found, the default voucher IT from the Sixt Res Control record is used and this code will be written to the Booking Reference field.	age
agencyNo2		Presently ignored	age2
flightNo	Res-flight-gate-no		flnr
bonusProgramNo		Bonus program number frequent flier number	idnr
forbiddenChargeCode		list of forbidden charge codes	forb
rate - elements
code	Res-rq-code	This is an 8 char field, we will store the whole 8 char in Res-rq-code so that it can be reported back to Germany but this is NOT the code CARS+ uses for the rental rate. This field may also be used in the CARS+ CDPID logic. See the notes under CDPID earlier in this chapter, for the alternate use of this field.	prl
plan	part of Res-rte-prod	This along with a currency code is used as the Rate Product Code template within CARS+ if the Sixt Rate Code has NOT been mapped to a CARS+ Rate Product. Again see the full discussion on Rate Codes in the Set-up section of this chapter.	pln
rebate			rebate
isPrepaid			prepaid
pickup - elements
date	Res-date-out	YYYYMMDD	uda
time	Res-time-out	HHMM	uti
station - elements
stationID	Res-loc-out	2 char numeric	uci
name			ucn
return - elements
date	Res-date-in	YYYYMMDD	rda
time	Res-time-in	HHMM	rti
station - elements
stationID	Res-loc-in	2 char numeric	rci
name			rcn
delivery - elements		delivery address
name1			dln1
name2			dln2
address - elements
street	Delcol-street		dlst
zipCode	Delcol-zip		dlpl
city	Delcol-city		dlor
state	Delcol-state		dlbl
country	Delcol-ctry		dlla
collection - elements		collection address
name1			con1
name2			con2
address - elements
street	Delcol-street		cost
zipCode	Delcol-zip		copl
city	Delcol-city		coor
state	Delcol-state		cobl
country	Delcol-ctry		cola
firstDriver - elements		renter
birthday	Cust-birth-date	YYYYMMDD	birth
passportNo	Cust-fed-id		rpn
contact - elements
phone	Cust-phone		tel
mobile	Cust-cell		mobile
email	Cust-email		emai
fax			fax
license - elements
licenseNo	Cust-dl-no		fsn
date	Cust-dl-exp-date	YYYYMMDD	fsd
city			fso
country	Cust-dl-state		fsc
name1	Cust-last-name, Res-last-name		nam1
name2	Cust-first-name, res-first-name		nam2
address - elements
street	Cust-st-2		str
zipCode	Cust-zip-cod		plz
city	Cust-city		ort
state	Cust-state
country			land
secondDriver - elements
birthday			birth-2
passportNo			rpn-2
contact - elements
phone			tel-2
mobile			mobile-2
email			emai-2
fax			fax-2
license - elements
licenseNo			fsn-2
date			fsd-2
city			fso-2
country			fsc-2
name1			nam1-2
name2			nam2-2
address - elements
street			str-2
zipCode			plz-2
city			ort-2
state
country			land-2
extra - elements		list of reserved items. For retail reservations these are the reserved items with their corresponding retail rate. For voucher reservations, these are the items that are included in the voucher and the rates are the net rates. For voucher reservations any out of voucher items that were reserved will be in the split/extra elements which appear later in this record layout.
code	Reschrg-opt-code	2 letter option code
name
booked	Reschrg-object-qty	quanity reserved (normally 1)
charged		days charged - if "1" and duration is greater then this is a flat fee charge
price - elements
currency
netAmount	Reschrg-primary-rate	either the daily rate of the package charge
vatPercent
insurance - elements		list of insurances
code	Reschrg-opt-code	2 letter option code
name
booked	Reschrg-object-qty	quanity reserved (normally 1)
charged		days charged - if "1" and duration is greater then this is a flat fee charge
price - elements
currency
netAmount	Reschrg-primary-rate	daily rate
vatpercent
total
discount - elements		list of discounts
reason		reason for this discount either: CUSTOMER or MANUAL
amount	Res-disc-amt	discount amount	nlb
percent	Res-disc-pct	discount percent	nlp
discount
vatAmount			stb
currency			wakz
netAmount		for rentals with vouchers, this is the voucher amount, it is written to Res Notes	vto
vatPercent			stp
payment - elements
type	Res-notes	2 letter FOP code If the value is "CC" the phase "SIXT CORPORATE CARD" will be written to the notes field of the Reservation main window (the actual card number is not sent in the reservation feed).	zah
corpNo	Res-cdpid	This is the primary field within the record for a Corporate Discount Code. If code here cannot be validated against the Corporate Account file, the value in the Rate Code field is used along with this code to create new CDPID records in CARS+. See the discussion on CDPID set up earlier in this chapter.	kdnr
expressNo	Res-superrez-no	This is the Other ID field of the Customer record. CARS+ will use this value to see if this renter has rented previously and if so, load their previous CARS+ Customer record into the reservation.	mnum
taxNo			stnr
pickupNative Currency
currency		currency code	hewa
exchangeRate			ank
ccNativeCurrency
currency		currency code	hwkz
exchangeRate			hkur
invoice - elements
name1			nam1_invoi
name2			nam2_invoi
address - elements
street			str_invoi
zipCode			plz_invoi
city			ort_invoi
state
country			land_invoi
split		if this element exists, the reservation is a net tour reservation. The options and rates in the previous fields are the net rates for the voucher included items. The items in the extra elements below are the out of voucher items that the renter will pay for outside the voucher.
type		split type
extra - elements		list of extras paid by the customer
code		2 letter option code
name
booked		quanity reserved (normally 1)
charged		days charged
price - elements
currency
netAmount		daily rate
vatPercent
insurance - elements		ins paid for by customer
code	Reschrg-opt-code	2 letter option code
name
booked	Reschrg-object-qty	quanity reserved (normally 1)
charged		days charged - if "1" and duration is greater then this is a flat fee charge
price - elements
currency
netAmount	Reschrg-primary-rate	daily rate
vatPercent
total		total price to be paid by customer
discount - elements		List of discounts
reason		CUSTOMER MANUAL
amount			nlb
percent	Reschg-primary-rate of the option DISC		nlp
vatAmount		calculated GST amount
curency
netAmount		RA total less GST
vatPercent		GST percentage
payment - elements
type		If "FC" a FVV (full value voucher) is written and charged to the same account as Prepaid IT.
corpNo
expressNo	Cust-superrez-no of renter. Xrefil-to of C/C record
taxNo
pickupNativeCurrency
currency
exchangeRate
ccnativeCurrency
currency
exchangeRate
invoice - elements
name1
name2
address - elements
street
zipCode
city
state
country
voucher - elements
voucherNo		voucher number	vouch_data
amadeusNo		Amadeus voucher number	ama_vid
value		Full credit nil credit EUR*****	v_value
isEvoucher		eVoucher indicator	sx_evouch
iataNo			book_iata
agency - elements
agencyNo			book_agent
name1			book_nam1
name2			book_nam2
address - elements
street			book_str
zipCode			book_plz
city			book_ort
state
country			book_land
corpCustomer - elements
corpNo			v_customer
name1			v_nam1
name2			v_nam2
address - elements
street			v_str
zipCode			v_plz
city			v_ort
state
country			v_land
beneficiary - elements
name1			nam1_lstt
name2			nam2_lstt
address - elements
street			str_lstt
zipCode			plz_lstt
city			ort_lstt
state
country			land_lstt

Any other data sent by Sixt will be included on the Interface Report, but it 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 and thus requires a CARS+ terminal record with an employee name of "RESINT" and a password of "RZMRGS" (see the section on set-up earlier in this chapter).

The transmission report shows data 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.

III. SET UP INSTRUCTIONS FOR THE SCRIPTS

This section is for Thermeon Support personnel.

In the config directory, create a file called SixtResInt.conf. A separate cron job must be set up for each country whose reservations are to be merged. An example configuration file is in SHELL called SixtResInt.conf.eg.

Here is an example:

BASIC_AUTH_USERNAME=franchise
BASIC_AUTH_PASSWORD=secret
COMPANY_NUMBER=1
COMPANY_PASSWORD=secreter=1
URL=https://webservices.sixt.de/webservices/franchise/test/soap_1.01
#URL=https://webservices.sixt.de/webservices/franchise/prod/soap_1.01
FIND_SOAPAction=http://webservices.sixt.de/webservices/franchise/reservationList_1.01
RETRIEVE_SOAPAction=http://webservices.sixt.de/webservices/franchise/reservationDetails_1.01

The data in the example should be correct except for items dealing with
authentication, and deciding which URL to use.

There are two levels of authentication: one at the web level
(BASIC_AUTH_USERNAME and BASIC_AUTH_PASSWORD), and one at the company
(franchisee) level (COMPANY_NUMBER, COMPANY_PASSWORD).

You can see the two possible URLs to use, one for testing and another for
production (commented out).

IV. RE-MERGING A RESERVATION

Each reservation received from Sixt, besides being merged into the reservation file, is also stored in your system in it's raw XML form. Even rejected reservations are stored this way. These raw reservations are named, using the Sixt reservation confirmation number. Batch files can be manually remerged into the reservation file. This is done by manually running the program RZMRGS (shortcut RESiNT-S) and entering the batch/confirmation number in the field provided.

The screen will display:

OPTION: __ SIXT XML RESERVATION INTERFACE 1 Start Batch Date 2 Start Batch Time 3 End Batch Date 4 End Batch Time 5 Print rejects only? 6 Batch file name 1SAVE 2NEXT 3ERASE 4DELETE 5BACKUP 6 7HELP 8

So for an example, if a reservation was rejected by CARS+ because of a missing Rate Plan or has used the default voucher IT because the IT record was missing:

• Correct the missing records (add the missing Rate Plan or set up the missing IT record)
• And then manually re-merge the reservation using the entire batch number such as: resspool/18/07/12/9998838111.01.bch