Parameter/Field

Default Value

Notes

File Type

CHECKOUT_GST_DETAILS

The name of the export.

File Description

Checkedout Guest Information Export

The long description of the export.

Export Source

EXP_RESERVATIONS

This field is only editable when configuring new exports. Select the down arrow and select the view used for this export from the list of values.

Source Description

Export View

The source description. The description is automatically populated once a value is selected in the Export Source field.

Pre Export Procedure

exp_create_data.create_export_data(pms_p.business_date,pms_p.business_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

EXP1

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.

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.

Note: This value defined in this field is not typically used in conjunction with values defined in the Parameter Form 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:

• Daily
• End of Month
• End of Year
• Weekly

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

export_id=exp_create_data.get_last_report_id and room_category not like '-%'

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

'BG'||to_char(pms_p.business_date,'mm')||to_char(pms_p.business_date,'dd')||to_char(pms_p.business_date,'yyyy')||to_char(pms_p.business_date,'dd')||to_char(sysdate,'hh')||property_code

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.

The name of the ASCII text file can consist of any of these values or can also be any string of characters. If the file has to be always called WY P296, then enter 'WY P296' (the single quotes are necessary). If the file has to depend on the business date of the property, then enter the following, for example:

'WY'||TO CHAR(PMS P.BUSINESS DATE,'MMDD')||'EXP'

This would give the name WY1103EXP for a business date of November 3.

File Extn Formula

XFR

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 User Set-up>Application Parameter>Opera>General. The Zip Program name (executable file) must be present in the \RUNTIMES directory.

Compress Data

Unchecked

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:

• Space
• Tab
• Comma
• Enter (CRLF or carriage return line feed)

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 the Components button allows users to configure components to be included in the export file.

FILE_GROUP_ID

FILE_TYPE_DESC

FILE and ZIP_FILE_NAME

FILE_EXTENSION

MISC

Checkedout Guest Information Export

XFR

COL_NAME

COL_LENGTH

COL_TYPE

FORMULA

CRS_CONFIRMATION_NO

12

VARCHAR2

CRS_CANC_NO

12

FORMULA

' '

TA_COMM_CODE

5

FORMULA

TO_CHAR(EXP_CREATE_DATA.COMM_PERC_AMT(EXP_CREATE_
DATA.GET_COMM_CODE(RATE_CODE,agent_NAME_ID,AGENT_
IATA_NO,SOURCE_NAME_ID,SOURCE_IATA_NO,RESV_NAME_ID
),'FM00.00')

TA_COMM

8

FORMULA

' '

BLOCK_CODE

10

VARCHAR2

CHANNEL_CODE

4

VARCHAR2

ADDRESS_TYPE

1

VARCHAR2

EMAIL

60

VARCHAR2

RATE_CODE

10

VARCHAR2

EXPANSION

266

FORMULA

' '

RECORD_TYPE

1

FORMULA

'G'

RECORD_VERSION

1

FORMULA

'5'

CRLF

2

FORMULA

CHR(13)||CHR(10)

PROPERTY_CODE

5

VARCHAR2

CONSIDERED_DATE

10

DATE

TOTALRECORDS

5

FORMULA

SPACE

1344

FORMULA

' '

RECORD_TYPE

1

FORMULA

'H'

RECORD_VERSION

1

FORMULA

'5'

CRLF

2

FORMULA

CHR(13)||CHR(10)

CONFIRMATION_NO

11

VARCHAR2

NO_SHOW_FLAG

1

FORMULA

DECODE(RESERVATION_STATUS,'NO SHOW','1','0')

CHECK_OUT_FLAG

1

VARCHAR2

CANCELLED_FLAG

1

FORMULA

DECODE(RESERVATION_STATUS,'CANCELLED','1','0')

NAME_TAX_TYPE

1

FORMULA

NVL(NAME_TAX_TYPE,'0')

ARRIVAL_DATE

10

DATE

ROOM_NIGHTS_TOTAL

3

NUMBER

ADULTS

2

NUMBER

CHILDREN

2

NUMBER

EXTRA_BEDS

2

FORMULA

NVL(EXTRA_BEDS,0)

CRIBS

2

FORMULA

NVL(CRIBS,0)

UDFN10

2

NUMBER

RATE_PLAN

6

FORMULA

' '

INSERT_DATE

10

DATE

BOOKING_TIME

5

FORMULA

TO_CHAR(INSERT_DATE,'HH:MI')

ARRIVAL_DATE

10

DATE

DEPARTURE_DATE

10

DATE

SINGLE_RATE

8

FORMULA

TO_CHAR(SHARE_AMOUNT*(POWER(10,PROPERTY_CURRENCY_
DECIMALS)),'FM00000000')

DOUBLE_RATE

8

FORMULA

TO_CHAR(SHARE_AMOUNT*(POWER(10,PROPERTY_CURRENCY_
DECIMALS)),'FM00000000')

EXTRA_AMOUNT

8

FORMULA

TO_CHAR(NVL(RESERVATION_OTHER_REVENUE,0)*(POWER(10,
PROPERTY_CURRENCY_DECIMALS)),'FM00000000')

BOOKED_RATE

8

FORMULA

TO_CHAR(CHECK_IN_RATE*(POWER(10,PROPERTY_CURRENCY
_DECIMALS)),'FM00000000')

LAST_CHANGED_RATE

8

FORMULA

TO_CHAR(SHARE_AMOUNT*(POWER(10,PROPERTY_CURRENCY_
DECIMALS)),'FM00000000')

CHECK_IN_RATE

8

FORMULA

TO_CHAR(CHECK_IN_RATE*(POWER(10,PROPERTY_CURRENCY_
DECIMALS)),'FM00000000')

GUEST_LAST_NAME

30

VARCHAR2

GUEST_FIRST_NAME

20

VARCHAR2

GUEST_TITLE_CODE

10

VARCHAR2

ROOM_TYPE

6

VARCHAR2

ROOM

6

VARCHAR2

RESERVATION_INSERT_USER_NAME

6

VARCHAR2

PROPERTY_CODE

5

VARCHAR2

CHECK_IN_TIME

5

FORMULA

TO_CHAR(ARRIVAL_DATE,'HH:MI')

CHECK_OUT_TIME

5

FORMULA

TO_CHAR(DEPARTURE_DATE,'HH:MI')

GUEST_TELEPHONE

45

VARCHAR2

RESERVATION_PAYMENT_METHOD

2

VARCHAR2

CREDIT_CARD_NO

26

VARCHAR2

GUEST_COMPANY_NAME

30

VARCHAR2

GUEST_ADDRESS_1

30

VARCHAR2

GUEST_ADDRESS_2

30

VARCHAR2

GUEST_CITY

18

VARCHAR2

GUEST_STATE_CODE

2

VARCHAR2

GUEST_POSTAL_CODE

10

VARCHAR2

GUEST_COUNTRY_CODE

2

VARCHAR2

COMPANY_ADDRESS_1

30

VARCHAR2

COMPANY_ADDRESS_2

30

VARCHAR2

COMPANY_ADDRESS_3

30

VARCHAR2

COMPANY_CITY

18

VARCHAR2

COMPANY_STATE

2

VARCHAR2

COMPANY_POSTAL_CODE

10

VARCHAR2

COMPANY_COUNTRY

2

VARCHAR2

CONFIRMATION_NO

12

VARCHAR2

CANCELLATION_NO

12

VARCHAR2

GUEST_SPECIALS_CODES

45

VARCHAR2

RESERVATION_COMMENTS

160

VARCHAR2

SHARER1

30

VARCHAR2

SHARER2

30

VARCHAR2

SHARER3

30

VARCHAR2

CHECKINOPERATOR

6

FORMULA

USER_LOG.USER_NAME(EXP_CREATE_DATA.GET_USER_ID
('CHECK IN',RESV_NAME_ID))

CHECKOUTOPERATOR

6

FORMULA

USER_LOG.USER_NAME(EXP_CREATE_DATA.GET_USER_ID
('CHECK OUT',RESV_NAME_ID))

AGENT_IATA_NO

10

VARCHAR2

LOYALTY_MEMBER_NO

12

VARCHAR2

COMPANY_CORP_ID

10

VARCHAR2

UDFC10

20

VARCHAR2

MARKET_CODE_1

4

VARCHAR2

VIP_CODE

10

FORMULA

COMPANY_CORP_ID

AIRLINE_PARTNER_CODE

2

FORMULA

' '

AIRLINE_NUMBER

12

FORMULA

' '

CREDIT_CARD_EXPIRATION

4

DATE

SHARER_AMOUNT

8

FORMULA

TO_CHAR(SHARE_AMOUNT*(POWER(10,PROPERTY_CURRENCY_
DECIMALS)),'FM00000000')

ROOM_REVENUE

8

FORMULA

TO_CHAR(NVL(RESERVATION_ROOM_REVENUE,0)*(POWER(10,
PROPERTY_CURRENCY_DECIMALS)),'FM00000000')

TA_FLAG

1

FORMULA

DECODE(EXP_CREATE_DATA.GET_COMM_CODE (RATE_CODE ,AGENT_NAME_ID, AGENT_IATA_NO, SOURCE_NAME_ID, SOURCE_IATA_NO,RESV_NAME_ID),NULL,'0','1')

GROUP_FLAG

1

FORMULA

DECODE(BLOCK_CODE,NULL,DECODE(GROUP_NAME_ID,NULL,
'0','1'),'1')

DAYUSE_FLAG

1

FORMULA

DECODE(TRUNC(ARRIVAL_DATE),TRUNC(DEPARTURE_DATE),
'1','0')

PROPERTY_CODE

5

VARCHAR2