previous

Potentials Export Data Definition (POTENTIAL_FORECAST)

This Potentials export data definition exports all potentials filtered by Start Date and Forecast Type. The export can also be used to import all required information into a third party system. This export can be manually run by selecting Miscellaneous>File Export or Configuration>External>Export Files. 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).

Application Setting

Select the application parameter General (Global)>Potential Property Details = Y.

File Type

POTENTIAL_FORECAST

Views Used by This Export

EXPORT_POTENTIAL_FORECAST.VW

Pre-Export Procedure

<None>

Post Export Procedure

<None>

File Name Formula

'POT_'||sc_exports.get_file_name_format

File Extension Formula

'CSV'

Parameter Form

When Generate is selected from the Export File Types screen, the Accounts Export (EXPORT_POTENTIALS) screen appears. Enter the Potential From and To Start Dates and the Potential Type for which you want to generate the potential forecast.

exp_export_potential_filter_form

Data Export Columns

Column Name  

Length

Align

Data Type

Prompt

Default

RECORD_TYPE (Program generated. P = Potentials) Cannot be changed.

Variable

L

VARCHAR2

N

P

SOURCE_SYSTEM (System sending the file, e.g. OPERA)

Variable

L

VARCHAR2

N

 

PROFILE_ID

Variable

L

NUMBER

N

 

PROFILE_NAME (Company Name of the linked company. If no company linked, then name of the linked agent)

Variable

L

VARCHAR2

N

 

UDFC40

Variable

L

VARCHAR2

N

 

POTENTIAL_ID (Profile ID)

Variable

L

NUMBER

N

 

POTENTIAL_NAME (Profile Name)

Variable

L

VARCHAR2

N

 

POTENTIAL_START_DATE (MM-DD-YYYY)

Variable

L

DATE

N

 

POTENTIAL_END_DATE (MM-DD-YYYY)

Variable

L

DATE

N

 

FORECAST_TYPE

Variable

L

VARCHAR2

N

 

RESORT

Variable

L

VARCHAR2

N

 

ROOM_NIGHTS

Variable

L

NUMBER

N

 

ROOM_REVENUE (FM999999999999D00)

Variable

R

NUMBER

N

 

ROOM_AVGRATE (FM999999999999D00)

Variable

L

NUMBER

N

 

OTHER_REVENUE (FM999999999999D00)

Variable

R

NUMBER

N

 

FB_REVENUE (FM999999999999D00)

Variable

R

NUMBER

N

 

Relationships File Header and Detail Data

See the Potentials File Header and Detail Data

See Also