|
|
|
PROFEXPORT Data Definition
The Profiles 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 & ZIP_FILE_NAME |
FILE_EXTENSION |
|---|---|---|---|
MISC |
Profiles Export |
'WY_296' |
TXT |
COL_NAME |
COL_LENGTH |
COL_TYPE |
FORMULA |
|---|---|---|---|
MEMBER_CARD_EXPIRATION2 |
40 |
FORMULA |
chr(13)||chr(10)||'109CARDEXPY '||TO_CHAR(MEMBER_CARD_EXPIRATION2,'YYYYMMDD') |
MEMBER_CARD_LEVEL2 |
40 |
FORMULA |
chr(13)||chr(10)||'110MISC_1 '||rtrim(MEMBER_CARD_LEVEL2) |
MEMBER_CARD_TYPE3 |
40 |
FORMULA |
chr(13)||chr(10)||'111CARDTYPE '||MEMBER_CARD_TYPE3 |
MEMBER_CARD_NO3 |
40 |
FORMULA |
chr(13)||chr(10)||'112CARDNR '||MEMBER_CARD_NO3 |
MEMBER_CARD_EXPIRATION3 |
40 |
FORMULA |
chr(13)||chr(10)||'113CARDEXPY '||TO_CHAR(MEMBER_CARD_EXPIRATION3,'YYYYMMDD') |
MEMBER_CARD_LEVEL3 |
40 |
FORMULA |
chr(13)||chr(10)||'114MISC_1 '||MEMBER_CARD_LEVEL3 |
MEMBER_CARD_TYPE4 |
40 |
FORMULA |
chr(13)||chr(10)||'115CARDTYPE '||MEMBER_CARD_TYPE4 |
MEMBER_CARD_NO4 |
40 |
FORMULA |
chr(13)||chr(10)||'116CARDNR '||MEMBER_CARD_NO4 |
MEMBER_CARD_EXPIRATION4 |
40 |
FORMULA |
chr(13)||chr(10)||'117CARDEXPY '||TO_CHAR(MEMBER_CARD_EXPIRATION4,'YYYYMMDD') |
MEMBER_CARD_LEVEL4 |
40 |
FORMULA |
chr(13)||chr(10)||'118MISC_1 '||MEMBER_CARD_LEVEL4 |
MEMBER_CARD_TYPE5 |
40 |
FORMULA |
chr(13)||chr(10)||'119CARDTYPE '||MEMBER_CARD_TYPE5 |
MEMBER_CARD_NO5 |
40 |
FORMULA |
chr(13)||chr(10)||'120CARDNR '||MEMBER_CARD_NO5 |
MEMBER_CARD_EXPIRATION5 |
40 |
FORMULA |
chr(13)||chr(10)||'121CARDEXPY '||TO_CHAR(MEMBER_CARD_EXPIRATION5,'YYYYMMDD') |
MEMBER_CARD_LEVEL5 |
40 |
FORMULA |
chr(13)||chr(10)||'122MISC_1 '||MEMBER_CARD_LEVEL5 |
MEMBER_CARD_TYPE6 |
40 |
FORMULA |
chr(13)||chr(10)||'123CARDTYPE '||MEMBER_CARD_TYPE6 |
MEMBER_CARD_NO6 |
40 |
FORMULA |
chr(13)||chr(10)||'124CARDNR '||MEMBER_CARD_NO6 |
MEMBER_CARD_EXPIRATION6 |
40 |
FORMULA |
chr(13)||chr(10)||'125CARDEXPY '||TO_CHAR(MEMBER_CARD_EXPIRATION6,'YYYYMMDD') |
MEMBER_CARD_LEVEL6 |
40 |
FORMULA |
chr(13)||chr(10)||'126MISC_1 '||MEMBER_CARD_LEVEL6 |
MEMBER_CARD_TYPE7 |
40 |
FORMULA |
chr(13)||chr(10)||'127CARDTYPE '||MEMBER_CARD_TYPE7 |
MEMBER_CARD_NO7 |
40 |
FORMULA |
chr(13)||chr(10)||'128CARDNR '||MEMBER_CARD_NO7 |
MEMBER_CARD_EXPIRATION7 |
40 |
FORMULA |
chr(13)||chr(10)||'129CARDEXPY '||TO_CHAR(MEMBER_CARD_EXPIRATION7,'YYYYMMDD') |
MEMBER_CARD_LEVEL7 |
40 |
FORMULA |
chr(13)||chr(10)||'130MISC_1 '||MEMBER_CARD_LEVEL7 |
MEMBER_CARD_TYPE8 |
40 |
FORMULA |
chr(13)||chr(10)||'131CARDTYPE '||MEMBER_CARD_TYPE8 |
MEMBER_CARD_NO8 |
40 |
FORMULA |
chr(13)||chr(10)||'132CARDNR '||MEMBER_CARD_NO8 |
MEMBER_CARD_EXPIRATION8 |
40 |
FORMULA |
chr(13)||chr(10)||'133CARDEXPY '||TO_CHAR(MEMBER_CARD_EXPIRATION8,'YYYYMMDD') |
POTENTIAL_REVENUE |
40 |
FORMULA |
chr(13)||chr(10)||'062POTREV '||TO_CHAR(POTENTIAL_REVENUE) |
MAILING_CODES |
40 |
FORMULA |
chr(13)||chr(10)||'063MAILING '||MAILING_CODES |
POTENTIAL_ROOM_NIGHTS |
40 |
FORMULA |
chr(13)||chr(10)||'064POTNIGHTS '||TO_CHAR(POTENTIAL_ROOM_NIGHTS) |
CURRENCY_CODE |
40 |
FORMULA |
chr(13)||chr(10)||'065TACURRENCY '||CURRENCY_CODE |
COMMISION_CODE |
40 |
FORMULA |
chr(13)||chr(10)||'066COMM_CODE'||COMMISION_CODE |
BLACK_LIST_MESSAGE |
40 |
FORMULA |
chr(13)||chr(10)||'067BL_MESSAGE '||BLACK_LIST_MESSAGE |
INTEREST |
40 |
FORMULA |
chr(13)||chr(10)||'068INTEREST '||INTEREST |
LOYALTY_MEMBER_TYPE |
40 |
FORMULA |
chr(13)||chr(10)||'069MEMBERTYPE '||LOYALTY_MEMBER_TYPE |
GUEST_INSERT_USER_ID |
40 |
FORMULA |
chr(13)||chr(10)||'070USERID '||TO_CHAR(GUEST_INSERT_USER_ID) |
PASSPORT |
40 |
FORMULA |
chr(13)||chr(10)||'071PASS '||PASSPORT |
PASSPORT1 |
15 |
FORMULA |
chr(13)||chr(10)||'072PASSPORT' |
SPECIALS_CODES |
40 |
FORMULA |
chr(13)||chr(10)||'073SPECIALS '||SPECIALS_CODES |
SPECIAL2 |
12 |
FORMULA |
chr(13)||chr(10)||'074SPECIAL2' |
TOTAL_ARRIVAL_LAST_YEAR |
40 |
FORMULA |
chr(13)||chr(10)||'075VJANREIS '||TO_CHAR(TOTAL_ARRIVAL_LAST_YEAR) |
KZ4 |
10 |
FORMULA |
chr(13)||chr(10)||'076KZ4' |
SCREENNAME |
15 |
FORMULA |
chr(13)||chr(10)||'077SCREENNAME' |
UPDATE_USER |
40 |
FORMULA |
chr(13)||chr(10)||'078LAST_WHO '||TO_CHAR(UPDATE_USER) |
UPDATE_TIME |
40 |
FORMULA |
chr(13)||chr(10)||'079LAST_TIME '||TO_CHAR(UPDATE_DATE,'HH:MI:SS') |
UPDATE_DATE |
40 |
FORMULA |
chr(13)||chr(10)||'080LAST_DATE '||TO_CHAR(UPDATE_DATE,'YYYYMMDD') |
DID_1 |
10 |
FORMULA |
chr(13)||chr(10)||'081DID_1' |
DID_2 |
10 |
FORMULA |
chr(13)||chr(10)||'082DID_2' |
DID_3 |
10 |
FORMULA |
chr(13)||chr(10)||'083DID_3' |
DID_4 |
10 |
FORMULA |
chr(13)||chr(10)||'084DID_4' |
DID_5 |
10 |
FORMULA |
chr(13)||chr(10)||'085DID_5' |
ROW_SEQUENCE |
30 |
FORMULA |
chr(13)||chr(10)||'086SEQUENCE_NO '||TO_CHAR(ROWNUM) |
GENDER |
10 |
FORMULA |
chr(13)||chr(10)||'087SEX' |
CREDIT_CARD_TYPE1 |
40 |
FORMULA |
chr(13)||chr(10)||'088CARDTYPE '||CREDIT_CARD_TYPE1 |
CREDIT_CARD_NO1 |
40 |
FORMULA |
chr(13)||chr(10)||'089CARDNR '||CREDIT_CARD_NO1 |
CREDIT_CARD_EXPIRATION1 |
40 |
FORMULA |
chr(13)||chr(10)||'090CARDEXPY '||TO_CHAR(CREDIT_CARD_EXPIRATION1,'YYYYMMDD') |
CREDIT_CARD_TYPE2 |
40 |
FORMULA |
chr(13)||chr(10)||'091CARDTYPE '||CREDIT_CARD_TYPE2 |
CREDIT_CARD_NO2 |
40 |
FORMULA |
chr(13)||chr(10)||'092CARDNR '||CREDIT_CARD_NO2 |
CREDIT_CARD_EXPIRATION2 |
40 |
FORMULA |
chr(13)||chr(10)||'093CARDEXPY '||TO_CHAR(CREDIT_CARD_EXPIRATION2,'YYYYMMDD') |
MEMBER_CARD_LEVEL8 |
40 |
FORMULA |
chr(13)||chr(10)||'134MISC_1 '||MEMBER_CARD_LEVEL8 |
MEMBER_CARD_TYPE9 |
40 |
FORMULA |
chr(13)||chr(10)||'135CARDTYPE '||MEMBER_CARD_TYPE9 |
MEMBER_CARD_NO9 |
40 |
FORMULA |
chr(13)||chr(10)||'136CARDNR '||MEMBER_CARD_NO9 |
MEMBER_CARD_EXPIRATION9 |
40 |
FORMULA |
chr(13)||chr(10)||'137CARDEXPY '||TO_CHAR(MEMBER_CARD_EXPIRATION9,'YYYYMMDD') |
MEMBER_CARD_LEVEL9 |
40 |
FORMULA |
chr(13)||chr(10)||'138MISC_1 '||MEMBER_CARD_LEVEL9 |
MEMBER_CARD_TYPE10 |
40 |
FORMULA |
chr(13)||chr(10)||'139CARDTYPE '||MEMBER_CARD_TYPE10 |
MEMBER_CARD_NO10 |
40 |
FORMULA |
chr(13)||chr(10)||'140CARDNR '||MEMBER_CARD_NO10 |
MEMBER_CARD_EXPIRATION10 |
40 |
FORMULA |
chr(13)||chr(10)||'141CARDEXPY '||TO_CHAR(MEMBER_CARD_EXPIRATION10,'YYYYMMDD') |
MEMBER_CARD_LEVEL10 |
40 |
FORMULA |
chr(13)||chr(10)||'142MISC_1 '||MEMBER_CARD_LEVEL10 |
MASTER_ACCOUNT_CODE |
40 |
FORMULA |
chr(13)||chr(10)||'143CARDNR '||MASTER_ACCOUNT_CODE |
MASTER_ACCOUNT_NAME |
40 |
FORMULA |
chr(13)||chr(10)||'144MISC_1 '||MASTER_ACCOUNT_NAME |
CRS_NAMEID |
40 |
FORMULA |
chr(13)||chr(10)||'145CRS_NAMEID '||TO_CHAR(CRS_NAMEID) |
PROPERTY_CODE |
40 |
FORMULA |
chr(13)||chr(10)||'146RESORT '||PROPERTY_CODE |
40 |
FORMULA |
chr(13)||chr(10)||'147EMAIL '||EMAIL |
|
NAME_ID |
40 |
FORMULA |
chr(13)||chr(10)||'001NUMMER '||TO_CHAR(NAME_ID) |
TITLE_CODE |
40 |
FORMULA |
chr(13)||chr(10)||'002ANREDE '||TITLE_CODE |
SALUTATION |
40 |
FORMULA |
chr(13)||chr(10)||'003PANREDE '||SALUTATION |
LANGUAGE |
20 |
FORMULA |
chr(13)||chr(10)||'004SPRACHE '||LANGUAGE |
LAST_NAME |
40 |
FORMULA |
chr(13)||chr(10)||'005NAME '||LAST_NAME |
FIRST_NAME |
40 |
FORMULA |
chr(13)||chr(10)||'006VORNAME '||FIRST_NAME |
BUSINESS_TITLE |
40 |
FORMULA |
chr(13)||chr(10)||'007TITEL '||BUSINESS_TITLE |
COMPANY_NAME |
40 |
FORMULA |
chr(13)||chr(10)||'008FIRMA '||COMPANY_NAME |
ADDRESS_1 |
40 |
FORMULA |
chr(13)||chr(10)||'009STRASSE1 '||ADDRESS_1 |
ADDRESS_2 |
40 |
FORMULA |
chr(13)||chr(10)||'010STRASSE2 '||ADDRESS_2 |
COUNTRY_CODE |
40 |
FORMULA |
chr(13)||chr(10)||'011LAND '||COUNTRY_CODE |
POSTAL_CODE |
40 |
FORMULA |
chr(13)||chr(10)||'012PLZ '||POSTAL_CODE |
CITY |
40 |
FORMULA |
chr(13)||chr(10)||'013ORT '||CITY |
TELEPHONE |
40 |
FORMULA |
chr(13)||chr(10)||'014TELEFON '||TELEPHONE |
TELEX |
20 |
FORMULA |
chr(13)||chr(10)||'015TELEX' |
FAX |
40 |
FORMULA |
chr(13)||chr(10)||'016TELEFAX '||FAX |
NOTIZ1 |
20 |
FORMULA |
chr(13)||chr(10)||'017NOTIZ1' |
VIP_STATUS |
30 |
FORMULA |
chr(13)||chr(10)||'018VIP '||VIP_STATUS |
GRUPPE |
20 |
FORMULA |
chr(13)||chr(10)||'019GRUPPE' |
PROVISION |
20 |
FORMULA |
chr(13)||chr(10)||'020PROVISION' |
LCONTRACT |
20 |
FORMULA |
chr(13)||chr(10)||'021LCONTRACT' |
BRIEFNR |
20 |
FORMULA |
chr(13)||chr(10)||'022BRIEFNR' |
BIRTHDAY |
40 |
FORMULA |
chr(13)||chr(10)||'023GEBDAT '||TO_CHAR(BIRTHDAY,'YYYYMMDD') |
FIRST_STAY |
40 |
FORMULA |
chr(13)||chr(10)||'024ERSTER '||TO_CHAR(FIRST_STAY,'YYYYMMDD') |
LAST_STAY |
40 |
FORMULA |
chr(13)||chr(10)||'025LETZTER '||TO_CHAR(LAST_STAY,'YYYYMMDD') |
BERUF |
20 |
FORMULA |
chr(13)||chr(10)||'026BERUF' |
TOTAL_ARRIVALS |
40 |
FORMULA |
chr(13)||chr(10)||'027ANREISEN '||TO_CHAR(TOTAL_ARRIVALS) |
CONSIDERED_DATE |
40 |
FORMULA |
'000DATE '||TO_CHAR(CONSIDERED_DATE,'YYYYMMDD') |
CREDIT_CARD_TYPE3 |
40 |
FORMULA |
chr(13)||chr(10)||'094CARDTYPE '||CREDIT_CARD_TYPE3 |
CREDIT_CARD_NO3 |
40 |
FORMULA |
chr(13)||chr(10)||'095CARDNR '||CREDIT_CARD_NO3 |
CREDIT_CARD_EXPIRATION3 |
40 |
FORMULA |
chr(13)||chr(10)||'096CARDEXPY '||TO_CHAR(CREDIT_CARD_EXPIRATION3,'YYYYMMDD') |
CREDIT_CARD_TYPE4 |
40 |
FORMULA |
chr(13)||chr(10)||'097CARDTYPE '||CREDIT_CARD_TYPE4 |
CREDIT_CARD_NO4 |
40 |
FORMULA |
chr(13)||chr(10)||'098CARDNR '||CREDIT_CARD_NO4 |
CREDIT_CARD_EXPIRATION4 |
40 |
FORMULA |
chr(13)||chr(10)||'099CARDEXPY '||TO_CHAR(CREDIT_CARD_EXPIRATION4,'YYYYMMDD') |
CREDIT_CARD_TYPE5 |
40 |
FORMULA |
chr(13)||chr(10)||'100CARDTYPE '||CREDIT_CARD_TYPE5 |
CREDIT_CARD_NO5 |
40 |
FORMULA |
chr(13)||chr(10)||'101CARDNR '||CREDIT_CARD_NO5 |
CREDIT_CARD_EXPIRATION5 |
40 |
FORMULA |
chr(13)||chr(10)||'102CARDEXPY '||TO_CHAR(CREDIT_CARD_EXPIRATION5,'YYYYMMDD') |
MEMBER_CARD_TYPE1 |
40 |
FORMULA |
chr(13)||chr(10)||'103CARDTYPE '||rtrim(MEMBER_CARD_TYPE1) |
MEMBER_CARD_NO1 |
40 |
FORMULA |
chr(13)||chr(10)||'104CARDNR '||rtrim(MEMBER_CARD_NO1) |
MEMBER_CARD_EXPIRATION1 |
40 |
FORMULA |
chr(13)||chr(10)||'105CARDEXPY '||TO_CHAR(MEMBER_CARD_EXPIRATION1,'YYYYMMDD') |
MEMBER_CARD_LEVEL1 |
40 |
FORMULA |
chr(13)||chr(10)||'106MISC_1 '||rtrim(MEMBER_CARD_LEVEL1) |
TOTAL_NIGHTS |
40 |
FORMULA |
chr(13)||chr(10)||'028NAECHTE '||TO_CHAR(TOTAL_NIGHTS) |
NEXT_ARRIVAL |
40 |
FORMULA |
chr(13)||chr(10)||'029RESERV '||TO_CHAR(NEXT_ARRIVAL,'YYYYMMDD') |
TOTAL_CANCELLATION |
40 |
FORMULA |
chr(13)||chr(10)||'030STORNOS '||TO_CHAR(TOTAL_CANCALLATIONS) |
TOTAL_NO_SHOWS |
40 |
FORMULA |
chr(13)||chr(10)||'031NOSHOW '||TO_CHAR(TOTAL_NO_SHOWS) |
DEFAULT_RATE_CODE |
40 |
FORMULA |
chr(13)||chr(10)||'032PKZ '||DEFAULT_RATE_CODE |
PREFERRED_ROOM |
40 |
FORMULA |
chr(13)||chr(10)||'033WUNSCHZI '||PREFERRED_ROOM |
LAST_ROOM |
40 |
FORMULA |
chr(13)||chr(10)||'034LZIMMER '||LAST_ROOM |
KZ7 |
20 |
FORMULA |
chr(13)||chr(10)||'035KZ7' |
ROOM_REVENUE_YTD |
40 |
FORMULA |
chr(13)||chr(10)||'036UMSATZ '||TO_CHAR(ROOM_REVENUE_YTD) |
MEMBER_CARD_TYPE2 |
40 |
FORMULA |
chr(13)||chr(10)||'107CARDTYPE '||rtrim(MEMBER_CARD_TYPE2) |
MEMBER_CARD_NO2 |
40 |
FORMULA |
chr(13)||chr(10)||'108CARDNR '||rtrim(MEMBER_CARD_NO2) |
LAST_RATE |
40 |
FORMULA |
chr(13)||chr(10)||'037LPREIS '||TO_CHAR(LAST_RATE) |
SPECIAL_PRICE |
40 |
FORMULA |
chr(13)||chr(10)||'038SPREIS' |
PROFILE_TYPE |
30 |
FORMULA |
chr(13)||chr(10)||'039MEMO '||PROFILE_TYPE |
AGENT |
10 |
FORMULA |
chr(13)||chr(10)||'040AGENT' |
SOURCE |
10 |
FORMULA |
chr(13)||chr(10)||'041SOURCE' |
CONTACT_LAST_NAME |
20 |
FORMULA |
chr(13)||chr(10)||'042KONTAKT1' |
CONTACT_FIRST_NAME |
20 |
FORMULA |
chr(13)||chr(10)||'043KTK1_VOR' |
KONTAKT2 |
15 |
FORMULA |
chr(13)||chr(10)||'044KONTAKT2' |
STATE |
40 |
FORMULA |
chr(13)||chr(10)||'045STATE '||STATE |
SM_ACCID |
15 |
FORMULA |
chr(13)||chr(10)||'046SM_ACCID' |
INSERT_DATE |
40 |
FORMULA |
chr(13)||chr(10)||'047CREATED '||TO_CHAR(INSERT_DATE,'YYYYMMDD') |
HISTORY_YN |
30 |
FORMULA |
chr(13)||chr(10)||'048SAVEGUEST '||HISTORY_YN |
ROOM_REVENUE_LAST_YEAR |
40 |
FORMULA |
chr(13)||chr(10)||'049VJUMSATZ '||TO_CHAR(ROOM_REVENUE_LAST_YEAR) |
TOTAL_CANCELLATIONS_LAST_YEAR |
40 |
FORMULA |
chr(13)||chr(10)||'050VJSTORNO '||TO_CHAR(TOTAL_CANCELLATIONS_LAST_YEAR) |
TOTAL_NO_SHOWS_LAST_YEAR |
40 |
FORMULA |
chr(13)||chr(10)||'051VJNOSHOW '||TO_CHAR(TOTAL_NO_SHOWS_LAST_YEAR) |
DEFAULT_BILLINST |
40 |
FORMULA |
chr(13)||chr(10)||'052BILLINST '||DEFAULT_BILLINST |
CASH_BL_IND |
30 |
FORMULA |
chr(13)||chr(10)||'053BLACKLIST '||CASH_BL_IND |
PREFERRED_ROOM_FEATURES |
40 |
FORMULA |
chr(13)||chr(10)||'054FEATURES '||PREFERRED_ROOM_FEATURES |
MASTERACC |
15 |
FORMULA |
chr(13)||chr(10)||'055MASTERACC' |
LOYALTY_MEMBER_NO |
40 |
FORMULA |
chr(13)||chr(10)||'056MEMBERNR '||LOYALTY_MEMBER_NO |
NOTESNR |
15 |
FORMULA |
chr(13)||chr(10)||'057NOTESNR' |
AVAILABILITY_OVERRIDE_FLAG |
30 |
FORMULA |
chr(13)||chr(10)||'058OVERBOOK '||AVAILABILITY_OVERRIDE_FLAG |
NATIONALITY |
40 |
FORMULA |
chr(13)||chr(10)||'059NATION '||NATIONALITY |
AR_ACCOUNT_NO |
40 |
FORMULA |
chr(13)||chr(10)||'060AR_NUMBER '||AR_ACCOUNT_NO |
TOTAL_NIGHTS_LAST_YEAR |
40 |
FORMULA |
chr(13)||chr(10)||'061VJNAECHTE '||TO_CHAR(TOTAL_NIGHTS_LAST_YEAR) |
See Also
