Screenshot:Tables and Columns

Back to Screens_Reference

Tables and Columns

Edit tables and columns so that Openbravo can access the database, as well as control the role access.

Table

Table

Define tables that Openbravo can access in the database.

• Data Package : Links a table to a package
• Name : A non-unique identifier for a record/document often used as a search tool.
• DB Table Name : Name of the table in the database
• Java Class Name : The classname is used when generating a representation of the table in java (the entity or business object). The classname is the simplename of the class (so without the package name). Often the AD_Table.name can be used here.
• Data Access Level : Indicates what type of data (in terms of AD_CLIENT and AD_ORG data columns) can be entered or viewed.
• Description : A space to write additional related information.
• Help/Comment : A comment that adds additional information to help users work with fields.
• Window : A work area which can be used to create, view, edit, and process a record.
• PO Window : Purchase Order Window
• View : This is a view
• Deletable Records : Indicates if records can be deleted from the database
• High Volume : Use Search instead of Pick list
• Fully Audited : Maitain Audit Trail for this table
• Acct date column
• Create Columns from DB : Create Dictionary Columns of Table not existing as a Column but in the Database
• Acct class name
• Type Area : Element this tree is built on (i.e Product, Business Partner)
• Development Status : Development Status
• Active : A flag indicating whether this record is available for use or de-activated.
• Table : A dictionary table used for this tab that points to the database table.
• SQL_Record_Identifier : SQL_Record_Identifier
• Organization : Organizational entity within client
• Client : Client for this installation.

Column

Column

Define columns within a table that Openbravo can access in the database.

• Module : Module
• DB Column Name : The name of a column within the database.
• Process Definition : Process to be executed by the button
• Name : A non-unique identifier for a record/document often used as a search tool.
• Length : An indication of the column length as defined in the database.
• Reference : The data type of this field.
• Reference Search Key : The exact reference specification for a list or a table.
• Validation : A validation rule that defines how an entry is determined to be valid or invalid.
• Validate on New : Validations and callouts are executed when a new record is created.
• Process : A series of actions carried out in sequential order.
• Triggers Autosave : Defines if a button triggers autosave or not
• Min. Value : The lowest possible value an object can take.
• Max. Value : The highest possible value an item can have.
• Mandatory : An indication noting that completing in a field is required to proceed.
• Updatable : An indication that an item can be updated by the user.
• Stored in Session : Is session attribute
• Key Column : This column is the key in this table
• Link to Parent Column : This column is a link to the parent table (e.g. header from lines) - incl. Association key columns
• Callout : A series of actions that occur when data is modified.
• Used as Record Identifier : This column is part of the record identifier
• Sequence Number : The order of records in a specified document.
• Description : A space to write additional related information.
• Help/Comment : A comment that adds additional information to help users work with fields.
• Application Element : An element that consolidates help, descriptions and terms for a database column and allows for a central maintenance.
• Default Value : The first non-null value in a set of values. It is used as a default value for a field when creating a record.
• Read Only Logic : Logic to determine if field is read only (applies only when field is read-write)
• Translation : An indication that an item is translated.
• Transient : Mark if a column is transient and will be ignored when comparing data
• Transient Condition : Java expression that will be evaluated and if the result is false, the column will be marked as transient
• Active : A flag indicating whether this record is available for use or de-activated.
• Development Status : Development Status
• Exclude Audit : Exclude column from audit
• Image Size Values Action
• Image Width
• Image Height
• Use Automatic Sequence : Use Automatic Sequence
• Display Encription : An indication noting if the input box of a field will present full text or just asterisks.
• De-encryptable : Is desencryptable
• Sqllogic
• Used as Filter Column : Is this column used for finding rows in windows
• Table : A dictionary table used for this tab that points to the database table.
• Secondary Key : Is secondary key
• Position : Determines the physical column position
• Organization : Organizational entity within client
• Column : A link to the database column of the table.
• Client : Client for this installation.
• Callout Function : A series of actions that occur when data is modified.

Role Access

Role Access

Edit role access to a particular table.

• Role : The profile of security for the user defining what windows and tabs they can see.
• Exclude : A selection permitting or denying a role access to specified data.
• Read Only : An object which may only be viewed, not edited.
• Active : A flag indicating whether this record is available for use or de-activated.
• Table Access
• Table : A dictionary table used for this tab that points to the database table.
• Organization : Organizational entity within client
• Client : Client for this installation.

Back to Screens_Reference