Data Dictionary

as at 2.7.2018

May not be complete. The file structures are for reference only and may have changed from your your UniRes system version. Ring support for assistance.

DATA DICTIONARY

This is a partial Data Dictionary. The only file usually needed is the Bookings file "unbook.dbf".

Note: Do not open the UniRes dbf files for editing in application other than UniRes. Non VFP  database tools will damage the file header of the original file making it unusable in UniRes. You have been warned.

The Design of the database and Table files, as well as UniRes Software is Copyright (c) 1989 - 2018 by Arcbase Pty Ltd. its author and directors.

UNBOOK                Main Current Bookings file        New, Future and checked-out bookings

UNBOOH                History Bookings                History file when the UniRes system has run a Periodic Maintenance

                                                       (Shift old bookings to history) - same structure as unbook.dbf.

UNSITA                        Site Table file                        One record for each site sold/booked/hired out  

UNSITR                        Site Current Transactions        Standard UniRes and Invoicing Option UniRes

UNSITH                        Site History Transactions        History file when the UniRes system has run a Periodic Maintenance

                                                       (Shift old bookings/ transactions to history)

UNSITY                        Site Types File                        One record per Type of site (Group), for site table and Rates Calculations

UNEXTR                Extras Sales                        Like a mini stock file. Sell other user defined items like services, Linen etc.

UNMARK                Market Codes                        Record from a defined source of the booking.

UNNOTE

UNSTAT                Statistics gathering file                Internal use

SYSDATA                System Data File                Contains UniRes Setup  Configuration

SETUP                        Internal use                        Only used when a new company is created or supplied.

ARSTAX                Tax Rates                        Referenced by Billing system

UNCBILL                Internal use                        Temporary File.

UNTOUR                Group Booking                        Used when a new groub booking is created

EXPORTS                Internal Use                        Internal use        

ATTACHMENTS                Email Attachments reference        Email system uses this file

ESETUP                Email Setup Reference                Internal use

EHEAD                        Email Header File                Internal use

QDATA                        Internal use                        Internal use        

EMAILLOG                Internal use                        Internal use

EMAILATTACHLOG        Internal use                        Internal use

RECURHEAD                Internal use                        Recurring Sales reference file

RECURITEM                Internal use                        Recurring Sales Items

LETTERLOG                Internal use                        Internal use - log file

REMINDERLIST                User definable timed reminders        Internal use

UNPARE                Group Bookings                        Internal use

--- Invoicing System Option ---

UNCUST                Customer Master (Account) File        Debtors Master File for Invoicing system

                                                       Bookings become (Orders) attached to this file.        

UNCASHC                Cash Receipts File                Monies Received

UNCASHD                Cash Disbursements File        Records where Cash Receipts were allocated to whic Booking/Invoice.

UNINVCH                Invoice Header File                Records Invoice Detail - referenced by transaction Files UNINVCH + UNSITR are used to create invoices.

Data Dictionary

as at 2.7.2018

May not be complete. The file structures are for reference only and may have changed from your your UniRes system version. Ring support for assistance.

DATA DICTIONARY

This is a partial Data Dictionary. The only file usually needed is the Bookings file "unbook.dbf".

Note: Do not open the UniRes dbf files for editing in application other than UniRes. Non VFP  database tools will damage the file header of the original file making it unusable in UniRes. You have been warned.

The Design of the database and Table files, as well as UniRes Software is Copyright (c) 1989 - 2018 by Arcbase Pty Ltd. its author and directors.

UNBOOK                Main Current Bookings file        New, Future and checked-out bookings

UNBOOH                History Bookings                History file when the UniRes system has run a Periodic Maintenance

                                                       (Shift old bookings to history) - same structure as unbook.dbf.

UNSITA                        Site Table file                        One record for each site sold/booked/hired out  

UNSITR                        Site Current Transactions        Standard UniRes and Invoicing Option UniRes

UNSITH                        Site History Transactions        History file when the UniRes system has run a Periodic Maintenance

                                                       (Shift old bookings/ transactions to history)

UNSITY                        Site Types File                        One record per Type of site (Group), for site table and Rates Calculations

UNEXTR                Extras Sales                        Like a mini stock file. Sell other user defined items like services, Linen etc.

UNMARK                Market Codes                        Record from a defined source of the booking.

UNNOTE

UNSTAT                Statistics gathering file                Internal use

SYSDATA                System Data File                Contains UniRes Setup  Configuration

SETUP                        Internal use                        Only used when a new company is created or supplied.

ARSTAX                Tax Rates                        Referenced by Billing system

UNCBILL                Internal use                        Temporary File.

UNTOUR                Group Booking                        Used when a new groub booking is created

EXPORTS                Internal Use                        Internal use        

ATTACHMENTS                Email Attachments reference        Email system uses this file

ESETUP                Email Setup Reference                Internal use

EHEAD                        Email Header File                Internal use

QDATA                        Internal use                        Internal use        

EMAILLOG                Internal use                        Internal use

EMAILATTACHLOG        Internal use                        Internal use

RECURHEAD                Internal use                        Recurring Sales reference file

RECURITEM                Internal use                        Recurring Sales Items

LETTERLOG                Internal use                        Internal use - log file

REMINDERLIST                User definable timed reminders        Internal use

UNPARE                Group Bookings                        Internal use

--- Invoicing System Option ---

UNCUST                Customer Master (Account) File        Debtors Master File for Invoicing system

                                                       Bookings become (Orders) attached to this file.        

UNCASHC                Cash Receipts File                Monies Received

UNCASHD                Cash Disbursements File        Records where Cash Receipts were allocated to whic Booking/Invoice.

UNINVCH                Invoice Header File                Records Invoice Detail - referenced by transaction Files UNINVCH + UNSITR are used to create invoices.

Created with the Personal Edition of HelpNDoc: Free PDF documentation generator