0FI_TV_02

Travel Planning: Booking Data | #TRAN | Extraction method: F1 | No Delta | Component: Travel Management
Tables used: FTPT_FLIGHT, FTPT_CAR, PTRV_HEAD, PTRV_PERIO, FTPT_ITEM ... +6 more
Column Name Description
PERNR Personnel Number
REINR Trip Number
MOREI Trip Provision Variant
USERG User Grouping for Travel Planning
Column Name Description
💲 Currency Key (WAERS):
HOTEL_RATE Rate/Price Per Night
HOTEL_PRICE Total Price for Hotel Stay
CAR_PRICE Car Rental Price Per Day/Week/Etc.
CAR_TOTAL_RATE Total Price for Car Rental
FARE Basic rate for flight ticket without tax
TOTAL_FARE Total price of flight ticket
REBATE_FARE Discount price of flight ticket
Column Name Description
Column Name Description
DATV1 Beginning Date of Trip Segment
UHRV1 Beginning Time of Trip Segment
DATB1 End Date of Trip Segment
UHRB1 End Time of Trip Segment
HOTEL_DATE_ARR Arrival Date Hotel
HOTEL_DATE_DEP Departure Date Hotel
CAR_DATE_BEG Start Date for Rental Car
CAR_DATE_END End date for car rental
FLIGHT_DATE_DEP Flight departure date
FLIGHT_TIME_DEP Flight departure time
LAST_DATE Last Ticketing Date
Column Name Description
ENTRY_TYPE Type of Trip Data Show values
PLAN_STATUS Travel Plan Status Show values
REAL_CAT Travel service category Show values
HOTEL_ROOMTYPE Hotel Room Type Show values
HOTEL_MEALS Hotel Meals Show values
HOTEL_STATUS Hotel Status Show values
HOTEL_AREA Hotel Area Show values
CAR_CLASS Rental Car Vehicle Class Show values
CAR_TYPE Rental Car Vehicle Type Show values
CAR_STATUS Car Rental Status Show values
CAR_AREA City of car rental office (location) Show values
RESTRICT_FARE Lowest Fare Search Show values
FLIGHT_CABIN Flight Cabin Class Show values
FLIGHT_STATUS Flight Status Show values
LOCAL_TST Ticket element is local (not in booking system) Show values
TICKET_MODE Ticketing Mode of Airline Ticket Show values
SALES_IND Sales Type of Airline Ticket Rate Show values
FLIGHT_CABIN1 Flight Cabin Class Show values
FLIGHT_CABIN2 Flight Cabin Class Show values
FLIGHT_CABIN3 Flight Cabin Class Show values
FLIGHT_CABIN4 Flight Cabin Class Show values
FLIGHT_CABIN_UNI Flight Cabin Class Show values
TST_ISSUE_TYPE Airline Ticket Issue Show values
TST_FARE_TYPE Fare Type (Normal, Negotiated, Etc.) Show values
Column Name Description Domain name
MOLGA HCM Localization MOLGA
SCHEM Trip Schema RSCHE
KZREA Trip Type: Statutory KZREA
BEREI Trip Type: Enterprise-Specific BEREI
KZTKT Trip Activity Type KZTKT
ZLAND Trip Country / Trip Country Group LNDGR
HRGIO Region of Main Destination RGION
ACTIVITY_TYPE Trip Activity Type FTPD_PLAN_ACTIVITY
REC_LOCATOR Passenger Name Record Locator FTPD_PNR_RECORD_LOCATOR
CATEGORY Enterprise-Specific Travel Service Category FTPD_USER_CAT
BELNR Document Number NRBEL
HOTEL_CHAIN Hotel Chain FTPD_PROVIDER_CODE
HOTEL_PROPERTY Hotel Code (Key for an Individual Hotel) FTPD_HOTEL_PROP
HOTEL_LOC Hotel Location FTPD_IATA_LOCATION
HOTEL_NAME Name of Hotel TEXT40
HOTEL_RATE_CODE Hotel Rate Category FTPD_HOTEL_RATE_CODE
ROOM_RATE_CODE Rate Code (Hotel-Specific) CHAR3
HOTEL_NIGHTS No.of Hotel Nights INT4
HOTEL_BOOKINGS Number of Hotel Bookings INT4
CAR_PROVIDER Car Rental Provider FTPD_PROVIDER_CODE
CAR_LOC_BEG Rental Car Starting Location FTPD_IATA_LOCATION
CAR_LOC_END Dropoff Location FTPD_IATA_LOCATION
CAR_RATE_CODE Rental Car Rate Key (Provider-Dependent) CHAR12
CAR_TOT_RATETYPE Car rental rate indicator (total amount) FTPD_CAR_RATE_CODE
CAR_DAYS Number of Car Rental Days INT4
CAR_BOOKINGS Number of Car Rental Bookings INT4
CAR_PICKUP_LOC Car rental branch office for vehicle pickup CHAR6
AIRLINE Airline FTPD_PROVIDER_CODE
FLIGHT_NR Flight Number FTPD_FLIGHT_NR
FLIGHT_LOC_DEP Departure Location FTPD_IATA_LOCATION
FLIGHT_LOC_ARR Flight Arrival Location FTPD_IATA_LOCATION
FLIGHT_RBD Flight Booking Code (RBD) FTPD_FLIGHT_RBD
FLIGHT_NUMBER Number of Flights INT4
FARE_BASIS_CODE Basis code of rate component CHAR10
AIRLINE1 Airline FTPD_PROVIDER_CODE
AIRLINE2 Airline FTPD_PROVIDER_CODE
AIRLINE3 Airline FTPD_PROVIDER_CODE
AIRLINE4 Airline FTPD_PROVIDER_CODE
AIRLINE_UNIQUE Airline FTPD_PROVIDER_CODE
FLIGHT_RBD1 Flight Booking Code (RBD) FTPD_FLIGHT_RBD
FLIGHT_RBD2 Flight Booking Code (RBD) FTPD_FLIGHT_RBD
FLIGHT_RBD3 Flight Booking Code (RBD) FTPD_FLIGHT_RBD
FLIGHT_RBD4 Flight Booking Code (RBD) FTPD_FLIGHT_RBD
FLIGHT_RBD_UNI Flight Booking Code (RBD) FTPD_FLIGHT_RBD
FLIGHT_LOC_VIA1 Connection Airport for Round Trip FTPD_IATA_LOCATION
FLIGHT_LOC_VIA2 Connection Airport for Round Trip FTPD_IATA_LOCATION
FLIGHT_RETURNS Number of Return Flights INT4
CAR_CORPORATE_ID Company ID for Negotiated Rates FTPD_CORPORATION_ID
OP_AIRLINE Airline FTPD_PROVIDER_CODE
HOTEL_CORP_ID Company identification for room reservation FTPD_CORPORATION_ID
PLATING_CARRIER Plating Carrier FTPD_PROVIDER_CODE
TICKETNUMBER Ticket Number FTPD_TICKET_NUMBER
TICKETTYPE Ticket Type FTPD_TICKET_TYPE