User Manual 2.2/System Admin

Java Version

This process shows your current java version.

Database Export

Database export task creates an export.

But it can be easily customizable on the application dictionary. It is a OS command.

Database Transfer

Not implemented yet.

Synchronize Terminology

Each column has an element assigned and each column has one or more fields. Suppose you have a table with many tabs pointing to it, so all the fields on those tabs have the same name.

Usually happens, you need to change the name of the field. In the case above changing all field's name could be a bit repetitive. Using this process, each field on the application is updated with the elements name.

Suppose now, you have different columns on different tables with the same name. You can assign the same element to same name columns. During the updating process, if a column has no elements the process matches one , with the same columnname, or creates one.

Realize, this process also manages languages.

Update Table Identifiers

In databases, records are strongly related (referential integration).

When you show information of another record, you may want to show different fields . Think of an order, it is related to the business partner. On the order tab, ¿what information, related with this business partner, do you want to have?

This can be customized on Openbravo. On the Application Dictionary, Tables and windows, Columns tab. Any column can be checked as identifier. So, the identifiers will be shown on business partner field.

But you need to update all existing identifiers for each table of the database: Update Table Identifiers

Recompile DB Objects

This process calls DBA_RECOMPILE DB procedure.

SQL Query

Is a very simple SQL client for select queries. It doesn't allow updates, deletes or inserts.