1. User Guide
  2. Administration
  3. Interfaces Administration
  4. Configuring Business Events
  5. Module – Rate

Module – Rate

Table 16-14 Module – Rate

Data Elementf Xml Tag Name Data Type New Product Update Product Delete Product New Rate Strategy Update Rate Strategy Delete Rate Strategy New Rule Update Rule Delete Rule New Rate Category Update Rate Category Delete Rate Category New Rate Class Update Rate Class Delete Rate Class New Rate Header Update Rate Header Delete Rate Header New Rate Set Update Rate Set Delete Rate Set New Season Code Update Season Code Delete Season Code New Rate Set Adjustment Update Rate Set Adjustment Delete Rate Set Adjustment New Hurdle Update Hurdle Delete Hurdle Rate Restrictions Clear Restrictions Rate Tier New Yield Market Delete Yield Market Update Yield Market Apply Daily Rates Delete Daily Rates New Best Available Rates Delete Best Available Rates Apply Prevailing Rates Restrictions Per Day Description

1 PERSON RATE

OnePersonRate

N

X

X

X

2 PERSON RATE

TwoPersonRate

N

X

X

X

3 PERSON RATE

ThreePersonRate

N

X

X

X

4 PERSON RATE

FourPersonRate

N

X

X

X

5 PERSON RATE

FivePersonRate

N

X

X

X

ACTIVE RATE SET

ActiveRateSet

C

X

X

ADD TO RATE YN

AddToRateYn

C

X

X

Is the package added to the rate?

ADDITION

Addition

C

X

X

X

ADJUSTMENT AMOUNT

YieldAdjustmentAmount

N

X

X

X

Amount used for comparison against Hurdle Rate for the selected Profile.

ADJUSTMENT CODE

YieldAdjustmentCode

C

X

X

X

Code used for comparison against Hurdle Rate for the selected Profile.

ADJUSTMENT TYPE

YieldAdjustmentType

C

X

X

X

Type used for comparison against Hurdle Rate for the selected Profile.

ADULTS THRESHOLD

Adultsthreshold

N

X

X

X

X

X

ADULTS THRESHOLD CHARGE

Adultsthresholdcharge

N

X

X

X

X

X

ADV BASE AMOUNT

BaseAmount

N

X

X

ADV BASE FLT PCT

AdvBaseFltPct

C

X

X

ADVANCE BOOKING DAYS

AdvBookingDays

N

X

X

X

ALLOWANCE

Allowance

C

X

X

ALLOWANCE AMOUNT

AllowanceAmount

N

X

X

X

X

ALTERNATIVE

Alternative

C

X

X

X

ALTERNATIVE TRANSACTION CODE

AlternativeTransCode

C

X

X

APP USER

AppUser

C

X

X

X

X

X

X

X

X

X

XX X

X

X

APPLY YN

ApplyYn

C

X

X

X

ARRIVAL

Arrival

C

X

ASB RATE CYCLE

ASBRateCycle

C

X

X

X

BAR AMOUNT

BarAmount

N

X

X

X

BAR FLT PCT

BarFltPct

C

X

X

X

BAR ROUNDING

BarRounding

C

X

X

X

BAR YN

BarYn

C

X

X

X

X

X

X

BEGIN DATE

BeginDate

D

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

Beginning Date

BEGIN SELL

RateHeaderBeginSell

D

X

X

X

Beginning Date that the rate code can be booked.

BEGIN SELL DATE

BeginSellDate

D

X

X

BLOCK CODE

BlockCode

C

X

X

X

BOOK MAX ADV

BookMaxAdv

N

X

BOOK MIN ADV

BookMinAdv

N

X

BUCKET2 PRICE

Bucket2Price

N

X

X

BUCKET2 ALLOWANCE AMOUNT

Bucket2AllowanceAmount

N

BUCKET3 PRICE

Bucket3Price

N

X

X

BUCKET3 ALLOWANCE AMOUNT

Bucket3AllowanceAmount

N

X

X

CALCULATION RULE

CalculationRule

C

X

X

Is the Package to be charged as a Flat Rate, Per Room, Per Person, Per Adult or Per Child

CEILING

Ceiling

N

X

X

X

CHANNEL

Channel

C

X

CHILD CHARGE 1

ChildCharge1

N

X

X

X

X

X

CHILD CHARGE 2

ChildCharge2

N

X

X

X

X

X

CHILD CHARGE 3

ChildCharge3

N

X

X

X

X

X

CHILD RATE

ChildRate

N

X

X

X

CHILD RATE 1

ChildRate1

N

X

X

CHILD RATE 2

ChildRate2

N

X

X

CHILD RATE 3

ChildRate3

N

X

X

CHILD RATE EXC THRESHOLD 1

ChildExcThreshold1

N

X

X

CHILD RATE EXC THRESHOLD 2

ChildExcThreshold2

N

X

X

CHILD RATE EXC THRESHOLD 3

ChildExcThreshold3

N

X

X

CHILD OWN RATE 1

ChildOwnRate1

N

X

X

CHILD OWN RATE 2

ChildOwnRate2

N

X

X

CHILD OWN RATE 3

ChildOwnRate3

N

X

X

CHILD OWN RATE 4

ChildOwnRate4

N

X

X

CHILDREN THRESHOLD

Childrenthreshold

N

X

X

X

X

X

CHILDREN THRESHOLD CHARGE

Childrenthresholdcharge

N

X

X

X

X

X

CLOSED TO ARRIVAL

ClosedToArrival

C

X

X

X

CLEAR ALL RESTRICTIONS

ClearAllRestrictions

C

X

X

CNL BEFORE TIME

CnlBeforeTime

T

X

X

X

CNL PENALTY AMOUNT

CnlPenaltyAmount

N

X

X

X

CNL PENALTY AMOUNT TYPE

CnlPenaltyAmountType

C

X

X

X

CNL PRIOR TO ARRIVAL

CnlDaysPriorToArrival

N

X

X

X

CODE

Code

C

X

X

X

COMBINED LINE

CombinedLine

C

X

X

COMMISSION CODE

CommissionCode

C

X

X

X

COMPLIMENTARY

Complimentary

C

X

X

X

CONDITION TYPE

ConditionType

C

X

X

X

CONDITION VALUE

ConditionValue

N

X

X

X

CONDITION VALUE TYPE

ConditionValueType

C

X

X

X

CONTROL END DATE

ControlEndDate

D

X

X

X

CONTROL START DATE

ControlStartDate

D

X

X

X

COUNTER COND YN

CounterCondYn

C

X

X

X

CURRENCY CODE

CurrencyCode

C

X

X

X

X

X

DAILY RATE YN

DailyRateYN

C

X

X

X

DAY 1

Day1

C

X

X

X

X

X

Values are Y or N. Indicates the Day of the Week the Rate Detail is applicable.

DAY 2

Day2

C

X

X

X

X

X

Values are Y or N. Indicates the Day of the Week the Rate Detail is applicable.

Parent topic: Configuring Business Events

Module – Rate

Table 16-15 Module – Rate

Data Element Xml Tag Name Data Type New Product Update Product Delete Product New Rate Strategy Update Rate Strategy Delete Rate Strategy New Rule Update Rule Delete Rule New Rate Category Update Rate Category Delete Rate Category New Rate Class Update Rate Class Delete Rate Class New Rate Header Update Rate Header Delete Rate Header New Rate Set Update Rate Set Delete Rate Set New Season Code Update Season Code Delete Season Code New Rate Set Adjustment Update Rate Set Adjustment Delete Rate Set Adjustment New Hurdle Update Hurdle Delete Hurdle Rate Restrictions Clear Restrictions Rate Tier New Yield Market Delete Yield Market Update Yield Market Apply Daily Rates Delete Daily Rates New Best Available Rates Delete Best Available Rates Apply Prevailing Rates Restrictions Per Day Description

DAY 4

Day4

C

X

X

X

X

X

Values are Y or N. Indicates the Day of the Week the Rate Detail is applicable.

DAY 6

Day6

C

X

X

X

X

X

Values are Y or N. Indicates the Day of the Week the Rate Detail is applicable.

DAY 7

Day7

C

X

X

X

X

X

Values are Y or N. Indicates the Day of the Week the Rate Detail is applicable.

DAY 5

Day5

C

X

X

X

X

X

Values are Y or N. Indicates the Day of the Week the Rate Detail is applicable.

DAY 3

Day3

C

X

X

X

X

X

Values are Y or N. Indicates the Day of the Week the Rate Detail is applicable.

DAY FIVE

DayFive

C

X

X

X

DAY FOUR

DayFour

C

X

X

X

DAY OF WEEK

DayOfWeek

C

X

DAY ONE

DayOne

C

X

X

X

DAY SEVEN

DaySeven

C

X

X

X

DAY SIX

DaySix

C

X

X

X

DAY THREE

DayThree

C

X

X

X

DAY TWO

DayTwo

C

X

X

X

DAY TYPE

DayType

C

X

X

X

DAY USE

DayUse

C

X

X

X

DAYS

Days

C

X

X

DAYS IN ADVANCE FROM

DaysInAdvanceFrom

N

X

X

X

DAYS IN ADVANCE TO

DaysInAdvanceTo

N

X

X

X

DELTA

Delta

N

X

X

X

DEP AMOUNT

DepAmount

N

X

X

DEP AMOUNT TYPE

DepAmountType

C

X

X

DEP DAYS AFTER BOOKING

DepDaysAfterBooking

N

X

X

DEP DAYS PRIOR TO ARRIVAL

DepDaysPriorToArrival

N

X

X

DEPARTURE

Departure

C

X

DEPT TAX INCL YN

DeptTaxInclYN

C

X

X

DESCRIPTION

Description

C

X

X

X

X

X

X

X

X

X

X

X

X

X

DISCOUNT RATE AMOUNT

DiscountRateAmount

N

X

X

X

DISCOUNT RATE PERCENTAGE YN

DiscountRatePercentageYN

C

X

X

X

DISCOUNT YN

DiscountYN

C

X

X

END DATE

EndDate

D

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

END SELL

RateHeaderEndSell

D

X

X

X

END SELL DATE

EndSellDate

D

X

X

EXCHANGE POSTING TYPE

ExchangePostingType

C

X

X

X

EXTERNAL REFERENCE

ExternalReference

C

X

X

X

EXTRA ADULT RATE

ExtraAdultRate

N

X

X

X

X

EXTRA CHILD RATE

ExtraChildRate

N

X

FORECAST CODE

PKGForecastCode

C

X

X

FORECAST NEXT DAY YN

ForecastNextDayYN

C

X

X

FORMULA

Formula

C

X

X

X

X

X

FROM DATE

FromDate

D

X

X

GDS ON REQUEST

GdsOnRequest

C

X

X

GENERATED BY RATE STRATEGY

GeneratedByRateStrategy

C

X

GROUP PACKAGE LIST

GroupPackageList

C

X

X

HOUSE USE

HouseUse

C

X

X

X

HURDLE

HurdleRate

N

X

X

X

HURDLE DATE

HurdleDate

D

X

X

X

HURDLE LOS

HurdleLos

N

X

X

X

INACTIVE DATE

InactiveDate

D

X

X

X

INCLUDED IN RATE

IncludedInRate

C

X

X

ITEM ID

ItemID

N

X

ITEM PRICE

ItemPrice

N

X

X

X

X

KEEP INVENTORY

KeepInventory

C

X

X

LENGTH OF STAY NA

LengthOfStayNA

C

X

Element value will be either O or C, seperated by commas, with a maximum length of 7 characters. Example: C,O,O,C,C,O,C

LONG INFO

LongInfo

C

X

X

Field in application can be up to 4000 characters. OPERA Cloud will only send the first 200 characters in the

LOS

Los

C

X

X

MANUALY DISTRIBUTE

ManuallyDistribute

C

X

MARKET CODE

MarketCode

C

X

X

X

X

X

X

MAX LOS

MaxLos

N

X

X

X

X

MAX NIGHTS

MaxNights

N

X

X

MAX PERSONS

MaxPersons

N

X

X

MAX STAY THROUGH

MaxStayThrough

N

X

MAXSOLDS

MaxSolds

N

X

X

X

MEMBERSHIP

Membership

C

X

X

X

MIN CHILDREN FOR FREE STAY

MinChildrenForFreeStay

N

X

X

X

MIN LOS

MinLos

N

X

X

X

X

MIN NIGHTS

MinNights

N

X

X

MIN PERSONS

MinPersons

N

X

X

MIN STAY THROUGH

MinStayThrough

N

X

MYFIDELIO UPLOAD

MyfidelioUpdate

C

X

X

X

NEGOTIATED

Negotiated

C

X

X

X

NUM CHILDREN STAY FREE

NumChildrenStayFree

N

X

X

X

NUMBER OF TIERS

NumberOfTiers

N

X

The number of configured Tiers for the Property. Value can be 2, 3, 4 or 5.

OCCUPANTS THRESHOLD

Occupantsthreshold

N

X

X

X

X

X

OCCUPANTS THRESHOLD CHARGE

Occupantsthresholdcharge

N

X

X

X

X

X

Parent topic: Module – Rate

Module – Rate

Table 16-16 Module – Rate

Data Element Xml Tag Name Data Type New Product Update Product Delete Product New Rate Strategy Update Rate Strategy Delete Rate Strategy New Rule Update Rule Delete Rule New Rate Category Update Rate Category Delete Rate Category New Rate Class Update Rate Class Delete Rate Class New Rate Header Update Rate Header Delete Rate Header New Rate Set Update Rate Set Delete Rate Set New Season Code Update Season Code Delete Season Code New Rate Set Adjustment Update Rate Set Adjustment Delete Rate Set Adjustment New Hurdle Update Hurdle Delete Hurdle Rate Restrictions Clear Restrictions Rate Tier New Yield Market Delete Yield Market Update Yield Market Apply Daily Rates Delete Daily Rates New Best Available Rates Delete Best Available Rates Apply Prevailing Rstes Restrictions Per Day Description

OVERAGE TAX INCL YN

OverageTaxInclYN

C

X

X

OVERRIDE

Override

C

X

X

X

PACKAGE BEGIN DATE

PackageBeginDate

D

X

PACKAGE CODE

PackageCode

C

X

X

X

PACKAGE END DATE

PackageEndDate

D

X

PACKAGE TRANSACTION CODE

PackageTransactionCode

C

X

X

X

PACKAGE TYPE

PackageType

C

X

X

X

Is this package part of a group or single? Element or Group.

PER DAY YN

PerDayYn

C

X

PERSON RATE 1

PersonRate1

N

X

PERSON RATE 2

PersonRate2

N

X

PHYSICAL

Physical

N

X

X

X

PKG FORECAST GROUP

PkgForecastGroup

C

X

X

PKG TRAN CODE TAX INCL

PkgTranCodeTaxIncl

C

X

X

X

PKG VALID END TIME

PKGValidEndTime

T

X

X

PKG VALID START TIME

PKGValidStartTime

T

X

X

POST NEXT DAY

PostNextDay

C

X

X

Is this package posting the next day?

POSTING RHYTHM

PostingRhythm

C

X

X

X

X

X

When does this package get posted? (examples: Every night, Only on arrival, Only on departure, etc..)

POSTING RHYTHM BEGIN DATE

PostingRhythmBeginDate

N

X

X

X

POSTING RHYTHM CODE

PostingRhythmCode

C

X

X

X

POSTING RHYTHM DESCRIPTION

PostingRhythmDescription

C

X

X

X

POSTING RHYTHM END DATE

PostingRhythmEndDate

N

X

X

X

POSTING RHYTHM NIGHTS

PostingRhythmNights

N

X

X

X

POSTING RHYTHM PAID NIGHTS

PostingRhythmPaidNights

N

X

X

X

POSTING RHYTHM REPEAT WITHIN SELL SEGMENT

PostingRhythmRepeatWithi nSellSegment

C

X

X

X

POSTING RHYTHM REPEAT WITHIN STAY FOR MULTI-SEGMENT

PostingRhythmRepeatWithi nStayForMultiSegment

C

X

X

X

PRINT RATE

PrintRate

C

X

X

X

Should the rate be printed on the guest folio?

PRODUCT CODE

ProductCode

C

X

X

X

X

X

Package Code

PRODUCT QTY

ProductQty

C

X

X

Quantity of Packages

QTY PLUS PACKAGE CODE

QtyPlusPackageCode

C

X

X

X

Quantity of Package and Package Code.

QUANTITY

ItemQuantity

N

X

RATE BUCKET

RateBucket

C

X

X

X

Groupings of Rate Codes for Revenue Management Systems. Only displayed if a Revenue Management license code is active.

RATE CATEGORY

RateCategory

C

X

X

X

X

X

X

X

X

X

X

Rate Category - Heirarchy is Rate Class, Rate Category and Rate Code

RATE CLASS

RateClass

C

X

X

X

X

X

X

X

X

X

X

X

X

X

Rate Class - - Heirarchy is Rate Class, Rate Category and Rate Code

RATE CODE

RateCode

C

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

RATE FLOOR

RateFloor

N

X

X

RATE FORMULA CHANGED YN

RateFormulaChangedYn

C

X

REPEAT

Repeat

C

X

X

X

When the RATES->RATE CODE POSTING RHYTHM

application parameter is active, a new checkbox is available on the More Tab of the Rate Setup (RTSETUP) screen for Repeat. When configuring a new Posting Rhythm, once the Nights field is populated the Repeat checkbox will be enabled and selected by default.

When selected, Posting Rhythm functionality will work as it does today. When unchecked, the rate will not post (or post a discounted amount based on the type of Posting Rhythm) only on the night defined.

RESERVATION TYPE

ReservationType

C

X

X

X

RESORT

Resort

C

X

RESTRICTION DATE

RestrictionDate

D

X

RESTRICTION END DATE

RestrictionEndDate

D

X

X

X

RESTRICTION START DATE

RestrictionStartDate

D

X

X

X

RESTRICTION TYPE

RestrictionType

C

X

X

X

RESTRICTION VALUE

RestrictionValue

N

X

X

X

ROOM CLASS

RoomClass

C

X

X

X

X

Room Class - Heirarchy is Room Class, Room Type. Room Class is activated by the parameter ROOM CLASS.

ROOM TYPE

RoomType

C

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

X

ROOM TYPES

RoomTypes

C

X

X

RULE BEGIN DATE

RuleBeginDate

D

X

X

X

RULE CODE

RuleCode

C

X

X

X

RULE END DATE

RuleEndDate

D

X

X

X

RULE TYPE

RuleType

C

X

X

X

SEASON CODE

RuleSeasonCode

C

X

X

X

SEASON CODE

SeasonCode

C

X

X

X

X

X

X

X

X

SELL SEPARATE

SellSeparate

C

X

X

SEPARATE LINE

SeparateLine

C

X

X

SEQUENCE

Sequence

N

X

X

X

SET ON

SetOn

C

X

SHORT DESCRIPTION

PKGShortDesc

C

X

X

SHORT TEXT

ShortText

C

X

X

SOURCE CODE

SourceCode

C

X

X

X

X

X

X

STAY

Stay

C

X

Parent topic: Module – Rate

Module – Rate

Table 16-17 Module – Rate

Data Element Xml Tag Name Data Type New Product Update Product Delete Product New Rate Strategy Update Rate Strategy Delete Rate Strategy New Rule Update Rule Delete Rule New Rate Category Update Rate Category Delete Rate Category New Rate Class Update Rate Class Delete Rate Class New Rate Header Update Rate Header Delete Rate Header New Rate Set Update Rate Set Delete Rate Set New Season Code Update Season Code Delete Season Code New Rate Set Adjustment Update Rate Set Adjustment Delete Rate Set Adjustment New Hurdle Update Hurdle Delete Hurdle Rate Restrictions Clear Restrictions Rate Tier New Yield Market Delete Yield Market Update Yield Market Apply Daily Rates Delete Daily Rates New Best Available Rates Delete Best Available Rates Apply Prevailing Rstes Restrictions Per Day Description

SUPPRESS RATE

SuppressRate

C

X

X

X

The Rate Amount is not displayed in the Sell Process or on the Reservation, Confirmation Letter or Folio - user will see 'SR' instead of the Amount.

TIER

Tier

C

X

X

X

Values for element Tier will be first day - end

day. Example: Tier 1 is configured as 1 –5 days. The element for Tier 1 would contain value of ‘1-5’. If a Rate Set is updated that is not Tiered, the element of 'Tier' in New Rate Set, Update Rate Set and Delete Rate Set will by <NULL>.

TIER 1

Tier1

N

X

Values sent will be number,number. I.e if Tier One was configured as 1 - 7 Days. The value in the element for Tier1 will be '1,7'

TIER 2

Tier2

N

X

Values sent will be number,number. I.e if Tier Two was configured as 1 - 7 Days. The value in the element for Tier2 will be '1,7'

TIER 3

Tier3

N

X

Values sent will be number,number. I.e if Tier Three was configured as 1 - 7 Days. The value in the element for Tier3 will be '1,7'

TIER 4

Tier4

N

X

Values sent will be number,number. I.e if Tier Four was configured as 1 - 7 Days. The value in the element for Tier4 will be '1,7'

TIER 5

Tier5

N

X

Values sent will be number,number. I.e if Tier Five was configured as 1 - 7 Days. The value in the element for Tier5 will be '1,7'

TIERED RATE

TieredRate

C

X

X

X

All rate codes will have the tiered flag set to either N or Y based on if the Tiered Rate check box is selected on the Rate Header tab.

TO DATE

Todate

D

X

X

TRAN CODE TAX INCL

TranCodeTaxIncl

C

X

X

X

TRANSACTION CODE

TransactionCode

C

X

X

X

X

X

TRANSACTION CODE FOR LOSS

TransCodeForLoss

C

X

X

TRANSACTION CODE FOR OVERAGE

TransCodeForOverage

C

X

X

TRANSACTION CODE FOR PROFIT

TransCodeForProfit

C

X

X

UPSOLDS

Upsolds

N

X

X

X

WEEKEND DAYS

WeekendDays

C

X

X

X

No longer used - the fields are not available on the Rate Header

YIELD CATEGORY

YieldCategory

C

X

X

X

Room Types in OPERA Cloud are assigned to Yield Catergories determined by the Revenue Management Companies. When a room type is 'Yieldable', a Yield Category must also be assigned in order for the Hurdle Rate to be compared.

YIELD MARKET

YieldMarket

C

X

X

YIELD MARKET TYPE

YieldMarketType

C

X

X

X

YIELD STATUS

YieldStatus

C

X

X

X

When a Yield License is active, Rate Codes can be assigned a Yield Status of Yieldable, Non-Yieldable or Stay Pattern Yieldable. If a Rate Code is Non-Yieldable, it is not compared to the Hurdle Rate for booking.

Parent topic: Module – Rate