This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →The table FTPT_IMR_HTL (IMR - Hotel) is a standard table in SAP ERP. It belongs to the package PTRI.
Table | FTPT_IMR_HTL |
Short Text | IMR - Hotel |
Package | PTRI |
Table Type | Transparent Table |
Field Name | Key | Description | Data Element | Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | ✔ | Client | MANDT | CLNT | 3 | * |
RECORD_LOCATOR | ✔ | Passenger Name Record Locator | PNR_RECORD_LOCATOR | CHAR | 20 | |
AIR_NUMBER | ✔ | Air record unique identifier | AIR_RECORD_NUMBER | NUMC | 12 | FTPT_IMR |
RUNNING_NUMBER | ✔ | Index | RUNNING_NUMBER | NUMC | 4 | |
HOTEL_SEG_TYPE | AIR : Description of segment type for itinerary portion | API_1A_AIR_SEGMENT_TYPE | NUMC | 2 | ||
TATTOO_NUMBER | Amadeus unique identifier for each element stored in PNR | API_1A_TATTOO_NUMBER | NUMC | 4 | ||
DISPLAY_NUMBER | Amadeus unique identifier for each element displayed in PNR | API_1A_DISPLAY_NUMBER | NUMC | 4 | ||
PROVIDER_CODE | CHAR | 4 | ||||
STATUS_CODE | Real status code from Amadeus | API_1A_STATUS_CODE | CHAR | 2 | ||
NUMBER_OF_ROOMS | NUMC | 2 | ||||
IN_DATE | DATS | 8 | ||||
OUT_DATE | DATS | 8 | ||||
ARPT_CITY_CODE | 5 character code identifying a City Code | API_1A_CITY_CODE | CHAR | 5 | ||
ARPT_CITY_NAME | CHAR | 20 | ||||
ROOM_TYPE_CODE | Room type code for Hotels | API_1A_HTL_ROOM_TYPE | CHAR | 8 | ||
CURRENCY_CODE | Currency code | API_1A_CURRENCY_CODE | CHAR | 5 | ||
RATE_PER_NIGHT | CHAR | 10 | ||||
RATE_TYPE | Room type code for Hotels | API_1A_HTL_RATE_TYPE | CHAR | 4 | ||
RATE_INFO | CHAR | 50 | ||||
PROPERTY_ID | CHAR | 3 | ||||
RATE_BOOK_CODE | CHAR | 10 | ||||
BS_TYPE | CHAR | 1 | ||||
BS | Booking source for reservation identification | API_1A_BOOKING_SOURCE | CHAR | 10 | ||
CONF_NUMBER | Confirmation Code returned after Hotel reservation | API_1A_CONFIRMATION | CHAR | 20 | ||
AP_MEALPLAN_RATE | CHAR | 20 | ||||
CORP_ID_NUMBER | Confirmation Code returned after Hotel reservation | API_1A_CORPORATE_ID | CHAR | 25 | ||
CRIB_RATE | CHAR | 20 | ||||
DEPOSIT_FOP | CHAR | 35 | ||||
EXTRA_PERS_RATE | CHAR | 20 | ||||
FA_MEALPLAN_RATE | CHAR | 20 | ||||
FM_MEALPLAN_RATE | CHAR | 20 | ||||
GUARANTEE_METHOD | CHAR | 35 | ||||
MA_MEALPLAN_RATE | CHAR | 20 | ||||
ADULT_ROLLAWAY | CHAR | 20 | ||||
CHILD_ROLLAWAY | CHAR | 20 | ||||
ROOM_OVERRIDE | CHAR | 8 | ||||
SUPP_INFO | CHAR | 50 | ||||
HFS_IND | CHAR | 1 | ||||
ACCOUNT_INFO | CHAR | 30 | ||||
HOTEL_NAME | CHAR | 50 | ||||
HOTEL_INFO1 | CHAR | 60 | ||||
HOTEL_INFO2 | CHAR | 60 | ||||
HOTEL_INFO3 | CHAR | 60 | ||||
HOTEL_ADD1 | CHAR | 60 | ||||
HOTEL_ADD2 | CHAR | 60 | ||||
HOTEL_CITY | CHAR | 30 | ||||
HOTEL_STATECODE | CHAR | 3 | ||||
HOTEL_COUNTRY | CHAR | 30 | ||||
HOTEL_ZIP_CODE | CHAR | 20 | ||||
HOTEL_PHONE | CHAR | 30 | ||||
HOTEL_FAX | CHAR | 30 | ||||
HOTEL_TELEX | CHAR | 30 | ||||
PAST_DATE_IND | CHAR | 1 | ||||
EXTRA_INFO1 | CHAR | 30 | ||||
EXTRA_INFO2 | CHAR | 30 | ||||
EXTRA_INFO3 | CHAR | 30 | ||||
EXTRA_INFO4 | CHAR | 30 |