ERP/3.0/Developers Guide/Database Model/org.openbravo.model.ad.ui/AD Tab
AD_Tab
- Name:AD_Tab
- Classname:ADTab
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
- Physical column name: AD_Table_Tree_ID
- Property Name: tableTree
- Reference: OBUISEL_Selector Reference
Foreign key column to ad_table_tree table, (column: AD_Table_Tree_ID)
Accounting Tab
- Physical column name: IsInfoTab
- Property Name: accountingTab
- Reference: YesNo
- Default value: N
Active
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
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@)
Column
- Physical column name: AD_Column_ID
- Property Name: column
- Reference: TableDir
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@
Confirmation Message
- Physical column name: CommitWarning
- Property Name: confirmationMessage
- Reference: Text
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Creation Date
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
- Default value: SYSDATE
Default Edit Mode
- Physical column name: IsSingleRow
- Property Name: defaultEditMode
- Reference: YesNo
- Default value: Y
Default Tree View Logic
- Physical column name: DefaultTreeViewLogic
- Property Name: defaultTreeViewLogic
- Reference: Text
Description
- Physical column name: Description
- Property Name: description
- Reference: String
Disable Parent Key Property
- Physical column name: Disable_Parent_Key_Property
- Property Name: disableParentKeyProperty
- Reference: YesNo
- Default value: N
Display Logic
- Physical column name: Displaylogic
- Property Name: displayLogic
- Reference: Text
EM_OBUIAPP_NewFn
- Physical column name: EM_Obuiapp_Newfn
- Property Name: oBUIAPPNewFn
- Reference: String
EM_OBUIAPP_Selection
- Physical column name: EM_OBUIAPP_Selection
- Property Name: oBUIAPPSelection
- Reference: String
EM_Obuiapp_Can_Add
- Physical column name: EM_Obuiapp_Can_Add
- Property Name: obuiappCanAdd
- Reference: YesNo
- Default value: N
EM_Obuiapp_Can_Delete
- Physical column name: EM_Obuiapp_Can_Delete
- Property Name: obuiappCanDelete
- Reference: YesNo
- Default value: N
EM_Obuiapp_Removefn
- Physical column name: EM_Obuiapp_Removefn
- Property Name: obuiappRemovefn
- Reference: String
EM_Obuiapp_Selection_Type
- Physical column name: EM_Obuiapp_Selection_Type
- Property Name: obuiappSelectionType
- Reference: List
List values: AD_Tab Selection Type
The allowed values for this list are:
- N (None)
- S (Single)
- M (Multiple)
EM_Obuiapp_Show_Select
- Physical column name: EM_Obuiapp_Show_Select
- Property Name: obuiappShowSelect
- Reference: YesNo
- Default value: Y
Filter Clause
- Physical column name: FilterClause
- Property Name: filterClause
- Reference: Text
Filter Name
- Physical column name: FilterName
- Property Name: filterName
- Reference: String
HQL Where Clause for Root Nodes
- Physical column name: Hqltreewhereclause
- Property Name: hQLWhereClauseForRootNodes
- Reference: Text
Help/Comment
- Physical column name: Help
- Property Name: helpComment
- Reference: Text
Hqlfilterclause
- Physical column name: Hqlfilterclause
- Property Name: hqlfilterclause
- Reference: Text
Hqlorderbyclause
- Physical column name: Hqlorderbyclause
- Property Name: hqlorderbyclause
- Reference: Text
Hqlwhereclause
- Physical column name: Hqlwhereclause
- Property Name: hqlwhereclause
- Reference: Text
Image
- Physical column name: AD_Image_ID
- Property Name: image
- Reference: TableDir
Foreign key column to AD_Image table, (column: AD_Image_ID)
Import Fields
- Physical column name: ImportFields
- Property Name: importFields
- Reference: Button
Included Column
- Physical column name: AD_ColumnSortYesNo_ID
- Property Name: includedColumn
- Reference: Table
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@
Included Tab
- Physical column name: Included_Tab_ID
- Property Name: includedTab
- Reference: Table
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@
Master Detail Form
- Physical column name: EditReference
- Property Name: masterDetailForm
- Reference: Table
Foreign key column to AD_Form table, (column: AD_Form_ID)
Module
- Physical column name: AD_Module_ID
- Property Name: module
- Reference: TableDir
- Default value: 0
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'
Name
- Physical column name: Name
- Property Name: name
- Reference: String
- This column is part of the table's identifier
Order Column
- Physical column name: AD_ColumnSortOrder_ID
- Property Name: orderColumn
- Reference: Table
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@
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
Foreign key column to AD_Org table, (column: AD_Org_ID)
Process
- Physical column name: AD_Process_ID
- Property Name: process
- Reference: TableDir
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'
Process Now
- Physical column name: Processing
- Property Name: processNow
- Reference: Button
Read Only
- Physical column name: IsReadOnly
- Property Name: readOnly
- Reference: YesNo
- Default value: N
Read Only Tree
- Physical column name: IsReadOnlyTree
- Property Name: readOnlyTree
- Reference: YesNo
- Default value: N
SQL Order by Clause
- Physical column name: OrderByClause
- Property Name: sQLOrderByClause
- Reference: Text
SQL Where Clause
- Physical column name: WhereClause
- Property Name: sQLWhereClause
- Reference: Text
Sequence Number
- Physical column name: SeqNo
- Property Name: sequenceNumber
- Reference: Integer
Sequence Tab
- Physical column name: IsSortTab
- Property Name: sequenceTab
- Reference: YesNo
- Default value: N
Show Parent's Buttons
- Physical column name: ShowParentButtons
- Property Name: showParentsButtons
- Reference: YesNo
- Default value: Y
Show Tree Node Icons
- Physical column name: IsShowTreeNodeIcons
- Property Name: showTreeNodeIcons
- Reference: YesNo
- Default value: Y
Tab
- Physical column name: AD_Tab_ID
- Property Name: id
- Reference: ID
Tab Level
- Physical column name: TabLevel
- Property Name: tabLevel
- Reference: Integer
Table
- Physical column name: AD_Table_ID
- Property Name: table
- Reference: TableDir
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.
Translation Tab
- Physical column name: IsTranslationTab
- Property Name: translationTab
- Reference: YesNo
- Default value: N
Tree Included
- Physical column name: HasTree
- Property Name: treeIncluded
- Reference: YesNo
- Default value: N
UI Pattern
- Physical column name: UIPattern
- Property Name: uIPattern
- Reference: List
- Default value: STD
List values: Tab UI Pattern
The allowed values for this list are:
- RO (Read Only): Allows just record view, not edition, creation or deletion.
- SR (Edit Only (No Insert nor Delete)): Allows to edit a single record, but not to create new ones or remove existen ones.
- ED (Edit and Delete Only (No Insert)): Allows to edit or delete the record. New records cannot be added.
- STD (Standard): Standard tab, allows record edtion, deletion and creation.
Updated
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
- Default value: SYSDATE
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Window
- Physical column name: AD_Window_ID
- Property Name: window
- Reference: TableDir
- This column is part of the table's identifier
- This column is a child for a business object (is Parent)
Foreign key column to AD_Window table, (column: AD_Window_ID)
Other Info
Indices
These are the indices for this table (for each index there is a list of all the columns included within it):
- AD_TAB_TABLE Not Unique. Columns:
- AD_TABLE_ID
- AD_TAB_TABLETREE_FK Not Unique. Columns:
- AD_TABLE_TREE_ID
- AD_TAB_WINDOW Not Unique. Columns:
- AD_WINDOW_ID
Check Constraints
These are the check constraints for this table:
- AD_TAB_HASTREE_CHK: HASTREE IN ('Y', 'N')
- AD_TAB_ISACTIVE_CHK: ISACTIVE IN ('Y', 'N')
- AD_TAB_ISINFOTAB_CHK: ISINFOTAB IN ('Y', 'N')
- AD_TAB_ISREADONLY_CHK: ISREADONLY IN ('Y', 'N')
- AD_TAB_ISREADONLYTREE_CHK: ISREADONLYTREE IN ('Y', 'N')
- AD_TAB_ISSHOWTREENODEICONS_CHK: ISSHOWTREENODEICONS IN ('Y', 'N')
- AD_TAB_ISSINGLEROW_CHK: ISSINGLEROW IN ('Y', 'N')
- AD_TAB_ISTRANSLATIONTAB_CHK: ISTRANSLATIONTAB IN ('Y', 'N')
- AD_TAB_NAME_CHK: INSTR(NAME, TO_CHAR('_')) = 0
- AD_TAB_PARENTKEYPROPERTY_CHK: DISABLE_PARENT_KEY_PROPERTY IN ('Y', 'N')
- AD_TAB_SHOWPARENTBUTTONS_CHK: SHOWPARENTBUTTONS IN ('Y', 'N')
- EM_OBUIAPP_AD_TAB_CAN_ADD: EM_OBUIAPP_CAN_ADD IN ('Y', 'N')
- EM_OBUIAPP_AD_TAB_CAN_DELETE: EM_OBUIAPP_CAN_DELETE IN ('Y', 'N')
- EM_OBUIAPP_AD_TAB_SHOW_SELECT: EM_OBUIAPP_SHOW_SELECT IN ('Y', 'N')
![]() | Back to org.openbravo.model.ad.ui |