ORS Field Label

ORS Table and Column

XML Tag

V6 DBF

V6 Field

Comment

NIGHTS

RESERVATION_NAME.END_DATE

NumberOfTimeUnits

GRES2

ABREISE

The IFC calculates what goes into ABREISE by looking at <stayDateRange timeUnitType=“DAY“><startTime> and adding <numberOFTimeUnits>

BLOCK_CODE

RESERVATION_DAILY_ELEMENTS. ALLOTMENT_HEADER_ID

InventoryBlockCode

GRES2

ALOTM

RESERVATION_NAME. INSERT_DATE

<originalBookingDate>

GRES2

AM

ARRIVAL

RESERVATION_NAME. BEGIN_DATE

stayDateRange timeUnitType=“DAY“><StartTime>

GRES2

ANREISE

NO_OF_ROOMS

RESERVATION_DAILY_ELEMENTS. QUANTITY

NumRooms

GRES2

ANZ

TRANSPORT TYPE

RESERVATION_NAME. ARRIVAL_TRANSPORT_TYPE

<ArrivalTransport transportType="AIR">

GRES2

ARR_TYPE

(i.e., AIR)

STATION CODE

RESERVATION_NAME. ARRIVAL_STATION_CODE

<locationCode>SC</locationCode>

GRES2

ARR_AIRPRT

Airline code (ie MIA)

CARRIER CODE

RESERVATION_NAME. ARRIVAL_CARRIER_CODE

Not Used – do not screen paint in ORS since the interface will not move it.

TRANSPORT NO.

RESERVATION_NAME. ARRIVAL_TRANSPORT_CODE

<transportID>DL321</transportID>

GRES2

ARR_FLIGHT

Airline and number are together (i.e., DL2562)

ARRIVAL DATE

RESERVATION_NAME. ARRIVAL_DATE_TIME

<transportTime>2003- 11- 22T18:30:00.000</transportTime>

GRES2

ARR_TIME

Arrival date is same date as Check- in and includes Pick up time if used.

PICK UP TIME

RESERVATION_NAME. ARRIVAL_ESTIMATE_TIME

Not Used – do not screen paint in ORS since the interface will not move it.

PICKUP REQD.

RESERVATION_NAME. ARRIVAL_TRANSPORTATION_YN

<mftransportRequired>1</mftransportRequired>

GRES2

ARR_TRAN

Flagged as Y or N. In message it is sent as numeric value 0 for No and 1 for Yes.

GUARANTEE_CODE

RESERVATION_NAME. GUARANTEE_CODE

MfGuaranteeType

GRES2

BA

ACCOMP

RESERVATION_NAME. NAME_USAGE_TYPE = AG

GenericName

GRES2

BEGL1

ACCOMP

RESERVATION_NAME. NAME_USAGE_TYPE = AG

GenericName

GRES2

BEGL2

ACCOMP

RESERVATION_NAME. NAME_USAGE_TYPE = AG

GenericName

GRES2

BEGL3

RESERVATION_NAME. NAME_USAGE_TYPE = AG

GenericName

GRES2

BEGL4

LAST_NAME (Contact)

RESERVATION. NAMEUDFC21

OrigContact

GRES2

BOOKER

Caller’s first and last name are all being inserted into the Booker field in the PMS.

FIRST_NAME (Contact

RESERVATION. NAMEUDFC22

OrigContact

GRES2

BOOKER

Caller’s first and last name are all being inserted into the Booker field in the PMS.

CHANNEL

RESERVATION.NAMECHANNEL

mfchannelCode

GRES2

CHANNEL

<Profile profileType="CORPORATE"<mfResortProfileID>

GRES2

COMPANY

CREDIT_CARD_NUMBER

NAME_CREDIT_CARD. CREDIT_CARD_NUMBER

creditCardNumber

GRES2

CREDITCARD

MfCRSShareID

GRES2

CRS_SHID

RESERVATION_NAME. CONFIRMATION_NO

ConfirmationID

GRES2

CRSRESNR

RESERVATION_DAILY_ELEMENTS. EXT_SEG_NO

MfLegNumbers

GRES2

CS_LEG_NOS

DEPARTURE_TRANSPORT_TYPE

RESERVATION_NAME. DEPARTURE_TRANSPORT_TYPE

Departure Transport TransportType

GRES2

DEP_TYPE

DEPARTURE_STATION_CODE

RESERVATION_NAME. DEPARTURE_STATION_CODE

Departure TransportLocationCode

GRES2

DEP_AIRPRT

DEPARTURE_TRANSPORT_CODE

RESERVATION_NAME. DEPARTURE_TRANSPORT_ CODE

Departure Transport TransportID

GRES2

DEP_FLIGHT

DEPARTURE_CARRIER_CODE –NOT USED-

DEPARTURE_DATE_TIME

RESERVATION_NAME. DEPARTURE_ESTIMATE_TIME

Departure Transport TransportTime

GRES2

DEP_TIME

DEPARTURE_ESTIMATE_TIME –NOT USED-

DEPARTURE_TRANSPORTATION_YN

RESERVATION_NAME. DEPARTURE_TRANSPORTATION_YN

Departure TransportMfYTransportRequired

GRES2

DEP_TRAN

‘Y’ OR ‘N’

DISCOUNT_REASON_CODE

RESERVATION_NAME. DISCOUNT_REASON_CODE

mfdiscountReason

GRES2

DISCREASON

ADULTS

RESERVATION_DAILY_ELEMENTS. ADULTS

<ageQualifyingCode>ADULT<

GRES2

ERW

RESERVATION_DAILY_ELEMENTS. CURRENCY_CODE

amount currencyCode

GRES2

EXCH_LNR

CREDIT_CARD_EXP_DATE

NAME_CREDIT_CARD. CREDIT_CARD_EXPIRATION_DATE

creditCardExpire

GRES2

EXPY

RESERVATION_MEMBERSHIPS. MEMBERSHIP_CARD_NO

AccountID

GRES2

FGPNUM

RESERVATION_MEMBERSHIPS. MEMBERSHIP_TYPE

ProgramCode

GRES2

FGPTYPE

<expireDate>

GRES2

FFPEXPY

RESERVATION_MEMBERSHIPS. MEMBERSHIP_CARD_NO

accountID

GRES2

FFPNUM

RESERVATION_MEMBERSHIPS. MEMBERSHIP_TYPE

ProgramCode

GRES2

FFPTYPE

RESERVATION_NAME. SGUEST_NAME

GenericName

GRES2

GASTNAME

ProfileID

GRES2

GASTNR

The IFC takes the crsname_id, then searches gaestest to find the nummer associated with that crsname_id, and then inserts the nummer into gastnr

<Profile profileType="GROUP"<mfResortProfileID>

GRES2

GROUP

ROOM_CATEGORY_LABEL

RESERVATION_DAILY_ELEMENTS. ROOM_CATEGORY

RoomInventoryCode

GRES2

KAT

CHILD

RESERVATION_DAILY_ELEMENTS. CHILD

<zageQualifyingCode>CHILD<

GRES2

KIN

mfupdateDate

GRES2

LAST_DATE

mfupdateDate

GRES2

LAST_TIME

GRES2

LAST_WHO

IFC automatically inserts the userid of the user logged into the ORS into the last_who field that user updates reservations in ORS. There is no xml tag.

MARKET_CODE

RESERVATION_DAILY_ELEMENTS. MARKET_CODE

mfMarketCode

GRES2

MARKET

GUARANTEE_CODE

RESERVATION_NAME. GUARANTEE_CODE

mfGuaranteeType

GRES2

OBA

PRODUCTS

RESERVATION_PRODUCTS. PRODUCT_ID

serviceInventoryCode

GRES2

PACKAGES

RATE_CODE

RESERVATION_DAILY_ELEMENTS. RATE_CODE

ratePlanCode

GRES2

PCODE

PAYMENT_METHOD

RESERVATION_NAME. PAYMENT_METHOD

mfPaymentMethod

GRES2

PMETHOD

SHARE_AMOUNT

RESERVATION_DAILY_ELEMENTS. AMOUNT

valueNum

GRES2

PREIS

DISCOUNT_AMOUNT

RESERVATION_NAME. DISCOUNT_AMT

mfDiscountAmount

GRES2

RATEDIFF

EXTERNAL_REFERENCE

RESERVATION_NAME. EXTERNAL_REFERENCE

pmsId

GRES2

REGISTER

Inserted into ORS from PMS via a result message

TRAVEL_AGENT_NAME

RESERVATION_NAME.NAME_ID

<Profile profileType="TRAVEL"<genericName>

GRES2

RT4

GROUP_NAME

RESERVATION_NAME.NAME_ID

<Profile profileType="GROUP"<genericName>

GRES2

RT5

SOURCE_NAME

RESERVATION_NAME.NAME_ID

<Profile profileType="WHOLESALER"<genericName>

GRES2

RT6

COMPANY_NAME

RESERVATION_NAME.

<Profile profileType="CORPORATE"<genericName>

GRES2

RT7

ORIGIN_OF_BOOKING

RESERVATION_DAILY_ELEMENTS. ORIGIN_OF_BOOKING

mfsourceCode

GRES2

SCODE

ORIGIN_OF_BOOKING

RESERVATION_DAILY_ELEMENTS. ORIGIN_OF_BOOKING

<Profile profileType="WHOLESALER"

GRES2

SOURCE

SPECIAL_REQUESTS

RESERVATION_SPECIAL_REQUEST. SPECIAL_REQUEST_ID

<SpecialRequest mfSpecialRequestType="SPE">          <requestCode>

GRES2

SPECIALS

RESERVATION_NAME. CANCELLATION_DATE

cancellationDate

GRES2

STORNO

RESERVATION_NAME.NAME_ID

<Profile profileType="TRAVEL"<mfResortProfileID>

GRES2

TRAVEL

<reservationOriginatorCode>

GRES2

USERID

DEPOSIT

RESERVATION_DEPOSIT_SCHEDULE. DEPOSIT_AMOUNT

<GuaranteeDeposit><valueNum>

GRES2

DEPOSIT

DEPOSIT

RESERVATION_DEPOSIT_SCHEDULE. DEPOSIT_DUE_DATE

<GuaranteeDeposit><dueDate>

GRES2

LIMIT

COMMENTS

RESERVATION_COMMENT.COMMENTS

<ResComment reservationActionType><comment>

NOTICE

NOTICE

CALLER FAX

CALL_HEADER.CALLER_FAX

<PhoneNumbers>

<PhoneNumber phoneNumberType="FAX">

<phoneNumber>

GRES2

RESBYFAX

C 25

CALLER PHONE

CALL_HEADER.CALLER_PHONE

<PhoneNumbers>

PhoneNumber phoneNumberType="BUSINESS">

<phoneNumber>

GRES2

RESBYPHONE

C 15

CALLER EMAIL

CALL_HEADER.CALLER_EMAIL

<ElectronicAddresses>

<ElectronicAddress electronicAddressType="EMAIL">

<eaddress>

GRES2

RESBYEMAIL

C 30