CA2229037A1 - Multiple currency travel reservation information management system and method - Google Patents
Multiple currency travel reservation information management system and method Download PDFInfo
- Publication number
- CA2229037A1 CA2229037A1 CA002229037A CA2229037A CA2229037A1 CA 2229037 A1 CA2229037 A1 CA 2229037A1 CA 002229037 A CA002229037 A CA 002229037A CA 2229037 A CA2229037 A CA 2229037A CA 2229037 A1 CA2229037 A1 CA 2229037A1
- Authority
- CA
- Canada
- Prior art keywords
- segment
- global
- travel
- currency
- price
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Abandoned
Links
- 238000000034 method Methods 0.000 title claims abstract description 56
- 238000013500 data storage Methods 0.000 claims abstract description 43
- 238000000794 confocal Raman spectroscopy Methods 0.000 claims description 9
- 238000011500 cytoreductive surgery Methods 0.000 claims description 9
- 238000004458 analytical method Methods 0.000 claims description 8
- 238000004891 communication Methods 0.000 claims description 7
- 230000004044 response Effects 0.000 claims description 6
- 238000007596 consolidation process Methods 0.000 abstract 1
- 206010071578 autoimmune retinopathy Diseases 0.000 description 30
- 239000003795 chemical substances by application Substances 0.000 description 21
- 230000008569 process Effects 0.000 description 19
- 238000006243 chemical reaction Methods 0.000 description 9
- 238000007726 management method Methods 0.000 description 6
- 238000012545 processing Methods 0.000 description 6
- 230000006870 function Effects 0.000 description 5
- 238000013461 design Methods 0.000 description 4
- 230000029305 taxis Effects 0.000 description 4
- 230000008901 benefit Effects 0.000 description 3
- 150000002500 ions Chemical class 0.000 description 3
- 238000012550 audit Methods 0.000 description 2
- 150000001768 cations Chemical class 0.000 description 2
- 230000002860 competitive effect Effects 0.000 description 2
- 230000002354 daily effect Effects 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 230000005055 memory storage Effects 0.000 description 2
- 238000012011 method of payment Methods 0.000 description 2
- 230000002093 peripheral effect Effects 0.000 description 2
- 238000012546 transfer Methods 0.000 description 2
- 238000010200 validation analysis Methods 0.000 description 2
- 241000091577 Mexicana Species 0.000 description 1
- 230000033228 biological regulation Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 230000003831 deregulation Effects 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 230000003203 everyday effect Effects 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 230000010006 flight Effects 0.000 description 1
- 238000002955 isolation Methods 0.000 description 1
- 235000015250 liver sausages Nutrition 0.000 description 1
- 235000012054 meals Nutrition 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 238000003908 quality control method Methods 0.000 description 1
- 230000001105 regulatory effect Effects 0.000 description 1
- 238000004513 sizing Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/02—Reservations, e.g. for tickets, services or events
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/02—Reservations, e.g. for tickets, services or events
- G06Q10/025—Coordination of plural reservations, e.g. plural trip segments, transportation combined with accommodation
Abstract
Methods and system for effecting the consolidation of travel reservation information including bookings and ticketing using different currencies are disclosed. Specifically, a method is disclosed in which travel reservation information is generated in a computer reservation system (CRS), the prices of which are represented in a predetermined global currency, and subsequently stored in a global data storage medium, such as a database. The information generated from the CRS can be pre-ticketed or ticketed. The information can be generated from more than one CRS. The system that is disclosed includes a global data storage medium, in which pricing information regarding travel reservations generated in at least one CRS is represented in a global currency and is stored. Each CRS is accessed by at least one locally operated computer system to generate the travel reservation information.
Description
MULTIPLE CURRENCY TRAVEL R~.~vATION
INFO~MATION MANAGEMENT SYSTEM AND METHOD
Statement of Field of the Invention This invention relates generally to the field of c~ ~uLerized travel reservation information management syste~s and, more particularly to such a system for automatically consolidating travel reservation 10 infor~ation that is generated in different currencies..
DescriPtion of the Relevant Prior Art With the advent of a global economy and associated glohal competition, corporations all over the world and particularly in the United States are being forced to re-evaluate their corporate philosophy in light of their competitive position. As a result, corporate down-sizing and automation have occurred. However, the one area, travel and entertainment ("T&E") expenditures, that makes up a large if not the largest percentage of corporate 20 expenditure for many corporations is not being monitored as closely as some other areas to achieve reduced overall ~ corporate expenditures. This lack of monitoring is not due to oversight, but is due to the inability to access their corporate travel expenses, particularly expense generated in foreign countries, efficiently a accurately in sufficient time to take advantage of price saving measures to develop strategic travel policy.
As the travel industry has become highly competitive, characterized by airline deregulation and 5 over capacity, travelers have been able to take advantage of fare wars and the ability to obtain significant discounts for services negotiated in advance and discount rates for the advanced booking of travel packages including airfare, hotel, and ground transportation. The lo incentives encourage travelers to book travel plans well in advance of their departure dates through their travel agents. However, due to the unpredictable travel d~n~
of the corporate international traveler, many times advanced purchases are impractical, if not impossible.
Therefore, in order to attract the corporate business traveler, airlines, hotels, car rental agencies, and other travel related suppliers offer volume discounted rates. Most of the time the volume discounts are negotiated based on the volume of travel taken in the 20 pr~c~;ng months or years. Corporations, thus, require detailed tracking from an entity (either an internal travel department or a travel agency) booking and ticketing the travel arrangements. The following explanation of the travel arranging process will show some of the difficulties experienced with obt~;n;ng this information.
Most available travel reservation systems include software that allows a travel agent to acquire any travel information requested by their customer by utilizing a locally operated computer system to access a remote computerized reservation system ("CRS"), the functions and capabilities of which are well known to those of ordinary skill in the art. CRSs provide information on the availability and price of commercial airline flights, 35 ground transportation, and lodging and allows the agent W O 97/08639 PCT~TS96/137S~
to book and ticket reservations from the CRS. Once booked, the reservations are maintained in most CRSs until after the travel is complete.
Each locally operated computer system that is configured for connection to the CRS is assigned a user or agency identification number ("ID"). An agency profile corresponding to the agency ID, is stored at the CRS host computer system. The profile contains relevant information regarding the agency, including data paths 10 and security access codes. One specific type of information available that is critical to the ticket issuing process is the type of currency used for the pri~e of the ticket. A single CRS supports both agencies and service providers (such as airlines, hotels, and car rental agencies) in many cuu~.LLies or geopolitical entities, each of which typically transacts business in the currency of their respective countries. Therefore, the agency profile contains the reporting currency for the CRS that is used when reporting prices and issuin~
tickets.
Typically, when the CRS is accessed to book a reservation, the travel agent enters all relevant info~ation regarding the travel plan including the travelerJs name, destination, departure date, arrival date, type of ticket being purchased (i.e., non-refundable, non-transferable, etc.), method of payment, and ticketing date. To expedite this process, ~ost CRSs have much of this information stored in a customer profile so that the travel agent will not have 30 to re-enter any common information each time a reservation is made.
When booking a reservation, this information is stored in a passenger name record ("PNR"). Then once a reservatiOn is booked, a ticket can be generated from the 35 CRS or other systems.
W O 97/08639 PCT~US96/13758 In response to the need for reconciling travel agency accounting records with information initially booked in the CRS regarding the travel reservations entered by that agency, it has become the s~n~rd practice in the travel industry to make this travel reservation information in the CRS available for analysis once the airline ticket issues. For example, travel information accounting systems, commonly referred to in the travel industry as back office systems, have been lo developed to interface information from the CRS
(typically sent from the CRS in the form of an accounting interface record ("AIR")) into a local database after a ticket issues, so that the information can be analyzed for accounting, regulatory reporting, and management information purposes. The ~X back-office system, developed by the assignee of this invention, is an example of such a system. Most of the existing travel information accounting systems only deal with post-ticketed data, however, some systems provide access to pre--ticketed data.
The term "pre-ticketed" refers to the time before an airline ticket is issued and the term "pre-invoice"
refers to the time before an invoice is issued on, for example a rental car or hotel reservation. However, the travel industry generally refers to both pre-ticketed and pre-invoice information as pre-ticketed information. All references to pre-ticketed information hereafter will include both pre-ticketed and pre-invoice information.
With the increasing emphasis on reducing travel costs, the need for access to pre-ticketed and pre-invoice data for analysis has arisen. For example, a corporation may monitor reservations made by their employees to prevent excess travel. Also, pre-ticketed data can be monitored to determine the number of people going to the same destination, so that a possible group CA 02229037 l998-02-06 rate may be negotiated by the travel agent. A system, developed by the assignee of the present invention and made in accordance with the invention disclosed in United States Pate.nt Application Serial No. 08/317,860, which is herein incorporated by reference, is such a mid-office system that: provides reporting capabilities utilizing both pre-ticketed and post-ticketed data.
Until the discovery of the present invention, corporations only periodically received the travel o reservation information stored in their travel agencies' bac~-office or mid-office systems. Typically, the infor~ation is distributed to the corporations via diskettes, magnetic tape, or paper and delivered to the corporation by mail, courier, or the like.
The~e are problems with these methods of transmitting travel information. First, if the information is being transmitted in different currencies, each individual transaction amount field must be converted to a common reporting currency before being 20 evaluated. As exchange rates change every day, the day of the transaction and the ~ch~nge rate on that day must be considered when performing the conversion or else t:he conversion information may not be representative of the money spent on the transaction date.
~n practice, an average exchange rate for the period of interest is used for currency conversion, which inherently introduces error in to the determination of travel expenses. For example, a corporation may use t:he average ~c.h~nge rate for a thirty day period. Any daily deviations from the average that may significantly impact the price of the travel are not accounted for.
Second, the travel information provided to the corporation is never current. This is a problem, because, for example, when generating a report on the money spent with a certain airline for volume discount W O 97/08639 PCT~US96/13758 negotiations, any tickets issued and paid for after the tra~ ion of the travel data to the corporation would not be included in the report. If the missed information represents a significant amount of money, the corporation is not using its full bargaining power in the volume discount negotiations.
Third, if the information is transmitted from different back office systems, then all the information must be converted to a common format in order to evaluate o the information. The conversion can be a very time consuming effort.
Although the current back-office and mid-office systems function well for their intended purposes, they were not designed to accept multiple currency data and, thus, were not designed to handle and separately maintain data from several countries. For example, a back-office system such as the MAX back-office system includes a database having a database file structure such as that shown in FIGs. la-lf (except the Tax Detail and Tax Detail Audit files shown in FIG. la), wherein each file is represented inside of an oval. Each file is related to another by a one-to-many primary relationship, one-to-one primary relationship, one-to-many secondary relationship, or one-to-one secondary relationship.
Each time an AIR is received from a CRS, the data in the AIR is converted by the receiving computer and stored in a relational database having the structure shown in FIGs. la-lf. The data is indexed and retrieved by transaction locator number.
Since the system was not designed to receive multiple currency data, because the information in the AIRs sent from the CRS was always in the same reporting currency identified in the agency profile, there is no means to distinguish an AIR record having one currency 35 from an AIR record having another currency. All the data W O 97/08639 PCTrUS~6/13758 is stored in the same file, the Invoice Master file. As a consequence, multiple currency data would be combined together, preventing the isolation of data of one > currency.
Another problem with single currency or single country systems is that they are not equipped to handle data in more than one language. Different countries may require different reporting languages. For example, a recor~ representing the booking of a flight from New York lo City to Madrid generated in English would show New York as t'New York." However, if the same record was generated in sr~ni ~h, then New York would be represented as "Nueva York." The single country system would only be able to report in a single language.
Also each country has an individual ticket form and ticket type. For example, Canada has the transitional automated ticket ("TAT"), a four (4) part document; the United States has the automated ticket and boarding pass ("AT~'), a single coupon document; and most other countries have the miscellaneous charge order ("MCO").
Obviously, none of the systems that are designed to receive single currency or country data are equipped to handle data having different ticket forms and types.
Another problem associated with the inability of a sysl:em to handle multiple-currency or multiple-country data is in report generation. For example, countries differ in how they present address and date information.
Yet another problem with the existing systems is the inability to download multiple currency travel data 30 to a corporation's main frame or internal computer, to, for e~ample, interface with the corporate general ledger.
SummarY of the Invention W O 97/08639 PCTnUS96/13758 A new method and system of consolidating at least two travel reservation information records including one or more travel segments with at least two different currencies generated from one or more a locally operated ~;~ uLer system has been developed to overcome the deficiencies of the prior art. This method and system are particularly suitable for companies having a significant number of employees that travel internationally for business, and thus, incur substantial lo travel and entertainment costs in different currencies.
In one embodiment, an operator, typically a person n~e~ing to access information consolidated with multiple travel segments selects a global currency in which to represent prices associated with each travel segment.
1S Then the same or another operator, such as a travel agent, enters a first locally operated c~ uLer system and acquires a first computer travel reservation information record with the price of at least one travel ~e_ ?nt represented in a first currency from a computer reservation system (CRS). When the record is received, the price of each ~_ ent is represented in the global currency and stored along with information from the ~uLer travel reservation information record in the global data storage medium, which is preferably a database. It is not necessary that all the information in the record be stored. If the currency in the computer travel reservation record is not the global currency, then the currency is converted before it is stored in the global data storage medium.
Then, a second locally operated computer system is entered into by the same or another operator, such as a travel agent to acquire a second computer travel reservation information record with the price of at least one travel segment in a second currency from the computer 35 reservation system (CRS). The price of each segment in the ~econd computer travel reservation information record is represented in the global currency and stored along wi~h information from the second computer travel reservation information record (could be the entire record) in the global data storage medium. Again, if the ~ecol-~ currency in the ~Ler travel reservation r~.cord is not the global currency, then the second currency is convQrted to the global currency before it is stored in the global data storage medium.
The first locally operated computer system can be in a first country with the first currency being the currency of the first country and the second locally operated c~ ~Ler system can be in a second country with second currency being the currency of the second country.
The term "c~ul-LL~" as it is used to this application, applies to any geopolitical entity or association that issues or uses a unique currency.
Once the data is stored in the global data storage medium, the data can be accessed for display or report 20 generation from an operational center computer, any of the locally operated compulcers, or any other system capable of accessing the global storage medium.
Instead of accessing travel reservaicion information records from a single CRS~ records could be generated ~rom two or more separate CRSsO
Two locally operated computer systems are not n~c~sAry t:o practice this invention. A single locally operated computer system may be capable of requesting travel information records that include prices reflected in differen~ currencies. Therefore, once a global currency is selected in which to represent prices associated with each travei segment, then a first computer travel reservation information record with price of at least one travel segment in a first currency, i.s 35 acquired from a computer reservation system (CRS) in the W O 97/08639 PCTAUS96/137~8 locally operated computer system. The price of each segment is represented in the global currency and stored along with information from the computer travel reservation information record in the global data storage 5 medium. If the currency in the computer travel reservation record is not the global currency, then the currency is converted before it is stored in the global data storage medium. Then, once a second computer travel reservation information record with price of at least one lo travel segment in a second currency from the computer reservation system (CRS) is acquired, the price of each segment is represented in the global currency and stored along with the information from the second computer travel reservation information record in the global data 15 storage medium. Again, if the second currency in the computer travel reservation record is not the global currency, then the second currency is converted before it is stored in the global data storage medium.
Also disclosed is a system for centralizing in a 20 predetermined global currency travel reservation information having at least two different currencies generated from locally operated computer systems for subsequent analysis. The system includes first and second locally operated computer systems, a global data 25 storage medium (preferably a database) and at least one computerized reservation system (CRS) accessible by the first and second locally operated computer systems that has the capability of generating at least one travel segment and price associated with each segment, of 30 booking reservations for a selected segments, of generating travel reservation information in response to a request by the first or second locally operated computer systems, and of detecting the booking of a reservation with the price of each booked segment. Also 35 included is means for representing the price of each W O 97/~18639 PCT~US96/1375X
booked se~ment in the predetermined global currency, means for transferring segment reservation information and the global currency representation of the price of each booked segments to the global data storage medium, and means for storing the transferred segment reservation information and the price of each booked segment in the global currency in the global data storage medium.
If the currency in the computer travel reservation record is not the global currency, then the means for o representing the currency in the global currency performs a conversion of the recorded currency to the global currency.
The term "book" includes, but is not limited to, reserving available travel and being wait-listed for travel that is already booked to capacity.
It is also not n~C~cc~ry that the price informatiGn be represented in the global currency be:Eore transmitting to the global data storage medium. The representation in the global currency could take place after transmission, but before storing.
The first and second locally operated computer system can be and typically are located in a remote location from the CRS and include c; -n;cation mech~n;sms to transfer data between the systems. The 25 c~ n;cation means could be any ?ch~n;sm to transm:it data such as a communication modem, phone lines or sa~ellites, or any other type of electronic transfer means.
The first locally operated computer system can be 30 in a first country with the first currency being the currency of the first country and the second locally operated computer system can be in a second country with second currency being the currency of the second country.
Again, this embodiment of the invention also 35 applies to a single locally operated computer system capable of accessing travel information records having different currencies.
The computer travel reservation information record may consist of pre-ticketed information or ticketed information.
once the data is stored in the global data storage medium, the data can be accessed for display or report generation from an operational center ~uLer, any of the locally operated ~u~uLers, or any other means lo capable of accessing the global data storage means, including, but not limited to a corporate internal ~u~Ler system.
Instead of accessing the travel reservation information record from a single CRS, records could be generated from two separate CRSs.
A method for consolidating travel reservation information generated from locally operated computer systems in at least two countries is also disclosed. The method includes selecting a global currency in which to represent price associated with each travel segment, entering a first locally operated computer system in a first country having a first country currency, accessing a computer reservation system (CRS) from the first locally operated computer system, generating, in the CRS, at least one travel segment for a traveler, selecting at least one travel segment with a price of the selected segment for booking, booking a reservation at the price in the CRS for each selected travel itinerary, representing the price of the travel segment in the 30 global currency, storing information regarding the booked travel segment and the price in the global currency in the global data storage medium, entering a second locally operated computer system in a second country have a second country currency, accessing the CRS from the second locally operated computer system, generating, in WO 97/0~639 PCT~US96/13758 the CRS, at least one travel segment for a traveler in the second country, selecting at least one second travel segment with price of the second travel segment for booking using the second locally operated computer system, booking a reservation at the price in the CRS for the second travel segment, representing the price of the ~co~ travel in the global currency, and storing information regarding the second booked travel segment and the price in the global currency in the global data 10 storage medium.
Another method is disclosed for reporting travel reservation information generated from at least one loca]ly operated computer system and at least one co~puter reservation system (CRS) and stored in a global data storage medium. The method includes the steps of selecting a company reporting format that includes at least a reporting language and a global currency, storing co~rAIny rel~orting format in the global storage medium, including reporting language, and a global currency, entering a locally operated computer system, accessing a computer reservation system (CRS) from the locally operated computer system generating, in the CRS, at least one travel ce ~nt, selecting at least one travel segment, including price of the selected segment, for booking, booking a reservation at the price in the CRS
for each se.lected travel segment, representing the price of the seg~ent in the global currency, storing information regarding the booked travel segment and the price in the global currency in the global storage medium, accessing the company reporting format and the stored booked travel segment and price in the global currency information in the global storage medium, and reporting the booked travel segment and price information in the company reporting format. The c__ Any reporting format may also include a reporting address format and a reporting date format. The information of the company reporting format may be stored in a single file or several files.
The computer travel reservation information record 5 referenced above may consist of pre-ticketed information or ticketed information. It may also consist of all the information stored in the CRS (for example, that stored in a PNR) or may be selected information such as that transferred in an AIR.
lo A travel segment, such as that referenced above, may represent any type of travel, including but not limited to, air, rail, car, ferries, and cruises.
Brief DescriPtion of the Drawinq In the Drawings:
FIGs. la-lf show a schematic representation of the structure of a logical database design structure associated with a single currency back-office system.
FIG. 2 is a schematic view of a system in accordance with the present invention.
FIG. 3 is a logical flow diagram showing the overall operation of the present invention.
FIG. 4 is an illustration of the form of raw data available in a PNR generated by a typical CRS system.
FIG. 5 is an illustration of a representation of 25 an AIR record including items selected from a PNR.
FIG. 6 is a schematic view of the system data flow of the preferred embodiment of the present invention.
Figs. 7a-7d show a schematic representation of the structure of the logical database design and associated 30 database relationship that comprise the global database of Fig. 6.
WO 97/08639 PCT~US96/13758 Description of the Preferred Embodiments Referring to the drawings, in FIG. 2 systems for managing consolidated multiple currency travel reservation information include global computer 10 (which in the preferred embodiment of this invention is an .~S400 computer, marketed by International Business Machines), and global. data storage medium 14 (which in the preferred embodiment. of this invention is the AS400 relational database or the equivalent ~oyLammed in an object 10 oriented ~anner as is well known to those of ordinary skill in the art) for storing travel reservation information generated in at least two currencies, which in this ca.se come from two different countries. Modem 18 is connect.ed via land lines 30 to a remotely maintailled computer systems 32 and at least two system for gathering travel reservation data 20 and 50 in two different countries. These systems could be located at travel agencies or within a corporation, but for illustrati~re purposes, the travel agency will be used. Each system 20 20 and 50 includes travel agency locally operated comput:er systems 21 and 51 and optional locally operated computer systems 23 and 53 having terminals 22 and 52, optional memory storage disks 24 and 54 for storing pre- and post--ticketed travel information, optional printers 26 25 and 56, communications modems 28 and 58, and any othe.r optional peripheral devices such as facsimile machine 27 and 57. Modem 28 is connected via land lines 30 to remotely m~aintained computer system 32 and modem 58 i.s connected via fiber optic cable lines 50 and land lines 30 30 to remotely maintained computer system 32. Computer system 32 .includes communication interface equipment 34, computer 3~, and a plurality of memory storage disks 38, 40, 42, 44, and 46, accessible by travel providers su.ch as lodging providers, ground transportation providers, and airlines.
Another optional component of this system is operational center computer 60. This component is typically not configured to generate and book itineraries through the CRS, but is designed to access the consolidated information stored in global database 14 for analysis, maint~n~nc~, and report generation. Operational computer center 60 is connected to communications modems 68 to access the global database, printer 66, and any other peripheral devices such as facsimile machine.
The term "connected" as it applies to this invention means "electrically connected" and does not require physical or constant connection. Therefore, the connection may only be for a short period of time.
Remote computer system 32 is a computer reservation system ("CRS"), which is well known to those of ordinary skill in the art. Typically, CRSs include a large mainframe, capable of processing significantly large amounts of data. CRSs are designed to provide travel itineraries and travel booking to locally operated terminals in many different countries. There are several CRS providers including the assignee of this invention.
The term "CRS" includes any system that receives, stores, processes, and/or transmits travel related information to and from another system, including, but not limited to, rental car company computer reservation systems, cruise company computer reservation systems, and hotel computer reservation systems.
FIG. 3 shows a process for automatically transferring the travel reservation information from a CRS to a global database once the reservation is ticketed in its broadest sense depicted in flow chart form. This process could be modified by one of ordinary skill in the art in accordance with the teachings of United States Patent Application Serial No. 08/317,860 to provide a process for automatically updating the local travel WO 97/08639 PCT~S96/13758 information database 24 and 54 and global database 1 every time a PNR is created or modified in the CRS.
However, for purposes of illustration, the process utilizing ticketed information will be described.
- 5 In this embodiment of the invention, the process is essentially performed by software executed in thr~.e locat:ions. The first part of the software is installed on a travel agent's locally operated ~u~uLer system, the ~c-o~-~ part is installed on the remote CRS host computer, o and t:he third part is installed on the global computer.
The three portions of the software communicate with e.ach other to e~ecute a recluest for a proposed itinerary, book a reservation for a traveler, and store selected information to global database 14.
Regardless of the ~o~Lly in which the travel agency resides, when making a reservation for a traveler, the t:ravel agent enters the traveler's name and travel information, step 100. The system automatically determines if the traveler is a first-time customer, step 102. If the traveler is a first-time customer, then the agent enters traveler identification information about the customer, step 104, such as, the address, method of payment and any special travel requirements and the desired travel information. Then the agent rec~uests aCCe5S to 1:he CRS host to obtain itineraries, step 106.
If a profi:Le exists, then it is accessed and modified if necessary, step 107, before accessing the CRS.
Each locally operated computer system that is configured for connection to CRS remote computer system 30 36 is assigned an agency identification number ("ID").
An agency profile corresponding to the agency ID, is stored at t:he CRS host. The profile contains all relevant information regarding the agency, including data paths, security access codes, and desired transaction 35 currency. one specific type of information available pertaining to this invention is whether or not the agency requested that an accounting interface record ("AIR") be generated automatically every time a reservation is ticketed. An AIR is a record temporarily generated by the CRS, including both traveler identification information, ticketed travel itinerary reservation information, and segment price information, which will be transmitted to a location, such as the agency or, in this case, global computer 10. Thus, when the agency requests o access to the CRS host, the agency ID is automatically sent to the CRS host to identify the locally operated computer system requesting access, step 106.
once the CRS host accesses the agency profile pursuant to the agent ID, step 108, the CRS checks 15 whether a customer profile exists, step 110. If a profile exists, then the computer accesses the profile and makes any npcp-csAry modifications, step 112. If a profile does not exist, then the CRS host computer creates one, step 114. Then the CRS host creates a PNR
20 record, step 116, and develops possible itineraries, step 118, for presentation to the agent. Each itinerary is composed of individual travel segments, for example a round-trip, non-stop flight includes a two segment. The agent then selects the best itinerary and, thus, the best segments and requests a reservation, step 120. Upon receipt of the reservation request, the CRS host then books the reservation, step 122. If the CRS is not re~uired to issue a ticket, step 124, then the record is finished.
Otherwise, the CRS proceeds with issuing the ticket. First, the price of the ticket is calculated in the currency specified in the agency profile, step 126.
Most CRSs are updated on a daily basis with current currency exchange rates. Then, the ticket is issued, 35 step 128.
W O 97/08639 PCT~US96/13758 If the agency profile indicates that an AIR is requested, step 129, then the CRS prepares and trans~its the ~IR record and ticket to the global computer, st,ep 130~ The AIR information is loaded into central global co~nputer system 10, step 134.
once the information is received, the computer determine whether the price of the segment in the AIR is reflected in the same currency as a predetermined global currency. If the price is in the global currency or 10 global replorting currency, then the global reporting currency representation of the price information is loaded into global database, step 142. The system i~;
designed to allow a user to specify at least a primary currency for storage and reporting purposes. For the purposes of this discussion "global currency" and "primary currency" are used interchangeably.
If the currency in the AIR is not the global reporting currency, then global computer 10 determines if the ~çh~nge rate exists, step 136. If not, then a new exchange ratets) must be added, step 138. Otherwise, the system utilizes the existing rates which should be updated. This step could be performed automatically if the ~h~nge rate is provided from a source capable of transmitting electronic data such as the CRS, Reuters Telerate, or any other source of electronic ~ch~nge rates. It is, however, preferable for an authorized person to input the information manually. In addition to the l~çh~nge rate sources mentioned above, the information is available in financial periodicals and 30 electronic services. The received price information is converted, step 140, and loaded and along with the ot:her received information into global database 14, step 142.
If the AIR option is not selected, then the CRS
host immediately issues the ticket and finishes the 35 recoxd, step lZ4.
In order to prepare an AIR, the CRS host parses the PNR created by the CRS, as shown in FIG. 4, step 130.
The host selects which information from the PNR is n~c~cE~ry and reformats the data for tr~n~icsion to the locally operated computer system. The PNR could be directly downloaded to the global database. However, it is much more efficient to format the data in the host, which facilitates the downloading of the data at the global database.
lo It is well known to those skilled in the art that any information selected from the PNR could be arranged in ~ny number of ways. Also, it is well known that the information could be stored in any storage medium rather than a dat A h;~
It is also well know to those of ordinary skill in the art that any or all information in the PNR can be transferred.
In the preferred embodiment of this invention, the information from the PNR is stored in the AIR in a number of predetermined fields, each represented by a specific code. FIG. 5 shows an example of an AIR developed from a PNR of a passenger flying from Acapulco, Mexico to Cancun, Mexico on Mexicana Airlines. However, each AIR
will vary depending on the travel information.
In the embodiment of the invention described above, the information from the AIR is then downloaded into central global computer database 14. The information can be loaded into any database utilizing any database management systems, such as AS400 relational dat~h~fi~.
The process described above could be modified by one of ordinary skill in the art to include enhancements that make the over all system more efficient. For example, the system could be reconfigured such that different component perform different functions. The AIR
WO 97/08639 PCT~US96/13758 could be loaded into any storage medium, which can be accessed for subsequent processing of the data in the AI~.
FIG. 6 shows a flow diagram of an enhanced version and the preferred embodiment of this invention, wherein travel agency 200 operates a locally operated computer to access CRS 202 and global computer 204. The travel reservation information generated by the CRS is stored in a remote data storage medium, such as global dat~hAs~ 206 lo con~rolled by remote global computer system 204.
In FIG. 6, a travel agent at travel agency 200 requests, books, and tickets travel itineraries in the CRS, step 208, in the same or similar manner to that as shown in FIG. 3, steps 100-192. As stated above, this process could be modified in accordance with the teachings of United States Patent Application Serial No.
08/317,860 to provide pre-ticketed data from CRS 208, but for discussion purposes, only the system utilizing ticketed data is described.
In this emboAim~nt of the invention, an operator may select whether to have the tickets issue from CRS
202, step 210, or from global computer 204, step 212.
Regardless of which equipment issues the ticket, the CRS
provides an AIR record to global computer 204, which is then processed, step 213, and stored in global database 206, step 213.
Global computer 204 is designed to accept, process, and if necessary to store information from several other sources. For example, the system is designed to accept foreign currency exchange rate iniEormation 220. This information can be received from an~ of the sources from the description of FIG. 3 above.
The system is also designed to interface with vendors 222 and allow them to provide expense, refund, and romm;ssion 35 in~o~ mation 224 to global database 206. Information is used for reconciliation, reporting, and vendor settlements. Vendors 222 then are able to receive payable information, vendor checks 226, from the database such as travel and expense checks.
Global computer 204 also accepts information regarding: payments, refunds, adjustment, and returned tickets 228 from customers through travel agency 200;
cash in receipts from retail point-of-sale operation from external data feed 230; and sale, discount, and payment lo information from credit card service establ;~h~nts 231.
Global computer 204 could be programmed to accept other type of information by one of ordinary skill in the art.
With all the information provided by the sources mentioned above, global computer 204 is capable of issuing checks in any selected language 232 and generating reports 234 for travel agency 200 and providing sales information, discounts, and payment to credit card service establishments 231. The sales information and the country of origin information allow global computer 204 to also generate local tax information 236 that can be used for many purposes including, but not limited to, obtaining refund of sales taxes paid in certain countries.
In addition to all the features mentioned above, the system shown in FIG. 6 performs all of the functions of the currently marketed MAX back office accounting system, marketed by the assignee of the present invention. These features include end-of-the-day processing 240, a general ledger database 242, process 30 and generate financial reports 248 for both management 250 and accounting 246. Journal entries from accounting are also processed 244 and downloaded into general ledger database 242. The system also processes and generates reports 252 aside from strict accounting reports for management 250. Unlike all the prior systems, the reports generated by this system include travel price information in a selected currency that is real-time and accur.ate and are in a preselected language using a preselected date/format/separator and preselected address format.
Since an AIR is instantaneously generated every time a reservation is ticketed, the information in the global database is current with the actual prices represented in the selected currency at all times. T]le lo data is also maintained in the database until it is archived an.d purged. Therefore, the reports can be generated cn any computer system, such as an operational center compluter that includes current, accurate information. providing a much more useful system.
The process for automatically updating the global travel information database 14 (FIG. 2) every time a reservation. is ticketed in the CRS described above utilizes an. AIR. However, the process could be modified by one of ordinary skill in the art to download any type of travel reservation information. The information could include any type of record. For example, the travel reservation information in the PNR could be directly downloaded from the PNR to the global computer system upon detection of the ticketing of a reservation. No AIR
is required.
The system could also be modified to accept travel reservation information from other CRSs. Either the information must be sent in the form of an AIR or anot:her for~at from another CRS recognized by the global computer sysltem, so that any relevant information may be extracted.
A portion of the database structure of the global database of the preferred embodiment of this invention, the company database structure, is shown in FIGs. 7a-7c.
This company database structure design is implemented to W O 97/08639 PCT~US96/13758 compliment the existing database file structure shown in FIGs. la-lf. However, the same process and method (described below) could be implemented in a unique design by one of ordinary skill in the art or be implemented with any single currency or single country back-office or mid-office system well known to those of ordinary skill in the art.
Global database 206 of FIG. 6 is structured to include two functional portions; a validation portion and 10 a travel information record storing portion. The travel information record storing portion is comprised of the files shown in FIGs. la-lf plus the Tax Detail and the Tax Detail Audit files. However, before the data is stored in the database, it is validated using the information stored in the portion of the database having the structure of FIGs. 7a-7d.
The validation portion allows for the handling of travel reservation data generated in multiple currencies, in multiple languages, multiple ticket forms, multiple ticket types, and multiple date formats.
FIG. 7a shows all the files of the company database structure. It is intended that a "co~rAny"
represent, for illustrative purposes, a geographical or operational division of an entity using this invention.
For example, an international entity having need to consolidate travel reservation information on a per country or per geographical regional basis, would set up a company database structure for each country or geographical region.
The information stored in the company database files is specific to the entity. For example, the Cities file includes all of the city codes and country codes of the cities to which customers or employees travel. The Country file contains a list of the full name of all the countries whose country codes exist in the Cities file.
Since the city and country code are constant all over the world, glohal computer uses the codes instead of the city and countr~ name to avoid miss spellings or variations in spelling.
All of the other files contain similar information zs follows. For example: the City Types file contains codes that pertain to the type of city; the Settlement Types file contains information that identifies the type of method used for reporting/processing within a Company, o such as Airline Reporting Corporation ("ARC"), Bank Settlement Plan ("BSP"), or Direct Form of Payment ("DFOP"); the States file contains the authorized postal abbreviations and associated names for each state, province or co~--L~; and the Form Codes files contain all 15 specific criteria regarding ticket forms.
The Tax Cross Reference files contains the valid tax codes ~or each state, province or county in a country and the Tax Rules file contains rules and regulations for applicable taxes in each country. These files are 20 accessed by global computer 204 to determine applicable taxes for a state, province, or county, to validate the tax codes, and to calculate the taxes on cnmm;~cion income and credit card service charges by processes well known to those of ordinary skill in the art.
The Language file contains attributes needed t:o specify a desired language by country specification.
The Product Types file consists of the codes used to identif~ and classify types of services rendered.
While the Secondary Product Types file includes 30 information on specific types of service within a product type.
The Form of Payments file contains all specific criteria regarding forms of payment on an invoice.
The Meal Codes file contains codes and 35 descriptions used by airlines for each menu.
W O 97/08639 PCT~US96/13758 The Address Elements file contains specific data elements defining fields of a given address lay out.
The Branch file lists all the branches (include name, address, etc.) that are part of the global system along with bank accounts and pseudo cities as shown in FIG. 7d branches.
The Customers file includes customer and vendor identification information, such as name, address, etc.
FIG. 7c shows a file information break down. The o information stored in these files includes (from left to right) charts of account information for sales/cost of sales, edit masks for ~uality control, quality control selections, summary of activity for a customer with number and amount of tickets and refunds by month, vendor summary information, accounting chart information for each vendor and branch, and conversion information to cross-reference information in other back-office systems to the present invention.
The Bank file defines the system bank accounts.
The Credit Card file contains credit card codes for service establishment processing.
The Agents file includes all agent numbers and names and is broken down in to the files shown in FIG. 7b which contain agent sines (duty codes), summary of agent activity including number and amount of tickets and refunds, ~uality control for each agent, and conversion information to cross-reference agency numbers from other back-office systems to a unique number in the present invention.
The User file contains user preference attributes and specific operating characteristics, such as date formats.
The Address Formats file contains all address elements available for user selection.
WO 97/08639 PCT~US96/137S8 The Rate of Exchange Variance and Rate of Exchange files contain all the rates of exchange that may be nec~sAry to convert the travel segment prices to the primary reporting or global currency. The currency file contains the designated primary reporting currency and any other secondary reporting currencies. Once Global computer 204 receives an AIR, it accesses the currency database to determine the primary or global reporting currency. Then, it compares the currency in the AIR t:o 10 the global currency. If the currencies are different, then global computer access the Rate of Exchange Variance and Rate of Exchange files (which should be updated fre~lently to reflect the accurate exchange rate) to ac~uire the ~YchA~ge rate to convert the AIR currency to 15 the global currency. Then, global computer 204 stores the price in both the original and global currencies in the ~nvoice Master files and subfiles of the storing database structure shown in FIG. la.
After step 140 of FIG. 3 is executed, the AIR is parsed to Eind the agency number, from which the comrArly can be determined. Once the company is determined, then the system access the company structure portion of the database to determine the primary reporting or global currency. Then the conversion and storing process described in the previous paragraph is executed.
Many of the entries in the comrAny database structure are used for reporting purposes. For example, a company database can be set up for a company in Canada, specifying that all reports be generated in French by placing French in the language field and that all addresses be reported in the format stored in the Address Format file. Date formats are also used for displaying or reporting and are specified in the Company, Branch, Customer and Bank files, depending on the hierarchy or the function. Thus, when the proper formats are determined from the company structure database, the storing database is accessed to acquire the appropriate data that needs to be reported.
The foregoing software was developed in RPG/400 and CLP/400 using object oriented based t~hni~ues and structured methodology bases. However, it will be obvious to anyone of ordinary skill in the art that the aforementioned program may be developed in a different P1 OYL amming language using non-object oriented 10 t~chn; ques. Even though the relational database package was used, the foregoing database configuration could be implemented in an object-oriented database or any other type of storage medium by one of ordinary skill in the art. All the equipment described in the above travel reservation system is readily available.
The embodiments of the invention described above all utilize a database in the locally operated and global computer system. However, any type of storage means may be used for storing the data. It is also not necessary that the locally operated computer system have databases, all information could be generated from the global database. In the alternative, the global database could be located at one of the locally operated computer system sites, wherein access for the other locally operated computer systems is provided.
The term "locally" is only use for illustrative purposes. For example, the operational center computer may also be located at one of the locally operated computer system sites and have access the CRS. It is not 30 required that the operational center computer be a stand-alone system, however, it is desirable.
The systems and methods described above could be modified by one of ordinary skill in the art to incorporate the functionality of the global computer or an global computer into a centralized processing system CA 02229037 l998-02-06 WO g7/08639 PCT/l~S96~13758 or service bureau, such as the one provided by the assiqnee of the present invention, so that several r-omp~n;es or agencies could remotely or locally access a single global computer for centralizing travel reservation information in a predetermined global currency.
The systems and methods described above could be modified by one of ordinary skill in the art to a systems and methods using only one locally operated c- _uLer o system capable of generating computer travel reservat;ion information including different currencies that re~uire converting before being loaded into the database.
The conversion of the currency can occur anywhere in the system or method as long as it occurs before the data is stored in the global data storage medium.
Also, the methods and systems described above could be altered to accept data manually or via electronic systems such as the Internet. The system described above could also be easily modified to provide the ability to access other electronic services or systems, such as the Internet.
The methods and systems described above could be modified by one of ordinary skill in the art to interface to a corporations main frame or internal computer system to exchange information. For example, the information from the global computer at a travel agency or corporate internal travel department could be down loaded into the main frame of a corporations to be entered into the corporations general ledger.
From the foregoing it will be seen that this invention is one well adapted to attain all of the features and objects hereinabove set forth, together with other advantages which are obvious and which are inherent to the methods and apparatuses.
It will be understood that certain features and subcombinations are of utility and may be employed without reference to other features and subcombinations.
This is contemplated by and is within the scope of the claims.
As many possible embodiments may be made of the invention without departing from the scope thereof, it is to be understood that all matter herein set forth or shown in the accompanying drawings is to be interpreted lo as illustrative and not in a limiting sense.
INFO~MATION MANAGEMENT SYSTEM AND METHOD
Statement of Field of the Invention This invention relates generally to the field of c~ ~uLerized travel reservation information management syste~s and, more particularly to such a system for automatically consolidating travel reservation 10 infor~ation that is generated in different currencies..
DescriPtion of the Relevant Prior Art With the advent of a global economy and associated glohal competition, corporations all over the world and particularly in the United States are being forced to re-evaluate their corporate philosophy in light of their competitive position. As a result, corporate down-sizing and automation have occurred. However, the one area, travel and entertainment ("T&E") expenditures, that makes up a large if not the largest percentage of corporate 20 expenditure for many corporations is not being monitored as closely as some other areas to achieve reduced overall ~ corporate expenditures. This lack of monitoring is not due to oversight, but is due to the inability to access their corporate travel expenses, particularly expense generated in foreign countries, efficiently a accurately in sufficient time to take advantage of price saving measures to develop strategic travel policy.
As the travel industry has become highly competitive, characterized by airline deregulation and 5 over capacity, travelers have been able to take advantage of fare wars and the ability to obtain significant discounts for services negotiated in advance and discount rates for the advanced booking of travel packages including airfare, hotel, and ground transportation. The lo incentives encourage travelers to book travel plans well in advance of their departure dates through their travel agents. However, due to the unpredictable travel d~n~
of the corporate international traveler, many times advanced purchases are impractical, if not impossible.
Therefore, in order to attract the corporate business traveler, airlines, hotels, car rental agencies, and other travel related suppliers offer volume discounted rates. Most of the time the volume discounts are negotiated based on the volume of travel taken in the 20 pr~c~;ng months or years. Corporations, thus, require detailed tracking from an entity (either an internal travel department or a travel agency) booking and ticketing the travel arrangements. The following explanation of the travel arranging process will show some of the difficulties experienced with obt~;n;ng this information.
Most available travel reservation systems include software that allows a travel agent to acquire any travel information requested by their customer by utilizing a locally operated computer system to access a remote computerized reservation system ("CRS"), the functions and capabilities of which are well known to those of ordinary skill in the art. CRSs provide information on the availability and price of commercial airline flights, 35 ground transportation, and lodging and allows the agent W O 97/08639 PCT~TS96/137S~
to book and ticket reservations from the CRS. Once booked, the reservations are maintained in most CRSs until after the travel is complete.
Each locally operated computer system that is configured for connection to the CRS is assigned a user or agency identification number ("ID"). An agency profile corresponding to the agency ID, is stored at the CRS host computer system. The profile contains relevant information regarding the agency, including data paths 10 and security access codes. One specific type of information available that is critical to the ticket issuing process is the type of currency used for the pri~e of the ticket. A single CRS supports both agencies and service providers (such as airlines, hotels, and car rental agencies) in many cuu~.LLies or geopolitical entities, each of which typically transacts business in the currency of their respective countries. Therefore, the agency profile contains the reporting currency for the CRS that is used when reporting prices and issuin~
tickets.
Typically, when the CRS is accessed to book a reservation, the travel agent enters all relevant info~ation regarding the travel plan including the travelerJs name, destination, departure date, arrival date, type of ticket being purchased (i.e., non-refundable, non-transferable, etc.), method of payment, and ticketing date. To expedite this process, ~ost CRSs have much of this information stored in a customer profile so that the travel agent will not have 30 to re-enter any common information each time a reservation is made.
When booking a reservation, this information is stored in a passenger name record ("PNR"). Then once a reservatiOn is booked, a ticket can be generated from the 35 CRS or other systems.
W O 97/08639 PCT~US96/13758 In response to the need for reconciling travel agency accounting records with information initially booked in the CRS regarding the travel reservations entered by that agency, it has become the s~n~rd practice in the travel industry to make this travel reservation information in the CRS available for analysis once the airline ticket issues. For example, travel information accounting systems, commonly referred to in the travel industry as back office systems, have been lo developed to interface information from the CRS
(typically sent from the CRS in the form of an accounting interface record ("AIR")) into a local database after a ticket issues, so that the information can be analyzed for accounting, regulatory reporting, and management information purposes. The ~X back-office system, developed by the assignee of this invention, is an example of such a system. Most of the existing travel information accounting systems only deal with post-ticketed data, however, some systems provide access to pre--ticketed data.
The term "pre-ticketed" refers to the time before an airline ticket is issued and the term "pre-invoice"
refers to the time before an invoice is issued on, for example a rental car or hotel reservation. However, the travel industry generally refers to both pre-ticketed and pre-invoice information as pre-ticketed information. All references to pre-ticketed information hereafter will include both pre-ticketed and pre-invoice information.
With the increasing emphasis on reducing travel costs, the need for access to pre-ticketed and pre-invoice data for analysis has arisen. For example, a corporation may monitor reservations made by their employees to prevent excess travel. Also, pre-ticketed data can be monitored to determine the number of people going to the same destination, so that a possible group CA 02229037 l998-02-06 rate may be negotiated by the travel agent. A system, developed by the assignee of the present invention and made in accordance with the invention disclosed in United States Pate.nt Application Serial No. 08/317,860, which is herein incorporated by reference, is such a mid-office system that: provides reporting capabilities utilizing both pre-ticketed and post-ticketed data.
Until the discovery of the present invention, corporations only periodically received the travel o reservation information stored in their travel agencies' bac~-office or mid-office systems. Typically, the infor~ation is distributed to the corporations via diskettes, magnetic tape, or paper and delivered to the corporation by mail, courier, or the like.
The~e are problems with these methods of transmitting travel information. First, if the information is being transmitted in different currencies, each individual transaction amount field must be converted to a common reporting currency before being 20 evaluated. As exchange rates change every day, the day of the transaction and the ~ch~nge rate on that day must be considered when performing the conversion or else t:he conversion information may not be representative of the money spent on the transaction date.
~n practice, an average exchange rate for the period of interest is used for currency conversion, which inherently introduces error in to the determination of travel expenses. For example, a corporation may use t:he average ~c.h~nge rate for a thirty day period. Any daily deviations from the average that may significantly impact the price of the travel are not accounted for.
Second, the travel information provided to the corporation is never current. This is a problem, because, for example, when generating a report on the money spent with a certain airline for volume discount W O 97/08639 PCT~US96/13758 negotiations, any tickets issued and paid for after the tra~ ion of the travel data to the corporation would not be included in the report. If the missed information represents a significant amount of money, the corporation is not using its full bargaining power in the volume discount negotiations.
Third, if the information is transmitted from different back office systems, then all the information must be converted to a common format in order to evaluate o the information. The conversion can be a very time consuming effort.
Although the current back-office and mid-office systems function well for their intended purposes, they were not designed to accept multiple currency data and, thus, were not designed to handle and separately maintain data from several countries. For example, a back-office system such as the MAX back-office system includes a database having a database file structure such as that shown in FIGs. la-lf (except the Tax Detail and Tax Detail Audit files shown in FIG. la), wherein each file is represented inside of an oval. Each file is related to another by a one-to-many primary relationship, one-to-one primary relationship, one-to-many secondary relationship, or one-to-one secondary relationship.
Each time an AIR is received from a CRS, the data in the AIR is converted by the receiving computer and stored in a relational database having the structure shown in FIGs. la-lf. The data is indexed and retrieved by transaction locator number.
Since the system was not designed to receive multiple currency data, because the information in the AIRs sent from the CRS was always in the same reporting currency identified in the agency profile, there is no means to distinguish an AIR record having one currency 35 from an AIR record having another currency. All the data W O 97/08639 PCTrUS~6/13758 is stored in the same file, the Invoice Master file. As a consequence, multiple currency data would be combined together, preventing the isolation of data of one > currency.
Another problem with single currency or single country systems is that they are not equipped to handle data in more than one language. Different countries may require different reporting languages. For example, a recor~ representing the booking of a flight from New York lo City to Madrid generated in English would show New York as t'New York." However, if the same record was generated in sr~ni ~h, then New York would be represented as "Nueva York." The single country system would only be able to report in a single language.
Also each country has an individual ticket form and ticket type. For example, Canada has the transitional automated ticket ("TAT"), a four (4) part document; the United States has the automated ticket and boarding pass ("AT~'), a single coupon document; and most other countries have the miscellaneous charge order ("MCO").
Obviously, none of the systems that are designed to receive single currency or country data are equipped to handle data having different ticket forms and types.
Another problem associated with the inability of a sysl:em to handle multiple-currency or multiple-country data is in report generation. For example, countries differ in how they present address and date information.
Yet another problem with the existing systems is the inability to download multiple currency travel data 30 to a corporation's main frame or internal computer, to, for e~ample, interface with the corporate general ledger.
SummarY of the Invention W O 97/08639 PCTnUS96/13758 A new method and system of consolidating at least two travel reservation information records including one or more travel segments with at least two different currencies generated from one or more a locally operated ~;~ uLer system has been developed to overcome the deficiencies of the prior art. This method and system are particularly suitable for companies having a significant number of employees that travel internationally for business, and thus, incur substantial lo travel and entertainment costs in different currencies.
In one embodiment, an operator, typically a person n~e~ing to access information consolidated with multiple travel segments selects a global currency in which to represent prices associated with each travel segment.
1S Then the same or another operator, such as a travel agent, enters a first locally operated c~ uLer system and acquires a first computer travel reservation information record with the price of at least one travel ~e_ ?nt represented in a first currency from a computer reservation system (CRS). When the record is received, the price of each ~_ ent is represented in the global currency and stored along with information from the ~uLer travel reservation information record in the global data storage medium, which is preferably a database. It is not necessary that all the information in the record be stored. If the currency in the computer travel reservation record is not the global currency, then the currency is converted before it is stored in the global data storage medium.
Then, a second locally operated computer system is entered into by the same or another operator, such as a travel agent to acquire a second computer travel reservation information record with the price of at least one travel segment in a second currency from the computer 35 reservation system (CRS). The price of each segment in the ~econd computer travel reservation information record is represented in the global currency and stored along wi~h information from the second computer travel reservation information record (could be the entire record) in the global data storage medium. Again, if the ~ecol-~ currency in the ~Ler travel reservation r~.cord is not the global currency, then the second currency is convQrted to the global currency before it is stored in the global data storage medium.
The first locally operated computer system can be in a first country with the first currency being the currency of the first country and the second locally operated c~ ~Ler system can be in a second country with second currency being the currency of the second country.
The term "c~ul-LL~" as it is used to this application, applies to any geopolitical entity or association that issues or uses a unique currency.
Once the data is stored in the global data storage medium, the data can be accessed for display or report 20 generation from an operational center computer, any of the locally operated compulcers, or any other system capable of accessing the global storage medium.
Instead of accessing travel reservaicion information records from a single CRS~ records could be generated ~rom two or more separate CRSsO
Two locally operated computer systems are not n~c~sAry t:o practice this invention. A single locally operated computer system may be capable of requesting travel information records that include prices reflected in differen~ currencies. Therefore, once a global currency is selected in which to represent prices associated with each travei segment, then a first computer travel reservation information record with price of at least one travel segment in a first currency, i.s 35 acquired from a computer reservation system (CRS) in the W O 97/08639 PCTAUS96/137~8 locally operated computer system. The price of each segment is represented in the global currency and stored along with information from the computer travel reservation information record in the global data storage 5 medium. If the currency in the computer travel reservation record is not the global currency, then the currency is converted before it is stored in the global data storage medium. Then, once a second computer travel reservation information record with price of at least one lo travel segment in a second currency from the computer reservation system (CRS) is acquired, the price of each segment is represented in the global currency and stored along with the information from the second computer travel reservation information record in the global data 15 storage medium. Again, if the second currency in the computer travel reservation record is not the global currency, then the second currency is converted before it is stored in the global data storage medium.
Also disclosed is a system for centralizing in a 20 predetermined global currency travel reservation information having at least two different currencies generated from locally operated computer systems for subsequent analysis. The system includes first and second locally operated computer systems, a global data 25 storage medium (preferably a database) and at least one computerized reservation system (CRS) accessible by the first and second locally operated computer systems that has the capability of generating at least one travel segment and price associated with each segment, of 30 booking reservations for a selected segments, of generating travel reservation information in response to a request by the first or second locally operated computer systems, and of detecting the booking of a reservation with the price of each booked segment. Also 35 included is means for representing the price of each W O 97/~18639 PCT~US96/1375X
booked se~ment in the predetermined global currency, means for transferring segment reservation information and the global currency representation of the price of each booked segments to the global data storage medium, and means for storing the transferred segment reservation information and the price of each booked segment in the global currency in the global data storage medium.
If the currency in the computer travel reservation record is not the global currency, then the means for o representing the currency in the global currency performs a conversion of the recorded currency to the global currency.
The term "book" includes, but is not limited to, reserving available travel and being wait-listed for travel that is already booked to capacity.
It is also not n~C~cc~ry that the price informatiGn be represented in the global currency be:Eore transmitting to the global data storage medium. The representation in the global currency could take place after transmission, but before storing.
The first and second locally operated computer system can be and typically are located in a remote location from the CRS and include c; -n;cation mech~n;sms to transfer data between the systems. The 25 c~ n;cation means could be any ?ch~n;sm to transm:it data such as a communication modem, phone lines or sa~ellites, or any other type of electronic transfer means.
The first locally operated computer system can be 30 in a first country with the first currency being the currency of the first country and the second locally operated computer system can be in a second country with second currency being the currency of the second country.
Again, this embodiment of the invention also 35 applies to a single locally operated computer system capable of accessing travel information records having different currencies.
The computer travel reservation information record may consist of pre-ticketed information or ticketed information.
once the data is stored in the global data storage medium, the data can be accessed for display or report generation from an operational center ~uLer, any of the locally operated ~u~uLers, or any other means lo capable of accessing the global data storage means, including, but not limited to a corporate internal ~u~Ler system.
Instead of accessing the travel reservation information record from a single CRS, records could be generated from two separate CRSs.
A method for consolidating travel reservation information generated from locally operated computer systems in at least two countries is also disclosed. The method includes selecting a global currency in which to represent price associated with each travel segment, entering a first locally operated computer system in a first country having a first country currency, accessing a computer reservation system (CRS) from the first locally operated computer system, generating, in the CRS, at least one travel segment for a traveler, selecting at least one travel segment with a price of the selected segment for booking, booking a reservation at the price in the CRS for each selected travel itinerary, representing the price of the travel segment in the 30 global currency, storing information regarding the booked travel segment and the price in the global currency in the global data storage medium, entering a second locally operated computer system in a second country have a second country currency, accessing the CRS from the second locally operated computer system, generating, in WO 97/0~639 PCT~US96/13758 the CRS, at least one travel segment for a traveler in the second country, selecting at least one second travel segment with price of the second travel segment for booking using the second locally operated computer system, booking a reservation at the price in the CRS for the second travel segment, representing the price of the ~co~ travel in the global currency, and storing information regarding the second booked travel segment and the price in the global currency in the global data 10 storage medium.
Another method is disclosed for reporting travel reservation information generated from at least one loca]ly operated computer system and at least one co~puter reservation system (CRS) and stored in a global data storage medium. The method includes the steps of selecting a company reporting format that includes at least a reporting language and a global currency, storing co~rAIny rel~orting format in the global storage medium, including reporting language, and a global currency, entering a locally operated computer system, accessing a computer reservation system (CRS) from the locally operated computer system generating, in the CRS, at least one travel ce ~nt, selecting at least one travel segment, including price of the selected segment, for booking, booking a reservation at the price in the CRS
for each se.lected travel segment, representing the price of the seg~ent in the global currency, storing information regarding the booked travel segment and the price in the global currency in the global storage medium, accessing the company reporting format and the stored booked travel segment and price in the global currency information in the global storage medium, and reporting the booked travel segment and price information in the company reporting format. The c__ Any reporting format may also include a reporting address format and a reporting date format. The information of the company reporting format may be stored in a single file or several files.
The computer travel reservation information record 5 referenced above may consist of pre-ticketed information or ticketed information. It may also consist of all the information stored in the CRS (for example, that stored in a PNR) or may be selected information such as that transferred in an AIR.
lo A travel segment, such as that referenced above, may represent any type of travel, including but not limited to, air, rail, car, ferries, and cruises.
Brief DescriPtion of the Drawinq In the Drawings:
FIGs. la-lf show a schematic representation of the structure of a logical database design structure associated with a single currency back-office system.
FIG. 2 is a schematic view of a system in accordance with the present invention.
FIG. 3 is a logical flow diagram showing the overall operation of the present invention.
FIG. 4 is an illustration of the form of raw data available in a PNR generated by a typical CRS system.
FIG. 5 is an illustration of a representation of 25 an AIR record including items selected from a PNR.
FIG. 6 is a schematic view of the system data flow of the preferred embodiment of the present invention.
Figs. 7a-7d show a schematic representation of the structure of the logical database design and associated 30 database relationship that comprise the global database of Fig. 6.
WO 97/08639 PCT~US96/13758 Description of the Preferred Embodiments Referring to the drawings, in FIG. 2 systems for managing consolidated multiple currency travel reservation information include global computer 10 (which in the preferred embodiment of this invention is an .~S400 computer, marketed by International Business Machines), and global. data storage medium 14 (which in the preferred embodiment. of this invention is the AS400 relational database or the equivalent ~oyLammed in an object 10 oriented ~anner as is well known to those of ordinary skill in the art) for storing travel reservation information generated in at least two currencies, which in this ca.se come from two different countries. Modem 18 is connect.ed via land lines 30 to a remotely maintailled computer systems 32 and at least two system for gathering travel reservation data 20 and 50 in two different countries. These systems could be located at travel agencies or within a corporation, but for illustrati~re purposes, the travel agency will be used. Each system 20 20 and 50 includes travel agency locally operated comput:er systems 21 and 51 and optional locally operated computer systems 23 and 53 having terminals 22 and 52, optional memory storage disks 24 and 54 for storing pre- and post--ticketed travel information, optional printers 26 25 and 56, communications modems 28 and 58, and any othe.r optional peripheral devices such as facsimile machine 27 and 57. Modem 28 is connected via land lines 30 to remotely m~aintained computer system 32 and modem 58 i.s connected via fiber optic cable lines 50 and land lines 30 30 to remotely maintained computer system 32. Computer system 32 .includes communication interface equipment 34, computer 3~, and a plurality of memory storage disks 38, 40, 42, 44, and 46, accessible by travel providers su.ch as lodging providers, ground transportation providers, and airlines.
Another optional component of this system is operational center computer 60. This component is typically not configured to generate and book itineraries through the CRS, but is designed to access the consolidated information stored in global database 14 for analysis, maint~n~nc~, and report generation. Operational computer center 60 is connected to communications modems 68 to access the global database, printer 66, and any other peripheral devices such as facsimile machine.
The term "connected" as it applies to this invention means "electrically connected" and does not require physical or constant connection. Therefore, the connection may only be for a short period of time.
Remote computer system 32 is a computer reservation system ("CRS"), which is well known to those of ordinary skill in the art. Typically, CRSs include a large mainframe, capable of processing significantly large amounts of data. CRSs are designed to provide travel itineraries and travel booking to locally operated terminals in many different countries. There are several CRS providers including the assignee of this invention.
The term "CRS" includes any system that receives, stores, processes, and/or transmits travel related information to and from another system, including, but not limited to, rental car company computer reservation systems, cruise company computer reservation systems, and hotel computer reservation systems.
FIG. 3 shows a process for automatically transferring the travel reservation information from a CRS to a global database once the reservation is ticketed in its broadest sense depicted in flow chart form. This process could be modified by one of ordinary skill in the art in accordance with the teachings of United States Patent Application Serial No. 08/317,860 to provide a process for automatically updating the local travel WO 97/08639 PCT~S96/13758 information database 24 and 54 and global database 1 every time a PNR is created or modified in the CRS.
However, for purposes of illustration, the process utilizing ticketed information will be described.
- 5 In this embodiment of the invention, the process is essentially performed by software executed in thr~.e locat:ions. The first part of the software is installed on a travel agent's locally operated ~u~uLer system, the ~c-o~-~ part is installed on the remote CRS host computer, o and t:he third part is installed on the global computer.
The three portions of the software communicate with e.ach other to e~ecute a recluest for a proposed itinerary, book a reservation for a traveler, and store selected information to global database 14.
Regardless of the ~o~Lly in which the travel agency resides, when making a reservation for a traveler, the t:ravel agent enters the traveler's name and travel information, step 100. The system automatically determines if the traveler is a first-time customer, step 102. If the traveler is a first-time customer, then the agent enters traveler identification information about the customer, step 104, such as, the address, method of payment and any special travel requirements and the desired travel information. Then the agent rec~uests aCCe5S to 1:he CRS host to obtain itineraries, step 106.
If a profi:Le exists, then it is accessed and modified if necessary, step 107, before accessing the CRS.
Each locally operated computer system that is configured for connection to CRS remote computer system 30 36 is assigned an agency identification number ("ID").
An agency profile corresponding to the agency ID, is stored at t:he CRS host. The profile contains all relevant information regarding the agency, including data paths, security access codes, and desired transaction 35 currency. one specific type of information available pertaining to this invention is whether or not the agency requested that an accounting interface record ("AIR") be generated automatically every time a reservation is ticketed. An AIR is a record temporarily generated by the CRS, including both traveler identification information, ticketed travel itinerary reservation information, and segment price information, which will be transmitted to a location, such as the agency or, in this case, global computer 10. Thus, when the agency requests o access to the CRS host, the agency ID is automatically sent to the CRS host to identify the locally operated computer system requesting access, step 106.
once the CRS host accesses the agency profile pursuant to the agent ID, step 108, the CRS checks 15 whether a customer profile exists, step 110. If a profile exists, then the computer accesses the profile and makes any npcp-csAry modifications, step 112. If a profile does not exist, then the CRS host computer creates one, step 114. Then the CRS host creates a PNR
20 record, step 116, and develops possible itineraries, step 118, for presentation to the agent. Each itinerary is composed of individual travel segments, for example a round-trip, non-stop flight includes a two segment. The agent then selects the best itinerary and, thus, the best segments and requests a reservation, step 120. Upon receipt of the reservation request, the CRS host then books the reservation, step 122. If the CRS is not re~uired to issue a ticket, step 124, then the record is finished.
Otherwise, the CRS proceeds with issuing the ticket. First, the price of the ticket is calculated in the currency specified in the agency profile, step 126.
Most CRSs are updated on a daily basis with current currency exchange rates. Then, the ticket is issued, 35 step 128.
W O 97/08639 PCT~US96/13758 If the agency profile indicates that an AIR is requested, step 129, then the CRS prepares and trans~its the ~IR record and ticket to the global computer, st,ep 130~ The AIR information is loaded into central global co~nputer system 10, step 134.
once the information is received, the computer determine whether the price of the segment in the AIR is reflected in the same currency as a predetermined global currency. If the price is in the global currency or 10 global replorting currency, then the global reporting currency representation of the price information is loaded into global database, step 142. The system i~;
designed to allow a user to specify at least a primary currency for storage and reporting purposes. For the purposes of this discussion "global currency" and "primary currency" are used interchangeably.
If the currency in the AIR is not the global reporting currency, then global computer 10 determines if the ~çh~nge rate exists, step 136. If not, then a new exchange ratets) must be added, step 138. Otherwise, the system utilizes the existing rates which should be updated. This step could be performed automatically if the ~h~nge rate is provided from a source capable of transmitting electronic data such as the CRS, Reuters Telerate, or any other source of electronic ~ch~nge rates. It is, however, preferable for an authorized person to input the information manually. In addition to the l~çh~nge rate sources mentioned above, the information is available in financial periodicals and 30 electronic services. The received price information is converted, step 140, and loaded and along with the ot:her received information into global database 14, step 142.
If the AIR option is not selected, then the CRS
host immediately issues the ticket and finishes the 35 recoxd, step lZ4.
In order to prepare an AIR, the CRS host parses the PNR created by the CRS, as shown in FIG. 4, step 130.
The host selects which information from the PNR is n~c~cE~ry and reformats the data for tr~n~icsion to the locally operated computer system. The PNR could be directly downloaded to the global database. However, it is much more efficient to format the data in the host, which facilitates the downloading of the data at the global database.
lo It is well known to those skilled in the art that any information selected from the PNR could be arranged in ~ny number of ways. Also, it is well known that the information could be stored in any storage medium rather than a dat A h;~
It is also well know to those of ordinary skill in the art that any or all information in the PNR can be transferred.
In the preferred embodiment of this invention, the information from the PNR is stored in the AIR in a number of predetermined fields, each represented by a specific code. FIG. 5 shows an example of an AIR developed from a PNR of a passenger flying from Acapulco, Mexico to Cancun, Mexico on Mexicana Airlines. However, each AIR
will vary depending on the travel information.
In the embodiment of the invention described above, the information from the AIR is then downloaded into central global computer database 14. The information can be loaded into any database utilizing any database management systems, such as AS400 relational dat~h~fi~.
The process described above could be modified by one of ordinary skill in the art to include enhancements that make the over all system more efficient. For example, the system could be reconfigured such that different component perform different functions. The AIR
WO 97/08639 PCT~US96/13758 could be loaded into any storage medium, which can be accessed for subsequent processing of the data in the AI~.
FIG. 6 shows a flow diagram of an enhanced version and the preferred embodiment of this invention, wherein travel agency 200 operates a locally operated computer to access CRS 202 and global computer 204. The travel reservation information generated by the CRS is stored in a remote data storage medium, such as global dat~hAs~ 206 lo con~rolled by remote global computer system 204.
In FIG. 6, a travel agent at travel agency 200 requests, books, and tickets travel itineraries in the CRS, step 208, in the same or similar manner to that as shown in FIG. 3, steps 100-192. As stated above, this process could be modified in accordance with the teachings of United States Patent Application Serial No.
08/317,860 to provide pre-ticketed data from CRS 208, but for discussion purposes, only the system utilizing ticketed data is described.
In this emboAim~nt of the invention, an operator may select whether to have the tickets issue from CRS
202, step 210, or from global computer 204, step 212.
Regardless of which equipment issues the ticket, the CRS
provides an AIR record to global computer 204, which is then processed, step 213, and stored in global database 206, step 213.
Global computer 204 is designed to accept, process, and if necessary to store information from several other sources. For example, the system is designed to accept foreign currency exchange rate iniEormation 220. This information can be received from an~ of the sources from the description of FIG. 3 above.
The system is also designed to interface with vendors 222 and allow them to provide expense, refund, and romm;ssion 35 in~o~ mation 224 to global database 206. Information is used for reconciliation, reporting, and vendor settlements. Vendors 222 then are able to receive payable information, vendor checks 226, from the database such as travel and expense checks.
Global computer 204 also accepts information regarding: payments, refunds, adjustment, and returned tickets 228 from customers through travel agency 200;
cash in receipts from retail point-of-sale operation from external data feed 230; and sale, discount, and payment lo information from credit card service establ;~h~nts 231.
Global computer 204 could be programmed to accept other type of information by one of ordinary skill in the art.
With all the information provided by the sources mentioned above, global computer 204 is capable of issuing checks in any selected language 232 and generating reports 234 for travel agency 200 and providing sales information, discounts, and payment to credit card service establishments 231. The sales information and the country of origin information allow global computer 204 to also generate local tax information 236 that can be used for many purposes including, but not limited to, obtaining refund of sales taxes paid in certain countries.
In addition to all the features mentioned above, the system shown in FIG. 6 performs all of the functions of the currently marketed MAX back office accounting system, marketed by the assignee of the present invention. These features include end-of-the-day processing 240, a general ledger database 242, process 30 and generate financial reports 248 for both management 250 and accounting 246. Journal entries from accounting are also processed 244 and downloaded into general ledger database 242. The system also processes and generates reports 252 aside from strict accounting reports for management 250. Unlike all the prior systems, the reports generated by this system include travel price information in a selected currency that is real-time and accur.ate and are in a preselected language using a preselected date/format/separator and preselected address format.
Since an AIR is instantaneously generated every time a reservation is ticketed, the information in the global database is current with the actual prices represented in the selected currency at all times. T]le lo data is also maintained in the database until it is archived an.d purged. Therefore, the reports can be generated cn any computer system, such as an operational center compluter that includes current, accurate information. providing a much more useful system.
The process for automatically updating the global travel information database 14 (FIG. 2) every time a reservation. is ticketed in the CRS described above utilizes an. AIR. However, the process could be modified by one of ordinary skill in the art to download any type of travel reservation information. The information could include any type of record. For example, the travel reservation information in the PNR could be directly downloaded from the PNR to the global computer system upon detection of the ticketing of a reservation. No AIR
is required.
The system could also be modified to accept travel reservation information from other CRSs. Either the information must be sent in the form of an AIR or anot:her for~at from another CRS recognized by the global computer sysltem, so that any relevant information may be extracted.
A portion of the database structure of the global database of the preferred embodiment of this invention, the company database structure, is shown in FIGs. 7a-7c.
This company database structure design is implemented to W O 97/08639 PCT~US96/13758 compliment the existing database file structure shown in FIGs. la-lf. However, the same process and method (described below) could be implemented in a unique design by one of ordinary skill in the art or be implemented with any single currency or single country back-office or mid-office system well known to those of ordinary skill in the art.
Global database 206 of FIG. 6 is structured to include two functional portions; a validation portion and 10 a travel information record storing portion. The travel information record storing portion is comprised of the files shown in FIGs. la-lf plus the Tax Detail and the Tax Detail Audit files. However, before the data is stored in the database, it is validated using the information stored in the portion of the database having the structure of FIGs. 7a-7d.
The validation portion allows for the handling of travel reservation data generated in multiple currencies, in multiple languages, multiple ticket forms, multiple ticket types, and multiple date formats.
FIG. 7a shows all the files of the company database structure. It is intended that a "co~rAny"
represent, for illustrative purposes, a geographical or operational division of an entity using this invention.
For example, an international entity having need to consolidate travel reservation information on a per country or per geographical regional basis, would set up a company database structure for each country or geographical region.
The information stored in the company database files is specific to the entity. For example, the Cities file includes all of the city codes and country codes of the cities to which customers or employees travel. The Country file contains a list of the full name of all the countries whose country codes exist in the Cities file.
Since the city and country code are constant all over the world, glohal computer uses the codes instead of the city and countr~ name to avoid miss spellings or variations in spelling.
All of the other files contain similar information zs follows. For example: the City Types file contains codes that pertain to the type of city; the Settlement Types file contains information that identifies the type of method used for reporting/processing within a Company, o such as Airline Reporting Corporation ("ARC"), Bank Settlement Plan ("BSP"), or Direct Form of Payment ("DFOP"); the States file contains the authorized postal abbreviations and associated names for each state, province or co~--L~; and the Form Codes files contain all 15 specific criteria regarding ticket forms.
The Tax Cross Reference files contains the valid tax codes ~or each state, province or county in a country and the Tax Rules file contains rules and regulations for applicable taxes in each country. These files are 20 accessed by global computer 204 to determine applicable taxes for a state, province, or county, to validate the tax codes, and to calculate the taxes on cnmm;~cion income and credit card service charges by processes well known to those of ordinary skill in the art.
The Language file contains attributes needed t:o specify a desired language by country specification.
The Product Types file consists of the codes used to identif~ and classify types of services rendered.
While the Secondary Product Types file includes 30 information on specific types of service within a product type.
The Form of Payments file contains all specific criteria regarding forms of payment on an invoice.
The Meal Codes file contains codes and 35 descriptions used by airlines for each menu.
W O 97/08639 PCT~US96/13758 The Address Elements file contains specific data elements defining fields of a given address lay out.
The Branch file lists all the branches (include name, address, etc.) that are part of the global system along with bank accounts and pseudo cities as shown in FIG. 7d branches.
The Customers file includes customer and vendor identification information, such as name, address, etc.
FIG. 7c shows a file information break down. The o information stored in these files includes (from left to right) charts of account information for sales/cost of sales, edit masks for ~uality control, quality control selections, summary of activity for a customer with number and amount of tickets and refunds by month, vendor summary information, accounting chart information for each vendor and branch, and conversion information to cross-reference information in other back-office systems to the present invention.
The Bank file defines the system bank accounts.
The Credit Card file contains credit card codes for service establishment processing.
The Agents file includes all agent numbers and names and is broken down in to the files shown in FIG. 7b which contain agent sines (duty codes), summary of agent activity including number and amount of tickets and refunds, ~uality control for each agent, and conversion information to cross-reference agency numbers from other back-office systems to a unique number in the present invention.
The User file contains user preference attributes and specific operating characteristics, such as date formats.
The Address Formats file contains all address elements available for user selection.
WO 97/08639 PCT~US96/137S8 The Rate of Exchange Variance and Rate of Exchange files contain all the rates of exchange that may be nec~sAry to convert the travel segment prices to the primary reporting or global currency. The currency file contains the designated primary reporting currency and any other secondary reporting currencies. Once Global computer 204 receives an AIR, it accesses the currency database to determine the primary or global reporting currency. Then, it compares the currency in the AIR t:o 10 the global currency. If the currencies are different, then global computer access the Rate of Exchange Variance and Rate of Exchange files (which should be updated fre~lently to reflect the accurate exchange rate) to ac~uire the ~YchA~ge rate to convert the AIR currency to 15 the global currency. Then, global computer 204 stores the price in both the original and global currencies in the ~nvoice Master files and subfiles of the storing database structure shown in FIG. la.
After step 140 of FIG. 3 is executed, the AIR is parsed to Eind the agency number, from which the comrArly can be determined. Once the company is determined, then the system access the company structure portion of the database to determine the primary reporting or global currency. Then the conversion and storing process described in the previous paragraph is executed.
Many of the entries in the comrAny database structure are used for reporting purposes. For example, a company database can be set up for a company in Canada, specifying that all reports be generated in French by placing French in the language field and that all addresses be reported in the format stored in the Address Format file. Date formats are also used for displaying or reporting and are specified in the Company, Branch, Customer and Bank files, depending on the hierarchy or the function. Thus, when the proper formats are determined from the company structure database, the storing database is accessed to acquire the appropriate data that needs to be reported.
The foregoing software was developed in RPG/400 and CLP/400 using object oriented based t~hni~ues and structured methodology bases. However, it will be obvious to anyone of ordinary skill in the art that the aforementioned program may be developed in a different P1 OYL amming language using non-object oriented 10 t~chn; ques. Even though the relational database package was used, the foregoing database configuration could be implemented in an object-oriented database or any other type of storage medium by one of ordinary skill in the art. All the equipment described in the above travel reservation system is readily available.
The embodiments of the invention described above all utilize a database in the locally operated and global computer system. However, any type of storage means may be used for storing the data. It is also not necessary that the locally operated computer system have databases, all information could be generated from the global database. In the alternative, the global database could be located at one of the locally operated computer system sites, wherein access for the other locally operated computer systems is provided.
The term "locally" is only use for illustrative purposes. For example, the operational center computer may also be located at one of the locally operated computer system sites and have access the CRS. It is not 30 required that the operational center computer be a stand-alone system, however, it is desirable.
The systems and methods described above could be modified by one of ordinary skill in the art to incorporate the functionality of the global computer or an global computer into a centralized processing system CA 02229037 l998-02-06 WO g7/08639 PCT/l~S96~13758 or service bureau, such as the one provided by the assiqnee of the present invention, so that several r-omp~n;es or agencies could remotely or locally access a single global computer for centralizing travel reservation information in a predetermined global currency.
The systems and methods described above could be modified by one of ordinary skill in the art to a systems and methods using only one locally operated c- _uLer o system capable of generating computer travel reservat;ion information including different currencies that re~uire converting before being loaded into the database.
The conversion of the currency can occur anywhere in the system or method as long as it occurs before the data is stored in the global data storage medium.
Also, the methods and systems described above could be altered to accept data manually or via electronic systems such as the Internet. The system described above could also be easily modified to provide the ability to access other electronic services or systems, such as the Internet.
The methods and systems described above could be modified by one of ordinary skill in the art to interface to a corporations main frame or internal computer system to exchange information. For example, the information from the global computer at a travel agency or corporate internal travel department could be down loaded into the main frame of a corporations to be entered into the corporations general ledger.
From the foregoing it will be seen that this invention is one well adapted to attain all of the features and objects hereinabove set forth, together with other advantages which are obvious and which are inherent to the methods and apparatuses.
It will be understood that certain features and subcombinations are of utility and may be employed without reference to other features and subcombinations.
This is contemplated by and is within the scope of the claims.
As many possible embodiments may be made of the invention without departing from the scope thereof, it is to be understood that all matter herein set forth or shown in the accompanying drawings is to be interpreted lo as illustrative and not in a limiting sense.
Claims (25)
1. A method of consolidating at least two travel reservation information records with at least two different currencies generated from a locally operated computer system, comprising the steps of selecting a global currency in which to represent prices associated with each travel segment, entering a first locally operated computer system, acquiring, in the first locally operated computer system, a first computer travel reservation information record with price of at least one travel segment represented in a first currency from a computer reservation system (CRS), representing the price of each segment in the global currency, storing information from the computer travel reservation information record and the price of each segment in the global currency in a global data storage medium, entering a second locally operated computer system, acquiring, in the second locally operated computer system, a second computer travel reservation information record with price of at least one travel segment represented in a second currency from the computer reservation system (CRS), representing the price of each segment in the second computer travel reservation information record in the global currency, and storing information from the second computer travel reservation information record and the price of each segment from the second record in the global currency in the global data storage medium.
2. The method of claim 1, wherein the computer travel reservation information record contains pre-ticketed information.
3. The method of claim 1, wherein the computer travel reservation information record contains ticketed information.
4. The method of claim 1, wherein the first locally operated computer system is in a first country with the first currency being the currency of the first country and the second locally operated computer system is in a second country with second currency being the currency of the second country.
5. The method of claim 1, wherein the global data storage medium is a database.
6. The method of claim 1, additionally comprising the steps of accessing the storage medium, and generating at least one report utilizing travel segment and converted price information stored in the global data storage medium.
7. The method of claim 6, wherein the information is displayed on an operational center computer.
8. The method of claim 6, wherein the report is printed from an operational center computer.
9. The method of claim 1, additionally comprising the steps of storing the price of the segments in the original currency in the global storage medium.
10. The method of claim 1, additionally comprising the step of downloading the information stored in the global storage medium to a corporate internal computer system.
11. A method of consolidating at least two travel reservation information records with at least two different currencies generated from locally operated computer systems, comprising the steps of selecting a global currency in which to represent prices associated with each travel segment, entering a first locally operated computer system, acquiring, in the first locally operated computer system, a first computer travel reservation information record with price of at least one travel segment represented in a first currency from a first computer reservation system (CRS), representing the price of each segment in the global currency, storing information from the computer travel reservation information record and the price of each segment in the global currency in the global data storage medium, entering a second locally operated computer system, acquiring, in the second locally operated computer system, a second computer travel reservation information record with price of at least one travel segment represented in a second currency from a second computer reservation system (CRS), representing the price of each segment in the second computer travel reservation information record in the global currency, and storing information from the second computer travel reservation information record and the second price of each segment from the second record in the global currency in the global data storage medium.
12. A method of consolidating at least two travel reservation information records with at least two currencies generated from a locally operated computer system, comprising the steps of selecting a global currency in which to represent price associated with each travel segment, entering a locally operated computer system, acquiring, in the locally operated computer system, a first computer travel reservation information record with price of at least one travel segment represented in a first currency from a first computer reservation system (CRS), representing the price of each segment in the global currency, storing information from the computer travel reservation information record and the price of each segment in the global currency in a global data storage medium, acquiring, in the locally operated computer system, a second computer travel reservation information record with price of at least one travel segment represented in a second currency from the computer reservation system (CRS), representing the price of each segment in the global currency, and storing information from the second computer travel reservation information record and the second price of each segment from the second record in the global currency in the global data storage medium.
13. The method of claim 12, additionally comprising the steps of acquiring, in the locally operated computer system, a third computer travel reservation information record with price of at least one travel segment represented in a currency from a second computer reservation system (CRS), representing the price of each segment in the global currency, and storing information from the third computer travel reservation information record and the price of each segment from the third record in the global currency in the global data storage medium.
14. A system for centralizing and standardizing in a predetermined global currency travel reservation information having at least two different currencies generated from locally operated computer systems for subsequent analysis, comprising a first locally operated computer system, a second locally operated computer system, a global data storage medium, at least one computerized reservation system (CRS) accessible by the first and second locally operated computer systems that has the capability of (a) generating at least one travel segment and price associated with each segment, (b) booking reservations for a selected segments, (c) generating travel reservation information in response to a request from the first or second locally operated computer systems, and (d) detecting the booking of a reservation with the price of each booked segment, means for representing the price of each booked segment in the predetermined global currency, whereby each price that is not in the global currency is converted to the global currency, means for transferring segment reservation information, and the global currency representation of the price of each booked segments to the global data storage medium, and means for storing the transferred segment reservation information, and the price of each booked segment in the global currency in the global data storage medium.
15. The system in accordance with claim 14, wherein the first and second locally operated computer systems are connected to the CRS through communication means.
16. The system in accordance with claim 15, wherein the communication means includes a communication modem and phone lines.
17. The system in accordance with claim 15, wherein the global storage medium includes a database.
18. The system in accordance with claim 14, wherein the first and second locally operated computer systems access different CRSs.
19. A system for centralizing and standardizing in a predetermined global currency travel reservation information generated in at least two different currencies from a locally operated computer system for subsequent analysis, comprising a locally operated computer system in a country, a global data storage medium, at least one computerized reservation system (CRS) accessible by the locally operated computer system that is capable of (a) generating travel segments and prices associated with each segment, (b) booking reservations for a selected segments, (c) generating travel reservation information in response to a request from the locally operated computer system, and (d) detecting the booking of a reservation with the price of each booked segment, means for representing the price of each segment in the predetermined global currency, whereby each price that is not in the global currency is converted to the global currency, means for transferring segment reservation information, the global currency representation of the price of each booked segments to the global storage medium for downloading into the database, and means for storing the transferred segment:
reservation information, and the converted price of each booked segment in the global data storage medium.
reservation information, and the converted price of each booked segment in the global data storage medium.
20. A system for centralizing and standardizing in a predetermined currency ticketed travel reservation information generated from locally operated computer systems in at least two countries for subsequent analysis, comprising a first locally operated computer system in a first country, a second locally operated computer system in a second country, a global data storage medium, at least one computerized reservation system (CRS) accessible by the first and second locally operated computer systems that has the capability of (a) generating at least one travel segment and prices associated with each segment, (b) booking reservations for a selected segments, (c) generating travel reservation information in response to a request from the first or second locally operated computer systems, and (d) detecting the ticketing of a reservation with the price of each ticketed segment, means for representing the price of each segment in the predetermined currency, whereby each price that is not in the global currency is converted to the global currency, means for transferring segment reservation information, the global currency representation of the price of each ticketed segment to the global data storage medium, and means for storing the transferred segment reservation information, and the price of each ticketed segment in the global currency in the global data storage medium.
21. A system for centralizing and standardizing in a predetermined global currency travel reservation information generated in at least two different currencies from a locally operated computer system for subsequent analysis, comprising a locally operated computer system in a country, a global data storage medium, at least one computerized reservation system (CRS) accessible by the locally operated computer system that is capable of (a) generating travel segments and prices associated with each segment, (b) booking reservations for a selected segments, (c) generating travel reservation information in response to a request from the locally operated computer system, and (d) detecting ticketing of a reservation with the price of each booked segment, means for representing the price of the segment in the predetermined global currency, whereby each price that is not in the global currency is converted to the global currency, means for transferring segment reservation information, the global currency representation of the price of each ticketed segment to the global storage medium, and means for storing the transferred segment reservation information, and the price of each ticketed segment in the global currency in the global data storage medium.
22. The system in accordance with claim 21, wherein the global storage medium includes a database.
23. A method of consolidating travel reservation information generated from locally operated computer systems in at least two countries, comprising the steps of selecting a global currency in which to represent price associated with each travel segment, entering a first locally operated computer system in a first country having a first country currency, accessing a computer reservation system (CRS) from the first locally operated computer system, generating, in the CRS, at least one travel segment for a traveler, selecting at least one travel segment with price of the selected segment, for booking, booking a reservation at the price in the CRS
for each selected travel itinerary, representing the price of the segment in the global currency, storing information regarding the booked travel segment and the price in the global currency in the global data base, entering a second locally operated computer system in a second country have a second country currency, accessing the CRS from the second locally operated computer system, and generating, in the CRS, at least one travel segment for a traveler, selecting at least one second travel segment with price of the second travel segment, for booking using the second locally operated computer system, booking a reservation at the price in the CRS
for the second travel segment, representing the price of the second travel segment in the global currency, storing information regarding the second booked travel segment and the price in the global currency in the global data base.
for each selected travel itinerary, representing the price of the segment in the global currency, storing information regarding the booked travel segment and the price in the global currency in the global data base, entering a second locally operated computer system in a second country have a second country currency, accessing the CRS from the second locally operated computer system, and generating, in the CRS, at least one travel segment for a traveler, selecting at least one second travel segment with price of the second travel segment, for booking using the second locally operated computer system, booking a reservation at the price in the CRS
for the second travel segment, representing the price of the second travel segment in the global currency, storing information regarding the second booked travel segment and the price in the global currency in the global data base.
24. A method of reporting travel reservation information generated from at least one locally operated computer system and at least one computer reservation system (CRS) and stored in a global data storage medium, comprising the steps of selecting a company reporting format with a reporting language and global currency, storing company reporting format in the global data storage medium with the reporting language and the global currency, entering a locally operated computer system, accessing a computer reservation system (CRS) from the locally operated computer system, generating, in the CRS, at least one travel segment, selecting at least one travel segment with price of the selected segment for booking, booking a reservation at the price in the CRS
for each selected travel segment, representing the price of the segment in the global currency, storing information regarding the booked travel segment and the price in the global currency in the global data storage medium, accessing the company reporting format and the stored booked travel segment and price in the global currency information in the global data storage medium, and reporting the booked travel segment and price information in the company reporting format.
for each selected travel segment, representing the price of the segment in the global currency, storing information regarding the booked travel segment and the price in the global currency in the global data storage medium, accessing the company reporting format and the stored booked travel segment and price in the global currency information in the global data storage medium, and reporting the booked travel segment and price information in the company reporting format.
25. The method of claim 24, wherein the company reporting format additionally comprises a reporting address format and a reporting date format.
Applications Claiming Priority (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| US08/521,354 US5644721A (en) | 1995-08-30 | 1995-08-30 | Multiple currency travel reservation information management system and method |
| US08/521,354 | 1995-08-30 |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CA2229037A1 true CA2229037A1 (en) | 1997-03-06 |
Family
ID=24076423
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CA002229037A Abandoned CA2229037A1 (en) | 1995-08-30 | 1996-08-28 | Multiple currency travel reservation information management system and method |
Country Status (11)
| Country | Link |
|---|---|
| US (1) | US5644721A (en) |
| EP (2) | EP1143366A3 (en) |
| CN (1) | CN1201539A (en) |
| AT (1) | ATE210319T1 (en) |
| AU (1) | AU714330B2 (en) |
| CA (1) | CA2229037A1 (en) |
| DE (1) | DE69617737T2 (en) |
| DK (1) | DK0870260T3 (en) |
| ES (1) | ES2168502T3 (en) |
| PT (1) | PT870260E (en) |
| WO (1) | WO1997008639A1 (en) |
Families Citing this family (118)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5794207A (en) | 1996-09-04 | 1998-08-11 | Walker Asset Management Limited Partnership | Method and apparatus for a cryptographically assisted commercial network system designed to facilitate buyer-driven conditional purchase offers |
| WO1997003404A1 (en) * | 1995-07-11 | 1997-01-30 | Hitachi, Ltd. | Service offering system |
| US6442526B1 (en) | 1995-09-06 | 2002-08-27 | The Sabre Group, Inc. | System for corporate travel planning and management |
| US7050986B1 (en) | 1995-09-06 | 2006-05-23 | The Sabre Group, Inc. | System for corporate traveler planning and travel management |
| US6119094A (en) * | 1996-02-29 | 2000-09-12 | Electronic Data Systems Corporation | Automated system for identifying alternate low-cost travel arrangements |
| US6839679B1 (en) * | 1996-03-18 | 2005-01-04 | Electronic Data Systems Corporation | Automated travel pricing system |
| US6240396B1 (en) | 1996-09-04 | 2001-05-29 | Priceline.Com Incorporated | Conditional purchase offer management system for event tickets |
| EP0932869A4 (en) * | 1996-10-21 | 2005-07-13 | Orissa Inc | Transportation network system |
| US5884274A (en) * | 1996-11-15 | 1999-03-16 | Walker Asset Management Limited Partnership | System and method for generating and executing insurance policies for foreign exchange losses |
| US6460020B1 (en) | 1996-12-30 | 2002-10-01 | De Technologies, Inc. | Universal shopping center for international operation |
| JPH1166193A (en) * | 1997-08-14 | 1999-03-09 | Hitachi Ltd | Method and device for managing electronic money and storage medium where electronic money managing program is stored |
| US6107932A (en) * | 1997-08-22 | 2000-08-22 | Walker Digital, Llc | System and method for controlling access to a venue using alterable tickets |
| US6898591B1 (en) * | 1997-11-05 | 2005-05-24 | Billy Gayle Moon | Method and apparatus for server responding to query to obtain information from second database wherein the server parses information to eliminate irrelevant information in updating databases |
| US6721715B2 (en) | 1998-03-30 | 2004-04-13 | Martin A. Nemzow | Method and apparatus for localizing currency valuation independent of the original and objective currencies |
| US6295521B1 (en) | 1998-07-02 | 2001-09-25 | Ita Software, Inc. | Travel planning system |
| US6307572B1 (en) | 1998-07-02 | 2001-10-23 | Ita Software, Inc. | Graphical user interface for travel planning system |
| US6381578B1 (en) | 1998-07-02 | 2002-04-30 | Ita Software, Inc. | Factored representation of a set of priceable units |
| US6377932B1 (en) | 1998-07-02 | 2002-04-23 | Ita Software, Inc. | Rules validation for travel planning system |
| US6609098B1 (en) | 1998-07-02 | 2003-08-19 | Ita Software, Inc. | Pricing graph representation for sets of pricing solutions for travel planning system |
| US6275808B1 (en) | 1998-07-02 | 2001-08-14 | Ita Software, Inc. | Pricing graph representation for sets of pricing solutions for travel planning system |
| US6067532A (en) * | 1998-07-14 | 2000-05-23 | American Express Travel Related Services Company Inc. | Ticket redistribution system |
| US6542875B1 (en) * | 1998-08-21 | 2003-04-01 | Arcon Capital, Llc | Charitable and public funding using tax credits and passive losses |
| US6434536B1 (en) * | 1998-12-23 | 2002-08-13 | Timothy S. Geiger | Methods and systems for commerce |
| EP0999511A1 (en) * | 1999-02-05 | 2000-05-10 | Manus Bray | A method and system for implementing currency calculations in a computer system |
| US6658390B1 (en) | 1999-03-02 | 2003-12-02 | Walker Digital, Llc | System and method for reselling a previously sold product |
| US8751272B1 (en) * | 1999-07-20 | 2014-06-10 | Expedia, Inc. | Fare compare—a system for collecting and displaying price information |
| US8706630B2 (en) | 1999-08-19 | 2014-04-22 | E2Interactive, Inc. | System and method for securely authorizing and distributing stored-value card data |
| US7333955B2 (en) | 2001-09-24 | 2008-02-19 | E2Interactive, Inc. | System and method for securing communication service |
| US6434533B1 (en) | 1999-10-27 | 2002-08-13 | Market Data Systems, Inc. | Method for the exchange, analysis, and reporting of performance data in businesses with time-dependent inventory |
| US20080154630A1 (en) * | 1999-11-01 | 2008-06-26 | Ita Software, Inc. | Method for Generating A Diverse Set of Travel Options |
| US7340403B1 (en) | 1999-11-01 | 2008-03-04 | Ita Software, Inc. | Method, system, and computer-readable medium for generating a diverse set of travel options |
| US6801226B1 (en) * | 1999-11-01 | 2004-10-05 | Ita Software, Inc. | Graphical user interface for travel planning system |
| US7340402B1 (en) | 1999-11-01 | 2008-03-04 | Ita Software, Inc. | Generating a diverse set of travel options |
| US7302399B1 (en) * | 1999-11-10 | 2007-11-27 | Electronic Data Systems Corporation | Method and system for processing travel reservation data |
| US20010047289A1 (en) * | 2000-04-14 | 2001-11-29 | Vacation. Com Corporation | System, method, and computer program product for administering a distribution channel for the promotion and sale of products and services |
| US20070038523A1 (en) * | 2000-06-19 | 2007-02-15 | E4X Inc. | System and method for transactional hedging |
| US6892184B1 (en) * | 2000-06-19 | 2005-05-10 | E4X Inc. | System and method for multiple currency transactions |
| US7395231B2 (en) * | 2000-07-14 | 2008-07-01 | American Express Travel Related Services Company, Inc. | Fee allocator system and method |
| RU2222825C2 (en) * | 2000-07-19 | 2004-01-27 | Закрытое акционерное общество "ИНФОФЛАЙВЭЙ" | Global computer-based sales system built around network information technologies |
| SE0002811D0 (en) * | 2000-08-03 | 2000-08-03 | Ticketanywhere Europ Ab | Method of handling electronic tickets |
| AU2001287171A1 (en) * | 2000-08-16 | 2002-02-25 | Airlines Reporting Corporation | Method and system for processing and settlement of travel transactions |
| US20040220815A1 (en) * | 2000-08-18 | 2004-11-04 | Johanne Belanger | Apparatus and method for the compilation, assembly, and distribution of product documentation and associated information |
| US7899690B1 (en) | 2000-08-18 | 2011-03-01 | The Crawford Group, Inc. | Extended web enabled business to business computer system for rental vehicle services |
| US7275038B1 (en) * | 2000-08-18 | 2007-09-25 | The Crawford Group, Inc. | Web enabled business to business operating system for rental car services |
| US8600783B2 (en) | 2000-08-18 | 2013-12-03 | The Crawford Group, Inc. | Business to business computer system for communicating and processing rental car reservations using web services |
| KR20020017020A (en) * | 2000-08-28 | 2002-03-07 | 박경용 | A method for ticket reservation and issue using Internet |
| US7668740B1 (en) | 2000-09-22 | 2010-02-23 | Ita Software, Inc. | Method, system, and computer program product for interfacing with information sources |
| US7660740B2 (en) | 2000-10-16 | 2010-02-09 | Ebay Inc. | Method and system for listing items globally and regionally, and customized listing according to currency or shipping area |
| US7231366B1 (en) | 2000-11-15 | 2007-06-12 | Heller Financial, Inc. | Global vendor financing system and method |
| WO2002048825A2 (en) * | 2000-11-15 | 2002-06-20 | Bagley, Dallin | System and method for guiding a computer user to promotional material |
| KR20010016338A (en) * | 2000-12-04 | 2001-03-05 | 최진욱 | The information supply and business agency system of travel |
| US20020174031A1 (en) * | 2001-03-06 | 2002-11-21 | Andrew Weiss | System and method for processing multi-currency transactions at a point of sale |
| AU2002258901B2 (en) | 2001-04-20 | 2007-03-29 | American Express Travel Related Services Company, Inc. | System and method for travel carrier contract management and optimization |
| CA2347396A1 (en) * | 2001-05-11 | 2002-11-11 | Webcc Inc. | Method and for secure, anonymous electronic financial transactions |
| US20020174148A1 (en) * | 2001-05-18 | 2002-11-21 | International Business Machines Corporation | System and method for formatting international shipping addresses |
| US7305356B2 (en) * | 2001-05-25 | 2007-12-04 | Amadeus Americas, Inc. | Travel value index |
| WO2003005161A2 (en) * | 2001-07-02 | 2003-01-16 | American Express Travel Related Services Company, Inc. | System and method for airline purchasing program management |
| US20040044664A1 (en) * | 2001-07-10 | 2004-03-04 | Sabre Inc. | Systems and methods for applying customer DNA to airline service and customer relationship management environments |
| KR20030009014A (en) * | 2001-07-21 | 2003-01-29 | 한종섭 | reservation method of train and a tour and fieldwork etc.. using internet. |
| US7499864B2 (en) * | 2002-01-25 | 2009-03-03 | American Express Travel Related Services Company, Inc. | Integrated travel industry system |
| US20050288974A1 (en) * | 2001-08-23 | 2005-12-29 | American Express Travel Related Services Company, Inc. | Travel service broker system and method |
| US20040260581A1 (en) * | 2001-08-23 | 2004-12-23 | American Express Travel Related Services Company, Inc. | Travel market broker system |
| US7539620B2 (en) * | 2002-07-02 | 2009-05-26 | American Express Travel Related Services Company, Inc. | System and method for facilitating transactions among consumers and providers of travel services |
| US8024206B2 (en) * | 2001-08-30 | 2011-09-20 | Aol Inc. | Travel |
| US7752266B2 (en) | 2001-10-11 | 2010-07-06 | Ebay Inc. | System and method to facilitate translation of communications between entities over a network |
| US8712811B2 (en) | 2001-10-16 | 2014-04-29 | Concur Technologies, Inc. | Method and systems for detecting duplicate travel path |
| US7974892B2 (en) * | 2004-06-23 | 2011-07-05 | Concur Technologies, Inc. | System and method for expense management |
| US20030120526A1 (en) * | 2001-10-16 | 2003-06-26 | Jonathan Altman | System and method for managing booking and expensing of travel products and services |
| US10115128B2 (en) | 2010-10-21 | 2018-10-30 | Concur Technologies, Inc. | Method and system for targeting messages to travelers |
| US9400959B2 (en) | 2011-08-31 | 2016-07-26 | Concur Technologies, Inc. | Method and system for detecting duplicate travel path information |
| US9286601B2 (en) | 2012-09-07 | 2016-03-15 | Concur Technologies, Inc. | Methods and systems for displaying schedule information |
| US7805323B2 (en) | 2002-01-25 | 2010-09-28 | American Express Travel Related Services Company, Inc. | System and method for processing trip requests |
| US8788302B1 (en) * | 2002-03-20 | 2014-07-22 | Ncr Corporation | Method of controlling a self-service terminal |
| US8078505B2 (en) | 2002-06-10 | 2011-12-13 | Ebay Inc. | Method and system for automatically updating a seller application utilized in a network-based transaction facility |
| US8108231B2 (en) | 2002-06-14 | 2012-01-31 | The Crawford Group, Inc. | Method and apparatus for improved customer direct on-line reservation of rental vehicles |
| US20040039612A1 (en) | 2002-06-14 | 2004-02-26 | Neil Fitzgerald | Method and apparatus for customer direct on-line reservation of rental vehicles |
| US20040138906A1 (en) * | 2002-07-01 | 2004-07-15 | Fagan Catherine J.M. | Custom destination guidebook system |
| US20040088204A1 (en) * | 2002-10-30 | 2004-05-06 | Christopher Plum | Method of retrieving a travel transaction record and an image of its supporting documentation |
| US7676376B2 (en) * | 2003-03-10 | 2010-03-09 | U-Haul International, Inc. | Rate and distribution system |
| US9881308B2 (en) | 2003-04-11 | 2018-01-30 | Ebay Inc. | Method and system to facilitate an online promotion relating to a network-based marketplace |
| US20040249682A1 (en) * | 2003-06-06 | 2004-12-09 | Demarcken Carl G. | Filling a query cache for travel planning |
| US20040249799A1 (en) * | 2003-06-06 | 2004-12-09 | Demarcken Carl G. | Query caching for travel planning systems |
| US20040249683A1 (en) * | 2003-06-06 | 2004-12-09 | Demarcken Carl G. | Query widening for query caches for travel planning systems |
| US7742985B1 (en) | 2003-06-26 | 2010-06-22 | Paypal Inc. | Multicurrency exchanges between participants of a network-based transaction facility |
| US8655309B2 (en) * | 2003-11-14 | 2014-02-18 | E2Interactive, Inc. | Systems and methods for electronic device point-of-sale activation |
| US20050125262A1 (en) * | 2003-12-04 | 2005-06-09 | American Express Travel Related Services | System for consumer travel service channel integration |
| US20070094129A1 (en) * | 2003-12-19 | 2007-04-26 | E2Interactive, Inc. D/B/A E2Interactive, Inc. | System and method for adding value to a stored-value account using provider specific pin |
| US7788116B2 (en) * | 2004-09-27 | 2010-08-31 | American Express Travel Related Services Company, Inc. | Travel savings assessment |
| US20060184422A1 (en) * | 2005-02-17 | 2006-08-17 | Sandy Cooper | Method and apparatus for accessing transaction data in a travel settlement system using a graphical user interface |
| US7979457B1 (en) * | 2005-03-02 | 2011-07-12 | Kayak Software Corporation | Efficient search of supplier servers based on stored search results |
| US7472822B2 (en) | 2005-03-23 | 2009-01-06 | E2Interactive, Inc. | Delivery of value identifiers using short message service (SMS) |
| US8583460B2 (en) * | 2005-07-19 | 2013-11-12 | Google Inc. | Pricing tickets based on constructing tables of pricing units for sub-portions of a ticket |
| US8271309B2 (en) | 2006-03-16 | 2012-09-18 | The Crawford Group, Inc. | Method and system for providing and administering online rental vehicle reservation booking services |
| US8639782B2 (en) | 2006-08-23 | 2014-01-28 | Ebay, Inc. | Method and system for sharing metadata between interfaces |
| US20080097798A1 (en) * | 2006-10-18 | 2008-04-24 | The Crawford Group, Inc. | Method and System for Creating and Processing Rental Vehicle Reservations Using Vouchers |
| US8160906B2 (en) * | 2006-12-12 | 2012-04-17 | The Crawford Group, Inc. | System and method for improved rental vehicle reservation management |
| US8566240B2 (en) * | 2007-01-16 | 2013-10-22 | E2Interactive, Inc. | Systems and methods for the payment of customer bills utilizing payment platform of biller |
| US8160907B2 (en) * | 2007-07-25 | 2012-04-17 | The Crawford Group, Inc. | System and method for allocating replacement vehicle rental costs using a virtual bank of repair facility credits |
| US8676672B2 (en) * | 2007-08-23 | 2014-03-18 | E2Interactive, Inc. | Systems and methods for electronic delivery of stored value |
| KR20120033338A (en) * | 2009-06-22 | 2012-04-06 | 라쿠텐 인코포레이티드 | Reservation information aggregation device, reservation information aggregation method, server, trip reservation status disclosure method, program, and recording medium |
| US20110016043A1 (en) * | 2009-07-20 | 2011-01-20 | Barbara Dornseif | Account transaction value added tax reimbursement |
| US20110137740A1 (en) | 2009-12-04 | 2011-06-09 | Ashmit Bhattacharya | Processing value-ascertainable items |
| EP2355023A1 (en) * | 2010-01-06 | 2011-08-10 | Amadeus S.A.S. | Improvements in or relating to a search engine and associated method |
| US20110218833A1 (en) * | 2010-03-02 | 2011-09-08 | International Business Machines Corporation | Service class prioritization within a controllable transit system |
| US10956999B2 (en) * | 2010-03-02 | 2021-03-23 | International Business Machines Corporation | Service class prioritization within a controllable transit system |
| US9031869B2 (en) | 2010-10-13 | 2015-05-12 | Gift Card Impressions, LLC | Method and system for generating a teaser video associated with a personalized gift |
| US9483786B2 (en) | 2011-10-13 | 2016-11-01 | Gift Card Impressions, LLC | Gift card ordering system and method |
| EP2605209A1 (en) * | 2011-12-13 | 2013-06-19 | Amadeus | System and method for providing enhanced information at the inventory |
| US10417677B2 (en) | 2012-01-30 | 2019-09-17 | Gift Card Impressions, LLC | Group video generating system |
| US10296968B2 (en) | 2012-12-07 | 2019-05-21 | United Parcel Service Of America, Inc. | Website augmentation including conversion of regional content |
| EP2746999A1 (en) * | 2012-12-19 | 2014-06-25 | Amadeus S.A.S. | Secured payment travel reservation system |
| US11219288B2 (en) | 2013-02-15 | 2022-01-11 | E2Interactive, Inc. | Gift card box with slanted tray and slit |
| US9565911B2 (en) | 2013-02-15 | 2017-02-14 | Gift Card Impressions, LLC | Gift card presentation devices |
| US10217107B2 (en) | 2013-05-02 | 2019-02-26 | Gift Card Impressions, LLC | Stored value card kiosk system and method |
| US20150221043A1 (en) * | 2014-02-05 | 2015-08-06 | Intuit Inc. | Method and system for providing global ready financial applications |
| US10262346B2 (en) | 2014-04-30 | 2019-04-16 | Gift Card Impressions, Inc. | System and method for a merchant onsite personalization gifting platform |
| US9965466B2 (en) | 2014-07-16 | 2018-05-08 | United Parcel Service Of America, Inc. | Language content translation |
| US10954049B2 (en) | 2017-12-12 | 2021-03-23 | E2Interactive, Inc. | Viscous liquid vessel for gifting |
Family Cites Families (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US4788643A (en) * | 1983-08-29 | 1988-11-29 | Trippe Kenneth A B | Cruise information and booking data processing system |
| US4827404A (en) * | 1986-04-14 | 1989-05-02 | Schlumberger Technology Corporation | Method and system for computer programming |
| US4862357A (en) * | 1987-01-28 | 1989-08-29 | Systemone Holdings, Inc. | Computer reservation system with means to rank travel itineraries chosen in terms of schedule/fare data |
| US4922439A (en) * | 1987-05-20 | 1990-05-01 | Nathan Greenblatt | Operational system for travel agents |
| US4937743A (en) * | 1987-09-10 | 1990-06-26 | Intellimed Corporation | Method and system for scheduling, monitoring and dynamically managing resources |
| US4885685A (en) * | 1987-09-18 | 1989-12-05 | L & C Family Partnership | Investment management system with travel usage funds indexed to customer account status |
| GB8723193D0 (en) * | 1987-10-02 | 1987-11-04 | Fusa K | Graphic display apparatus |
| US5125091A (en) * | 1989-06-08 | 1992-06-23 | Hazox Corporation | Object oriented control of real-time processing |
| US5191523A (en) * | 1989-11-06 | 1993-03-02 | Prism Group, Inc. | System for synthesizing travel cost information |
| US5270921A (en) * | 1990-12-19 | 1993-12-14 | Andersen Consulting | Virtual fare methods for a computerized airline seat inventory control system |
| US5253166A (en) * | 1991-03-29 | 1993-10-12 | Disc Corporation | Pre-ticket travel reservation record keeping system |
| US5237499A (en) * | 1991-11-12 | 1993-08-17 | Garback Brent J | Computer travel planning system |
| JPH05217074A (en) * | 1992-01-07 | 1993-08-27 | Nec Corp | Pos device |
| DE69412119T2 (en) * | 1993-10-26 | 1999-04-15 | Radisson Hotels Internationals | SYSTEM AND METHOD FOR REWARDING PERSONS WHO MAKE TRAVEL RESERVATIONS |
| CA2137167C (en) * | 1993-12-22 | 1999-09-21 | Tony J. Brice | Data management method and architecture |
-
1995
- 1995-08-30 US US08/521,354 patent/US5644721A/en not_active Expired - Lifetime
-
1996
- 1996-08-28 CN CN96196616.5A patent/CN1201539A/en active Pending
- 1996-08-28 DK DK96929749T patent/DK0870260T3/en active
- 1996-08-28 CA CA002229037A patent/CA2229037A1/en not_active Abandoned
- 1996-08-28 AU AU69025/96A patent/AU714330B2/en not_active Expired
- 1996-08-28 AT AT96929749T patent/ATE210319T1/en active
- 1996-08-28 DE DE69617737T patent/DE69617737T2/en not_active Expired - Lifetime
- 1996-08-28 PT PT96929749T patent/PT870260E/en unknown
- 1996-08-28 ES ES96929749T patent/ES2168502T3/en not_active Expired - Lifetime
- 1996-08-28 EP EP01110070A patent/EP1143366A3/en not_active Ceased
- 1996-08-28 WO PCT/US1996/013758 patent/WO1997008639A1/en active IP Right Grant
- 1996-08-28 EP EP96929749A patent/EP0870260B1/en not_active Expired - Lifetime
Also Published As
| Publication number | Publication date |
|---|---|
| PT870260E (en) | 2002-05-31 |
| CN1201539A (en) | 1998-12-09 |
| DK0870260T3 (en) | 2002-04-02 |
| EP1143366A3 (en) | 2003-10-29 |
| EP0870260A1 (en) | 1998-10-14 |
| ES2168502T3 (en) | 2002-06-16 |
| AU714330B2 (en) | 1999-12-23 |
| WO1997008639A1 (en) | 1997-03-06 |
| US5644721A (en) | 1997-07-01 |
| AU6902596A (en) | 1997-03-19 |
| DE69617737T2 (en) | 2002-08-08 |
| ATE210319T1 (en) | 2001-12-15 |
| EP1143366A2 (en) | 2001-10-10 |
| DE69617737D1 (en) | 2002-01-17 |
| EP0870260B1 (en) | 2001-12-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US5644721A (en) | Multiple currency travel reservation information management system and method | |
| US6023679A (en) | Pre- and post-ticketed travel reservation information management system | |
| US5191523A (en) | System for synthesizing travel cost information | |
| US8195538B2 (en) | Fee allocator system and method | |
| US6442526B1 (en) | System for corporate travel planning and management | |
| US6009408A (en) | Automated processing of travel related expenses | |
| US7050986B1 (en) | System for corporate traveler planning and travel management | |
| US5897620A (en) | Method and apparatus for the sale of airline-specified flight tickets | |
| US20020077871A1 (en) | Traveler service system with a graphical user interface for accessing multiple travel suppliers | |
| US20030120526A1 (en) | System and method for managing booking and expensing of travel products and services | |
| US20110258005A1 (en) | System and method for ancillary travel vendor fee expense management | |
| CA2660499C (en) | System for managing travelvouchers and method of same | |
| CN101198973A (en) | System for, and method of, providing travel-related services | |
| US20110071864A1 (en) | System and method for settling the payment of a travel e-ticket | |
| MXPA98001607A (en) | System and method of administration of information of travel reservations in multiple divi | |
| US20180075497A1 (en) | Database management system | |
| JP2023044263A (en) | Travel business support system | |
| JP2023154245A (en) | Data structure for travel business and accounting processing system using the same | |
| JP2023023528A (en) | Travel reservation information input system | |
| CN111599025A (en) | Touch inquiry ticketing system based on travel ticketing | |
| Thattiyakul | Ticket sales information system of Sub-tawan Co., Ltd | |
| Limpanatevin | Automobile spareparts system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| EEER | Examination request | ||
| FZDE | Discontinued |