|
Sheet Chain |
Sheet Hotel |
Sheet RoomType |
Sheet Room |
Sheet Media_hotel |
Sheeet Media_roomType |
Sheet Code |
Sheet Block |
Sheet Floor |
Sheet Section |
Sheet Code_roomType |
Sheet Code_hotel |
||||||||||||||||||||||||
|
Main group, there will be many hotels |
Hotel |
Types of rooms available in the hotel |
Rooms available in hotels, usually identified by number |
The hotel's media information |
The media information of the room type |
Information that needs configuration (preferences: special, hotel feature,market code, source code ….) |
Regional block of the hotel |
The hotel's floor |
Division by region |
Room type code (Room type) |
Hotel Code (Hotel) |
||||||||||||||||||||||||
|
Column |
Meaning |
Status |
Column |
Meaning |
Status |
Column |
Meaning |
Status |
Column |
Meaning |
Status |
Column |
Meaning |
Status |
Column |
Meaning |
Status |
Column |
Meaning |
Status |
Column |
Meaning |
Status |
Column |
Meaning |
Status |
Column |
Meaning |
Status |
Column |
Meaning |
Status |
Column |
Meaning |
Status |
|
id |
Information exported from the software |
System generated, do not enter |
Id |
Information exported from the software |
System generated, do not enter |
Id |
Information exported from the software |
System generated, do not enter |
id |
Information exported from the software |
System generated, do not enter |
id |
Information exported from the software |
System generated, do not enter |
id |
Information exported from the software |
System generated, do not enter |
id |
Information exported from the software |
System generated, do not enter |
id |
Information exported from the software |
System generated, do not enter |
id |
Information exported from the software |
System generated, do not enter |
id |
Information exported from the software |
System generated, do not enter |
id |
Information exported from the software |
System generated, do not enter |
id |
Information exported from the software |
System generated, do not enter |
|
name |
Name of chain |
Required to enter |
logo |
Logo of the Hotel, can it be imported using the link of the photo? |
Not required to enter |
name |
Room Type Name |
Required to enter |
name |
Room name |
Required to enter |
url |
Where is the image link of this hotel to put in this excel file? |
Required to enter |
url |
Where is the image link of this room type to put in this excel file? |
Required to enter |
name |
Name definition |
Required to enter |
name |
Block name |
Required to enter |
name |
Floor name |
Required to enter |
name |
Name definition |
Required to enter |
code |
Ordinal number |
Not required to enter |
code |
Ordinal number |
Not required to enter |
|
slug |
a type of code generated from the name used for identification |
System generated, do not enter |
name |
Name of hotel |
Required to enter |
slug |
a type of code generated from the name used for identification |
System generated, do not enter |
prefix |
|
System generated, do not enter |
title |
Information exported from the software |
System |
title |
Information exported from the software |
Required to enter |
description |
Description of information |
Not required to enter |
description |
Block description |
Not required to enter |
description |
Floor description |
Not required to enter |
description |
description |
Not required to enter |
roomTypeCode |
Room type code (Room type) |
Required to enter |
hotelCode |
Hotel Code |
Required to enter |
|
description |
Description of the chain |
Not required to enter |
slug |
a type of code generated from the name used for identification |
System generated, do not enter |
code |
Room type code |
Required to enter |
slug |
a type of code generated from the name used for identification |
System |
order |
Quantity |
Not required to enter |
order |
Quantity |
Not required to enter |
order |
Ordinal number |
Not required to enter |
order |
Ordinal number |
Not required to enter |
order |
Ordinal number |
Not required to enter |
order |
Ordinal number |
Not required to enter |
hotel Code |
Hotel Code |
Required to enter |
|
|
|
|
order |
Ordinal number |
Not required to enter |
description |
Hotel description |
Not required to enter |
description |
Room type description |
Not required to enter |
description |
Room description |
Not required to enter |
type |
Image type |
Required to enter |
type |
Image type |
System |
icon |
Image |
Not required to enter |
code |
Block Code |
Required to enter |
code |
Floor code |
Required to enter |
code |
Section Code |
Required to enter |
|
|
|
|
|
|
|
code |
Chain Code |
Required to enter |
order |
Ordinal number |
Not required to enter |
short Description |
Short description of the room type |
Not required to enter |
order |
Ordinal number |
Not required to enter |
size |
|
System generated, do not enter |
size |
|
System generated, do not enter |
type |
What kind of information? |
Required to enter |
status |
Input “1” the status is active. input “0” the status is inactive |
Required to enter |
status |
Input “1” the status is active. input “0” the status is inactive |
Required to enter |
status |
Input “1” the status is active. input “0” the status is inactive |
Required to enter |
|
|
|
|
|
|
|
totalHotels |
Total number of Chain hotels created in the Hotel sheet, system will automatically take the total => Do not enter |
System generated, do not enter |
location Coordinates |
location coordinates |
Not required to enter |
order |
Ordinal number |
Not required to enter |
roomNumber |
Room.No (E.g: 1890, 1789,…0 |
Required to enter |
contentType |
|
System generated, do not enter |
contentType |
|
System generated, do not enter |
code |
information code |
Required to enter |
createdAt |
The date of starting to create block on the system, the system will automatically record the date |
Not required to enter |
createdAt |
The date of starting to create floor on the system, the system will automatically record the date |
Not required to enter |
createdAt |
The date of starting to create Section on the system, the system will automatically record the date |
Not required to enter |
|
|
|
|
|
|
|
status |
Input “1” the status is active. input “0” the status is inactive |
Required to enter |
star |
hotel ratings |
Not required to enter |
status |
Input “1” the status is active. input “0” the status is inactive |
Required to enter |
phoneNumber |
Room’s phone number |
Not required to enter |
width |
|
System generated, do not enter |
width |
|
System generated, do not enter |
status |
Input “1” the status is active. input “0” the status is inactive |
Required to enter |
updatedAt |
Record the date of modification of block information on the system, the system automatically records the date |
Not required to enter |
updatedAt |
Record the date of modification of floor information on the system, the system automatically records the date |
Not required to enter |
updatedAt |
aRecord the date of modification of section information on the system, the system automatically records the date |
Not required to enter |
|
|
|
|
|
|
|
createdAt |
The date of starting to create chain on the system, the system will automatically record the date |
Not required to enter |
beginDate |
Operation start date |
Not required to enter |
numberOfRoom |
Number of "Rooms" under "Room Type". This information field will automatically get the information on the sheet "Room" |
System generated, do not enter |
isSmoking |
Input "1" if smoking is allowed, input "0" if not allowed |
Required to enter |
height |
|
System generated, do not enter |
height |
|
System generated, do not enter |
|
|
|
hotelCode |
Hotel code |
Required to enter |
hotelCode |
Hotel code |
Required to enter |
hotelCode |
Hotel code |
Required to enter |
|
|
|
|
|
|
|
updatedAt |
Record the date of modification of chain information on the system, the system automatically records the date |
Not required to enter |
legalOwner |
|
System generated, do not enter |
numberOfTotalRoom |
Total Number of "Rooms" under "Room Type". This information field will automatically get the information on the sheet "Room" |
System generated, do not enter |
bedInfo |
|
System generated, do not enter |
hotelCode |
Hotel code (Hotel Code) |
Required to enter |
roomTypeCode |
Room type code (Room type) |
Required to enter |
|
|
|
|
|
|
blockCode |
Block code |
System generated, do not enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
street |
Hotel’s address |
Not required to enter |
numberOfBed |
total number of beds for this room type |
Not required to enter |
roomStatus |
|
System generated, do not enter |
|
|
|
hotelCode |
Hotel code containing this room type |
Required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
postCode |
Post code |
Not required to enter |
defaultOccupancy |
Default occupancy |
Not required to enter |
foStatus |
|
System generated, do not enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
city |
city |
Not required to enter |
isHouseKeeping |
|
System generated, do not enter |
assignStatus |
|
System generated, do not enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
telephone |
Hotel’s phone number |
Not required to enter |
isGeneric |
|
System generated, do not enter |
hkStatus |
|
System generated, do not enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
hotelphone |
Hotel’s phone number |
Not required to enter |
isPseudo |
Input “1” if it's a psuedo room. If it is not input “0” |
Not required to enter |
status |
Input “1” the status is active. input “0” the status is inactive |
Required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
numberOfRooms |
Number of room |
Not required to enter |
isMeeting |
|
System generated, do not enter |
sectionId |
|
System generated, do not enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
fax |
Hotel’s FAX |
Not required to enter |
isGroup |
|
System generated, do not enter |
isPsuedo |
Input “1” if it's a psuedo room. If it is not input “0” |
Required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
webAddress |
Hotel’s website address |
Not required to enter |
autoRoomAssign |
|
System generated, do not enter |
isPsuedo,isPseudo |
|
System generated, do not enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Hotel’s email |
Required to enter |
autoPopulate |
|
System generated, do not enter |
squareUnit |
room area |
Not required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
currencySymbol |
The currency used in the hotel |
Not required to enter |
maxOccupancy |
Maximum occupancy |
Required to enter |
squareUnitType |
unit for calculating area |
Not required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
checkInTime |
Check in time |
Required to enter |
squareUnit |
room area |
Required to enter |
hotelCode |
Hotel code (Hotel Code), containing this room |
Required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
checkOutTime |
Check out time |
Required to enter |
squareUnitType |
unit for calculating area |
Required to enter |
roomTypeCode |
Room type code (Room type) containing this room |
Required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
baseLanguage |
Base language |
Not required to enter |
maxAdult |
maximum number of adults |
Required to enter |
blockCode |
Block code |
System |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
regionCode |
|
System generated, do not enter |
maxChild |
maximum number of children |
Required to enter |
floor Code |
Floor code |
System |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
code |
Hotelcode |
Required to enter |
activeDate |
|
System generated, do not enter |
sectionCode |
Section code |
System |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
status |
Input “1” the status is active. input “0” the status is inactive |
Required to enter |
createdAt |
The date of starting to create room type on the system, the system will automatically record the date |
Not required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
createdAt |
The date of starting to create hotel on the system, the system will automatically record the date |
Not required to enter |
updatedAt |
Record the date of modification of information on the system, the system automatically records the date |
Not required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
updatedAt |
Record the date of modification of hotel information on the system, the system automatically records the date |
Not required to enter |
typeOfRoom |
Rooms of Room Type. There are 2 types of rooms Hotel room, villa |
Not required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
chainCode |
If the hotel belongs to a chain, record that chain code |
Required to enter |
numberOfBedRoom |
number of beds |
Not required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
hotelTypeCode |
Hoteltype code |
Not required to enter |
maxExtraBeds |
Maximum number of extra beds for children |
Required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
countryCode |
Country code |
Not required to enter |
hotelCode |
Hotel code (This room type belongs to which hotel ?) |
Required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
stateCode |
State code |
Not required to enter |
chainCode |
Chain code (This room type belongs to which chain?) |
Not required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
roomNumber |
List Room.No of each Room Type |
Not required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|