Defining objects for applications
To extend the scope of your system, you must create objects.
Every application is created based on the underling objects that support
the required business functions. You must understand the construction
of your database before you define additional objects.
Creating objects
An object is a self-contained software entity that consists of both data and functions to manipulate data. You can use an abbreviation of your organization as a prefix to any new or modified object or attribute name.
Adding views to databases
A view can contain data from more than one object in the database. You can create object views in addition to views on existing system objects. If you work with custom applications, you can add object tables in the Database Configuration application.
Creating applications from imported database views
You can use imported database views to create applications.
Specifying attributes for objects
Attributes contain the data that is associated with objects. When you create an object, you must specify the attributes that are assigned to the object.
Enabling autonumbering for attributes
You can configure autonumbering at the system, set, organization, or site level. You can enable autonumbering for attributes to apply starting numbers and prefixes to items such as assets or work orders. Autonumbering can facilitate the movement of items across the organization levels.
Adding tax types to database tables
A tax type corresponds to a kind of tax, for example, to a city sales tax. You can specify up to 27 different tax types. The requirements of your financial system determine how many tax types you can specify.
Adding indexes
You create an index to optimize performance when searching the table using the Find function and to establish uniqueness of table columns.
Adding primary keys to user-defined objects
Primary keys can be added to user-defined objects to uniquely identify these objects in a database. A primary index is automatically created for the primary key and ensures that the primary key is unique.
Creating relationships between parent and child tables
To retrieve data on objects, you must define the relationships between objects. You define SQL for joins to create relationships between parent and child objects.