Previous Topic

Next Topic

Generic Arrivals Data Definition

The Generic Arrivals 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).

Export File Header

FILE_GROUP_ID

FILE_TYPE_DESC

FILE and ZIP_FILE_NAME

FILE_EXTENSION

MISC

Generic Arrivals Export

 

TXT

 Export File Details

COL_NAME

COL_LENGTH

COL_TYPE

FORMULA

GUEST_FIRST_NAME

20

VARCHAR2

'H'

GUEST_LAST_NAME

20

VARCHAR2

 

ARRIVAL_DATE

8

DATE

 

DEPARTURE_DATE

8

DATE

 

ROOM

5

VARCHAR2

 

 

See Also