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.
Property. Enter or select the property
External System. Select the external system from the list. See Configuring External Systems
Module. Select the module from the list
Business Event. Select the business event from the list
Search and select data elements in the Available panel, click > or >> to move selection to the Selected panel.
Conditions (where clause)
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.
Click OK.
Repeat to add another condition.
To Edit, select a condition and click Edit.
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.
Parent topic: Interfaces Administration
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 | Description |
---|---|---|---|---|---|---|---|---|---|
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 |
Parent topic: Configuring Business Events
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. |
Parent topic: Configuring Business Events
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 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, 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 |
|||||||||||||||
Parent topic: Configuring Business Events
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 | Description |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
Parent topic: Configuring Business Events
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 |
Parent topic: Configuring Business Events
Table 16-6 Module – Catering
Data Element | Xml Tag Name | Data Type | New Posting | Update Posting | Delete Posting | Description |
---|---|---|---|---|---|---|
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 |
Parent topic: Configuring Business Events
Table 16-7 Module – E-Certificate
Data Element | Xml Tag Name | Data Type | New E-Certificate | Update E-Certificate | New In Lieu E-Certificate | Description |
---|---|---|---|---|---|---|
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 |
Parent topic: Configuring Business Events
Table 16-8 Module – Enrollment
Data Element | Xml Tag Name | Data Type | New Enrollment | Update Enrollment | Description |
---|---|---|---|---|---|
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 |
Parent topic: Configuring Business Events
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 |
Parent topic: Configuring Business Events
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 |
||||||
Parent topic: Configuring Business Events
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 | Description |
---|---|---|---|---|---|---|---|---|---|---|
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 |
Parent topic: Configuring Business Events
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 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 |
||||||||||
|
|
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 |
Parent topic: Configuring Business Events
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 | Description |
---|---|---|---|---|---|---|---|
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 |
Parent topic: Configuring Business Events