EXM_ITINERARY_RESERVATIONS
This table contains information about travel itinerary bookings or reservations made, which includes reservations for air travel, hotel, car rental and/or rail transportation.
Details
-
Schema: FUSION
-
Object owner: EXM
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
EXM_ITINERARY_RESERVATION_PK |
ITINERARY_RESERVATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ITINERARY_RESERVATION_ID | NUMBER | 18 | Yes | Unique Identifier of a reservation in a travel itinerary. | |
| HOTEL_LOCATION_CODE | VARCHAR2 | 30 | Global Distribution System code of hotel location. | ||
| PICKUP_LOCATION_CODE | VARCHAR2 | 30 | Global Distribution System code of pickup location for vehicle rental. | ||
| RETURN_LOCATION_CODE | VARCHAR2 | 30 | Global Distribution System code of return location for vehicle rental. | ||
| TRAVEL_ITINERARY_ID | NUMBER | 18 | Yes | Itinerary to which reservation belongs. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| CONFIRMATION_NUM | VARCHAR2 | 32 | Confirmation number for HOTEL and VEHICLE RENTAL reservations. Null for AIR and RAIL reservations because confirmation numbe is stored at the travel segment level in EXM_RESERVATION_ITEMS table. | ||
| RESERVATION_TYPE | VARCHAR2 | 30 | Yes | Type of reservation such as AIR, HOTEL, RAIL or VEHICLE RENTAL. | |
| VERSION_NUMBER | NUMBER | 9 | Version number of imported reservation record. This number is incremented every time that data in reservation has been updated in the travel partner system from which data was imported. | ||
| VALIDATION_FAILURE_FLAG | VARCHAR2 | 1 | Indicates whether reservation has validation failures. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency of reservation amount. | ||
| AMOUNT | NUMBER | Reservation amount, which does not include tax. | |||
| TOTAL_TAX | NUMBER | Tax on reservation amount. | |||
| TOTAL_AMOUNT | NUMBER | Total reservation amount, which includes tax. | |||
| LOWER_AMOUNT | NUMBER | Lowest amount available in the booking tool that was not chosen by employee. | |||
| FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | 15 | Functional currency of primary ledger for business unit. | ||
| FUNCTIONAL_AMOUNT | NUMBER | Reservation amount, which does not include tax, converted to functional currency of primary ledger for Business Unit. | |||
| FUNCTIONAL_LOWER_AMOUNT | NUMBER | Lowest amount available in the booking tool that was not chosen by employee. This amount is converted to functional currency of primary ledger for business unit. | |||
| FUNCTIONAL_TOTAL_AMOUNT | NUMBER | Total reservation amount, which includes tax, that is converted to functional currency of primary ledger for business unit. | |||
| EXCHANGE_TYPE_CODE | VARCHAR2 | 30 | Conversion type used to convert amounts from transactional currency into functional currency. | ||
| EXCHANGE_RATE | NUMBER | Conversion rate used to convert amounts from transactional curency for functional currency. | |||
| MERCHANT_ID | NUMBER | 18 | Merchant identifier. This column is populated only if a match is found for merchant_code against EXM_MERCHANTS table as part of itinerary validation process. | ||
| MERCHANT_CODE | VARCHAR2 | 30 | Merchant code for Hotel Chain or Car Rental Agency. | ||
| MERCHANT_NAME | VARCHAR2 | 120 | Merchant name for hotel or car rental agency. | ||
| HOTEL_CODE | VARCHAR2 | 30 | Hotel code for a hotel reservation. | ||
| START_DATE_TIME | VARCHAR2 | 32 | Check-in date and time for hotel reservation and pickup time for vehicle rental. | ||
| END_DATE_TIME | VARCHAR2 | 32 | Checkout date and time for hotel reservation and drop-off time for vehicle rental. | ||
| NUMBER_OF_ROOMS | NUMBER | 3 | Number of hotel rooms for this hotel reservation. | ||
| ROOM_CODE | VARCHAR2 | 30 | Hotel room type for this hotel reservation. | ||
| BASE_RATE | NUMBER | Daily base rate for this hotel reservation. | |||
| RATE_DETAILS | VARCHAR2 | 240 | Details provided by the hotel for this hotel reservation. | ||
| NUMBER_OF_GUESTS | NUMBER | 3 | Number of guests for this hotel reservation. | ||
| ADDRESS_LINE_1 | VARCHAR2 | 240 | First line of address information for hotel or vehicle rental reservation. | ||
| ADDRESS_LINE_2 | VARCHAR2 | 240 | Second line of address information hotel or vehicle rental reservation. | ||
| ADDRESS_LINE_3 | VARCHAR2 | 240 | Third line of address information hotel or vehicle rental reservation. | ||
| ADDRESS_LINE_4 | VARCHAR2 | 240 | Fourth line of address information hotel or vehicle rental reservation. | ||
| CONTACT_NUMBER_1 | VARCHAR2 | 16 | First contact number hotel or vehicle rental reservation. | ||
| CONTACT_NUMBER_2 | VARCHAR2 | 16 | Second contact number hotel or vehicle rental reservation. | ||
| CONTACT_NUMBER_3 | VARCHAR2 | 16 | Third contact number hotel or vehicle rental reservation. | ||
| CONTACT_NUMBER_4 | VARCHAR2 | 16 | Fourth contact number hotel or vehicle rental reservation. | ||
| HOTEL_CITY | VARCHAR2 | 64 | City in which hotel is located for which reservation is made. | ||
| HOTEL_STATE | VARCHAR2 | 64 | State or province in which hotel is located for which reservation is made. | ||
| HOTEL_STATE_CODE | VARCHAR2 | 64 | Code of the state or province in which hotel is located for which reservation is made. | ||
| HOTEL_COUNTRY | VARCHAR2 | 64 | Country in which hotel is located for which reservation is made. | ||
| HOTEL_COUNTRY_CODE | VARCHAR2 | 64 | Code of the country in which hotel is located for which reservation is made. | ||
| HOTEL_GEOGRAPHY_ID | NUMBER | 18 | Geographical hotel location in Oracle Trading Community Architecture(TCA). This column will only be populated if a geographical match is found in TCA using hotel city, state or province and country as part of the travel itinerary validation process. | ||
| VEHICLE_TYPE | VARCHAR2 | 32 | Vehicle type for vehicle rental reservation. | ||
| PICKUP_CITY | VARCHAR2 | 64 | Pickup city for vehicle rental reservation. | ||
| PICKUP_STATE | VARCHAR2 | 64 | Pickup state or province for vehicle rental reservation. | ||
| PICKUP_STATE_CODE | VARCHAR2 | 64 | Code of pickup state or province for vehicle rental reservation. | ||
| PICKUP_COUNTRY | VARCHAR2 | 64 | Pickup country for vehicle rental reservation. | ||
| PICKUP_COUNTRY_CODE | VARCHAR2 | 64 | Pickup country code for vehicle rental reservation. | ||
| PICKUP_GEOGRAPHY_ID | NUMBER | 18 | Geographical rental vehicle pickup location in Oracle Trading Community Architecture(TCA). This column will only be populated if a geographical match is found in TCA using rental vehicle pickup city, state or province, and country as part of the travel itinerary validation process. | ||
| RETURN_CITY | VARCHAR2 | 64 | Return city for vehicle rental reservation. | ||
| RETURN_STATE | VARCHAR2 | 64 | Return state or province for vehicle rental reservation. | ||
| RETURN_STATE_CODE | VARCHAR2 | 64 | Return state or province code for vehicle rental reservation. | ||
| RETURN_COUNTRY | VARCHAR2 | 64 | Return country for vehicle rental reservation. | ||
| RETURN_COUNTRY_CODE | VARCHAR2 | 20 | Return country code for vehicle rental reservation. | ||
| RETURN_GEOGRAPHY_ID | NUMBER | 18 | Geographical rental vehicle return location in Oracle Trading Community Architecture(TCA). This column will only be populated if a geographical match is found in TCA using rental vehicle return city, state or province, and country as part of the travel itinerary validation process. | ||
| POLICY_VIOLATION | VARCHAR2 | 240 | Policy violation text displayed to employee while booking this reservation. | ||
| POLICY_VIOLATION_CODE | VARCHAR2 | 30 | Policy violation lookup_code that maps to policy violation text. This column is populated only if match is found against lookup_code in FND_LOOKUPS table during the itinerary validation process. | ||
| POLICY_JUSTIFICATION | VARCHAR2 | 240 | Policy violation justification text provided by employee while booking this reservation. | ||
| POLICY_JUSTIFICATION_CODE | VARCHAR2 | 30 | Policy violation lookup_code that maps to policy violation justification text. This column will only be populated if match was found against FND_LOOKUPS table during the itinerary validation process. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATETIME1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATETIME2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| PREPAID_FLAG | VARCHAR2 | 1 | Indicates whether the reservation in a travel itinerary is prepaid. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| EXM_ITINERARY_RESERVATIONS_N1 | Non Unique | Default | TRAVEL_ITINERARY_ID |
| EXM_ITINERARY_RESERVATIONS_PK | Unique | Default | ITINERARY_RESERVATION_ID |