FTPT_IMR_HTL

IMR - Hotel | #transactional | Component: Travel Planning
Column Name Description
MANDT Client
RECORD_LOCATOR Passenger Name Record Locator
AIR_NUMBER FK Air record unique identifier
RUNNING_NUMBER Index
Column Name Description
Column Name Description
Column Name Description
IN_DATE null
OUT_DATE null
Column Name Description
Column Name Description Domain name
HOTEL_SEG_TYPE AIR : Description of segment type for itinerary portion FTPD_AIR_SEGMENT_TYPE
TATTOO_NUMBER Amadeus unique identifier for each element stored in PNR
DISPLAY_NUMBER Amadeus unique identifier for each element displayed in PNR
PROVIDER_CODE null
STATUS_CODE Real status code from Amadeus
NUMBER_OF_ROOMS null
ARPT_CITY_CODE 5 character code identifying a City Code
ARPT_CITY_NAME null
ROOM_TYPE_CODE Room type code for Hotels
CURRENCY_CODE Currency code
RATE_PER_NIGHT null
RATE_TYPE Room type code for Hotels
RATE_INFO null
PROPERTY_ID null
RATE_BOOK_CODE null
BS_TYPE null
BS Booking source for reservation identification
CONF_NUMBER Confirmation Code returned after Hotel reservation
AP_MEALPLAN_RATE null
CORP_ID_NUMBER Confirmation Code returned after Hotel reservation
CRIB_RATE null
DEPOSIT_FOP null
EXTRA_PERS_RATE null
FA_MEALPLAN_RATE null
FM_MEALPLAN_RATE null
GUARANTEE_METHOD null
MA_MEALPLAN_RATE null
ADULT_ROLLAWAY null
CHILD_ROLLAWAY null
ROOM_OVERRIDE null
SUPP_INFO null
HFS_IND null
ACCOUNT_INFO null
HOTEL_NAME null
HOTEL_INFO1 null
HOTEL_INFO2 null
HOTEL_INFO3 null
HOTEL_ADD1 null
HOTEL_ADD2 null
HOTEL_CITY null
HOTEL_STATECODE null
HOTEL_COUNTRY null
HOTEL_ZIP_CODE null
HOTEL_PHONE null
HOTEL_FAX null
HOTEL_TELEX null
PAST_DATE_IND null
EXTRA_INFO1 null
EXTRA_INFO2 null
EXTRA_INFO3 null
EXTRA_INFO4 null