View source | Discuss this page | Page history | Printable version   

ERP/3.0/Developers Guide/Database Model/org.openbravo.model.ad.ui/AD Tab

This article is protected against manual editing because it is automatically generated from Openbravo meta-data. Learn more about writing and translating such documents.
Back button.png   Back to ERP/3.0/Developers Guide/Database Model/org.openbravo.model.ad.ui


Contents

AD_Tab

This table contains the following columns:

Name Nullable Data Type Description


AD_Table_Tree_ID Yes VARCHAR (32) Tree tables can define several tree structures. If a table tree structure is set in this field, the tab will include a tree view that will allow to browse the data hierarchically.
IsInfoTab Yes CHAR (1) The Accounting Tab checkbox indicates if this window contains accounting information.
IsActive No CHAR (1) There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records:

(1) The system requires the record for auditing purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.

AD_Client_ID No VARCHAR (32) A Client is a company or a legal entity. You cannot share data between Clients.
AD_Column_ID Yes VARCHAR (32) Link to the database column of the table
CommitWarning Yes NVARCHAR (2000) Warning or information displayed when committing the record
CreatedBy No VARCHAR (32) The Created By field indicates the user who created this record.
Created No TIMESTAMP (7) The Created field indicates the date that this record was created.
IsSingleRow No CHAR (1) The Single Row Layout checkbox indicates if the default display type for this window is a single row as opposed to multi row.
DefaultTreeViewLogic Yes VARCHAR (2000) It defines a criteria to set by default the visualization of the tree grid view when the window loads
Description Yes NVARCHAR (255) A description is limited to 255 characters.
Disable_Parent_Key_Property No CHAR (1) Flag to check whether parent property needs to be used when computing tab whereclause
Displaylogic Yes VARCHAR (2000) A specification of statements which, when evaluated as false, cause the field to appear hidden.
EM_Obuiapp_Newfn Yes VARCHAR (255) Defines the function that will called when adding a new row to the grid
EM_OBUIAPP_Selection Yes VARCHAR (255) When the user changes the selection (a row gets selected or deselected) the custom JavaScript function will get executed
EM_Obuiapp_Can_Add No CHAR (1) Defines if a user is allowed to add new lines
EM_Obuiapp_Can_Delete No CHAR (1) Defines if a user is allowed to delete lines
EM_Obuiapp_Removefn Yes VARCHAR (255) When the grid allows remove rows you can specify a "on remove" function that will get executed when trying remove a row. If the function returns false, the row will not get removed.
EM_Obuiapp_Selection_Type Yes VARCHAR (60) It specifies the selection type that will apply to the grid.

Its value can be:

* "None": no rows can be selected
* "Single": only one row can be selected
* "Multiple": multiple rows can be selected
EM_Obuiapp_Show_Select Yes CHAR (1) Some use cases requires that the selection column (checkbox column) is hidden
FilterClause Yes NVARCHAR (2000) Filter clause
FilterName Yes NVARCHAR (60) When there is a default filter for the tab, it can be named so the user can see it in the UI.
Hqltreewhereclause Yes VARCHAR (2000) By default the root nodes of the tree are those whose parent is null or 0. When the default case does not apply, a HQL where clause can be set to define which are the root nodes for this tab.
Help Yes NVARCHAR (2000) The Help field contains a hint, comment or help about the use of this item.
Hqlfilterclause Yes VARCHAR (2000) By using this HQL clause, initially the user will not be able to see data that does not fit the criteria. Once the user clears the filter, this hql clause will not be applied.
Hqlorderbyclause Yes VARCHAR (2000)
Hqlwhereclause Yes VARCHAR (2000) By using this HQL filter, the user will never be able to see data that does not fit the criteria. The HQL where clause is added to the query to retrieve the data which is returned by the datasource
AD_Image_ID Yes VARCHAR (32) Defines a system image
ImportFields Yes CHAR (1) Create Fields from Table Columns, this process will create the fields that don't exists in the tab but which exist in the correspondent table.
AD_ColumnSortYesNo_ID Yes VARCHAR (32) If a Included Column is defined, it decides, if a column is active in the ordering - otherwise it is determined that the Order Column has a value of one or greater
Included_Tab_ID Yes VARCHAR (32) You can include a Tab in a Tab. If displayed in single row record, the included tab is displayed as multi-row table.
EditReference Yes VARCHAR (32) The form referenced in the edition command
AD_Module_ID No VARCHAR (32) Indicates the module the element forms part of.
Name No NVARCHAR (60) A more descriptive identifier (that does need to be unique) of a record/document that is used as a default search option along with the search key (that is unique and mostly shorter). It is up to 60 characters in length.
AD_ColumnSortOrder_ID Yes VARCHAR (32) Integer Column of the table determining the order (display, sort, ..). If defined, the Order By replaces the default Order By clause. It should be fully qualified (i.e. "tablename.columnname").
AD_Org_ID No VARCHAR (32) An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
AD_Process_ID Yes VARCHAR (32) The Process field identifies a unique Process or Report in the system.
Processing Yes CHAR (1) When this field is set as 'Y' a process is being performed on this record.
IsReadOnly Yes CHAR (1) The Read Only indicates that this field may only be Read. It may not be updated.
IsReadOnlyTree No CHAR (1) It defines if the tree of this tab should behave as read only mode so nodes cannot be reordered.
OrderByClause Yes NVARCHAR (2000) The ORDER BY Clause indicates the SQL ORDER BY clause to use for record selection
WhereClause Yes NVARCHAR (2000) The Where Clause indicates the SQL WHERE clause to use for record selection. The WHERE clause is added to the query. Fully qualified means "tablename.columnname".
SeqNo No DECIMAL (10,0) The Sequence indicates the order of records
IsSortTab No CHAR (1) The Tab determines the Order.
ShowParentButtons No CHAR (1) In case this flag is enabled, buttons defined in parent tab will be shown in current one.
IsShowTreeNodeIcons No CHAR (1) It defines if the tree nodes icons (folder and leaf) should be shown. It only applies if the tree grid is in read only mode.
AD_Tab_ID No VARCHAR (32) The Tab indicates a tab that displays within a window.
TabLevel No DECIMAL (10,0) Hierarchical level of the tab. If the level is 0, it is the top entity. Level 1 entries are dependent on level 0, etc.
AD_Table_ID No VARCHAR (32) The Table indicates the table in which a field or fields reside.
IsTranslationTab No CHAR (1) The Translation Tab checkbox indicate if a tab contains translation information.
HasTree No CHAR (1) The Has Tree checkbox indicates if this window displays a tree metaphor.
UIPattern No VARCHAR (60) Defines the UI Pattern that the object implements.
Updated No TIMESTAMP (7) The Updated field indicates the date that this record was updated.
UpdatedBy No VARCHAR (32) The Updated By field indicates the user who updated this record.
AD_Window_ID No VARCHAR (32) The Window field identifies a unique Window in the system.

Columns

AD_Table_Tree_ID


Foreign key column to ad_table_tree table, (column: AD_Table_Tree_ID)

top


Accounting Tab



top


Active



top


Client


Foreign key column to AD_Client table, (column: AD_Client_ID) It has a validation "AD_Client Security validation", with the following code

AD_Client.AD_Client_ID in (@#User_Client@)

top


Column


Foreign key column to AD_Column table, (column: AD_Column_ID) It has a validation "AD_Column must be in AD_Table", with the following code

AD_Column.AD_Table_ID=@AD_Table_ID@

top


Confirmation Message



top


Created By


Foreign key column to AD_User table, (column: AD_User_ID)

top


Creation Date



top


Default Edit Mode



top


Default Tree View Logic



top


Description



top


Disable Parent Key Property



top


Display Logic



top


EM_OBUIAPP_NewFn



top


EM_OBUIAPP_Selection



top


EM_Obuiapp_Can_Add



top


EM_Obuiapp_Can_Delete



top


EM_Obuiapp_Removefn



top


EM_Obuiapp_Selection_Type



List values: AD_Tab Selection Type

The allowed values for this list are:

top


EM_Obuiapp_Show_Select



top


Filter Clause



top


Filter Name



top


HQL Where Clause for Root Nodes



top


Help/Comment



top


Hqlfilterclause



top


Hqlorderbyclause



top


Hqlwhereclause



top


Image


Foreign key column to AD_Image table, (column: AD_Image_ID)

top


Import Fields



top


Included Column


Foreign key column to AD_Column table, (column: AD_Column_ID) It has a validation "AD_Column must be in AD_Table", with the following code

AD_Column.AD_Table_ID=@AD_Table_ID@

top


Included Tab


Foreign key column to AD_Tab table, (column: AD_Tab_ID) It has a validation "AD_Tab in Window", with the following code

AD_Tab.AD_Window_ID=@AD_Window_ID@

top


Master Detail Form


Foreign key column to AD_Form table, (column: AD_Form_ID)

top


Module


Foreign key column to AD_Module table, (column: AD_Module_ID) It has a validation "Ad_Module_ID IsInDevelopment", with the following code

IsInDevelopment = 'Y' and type != 'T'

top


Name


top


Order Column


Foreign key column to AD_Column table, (column: AD_Column_ID) It has a validation "AD_Column must be in AD_Table", with the following code

AD_Column.AD_Table_ID=@AD_Table_ID@

top


Organization


Foreign key column to AD_Org table, (column: AD_Org_ID)

top


Process


Foreign key column to AD_Process table, (column: AD_Process_ID) It has a validation "AD_Process Reports", with the following code

AD_Process.IsReport='Y'

top


Process Now



top


Read Only



top


Read Only Tree



top


SQL Order by Clause



top


SQL Where Clause



top


Sequence Number



top


Sequence Tab



top


Show Parent's Buttons



top


Show Tree Node Icons



top


Tab



top


Tab Level



top


Table


Foreign key column to AD_Table table, (column: AD_Table_ID)

Callout: SL_TableTab

This column has a callout associated. Callout executed when the table of a tab is changed It is implemented by [1] Java Class.

top


Translation Tab



top


Tree Included



top


UI Pattern


List values: Tab UI Pattern

The allowed values for this list are:

top


Updated



top


Updated By


Foreign key column to AD_User table, (column: AD_User_ID)

top


Window

Foreign key column to AD_Window table, (column: AD_Window_ID)

top


Other Info

Indices

These are the indices for this table (for each index there is a list of all the columns included within it):

top

Check Constraints

These are the check constraints for this table:

top

Back button.png   Back to org.openbravo.model.ad.ui

Retrieved from "http://wiki.openbravo.com/wiki/ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.ui/AD_Tab"

This page has been accessed 6,467 times. This page was last modified on 13 March 2023, at 01:39. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.