|
|
|
RESVEXPORT Data Definition
The Checkedout Reservations Export is automatically generated and transmitted to the application server during the Night Audit procedure in Opera. But this export can be manually ran by selecting Miscellaneous>File Export>General or Configuration>External>Export Files. This export file is available on-demand, to allow for external and local resources to produce more up to the minute information in case of an emergency. The file transfer from Opera to the database is completed by using the Opera OXI_HUB Interface, with an HTTP address that is setup for the actual export file itself (See Export Files for details).
FILE_GROUP_ID |
FILE_TYPE_DESC |
FILE and ZIP_FILE_NAME |
FILE_EXTENSION |
MISC |
Checkedout Reservations Export |
'WY_296' |
TXT |
COL_NAME |
COL_LENGTH |
COL_TYPE |
FORMULA |
|---|---|---|---|
UPDATE_TIME |
40 |
FORMULA |
chr(13)||chr(10)||'114LAST_TIME '||TO_CHAR(UPDATE_DATE,'HH:MI:SS') |
UPDATE_DATE |
40 |
FORMULA |
chr(13)||chr(10)||'115LAST_DATE '||TO_CHAR(UPDATE_DATE,'YYYYMMDD') |
CC_USAGE |
20 |
FORMULA |
chr(13)||chr(10)||'116CC_USAGE' |
ROW_SEQUENCE |
25 |
FORMULA |
chr(13)||chr(10)||'117SEQUENCE_NO '||TO_CHAR(ROWNUM) |
PROPERTY_CODE |
40 |
FORMULA |
chr(13)||chr(10)||'118RESORT '||PROPERTY_CODE |
WYNDHAM_CREDIT_CARD |
40 |
FORMULA |
chr(13)||chr(10)||'119WY_CC' |
GUEST_NAME_ID |
40 |
FORMULA |
chr(13)||chr(10)||'003GASTNR '||to_char(guest_name_id) |
GUEST_LAST_NAME |
40 |
FORMULA |
chr(13)||chr(10)||'004GASTNAME '||guest_last_name |
ARRIVAL_DATE |
40 |
FORMULA |
chr(13)||chr(10)||'005ANREISE '||to_char(arrival_date,'YYYYMMDD') |
DEPARTURE_DATE |
40 |
FORMULA |
chr(13)||chr(10)||'006ABREISE '||to_char(departure_date,'YYYYMMDD') |
BLOCK_CODE |
40 |
FORMULA |
chr(13)||chr(10)||'060ALOTM '||BLOCK_CODE |
DEPOSIT_DATE_2 |
40 |
FORMULA |
chr(13)||chr(10)||'061LIMIT2' |
CANCELLATION_REASON |
40 |
FORMULA |
chr(13)||chr(10)||'062MEMO '||CANCELLATION_REASON |
MARKET_CODE_1 |
40 |
FORMULA |
chr(13)||chr(10)||'063MARKET '||MARKET_CODE_1 |
COMPLIMENTARY_YN |
25 |
FORMULA |
chr(13)||chr(10)||'064COMP '||COMPLIMENTARY_YN |
SOURCE_C0DE |
40 |
FORMULA |
chr(13)||chr(10)||'065SCODE '||source_code |
PAYMENT_CODE |
40 |
FORMULA |
chr(13)||chr(10)||'066PMETHOD '||payment_code |
OBA |
10 |
FORMULA |
chr(13)||chr(10)||'067OBA' |
CREDIT_CARD_NO |
40 |
FORMULA |
chr(13)||chr(10)||'068CREDITCARD '||CREDIT_CARD_NO |
CREDIT_CARD_EXPIRATION |
40 |
FORMULA |
chr(13)||chr(10)||'069EXPY '||TO_CHAR(CREDIT_CARD_EXPIRATION,'YYYYMMDD') |
RESV_NAME_ID |
40 |
FORMULA |
chr(13)||chr(10)||'070REGISTER '||to_char(RESV_NAME_ID) |
BILLING |
15 |
FORMULA |
chr(13)||chr(10)||'071BILLLING' |
RESERVATION_FOLIO_NUMBER |
40 |
FORMULA |
chr(13)||chr(10)||'072RNR '||TO_CHAR(RESERVATION_FOLIO_NUMBER) |
ACCOMPANYING_NAME_1 |
40 |
FORMULA |
chr(13)||chr(10)||'073BEGL1 '||ACCOMPANYING_NAME_1 |
ACCOMPANYING_BIRTHDAY_2 |
40 |
FORMULA |
chr(13)||chr(10)||'076GEB2 '||TO_CHAR(ACCOMPANYING_BIRTHDAY_2,'YYYYMMDD') |
Cl_AUTHORIZED_YN |
40 |
FORMULA |
chr(13)||chr(10)||'077AUTHORIZE '||CL_AUTHORIZED_YN |
RESV_CONF_LETTER_ID |
40 |
FORMULA |
chr(13)||chr(10)||'078CONFIRM '||TO_CHAR(RESV_CONF_LETTER_ID) |
RESERVATION_INSERT_USER_ID |
40 |
FORMULA |
chr(13)||chr(10)||'079USERID '||TO_CHAR(RESERVATION_INSERT_USER_ID) |
DISCOUNT |
20 |
FORMULA |
chr(13)||chr(10)||'080DISCOUNT' |
DEDUCTPCT |
20 |
FORMULA |
chr(13)||chr(10)||'081DEDUCTPCT' |
PACKAGES |
40 |
FORMULA |
chr(13)||chr(10)||'082PACKAGES '||PACKAGES |
PACKAGES_OTHER_REVENUE |
10 |
FORMULA |
chr(13)||chr(10)||'083PEXTRAS' |
MESSAGE |
20 |
FORMULA |
chr(13)||chr(10)||'084MESSAGE' |
EXCHANGE_RATE |
40 |
FORMULA |
chr(13)||chr(10)||'085EXCH_RATE '||to_char(EXCHANGE_RATE) |
ACTUAL_CHECK_OUT_DATE |
40 |
FORMULA |
chr(13)||chr(10)||'086CO_TIME '||TO_CHAR(ACTUAL_CHECK_OUT_DATE,'HH:MI:SS') |
CURRENCY_CODE |
30 |
FORMULA |
chr(13)||chr(10)||'087EXCH_LNR '||CURRENCY_CODE |
PROFORMA |
10 |
FORMULA |
chr(13)||chr(10)||'088PROFORMA' |
GUEST_SPECIALS_CODES |
40 |
FORMULA |
chr(13)||chr(10)||'089SPECIALS '||GUEST_SPECIALS_CODES |
RATE_ROOM_TYPE |
35 |
FORMULA |
chr(13)||chr(10)||'090RATE_KAT '||RATE_ROOM_TYPE |
CREDIT_CARD_APPROVAL_CODE |
40 |
FORMULA |
chr(13)||chr(10)||'091APPR_CODE '||CREDIT_CARD_APPROVAL_CODE |
CREDIT_CARD_APPROVAL_AMOUNT |
40 |
FORMULA |
chr(13)||chr(10)||'092APPR_AMNT '||TO_CHAR(CREDIT_CARD_APPROVAL_AMOUNT) |
CHANNEL_CODE |
40 |
FORMULA |
chr(13)||chr(10)||'093CHANNEL '||CHANNEL_CODE |
DISCOUNT_AMOUNT |
40 |
FORMULA |
chr(13)||chr(10)||'094RATEDIFF '||TO_CHAR(DISCOUNT_AMOUNT) |
CRS_CONFIRMATION_NO |
40 |
FORMULA |
chr(13)||chr(10)||'095CRSRESNR '||CRS_CONFIRMATION_NO |
AGENT_COMMISION_SENT |
20 |
FORMULA |
chr(13)||chr(10)||'096COMM_SENT' |
SOURCE_COMMISION_SENT |
20 |
FORMULA |
chr(13)||chr(10)||'097SRC_SENT' |
L_FOLPRT |
20 |
FORMULA |
chr(13)||chr(10)||'098L_FOLPRT' |
GUEST_FAX |
25 |
FORMULA |
chr(13)||chr(10)||'099TELEFAX '||GUEST_FAX |
GUEST_INTERESTS |
20 |
FORMULA |
chr(13)||chr(10)||'100INTEREST' |
AIRLINE_MEMBER_TYPE |
40 |
FORMULA |
chr(13)||chr(10)||'101FFPTYPE '||AIRLINE_MEMBER_TYPE |
ACCOMPANYING_NAME_3 |
40 |
FORMULA |
chr(13)||chr(10)||'102BEGL3 '||ACCOMPANYING_NAME_3 |
CREDIT_CARD_NAME_ON_CARD |
40 |
FORMULA |
chr(13)||chr(10)||'103CC_NAME '||CREDIT_CARD_NAME_ON_CARD |
ACCOMPANYING_BIRTHDAY_1 |
40 |
FORMULA |
chr(13)||chr(10)||'074GEB1 '||TO_CHAR(ACCOMPANYING_BIRTHDAY_1,'YYYYMMDD') |
ACCOMPANYING_NAME_2 |
40 |
FORMULA |
chr(13)||chr(10)||'075BEGL2 '||ACCOMPANYING_NAME_2 |
CONSIDERED_DATE |
30 |
FORMULA |
'000DATE '||TO_CHAR(CONSIDERED_DATE,'YYYYMMDD') |
VIDEO_CHECKOUT_YN |
30 |
FORMULA |
chr(13)||chr(10)||'104VID_CHKO '||VIDEO_CHECKOUT_YN |
ROOM_CHANGE_DATE |
10 |
FORMULA |
chr(13)||chr(10)||'059UMZUG' |
HURDLE_VALUE |
40 |
FORMULA |
chr(13)||chr(10)||'105HURDLE '||TO_CHAR(HURDLE_VALUE) |
HURDLE_OVERRIDE_YN |
25 |
FORMULA |
chr(13)||chr(10)||'106HURDLE_OVR '||HURDLE_OVERRIDE_YN |
LOYALTY_MEMBER_NO |
40 |
FORMULA |
chr(13)||chr(10)||'107FFPNUM '||LOYALTY_MEMBER_NO |
LOYALTY_MEMBER_EXPIRATION |
40 |
FORMULA |
chr(13)||chr(10)||'108FFEXPY '||TO_CHAR(LOYALTY_MEMBER_EXPIRATION,'YYYYMMDD') |
ORG_KAT |
20 |
FORMULA |
chr(13)||chr(10)||'109ORG_KAT' |
ORG_ZIMMER |
20 |
FORMULA |
chr(13)||chr(10)||'110ORG_ZIMMER' |
ORG_ABREIS |
20 |
FORMULA |
chr(13)||chr(10)||'111ORG_ABREIS' |
ORG_ZEIT |
20 |
FORMULA |
chr(13)||chr(10)||'112ORG_ZEIT' |
RESERVATION_UPDATE_USER_ID |
40 |
FORMULA |
chr(13)||chr(10)||'113LAST_WHO '||TO_CHAR(RESERVATION_UPDATE_USER_ID) |
RATE_CODE |
25 |
FORMULA |
chr(13)||chr(10)||'030PCODE '||RATE_CODE |
PREF_ROOM |
10 |
FORMULA |
chr(13)||chr(10)||'031AKZ' |
DEPOSIT |
40 |
FORMULA |
chr(13)||chr(10)||'032DEPOSIT '||TO_CHAR(DEPOSIT_AMOUNT) |
CANCELLATION_DATE |
40 |
FORMULA |
chr(13)||chr(10)||'033STORNO '||TO_CHAR(CANCELLATION_DATE,'YYYYMMDD') |
DISCOUNT_PRCNT |
20 |
FORMULA |
chr(13)||chr(10)||'034DRKZ' |
RATE_FOLIO_TEXT |
40 |
FORMULA |
chr(13)||chr(10)||'035BEGL4 '||RATE_FOLIO_TEXT |
RESERVATION_COMMENTS |
100 |
FORMULA |
chr(13)||chr(10)||'036RTXT '||RESERVATION_COMMENTS |
CHECKIN FLAG |
25 |
FORMULA |
chr(13)||chr(10)||'037CHECK '||CHECK_IN_FLAG |
CHECKOUT FLAG |
25 |
FORMULA |
chr(13)||chr(10)||'038LFDNR '||CHECK_OUT_FLAG |
RHYTHM_SHEETS |
25 |
FORMULA |
chr(13)||chr(10)||'039RHYTW '||TO_CHAR(RHYTHM_SHEETS) |
RHYTHM_TOWELS |
25 |
FORMULA |
chr(13)||chr(10)||'040RHYTH '||TO_CHAR(RHYTHM_TOWELS) |
CONFIRMATION_LETTER_ID |
30 |
FORMULA |
chr(13)||chr(10)||'041POINTER '||TO_CHAR(CONFIRMATION_LETTER_ID) |
RESERVATION_ROOM_REVENUE |
40 |
FORMULA |
chr(13)||chr(10)||'042UMFIX '||TO_CHAR(RESERVATION_ROOM_REVENUE) |
RESERVATION_OTHER_REVENUE |
40 |
FORMULA |
chr(13)||chr(10)||'043UMEXTRA '||to_char(RESERVATION_OTHER_REVENUE) |
RESERVATION_CREDIT |
40 |
FORMULA |
chr(13)||chr(10)||'044GUTH '||TO_CHAR(RESERVATION_CREDIT) |
LAST_FIX_CHARGES_POST_DATE |
40 |
FORMULA |
chr(13)||chr(10)||'045FDAT' |
RESERVATION_FOLIO_TEXT |
40 |
FORMULA |
chr(13)||chr(10)||'046RT3' |
AGENT_NAME |
40 |
FORMULA |
chr(13)||chr(10)||'047RT4 '||AGENT_NAME |
GROUP_NAME |
40 |
FORMULA |
chr(13)||chr(10)||'048RT5 '||GROUP_NAME |
SOURCE_NAME |
40 |
FORMULA |
chr(13)||chr(10)||'049RT6 '||SOURCE_NAME |
COMPANY_GROUP_NAME |
40 |
FORMULA |
chr(13)||chr(10)||'050RT7 '||COMPANY_GROUP_NAME |
TOTAL_DEPOSIT_PAID |
40 |
FORMULA |
chr(13)||chr(10)||'051VKZ '||TO_CHAR(TOTAL_DEPOSIT_PAID) |
DEPOSIT_PAY_DATE |
40 |
FORMULA |
chr(13)||chr(10)||'052VZDAT '||TO_CHAR(DEPOSIT_PAY_DATE,'YYYYMMDD') |
GUARANTEE_CODE |
40 |
FORMULA |
chr(13)||chr(10)||'001BA '||guarantee_code |
KONT |
25 |
FORMULA |
chr(13)||chr(10)||'002KONT' |
GROUP_NAME_ID |
40 |
FORMULA |
chr(13)||chr(10)||'053GROUP '||TO_CHAR(GROUP_NAME_ID) |
AGENT_NAME_ID |
40 |
FORMULA |
chr(13)||chr(10)||'054TRAVEL '||TO_CHAR(AGENT_NAME_ID) |
SOURCE_NAME_ID |
40 |
FORMULA |
chr(13)||chr(10)||'055SOURCE '||TO_CHAR(SOURCE_NAME_ID) |
COMPANY_NAME_ID |
40 |
FORMULA |
chr(13)||chr(10)||'056COMPANY '||TO_CHAR(COMPANY_NAME_ID) |
AGENT_COMMISION_PRCNT |
15 |
FORMULA |
chr(13)||chr(10)||'057TRAVELPCT' |
SOURCE_COMMISION_PRCNT |
15 |
FORMULA |
chr(13)||chr(10)||'058SOURCEPCT' |
ROOM_TYPE |
40 |
FORMULA |
chr(13)||chr(10)||'007KAT '||room_type |
NO_OF_ROOMS |
25 |
FORMULA |
chr(13)||chr(10)||'008ANZ '||TO_CHAR(NO_OF_ROOMS) |
PREFERRED_ROOM_TYPE |
40 |
FORMULA |
chr(13)||chr(10)||'009WKAT '||PREFERRED_ROOM_TYPE |
ROOM |
25 |
FORMULA |
chr(13)||chr(10)||'010ZIMMER '||ROOM |
PREF_ROOM |
20 |
FORMULA |
chr(13)||chr(10)||'011WZIMMER' |
ADULTS |
25 |
FORMULA |
chr(13)||chr(10)||'012ERW '||TO_CHAR(ADULTS) |
CHILDREN |
25 |
FORMULA |
chr(13)||chr(10)||'013KIN '||TO_CHAR(CHILDREN) |
EXTRA_BEDS |
10 |
FORMULA |
chr(13)||chr(10)||'014ZB' |
CRIBS |
10 |
FORMULA |
chr(13)||chr(10)||'015KB' |
TIME_OF_ARRIVAL |
40 |
FORMULA |
chr(13)||chr(10)||'016ZEIT '||TO_CHAR(ARRIVAL_DATE,'HH:MI:SS') |
INSERT_DATE |
40 |
FORMULA |
chr(13)||chr(10)||'017AM '||TO_CHAR(INSERT_DATE,'YYYYMMDD') |
UPDATE_DATE |
40 |
FORMULA |
chr(13)||chr(10)||'018AENDERUNG '||TO_CHAR(UPDATE_DATE,'YYYYMMDD') |
CONFIRMATION_LETTER |
40 |
FORMULA |
chr(13)||chr(10)||'019BESTG '||CONFIRMATION_LETTER |
CONFIRMATION_LETTER_PRINT_DATE |
40 |
FORMULA |
chr(13)||chr(10)||'020DRUCK '||TO_CHAR(CONFIRMATION_LETTER_PRINT_DATE,'YYYYMMDD') |
DISPLAY_COLOR |
40 |
FORMULA |
chr(13)||chr(10)||'021AN '||DISPLAY_COLOR |
DEPOSIT_DUE_DATE |
40 |
FORMULA |
chr(13)||chr(10)||'022LIMIT '||TO_CHAR(DEPOSIT_DUE_DATE,'YYYYMMDD') |
SHARE_AMOUNT |
40 |
FORMULA |
chr(13)||chr(10)||'023PREIS '||to_char(share_amount) |
RKZ1 |
10 |
FORMULA |
chr(13)||chr(10)||'024RKZ1' |
RKZ2 |
10 |
FORMULA |
chr(13)||chr(10)||'025RKZ2' |
RKZ3 |
10 |
FORMULA |
chr(13)||chr(10)||'026RKZ3' |
RKZ4 |
10 |
FORMULA |
chr(13)||chr(10)||'027RKZ4' |
RKZ5 |
10 |
FORMULA |
chr(13)||chr(10)||'028RKZ5' |
RKZ6 |
10 |
FORMULA |
chr(13)||chr(10)||'029RKZ6' |
See Also
