previous

TSA01 Export

The TSA01 Export is automatically generated and transmitted to the application server during the Night Audit procedure in OPERA. But this export can be manually run 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 set up for the actual export file itself (see Export Files for details).

Select the TSA01 Export to view information about the reservation that was in-house or checked out on business date -1 (reservation status CHECKED IN, CHECKED OUT) and has Products (Packages) attached to the reservation.

The business date is the date for which the End of Day process is being done. So the data contained in the export file will be two days older when compared to the current business date. For example, if the End of Day is run for the date of the 20th, the data in the file will be for the 19th, and the current business date will be the 21st.

tsa01_export_file_details

Export File Details Sample Setup

FILE_TYPE: TSA01

FILE_GROUP_ID: MISC

FILE_TYPE_DESC: TSA01 Export

SOURCE_VIEW_CODE: EXP_TSA01_VW

FILE_NAME: 'TSA01_'||pms_p.resort||'_'||to_char(sysdate,'YYYYMMDD')

FILE_EXTENSION: 'csv'

COL_SEPERATOR: COMMA

WHERE_CLAUSE: business_date=to_char(pms_p.business_date-1,'DD-MM-YY')

ZIP_FILE_NAME: TSA01EXPORTZIP

TSA01 File Header and Detail Data

See the TSA01 Export File Header and Details.

See Also