Configuring Business Events

Business Events are required in OPERA Cloud to trigger and send messages to the external systems configured at your property. Business Events are configured according to the types of data the external system supports and requires. Unique business events and data elements are defined for each external system, external database and module combination. When a user performs an action in OPERA Cloud that involves that selected data elements and conditions (optional), a business event is triggered which then becomes a message to the external system.

For example, if an external system requires reservations and profiles data you need to configure reservation and profile business events. If an external system requires rates and inventory data you need to configure business events for rates and inventory, and so forth.

There are three levels to Business Event setup.

The Business Event Modules (Activity, Availability, Block, Block Offsets, Cashiering, Catering Notes, Configuration, Enrollment, Housekeeping, Night Audit, Owner Contract, Profile, Rate, Reservation, and Stay Records.)
Within each module there are the actual Business Events (Action Types) that can be subscribed to- New Reservation, Update Reservation, New Profile, etc.
Finally, there are Data Elements corresponding to each Action Type- Room Type, Rate Code, name , etc.

The Business Events generated are based on a customizable configuration that the business event user determines. The result is a user-configurable flow of data that is available to third parties to extract (dequeue) from OPERA Cloud on a regular basis.

Note:

Business Events subscribed to with no Data Elements attached will generate an XML message with header information only for the Business Event. It is imperative that third party systems carefully consider this before programming their dequeue process from OPERA Cloud. It is highly suggested that the third party dequeue application is programmed to ignore Modules/Business Events (Action Types)/ Data Elements that the hotel may subscribe to but that the data recipient does not recognize. In this way, you can insure an uninterrupted process of data flow.

Adding Business Events

From the Administration menu, select Interfaces, select Business Events and then select Business Event Configuration.
Click New and enter the following details:
1. Property. Enter or select the property
2. External System. Select the external system from the list. See Configuring External Systems
3. Module. Select the module from the list
4. Business Event. Select the business event from the list
5. Data Elements to generate a Business Event when any of the data element values are changed in OPERA Cloud.
  1. Search and select data elements in the Available panel, click > or >> to move selection to the Selected panel.
6. Conditions (where clause)
  1. Click Add to add a conditional expression.
    - And/Or. Displays for compound expressions; select AND / OR operator.
    - Attribute. Select an attribute from the list.
    - Operator. Select an operator from the list.
    - Value. Enter the comparison value for the expression.
  2. Click OK.
  3. Repeat to add another condition.
7. To Edit, select a condition and click Edit.
8. To Delete, select a condition and click Delete.
Click Save.

Editing Business Events

From the Administration menu, select Interfaces, select Business Events and then select External Systems.
Enter search criteria and click Search.
Select the business event, click vertical ellipsis and select Edit.
Update details.
Click Save.

Deleting Business Events

From the Administration menu, select Interfaces, select Business Events and then select Business Event Configuration.
Enter search criteria and click Search.
Select the business event, click vertical ellipsis and select Delete.
Click Delete to confirm.

Module–Activity

Table 16-1 Module–Activity

Data Element	Xml Tag Name	Data Type	Create Activity	Delete Activity	Update Activity	Create OSAActivity	Update OSA Activity	Delete OSA Activity
ACTIVITY ID	Activityid	N				X	X	X
ACT_ID	ActId	N	X	X	X
ATTENDEES	Attendees	N				X	X	X
END DATE	Enddate	D				X	X	X
END TIME	Endtime	T				X	X	X
GUEST NAME ID	Guestnameid	N				X	X	X
LOCATION CODE	Locationcode	C				X	X	X
RESORT	Resort	N	X	X	X	X	X	X
RESV NAME ID	Resvnameid	N				X	X	X
START DATE	Startdate	D				X	X	X
START TIME	Starttime	T				X	X	X

Module–Availability

Table 16-2 Module–Availability

Data Element	Xml Tag Name	Data Type	Summary Totals	Delete lAllowance	Update Allowance	New Allowance	Item Inventory Details	Item Inventory Totals	Description
ALLOWANCE	Allowance	N		X	X	X
BEGIN DATE	BeginDate	D		X	X	X
CONFIRMATION LEG NO	Confirmation LegNo	N					X		Confirmation leg number of the reservation that is consuming the inventory items in OPERA PMS/ORS that are sent to MYFIDELIO through OXI and OXIHUB.
CONFIRMATION NO	ConfirmationNo	C					X		Confirmation number of the reservation that is consuming the inventory items in OPERA PMS/ORS that are sent to MYFIDELIO through OXI and OXIHUB.
DATE	Date	D	X						The current business date
END DATE	EndDate	D		X	X	X
HOTEL ROOMS SOLD	HotelRoomsSold	N	X
ITEM CODE	ItemCode	C						X
ITEMS AVAILABLE	ItemsAvailable	N						X
ITEMS IN STOCK	ItemsInStock	N						X
ITEMS SOLD	ItemsSold	N						X
OUT OF ORDER	OutOfOrder	N	X						This does not include Out of Service Rooms.
OVERBOOKING	Overbooking	N	X
PHYSICAL ROOMS	PhysicalRooms	N	X						In the case of Suites: An availability business event for each of the room types making up the component suite will be generated. As there is no physical inventory attached to the component suite - physical rooms could never be determined.
RATE CODE	RateCode	C		X	X	X
RESERVED BY	ReservedBy	C					X		Reservation reserved by of the reservation that is consuming the inventory items in OPERA PMS/ORS that are sent to MYFIDELIO through OXI and OXIHUB.
RESERVED BY ID	ReservedById	N					X		Reservation reserved by ID number of the reservation that is consuming the inventory items in OPERA PMS/ORS that are sent to MYFIDELIO through OXI and OXIHUB.
ROOM TYPE	RoomType	C	X	X	X	X			Pseudo Room Types: Not generated for Pseudo=Y, Generic Flag = Y or Inactive = Y Component Suites: An availability business event for each of the room types that make up the component suite will be created. For example: If a suite is made up of three room types - three room type avail messaged would be generated: Discontinued Room Types: Inactive Room Types are not included in the business event synchronization. Enhancement request added for a future version to consider inactive date for business event synchronization.
SOLD ROOMS	SoldRooms	N	X						Number of Rooms that have been reserved.

Module – Block

Table 16-3 Module – Block

Data Element	Xml Tag Name	Data Type	Update Block Grid	Update Lead Grid	Update Block Grid Summary	Update Block Pickup	Update Rates	Update Lead Rates	New Block Header	Delete Block Header	Update Block Header	Update Lead Header	Delete Lead Header	Update Lead Notes	Block Restrictions	Delete Contract Header	Update Contract Header	Update Block Security	Update Businessblock Links	Description
1 PERSON RATE	OnePersonRate	N					X	X
2 PERSON RATE	TwoPersonRate	N					X	X
3 PERSON RATE	ThreePersonRate	N					X	X
4 PERSON RATE	FourPersonRate	N					X	X
ADDITIONAL PERSON	AdditionalPerson	N					X	X
AGENT CONTACT NAME ID	agentContactNameId	N									X								X
ALIAS	Alias	C							X	X	X	X	X						X
ALLOTMENT HEADER ID	AllotmentHeaderId	N												X
ALLOTMENT ORIGIN	AllotmentOrigin	C							X		X	X							X
ALLOTTED BLOCKED	AllottedBlock	N	X	X
ARRIVAL	Arrival	C													X
ARRIVAL TIME	ArrivalTime	T							X	X	X								X
ATTACHMENT CHANGED	AttachmentChanged	C									X
ATTENDEES	attendees	N									X
BLOCK CODE	BlockCode	C	X	X	X	X	X		X	X	X	X	X						X	The Block Code of the Block. This does not need to be unique based on application parameter UNIQUE BLOCK CODE.
BLOCK ID	BlockId	N													X
BLOCK NAME	BlockName	C	X	X	X	X	X		X	X	X	X	X						X
BLOCK SHIFT YN	BlockShiftYn	C	X				X
BLOCK TYPE	BlockType	C							X	X	X								X
BOOK MAX ADV	BookMaxAdv	N													X
BOOK MIN ADV	BookMinAdv	N													X
BOOKING STATUS	BookingStatus	C							X	X	X								X	Status will be shown as CAN for cancelled blocks.
BOOKING TYPE	BookingType	C							X	X	X								X
CAT DECISION	CatDecision	D									X
CAT FOLLOWUP	CatFollowUp	D									X
CAT STATUS	CatStatus	C							X	X	X								X
CATERING ONLY YN	CateringOnlyYn	C							X	X	X	X	X						X
CHANNEL	Channel	C							X	X	X	X	X						X
COMMISSION	Commission	C							X	X	X								X
COMPANY NAME	CompanyName	C							X	X	X	X	X						X
COMPANY NAME ID	CompanyNameId	N							X	X	X	X	X						X
CONTACT NAME ID	contactNameId	N									X						X		X
CONTRACT	Contract	C														X	X
CONTRACT NO	ContractNo	C														X	X
CONTRACT OCC 1	ContractOcc1	N	X	X
CONTRACT OCC 2	ContractOcc2	N	X	X
CONTRACT OCC 3	ContractOcc3	N	X	X
CONTRACT OCC 4	ContractOcc4	N	X	X
CREDIT CARD NUMBER	CreditCardNumber	C							X	X	X	X	X						X
CURRENCY CODE	CurrencyCode	C							X	X	X	X	X						X	The currency code that the block was created in.
CUTOFF DATE	CutoffDate	D	X	X					X	X	X	X	X						X	The date when the system will release any non-picked up rooms and put back into inventory.
CUTOFF DAYS	CutoffDays	N	X	X					X	X	X	X	X						X	The number of days before the arrival date when the system will release any non- picked up rooms and put back into inventory.
CXL PENALTY	CxlPenalty	N							X		X								X
DATES FLEXIBLE	DatesFlexible	C							X	X	X	X	X						X
DAY OF WEEK	DayOfWeek	C													X
DECISION DATE	DecisionDate	D							X	X	X								X
DEPARTURE	Departure	C													X
DEPARTURE TIME	DepartureTime	T							X	X	X								X
DETAILS OK YN	DetailsOkYn	C									X
DISTRIBUTED DATE	DistributedDate	D									X
DISTRIBUTED YN	DistributedYn	C									X
ELASTIC BLOCK	ElasticBlock	N							X	X	X	X	X						X	Is this Block allowed to have reservations made outside the block date?
END DATE	EndDate	D							X	X	X	X	X						X	The UPDATE BLOCK HEADER business event will not be triggered for business blocks that are updated and have an End Date prior to the current business date.
EVENT GUARANTEED YN	EventGuarantedYn	C									X
EXTERNAL LOCKED	ExternalLocked	C							X	X	X	X	X						X
EXTERNAL ID	Externalid	N												X
FB AGENDA CURR	FbAgendaCurr	C							X	X	X								X
FIT CONTRACT MODE	FitContractMode	C															X
FOLLOW UP DATE	FollowUpDate	D							X	X	X								X
GRID DATE	GridDate	D	X	X		X	X	X
GROUP NAME	GroupName	C							X	X	X	X	X						X	Refers to the Group Profile Name attached to the Block. Block name is the name of the Business Block.
GROUP NAME ID	GroupNameId	N							X	X	X	X	X						X
GSO ASSOCIATE	GsoAssociate	C							X	X	X								X
GSO SENDING LOCATION	GsoSendingLocation	C							X	X	X								X
HLX CANX NOTICE DAYS	HlxCanxNoticeDays	N							X		X							X	X
HLX COMMISSIONABLE YN	HlxCommissionableYn	C							X		X							X	X
HLX DD SECURED YN	HlxDdSecuredYn	C																X
HLX DEPOSIT DAYS	HlxDepositDays	N							X		X							X	X
HLX DI SECURED YN	HlxDiSecuredYn	C																X
HLX HOUSINGINFO SECURED YN	HlxHousinginfoSecuredYn	C																X
HLX RATE ALL SECURED YN	HlxRateAllSecuredYn	C																X
HLX RATES GNR SECURED YN	HlxRatesGnrSecuredYn	C																X
HLX RETURN EACH DAY YN	HlxReturnEachDayYn	C							X		X							X	X
INFO BOARD	infoBoardName	C									X
INITIAL BLOCKED	InitialBlocked	N	X	X
INSERT DATE	InsertDate	D							X	X	X	X	X						X	This doesn't apply to Block Grids as Insert Data is not availble for inserting availablity in the grid. Update Block Header would give you the Update Date.
INSERT USER	InsertUser	N							X	X	X								X
INTERNAL_YN	InternalYn	C												X
ISAC OPPTY ID	IsacOpptyId	C							X	X	X								X
LEADSTATUS	LeadStatus	C											X			X	X
LENGTH OF STAY NA	LengthOfStayNA	C													X
LINK DATE	LinkDate	D							X	X	X								X
LOST TO PROPERTY	LostToProperty	C									X								X
MARKET CODE	MarketCode	C							X	X	X	X	X						X
MAX LOS	MaxLos	N													X
MAX STAY THROUGH	MaxStayThrough	N													X
MIN LOS	MinLos	N													X
MIN STAY THROUGH	MinStayThrough	N													X
NOTES	Notes	C												X
NOTE_CODE	NoteCode	C												X
NOTE_ID	NoteId	N												X
NOTE_TITLE	NoteTitle	C												X
NUMBER OF ROOMS RELEASED	NumberOfRoomsReleased	N	X	X																The number of rooms released when any non-picked up rooms are released back into inventory. Regarless if the system releases the rooms based on cutoff date or are released manually.
OPPTY CREATED DATE	OpptyCreatedDate	D							X	X	X								X
ORIGINAL BEGIN DATE HOLIDEX	OriginalBeginDateHolidex	D							X	X	X								X
PAYMENT METHOD	PaymentMethod	C							X	X	X	X	X						X
PICK UP ROOMS	PickupRooms	N				X														The number of rooms that have reservations made against the block.
PRINT RATE FLAG	PrintRateFlag	C							X	X	X								X
PRODUCTS	Products	C							X	X	X	X	X						X	The add-on packages that have been attached to the block or are attached by default because a Package is attached to the Rate Code on the Block Header.
RATE CODE	RateCode	C							X	X	X	X	X						X	The rate code that has been attached to the block. There is no relationship between a group and a rate code. A rate code can be used for both transient and block reservation. A business practice could be to only use specific rate codes for blocks, but OPERA Cloud would not force this functionality.
REPLY STATUS	ReplyStatus	C										X				X	X
RESERVATION METHOD	ReservationMethod	C							X	X	X								X
RESERVATION TYPE	ReservationType	C							X	X	X	X	X						X	The default reservation type for all reservations made against this block. If a Block has a Block Status of 'O' Open for Pickup, the Reservation Type should be used to determine if the Rooms Held are Deduct or Non-Deduct from Inventory.
RESERVE INVENTORY	ReserveInventory	C							X	X	X	X	X						X	Value will be populated with Y or N. When Y, the Block rooms are deduct from inventory. This is relevant when Block Status is 'O' - Open for Pickup. This Block Status alone does not represent whether the inventory is deduct or non deduct. This element is released in Version 2.6.
RESORT	Resort	C												X
RESPONSE DUE DATE	ResponseDueDate	D							X	X	X								X
ROOM TYPE	RoomType	C	X	X		X	X	X							X
ROOMING LIST DUE	RoomingListDue	D							X	X	X								X
SELL LIMIT	SellLimit	N	X
SELL LIMIT SOLD	SellLimitSold	N				X
SELL THRU	SellThru	C							X	X	X								X
SET ON	SetOn	C													X
SHOULDER END DATE	ShoulderEndDate	D							X	X	X								X
SHOULDER END RATE	ShoulderEndRate	C							X	X	X								X
SHOULDER START RATE	ShoulderStartRate	C							X	X	X								X
SHOULDER STARTING DATE	ShoulderStartingDate	D							X	X	X								X
SOURCE CODE	SourceCode	C							X	X	X	X	X						X
SOURCE NAME	SourceName	C							X	X	X	X	X						X
SOURCE NAME ID	SourceNameId	N							X	X	X	X	X						X
STARTING DATE	BLKStartDate	D							X	X	X	X	X						X
STATUS	BLKStatus	C							X	X	X	X	X						X	The current block status. 'C'=Returns all held rooms to inventory; 'F'= Not open for Pickup, do not deduct rooms from inventory; 'I'= Not open for pickup, deduct from inventory; 'O'= Open for pickup. This alone does not determine whether or not to deduct rooms from inventory. When 'O' is received as the block status (status element) then the reservation type also needs to be considered. The reservation type determines if the rooms are deduct or non-deduct. 'P'=Not open for pickup. Do not deduct from inventory. This status is no longer used in OPERA Cloud, instead 'F' is assigned, however, blocks created in the past may indeed have this status.
SUB ALLOTMENT	SubAllotment	C									X								X
SUPER BLOCK CODE	SuperBlockCode	C							X	X	X	X	X						X	If this block is a sub-block of another, what is the code of the main block?
SUPER BLOCK ID	SuperBlockId	C							X	X	X	X	X						X	If this block is a sub-block of another, what is the Block ID of the Main Block Header. In the case of Tour Series, the Super Block ID will be '-2'.
SUPPRESS RATE FLAG	SuppressRateFlag	C							X	X	X								X
SYNC CONTRACT	SyncContract	C							X	X	X	X	X						X
TRACE CODE	TraceCode	C							X	X	X	X	X						X
TRAVEL AGENT NAME	TravelAgentName	C							X	X	X	X	X						X
TRAVEL AGENT NAME ID	TravelAgentNameId	N							X	X	X	X	X						X
UPDATE USER	UpdateUser	N							X	X	X								X
WEB BOOKABLE	WebBookable	C							X	X	X

Module – Block Offsets

Table 16-4 Module – Block Offsets

Data Element	Xml Tag Name	Data Type	Create Offset Grid	Create Offset Product	Create Offset Rate	Create Offset Type	Delete Offset Grid	Delete Offset Product	Delete Offset Rate	Delete Offset Type	Update Offset Grid	Update Offset Product	Update Offset Rate	Update Offset Type
ACTION_ID	ActionId	N		X								X
ALLOTMENT_DATE	AllotmentDate	D					X
ALLOTMENT_HEADER_ID	AllotmentHeaderId	N	X	X	X	X	X	X	X	X	X	X	X	X
ALLOTMENT_PRODUCT_ID	AllotmentProductId	N		X				X				X
BEGIN_DATE	BeginDate	D	X	X	X		X				X	X	X
DML_SEQ_NO	DmlSeqNo	N		X								X
END_DATE	EndDate	D	X	X	X		X				X	X	X
IGNORE_OFFSET_YN	IgnoreOffsetYn	C				X								X
INACTIVE_DATE	InactiveDate	D				X								X
LAPTOP_CHANGE	LaptopChange	N		X								X
OCC1	Occ1	N	X								X
OCC2	Occ2	N	X								X
OCC3	Occ3	N	X								X
OCC4	Occ4	N	X								X
OFFSET_TYPE	OffsetType	C	X	X		X	X		X	X	X	X	X	X
PICKUP_OCC1	PickupOcc1	N	X								X
PICKUP_OCC2	PickupOcc2	N	X								X
PICKUP_OCC3	PickupOcc3	N	X								X
PICKUP_OCC4	PickupOcc4	N	X								X
PICKUP_QUANTITY	PickupQuantity	N	X								X
PRIMARY_YN	PrimaryYn	C			X								X
PRODUCT_GROUP	ProductGroup	C		X								X
PRODUCT_ID	ProductId	C		X								X
PRODUCT_SOURCE	ProductSource	C		X								X
QTY_EXCLUDED	QtyExcluded	N		X								X
QUANTITY	Quantity	N	X	X							X	X
RATE1	Rate1	N	X								X
RATE2	Rate2	N	X								X
RATE3	Rate3	N	X								X
RATE4	Rate4	N	X								X
RATEAP	Rateap	N	X								X
RATE_CODE	RateCode	C		X	X				X			X	X
RECORD_TYPE	RecordType	C			X				X				X
RESORT	Resort	C	X	X	X	X	X	X	X	X	X	X	X	X
ROOM_CATEGORY	RoomCategory	C	X				X				X
ROOM_CLASS	RoomClass	C	X								X
SC_ROOM_CATEGORY	ScRoomCategory	C	X								X
SYNC ALL OFFSETS	SyncAllOffsets	C												X

Module – Cashiering

Table 16-5 Module – Cashiering

Data Element	Xml Tag Name	Data Type	New Posting	Update Posting	Delete Posting	Description
AMOUNT	Amount	N	X	X	X
APPROVAL CODE	Approval Code	C	X	X	X
APPROVAL DATE	ApprovalDate	D	X	X	X
APPROVAL STATUS	ApprovalStatus	C	X	X	X
AUTHORIZER	Authorizer	N	X	X	X
CASHIER	Cashier	N	X	X	X
COMP NO	CompNumber	C	X	X	X
CONFIRMATION NO	ConfirmationNo	N	X	X	X
CREDIT	Credit	N	X	X	X
CURRENCY CODE	CurrencyCode	C	X	X	X
DEBIT	Debit	N	X	X	X
DEPOSIT CREDIT	DepositCredit	C		X	X
DEPOSIT CREDIT	DepositCredit	N	X
DEPOSIT DEBIT	DepositDebit	C		X	X
DEPOSIT DEBIT	DepositDebit	N	X
EXTERNAL USER ID	ExternalUserId	C	X	X	X
FIRST NAME	FirstName	C	X	X	X
GUEST NAME ID	GuestNameID	N	X	X	X
MEMBERSHIP NUMBER	MembershipNumber	C	X	X	X
MEMBERSHIP TYPE	MembershipType	C	X	X	X
NAME	Name	C	X	X	X
POSTED AMOUNT	PostedAmount	C		X	X
POSTED AMOUNT	PostedAmount	N	X
RESV NAME ID	ResvNameId	N	X	X	X	Available as of Version 3.0
ROOM	RoomNumber	C	X	X	X
SUB GROUP	SubGroup	C	X	X	X
TRANSACTION CODE	TransactionCode	C	X	X	X
TRANSACTION DATE	TransactionDate	D	X	X	X
TRANSACTION DESC	TransactionDesc	C	X	X	X
TRANSACTION ID	TransactionID	N	X	X	X
TRANSACTION STATUS	TransactionStatus	C	X	X	X	Status of the posting. Transfer or Adjustment
TRX AMOUNT	TrxAmount	C		X	X
TRX AMOUNT	TrxAmount	N	X
USER NAME	UserName	C	X	X	X	Authorizer's Login User Name. Available as of Version 3.0
WINDOW	Window	N	X	X	X

Module – Catering

Table 16-6 Module – Catering

Data Element	Xml Tag Name	Data Type	New Posting	Update Posting	Delete Posting
ACTUAL_ATTENDEES	ActualAttendees	N	X		X
ACTUAL_MANUAL	ActualManual	C	X		X
ATTENDEES	Attendees	N	X		X
BLOCKEND	Blockend	D	X		X
BLOCKSTART	Blockstart	D	X		X
BOOK_ID	BookId	N	X	X	X
DONT_MOVE_YN	DontMoveYn	C	X		X
DOORCARD	Doorcard	C	X		X
DOORCARD_YN	DoorcardYn	C	X		X
END_DATE	EndDate	D	X		X
EVENT_ID	EventId	N	X	X	X
EVENT_LINK_ID	EventLinkId	N	X		X
EVENT_LINK_TYPE	EventLinkType	C	X		X
EV_NAME	EvName	C	X		X
EV_RESORT	EvResort	C	X		X
EV_STATUS	EvStatus	C	X		X
EV_TYPE	EvType	C	X		X
EXCLUDE_FROM_FORECAST_YN	ExcludeFromForecastYn	C	X		X
EXTERNAL REFERENCE	ExternalReference	C		X
FORECAST_REVENUE_ONLY_YN	ForecastRevenueOnlyYn	C	X		X
GROUP_ID	GroupId	N	X		X
GUARANTEED	Guaranteed	N	X		X
INSPECTED_DATE	InspectedDate	D	X		X
INSPECTED_USER	InspectedUser	N	X		X
INSPECTED_YN	InspectedYn	C	X		X
MASTER_EVENT_ID	MasterEventId	N	X		X
MASTER_YN	MasterYn	C	X		X
PKG_ACT_ATTENDEES	PkgActAttendees	N	X		X
PKG_EXP_ATTENDEES	PkgExpAttendees	N	X		X
PKG_GUA_ATTENDEES	PkgGuaAttendees	N	X		X
PKG_ID	PkgId	N	X		X
PROBLEM_YN	ProblemYn	C	X		X
RESORT	Resort	C	X	X	X
ROOM	Room	C	X		X
ROOM_SETUP	RoomSetup	C	X		X
SETDOWN_TIME	SetdownTime	N	X		X
SETUP_TIME	SetupTime	N	X		X
START_DATE	StartDate	D	X		X
TRACECODE	Tracecode	C	X		X
TURNTO_STATUS	TurntoStatus	C	X		X
WAITLIST_YN	WaitlistYn	C	X		X
WL_IGNORE_YN	WlIgnoreYn	C	X		X

Module – E-Certificate

Table 16-7 Module – E-Certificate

Data Element	Xml Tag Name	Data Type	New E-Certificate	Update E-Certificate	New In Lieu E-Certificate
AUTH CODE	AuthCode	C	X	X	X
AWARD POINTS	AwardPoints	N	X	X	X
AWARD TYPE	AwardType	C	X	X	X
CANCEL ALLOWED YN	CancelAllowedYn	C	X	X	X
CANCEL REQUEST DATE	CancelRequestDate	D	X	X	X
CERT CODE	CertCode	C	X	X	X
CERT ID	CertId	N	X	X	X
CERT LABEL	CertLabel	C	X	X	X
CERTIFICATE NO	CertificateNo	C	X	X	X
CERTIFICATE SEQ NO	CertificateSeqNo	N	X	X	X
CHAIN CODE	ChainCode	C	X	X	X
CONSUMED AT	ConsumedAt	C	X	X	X
CONSUMER EMAIL	ConsumerEmail	C	X	X	X
CONSUMER FIRST NAME	ConsumerFirstName	C	X	X	X
CONSUMER LAST NAME	ConsumerLastName	C	X	X	X
CONSUMER MIDDLE NAME	ConsumerMiddleName	C	X	X	X
CONSUMPTION DATE	ConsumptionDate	D	X	X	X
CONSUMPTION LEG NO	ConsumptionLegNo	C	X	X	X
CONSUMPTION REF NO	ConsumptionRefNo	C	X	X	X
CONSUMPTION REF TYPE	ConsumptionRefType	C	X	X	X
CONSUMPTION USER NAME	ConsumptionUserName	C	X	X	X
COST	Cost	N	X	X	X
EXPIRY DATE	ExpiryDate	D	X	X	X
FOR CHAIN CODE	ForChainCode	C	X	X	X
GEN IN LIEU CERT YN	GenInLieuCertYn	C	X	X	X
GEN RULE ID	GenRuleId	N	X	X	X
GEN RULE VALUE	GenRuleValue	C	X	X	X
GEN RULE VALUE TYPE	GenRuleValueType	C	X	X	X
INACTIVE DATE	InactiveDate	D	X	X	X
INSERT DATE	InsertDate	D	X	X	X
INSERT USER	InsertUser	N	X	X	X
ISSUE DATE	IssueDate	D	X	X	X
ISSUE SOURCE	IssueSource	C	X	X	X
ISSUE TYPE	IssueType	C	X	X	X
ISSUED DATABASE ID	IssuedDatabaseId	C	X	X	X
LONG DESCRIPTION	LongDescription	C	X	X	X
MEMBERSHIP AWARD ID	MembershipAwardId	N	X	X	X
MEMBERSHIP TYPE	MembershipType	C	X	X	X
NAME ID	NameId	N	X	X	X
OCIS CURRENCY CODE	OcisCurrencyCode	C	X	X	X
ORIGINAL CERTIFICATE NO	OriginalCertificateNo	C	X	X	X
ORIGINAL VOUCHER NO	OriginalVoucherNo	C	X	X	X
OWS CONSUMED YN	OwsConsumedYn	C	X	X	X
PMS CONSUMED YN	PmsConsumedYn	C	X	X	X
PRINT STATUS	PrintStatus	C	X	X	X
PROMOTION CODE	PromotionCode	C	X	X	X
RESERVATION CERT YN	ReservationCertYn	C	X	X	X
RESORT	Resort	C	X	X	X
RESORT CONSUMED	ResortConsumed	C	X	X	X
RESV NAME ID	ResvNameId	N	X	X	X
SCOPE	Scope	C	X
SERVICE DATE	ServiceDate	D	X	X	X
SHORT DESCRIPTION	ShortDescription	C	X	X	X
STATUS	Status	C	X	X	X
UPDATE DATE	UpdateDate	D	X	X	X
UPDATE USER	UpdateUser	N	X	X	X
USER NOTES	UserNotes	C	X	X	X
VALUE	Value	N	X	X	X
VERIFY CERT NO YN	VerifyCertNoYn	C	X	X	X
VOUCHER NO	VoucherNo	C	X	X	X

Module – Enrollment

Table 16-8 Module – Enrollment

Data Element	Xml Tag Name	Data Type	New Enrollment	Update Enrollment
ADDRESS 1	Address1	C	X	X
ADDRESS 2	Address2	C	X	X
AGENT MEMBER NO	AgentMemberNo	C	X	X
BUSINESS EXT	BusinessExt	C	X	X
BUSINESS PHONE	BusinessPhone	C	X	X
CC EXPIRATION DATE	CcExpirationDate	C	X	X
CC NO	CcNo	C	X	X
CC NO 4 DIGITS	CcNo4Digits	C	X	X
CC TYPE	CcType	C	X	X
CC VAULT ID	CcVaultId	C	X	X
CITY	City	C	X	X
COMM NAME	CommName	C	X	X
COUNTRY	Country	C	X	X
COUNTRY BIRTH	CountryBirth	C	X	X
COUNTRY CITIZEN	CountryCitizen	C	X	X
COUNTRY PASSPORT	CountryPassport	C	X	X
EMAIL ADDRESS	EmailAddress	C	X	X
EMAIL PREF CODE	EmailPrefCode	C	X	X
ENROLLMENT REC TYPE	EnrollmentRecType	C	X	X
FIRST NAME	FirstName	C	X	X
GUEST NAME ID	GuestNameID	N	X
HOME OR BUSINESS FLAG	HomeOrBusinessFlag	C	X	X
HOME PHONE	HomePhone	C	X	X
INSERT USER	InsertUser	N	X	X
LANGUAGE CODE	LanguageCode	C	X	X
LAST NAME	LastName	C	X	X
MEMBERSHIP LEVEL	MembershipLevel	C	X	X
MEMBERSHIP NO	MembershipNo	N	X	X
MIDDLE INITIAL	MiddleInitial	C	X	X
MP CODE	MpCode	C	X	X
PASSPORT NUMBER	PassportNumber	C	X	X
PMT AMOUNT	PmtAmount	N	X	X
PMT CC EXPIRATION DATE	PmtCcExpirationDate	C	X	X
PMT CC NO	PmtCcNo	C	X	X
PMT CC TYPE	PmtCcType	C	X	X
PMT METHOD	PmtMethod	C	X	X
PREF NAME	PrefName	C	X	X
PREFERENCE	Preference	N	X	X
PREFERENCE TYPE	PreferenceType	N	X	X
RATE CODE	RateCode	C	X	X
RESORT	Resort	C	X	X
RESV NAME ID	ResvNameId	N	X
SET NUMBER	SetNumber	C	X	X
SOURCE CODE	SourceCode	C	X	X
STATE	State	C	X	X
ZIP CODE	ZipCode	C	X	X

Module – Housekeeping

Table 16-9 Module – Housekeeping

Data Element	Xml Tag Name	Data Type	New Out Of Order	Update Out Of Order	New Out Of Service	Update Out Of Service	Update FO Status	Update Room Status	New Queue Room	Update Queue Room	Delete Queue Room	Room Type Out Of Order	New Closed for Web	Update Closed for Web	Description
ARRIVAL DATE	ArrivalDate	D							X	X	X
BEGIN DATE	OOOBeginDate	D	X	X	X	X						X	X	X
COMPLETED DATE	CompletedDate	D	X	X	X	X						X	X	X	The properties business date that the out of order task was completed.
END DATE	OOOEndDate	D	X	X	X	X						X	X	X
FO STATUS	FoStatus	C					X
GUEST NAME ID	GuestNameId	N							X	X	X
NAME	Name	C							X	X	X
QUEUE TIME	QueueTime	T							X	X	X
REASON	OOOReason	C	X	X	X	X						X	X	X
REPAIR REMARKS	RepairRemarks	C	X	X	X	X						X	X	X
REPAIR TYPE	RepairType	C	X	X	X	X						X	X	X
RESERVATION STATUS	ReservationStatus	C							X	X	X
RETURN STATUS	OOOReturnStatus	C	X	X	X	X						X	X	X
ROOM	RoomNumber	C	X	X	X	X	X	X				X	X	X
ROOM NUMBER	RoomNumber	C							X	X	X
ROOM STATUS	RoomStatus	C	X	X	X	X		X				X	X	X
ROOM TYPE	RoomType	C	X	X	X	X	X	X	X	X	X	X	X	X
ROOM TYPE CHILD EVENT	RoomTypeChildEvent	C	X	X											This data element allows for a reduction in messaging when multiple room types are taken out of order for an extended period. This child event will be used by the OXI interface to choose whether to suppress these for ‘ROOM TYPE OUT OF ORDER’ event.
USER ID	UserId	N					X

Module – Night Audit

Table 16-10 Module – Night Audit

Data Element	Xml Tag Name	Data Type	Due in Reservations	Revenue Sum	Roll Business Date	Close Business Date	Market Statistics	Hotel Statistics	Description
ADULTS	Adults	C						X
ARRIVAL DATE	ArrivalDate	D	X	X
ARRIVAL ROOMS	ArrivalRooms	C						X
ARRIVAL ROOMS TOMORROW	ArrivalRoomsTomorrow	C						X
BUSINESS DATE	BusinessDate	D		X	X	X	X	X	The properties date that the night audit is being run for.
CANCEL ROOMS ARRIVAL TODAY	CancelRoomsArrivalToday	C					X	X
CHILDREN	Children	C						X
COMPANY ROOMS	CompanyRooms	C						X
COMPLIMENTARY ROOMS	ComplimentaryRooms	C						X
CONFIRMATION NO	ConfirmationNo	C	X
CONFIRMATION LEG NO	ConfirmationLegNo	C	X
DAY USE ROOMS	DayUseRooms	C					X	X
DEPARTURE DATE	DepartureDate	D	X	X
DEPARTURE ROOMS	DepartureRooms	C						X
DEPARTURE ROOMS TOMORROW	DepartureRoomsTomorrow	C						X
EXTRA REVENUE	ExtraRevenue	N		X			X	X
FOOD BEV REVENUE	FoodBevRevenue	N		X			X	X
GROUP REVENUE	GroupRevenue	C						X
GROUP ROOMS	GroupRooms	C						X
HOUSE USE ROOMS	HouseUseRooms	C						X
MARKET CODE	MarketCode	C					X
MEMBERSHIP ID	MembershipID	N	X
MEMBERSHIP NUMBER	MembershipNumber	C	X
MEMBERSHIP TYPE	MembershipType	C	X
NO OF GUESTS	NoOfGuests	C					X
NO SHOW ROOMS	NoShowRooms	C					X	X
OCCUPIED ROOMS	OccupiedRooms	C					X		Number of rooms In-House with a Front Office status of OCC
OUT OF ORDER ROOMS	OutOfOrderRooms	C						X
PHYSICAL ROOMS	PhysicalRooms	C						X
RESERVATION NAME ID	ResvNameId	N	X	X
RESERVATION STATUS	ReservationStatus	C	X
ROOM	Room	C	X
ROOM CLASS	RoomClass	C						X
ROOM REVENUE	RoomRevenue	N		X			X	X
ROOM TYPE	RoomType	C
TOTAL REVENUE	TotalRevenue	N		X			X	X
TURNAWAYS	Turnaways	C						X
WALKIN ROOMS	WalkinRooms	C						X

Module – Owner Contract

Table 16-11 Module – Owner Contract

Data Element	Xml Tag Name	Data Type	Add Auth User	Delete Auth User	Update Auth User	New Owner Contract	Delete Owner Contract	Update Owner Contract	Auto Renew Contract
OWNER ROOM TYPE	OwnerRoomType	C				X	X	X	X
OWNERS USERS ID	OwnersUsersId	N	X	X	X	X	X	X
OWNERS USERS REC STATUS	OwnersUsersRecStatus	C	X	X	X	X	X	X
PARENT ID	ParentId	N				X	X	X
PRIMARY ADDRESS ID	PrimaryAddressId	N				X	X	X
PRIMARY NAME ID	PrimaryNameId	N				X	X	X
PROFILE TYPE	ProfileType	C	X	X	X	X	X	X
PURCHASE PRICE	PurchasePrice	N				X	X	X
REAL ESTATE AGENT	RealEstateAgent	C				X	X	X
RELATION	Relation	C	X	X	X	X	X	X
RENTAL BEGIN DATE	RentalBeginDate	D				X	X	X	X
RENTAL CONTRACT ID	RentalContractId	N				X	X	X	X
RENTAL END DATE	RentalEndDate	D				X	X	X	X
RENTAL PROGRAM YN	RentalProgramYn	C				X	X	X	X
RENTAL REC STATUS	RentalRecStatus	C				X	X	X	X
RES MAX NIGHTS	ResMaxNights	N				X	X	X	X
RESORT	Resort	C	X	X	X	X	X	X	X
RESTRICTION ID	RestrictionId	N				X	X	X
RESTRICTION REC STATUS	RestrictionRecStatus	C				X	X	X
RESTRICTION TYP	RestrictionType	C				X	X	X
REV SHARE FORMULA	RevShareFormula	C				X	X	X	X
REVENUE SHARE	RevenueShare	N				X	X	X
SALES ASSOCIATE	SalesAssociate	C				X	X	X
SPECIAL CHANGES TO UNIT	SpecialChangesToUnit	C				X	X	X
SSN TAX ID	SsnTaxId	C				X	X	X
STATUS	Status	C				X	X	X
TEMPLATE CODE	TemplateCode	C				X	X	X
UDFC01 - UDFC15	Udfc01 - Udfc15	C				X	X	X
UDFD01 - UDFD15	Udfd01 - Udfd15	D				X	X	X
UDFN01 - UDFN15	Udfn01 - Udfn15	N				X	X	X
UNIT	Unit	C				X	X	X	X
UPDATE DATE	UpdateDate	D	X	X	X	X	X	X	X
UPDATE TIME	UpdateTime	T	X	X	X	X	X	X	X
UPDATE USER	UpdateUser	N	X	X	X	X	X	X	X
USED NIGHTS ADJUSTMENT	UsedNightsAdjustment	N				X	X	X

Module – Profile

Table 16-12 Module – Profile

Data Element	Xml Tag Name	Data Type	New History	Delete History	Update History	Update Profile	Delete Profile	Merge Profile	New Profile	Purge Profile	Subscribed Profile	New Relationship	Update Relationship	Delete Relationship	Description
A/R NUMBER	ARNumber	C				X	X	X	X
ACCESS CHANNEL	AccessChannel	C				X	X	X	X
ACCESS CHANNEL CODE	AccessChannelCode	C				X	X	X	X	X
ACCESS CODE	AccessCode	C				X	X	X	X
ACCESS INACTIVE DATE	AccessInactiveDate	D				X	X	X	X
ACCESS RATE CODE	AccessRateCode	C				X	X	X	X
ACCESS UPDATE DATE	AccessUpdateDate	D				X	X	X	X
ACCOUNT SOURCE	AccountSource	C				X	X		X
ACCOUNT TYPE	AccountType	C				X	X		X
ACTION CODE	ActionCode	C				X	X		X
ADDRESS LANGUAGE	AddressLanguage	C				X	X	X	X
ADDRESS PRIMARY YN	AddressPrimaryYN	C				X	X	X	X
ADDRESS TYPE	AddressType	C				X	X	X	X
ADDRESS1	Address1	C				X	X	X	X
ADDRESS2	Address2	C				X	X	X	X
ADDRESS3	Address3	C				X	X	X	X
ADDRESS4	Address4	C				X	X	X	X
ADJUSTMENT AMOUNT	YieldAdjustmentAmount	N				X	X	X	X						Amount used to determine the Rateable Value for comparison against Hurdle Rate when the Profile is defined in the Rate Query Scope. This Adjustment is used in conjunction with any Yield Adjustments configured on the Rate Code. If the same adjustment type is used on both the Rate Code and the Profile, the Heirarchy will use the amount of the Profile. If the same adjustment type is used on several Profiles, the Heirarchy of the amount is as follows: Individual, Company, Travel Agent, Source.
ADJUSTMENT CODE	YieldAdjustmentCode	C				X	X	X	X						Code used to determine the Rateable Value for comparison against Hurdle Rate for the selected Profile. User defined and amount can be changed per Profile when attached to the Profile. The Code cannot be changed.
ADJUSTMENT TYPE	YieldAdjustmentType	C				X	X	X	X						Is the Adjustment AmountPer Night, Per Stay, Per Person/Per Stay, Per Person/Per Night?
ADULTS	Adults	N	X	X	X
ARRIVAL	ArrivalDate	D	X	X	X
ATTACHMENT CHANGED	AttachmentChanged	C				X
AUTO ENROLL MEMBERSHIP OPT IN FLG	AutoEnrollMembershipOptInFlg	C				X		X	X
AUTO ENROLL MEMBERSHIP YN	AutoenrollMemberYN	C				X		X	X
BARCODE	Barcode	C				X	X	X	X
BIRTH COUNTRY	BirthCountry	C				X		X	X
BIRTH DATE	BirthDate	D				X	X	X	X
BIRTH PLACE	BirthPlace	C				X		X	X
BL MSG	CreditRestrictionComments	C				X	X	X	X
BUSINESS TITLE	BusinessTitle	C				X	X	X	X
CANCELLATION DATE	CancellationDate	D	X	X	X
CANCELLATION NO	CancellationNo	C	X	X	X
CANCELLED BY	CancelledBy	C	X	X	X
CASH BL IND	CreditRestrictionIndicator	C				X	X	X	X
CENTRAL AR NUMBER	CentralArNumber	C				X	X	X	X
CHAIN CODE	ChainCode	C				X	X	X	X						When subscribed to, for example properties in ASP Mode, and a change has been made to any of the data elements for that business event, the Chain Code will be included, allowing external systems to filter business events for specific chains. This will not affect updates coming into OPERA Cloud from external systems.
CHILDREN	Children	N	X	X	X
CITY	City	C				X	X	X	X
COMMENTS	Comments	C				X	X	X	X
COMMISSION CODE	CommissionCode	C				X	X	X	X
COMMISSION CURRENCY	CommissionCurrency	C				X	X	X	X
COMPANY NAME	CompanyName	C	X	X	X
COMPANY NAME ID	CompanyNameId	N	X	X	X
COMPANY NUMBER	CompanyNumber	C				X	X	X	X
COMPANY TYPE	CompanyType	C				X	X	X	X
COMPETITION CODE	CompetitionCode	C				X	X		X
CONFIRMATION NO	ConfirmationNo	C	X	X	X
COUNTRY	Country	C				X	X	X	X
CREDIT CARD EXPIRATION DATE	CreditCardExpDate	D				X	X	X	X
CREDIT CARD NUMBER	CreditCardNumber	C	X	X	X	X	X	X	X
CREDIT CARD NUMBER 4 DIGITS	CreditCardNumber4Digits	C	X	X	X	X	X	X	X
CREDIT CARD TYPE	CreditCardType	C	X	X	X	X	X	X	X
CREDIT CARD VAULT ID	CreditCardVaultId	C	X	X	X	X	X	X	X
CREDIT RATING	CreditRating	C				X		X	X
CRS NUMBER	CRSNumber	C	X	X	X
DATABASE ID	DatabaseID	C				X	X	X	X		X
DEPARTMENT NOTE SHORT	DepartmentNoteShort	C			X	X	X	X	X
DEPARTURE	DepartureDate	D	X	X	X
EMAIL	Email	C				X	X	X	X
EMAIL LANGUAGE	EmailLanguage	C				X	X		X
EMAIL OPT IN FLG	EmailOptInFlg	C				X		X	X
EMAIL YN	EmailYN	C				X		X	X
EXTRA REVENUE	ExtraRevenue	N	X	X	X
FAX NUMBER	FaxNumber	C				X	X	X	X
FB REVENUE	FBRevenue	N	X	X	X
FIRST NAME	FirstName	C				X	X	X	X
FROM NAME	FromName	C										X	X	X	Only triggered for Global Relationships
FROM NAME ID	FromNameId	N										X	X	X	Only triggered for Global Relationships
FROM RELATION	FromRelation	C										X	X	X	Only triggered for Global Relationships
GENDER	Gender	C				X		X	X
GROUP NAME	GroupName	C	X	X	X
GROUP NAME ID	GroupNameId	N	X	X	X
GUEST NAME	GuestName	C	X	X	X
GUEST NAME ID	GuestNameId	N	X	X	X
GUEST PRIVACY OPT IN FLG	GuestPrivacyOptInFlg	X				X		X	X
GUEST PRIVACY YN	GuestPrivYN	C				X		X	X
IATA NUMBER	IATANumber	C				X	X	X	X
IATA TYPE	IATAType	C				X	X	X	X
ID COUNTRY	IdCountry	C				X	X	X	X
ID NUMBER	IdNumber	C				X	X		X
ID TYPE	IdType	C				X	X		X
INCOGNITO FIRST	IncognitoFirst	C				X	X	X	X						Field displays based on activation of the Application Setting- >Function INCOGNITO.
INCOGNITO NAME	IncognitoName	C				X	X	X	X						Field displays based on activation of the Application Setting- >Function INCOGNITO.
INFLUENCE	Influence	C				X	X		X
INDUSTRY CODE	IndustryCode	C				X	X		X
LANGUAGE	Language	C				X	X	X	X
MAILING LIST OPT IN FLG	MailingListOptInFlg	C				X		X	X
MAILING LIST YN	MailList	C				X		X	X
MARKET CODE	MarketCode	C	X	X	X
MARKET RESEARCH OPT IN FLG	MarketResearchOptInFlg	C				X		X	X
MARKET RESEARCH YN	MarketResearchYN	C				X		X	X
MARKETS	Markets	C				X		X	X
MEMBERSHIP ENROLLED AT	MembershipEnrolledAt	C				X			X
MEMBERSHIP ENROLLMENT SOURCE	MembershipEnrollmentSource	C				X			X
MEMBERSHIP EXPIRATION DATE	MembershipExpDate	D				X	X	X	X
MEMBERSHIP LEVEL	MembershipLevel	C				X	X	X	X
MEMBERSHIP NAME ON CARD	MembershipNameOnCard	C				X									When subscribed, changing the Member Name on any type of Membership will fire the business event and send Update Profile messages to OXI and OXIHUB. The Membership Name will then be updated in ORS/OCIS with the exception of Memberships marked as primary. These primary Memberships will not be updated.
MEMBERSHIP NUMBER	MembershipNumber	C				X	X	X	X
MEMBERSHIP PREFERRED CARD	MembershipPreferredCard	C				X
MEMBERSHIP TYPE	MembershipType	C				X	X	X	X
MIDDLE	Middle	C				X	X	X	X
NAME	Name	C				X	X	X	X	X
NAME ID	NameId	N				X	X	X	X	X
NAME TYPE	NameType	C				X	X	X	X
NATIONALITY	Nationality	C				X	X	X	X
NEG BEGIN SELL	NegRateBeginDate	C				X
NEG COMMISSION CODE	NegCommissionCode	C				X
NEG END SELL	NegRateEndDate	C				X
NOTIFICATION	Notification	C				X	X		X						When a Profile Notification is resolved, the status of the notification description is updated from "UN RESOLVED" to "RESOLVED ON" and is triggered with the Update Profile Action Type. But when a Profile Notification is unresolved, the status of the notification description is updated from "RESOLVED ON" to "UN RESOLVED".
PAGER	Pager	C				X	X	X	X
PASSPORT NUMBER	PassportNumber	C				X	X	X	X
PAYMENT	Payment	N	X	X	X
PAYMENT METHOD	PaymentMethod	C	X	X	X
PCC CHANNEL	PccChannel	C				X	X	X	X
PCC CODE	PccCode	C				X	X	X	X
PCC INACTIVE DATE	PccInactiveDate	D				X	X	X	X
PHONE NUMBER	PhoneNumber	C				X	X	X	X
PHONE OPT IN FLG	PhoneOptInFlg	C				X		X	X
PHONE PRIMARY YN	PhonePrimaryYN	C				X	X	X	X
PHONE TYPE	PhoneType	C				X	X	X	X
PHONE YN	PhoneYn	C				X		X	X
POSTAL CODE	PostalCode	C				X	X	X	X
PREFERENCE GROUP	PreferenceGroup	C				X	X		X
PREFERENCE TYPE	PreferenceType	C				X	X	X	X
PREFERENCE TYPE DESCRIPTION	PreferenceTypeDescription	C				X	X		X
PRIMARY YN	PrimaryYn	C										X	X	X	Only triggered for Global Relationships
PRIORITY	C					X	X		X
RATE AMOUNT	RateAmount	N	X	X	X
RATE CODE	RateCode	C	X	X	X	X	X	X	X
RESERVATION DATE	ReservationDate	D	X	X	X
RESERVATION STATUS	ReservationStatus	C	X	X	X
RESV NAME ID	ResvNameId	N		X	X
ROOM REVENUE	RoomRevenue	N	X	X	X
ROOMS POTENTIAL	RoomsPotential	C				X	X		X
SALES MANAGER	SalesManager	C				X	X	X	X
SCOPE	Scope	C				X	X		X
SCOPE CITY	ScopeCity	C				X	X		X
SMS OPT IN FLG	SmsOptInFlg	C				X		X	X
SMS YN	SmsYn	C				X		X	X
SOURCE	Source	C	X	X	X										For Account Profiles (Company, Travel Agent, and Source, the Source of business. This is not the same as Source Codes configured for Reservations. The field is on the Sales Info screen and the List of Values are configured under System Configuration->Profiles->Sales Information->Sources
SOURCE NAME	SourceName	C	X	X	X
SOURCE NAME ID	SourceNameId	N	X	X	X
STATE	State	C				X	X	X	X
STATUS	Status	C				X	X	X	X
TAX NUMBER1	Tax1No	C				X		X	X
TAX NUMBER2	Tax2No	C				X		X	X
THIRD PARTY OPT IN FLG	ThirdPartyOptInFlg	C				X		X	X
THIRD PARTY YN	ThirdPartyYN	C				X		X	X
TITLE	Title	C				X	X	X	X
TO NAME	ToName	C										X	X	X	Only triggered for Global Relationships
TO NAME ID	ToNameId	N										X	X	X	Only triggered for Global Relationships
TO RELATION	ToRelation	C										X	X	X	Only triggered for Global Relationships
TRAVEL AGENT NAME	TravelAgentName	C	X	X	X
TRAVEL AGENT NAME ID	TravelAgentNameId	N	X	X	X
UDF CHAR 01 – UDF CHAR 40	UdfChar01 – UdfChar40	C				X	X	X	X
UDF DATE 01 – UDF DATE 20	UdfDate01 – UdfDate20	D				X	X	X	X
UDF NUMBER 01 – UDF NUMBER 40	UdfNumber01 – Udf Number40	N				X	X	X	X
VIP STATUS	VIPStatus	C				X	X	X	X
VIRTUAL NUMBER	VirtualNumber	N				X	X	X	X
WEB ACCOUNT LOCKED	WebAccountLocked	D				X
WEB COMMENTS	WebComments	C				X
WEB LOGIN NAME	WebLoginName	C				X
WEB PASSWORD	WebPassword	C				X
WEB SECRET ANSWER	WebSecretAnswer	C				X
WEB SECRET QUESTION	WebSecretQuestion	C				X
WEBPAGE	Webpage	C				X	X	X	X
XFIRST NAME	XFirstName	C				X	X	X	X
XNAME	XName	C				X	X	X	X
XSALUTATION	XSalutation	C				X	X	X	X
XTITLE	XTitle	C				X	X	X	X

Module – Stay Records

Table 16-13 Module – Stay Records

Data Element	Xml Tag Name	Data Type	Insert Stay Records	Insert Stay Records Projections	Update Stay Records	Update Stay Records Projections
COMPANY_NAME_ID	Company_Name_Id	N	X	X	X	X
GROUP_NAME_ID	Group_Name_Id	N	X	X	X	X
GUEST_NAME_ID	Guest_Name_Id	N	X	X	X	X
MISC_NAME_ID	Misc_Name_Id	N	X	X	X	X
TRAVEL_NAME_ID	Travel_Name_Id	N	X	X	X	X
WHOLESALER_NAME_ID	Wholesaler_Name_Id	N	X	X	X	X