Business Events - Block Offsets

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

CREATE OFFSET GRID

ALLOTMENT_HEADER_ID

N

AllotmentHeaderId

 

BEGIN_DATE

D

BeginDate

 

END_DATE

D

EndDate

 

OCC1

N

Occ1

 

OCC2

N

Occ2

 

OCC3

N

Occ3

 

OCC4

N

Occ4

 

OFFSET_TYPE

C

OffsetType

 

PICKUP_OCC1

N

PickupOcc1

 

PICKUP_OCC2

N

PickupOcc2

 

PICKUP_OCC3

N

PickupOcc3

 

PICKUP_OCC4

N

PickupOcc4

 

PICKUP_QUANTITY

N

PickupQuantity

 

QUANTITY

N

Quantity

 

RATE1

N

Rate1

 

RATE2

N

Rate2

 

RATE3

N

Rate3

 

RATE4

N

Rate4

 

RATEAP

N

Rateap

 

RESORT

C

Resort

 

ROOM_CATEGORY

C

RoomCategory

 

ROOM_CLASS

C

RoomClass

 

SC_ROOM_CATEGORY

C

ScRoomCategory

 

CREATE OFFSET PRODUCT

ACTION_ID

N

ActionId

 

ALLOTMENT_HEADER_ID

N

AllotmentHeaderId

 

ALLOTMENT_PRODUCT_ID

N

AllotmentProductId

 

BEGIN_DATE

D

BeginDate

 

DML_SEQ_NO

N

DmlSeqNo

 

END_DATE

D

EndDate

 

LAPTOP_CHANGE

N

LaptopChange

 

OFFSET_TYPE

C

OffsetType

 

PRODUCT_GROUP

C

ProductGroup

 

PRODUCT_ID

C

ProductId

 

PRODUCT_SOURCE

C

ProductSource

 

QTY_EXCLUDED

N

QtyExcluded

 

QUANTITY

N

Quantity

 

RATE_CODE

C

RateCode

 

RESORT

C

Resort

 

CREATE OFFSET RATE

ALLOTMENT_HEADER_ID

N

AllotmentHeaderId

 

BEGIN_DATE

D

BeginDate

 

END_DATE

D

EndDate

 

OFFSET_TYPE

C

OffsetType

 

PRIMARY_YN

C

PrimaryYn

 

RATE_CODE

C

RateCode

 

RECORD_TYPE

C

RecordType

 

RESORT

C

Resort

 

CREATE OFFSET TYPE

ALLOTMENT_HEADER_ID

N

AllotmentHeaderId

 

IGNORE_OFFSET_YN

C

IgnoreOffsetYn

 

INACTIVE_DATE

D

InactiveDate

 

OFFSET_TYPE

C

OffsetType

 

RESORT

C

Resort

 

DELETE OFFSET GRID

ALLOTMENT_DATE

D

AllotmentDate

 

ALLOTMENT_HEADER_ID

N

AllotmentHeaderId

 

BEGIN_DATE

D

BeginDate

 

END_DATE

D

EndDate

 

OFFSET_TYPE

C

OffsetType

 

RESORT

C

Resort

 

ROOM_CATEGORY

C

RoomCategory

 

DELETE OFFSET PRODUCT

ALLOTMENT_HEADER_ID

N

AllotmentHeaderId

 

ALLOTMENT_PRODUCT_ID

N

AllotmentProductId

 

BEGIN_DATE

D

BeginDate

 

END_DATE

D

EndDate

 

OFFSET_TYPE

C

OffsetType

 

PRODUCT_ID

C

ProductId

 

RESORT

C

Resort

 

DELETE OFFSET RATE

ALLOTMENT_HEADER_ID

N

AllotmentHeaderId

 

OFFSET_TYPE

C

OffsetType

 

RATE_CODE

C

RateCode

 

RECORD_TYPE

C

RecordType

 

RESORT

C

Resort

 

DELETE OFFSET TYPE

ALLOTMENT_HEADER_ID

N

AllotmentHeaderId

 

OFFSET_TYPE

C

OffsetType

 

RESORT

C

Resort

 

UPDATE OFFSET GRID

ALLOTMENT_HEADER_ID

N

AllotmentHeaderId

 

BEGIN_DATE

D

BeginDate

 

END_DATE

D

EndDate

 

OCC1

N

Occ1

 

OCC2

N

Occ2

 

OCC3

N

Occ3

 

OCC4

N

Occ4

 

OFFSET_TYPE

C

OffsetType

 

PICKUP_OCC1

N

PickupOcc1

 

PICKUP_OCC2

N

PickupOcc2

 

PICKUP_OCC3

N

PickupOcc3

 

PICKUP_OCC4

N

PickupOcc4

 

PICKUP_QUANTITY

N

PickupQuantity

 

QUANTITY

N

Quantity

 

RATE1

N

Rate1

 

RATE2

N

Rate2

 

RATE3

N

Rate3

 

RATE4

N

Rate4

 

RATEAP

N

Rateap

 

RESORT

C

Resort

 

ROOM_CATEGORY

C

RoomCategory

 

ROOM_CLASS

C

RoomClass

 

SC_ROOM_CATEGORY

C

ScRoomCategory

 

UPDATE OFFSET PRODUCT

ACTION_ID

N

ActionId

 

ALLOTMENT_HEADER_ID

N

AllotmentHeaderId

 

ALLOTMENT_PRODUCT_ID

N

AllotmentProductId

 

BEGIN_DATE

D

BeginDate

 

DML_SEQ_NO

N

DmlSeqNo

 

END_DATE

D

EndDate

 

LAPTOP_CHANGE

N

LaptopChange

 

OFFSET_TYPE

C

OffsetType

 

PRODUCT_GROUP

C

ProductGroup

 

PRODUCT_ID

C

ProductId

 

PRODUCT_SOURCE

C

ProductSource

 

QTY_EXCLUDED

N

QtyExcluded

 

QUANTITY

N

Quantity

 

RATE_CODE

C

RateCode

 

RESORT

C

Resort

 

UPDATE OFFSET RATE

ALLOTMENT_HEADER_ID

N

AllotmentHeaderId

 

BEGIN_DATE

D

BeginDate

 

END_DATE

D

EndDate

 

OFFSET_TYPE

C

OffsetType

 

PRIMARY_YN

C

PrimaryYn

 

RATE_CODE

C

RateCode

 

RECORD_TYPE

C

RecordType

 

RESORT

C

Resort

 

UPDATE OFFSET TYPE

ALLOTMENT_HEADER_ID

N

AllotmentHeaderId

 

IGNORE_OFFSET_YN

C

IgnoreOffsetYn

 

INACTIVE_DATE

D

InactiveDate

 

OFFSET_TYPE

C

OffsetType

 

RESORT

C

Resort

 

SYNC ALL OFFSETS

C

SyncAllOffsets