User Manual 2.2/Table and Column

Table tab

Column tab

Definition

Openbravo stores information in an external database, however the database is managed within the system. The management is done using tables and columns, each with corresponding attributes, keys, and other identification information.

The definition of a table includes the table and its column parameters. In order to access a table from a selected window it is essential to activate the table beforehand.

Process Information

• The most significant data to be introduced is as follows:
  • A table name in the application - Name
  • A table name in the database - DB Table Name, Data Access Level, Window, and PO Window.

• Before creating tables and columns in the application, create them in the database.

• Create Columns from DB button: Introduces all records in a selected tab. It is recommendable to check the configuration after the execution of the process.

• The definition of a column determines the fields design in a tab.