|
|
|
Mapping Table between ORS, XML message and V6 PMS for PROFILES
If (ORS Field Label) column below is blank, either this value is internally populated and there is no actual field on the profile screen in ORS to view this value, or the value is populated from a field from a different table other than the profile tables.
ORS Field Label |
ORS Table and Column |
XML Tag |
V6 DBF |
V6 Field |
Comment |
Individual Guest Name Information |
|
|
|
|
|
LAST_NAME |
NAME.LAST |
nameSur |
GAESTEST |
NAME |
C, 30 |
FIRST_NAME |
NAME.FIRST |
nameFirst |
GAESTEST |
VORNAME |
C, 30 |
MIDDLE_NAME |
NAME.MIDDLE |
nameMiddle |
|
|
|
LANGUAGE_CODE |
NAME.LANGUAGE |
primaryLanguageID |
GAESTEST |
SPRACHE |
C, 1 |
TITLE |
NAME.TITLE |
namePrefix |
GAESTEST |
ANREDE |
C, 20 |
XLAST_NAME |
NAME.XLAST |
nameSur |
GAESTEST |
NAME |
C, 30 |
XFIRST_NAME |
NAME.XFIRST |
nameSur |
|
|
|
XLANGUAGE |
NAME.XLANGUAGE |
alternateLanguageIDs |
|
|
|
XTITLE |
NAME.XTITLE |
|
GAESTEST |
ANREDE |
C, 30 |
XSALUTATION |
NAME.XSALUTATION |
|
GAESTEST |
PANREDE |
C, 60 |
Individual Guest Address Information#1 |
|
|
|
|
|
ADDRESS_TYPE |
NAME_ADDRESS.ADDRESS_TYPE |
PostalAddress addressType |
GAESTEST |
ADDTYPE |
C, 1 |
ADDRESS1 |
NAME_ADDRESS.ADDRESS1 |
address1 |
GAESTEST |
STRASSE1 |
C, 30 |
ADDRESS2 |
NAME_ADDRESS.ADDRESS2 |
address2 |
GAESTEST |
STRASSE2 |
C, 30 |
ADDRESS3 |
NAME_ADDRESS.ADDRESS3 |
address3 |
GAESTEST |
STRASSE3 |
C, 30 |
CITY |
NAME_ADDRESS.CITY |
city |
GAESTEST |
ORT |
C, 30 |
ZIP_CODE |
NAME_ADDRESS.ZIP_CODE |
postalCode |
GAESTEST |
PLZ |
C, 10 |
CITY_EXT |
NAME_ADDRESS.CITY_EXT |
|
|
|
|
COUNTRY |
NAME_ADDRESS.COUNTRY |
countryCode |
GAESTEST |
countryCode |
C, 3 |
STATE |
NAME_ADDRESS.STATE |
stateCode |
GAESTEST |
STATE |
C, 3 |
LANGUAGE_CODE |
|
|
GAESTEST |
STRASSE4 |
C, 30 or C, 1 (depending on use) |
Individual Guest Address Information#2 |
(B)fields are used when the client is using the secondary address information. The Business address will populate the (B) fields in GAESTEST. |
|
|
|
|
ADDRESS_TYPE |
NAME_ADDRESS.ADDRESS_TYPE |
PostalAddress addressType |
GAESTEST |
BADDTYPE |
C, 1 |
ADDRESS1 |
NAME_ADDRESS.ADDRESS1 |
address1 |
GAESTEST |
BSTRASSE1 |
C, 30 |
ADDRESS2 |
NAME_ADDRESS.ADDRESS2 |
address2 |
GAESTEST |
BSTRASSE2 |
C, 30 |
CITY |
NAME_ADDRESS.CITY |
city |
GAESTEST |
BORT |
C, 30 |
ZIP_CODE |
NAME_ADDRESS.ZIP_CODE |
postalCode |
GAESTEST |
BPLZ |
C, 10 |
CITY_EXT |
NAME_ADDRESS.CITY_EXT |
|
|
|
|
COUNTRY |
NAME_ADDRESS.COUNTRY |
countryCode |
GAESTEST |
BLAND |
C, 3 |
STATE |
NAME_ADDRESS.STATE |
stateCode |
GAESTEST |
BSTATE |
C, 3 |
PRIMARY_YN |
NAME_ADDRESS.PRIMARY_YN |
MfPrimaryYN |
|
|
|
SALUTATION |
NAME.SALUTATION |
|
GAESTEST |
PANREDE |
C, 60 |
VIP_CODE |
NAME.VIP_STATUS |
MfVipStatus |
GAESTEST |
VIP |
N, 3 |
NATIONALITY_CODE |
NAME.NATIONALITY |
nationality |
GAESTEST |
NATION |
C, 3 |
SUMM_REF_CC (Reference Currency) |
|
|
|
|
|
MARKETS |
NAME.MARKETS |
|
|
|
|
MAILING |
NAME.MAIL_YN |
mfallowmail |
GAESTEST |
ALLOWMAIL |
L,1 (used in OH versions 2.5 an v2.6) |
MAILING_LIST |
NAME.MAIL_LIST |
mfallowmail |
GAESTEST |
ALLOWMAIL |
L,1 (used in OH version 3.0) |
RESORT |
NAME.RESORT |
|
|
|
|
NOTES (Central Comments type in Notes) |
NAME_COMMENT.COMMENTS and NAME$NOTES.NOTES |
<CentralComment xmlns="ccomment.fidelio.1.0"> <comment> |
GAESTEST
|
CENTRAL COMMENTS |
In Remarks>Central Comments, this is transmitted up/down. (Separate message goes out of ORS to the V6 as CCOMMENT.) |
NOTES (Property Notes type in Notes) |
NAME$NOTES. NOTES |
<commentStr> |
GAESTEST |
NOTES |
In Remarks>Profile Remarks, this is only sent from V6 to ORS. ORS will not sent this information back to V6 PMS. |
KEYWORD |
NAME_KEYWORDS.KEYWORD |
|
GAESTEST |
ID_CARD |
C, 15 This is for Shangri- La Hotels to pass an additional ID Card |
DATE_OF_BIRTH |
NAME.BIRTH_DATE |
dateOfBirth |
GAESTEST |
GEBDAT |
D, 8 |
PASSPORT |
NAME.PASSPORT |
<docNumber> and <documentCode> |
GAESTEST |
PASSPORT OR PASS In a co- existant model ensure that only field exists in GAESTEST i.e. if data is changed from one field and not updated on another field than it leads to inconsistencies. V3 can handle both fields |
C, 20 |
Country that issues the document |
NAME.ID_COUNTRY |
|
GAESTEST |
|
|
Document Code |
NAME.ID_NUMBER |
|
GAESTEST |
|
|
KEYWORD (ID_CARD) |
NAME_KEYWORD.KEYWORD |
<Udfs> <Udf xmlns="udf.fidelio.1.0"> <UdfDefinition xmlns="udfdefinition.fidelio.1.0"> <pmsTableName>GAESTEST</pmsTableName> <pmsColumnName>ID_CARD</pmsColumnName> </UdfDefinition> |
GAESTEST |
ID_CARD |
|
F_BL_MSG |
NAME.CASH_BL_IND |
MfBlacklist |
GAESTEST |
|
|
F_BL_MSG |
NAME.BL_MSG |
mfBlacklistMessage |
GAESTEST |
BL_MESSAGE |
|
MAILING |
NAME.MAIL_YN |
mfallowmail |
GAESTEST |
ALLOWMAIL |
L,1 (used in OH version 2.5 & 2.6) |
MAILING_LIST |
NAME.MAILING_LIST |
mfallowmail |
GAESTEST |
ALLOWMAIL |
L,1 (used in OH version 3.0, no longer using MAIL_YN for Mailing) |
EMAIL_YN |
NAME.EMAIL_YN |
mfAllowEMail |
GAESTEST |
ALLOWEMAIL |
L,1 |
GUEST_PRIV_YN |
NAME.GUEST_PRIV_YN |
mfGuestPriv |
GAESTEST |
GUESTPRIV |
L,1 |
NAME_CODE |
NAME.NAME_CODE |
MfNameCode |
GAESTEST |
MEMBERNR |
C,15 |
Individual Guest Communication Information |
|
|
|
|
|
COMM1_TYPE (Home) and PHONE_NUMBER |
NAME_PHONE. PHONE_NUMBER |
<PhoneNumber phoneNumberType> and <phoneNumber> |
GAESTEST |
TELEFON |
C, 20 |
COMM2_TYPE (E-mail) and PHONE_NUMBER |
NAME_PHONE. PHONE_NUMBER |
<ElectronicAddress electronicAddressType> and <eAddress> |
GAESTEST |
C, 30 |
|
COMM3_TYPE (Business) and PHONE_NUMBER |
NAME_PHONE. PHONE_NUMBER |
<PhoneNumber phoneNumberType> and <phoneNumber> |
GAESTEST |
BTELEFON |
C, 20 |
COMM4_TYPE (Fax) and PHONE_NUMBER |
NAME_PHONE. PHONE_NUMBER |
<PhoneNumber phoneNumberType> and <phoneNumber> |
GAESTEST |
TELEFAX |
C, 20 |
Individual Guest Memberships Card |
|
|
|
|
|
MEMBERSHIP_TYPE |
MEMBERSHIPS.MEMBERSHIP_TYPE |
programCode |
PR_SUP |
CARDTYPE |
C, 3 |
MEMBERSHIP_CARD_ NO |
MEMBERSHIPS. MEMBERSHIP_CARD_NO |
accountID |
PR_SUP |
CARDNR |
C, 20 |
NAME_ON_CARD |
MEMBERSHIPS.NAME_ON_CARD |
|
|
|
|
MEMBERSHIP_LEVEL |
MEMBERSHIPS.MEMBERSHIP_ LEVEL |
levelCode |
PR_SUP |
MISC_1 |
C, 20 |
ENROLLMENT_CODE |
|
|
|
|
|
EXPIRATION_DATE |
MEMBERSHIPS.EXPIRATION_DATE |
ExpireDate |
PR_SUP |
CARDEXPY |
C, 5 |
JOINED_DATE |
MEMBERSHIPS.JOINED_DATE |
startDate |
PR_SUP |
CC_START |
C, 4 |
INACTIVE_YN |
MEMBERSHIPS.INACTIVE_YN |
|
|
|
|
COMMENTS |
NAME_COMMENTS.COMMENTS |
|
|
|
|
MEMBER_INDICATOR |
|
|
|
|
|
GRACE_PERIOD_ INDICATOR |
|
|
|
|
|
Individual Guest Miscellaneous |
|
|
|
|
|
F_BL_MSG |
NAME.CASH_BL_IND |
MfBlacklist |
|
|
|
F_BL_MSG |
NAME.BL_MSG |
mfBlacklistMessage |
GAESTEST |
BL_MESSAGE |
|
Company/TA/Source Name Information |
|
|
|
|
|
F_NAME |
NAME.COMPANY |
nameSur |
GAESTEST |
NAME |
C, 30 |
F_NAME2 |
NAME.NAME2 |
nameTitle |
GAESTEST |
TITEL |
|
F_NAME3 |
|
|
|
|
|
LANGUAGE_CODE |
NAME.LANGUAGE |
primaryLanguageID |
GAESTEST |
SPRACHE |
C, 1 |
XNAME_POP |
|
|
|
|
|
XLANGUAGE |
|
|
|
|
|
Legal Company |
NAME.LEGAL_COMPANY |
mfCorporatePosition |
GAESTEST |
FIRMA |
|
LAST NAME (contact) |
NAME.UDFC24 |
mfContactLast |
GAESTEST |
GAST- >KONTAKT1 |
|
FIRST NAME (contact) |
NAME.UDFC21 |
mfContactFirst |
GAESTEST |
KTK1_VOR |
|
Company/TA/Source Address Information |
|
|
|
|
|
ADDRESS_TYPE |
NAME_ADDRESS.ADDRESS_TYPE |
<PostalAddress addressType= "BUSINESS"> |
GAESTEST |
ADDTYPE |
C, 1 |
ADDRESS1 |
NAME_ADDRESS.ADDRESS1 |
address1 |
GAESTEST |
STRASSE1 |
C, 30 |
ADDRESS2 |
NAME_ADDRESS.ADDRESS2 |
address2 |
GAESTEST |
STRASSE2 |
C, 30 |
ADDRESS3 |
NAME_ADDRESS.ADDRESS3 |
address3 |
GAESTEST |
STRASSE3 |
C, 30 |
CITY |
NAME_ADDRESS.CITY |
City |
GAESTEST |
ORT |
C, 30 |
ZIP_CODE |
NAME_ADDRESS.ZIP_CODE |
PostalCode |
GAESTEST |
PLZ |
C, 10 |
CITY_EXT |
NAME_ADDRESS.CITY_EXT |
|
|
|
|
COUNTRY |
NAME_ADDRESS.COUNTRY |
CountryCode |
GAESTEST |
LAND |
C, 3 |
STATE |
NAME_ADDRESS.STATE |
StateCode |
GAESTEST |
STATE |
C, 3 |
PRIMARY_YN |
NAME_ADDRESS.PRIMARY_YN |
MfPrimaryYN |
|
|
|
LANGUAGE_CODE |
|
|
GAESTEST |
STRASSE4 |
C, 1 OR C, 30 Depending on use |
F_TERRITORY |
|
|
|
|
|
F_TRACECODE |
|
|
|
|
|
F_KEYWORD |
|
|
|
|
|
F_NAME_TYPE |
|
|
|
|
|
F_IATA_CORP_NO |
NAME.NAME_CODE |
mfNameCode |
GAESTEST |
MEMBERNR |
C, 15 |
IATA_COMP_TYPE |
|
|
|
|
|
F_SUMM_REF_CC |
|
|
|
|
|
AR_NO_CENTRAL |
NAME.AR_NO |
mfARNumber |
GAESTEST |
AR_NUMBER |
C, 10 |
RESORT |
NAME_SUBSCRIPTIONS. DATABASE_ID |
|
|
|
|
Company/TA/Source Communication Information |
|
|
|
|
|
F_ACC_PHONE_TYPE1 |
NAME_PHONE. PHONE_TYPE |
<PhoneNumber phoneNumberType= "BUSINESS"> |
GAESTEST |
BTELEFON |
C, 20 |
F_ACC_PHONE1 |
NAME_PHONE. PHONE_NUMBER |
PhoneNumber |
|
|
|
PRIMARY_YN |
NAME_PHONE.PRIMARY_YN |
MfPrimaryYN |
|
|
|
F_ACC_PHONE_TYPE2 |
NAME_PHONE. PHONE_NUMBER |
<ElectronicAddress electronicAddressType= "WEBPAGE"> |
|
|
|
F_ACC_PHONE2 |
NAME_PHONE. PHONE_NUMBER |
EAddress |
|
|
|
PRIMARY_YN |
NAME_PHONE. PRIMARY_YN |
MfPrimaryYN |
|
|
|
F_ACC_PHONE_TYPE3 |
NAME_PHONE. PHONE_TYPE |
<PhoneNumber phoneNumberType= "BUSINESSFAX"> |
GAESTEST |
TELEFAX |
C, 20 |
F_ACC_PHONE3 |
NAME_PHONE. PHONE_NUMBER |
phoneNumber |
|
|
|
PRIMARY_YN |
NAME_PHONE. PRIMARY_YN |
MfPrimaryYN |
|
|
|
Company/TA/Source Negotiated Rates |
|
|
|
|
|
RATE_CODE |
RATE_HEADER_NEGOTIATED. RATE_CODE |
preferredRatePlanCode |
GAESTEST |
PKZ |
C, 3 |
BEGIN_DATE |
RATE_HEADER_NEGOTIATED. BEGIN_DATE |
|
|
|
|
END_DATE |
RATE_HEADER_NEGOTIATED. END_DATE |
|
|
|
|
ORDER_BY |
RATE_HEADER_NEGOTIATED. ORDER_BY |
|
|
|
|
Company/TA/Source Miscellaneous |
|
|
|
|
|
|
NAME.INSERT_DATE |
createdDate |
GAESTEST |
CREATED, LAST_DATE, LAST_TIME |
D, 8 |
|
NAME.NAME_ID |
profileID |
GAESTEST |
CRSNAME_ID |
C, 16 |
|
NAME.CRS_NAMEID |
pmsId |
GAESTEST |
NUMMER |
N, 8 |
TAX1_NO |
|
|
|
|
|
F_BL_MSG |
NAME.BL_MSG |
MfBlacklist |
|
|
|
F_BL_MSG |
NAME.BL_MSG |
mfBlacklistMessage |
GAESTEST |
BL_MESSAGE |
|
KEYWORD (SEARCH_NAME) |
NAME_KEYWORDS.KEYWORD |
nameFirst |
GAESTEST |
VORNAME |
C,30 |
KEYWORD (MASTER_ACCOUNT) |
NAME_KEYWORDS.KEYWORD |
mfMasterAccount |
PR_SUP |
CARDNR |
|
MAILING |
NAME.MAIL_YN |
mfallowmail |
GAESTEST |
ALLOWMAIL |
L,1 (used in OH version 2.5 & 2.6) |
MAILING_LIST |
NAME.MAILING_LIST |
mfallowmail |
GAESTEST |
ALLOWMAIL |
L,1 (used in OH version 3.0, no longer using MAIL_YN for Mailing) |
EMAIL_YN |
NAME.EMAIL_YN |
mfAllowEMail |
GAESTEST |
ALLOWEMAIL |
L,1 |
GUEST_PRIV_YN |
NAME.GUEST_PRIV_YN |
mfGuestPriv |
GAESTEST |
GUESTPRIV |
L,1 |
Group Name Information |
|
|
|
|
|
LAST_NAME |
NAME.LAST |
NameSur |
GAESTEST |
NAME |
C, 30 |
LANGUAGE_CODE |
NAME.LANGUAGE |
PrimaryLanguageID |
GAESTEST |
SPRACHE |
C, 1 |
XLAST_NAME |
NAME.XLAST |
NameFirst |
GAESTEST |
VORNAME |
C, 30 |
XLANGUAGE |
NAME.XLANGUAGE |
alternateLanguageIDs |
|
|
|
Group Address Information |
|
|
|
|
|
ADDRESS_TYPE |
NAME_ADDRESS.ADDRESS_TYPE |
PostalAddress addressType |
GAESTEST |
ADDTYPE |
C, 1 |
ADDRESS1 |
NAME_ADDRESS.ADDRESS1 |
address1 |
GAESTEST |
STRASSE1 |
C, 30 |
ADDRESS2 |
NAME_ADDRESS.ADDRESS2 |
address2 |
GAESTEST |
STRASSE2 |
C, 30 |
ADDRESS3 |
NAME_ADDRESS.ADDRESS3 |
address3 |
GAESTEST |
STRASSE3 |
C, 30 |
CITY |
NAME_ADDRESS.CITY |
city |
GAESTEST |
ORT |
C, 30 |
ZIP_CODE |
NAME_ADDRESS.ZIP_CODE |
postalCode |
GAESTEST |
PLZ |
C, 10 |
CITY_EXT |
NAME_ADDRESS.CITY_EXT |
|
|
|
|
COUNTRY |
NAME_ADDRESS.COUNTRY |
countryCode |
GAESTEST |
LAND |
C, 3 |
STATE |
NAME_ADDRESS.STATE |
stateCode |
GAESTEST |
STATE |
C, 3 |
LANGUAGE_CODE |
|
|
GAESTEST |
STRASSE4 |
C, 30 or C, 1 (depending on use) |
PRIMARY_YN |
NAME_ADDRESS.PRIMARY_YN |
MfPrimaryYN |
|
|
|
VIP_CODE |
NAME.VIP_STATUS |
MfVipStatus |
GAESTEST |
VIP |
N, 3 |
ACCT_CONTACT |
NAME.ACCT_CONTACT |
|
|
|
|
ACCOUNT_TYPE |
NAME.ACCOUNT_TYPE |
|
|
|
|
SUMM_REF_CC (Ref Currency) |
NAME.CURRENCY_CODE |
|
|
|
|
INDUSTRY_CODE |
NAME.INDUSTRY_CODE |
|
|
|
|
AR_NO_CENTRAL |
NAME.AR_NO |
|
GAESTEST |
AR_NUMBER |
|
SREP_CODE |
NAME.SALESREP |
|
|
|
|
RESORTG |
|
|
|
|
|
COMMENTS |
NAME_COMMENTS.COMMENTS |
|
|
|
|
Group Communication Information |
|
|
|
|
|
COMM1_TYPE |
NAME_PHONE. PHONE_TYPE |
<PhoneNumber phoneNumberType= "BUSINESS"> |
GAESTEST |
BTELEFON |
C, 20 |
COMM1_VALUE |
NAME_PHONE. PHONE_NUMBER |
phoneNumber |
|
|
|
COMM2_TYPE |
NAME_PHONE. PHONE_TYPE |
<PhoneNumber phoneNumberType= "BUSINESSFAX"> |
GAESTEST |
TELEFAX |
C, 20 |
COMM2_VALUE |
NAME_PHONE. PHONE_NUMBER |
phoneNumber |
|
|
|
COMM3_TYPE |
NAME_PHONE. PHONE_TYPE |
<ElectronicAddress electronicAddressType= "WEBPAGE"> |
|
|
C, 30 |
COMM3_VALUE |
NAME_PHONE. PHONE_NUMBER |
<eAddress> |
|
|
|
Group Negotiated Rates |
|
|
|
|
|
RATE_CODE |
RATE_HEADER_NEGOTIATED. RATE_CODE |
preferredRatePlanCode |
GAESTEST |
PKZ |
C, 3 |
BEGIN_DATE |
RATE_HEADER_NEGOTIATED. BEGIN_DATE |
|
|
|
|
END_DATE |
RATE_HEADER_NEGOTIATED. END_DATE |
|
|
|
|
ORDER_BY |
RATE_HEADER_NEGOTIATED. ORDER_BY |
|
|
|
|
Group Miscellaneous |
|
|
|
|
|
|
NAME.INSERT_DATE |
createdDate |
GAESTEST |
CREATED, LAST_DATE, LAST_TIME |
D, 8 |
|
NAME.NAME_ID |
profileID |
GAESTEST |
CRSNAME_ID |
C, 16 |
|
NAME.CRS_NAMEID |
pmsId |
GAESTEST |
NUMMER |
N, 8 |
F_BL_MSG |
NAME.CASH_BL_IND |
MfBlacklist |
GAESTEST |
BLACKLIST |
C, 1 |
F_BL_MSG |
NAME.BL_MSG |
mfBlacklistMessage |
GAESTEST |
BL_MESSAGE |
C, 16 |
KEYWORD (SEARCH_NAME) |
NAME_KEYWORDS.KEYWORD |
nameFirst |
GAESTEST |
VORNAME |
C,30 |
MAILING |
NAME.MAIL_YN |
mfallowmail |
GAESTEST |
ALLOWMAIL |
L,1 (used in OH version 2.5 & 2.6) |
MAILING_LIST |
NAME.MAILING_LIST |
mfallowmail |
GAESTEST |
ALLOWMAIL |
L,1 (used in OH version 3.0, no longer using MAIL_YN for Mailing) |
EMAIL_YN |
NAME.EMAIL_YN |
mfAllowEMail |
GAESTEST |
ALLOWEMAIL |
L,1 |
GUEST_PRIV_YN |
NAME.GUEST_PRIV_YN |
mfGuestPriv |
GAESTEST |
GUESTPRIV |
L,1 |
