Owners Statement Export Data Definition

The Owners Statement Export is automatically generated and transmitted to the application server during the Night Audit procedure in Opera. 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 t 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).

Views Used by This Export

Owners Export View: EXP_OWNERS_STATEMENT

Pre-Export Procedure

<None>

Post Export Procedure

exp_create_data.delete_report_table(exp_create_data.get_last_report_id)

Parameter Form

EXP_OVOS

Input Parameters

From Date. Start date for the export.

To Date. End date for the export.

Filter Conditions

export_id = exp_create_data.get_last_report_id

File Name Formula

'VOS'||to_char(pms_p.business_date,'rrddd')

File Extension Formula

'VOS'

Export File Header

FILE_GROUP_ID	FILE_TYPE_DESC	FILE and ZIP_FILE_NAME	FILE_EXTENSION
MISC	Owners Statement Export	'VOS'\|\|to_char(pms_p.business_date,'rrddd')	'VOS'

Export File Details

COL_NAME	COL_LENGTH	COL_TYPE	FORMULA
EXPORT_ID	13	NUMBER
ROW_SEQUENCE	13	NUMBER
EXPORT_TYPE	1	VARCHAR2
FROM_DATE	11	DATE
TO_DATE	11	DATE
NAME_ID	13	NUMBER
OWNER_NAME	100	VARCHAR2
ACCOUNT_NO	100	VARCHAR2
UNITS	100	VARCHAR2
OPN_BALANCE	13	NUMBER
OWNER_SHARE	13	NUMBER
FEES	13	NUMBER
OTHER_ACTIVITY	13	NUMBER
PAYMENT	13	NUMBER
BALANCE	13	NUMBER