Configuring databases
When your business needs change, you can create objects
to extend the scope of your database before you create additional
applications. As configuration changes are based on business rational,
you must understand the structure of your database and the business
requirements before you begin creating objects.
Database design
You typically extend the scope of your system because you have a use case that you want to include in the system. During the design phase you define the use case, the business objects, and the relationships between the business objects. To configure objects in the database, you must understand the structure of the database and the implications of the changes that you make to existing objects, tables, indexes, and relationships.
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.
Configuration of general ledger accounts
Default general ledger (GL) accounts are created as part of the installation process but you can create additional GL account codes at a later date. You must configure default GL account code formats for the system level before you can create a chart of accounts. Once configured, it is not recommended that you modify the GL account formats as changing the configuration can make the existing chart of accounts unusable.
Configuring the database
When you change the database, for example by creating or deleting objects, attributes, or indexes, changes are stored in secondary tables. The changes do not take effect until you configure the database. The product restores the backup tables as part of configuration.
Configuring the system for regulatory compliance
Electronic signature verification and electronic audit records provide an additional level of security control and auditing capability that are often needed for regulatory compliance.
Controlling changes to objects
Depending on your users needs, you can add functions that will help users, for example creating lookups or creating system messages.
Search option configuration for performance optimization
You want to prevent users from performing queries that retrieve hundreds of thousands of records. You should periodically review users saved queries, you could define default queries for your users, or educate them on how to create efficient queries