We are actively reviewing known translation gaps and prioritizing the effort to ensure that content is available in all languages.
Unfortunately, not all hotels have fully translated descriptions yet. If a hotel’s description has not been translated in a specific language, that hotel will not be listed in the respective description’s language file. If no translations are available for any hotels for a specific language, the corresponding multi-language file is not available.

Relational Data Files

ActivePropertyList

File Name:  ActivePropertyList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/ActivePropertyList.zip
  • This is a list of all active properties in the EAN database with English language data.
  • Properties can sorted by performance via the SequenceNumber field.
    • The SequenceNumber value ranks properties based on EAN transactional data from the last 30 days, with 1 indicating the best-performing hotel and others following in ascending numerical order.
    • This is the same sort algorithm used for dateless hotel list requests; values are updated daily.
  • The Location field is a short description of the location of the property.  A possible value for this field is “Near Times Square”.
  • The chain code can be mapped to the ChainCodeList to get the chain name. 
  • Use Latitude/Longitude to map properties to your own database of properties when using other content sources.
Attribute Name Base Data Type (Length)
EANHotelID int
SequenceNumber int
Name nvarchar(70)
Address1 nvarchar(50)
Address2 nvarchar(50)
City nvarchar(50)
StateProvince nvarchar(2)
PostalCode nvarchar(15)
Country nvarchar(2)
Latitude numeric(8,5)
Longitude numeric(8,5)
AirportCode nvarchar(3)
PropertyCategory int
PropertyCurrency nvarchar(3)
StarRating numeric(2,1)
Confidence int
SupplierType nvarchar(3)
Location  (a short description of the location of the property.) nvarchar(80)
ChainCodeID (The chain code can be mapped to the ChainCodeList to get the chain name.) nvarchar(5)
RegionID (no longer applicable; returns blank space) int
HighRate (do not use – no longer maintained) numeric(19,4)
LowRate (do not use – no longer maintained) numeric(19,4)
CheckInTime nvarchar(10)
CheckOutTime nvarchar(10)

ActivePropertyList
Multi-Language

File Name:  ActivePropertyList_xx_XX.txt
Zip File Name:  https://www.ian.com/affiliatecenter/include/V2/ActivePropertyList_xx_XX.zip

This file holds all non-English language translations for the records located in the ActivePropertyList file.

Use the URL format provided above, substituting the _xx_XX suffix with your desired language code.

Note:
The English language Active Property List, above this entry, is the master list of all of the Expedia-collect properties. Our multi-language files also contain properties which are Hotel Collect inventory. These additional hotels are only available for sale by partners who are permitted and configured to sell this type of inventory.

Please use the set of hotels in the English language file as your master set of properties to sell.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
Name nvarchar(70)
Location nvarchar(80)
CheckInTime nvarchar(10)
CheckOutTime nvarchar(10)

PropertyTypeList

File Name: PropertyTypeList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/PropertyTypeList.zip

This is a mapping list of property types for the given PropertyCategory. This can be used in conjunction with the ActivePropertyList.

Attribute Name Base Data Type (Length)
PropertyCategory int
LanguageCode nvarchar(5)
PropertyCategoryDesc nvarchar(256)

PropertyTypeList
Multi-Language

File Name:  PropertyTypeList_xx_XX.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/PropertyTypeList_xx_XX.zip

This file holds all non-English language translations for the records located in the PropertyTypeList file.

Use the URL format provided above, substituting the _xx_XX suffix with your desired language code.

Attribute Name Base Data Type (Length)
PropertyCategory int
LanguageCode nvarchar(5)
PropertyCategoryDesc nvarchar(256

ChainList

File Name:  ChainList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/ChainList.zip

This is a listing of all chain names.  It can be used in conjunction with the ActivePropertyList to add chain names to the property list.

Attribute Name Base Data Type (Length)
ChainCodeID int
ChainName nvarchar(30)

PropertyDescriptionList

File Name:  PropertyDescriptionList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/PropertyDescriptionList.zip

This file holds the English language long general description of the properties in the EAN system.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
PropertyDescription TEXT

PropertyDescriptionList
Multi-Language

File Name: PropertyDescriptionList_xx_XX.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/PropertyDescriptionList_xx_XX.zip

This file holds all non-English language translations for the records located in the PropertyDescriptionList file.

Use the URL format provided above, substituting the _xx_XX suffix with your desired language code.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
PropertyDescription TEXT

PolicyDescriptionList

File Name:  PolicyDescriptionList.txt
Zip File Name:  https://www.ian.com/affiliatecenter/include/V2/PolicyDescriptionList.zip

This file holds all the English language long description policy data for properties in the EAN system.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
PolicyDescription TEXT

PolicyDescriptionList
Multi-Language

File Name:   PolicyDescriptionList_xx_XX.txt
Zip File Name:  https://www.ian.com/affiliatecenter/include/V2/PolicyDescriptionList_xx_XX.zip

This file holds all non-English language translations for the records located in the PolicyDescriptionList file.

Use the URL format provided above, substituting the _xx_XX suffix with your desired language code.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
PolicyDescription TEXT

PropertyFeesList

File Name: PropertyFeesList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/PropertyFeesList.zip

This file contains descriptions for incidental per-room and service fees, e.g. pet fees, breakfast, room deposits, parking and shuttle fees.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
PropertyFeesDescription TEXT

PropertyFeesList
Multi-Language

File Name: PropertyFeesList_xx_XX.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/PropertyFeesList_xx_XX.zip

This file holds all non-English language translations for the records located in the PropertyFeesList file.

Use the URL format provided above, substituting the _xx_XX suffix with your desired language code.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
PropertyFeesDescription TEXT

PropertyMandatoryFeesList

File Name: PropertyMandatoryFeesList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/PropertyMandatoryFeesList.zip

This file contains descriptions for resort fees, city taxes, specific VAT and other mandatory taxes or charges. May describe which services are covered by any fees, such as fitness centers or internet access.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
PropertyMandatoryFeesDescription TEXT

PropertyMandatoryFeesList
Multi-Language

File Name: PropertyMandatoryFeesList_xx_XX.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/PropertyMandatoryFeesList_xx_XX.zip

This file holds all non-English language translations for the records located in the PropertyMandatoryFeesList file.

Use the URL format provided above, substituting the _xx_XX suffix with your desired language code.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
PropertyFeesDescription TEXT

RecreationDescriptionList

File Name:  RecreationDescriptionList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/RecreationDescriptionList.zip

This file holds all the English language long description data about recreation activities for properties in the EAN system.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
RecreationDescription TEXT

RecreationDescriptionList
Multi-Language

File Name:  RecreationDescriptionList_xx_XX.txt
Zip File Name:  https://www.ian.com/affiliatecenter/include/V2/RecreationDescriptionList_xx_XX.zip

This file holds all non-English language translations for the records located in the RecreationDescriptionList file.

Use the URL format provided above, substituting the _xx_XX suffix with your desired language code.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
RecreationDescription TEXT

PropertyAmenitiesList

File Name: PropertyAmenitiesList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/PropertyAmenitiesList.zip

This file contains descriptions for general amenities (non-room-specific), e.g. pool, fitness center, lobby amenities, spas, etc., for properties in the EAN system.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
PropertyAmenitiesDescription TEXT

PropertyAmenitiesList
Multi-Language

File Name: PropertyAmenitiesList_xx_XX.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/PropertyAmenitiesList_xx_XX.zip

This file holds all non-English language translations for the records located in the PropertyAmenitiesList file.

Use the URL format provided above, substituting the _xx_XX suffix with your desired language code.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
PropertyAmenitiesDescription TEXT

PropertyBusinessAmenitiesList

File Name: PropertyBusinessAmenitiesList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/PropertyBusinessAmenitiesList.zip

This file contains descriptions for business-specific general amenities, e.g. multilingual staff, business centers, conference rooms, courtesy shuttles, etc., for properties in the EAN system.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
PropertyBusinessAmenitiesDescription TEXT

PropertyBusinessAmenitiesList Multi-Language

File Name: PropertyBusinessAmenitiesList_xx_XX.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/PropertyBusinessAmenitiesList_xx_XX.zip

This file holds all non-English language translations for the records located in the PropertyBusinessAmenitiesList file.

Use the URL format provided above, substituting the _xx_XX suffix with your desired language code.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
PropertyBusinessAmenitiesList TEXT

PropertyLocationList

File Name:   PropertyLocationList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/PropertyLocationList.zip

This file contains descriptions of property grounds and their relative location to nearby landmarks in the city.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
PropertyLocationDescription TEXT

PropertyLocationList
Multi-Language

File Name:   PropertyLocationList_xx_XX.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/PropertyLocationList_xx_XX.zip

This file holds all non-English language translations for the records located in the PropertyRenovationList file. Use the URL format provided above, substituting the _xx_XX suffix with your desired language code.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
PropertyLocationDescription TEXT

PropertyNationalRatingsList

File Name:   PropertyNationalRatingsList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/PropertyNationalRatingsList.zip

This file describes the source of properties' star ratings (e.g. a regional or national tourism agency) and any other ratings claimed.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
PropertyNationalRatingsDescription TEXT

PropertyNationalRatingsList
Multi-Language

File Name:   PropertyNationalRatingsList_xx_XX.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/PropertyNationalRatingsList_xx_XX.zip

This file holds all non-English language translations for the records located in the PropertyNationalRatingsList file. Use the URL format provided above, substituting the _xx_XX suffix with your desired language code.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
PropertyNationalRatingsDescription TEXT

PropertyRenovationsList

File Name:   PropertyRenovationsList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/PropertyRenovationsList.zip

This file contains information on upcoming property renovations. Dates of closure, affected rooms or facilities, and additional details are available as provided by the individual property.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
PropertyRenovationsDescription TEXT

PropertyRenovationsList
Multi-Language

File Name:   PropertyRenovationsList_xx_XX.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/PropertyRenovationsList_xx_XX.zip

This file holds all non-English language translations for the records located in the PropertyRenovationsList file. Use the URL format provided above, substituting the _xx_XX suffix with your desired language code.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
PropertyRenovationsDescription TEXT

PropertyRoomsList

File Name:   PropertyRoomsList.zip
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/PropertyRoomsList.zip

This file contains descriptions of typical room amenities for the property.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
PropertyRoomsDescription TEXT

PropertyRoomsList
Multi-Language

File Name:   PropertyRoomsList_xx_XX.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/PropertyRoomsList_xx_XX.zip

This file holds all non-English language translations for the records located in the PropertyRenovationList file. Use the URL format provided above, substituting the _xx_XX suffix with your desired language code.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
PropertyRoomsList TEXT

AreaAttractionsList

File Name:   AreaAttractionsList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/AreaAttractionsList.zip

This file holds all the English language long description data about area attractions near properties in the EAN system.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
AreaAttractions TEXT

AreaAttractionsList
Multi-Language

File Name:  AreaAttractionsList_xx_XX.txt
Zip File Name:  https://www.ian.com/affiliatecenter/include/V2/AreaAttractionsList_xx_XX.zip

This file holds all non-English language translations for the records located in the AreaAttractionsList file.

Use the URL format provided above, substituting the _xx_XX suffix with your desired language code.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
AreaAttractions TEXT

DiningDescriptionList

File Name:  DiningDescriptionList.txt
Zip File Name:  https://www.ian.com/affiliatecenter/include/V2/DiningDescriptionList.zip

This file holds all the English language long description data about nearby dining options for properties in the EAN system.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
PropertyDiningDescription TEXT

DiningDescriptionList
Multi-Language

File Name:  DiningDescriptionList_xx_XX.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/DiningDescriptionList_xx_XX.zip

This file holds all non-English language translations for the records located in the DiningDescriptionList file.

Use the URL format provided above, substituting the _xx_XX suffix with your desired language code.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
PropertyDiningDescription TEXT

SpaDescriptionList

File Name: SpaDescriptionList.txt
Zip File Name:  https://www.ian.com/affiliatecenter/include/V2/SpaDescriptionList.zip

This file holds all the English language long description data about spa information for properties in the EAN system.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
SpaDescription TEXT

SpaDescriptionList
Multi-Language

File Name:  SpaDescriptionList_xx_XX.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/SpaDescriptionList_xx_XX.zip

This file holds all non-English language translations for the records located in the SpaDescriptionList file.

Use the URL format provided above, substituting the _xx_XX suffix with your desired language code.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
SpaDescription TEXT

WhatToExpectDescriptionList

File Name:  WhatToExpectList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/WhatToExpectList.zip

This file holds all the English language long description data containing pertinent information for properties in the EAN system.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
WhatToExpect TEXT

WhatToExpectList
Multi-Language

File Name:  WhatToExpectList_xx_XX.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/WhatToExpectList_xx_XX.zip

This file holds all non-English language translations for the records located in the WhatToExpectDescriptionList file.

Use the URL format provided above, substituting the _xx_XX suffix with your desired language code.

Attribute Name Base Data Type (Length)
EANHotelID int
LanguageCode nvarchar(5)
WhatToExpect TEXT