Wikiadmin: /* Table */

2018-10-26T09:49:48Z

‎Table

Wikiadmin: /* Column */

2018-10-26T09:45:30Z

‎Column

Wikiadmin: /* Role Access */

2018-10-26T09:42:59Z

‎Role Access

Wikiadmin: Created page with "{{BackTo|Screens Reference}} == '''Tables and Columns''' == Edit tables and columns so that Openbravo can access the database, as well as control the role access. === '''Tab..."

2018-10-26T09:42:30Z

Created page with "{{BackTo|Screens Reference}} == '''Tables and Columns''' == Edit tables and columns so that Openbravo can access the database, as well as control the role access. === '''Tab..."

New page

{{BackTo|Screens Reference}}

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

=== '''Table''' ===

Define tables that Openbravo can access in the database.
* '''[[Screenshot:Module#Data Package | Data Package]]''' : Links a table to a package
* '''Name''' : A non-unique identifier for a record/document often used as a search tool.
* '''Data Origin''' : Field to specify the type of data origin: physical table/view or datasource
* '''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.
* '''[[Screenshot:Datasource#Datasources | Datasource]]''' : Datasource used to feed the table
* '''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.
* '''[[Screenshot:Windows, Tabs, and Fields#Window | Window]]''' : A work area which can be used to create, view, edit, and process a record.
* '''[[Screenshot:Windows, Tabs, and Fields#Window | 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
* '''Audit Inserts''' : If this flag is checked, if when a record is inserted in an audited table the initial value of all its columns will be saved in the audit table
* '''[[Screenshot:Tables and Columns#Column | 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.
* '''Is Tree''' : Defines if the data of this table wants to be displayed hierarchically
* '''HQL Query''' : HQL query used to populate the table
* '''Entity Alias'''
* '''Table''' : A dictionary table used for this tab that points to the database table.
* '''SQL_Record_Identifier''' : SQL_Record_Identifier
* '''[[Screenshot:Organization#Organization | Organization]]''' : Organizational entity within client
* '''[[Screenshot:Client#Client | Client]]''' : Client for this installation.

=== '''Column''' ===

Define columns within a table that Openbravo can access in the database.
* '''[[Screenshot:Module#Module | Module]]''' : Module
* '''DB Column Name''' : The name of a column within the database.
* '''[[Screenshot:Process Definition#Process | 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.
* '''[[Screenshot:Reference#Reference | Reference]]''' : The data type of this field.
* '''[[Screenshot:Reference#Reference | Reference Search Key]]''' : The exact reference specification for a list or a table.
* '''[[Screenshot:Validation Setup#Validation | 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.
* '''[[Screenshot:Report and Process#Report & Process | 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
* '''[[Screenshot:Callout#Callout | 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.
* '''[[Screenshot:Element#Element | 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''' : This field is used to define a computed column. A computed column is a column of a table which is computed using a sql expression and which does not exist explicitly in the database schema.
* '''Clause Left Part''' : The left part definition of a column in an HQL query.
* '''Allow Sorting''' : When this checkbox is checked, the column will be sortable.
* '''Allow Filtering''' : When this checkbox is checked, the column will be filterable.
* '''Allow Cross Organization Reference'''
* '''Used as Filter Column''' : Is this column used for finding rows in windows
* '''[[Screenshot:Tables and Columns#Table | 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
* '''[[Screenshot:Organization#Organization | Organization]]''' : Organizational entity within client
* '''Column''' : A link to the database column of the table.
* '''[[Screenshot:Client#Client | Client]]''' : Client for this installation.
* '''Callout Function''' : A series of actions that occur when data is modified.

=== '''Role Access''' ===

Edit role access to a particular table.
* '''[[Screenshot:Role#Role | 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.
* '''[[Screenshot:Role#Role | Inherited From]]''' : Inherited From
* '''Table Access'''
* '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that points to the database table.
* '''[[Screenshot:Organization#Organization | Organization]]''' : Organizational entity within client
* '''[[Screenshot:Client#Client | Client]]''' : Client for this installation.

=== '''Table Tree Category''' ===

Once a tree table has defined a table tree category, it can be used in tree referenced and the tree view will be available when the table is displayed in a tab.
* '''[[Screenshot:Organization#Organization | Organization]]''' : Organizational entity within client
* '''[[Screenshot:Module#Module | Module]]''' : Module
* '''Name''' : A non-unique identifier for a record/document often used as a search tool.
* '''Tree Structure''' : Inner structure of the tree
* '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that points to the database table.
* '''Is Ordered''' : Defines if the tree is ordered
* '''Is Parent Selection Allowed''' : Defines if parent nodes can be selected when using a tree reference
* '''Is Main Tree''' : Flag to specify if this is the main tree of the table
* '''Apply HQL Where Clause To Child Nodes''' : Defines if the tab where clause should be applied to non root nodes
* '''[[Screenshot:Tables and Columns#Column | Link to Parent Column]]''' : For Link to Parent tables: column that points to the node id of the parent node
* '''[[Screenshot:Tables and Columns#Column | Node ID Column]]''' : For Link to Parent tables: column that represents the id of the node
* '''Has Multiparent Nodes''' : Allows to define if a node can have several parents
* '''Handle Nodes Manually''' : If this flag is checked the creation and deletion of tree nodes will be handled manually.
* '''Node Deletion Policy''' : It defines the behavior when a node item is deleted
* '''Active''' : A flag indicating whether this record is available for use or de-activated.
* '''[[Screenshot:Datasource#Datasources | Datasource]]''' : Datasource used to feed the table
* '''Table Tree Category''' : Table tree structure to be used in this tab
* '''[[Screenshot:Client#Client | Client]]''' : Client for this installation.

=== '''Navigation Rules''' ===

Configuration of the rules that a window's link has to meet to reach a tab. The rules are in short HQL where clauses in which "e" is the current table.
* '''[[Screenshot:Organization#Organization | Organization]]''' : Organizational entity within client
* '''[[Screenshot:Module#Module | Module]]''' : Module
* '''Sequence Number''' : The order of records in a specified document.
* '''[[Screenshot:Windows, Tabs, and Fields#Tab | Navigate to Tab]]''' : An indication that a tab is displayed within a window.
* '''Direct Navigation''' : The rule does not need to comply an HQL Logic
* '''HQL Logic''' : HQL where clause that the destination row has to meet in order to open the specified tab of the rule
* '''[[Screenshot:Windows, Tabs, and Fields#Field | Field]]''' : Any element which can be viewed, edited, or added to a window.
* '''Active''' : A flag indicating whether this record is available for use or de-activated.
* '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that points to the database table.
* '''[[Screenshot:Client#Client | Client]]''' : Client for this installation.
* '''AD_Table_Navigation_ID''' : A table navigation row is a rule that makes the links of Openbravo wich have that table as a reference navigate to a custom tab

{{BackTo|Screens Reference}}

[[Category:User Guide]]

@@ Line 35: / Line 35: @@
 * '''SQL_Record_Identifier''' : SQL_Record_Identifier
 * '''[[Screenshot:Organization#Organization | Organization]]''' : Organizational entity within client
 * '''[[Screenshot:Client#Client | Client]]''' : Client for this installation.
 === '''Column''' ===

@@ Line 90: / Line 90: @@
 * '''Column''' : A link to the database column of the table.
 * '''[[Screenshot:Client#Client | Client]]''' : Client for this installation.
 * '''Callout Function''' : A series of actions that occur when data is modified.
 === '''Role Access''' ===

@@ Line 103: / Line 103: @@
 * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that points to the database table.
 * '''[[Screenshot:Organization#Organization | Organization]]''' : Organizational entity within client
 * '''[[Screenshot:Client#Client | Client]]''' : Client for this installation.
 === '''Table Tree Category''' ===

Screenshot:Tables and Columns - Revision history

Wikiadmin: /* Table */

Wikiadmin: /* Column */

Wikiadmin: /* Role Access */

Wikiadmin: Created page with "{{BackTo|Screens Reference}} == '''Tables and Columns''' == Edit tables and columns so that Openbravo can access the database, as well as control the role access. === '''Tab..."