Business Events - Rate

The following table outlines the action types, data elements, data types and XML tag names within this OPERA Cloud Business Events module. 

Action Type Data Element Data Type XML Tag Description

APPLY DAILY RATES

ADULTS THRESHOLD

N

Adultsthreshold

  

ADULTS THRESHOLD CHARGE

N

Adultsthresholdcharge

  

ADV DAILY BASE RATE CODE

C

AdvDailyBaseRateCode

  

APP USER

C

AppUser

  

BEGIN DATE

D

BeginDate

Beginning Date

CHILD CHARGE 1

N

Childcharge1

  

CHILD CHARGE 2

N

Childcharge2

  

CHILD CHARGE 3

N

Childcharge3

  

CHILD RATE EXC THRESHOLD 1

C

ChildRateExcThreshold1

  

CHILD RATE EXC THRESHOLD 2

C

ChildRateExcThreshold2

  

CHILD RATE EXC THRESHOLD 3

C

ChildRateExcThreshold3

  

CHILDREN THRESHOLD

N

Childrenthreshold

  

CHILDREN THRESHOLD CHARGE

N

Childrenthresholdcharge

  

DAY 1

C

Day1

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

DAY 2

C

Day2

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

DAY 3

C

Day3

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

DAY 4

C

Day4

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

DAY 5

C

Day5

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

DAY 6

C

Day6

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

DAY 7

C

Day7

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

END DATE

D

EndDate

  

EXTRA ADULT RATE

N

ExtraAdultRate

  

EXTRA CHILD RATE

N

ExtraChildRate

  

OCCUPANTS THRESHOLD

N

Occupantsthreshold

  

OCCUPANTS THRESHOLD CHARGE

N

Occupantsthresholdcharge

  

PERSON RATE 1

N

PersonRate1

  

PERSON RATE 2

N

PersonRate2

  

ROOM TYPES

C

RoomTypes

  

APPLY PREVAILING RATES

RESORT

C

Resort

  

CLEAR RESTRICTIONS

CLEAR ALL RESTRICTIONS

C

ClearAllRestrictions

  

DAY OF WEEK

C

DayOfWeek

  

DELETE BEST AVAILABLE RATES

DAYS

C

Days

  

FROM DATE

D

FromDate

  

LOS

C

Los

  

RATE CODE

C

RateCode

  

TO DATE

D

ToDate

  

DELETE DAILY RATES

ADULTS THRESHOLD

N

Adultsthreshold

  

ADULTS THRESHOLD CHARGE

N

Adultsthresholdcharge

  

ADV DAILY BASE RATE CODE

C

AdvDailyBaseRateCode

  

APP USER

C

AppUser

  

BEGIN DATE

D

BeginDate

Beginning Date

CHILD CHARGE 1

N

Childcharge1

  

CHILD CHARGE 2

N

Childcharge2

  

CHILD CHARGE 3

N

Childcharge3

  

CHILD RATE EXC THRESHOLD 1

C

ChildRateExcThreshold1

  

CHILD RATE EXC THRESHOLD 2

C

ChildRateExcThreshold2

  

CHILD RATE EXC THRESHOLD 3

C

ChildRateExcThreshold3

  

CHILDREN THRESHOLD

N

Childrenthreshold

  

CHILDREN THRESHOLD CHARGE

N

Childrenthresholdcharge

  

DAY 1

C

Day1

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

DAY 2

C

Day2

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

DAY 3

C

Day3

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

DAY 4

C

Day4

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

DAY 5

C

Day5

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

DAY 6

C

Day6

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

DAY 7

C

Day7

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

END DATE

D

EndDate

  

OCCUPANTS THRESHOLD

N

Occupantsthreshold

  

OCCUPANTS THRESHOLD CHARGE

N

Occupantsthresholdcharge

  

ROOM TYPES

C

RoomTypes

  

DELETE HURDLE

APP USER

C

AppUser

  

CEILING

N

Ceiling

  

DELTA

N

Delta

  

HURDLE

N

HurdleRate

  

HURDLE DATE

D

HurdleDate

  

HURDLE LOS

N

HurdleLos

  

MAXSOLDS

N

MaxSolds

  

OVERRIDE

C

Override

  

ROOM TYPE

C

RoomType

  

UPSOLDS

N

Upsolds

  

YIELD CATEGORY

C

YieldCategory

Room Types in OPERA are assigned to Yield Categories 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 TYPE

C

YieldMarketType

  

DELETE PRODUCT

APP USER

C

AppUser

  

PACKAGE CODE

C

PackageCode

  

PACKAGE TYPE

C

PackageType

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

DELETE RATE CATEGORY

BEGIN DATE

D

BeginDate

Beginning Date

DESCRIPTION

C

Description

  

END DATE

D

EndDate

  

RATE CATEGORY

C

RateCategory

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

RATE CLASS

C

RateClass

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

DELETE RATE CLASS

BEGIN DATE

D

BeginDate

Beginning Date

DESCRIPTION

C

Description

  

END DATE

D

EndDate

  

RATE CLASS

C

RateClass

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

DELETE RATE HEADER

ADDITION

C

Addition

  

ADV DAILY BASE YN

C

AdvDailyBaseYN

  

ADV DAILY RATE YN

C

AdvDailyRateYN

  

ADVANCE BOOKING DAYS

N

AdvBookingDays

  

ASB RATE CYCLE

C

ASBRateCycle

  

BAR YN

C

BarYn

  

BASE TYPE

C

BaseType

  

BEGIN SELL

D

RateHeaderBeginSell

Beginning Date that the rate code can be booked.

BYPASS RANK CHECK YN

C

BypassRankCheckYn

  

CHANNEL ALLOWED YN

C

ChannelAllowedYn

  

CLOSED TO ARRIVAL

C

ClosedToArrival

  

COMMISSION CODE

C

CommissionCode

  

COMPLIMENTARY

C

Complimentary

  

CURRENCY CODE

C

CurrencyCode

  

DAILY RATE YN

C

DailyRateYn

  

DAY TYPE

C

DayType

  

DAY USE

C

DayUse

  

DEPOSIT MATURITY PREFERENCE

C

    

DISCOUNT RATE AMOUNT

N

DiscountRateAmount

  

DISCOUNT RATE PERCENTAGE YN

C

DiscountRatePercentageYN

  

END SELL

D

RateHeaderEndSell

  

ENTITY TYPE

C

EntityType

  

ENTITY VALUE

C

EntityValue

  

EXCHANGE POSTING TYPE

C

ExchangePostingType

  

EXTERNAL LOCKED

C

ExternalLocked

  

FORMULA

C

Formula

  

HOUSE USE

C

HouseUse

  

MARKET CODE

C

MarketCode

  

MAX LOS

N

MaxLos

  

MAX OCCUPANCY

N

MaxOccupancy

  

MEMBERSHIP

C

Membership

  

MIN LOS

N

MinLos

  

MIN OCCUPANCY

N

MinOccupancy

  

MYFIDELIO UPLOAD

C

MyfidelioUpdate

  

NEGOTIATED

C

Negotiated

  

OCCUPANCY BASED YN

C

OccupancyBasedYN

  

OCCUPANCY LEVEL

N

OccupancyLevel

  

OVERRIDE PACKAGE YN

C

OverridePackageYn

  

PACKAGE TRANSACTION CODE

C

PackageTransactionCode

  

PKG TRAN CODE TAX INCL

C

PkgTranCodeTaxIncl

  

POSTING RHYTHM

C

PostingRhythm

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

POSTING RHYTHM BEGIN DATE

D

PostingRhythmBeginDate

  

POSTING RHYTHM CODE

C

PostingRhythmCode

  

POSTING RHYTHM DESCRIPTION

C

PostingRhythmDescription

  

POSTING RHYTHM END DATE

D

PostingRhythmEndDate

  

POSTING RHYTHM FREE NIGHTS

N

PostingRhythmFreeNights

  

POSTING RHYTHM NIGHTS

N

PostingRhythmNights

  

POSTING RHYTHM PAID NIGHTS

N

PostingRhythmPaidNights

  

POSTING RHYTHM REPEAT WITHIN SELL SEGMENT YN

C

PostingRhythmRepeatWithinSellSegmentYN

  

POSTING RHYTHM REPEAT WITHIN STAY FOR MULTI-SEGMENT YN

C

PostingRhythmRepeatWithinStayForMultiSegmentYN

  

PRINT RATE

C

PrintRate

Should the rate be printed on the guest folio?

PRIVILEGED RESTRICTION YN

C

PrivilegedRestrictionYn

  

PRIVILEGED YN

C

PrivilegedYn

  

QTY PLUS PACKAGE CODE

C

QtyPlusPackageCode

  

RANK ADJUSTMENT FACTOR

N

RankAdjustmentFactor

  

RANK VALUE

N

RankValue

  

RATE BUCKET

C

RateBucket

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

RATE CATEGORY

C

RateCategory

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

RATE CLASS

C

RateClass

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

RATE CODE

C

RateCode

  

RATE UPDATE

C

RateUpdate

  

REGIONAL AVAILABILITY

C

RegionalAvailability

  

REPEAT

C

Repeat

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.

RESTRICTION UPDATE

C

RestrictionUpdate

  

ROOM TYPE

C

RoomType

  

SOURCE CODE

C

SourceCode

  

SUPPRESS RATE

C

SuppressRate

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.

TIERED RATE

C

TieredRate

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.

TRAN CODE TAX INCL

C

TranCodeTaxIncl

  

TRANSACTION CODE

C

TransactionCode

  

VOUCHER BENEFIT RATE YN

C

VoucherBenefitRateYn

  

WEEKEND DAYS

C

WeekendDays

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

YIELD STATUS

C

YieldStatus

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.

DELETE RATE SET

1 PERSON RATE

N

OnePersonRate

  

2 PERSON RATE

N

TwoPersonRate

  

3 PERSON RATE

N

ThreePersonRate

  

4 PERSON RATE

N

FourPersonRate

  

5 PERSON RATE

N

FivePersonRate

  

ADULTS THRESHOLD

N

Adultsthreshold

  

ADULTS THRESHOLD CHARGE

N

Adultsthresholdcharge

  

ADV DAILY BASE RATE CODE

C

AdvDailyBaseRateCode

  

AMOUNT 1 TYPE

C

Amount1Type

  

AMOUNT 2 TYPE

C

Amount2Type

  

AMOUNT 3 TYPE

C

Amount3Type

  

AMOUNT 4 TYPE

C

Amount4Type

  

AMOUNT 5 TYPE

C

Amount5Type

  

APP USER

C

AppUser

  

BAR AMOUNT

N

BarAmount

  

BAR FLT PCT

C

BarFltPct

  

BAR ROUNDING

C

BarRounding

  

BAR YN

C

BarFltPct

  

BEGIN DATE

D

BeginDate

Beginning Date

CHILD CHARGE 1

N

Childcharge1

  

CHILD CHARGE 2

N

Childcharge2

  

CHILD CHARGE 3

N

Childcharge3

  

CHILD RATE

N

ChildRate

  

CHILD RATE EXC THRESHOLD 1

C

ChildRateExcThreshold1

  

CHILD RATE EXC THRESHOLD 2

C

ChildRateExcThreshold2

  

CHILD RATE EXC THRESHOLD 3

C

ChildRateExcThreshold3

  

CHILDREN THRESHOLD

N

Childrenthreshold

  

CHILDREN THRESHOLD CHARGE

N

Childrenthresholdcharge

  

DAY 1

C

Day1

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

DAY 2

C

Day2

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

DAY 3

C

Day3

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

DAY 4

C

Day4

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

DAY 5

C

Day5

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

DAY 6

C

Day6

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

DAY 7

C

Day7

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

DIFF AMOUNT 1

N

DiffAmount1

  

DIFF AMOUNT 2

N

DiffAmount2

  

DIFF AMOUNT 3

N

DiffAmount3

  

DIFF AMOUNT 4

N

DiffAmount4

  

DIFF AMOUNT 5

N

DiffAmount5

  

DIFF AMOUNT EXTRA ADULT

N

DiffAmountExtraAdult

  

DIFF PERCENTAGE 1 YN

C

DiffPercentage1YN

  

DIFF PERCENTAGE 2 YN

C

DiffPercentage2YN

  

DIFF PERCENTAGE 3 YN

C

DiffPercentage3YN

  

DIFF PERCENTAGE 4 YN

C

DiffPercentage4YN

  

DIFF PERCENTAGE 5 YN

C

DiffPercentage5YN

  

DIFF PERCENTAGE EXTRA ADULT YN

C

DiffPercentageExtraAdultYN

  

END DATE

D

EndDate

  

EXTRA ADULT RATE

N

ExtraAdultRate

  

EXTRA ADULT TYPE

C

ExtraAdultType

  

MARKET CODE

C

MarketCode

  

MAXIMUM RATE PERSON 1

N

MaxRatePerson1

  

MAXIMUM RATE PERSON 2

N

MaxRatePerson2

  

MIN CHILDREN FOR FREE STAY

N

MinChildrenForFreeStay

  

MINIMUM RATE PERSON 1

N

MinRatePerson1

  

MINIMUM RATE PERSON 2

N

MinRatePerson2

  

NUM CHILDREN STAY FREE

N

NumChildrenStayFree

  

OCCUPANTS THRESHOLD

N

Occupantsthreshold

  

OCCUPANTS THRESHOLD CHARGE

N

Occupantsthresholdcharge

  

POINTS REQUIRED

N

pointsRequired

  

PRODUCT CODE

C

ProductCode

Package Code

RATE CODE

C

RateCode

  

ROOM TYPE

C

RoomType

  

SEASON CODE

C

SeasonCode

  

SOURCE CODE

C

SourceCode

  

TIER

C

Tier

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>.

DELETE RATE SET ADJUSTMENT

ADJUSTMENT AMOUNT

N

YieldAdjustmentAmount

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

ADJUSTMENT CODE

C

YieldAdjustmentCode

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

ADJUSTMENT TYPE

C

YieldAdjustmentType

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

BEGIN DATE

D

BeginDate

Beginning Date

END DATE

D

EndDate

  

FLAT OR PERCENTAGE

C

FlatOrPercentage

  

RATE CODE

C

RateCode

  

ROOM TYPE

C

RoomType

  

DELETE RATE STRATEGY

APPLY YN

C

ApplyYn

  

CONDITION TYPE

C

ConditionType

  

CONDITION VALUE

N

ConditionValue

  

CONDITION VALUE TYPE

C

ConditionValueType

  

CONTROL END DATE

D

ControlEndDate

  

CONTROL START DATE

D

ControlStartDate

  

COUNTER COND YN

C

CounterCondYn

  

DAY FIVE

C

DayFive

  

DAY FOUR

C

DayFour

  

DAY ONE

C

DayOne

  

DAY SEVEN

C

DaySeven

  

DAY SIX

C

DaySix

  

DAY THREE

C

DayThree

  

DAY TWO

C

DayTwo

  

DAYS IN ADVANCE FROM

N

DaysInAdvanceFrom

  

DAYS IN ADVANCE TO

N

DaysInAdvanceTo

  

EXTERNAL REFERENCE

C

ExternalReference

  

INACTIVE DATE

D

InactiveDate

  

OCCUPANCY BASED AMOUNT

N

OccupancyBasedAmount

  

OCCUPANCY BASED YN

C

OccupancyBasedYN

  

PHYSICAL

N

Physical

  

RATE CATEGORY

C

RateCategory

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

RATE CLASS

C

RateClass

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

RATE CODE

C

RateCode

  

RESTRICTION END DATE

D

RestrictionEndDate

  

RESTRICTION START DATE

D

RestrictionStartDate

  

RESTRICTION TYPE

C

RestrictionType

  

RESTRICTION VALUE

N

RestrictionValue

  

ROOM CLASS

C

RoomClass

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

ROOM TYPE

C

RoomType

  

SEQUENCE

N

Sequence

  

DELETE RULE

BLOCK CODE

C

BlockCode

  

BLOCK ID

N

BlockId

  

CNL BEFORE TIME

T

CnlBeforeTime

  

CNL DAYS PRIOR TO ARRIVAL

N

CnlDaysPriorToArrival

  

CNL PENALTY AMOUNT

N

CnlPenaltyAmount

  

CNL PENALTY AMOUNT TYPE

C

CnlPenaltyAmountType

  

DEP AMOUNT

N

DepAmount

  

DEP AMOUNT TYPE

C

DepAmountType

  

DEP DAYS AFTER BOOKING

N

DepDaysAfterBooking

  

DEP DAYS PRIOR TO ARRIVAL

N

DepDaysPriorToArrival

  

RATE CODE

C

RateCode

  

RESERVATION TYPE

C

ReservationType

  

RULE BEGIN DATE

D

RuleBeginDate

  

RULE CODE

C

RuleCode

  

RULE END DATE

D

RuleEndDate

  

RULE TYPE

C

RuleType

  

SEASON CODE

C

RuleSeasonCode

  

DELETE SEASON CODE

BEGIN DATE

D

BeginDate

Beginning Date

DESCRIPTION

C

Description

  

END DATE

D

EndDate

  

RATE CODE

C

RateCode

  

SEASON CODE

C

SeasonCode

  

DELETE YIELD MARKET

ALTERNATIVE

C

Alternative

  

CODE

C

Code

  

NEW BEST AVAILABLE RATES

DAYS

C

Days

  

FROM DATE

D

FromDate

  

LOS

C

Los

  

RATE CODE

C

RateCode

  

TO DATE

D

ToDate

  

NEW HURDLE

APP USER

C

AppUser

  

CEILING

N

Ceiling

  

DELTA

N

Delta

  

HURDLE

N

HurdleRate

  

HURDLE DATE

D

HurdleDate

  

HURDLE LOS

N

HurdleLos

  

MAXSOLDS

N

MaxSolds

  

OVERRIDE

C

Override

  

ROOM TYPE

C

RoomType

  

UPSOLDS

N

Upsolds

  

YIELD CATEGORY

C

YieldCategory

Room Types in OPERA are assigned to Yield Categories 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 TYPE

C

YieldMarketType

  

NEW PRODUCT

ALLOWANCE

C

Allowance

  

ALLOWANCE AMOUNT

N

AllowanceAmount

  

ALTERNATIVE TRANSACTION CODE

C

AlternativeTransCode

  

APP USER

C

AppUser

  

BEGIN DATE

D

BeginDate

Beginning Date

BEGIN SELL DATE

D

BeginSellDate

  

BUCKET2 ALLOWANCE AMOUNT

N

Bucket2AllowanceAmount

  

BUCKET2 PRICE

N

Bucket2Price

  

BUCKET3 ALLOWANCE AMOUNT

N

Bucket3AllowanceAmount

  

BUCKET3 PRICE

N

Bucket3Price

  

CALCULATION RULE

C

CalculationRule

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

CATERING YN

C

CateringYn

  

COMBINED LINE

C

CombinedLine

  

CURRENCY CODE

C

CurrencyCode

  

DAY1

C

Day1

  

DAY2

C

Day2

  

DAY3

C

Day3

  

DAY4

C

Day4

  

DAY5

C

Day5

  

DAY6

C

Day6

  

DAY7

C

Day7

  

DEPT TAX INCL YN

C

DeptTaxInclYN

  

DESCRIPTION

C

Description

  

END DATE

D

EndDate

  

END SELL DATE

D

EndSellDate

  

FORECAST CODE

C

PKGForecastCode

  

FORECAST NEXT DAY YN

C

ForecastNextDayYN

  

FORMULA

C

Formula

  

GROUP PACKAGE LIST

C

GroupPackageList

  

INACTIVE DATE

D

InactiveDate

  

INCLUDED IN RATE

C

IncludedInRate

  

ITEM PRICE

N

ItemPrice

  

KEEP INVENTORY

C

KeepInventory

  

MAX NIGHTS

N

MaxNights

  

MAX PERSONS

N

MaxPersons

  

MIN NIGHTS

N

MinNights

  

MIN PERSONS

N

MinPersons

  

OVERAGE TAX INCL YN

C

OverageTaxInclYN

  

PACKAGE CODE

C

PackageCode

  

PACKAGE TYPE

C

PackageType

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

PKG ARRANGEMENT CODE

C

PkgArrangementCode

  

PKG FORECAST GROUP

C

PkgForecastGroup

  

PKG VALID END TIME

T

PKGValidEndTime

  

PKG VALID START TIME

T

PKGValidStartTime

  

POINTS REQUIRED

N

PointsRequired

  

POST NEXT DAY

C

PostNextDay

Is this package posting the next day?

POSTING RHYTHM

C

PostingRhythm

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

RATE CODE

C

RateCode

  

SEASON CODE

C

SeasonCode

  

SELL OWS YN

C

SellOwsYn

  

SELL SEPARATE

C

SellSeparate

  

SEPARATE LINE

C

SeparateLine

  

SH CRS DEFAULT YN

C

ShCrsDefaultYN

  

SH CRS PKG CODE

C

ShCrsPkgCode

  

SHORT DESCRIPTION

C

PKGShortDesc

  

TRANSACTION CODE

C

TransactionCode

  

TRANSACTION CODE FOR LOSS

C

TransCodeForLoss

  

TRANSACTION CODE FOR OVERAGE

C

TransCodeForOverage

  

TRANSACTION CODE FOR PROFIT

C

TransCodeForProfit

  

NEW RATE CATEGORY

BEGIN DATE

D

BeginDate

Beginning Date

DESCRIPTION

C

Description

  

END DATE

D

EndDate

  

RATE CATEGORY

C

RateCategory

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

RATE CLASS

C

RateClass

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

SH DEFAULT NO OF ROOMS

C

ShDefaultNoOfRooms

  

SH DISPLAY SEQ

C

ShDisplaySeq

  

SH ENTITLEMENTS YN

C

ShEntitlementsYN

  

SH LAST ROOM AVAILABILITY

C

ShLastRoomAvailability

  

SH ROOM CATEGORY

C

ShRoomCategory

  

NEW RATE CLASS

BEGIN DATE

D

BeginDate

Beginning Date

DESCRIPTION

C

Description

  

END DATE

D

EndDate

  

RATE CLASS

C

RateClass

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

NEW RATE HEADER

ADD TO RATE YN

C

AddToRateYn

Is the package added to the rate?

ADDITION

C

Addition

  

ADV DAILY BASE YN

C

AdvDailyBaseYN

  

ADV DAILY RATE YN

C

AdvDailyRateYN

  

ADVANCE BOOKING DAYS

N

AdvBookingDays

  

ALLOWANCE AMOUNT

N

AllowanceAmount

  

ALTERNATE RATE CODE

C

AlternateRateCode

  

ASB RATE CYCLE

C

ASBRateCycle

  

BAR YN

C

BarYn

  

BASE TYPE

C

BaseType

  

BEGIN SELL

D

RateHeaderBeginSell

  

BYPASS RANK CHECK YN

C

BypassRankCheckYn

  

CHANNEL ALLOWED YN

C

ChannelAllowedYn

  

CLOSED TO ARRIVAL

C

ClosedToArrival

  

COMMISSION CODE

C

CommissionCode

  

COMPLIMENTARY

C

Complimentary

  

CURRENCY CODE

C

CurrencyCode

  

DAILY RATE YN

C

DailyRateYn

  

DAY TYPE

C

DayType

  

DAY USE

C

DayUse

  

DEPOSIT MATURITY PREFERENCE

C

    

DESCRIPTION

C

Description

  

DISCOUNT RATE AMOUNT

N

DiscountRateAmount

  

DISCOUNT RATE PERCENTAGE YN

C

DiscountRatePercentageYN

  

DISCOUNT YN

C

DiscountYN

  

END SELL

D

RateHeaderEndSell

  

ENTITY TYPE

C

EntityType

  

ENTITY VALUE

C

EntityValue

  

EXCHANGE POSTING TYPE

C

ExchangePostingType

  

EXTERNAL LOCKED

C

ExternalLocked

  

FORMULA

C

Formula

  

HOUSE USE

C

HouseUse

  

ITEM PRICE

N

ItemPrice

  

LONG INFO

C

LongInfo

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

MARKET CODE

C

MarketCode

  

MAX LOS

N

MaxLos

  

MAX OCCUPANCY

N

MaxOccupancy

  

MEMBERSHIP

C

Membership

  

MIN LOS

N

MinLos

  

MIN OCCUPANCY

N

MinOccupancy

  

MYFIDELIO UPLOAD

C

MyfidelioUpdate

  

NEGOTIATED

C

Negotiated

  

OCCUPANCY BASED YN

C

OccupancyBasedYN

  

OCCUPANCY LEVEL

N

OccupancyLevel

  

OVERRIDE PACKAGE YN

C

OverridePackageYn

  

PACKAGE BEGIN DATE

D

PackageBeginDate

  

PACKAGE END DATE

D

PackageEndDate

  

PACKAGE TRANSACTION CODE

C

PackageTransactionCode

  

PKG TRAN CODE TAX INCL

C

PkgTranCodeTaxIncl

  

POSTING RHYTHM

C

PostingRhythm

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

POSTING RHYTHM BEGIN DATE

D

PostingRhythmBeginDate

  

POSTING RHYTHM CODE

C

PostingRhythmCode

  

POSTING RHYTHM DESCRIPTION

C

PostingRhythmDescription

  

POSTING RHYTHM END DATE

D

PostingRhythmEndDate

  

POSTING RHYTHM FREE NIGHTS

N

PostingRhythmFreeNights

  

POSTING RHYTHM NIGHTS

N

PostingRhythmNights

  

POSTING RHYTHM PAID NIGHTS

N

PostingRhythmPaidNights

  

POSTING RHYTHM REPEAT WITHIN SELL SEGMENT YN

C

PostingRhythmRepeatWithinSellSegmentYN

  

POSTING RHYTHM REPEAT WITHIN STAY FOR MULTI-SEGMENT YN

C

PostingRhythmRepeatWithinStayForMultiSegmentYN

  

PRINT RATE

C

PrintRate

Should the rate be printed on the guest folio?

PRIVILEGED RESTRICTION YN

C

PrivilegedRestrictionYn

  

PRIVILEGED YN

C

PrivilegedYn

  

PRODUCT CODE

C

ProductCode

Package Code

PRODUCT QTY

C

ProductQty

Quantity of Packages

QTY PLUS PACKAGE CODE

C

QtyPlusPackageCode

Quantity of Package and Package Code.

RANK ADJUSTMENT FACTOR

N

RankAdjustmentFactor

  

RANK VALUE

N

RankValue

  

RATE BUCKET

C

RateBucket

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

RATE CATEGORY

C

RateCategory

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

RATE CLASS

C

RateClass

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

RATE CODE

C

RateCode

  

RATE FLOOR

N

RateFloor

  

RATE UPDATE

C

RateUpdate

  

REGIONAL AVAILABILITY

C

RegionalAvailability

  

REPEAT

C

Repeat

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.

RESTRICTION UPDATE

C

RestrictionUpdate

  

ROOM TYPE

C

RoomType

  

SEASON CODE

C

SeasonCode

  

SH GROUP YN

C

GroupYN

  

SH ID REQUIREMENTS

C

IdRequirements

  

SH RIV MARKET SEGMENT

C

RivMarketSegment

  

SH STAY DAYS

C

StayDays

  

SHORT TEXT

C

ShortText

  

SOURCE CODE

C

SourceCode

  

SUPPRESS RATE

C

SuppressRate

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.

TIERED RATE

C

TieredRate

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.

TRAN CODE TAX INCL

C

TranCodeTaxIncl

  

TRANSACTION CODE

C

TransactionCode

  

VOUCHER BENEFIT RATE YN

C

VoucherBenefitRateYn

  

WEEKEND DAYS

C

WeekendDays

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

YIELD MARKET

C

YieldMarket

  

YIELD STATUS

C

YieldStatus

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.

NEW RATE SET

1 PERSON RATE

N

OnePersonRate

  

2 PERSON RATE

N

TwoPersonRate

  

3 PERSON RATE

N

ThreePersonRate

  

4 PERSON RATE

N

FourPersonRate

  

5 PERSON RATE

N

FivePersonRate

  

ACTIVE RATE SET

C

ActiveRateSet

  

ADULTS THRESHOLD

N

Adultsthreshold

  

ADULTS THRESHOLD CHARGE

N

Adultsthresholdcharge

  

ADV BASE AMOUNT

N

BaseAmount

  

ADV BASE COMPARE YN

C

AdvBaseCompareYN

  

ADV BASE FLT PCT

C

AdvBaseFltPct

  

ADV DAILY BASE RATE CODE

C

AdvDailyBaseRateCode

  

AMOUNT 1 TYPE

C

Amount1Type

  

AMOUNT 2 TYPE

C

Amount2Type

  

AMOUNT 3 TYPE

C

Amount3Type

  

AMOUNT 4 TYPE

C

Amount4Type

  

AMOUNT 5 TYPE

C

Amount5Type

  

APP USER

C

AppUser

  

BAR AMOUNT

N

BarAmount

  

BAR FLT PCT

C

BarFltPct

  

BAR ROUNDING

C

BarRounding

  

BAR YN

C

BarFltPct

  

BEGIN DATE

D

BeginDate

Beginning Date

CHILD CHARGE 1

N

Childcharge1

  

CHILD CHARGE 2

N

Childcharge2

  

CHILD CHARGE 3

N

Childcharge3

  

CHILD OWN RATE 1

N

ChildOwnRate1

  

CHILD OWN RATE 2

N

ChildOwnRate2

  

CHILD OWN RATE 3

N

ChildOwnRate3

  

CHILD OWN RATE 4

N

ChildOwnRate4

  

CHILD RATE

N

ChildRate

  

CHILD RATE 1

N

ChildRate1

  

CHILD RATE 2

N

ChildRate2

  

CHILD RATE 3

N

ChildRate3

  

CHILD RATE EXC THRESHOLD 1

C

ChildRateExcThreshold1

  

CHILD RATE EXC THRESHOLD 2

C

ChildRateExcThreshold2

  

CHILD RATE EXC THRESHOLD 3

C

ChildRateExcThreshold3

  

CHILD RATE OWN 1

N

ChildOwnRate1

  

CHILD RATE OWN 2

N

ChildOwnRate2

  

CHILD RATE OWN 3

N

ChildOwnRate3

  

CHILDREN THRESHOLD

N

Childrenthreshold

  

CHILDREN THRESHOLD CHARGE

N

Childrenthresholdcharge

  

DAY 1

C

Day1

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

DAY 2

C

Day2

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

DAY 3

C

Day3

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

DAY 4

C

Day4

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

DAY 5

C

Day5

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

DAY 6

C

Day6

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

DAY 7

C

Day7

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

DIFF AMOUNT 1

N

DiffAmount1

  

DIFF AMOUNT 2

N

DiffAmount2

  

DIFF AMOUNT 3

N

DiffAmount3

  

DIFF AMOUNT 4

N

DiffAmount4

  

DIFF AMOUNT 5

N

DiffAmount5

  

DIFF AMOUNT EXTRA ADULT

N

DiffAmountExtraAdult

  

DIFF PERCENTAGE 1 YN

C

DiffPercentage1YN

  

DIFF PERCENTAGE 2 YN

C

DiffPercentage2YN

  

DIFF PERCENTAGE 3 YN

C

DiffPercentage3YN

  

DIFF PERCENTAGE 4 YN

C

DiffPercentage4YN

  

DIFF PERCENTAGE 5 YN

C

DiffPercentage5YN

  

DIFF PERCENTAGE EXTRA ADULT YN

C

DiffPercentageExtraAdultYN

  

END DATE

D

EndDate

  

EXTRA ADULT RATE

N

ExtraAdultRate

  

EXTRA ADULT TYPE

C

ExtraAdultType

  

MARKET CODE

C

MarketCode

  

MAXIMUM RATE PERSON 1

N

MaxRatePerson1

  

MAXIMUM RATE PERSON 2

N

MaxRatePerson2

  

MIN CHILDREN FOR FREE STAY

N

MinChildrenForFreeStay

  

MINIMUM RATE PERSON 1

N

MinRatePerson1

  

MINIMUM RATE PERSON 2

N

MinRatePerson2

  

NUM CHILDREN STAY FREE

N

NumChildrenStayFree

  

OCCUPANTS THRESHOLD

N

Occupantsthreshold

  

OCCUPANTS THRESHOLD CHARGE

N

Occupantsthresholdcharge

  

POINTS REQUIRED

N

pointsRequired

  

PRODUCT CODE

C

ProductCode

Package Code

RATE CODE

C

RateCode

  

ROOM TYPE

C

RoomType

  

SEASON CODE

C

SeasonCode

  

SOURCE CODE

C

SourceCode

  

TIER

C

Tier

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>.

NEW RATE SET ADJUSTMENT

ADJUSTMENT AMOUNT

N

YieldAdjustmentAmount

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

ADJUSTMENT CODE

C

YieldAdjustmentCode

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

ADJUSTMENT TYPE

C

YieldAdjustmentType

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

BEGIN DATE

D

BeginDate

Beginning Date

END DATE

D

EndDate

  

FLAT OR PERCENTAGE

C

FlatOrPercentage

  

RATE CODE

C

RateCode

  

ROOM TYPE

C

RoomType

  

NEW RATE STRATEGY

APPLY YN

C

ApplyYn

  

CONDITION TYPE

C

ConditionType

  

CONDITION VALUE

N

ConditionValue

  

CONDITION VALUE TYPE

C

ConditionValueType

  

CONTROL END DATE

D

ControlEndDate

  

CONTROL START DATE

D

ControlStartDate

  

COUNTER COND YN

C

CounterCondYn

  

DAY FIVE

C

DayFive

  

DAY FOUR

C

DayFour

  

DAY ONE

C

DayOne

  

DAY SEVEN

C

DaySeven

  

DAY SIX

C

DaySix

  

DAY THREE

C

DayThree

  

DAY TWO

C

DayTwo

  

DAYS IN ADVANCE FROM

N

DaysInAdvanceFrom

  

DAYS IN ADVANCE TO

N

DaysInAdvanceTo

  

EXTERNAL REFERENCE

C

ExternalReference

  

INACTIVE DATE

D

InactiveDate

  

OCCUPANCY BASED AMOUNT

N

OccupancyBasedAmount

  

OCCUPANCY BASED YN

C

OccupancyBasedYN

  

PHYSICAL

N

Physical

  

RATE CATEGORY

C

RateCategory

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

RATE CLASS

C

RateClass

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

RATE CODE

C

RateCode

  

RESTRICTION END DATE

D

RestrictionEndDate

  

RESTRICTION START DATE

D

RestrictionStartDate

  

RESTRICTION TYPE

C

RestrictionType

  

RESTRICTION VALUE

N

RestrictionValue

  

ROOM CLASS

C

RoomClass

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

ROOM TYPE

C

RoomType

  

SEQUENCE

N

Sequence

  

NEW RULE

BLOCK CODE

C

BlockCode

  

BLOCK ID

N

BlockId

  

CNL BEFORE TIME

T

CnlBeforeTime

  

CNL DAYS PRIOR TO ARRIVAL

N

CnlDaysPriorToArrival

  

CNL PENALTY AMOUNT

N

CnlPenaltyAmount

  

CNL PENALTY AMOUNT TYPE

C

CnlPenaltyAmountType

  

DEP AMOUNT

N

DepAmount

  

DEP AMOUNT TYPE

C

DepAmountType

  

DEP DAYS AFTER BOOKING

N

DepDaysAfterBooking

  

DEP DAYS PRIOR TO ARRIVAL

N

DepDaysPriorToArrival

  

RATE CODE

C

RateCode

  

RESERVATION TYPE

C

ReservationType

  

RULE BEGIN DATE

D

RuleBeginDate

  

RULE CODE

C

RuleCode

  

RULE END DATE

D

RuleEndDate

  

RULE TYPE

C

RuleType

  

SEASON CODE

C

RuleSeasonCode

  

NEW SEASON CODE

BEGIN DATE

D

BeginDate

Beginning Date

DESCRIPTION

C

Description

  

END DATE

D

EndDate

  

RATE CODE

C

RateCode

  

SEASON CODE

C

SeasonCode

  

NEW YIELD MARKET

ALTERNATIVE

C

Alternative

  

CODE

C

Code

  

DESCRIPTION

C

Description

  

RATE RESTRICTIONS

APP USER

C

AppUser

  

ARRIVAL

C

Arrival

  

BOOK MAX ADV

N

BookMaxAdv

  

BOOK MIN ADV

N

BookMinAdv

  

CHANNEL

C

Channel

  

CLEAR ALL RESTRICTIONS

C

ClearAllRestrictions

  

DAY OF WEEK

C

DayOfWeek

  

DEPARTURE

C

Departure

  

GDS ON REQUEST

C

GdsOnRequest

  

GENERATED BY RATE STRATEGY

C

GeneratedByRateStrategy

  

GdsOnRequest

C

GdsOnRequest

  

LENGTH OF STAY NA

C

LengthOfStayNA

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

MAX LOS

N

MaxLos

  

MAX STAY THROUGH

N

MaxStayThrough

  

MIN LOS

N

MinLos

  

MIN STAY THROUGH

N

MinStayThrough

  

PER DAY YN

C

PerDayYn

  

RATE CATEGORY

C

RateCategory

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

RATE CLASS

C

RateClass

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

RATE CODE

C

RateCode

  

ROOM CLASS

C

RoomClass

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

ROOM TYPE

C

RoomType

  

SET ON

C

SetOn

  

STAY

C

Stay

  

YIELDABILITY

C

Yieldability

  

RATE TIER

NUMBER OF TIERS

N

NumberOfTiers

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

TIER 1

N

Tier1

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

N

Tier2

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

N

Tier3

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

N

Tier4

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

N

Tier5

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'

RESTRICTIONS PER DAY

RESTRICTION DATE

D

RestrictionDate

  

UPDATE HURDLE

APP USER

C

AppUser

  

CEILING

N

Ceiling

  

DELTA

N

Delta

  

HURDLE

N

HurdleRate

  

HURDLE DATE

D

HurdleDate

  

HURDLE LOS

N

HurdleLos

  

MAXSOLDS

N

MaxSolds

  

OVERRIDE

C

Override

  

ROOM TYPE

C

RoomType

  

UPSOLDS

N

Upsolds

  

YIELD CATEGORY

C

YieldCategory

Room Types in OPERA are assigned to Yield Categories 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 TYPE

C

YieldMarketType

  

UPDATE PRODUCT

ALLOWANCE

C

Allowance

  

ALLOWANCE AMOUNT

N

AllowanceAmount

  

ALTERNATIVE TRANSACTION CODE

C

AlternativeTransCode

  

APP USER

C

AppUser

  

BEGIN DATE

D

BeginDate

Beginning Date

BEGIN SELL DATE

D

BeginSellDate

  

BUCKET2 ALLOWANCE AMOUNT

N

Bucket2AllowanceAmount

  

BUCKET2 PRICE

N

Bucket2Price

  

BUCKET3 ALLOWANCE AMOUNT

N

Bucket3AllowanceAmount

  

BUCKET3 PRICE

N

Bucket3Price

  

CALCULATION RULE

C

CalculationRule

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

CATERING YN

C

CateringYn

  

COMBINED LINE

C

CombinedLine

  

CURRENCY CODE

C

CurrencyCode

  

DAY1

C

Day1

  

DAY2

C

Day2

  

DAY3

C

Day3

  

DAY4

C

Day4

  

DAY5

C

Day5

  

DAY6

C

Day6

  

DAY7

C

Day7

  

DEPT TAX INCL YN

C

DeptTaxInclYN

  

DESCRIPTION

C

Description

  

END DATE

D

EndDate

  

END SELL DATE

D

EndSellDate

  

FORECAST CODE

C

PKGForecastCode

  

FORECAST NEXT DAY YN

C

ForecastNextDayYN

  

FORMULA

C

Formula

  

GROUP PACKAGE LIST

C

GroupPackageList

  

INACTIVE DATE

D

InactiveDate

  

INCLUDED IN RATE

C

IncludedInRate

  

ITEM ID

N

ItemID

  

ITEM PRICE

N

ItemPrice

  

KEEP INVENTORY

C

KeepInventory

  

MAX NIGHTS

N

MaxNights

  

MAX PERSONS

N

MaxPersons

  

MIN NIGHTS

N

MinNights

  

MIN PERSONS

N

MinPersons

  

OVERAGE TAX INCL YN

C

OverageTaxInclYN

  

PACKAGE CODE

C

PackageCode

  

PACKAGE TYPE

C

PackageType

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

PKG ARRANGEMENT CODE

C

PkgArrangementCode

  

PKG FORECAST GROUP

C

PkgForecastGroup

  

PKG VALID END TIME

T

PKGValidEndTime

  

PKG VALID START TIME

T

PKGValidStartTime

  

POINTS REQUIRED

N

PointsRequired

  

POST NEXT DAY

C

PostNextDay

Is this package posting the next day?

POSTING RHYTHM

C

PostingRhythm

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

QUANTITY

N

ItemQuantity

  

RATE CODE

C

RateCode

  

SEASON CODE

C

SeasonCode

  

SELL OWS YN

C

SellOwsYn

  

SELL SEPARATE

C

SellSeparate

  

SEPARATE LINE

C

SeparateLine

  

SH CRS DEFAULT YN

C

ShCrsDefaultYN

  

SH CRS PKG CODE

C

ShCrsPkgCode

  

SHORT DESCRIPTION

C

PKGShortDesc

  

TRANSACTION CODE

C

TransactionCode

  

TRANSACTION CODE FOR LOSS

C

TransCodeForLoss

  

TRANSACTION CODE FOR OVERAGE

C

TransCodeForOverage

  

TRANSACTION CODE FOR PROFIT

C

TransCodeForProfit

  

UPDATE RATE CATEGORY

BEGIN DATE

D

BeginDate

Beginning Date

DESCRIPTION

C

Description

  

END DATE

D

EndDate

  

RATE CATEGORY

C

RateCategory

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

RATE CLASS

C

RateClass

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

SH DEFAULT NO OF ROOMS

C

ShDefaultNoOfRooms

  

SH DISPLAY SEQ

C

ShDisplaySeq

  

SH ENTITLEMENTS YN

C

ShEntitlementsYN

  

SH LAST ROOM AVAILABILITY

C

ShLastRoomAvailability

  

SH ROOM CATEGORY

C

ShRoomCategory

  

UPDATE RATE CLASS

BEGIN DATE

D

BeginDate

Beginning Date

DESCRIPTION

C

Description

  

END DATE

D

EndDate

  

RATE CLASS

C

RateClass

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

UPDATE RATE HEADER

ADD TO RATE YN

C

AddToRateYn

Is the package added to the rate?

ADDITION

C

Addition

  

ADV DAILY BASE YN

C

AdvDailyBaseYN

  

ADV DAILY RATE YN

C

AdvDailyRateYN

  

ADVANCE BOOKING DAYS

N

AdvBookingDays

  

ALLOWANCE AMOUNT

N

AllowanceAmount

  

ALTERNATE RATE CODE

C

AlternateRateCode

  

ASB RATE CYCLE

C

ASBRateCycle

  

BAR YN

C

BarYn

  

BASE TYPE

C

BaseType

  

BEGIN SELL

D

RateHeaderBeginSell

Beginning Date that the rate code can be booked.

BYPASS RANK CHECK YN

C

BypassRankCheckYn

  

CHANNEL ALLOWED YN

C

ChannelAllowedYn

  

CLOSED TO ARRIVAL

C

ClosedToArrival

  

COMMISSION CODE

C

CommissionCode

  

COMPLIMENTARY

C

Complimentary

  

CURRENCY CODE

C

CurrencyCode

  

DAILY RATE YN

C

DailyRateYn

  

DAY TYPE

C

DayType

  

DAY USE

C

DayUse

  

DEPOSIT MATURITY PREFERENCE

C

    

DESCRIPTION

C

Description

  

DISCOUNT RATE AMOUNT

N

DiscountRateAmount

  

DISCOUNT RATE PERCENTAGE YN

C

DiscountRatePercentageYN

  

DISCOUNT YN

C

DiscountYN

  

END SELL

D

RateHeaderEndSell

  

ENTITY TYPE

C

EntityType

  

ENTITY VALUE

C

EntityValue

  

EXCHANGE POSTING TYPE

C

ExchangePostingType

  

EXTERNAL LOCKED

C

ExternalLocked

  

FORMULA

C

Formula

  

HOUSE USE

C

HouseUse

  

ITEM PRICE

N

ItemPrice

  

LONG INFO

C

LongInfo

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

MANUALLY DISTRIBUTE

C

ManuallyDistribute

  

MARKET CODE

C

MarketCode

  

MAX LOS

N

MaxLos

  

MAX OCCUPANCY

N

MaxOccupancy

  

MEMBERSHIP

C

Membership

  

MIN LOS

N

MinLos

  

MIN OCCUPANCY

N

MinOccupancy

  

MYFIDELIO UPLOAD

C

MyfidelioUpdate

  

NEGOTIATED

C

Negotiated

  

OCCUPANCY BASED YN

C

OccupancyBasedYN

  

OCCUPANCY LEVEL

N

OccupancyLevel

  

OVERRIDE PACKAGE YN

C

OverridePackageYn

  

PACKAGE TRANSACTION CODE

C

PackageTransactionCode

  

PKG TRAN CODE TAX INCL

C

PkgTranCodeTaxIncl

  

POSTING RHYTHM

C

PostingRhythm

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

POSTING RHYTHM BEGIN DATE

D

PostingRhythmBeginDate

  

POSTING RHYTHM CODE

C

PostingRhythmCode

  

POSTING RHYTHM DESCRIPTION

C

PostingRhythmDescription

  

POSTING RHYTHM END DATE

D

PostingRhythmEndDate

  

POSTING RHYTHM FREE NIGHTS

N

PostingRhythmFreeNights

  

POSTING RHYTHM NIGHTS

N

PostingRhythmNights

  

POSTING RHYTHM PAID NIGHTS

N

PostingRhythmPaidNights

  

POSTING RHYTHM REPEAT WITHIN SELL SEGMENT YN

C

PostingRhythmRepeatWithinSellSegmentYN

  

POSTING RHYTHM REPEAT WITHIN STAY FOR MULTI-SEGMENT YN

C

PostingRhythmRepeatWithinStayForMultiSegmentYN

  

PRINT RATE

C

PrintRate

Should the rate be printed on the guest folio?

PRIVILEGED RESTRICTION YN

C

PrivilegedRestrictionYn

  

PRIVILEGED YN

C

PrivilegedYn

  

PRODUCT CODE

C

ProductCode

Package Code

PRODUCT QTY

C

ProductQty

Quantity of Packages

QTY PLUS PACKAGE CODE

C

QtyPlusPackageCode

Quantity of Package and Package Code.

RANK ADJUSTMENT FACTOR

N

RankAdjustmentFactor

  

RANK VALUE

N

RankValue

  

RATE BUCKET

C

RateBucket

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

RATE CATEGORY

C

RateCategory

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

RATE CLASS

C

RateClass

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

RATE CODE

C

RateCode

  

RATE FLOOR

N

RateFloor

  

RATE FORMULA CHANGED YN

C

RateFormulaChangedYn

  

RATE UPDATE

C

RateUpdate

  

REGIONAL AVAILABILITY

C

RegionalAvailability

  

REPEAT

C

Repeat

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.

RESTRICTION UPDATE

C

RestrictionUpdate

  

ROOM TYPE

C

RoomType

  

SH GROUP YN

C

GroupYN

  

SH ID REQUIREMENTS

C

IdRequirements

  

SH RIV MARKET SEGMENT

C

RivMarketSegment

  

SH STAY DAYS

C

StayDays

  

SHORT TEXT

C

ShortText

  

SOURCE CODE

C

SourceCode

  

SUPPRESS RATE

C

SuppressRate

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.

TIERED RATE

C

TieredRate

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.

TRAN CODE TAX INCL

C

TranCodeTaxIncl

  

TRANSACTION CODE

C

TransactionCode

  

VOUCHER BENEFIT RATE YN

C

VoucherBenefitRateYn

  

WEEKEND DAYS

C

WeekendDays

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

YIELD MARKET

C

YieldMarket

  

YIELD STATUS

C

YieldStatus

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.

UPDATE RATE SET

1 PERSON RATE

N

OnePersonRate

  

2 PERSON RATE

N

TwoPersonRate

  

3 PERSON RATE

N

ThreePersonRate

  

4 PERSON RATE

N

FourPersonRate

  

5 PERSON RATE

N

FivePersonRate

  

ACTIVE RATE SET

C

ActiveRateSet

  

ADULTS THRESHOLD

N

Adultsthreshold

  

ADULTS THRESHOLD CHARGE

N

Adultsthresholdcharge

  

ADV BASE AMOUNT

N

BaseAmount

  

ADV BASE COMPARE YN

C

AdvBaseCompareYN

  

ADV BASE FLT PCT

C

AdvBaseFltPct

  

ADV DAILY BASE RATE CODE

C

AdvDailyBaseRateCode

  

AMOUNT 1 TYPE

C

Amount1Type

  

AMOUNT 2 TYPE

C

Amount2Type

  

AMOUNT 3 TYPE

C

Amount3Type

  

AMOUNT 4 TYPE

C

Amount4Type

  

AMOUNT 5 TYPE

C

Amount5Type

  

APP USER

C

AppUser

  

BAR AMOUNT

N

BarAmount

  

BAR FLT PCT

C

BarFltPct

  

BAR ROUNDING

C

BarRounding

  

BAR YN

C

BarFltPct

  

BEGIN DATE

D

BeginDate

Beginning Date

CHILD CHARGE 1

N

Childcharge1

  

CHILD CHARGE 2

N

Childcharge2

  

CHILD CHARGE 3

N

Childcharge3

  

CHILD OWN RATE 1

N

ChildOwnRate1

  

CHILD OWN RATE 2

N

ChildOwnRate2

  

CHILD OWN RATE 3

N

ChildOwnRate3

  

CHILD OWN RATE 4

N

ChildOwnRate4

  

CHILD RATE

N

ChildRate

  

CHILD RATE 1

N

ChildRate1

  

CHILD RATE 2

N

ChildRate2

  

CHILD RATE 3

N

ChildRate3

  

CHILD RATE EXC THRESHOLD 1

C

ChildRateExcThreshold1

  

CHILD RATE EXC THRESHOLD 2

C

ChildRateExcThreshold2

  

CHILD RATE EXC THRESHOLD 3

C

ChildRateExcThreshold3

  

CHILD RATE OWN 1

N

ChildOwnRate1

  

CHILD RATE OWN 2

N

ChildOwnRate2

  

CHILD RATE OWN 3

N

ChildOwnRate3

  

CHILDREN THRESHOLD

N

Childrenthreshold

  

CHILDREN THRESHOLD CHARGE

N

Childrenthresholdcharge

  

DAY 1

C

Day1

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

DAY 2

C

Day2

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

DAY 3

C

Day3

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

DAY 4

C

Day4

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

DAY 5

C

Day5

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

DAY 6

C

Day6

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

DAY 7

C

Day7

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

DIFF AMOUNT 1

N

DiffAmount1

  

DIFF AMOUNT 2

N

DiffAmount2

  

DIFF AMOUNT 3

N

DiffAmount3

  

DIFF AMOUNT 4

N

DiffAmount4

  

DIFF AMOUNT 5

N

DiffAmount5

  

DIFF AMOUNT EXTRA ADULT

N

DiffAmountExtraAdult

  

DIFF PERCENTAGE 1 YN

C

DiffPercentage1YN

  

DIFF PERCENTAGE 2 YN

C

DiffPercentage2YN

  

DIFF PERCENTAGE 3 YN

C

DiffPercentage3YN

  

DIFF PERCENTAGE 4 YN

C

DiffPercentage4YN

  

DIFF PERCENTAGE 5 YN

C

DiffPercentage5YN

  

DIFF PERCENTAGE EXTRA ADULT YN

C

DiffPercentageExtraAdultYN

  

END DATE

D

EndDate

  

EXTRA ADULT RATE

N

ExtraAdultRate

  

EXTRA ADULT TYPE

C

ExtraAdultType

  

MARKET CODE

C

MarketCode

  

MAXIMUM RATE PERSON 1

N

MaxRatePerson1

  

MAXIMUM RATE PERSON 2

N

MaxRatePerson2

  

MIN CHILDREN FOR FREE STAY

N

MinChildrenForFreeStay

  

MINIMUM RATE PERSON 1

N

MinRatePerson1

  

MINIMUM RATE PERSON 2

N

MinRatePerson2

  

NUM CHILDREN STAY FREE

N

NumChildrenStayFree

  

OCCUPANTS THRESHOLD

N

Occupantsthreshold

  

OCCUPANTS THRESHOLD CHARGE

N

Occupantsthresholdcharge

  

POINTS REQUIRED

N

pointsRequired

  

PRODUCT CODE

C

ProductCode

Package Code

RATE CODE

C

RateCode

  

ROOM TYPE

C

RoomType

  

SEASON CODE

C

SeasonCode

  

SOURCE CODE

C

SourceCode

  

TIER

C

Tier

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>.

UPDATE RATE SET ADJUSTMENT

ADJUSTMENT AMOUNT

N

YieldAdjustmentAmt

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

ADJUSTMENT CODE

C

YieldAdjustmentCode

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

ADJUSTMENT TYPE

C

YieldAdjustmentType

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

BEGIN DATE

D

BeginDate

Beginning Date

END DATE

D

EndDate

  

FLAT OR PERCENTAGE

C

FlatOrPercentage

  

RATE CODE

C

RateCode

  

ROOM TYPE

C

RoomType

  

UPDATE RATE STRATEGY

APPLY YN

C

ApplyYn

  

CONDITION TYPE

C

ConditionType

  

CONDITION VALUE

N

ConditionValue

  

CONDITION VALUE TYPE

C

ConditionValueType

  

CONTROL END DATE

D

ControlEndDate

  

CONTROL START DATE

D

ControlStartDate

  

COUNTER COND YN

C

CounterCondYn

  

DAY FIVE

C

DayFive

  

DAY FOUR

C

DayFour

  

DAY ONE

C

DayOne

  

DAY SEVEN

C

DaySeven

  

DAY SIX

C

DaySix

  

DAY THREE

C

DayThree

  

DAY TWO

C

DayTwo

  

DAYS IN ADVANCE FROM

N

DaysInAdvanceFrom

  

DAYS IN ADVANCE TO

N

DaysInAdvanceTo

  

EXTERNAL REFERENCE

C

ExternalReference

  

INACTIVE DATE

D

InactiveDate

  

OCCUPANCY BASED AMOUNT

N

OccupancyBasedAmount

  

OCCUPANCY BASED YN

C

OccupancyBasedYN

  

PHYSICAL

N

Physical

  

RATE CATEGORY

C

RateCategory

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

RATE CLASS

C

RateClass

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

RATE CODE

C

RateCode

  

RESTRICTION END DATE

D

RestrictionEndDate

  

RESTRICTION START DATE

D

RestrictionStartDate

  

RESTRICTION TYPE

C

RestrictionType

  

RESTRICTION VALUE

N

RestrictionValue

  

ROOM CLASS

C

RoomClass

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

ROOM TYPE

C

RoomType

  

SEQUENCE

N

Sequence

  

UPDATE RULE

BLOCK CODE

C

BlockCode

  

BLOCK ID

N

BlockId

  

CNL BEFORE TIME

T

CnlBeforeTime

  

CNL DAYS PRIOR TO ARRIVAL

N

CnlDaysPriorToArrival

  

CNL PENALTY AMOUNT

N

CnlPenaltyAmount

  

CNL PENALTY AMOUNT TYPE

C

CnlPenaltyAmountType

  

DEP AMOUNT

N

DepAmount

  

DEP AMOUNT TYPE

C

DepAmountType

  

DEP DAYS AFTER BOOKING

N

DepDaysAfterBooking

  

DEP DAYS PRIOR TO ARRIVAL

N

DepDaysPriorToArrival

  

RATE CODE

C

RateCode

  

RESERVATION TYPE

C

ReservationType

  

RULE BEGIN DATE

D

RuleBeginDate

  

RULE CODE

C

RuleCode

  

RULE END DATE

D

RuleEndDate

  

RULE TYPE

C

RuleType

  

SEASON CODE

C

RuleSeasonCode

  

UPDATE SEASON CODE

BEGIN DATE

D

BeginDate

Beginning Date

DESCRIPTION

C

Description

  

END DATE

D

EndDate

  

RATE CODE

C

RateCode

  

SEASON CODE

C

SeasonCode

  

UPDATE YIELD MARKET

ALTERNATIVE

C

Alternative

  

CODE

C

Code

  

DESCRIPTION

C

Description

  

Parent topic: Business Events Modules