Infinium Owner Export

The Infinium Owner Export allows properties to export owner revenue information from Opera to Infinium, an external system. This export can be run manually or can be automatically generated during the Night Audit procedure in Opera.

If the Export is Run Manually

To run this report manually, select Miscellaneous>File Export>General, or Configuration>External>Export Files. From the Export File List screen, select Infinium Owner Export from the list, and select the Generate button two times. A date display appears that asks for the specific date range to compile the export for.

Select the from date in the From Date field and to date in the To Date field, and select the Start button. The file is generated in ASCII format with the .vos file extension, and is manually delivered to Infinium.

File Header

FILE_GROUP_ID

FILE_TYPE_DESC

FILE_NAME

FILE_EXTENSION

INFI_OWNER_EXP

Infinium Owner Export

exp_create_data.get_hotel_code(pms_p.resort)||lpad(to_char(pms_p.business_date,'DDD'),3,'0')

The file name includes the HOTEL_CODE (from the Property Details screen). If Hotel Code is null, the Property Code (RESORT) is used.

VOS

File Details

COL_NAME	COL LENGTH	COL_TYPE	FORMAT	FORMULA
ACCOUNT_NO	12	VARCHAR2
OWNER_NAME	30	VARCHAR2
NAME_ID	12	VARCHAR2	FM000000000000
EXPORT_ID	30	VARCHAR2	FM000000000000
OWNER_ADDRESS1	30	VARCHAR2
OWNER_ADRESS2	30	VARCHAR2
OWNER_CITY	20	VARCHAR2
OWNER_ZIP	10	VARCHAR2
OWNER_COUNTRY	3	VARCHAR2
OWNER_PHONE	10	VARCHAR2
ROW_SEQUENCE	30	NUMBER	FM00000000000
OWNER_STATE	2	VARCHAR2
OPN_BALANCE	9	FORMULA		to_char(nvl(OPN_BALANCE,0),decode(nvl(sign(OPN_BALANCE),0),- 1,'FM00000.00','FM000000.00'))
BALANCE	9	FORMULA		to_char(nvl(BALANCE,0),decode(nvl(sign(BALANCE),0),- 1,'FM00000.00','FM000000.00'))
FROM_DATE	6	DATE	MMDDRR
TO_DATE	6	DATE	MMDDRR
OWNER_SHARE	9	FORMULA		to_char(nvl(OWNER_SHARE,0),decode(nvl(sign(OWNER_SHARE),0),- 1,'FM00000.00','FM000000.00'))
EXPORT_TYPE	1	VARCHAR2
FEES	9	FORMULA		to_char(nvl(FEES,0),decode(nvl(sign(FEES),0),-1,'FM00000.00','FM000000.00'))
OTHER_ACTIVITY	9	FORMULA		to_char(nvl(OTHER_ACTIVITY,0),decode(nvl(sign(OTHER_ACTIVITY),0),- 1,'FM00000.00','FM000000.00'))
PAYMENT	9	FORMULA		to_char(nvl(PAYMENT,0),decode(nvl(sign(PAYMENT),0),- 1,'FM00000.00','FM000000.00'))
UNITS	80	VARCHAR2

If the Export is Run as Part of the Night Audit

If the report is to be automatically generated and transmitted to a central database during the Night Audit procedure in Opera, select Miscellaneous>File Export>General, or Configuration>External>Export Files. From the Export File List screen, select Infinium Owner Export Night Audit from the list, and select the Edit button to access the Export File Details screen. Select the Night Audit checkbox and select the frequency that the export is to be included as part of the Night Audit process. Your selection options are Daily, End of Month, End of Year, or Weekly. Select the Save button and then the Generate button two times. The file is generated in ASCII format with the .vos file extension, and is manually delivered to Infinium.