|
|
|
GL Export SCC Data Definition
The Global 2000 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 |
Global 2000 Export |
'MSSFIL' |
decode(sign(to_number(to_char(pms_p.business_date,'MM'))-10),-, |
COL_NAME |
COL_LENGTH |
COL_TYPE |
FORMULA |
DEPARTURE_DATE |
8 |
DATE |
|
ROOM_TYPE |
4 |
VARCHAR2 |
|
GUEST_LAST_NAME |
20 |
VARCHAR2 |
|
GUEST_FIRST_NAME |
20 |
VARCHAR2 |
|
GUEST_TITLE_CODE |
10 |
VARCHAR2 |
|
COMPANY_GROUP_NAME |
30 |
VARCHAR2 |
|
GUEST_BUSINESS_TITLE |
30 |
VARCHAR2 |
|
GUEST_ADDRESS_1 |
30 |
VARCHAR2 |
|
GUEST_ADDRESS_2 |
30 |
VARCHAR2 |
|
GUEST_CITY |
30 |
FORMULA |
RPAD(RTRIM(GUEST_CITY)||DECODE(GUEST_CITY,NULL,' ', |
GUEST_POSTAL_CODE |
10 |
VARCHAR2 |
|
GUEST_TELEPHONE |
20 |
VARCHAR2 |
|
LEAD_DAYS |
3 |
FORMULA |
TO_CHAR(LEAD_DAYS,'FM000') |
GUEST_PROFESSION_BLANK |
3 |
FORMULA |
' ' |
ROOM_NIGHTS_TOTAL |
3 |
FORMULA |
TO_CHAR(ROOM_NIGHTS_TOTAL,'FM000') |
GUEST_NIGHTS_TOTAL |
3 |
FORMULA |
TO_CHAR(GUEST_NIGHTS_TOTAL,'FM000') |
GROUP_FLAG |
1 |
VARCHAR2 |
|
AGENT_IATA_NO |
12 |
FORMULA |
EXP_CREATE_DATA.GET_PROF_INFO(AGENT_NAME_ID,'IATA_CORP |
COMPANY_CORP_ID |
12 |
FORMULA |
EXP_CREATE_DATA.GET_PROF_INFO(COMPANY_NAME_ID,'IATA_ |
BLANK1 |
10 |
FORMULA |
' ' |
BLANK2 |
10 |
FORMULA |
' ' |
LOYALTY_MEMBER_TYPE |
2 |
FORMULA |
DECODE(UPPER(LOYALTY_MEMBER_TYPE),'SCC',SCC_MEMBER_ |
LOYALTY_MEMBER_NO |
12 |
FORMULA |
DECODE(UPPER(LOYALTY_MEMBER_TYPE),'SCC',RPAD(LOYALTY_ |
AIRLINE_MEMBER_TYPE |
2 |
VARCHAR2 |
|
AIRLINE_MEMBER_NO |
12 |
FORMULA |
RPAD(AIRLINE_MEMBER_NO,12) |
BLANK3 |
5 |
FORMULA |
' ' |
AIRLINE_BONUS_POINTS |
5 |
FORMULA |
TO_CHAR(AIRLINE_BONUS_POINTS,'FM00000') |
BLANK5 |
5 |
FORMULA |
' ' |
GUEST_LANGUAGE |
1 |
VARCHAR2 |
|
BLANK6 |
2 |
FORMULA |
' ' |
BLANK7 |
4 |
FORMULA |
' ' |
BLANK8 |
4 |
FORMULA |
' ' |
BLANK9 |
3 |
FORMULA |
' ' |
SOURCE_CODE |
2 |
VARCHAR2 |
|
UDFC20 |
4 |
VARCHAR2 |
|
UDFC19 |
4 |
VARCHAR2 |
|
Data_Lbl |
1 |
FORMULA |
'D' |
CONFIRMATION_NO |
8 |
FORMULA |
LPAD(CONFIRMATION_NO,8,'0') |
ARRIVAL_DATE |
8 |
DATE |
|
BLANK27 |
1 |
FORMULA |
' ' |
RATE_CODE |
8 |
VARCHAR2 |
|
BLANK28 |
8 |
FORMULA |
' ' |
BLANK29 |
8 |
FORMULA |
' ' |
BLANK30 |
8 |
FORMULA |
' ' |
BLANK31 |
10 |
FORMULA |
' ' |
CREDIT_CARD_NO |
20 |
VARCHAR2 |
|
AR_ACCOUNT_NO |
12 |
VARCHAR2 |
|
UDFC18 |
30 |
VARCHAR2 |
|
BLANK32 |
3 |
FORMULA |
' ' |
BLANK33 |
3 |
FORMULA |
' ' |
HLbl |
1 |
FORMULA |
'H' |
PROPERTY_CURRENCY_CODE |
3 |
VARCHAR2 |
|
PROPERTY_CURRENCY_DECIMALS |
3 |
NUMBER |
|
ST_DATE_LBL |
8 |
FORMULA |
to_char(sysdate,'YYYYMMDD') |
ST_TIME_LBL |
6 |
FORMULA |
to_char(sysdate,'HHMISS') |
hotel_LBL |
4 |
FORMULA |
'OPER' |
PMS_VERSION |
4 |
FORMULA |
substr(PMS_VERSION,1,3) |
BLANK40 |
3 |
FORMULA |
' ' |
TRecLbl |
1 |
FORMULA |
'T' |
BLANK34 |
5 |
FORMULA |
' ' |
EXP_ROOM_NIGHTS_TOTAL |
5 |
NUMBER |
|
BLANK35 |
5 |
FORMULA |
' ' |
BLANK36 |
5 |
FORMULA |
' ' |
BLANK37 |
5 |
FORMULA |
' ' |
BLANK38 |
5 |
FORMULA |
' ' |
TRANS_ST_DATE |
5 |
FORMULA |
to_char(trunc(sysdate)-to_date('31-DEC- 1976'),'FM00000') |
TRANS_END_DATE |
5 |
FORMULA |
to_char(trunc(sysdate)-to_date('31-DEC- 1976'),'FM00000') |
GUEST_COUNTRY_CODE |
2 |
VARCHAR2 |
|
COMPANY_CORP_ID |
12 |
FORMULA |
EXP_CREATE_DATA.GET_PROF_INFO(COMPANY_NAME_ID,'IATA |
BLANK45 |
5 |
FORMULA |
'00000' |
BLANK46 |
5 |
FORMULA |
'00000' |
TOTALRECORDS |
5 |
FORMULA |
|
IHC_CUSTOM_VERSION |
4 |
FORMULA |
'9409' |
HOTEL_ID |
10 |
FORMULA |
property_code |
TOTALRECORDS |
5 |
FORMULA |
to_char(EXP_ROOM_NIGHTS_TOTAL,'FM00000') |
GUEST_SPECIALS |
24 |
FORMULA |
replace(guest_specials_codes,',','') |
BLANK |
2 |
FORMULA |
' ' |
BLANK10 |
10 |
FORMULA |
' ' |
CHANNEL_CODE |
2 |
VARCHAR2 |
|
CRS_CONFIRMATION_NO |
10 |
VARCHAR2 |
|
GUEST_COUNTRY_CODE |
2 |
VARCHAR2 |
|
GUEST_STATE_CODE |
2 |
VARCHAR2 |
|
BLANK11 |
5 |
FORMULA |
' ' |
BLANK12 |
1 |
FORMULA |
' ' |
BLANK13 |
1 |
FORMULA |
' ' |
BLANK14 |
1 |
FORMULA |
' ' |
BLANK15 |
1 |
FORMULA |
' ' |
PAYMENT_CODE |
2 |
FORMULA |
exp_create_Data.get_cash_type(payment_code) |
BLANK16 |
10 |
FORMULA |
' ' |
REVENUE_AMOUNT_1 |
10 |
FORMULA |
TO_CHAR(REVENUE_AMOUNT_1*(POWER(10,PROPERTY_CURRENCY |
REVENUE_AMOUNT_2 |
10 |
FORMULA |
TO_CHAR(REVENUE_AMOUNT_2*(POWER(10,PROPERTY_CURRENCY |
REVENUE_AMOUNT_3 |
10 |
FORMULA |
TO_CHAR(REVENUE_AMOUNT_3*(POWER(10,PROPERTY_CURRENCY |
REVENUE_AMOUNT_4 |
10 |
FORMULA |
TO_CHAR(REVENUE_AMOUNT_4*(POWER(10,PROPERTY_CURRENCY |
REVENUE_AMOUNT_5 |
10 |
FORMULA |
TO_CHAR(REVENUE_AMOUNT_5*(POWER(10,PROPERTY_CURRENCY |
REVENUE_AMOUNT_6 |
10 |
FORMULA |
TO_CHAR(REVENUE_AMOUNT_6*(POWER(10,PROPERTY_CURRENCY |
REVENUE_AMOUNT_7 |
10 |
FORMULA |
TO_CHAR(REVENUE_AMOUNT_7*(POWER(10,PROPERTY_CURRENCY |
REVENUE_AMOUNT_8 |
10 |
FORMULA |
TO_CHAR(REVENUE_AMOUNT_8*(POWER(10,PROPERTY_CURRENCY |
REVENUE_AMOUNT_9 |
10 |
FORMULA |
TO_CHAR(REVENUE_AMOUNT_9*(POWER(10,PROPERTY_CURRENCY |
REVENUE_AMOUNT_10 |
10 |
FORMULA |
TO_CHAR(REVENUE_AMOUNT_10*(POWER(10,PROPERTY_CURRENCY |
MARKET_CODE_1 |
3 |
VARCHAR2 |
|
MARKET_CODE_2 |
3 |
VARCHAR2 |
|
MARKET_CODE_3 |
3 |
VARCHAR2 |
|
MKT_ROOM_NIGHTS_1 |
3 |
FORMULA |
TO_CHAR(MKT_ROOM_NIGHTS_1,'FM000') |
MKT_ROOM_NIGHTS_2 |
3 |
FORMULA |
TO_CHAR(MKT_ROOM_NIGHTS_2,'FM000') |
MKT_ROOM_NIGHTS_3 |
3 |
FORMULA |
TO_CHAR(MKT_ROOM_NIGHTS_3,'FM000') |
BLANK17 |
3 |
FORMULA |
' ' |
BLANK19 |
3 |
FORMULA |
' ' |
BLANK20 |
3 |
FORMULA |
' ' |
MKT_ROOM_REVENUE_1 |
10 |
FORMULA |
TO_CHAR(MKT_ROOM_REVENUE_1,'FM0000000000') |
MKT_ROOM_REVENUE_2 |
10 |
FORMULA |
TO_CHAR(MKT_ROOM_REVENUE_2,'FM0000000000') |
MKT_ROOM_REVENUE_3 |
10 |
FORMULA |
TO_CHAR(MKT_ROOM_REVENUE_3,'FM0000000000') |
BLANK21 |
10 |
FORMULA |
' ' |
RESERVATION_STATUS_FLAG |
1 |
VARCHAR2 |
|
BLANK22 |
1 |
FORMULA |
' ' |
BLANK24 |
12 |
FORMULA |
' ' |
BLANK25 |
1 |
FORMULA |
' ' |
BLANK26 |
20 |
FORMULA |
' ' |
See Also
