|
|
|
Daily Data Export Data Definition (DAILY_DATA_EXPORT & DAILY_DATA_EXP_DAY)
The Daily Data Extract Export (DAILY_DATA_EXPORT) is automatically generated and transmitted to the application server during the Night Audit procedure in OPERA, but the DAILY_DATA_EXPORT_DAY) can be run manually and is available on-demand, which allows 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).
The Daily Data Extract Export is a compilation of all guest folio information for the day, as well as turnaways (regrets and denials). Specifically, the export includes these parts:
This export in most parts is based on 4 different exports (DCO, DRS, Revenue, EFolio) that currently exist for SCH mode and provide similar information, but there are a few new fields in this export and the format of this export file / information could vary compared to the existing 4 exports.
Guest Header Information:
Guest Detail Information:
Native Guest Header
Please note following:
The General>Alternate Name application function will be activated.
Regrets and Denials:
The DRS export section is same as existing DRS export except for the addition of superfield 009 providing the AR account information in the new export.
The EOF section will be the information based on the bucket codes configured in the REVENUE_EXPORT bucket type.
To manually configure the export, select Miscellaneous>File Export>General or Configuration>External>Export Files to access the Export File List screen. Select the export from the list and select the Edit button to access the Export File Details screen. The Export File Details screen allows you to specify the particular features of the export file. Once configured, refer to Generate Export Data for information on generating the export.
Note: A DAT type is added to the Type list of values when the OXI Export check box is selected.
Refer to the following table when running the export manually or changing the export parameters.
The table provides a description of the available fields and includes the following information:
Parameter/Field |
Default Value |
Notes |
File Type |
DAILY_DATA_EXPORT |
The name of the export. |
File Description |
Daily Data Export |
The long description of the export. |
Export Source |
EXP_DAILYDATA_RESERVATIONS See Source View Codes in Child Exports section, below. |
Note: This view requires the pre-export procedure exp_create_dailydata to populate data into the views. |
Source Description |
-Data for each guest folio.
|
The source description. The description is automatically populated once a value is selected in the Export Source field. |
Pre Export Procedure |
DAILY_DATA_EXPORT exp_create_dailydata.create_data
DAILY_DATA_EXPORT_DAY exp_create_dailydata.create_data(exp_general_resv_pkg.exp_start_date) |
The pre-export procedure is an internal setup procedure which will be executed prior to the data export. The pre-export procedure is a pre-processor that populates and filters views, and sets variables. The procedure extracts the data and stores it in a temporary table. The view (defined in the Export Source field) reads from this table and creates the export data. The temporary table is deleted once the export is complete. If a pre export procedure is not specified, the export will look at the value(s) defined in the Parameter Form field. |
Post Export Procedure |
exp_create_data.delete_report_table |
An internal setup procedure which will be executed after the data export is done. The post-export procedure is a post-processor that truncates temp tables following export generation and may also reset parameters that were set for the export. |
Parameter Form |
exp_by_daterange |
The Parameter Form field is used for exports that can be manually generated. This field contains the name of the parameter form which is used to generate a manual export. Note: When automatically generating exports via End of Day processing (the Night Audit Export check box is selected), the parameter form should not be used, because the export is generated automatically and there is no opportunity for manual input. This export uses the EXP_BY_DATERANGE parameter form, which requires date range for which the export needs to be run. The default value is the pms_p.business_date-1 Typically, this field is not required if the pre-export procedure is defined, however this can vary depending on the definition of the export. Each pre-export procedure has a unique parameter form, as the procedure is hard-coded within the form. If a value is not defined in the Parameter Form field, the procedure will look at the view utilized for the export (defined in the Export Source field). |
Night Audit Export |
Checked |
When selected, this export will be included as part of the night audit procedure. |
Frequency |
Daily |
This field appears when the Night Audit Export check box is selected, and is the frequency that this export will generate. The available options are:
|
HTTP Upload |
Unchecked |
This field is not available if the OXI Export check box is selected. Select this check box to use an HTTP upload of the export file. This file can be uploaded and automatically transferred to the HTTP address during End of Day processing or on demand (for more current information). Note: If the export is configured to run during End of Day processing and the HTTP transmission fails, the night audit will continue to run to complete the End of Day. But, an error message will display in the naweather.rdf report to notify the user of the transmission failure. As this report is non-mandatory, properties using the HTTP transmission must configure the report. |
HTTP Address |
Blank |
This field appears when the HTTP Address check box is selected. Enter the database HTTP address where the export file will be uploaded to. |
Protocol |
Blank |
Select the down arrow to select the protocol used for extracting XML (e.g., SOAP) from the uploaded file. |
OXI Export |
Unchecked |
Available when as OPX_nnn OXI add-on license is active. Select this check box to transport the export file via the OXI interface. When this check box is selected, the Type and Interface fields appear. Note: This checkbox is not available if the HTTP Upload check box is selected. |
Type |
Blank |
This field appears when the OXI Export check box is selected. Select the down arrow and select the type of OXI export. |
Interface |
Blank |
This field appears when the OXI Export check box is selected. Select the down arrow and select the third-party system to which OPERA connects through OXI. |
Filter Condition |
|
The condition for the export. By default, depending on the view, all data will be exported. But if only certain information is required to be exported, then users can enter a value in this field. Technically, this is the where clause in the select statement. For example, if only certain market codes statistics are required in the market codes statistics export, such as FIT, COM and IND, then the condition Market code IN (FIT,COM,IND) can be entered, where market code would be one of the column names in the Export source view/table. When clicking OK, the export setup is saved and now the columns can be defined. When the export setup is saved, the button option Export Columns will now be available. To define the export columns, select the Export Columns button. Once selected, the Export Columns Details screen appears, displaying the columns available in the view. |
XML |
Unchecked |
When selected, the export will generate via XML messaging. |
File Name Formula |
DAILY_DATA_EXPORT "'DATAEXT'||SUBSTR(EXP_CREATE_DATA.GET_HOTEL_CODE,1,5)||TO_CHAR(PMS_P.BUSINESS_DATE,'DDD')"
DAILY_DATA_EXPORT_DAY "'DATAEXT'||SUBSTR(EXP_CREATE_DATA.GET_HOTEL_CODE,1,5)||TO_CHAR(exp_general_resv_pkg.exp_start_date,'DDD')" |
The file name formula is the name of the ASCII export file which will be created when the export is generated. This field can accept valid SQL formulas so that the file name can include dates or other program specific exports information. For example, the first 5 characters of the property code + the current system Month + F would be: SUBSTR(property code,5)||MM||F Select the down arrow and select the columns ( defined in the Export Source View/Table) that can be used to create the File Name Formula from the list of values. |
File Extn Formula |
'DAT' |
Used to create any file extension for the daily export. This field can accept SQL statements so that the extension can include dates or other program specific export information (Current System Month + Day MM||DD). Examples for the file extension name would be TXT or EXP. The single quotes are necessary. |
Zip File Name |
Blank |
The name of the compressed file if the export files are to be zipped. To make use of this functionality, the EXPORT ZIPPROGRAM parameter must contain the zip program namezip. The Zip Program name parameter EXPORT ZIPPROGRAM is already configured in the General application settings. The Zip Program (executable file) must be present in the ...\runtimes directory. |
Compress Data |
Checked |
Select this check box to compress all records in the export file. This would be used for delimited ASCII text files. The delimiter can be entered in the Col Separator field. |
Col Separator |
Blank |
This field appears when the Compress Data check box is selected. Select the down arrow and select the delimiter used to separate the columns from the list of values. The available options are:
|
Always Export Header and Footer |
Unchecked |
Based on the export setup, if no data has been generated within the export and if a header and footer is defined, and a file name is given in the export setup, OPERA will always generate the export file that contains no information other than the header and the footer. |
Inactive |
Unchecked |
If this check box is checked, the file type will be inactive. |
Add Newline |
Checked |
Select this check box to have each record displayed on a separate line in the ASCII text file. |
Component Export |
Unchecked |
Select this check box to expose the Components button. Selecting the Components button allows users to configure components to be included in the export file. |
Export Columns - Select this button to define and configure the export columns. The Export Columns Details screen appears, displaying the columns available in the view. For additional information on the Export Column Details screen, refer to Export Column Details.
Components - Select this button to access the Export Components screen and configure the components to be included in the export. This button only displays when the Component Export check box is selected.
COL_NAME |
COL_LENGTH |
COL_TYPE |
FORMULA |
SUPER1 |
4 |
FORMULA |
(CASE WHEN RECORD_TYPE = 1 THEN '00A:' END) |
HOTEL_CODE |
10 |
FORMULA |
"(CASE WHEN RECORD_TYPE = 1 THEN RPAD(PROPERTY_CODE,10) END)" |
ROOM_TYPE |
4 |
FORMULA |
"(CASE WHEN RECORD_TYPE = 1 THEN RPAD(ROOM_TYPE,4) END)" |
PREV_ROOM |
6 |
FORMULA |
"CASE WHEN RECORD_TYPE = 1 THEN LPAD(NVL(PREVIOUS_ROOM,'0'),6,'0') END" |
ROOM |
6 |
FORMULA |
"CASE WHEN RECORD_TYPE = 1 THEN LPAD(NVL(ROOM,'0'),6,'0') END" |
PROF_NUM |
30 |
FORMULA |
"CASE WHEN RECORD_TYPE = 1 THEN TO_CHAR(GUEST_NAME_ID,'FM000000000000000000000000000000') END" |
ARRIVAL |
8 |
FORMULA |
"(CASE WHEN RECORD_TYPE=1 THEN TO_CHAR(ARRIVAL_DATE,'YYYYMMDD') END)" |
NTS |
3 |
FORMULA |
"CASE WHEN RECORD_TYPE = 1 THEN TO_CHAR(ROOM_NIGHTS_TOTAL,'FM000') END" |
DEPARTURE |
8 |
FORMULA |
"CASE WHEN RECORD_TYPE = 1 THEN TO_CHAR(DEPARTURE_DATE,'YYYYMMDD') END" |
RES_STATUS |
1 |
FORMULA |
CASE WHEN RECORD_TYPE=1 THEN EXPORT_RES_STATUS END |
CHK_IN_TIME |
8 |
FORMULA |
CASE WHEN RECORD_TYPE = 1 THEN ARRIVAL_TIME END |
CK_OUT_TIME |
8 |
FORMULA |
"CASE WHEN RECORD_TYPE = 1 AND DEPARTURE_TIME = '00:00:00' THEN RPAD(' ',8) WHEN RECORD_TYPE = 1 THEN RPAD(DEPARTURE_TIME,8) END" |
ADULTS |
1 |
FORMULA |
CASE WHEN RECORD_TYPE = 1 THEN ADULTS END |
CHILDREN |
1 |
FORMULA |
CASE WHEN RECORD_TYPE = 1 THEN CHILDREN END |
FNAME |
20 |
FORMULA |
"CASE WHEN RECORD_TYPE = 1 THEN RPAD(NVL(GUEST_FIRST_NAME,' '),20) END" |
LNAME |
20 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(GUEST_LAST_NAME,20) END" |
ADDRESS_TYPE |
4 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(NVL(GUEST_ADDRESS_TYPE,' '),4) END" |
ADDRESS1 |
30 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(NVL(GUEST_ADDRESS_1,' '),30) END" |
ADDRESS2 |
30 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(NVL(GUEST_ADDRESS_2,' '),30) END" |
ADDRESS3 |
30 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(NVL(GUEST_ADDRESS_3,' '),30) END" |
CITY |
30 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(NVL(GUEST_CITY,' '),30) END" |
STATE |
2 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(NVL(GUEST_STATE_CODE,' '),2) END" |
POSTAL |
9 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(NVL(GUEST_POSTAL_CODE,' '),30) END" |
COUNTRY |
2 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(NVL(GET_ISO_CODE(GUEST_COUNTRY_CODE),' '),2) END" |
NATIONALITY |
2 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(NVL(NATIONALITY,' '),2) END" |
PASSPORT |
40 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(NVL(GUEST_PASSPORT,' '),40) END" |
RESCOUNTRY |
2 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(NVL(GET_ISO_CODE(GUEST_COUNTRY_CODE),' '),2) END" |
80 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(NVL(EMAIL,' '),80) END" |
|
PHONETYPE |
4 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(NVL(PHONE_TYPE,' '),4) END" |
PHONENUM |
15 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(NVL(PHONE_NO,' '),15) END" |
FAX |
15 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(NVL(FAX_NO,' '),15) END" |
PRIVACY |
3 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(PRIVACY_SET,3) END" |
ALLIANCE |
3 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(NVL(AIRLINE_MEMBER_TYPE,' '),3) END" |
ALLIANCE_NUM |
16 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(NVL(AIRLINE_MEMBER_NO,' '),16) END" |
SCCCODE |
2 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(NVL(SCC_MEMBERSHIP_LEVEL,' '),2) END" |
SCCNUM |
12 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(NVL(SCC_MEMBERSHIP_NO,' '),12) END" |
HDX_CONF |
20 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(NVL(CRS_CONFIRMATION_NO,' '),20) END" |
ACCSEQNO |
4 |
FORMULA |
"CASE WHEN RECORD_TYPE= 1 THEN RPAD(NVL(ACC_SEQ,' '),4) END" |
MNEMONIC |
5 |
FORMULA |
"CASE WHEN RECORD_TYPE= 1 THEN RPAD(NVL(UDFC31,PROPERTY_CODE),5) END" |
BOOK_SOURCE |
1 |
FORMULA |
"CASE WHEN RECORD_TYPE= 1 THEN RPAD(NVL(UDFC32,' '),1) END" |
ORIGIN_CODE |
10 |
FORMULA |
"CASE WHEN RECORD_TYPE= 1 THEN RPAD(NVL(CHANNEL_CODE,' '),10) END" |
BOOK_DATE |
8 |
FORMULA |
"CASE WHEN RECORD_TYPE= 1 THEN TO_CHAR(INSERT_DATE,'YYYYMMDD') END" |
MKTSEG |
4 |
FORMULA |
"CASE WHEN RECORD_TYPE= 1 THEN RPAD(EXP_CREATE_DATA.GET_CRS_CODE('HOLIDEX','MARKET_CODE',MARKET_CODE),4)END" |
TA_NUM |
9 |
FORMULA |
"CASE WHEN RECORD_TYPE= 1 THEN RPAD(NVL(AGENT_IATA_NO,' '),9) END" |
PMS_CONF |
10 |
FORMULA |
CASE WHEN RECORD_TYPE= 1 THEN LPAD(CONFIRMATION_NO,10,'0') END |
CURRENCY |
3 |
FORMULA |
"CASE WHEN RECORD_TYPE= 1 THEN RPAD(PROPERTY_CURRENCY_CODE,3) END" |
DECIMAL |
1 |
FORMULA |
"CASE WHEN RECORD_TYPE= 1 THEN TO_CHAR(PROPERTY_CURRENCY_DECIMALS,'FM0') END" |
ROOM_RATE |
7 |
FORMULA |
"CASE WHEN RECORD_TYPE= 1 THEN TO_CHAR(NVL(SHARE_AMOUNT,0)*POWER(10,PROPERTY_CURRENCY_DECIMALS),'FM0000000') END" |
CORP_NUM |
9 |
FORMULA |
"CASE WHEN RECORD_TYPE= 1 THEN RPAD(NVL(COMPANY_CORP_ID,' '),9) END" |
PMS_RATE |
8 |
FORMULA |
"CASE WHEN RECORD_TYPE= 1 THEN RPAD(NVL(RATE_CODE,' '),4) END" |
ORIG_CRS_RATE |
8 |
FORMULA |
"CASE WHEN RECORD_TYPE= 1 THEN RPAD(NVL(EXP_CREATE_DATA.GET_CRS_CODE('HOLIDEX','RATE_CODE',UDFC28),' '),8) END" |
CRS_RATE_CODE |
8 |
FORMULA |
"CASE WHEN RECORD_TYPE = 1THEN RPAD(NVL(EXP_CREATE_DATA.GET_CRS_CODE('HOLIDEX','RATE_CODE',RATE_CODE),' '),8) END" |
GROUP_CODE |
3 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(NVL(BLOCK_CODE,' '),3) END" |
GROUP_CONTACT |
40 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(NVL(GROUP_CONTACT_NAME,' '),40) END" |
GROUP_ACCT |
30 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(NVL(GROUP_NAME,' '),30) END" |
PAY_TYPE |
2 |
FORMULA |
"CASE WHEN RECORD_TYPE = 1 AND PAYMENT_CREDIT_CARD_NO IS NULL THEN RPAD(NVL(PAYMENT_TYPE,NVL(RESERVATION_PAYMENT_CODE,' ')),2) WHEN RECORD_TYPE = 1 THEN RPAD(NVL(EXP_CREATE_DATA.GET_CRS_CODE('HOLIDEX','PAYMENT_METHOD',PAYMENT_TYPE),' '),2) END"
Note: Windows that have a payment transaction show that payment type and ignore the setting on the reservation. In case there is more than one payment transaction on a window the transaction with the highest amount will be exported. Windows that do not have a payment type configured on the reservation show the payment type of window 1.
|
PAY_REF |
60 |
FORMULA |
"CASE WHEN RECORD_TYPE = 1 AND PAYMENT_CREDIT_CARD_NO IS NOT NULL THEN RPAD(TRIM(PAYMENT_CREDIT_CARD_NO)||TO_CHAR(PAYMENT_CREDIT_CARD_EXPY,'MMYY'),60) END" |
PAY_REF2 |
60 |
FORMULA |
"CASE WHEN RECORD_TYPE = 1 AND PAYMENT_CREDIT_CARD_NO IS NULL THEN RPAD(NVL(DIRECT_BILL_NAME,' '),60)END" |
TAX_TYPE |
1 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(NVL(TAX_TYPE,' '),1) END" |
TAX_TYPE_DESC |
30 |
FORMULA |
"CASE WHEN RECORD_TYPE=1 THEN RPAD(NVL(TAX_TYPE_DESCRIPTION,' '),30) END" |
RES_CTR |
5 |
FORMULA |
"CASE WHEN RECORD_TYPE = 1THEN TO_CHAR(RESERVATION_COUNTER,'FM00000') END" |
A_EOF |
2 |
FORMULA |
CASE WHEN RECORD_TYPE =1 THEN CHR(13)||CHR(10) END |
SUPERB |
4 |
FORMULA |
"CASE WHEN RECORD_TYPE IN (2,2.5) THEN '00B:' END" |
PMS_CONF |
10 |
FORMULA |
"CASE WHEN RECORD_TYPE IN (2,2.5) THEN RPAD(CONFIRMATION_NO,10) END" |
PREF_CODE_DESC |
32 |
FORMULA |
"CASE WHEN RECORD_TYPE = 2 THEN RPAD(NVL(CODE,' '),2)||RPAD(NVL(CODE_DESCRIPTION,' '),30) WHEN RECORD_TYPE = 2.5 THEN RPAD(' ',32) END" |
SPECIAL_CODE_DESC |
30 |
FORMULA |
"CASE WHEN RECORD_TYPE = 2.5 THEN RPAD(NVL(CODE,' '),5)||RPAD(NVL(CODE_DESCRIPTION,' '),40) WHEN RECORD_TYPE = 2 THEN RPAD(' ',45) END" |
EOF |
2 |
FORMULA |
"CASE WHEN RECORD_TYPE IN (2.,2.5) THEN CHR(13)||CHR(10) END" |
SUPERC |
4 |
FORMULA |
CASE WHEN RECORD_TYPE = 3 THEN '00C:' END |
PMS_CONF |
10 |
FORMULA |
"CASE WHEN RECORD_TYPE = 3 THEN RPAD(CONFIRMATION_NO,10) END" |
PACKAGE |
20 |
FORMULA |
"CASE WHEN RECORD_TYPE = 3 THEN RPAD(CODE,20) END" |
PACKADE_DESC |
30 |
FORMULA |
"CASE WHEN RECORD_TYPE = 3 THEN RPAD(CODE_DESCRIPTION,30) END" |
EOF |
2 |
FORMULA |
CASE WHEN RECORD_TYPE = 3 THEN CHR(13)||CHR(10) END |
SUPERD |
4 |
FORMULA |
CASE WHEN RECORD_TYPE = 4 THEN '00D:' END |
FOLIO_NO |
29 |
FORMULA |
"CASE WHEN RECORD_TYPE = 4 THEN TO_CHAR(NVL(RESERVATION_FOLIO_NUMBER,0),'FM00000000000000000000000000000') END" |
WIN |
1 |
FORMULA |
"CASE WHEN RECORD_TYPE = 4 THEN TO_CHAR(NVL(FOLIO_VIEW,1),'FM0') END" |
REV_TYPE |
3 |
FORMULA |
"CASE WHEN RECORD_TYPE = 4 THEN RPAD(NVL(EXPORT_BUCKET,' '),3) END" |
REFERENCE |
4 |
FORMULA |
"CASE WHEN RECORD_TYPE = 4 THEN LPAD(SUBSTR(TO_CHAR(NVL(TRX_NUMBER,0)),LENGTH(TO_CHAR(NVL(TRX_NUMBER,0)))-3),4,'0') END" |
TRAN_DATE |
8 |
FORMULA |
"CASE WHEN RECORD_TYPE = 4 THEN TO_CHAR(TRX_DATE, 'YYYYMMDD') END" |
TRAN_CODE |
8 |
FORMULA |
"CASE WHEN RECORD_TYPE = 4 THEN RPAD(TRX_CODE,8) END" |
ITEM_ID |
4 |
FORMULA |
CASE WHEN RECORD_TYPE=4 THEN '0001' END |
DESCRIPTION |
60 |
FORMULA |
"CASE WHEN RECORD_TYPE = 4 AND PAYMENT_CREDIT_CARD_NO IS NOT NULL THEN RPAD( PAYMENT_CREDIT_CARD_NO||TO_CHAR(PAYMENT_CREDIT_CARD_EXPY,'MM/YY') ,60) END" |
DESC2 |
60 |
FORMULA |
"CASE WHEN RECORD_TYPE = 4 AND PAYMENT_CREDIT_CARD_NO IS NULL THEN RPAD(NVL(DIRECT_BILL_NAME||TRX_DESCRIPTION,' '),60) END" |
AMOUNT |
12 |
FORMULA |
"CASE WHEN RECORD_TYPE = 4 AND SIGN(TRX_AMOUNT) = -1 THEN TO_CHAR(TRX_AMOUNT*(POWER(10,NVL(PROPERTY_CURRENCY_DECIMALS,0))),'S000000000000') |
TRAN_COUNTER |
5 |
FORMULA |
"CASE WHEN RECORD_TYPE=4 THEN TO_CHAR(TRX_COUNTER,'FM00000') END" |
EOF |
2 |
FORMULA |
CASE WHEN RECORD_TYPE = 4 THEN CHR(13)||CHR(10) END |
SUPER_FIELD_ID |
4 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN LPAD('00F:',4) END) |
HOTEL_CODE |
10 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN RPAD(PROPERTY_CODE,10) END) |
DB_LANGUAGE |
5 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN RPAD(NVL(XLANGUAGE,' '),5) END) |
FNAME |
60 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN SUBSTRB(RPAD(NVL(GUEST_FIRST_NAME,' '),60),1,60) END) |
LNAME |
60 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN SUBSTRB(RPAD(NVL(GUEST_LAST_NAME,' '),60),1,60) END) |
ADDRESS_TYPE |
12 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN SUBSTRB(RPAD(NVL(GUEST_ADDRESS_TYPE,' '),12),1,12) END) |
ADDRESS_1 |
90 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN SUBSTRB(RPAD(NVL(GUEST_ADDRESS_1,' '),90),1,90) END) |
ADDRESS_2 |
90 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN SUBSTRB(RPAD(NVL(GUEST_ADDRESS_2,' '),90),1,90) END) |
ADDRESS_3 |
90 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN SUBSTRB(RPAD(NVL(GUEST_ADDRESS_3,' '),90),1,90) END) |
CITY |
90 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN SUBSTRB(RPAD(NVL(GUEST_CITY,' '),90),1,90) END) |
STATE |
20 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN SUBSTRB(RPAD(NVL(GUEST_STATE_CODE,' '),20),1,20) END) |
POSTAL_CODE |
20 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN SUBSTRB(RPAD(NVL(GUEST_POSTAL_CODE,' '),20),1,20) END) |
COUNTRY |
10 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN RPAD(NVL(GET_ISO_CODE(GUEST_COUNTRY_CODE),' '),10) END) |
NATIONALITY |
10 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN RPAD(NVL(GET_ISO_CODE(NATIONALITY),' '),10) END) |
PASSPORT |
50 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN SUBSTRB(RPAD(NVL(GUEST_PASSPORT,' '),50),1,50) END) |
COUNTRY_RES |
10 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN RPAD(NVL(GET_ISO_CODE(GUEST_COUNTRY_CODE),' '),10) END) |
250 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN SUBSTRB(RPAD(NVL(EMAIL,' '),250),1,250) END) |
|
PHONE_TYPE |
12 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN SUBSTRB(RPAD(NVL(PHONE_TYPE,' '),12),1,12) END) |
PHONE_NUM |
30 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN RPAD(NVL(PHONE_NO,' '),30) END) |
FAX_NUM |
30 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN RPAD(NVL(FAX_NO,' '),30) END) |
PRIVACY_SET |
10 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN RPAD(NVL(PRIVACY_SET,' '),10) END) |
ALLIANCE_CODE |
10 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN RPAD(NVL(AIRLINE_MEMBER_TYPE,' '),10) END) |
ALLIANCE_NUM |
40 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN SUBSTRB(RPAD(NVL(AIRLINE_MEMBER_NO,' '),40),1,40) END) |
SCC_CODE |
10 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN RPAD(NVL(SCC_MEMBERSHIP_LEVEL,' '),10) END) |
SCC_NUM |
40 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN SUBSTRB(RPAD(NVL(SCC_MEMBERSHIP_NO,' '),40),1,40) END) |
HEADER_COUNT |
5 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN TO_CHAR(XNAME_COUNTER,'FM00000') END) |
EOF |
2 |
FORMULA |
(CASE WHEN RECORD_TYPE = 5 THEN CHR(13)||CHR(10) END) |
FILE_TYPE |
EXPORT_SEQUENCE |
FILE_TYPE_DESC |
SOURCE_VIEW_CODE |
REGRETS_DENIALS |
1 |
Regrets and Denials |
EXP_TURNAWAY_STATS |
DRS_RESORT |
3 |
DRS Extract |
RESORT |
LEDGER_BALANCES |
4 |
Ledger Balances |
EXP_LEDGER_BALANCE |
MARKET_STATS |
5 |
"Stats by market code,tiers and room types" |
EXP_MARKET_ROOMCAT_TIER_STATS |
ADMIN_GENERAL |
6 |
Administrative and General |
EXP_AGING_BUCKET_BALANCE |
CASHIER_OVERSHORT |
7 |
Cashier Over/Short Amount |
EXP_CASHIER_DROP_AMOUNTS |
TRX_CODES |
8 |
Transaction Codes |
EXP_TB_VIEW |
CC_MERCHANTS |
9 |
Credit Card Merchant Id |
EXP_PAYMENT_METHODS |
MANAGER_REPORT |
10 |
Statistics |
EXP_MANAGER_REPORT |
AR_ACCOUNTS |
11 |
AR Accounts export |
EXP_AR_ACCOUNTS |
EXPORT_EOF |
12 |
Revenue Export |
EXP_REV_STATISTICS |
COL_NAME |
COL_LENGTH |
COL_TYPE |
FORMULA |
SUPER_FIELD_ID |
4 |
FORMULA |
'00E:' |
PROPERTY_CODE |
10 |
VARCHAR2 |
|
ARRIVAL_DATE |
8 |
DATE |
|
ROOMS |
2 |
NUMBER |
|
NIGHTS |
3 |
NUMBER |
|
RATE_CAT |
10 |
FORMULA |
"EXP_CREATE_DATA.GET_CRS_CODE('HOLIDEX','RATE_CODE',RATE_CODE)" |
TURNAWAY_CODE |
5 |
VARCHAR2 |
|
MKTSEG |
1 |
FORMULA |
"EXP_CREATE_DATA.GET_CRS_CODE('HOLIDEX','MARKET_CODE',MARKET_CODE)" |
SEQ_NUM |
20 |
FORMULA |
"TO_CHAR(CONSIDERED_DATE, 'YYYYMMDD')||TO_CHAR(MOD(NVL(RESERVATION_COUNTER,0),9998),'FM0000')" |
TRX_COUNTER |
5 |
NUMBER |
|
EOR |
2 |
FORMULA |
CHR(13)||CHR(10) |
ROOM_TYPE |
4 |
VARCHAR2 |
|
SHARE_AMOUNT |
7 |
FORMULA |
"TO_CHAR(RATE_AMOUNT*(POWER(10,NVL(PROPERTY_CURRENCY_DECIMALS,0))),'FM0000000')" |
CONSIDERED_DATE |
8 |
DATE |
|
PROPERTY_CURRENCY_CODE |
3 |
VARCHAR2 |
|
PROPERTY_CURRENCY_DECIMALS |
2 |
VARCHAR2 |
|
DESCRIPTION |
15 |
VARCHAR2 |
|
DAY_TYPE_CODE |
3 |
VARCHAR2 |
|
GRP_CODE |
3 |
FORMULA |
' ' |
CONFIRM |
8 |
FORMULA |
' ' |
EOF |
2 |
FORMULA |
CHR(13)||CHR(10) |
COL_NAME |
COL_LENGTH |
COL_TYPE |
FORMULA |
INIT_SAVE |
0 |
FORMULA |
"DECODE(ROWNUM,1,EXP_CREATE_DATA.SUM_BUCKET_INIT(1),NULL)" |
HDR_FIELD |
4 |
FORMULA |
'HDR:' |
HOTEL_CODE |
5 |
VARCHAR2 |
|
HDR_BUS_DATE_DTE |
8 |
FORMULA |
"TO_CHAR(EXP_GENERAL_RESV_PKG.EXP_START_DATE,'YYYYMMDD')" |
HDR_DTE_TIM_STA_DTE |
14 |
FORMULA |
"TO_CHAR(SYSDATE,'YYYYMMDD@HH:MM')" |
CURRENCY_CODE |
3 |
VARCHAR2 |
|
CURRENCY_CODE_DESC |
20 |
FORMULA |
EXP_STATISTIC_PKG.GET_CURRENCY_DESCRIPTION(CURRENCY_CODE) |
CURRENCY_DECIMALS |
1 |
NUMBER |
|
HRD_HOT_TYP_ID |
8 |
FORMULA |
' ' |
HDR_EOF_ID |
3 |
FORMULA |
'***' |
COUNT_SAVE |
0 |
FORMULA |
"EXP_CREATE_DATA.SUM_BUCKET_SAVE(1,1)" |
COL_NAME |
COL_LENGTH |
COL_TYPE |
FORMULA |
BAL_SUP_FLD_ID |
4 |
FORMULA |
'002:' |
DEPOSIT_LED_BALANCE |
26 |
FORMULA |
"REPLACE(DECODE(SIGN(DEPOSIT_LEDGER_BALANCE),-1,TO_CHAR(DEPOSIT_LEDGER_BALANCE,'FM99999999999999990.000000000'),TO_CHAR(DEPOSIT_LEDGER_BALANCE,'FM00000000000000000.000000000')),'.')" |
BAL_CTY_LED_BAL_AMT |
26 |
FORMULA |
"REPLACE(DECODE(SIGN(AR_LEDGER_BALANCE),-1,TO_CHAR(AR_LEDGER_BALANCE,'FM99999999999999990.000000000'),TO_CHAR(AR_LEDGER_BALANCE,'FM00000000000000000.000000000')),'.')" |
BAL_GST_LED_BAL_AMT |
26 |
FORMULA |
"REPLACE(DECODE(SIGN(GUEST_LEDGER_BALANCE),-1,TO_CHAR(GUEST_LEDGER_BALANCE,'FM99999999999999990.000000000'),TO_CHAR(GUEST_LEDGER_BALANCE,'FM00000000000000000.000000000')),'.')" |
BAL_PKG_LED_BAL_AMT |
26 |
FORMULA |
"REPLACE(DECODE(SIGN(PACKAGE_LEDGER_BALANCE),-1,TO_CHAR(PACKAGE_LEDGER_BALANCE,'FM99999999999999990.000000000'),TO_CHAR(PACKAGE_LEDGER_BALANCE,'FM00000000000000000.000000000')),'.')" |
BAL_EOF_ID |
3 |
FORMULA |
'***' |
COUNT_SAVE |
0 |
FORMULA |
"EXP_CREATE_DATA.SUM_BUCKET_SAVE(1,1)" |
COL_NAME |
COL_LENGTH |
COL_TYPE |
FORMULA |
ROM_SUP_FLD_ID |
4 |
FORMULA |
'003:' |
MARKET_CODE |
8 |
VARCHAR2 |
|
ROM_MKT_CDE_AMT |
26 |
FORMULA |
"REPLACE(DECODE(SIGN(TOTAL_MARKET_REVENUE),-1,TO_CHAR(TOTAL_MARKET_REVENUE,'FM99999999999999990.000000000'),TO_CHAR(TOTAL_MARKET_REVENUE,'FM00000000000000000.000000000')),'.')" |
ROOM_CATEGORY |
8 |
VARCHAR2 |
|
LOS_TIER |
8 |
NUMBER |
|
ROM_TIER_BED_AMT |
26 |
FORMULA |
"REPLACE(DECODE(SIGN(TOTAL_REVENUE),-1,TO_CHAR(TOTAL_REVENUE,'FM99999999999999990.000000000'),TO_CHAR(total_revenue,'FM00000000000000000.000000000')),'.')" |
TOTAL_MARKET_ROOMS |
15 |
NUMBER |
|
TOTAL_ROOMS |
15 |
NUMBER |
|
ROM_EOF_ID |
3 |
FORMULA |
'***' |
COUNT_SAVE |
0 |
FORMULA |
"EXP_CREATE_DATA.SUM_BUCKET_SAVE(1,1)" |
COL_NAME |
COL_LENGTH |
COL_TYPE |
FORMULA |
AAG_SUP_FLD_ID |
4 |
FORMULA |
"DECODE(AGING_BUCKET_NO,1,'004:',NULL)" |
AAG_AR_BAD_DEBT |
26 |
FORMULA |
"DECODE(AGING_BUCKET_NO,1,LPAD(REPLACE(DECODE(SIGN(nvl(exp_statistic_pkg.get_total_trx_amount('7600',EXP_GENERAL_RESV_PKG.EXP_START_DATE()),0)),-1,TO_CHAR(nvl(EXP_STATISTIC_PKG.GET_TOTAL_TRX_AMOUNT('7600',EXP_GENERAL_RESV_PKG.EXP_START_DATE()),0),'FM99999999999999990.000000000'),TO_CHAR(nvl(EXP_STATISTIC_PKG.GET_TOTAL_TRX_AMOUNT('7600',EXP_GENERAL_RESV_PKG.EXP_START_DATE()),0),'FM00000000000000000.000000000')),'.'),26,' '),NULL)" |
AAG_AR_CUR_AMT |
26 |
FORMULA |
"DECODE(AGING_BUCKET_NO, 1, LPAD(REPLACE(DECODE(SIGN(BALANCE),-1, TO_CHAR(BALANCE,'FM99999999999999990.000000000'), TO_CHAR(BALANCE,'FM00000000000000000.000000000')),'.'),26,' '),NULL)" |
AAG_AR_OVR_30 |
26 |
FORMULA |
"DECODE(AGING_BUCKET_NO, 2, LPAD(REPLACE(DECODE(SIGN(BALANCE),-1, TO_CHAR(BALANCE,'FM99999999999999990.000000000'), TO_CHAR(BALANCE,'FM00000000000000000.000000000')),'.'),26,' '),NULL)" |
AAG_AR_OVR_60 |
26 |
FORMULA |
"DECODE(AGING_BUCKET_NO, 3, LPAD(REPLACE(DECODE(SIGN(BALANCE),-1, TO_CHAR(BALANCE,'FM99999999999999990.000000000'), TO_CHAR(BALANCE,'FM00000000000000000.000000000')),'.'),26,' '),NULL)" |
AAG_AR_OVR_90 |
26 |
FORMULA |
"DECODE(AGING_BUCKET_NO, 4, LPAD(REPLACE(DECODE(SIGN(BALANCE),-1, TO_CHAR(BALANCE,'FM99999999999999990.000000000'), TO_CHAR(BALANCE,'FM00000000000000000.000000000')),'.'),26,' '),NULL)" |
AAG_AR_OVR_120 |
26 |
FORMULA |
"DECODE(AGING_BUCKET_NO, 5, LPAD(REPLACE(DECODE(SIGN(BALANCE),-1, TO_CHAR(BALANCE,'FM99999999999999990.000000000'), TO_CHAR(BALANCE,'FM00000000000000000.000000000')),'.'),26,' '),NULL)" |
AAG_AR_OVR_SHT_AMT |
26 |
FORMULA |
"DECODE(AGING_BUCKET_NO,5, LPAD(REPLACE(DECODE(SIGN(nvl(EXP_STATISTIC_PKG.GET_TOTAL_OVER_SHORT_AMT(EXP_GENERAL_RESV_PKG.EXP_START_DATE()),0)), -1,TO_CHAR(nvl(EXP_STATISTIC_PKG.GET_TOTAL_OVER_SHORT_AMT(EXP_GENERAL_RESV_PKG.EXP_START_DATE()),0),'FM99999999999999990.000000000'),TO_CHAR(nvl(EXP_STATISTIC_PKG.GET_TOTAL_OVER_SHORT_AMT(EXP_GENERAL_RESV_PKG.EXP_START_DATE()),0),'FM00000000000000000.000000000')),'.'),26,' '),NULL)" |
AAG_EOF_ID |
3 |
FORMULA |
"DECODE(AGING_BUCKET_NO,5,'***'||chr(13)||chr(10),NULL)" |
COUNT_SAVE |
0 |
FORMULA |
"DECODE(ROWNUM,1,EXP_CREATE_DATA.SUM_BUCKET_SAVE(1,1),NULL)" |
COL_NAME |
COL_LENGTH |
COL_TYPE |
FORMULA |
COS_SUP_FLD_ID |
4 |
FORMULA |
'005:' |
CASHIER_APP_USER |
15 |
VARCHAR2 |
|
COS_OVR_SHT_AMT |
26 |
FORMULA |
"REPLACE(DECODE(SIGN(NVL(DIFF_CASH,0)+NVL(DIFF_CHECK,0)),-1,TO_CHAR(NVL(DIFF_CASH,0)+NVL(DIFF_CHECK,0),'FM99999999999999990.0000000009'),TO_CHAR(NVL(DIFF_CASH,0)+NVL(DIFF_CHECK,0),'FM00000000000000000.000000000')),'.')" |
COS_EOF_ID |
3 |
FORMULA |
'***' |
COUNT_SAVE |
0 |
FORMULA |
"EXP_CREATE_DATA.SUM_BUCKET_SAVE(1,1)" |
COL_NAME |
COL_LENGTH |
COL_TYPE |
FORMULA |
TRN_SUP_FLD_ID |
4 |
FORMULA |
'006:' |
DESCRIPTION |
20 |
VARCHAR2 |
|
TRN_COD_ID |
5 |
FORMULA |
"LPAD(TRX_CODE,5,'0')" |
TRN_COD_AMT |
26 |
FORMULA |
"REPLACE(DECODE(SIGN(AMOUNT),-1,TO_CHAR(AMOUNT,'FM99999999999999990.000000000'),TO_CHAR(AMOUNT,'FM00000000000000000.000000000')),'.')" |
TRN_EOF_ID |
3 |
FORMULA |
'***' |
COUNT_SAVE |
0 |
FORMULA |
"EXP_CREATE_DATA.SUM_BUCKET_SAVE(1,1)" |
COL_NAME |
COL_LENGTH |
COL_TYPE |
FORMULA |
CMI_SUP_FLD_ID |
4 |
FORMULA |
'007:' |
PAYMENT_METHOD |
8 |
VARCHAR2 |
|
DESCRIPTION |
40 |
VARCHAR2 |
|
CMI_CRD_NUM_ID |
26 |
FORMULA |
"LPAD(NVL(MERCHANT_NUMBER,'0'),26,'0')" |
CMI_EOF_ID |
3 |
FORMULA |
'***' |
COUNT_SAVE |
0 |
FORMULA |
"EXP_CREATE_DATA.SUM_BUCKET_SAVE(1,1)" |
COL_NAME |
COL_LENGTH |
COL_TYPE |
FORMULA |
ROM_SUP_FLD_ID |
4 |
FORMULA |
'008:' |
ROM_WAK_IN_AMT |
26 |
FORMULA |
"REPLACE(TO_CHAR(EXP_STATISTIC_PKG.GET_WALKIN_REVENUE(EXP_GENERAL_RESV_PKG.EXP_START_DATE()) ,'FM00000000000000000.000000000'),'.')" |
ROM_NUM_WAK_IN_STA |
15 |
FORMULA |
"TO_CHAR(NVL(WALKIN_DAY,0),'FM000000000000000')" |
ROM_NUM_GAR_NO_SHW_STA |
15 |
FORMULA |
"TO_CHAR(NVL(NOSHOW_DAY,0),'FM000000000000000')" |
ROM_NUM_ADU_STA |
15 |
FORMULA |
"TO_CHAR(NVL(ADULTS_DAY,0),'FM000000000000000')" |
ROM_NUM_CHL_STA |
15 |
FORMULA |
"TO_CHAR(NVL(CHILDREN_DAY,0),'FM000000000000000')" |
ROM_OUT_ORD_STA |
15 |
FORMULA |
"TO_CHAR(NVL(OOO_ROOMS_DAY,0),'FM000000000000000')" |
ROM_OUT_SER_STA |
15 |
FORMULA |
"TO_CHAR(NVL(OS_ROOMS_DAY,0),'FM000000000000000')" |
ROM_VAC_STA |
15 |
FORMULA |
"TO_CHAR(AVAIL_ROOM_DAY,'FM000000000000000')" |
ROM_EOF_ID |
3 |
FORMULA |
'***' |
COUNT_SAVE |
0 |
FORMULA |
"EXP_CREATE_DATA.SUM_BUCKET_SAVE(1,1)" |
COL_NAME |
COL_LENGTH |
COL_TYPE |
FORMULA |
SUPERFIELDID |
4 |
FORMULA |
'009:' |
RESORT |
20 |
VARCHAR2 |
|
ACCOUNT_CODE |
20 |
NUMBER |
|
ACCOUNT_NO |
20 |
VARCHAR2 |
|
ACCOUNT_TYPE_ID |
20 |
NUMBER |
|
ACCOUNT_NAME |
30 |
VARCHAR2 |
|
COMPANY_NAME |
30 |
VARCHAR2 |
|
ACCOUNT_SNAME |
30 |
VARCHAR2 |
|
ADDRESS1 |
30 |
VARCHAR2 |
|
ADDRESS2 |
30 |
VARCHAR2 |
|
ADDRESS3 |
30 |
VARCHAR2 |
|
CITY |
30 |
VARCHAR2 |
|
STATE |
2 |
VARCHAR2 |
|
COUNTRY |
2 |
VARCHAR2 |
|
ZIP |
20 |
VARCHAR2 |
|
PHONE |
30 |
VARCHAR2 |
|
FAX |
30 |
VARCHAR2 |
|
SUM_CUR_CODE |
3 |
VARCHAR2 |
|
CREDIT_LIMIT |
15 |
NUMBER |
|
ACCOUNT_STATUS |
1 |
VARCHAR2 |
|
INACTIVE_DATE |
8 |
DATE |
|
INSERT_DATE |
8 |
DATE |
|
UPDATE_DATE |
8 |
DATE |
|
ROM_EOF_ID |
3 |
FORMULA |
'***' |
COL_NAME |
COL_LENGTH |
COL_TYPE |
FORMULA |
SUPERFIELD_ID |
4 |
FORMULA |
'EOF:' |
PROPERTY_CODE |
10 |
VARCHAR2 |
|
OPR_TYPE |
3 |
FORMULA |
'OPR' |
PROPERTY_CURRENCY_CODE |
3 |
VARCHAR2 |
|
REVENUE_1 |
52 |
FORMULA |
'1'||DECODE(SIGN(NET_AMOUNT_1),'-1','1','0')||TO_CHAR(ABS(NET_AMOUNT_1*(POWER(10,PROPERTY_CURRENCY_DECIMALS))),'FM00000000000000000000000000000000000000000000000000') |
REVENUE_2 |
52 |
FORMULA |
'2'||DECODE(SIGN(NET_AMOUNT_2),'-1','1','0')||TO_CHAR(ABS(NET_AMOUNT_2*(POWER(10,PROPERTY_CURRENCY_DECIMALS))),'FM00000000000000000000000000000000000000000000000000') |
REVENUE_3 |
52 |
FORMULA |
'3'||DECODE(SIGN(NET_AMOUNT_3),'-1','1','0')||TO_CHAR(ABS(NET_AMOUNT_3*(POWER(10,PROPERTY_CURRENCY_DECIMALS))),'FM00000000000000000000000000000000000000000000000000') |
RESORT_ROOMS |
12 |
FORMULA |
"'4'||'0'||TO_CHAR(EXP_STATISTIC_PKG.GET_TOTAL_RESORT_ROOMS,'FM0000000000')" |
SINGLE_OCC_ROOMS |
12 |
FORMULA |
"'5'||'0'||TO_CHAR(ABS(SINGLE_OCC_ROOM),'FM0000000000')" |
MULTI_OCC_ROOM |
12 |
FORMULA |
"'6'||'0'||TO_CHAR(ABS(MULTI_OCC_ROOM),'FM0000000000')" |
REVENUE_4 |
52 |
FORMULA |
'7'||DECODE(SIGN(NET_AMOUNT_4),'-1','1','0')||TO_CHAR(ABS(NET_AMOUNT_4*(POWER(10,PROPERTY_CURRENCY_DECIMALS))),'FM00000000000000000000000000000000000000000000000000') |
TOTAL_HASH |
12 |
FORMULA |
"'9'||decode(sign((ROUND(NVL(NET_AMOUNT_1,0),2)+ROUND(NVL(NET_AMOUNT_2,0),2)+ROUND(NVL(NET_AMOUNT_3,0),2)+ROUND(NVL(NET_AMOUNT_4,0),2))*100 + nvl(single_occ_room,0)+nvl(multi_occ_room,0)+nvl(exp_statistic_pkg.get_total_resort_rooms,0)),-1,1,0)||TO_CHAR((ROUND(NVL(NET_AMOUNT_1,0),2)+ROUND(NVL(NET_AMOUNT_2,0),2)+ROUND(NVL(NET_AMOUNT_3,0),2)+ROUND(NVL(NET_AMOUNT_4,0),2))*100 + nvl(single_occ_room,0)+nvl(multi_occ_room,0)+nvl(exp_statistic_pkg.get_total_resort_rooms,0),'FM0000000000')" |
SEQ_NUM |
20 |
FORMULA |
"TO_CHAR(PMS_P.BUSINESS_DATE,'YYYYMMDD')||TO_CHAR(MOD(nvl(EXP_CREATE_DAILYDATA.GET_LAST_RESERVATION_CTR,0),9998),'FM0000')" |
DAILY_EXT_VER |
6 |
FORMULA |
'010001' |
TOTAL_HEADER_CTR |
5 |
FORMULA |
"TO_CHAR(nvl(EXP_CREATE_DAILYDATA.GET_LAST_RESERVATION_CTR,0),'FM00000')" |
EOR |
2 |
FORMULA |
CHR(13)||CHR(10) |
EOF |
1 |
FORMULA |
CHR(26) |
