|
|
|
Mapping Table between ORS, XML message and V6 PMS for BLOCKS
If (ORS Field Label) column below is blank, either this value is internally populated and there is no actual field on the block screen in ORS to view this value, or the value is populated from a field from a different table other than the block tables.
ORS Field Label |
ORS Table and Column |
XML Tag |
V6 DBF |
V6 Field |
Comment |
F_DESCRIPTION |
ALLOTMENT_HEADER. DESCRIPTION |
InventoryBlockName |
BLOCK |
FULLNAME |
|
F_BEGIN_DATE |
ALLOTMENT_HEADER. BEGIN_DATE |
startTime |
BLOCK |
STARTDATE |
|
NIGHTS |
|
numberOfTimeUnits |
BLOCK |
NIGHTS |
This is an internal field. The number of nights is calculated from the start date and end date of the block |
F_END_DATE |
ALLOTMENT_HEADER. END_DATE |
|
BLOCK |
ENDATE |
This is calculated from the start date and number of days in the block |
F_ALLOTMENT_CODE |
ALLOTMENT_HEADER. ALLOTMENT_CODE |
inventoryBlockGroupingCode |
BLOCK |
ALOTM |
Can only be 10 characters |
F_BOOKING_STATUS |
|
inventoryBlockStatusType |
BLOCK |
STATUS |
This is a combination of INITIAL/FORCEINITIAL/ACTIVEELASTIC/NONELASTIC- >INITIAL/ACTIVE |
F_GUARANTEE_CODE |
|
|
BLOCK |
RESTYPE |
CRS_LOCKED=T FOR ALL TENTATIVE BLOCKS.CRS_LOCKED=F FOR ALL DEFINITIVE BLOCKS |
F_RATE_CODE |
ALLOTMENT_HEADER. RATE_CODE |
RatePlanCodes |
BLOCK |
RATECODE |
|
F_INV_CUTOFF_DATE |
ALLOTMENT_HEADER. INV_CUTOFF_DATE |
MfCutoffDate |
BLOCK |
CUTDATE |
|
F_INV_CUTOFF_DAYS |
ALLOTMENT_HEADER. INV_CUTOFF_DAYS |
MfCutoffDays |
BLOCK |
CUTDAYS |
|
F_MARKET_CODE |
ALLOTMENT_HEADER. MARKET_CODE |
MfMarketCode |
BLOCK |
MARKET |
|
F_SOURCE |
ALLOTMENT_HEADER. SOURCE |
MfSourceCode |
BLOCK |
SCODE |
|
F_CHANNEL |
ALLOTMENT_HEADER. CHANNEL |
mfChannelCode |
BLOCK |
CHANNEL |
|
ELASTIC |
ALLOTMENT_HEADER. ELASTIC |
MfBlockType |
BLOCK |
ELASTIC |
|
|
ALLOTMENT_HEADER.INSERT_DATE |
createdDate |
BLOCK |
CREATED |
Takes PMS system date |
BUSINESS_BLOCK_ID |
|
MfAllotmentId |
BLOCK |
CRS_SRPID |
Once ORS delivers the block the details are only delivered once the crs_srpid is populated |
F_ALLOTMENT_CODE |
ALLOTMENT_HEADER.ALLOTMENT_CODE |
InventoryBlockGroupingCode |
GALLOTT |
ALTDESC |
|
F_BEGIN_DATE |
ALLOTMENT_DETAIL.ALLOTMENT_DATE |
mfInventoryDate |
GALLOTT |
DATUM |
Start date of the Block |
INITIALBLOCK |
ALLOTMENT_DETAIL. TO_SELLFORECASTED_TO_SELL |
numberToBlock |
GALLOTT |
ALLOTTEDORIGINAL |
|
F_CELL_I |
ALLOTMENT_DETAIL.ROOM_CATEGORY |
inventoryCode |
GALLOTT |
KAT |
1 record per room type per day |
F_INV_CTOFF_DATE |
ALLOTMENT_DETAIL.INV_CUTOFF_DATE |
MfCutoffDate |
GALLOTT |
CUTOFF |
|
F_GUARANTEE_CODE |
ALLOTMENT_DETAIL.GUARANTEE_CODE |
MfBlockType |
GALLOTT |
RESTYPE |
Not mapped through the interface |
F_RATE1 |
ALLOTMENT_DETAIL.RATE_AMOUNT_1 |
mfRate1 |
GALLOTT |
RATE1 |
|
F_RATE2 |
ALLOTMENT_DETAIL.RATE_AMOUNT_2 |
mfRate2 |
GALLOTT |
RATE2 |
|
F_RATE3 |
ALLOTMENT_DETAIL.RATE_AMOUNT_3 |
mfRate3 |
GALLOTT |
RATE3 |
|
F_RATE4 |
ALLOTMENT_DETAIL.RATE_AMOUNT_4 |
mfRate4 |
GALLOTT |
RATE4 |
|
